Pizza Cost worksheet This spreadsheet is for calculating profit on a pizza. Use the information on the right to complete the missing information with appropriate functions and/or formulas. Use VLOOKUP when working on this assignment. a) Chorizo Cost per unit: The current costs for Chorizo are hard coded to $1.50 in cell D20 and highlighted in yellow. The amount of Chorizo ordered for the current month is the prior month chorizo pizza multiplied by the quantity in C20. In cell D20, please use Vlookup on the chorizo order to determine the cost/oz. b) Create pie chart Create a ple chart titled COST DISTRIBUTION which shows the Primary ingredients, secondary ingredients, and utility and prep cost as part of the pie chart. See this example on how it should look like. COST DISTRIBUTION PRIMARY INCLIENTS SECONDARY INGREDIENTS UTILITY AND PREP COST IAN GIN c) Set up a table to do VLOOKUP: Similar to the Chorizo order table, create a table for Dough cost lookup. 1-9,999 oz, the dough is .07 Anything greater than 9,999 oz and the pizza dough is cost.05 Update cell D1 to do the Vlookup on pizza dough. B E F H DATE 11/19/2021 Chor 6 7 DISH NAME Chorizo Pizza 8 EST. SALE PRICE $ 27.35 10 TOTAL COST $ 21.37 COST MARGIN 11 12 13 14 15 16 78.14 NET PROFIT 5.98 18 19 20 121 22 23 PRIMARY INGREDIENTS Product Name Qty (oz) Chorizo 8 Dough 16 Cost Total Cost (per unit) 1.50 $ 12.00 007S 1.12 $ $ 13.12 TOTAL 2800.00 SECONDARY INGREDIENTS 26 Product Name Qty Cost 27 Total Cost O 1/O 28 Mozerrella cheese 16 $ 0.265 4.16 29 Marina Sauce $ 0.12 $ 0.96 Recipe 30 Peppers $ 0.10 $ 0.80 31 $ 32 $ 33 s 34 $ 35 $ 36 $ 37 $ 38 TOTAL $ 5.92 40 UTILITY AND PREP. COST 41 Name Total Cost 42 Preparation $ 43 200 Gas $ 44 Electricity 0.12 5 Water 0.11 5 010 S&P 500 Pizza Cost Population Ready B D Qty. (oz) 19 20 Product Name Chorizo Dough 8 16 Cost Total Cost (per unit) $ 1.50 $ 12.00 $ 0.07 $ 1.12 S $ 13.12 22 23 TOTAL 25 26 27 SECONDARY INGREDIENTS Product Name Qty Oz Mozerrella cheese 16 Marina Sauce Peppers A A $ $ 00 30 ADA WEB ENGINN Cost Total Cost $/Oz 0.26 $ 4.16 0.12 $ 0.96 Recipe 0.10 $ 0.80 $ $ $ $ $ $ $ $ 5.92 34 35 36 37 CATA A 38 TOTAL 40 42 UTILITY AND PREP. COST Name Preparation Gas Electricity Water TOTAL 44 45 Total Cost 5 2.00 $ 0.12 S 0.11 $ 0.10 $ 2.33 ALLERGIES 49 50 51 52 53 55 Prepared By Approved By Occupation Occupation 52 90 59 60 61 62 63 Chorizo Cost Prior Month Pizza volume Chorizo Pizza Pies 2500 Oz ordered Oz ordered 15 150 1000 130 5000 5 105 100005 0.80 15000 5 0.70 25000 5 0:55 Oz ordered Oz ordered Dough Cost Pizza Cost worksheet This spreadsheet is for calculating profit on a pizza. Use the information on the right to complete the missing information with appropriate functions and/or formulas. Use VLOOKUP when working on this assignment. a) Chorizo Cost per unit: The current costs for Chorizo are hard coded to $1.50 in cell D20 and highlighted in yellow. The amount of Chorizo ordered for the current month is the prior month chorizo pizza multiplied by the quantity in C20. In cell D20, please use Vlookup on the chorizo order to determine the cost/oz. b) Create pie chart Create a ple chart titled COST DISTRIBUTION which shows the Primary ingredients, secondary ingredients, and utility and prep cost as part of the pie chart. See this example on how it should look like. COST DISTRIBUTION PRIMARY INCLIENTS SECONDARY INGREDIENTS UTILITY AND PREP COST IAN GIN c) Set up a table to do VLOOKUP: Similar to the Chorizo order table, create a table for Dough cost lookup. 1-9,999 oz, the dough is .07 Anything greater than 9,999 oz and the pizza dough is cost.05 Update cell D1 to do the Vlookup on pizza dough. B E F H DATE 11/19/2021 Chor 6 7 DISH NAME Chorizo Pizza 8 EST. SALE PRICE $ 27.35 10 TOTAL COST $ 21.37 COST MARGIN 11 12 13 14 15 16 78.14 NET PROFIT 5.98 18 19 20 121 22 23 PRIMARY INGREDIENTS Product Name Qty (oz) Chorizo 8 Dough 16 Cost Total Cost (per unit) 1.50 $ 12.00 007S 1.12 $ $ 13.12 TOTAL 2800.00 SECONDARY INGREDIENTS 26 Product Name Qty Cost 27 Total Cost O 1/O 28 Mozerrella cheese 16 $ 0.265 4.16 29 Marina Sauce $ 0.12 $ 0.96 Recipe 30 Peppers $ 0.10 $ 0.80 31 $ 32 $ 33 s 34 $ 35 $ 36 $ 37 $ 38 TOTAL $ 5.92 40 UTILITY AND PREP. COST 41 Name Total Cost 42 Preparation $ 43 200 Gas $ 44 Electricity 0.12 5 Water 0.11 5 010 S&P 500 Pizza Cost Population Ready B D Qty. (oz) 19 20 Product Name Chorizo Dough 8 16 Cost Total Cost (per unit) $ 1.50 $ 12.00 $ 0.07 $ 1.12 S $ 13.12 22 23 TOTAL 25 26 27 SECONDARY INGREDIENTS Product Name Qty Oz Mozerrella cheese 16 Marina Sauce Peppers A A $ $ 00 30 ADA WEB ENGINN Cost Total Cost $/Oz 0.26 $ 4.16 0.12 $ 0.96 Recipe 0.10 $ 0.80 $ $ $ $ $ $ $ $ 5.92 34 35 36 37 CATA A 38 TOTAL 40 42 UTILITY AND PREP. COST Name Preparation Gas Electricity Water TOTAL 44 45 Total Cost 5 2.00 $ 0.12 S 0.11 $ 0.10 $ 2.33 ALLERGIES 49 50 51 52 53 55 Prepared By Approved By Occupation Occupation 52 90 59 60 61 62 63 Chorizo Cost Prior Month Pizza volume Chorizo Pizza Pies 2500 Oz ordered Oz ordered 15 150 1000 130 5000 5 105 100005 0.80 15000 5 0.70 25000 5 0:55 Oz ordered Oz ordered Dough Cost
