Question: Please someone help me out with this homework assignment. I will thumbs up if answers make sense!! Trying to understand this so please leave clear

Please someone help me out with this homeworkPlease someone help me out with this homework

Please someone help me out with this homework

Please someone help me out with this homework assignment. I will thumbs up if answers make sense!! Trying to understand this so please leave clear answers to each question. Thank you!!!!!!!! Lmk if you need any other info.

(variation or oblem in chapter 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 RDB is bolted to the car using existing holes in the car's frame. Model RDW is a heavier roll bar that must be welded to the car's frame. Model RDB requires 20 pounds of a special high alloy steel, 40 minutes of manufacturing time, and 60 minutes of assembly time. Model RDW 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 40,000 pounds of the high-alloy steel will be available next quarter. In addition, Deegan estimates that 2000 hours of manufacturing time and 1600 hours of assembly time will be available next quarter. The profit contributions are $200 per unit for model RDB and $280 per unit for model RDW. Deegan's production manager used the Excel solver to solve the above product mix problem. The following is the output from Excel Solver: Answer Report Objective Cell (Max) Cell Original Value Final Value $G$1: Units Produced Total Profit $424,000.00 $424,000.00 Name Variable Cells Cell Name $C$1: Units Produced RDB $0$1: Units Produced RDW Original Value Final Value Integer 1000 1000 Contin 900 900 Contin Constraints Cell Name $E$7 Steel Availability Resource Used $$s Manufacturing Mins Resource Used $$9 Assembley Mins Resource Used Cell Value Formula Status Slack 40000 SE$70 $A$7 Binding a 120000 SESS$8 Hinding 92000 SESY

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!