This preview shows page 1. Sign up to view the full content.
Unformatted text preview: ing Objective: 1802 Evaluate demand using
quantitative forecasting models. Problem 18-13
His toric al demand for a produc t is as follows : April May J une J uly Augus t September DEMAND
68 63 88 68 93 88 http://e z to.mhe c loud.mc gr a w- hill.c om/hm.tpx? todo= pr intvie w 9/10 1/29/2014 Assignme nt Pr int Vie w
a. Us ing a s imple fourmonth mov ing av erage, c alc ulate a forec as t for Oc tober. (Round your answer to 2
decim al places.) Forec as t for Oc tober 84.25 ± 1% b. Us ing s ingle ex ponential s moothing with α = 0.20 and a September forec as t = 54, c alc ulate a forec as t
for Oc tober. (Round your answer to 2 decim al places.) Forec as t for Oc tober 60.80 ± 1% c. Us ing s imple linear regres s ion, c alc ulate the trend line for the his toric al data. Say the X ax is is April =
1, May = 2, and s o on, while the Y ax is is demand. (Round your intercept value to the nearest whole
num ber and slope value to 2 decim al places.) Y = 61 ± 1% + 4.86 ± .05 t d....
View Full Document
- Fall '09