please dont copy answers from other posts, this has different numbers. please use the excel format provided. thank you!!

the company a 14.4 30. The Silver Star Bicycle Company will be manufac- turing men's and women's models of its Easy-Pedal 10-speed bicycle during the next two months, and would like a production schedule indicating how many bicycles of each model should be produced in each month. Current demand fore- casts call for 150 men's and 125 women's models to be shipped during the first month and 200 men's and 150 women's models to be shipped during the second month. Additional data are shown in Exhibit 14.29. Each month, 3,000 hours of manufactur- ing labor and 1,000 hours of assembly labor are available. The company charges monthly inven- tory at the rate of two percent of the production cost based on the inventory levels at the end of the month. Silver Star would like to have at least 25 units of each model in inventory at the end of the two months. Formulate this as a linear optimization model but do not solve (see Supplement D). Chapter 13 P7 Bicycle Production Plan Solve this problem using Level Strategy and Chase Strategy with the goal of minimizing production costs, labor hours and inventory costs. A. Level Strategy 8. Chase Strategy C. Which strategy works best to minimize total cost? Problem A Level Strategy $ Mens Beg Inventory Prodn Cost Mfg Labor (hrs) Assembly Labor (hrs) Desired End Inv 20 40 10 3 25 Demand Prodn End Iny Prodn Cost Labor Inv. Cost Month 1 Month 2 150 200 BegInv 20 0 $ Women's Beg Inventory Prodn Cost Mfg Labor (hrs) Assembly Labor (hrs) Desired End Inv 30 30 8 2 30 Demand Prodn End Inv Prodn Cost Labor Inv. Cost Month 1 Month 2 125 150 Beg. Inv 30 o Month 1 Month 2 Total labor Hrs Total labor Hrs add mens and womens labor hrs add mens and womens labor hes add mens and womens prodn costs add mens and womens inventory costs Total Production Cost Total Inventory Cost Total Cost Problem 8 Chase Strategy Use same data as in Problem A Mens Demand Prodn End Inv Prodn Cost Labor Inv. Cost Month 1 Month 2 150 200 Beg. Inv 20 0 Womens ni mundo 30 Desired End Inv Demand Prodn End Inv Prodn Cost Labor Inv. Cost Beg. Inv 30 Month 1 Month 2 125 150 Month 1 Month 2 Total labor Hrs Total labor Hrs add mens and womens labor hrs add mens and womens labor hrs add men and womens prodn costs add mens and womens inventory costs Total Production Cost Total Inventory Cost Total Cost Problem Chase Strategy Use same data as in Problem A Mens Demand Prodn End Inv Prodn Cost Labor Inv. Cost Month 1 Month 2 150 200 Beg. Inv 20 0 Womens Demand Prodn End Inv Prodn Cost Labor Beg. Inv 30 Inv. Cost Month 1 Month 2 125 150 Month 1 Month 2 Total labor Hrs Total labor Hrs add men and womens labor hrs add men and womens labor hrs Total Production Cost Total Inventory Cost Total Cost add mens and womens prodn costs add mens and womens Inventory costs Problem C Which strategy works best to minimize total cost