Professor Yih-Long Chang Exam 01 (May 24, 2017 MGT 2251 Summer 2017 For the mont

Question

Professor Yih-Long Chang Exam 01 (May 24, 2017 MGT 2251 Summer 2017 For the month of the company can buy and use up to 30,000 pounds of raw sheeting or chassis. Similarly, 25,000 pounds of aluminum are available. One standard chassis rack requires 12 pounds of steel and 8 pounds of aluminum. A Deluxe chassis rack requires 10 pounds of steel and 12 pounds ofaluminum The output of metal sheeting is restricted by the capacity of the polisher. For January the polisher can handle any mix of the two metals up to 5,000 pounds of metal sheeting Chassis manufacture is restricted by either metal stamping or assembly operations No polishing is required. During the month no more than 3,000 total chassis can be stamped. There are 1500 hours of assembly time available each month. Valley's efficient operations manager has reduced the assembly time to 36 minutes for the Standard chassis rack and 48 minutes for the Deluxe chassis rack. Market conditions limit the number of chassis racks sold to no more than 1.200 Standard and no more than 1,000 Deluxe. Any quantities of metal sheeting can be sold Use only the following decision variables to formulate the problem as an LP model: SS pounds of steel sheeting produced and sold AS pounds of aluminum sheeting produced and sold SC number of Standard chassis racks produced and sold DC number of Deluxe chassis racks produced and sold Optimize the LP model with Excel Solver and the following reports show th spreadsheet model, the answer, and the sensitivity report. Answer the following questions based on these reports. Valley Chassis T T T T O6 Unit profit DVI Stamping SC Market Market

Explanation / Answer

12) SC+ DC = 1200 +975 = 2175   

see table { B4,C4,D4,E4)

option d) is correct

13) 21 is answer

F11 - assembly LHS {see table}

14)

A) raw steel is correct

as F7 (raw steel LHS) is 0 .

all other options have non-zero value.

15) 0.1 is correct answer

steel sheeting - allowable increase - 0.1 see table B4

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.