dataset.xlsx

	A	B	C	D	E	F	G	H	I	J	K
1	Date	Product ID	Product Name	Category	Units Sold	Revenue	COGS	Marketing Spend	Other Expenses	Adjusted Revenue	Highly Adjusted Revenue
2	2018-11-08 05:53:59	1	Shampoo	Personal Care	10	117,6753772	397,9913349	70,5517668	15,56094516	169,1096498	123,4617176
3	2018-11-08 05:53:59	2	Baby Shampoo	Baby Products	91	750,1459758	224,0414635	19,56305245	78,72600296	1467,017633	2046,620337
4	2018-11-08 05:53:59	3	Wipes	Baby Products	52	749,1545429	123,0442814	128,3769795	30,17907189	1317,608925	490,5076971
5	2018-11-08 05:53:59	4	Fruit Gummies	Snacks	35	604,4483339	497,8096808	113,4503251	93,10293064	990,5654782	2775,591576
6	2018-11-08 05:53:59	5	Nut Mix	Snacks	20	719,157096	386,0899256	13,94027446	59,41275056	892,0545267	1197,044118
7	2018-11-08 05:53:59	6	Blueberry Muffins	Bakery	51	522,1820326	418,4000422	117,4883522	19,01210821	647,712018	1817,898565
8	2018-11-08 05:53:59	7	Disinfectant Spray	Home Care	60	575,8623306	459,1865721	169,0268889	41,61309754	663,5519115	1095,693166
9	2018-11-08 05:53:59	8	Croissants	Bakery	92	298,1678559	303,2665837	56,74351468	67,35338181	560,4239372	846,8879785
10	2018-11-08 05:53:59	9	Salmon Fillet	Meat & Seafood	41	661,0099483	486,6246992	108,9474154	63,3186978	1084,719646	1956,719175
11	2018-11-08 05:53:59	10	Beef Patties	Frozen Foods	35	636,0093654	410,7107909	23,42655361	10,62529938	1104,917014	847,065925
12	2018-11-08 05:53:59	11	Face Cream	Personal Care	55	118,6071561	208,8512838	22,69736861	67,01155288	132,6651932	576,8021168
13	2018-11-08 05:53:59	12	Fruit Gummies	Snacks	56	69,29621133	487,1242519	71,02708476	20,48835818	113,5621208	318,20417
14	2018-11-08 05:53:59	13	Nut Mix	Snacks	8	863,0350802	366,6381966	97,47985122	97,85032303	1070,523192	1436,53045
15	2018-11-08 05:53:59	14	Chocolate Bar	Snacks	2	752,3340352	470,6025456	167,2824598	25,40312683	1484,294012	3000,381639
16	2018-11-08 05:53:59	15	Organic Milk	Dairy	68	259,5154035	103,2734932	40,58416611	56,08496509	479,8954629	1226,922713
17	2018-11-08 05:53:59	16	Toothpaste	Personal Care	35	21,87174281	66,77403884	116,1111951	16,99311571	28,23872086	99,0073229
18	2018-11-08 05:53:59	17	Veggie Pizza	Frozen Foods	60	971,0847961	92,3474991	36,32233342	74,18967635	1227,103991	3098,294504
19	2018-11-08 05:53:59	18	Dish Soap	Home Care	72	664,4747424	188,9423366	180,7050941	17,42200936	840,6031147	3088,767023
20	2018-11-08 05:53:59	19	Organic Milk	Dairy	24	386,3539981	463,8110653	86,75544368	84,53286874	714,445186	1826,583274
21	2018-11-08 05:53:59	20	Shrimp	Meat & Seafood	75	938,9308319	113,7500502	60,87771958	2,606116095	1289,920095	843,3629395
22	2018-11-08 05:53:59	21	Sparkling Water	Beverages	76	199,775849	168,0642109	58,09347823	57,90321316	314,1037294	276,0748168
23	2018-11-08 05:53:59	22	Baby Shampoo	Baby Products	45	239,4995567	424,2653299	31,36043226	37,79885352	468,3756018	653,4257054
24	2018-11-08 05:53:59	23	Fish Oil	Health & Wellness	26	495,1942865	438,8582662	140,2234979	88,92531519	737,2207499	348,380471
25	2018-11-08 05:53:59	24	Coffee Blend	Beverages	46	724,094424	262,8546585	53,2006365	74,57488989	986,2935232	1422,111665
26	2018-11-08 05:53:59	25	Laundry Detergent	Home Care	51	790,5299781	475,9689254	95,44592942	67,62215926	1304,902226	1777,939711
27	2018-11-08 05:53:59	26	Cheddar Cheese	Dairy	56	317,4059724	318,668599	41,34641038	28,71213256	388,9951356	546,2781009
28	2018-11-08 05:53:59	27	Organic Milk	Dairy	43	718,0547485	213,7582575	80,34357795	7,717909999	1327,825675	3394,779917
29	2018-11-08 05:53:59	28	Herbal Supplements	Health & Wellness	47	867,2820295	31,79862372	150,0779544	56,00901743	1182,044856	3668,012185
30	2018-11-08 05:53:59	29	Shampoo	Personal Care	7	104,475009	348,8954566	99,31091687	83,20755055	150,1395839	109,6122601
31	2018-11-08 05:53:59	30	Body Wash	Personal Care	85	855,8517319	19,91612308	12,68209279	89,08696088	1223,633181	1801,901652
32	2018-11-08 05:53:59	31	Fish Oil	Health & Wellness	91	332,439887	52,50282291	31,39623304	86,67597857	494,9200535	233,8790401
33	2018-11-08 05:53:59	32	Ice Cream	Frozen Foods	60	620,9291359	26,20963946	50,14391074	54,50019266	937,8904766	1095,446469
34	2018-11-08 05:53:59	33	Salmon Fillet	Meat & Seafood	75	946,0762605	189,2167531	142,3339051	17,36496157	1552,514465	2800,571405
35	2018-11-08 05:53:59	34	Body Wash	Personal Care	66	207,2098764	111,2997806	184,631593	33,97525781	296,2532771	436,2575955
36	2018-11-08 05:53:59	35	Organic Milk	Dairy	46	839,9435148	141,0007135	122,1493473	45,19631223	1553,222184	3971,038952
37	2018-11-08 05:53:59	36	Glass Cleaner	Home Care	88	635,7181712	408,2422555	6,681720774	47,19106003	1148,525552	1870,367012
38	2018-11-08 05:53:59	37	Shampoo	Personal Care	50	365,6914223	216,4135095	93,15786676	99,08511506	525,5300624	383,6732217
39	2018-11-08 05:53:59	38	Multivitamins	Health & Wellness	98	880,5357765	196,5397644	38,45250649	0,8734730469	1126,827272	998,6675866
40	2018-11-08 05:53:59	39	Chicken Nuggets	Frozen Foods	1	497,270577	75,38191388	198,7005925	29,55423964	777,1399249	2043,725588
41	2018-11-08 05:53:59	40	Toothpaste	Personal Care	96	518,2918101	483,6865116	19,71770226	82,28427873	669,169251	2346,163497
42	2018-11-08 05:53:59	41	Shampoo	Personal Care	68	534,6173193	143,6248981	96,13250288	69,59781789	768,2911221	560,9055525
43	2018-11-08 05:53:59	42	Blueberry Muffins	Bakery	12	969,6618105	339,1160357	18,17947785	93,96407743	1202,763728	3375,732415
44	2018-11-08 05:53:59	43	Wipes	Baby Products	18	370,6661853	442,9396294	24,82556408	75,88208348	651,9256658	242,6930714
45	2018-11-08 05:53:59	44	Herbal Supplements	Health & Wellness	1	458,6615246	139,5135239	3,055966086	48,78127148	625,123636	1939,825805
46	2018-11-08 05:53:59	45	Whole Wheat Bread	Bakery	90	40,96302324	476,7368923	35,67425025	7,089931991	66,89970814	34,22370049
47	2018-11-08 05:53:59	46	Multivitamins	Health & Wellness	33	205,5105491	383,2987552	86,1331288	64,81083301	262,9931658	233,0816414
48	2018-11-08 05:53:59	47	Disinfectant Spray	Home Care	54	653,6536148	225,8285239	67,48914721	81,77515587	753,188883	1243,70663
49	2018-11-08 05:53:59	48	Baby Food	Baby Products	97	450,3676723	260,1164628	51,04352374	94,89180024	514,2322274	2225,262712
50	2018-11-08 05:53:59	49	Laundry Detergent	Home Care	98	770,2106935	175,4509853	2,26397858	44,85153566	1271,361841	1732,240669
51	2018-11-08 05:53:59	50	Energy Drink	Beverages	72	575,7511219	480,5895247	175,8024007	56,79676984	948,1414012	2288,669126
52	2018-11-08 05:53:59	51	Organic Milk	Dairy	71	74,75297348	84,32481947	115,4989356	98,63907173	138,2330772	353,4130143
53	2018-11-08 05:53:59	52	Croissants	Bakery	28	938,579888	162,2295416	173,901722	69,92023622	1764,115836	2665,854177
54	2018-11-08 05:53:59	53	Whole Wheat Bread	Bakery	94	953,0851706	32,14729314	87,71911217	97,0391828	1556,553074	796,2815936
55	2018-11-08 05:53:59	54	Chocolate Bar	Snacks	39	657,9362927	246,8634981	50,383172	5,552949744	1298,054925	2623,914219
56	2018-11-08 05:53:59	55	Chicken Breast	Meat & Seafood	89	837,6942498	402,5026567	21,94515814	58,96673632	1050,026045	1167,930552
57	2018-11-08 05:53:59	56	Coffee Blend	Beverages	11	973,7857937	31,36089156	150,3216337	44,7450422	1326,399693	1912,502142
58	2018-11-08 05:53:59	57	Sparkling Water	Beverages	88	467,2037866	24,1780496	173,1999978	10,09871419	734,575538	645,6396027
59	2018-11-08 05:53:59	58	Blueberry Muffins	Bakery	24	123,1783868	417,7828846	122,0015393	13,60986442	152,7898635	428,8271112
60	2018-11-08 05:53:59	59	Wipes	Baby Products	77	976,0516625	405,2680584	93,32315542	6,36503146	1716,674342	639,0682106
61	2018-11-08 05:53:59	60	Baby Food	Baby Products	53	711,4726515	404,5244751	135,682807	83,04702543	812,3632951	3515,380121
62	2018-11-08 05:53:59	61	Protein Powder	Health & Wellness	12	114,3612405	491,0021954	172,2432976	33,62366421	132,4928074	60,02244301
63	2018-11-08 05:53:59	62	Chocolate Bar	Snacks	76	310,7629526	488,8512571	169,1612045	48,60278744	613,1100923	1239,353018
64	2018-11-08 05:53:59	63	Fish Oil	Health & Wellness	42	202,1948119	48,54169249	85,26016324	90,02938194	301,0176307	142,2486602
65	2018-11-08 05:53:59	64	Ice Cream	Frozen Foods	40	782,1007421	420,2753802	134,835365	76,02802333	1181,334222	1379,786269
66	2018-11-08 05:53:59	65	Nut Mix	Snacks	32	353,7556818	165,5414037	189,0612042	56,69538381	438,8044824	588,8298406
67	2018-11-08 05:53:59	66	Body Wash	Personal Care	73	819,111627	283,9210351	146,9679155	5,633033066	1171,104911	1724,549404
68	2018-11-08 05:53:59	67	Fish Oil	Health & Wellness	85	56,6670194	86,23398553	57,96551545	45,07975154	84,36305442	39,86654016
69	2018-11-08 05:53:59	68	Herbal Supplements	Health & Wellness	12	945,0162577	482,7663364	88,67449331	75,33088976	1287,991182	3996,775017
70	2018-11-08 05:53:59	69	Diapers	Baby Products	40	311,4411346	190,2097695	109,7629751	61,03593965	608,5550376	1298,577614
71	2018-11-08 05:53:59	70	Body Wash	Personal Care	67	495,9319219	373,9045736	120,8967536	69,44875322	709,0465938	1044,130094
72	2018-11-08 05:53:59	71	Chicken Nuggets	Frozen Foods	11	695,9310659	391,8454095	156,2603442	58,64082119	1087,608721	2860,197632
73	2018-11-08 05:53:59	72	Butter Spread	Dairy	90	121,2084119	467,1800932	168,5026747	45,68193581	238,6677058	446,1509584
74	2018-11-08 05:53:59	73	Nut Mix	Snacks	11	282,9629618	251,989333	52,67735216	53,32819331	350,9920049	470,9946561
75	2018-11-08 05:53:59	74	Chocolate Bar	Snacks	1	528,5811666	249,1009396	161,0649084	45,2021061	1042,847756	2108,033337
76	2018-11-08 05:53:59	75	Organic Milk	Dairy	4	107,0009805	255,5738817	140,9639241	28,46634085	197,8660394	505,8733757
77	2018-11-08 05:53:59	76	Fruit Gummies	Snacks	22	445,3187051	194,7823007	18,62611571	50,52934202	729,7850146	2044,877581
78	2018-11-08 05:53:59	77	Salmon Fillet	Meat & Seafood	9	999,3251011	159,0000369	74,22092757	59,38252456	1639,895999	2958,198424
79	2018-11-08 05:53:59	78	Chocolate Bar	Snacks	27	501,2454422	431,8565469	179,5559642	93,41797263	988,9165899	1999,015798
80	2018-11-08 05:53:59	79	Fish Oil	Health & Wellness	91	943,3420778	67,21490744	58,3675844	66,2224366	1404,401006	663,66266
81	2018-11-08 05:53:59	80	Ice Cream	Frozen Foods	69	18,09426811	301,9435575	13,93101268	77,63551594	27,33072224	31,92200359
82	2018-11-08 05:53:59	81	Veggie Pizza	Frozen Foods	75	362,4575337	295,8050451	114,3422593	95,55497413	458,0167333	1156,438849
83	2018-11-08 05:53:59	82	Cheddar Cheese	Dairy	87	699,4673727	156,4282197	76,69654899	38,17159045	857,2283737	1203,832761
84	2018-11-08 05:53:59	83	Fish Oil	Health & Wellness	22	39,17354266	293,6595514	90,62725724	17,61503781	58,31963188	27,55948042
85	2018-11-08 05:53:59	84	Ice Cream	Frozen Foods	100	15,28455757	128,5368591	183,5177728	20,94017661	23,08675846	26,96509737
86	2018-11-08 05:53:59	85	Laundry Detergent	Home Care	29	821,3865193	457,6321717	178,6198669	78,25635925	1355,836119	1847,337547
87	2018-11-08 05:53:59	86	Energy Drink	Beverages	97	421,7080772	55,80584549	8,9291897	59,84228237	694,4647991	1676,332394
88	2018-11-08 05:53:59	87	Organic Milk	Dairy	80	812,0142278	240,1429757	154,2126218	56,24568397	1501,575392	3838,996398
89	2018-11-08 05:53:59	88	Herbal Supplements	Health & Wellness	24	664,7779303	200,2076648	68,0941199	41,53057585	906,0459067	2811,557793
90	2018-11-08 05:53:59	89	Greek Yogurt	Dairy	8	837,0726515	200,9174668	36,55640875	74,40373391	1529,798497	3164,58016
91	2018-11-08 05:53:59	90	Blueberry Muffins	Bakery	58	939,7236192	64,78613013	131,6146003	41,94639761	1165,628543	3271,507085
92	2018-11-08 05:53:59	91	Disinfectant Spray	Home Care	17	621,2496315	158,671409	153,9204298	1,487599065	715,8505751	1182,051576
93	2018-11-08 05:53:59	92	Herbal Supplements	Health & Wellness	97	500,0808576	480,8366536	64,23399473	12,09590852	681,5752951	2115,001368
94	2018-11-08 05:53:59	93	Nut Mix	Snacks	42	109,5579975	306,1923674	127,1167822	8,823236602	135,8975781	182,3603734
95	2018-11-08 05:53:59	94	Multivitamins	Health & Wellness	39	933,8592505	174,769953	64,37930108	35,61444037	1195,065663	1059,144885
96	2018-11-08 05:53:59	95	Bagels	Bakery	90	82,34002339	173,7767114	167,392199	13,64038662	113,1477401	326,9488944
97	2018-11-08 05:53:59	96	Glass Cleaner	Home Care	43	829,9087062	416,3326617	46,39148277	54,32560387	1499,361507	2441,701272
98	2018-11-08 05:53:59	97	Greek Yogurt	Dairy	13	121,8806305	129,6834881	42,53093409	19,71506703	222,7438742	460,7736551
99	2018-11-08 05:53:59	98	Dish Soap	Home Care	4	500,9003225	456,5951421	11,8899166	20,01807712	633,670995	2328,402118
100	2018-11-08 05:53:59	99	Wipes	Baby Products	95	986,6672588	132,2356152	87,16853657	94,32510322	1735,344995	646,0187548