Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Question
Chapter 2.6, Problem 10P
Summary Introduction
To find: The best fitting linear, power and exponential trend lines and also calculate MAPE.
Forecasting is a method utilized by organizations to project future demand and implement their production strategies accordingly. Forecasting is essential for developing the budget, marketing plans and for making other financial considerations.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
A golf club manufacturer is trying to determine how the price of a set of clubs affects the demand for clubs. The file P10_50.xlsx contains the price of a set of clubs and the monthly sales.
Assume the only factor influencing monthly sales is price. Fit the following three curves to these data: linear (Y = a + bX), exponential (Y = abX), and multiplicative (Y = aXb). Which equation fits the data best?
Interpret your best-fitting equation.
Using the best-fitting equation, predict sales during a month in which the price is $470.
File data:
Price
Demand
$400
20,000
$420
19,000
$440
17,000
$460
16,000
$500
14,000
$380
22,000
$290
31,000
$340
26,000
$220
41,000
$700
6,000
A TV program has a rating of 17.6. With approximately 118.4 million television households in the United States as of 2016, what is that program’s CPM if a 30-second commercial costs $600,000? Now assume that an advertiser’s target audience consists only of people aged 25 to 54, which constitute 62 percent of the program’s total audience. What is the CPM-TM in this case?
The CPM and CPC rates of a publisher of display ads is $40 and $4, respectively. The
average CTR of display ads is 0.5%. Which of the two buying models will be more
profitable for the marketer and which model should the publisher choose for selling ad
inventory?
Chapter 2 Solutions
Practical Management Science
Ch. 2.4 - Prob. 1PCh. 2.4 - Prob. 2PCh. 2.4 - Prob. 3PCh. 2.4 - Prob. 4PCh. 2.5 - Prob. 5PCh. 2.5 - Prob. 6PCh. 2.5 - Prob. 7PCh. 2.5 - Prob. 8PCh. 2.5 - Prob. 9PCh. 2.6 - Prob. 10P
Ch. 2.6 - Prob. 11PCh. 2.6 - Prob. 12PCh. 2.6 - Prob. 13PCh. 2.7 - Prob. 14PCh. 2.7 - Prob. 15PCh. 2.7 - Prob. 16PCh. 2.7 - Prob. 17PCh. 2.7 - Prob. 18PCh. 2.7 - Prob. 19PCh. 2 - Julie James is opening a lemonade stand. She...Ch. 2 - Prob. 21PCh. 2 - Prob. 22PCh. 2 - Prob. 23PCh. 2 - Prob. 24PCh. 2 - Prob. 25PCh. 2 - The file P02_26.xlsx lists sales (in millions of...Ch. 2 - Prob. 27PCh. 2 - The file P02_28.xlsx gives the annual sales for...Ch. 2 - Prob. 29PCh. 2 - A company manufacturers a product in the United...Ch. 2 - Prob. 31PCh. 2 - Prob. 32PCh. 2 - Assume the demand for a companys drug Wozac during...Ch. 2 - Prob. 34PCh. 2 - Prob. 35PCh. 2 - Prob. 36PCh. 2 - Prob. 37PCh. 2 - Suppose you are borrowing 25,000 and making...Ch. 2 - You are thinking of starting Peaco, which will...Ch. 2 - Prob. 40PCh. 2 - The file P02_41.xlsx contains the cumulative...Ch. 2 - Prob. 42PCh. 2 - Prob. 43PCh. 2 - The IRR is the discount rate r that makes a...Ch. 2 - A project does not necessarily have a unique IRR....Ch. 2 - Prob. 46PCh. 2 - Prob. 1CCh. 2 - The eTech Company is a fairly recent entry in the...
Knowledge Booster
Similar questions
- Sometimes curvature in a scatterplot can be fit adequately (especially to the naked eye) by several trend lines. We discussed the exponential trend line, and the power trend line is discussed in the previous problem. Still another fairly simple trend line is the parabola, a polynomial of order 2 (also called a quadratic). For the demand-price data in the file P13_10.xlsx, fit all three of these types of trend lines to the data, and calculate the MAPE for each. Which provides the best fit? (Hint: Note that a polynomial of order 2 is still another of Excels Trend line options.)arrow_forwardA major source of revenue in Texas is a state sales tax on certain types of goodsand services. Data are compiled and the state comptroller uses them to project future revenuesfor the state budget. One particular category of goods is classified as Retail Trade. Four years ofquarterly data (in $millions) for one particular area of southeast Texas follow:Quarter Year 1 Year 2 Year 3 Year 41 218 225 234 2502 247 254 265 2833 243 255 264 2894 292 299 327 356Compute the Q1, Q2, Q3, & Q4 forecasts for Year 5 given the fact that this data is known to beaffected by: Irregular effects Seasonal effects Trending effectsarrow_forwardRina consumes orange and avocado. In year 2020, orange cost $4 each, avocado cost $5 each. In year 2021, orange cost $6 , avocado cost $8. She buys 5 oranges and 4 avocados. a. Compute a consumer price index for oranges dan avocados for each year. Assume that year 2020 is the base year in which the consumer basket is fixed. How does your index change from 2020 to year 2021? b. Compute Rina’s nominal spending on oranges and avocados in each year. How does it change from 2020 to 2021?arrow_forward
- The file P13_21.xlsx contains the weekly sales of rakes at a hardware store for a two-year period. Use the moving averages method, with spans of your choice, to forecast sales for the next 30 weeks. Does this method appear to track sales well? If not, what might be the reason?arrow_forwardThe file P13_20.xlsx contains the monthly sales of iPod cases at an electronics store for a two-year period. Use the moving averages method, with spans of your choice, to forecast sales for the next six months. Does this method appear to track sales well? If not, what might be the reason?arrow_forwardThe file P13_03.xlsx contains monthly data on production levels and production costs during a four-year period for a company that produces a single product. Use simple regression on all of the data to see how Total Cost is related to Units Produced. Use the resulting equation to predict total cost in month 49, given that the proposed production level for that month is 450 units. Do you see anything wrong with the analysis? How should you modify your analysis if your main task is to find an equation useful for predicting future costs, and you know that the company installed new machinery at the end of month 18? Write a concise memo to management that describes your findings.arrow_forward
- The CPM and CPC rates of a publisher of display ads is $100 and $10, respectively. The average CTR of display ads is 0.80%. Which of the two buying models will be more profitable for the marketer/advertiser and which model should the publisher choose for selling ad inventory?arrow_forwardStruggling with answering this question A manufacturer produces three types of humidifiers. The retail price of Humidifier Regular (HR) is $60 with variable costs of $20. Humidifier Advanced (HA) sells for $200 for its advanced features. This model’s variable costs are $80. Humidifier Simple (HS) is a simplified version and only sells for $25 with variable costs of $15. The manufacturer has machines and facilities worth $320,000 annually. The sales data show that 1000 units of HR, 2000 units of HA, and 10,000 units of HS was sold last year. Calculate the break-even point of the firm. The firm has some idle capacity at these volumes and chooses to cut the selling price of HR from $60 to $45, believing that its sales volume will rise from 1000 units to 2500 units. What is the revised break-even point?arrow_forwardI need the answer in Excel. Please help me. The following table contains 5-year quarterly sales information for the KYRYH product. Year Q1 Q2 Q3 Q4 Total 2016 43000 37800 32300 40600 153700 2017 47000 37000 31200 40000 155200 2018 46000 39000 28000 40500 153500 2019 49000 42300 33500 44000 168800 2020 52700 44000 33600 45700 176000 a) Determine the demand for the year 2021 using the moving averages. b) Comment on the validity of the model based on the 95% confidence level.arrow_forward
- Your company makes hand sanitizer in two lines: Moisturizing+, and StandardSoap. On the market, Moisturizing+ retails for $175/L and StandardSoap retails for $95/L. You make the hand sanitizer by combining lotion, soap, and secret ingredient SpecialX. These ingredients are purchased from a mysterious supplier, and you can purchase at most 4000L of lotion, 5000L of soap, and 750L of SpecialX in a month. Lotion costs $25/L, soap costs $10/L, and SpecialX costs $35/L. To make 1L of Moisturizing+, you need to combine 0.5L of lotion, 0.3L of soap, and 0.2L of SpecialX. To make 1L of StandardSoap, you need to combine 0.4L of lotion, 0.55L of soap, and 0.05L of SpecialX. Your company has committed to donating 500L of StandardSoap to a local charity. Since this is a donation, you will not receive any revenue. However, the costs and purchasing limits apply to both the hand sanitizer that is sold on the market and donated to charity. You want to maximize your monthly profit. Assume that…arrow_forwardNestlé has a variety of big data analysts in their headquarters back in Vevey, Switzerland. One enterprising analyst, comparing sales performance of various product lines between different types of countries, notices what appears to be a recurring anomaly. More precisely, he discovers that even though the GDP per capita report for a country might be low to extremely low, grassroots data on actual sales levels and trends in those markets, such as in Mozambique, Guatemala, Zambia, Cambodia, indicate surprisingly robust demand for the sorts of food products that Nestlé makes. In trying to reduce the variance, the analyst runs and reruns the data, but cannot resolve the problem. In frustration, he consults a colleague, asking what she thinks might be going on with his data. She immediately concurs with his outlook—that is, if we were to stick with the officially reported GDP per capita data, Nestlé would wisely would postpone expanding into many of these countries. Alternatively, she…arrow_forwardWhich of the following statements is correct for the Black-Scholes model? A) The price of an American call written on a stock is: c = SN(d1)-Ke-rTN(d2) B) The stock price at a future point in time follows a log-normal distribution. C) The continuously compounded return on the stock follows a log-normal distribution. D) Black-Scholes prices may allow for arbitrage opportunities. Please explain and justify your choice.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,