Question: Please make sure it is the Level Production Strategy. Please show in Excel file Format with the formulas in the cell. Given the following production

Please make sure it is the Level Production Strategy. Please show in Excel file Format with the formulas in the cell.

Please make sure it is the Level Production

Given the following production plan, compute the monthly production, ending inventory/(backlog) and workforce levels using a level production strategy. Assume that a worker can produce 30 units per month and the beginning inventory in June is 400 units, and the firm desires to have 200 units of inventory at the end of November. Month June Jul Aug Sep Oct Nov Demand 1500 2800 4200 3600 2350 1400 Production Ending Inventory Workforce

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!