Fruit 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...

Fruit 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 3000 chips and 1200 hours of labor are available.

a. Determine how Fruit can maximize its profit.

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