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
Get step-by-step solutions from verified subject matter experts
