Merrylands Sales Report.xlsx

	B	C	D	E	F	G	H	I	J	K
1	SR MERRYLANDS - PRODUCTION VS SALES REPORT
2					Total Sales:		$ 21,802.55
3	2026/09/28-2026/10/04
4	Category	Production QTY	COG $	Sale QTY	Sale Value $	% of Sales	Wastage QTY	Wastage Value	Profit $	Gross Profit %
5	Pastry	414	$ 1,863.00	306	$ 2,533.50	12%	108	$ 486.00	$ 670.50	36%
6	Bakery	22	$ 529.88	115	$ 1,520.00	7%	46	$ 123.52	$ 990.12	187%
7	Kitchen			932	$ 13,725.50	63%
8	Coffee			351	$ 3,068.00	14%
9	Cold Drinks			167	$ 901.45	4%
10	Others			132	$ 54.10	0%
11			$ 2,392.88		$ 21,802.55	100%
12
13
14	SR MERRYLANDS - PRODUCTION VS SALES REPORT
15					Total Sales:		$ 23,133.12
16	2026/10/05-2026/10/11
17	Category	Production QTY	COG $	Sale QTY	Sale Value $	% of Sales	Wastage QTY	Wastage Value	Profit $	Gross Profit %
18	Pastry	453	$ 2,038.50	299	$ 2,493.25	11%	154	$ 693.00	$ 454.75	22%
19	Bakery		$ 510.56	123	$ 1,618.30	7%	43	$ 133.52	$ 1,107.74	217%
20	Kitchen			972	$ 14,917.92	64%
21	Coffee			349	$ 3,069.03	13%
22	Cold Drinks			185	$ 997.42	4%
23	Others			128	$ 37.20	0%
24			$ 2,549.06		$ 23,133.12	100%
25
26
27	SR MERRYLANDS - PRODUCTION VS SALES REPORT
28					Total Sales:
29
30	Category	Production QTY	COG $	Sale QTY	Sale Value $	% of Sales	Wastage QTY	Wastage Value	Profit $	Gross Profit %
31	Pastry					#DIV/0!	0	$ -	$ -	#DIV/0!
32	Bakery					#DIV/0!
33	Kitchen					#DIV/0!
34	Coffee					#DIV/0!
35	Cold Drinks					#DIV/0!
36	Others					#DIV/0!
37			$ -		$ -	#DIV/0!
38
39
40	SR MERRYLANDS - PRODUCTION VS SALES REPORT
41					Total Sales:
42
43	Category	Production QTY	COG $	Sale QTY	Sale Value $	% of Sales	Wastage QTY	Wastage Value	Profit $	Gross Profit %
44	Pastry					#DIV/0!	0	$ -	$ -	#DIV/0!
45	Bakery					#DIV/0!
46	Kitchen					#DIV/0!
47	Coffee					#DIV/0!
48	Cold Drinks					#DIV/0!
49	Others					#DIV/0!
50			$ -		$ -	#DIV/0!
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