Business Analysis -Linear Programming

2. Hong Kong Farm, a land and farming company, plans to grow two types of vegetables: tomato and green pepper. The company wants to maximize its net profit (i.e., gross revenue minus operating cost) subject to budget, time (in man days) and land constraints. The expected gross revenue, operating cost, time and land requirements for each unit of tomato and pepper are:

Vegetables Gross Revenue Operating Cost Time (man days) Land Requirement Tomato $800 $500 12 1 Pepper $600 $250 24 1Objective Function Value Tomato Green PepperVariable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$5 Tomato (T) A 0 300 400 125 $C$6 Pepper (P) B 0 350 250 200 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $D$11 Total Cost C 0.33 15000 3750 3000 $E$11 Total Time D 11.11 720 180 144 $F$11 Total Land E 0 45 1E+30 5 Tomato at least half $C$16 green pepper F 0 0 10 1E+30 Tomato at most twice $C$17 green pepper G 0 0 1E+30 20