Question: Please Solve - please show formulas used for excel - step b y step. Please use data here. Hart Manufacturing makes three products. Each product

Please Solve - please show formulas used for excel- step by step. Please use data here.
Hart Manufacturing makes three products. Each product requires manufacturing operations in three departments: A,B, and C. The labor-hour requirements, by department, are as follows.
During the next production period, the labor-hours available are 450in department A,350in department B, and 50in department C. The profit contributions per unit are $27 for product 1,$29 for product 2, and $31$ Pf= units of product i produced, for i=1,2,3.P1',P2'P30
(b) Solve the linear program formulated in part (a). How much of each product should be produced, and what is the projected total profit contribution (in dollars)?
(P1,P2,P3)=(,) with profit $1iis produced and zero otherwise, for i=1,2,3.p1,P2',p30;y1'y2,y3=0,1
(e) Solve the mixed-integer linear program formulated in part (d). How much of each product should be produced, and what is the projected total profit contribution (in dollars)?
Please Solve - please show formulas used for

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!