Production and Operations Management – excel activities on forecasting, scheduling and planning
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →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
Get a plagiarism-free answer to this question
Send us your instructions and we’ll match you with the best writer in your subject.
- 100% human-written, zero AI
- Turnitin report included
- Confidential — we never share your data
- Free revisions & refunds