Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please provide the answer in excel sheet form board Styles Editing Sales. Mix Sales Sales Mix Font Paragraph Excel Exercise 1. Sales for one Friday
please provide the answer in excel sheet form
board Styles Editing Sales. Mix Sales Sales Mix Font Paragraph Excel Exercise 1. Sales for one Friday night are shown on the textbook's companion website. On your Excel spreadsheet a Calculate the average cheque (assume one customer for each main dish sold). b. Calculate the sales mix c. Eight servers are on duty that night. Calculate the average sales per server d. Calculate the seat turnover for the meal period. you do not need companion website the format is below New York Strip Steak Prime Rib of Beef Baby Back Pork Ribs Roast Leg of Lamb Loin of Pork a Maison Meatless Manicotti Chicken Breasts au Say Tea Smoked Salmon Baked Stull Shrimp Chicken Albuleta Fruits De Mer Catch of the Day (round to two decimal points) Sales For Friday Night Menu Item Number Sold Menu Price Total Sales Total Covers Average Sale per Server Average Sale per Server Total Sales Number of Servers Black Bean Soup Clam Chowder Shrimp Cocktail Oysters Rockefeller Prosciutto and Fig Bruschetta Jewels of the Sea New York Strip Steak Prime Rib of Beef Baby Back Pork Ribs Roast Leg of Lamb Loin of Pork a Maison Meatless Manicolli Chicken Breasts au Say Tea-Smoked Salmon Baked Stuff Shrimp Chicken Albufera Fruits De Mer Catch of the Day Deep Dish Apple Ple Banca Beignets Apple Blackberry Cobler Seat Tumover Seal Turnover Number of Customer Served Number of Seats Total Covers Total Sales Average Check Total Sales Total Covers Average Check Focus I 18 - board Styles Editing Sales. Mix Sales Sales Mix Font Paragraph Excel Exercise 1. Sales for one Friday night are shown on the textbook's companion website. On your Excel spreadsheet a Calculate the average cheque (assume one customer for each main dish sold). b. Calculate the sales mix c. Eight servers are on duty that night. Calculate the average sales per server d. Calculate the seat turnover for the meal period. you do not need companion website the format is below New York Strip Steak Prime Rib of Beef Baby Back Pork Ribs Roast Leg of Lamb Loin of Pork a Maison Meatless Manicotti Chicken Breasts au Say Tea Smoked Salmon Baked Stull Shrimp Chicken Albuleta Fruits De Mer Catch of the Day (round to two decimal points) Sales For Friday Night Menu Item Number Sold Menu Price Total Sales Total Covers Average Sale per Server Average Sale per Server Total Sales Number of Servers Black Bean Soup Clam Chowder Shrimp Cocktail Oysters Rockefeller Prosciutto and Fig Bruschetta Jewels of the Sea New York Strip Steak Prime Rib of Beef Baby Back Pork Ribs Roast Leg of Lamb Loin of Pork a Maison Meatless Manicolli Chicken Breasts au Say Tea-Smoked Salmon Baked Stuff Shrimp Chicken Albufera Fruits De Mer Catch of the Day Deep Dish Apple Ple Banca Beignets Apple Blackberry Cobler Seat Tumover Seal Turnover Number of Customer Served Number of Seats Total Covers Total Sales Average Check Total Sales Total Covers Average Check Focus I 18Step 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