Question: 2 Problems Saved Help Save Problem 12-9 (Algo) A ski repair shop at a resort in Colorado sells replacement poles each season. The shop needs

2 Problems Saved Help Save Problem 12-9 (Algo) A
2 Problems Saved Help Save Problem 12-9 (Algo) A
2 Problems Saved Help Save Problem 12-9 (Algo) A ski repair shop at a resort in Colorado sells replacement poles each season. The shop needs to develop a forecast of next season's sales so that they can place an order for poles with their supplier well in advance of the beginning of the season. Sales data for the past five years are shown below. Compare the forecasts given by the following models. Year 1 Balen (units) 393 2 365 3 372 4 400 5 373 PrictureClick here for the Excel Data File a. Develop forecast using a five-year moving average. (Round your answer to 1 decimal place.) Fotocasted solos for 6th year b. Develop forecast using a weighted moving average model with weights of 01.0.2, 0.2, 0.1, and 0.4 for years 1 through 5 respectively. (Round your answer to 1 decimal place.) Forecasted sales for th your Prey 1 of 6 !!! Next > 14 W Seved er 12 Problems Help b. Develop forecast using a weighted moving average model with weights of 0.1, 0.2.0.2, 0.1, and 0.4 for years 1 through 5 respectively. (Round your answer to 1 decimal place.) Forecasted sales for 6th year noos c. Develop forecast using an exponential smoothing model with year forecast of 385 and a 0.2. (Do not round intermediate calculations. Round your answer to 2 decimal places.) Forecasted sales for Bon your Prey 1 of 6 !!! Next >

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!