Answered step by step
Verified Expert Solution
Question
1 Approved Answer
(2.2) (18 points) Given the actual sales of an item in the past 8 months same as in (2.1) in the table below, calculate the
(2.2) (18 points) Given the actual sales of an item in the past 8 months same as in (2.1) in the table below, calculate the 3-month moving average forecasts up to month 9, and |forecast errors|. Put the results in the table. (Reminder: Place your moving-average results in the correct rows.) (Keep one digits after decimal point.)
(2.2) (18 points) Given the actual sales of an item in the past 8 months same as in (2.1) in the table below, calculate the 3-month moving average forecasts up to month 9, and forecast errors. Put the results in the table. (Reminder: Place your moving average results in the correct rows.) (Keep one digits after decimal point.) + Month 3-month moving average forecasts (n=3) Forecast Errors! 1 2 3 4 5 6 7 8 9 Actual sales (S) 720 840 750 980 650 820 760 780 Calculate MAD for the above moving average forecasts with n=3: MAD3 (2.3/4 points) Which is better, n=2 or n=3, in this problem in terms of forecasting accuracy? Briefly explain. (2.2) (18 points) Given the actual sales of an item in the past 8 months same as in (2.1) in the table below, calculate the 3-month moving average forecasts up to month 9, and forecast errors. Put the results in the table. (Reminder: Place your moving average results in the correct rows.) (Keep one digits after decimal point.) + Month 3-month moving average forecasts (n=3) Forecast Errors! 1 2 3 4 5 6 7 8 9 Actual sales (S) 720 840 750 980 650 820 760 780 Calculate MAD for the above moving average forecasts with n=3: MAD3 (2.3/4 points) Which is better, n=2 or n=3, in this problem in terms of forecasting accuracy? Briefly explainStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started