| | CASE PROBLEM - "JULIA'S FOOD BOOTH | | | | | SEE PAGES 108 AND 109 FOR DETAILS |
| | | COST OF BOOTH - $1,000 PER GAME |
| | | LEASE OF A WARMING OVEN - $600 PER 6 GAME SEASON |
| | | VENDORS CAN SELL FOOD OR DRINK, BUT NOT BOTH. |
| | | PIZZA, HOT DOGS, BARBECUE SANDWICHES WILL BE SOLD. |
| | | OVEN HAS 16 SHELVES (36 BY 48 INCHES) = (16*36*48 )* 2 = | | | | | | 55296 |
| | | FILLS OVEN BEFORE GAME AND BEFORE HALF TIME. |
| | | PIZZA DELIVERY COMPANY WILL DELIVER PIZZAS |
| | | | BEFORE GAME AND AFTER KICKOFF. |
| | | | | | | SALES | | SPACE |
| | | | | | COST | PRICE | PROFIT | REQUIREMENT |
| | | PIZZA | [6 / 8] per slice | | 0.75 | 1.50 | 0.75 | 24.5 SQUARE INCHES** |
| | | HOT DOGS | | | 0.45 | 1.50 | 1.05 | 16 SQUARE INCHES |
| | | BARBECUE SANDWICH | | | 0.90 | 2.25 | 1.35 | 25 SQUARE INCHES |
| | | INITIAL CASH AVAILABLE - $1,500 | | | | | | **COMPUTATION OF PIZZA SLICE SQ. IN. |
| | | SALES ESTIMATES | | | | | | 14 INCH SQUARE PIZZA: |
| | | 1 | PIZZAS >= HOT DOGS + BARBECUE SANDWICHES | | | | | AREA = 14 * 14 = 196 / 8 = | | | 24.5 |
| | | 2 | HOT DOGS >= 2 * BARBECUE SANDWICHES |
| | | GOAL: AT LEAST $1,000 PROFIT PER GAME |
| | | | OBJECTIVE FUNCTION: 3 PRODUCTS WITH PROFITS ABOVE |
| | | | CONSTRAINTS: |
| | | | 1) AVAILABLE MONEY = 1500 |
| | | | 2) OVEN SPACE = 55296 | | | | | | X1 >= X2 + X3 |
| | | | 3) SALES ESTIMATE 1 - ABOVE | | | | | | X1 - X2 - X3 >= 0 |
| | | | 4) SALES ESTIMATE 2 - ABOVE |
| | | | | | | | | | X2 >= 2 * X3 |
| | | CALCULATION OF PROFIT PER GAME: | | | | | | | X2 - 2*X3 >= 0 |
| | | | OPTIMAL PROFIT FROM LINEAR PROGRAMMING SOLUTION |
| | | | LESS: COST OF BOOTH PER GAME |
| | | | LESS: COST OF WARMING OVEN PER GAME |
khadija0205
JuliasFoodBooth.xlsx
