Answered step by step
Verified Expert Solution
Question
1 Approved Answer
E G H Cost of Ingredients for Menu Options Dish Large - Dishes Available Average Price Medium Off Menu Y Average Price Large Y Category
E G H Cost of Ingredients for Menu Options Dish Large - Dishes Available Average Price Medium Off Menu Y Average Price Large Y Category Mains Finger Foods Salads Desserts Highest Price Lowest Price Y Menu Code Category 2627 Mains 1151 Mains 1236 Mains 3039 Mains 1261 Mains 1003 Mains 3341 Mains 2948 Mains 3821 Main 1316 Mains 3053 Mains 3992 Mains 390B Mains 2864 Mains 3868 Mains 3295 Mains 2697 Mains 1189 Mains 2346 Mains 1770 Mains 3924 Mains 1873 Mains 2267 Main 2430 Mains 2792 Mains 1780 Mains 1913 Mains 3750 Mains 1660 Finger Foods 3483 Finger Foods 3781 Finger Foods 3523 Finger Foods 1467 Finger Foods 1831 Finger Foods 1185 Finger Foods 2965 Finger Foods 3413 Finger Foods 2150 Finger Foods 1793 Finger Foods 3203 Finger Foods 3726 Finger Foods 2379 Finger Foods 3414 Finger Foods 1042 Finger Foods 2557 Finger Foods 3776 Finger Foods 2841 Finger Foods 3388 Finger Foods 3587 Finger Foods 2135 Finger Foods 2154 Finger Foods 3693 Finger Foods 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 ala 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 Chicken Platter Trio Vegetable Kebabs Curry Puffs Fish, Prawns and Calamari Platter Sushi Arancini Pletter - Baby Size Arancini Platter - Baby Size Vegetarian Vegetarian Platter Cooked Mini Quiches Mini Vegetarian Pies Ribbon Sandwiches - Vegetarian Foccacia Platter - Vegetarian Meatball Platter - Italian Style Pizza Platter (Vegetarian) Pizza Platter Cutlet pieces and Arancini Platter Foccacia Platter Crumbed Calamari Platter Fresh Seafood Platter Antipasto (Mixed Meat, Cheese and Olive Cutlets Cooked Prawn Platter Lemon Chicken Fingers Platter Prosciutto Ham with Melon Vegetarian Platter Ingredient Costs Medium $53 $80 $88 $132 $83 $125 $58 $87 $65 $98 $60 $90 $52 $78 $40 $60 $45 $68 $47 $71 $34 $51 $39 $59 $34 $51 $35 $53 $29 $44 $69 $63 $95 $35 $53 $35 $53 $93 $140 $68 $102 $35 $53 $40 $60 $48 $72 $71 $70 $105 $37 $56 $36 $54 $32 $48 $37 $56 $53 $80 $43 $65 $35 $53 $40 $60 $34 $51 $35 $53 $40 $60 $31 $47 $37 $56 $37 $56 $32 $48 $37 $56 $37 $56 $42 $63 $35 $53 $53 $80 $40 $60 $43 $65 $57 $86 $39 $59 $28 $42 $28 $42 F G H J 56 2135 57 2154 58 3693 D $39 $28 SZO $28 $ $27 $36 $36 e $38 Y 59 1702 Mini Spring Rolls $35 $41 $55 $58 $40 Y E $59 $42 $42 $41 $54 $57 $53 $ $62 to $83 to $87 $60 $90 $83 $56 $54 $48 $56 $98 $63 $48 $59 $59 $53 $29 $38 $54 59 60 2072 60 2072 61 3923 62 1575 63 2518 ago 64 2388 65 2190 66 3643 67 3244 68 1601 . 69 1532 *** 70 2800 71 2992 72 2909 73 3906 74 1216 75 3791 76 1449 77 1181 78 3595 79 3092 80 2960 -700 81 3262 82 1539 83 3826 84 3436 85 3412 86 2746 87 1540 88 2750 - 89 3810 90 1043 91 3721 22 1340 92 1545 93 2649 son 94 2068 95 3836 2000 96 1172 97 2786 98 2728 00 1089 99 1089 100 1655 10LEE 102 101 2874 102 1721 wo 103 3681 1042116 104 3116 er 105 2393 . 106 2471 107 2441 108 3361 109 2570 110 1220 111 2884 112 2047 113 1667 114 B Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods El Food Finger Foods Finger Foods Finger Foods . . Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods ange Finger Foods Salads Salads was Salads Salads Salads Salads Salads Salads wake Salads Salads Salads Salads Salads wake Salads w Salads wa Desserts Desserts Desserts Desserts D. Desserts Desserts Desserts . Desserts . Desserts Desserts Desserts Desserts Desserts Desserts Desserts Desserts Desserts Desserts Desserts Desserts C Lemon Chicken Fingers Platter Prosciutto Ham with Melon Vegetarian Platter Hors d'oeuvres Ribbon Sandwiches Mini Mini Mini Samosas Cheesy Tomato Basil Mussels Scallop and Bacon Bites Coconut Prawns with Mango Sauce Smoked Salmon and Camembert Puffs Lemon Ginger Prawns Baked Oysters with Garlic Herb Butter Chicken Drummettes Chicken Cheese Patties Glazed Chicken Bites Mini Size Maxi Taste Sausage Rolls ..... Steamed Chilli Prawns Spinach & Ricotta Pufts 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 cance Tangy Coleslaw Club Salad Greek Salad Waldorf Salad Caesar Salad Variation san Pecan and Avocado Salad Seasonal Salad Fresh Fruit and Cheese Platter Peach and Raspberry Tea Cake Custard Cakes - Chocolate Sicilian Canno Custard Cakes - Vanilla Sicilian Cannoli Orange & Almond (Gluten Free) Friends (Gluten Free) Black Forest Cake Italian Fruit Torte T. Tiramisu Papered Cup Cakes (Petite) Bacci Bomb Cookies and Cream Cake Apple, Rhubarb and Raspberry Tart Salted Caramel Nut Tart Lemon and Lime Tart Apple Pie Lemon Meringue Pie Danish Pastry Platter Raspberry-dusted Chocolate Fudge Truffe Home-Made Biscuits $60 $55 $37 $36 $32 $37 $65 $42 $32 $39 $39 $35 $19 $25 $36 $20 $32 $24 $21 $20 $29 $24 $25 $19 $29 $29 $19 $30 $48 $36 $32 $30 $44 $36 $38 $29 Y $44 $29 $42 $63 Y Y Y $32 932 $28 420 $27 $32 $22 $19 en $27 $37 $27 eco $59 $43 $29 Y Y $48 $ $42 $41 $48 $29 $41 tec $56 $ $41 $89 ter $65 $44 $47 $41 $48 $41 $41 $54 $68 $75 $31 $27 $32 $27 $27 $36 $45 $50 Section D 8 The following are to be completed in the Menu Worksheet This sheet contains Menu options with associated costs. In cell 112 use a formula to calculate the highest price in D7:E113. D1 1 D2 In cell 113 use a formula to calculate the lowest price in D7:E113. 1 D3 3 D4 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 J7 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 E G H Cost of Ingredients for Menu Options Dish Large - Dishes Available Average Price Medium Off Menu Y Average Price Large Y Category Mains Finger Foods Salads Desserts Highest Price Lowest Price Y Menu Code Category 2627 Mains 1151 Mains 1236 Mains 3039 Mains 1261 Mains 1003 Mains 3341 Mains 2948 Mains 3821 Main 1316 Mains 3053 Mains 3992 Mains 390B Mains 2864 Mains 3868 Mains 3295 Mains 2697 Mains 1189 Mains 2346 Mains 1770 Mains 3924 Mains 1873 Mains 2267 Main 2430 Mains 2792 Mains 1780 Mains 1913 Mains 3750 Mains 1660 Finger Foods 3483 Finger Foods 3781 Finger Foods 3523 Finger Foods 1467 Finger Foods 1831 Finger Foods 1185 Finger Foods 2965 Finger Foods 3413 Finger Foods 2150 Finger Foods 1793 Finger Foods 3203 Finger Foods 3726 Finger Foods 2379 Finger Foods 3414 Finger Foods 1042 Finger Foods 2557 Finger Foods 3776 Finger Foods 2841 Finger Foods 3388 Finger Foods 3587 Finger Foods 2135 Finger Foods 2154 Finger Foods 3693 Finger Foods 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 ala 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 Chicken Platter Trio Vegetable Kebabs Curry Puffs Fish, Prawns and Calamari Platter Sushi Arancini Pletter - Baby Size Arancini Platter - Baby Size Vegetarian Vegetarian Platter Cooked Mini Quiches Mini Vegetarian Pies Ribbon Sandwiches - Vegetarian Foccacia Platter - Vegetarian Meatball Platter - Italian Style Pizza Platter (Vegetarian) Pizza Platter Cutlet pieces and Arancini Platter Foccacia Platter Crumbed Calamari Platter Fresh Seafood Platter Antipasto (Mixed Meat, Cheese and Olive Cutlets Cooked Prawn Platter Lemon Chicken Fingers Platter Prosciutto Ham with Melon Vegetarian Platter Ingredient Costs Medium $53 $80 $88 $132 $83 $125 $58 $87 $65 $98 $60 $90 $52 $78 $40 $60 $45 $68 $47 $71 $34 $51 $39 $59 $34 $51 $35 $53 $29 $44 $69 $63 $95 $35 $53 $35 $53 $93 $140 $68 $102 $35 $53 $40 $60 $48 $72 $71 $70 $105 $37 $56 $36 $54 $32 $48 $37 $56 $53 $80 $43 $65 $35 $53 $40 $60 $34 $51 $35 $53 $40 $60 $31 $47 $37 $56 $37 $56 $32 $48 $37 $56 $37 $56 $42 $63 $35 $53 $53 $80 $40 $60 $43 $65 $57 $86 $39 $59 $28 $42 $28 $42 F G H J 56 2135 57 2154 58 3693 D $39 $28 SZO $28 $ $27 $36 $36 e $38 Y 59 1702 Mini Spring Rolls $35 $41 $55 $58 $40 Y E $59 $42 $42 $41 $54 $57 $53 $ $62 to $83 to $87 $60 $90 $83 $56 $54 $48 $56 $98 $63 $48 $59 $59 $53 $29 $38 $54 59 60 2072 60 2072 61 3923 62 1575 63 2518 ago 64 2388 65 2190 66 3643 67 3244 68 1601 . 69 1532 *** 70 2800 71 2992 72 2909 73 3906 74 1216 75 3791 76 1449 77 1181 78 3595 79 3092 80 2960 -700 81 3262 82 1539 83 3826 84 3436 85 3412 86 2746 87 1540 88 2750 - 89 3810 90 1043 91 3721 22 1340 92 1545 93 2649 son 94 2068 95 3836 2000 96 1172 97 2786 98 2728 00 1089 99 1089 100 1655 10LEE 102 101 2874 102 1721 wo 103 3681 1042116 104 3116 er 105 2393 . 106 2471 107 2441 108 3361 109 2570 110 1220 111 2884 112 2047 113 1667 114 B Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods El Food Finger Foods Finger Foods Finger Foods . . Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods ange Finger Foods Salads Salads was Salads Salads Salads Salads Salads Salads wake Salads Salads Salads Salads Salads wake Salads w Salads wa Desserts Desserts Desserts Desserts D. Desserts Desserts Desserts . Desserts . Desserts Desserts Desserts Desserts Desserts Desserts Desserts Desserts Desserts Desserts Desserts Desserts C Lemon Chicken Fingers Platter Prosciutto Ham with Melon Vegetarian Platter Hors d'oeuvres Ribbon Sandwiches Mini Mini Mini Samosas Cheesy Tomato Basil Mussels Scallop and Bacon Bites Coconut Prawns with Mango Sauce Smoked Salmon and Camembert Puffs Lemon Ginger Prawns Baked Oysters with Garlic Herb Butter Chicken Drummettes Chicken Cheese Patties Glazed Chicken Bites Mini Size Maxi Taste Sausage Rolls ..... Steamed Chilli Prawns Spinach & Ricotta Pufts 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 cance Tangy Coleslaw Club Salad Greek Salad Waldorf Salad Caesar Salad Variation san Pecan and Avocado Salad Seasonal Salad Fresh Fruit and Cheese Platter Peach and Raspberry Tea Cake Custard Cakes - Chocolate Sicilian Canno Custard Cakes - Vanilla Sicilian Cannoli Orange & Almond (Gluten Free) Friends (Gluten Free) Black Forest Cake Italian Fruit Torte T. Tiramisu Papered Cup Cakes (Petite) Bacci Bomb Cookies and Cream Cake Apple, Rhubarb and Raspberry Tart Salted Caramel Nut Tart Lemon and Lime Tart Apple Pie Lemon Meringue Pie Danish Pastry Platter Raspberry-dusted Chocolate Fudge Truffe Home-Made Biscuits $60 $55 $37 $36 $32 $37 $65 $42 $32 $39 $39 $35 $19 $25 $36 $20 $32 $24 $21 $20 $29 $24 $25 $19 $29 $29 $19 $30 $48 $36 $32 $30 $44 $36 $38 $29 Y $44 $29 $42 $63 Y Y Y $32 932 $28 420 $27 $32 $22 $19 en $27 $37 $27 eco $59 $43 $29 Y Y $48 $ $42 $41 $48 $29 $41 tec $56 $ $41 $89 ter $65 $44 $47 $41 $48 $41 $41 $54 $68 $75 $31 $27 $32 $27 $27 $36 $45 $50 Section D 8 The following are to be completed in the Menu Worksheet This sheet contains Menu options with associated costs. In cell 112 use a formula to calculate the highest price in D7:E113. D1 1 D2 In cell 113 use a formula to calculate the lowest price in D7:E113. 1 D3 3 D4 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 J7 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started