Avion Computer produces two types of computers: Pear computers and Apricot computers. The relevant data are given in the file P06_52.xlsx. The equipment cost is a fixed cost that is incurred if any of this type of computer is produced. A total of 2000 chips and 1500 hours of labor are available.

a. Determine how Avion can maximize its net profit.

b. Use SolverTable to analyze the effect on the optimal solution of a change in the unit margin of Pear computers. Do the same for the unit margin of Apricot computers.