Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Finance Essentials

Authors: Charles O. Kroncke, Alan E. Grunewald, Erwin Esser Nemmers

2nd Edition

0829901590, 978-0829901597

More Books

Students also viewed these Finance questions