The PENTEL Corporation manufactures three different types of computer chips. Each
type of chip requires different amounts of processing time in three different departments
as summarized in the following table.
Processing Hours Required per 100 chips
The total profit for each type of chip may be described as follows:
Chip A profit = -0.35A2 + 8.3A + 540
Chip B profit = -0.60B2 + 9.45B + 1108
Chip C profit = -0.47C2 + 11.0C + 850
Where A, B, and C represent the number of chips produced in 100s.
* Formulate an Nonlinear Programming model for this problem.
* Implement your model in a spreadsheet and solve it.
* What is the optimal solution?