Buckeye Manufacturing produces heads for engines used in the manufacture of trucks. The production line is highly complex, and it measures 900 feet in length. Two types of engine heads are produced on this line: the P-Head and the H-Head. The P-Head is used in heavy duty trucks and the H-Head is used in smaller trucks. Because only one type of head can be produced at a time, the line is set up to manufacture either the P-Head or the H-Head, but not both. Changeovers are made over a weekend; costs are $500 in going from a setup for the P-Head to a setup for the H-Head, and vice versa. When set up for the P-Head, the maximum production rate is 100 units per week and when set up for the H-Head, the maximum production rate is 80 units per week. Buckeye just shut down for the week after using the line to produce the P-Head. The manager wants to plan production and changeovers for the next eight weeks. Currently, Buckeyes inventory consists of 125 P-Heads and 143 H-Heads. Inventory carrying costs are charged at an annual rate of 19.5% of the value of inventory. The production cost for the P-Head is $225, and the production cost for the H-Head is $310. The objective in developing a production schedule is to minimize the sum of production cost, plus inventory carrying cost, plus changeover cost. Buckeye received the following requirements schedule from its customer (an engine assembly plant) for the next nine weeks: Product Demand Week P-Head H-Head 1 55 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% of the next weeks demand. Managerial Report Prepare a report for Buckeyes 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.

Request to please provide detail working and excel image also for the same.