HW Ch 4 - 4.2(a)No, the data appear to have no consistent...

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

View Full Document Right Arrow Icon
(d) The three-year moving average appears to give better results. = + = + = = + = + - = July June August July (a) 0.2(Forecasting error) 42 0.2(40 – 42) 41.6 (b) 0.2(Forecasting error) 41.6 0.2(45 41.6) 42.3 F F F F 4.4 (c) The banking industry has a great deal of seasonality in its processing requirements 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 June 16 6 36 96 July 17 7 49 119 August 18 8 64 144 September 20 9 81 180 October 20 10 100 200 November 21 11 121 231 December 23 12 144 276 Sum  218 78 650 1474 Average    18.2    6.5 (a) 1 4.2 (a) No, the data appear to have no consistent pattern (see part d for graph). Year 1 2 3 4 5 6 7 8 9 10 11 Forecast Demand 7 9 5 9.0 13.0 8.0 12.0 13.0 9.0 11.0 7.0 (b) 3-year moving 7.0 7.7 9.0 10.0 11.0 11.0 11.3 11.0 9.0 (c) 3-year weighted 6.4 7.8 11.0 9.6 10.9 12.2 10.5 10.6 8.4
Background image of page 1

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

View Full DocumentRight Arrow Icon
CHAPTER 4 F OR E C A S T I N G 2 (b) [i] Naive The coming January = December = 23 [ii] 3-month moving (20 + 21 + 23)/3 = 21.33 [iii] 6-month weighted [(0.1 × 17) + (.1 × 18) + (0.1 × 20) + (0.2 × 20) + (0.2 × 21) + (0.3 × 23)]/1.0 = 20.6 [iv] Exponential smoothing with alpha = 0.3 = + - = = + - = = + - = = + - = 18 0.3(20 18) 18.6 18.6 0.3(20 18.6) 19.02 19.02 0.3(21 19.02) 19.6 19.6 0.3(23 19.6) 20.62 21 Oct Nov Dec Jan F F F F [v] Trend 78, 6.5, 218, 18.17 x x y = y ∑ = = = - = = = - = - = 2 1474 (12)(6.5)(18.2) 54.4 0.38 650 12(6.5) 143 18.2 0.38(6.5) 15.73 b a Forecast = 15.73 + .38(13) = 20.67, where next January is the 13th month. (c) Only trend provides an equation that can extend beyond one month + + = (96 88 90) (a) 91.3 3 4.8 Table for Problem 4.9 (a, b, c) Forecast |Error| Two-Month Three-Month Two-Month Three-Month Price per Moving Moving Moving Moving Month Chip Average Average Average Average January $1.80 February 1.67 March 1.70 1.735 .035 April 1.85 1.685 1.723 .165 .127 May 1.90 1.775 1.740 .125 .160 June 1.87 1.875 1.817 .005 .053 July 1.80 1.885 1.873 .085 .073 August 1.83 1.835 1.857 .005 .027 September 1.70 1.815 1.833 .115 .133 October 1.65 1.765 1.777 .115 .127 November 1.70 1.675 1.727 .025 .027 December 1.75 1.675 1.683 .075 .067 Totals .750 .793
Background image of page 2
CHAPTER 4 F OR E C A S T I N G 3 + = (88 90) (b) 89 2 (c) Temperature 2 day M.A.  |Error| (Error) 2    Absolute % Error 93    — 94    — 93 93.5  0.5    0.25    100(.5/93)  = 0.54% 95 93.5  1.5     2.25    100(1.5/95)   = 1.58% 96 94.0  2.0    4.00    100(2/96)  = 2.08% 88 95.5  7.5    56.25    100(7.5/88)   = 8.52% 90 92.0  2.0    4.00    100(2/90)  = 2.22% 13.5 66.75 14.94% MAD = 13.5/5 = 2.7 (d) MSE = 66.75/5 = 13.35 (e) MAPE = 14.94%/5 = 2.99% (c) The forecasts are about the same. 4.10
Background image of page 3

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

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/16/2009 for the course BUSQOM 1070 taught by Professor Shang during the Fall '09 term at Pittsburgh.

Page1 / 10

HW Ch 4 - 4.2(a)No, the data appear to have no consistent...

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

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