Answered step by step
Verified Expert Solution
Link Copied!

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.)

image text in transcribed

(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 explain

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Management Core Concepts

Authors: Raymond Brooks

3rd Edition

0133866742, 9780133866742

More Books

Students also viewed these Finance questions

Question

Will you be able to pay your bills?

Answered: 1 week ago