Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following table summarizes car sales by month. a - Determine the forecast for the months of July to December using the moving average based

The following table summarizes car sales by month.
a - Determine the forecast for the months of July to December using the moving average based on 6
months (assume the current ones for the months of July to December as 12,16,15,11,19 and 21).
b- Determine the forecast error for each month.
c - Use the MAD to estimate the future error of the forecasts.
d-Explain the relationship of your prognosis with the result you obtained from the MAD.
Using the sales values from problem 1
a - Forecast through December with the three-month "Weighted Moving Average" with the following
weights:
b-Determine the forecast error per month.
c- Determine variation with the MSE.
Using the sales values from problem 1
a - Forecast from July to December using exponential smootting with a=0.1. Assume the June
forecast is 16.
b - Determine the forecast error per month.
c - What will be the percentage of variation using MAPE?
d - Evaluate the forecast with a=0.8 and a=0.5.
e - Which of the three alpha values would you choose to forecast?
image text in transcribed

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

Fundamentals of Management

Authors: Robbins, DeCenzo, Coulter

7th Edition

132996855, 0-13-610982-9 , 9780132996853, 978-0-13-61098, 978-0136109822

More Books

Students also viewed these General Management questions

Question

Explain about operations on Data Structure?

Answered: 1 week ago

Question

Which of the following strait separate north america from Asia ?

Answered: 1 week ago

Question

Highest peak as well as active volcano of North America?

Answered: 1 week ago