| Ashley's Tip Distribution |
| Thursday, March 1, 2018 |
| 11:00 a.m. - 1:30 p.m. |
| | Customer Subtotal and Tip | | | | Tip Rates | | | | Tip Amounts |
| Customer | Food | Drinks | Subtotal | Tip Left | Total Received | Bartender | Assistant Food | Assistant Drink | Bartender | Assistant | My Net Tip |
| 1 | 35 | 6.75 | 41.75 | 6 | D | 13% | 1.75% | 2% |
| 2 | 42.5 | 8.45 | 50.95 | 10 |
| 3 | 100.18 | 10.25 | 110.43 | 25 |
| 4 | 38.75 | 6.75 | 45.5 | 7 |
| 5 | 51.37 | 8.45 | 59.82 | 12 |
| 6 | 16.25 | 5.25 | 21.5 | 3.5 |
| 7 | 12.95 | 6.75 | 19.7 | 4 |
| 8 | 65.81 | 8.45 | 74.26 | 14 |
| 9 | 112.45 | 25.25 | 137.7 | 30 |
| 10 | 35.13 | 6.75 | 41.88 | 9 |
| 11 | 62.1 | 12.95 | 75.05 | 14 |
| 12 | 84.34 | 12.95 | 97.29 | 20 |
| 13 | 12.25 | 0 | 12.25 | 2 |
| 14 | 25.45 | 6.75 | 32.2 | 5.5 |
| 15 | 75.12 | 13.5 | 88.62 | 20 |
| 16 | 40.44 | 10.25 | 50.69 | 8.85 |
| 17 | 13.87 | 0 | 13.87 | 2 |
| 18 | 24.75 | 3.5 | 28.25 | 6 |
| 19 | 67.33 | 9.75 | 77.08 | 15 |
| 20 | 42.44 | 6.75 | 49.19 | 12 |
| Notes: | (1) The bartender gets a 13% tip based on the total drink order for each customer. |
| | (2) The server assistant gets 1.75% of the food order and 2% of the drink order. |
M123_B
e01b1Server_.xlsx
