Question: a) using a 3 year moving average, calculate the forecast for 2019-2021 b) using weighted moving average, calculate 2020 and 2021 forecast with the following

a) using a 3 year moving average, calculate the forecast for 2019-2021

b) using weighted moving average, calculate 2020 and 2021 forecast with the following weights:

most recent = .4; second ,most recent = .35; third most recent = .15; fourth most recent = .1

actual forecast
2016 1250000
2017 1500000
2018 1600000
2019 2500000
2020 1200000
2021

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:

The following table shows the actual demand observed over the last 11 years: Year 1 2 3 4 6 7 8 9 10 11 5 13 7 10 4 10 8 11 14 9 13 6 Demand This exercise contaa only parts b, c, and a b) Using the 3...

Q:

parts A through D please The following table shows the actual demand observed over the last 11 years 1 2 4 7 9 5 11 6 9 8 14 10 9 11 6 7 8 4 10 13 10 Year 3 Demand This exercise contains only parts...

Q:

The following table shows the actual demand observed over the last 11 years O 11 8 Year 1 2 3 4 5 6 7 8 9 10 Demand 8 8 6 10 13 7 13 14 8 13 This exercise contains only parts , c, and a b) Using the...

Q:

The following table shows the actual demand observed over the last 11 years 0 Year Demand 1 8 2 9 3 5 4 7 5 12 6 9 7 12 8 14 9 9 10 9 11 6 This exercise contains only parts b, c, and d b) Using the 3...

Q:

10 9 8 11 6 12 The following the whows the actual demand observed over the last 11 years Year 1 2 3 4 6 7 8 Demand 7 10 6 10 7 13 14 This exercise contain any part, and d b) Using the 3 year moving...

Q:

The following table shows the actual demand observed over the last 11 years: This exercise contains only parts b,c, and d. b) Using the 3 -year moving average, provide the forecast from periods 4...

Q:

Please help me solve part C. could you allow see if my MA(3) and part D is correct. the yellow are answers/help i need. b) Using the 3 -year moving average, provide the forecast frompcriods 4 through...

Q:

The following table shows the actual demand observed for the last 11 years using the 3 year moving average provide the forecast from oeriods 4 through 12 round your answer to one decimal place using...

Q:

c part The following table shows the actual demand observed over the last 11 years 5 1 7 2 8 3 4 4 10 6 9 7 12 8 14 9 9 10 13 11 7 11 6 8 Year Demand This exercise contains only parts b, c, and d b)...

Q:

a) Plot the above data on a graph. Do you observe any trend, cycles, or random variations? b) Starting in year 4 and going to year 12 , forecast demand using a 3 -year moving average. Plot your...

Q:

Shaw Manufacturing paid $62,000 to purchase a computerized assembly machine on January 1, 2008. The machine had an estimated life of eight years and a $2,000 salvage value . Shaw's financial...

Q:

1) A Detroit based company ships a $100,000 car on September 30 to a customer in Honolulu, Hawaii. There is a hurricane on October 5th and the car washes overboard. If the shipping terms were F.O.B...

Q:

What is the principal limit factor in regards to a reverse mortgage?

Q:

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...