Answered step by step
Verified Expert Solution
Question
1 Approved Answer
i really need this for tonight, thanks so much er z + 50% Chapter 7: Integer Linear Programming Question 6 (25 points). Hart Manufacturing makes
i really need this for tonight, thanks so much
er z + 50% Chapter 7: Integer Linear Programming Question 6 (25 points). Hart Manufacturing makes three products. Each product requires manufacturing operations in three departments A, B, and C. The labor-hour requirements, by department, are follows: 85 Product I Department Product 2 Product 3 1.50 3.00 2.00 2.00 1.00 2.50 C 0.25 0.25 0.25 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 The production supervisors noted that production setup costs had not been taken into account She noted that setup costs are $400 for product 1, $550 for product 2, and 5600 for product 3. Management also stated that we should not consider making more than 175 units of product 3. product of 2, units of 150 product units or 140 a Formulate a linear programming model for maximizing total profit contribution. Solve the linear program formulated in part (a). using the MS Excel Solver. b Provide screenshots for each excel sheet Your model sheet, excel solver screen (I want to see your inputs to solver), answer report, sensitivity analysis (see Appendix for examples) If you will miss to provide the screenshot for MS Excel Solver Solution, you will be graded for zero for the solution part. How much of each product should be produced, and what is the projected total profit contribution? What is the total profit contribution after taking into account the setup costs? OL 1 H L Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started