Forecast using exponential smoothing method


A rental car manager estimates the number of full-size sedans rented per week so that she can maintain adequate number of cars in the lot. Data for the past 10 weeks are shown here:

Week Rentals Week Rentals
1          23        6        28
2          24        7        32
3          32        8        35
4          26        9        26
5          31       10       24

A) Prepare a forecast for week 11 by using a five -week moving average

b) Prepare a forecast for week 11 by using a 3-period weighted moving average, giving the weight of 0.5 to the most recent week, 0.3 to the second week and 0.2 to the third week.

c) Prepare a forecast using exponential smoothing method with α = 0.2. Forecast for week 1 was 22.

Solution Preview :

Prepared by a verified Expert
Other Subject: Forecast using exponential smoothing method
Reference No:- TGS01615292

Now Priced at $20 (50% Discount)

Recommended (90%)

Rated (4.3/5)