Buckeye Manufacturing produces heads for engines used in the manufacture of trucks. The production line is highly complex, and it measures 900 feet...

38

2 55 38

3 44 30

4 0 0

5 45 48

6 45 48

7 36 58

8 35 57

9 35 58

Safety stock requirements are such that week-ending inventory must provide for at least 80 percent of the next week's demand.

Managerial Report Prepare a report for Buckeye's management with a production and changeover schedule for the next eight weeks. Be sure to note how much of the total cost is due to production, how much is due to inventory, and how much is due to changeover. Using Microsoft Excel to solve this problem. Submit a Excel file and a report.