Alcohol / Food consumption chart.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	Q	R
1
2		Hours	# people	Drinkspp/ph	Total	Beer/Wine	Premium	Call	Bartender Fee	Soda/water	% liquor	Billed %	Diff %	Adj amount	Difference	Average Consumption
3
4
5	2023 LaQuinta
6	9/20/23 Reception	1.5	215	1.00	358	324	0		750	29
7
8
9	2022 Kiawah Island
10	10/12 Reception	1.5	158	1.23	292	122	146			24	0.00
11	10/13 Hilda Allen Dinner	1.5	44	0.61	40	30	10
12	10/13 Reception	1.5	157	1.15	272	134	116			22
13
14	Pinehurst Monday	1.5	130	1.94	379	222	94	38		25	0.10	2733	0.9	2460.8	272.2	Drinks pp/ph	1.0
15	Pinehurst Tuesday	1.5	160	2.43	582	222	0	289		71	0.50	5053	0.72	3646.5	1406.5	Total Drinks	241
16	Pinehurst Wed	1.5	90	3.21	433	197	0	200		36	0.46	4995	0.55	2725.3	2269.7	% Beer/Wine	63%
17	Pinehurst Gala	1	92	0.80	74	22	16	32		4	0.43					% Premium	28%
18	San Diego Tuesday	2	180	1.33	478	189		189		100	0.40					% Soda/Water	10%
19	San Diego Wednesday	2	120	0.71	171	115		56			0.33					% Call	#DIV/0!
20	LQ Gala	1.75	240	2.05	859	532		260		67	0.30
21	LQ Tue	1.5	200	2.02	606	347		205		54	0.34
22					0
23	Amelia Gala	3.5	137	1.05	504	269		198		37	0.39
24	Amelia Tu	1.5	220	2.06	681	475		171		35	0.25	4671
25
26
27
28
29
30
31
32
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