[Template] Tip Points Comparison

	B	C	D	E	F	G	H	J	K	L	M	N	O	P
1	EX. 1 - Same Points and Hours							EX. 3 - Different Points Same Hours
2	Employee	Labor Role	Tip Points / HR	Hours	Tip Points	Tips	% of Tips	Employee	Labor Role	Tip Points / HR	Hours	Tip Points	Tips	% of Tips
3	Jane Doe	Bartender	10	6	60	$30.00	50.00%	Jane Doe	Bartender	10	6	60	$40.00	66.67%
4	John Smith	Bartender	10	6	60	$30.00	50.00%	Jimmy Buffet	Busser	5	6	30	$20.00	33.33%
5	Total			12	120	$60.00	100.00%	Total			12	90	$60.00	100.00%
6
7		Reported Tips	$60.00						Reported Tips	$60.00
8		Total Points	120						Total Points	90
9		$/point	$0.50						$/point	$0.67
10
11
12	EX. 2 - Same Points different Hours							EX. 4 - Different Points and Hours
13	Employee	Labor Role	Tip Points / HR	Hours	Tip Points	Tips	% of Tips	Employee	Labor Role	Tip Points / HR	Hours	Tip Points	Tips	% of Tips
14	Jane Doe	Bartender	10	6	60	$40.00	66.67%	Jane Doe	Bartender	10	6	60	$57.14	95.24%
15	John Smith	Bartender	10	3	30	$20.00	33.33%	Jimmy Buffet	Busser	1	3	3	$2.86	4.76%
16	Total			9	90	$60.00	100.00%	Total			9	63	$60.00	100.00%
17
18		Reported Tips	$60.00						Reported Tips	$60.00
19		Total Points	90						Total Points	63
20		$/point	$0.67						$/point	$0.95
21
22
23	EX. 5 - Different Roles, Same Hours - 3 ppl							EX. 6 - Different Roles and Hours - 3 ppl
24	Employee	Labor Role	Tip Points / HR	Hours	Tip Points	Tips	% of Tips	Employee	Labor Role	Tip Points / HR	Hours	Tip Points	Tips	% of Tips
25	Jane Doe	Bartender	10	6	60	$31.58	52.63%	Jane Doe	Bartender	20	4	80	$20.00	33.33%
26	John Smith	Bar Lead	8	6	48	$25.26	42.11%	John Smith	Bar Lead	25	6	150	$37.50	62.50%
27	Jimmy Buffet	Busser	1	6	6	$3.16	5.26%	Jimmy Buffet	Busser	2	5	10	$2.50	4.17%
28	Total			18	114	$60.00	100.00%	Total			15	240	$60.00	100.00%
29
30		Reported Tips	$60.00						Reported Tips	$60.00
31		Total Points	114						Total Points	240
32		$/point	$0.53						$/point	$0.25
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100