3 different excel files: one on forcasting, one on planning and one on scheduling
1. Complete the attached template 1 to assist LawnKing in forecasting. You will not just compute one forecast for next years sales, but multiple forecasts using a variety of forecasting methods. Of course, before you’re done, you’ll need to decide which forecasting method is the best for them! (Note: “Best is based on historical accuracy, and is not guarentee of future performance.)
Note — you’ll need your final forecast for the next assignment (Just copy then paste-special-values-only.)
2. Complete the attached template 2 to assist LawnKing in planning. You will not just compute one plan for next year’s production, but three separate plans using different methods. Of course, before you’re done, you’ll need to decide which planning method is the best for them! (Note: “Best is based on minimum total cost.)
Note: You’ll need your final forecast from the previous assignment before starting this one. (Just copy your data for the 12-months forecasted sales.)
3. Complete the attached template 3 to assist the Classic Car Repair shop in scheduling. You will not just compute one schedule for tomorrow’s production, but two separate schedules using different amounts of assets. Of course, before you’re done, you’ll need to decide which schedule is the best for them! (Note: “Best is based on minimum total cost.)
Note: This assignment is NOT connected to your LawnKing forecast or plan.
textbook: Operations Managementin Supply Chain: Decisions and Cases, 8th Edition By: Roger Schroeder and Susan Goldstein ISBN: 978-1-260-36810-9
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|