Question: please solve in excel and show step by step instructions. Hart Manufacturing makes three products. Each product requires manufacturing operations in three departments: A, B,

please solve in excel and show step by step instructions.  please solve in excel and show step by step instructions. Hart
Manufacturing makes three products. Each product requires manufacturing operations in three departments:

Hart Manufacturing makes three products. Each product requires manufacturing operations in three departments: A, B, and C The labor-hour requirements, by department, are shown in the spreadsheet. During the next production period, the labor hours available are 450 in department A, 350 in department B, and 50 in department C. The profit contributions per unit are $25 for product 1,$28 for product 2 , and $30 for product 3 . a. Formulate a linear programming model in the spreadsheet for maximizing total profit contribution. 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? Hart Manufacturing Parameters Labor Hours/Unit

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!