Assume we have data demonstrating a strong linear link between the amount of fertilizer applied to certain plants and their yield. Which is the dependent variable in this research question?
Q: Given the data here, a. Compute the average return for each of the assets from 1929 to 1940 (the…
A: Use excel as follows to calculate average return , variance and standard deviation
Q: Double Tree Hilton is a hotel that provides two types of rooms with three rental classes: Super…
A: Solution Let X1 be the number of type I super saver room. X2 be the number of type I deluxe room. X3…
Q: MarkLines is an online portal (www.marklines.com) that reports automotive industry data. The table…
A: Find the Given details below: Given Details: Car Sales Manufacturer Jan.-Nov.(2017)…
Q: A manufacturing company of wood products makes tables and chairs. It primarily uses two machines,…
A: Given Information: I. Decision Variables: Let x = no. of doors to be manufactured for…
Q: What is the implication of a data distribution with mean, median and mode being approximately equal?…
A: Mean, median, and mode are the measures of central tendency.
Q: Use the below formula to calculate the CLV for the following: A manager of a cable company wants…
A: Given that - Margin profit (M) = $150 Annual marketing cost (C) = $30 Retention rate (r) = 65%…
Q: of hybrid cars that have be requested for rental from a car rental office during a 50 day sample…
A: Demand for Cars Number of Days Probability 3 3…
Q: Using MAD as the criterion, which of the following models would you use for the given time series…
A: THE ANSWER IS AS BELOW:
Q: #28 Even though independent gasoline stations have been having a difficult time, Susan Solomon has…
A: Note- Hi! Thank you for the question, As per the honour code, we are allowed to answer three…
Q: following outcomes over the last seven months: Quantity Sold Price Advertising 8500 $ 2 $ 2,800 4700…
A: given,
Q: 4.Hilltop Coffee manufactures a coffee product by blending three types of coffee beans. The cost per…
A: Decision variables: Let x be no. of pounds of bean 1y be no. of pounds of bean 2z be no. of pounds…
Q: the Select an answer increases by The regression equation approximates the wither height by the…
A: WE ARE ALLOWED TO DO ONE QUESTION AT A TIME. THUS, I AM ATTEMPTING QUESTION IN FIRST PICTURE WITH…
Q: The planning committee of a bank makes monthly decisions on the amount of funds to allocate to loans…
A: Given data: To formulate a liner programming model x1,x2,x3,x4,x5,x6,x7 be the decision variables…
Q: He is particularly interested in enhancing the effectiveness of their Janssen COVID-19 vaccine.…
A: Every organization having various products and business in the market try to evaluate their each…
Q: The following data is given x 0.2 0.5 1 2 3 y 3 2 1.4 1 0.6 Using the transformed…
A:
Q: Madison Company is a large manufacturer and distributor of cake supplies. It is based in Chicago…
A: Business organizations need to have an appropriate market entry strategy before entering a new…
Q: An airline decided to offer direct service from City A to City B. Management must decide between a…
A: Thank you for posting the question,As per our guidelines we will be answering the first 3 sub parts…
Q: The management accountant at Miller Merchandising & More, Odail Russell is in the process of…
A: Cash budget of the organization shows all expected cash collections and cash payments to be made in…
Q: How to solve descision tree using Analytical Solver for the assignment below Chelsea Bush is an…
A: a) Chelsea should run in the NH essential. On the off chance that she progresses admirably, at that…
Q: A large food chain owns a number of pharmacies that operate in a variety of settings. Some are…
A: Hours of Operation Average Revenue 40 5958 44 6662 48 6004 48 6011 60 7250 70 8632 72…
Q: Highline Financial Services provides three categories of service to its clients. Managing partner…
A: Service A: Formula:
Q: A rice importer has three sources: Thailand, Vietnam, and China. Unfortunately, the annual amount of…
A: It is a TRUE statement. It is a maximition problem.
Q: The manager of the local National Video Store sells videocassette recorders at discount prices. If…
A: Given information, Customer demand = 90% Mean = 180 Standard Deviation = 60
Q: This is a maximization problem. True or False?
A: This is a maximization problem is true.
Q: Round Tree Manor is a hotel that provides two types of rooms with three rental classes: Super Saver,…
A: Given data: Rental Class Room Super Saver Deluxe Business Availability Type I 30 35 -…
Q: 1. Sara is planning to start a new designer cloth shop. Her problem is to decide how large her shop…
A: The Laplace criterion: The Laplace criterion manages all the knowledge by assigning similar…
Q: expenditure on food, gas and clothing for a family living in the USA in 2010. Read the description…
A: The above graph seems to be a result of a research. The research process can be defined as the…
Q: Suppose the distribution of home sales prices has mean k300, 000 and standard deviation of k50, 000.…
A: Chebyshev's Theorem is a fact that refers to every potential data sets. It depicts the smallest…
Q: You are the Economic Consultant for Zuku Farms Ghana Limited. Zuku produces cowpea in a community…
A: Given information, Y = Income of the consumer Initial Price = 31.00 Income = 1001.50 Qd =…
Q: A motion picture industry analyst is studying movies based on epic novels. The following data were…
A: Regression analysis is a type of prescient displaying method which explores the connection between a…
Q: Prepare a purchases budget expressed in quantities to be purchased.
A: Introduction: In general, the term production refers to the process of converting the inputs into…
Q: This is a maximization problem. True or Flase?
A: As all variables are positive it is a maximization problem.
Q: Every month a clothing store conducts an inventory and calculates the losses due to theft. The store…
A:
Q: The scatter chart below displays the residuals versus the dependent variable, x. Which of the…
A: The scatter diagram charts sets of numerical data, with one variable on each axis, to look for a…
Q: The Gorman Manufacturing Company must decide whether to manufacture a component part at its plant or…
A: As there are two alternatives, two branch nodes are drawn. For each alternative, there are 3 states…
Q: Even though independent gasoline stations have been having a difficult time, Susan Solomon has been…
A: “Hi, since there are multiple questions posted, we will answer the sub-parts from (a) to (d)…
Q: Madison Company is a large manufacturer and distributor of cake supplies. It is based in Chicago…
A: All business have an objective of making expansion in markets outside domestic areas. It is because…
Q: A producer is currently selling three different brands (Brand A, Brand B, and Brand C) of fountain…
A: The given data is shown in a tabular form. Per unit data Brand A Brand B Brand C…
Q: A major source of revenue in Texas is a state sales tax on certain types of goods and services. Data…
A: Given data is
Q: Well Water Inc. wants to produce and sell a new flavored water. In order to penetrate the market,…
A: Given, Annual sales = 50000 bottles Selling cost = $2 Sales revenue = $2*50000 = $100,000 Desired…
Q: Zaki has been thinking about starting his own petrol station. He’s problem is to decide how large…
A: The maximax criterion applies to selecting the option that maximizes the highest payoff available.…
Q: All MBA students have to take entry test for admission to AUAF. Scores are normally distributed with…
A: Quality refers to the degree of excellence of something. Quality has some standard on the basis of…
Q: Suppose the company could acquire 1,000 pounds more of either nitrogen or phosphorous. Which should…
A: The problem can be setup in excel.
Q: What is the value captured by all sellers?
A: Since you have asked multiple question, we will solve the first question for you. If you want any…
Q: The following table represents sales data for milk (in hundred liters) sold by a grocery. Do the…
A: Note: - Since the exact question that has to be answered is not specified we will answer the…
Q: Malik Kurdi, Vice President of Al-Madinah Drug Industry Company, is currently leading efforts to…
A: Competency or skill: It is anything an employee does effectively, and an employee may have various…
Step by step
Solved in 2 steps
- A company manufacturers a product in the United States and sells it in England. The unit cost of manufacturing is 50. The current exchange rate (dollars per pound) is 1.221. The demand function, which indicates how many units the company can sell in England as a function of price (in pounds) is of the power type, with constant 27556759 and exponent 2.4. a. Develop a model for the companys profit (in dollars) as a function of the price it charges (in pounds). Then use a data table to find the profit-maximizing price to the nearest pound. b. If the exchange rate varies from its current value, does the profit-maximizing price increase or decrease? Does the maximum profit increase or decrease?Play Things is developing a new Lady Gaga doll. The company has made the following assumptions: The doll will sell for a random number of years from 1 to 10. Each of these 10 possibilities is equally likely. At the beginning of year 1, the potential market for the doll is two million. The potential market grows by an average of 4% per year. The company is 95% sure that the growth in the potential market during any year will be between 2.5% and 5.5%. It uses a normal distribution to model this. The company believes its share of the potential market during year 1 will be at worst 30%, most likely 50%, and at best 60%. It uses a triangular distribution to model this. The variable cost of producing a doll during year 1 has a triangular distribution with parameters 15, 17, and 20. The current selling price is 45. Each year, the variable cost of producing the doll will increase by an amount that is triangularly distributed with parameters 2.5%, 3%, and 3.5%. You can assume that once this change is generated, it will be the same for each year. You can also assume that the company will change its selling price by the same percentage each year. The fixed cost of developing the doll (which is incurred right away, at time 0) has a triangular distribution with parameters 5 million, 7.5 million, and 12 million. Right now there is one competitor in the market. During each year that begins with four or fewer competitors, there is a 25% chance that a new competitor will enter the market. Year t sales (for t 1) are determined as follows. Suppose that at the end of year t 1, n competitors are present (including Play Things). Then during year t, a fraction 0.9 0.1n of the company's loyal customers (last year's purchasers) will buy a doll from Play Things this year, and a fraction 0.2 0.04n of customers currently in the market ho did not purchase a doll last year will purchase a doll from Play Things this year. Adding these two provides the mean sales for this year. Then the actual sales this year is normally distributed with this mean and standard deviation equal to 7.5% of the mean. a. Use @RISK to estimate the expected NPV of this project. b. Use the percentiles in @ RISKs output to find an interval such that you are 95% certain that the companys actual NPV will be within this interval.Stock market analysts are continually looking for reliable predictors of stock prices. Consider the problem of modeling the price per share of electric utility stocks (Y). Two variables thought to influence this stock price are return on average equity (X1) and annual dividend rate (X2). The stock price, returns on equity, and dividend rates on a randomly selected day for 16 electric utility stocks are provided in the file P13_15.xlsx. Estimate a multiple regression equation using the given data. Interpret each of the estimated regression coefficients. Also, interpret the standard error of estimate and the R-square value for these data.
- Suppose that a regional express delivery service company wants to estimate the cost of shipping a package (Y) as a function of cargo type, where cargo type includes the following possibilities: fragile, semifragile, and durable. Costs for 15 randomly chosen packages of approximately the same weight and same distance shipped, but of different cargo types, are provided in the file P13_16.xlsx. a. Estimate a regression equation using the given sample data, and interpret the estimated regression coefficients. b. According to the estimated regression equation, which cargo type is the most costly to ship? Which cargo type is the least costly to ship? c. How well does the estimated equation fit the given sample data? How might the fit be improved? d. Given the estimated regression equation, predict the cost of shipping a package with semifragile cargo.It costs a pharmaceutical company 75,000 to produce a 1000-pound batch of a drug. The average yield from a batch is unknown but the best case is 90% yield (that is, 900 pounds of good drug will be produced), the most likely case is 85% yield, and the worst case is 70% yield. The annual demand for the drug is unknown, with the best case being 20,000 pounds, the most likely case 17,500 pounds, and the worst case 10,000 pounds. The drug sells for 125 per pound and leftover amounts of the drug can be sold for 30 per pound. To maximize annual expected profit, how many batches of the drug should the company produce? You can assume that it will produce the batches only once, before demand for the drug is known.Based on Babich (1992). Suppose that each week each of 300 families buys a gallon of orange juice from company A, B, or C. Let pA denote the probability that a gallon produced by company A is of unsatisfactory quality, and define pB and pC similarly for companies B and C. If the last gallon of juice purchased by a family is satisfactory, the next week they will purchase a gallon of juice from the same company. If the last gallon of juice purchased by a family is not satisfactory, the family will purchase a gallon from a competitor. Consider a week in which A families have purchased juice A, B families have purchased juice B, and C families have purchased juice C. Assume that families that switch brands during a period are allocated to the remaining brands in a manner that is proportional to the current market shares of the other brands. For example, if a customer switches from brand A, there is probability B/(B + C) that he will switch to brand B and probability C/(B + C) that he will switch to brand C. Suppose that the market is currently divided equally: 10,000 families for each of the three brands. a. After a year, what will the market share for each firm be? Assume pA = 0.10, pB = 0.15, and pC = 0.20. (Hint: You will need to use the RISKBINOMLAL function to see how many people switch from A and then use the RISKBENOMIAL function again to see how many switch from A to B and from A to C. However, if your model requires more RISKBINOMIAL functions than the number allowed in the academic version of @RISK, remember that you can instead use the BENOM.INV (or the old CRITBENOM) function to generate binomially distributed random numbers. This takes the form =BINOM.INV (ntrials, psuccess, RAND()).) b. Suppose a 1% increase in market share is worth 10,000 per week to company A. Company A believes that for a cost of 1 million per year it can cut the percentage of unsatisfactory juice cartons in half. Is this worthwhile? (Use the same values of pA, pB, and pC as in part a.)
- The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels. Management is trying to decide whether direct labor hours (DLH) or units produced is the better measure of activity for the firm. Monthly data for the preceding 24 months appear in the file P13_40.xlsx. Use regression analysis to determine which measure, DLH or Units (or both), should be used for the budget. How would the regression equation be used to obtain the budget for the firms overhead costs?The eTech Company is a fairly recent entry in the electronic device area. The company competes with Apple. Samsung, and other well-known companies in the manufacturing and sales of personal handheld devices. Although eTech recognizes that it is a niche player and will likely remain so in the foreseeable future, it is trying to increase its current small market share in this huge competitive market. Jim Simons, VP of Production, and Catherine Dolans, VP of Marketing, have been discussing the possible addition of a new product to the companys current (rather limited) product line. The tentative name for this new product is ePlayerX. Jim and Catherine agree that the ePlayerX, which will feature a sleeker design and more memory, is necessary to compete successfully with the big boys, but they are also worried that the ePlayerX could cannibalize sales of their existing productsand that it could even detract from their bottom line. They must eventually decide how much to spend to develop and manufacture the ePlayerX and how aggressively to market it. Depending on these decisions, they must forecast demand for the ePlayerX, as well as sales for their existing products. They also realize that Apple. Samsung, and the other big players are not standing still. These competitors could introduce their own new products, which could have very negative effects on demand for the ePlayerX. The expected timeline for the ePlayerX is that development will take no more than a year to complete and that the product will be introduced in the market a year from now. Jim and Catherine are aware that there are lots of decisions to make and lots of uncertainties involved, but they need to start somewhere. To this end. Jim and Catherine have decided to base their decisions on a planning horizon of four years, including the development year. They realize that the personal handheld device market is very fluid, with updates to existing products occurring almost continuously. However, they believe they can include such considerations into their cost, revenue, and demand estimates, and that a four-year planning horizon makes sense. In addition, they have identified the following problem parameters. (In this first pass, all distinctions are binary: low-end or high-end, small-effect or large-effect, and so on.) In the absence of cannibalization, the sales of existing eTech products are expected to produce year I net revenues of 10 million, and the forecast of the annual increase in net revenues is 2%. The ePIayerX will be developed as either a low-end or a high-end product, with corresponding fixed development costs (1.5 million or 2.5 million), variable manufacturing costs ( 100 or 200). and selling prices (150 or 300). The fixed development cost is incurred now, at the beginning of year I, and the variable cost and selling price are assumed to remain constant throughout the planning horizon. The new product will be marketed either mildly aggressively or very aggressively, with corresponding costs. The costs of a mildly aggressive marketing campaign are 1.5 million in year 1 and 0.5 million annually in years 2 to 4. For a very aggressive campaign, these costs increase to 3.5 million and 1.5 million, respectively. (These marketing costs are not part of the variable cost mentioned in the previous bullet; they are separate.) Depending on whether the ePlayerX is a low-end or high-end produce the level of the ePlayerXs cannibalization rate of existing eTech products will be either low (10%) or high (20%). Each cannibalization rate affects only sales of existing products in years 2 to 4, not year I sales. For example, if the cannibalization rate is 10%, then sales of existing products in each of years 2 to 4 will be 10% below their projected values without cannibalization. A base case forecast of demand for the ePlayerX is that in its first year on the market, year 2, demand will be for 100,000 units, and then demand will increase by 5% annually in years 3 and 4. This base forecast is based on a low-end version of the ePlayerX and mildly aggressive marketing. It will be adjusted for a high-end will product, aggressive marketing, and competitor behavior. The adjustments with no competing product appear in Table 2.3. The adjustments with a competing product appear in Table 2.4. Each adjustment is to demand for the ePlayerX in each of years 2 to 4. For example, if the adjustment is 10%, then demand in each of years 2 to 4 will be 10% lower than it would have been in the base case. Demand and units sold are the samethat is, eTech will produce exactly what its customers demand so that no inventory or backorders will occur. Table 2.3 Demand Adjustments When No Competing Product Is Introduced Table 2.4 Demand Adjustments When a Competing Product Is Introduced Because Jim and Catherine are approaching the day when they will be sharing their plans with other company executives, they have asked you to prepare an Excel spreadsheet model that will answer the many what-if questions they expect to be asked. Specifically, they have asked you to do the following: You should enter all of the given data in an inputs section with clear labeling and appropriate number formatting. If you believe that any explanations are required, you can enter them in text boxes or cell comments. In this section and in the rest of the model, all monetary values (other than the variable cost and the selling price) should be expressed in millions of dollars, and all demands for the ePlayerX should be expressed in thousands of units. You should have a scenario section that contains a 0/1 variable for each of the binary options discussed here. For example, one of these should be 0 if the low-end product is chosen and it should be 1 if the high-end product is chosen. You should have a parameters section that contains the values of the various parameters listed in the case, depending on the values of the 0/1 variables in the previous bullet For example, the fixed development cost will be 1.5 million or 2.5 million depending on whether the 0/1 variable in the previous bullet is 0 or 1, and this can be calculated with a simple IF formula. You can decide how to implement the IF logic for the various parameters. You should have a cash flows section that calculates the annual cash flows for the four-year period. These cash flows include the net revenues from existing products, the marketing costs for ePlayerX, and the net revenues for sales of ePlayerX (To calculate these latter values, it will help to have a row for annual units sold of ePlayerX.) The cash flows should also include depreciation on the fixed development cost, calculated on a straight-line four-year basis (that is. 25% of the cost in each of the four years). Then, these annual revenues/costs should be summed for each year to get net cash flow before taxes, taxes should be calculated using a 32% tax rate, and taxes should be subtracted and depreciation should be added back in to get net cash flows after taxes. (The point is that depreciation is first subtracted, because it is not taxed, but then it is added back in after taxes have been calculated.) You should calculate the company's NPV for the four-year horizon using a discount rate of 10%. You can assume that the fixed development cost is incurred now. so that it is not discounted, and that all other costs and revenues are incurred at the ends of the respective years. You should accompany all of this with a line chart with three series: annual net revenues from existing products; annual marketing costs for ePlayerX; and annual net revenues from sales of ePlayerX. Once all of this is completed. Jim and Catherine will have a powerful tool for presentation purposes. By adjusting the 0/1 scenario variables, their audience will be able to see immediately, both numerically and graphically, the financial consequences of various scenarios.Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the companys mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. The following data are available: If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog. If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives. If a customer last placed an order two catalogs ago, there is a 12% chance she will order from the next catalog she receives. If a customer last placed an order three catalogs ago, there is an 8% chance she will order from the next catalog she receives. If a customer last placed an order four catalogs ago, there is a 4% chance she will order from the next catalog she receives. If a customer last placed an order five catalogs ago, there is a 2% chance she will order from the next catalog she receives. It costs 2 to send a catalog, and the average profit per order is 30. Assume a customer has just placed an order. To maximize expected profit per customer, would Seas Beginning make more money canceling such a customer after six nonorders or four nonorders?
- When you use a RISKSIMTABLE function for a decision variable, such as the order quantity in the Walton model, explain how this provides a fair comparison across the different values tested.The U.S. pharmaceutical market is the largest in the world in which it generated over 530 billion U.S. dollars in 2020. The industry sales growth rate is expected to continue growing, and it will be worth 685.45 billion U.S. dollars by 2023. Johnson & Johnson (J&J) is the current market leader in the U.S. pharmaceutical industry and its market share increased by 7.89% in 2020. After applying the BCG Matrix, the CEO of J&J found that the pharmaceutical segment generates the majority of his company’s sales. Therefore, he decided to allocate more capital to research and development in this segment. He is particularly interested in enhancing the effectiveness of their Janssen COVID-19 vaccine. Which of the following strategies did the CEO of J&J decide to pursue? * Market developmentProduct DevelopmentHorizontal IntegrationMarket penetrationUse the following data to answer all of the remaining questions. Consider a commodity market where the products provided by all sellers are identical. A group of 12 potential buyers in this market have willingness to pay (WTP) as follows (in random order): $65, $60, $55, $80, $70, $30, $20, $55, $10, $45, $40, and $15. A group of potential suppliers serving this market have wiliness to accept (WTA) as follows (also in random order): $20, $25, $30, $10, $45, $50, $55, $15, $20, $30, $40, and $60. What is the value captured by all sellers? Buyers 2. What is the value captured in this market by an individual buyer with WTP = $80? 3. What is the total consumers surplus (i.e., all buyers) in this market? Value added 4. What is the value added for the supplier with a WTA (willingness to accept) of $15?