Question: Use the time series below to answer the questions which follow. Time Period Demand 6 years ago 21 5 years ago 28 4 years ago

Use the time series below to answer the questions which follow.

Time Period Demand

6 years ago 21

5 years ago 28

4 years ago 35

3 years ago 42

2 years ago 56

Last year 69

A. What is this year's forecast using a three-year moving average?

B. What is this year's forecast using a three-year weighted moving average, where the weights are .6, .3, .1?

C. What is this years forecast using the linear trend method.

D. Which forecast method has the smallest Mean Absolute Deviation (MAD), based upon forecasts for the latest 3 years of data?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

Please use the following information to 1. Generate complete income statements and balance sheets for FY2019 and FY2020. 2. Generate a cash flow statement for FY2020 3. Analyze the profit margins for...

Q:

Data on demand over the last few years are available as follows: Time period Demand 7 yrs ago 7 6yrs ago 28 5yrs ago 21 4yrs ago 42 3yrs ago 35 2yrs ago 56 Last year 49 What is this year's forecast...

Q:

Profit Amazon Echo and Google Home are two of the market leaders in the rapidly growing digital personal assistant product category. Ophelia is a brand manager for a smaller consumer electronics firm...

Q:

Ch. 3: Forecasting Given the following demand data: Time Period Demand 7 years ago 6 years ago 5 years ago 4 years ago 3 years ago 2 years ago Last year 7 28 21 42 35 56 49 4. Using the linear trend...

Q:

Marketing Analytics: Channel Sales and Profit Amazon Echo and Google Home are two of the market leaders in the rapidly growing digital personal assistant product category. Ophelia is a brand manager...

Q:

Ch. 3: Forecasting Given the following demand data: Time Period Demand 7 years ago 6 years ago 5 years ago 4 years ago 3 years ago 2 years ago Last year 7 28 21 42 35 56 49 1. What is this year's...

Q:

Data on demand over the last few years are available as follows: Time Period Demand 7 years ago 7 6 years ago 28 5 years ago 21 4 years ago 42 3 years ago 35 2 years ago 56 49 Last year What are this...

Q:

Time Period Demand 7 years ago 7 6 years ago 2 8 5 years ago 2 1 4 years ago 4 2 3 years ago 3 5 2 years ago 5 6 Last year 4 9 What is this years forecast using a four - year simple moving average

Q:

Time Period Demand 7 years ago 7 6 years ago 28 5 years ago 21 4 years ago 42 3 years ago 35 2 years ago 56 Last year 49 What is this years forecast using the naive approach?

Q:

Marketing Analytics: Channel Sales and Profit Amazon Echo and Google Home are two of the market leaders in the rapidly growing digital personal assistant product category. Ophelia is a brand manager...

Q:

Marketing Analytics: Channel Sales and Profit Amazon Echo and Google Home are two of the market leaders in the rapidly growing digital personal assistant product category. Ophelia is a brand manager...

Q:

Italian Construction Company purchased a new crane for $360,500 at the beginning of year 1. The crane has an estimated residual value of $35,000 and an estimated useful life of six years. The crane...

Q:

Consider building a CSMA/CD network running at 1 Gbps over a 1-km cable with no repeaters. The signal speed in the cable is 200,000 km/sec. What is the minimum frame size?

Q:

The auditor should ensure that they have sufficient evidence and time to ensure all impacts on revenue are proper... because management may be pressured or incented to inflate revenues Question 5...

Q:

What is an example of constructive feedback? provide reference