Answered step by step
Verified Expert Solution
Link Copied!

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 formimage text in transcribed

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 18

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Securing An IT Organization Through Governance Risk Management And Audit Internal Audit And IT Audit

Authors: Ken E. Sigler, III Rainey

1st Edition

0367658658, 978-0367658656

More Books

Students also viewed these Accounting questions

Question

c. What were you expected to do when you grew up?

Answered: 1 week ago

Question

d. How were you expected to contribute to family life?

Answered: 1 week ago

Question

e. What do you know about your ethnic background?

Answered: 1 week ago