This paper circulates around the core theme of Implement your model in a spreadsheet and solve it. What is the optimal solution? together with its essential aspects. It has been reviewed and purchased by the majority of students thus, this paper is rated 4.8 out of 5 points by the students. In addition to this, the price of this paper commences from £ 99. To get this paper written from the scratch, order this assignment now. 100% confidential, 100% plagiarism-free.
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
Chip A
Chip B
Chip C
Dept. 1
Dept. 2
Dept. 3
3
2
3
2
4
4
4
3
2
Hours
Available
10,000
9,000
11,000
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?