Question: answer part c and d please. a ABC Ltd. is a manufacturer of two products, P1 and P2, that require four manufacturing operations: Cutting, Sewing,

answer part c and d please. answer part c and d please. a ABC Ltd. is a
a ABC Ltd. is a manufacturer of two products, P1 and P2, that require four manufacturing operations: Cutting, Sewing, Finishing, and Packaging. A careful analysis of the manufacturing requirements resulted in the following table, which shows the production time requirements for the four operations and the accounting department's estimate of the profit contribution per one unit of the product: Production Time (hours) Product Cutting Sewing Finishing Packaging Profit per unit P1 P2 7 10 3 5. 3 2 1 2.5 $10 $9 The director of manufacturing estimates that 6,300 hours of cutting, 3,600 hours of sewing. 2,124 hours of finishing time, and 1,350 hours of packaging will available for the production of the two products The company wants to maximize total profit contribution a) (30 p.) Build a linear program (LP) that can be used to determine how many units of each product the company should manufacture. b) (30 p.) Solve the LP using the graphical procedure (Note: You may use any of the two graphical methods presented in the class materials; draw the feasible region manually and as neatly as possible). Show all your calculations. c) (20 p.) Solve the LP using also the Excel's Solver. Attach two Excel's screenshots as exhibits: the screenshot of the model itself (Sheet 1) and the Answer Report. d) (20 p.) Fully interpret your solution

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!