{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

# Case 4 - and attach your hand calculations for parts A B C...

This preview shows page 1. Sign up to view the full content.

MGSC 395 – Spring 2011 Forecasting Name_______________________ Due: on the day of your Final Exam You must submit your solution to me in writing (on paper) before you take the final exam. Electronic submissions cannot be accepted. The replacement-part inventory manager at Simpson Electric would like to develop a weekly forecast for replacement breakers. The following table provides the actual demand for the part over the last 6 weeks. Demand (in units) for replacement breakers at Simpson Electric Week 1 2 3 4 5 6 Demand 196 209 213 215 211 220 Calculate a forecast for week 7 using the following procedures. Answer each question using hand calculations (expect for D which can be calculated using POMS). Provide your answers on this page
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: and attach your hand calculations for parts A, B, C, and the POMS output for part D to this page. A. 5 week moving average Forecast for week 7: MAPE of your forecasting procedure: B. 3 week weighted moving average with weights of 50% for the most recent week, 30% for the next most recent week and 20% for the last week of the 3 week moving average. Forecast for week 7: MAPE of your forecasting procedure: C. Exponential Smoothing with a smoothing coefficient of 0.7. Assume that the starting forecast for week 1 is 200 units Forecast for week 7: MAPE of your forecasting procedure: D. Linear regression Forecast for week 7: MAPE of your forecasting procedure:...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online