A manufacturer produces six products from six inputs. Each product requires different combinations and amounts of inputs. The following table shows the profit and raw materials requirements for each product. The last column shows the total amounts of raw materials available
|
Products
|
1
|
2
|
3
|
4
|
5
|
6
|
TotalAmounts of Inputs
|
|
Profits Inputs Required:
Aluminum
|
60
.5
|
70
2
|
48
-
|
52
2
|
48
1
|
60
-
|
400
|
|
Steel
|
2
|
2.5
|
1.5
|
-
|
.5
|
-
|
580
|
|
Plastic
|
-
|
1.5
|
4
|
-
|
.5
|
-
|
890
|
|
Rubber
|
1
|
-
|
.5
|
1
|
.5
|
2.5
|
525
|
|
Glass
|
1
|
2
|
1.5
|
.4
|
1
|
2
|
650
|
|
Chrome
|
.5
|
2
|
.5
|
2
|
1.5
|
2
|
620
|
a. Formulate the appropriate linear program.
b. Find the company's most profitable production plan using a spreadsheet optimizer.