MBI produces two types of computers: Sonwat & Tranfor. There are three critical resources: hard drives,...

  

Transcribed Image Text:

MBI produces two types of computers: Sonwat & Tranfor. There are three critical resources: hard drives, assembly labor and quality assurance labor. Next quarter MBI hopes to have 20,000 hard drives, 32,000 hours of labor in assembly and 88,000 hours of labor in QA. Each Sonwat contributes $900 to profits, and needs 2 hard drives while using 4 hours of assembly and 2 hours of QA, while each Tranfor contributes $600 to profits, and needs 1 hard drive while using 1 hour of assembly and 7 hours of QA. • Formulate a linear programming model with integer constraints on the number of Sonwat and Tranfor computers to maximize production for the next quarter. • Use Excel to determine how this can be done at maximize profit. MBI produces two types of computers: Sonwat & Tranfor. There are three critical resources: hard drives, assembly labor and quality assurance labor. Next quarter MBI hopes to have 20,000 hard drives, 32,000 hours of labor in assembly and 88,000 hours of labor in QA. Each Sonwat contributes $900 to profits, and needs 2 hard drives while using 4 hours of assembly and 2 hours of QA, while each Tranfor contributes $600 to profits, and needs 1 hard drive while using 1 hour of assembly and 7 hours of QA. • Formulate a linear programming model with integer constraints on the number of Sonwat and Tranfor computers to maximize production for the next quarter. • Use Excel to determine how this can be done at maximize profit.

Answer rating: 100% (QA)

Step 1 In numerous settings the term alludes to integer linear programming ILP in which the tr... View the full answer