Individual Assignment 2 Excel Sheet

Individual Assignment 2 Excel Sheet - 154 151.33 2.67...

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

View Full Document Right Arrow Icon
Problem 2 Three-Period Simple Moving Average Chart for October Repair Calls October Number of Daily Calls Three-period Moving Average Forecast Forecast Error CFE 1 92.0 - - - CFE 2 127.0 - - - 31.3 3 106.0 - - - 4 165.0 108.3 56.7 56.7 MAD 5 125.0 132.7 -7.7 49.0 34.1 6 111.0 132.0 -21.0 28.0 7 178.0 133.7 44.3 72.3 8 97.0 138.0 -41.0 31.3 Three-Period Weighted Moving Average Forecast Chart for October Repair Calls October Number of Daily Calls Weight Moving Average Forecast Forecast Error CFE 1 92.0 - - - CFE 2 127.0 - - - 20.3 3 106.0 - - - 4 165.0 109.5 55.5 55.5 MAD 5 125.0 139.7 -14.7 40.8 38.9 6 111.0 133.2 -22.2 18.6 7 178.0 126.0 52.0 70.6 8 97.0 147.3 -50.3 20.3 Weights W1=.5, W2=.3, W3=.2
Background image of page 1

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

View Full DocumentRight Arrow Icon
Problem 3 Day Demand 3-Period Moving Average Forecast 3-Period Forecast Error 5-Period Moving Average Forecast 5-Period Forecast Error 3-Period CFE 5-Period CFE 1 200 - - 2 134 - - 3 147 - - 4 165 160.33 4.67 - 4.67 5 183 148.67 34.33 - 39.00 6 125 165.00 -40.00 165.80 -40.80 -1.00 -40.80 7 146 157.67 -11.67 150.80 -4.80 -12.67 -45.60 8
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 154 151.33 2.67 153.20 0.80-10.00-44.80 9 182 141.67 40.33 154.60 27.40 30.33-17.40 10 197 160.67 36.33 158.00 39.00 66.67 21.60 11 132 177.67-45.67 160.80-28.80 21.00-7.20 12 163 170.33-7.33 162.20 0.80 13.67-6.40 13 157 164.00-7.00 165.60-8.60 6.67-15.00 14 169 150.67 18.33 166.20 2.80 25.00-12.20 25.00-12.20 3 Period MSE 5 Period MSE 21.81 1664.64 1178.55 23.04 1600.00 0.64 136.19 750.76 7.13 1521 1626.51 829.44 1319.87 0.64 2085.75 73.96 53.73 7.84 49.00 541.33 335.99 764.96 1 2 3 4 5 6 7 8 9 10 11 12 13 14 0.00 50.00 100.00 150.00 200.00 250.00 ABC Floral Shop Geranium Demand Column B Column C Column E Problem 9 Period Tracking Signal CFE 20 1 300 290 10 19 0.5263157895 10 2 280 291-11 18.2-0.0549450549-1 3 309 289.9 19.1 18.29 0.9896118097 18.1 D t F t e t MAD t...
View Full Document

This note was uploaded on 01/31/2012 for the course MGT 302 taught by Professor Baker during the Spring '09 term at Miami University.

Page1 / 3

Individual Assignment 2 Excel Sheet - 154 151.33 2.67...

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