Develop problem using Excel:
The Waikiki Enterprise Corporation produces two types of computers at its manufacturing plant in Torrance, California. Profit on computer A is $900 per unit and for B it is $600. The manufacturing plant can produce not more than 50 of computer A and 100 of computer B a day. The following table displays the capacity for the manufacturing plant.
PLANT CAPACITY OF COMPUTER A CAPACITY OF COMPUTER B MAXIMUM AVAILABLE CAPACITY
A Riverview Plant 51 101 18000
Unit Profit $900 $600
A. What are the decision variables?
B. What is the objective function?
C. What are the constraints?
D. What are the non-negativity assumptions?
This posting contains solution to following linear programming problem