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

image 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 840 840 805 835 838 818 850 825 855 765 778 785 839 795 781 818 818 789 855 SER 785 795 855 19 785 795 798 a. Compute the MSE and MAD for each forecast (Round your answers to 2 decimal places.) MSE MAD Forecast 1 Forecast 2 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. (Negative values should be Indicated by a minus sign. Round your answers to 2 decimal places.) MSE MAD Tracking signal Control limits

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Linear Algebra A Modern Introduction

Authors: David Poole

3rd edition

9781133169574 , 978-0538735452

Students also viewed these Economics questions

Question

2. What is the meaning and definition of Banking?

Answered: 1 week ago

Question

3.What are the Importance / Role of Bank in Business?

Answered: 1 week ago