A D E F 1 Pizza Man pizza mix problem 2 3 Input data 4 Type Plain Meat Vegetable Supreme Available 5 Dough 5 5 5 5 200 6 Sauce 3 3 3 3 90 7 Cheese 3 3 4 120 8 Meat 0 3 0 2. 75 9 Vegetables 0 0 3 2. 40 10 Price $8.00 $10.00 $12.00 $15.00 11 12 Pizza mix plan 13 Type Plain Meat Vegetable Supreme 14 Number of pizza 15 16 Constraints 17 Used Available 18 Dough 19 Sauce 20 Cheese 21 Meat 22 Vegetables 23 24 Objective 25 Total revenue 26 27 28 29 30 31 32 33 Please insert excel formulas for each box 34 Q2. Is there any type of pizza not made in the final plan? If yes, how should its price be adjusted so that it will be made? 35 Type of Pizzas Plain Meat Vegetable Supreme 36 Produced or Not? (Y/N) 37 How to change the price 38 39 40 41 42 A D E F 1 Pizza Man pizza mix problem 2 3 Input data 4 Type Plain Meat Vegetable Supreme Available 5 Dough 5 5 5 5 200 6 Sauce 3 3 3 3 90 7 Cheese 3 3 4 120 8 Meat 0 3 0 2. 75 9 Vegetables 0 0 3 2. 40 10 Price $8.00 $10.00 $12.00 $15.00 11 12 Pizza mix plan 13 Type Plain Meat Vegetable Supreme 14 Number of pizza 15 16 Constraints 17 Used Available 18 Dough 19 Sauce 20 Cheese 21 Meat 22 Vegetables 23 24 Objective 25 Total revenue 26 27 28 29 30 31 32 33 Please insert excel formulas for each box 34 Q2. Is there any type of pizza not made in the final plan? If yes, how should its price be adjusted so that it will be made? 35 Type of Pizzas Plain Meat Vegetable Supreme 36 Produced or Not? (Y/N) 37 How to change the price 38 39 40 41 42