Question: Please use the space provided to solve the question: ( LO 3 ) Year Sales Forecast 2 0 1 8 , 1 4 0 ,

Please use the space provided to solve the question: (LO3)
Year Sales Forecast
2018,140,000,120,000
2019,130,000,116,000
2020,150,000,121,600
2021,140,000,132,960
2022,150,000,135,776
2023,165,000,160,500
a. Compute a four-period moving average forecast to estimate the sales in 2024.(5 pts.)
b. Compute a weighted moving average forecast using weights (ordered starting from the most recent period) of 0.4,0.3,0.25 and 0.05 to estimate the sales in 2024.(10 pts.)
c. Compute an exponential smoothing forecast where =0.55 to estimate the sales in 2024.(10 pts.)
d. Compute a Linear Trend Forecast to estimate the sales in 2024.(15 pts.)
 Please use the space provided to solve the question: (LO3) Year

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!