Question: 1. Following are two weekly forecasts made by two different methods for the number of gallons of gasoline, in thousands, demanded at a local gasoline
1. Following are two weekly forecasts made by two different methods for the number of gallons of gasoline, in thousands, demanded at a local gasoline station. Also shown are actual demand levels, in thousands of gallons:
|
|
|
The MAD for Method 1 = . 133.133 thousand gallons (round your response to three decimal places).
The mean squared error (MSE) for Method 1 = _____thousand gallons squared (round your response to three decimal places).
2. Sales of quilt covers at Bud Banis's discount department store in Carbondale over the past year are shown below. Management prepared a forecast using a combination exponential smoothing and its collective judgment for the 4 months (March, April, May, and June):
| Month | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun |
| Unit Sales | 98 | 97 | 94 | 112 | 120 | 118 | 92 | 84 | 102 | 96 | 88 | 110 |
| Management's Forecast | 125 | 116 | 110 | 110 |
a) MAD for the forecast developed by the management's technique = 16.25 sales (round your response to two decimal places).
MAPE for the forecast developed by the management's technique = 17.101 (round your response to two decimal places).
b) Using the Naive Method the forecast for period March through June is (round your response to two decimal places):
| Month | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun |
| Unit Sales | 98 | 97 | 94 | 112 | 120 | 118 | 92 | 84 | 102 | 96 | 88 | 110 |
| Naive Forecast | 8484 | 102102 | 9696 | 8888 |
MAD for the naive forecast = ______ sales (round your response to two decimal places).
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
