{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

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

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

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

View Full Document
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
August 62 48.33 13.67 22.04 186.78 Septembe r

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}