Truckco manufactures two types of trucks; the T1 and the T2. Each truck must go

Question

Truckco manufactures two types of trucks; the T1 and the T2. Each truck must go through the painting shop and the assembly shop. If the painting shop were completely devoted to the T1, 800 trucks could be painted in a day. If it were completely devoted to painting the T2, 700 trucks could be painted per day. If the assembly shop were devoted exclusively to assembling T1 engines, 1500 per day could be assembled. If it were devoted to assembling T2 engines 1200 could be assembled in one day.

The T1 contributes $300 in profit and the T2 contributes $500. Develop and solve a spreadsheet model to determine the optimum integer number of each truck type to manufacture each day to maximize profit?

Use solver table or parameter analysis to show how the number of each type and the profit vary as the number of T1’s that can be painted per day varies from 1000 to 2000 in increments of 100.

Explanation / Answer

SOLUTION x1 : number of type 1 trucks manufactured x2 : number of type 2 trucks manufactured Maximize 300 x1 + 500 x2 (objective function) subject to :        7 x1 +   8 x2    5600 (painting constraint) 12 x1 + 15 x2   18000 (assembly constraint)         x1 , x2 0 (sign restrictions) BY Using Solver (in excel) Variable X1 X2 Coefficient 300 500 Solutions 0 700 Z 350000 Constraints 1 7 8

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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