{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

OPMACh2HW2 - 1 Computer Store Printer Rentals Week 6 Week 7...

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

View Full Document Right Arrow Icon
1. Computer Store Printer Rentals Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 a. S b. b.i. Week 6: |28 – 27| = 1, Week 7: |32 – 28| = 4, Week 8: |35 – 30| = 5, Week 9: |26 – 30| = 4, Week 10: |24-30| = 6 b.i.1. Total = 20/5 = 4 Month 3-month average Absolute Error(3) Percent Error (3) 4-month average Absolute Error(4) Percent Error (4) May |37-27.33|=9.67 26.14% |37-25.5|=11.5 31.08% June |47-31.67|=15.33 32.62% |47-29.75|=17.25 36.71% July |53-38.33|=14.67 27.68% |53-35.5|=17.5 33.02% August |62-45.67|=16.33 26.34% |62-42|=20 32.26% September |54-54|=0 0% |54-49.75|=4.25 7.87% October |36-56.33|=20.33 56.47% |36-54|=18 50% November |32-50.67|=18.67 58.34% |32-51.25|=19.25 60.16% December |29-40.67|=11.67 40.24% |29-46|=17 58.62% Average: 13.33 33.48% 15.59 38.71% 2. Dalworth Company Sales Questions C-E Answers Measure 3-Month 4-Month Recommendation Mean Absolute Deviation 13.33 15.59 3-Month Mean Absolute % Error 33.48% 38.71% 3-Month
Background image of page 1

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

View Full Document Right Arrow Icon
Mean Squared Error 213.56 267.21 3-Month In reference to above [C-E) 26.14 31.0810 8 9.67 11.5 32.62 36.7021 3 15.33 17.25 27.68 33.0188 7 14.67 17.5 26.34 32.2580 6 16.33 20 0 7.87037 0 4.25 56.47 50 20.33 18 58.34 60.1562 5 18.67 19.25 40.24 58.6206 9 11.67 17 33.4787 5 38.7134 3 1708.46 2 213 7.68 8 213.557 8 267. 210 9 (Excel Document) 3. Week Actual Calls F(t+1) Alpha Error CFE MAD MSE MAPE 1 24 24 0.2 0 0 2 32 25.6 0.2 8 8 8 64 25 3 36 27.68 0.2 10.4 18.4 10.4 108.16 28.8888 9 4 23 26.744 0.2 -4.68 13.72 4.68 21.9024 20.3478 3 5 25 26.3952 0.2 -1.744 11.976 1.744 3.04153 6 6.976 6 26.4 0.2 6.206 49.2759 8 20.3031 8 4) [a] Month Sales ($ millions) 3-Month Weighted Average Absolute Error Absolute Error % Squared Error January 20 February 24 March 27 April 31 24.83 6.17 19.89 38.03 May 37 28.5 8.5 22.97 72.25 June 47 33.33 13.67 29.08 186.78 July 53 41 12 22.64 144
Background image of page 2
August 62 48.33 13.67 22.04 186.78 Septembe r
Background image of page 3

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

View Full Document Right Arrow Icon
Background image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}