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

image text in transcribedimage text in transcribed

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 830 790 820 2 840 820 800 3 810 825 825 4 845 835 805 5 795 820 795 6 830 770 806 7 805 790 755 8 840 830 785 9 840 805 785 10 800 820 850 a. Compute the MSE and MAD for each forecast. (Round your answers to 2 decimal places.) Forecast 1 Forecast 2 MSE MAD b. Compute MAPE for each forecast. (Round your intermediate calculations to 5 decimal places and final answers to 4 decimal places.) MAPE F1 MAPE F2 % % 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. (Round your answers to 2 decimal places.) MSE MAD Tracking signal Control limits 0

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

Intermediate Accounting

Authors: Donald E. Kieso, Jerry J. Weygandt, Terry D. Warfield

IFRS edition volume 2

978-0470613474, 470613475, 978-0470616314

More Books

Students also viewed these Accounting questions

Question

2. Contributing something significant to the company.

Answered: 1 week ago

Question

7. The need to use a variety of complex skills.

Answered: 1 week ago