(***) (Microsoft Excel problem) Note that problems 6 through 8 could all be solved by using a single spreadsheet that allows the user to change the planning, “Forecasted Sales,” and “Actual Workers” values. Create this spreadsheet. Your spreadsheet should calculate new results any time the planning, “Forecasted Sales,” or “Actual Workers” values change. Verify that your spreadsheet works by determining whether it generates the same costs for a level production plan and a chase production plan shown in problems 6 and 7.
problems 6 and 7:
6. (**) Complete the level production plan, using the following information. The only costs you need to consider here are layoff, hiring, and inventory costs. If you complete the plan correctly, your hiring, layoff, and inventory costs should match those given here.
7. (**) Complete the chase production plan, using the following information. The only costs you need to consider here are layoff, hiring, and inventory costs. If you complete the plan correctly, your hiring, layoff, and inventory costs should match those given here.
