Please answer D & E. The Porsche Club of America sponsors driver education events that provide high-performance driving instruction on actual race tracks. Because safety is a primaryconsideration 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 tothe 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 alloysteel, 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 manufacturingtime, and 40 minutes of assembly time. Deegan's steel supplier indicated that at most 36,000 pounds of the high-alloy steel will be available next quarter. In addition,Deegan estimates that 2,000 hours of manufacturing time and 1,700 hours of assembly time will be available next quarter. The profit contributions are $200 per unit formodel DRB and $280 per unit for model DRW. The linear programming model for this problem is as follows:Maxs.t.200DRB + 280DRWThe computer solution is shown below.20DRB + 25DRW40DRB + 100DRW60DRB + 40DRWDRB, DRW >VariableDRBDRWOptimal Objective Value = 388800.00000Constraint123VariableDRBDRWConstraint12W N3≤36,000≤ 120,000≤ 102,0000Value600.00000960.00000Slack/SurplusReduced Cost0.000000.000000.000000.0000027600.00000200.00000280.00000Steel availableManufacturing minutesAssembly minutesObjective Allowable AllowableCoefficientDecreaseIncrease24.0000088.00000220.0000030.00000RHSValue36000.00000120000.00000102000.00000Dual Value8.800000.600000.00000AllowableIncrease6272.7272724000.00000InfiniteAllowableDecrease6000.0000039428.5714327600.00000 (a) What is the optimal solution and the total profit contribution (in $)?DRBDRWtotal 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 poundsof 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.No, there is a slack value of 6,273, 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.No, the allowable increase for steel is only 24 pounds, so the additional profits are not applicable for 500 pounds.(c) Deegan is considering using overtime to increase the available assembly time. What would you advise Deegan to do regarding this option? Explain.Constraint ? ✓ has a slack. Increasing the number of hours of assembly time will |---Select--- profits.(d) Because of increased competition, Deegan is considering reducing the price of model DRB such that the new contribution to profit is $175 per unit. How would thischange in price affect the optimal solution? Explain.The objective coefficient range for model DRB shows a lower limit of $$Thus, the optimal solution ---Select--- change and the new value will be(e) If the available manufacturing time is increased by 500 hours, will the dual value for the manufacturing time constraint change? Explain.The allowable increase isminutes, so the dual value for this constraint ---Select--- ✓ change.

Production is the process in which inputs are combined to have the required output. It includes a…

(d) Because of increased competition, Deegan is considering reducing the price of model DRB such that the new contribution to profit is $175 per unit. How would this change in price affect the optimal solution? Explain. The objective coefficient range for model DRB shows a lower limit of $ $ . Thus, the optimal solution --Select--- change and the new value will be (e) If the available manufacturing time is increased by 500 hours, will the dual value for the manufacturing time constraint change? Explain. The allowable increase is minutes, so the dual value for this constraint ---Select--- change.

(d) Because of increased competition, Deegan is considering reducing the price of model DRB such that the new contribution to profit is $175 per unit. How would this change in price affect the optimal solution? Explain. The objective coefficient range for model DRB shows a lower limit of $ $ . Thus, the optimal solution --Select--- change and the new value will be (e) If the available manufacturing time is increased by 500 hours, will the dual value for the manufacturing time constraint change? Explain. The allowable increase is minutes, so the dual value for this constraint ---Select--- change.

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...

See similar textbooks

Similar questions

importance of the following in air freight forwarding Knowledge of customs regulations, Good service industry, Qualified workers.
14 Online channels generally support service provision with lower transaction costs than offline channels. Select one: a. False b. True
Assume that you manage a full-service country club. Wesson Brothers, purveyors of fine meats, has been your main source of meat supply for a considerable period. Recently, Wesson proposed a “trade-off”, they want to get out of the transportation business and are considering allowing their customers to pick up their own orders. In doing that, Wesson will reduce their AP price by 8%. a. Would you like to perform the transportation function? Why or why not? b. Assume that you do not wish to preform the transportation function, and that Wesson is an exclusive distributor for certain products you must have. What do you suggest?
3. Define whether a motor carrier's costs are more fixed or variable. Explain your answer.
Explain the distribution and the inventory management of travel industry? (Paragraph form please)
4 - This term represents the removal of traditional service provider transactions - which occurs when an intermediary (i.e. human agent) is cut from the value chain. Disintermediation Channel cooperation Reintermediation Channel conflict
What is Amazon Simple Storage Service (S3)?
1.decribe the following letter services: surcharges(tax), envelopes and cards and redirection.
Prepare a request for proposal for a new KFC Mobile Apps Ordering System?
1. a. Define following: iv. Cycle Inventory v. Level of Product Availability vi. Reverse Logistics vii. Honey Combing