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,

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
Get step-by-step solutions from verified subject matter experts
