Question

12.6. The manager of the Excom Service Station wants to foreca the demand for unleaded gasoline next month so that the proper mem- ber of gallons can be ordered from the distributor The ner has cumulated the following data on demand for unleaded gasoline from sales during the past 10 months: MONTH GASOLINE DEMANDED (GALI 800 645 October November December January February March April May June July Comp ted ex linear and a accur 129. COM to for 730 810 1200 980 price a. Compute an exponentially smoothed forecast using an a value of .30.

Answer 1

Formulas Data Review View Developer Add-ins XLSTAT Tell me what you want to do..... File - General Home Insert Page Layout X Cut Calibri Copy - Format Painter BIU - Clipboard Font 11 - A A === - AE On E Wrap Text Merge & Center, Paste E $ % , 8.09 Conditional Format as Cell Formatting Table Styles Styles Insert Delete Fo - Cells Alignment Number K21 C D E F G H I K L M N O ID-F alpha, a = 0.30 Exponential smoothing formula Ft+2 = a*Dt- +(1-a) *Ft-1 Ft+2 = (0.30) *D-1 +(0.70) *F-1 75.00 Month October November December January February March April May June July Demand(D) 800 725 630 500 645 690 730 810 1200 980 (F) Formula 800.00 800.00 =0.3*800+0.7*800 777.50 733.25 663.28 657.79 667.45 686.22 723.35 866.35 900.44 |=0.3*980+0.7*866.35 MAD = 142.54 =AVERAGE(H4:H12) 147.50 233.25 18.28 32.21 62.55 123.78 476.65 113.65