A company produces two products, A and B, which have profits of $9 and $7, respectively Each unit of product must be processed on two assembly lines, where the required production times are as follows Product Line 1 Line 2 A 11 5 B 6 9 Total Hours 65 40 a Formulate a linear programming model to determine the optimal product mix that will maximize profit b What are the sensitivity ranges for the objective function coefficients c Determine the shadow prices for additional hours of production time on line 1 and line 2 and indicate whether the company would prefer additional line 1 or line 2 hours PLEASE USE EXCEL AND SHOW FORMULAS A B products Hours Unit Product Line 1 Line2 Constraints Total Hours Profits ($) 15 Product A Product B decision variables Maximized profits Obiective function Sensitivity Range for the coefficient of of units of product A in the objectivefunction Sensitivity Range for the coefficient of of units of product B in the objectiveru nction (c Shadow Price for additional hours of production time on Line 1 Shadow Price for additional hours of production time on Line 2 Which one of the two the company would prefer (Line 1 or Line 2 )

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 14, 2024

A company produces two products, A and B, which have profits of $9 and $7, respectively. Each unit of product must be processed on two

A company produces two products, A and B, which have profits of $9 and $7, respectively. Each unit of product must be processed on two assembly lines, where the required production times are as follows:

Product	Line 1	Line 2
A	11	5
B	6	9
Total Hours	65	40

a. Formulate a linear programming model to determine the optimal product mix that will maximize profit. b. What are the sensitivity ranges for the objective function coefficients?

c. Determine the shadow prices for additional hours of production time on line 1 and line 2 and indicate whether the company would prefer additional line 1 or line 2 hours.

image text in transcribed

PLEASE USE EXCEL AND SHOW FORMULAS

A & B products Hours/ Unit Product Line 1 Line2 Constraints Total Hours Profits ($) 15 Product A Product B decision variables Maximized profits Obiective function Sensitivity Range for the coefficient of # of units of product A in the objectivefunction Sensitivity Range for the coefficient of # of units of product B in the objectiveru nction (c Shadow Price for additional hours of production time on Line 1 Shadow Price for additional hours of production time on Line 2 Which one of the two the company would prefer (Line 1 or Line 2?)