CH04hw - 4.1 (a) 374 + 368 + 381 = 374.33 pints 3 (b) Week...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
374 + 368 + 381 (a) 374.33 pints 3 = 4.1 (b) Week of Pints Used Weighted Moving Average August 31 360 September 7 389 381 × .1 = 38.1 September 14 410 368 × .3 = 110.4 September 21 381 374 × .6 = 224.4 September 28 368 372.9 October 5 374 Forecast 372.9 (c) Week of Pints Forecast Forecasting Error Error × .20 Forecast August 31 360 360 0 0 360 September 7 389 360 29 5.8 365.8 September 14 410 365.8 44.2 8.84 374.64 September 21 381 374.64 6.36 1.272 375.912 September 28 368 375.912 –7.912 –1.5824 374.3296 October 5 374 374.3296 –.3296 –.06592 374.2636 The forecast is 374.26. 3,700 + 3,800 (a) 3,750 ml. 2 = 4.5 (b) Year Mileage Two-Year Moving Average Error |Error| 1 3,000 2 4,000 3 3,400 3,500 –100 100 4 3,800 3,700 100 100 5 3,700 3,600 100 100 Totals 100 300 300 100. 3 MAD ==
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
4.5 (c) Weighted 2 year M.A. with .6 weight for most recent year. Year Mileage Forecast Error |Error| 1 3,000 2 4,000 3 3,400 3,600 –200 200 4 3,800 3,640 160 160 5 3,700 3,640 60 60 420 Forecast for year 6 is 3,740 miles. 420 140 3 MAD ⎛⎞ == ⎜⎟ ⎝⎠ 4.5 (d) Year Mileage Forecast Forecast Error Error × α = .50 New Forecast 1 3,000 3,000 0 0 3,000 2 4,000 3,000 1,000 500 3,500 3 3,400 3,500 –100 –50 3,450 4 3,800 3,450 350 175 3,625 5 3,700 3,625 75 38 3,663 Total 1,325 The forecast is 3,663 miles. 4.6 Y Sales X Period X 2 XY January 20 1 1 20 February 21 2 4 42 March 15 3 9 45 April 14 4 16 56 May 13 5 25 65
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/08/2010 for the course BUS 140 at San Jose State University .

Page1 / 3

CH04hw - 4.1 (a) 374 + 368 + 381 = 374.33 pints 3 (b) Week...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online