This Pizza Man is a local shop that plans to make all of its sales this Saturday from its sidewalk tables during the town's holiday parade. On this occasion, the shop's owners know that customers will buy by the slice and any kind of pizza offered will sell. The Pizza Man offers plain, meat, vegetable, and supreme pizza. Each variety has its own requirement for sauce, cheese, dough, and toppings (in ounces), and each has its own selling price. Plain Meat Vegetable Supreme Ingredients Available Dough 55 55 200 Sauce 3 3 3 3 90 Cheese 4 120 Meat 10 30 75 Vegetables0 40 Pizza Price $8.00 $10.00 $12.00 $15.00 The Pizza Man experts to use its entire stock of ingredients and wishes to maximize revenue from its sales. Questions: 1. What mix of pizzas should be made? (Assume that fractions can be sold). What is the maximum sales revenue? 2. 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? 3. Which ingredients are economically scarce (which ones limits profits)? For scarce ingredients, if you increase their availability by 1 ounce, how will the total revenue be affected? SOM 4317 Problem Set 03 - Excel DATA REVIEW VIEW General Normal La Copy FILE HOME INSERT PAGE LAYOUT FORMULAS * Cut Calibri - 11 FAA Paste - Format Painter BIU-BOA. Clipboard G26 Wrap Text Merge Center . . $. % Conditional Format as Good Formatting Table Neutral Alignment Vegetable Supreme Available 3 Input data 4 Type 5 Dough 6 Sauce 7 Cheese 8 Meat 9 Vegetables 10 Price $8.00 $10.00 $12.00 $15.00 12 Pleza mix plan 13 Type 14 Number of pizza Plain Meat 0 Vegetable 100 Supreme 20 Available 15 Constraints 17 18 Dough 19 Sauce 20 Cheese 21 Meat 22 Vegetables AAAAA Used Range Names Available_Capacity Pizza Man'$D$18.$D$22 Consumer Capacity - Pizza Man'$B$18:$B$22 Number_of_pizza Pizza Man'$B$14:$E$14 Total Revenue - Pizza Man'$B$25 24 Objective 25 Total revenue $ 400.00 Selvity Report 1 Parra Man Type here to search Desktop - On This Pizza Man is a local shop that plans to make all of its sales this Saturday from its sidewalk tables during the town's holiday parade. On this occasion, the shop's owners know that customers will buy by the slice and any kind of pizza offered will sell. The Pizza Man offers plain, meat, vegetable, and supreme pizza. Each variety has its own requirement for sauce, cheese, dough, and toppings (in ounces), and each has its own selling price. Plain Meat Vegetable Supreme Ingredients Available Dough 55 55 200 Sauce 3 3 3 3 90 Cheese 4 120 Meat 10 30 75 Vegetables0 40 Pizza Price $8.00 $10.00 $12.00 $15.00 The Pizza Man experts to use its entire stock of ingredients and wishes to maximize revenue from its sales. Questions: 1. What mix of pizzas should be made? (Assume that fractions can be sold). What is the maximum sales revenue? 2. 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? 3. Which ingredients are economically scarce (which ones limits profits)? For scarce ingredients, if you increase their availability by 1 ounce, how will the total revenue be affected? SOM 4317 Problem Set 03 - Excel DATA REVIEW VIEW General Normal La Copy FILE HOME INSERT PAGE LAYOUT FORMULAS * Cut Calibri - 11 FAA Paste - Format Painter BIU-BOA. Clipboard G26 Wrap Text Merge Center . . $. % Conditional Format as Good Formatting Table Neutral Alignment Vegetable Supreme Available 3 Input data 4 Type 5 Dough 6 Sauce 7 Cheese 8 Meat 9 Vegetables 10 Price $8.00 $10.00 $12.00 $15.00 12 Pleza mix plan 13 Type 14 Number of pizza Plain Meat 0 Vegetable 100 Supreme 20 Available 15 Constraints 17 18 Dough 19 Sauce 20 Cheese 21 Meat 22 Vegetables AAAAA Used Range Names Available_Capacity Pizza Man'$D$18.$D$22 Consumer Capacity - Pizza Man'$B$18:$B$22 Number_of_pizza Pizza Man'$B$14:$E$14 Total Revenue - Pizza Man'$B$25 24 Objective 25 Total revenue $ 400.00 Selvity Report 1 Parra Man Type here to search Desktop - On
