Implement your model in a spreadsheet and solve it.  What is the optimal solution?

Implement your model in a spreadsheet and solve it. What is the optimal solution?

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?


Price: £ 45

100% Plagiarism Free & Custom Written, Tailored to your instructions

Leave your Comments


Can't read the image? click here to refresh