1. The BoilerPizza is a local shop that plans to make all of its sales this Friday from its sidewalk tables. On this occasion, the shop's owners know that customers will buy by the slice and any kind of pizza offered will sell. The BoilerPizza offers plain, meat, vegetable, and supreme pizzas. Each variety has its own requirement for sauce, cheese, dough, and toppings (in ounces, as shown in the table), and each has its own selling price.

The BoilerPizza wishes to maximize revenue from its sales.

a. Write down the model in equations. Detail the decision variables with a clear description of each one, the objective function and the constraints.

b. Use Excel Solver to solve your model. What mix of pizzas should be made? (Assume that fractions can be sold.) What is the maximum sales revenue?

c. To offer enough variety the owner decides that there should be a minimum of 5 pizzas of each type offered during that day. How does the model change now in terms of equations? Use Excel Solver to re-solve your model. What is the new mix of pizzas that should be made? (Assume that fractions can be sold.) What is the new maximum sales revenue?

Plain 5 3 3 0 Meat 5 3 Dough Sauce Cheese Meat Vegetables Price 4 Vegetable Supreme Available 5 5 200 3 3 90 3 4 110 0 3 80 3 2 40 $12 $15 3 0 0 $8 $10 E24 fx 40 A B C D E F G H Objective 1 2. 3 Revenue 4 Decision Variables 5 Plain Meat Vegetable Supreme 6 7 8 Data 9 Plain Meat Available Vegetable 5 Supreme 15 10 Dough 5 5 200 11 Sauce 3 3 3 3 90 12 Cheese 3 4 3 4 110 13 Meat o 3 0 3 80 14 0 3 2 40 Vegetables o $8 15 Price $10 $12 $15 16 17 18 Constraints 19 Required Available 20 Dough 200 21 Sauce 90 22 Cheese 110 23 Meat 80 24 Vegetables 40 2 Plain 5 3 3 0 Meat 5 3 Dough Sauce Cheese Meat Vegetables Price 4 Vegetable Supreme Available 5 5 200 3 3 90 3 4 110 0 3 80 3 2 40 $12 $15 3 0 0 $8 $10 E24 fx 40 A B C D E F G H Objective 1 2. 3 Revenue 4 Decision Variables 5 Plain Meat Vegetable Supreme 6 7 8 Data 9 Plain Meat Available Vegetable 5 Supreme 15 10 Dough 5 5 200 11 Sauce 3 3 3 3 90 12 Cheese 3 4 3 4 110 13 Meat o 3 0 3 80 14 0 3 2 40 Vegetables o $8 15 Price $10 $12 $15 16 17 18 Constraints 19 Required Available 20 Dough 200 21 Sauce 90 22 Cheese 110 23 Meat 80 24 Vegetables 40 2