Daily sales & Cost of sales summary

Daily sales & Cost of sales summary

Canteen sales total: Php7,531

Food cost:                Php5,352 

Cost of sales vs sales:   71% 

Total food cost: Php6,942

bulk Rice cost:  Php1,980

Food cost w/o rice:  Php4,962

Rice cost of sales: Php370 ( 50% for rice sales Php740)

P4,962(food cost w/o rice) + P370 (50%/P740 as Rice cost of sales)

= P5,362 / food cost as of cost of sales from 14.Sep to21.Sep

Please inform how much you have remaining food material to create sales.

Our food material cost must set 50% or less of sales.

Sales date	canteen	grocery	Salon	Total	Purchased date	canteen	grocery	Salon	Total
15-Sep	844	112		956	15-Sep	4722	11247	6786	22755
16-Sep	645	65		710	18-Sep	225			225
17-Sep	1185	0		1185	19-Sep	77			77
18-Sep	1085	95		1180	20-Sep	469			469
19-Sep	1072	33		1105	21-Sep	1239			1239
20-Sep	1160	99		1259	21-Sep	210			210
21-Sep	1540	19		1559
Daliy sales Total	7531	423	0	7954	Cost of sales Total	6942	11247	6786	24975
Cost of sales Total	5332	11247	6786	23365	Rice 25kls 1,015	1015
Cost of Sales vs sales	71%	2659%	#DIV/0!	294%	Rice 25kls 965	965
					cost w/o rice	4962
					rice cost on 9/21	370
					food cost	5332