8 Section D The following are to be completed in the Menu Worksheet This sheet contains Menu options with associated costs. D1 In cell 112 use a formula to calculate the highest price in D7:E113. 1 D2 1 D3 In cell 113 use a formula to calculate the lowest price in D7:E113. In 17 create a calculation to work out how many Mains dishes are available (Category is Mains and Off Menu is not set to Y). Copy down to 110. In 37 create a calculation to work out the average cost of Medium size Mains dishes. Use appropriate referencing so that the formula can be dragged down and across. (1 mark for correct referencing.) 3 3 D4 B D E F H L 2 Cost of Ingredients for Menu Options 3 4 Dishes Available Category Mains Average Price Medium Average Price Large Finger Foods Salads Desserts Highest Price Lowest Price 5 6 Menu Co 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 22 3295 Mains 23 2697 24 1189 Mains 25 2346 Mains 26 1770 Mains 27 3924 Mains 28 1873 Mains 29 2267 Mains 30 2430 Mains 31 2792 Mains 32 1780 Mains 33 1913 Mains Dish 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 Decor 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 Marinara Garlic Prawns and Pasta Cannelloni Spinach & Ricotta) Eggplant Parmigiana Pineapple Glazed Ham Italian Pot Roast Roast Vegetables Chicken Cacciatore Chicken Stroganoff BBQ Chicken Platter Herb Crusted Leg of Lamb Roast Chicken Roll Platter Ingredient Costs Medium Large - Off Meni 158 387 Y 178 $117 Y 193 1140 153 180 170 $105 $55 183 052 178 140 160 145 168 42 163 $39 159 139 159 139 $59 145 168 129 144 146 169 63 195 145 168 145 168 193 1140 173 1110 140 160 145 168 138 157 042 163 75 0113 147 171 Mains F G H E $54 63 356 180 157 D $36 42 137 $53 138 $40 $35 139 140 $35 141 $37 137 127 34 3750 35 1660 36 3483 37 3781 38 3523 39 1467 40 1831 41 1185 42 2965 43 3413 44 2150 45 1793 46 3203 47 3726 48 2379 49 3414 50 1042 51 2557 52 3776 53 2841 54 3388 55 3587 56 2135 57 2154 58 3693 59 1702 60 2072 61 3923 62 1575 63 2518 64 2388 65 2190 66 3643 67 3244 68 1601 B Mains Chicken Platter Trio Finger Foods Vegetable Kebabs Finger Foods Curry Puffs Finger Foods Fish, Prawns and Calamari Platter Finger Foods Sushi Finger Foods Arancini Platter - Baby Size Finger Foods Arancini Platter - Baby Size Vegetari Finger Foods Vegetarian Platter Cooked Finger Foods Mini Quiches Finger Foods Mini Vegetarian Pies Finger Foods Ribbon Sandwiches - Vegetarian Finger Foods Foccacia Platter - Vegetarian Finger Foods Meatball Platter - Italian Style Finger Foods Pizza Platter Vegetarian) Finger Foods Pizza Platter Finger Foods Cudet pieces and Arancini Platter Finger Foods Foccacia Platter Finger Foods Crumbed Calamari Platter Finger Foods Fresh Seafood Platter Finger Foods Antipasto (Mixed Meat, Cheese and Finger Foods Cutlets Finger Foods Cooked Prawn Platter Finger Foods Lemon Chicken Fingers Platter Finger Foods Prosciutto Ham with Melon Finger Foods Vegetarian Platter Finger Foods Hors d'oeuvres Finger Foods Ribbon Sandwiches Finger Foods Mini Spring Rolls Finger Foods Mini Samosas Finger Foods Cheesy Tomato Basil Mussels Finger Foods Scallop and Bacon Bites Finger Foods Coconut Prawns with Mango Sauce Finger Foods Smoked Salmon and Camembert Pu Finger Foods Lemon Ginger Prawns Finger Foods Baked Oysters with Garlic Herb But 060 153 159 160 $53 162 $56 $56 141 141 $71 148 160 127 $47 132 140 148 145 143 $72 $68 165 147 144 171 166 157 157 138 $38 132 141 038 135 146 155 $58 $40 $55 $50 148 162 157 153 169 183 Y 187 160 183 175 C E F G H K D 032 136 132 137 165 $32 142 134 134 145 124 125 131 B Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Salads Salads Salads Salads Salads Salads Salads Salads Salads Salads Salads Salads Salads 69 1532 70 2800 71 2992 72 2909 73 3906 74 1216 75 3791 76 1449 77 1181 78 3595 79 3092 80 2960 81 3262 82 1539 83 3826 84 3436 85 3412 86 2746 87 1540 88 2750 89 3810 90 1043 91 3721 92 1545 93 2649 94 2068 148 $54 148 056 198 148 163 151 051 168 136 038 147 030 148 144 147 Chicken Drummettes Chicken Cheese Patties Glazed Chicken Bites Mini Size Maxi Taste Sausage Rolls Steamed Chilli Prawns Spinach & Ricotta Puffs Party Platter Chicken Yakitori Cheese & Herb Potato Croquettes Chicken Cutlets Spicy Egg 'n Bacon Salad Platter Julienne Vegetable Salad Bocconcini Tomato Skewers Tuna Salad Festive Chicken Salad Garden Green Salad Cubed Potato with Sour Cream Italian Rice Salad Tangy Coleslaw Club Salad Greek Salad Waldorf Salad Caesar Salad Variation Pecan and Avocado Salad Seasonal Salad Fresh Fruit and Cheese Platter Peach and Raspberry Tea Cake Custard Cakes - Chocolate Sicilian C Custard Cakes - Vanilla Sicilian Cani Orange & Almond Gluten Free) Friands (Gluten Free) Black Forest Cake Italian Fruit Torte Tiramisu Papered Cup Cakes (Petite) 120 132 129 $31 120 129 19 120 Salads 129 129 119 129 132 127 $30 044 129 030 144 144 129 144 148 141 $42 033 141 121 $33 148 $56 189 95 3836 Y Salads Desserts Desserts Desserts Desserts Desserts Desserts Desserts Desserts Desserts Desserts 96 1172 97 2786 98 2728 99 1089 100 1655 101 2874 102 1721 103 3681 028 122 127 Y $14 122 132 137 159 104 3116 105 2393 106 2471 107 2441 108 3361 109 2570 110 1220 111 2884 112 2047 113 1667 Desserts Desserts Desserts Desserts Desserts Desserts Desserts Desserts Desserts Desserts Bacci Bomb Cookies and Cream Cake Apple, Rhubarb and Raspberry Tart Salted Caramel Nut Tart Lemon and Lime Tart Apple Pie Lemon Meringue Pic Danish Pastry Platter Raspberry-dusted Chocolate Fudge? Home-Made Biscuits 138 $24 131 127 137 137 127 $31 145 50 $57 136 147 141 $56 156 $41 147 168 175 114