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.