Question: Challenge 3: Advanced Quantitative Forecasting Models (9 Points) 3.1 Feb. predicted demand for Ford Mustangs is 104 units. Feb. actual demand is 88 units. Using

Challenge 3: Advanced Quantitative Forecasting Models (9 Points)

3.1 Feb. predicted demand for Ford Mustangs is 104 units. Feb. actual demand is 88 units. Using a smoothing constant alpha =.20, please forecast March demand for Mustangs based on the exponential smoothing method.

3.2 The number of pints of Type A blood used at St. Joseph Hospital over 6 weeks last year is given in the following table. Forecast the demand for the week of October 12th using exponential smoothing. Use Alpha values of 0.05, 0.1, 0.2, and 0.3. Start the method using a two-period moving average of August 31 and September 7th. Compute the bias, MAD, and Standard Deviation based on each Alpha value. What is the best Alpha value?

Week ofPints Used31-Aug3607-Sep38914-Sep41021-Sep38128-Sep3685-Oct374

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!