management information system and app

profileMo7ammedaziz
e01b1Server.xlsx

Tips

Ashley's Tip Distribution
Tuesday, March 1, 2016
11:00 a.m. - 1:30 p.m.
Customer Subtotal and Tip Tip Rates Tip Amounts
Customer Food Drinks Tip Left Total Received Bartender Assistant Bartender Assistant My Net Tip
1 35 6.75 6
2 42.5 8.45 10
3 100.18 10.25 25
4 38.75 6.75 7
5 51.37 8.45 12
6 16.25 5.25 3.5
7 12.95 6.75 4
8 65.81 8.45 14
9 112.45 25.25 30
10 35.13 6.75 9
11 62.1 12.95 14
12 84.34 12.95 20
13 12.25 0 2
14 25.45 6.75 5.5
15 75.12 13.5 20
16 40.44 10.25 8.85
17 13.87 0 2
18 24.75 3.5 6
19 67.33 9.75 15
20 42.44 6.75 12
Notes: (1) The bartender gets a 15% tip based on the total drink order for each customer.
(2) The server assistant gets 10% of the total tip left by the customer.