E4 3 In H14 enter a formula to look up the cost for the Menu code in C14 and size in E14 from the Menu table. Formula should copy down. B C D E F Cost of Ingredients for Menu Options 2 3 4 Dish Off Menu Y Y 6 Menu Code Category 7 2627 Mains 8 1151 Mains 9 1236 Mains 10 3039 Mains 11 1261 Mains 12 1003 Mains 13 3341 Mains 14 2948 Mains 15 3821 Mains 16 1316 Mains 17 3053 Mains 18 3992 Mains 19 3908 Mains 20 2864 Mains 21 3868 Mains Roast Turkey Platter Whole Turkey Roast with Stuffing Honey Maple Glazed Leg Ham Seasoned Roast Pork with Crackling Traditional Lamb Roast Fruit Cake with Frosting and Decoration Lasagna Vegetarian Gnocchi (Spinach and Ricotta) Cannelloni (Beef) Lasagna (the way that Mama makes) Tortellini a la Panna Ravioli Fresh (Spinach and Ricotta) Ravioli Fresh (Veal) Gnocchi Con Patate Spaghetti Bolognaise Siciliana Ingredient Costs Medium Large $58 $87 $83 $125 $83 $125 $63 $95 $65 $98 $50 $75 $42 $63 $40 $60 $45 $68 $52 $78 $34 $51 $34 $39 $59 $40 $60 $29 $44 $51 H49 4 x fc =TEXT(C49,"dddd") AB D E F H Catering Job Costs 5 6 Client Parmis Technologies Jol 7 Contact 8 Job Description Sales Conference 9 10 11 12 13 Size Cost/Unit 14 Medium Category Mains Mains Mains 15 16 17 18 19 Mains Mains FOOD COSTS (MATERIALS) Menu Code Quantity 3341 3 2697 1 1873 1 2267 3 1780 3 1913 3 1660 2 3523 2 2965 2 1793 3 2557 2 3776 3 Description Lasagna Vegetarian Garlic Prawns and Pasta Roast Vegetables Chicken Cacciatore Herb Crusted Leg of Lamb Roast Chicken Roll Platter Vegetable Kebabs Sushi Mini Quiches Foccacia Platter - Vegetarian Crumbed Calamari Platter Fresh Seafood Platter Mains Medium Large Medium Medium Large Large Large Large Large Large Large 20 21 22 Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods 23 24 25 E4 3 In H14 enter a formula to look up the cost for the Menu code in C14 and size in E14 from the Menu table. Formula should copy down. B C D E F Cost of Ingredients for Menu Options 2 3 4 Dish Off Menu Y Y 6 Menu Code Category 7 2627 Mains 8 1151 Mains 9 1236 Mains 10 3039 Mains 11 1261 Mains 12 1003 Mains 13 3341 Mains 14 2948 Mains 15 3821 Mains 16 1316 Mains 17 3053 Mains 18 3992 Mains 19 3908 Mains 20 2864 Mains 21 3868 Mains Roast Turkey Platter Whole Turkey Roast with Stuffing Honey Maple Glazed Leg Ham Seasoned Roast Pork with Crackling Traditional Lamb Roast Fruit Cake with Frosting and Decoration Lasagna Vegetarian Gnocchi (Spinach and Ricotta) Cannelloni (Beef) Lasagna (the way that Mama makes) Tortellini a la Panna Ravioli Fresh (Spinach and Ricotta) Ravioli Fresh (Veal) Gnocchi Con Patate Spaghetti Bolognaise Siciliana Ingredient Costs Medium Large $58 $87 $83 $125 $83 $125 $63 $95 $65 $98 $50 $75 $42 $63 $40 $60 $45 $68 $52 $78 $34 $51 $34 $39 $59 $40 $60 $29 $44 $51 H49 4 x fc =TEXT(C49,"dddd") AB D E F H Catering Job Costs 5 6 Client Parmis Technologies Jol 7 Contact 8 Job Description Sales Conference 9 10 11 12 13 Size Cost/Unit 14 Medium Category Mains Mains Mains 15 16 17 18 19 Mains Mains FOOD COSTS (MATERIALS) Menu Code Quantity 3341 3 2697 1 1873 1 2267 3 1780 3 1913 3 1660 2 3523 2 2965 2 1793 3 2557 2 3776 3 Description Lasagna Vegetarian Garlic Prawns and Pasta Roast Vegetables Chicken Cacciatore Herb Crusted Leg of Lamb Roast Chicken Roll Platter Vegetable Kebabs Sushi Mini Quiches Foccacia Platter - Vegetarian Crumbed Calamari Platter Fresh Seafood Platter Mains Medium Large Medium Medium Large Large Large Large Large Large Large 20 21 22 Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods 23 24 25
