The Porsche Club of America sponsors driver education events that provide high-performance driving instruction on actual race tracks. Because safety is a primary consideration at such events owners elect to install roll bars in their cars. Deegan Industries manufactures two types of roll bars for Porsches. Model DRB is bolted to the car using existing holes in the car's frame. Model D heavier roll bar that must be weided to the car's frame. Model DRB requires 20 pounds of a special high alloy steel, 40 minutes of manufacturing time, and 60 minutes of assembly time. Model requires 25 pounds of the special high alloy steel, 100 minutes of manufacturing time, and 40 minutes of assembly time. Deegan's steel supplier indicated that at most 38,000 pounds of the hig steel will be avalable next quarter. In addition, Deegan estimates that 2,000 hours of manufacturing time and 1,800 hours of assembly time will be available next quarter. The profit contribution $200 per unit for model DRB and $280 per unit for model DRW. The linear programming model for this problem is as follows: Max 200DRB + 28ODRW s.t. S 38,000 Steel avalable 40DRB + 100DRW S 120,000 Manufacturing minutes 60DRB + 40DRW S 108,000 Assembly minutes 20DRB + 25DRW DRB, DRW 2 The computer solution is shown below. Optimal Objective Value - 40400.c0000 Variable Value Reduced Coat DRS B00.00000 0.00000 DRN 0.00000 0.00000 Constraint Slack/Surplus Dual Value 0.00000 0.00000 0.60000 24800.00000 0.00000 Allowable ALlowable Cbjective Coetticient Variable Increase Decrease .00000 30.00000 D 200.00000 24.00000 280.00000 220.00000 Allowable Decrease Allowable Conat.caint. Value Increase

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question
The Porsche Club of America sponsors driver education events that provide high-performance driving instruction on actual race tracks. Because safety is a primary consideration at such events, many
owners elect to install roll bars in their cars. Deegan Industries manufactures two types of roll bars for Porsches. Model DRB is bolted to the car using existing holes in the car's frame. Model DRW is a
heavier roll bar that must be welded to the car's frame. Model DRB requires 20 pounds of a special high alloy steel, 40 minutes of manufacturing time, and 60 minutes of assembly time. Model DRW
requires 25 pounds of the special high alloy steel, 100 minutes of manufacturing time, and 40 minutes of assembly time. Deegan's steel supplier indicated that at most 38,000 pounds of the high-alloy
steel will be avallable next quarter. In addition, Deegan estimates that 2,000 hours of manufacturing time and 1,800 hours of assembly time will be available next quarter. The profit contributions are
$200 per unit for model DRB and $280 per unit for model DRW. The linear programming model for this problem is as follows:
Max
200DRB + 280DRW
s.t.
S 38,000 Steel available
S 120,000 Manufacturing minutes
S 108,000 Assembly minutes
20DRB + 25DRW
40DRB + 10ODRW
60DRB + 40DRW
DRB, DRW 2
The computer solution is shown below.
Optimal objective Value - 406400.00000
Variable
Value
Reduced Coat
DRS
800.00000
0.00000
DRN
0.00000
0.00000
Deal Value
8.60000
0.60000
Constraint
Slack/Surplus
0.00000
0.00000
24000.0000
0.00000
ALlowable
Decrease
Allowable
Objective
Coetticient
Variable
Increase
200.00000
24.00000
8.00000
280.00000
220.00000
30.00000
Allowable
Decrease
00.00000
35428.5714
240.0000o
Allowable
Constraint
Value
Increase
38000.0000o
S636.36364
120000.000o
32000.0000D
108000.00000
Infinite
Transcribed Image Text:The Porsche Club of America sponsors driver education events that provide high-performance driving instruction on actual race tracks. Because safety is a primary consideration at such events, many owners elect to install roll bars in their cars. Deegan Industries manufactures two types of roll bars for Porsches. Model DRB is bolted to the car using existing holes in the car's frame. Model DRW is a heavier roll bar that must be welded to the car's frame. Model DRB requires 20 pounds of a special high alloy steel, 40 minutes of manufacturing time, and 60 minutes of assembly time. Model DRW requires 25 pounds of the special high alloy steel, 100 minutes of manufacturing time, and 40 minutes of assembly time. Deegan's steel supplier indicated that at most 38,000 pounds of the high-alloy steel will be avallable next quarter. In addition, Deegan estimates that 2,000 hours of manufacturing time and 1,800 hours of assembly time will be available next quarter. The profit contributions are $200 per unit for model DRB and $280 per unit for model DRW. The linear programming model for this problem is as follows: Max 200DRB + 280DRW s.t. S 38,000 Steel available S 120,000 Manufacturing minutes S 108,000 Assembly minutes 20DRB + 25DRW 40DRB + 10ODRW 60DRB + 40DRW DRB, DRW 2 The computer solution is shown below. Optimal objective Value - 406400.00000 Variable Value Reduced Coat DRS 800.00000 0.00000 DRN 0.00000 0.00000 Deal Value 8.60000 0.60000 Constraint Slack/Surplus 0.00000 0.00000 24000.0000 0.00000 ALlowable Decrease Allowable Objective Coetticient Variable Increase 200.00000 24.00000 8.00000 280.00000 220.00000 30.00000 Allowable Decrease 00.00000 35428.5714 240.0000o Allowable Constraint Value Increase 38000.0000o S636.36364 120000.000o 32000.0000D 108000.00000 Infinite
(a) What is the optimal solution and the total profit contribution (in $)?
DRB
DRW
total profit contribution
(b) Another supplier offered to provide Deegan Industries with an additional 500 pounds of the steel alloy at $2 per pound. Should Deegan purchase the additional pounds of the steel alloy? Explain.
Yes, there is no surplus of steel so any additional steel that becomes available should be purchased.
Yes, the dual value for steel available is 8.8. Each pound of steel will increase profits more than the $2 per pound that the supplier is offering.
O No, the allowable Increase for steel is only 24 pounds, so the additional profits are not applicable for S00 pounds.
O No, there is a slack value of 5,636, so additional pounds of steel will not increase profits.
No, the dual value for steel available is 0.6. Each pound of steel will not increase profits enough to justify the $2 per pound that the supplier is offering.
(c) Deegan is considering using overtime to increase the available assembly time. What would you advise Deegan to do regarding this option? Explain.
Constraint 0 has a slack. Increasing the number of hours of assembly time willSetect--- B profits.
(d) Because of increased competition, Deegan is considering reducing the price of model DRB such that the new contribution to profit ia $175 per unit. How would this change in price affect the
optimal solution? Explain.
Thus, the optimal solution-elect change and the new value will be s
The objective coefficient range for model DRB shows a lower limit of $
(e) If the avalable manufacturing time is Increased by 500 hours, will the dual value for the manufacturing time constraint change? Explain.
minutes, so the dual value for this constraint Select B change.
The allowable increase is
Need Help?
Read
Transcribed Image Text:(a) What is the optimal solution and the total profit contribution (in $)? DRB DRW total profit contribution (b) Another supplier offered to provide Deegan Industries with an additional 500 pounds of the steel alloy at $2 per pound. Should Deegan purchase the additional pounds of the steel alloy? Explain. Yes, there is no surplus of steel so any additional steel that becomes available should be purchased. Yes, the dual value for steel available is 8.8. Each pound of steel will increase profits more than the $2 per pound that the supplier is offering. O No, the allowable Increase for steel is only 24 pounds, so the additional profits are not applicable for S00 pounds. O No, there is a slack value of 5,636, so additional pounds of steel will not increase profits. No, the dual value for steel available is 0.6. Each pound of steel will not increase profits enough to justify the $2 per pound that the supplier is offering. (c) Deegan is considering using overtime to increase the available assembly time. What would you advise Deegan to do regarding this option? Explain. Constraint 0 has a slack. Increasing the number of hours of assembly time willSetect--- B profits. (d) Because of increased competition, Deegan is considering reducing the price of model DRB such that the new contribution to profit ia $175 per unit. How would this change in price affect the optimal solution? Explain. Thus, the optimal solution-elect change and the new value will be s The objective coefficient range for model DRB shows a lower limit of $ (e) If the avalable manufacturing time is Increased by 500 hours, will the dual value for the manufacturing time constraint change? Explain. minutes, so the dual value for this constraint Select B change. The allowable increase is Need Help? Read
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.