Coco Cola Dashboard.xlsx

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1
2	Key American Coca-Cola Retailers
3	Beverage Sales & Operating Margin 2021
4
5	Retailer	Retailer ID	Invoice Date	Region	State	City	Beverage Brand	Price per Unit	Units Sold	Total Sales	Operating Profit	Operating Margin	Month number	Month
6	Sodapop	1185732	1/14/2021	Northeast	New York	New York	Coca-Cola	$0.50	12,000	$6,000	$3,000	50%	1	Jan
7	Sodapop	1185732	1/14/2021	Northeast	New York	New York	Diet Coke	$0.50	10,000	$5,000	$1,500	30%	1	Jan	1	Jan
8	Sodapop	1185732	1/14/2021	Northeast	New York	New York	Sprite	$0.40	10,000	$4,000	$1,400	35%	1	Jan	2	Feb
9	Sodapop	1185732	1/14/2021	Northeast	New York	New York	Fanta	$0.45	8,500	$3,825	$1,339	35%	1	Jan	3	Mar
10	Sodapop	1185732	1/14/2021	Northeast	New York	New York	Powerade	$0.60	9,000	$5,400	$1,620	30%	1	Jan	4	Apr
11	Sodapop	1185732	1/14/2021	Northeast	New York	New York	Dasani Water	$0.50	10,000	$5,000	$1,250	25%	1	Jan	5	May
12	Sodapop	1185732	2/12/2021	Northeast	New York	New York	Coca-Cola	$0.50	12,500	$6,250	$3,125	50%	2	Feb	6	Jun
13	Sodapop	1185732	2/12/2021	Northeast	New York	New York	Diet Coke	$0.50	9,000	$4,500	$1,350	30%	2	Feb	7	Jul
14	Sodapop	1185732	2/12/2021	Northeast	New York	New York	Sprite	$0.40	9,500	$3,800	$1,330	35%	2	Feb	8	Aug
15	Sodapop	1185732	2/12/2021	Northeast	New York	New York	Fanta	$0.45	8,250	$3,713	$1,299	35%	2	Feb	9	Sep
16	Sodapop	1185732	2/12/2021	Northeast	New York	New York	Powerade	$0.60	9,000	$5,400	$1,620	30%	2	Feb	10	Oct
17	Sodapop	1185732	2/12/2021	Northeast	New York	New York	Dasani Water	$0.50	10,000	$5,000	$1,250	25%	2	Feb	11	Nov
18	Sodapop	1185732	3/10/2021	Northeast	New York	New York	Coca-Cola	$0.50	12,200	$6,100	$3,050	50%	3	Mar	12	Dec
19	Sodapop	1185732	3/10/2021	Northeast	New York	New York	Diet Coke	$0.50	9,250	$4,625	$1,388	30%	3	Mar
20	Sodapop	1185732	3/10/2021	Northeast	New York	New York	Sprite	$0.40	9,500	$3,800	$1,330	35%	3	Mar
21	Sodapop	1185732	3/10/2021	Northeast	New York	New York	Fanta	$0.45	8,000	$3,600	$1,260	35%	3	Mar
22	Sodapop	1185732	3/10/2021	Northeast	New York	New York	Powerade	$0.60	8,500	$5,100	$1,530	30%	3	Mar
23	Sodapop	1185732	3/10/2021	Northeast	New York	New York	Dasani Water	$0.50	9,500	$4,750	$1,188	25%	3	Mar
24	Sodapop	1185732	4/11/2021	Northeast	New York	New York	Coca-Cola	$0.50	12,000	$6,000	$3,000	50%	4	Apr
25	Sodapop	1185732	4/11/2021	Northeast	New York	New York	Diet Coke	$0.50	9,000	$4,500	$1,350	30%	4	Apr
26	Sodapop	1185732	4/11/2021	Northeast	New York	New York	Sprite	$0.40	9,000	$3,600	$1,260	35%	4	Apr
27	Sodapop	1185732	4/11/2021	Northeast	New York	New York	Fanta	$0.45	8,250	$3,713	$1,299	35%	4	Apr
28	Sodapop	1185732	4/11/2021	Northeast	New York	New York	Powerade	$0.60	8,250	$4,950	$1,485	30%	4	Apr
29	Sodapop	1185732	4/11/2021	Northeast	New York	New York	Dasani Water	$0.50	9,500	$4,750	$1,188	25%	4	Apr
30	Sodapop	1185732	5/10/2021	Northeast	New York	New York	Coca-Cola	$0.60	12,200	$7,320	$3,660	50%	5	May
31	Sodapop	1185732	5/10/2021	Northeast	New York	New York	Diet Coke	$0.55	9,250	$5,088	$1,526	30%	5	May
32	Sodapop	1185732	5/10/2021	Northeast	New York	New York	Sprite	$0.50	9,000	$4,500	$1,575	35%	5	May
33	Sodapop	1185732	5/10/2021	Northeast	New York	New York	Fanta	$0.50	8,500	$4,250	$1,488	35%	5	May
34	Sodapop	1185732	5/10/2021	Northeast	New York	New York	Powerade	$0.60	8,750	$5,250	$1,575	30%	5	May
35	Sodapop	1185732	5/10/2021	Northeast	New York	New York	Dasani Water	$0.65	10,000	$6,500	$1,625	25%	5	May
36	Sodapop	1185732	6/12/2021	Northeast	New York	New York	Coca-Cola	$0.60	12,500	$7,500	$3,750	50%	6	Jun
37	Sodapop	1185732	6/12/2021	Northeast	New York	New York	Diet Coke	$0.55	10,000	$5,500	$1,650	30%	6	Jun
38	Sodapop	1185732	6/12/2021	Northeast	New York	New York	Sprite	$0.50	9,250	$4,625	$1,619	35%	6	Jun
39	Sodapop	1185732	6/12/2021	Northeast	New York	New York	Fanta	$0.50	9,000	$4,500	$1,575	35%	6	Jun
40	Sodapop	1185732	6/12/2021	Northeast	New York	New York	Powerade	$0.60	9,000	$5,400	$1,620	30%	6	Jun
41	Sodapop	1185732	6/12/2021	Northeast	New York	New York	Dasani Water	$0.65	10,500	$6,825	$1,706	25%	6	Jun
42	Sodapop	1185732	7/10/2021	Northeast	New York	New York	Coca-Cola	$0.60	12,750	$7,650	$3,825	50%	7	Jul
43	Sodapop	1185732	7/10/2021	Northeast	New York	New York	Diet Coke	$0.55	10,250	$5,638	$1,691	30%	7	Jul
44	Sodapop	1185732	7/10/2021	Northeast	New York	New York	Sprite	$0.50	9,500	$4,750	$1,663	35%	7	Jul
45	Sodapop	1185732	7/10/2021	Northeast	New York	New York	Fanta	$0.50	9,000	$4,500	$1,575	35%	7	Jul
46	Sodapop	1185732	7/10/2021	Northeast	New York	New York	Powerade	$0.60	9,250	$5,550	$1,665	30%	7	Jul
47	Sodapop	1185732	7/10/2021	Northeast	New York	New York	Dasani Water	$0.65	11,000	$7,150	$1,788	25%	7	Jul
48	Sodapop	1185732	8/11/2021	Northeast	New York	New York	Coca-Cola	$0.60	12,500	$7,500	$3,750	50%	8	Aug
49	Sodapop	1185732	8/11/2021	Northeast	New York	New York	Diet Coke	$0.55	10,250	$5,638	$1,691	30%	8	Aug
50	Sodapop	1185732	8/11/2021	Northeast	New York	New York	Sprite	$0.50	9,500	$4,750	$1,663	35%	8	Aug
51	Sodapop	1185732	8/11/2021	Northeast	New York	New York	Fanta	$0.50	9,250	$4,625	$1,619	35%	8	Aug
52	Sodapop	1185732	8/11/2021	Northeast	New York	New York	Powerade	$0.60	9,000	$5,400	$1,620	30%	8	Aug
53	Sodapop	1185732	8/11/2021	Northeast	New York	New York	Dasani Water	$0.65	10,750	$6,988	$1,747	25%	8	Aug
54	Sodapop	1185732	9/10/2021	Northeast	New York	New York	Coca-Cola	$0.60	12,000	$7,200	$3,600	50%	9	Sep
55	Sodapop	1185732	9/10/2021	Northeast	New York	New York	Diet Coke	$0.55	10,000	$5,500	$1,650	30%	9	Sep
56	Sodapop	1185732	9/10/2021	Northeast	New York	New York	Sprite	$0.50	9,250	$4,625	$1,619	35%	9	Sep
57	Sodapop	1185732	9/10/2021	Northeast	New York	New York	Fanta	$0.50	9,000	$4,500	$1,575	35%	9	Sep
58	Sodapop	1185732	9/10/2021	Northeast	New York	New York	Powerade	$0.60	9,000	$5,400	$1,620	30%	9	Sep
59	Sodapop	1185732	9/10/2021	Northeast	New York	New York	Dasani Water	$0.65	10,000	$6,500	$1,625	25%	9	Sep
60	Sodapop	1185732	10/12/2021	Northeast	New York	New York	Coca-Cola	$0.65	11,750	$7,638	$3,819	50%	10	Oct
61	Sodapop	1185732	10/12/2021	Northeast	New York	New York	Diet Coke	$0.55	10,000	$5,500	$1,650	30%	10	Oct
62	Sodapop	1185732	10/12/2021	Northeast	New York	New York	Sprite	$0.55	9,000	$4,950	$1,733	35%	10	Oct
63	Sodapop	1185732	10/12/2021	Northeast	New York	New York	Fanta	$0.55	8,750	$4,813	$1,684	35%	10	Oct
64	Sodapop	1185732	10/12/2021	Northeast	New York	New York	Powerade	$0.65	8,750	$5,688	$1,706	30%	10	Oct
65	Sodapop	1185732	10/12/2021	Northeast	New York	New York	Dasani Water	$0.70	10,000	$7,000	$1,750	25%	10	Oct
66	Sodapop	1185732	11/11/2021	Northeast	New York	New York	Coca-Cola	$0.65	11,500	$7,475	$3,738	50%	11	Nov
67	Sodapop	1185732	11/11/2021	Northeast	New York	New York	Diet Coke	$0.55	9,750	$5,363	$1,609	30%	11	Nov
68	Sodapop	1185732	11/11/2021	Northeast	New York	New York	Sprite	$0.55	9,200	$5,060	$1,771	35%	11	Nov
69	Sodapop	1185732	11/11/2021	Northeast	New York	New York	Fanta	$0.55	9,000	$4,950	$1,733	35%	11	Nov
70	Sodapop	1185732	11/11/2021	Northeast	New York	New York	Powerade	$0.65	8,750	$5,688	$1,706	30%	11	Nov
71	Sodapop	1185732	11/11/2021	Northeast	New York	New York	Dasani Water	$0.70	9,750	$6,825	$1,706	25%	11	Nov
72	Sodapop	1185732	12/10/2021	Northeast	New York	New York	Coca-Cola	$0.65	12,000	$7,800	$3,900	50%	12	Dec
73	Sodapop	1185732	12/10/2021	Northeast	New York	New York	Diet Coke	$0.55	10,000	$5,500	$1,650	30%	12	Dec
74	Sodapop	1185732	12/10/2021	Northeast	New York	New York	Sprite	$0.55	9,500	$5,225	$1,829	35%	12	Dec
75	Sodapop	1185732	12/10/2021	Northeast	New York	New York	Fanta	$0.55	9,000	$4,950	$1,733	35%	12	Dec
76	Sodapop	1185732	12/10/2021	Northeast	New York	New York	Powerade	$0.65	9,000	$5,850	$1,755	30%	12	Dec
77	Sodapop	1185732	12/10/2021	Northeast	New York	New York	Dasani Water	$0.70	10,000	$7,000	$1,750	25%	12	Dec
78	BevCo	1197831	1/2/2021	South	Texas	Houston	Coca-Cola	$0.25	9,000	$2,250	$788	35%	1	Jan
79	BevCo	1197831	1/2/2021	South	Texas	Houston	Diet Coke	$0.35	9,000	$3,150	$1,103	35%	1	Jan
80	BevCo	1197831	1/2/2021	South	Texas	Houston	Sprite	$0.35	7,000	$2,450	$858	35%	1	Jan
81	BevCo	1197831	1/2/2021	South	Texas	Houston	Fanta	$0.35	7,000	$2,450	$1,103	45%	1	Jan
82	BevCo	1197831	1/2/2021	South	Texas	Houston	Powerade	$0.40	5,500	$2,200	$660	30%	1	Jan
83	BevCo	1197831	1/2/2021	South	Texas	Houston	Dasani Water	$0.35	7,000	$2,450	$1,225	50%	1	Jan
84	BevCo	1197831	2/1/2021	South	Texas	Houston	Coca-Cola	$0.25	8,500	$2,125	$744	35%	2	Feb
85	BevCo	1197831	2/1/2021	South	Texas	Houston	Diet Coke	$0.35	8,500	$2,975	$1,041	35%	2	Feb
86	BevCo	1197831	2/1/2021	South	Texas	Houston	Sprite	$0.35	6,750	$2,363	$827	35%	2	Feb
87	BevCo	1197831	2/1/2021	South	Texas	Houston	Fanta	$0.35	6,250	$2,188	$984	45%	2	Feb
88	BevCo	1197831	2/1/2021	South	Texas	Houston	Powerade	$0.40	5,000	$2,000	$600	30%	2	Feb
89	BevCo	1197831	2/1/2021	South	Texas	Houston	Dasani Water	$0.35	7,000	$2,450	$1,225	50%	2	Feb
90	BevCo	1197831	3/3/2021	South	Texas	Houston	Coca-Cola	$0.30	8,750	$2,625	$919	35%	3	Mar
91	BevCo	1197831	3/3/2021	South	Texas	Houston	Diet Coke	$0.40	8,750	$3,500	$1,225	35%	3	Mar
92	BevCo	1197831	3/3/2021	South	Texas	Houston	Sprite	$0.35	7,000	$2,450	$858	35%	3	Mar
93	BevCo	1197831	3/3/2021	South	Texas	Houston	Fanta	$0.40	6,000	$2,400	$1,080	45%	3	Mar
94	BevCo	1197831	3/3/2021	South	Texas	Houston	Powerade	$0.45	5,000	$2,250	$675	30%	3	Mar
95	BevCo	1197831	3/3/2021	South	Texas	Houston	Dasani Water	$0.40	6,500	$2,600	$1,300	50%	3	Mar
96	BevCo	1197831	4/2/2021	South	Texas	Houston	Coca-Cola	$0.30	9,000	$2,700	$945	35%	4	Apr
97	BevCo	1197831	4/2/2021	South	Texas	Houston	Diet Coke	$0.40	9,000	$3,600	$1,260	35%	4	Apr
98	BevCo	1197831	4/2/2021	South	Texas	Houston	Sprite	$0.35	7,250	$2,538	$888	35%	4	Apr
99	BevCo	1197831	4/2/2021	South	Texas	Houston	Fanta	$0.40	6,250	$2,500	$1,125	45%	4	Apr
100	BevCo	1197831	4/2/2021	South	Texas	Houston	Powerade	$0.45	5,250	$2,363	$709	30%	4	Apr