D.) compute MAPE for each data set. Which forecast appears to be more accurate? 21. Two different forecasting techniquesbottled water. Actual demand and the two sets of forecasts are as folloPREDICTED DEMANDF1F2PeriodDemand66661686868757072703.7471726972746.7270767.8071788.787480a. Compute MAD for each set of forecasts. Given your results, which forecast appears to be moreaccurate? Explain.b. Compute the MSE for each set of forecasts. Given your results, which forecast appears to bemore accurate?

Forecasting is the process in which estimation of future demand is determined using the previous or…

Answered: D.) compute MAPE for each data set.…

Business

Operations Management

D.) compute MAPE for each data set. Which forecast appears to be more accurate?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

7. Tim Hortons is planning to expand a new emarket by opening 6 branches . What are the 2 possible forecasting strategies that this company may implement. * Enter your answer
(4) Exponential smoothing with a smoothing constant equal to 0.15, assuming a March forecast of 15(000). (Round your intermediate forecast values and final answer to 2 decimal places.) Forecast thousands (5) A linear trend equation. (Round your intermediate calculations and final answer to 2 decimal places.) Yt thousands
6. Consider the following data table. (12 Points) a) Forecast demand using exponential smoothing with an apha of 0.25, and an initial forecast of 128.0 for period 1. b) Calculate the MAD and MSE. Period Real demand 130 138 129 140 3 4 5 133
Explain the term design for manufacturing and briefly explain why it is important.
Period 1 2 3 4 5 New Accounts Period 201 215 212 229 236 6 7 8 9 10 New Accounts Period 233 249 253 254 268 11 12 13 14 15 New Accounts 282 276 281 289 311
Problem 3-22 (Algo) Two independent methods of forecasting based on judgment and experience have been prepared each month for the past 10 months. The forecasts and actual sales are as follows:
a. What is the mean square error for time periods 2 through 4 using the average forecasting method? b. What is the mean absolute error for time periods 2 through 4 using the average forecasting method? c. What is the mean absolute percentage error for time period 2 through 4 using the average forecasting method? Round all answers to two decimal places. Time Period 1 2 3 4 Mean absolute error (MAE) Mean squared error (MSE) Mean absolute percentage error (MAPE) Electric Bill 510 315 420 480 Average Forecast Forecast Error
Assume that your stock of sales merchandise is maintained based on the forecast demand. If the distributor's sales personnel call on the first day of each month, compute your forecast sales by each of the three methods requested here. June July August ACTUAL 144 184 210 a. Using a simple three-month moving average, what is the forecast for September? Note: Round your answer to 2 decimal places. Forecast for September b. Using a weighted moving average, what is the forecast for September with weights of 0.30, 0.40, and 0.30 for June, July, and August, respectively? Note: Do not round intermediate calculations. Round your answer to 2 decimal places. Forecast for September
January February March April May June a. Calculate forecasts for the remaining five months using simple exponential smoothing with a = 0.4. February March April May June ACTUAL FORECAST 100 85 96 103 82 66 90 MAD Forecasts 91 93 97 91 81 b. Calculate the MAD for all the forecasts, including January's. (Round your answer to 1 decimal place.)
The Toro Cutlery Company has collected monthly sales information below: MONTH January February March April The company is examining two forecasting methods, moving average and exponential smoothing for forecasting sales. a. What will the forecast be for January the following year using a three-, four-, and five-month moving averages? Do not round intermediate calculations. Round your answers to the nearest whole number. Forecast (January, 3-month MA): 87667 Forecast (January, 4-month MA): 72500 Forecast (January, 5-month MA): 69600 b. What will the forecast be for January the following year using exponential smoothing with a = 0.6? Assume the forecast for February this year is 25,000. Do not round intermediate calculations. Round your answer to the nearest whole number. SALES 25,000 18,000 43,000 110,000 MONTH May June July August SALES MONTH 84,000 September 28,000 October 97,000 November 58,000 December SALES 27,000 105,000 82,000 76,000
45 A forecasting method has produced the following over the past five months. What is the mean absolute deviation? Actual Forecast Error |Error| 10 11 -1 1 8 10 -2 2 10 8 2 2 6 6 0 0 9 8 1 1 Select one: a. -0.2 b. 1.2 c. 8.6 d. -1.0 e. 0.0
b5 need urgent in 15 minutes