Coffee Chain Datasets.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	Area Code	Date	Market	Market Size	Product	Product Line	Product Type	State	Type	Budget COGS	Budget Margin	Budget Profit	Budget Sales	COGS	Inventory	Margin	Marketing	Profit	Sales	Total Expenses
2	719	Sunday, January 01, 2012	Central	Major Market	Amaretto	Beans	Coffee	Colorado	Regular	90	130	100	220	89	777	130	24	94	219	36
3	970	Sunday, January 01, 2012	Central	Major Market	Colombian	Beans	Coffee	Colorado	Regular	80	110	80	190	83	623	107	27	68	190	39
4	970	Sunday, January 01, 2012	Central	Major Market	Decaf Irish Cream	Beans	Coffee	Colorado	Decaf	100	140	110	240	95	821	139	26	101	234	38
5	303	Sunday, January 01, 2012	Central	Major Market	Green Tea	Leaves	Tea	Colorado	Regular	30	50	30	80	44	623	56	14	30	100	26
6	303	Sunday, January 01, 2012	Central	Major Market	Caffe Mocha	Beans	Espresso	Colorado	Regular	60	90	70	150	54	456	80	15	54	134	26
7	720	Sunday, January 01, 2012	Central	Major Market	Decaf Espresso	Beans	Espresso	Colorado	Decaf	80	130	80	210	72	558	108	23	53	180	55
8	970	Sunday, January 01, 2012	Central	Major Market	Chamomile	Leaves	Herbal Tea	Colorado	Decaf	140	160	110	300	170	1091	171	47	99	341	72
9	719	Sunday, January 01, 2012	Central	Major Market	Lemon	Leaves	Herbal Tea	Colorado	Decaf	50	80	20	130	63	435	87	57	0	150	87
10	970	Sunday, January 01, 2012	Central	Major Market	Mint	Leaves	Herbal Tea	Colorado	Decaf	50	70	40	120	60	336	80	19	33	140	47
11	719	Sunday, January 01, 2012	Central	Major Market	Darjeeling	Leaves	Tea	Colorado	Regular	40	70	20	110	58	338	72	22	17	130	55
12	303	Sunday, January 01, 2012	Central	Major Market	Earl Grey	Leaves	Tea	Colorado	Regular	50	70	40	120	64	965	76	19	36	140	40
13	217	Sunday, January 01, 2012	Central	Major Market	Colombian	Beans	Coffee	Illinois	Regular	150	210	130	360	144	862	201	47	111	345	90
14	309	Sunday, January 01, 2012	Central	Major Market	Decaf Irish Cream	Beans	Coffee	Illinois	Decaf	100	140	100	240	95	608	139	30	87	234	52
15	309	Sunday, January 01, 2012	Central	Major Market	Caffe Mocha	Beans	Espresso	Illinois	Regular	270	370	260	640	234	1310	312	77	203	546	109
16	630	Sunday, January 01, 2012	Central	Major Market	Decaf Espresso	Beans	Espresso	Illinois	Decaf	260	270	180	530	228	1459	228	63	140	456	88
17	312	Sunday, January 01, 2012	Central	Major Market	Chamomile	Leaves	Herbal Tea	Illinois	Decaf	70	120	100	190	89	777	130	24	95	219	35
18	630	Sunday, January 01, 2012	Central	Major Market	Lemon	Leaves	Herbal Tea	Illinois	Decaf	70	90	60	160	83	623	107	27	68	190	39
19	773	Sunday, January 01, 2012	Central	Major Market	Mint	Leaves	Herbal Tea	Illinois	Decaf	80	120	100	200	95	821	139	26	101	234	38
20	217	Sunday, January 01, 2012	Central	Major Market	Darjeeling	Leaves	Tea	Illinois	Regular	40	70	50	110	54	456	80	15	53	134	27
21	708	Sunday, January 01, 2012	Central	Major Market	Earl Grey	Leaves	Tea	Illinois	Regular	60	90	40	150	72	558	108	23	54	180	54
22	319	Sunday, January 01, 2012	Central	Small Market	Amaretto	Beans	Coffee	Iowa	Regular	10	30	20	40	18	821	27	5	11	45	16
23	641	Sunday, January 01, 2012	Central	Small Market	Colombian	Beans	Coffee	Iowa	Regular	20	40	20	60	28	965	34	8	5	62	29
24	712	Sunday, January 01, 2012	Central	Small Market	Decaf Irish Cream	Beans	Coffee	Iowa	Decaf	20	30	20	50	23	623	31	7	12	54	19
25	563	Sunday, January 01, 2012	Central	Small Market	Caffe Mocha	Beans	Espresso	Iowa	Regular	10	40	30	50	17	777	26	4	11	43	15
26	563	Sunday, January 01, 2012	Central	Small Market	Decaf Espresso	Beans	Espresso	Iowa	Decaf	10	40	30	50	17	777	26	4	10	43	16
27	641	Sunday, January 01, 2012	Central	Small Market	Chamomile	Leaves	Herbal Tea	Iowa	Decaf	200	280	200	480	234	1310	312	77	202	546	110
28	563	Sunday, January 01, 2012	Central	Small Market	Lemon	Leaves	Herbal Tea	Iowa	Decaf	80	120	90	200	95	608	139	30	86	234	53
29	712	Sunday, January 01, 2012	Central	Small Market	Darjeeling	Leaves	Tea	Iowa	Regular	190	210	140	400	228	1459	228	63	141	456	87
30	319	Sunday, January 01, 2012	Central	Small Market	Earl Grey	Leaves	Tea	Iowa	Regular	210	270	160	480	245	1419	301	93	175	546	126
31	636	Sunday, January 01, 2012	Central	Small Market	Colombian	Beans	Coffee	Missouri	Regular	90	100	40	190	85	494	105	32	39	190	66
32	573	Sunday, January 01, 2012	Central	Small Market	Decaf Irish Cream	Beans	Coffee	Missouri	Decaf	80	90	50	170	78	965	92	24	47	170	45
33	417	Sunday, January 01, 2012	Central	Small Market	Green Tea	Leaves	Tea	Missouri	Regular	20	40	0	60	34	197	42	12	-4	76	46
34	573	Sunday, January 01, 2012	Central	Small Market	Caffe Mocha	Beans	Espresso	Missouri	Regular	50	90	70	140	50	821	73	14	48	123	25
35	660	Sunday, January 01, 2012	Central	Small Market	Decaf Espresso	Beans	Espresso	Missouri	Decaf	50	80	60	130	46	777	68	12	45	114	23
36	573	Sunday, January 01, 2012	Central	Small Market	Chamomile	Leaves	Herbal Tea	Missouri	Decaf	30	40	0	70	37	261	53	34	-11	90	64
37	314	Sunday, January 01, 2012	Central	Small Market	Lemon	Leaves	Herbal Tea	Missouri	Decaf	70	10	-20	80	88	525	11	27	-39	99	50
38	314	Sunday, January 01, 2012	Central	Small Market	Darjeeling	Leaves	Tea	Missouri	Regular	30	40	10	70	35	196	47	11	9	82	38
39	573	Sunday, January 01, 2012	Central	Small Market	Earl Grey	Leaves	Tea	Missouri	Regular	20	30	-10	50	29	169	36	11	-9	65	45
40	740	Sunday, January 01, 2012	Central	Major Market	Amaretto	Beans	Coffee	Ohio	Regular	60	80	50	140	60	336	80	19	34	140	46
41	614	Sunday, January 01, 2012	Central	Major Market	Colombian	Beans	Coffee	Ohio	Regular	60	80	50	140	57	364	83	18	42	140	41
42	614	Sunday, January 01, 2012	Central	Major Market	Decaf Irish Cream	Beans	Coffee	Ohio	Decaf	60	90	20	150	63	435	87	57	0	150	87
43	216	Sunday, January 01, 2012	Central	Major Market	Earl Grey	Leaves	Tea	Ohio	Regular	70	100	60	170	84	500	116	26	67	200	49
44	614	Sunday, January 01, 2012	Central	Major Market	Decaf Espresso	Beans	Espresso	Ohio	Decaf	60	90	40	150	58	338	72	22	16	130	56
45	614	Sunday, January 01, 2012	Central	Major Market	Caffe Mocha	Beans	Espresso	Ohio	Regular	190	210	140	400	170	1091	171	47	99	341	72
46	937	Sunday, January 01, 2012	Central	Major Market	Chamomile	Leaves	Herbal Tea	Ohio	Decaf	20	50	50	70	32	456	48	8	29	80	19
47	740	Sunday, January 01, 2012	Central	Major Market	Lemon	Leaves	Herbal Tea	Ohio	Decaf	20	50	50	70	32	821	48	8	29	80	19
48	567	Sunday, January 01, 2012	Central	Major Market	Darjeeling	Leaves	Tea	Ohio	Regular	70	110	60	180	84	651	126	27	68	210	58
49	262	Sunday, January 01, 2012	Central	Small Market	Amaretto	Beans	Coffee	Wisconsin	Regular	50	70	30	120	54	312	66	20	13	120	53
50	262	Sunday, January 01, 2012	Central	Small Market	Colombian	Beans	Coffee	Wisconsin	Regular	80	110	20	190	79	551	111	72	9	190	102
51	414	Sunday, January 01, 2012	Central	Small Market	Decaf Irish Cream	Beans	Coffee	Wisconsin	Decaf	80	100	60	180	77	432	103	25	51	180	52
52	262	Sunday, January 01, 2012	Central	Small Market	Earl Grey	Leaves	Tea	Wisconsin	Regular	60	90	10	150	75	522	105	68	7	180	98
53	262	Sunday, January 01, 2012	Central	Small Market	Decaf Espresso	Beans	Espresso	Wisconsin	Decaf	50	70	50	120	48	623	62	15	34	110	28
54	414	Sunday, January 01, 2012	Central	Small Market	Caffe Mocha	Beans	Espresso	Wisconsin	Regular	80	90	50	170	69	965	81	21	38	150	43
55	715	Sunday, January 01, 2012	Central	Small Market	Chamomile	Leaves	Herbal Tea	Wisconsin	Decaf	50	100	80	150	67	400	113	20	70	180	43
56	715	Sunday, January 01, 2012	Central	Small Market	Lemon	Leaves	Herbal Tea	Wisconsin	Decaf	20	50	50	70	33	777	48	9	28	81	20
57	608	Sunday, January 01, 2012	Central	Small Market	Darjeeling	Leaves	Tea	Wisconsin	Regular	50	80	50	130	61	390	89	19	47	150	42
58	475	Sunday, January 01, 2012	East	Small Market	Darjeeling	Leaves	Tea	Connecticut	Regular	50	80	60	130	50	821	73	14	47	123	26
59	475	Sunday, January 01, 2012	East	Small Market	Green Tea	Leaves	Tea	Connecticut	Regular	40	60	40	100	38	777	56	10	35	94	21
60	475	Sunday, January 01, 2012	East	Small Market	Decaf Espresso	Beans	Espresso	Connecticut	Decaf	50	70	40	120	55	312	75	18	30	130	45
61	860	Sunday, January 01, 2012	East	Small Market	Caffe Mocha	Beans	Espresso	Connecticut	Regular	70	100	20	170	75	522	105	68	7	180	98
62	475	Sunday, January 01, 2012	East	Small Market	Colombian	Beans	Coffee	Connecticut	Regular	110	180	130	290	124	961	186	40	115	310	71
63	860	Sunday, January 01, 2012	East	Small Market	Lemon	Leaves	Herbal Tea	Connecticut	Decaf	60	80	40	140	85	494	105	32	40	190	65
64	475	Sunday, January 01, 2012	East	Small Market	Mint	Leaves	Herbal Tea	Connecticut	Decaf	50	80	50	130	78	965	92	24	47	170	45
65	954	Sunday, January 01, 2012	East	Major Market	Darjeeling	Leaves	Tea	Florida	Regular	30	50	40	80	32	821	48	8	28	80	20
66	754	Sunday, January 01, 2012	East	Major Market	Green Tea	Leaves	Tea	Florida	Regular	30	50	40	80	33	777	48	9	28	81	20
67	754	Sunday, January 01, 2012	East	Major Market	Decaf Espresso	Beans	Espresso	Florida	Decaf	70	100	60	170	77	432	103	25	50	180	53
68	239	Sunday, January 01, 2012	East	Major Market	Caffe Mocha	Beans	Espresso	Florida	Regular	70	110	30	180	79	551	111	72	9	190	102
69	754	Sunday, January 01, 2012	East	Major Market	Decaf Irish Cream	Beans	Coffee	Florida	Decaf	80	110	70	190	84	500	116	26	67	200	49
70	954	Sunday, January 01, 2012	East	Major Market	Colombian	Beans	Coffee	Florida	Regular	80	110	70	190	84	651	126	27	68	210	58
71	863	Sunday, January 01, 2012	East	Major Market	Chamomile	Leaves	Herbal Tea	Florida	Decaf	30	50	30	80	48	623	62	15	34	110	28
72	239	Sunday, January 01, 2012	East	Major Market	Lemon	Leaves	Herbal Tea	Florida	Decaf	40	50	20	90	54	312	66	20	13	120	53
73	772	Sunday, January 01, 2012	East	Major Market	Mint	Leaves	Herbal Tea	Florida	Decaf	50	60	40	110	69	965	81	21	39	150	42
74	508	Sunday, January 01, 2012	East	Major Market	Darjeeling	Leaves	Tea	Massachusetts	Regular	30	50	40	80	32	821	48	8	29	80	19
75	781	Sunday, January 01, 2012	East	Major Market	Green Tea	Leaves	Tea	Massachusetts	Regular	30	50	40	80	32	456	48	8	29	80	19
76	978	Sunday, January 01, 2012	East	Major Market	Regular Espresso	Beans	Espresso	Massachusetts	Regular	160	170	110	330	170	1091	171	47	100	341	71
77	781	Sunday, January 01, 2012	East	Major Market	Caffe Mocha	Beans	Espresso	Massachusetts	Regular	60	60	-10	120	63	435	63	57	-23	126	86
78	413	Sunday, January 01, 2012	East	Major Market	Colombian	Beans	Coffee	Massachusetts	Regular	60	400	360	460	72	558	422	23	367	494	55
79	339	Sunday, January 01, 2012	East	Major Market	Lemon	Leaves	Herbal Tea	Massachusetts	Decaf	40	60	30	100	58	338	72	22	17	130	55
80	603	Sunday, January 01, 2012	East	Small Market	Darjeeling	Leaves	Tea	New Hampshire	Regular	10	30	20	40	18	821	27	5	10	45	17
81	603	Sunday, January 01, 2012	East	Small Market	Green Tea	Leaves	Tea	New Hampshire	Regular	10	30	20	40	17	777	26	4	11	43	15
82	603	Sunday, January 01, 2012	East	Small Market	Regular Espresso	Beans	Espresso	New Hampshire	Regular	20	40	0	60	29	169	36	11	-8	65	44
83	603	Sunday, January 01, 2012	East	Small Market	Caffe Mocha	Beans	Espresso	New Hampshire	Regular	30	50	0	80	37	261	53	34	-10	90	63
84	603	Sunday, January 01, 2012	East	Small Market	Amaretto	Beans	Coffee	New Hampshire	Regular	30	50	30	80	38	241	55	12	20	93	35
85	603	Sunday, January 01, 2012	East	Small Market	Colombian	Beans	Coffee	New Hampshire	Regular	40	70	40	110	48	372	72	15	25	120	47
86	603	Sunday, January 01, 2012	East	Small Market	Lemon	Leaves	Herbal Tea	New Hampshire	Decaf	20	30	0	50	34	197	42	12	-4	76	46
87	347	Sunday, January 01, 2012	East	Major Market	Darjeeling	Leaves	Tea	New York	Regular	100	150	120	250	95	821	139	26	101	234	38
88	646	Sunday, January 01, 2012	East	Major Market	Earl Grey	Leaves	Tea	New York	Regular	90	140	110	230	89	777	130	24	94	219	36
89	347	Sunday, January 01, 2012	East	Major Market	Green Tea	Leaves	Tea	New York	Regular	50	90	70	140	54	456	80	15	54	134	26
90	631	Sunday, January 01, 2012	East	Major Market	Regular Espresso	Beans	Espresso	New York	Regular	210	270	200	480	228	1459	262	63	175	490	87
91	315	Sunday, January 01, 2012	East	Major Market	Caffe Mocha	Beans	Espresso	New York	Regular	100	-50	-170	50	105	725	-44	95	-172	61	128
92	716	Sunday, January 01, 2012	East	Major Market	Colombian	Beans	Coffee	New York	Regular	260	380	260	640	271	2101	407	94	262	678	145
93	607	Sunday, January 01, 2012	East	Major Market	Lemon	Leaves	Herbal Tea	New York	Decaf	180	190	100	370	245	1419	238	93	111	483	127
94	845	Sunday, January 01, 2012	East	Major Market	Mint	Leaves	Herbal Tea	New York	Decaf	150	-10	-70	140	207	965	-27	64	-113	180	86
95	337	Sunday, January 01, 2012	South	Small Market	Caffe Mocha	Beans	Espresso	Louisiana	Regular	50	100	80	150	67	400	113	20	70	180	43
96	337	Sunday, January 01, 2012	South	Small Market	Decaf Espresso	Beans	Espresso	Louisiana	Decaf	50	70	50	120	61	390	89	19	48	150	41
97	337	Sunday, January 01, 2012	South	Small Market	Chamomile	Leaves	Herbal Tea	Louisiana	Decaf	40	60	40	100	49	623	63	16	35	112	28
98	504	Sunday, January 01, 2012	South	Small Market	Lemon	Leaves	Herbal Tea	Louisiana	Decaf	80	100	40	180	85	494	105	32	40	190	65
99	504	Sunday, January 01, 2012	South	Small Market	Caffe Latte	Beans	Espresso	Louisiana	Regular	60	90	10	150	75	522	105	68	8	180	97
100	225	Sunday, January 01, 2012	South	Small Market	Colombian	Beans	Coffee	Louisiana	Regular	40	60	50	100	34	777	51	9	30	85	21