Julia's Food Booth - Pizza Hot Dogs Barbecue

Case 3 - Julia's Food Booth

Food items: Pizza Hot Dogs Barbecue

Profit per item: 0.75 1.05 1.35

Constraints: Available Usage Left over

Budget ($) 0.75 0.45 0.90 1,500 1,500.00 0

Oven space (sq. in.) 24 16 25 55,296 50,000.00 5296

Demand 1 -1 -1 0 - 0

Demand 0 1 -2 0 1,250.00 -1250

Stock

Pizza= 1250 slices

Hot Dogs= 1250 hot dogs

Barbecue= 0 sandwiches

Profit= 2,250.00

Adjustable Cells

Final Reduced Objective Allowable Allowable

Cell Name Value Cost Coefficient Increase Decrease

$B$12 Pizza= 1250 0 0.75 1 1.00

$B$13 Hot Dogs= 1250 0 1.05 1E+30 0.27

$B$14 Barbecue= 0 0 1.35 0.375000011 1E+30

Constraints

Final Shadow Constraint Allowable Allowable

Cell Name Value Price R.H. Side Increase Decrease

$G$9 Demand Usage 1,250.00 - 0 1250 1E+30

$G$7 Oven space (sq. in.) Usage 50,000.00 - 55296 1E+30 5296

$G$6 Budget ($) Usage 1,500.00 1.50 1500 158.88 1500

$G$8 Demand Usage - (0.38) 0 2000 3333.33

Transpotation

Homework #6-11

Trucking Firms

Plants Kyoto Gunma Nagano Supply Shipped

Nagoya 0 0 5 5 5

Toyohashi 0 0 10 25 10

Yokohama 0 20 0 20 20

Osaka 10 0 0 25 10

Demand 10 20 15

Shipped 10 20 15