A manufacturer of executive jet aircraft is concerned with its profit picture over the short run. It produces two different models of planes, x1 and x2. Its profits are $30,000 for each x1 and $20,000 for each x2. There are two major constraints on production:
Labor 4 x1 + 2 x2 ≤ 17 weeks
Materials 5x1 + 4x2 ≤ 21 tons
x1, x2 ≥ 0 and integer
Also, assume that no more than 4 x2's can be produced due to a prior union agreement.
Solve this problem using Excel.