A leading hardware company produces three types of computers: Pear computers, Apricot computers, and Orange computers. The relevant data are given in the file S14_91.xlsx. The equipment cost is a fixed cost; it is incurred if any of this type of computer is produced. A total of 30,000 chips and 12,000 hours of labor are available. The company wants to produce at least two types of computers.
a. Determine how the company can maximize its profit.
b. For any computer type not in the optimal product mix, use SolverTable to find how much larger its unit margin would have to be before it would enter the optimal product mix.