Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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:

Month Sales Forecast 1 Forecast 2
1 835 790 805
2 840 795 825
3 835 820 815
4 845 835 855
5 795 780 785
6 830 780 801
7 815 780 785
8 860 820 815
9 815 830 845
10 845 835 835

a. Compute the MSE and MAD for each forecast. (Round your answers to 2 decimal places.)

b. Compute MAPE for each forecast. (Round your intermediate calculations to 5 decimal places and final answers to 4 decimal places.)

c. Prepare a naive forecast for periods 2 through 11 using the given sales data. Compute each of the following; (1) MSE, (2) MAD, (3) tracking signal at month 10, and(4) 2s control limits. (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.)

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

Step: 3

blur-text-image

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

Retailing Management

Authors: Michael Levy, Barton A Weitz

8th Edition

0073530026, 9780073530024

More Books

Students also viewed these General Management questions