Question: Think about the example (below), and carefully describe how you would construct a 'Server Sales - Sunday Evening' table (total sales per server for only

Think about the example (below), and carefully describe how you would construct a 'Server Sales - Sunday Evening' table (total sales per server for only Sunday evening shifts).

What columns are required to calculate the Sunday evening total per server, and specifically, what Excel function best meets the need? Give an example of the function syntax for 'Sunday Evening Total'? Think about the example (below), and carefully describe how you would construct

E 7 Sun 8 Sun A B. D 1 Sales by Server - Week of Jan 1-8 2 Day Shift Server Nightly Sales 3 Sun Evening Alishia 2,600.71 4. Sun Day Alishia 2,682.33 5 Sun Evening Carol 2,578.45 6 Sun Evening Hugo 2,608.13 Evening Meredith 1,938.03 Day Bryan 1,678.69 9 Sun Evening Bryan 2,796.24 10 Sun Evening Todd 2,404.86 11 Sun Evening Mary 2,395.43 12 Sun Evening Margo 2,244.54 13 Sun Day Jake 2,032.34 14 Sun Day Jerri 1,268.45 15 Sun Evening Jerri 1,504.23 Day Rhea 1,524.81 17 Mon Evening Rhea 1,320.76 18 Mon Day Carol 2,200.03 19 Mon Evening Carol 1,892.10 F G Total Sales Per Server Server Weekly Sales Alishia $ 25,558 Arty $ 1,950 Bryan $ 11,736 Carol $ 22,708 Hugo $ 16,401 Jake $ 8,529 Janna 3,978 Jerri $ 4,372 Josh $ 10,450 Justina $ 16,999 Lexi $ 15,826 Marcus $ 15,284 Margo $ 3,477 Mary $ 4,371 Meredith $ 21,826 Rhea $ 19,432 Todd $ 4,587 16 Mon E 7 Sun 8 Sun A B. D 1 Sales by Server - Week of Jan 1-8 2 Day Shift Server Nightly Sales 3 Sun Evening Alishia 2,600.71 4. Sun Day Alishia 2,682.33 5 Sun Evening Carol 2,578.45 6 Sun Evening Hugo 2,608.13 Evening Meredith 1,938.03 Day Bryan 1,678.69 9 Sun Evening Bryan 2,796.24 10 Sun Evening Todd 2,404.86 11 Sun Evening Mary 2,395.43 12 Sun Evening Margo 2,244.54 13 Sun Day Jake 2,032.34 14 Sun Day Jerri 1,268.45 15 Sun Evening Jerri 1,504.23 Day Rhea 1,524.81 17 Mon Evening Rhea 1,320.76 18 Mon Day Carol 2,200.03 19 Mon Evening Carol 1,892.10 F G Total Sales Per Server Server Weekly Sales Alishia $ 25,558 Arty $ 1,950 Bryan $ 11,736 Carol $ 22,708 Hugo $ 16,401 Jake $ 8,529 Janna 3,978 Jerri $ 4,372 Josh $ 10,450 Justina $ 16,999 Lexi $ 15,826 Marcus $ 15,284 Margo $ 3,477 Mary $ 4,371 Meredith $ 21,826 Rhea $ 19,432 Todd $ 4,587 16 Mon

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

create a event schedule for banquet events that does not exceed the budgeted labor cost of 9.5% PRACTICAL LAB #2 OBJECTIVE The objective of the assignment is to create a schedule for the below...

Please see attachment. All three question need to be answered in narrative format. If you have questions, just let me know. Normal requirement for references are 2 outside our course text....

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

PLEASE COMPLETE NO LATER THAN 10/07 @8:00AM Each question(1,2,& 3) must be a minimum of 200 words. Please make answers detailed and knowledgeable based off the attached reading. ARE YOU ABLE TO...

please provide the answer in your own words. thank u so much... In the discussion forum, you are expected to participate often and engage in deep levels of discourse. Please post your initial...

Revenue Management at The View Sheryl E. Kimes Shirley Tan, the Manager of The View, a popular bar in Sydney, has been charged with figuring out how to apply revenue management principles to The...

Read the following case and fill in the excel sheet below. Determine Windham's income, profit, and ROI from each medium: Exhibit 2 Use information from the case and appropriate calculations to...

MONTE CARLO SIMULATION The procedures described here will allow you to make decisions throughout the duration of a project. You will define goals considering specific bonuses and penalties. You will...

1. List and describe each payment method used by the restaurant and foodservice industry. 2. Describe the components and factors to consider in the development of a master schedule. 3. Chef Johnson...

Can you please help me with questions 8 and 9 for Case 6..... I have answers to questions 1-7 if needed... Cases for Management Decision-Making CA-1 Suggested Uses of Cases Case Overview CASE 1 This...

Three different methods for assembling a product were proposed by an industrial engineer. To investigate the number of units assembled correctly with each method, 30 employees were randomly selected...

Explain in detail how monetary policy influences banks lending behavior. Show how an open market purchase affects the banking systems balance sheet, and discuss the impact on the supply of bank loans.

10. What evidence is necessary to demonstrate the ability to defer settlement of short-term debt?

Scenario: A Multi-national Corporation called The Globe has created a subsidiary called Thirst in an under-developed country called non-potable waters. This hosting country suffers from a severe...

1. Identify six imperatives for studying intercultural communication.

6. Discuss the relationship between nonverbal communication and power.

6. Understand the difference among a universalistic, a relativist, and a dialogic approach to the study of ethics and intercultural communication.