Answered: Calculate (a) MAD and (b) MSE for the…

Calculate (a) MAD and (b) MSE for the following forecast versus actual sales figures: Forecast 100 110 120 130 Actual 95 108 123 130 a) MAD =O (round your response to one decimal place). %3D

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

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
8. Calculate (a) MAD and (b) MSE for the following forecast versus actual sales figures: Forecast 100 110 120 130 Actual 95 108 123 130 Part 2 a) MAD= __________ (round your response to one decimal place).
Given the following original forecast and actual data: Month Actual Forecast Jan 600 Feb 475 Mar 550 Apr 575 May 643 Jun 662 Jul ??? ??? Using a 2 month weighted moving average with weights of 75% for the previous month and 25% for two months back, what is the forecast for July. Round your answer to 1 decimal place. 400 -- —— ——
pls help
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
Given the following original forecast and actual data: Month Actual Forecast Jan 600 Feb 475 Mar 550 Apr 575 May 643 Jun 662 Jul ??? ??? Using a 2 month weighted moving average with weights of 75% for the previous month and 25% for two months back, what is the forecast for July. Round your answer to 1 decimal place. 400 -- —— ——
41) A medium-term forecast is considered to cover what length of time? A) 2-4 weeks B) 1 month to 1 year C) 2-4 years D) 5-10 years E) 20 years 42) When is the exponential smoothing model equivalent to the naÃ¯ve forecasting model? A) ? = 0 B) ? = 0.5 C) ? = 1 D) during the first period in which it is used E) never 43) Enrollment in a particular class for the last four semesters has been 120, 126, 110, and 130. Suppose a one-semester moving average was used to forecast enrollment (this is sometimes referred to as a naÃ¯ve forecast). Thus, the forecast for the second semester would be 120, for the third semester it would be 126, and for the last semester it would be 110. What would the MSE be for this situation? A) 196.00 B) 230.67 C) 100.00 D) 42.00 E) None of the above 44) Which of the following methods tells whether the forecast tends to be too high or too low? A) MAD B) MSE C) MAPE D) decomposition E) bias 45) Assume that you have tried three different…
(Use excel to show formulas used) Use regression or simple exponential smoothing with the following data. For exponential smoothing, assume the forecast for year 1 was the same as the actual and use an alpha of 0.7. Year Sales 1 290 2 340 3 400 4 410 5 400 Forecast Year 6 sales. Compute MAD.
Problem 5 You are trying to determine what forecast method to use. Based upon the following historical data, calculate the following forecast and specify what procedure you would utilize. MAY JUNE MONTH JANUARY FEBRUARY MARCH APRIL DEMAND 62 65 67 68 71 73 MONTH JULY AUGUST SEPTEMBER OCTOBER NOVEMBER DECEMBER DEMAND 76 78 78 80 84 85 a. Calculate the simple three-month moving average for periods 4 to 12. b. Calculate the weighted three-month moving average for periods 4 to 12. Use weights of 0.50, 0.30, and 0.20 for the most recent, second most recent, and third most recent periods, respectively. c. Calculate the single exponential smoothing forecast for periods 2 to 12 using an initial forecast (F₁) of 61 and a of 0.30. d. Calculate the exponential smoothing with trend component forecast for periods 2 to 12 using an initial trend forecast (T₁) of 1.8, and initial exponential smoothing forecast (F₁) of 60, an a of 0.30 and ō of 0.30. e. Calculate the MAD for the forecasts made by each…
Historical sales data is shown below. Week Actual Forecast 1 328 300 2 272 3 245 4 223 5 205 6 Using alpha (α) = 0.2, what is the exponential smoothing forecast for period 6? Note: Round your answer to 2 decimal places. Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
Passenger miles flown on Northeast Airlines, a commuter firm serving the Boston hub, are shown for the past 12 weeks: 2 3 21 19 Week 1 Actual Passenger Miles (in thousands) 17 Week Forecasted Passenger Miles (in thousands) a) Assuming an initial forecast for week 1 of 17,000 miles, use exponential smoothing to compute miles for weeks 2 through 12. Use α = 0.2 (round your responses to two decimal places). 10 11 4 5 6 7 8 9 23 18 16 20 18 22 20 15 2 1 3 4 6 7 17.00 17.00 17.80 18.04 19.03 18.83 18.26 5 8 18.61 9 18.49 19.19 10 12 22 11 12