06. P&Q - Juni 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	Jun-2022													0
3		56%	630,770,000	219,432,682	366,750,000				Sales	246,527,902	287,907,036	288,834,300	170,855,672	222,827,772	1,216,952,682
4	Hari	Tanggal	SATELIT KARAWANG				Cost	%	Cost	122,000,721	150,519,901	170,790,882	92,010,870	119,805,931	655,128,305
5	Hari	Tanggal	SPV	JSP	DANONE	Total	Cost	%	%	49.49%	52.28%	59.13%	53.85%	53.77%	53.83%

6	Wednesday	1-Jun	17,288,250	1,388,640		18,676,890	9,698,018	51.9%
7	Thursday	2-Jun	23,640,750	10,142,765	15,750,000	49,533,515	22,280,200	45.0%
8	Friday	3-Jun	23,640,750	9,161,170	15,750,000	48,551,920	21,979,349	45.3%
9	Saturday	4-Jun	14,628,250	1,388,640		16,016,890	8,215,847	51.3%
10	Sunday	5-Jun	14,628,250	1,388,640		16,016,890	8,917,884	55.7%
11	Monday	6-Jun	23,640,750	9,719,354	15,750,000	49,110,104	25,003,859	50.9%
12	Tuesday	7-Jun	23,640,750	9,230,943	15,750,000	48,621,693	25,905,564	53.3%
13	Wednesday	8-Jun	23,640,750	9,928,673	15,750,000	49,319,423	25,056,088	50.8%
14	Thursday	9-Jun	23,640,750	10,544,133	18,000,000	52,184,883	26,597,140	51.0%
15	Friday	10-Jun	23,640,750	9,751,854	18,000,000	51,392,604	26,841,640	52.2%
16	Saturday	11-Jun	14,628,250	1,388,640		16,016,890	8,451,640	52.8%
17	Sunday	12-Jun	14,628,250	1,388,640		16,016,890	8,332,976	52.0%
18	Monday	13-Jun	23,640,750	9,161,170	18,000,000	50,801,920	27,522,579	54.2%
19	Tuesday	14-Jun	23,640,750	10,533,676	18,000,000	52,174,426	27,717,838	53.1%
20	Wednesday	15-Jun	23,640,750	9,789,127	18,000,000	51,429,877	27,605,623	53.7%			0	0	0
21	Thursday	16-Jun	23,640,750	9,300,716	18,000,000	50,941,466	27,865,510	54.7%		246,527,902	534,434,938	823,269,238	994,124,910
22	Friday	17-Jun	23,640,750	9,370,489	18,000,000	51,011,239	27,126,070	53.2%		246,527,902	534,434,938	823,269,238	994,124,910
23	Saturday	18-Jun	14,628,250	1,388,640		16,016,890	8,761,043	54.7%
24	Sunday	19-Jun	14,628,250	1,388,640		16,016,890	8,436,300	52.7%
25	Monday	20-Jun	23,640,750	10,207,765	18,000,000	51,848,515	27,694,516	53.4%
26	Tuesday	21-Jun	23,640,750	9,928,673	18,000,000	51,569,423	43,301,820	84.0%
27	Wednesday	22-Jun	23,640,750	10,142,765	18,000,000	51,783,515	27,456,890	53.0%
28	Thursday	23-Jun	23,640,750	9,984,640	18,000,000	51,625,390	27,138,220	52.6%
29	Friday	24-Jun	23,640,750	9,789,127	18,000,000	51,429,877	28,643,250	55.7%
30	Saturday	25-Jun	14,628,250	1,388,640		16,016,890	8,772,510	54.8%
31	Sunday	26-Jun	14,628,250	1,388,640		16,016,890	8,442,350	52.7%
32	Monday	27-Jun	23,640,750	9,230,943	18,000,000	50,871,693	26,994,320	53.1%
33	Tuesday	28-Jun	23,640,750	9,928,673	18,000,000	51,569,423	28,123,087	54.5%
34	Wednesday	29-Jun	23,640,750	10,544,133	18,000,000	52,184,883	28,123,087	53.9%
35	Thursday	30-Jun	23,640,750	10,544,133	18,000,000	52,184,883	28,123,087	53.9%
36
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