Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a catcher's model. The firm has 900 hours of production time available In Its cutting and sewing department, 300 hours available in Its finishing department, and 400 hours available in its packaging and shipping department. The production time requirements and the profit contribution per glove are given In the following table: Production Time (Hours) Cutting and Packaging and Model Sewing Finishing Shipping Profit/Glove Regular model 1/2 1/8 $5 Catcher's model 3/2 1/4 1/7 $7 Assuming that the company Is Interested In maximizing the total profit contribution, answer the following: (a) What is the linear programming model for this problem? If required, round your answers to 3 decimal places or enter your answers as a fraction. If the constant Is "1" it must be entered In the box. Do not round Intermediate calculation. If an amount Is zero, enter "D". Let A = number of units of regular model. C = number of units of catcher's model. Max 7 c S.t. 1.50 900 Cutting and Sewing 333 WR + .333 300 Finishing .333 100 packing and Shipping R. C v (b) Develop a spreadsheet model and find the optimal solution using Solver. How many gloves of each model should Kelson manufacture? Regular Model = 500 units Catcher's Model = 150 / units (c) What is the total profit contribution Kelson can earn with the given production quantities? 3700* (d) How many hours of production time will be scheduled In each department? Department Production Time (Hours)(b) Develop a spreadsheet model and find the optimal solution using Solver. How many gloves of each model should Kelson manufacture? Regular Model = 500 units Catcher's Model = 150 units (c) What is the total profit contribution Kelson can earn with the given production quantitles? 3700 (d) How many hours of production time will be scheduled In each department? Department Production Time (Hours) Cutting and Sewing 900 Finishing 200 Packing and Shipping 100 [e) What is the slack time in each department? If your answer is zero, enter "0 Department Slack Time ( Hours) Cutting and Sewing 750 X Finishing 300 Packing and Shipping 100 X " Hide Feedback Partially Correct Hint ( 5) Check My Work O- Icon Key Problem 12-01 Algo (A Simple Maximization Problem) Question 1 of 5 k Save Submit AmalmamasPhoton Technologies, Inc., a manufacturer of batteries for mobile phones, signed a contract with a large electronics manufacturer to produce three models of lithium-Ion battery packs for a new line of phones. The contract calls for the following: Battery Pack Production Quantity PT-100 200,DOO PT-200 100,000 PT-300 150,D00 Photon Technologies can manufacture the battery packs at manufacturing plants located In the Philippines and Mexico. The unit cost of the battery packs differs at the two plants because of differences In production equipment and wage rates. The unit costs for each battery pack at each manufacturing plant are as follows: Plant Product Philippines Mexico PT-100 $0.95 $0.98 PT-200 $0.98 $1.06 PT-300 $1.34 $1.15 The PT-100 and PT-200 battery packs are produced using similar production equipment available at both plants. However, each plant has a limited capacity for the total number of PT- 100 and PT-200 battery packs produced. The combined PT-100 and PT-200 production capacities are 175,000 units at the Philippines plant and 160,000 units at the Mexico plant. The PT-300 production capacities are 75,000 units at the Philippines plant and 100,000 units at the Mexico plant. The cost of shipping from the Philippines plant is $0.18 per unit, and the cost of shipping from the Mexico plant Is $0.10 per unit. (a) Develop a linear program that Photon Technologies can use to determine how many units of each battery pack to produce at each plant to minimize the total production and shipping cost associated with the new contract. If the constraint Is one, enter "1". If the amount Is zero, enter "D". Let P1 = number of PT-100 battery packs produced at the Philippines plant P2 = number of PT-200 battery packs produced at the Philippines plant P3 = number of PT-300 battery Con. Behavior Print.docx Want M1 = number of PT-100 battery packs produced at the Mexico plant M2 = number of PT-200 battery packs produced at the Mexico plant M3 = number of PT-300 battery packs produced at the Mexico plant Min 1.1 PI + 1.13 3 pz + 1.49 p3 + 1.06 MI + 1.14 20M2 + 1.23 /M3 s.t. 4000 0 PI + PZ + P3 + MI + * MZ + M3 200001 Production PT-100 PZ p3 + MI + M3 100001 Production PT-200(b) Solve the linear program developed In part (a), to determine the optimal production plan. If the amount Is zero, enter "0". Qty Produced Phillipines Mexico PT-100 40000 160000 V PT-200 1000 0 PT-300 50000 100000 Total Cost = $ 524,10 x (c) Use sensitivity analysis to determine how much the production and/or shipping cost per unit would have to change to produce additional units of the PT-100 In the Philippines plant. If required, round your answer to two decimal digits. At least $ * / unit. (d) Use sensitivity analysis to determine how much the production and/or shipping cost per unit would have to change to produce additional units of the PT-200 In the Mexico plant. If required, round your answer to two decimal digits. At least $ .05 19/ unit. Hide Feedback Partially Correct Hint(5) Check My Work O- Icon Key Problem 12-08 Algo (Sensitivity Analysis) Question 2 of 5 F Save Submit Assignment for Grading