02. P&Q - Februari 2021 - Google Sheets

	B	C	D	H	I	J	L	M	N	P	Q	R	S	T	U	V
1		SATELIT KARAWANG								Week	I	II	III	IV	V	TOTAL
2	Periode	Feb-2022								Estimasi Sales	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
3		56%	634,513,500	138,555,063	378,528,000	81,000,000				Sales	307,186,646	333,241,594	303,231,358	200,825,117	88,111,848	1,232,596,563
4	Hari	Tanggal	SATELIT KARAWANG					Cost	%	Cost	167,321,555	159,489,135	163,303,006	100,087,489	43,476,225	633,677,410
5	Hari	Tanggal	SPV	JSP	DEHEUS	DANONE	Total	Cost	%	%	54.47%	47.86%	53.85%	49.84%	49.34%	51.41%

6	Tuesday	1-Feb	18,441,500	2,304,775	12,880,000		33,626,275	14,586,182	43.4%
7	Wednesday	2-Feb	29,292,250	9,296,870	14,736,000		53,325,120	22,900,061	42.9%
8	Thursday	3-Feb	26,545,750	9,665,283	14,736,000		50,947,033	56,008,092	109.9%
9	Friday	4-Feb	29,188,500	9,008,232	14,736,000		52,932,732	20,019,338	37.8%
10	Saturday	5-Feb	14,925,750	1,326,820	12,880,000		29,132,570	13,576,289	46.6%
11	Sunday	6-Feb	17,506,250	1,947,275	9,776,000		29,229,525	13,528,303	46.3%
12	Monday	7-Feb	24,463,250	8,669,141	14,736,000	10,125,000	57,993,391	26,703,290	46.0%
13	Tuesday	8-Feb	27,839,750	9,002,983	14,736,000	9,000,000	60,578,733	27,223,823	44.9%
14	Wednesday	9-Feb	23,640,750	9,002,983	14,736,000	7,875,000	55,254,733	27,316,360	49.4%
15	Thursday	10-Feb	27,839,750	9,142,529	14,736,000	4,500,000	56,218,279	24,621,222	43.8%
16	Friday	11-Feb	23,640,750	7,243,888	14,736,000	4,500,000	50,120,638	23,245,846	46.4%
17	Saturday	12-Feb	17,153,500	1,295,002	12,880,000		31,328,502	15,361,875	49.0%
18	Sunday	13-Feb	14,628,250	1,015,910	9,776,000		25,420,160	13,593,143	53.5%
19	Monday	14-Feb	27,839,750	7,244,799	14,736,000	4,500,000	54,320,549	28,126,866	51.8%
20	Tuesday	15-Feb	23,640,750	4,194,572	14,736,000	4,500,000	47,071,322	27,904,851	59.3%		#REF!	#REF!	#REF!	#REF!
21	Wednesday	16-Feb	27,839,750	4,157,299	14,736,000	4,500,000	51,233,049	26,342,524	51.4%		307,186,646	640,428,240	943,659,598	1,144,484,715
22	Thursday	17-Feb	23,640,750	4,534,572	14,736,000	4,500,000	47,411,322	27,971,284	59.0%		#REF!	#REF!	#REF!	#REF!
23	Friday	18-Feb	27,839,750	5,098,210	14,736,000	4,500,000	52,173,960	26,635,455	51.1%
24	Saturday	19-Feb	14,628,250	1,669,904	12,880,000		29,178,154	14,280,388	48.9%
25	Sunday	20-Feb	17,153,500	1,557,275	9,776,000		28,486,775	13,596,637	47.7%
26	Monday	21-Feb	23,640,750	4,800,026	14,736,000	4,500,000	47,676,776	26,571,867	55.7%
27	Tuesday	22-Feb	27,839,750	5,210,029	14,736,000	4,500,000	52,285,779	27,494,449	52.6%
28	Wednesday	23-Feb	23,640,750	5,210,029	14,736,000	4,500,000	48,086,779	27,581,738	57.4%
29	Thursday	24-Feb	27,839,750	5,252,757	14,736,000	4,500,000	52,328,507	24,521,569	46.9%
30	Friday	25-Feb	23,640,750	5,247,302	14,736,000	4,500,000	48,124,052	20,489,733	42.6%
31	Saturday	26-Feb	17,153,500	1,594,548	12,880,000		31,628,048	14,364,550	45.4%
32	Sunday	27-Feb	14,628,250	1,557,275	9,776,000		25,961,525	13,467,855	51.9%
33	Monday	28-Feb	18,441,500	2,304,775	9,776,000		30,522,275	15,643,820	51.3%
34
35
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