sample data.xlsx

	A	B	C	D	E	F	G
1	Date_	Item Name	Unit Cost	Sales Rate	Customer Name	Brand	Department
2	01/01/2023	oil	12.000	26.000	A Hyper Market	AB	a
3	01/01/2023	soda	19.000	22.000	A Hyper Market	AB	a
4	01/01/2023	soda	13.000	20.000	AZ General Store	AB	a
5	01/01/2023	soda	13.000	27.000	WM Wholesale	AB	b
6	01/01/2023	soda	15.000	21.000	B General Trading	AB	a
7	01/01/2023	CHEESE	14.000	24.000	B General Trading	AB	a
8	01/01/2023	SODA	19.000	22.000	B General Trading	BA	a
9	2/1/2023	JAM	15.000	24.000	B General Trading	BA	q
10	01/01/2023	TOMATO KETCHUP	12.000	22.000	B General Trading	BA	a
11	01/01/2023	KIDNEY BEANS	14.000	24.000	B General Trading	BA	a
12	01/01/2023	BROWN SUGAR	20.000	27.000	B General Trading	AB	a
13	01/01/2023	PINK SALT	12.000	22.000	B General Trading	AB	b
14	01/01/2023	EGGS	20.000	24.000	AZ General Store	BA	b
15	01/01/2023	CHICKEN THIGHS	18.000	28.000	A Hyper Market	AB	b
16	01/01/2023	BBQ SAUCE	13.000	21.000	A Hyper Market	AB	b
17	01/01/2023	EGGS	15.000	22.000	A Hyper Market	BA	w
18	3/1/2023	CHICKEN THIGHS	15.000	23.000	A Hyper Market	PO	w
19	3/2/2023	BBQ SAUCE	16.000	29.000	AZ General Store	UP	w
20	3/3/2023	EGGS	12.000	27.000	WM Wholesale	YP	w
21	3/4/2023	CHICKEN THIGHS	20.000	30.000	Chinese Dragon Restaurant	TP	w
22	3/5/2023	BBQ SAUCE	20.000	21.000	Chinese Dragon Restaurant	RP	q
23	3/6/2023	EGGS	20.000	26.000	Chinese Dragon Restaurant	RP	q
24	3/7/2023	CHICKEN THIGHS	19.000	26.000	Chinese Dragon Restaurant	RPR	q
25	3/8/2023	BBQ SAUCE	16.000	24.000	Chinese Dragon Restaurant	RP	a
26	3/9/2023	CHEESE	16.000	24.000	Chinese Dragon Restaurant	RPR	a
27	3/10/2023	SODA	17.000	20.000	Chinese Dragon Restaurant	RP	a
28	3/11/2023	JAM	18.000	22.000	Chinese Dragon Restaurant	RPR	q
29	3/12/2023	TOMATO KETCHUP	19.000	30.000	Chinese Dragon Restaurant	RP	a
30	3/13/2023	KIDNEY BEANS	14.000	30.000	Chinese Dragon Restaurant	RR	a
31	3/14/2023	soda	16.000	24.000	Chinese Dragon Restaurant	RP	a
32	3/15/2023	soda	20.000	27.000	Chinese Dragon Restaurant	RPR	a
33	3/16/2023	soda	13.000	22.000	Chinese Dragon Restaurant	PR	a
34	3/17/2023	CHEESE	20.000	22.000	Chinese Dragon Restaurant	PA	b
35	3/18/2023	SODA	13.000	23.000	AZ General Store	PA	a
36	3/19/2023	JAM	13.000	22.000	A Hyper Market	PA	a
37	3/20/2023	TOMATO KETCHUP	19.000	30.000	WM Wholesale	PA	a
38	3/21/2023	CHICKEN THIGHS	12.000	22.000	B General Trading	PA	q
39	3/22/2023	BBQ SAUCE	16.000	27.000	AZ General Store	PA	a
40	3/23/2023	OLIVE OIL	15.000	25.000	WM Wholesale & Foods	AB	a
41	3/24/2023	LETTUCE	14.000	30.000	WM Wholesale & Foods	AB	a
42	3/25/2023	CHICKEN THIGHS	19.000	26.000	WM Wholesale & Foods	AB	b
43	3/26/2023	BBQ SAUCE	16.000	26.000	WM Wholesale & Foods	AB	b
44	3/27/2023	OLIVE OIL	14.000	27.000	WM Wholesale & Foods	AB	b
45	3/28/2023	CHICKEN THIGHS	16.000	22.000	WM Wholesale & Foods	AB	b
46	3/29/2023	BBQ SAUCE	14.000	22.000	Chinese Dragon Restaurant	AB	w
47	3/30/2023	OLIVE OIL	12.000	26.000	AZ General Store	AB	w
48	3/31/2023	CELERY	16.000	27.000	A Hyper Market	BA	w
49	4/1/2023	CHEESE	20.000	27.000	AZ General Store	BA	w
50	4/2/2023	SODA	17.000	27.000	WM Wholesale	BA	w
51	4/3/2023	JAM	13.000	24.000	AZ General Store	BA	q
52	4/4/2023	TOMATO KETCHUP	13.000	30.000	WM Wholesale	AB	q
53	4/5/2023	KIDNEY BEANS	13.000	21.000	AZ General Store	AB	q
54	4/6/2023	JAM	17.000	29.000	WM Wholesale	BA	a
55	4/7/2023	TOMATO KETCHUP	15.000	29.000	A Hyper Market	AB	a
56	4/8/2023	KIDNEY BEANS	17.000	29.000	AZ General Store	AB	a
57	4/9/2023	soda	19.000	29.000	WM Wholesale	BA	q
58	4/9/2023	soda	19.000		WM Wholesale	BA	q
59	4/10/2023	BBQ SAUCE	14.000		Chinese Dragon Restaurant	AB	w
60	4/10/2023	CHICKEN THIGHS	19.000		WM Wholesale & Foods	AB	b
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