B D E H Pizza Man pizza mix problem Plain Meat Vegetable Supreme 5 S 5 Available S 200 3 3 3 Input data Type Dough Sauce Cheese Meat Vegetables Price 4 3 3 4 120 0 3 0 2 0 3 2 40 $8.00 $10.00 $12.00 $15.00 Pizza mix plan Type Number of pizza Plain Meat Vegetable Supreme Constraints Used Available Dough Sauce Cheese Meat Vepetables Objective Total revenue Meccani 23 Objective 25 Total revenue 26 27 Meat 2001. What mix of ples should be made? (Assume that tractions can be sold). What is the maximum sales revenue 30 Type of plazas Plain Vegetableeme 11 Number of Paras Maximum Sales Revue 10 34 02. Is there any type of planot made in the final plan? yes, how should its price be adjusted so that it will be made! 15 Type of Paras Pain Vente Supreme Produced or Not? (Y/N) How to chance the price Meat Sauce Cheese Meat 39 a. Which ingredients are sconomically scarce (which one limits profite? For care ingredients, if you increase their webity by 1 ounce, how will the total venue be affected? Type of ingredients Douch Veerties Scarte Ingredients Not? (V/N) How to affect total revenue 4 AS Plan Man Machines 1 Assignment of jobs to machines H Paste the used Range Names Input Data 4 Job 1 Job 2 14 Job 3 Job 4 Capacity 5 Machine 1 Machine 2 2 Machine 3 Machine 4 Machine 5 10 Required Machines 6 10 2 1 12 Network structure and flows 11 List of arcs in the network by Orgin Destination Flow balance constraints T.Nodes with only outflows on two capacity 16 16 17 2.Nodes with only towanows > Oman 24 Nos with both outdows and into total outflowstofows) hitta Mon Machine Assignment Home Page Layout Formula Data Review View Help AM General -11 - A == 18 wap test BT-A Feel te 2 AMA format $ % 9. con fot og testes D E F H 1 Flow balance constraints 19 Required Machines 11 T2 Network structure and flows 13 List of arts in the network by (Origin Destination) 14 15 1.Nodes with only outflow (total outflows capacity 16 18 19 20 21 3 Nodes with only innows totais > Comand) 25 26 27 28 3.Nodes with both outflows and Infowe (total outflows to now 16 Objective to minimize 30 Fra Mart Machine Assignment Product Mix Problem 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 3 3 3 75 Vegetables 2 Pizza Pnce $8.00 $10.00 $12.00 $15.00 5 5 5 3 Sauce Cheese Meat 5 3 3 O 3 200 90 120 3 4 0 O 2 0 40 The Pizza Man experts to use its entire stock of ingredients and wishes to maximize revenue from its sales Requirements 1. Download the Excel template file, and set up the model based on it. Answer all the questions listed in the file. 2. Please define the appropriate range names to make the Solver configuration more readable. Paste the used range names 3. Run the sensitivity analysis using Solver 4. Answer all the questions listed in the file. Job Assignment Problem There are 5 machines to be assigned to 4 jobs in order to minimize the total time to complete all the jobs Time to perform different jobs on various machines are below Job 1 Job 2 Job 3 Job 4 Capacity Machine 1 14 5 8 7 1 Machine 2 2 12 6 5 2 Machine 3 7 3 9 1 Machine 4 2 4 6 10 2 Machine 5 5 5 4 8 1 Each job requires only 1 machine to be assigned Requirements 1. Use networking logic to build the model in spreadsheet and figure out the best machine assignment plan. 2. Appropriately define the range names to make sure the model readable. Paste the used range names B D E H Pizza Man pizza mix problem Plain Meat Vegetable Supreme 5 S 5 Available S 200 3 3 3 Input data Type Dough Sauce Cheese Meat Vegetables Price 4 3 3 4 120 0 3 0 2 0 3 2 40 $8.00 $10.00 $12.00 $15.00 Pizza mix plan Type Number of pizza Plain Meat Vegetable Supreme Constraints Used Available Dough Sauce Cheese Meat Vepetables Objective Total revenue Meccani 23 Objective 25 Total revenue 26 27 Meat 2001. What mix of ples should be made? (Assume that tractions can be sold). What is the maximum sales revenue 30 Type of plazas Plain Vegetableeme 11 Number of Paras Maximum Sales Revue 10 34 02. Is there any type of planot made in the final plan? yes, how should its price be adjusted so that it will be made! 15 Type of Paras Pain Vente Supreme Produced or Not? (Y/N) How to chance the price Meat Sauce Cheese Meat 39 a. Which ingredients are sconomically scarce (which one limits profite? For care ingredients, if you increase their webity by 1 ounce, how will the total venue be affected? Type of ingredients Douch Veerties Scarte Ingredients Not? (V/N) How to affect total revenue 4 AS Plan Man Machines 1 Assignment of jobs to machines H Paste the used Range Names Input Data 4 Job 1 Job 2 14 Job 3 Job 4 Capacity 5 Machine 1 Machine 2 2 Machine 3 Machine 4 Machine 5 10 Required Machines 6 10 2 1 12 Network structure and flows 11 List of arcs in the network by Orgin Destination Flow balance constraints T.Nodes with only outflows on two capacity 16 16 17 2.Nodes with only towanows > Oman 24 Nos with both outdows and into total outflowstofows) hitta Mon Machine Assignment Home Page Layout Formula Data Review View Help AM General -11 - A == 18 wap test BT-A Feel te 2 AMA format $ % 9. con fot og testes D E F H 1 Flow balance constraints 19 Required Machines 11 T2 Network structure and flows 13 List of arts in the network by (Origin Destination) 14 15 1.Nodes with only outflow (total outflows capacity 16 18 19 20 21 3 Nodes with only innows totais > Comand) 25 26 27 28 3.Nodes with both outflows and Infowe (total outflows to now 16 Objective to minimize 30 Fra Mart Machine Assignment Product Mix Problem 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 3 3 3 75 Vegetables 2 Pizza Pnce $8.00 $10.00 $12.00 $15.00 5 5 5 3 Sauce Cheese Meat 5 3 3 O 3 200 90 120 3 4 0 O 2 0 40 The Pizza Man experts to use its entire stock of ingredients and wishes to maximize revenue from its sales Requirements 1. Download the Excel template file, and set up the model based on it. Answer all the questions listed in the file. 2. Please define the appropriate range names to make the Solver configuration more readable. Paste the used range names 3. Run the sensitivity analysis using Solver 4. Answer all the questions listed in the file. Job Assignment Problem There are 5 machines to be assigned to 4 jobs in order to minimize the total time to complete all the jobs Time to perform different jobs on various machines are below Job 1 Job 2 Job 3 Job 4 Capacity Machine 1 14 5 8 7 1 Machine 2 2 12 6 5 2 Machine 3 7 3 9 1 Machine 4 2 4 6 10 2 Machine 5 5 5 4 8 1 Each job requires only 1 machine to be assigned Requirements 1. Use networking logic to build the model in spreadsheet and figure out the best machine assignment plan. 2. Appropriately define the range names to make sure the model readable. Paste the used range names