Please Helpp!!!

How Much will the Catering Cost? You are hosting a large memorial service. Use a spreadsheet to figure out how much the food is going to cost including sales tax. How quickly can the use of a spreadsheet help you provide the total cost even as the number of mourners changes? Instructions Use the menus below to create a spreadsheet that can quickly calculate the cost of the catering based on the ditferent food options, the different restaurants, and the number of guests. - Menu 1 - 2020-01 Tiouch Funeral Menu - Menu 2 - Funeral Menus \& - Menu 3 - Jiesvas Create a Google Sheet that can quickly calculate the cost of the catering for each of the three menu options. You can create all three restaurant options on a single sheet, or male individual sheets for each restaurant. To accomplish this you should need to use some cell formatting a formula or two, and some cell referencing. All of these skills were covered in our module this week Make your spreadsheet(s) as presentable and efficient to use as possible. Formatting and color can make a big visual differencel Turn in your spreadsheet by submitting a shared liok to it in this assignment. Tinucci's Family Funeral Menu The Tinucci family has been serving the community since 1958 (since 1946 from Inver Grove) and is committed to serving only the highest quality food and providing the best in service. Thank you for considering Tinucci's to help cater your loved ones funeral. We've included what our customers have told us are their favorite catered meals. If you don't see what you need, please don't hesitate to ask for our special menus. Please give us a call or stop in to see us. 396 21st Street Newport, MN 55055-1008 Phone (651)4593211 Fax (651)769-2206 markjr@tinuccis.com Tinucci's Family Funeral Menu Carl's Catering \&x Banquet Facility 5110 W. Loomis Road Greendale. WI 53129 Phone (414)421-6550 Fax (414)421-6510 SnecialFuneralMenu. Selections $9.95 per person plus $50.00 Set Up Charge Seasonal Fresh fruits are avallable at an additional $1.80 per person charge. Home-made cheesecakes and Tortes are available at an additional $3.00 per person. China and tinen service are avallable at an additional \$5.50 per person charge Full Service Bar available at no extra charge. 18% Gratuity applied to all food and beverage costs. 6.1% state Sales Tax is applied to the entire bill. Carl's Catering \& Banquet Facility 5110 W. Loomis Road Greendale, WI 53129 Phone (414)421-6550 Fax (414)421-6510 Special Funeral Menu Selections Cold Buffet Shaved Ham, Turkey and Beef served on Medium Buns. (Lettuce and Condiments are provided) Assorted Cheese Tray served with Grackers American Potato Salad OR Pasta Salad Raw Vegetable Platter served with Dill Dip Assorted Relishes Brownie \& Cookie Tray Coffee and Milk $8.95 per person charge plus $50.00 Set Up Charge Seasonal fresh fruits are available at an additional \$1.80 per person. Home-made Cheesecakes and Tortes are available at \$3.00 per person: Full Service Bar available at no extra charge. 18% Gratuity applied to all food and beverage costs. 6.1% State Sales Tax applied to the entire bill. JIGSY'S ITALIAN BAKED CHICK EN Includes Roasted Red Potatoes, Country Stuffing, Buttered Corn or Green Beans, Garden Salad, Dinner Rolls and Butter, and lced Tea $12.99 per person e OVEN ROASTED TURKEY BREAST Includes Country Bread Stuffing. Creamy Mashed Potatoes, Cranberry Tray. Buttered Corn or Green Beans. Garden Salad, Dinner Rolls with Butter, and Iced Tea $12.99 per person ROAST BEEF Sliced. Includes Mashed Polatoes or Roosled Red Polatoes: Garden Salad, Corn or Green Beans. Dinner Rolls and Buller, Cookie and Brownie Tray: and iced tea $15.99 per person How Much will the Catering Cost? You are hosting a large memorial service. Use a spreadsheet to figure out how much the food is going to cost including sales tax. How quickly can the use of a spreadsheet help you provide the total cost even as the number of mourners changes? Instructions Use the menus below to create a spreadsheet that can quickly calculate the cost of the catering based on the ditferent food options, the different restaurants, and the number of guests. - Menu 1 - 2020-01 Tiouch Funeral Menu - Menu 2 - Funeral Menus \& - Menu 3 - Jiesvas Create a Google Sheet that can quickly calculate the cost of the catering for each of the three menu options. You can create all three restaurant options on a single sheet, or male individual sheets for each restaurant. To accomplish this you should need to use some cell formatting a formula or two, and some cell referencing. All of these skills were covered in our module this week Make your spreadsheet(s) as presentable and efficient to use as possible. Formatting and color can make a big visual differencel Turn in your spreadsheet by submitting a shared liok to it in this assignment. Tinucci's Family Funeral Menu The Tinucci family has been serving the community since 1958 (since 1946 from Inver Grove) and is committed to serving only the highest quality food and providing the best in service. Thank you for considering Tinucci's to help cater your loved ones funeral. We've included what our customers have told us are their favorite catered meals. If you don't see what you need, please don't hesitate to ask for our special menus. Please give us a call or stop in to see us. 396 21st Street Newport, MN 55055-1008 Phone (651)4593211 Fax (651)769-2206 markjr@tinuccis.com Tinucci's Family Funeral Menu Carl's Catering \&x Banquet Facility 5110 W. Loomis Road Greendale. WI 53129 Phone (414)421-6550 Fax (414)421-6510 SnecialFuneralMenu. Selections $9.95 per person plus $50.00 Set Up Charge Seasonal Fresh fruits are avallable at an additional $1.80 per person charge. Home-made cheesecakes and Tortes are available at an additional $3.00 per person. China and tinen service are avallable at an additional \$5.50 per person charge Full Service Bar available at no extra charge. 18% Gratuity applied to all food and beverage costs. 6.1% state Sales Tax is applied to the entire bill. Carl's Catering \& Banquet Facility 5110 W. Loomis Road Greendale, WI 53129 Phone (414)421-6550 Fax (414)421-6510 Special Funeral Menu Selections Cold Buffet Shaved Ham, Turkey and Beef served on Medium Buns. (Lettuce and Condiments are provided) Assorted Cheese Tray served with Grackers American Potato Salad OR Pasta Salad Raw Vegetable Platter served with Dill Dip Assorted Relishes Brownie \& Cookie Tray Coffee and Milk $8.95 per person charge plus $50.00 Set Up Charge Seasonal fresh fruits are available at an additional \$1.80 per person. Home-made Cheesecakes and Tortes are available at \$3.00 per person: Full Service Bar available at no extra charge. 18% Gratuity applied to all food and beverage costs. 6.1% State Sales Tax applied to the entire bill. JIGSY'S ITALIAN BAKED CHICK EN Includes Roasted Red Potatoes, Country Stuffing, Buttered Corn or Green Beans, Garden Salad, Dinner Rolls and Butter, and lced Tea $12.99 per person e OVEN ROASTED TURKEY BREAST Includes Country Bread Stuffing. Creamy Mashed Potatoes, Cranberry Tray. Buttered Corn or Green Beans. Garden Salad, Dinner Rolls with Butter, and Iced Tea $12.99 per person ROAST BEEF Sliced. Includes Mashed Polatoes or Roosled Red Polatoes: Garden Salad, Corn or Green Beans. Dinner Rolls and Buller, Cookie and Brownie Tray: and iced tea $15.99 per person