Problem: 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
1) What are the decision variables?
2) What is the objective function?
3) What are the constraints?
4) What are the non-negativity assumptions?