05. P&Q - Mei 2022 - Google Sheets

	B	C	D	H	J	L	M	N	P	Q	R	S	T	U	V
1		SATELIT KARAWANG							Week	I	II	III	IV	V	TOTAL
2	Periode	May-2022													0
3		56%	669,049,250	166,637,178	230,625,000				Sales	189,264,973	270,967,278	249,393,511	161,816,969	194,868,697	1,066,311,428
4	Hari	Tanggal	SATELIT KARAWANG				Cost	%	Cost	58,827,810	84,426,945	144,946,944	59,715,722	90,274,153	438,191,574
5	Hari	Tanggal	SPV	JSP	DANONE	Total	Cost	%	%	31.08%	31.16%	58.12%	36.90%	46.33%	41.09%

6	Sunday	1-May	1,750,000	1,540,910		3,290,910	1,675,003	50.9%
7	Monday	2-May	39,688,250	1,388,640		41,076,890	10,152,747	24.7%
8	Tuesday	3-May	19,228,500	1,388,640		20,617,140	10,983,176	53.3%
9	Wednesday	4-May	25,390,750	4,867,744	3,375,000	33,633,494	16,122,984	47.9%
10	Thursday	5-May	29,914,750	5,077,063	2,250,000	37,241,813	8,881,084	23.8%
11	Friday	6-May	25,390,750	5,146,836	2,250,000	32,787,586	7,998,785	24.4%
12	Saturday	7-May	19,228,500	1,388,640		20,617,140	3,014,031	14.6%
13	Sunday	8-May	16,378,250	1,520,458		17,898,708	5,432,150	30.3%
14	Monday	9-May	27,839,750	7,514,345	13,500,000	48,854,095	14,578,002	29.8%
15	Tuesday	10-May	23,640,750	8,393,667	13,500,000	45,534,417	12,920,500	28.4%
16	Wednesday	11-May	23,640,750	9,091,397	13,500,000	46,232,147	11,477,520	24.8%
17	Thursday	12-May	27,839,750	9,207,989	13,500,000	50,547,739	20,430,617	40.4%
18	Friday	13-May	23,640,750	8,742,532	13,500,000	45,883,282	14,147,533	30.8%
19	Saturday	14-May	14,628,250	1,388,640		16,016,890	5,440,623	34.0%
20	Sunday	15-May	17,153,500	1,388,640		18,542,140	10,522,616	56.7%			0	0	0
21	Monday	16-May	17,288,250	1,947,735		19,235,985	10,238,375	53.2%		189,264,973	460,232,251	709,625,762	871,442,731
22	Tuesday	17-May	23,640,750	9,300,716	13,500,000	46,441,466	25,600,382	55.1%		189,264,973	460,232,251	709,625,762	871,442,731
23	Wednesday	18-May	27,839,750	9,091,397	15,750,000	52,681,147	30,293,418	57.5%
24	Thursday	19-May	23,640,750	9,161,170	15,750,000	48,551,920	29,392,401	60.5%
25	Friday	20-May	23,640,750	8,533,213	15,750,000	47,923,963	28,649,100	59.8%
26	Saturday	21-May	14,628,250	1,388,640		16,016,890	10,250,652	64.0%
27	Sunday	22-May	14,628,250	1,388,640		16,016,890	7,493,930	46.8%
28	Monday	23-May	23,640,750	8,817,078	15,750,000	48,207,828	7,345,976	15.2%
29	Tuesday	24-May	23,640,750	9,719,354	15,750,000	49,110,104	22,437,908	45.7%
30	Wednesday	25-May	23,640,750	9,091,397	15,750,000	48,482,147	22,437,908	46.3%
31	Thursday	26-May	17,288,250	1,388,640		18,676,890	8,798,319	47.1%
32	Friday	27-May	23,640,750	7,835,483	15,750,000	47,226,233	23,903,764	50.6%
33	Saturday	28-May	14,628,250	1,388,640		16,016,890	10,017,576	62.5%
34	Sunday	29-May	14,628,250	1,388,640		16,016,890	8,765,101	54.7%
35	Monday	30-May	23,640,750	9,021,624	15,750,000	48,412,374	20,118,098	41.6%
36	Tuesday	31-May	23,640,750	9,128,670	15,750,000	48,519,420	18,671,295	38.5%
37
38
39
40
41
42
43
44
45
46
47
48
49
50
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