week 7 homework question>>>>>>>>>>>>>xoon only

profilemvm1116
hw7_answer_sheet.xlsx
Home>Mathematics homework help>week 7 homework question>>>>>>>>>>>>>xoon only

P8

Sporting Goods
(1) Resource Requirements per Unit (2) Resource Requirements per Unit
Product Rubber (lb.) Leather (ft2) Product Rubber (lb.) Leather (ft2)
Basketball 3 4 Basketball 3 4
Football 2 5 Football 2 5
input Constraints
Total resources available 500 800 Total resources available 500 800
Basketball Football Basketball Football
Profits ($) 12 16 Profits ($) 13 15
Basketball Decision variables Basketball
Football Football
Maximized profits input Objective function Maximized profits
(3a) Resource Requirements per Unit (3b) Resource Requirements per Unit
Product Rubber (lb.) Leather (ft2) Product Rubber (lb.) Leather (ft2)
Basketball 3 4 Basketball 3 4
Football 2 5 Football 2 5
input Constraints
Total resources available 1000 800 Total resources available 500 1300
Basketball Football Basketball Football
Profits ($) 12 16 Profits ($) 12 16
Basketball Decision variables Basketball
Football Football
Maximized profits input Objective function Maximized profits
Please use computer method to solve the problem
Please enter your solution in Yellow cells

P10

A & B products
Hours/ Unit
Product Line 1 Line2
A 12 4
B 4 8
Constraints
Total Hours 60 40
A B
Profits ($) 9 7
Product A decision variables
Product B
Maximized profits Objective function

P11

A & B products
(1) Hours/ Unit (2a) Hours/ Unit
Product Line 1 Line2 Product Line 1 Line2
A 12 4 A 12 4
B 4 8 B 4 8
Constraints
Total Hours 40 40 Total Hours 60 40
A B A B
Profits ($) 9 7 Profits ($) 9 15
Product A decision variables Product A
Product B Product B
Maximized profits Objective function Maximized profits
(2b) Hours/ Unit
Product Line 1 Line2
A 12 4
B 4 8
Total Hours 60 40
A B
Profits ($) 9 20
Product A
Product B
Maximized profits

P12

Please run sensitivity analysis on P10 and enter the results (changes in coefficients of the objective function, and shadow prices) in YELLOW cells
Sensitivity analysis Min Max
Product A Coefficients in the objective function (profits for A and B)
Product B
Shadow price Additional Profits
Line 1
Line 2

P14

Irwin textile mills
Corduroy denim
Profits for each product 3.1 2.25
Resources Available Resources Left over
Cotton 7.5 5 <= 6500
Labor 3.2 3 <= 3000
Demands
Corduroy <= 510
denim <= 1000000
Maximized profits
Corduroy denim Corduroy denim
Profits for each product 3.1 3 Profits for each product 4 2.25
Resources Available Resources Resources Available Resources
Cotton 7.5 5 <= 6500 Cotton 7.5 5 <= 6500
Labor 3.2 3 <= 3000 Labor 3.2 3 <= 3000
Demands Demands
Corduroy <= 510 Corduroy <= 510
denim <= 1000000 denim <= 1000000
Maximized profits Maximized profits
Corduroy denim
Profits for each product 3.1 2.25
Resources Available Resources
Cotton 7.5 5 <= 6000
Labor 3.2 3 <= 3000
Demands
Corduroy <= 510
denim <= 1000000
Maximized profits

P15

Please run sensitivity analysis on P14 and answer the following questions.
a.       If Irwin Mills can obtain additional cotton or processing time, but not both, which should it select? How much? Explain your answer.
Answer:
a.       Identify the sensitivity ranges for the objective function coefficients and for the constraint quantity values.
Then explain the sensitivity range for the demand for corduroy.
Min Max
Corduroy Demand ranges

P16 & P18

United Aluminum company
Aluminum Grade Mill
1 2 constraints
High 6 2 >= 12
Medium 2 2 >= 8
Low 4 10 >= 5
Aluminum Grade Mill
1 2
Cost ($) 6000 7000
Mill #1
Mill #2
Minimize Cost ($)
a.       Identify and explain the shadow prices for each of the aluminum grade contract requirements.
Shadow Price
High
Medium
Low
b.       Identify the sensitivity ranges for the objective function coefficients and the constraint quantity values.
Min Max
Mill #1
Mill #2
c. Aluminum Grade Mill
1 2 constraints
High 6 2 >= 20
Medium 2 2 >= 8
Low 4 10 >= 5
Aluminum Grade Mill
1 2
Cost ($) 6000 7000
Mill #1
Mill #2
Minimize Cost ($)

P24

Burger Doodle franchise
Biscuit Labor (hr.) Sausage (lb.) Ham (lb.) Flour (lb.)
Sausage 0.01 0.1 --- 0.04
Ham 0.024 --- 0.15 0.04
Constraints
6 30 30 16
Sausage Ham
Profits ($) 0.6 0.5
Sausage
Ham
Maximize Profits
a.       Identify and explain the shadow prices for each of the resource constraints
Shadow Price
Labor
Sausage
Ham
Flour
b.       Which of the resources constrains profit the most? Answer:
c. Identify the sensitivity ranges for the profit of a sausage biscuit and the amount of sausage available.
Min Max
Sausage Profits
Sausage amounts