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

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

View Full Document Right Arrow Icon
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
Background image of page 1
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

This note was uploaded on 06/06/2011 for the course MGSC 395 taught by Professor Zimmer during the Spring '10 term at South Carolina.

Ask a homework question - tutors are online