Section D The following are to be completed in the Menu Worksheet This sheet contains Menu...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Section D 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 D2 D3 D4 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 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.) 00 8 1 1 3 3 U B 5 6 Menu C Category 7 2627 8 1151 9 1236 10 3039 11 1261 12 1003 13 3341 14 2948 15 3821 16 1316 17 3053 18 3992 19 3908. 20 2864 21 3868 22 3295 23 2697 24 1189 25 2346 26 1770 27 3924 28 1873 29 2267 30 2430 31 2792 32 1780 33 1913 Mains Mains Mains Mains Mains Mains Mains Mains. Mains Mains Mains. Mains Mains. Mains. Mains. Mains Mains Mains Mains Mains Mainst Mains Mains Mains Mains Mainst Mains C 2 Cost of Ingredients for Menu Options 3 4 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 D Ingredient Costs Medium $58 $78 $93 $53 $70 $55 $52 E $40 $45 $42 $39 $39 $39 $45 $29 $46 $63 $45 $45 193 $73 $40 $45 $38 $42 $75 $47 Large $87 $117 $140 $80 $105 $83 $78 $60 $68 $63 $59 $59 $59 $68 $44 $69 $95 $68 $68 $140 $110. $60 $68 $57 $63 $113 $71 F Off Men Y Y Y G H Category Mains Finger Foods Salads Desserts Highest Price Lowest Price 1 Dishes Available Average Price Medium K Average Price Large L A 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 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 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 Finger Foods Finger Foods Chicken Platter Trio Vegetable Kebabs Curry Puffs Fish, Prawns and Calamari Platter Sushi Arancini Platter - Baby Size Arancini Platter - Baby Size Vegetari 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 Cutlets Cooked Prawn Platter Lemon Chicken Fingers Platter Prosciutto Ham with Melon Vegetarian Platter Hors d'oeuvres Ribbon Sandwiches Mini Spring Rolls Mini Samosas Cheesy Tomato Basil Mussels Scallop and Bacon Bites Coconut Prawns with Mango Sauce Smoked Salmon and Camembert Pu Lemon Ginger Prawns Baked Oysters with Garlic Herb But D $36 $42 $37 $53 $38 $40 $35 $39 $40 $35 $41 $37 $37 $27 $27 $47 $32 $40 $48 $45 $43 $47 $44 $38 $38 $32 $41 $38 $35 $46 $55 $58 $40 $55 $50 E $54 $63 $56 $80 $57 $60 $53 $59 $60 $53 $62 $56 $56 $41 $41 $71 $48 $60 $72 $68 $65 $71 $66 $57 $57 $48 $62 $57 153 $69 $83 $87 $60 $83 $75 F Y G H 1 A 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 95 3836 96 1172 97 2786 98 2728 99 1089 100 1655 101 2874 102 1721 103 3681 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 Salads Salads Desserts Desserts Desserts Desserts Desserts Desserts Desserts Desserts Desserts Desserts C 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 Canı Orange & Almond (Gluten Free) Friands (Gluten Free) Black Forest Cake Italian Fruit Torte Tiramisu Papered Cup Cakes (Petite) D $32 $36 132 $37 $65 $32 $42 $34 $34 $45 $24 $25 $31 $20 $32 $29 $31 $20 129 $19 $20 $29 $29 $19 $29 $32 $27 $28 $22 $27 $14 $22 $32 $37 $59 E $48 $54 $48 $56 198 $48 $63 $51 $51 $68 $36 $38 $47 $30 $48 $44 $47 $30 $44 $29 $30 $44 $44 $29 $44 $48 $41 $42 $33 $41 $21 $33 $48 $56 $89 F Y Y Y Y G H 1 K 104 3116 105 2393 106 2471 107 2441 108 3361 109 2570 110 1220 111 2884 112 2047 113 1667 114 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 Pie Danish Pastry Platter Raspberry-dusted Chocolate Fudge Home-Made Biscuits $38 $24 $31 $27 $37 $37 $27 $31 $45 $50 $57 $36 $47 $41 $56 $56 $41 $47 $68 $75 Section D 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 D2 D3 D4 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 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.) 00 8 1 1 3 3 U B 5 6 Menu C Category 7 2627 8 1151 9 1236 10 3039 11 1261 12 1003 13 3341 14 2948 15 3821 16 1316 17 3053 18 3992 19 3908. 20 2864 21 3868 22 3295 23 2697 24 1189 25 2346 26 1770 27 3924 28 1873 29 2267 30 2430 31 2792 32 1780 33 1913 Mains Mains Mains Mains Mains Mains Mains Mains. Mains Mains Mains. Mains Mains. Mains. Mains. Mains Mains Mains Mains Mains Mainst Mains Mains Mains Mains Mainst Mains C 2 Cost of Ingredients for Menu Options 3 4 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 D Ingredient Costs Medium $58 $78 $93 $53 $70 $55 $52 E $40 $45 $42 $39 $39 $39 $45 $29 $46 $63 $45 $45 193 $73 $40 $45 $38 $42 $75 $47 Large $87 $117 $140 $80 $105 $83 $78 $60 $68 $63 $59 $59 $59 $68 $44 $69 $95 $68 $68 $140 $110. $60 $68 $57 $63 $113 $71 F Off Men Y Y Y G H Category Mains Finger Foods Salads Desserts Highest Price Lowest Price 1 Dishes Available Average Price Medium K Average Price Large L A 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 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 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 Finger Foods Finger Foods Chicken Platter Trio Vegetable Kebabs Curry Puffs Fish, Prawns and Calamari Platter Sushi Arancini Platter - Baby Size Arancini Platter - Baby Size Vegetari 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 Cutlets Cooked Prawn Platter Lemon Chicken Fingers Platter Prosciutto Ham with Melon Vegetarian Platter Hors d'oeuvres Ribbon Sandwiches Mini Spring Rolls Mini Samosas Cheesy Tomato Basil Mussels Scallop and Bacon Bites Coconut Prawns with Mango Sauce Smoked Salmon and Camembert Pu Lemon Ginger Prawns Baked Oysters with Garlic Herb But D $36 $42 $37 $53 $38 $40 $35 $39 $40 $35 $41 $37 $37 $27 $27 $47 $32 $40 $48 $45 $43 $47 $44 $38 $38 $32 $41 $38 $35 $46 $55 $58 $40 $55 $50 E $54 $63 $56 $80 $57 $60 $53 $59 $60 $53 $62 $56 $56 $41 $41 $71 $48 $60 $72 $68 $65 $71 $66 $57 $57 $48 $62 $57 153 $69 $83 $87 $60 $83 $75 F Y G H 1 A 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 95 3836 96 1172 97 2786 98 2728 99 1089 100 1655 101 2874 102 1721 103 3681 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 Salads Salads Desserts Desserts Desserts Desserts Desserts Desserts Desserts Desserts Desserts Desserts C 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 Canı Orange & Almond (Gluten Free) Friands (Gluten Free) Black Forest Cake Italian Fruit Torte Tiramisu Papered Cup Cakes (Petite) D $32 $36 132 $37 $65 $32 $42 $34 $34 $45 $24 $25 $31 $20 $32 $29 $31 $20 129 $19 $20 $29 $29 $19 $29 $32 $27 $28 $22 $27 $14 $22 $32 $37 $59 E $48 $54 $48 $56 198 $48 $63 $51 $51 $68 $36 $38 $47 $30 $48 $44 $47 $30 $44 $29 $30 $44 $44 $29 $44 $48 $41 $42 $33 $41 $21 $33 $48 $56 $89 F Y Y Y Y G H 1 K 104 3116 105 2393 106 2471 107 2441 108 3361 109 2570 110 1220 111 2884 112 2047 113 1667 114 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 Pie Danish Pastry Platter Raspberry-dusted Chocolate Fudge Home-Made Biscuits $38 $24 $31 $27 $37 $37 $27 $31 $45 $50 $57 $36 $47 $41 $56 $56 $41 $47 $68 $75
Expert Answer:
Related Book For
Posted Date:
Students also viewed these mathematics questions
-
This assignment is to be completed in essay format. Consult your states criminal statutes and compare the range of punishments for misdemeanor and felony offenses. You can access those statutes in...
-
What are the steps to be completed in preparing the opening IFRS statement of financial position?
-
In this mini-case, you will determine overall materiality as well as tolerable misstatement amounts for balance sheet accounts of EarthWear Clothiers, Inc. Most auditing firms use a simple approach...
-
Suppose that there is parity between the Australian dollar and the United States dollar. Let x be a positive number and assume that the United States dollar increases by 100x % in Australian dollars....
-
Imagine a huge space colony that consists of a rotating air-filled cylinder. How would the density of air at "ground level" compare to the air densities "above"?
-
Prather Company owns 80% of the common stock of Stone Company. The stock was purchased for $960,000 on January 1, 2022, when Stone Companys retained earnings were $675,000. On January 1, 2024, Stone...
-
The basic equation that describes the motion of the fluid above a large oscillating flat plate is \[ \frac{\partial u}{\partial t}=v \frac{\partial^{2} u}{\partial y^{2}} \] where \(u\) is the fluid...
-
Selected account balances for R. Tam Company at January 1, 2012, are presented below. Accounts Payable $14,000 Accounts Receivable 22,000 Cash 17,000 Inventory 13,500 R. Tams sales journal for...
-
One capital investment that State Insurance Company Limited might need to secure financing for in the coming fiscal year is the purchase of a new claims processing system. The estimated cost of the...
-
Kepler's second law states that as a planet moves around in its orbit, it sweeps out equal areas in equal times. Examine the following figure, which shows a planet (blue dot, labeled "E"), orbiting...
-
a) ABC Company is preparing their year end financial statements. On December 31, 2021, the balance in Accounts Receivable was $680,000. An aging analysis of the accounts receivable indicated that...
-
You are working in a team and your team member asks you to share your credentials so that he can submit his work. He has some trouble with his own account and cannot continue unless you help him....
-
What's a good attention gainer for know your Marines and look out for their welfare?
-
Among the many campaigns on TikTok, there is a campaign with Pringles. #Playwithpringles is a campaign to create and post videos like popping out of a Pringles barrel. How this campaign get more...
-
Chris Rock and Brent Staples both deal with the topic of racism in their essays "Just Walk on By" and "It's a White Industry". However, they approach the subject matter in very different ways. an...
-
Explain some case from your own life where you can now guess that some selection effect was likely going on and you were, at the time, unaware of this (likely) reality.
-
The stock is currently selling for $15.25 per share, and its noncallable $1,000 par value, 20-year, 7.25% bonds with semiannual payments are selling for $875.00. The beta is 1.25, the yield on a...
-
Explain why each of the following is either a private good or a public good: traffic lights, in line skates, a city park, a chicken salad sandwich, a tennis racket, national defense, a coastal...
-
Define (a) a contingency and (b) a contingent liability.
-
The Coca-Cola Company and PepsiCo, Inc. Instructions Go to the books companion website and use information found there to answer the following questions related to The Coca-Cola Company and PepsiCo,...
-
What two assumptions are central to the IASB conceptual framework?
-
Explain the "fruit salad law," and how does it apply to the formulation of equations describing engineering systems?
-
Why should projects be linked to the organisation's Strategic Plan?
-
What is the BCG matrix and how is it used?
Study smarter with the SolutionInn App