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:

Week

Forecast Method 1

Actual

Demand

1

0.95

0.72

2

1.05

1.05

3

0.95

1.00

4

1.22

0.97

Week

Forecast Method 2

Actual

Demand

1

0.82

0.72

2

1.21

1.05

3

0.92

1.00

4

1.11

0.97

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

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!