Ranking Serviers
docx
keyboard_arrow_up
School
Conestoga College *
*We aren’t endorsed by this school
Course
8998
Subject
Information Systems
Date
Dec 6, 2023
Type
docx
Pages
5
Uploaded by DeaconPuppy3545
Activity: Ranking
Servers
Based on
Performance
Fill in the blanks in the following
report using the knowledge you
just gained to calculate the average
sale per server.
Once complete, rank the servers by
average daily guest cheque and
then rank them based on the week
so far.
Try to use Excel formulas to
calculate the missing totals directly
in the highlighted fields. 3You can
also use a calculator, if you prefer
Note
This is an ungraded activity but
completion is mandatory as part of
this week’s learning.
Activity Instructions
Excel File
Download the Excel file
and save it
to your computer, then follow the
directions below. Review the
activity debrief when you have
finished.
Directions
Tip
: Use Excel formulas to
perform the calculations on the
spreadsheet.
Refer to cell comments for help
with the calculations.
Click the numbers to reveal
examples of the calculations.
Open All
/ Close All
1
Download the
Avg Sale Per
Server (Best Server)
Excel file
and save it to your computer.
2
Calculate the
average sale per
server for each day
in the
report in the highlighted cells.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
3
Calculate
total sales, covers,
and average cost for each
day in the report
, by adding
the total sales
and covers for the day (left
column) and calculating the
average sales per day (right
column) for all servers.
4
Calculate
weekly total sales,
covers, and average cost for
each server
, by adding the
total sales and customers
(covers) for the week so far
(Monday, Tuesday, and
Wednesday)... and calculating
the average sale per server for
the week in the highlighted
cells.
5
Calculate
total sales, covers,
and average cost for all
servers for the week
, by
adding the total sales and
covers for the week for all
servers (left column) and
calculating the average sales
per day (right column) for all
servers.
6
Check your answers against
the
Answers
worksheet to
ensure that your calculations
were correct
Activity Debrief