Target Tele.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1												-

2	LOB	SPV	Actual Day		Real Target	Achievement	Ach%	Shortage	Target Harian	Acc	Target Prospect	Min Acc	Target Kunjungan	Pencapaian seharusnya	Week 2	%	RR
3	KMOB	Fandi	21.0	0.50	19,800,000,000	12,434,791,251	62.80%	(7,365,208,749)	(7,365,208,749)	(67)	(13,391,288,635)	(26)	- 9,206,510,936	20,790,000,000	10,350,000,000	120%	59.81%
4	KMOB	Tiwi	21.0	0.50	19,800,000,000	11,544,964,337	58.31%	(8,255,035,663)	(8,255,035,663)	(75)	(15,009,155,751)	(26)	- 10,318,794,579	20,790,000,000	10,350,000,000	112%	55.53%
5	KMOB				39,600,000,000	23,979,755,588	60.6%	(15,620,244,412)	(1,007,757,704)	(9)	(1,832,286,735)	(26)	- 1,259,697,130	10,890,000,000	20,700,000,000	116%	58%
6
7	LOB	SPV	Actual Day		Real Target	Achievement	Ach%	Shortage	Target Harian		Min Closing	Min Acc	Target Ke Cabang	Pencapaian seharusnya	Week 3	%	RR
8	KMB	Meylan	21.0	0.14	4,545,450,000	3,947,093,500	86.84%	(598,356,500)	(598,356,500)	(5)	(1,087,920,909)	(26)	- 747,945,625	4,772,722,500	2,376,030,682	166%	82.70%
9	KMB	Rofiq	21.0	0.14	4,545,450,000	3,328,549,500	73.23%	(1,216,900,500)	(1,216,900,500)	(11)	(2,212,546,364)	(26)	- 1,521,125,625	4,772,722,500	2,376,030,682	140%	69.74%
10	KMB	Reza	21.0	0.12	4,000,000,000	2,611,162,000	65.28%	(1,388,838,000)	(1,388,838,000)	(13)	(2,525,160,000)	(26)	- 1,736,047,500	4,200,000,000	2,090,909,091	125%	62.17%
11	KMB	Denny	21.0	0.12	4,000,000,000	2,162,128,000	54.05%	(1,837,872,000)	(1,837,872,000)	(17)	(3,341,585,455)	(26)	- 2,297,340,000	4,200,000,000	2,090,909,091	103%	51.48%
12	KMB	Yuni	21.0	0.17	5,636,350,000	3,832,258,500	67.99%	(1,804,091,500)	(1,804,091,500)	(16)	(3,280,166,364)	(26)	- 2,255,114,375	5,918,167,500	2,946,273,864	130%	64.75%
13	KMB	Indah	21.0	0.16	5,244,750,000	3,162,278,500	60.29%	(2,082,471,500)	(2,082,471,500)	(19)	(3,786,311,818)	(26)	- 2,603,089,375	5,506,987,500	2,741,573,864	115%	57.42%
14	KMB	Ani	21.0	0.16	5,244,750,000	2,664,093,500	50.80%	(2,580,656,500)	(2,580,656,500)	(23)	(4,692,102,727)	(26)	- 3,225,820,625	5,506,987,500	2,741,573,864	97%	48.38%
15	KMB		21.0		33,216,750,000	21,707,563,500	65.4%	(6,846,058,500)	(6,846,058,500)	(62)	(12,447,379,091)	(130)	(8,557,573,125)	23,863,612,500	11,880,153,409		62.24%
16
17	LOB	SPV	Actual Day		Real Target	Achievement	Ach%	Shortage	Target Harian		Min Closing	Min Acc	Target Ke Cabang	Pencapaian seharusnya	Week 3	%	RR
18	WG	Dian	21.0	0.60	500		0.00%	(500)	(500)	(0)	(909)	(26)	- 625	525	261	0%	0.00%
19	WG	Teti	21.0	0.40	330		0.00%	(330)	(330)	(0)	(600)	(26)	- 413	347	173	0%	0.00%
20	WG		21.0		830	-	0.00%	(830)	(830)	(0)	(1,509)	(52)	(1,038)	872	434		0.00%
21
22
32														Battle SPV
33						KMOB	KMB	WG
34		KMOB	1M/SPV		Pencapaian seharusnya	1,976,470,588	43	37						Yuni - Meylan
35		KMB	200 ambil		monitoring productivity									Indah - Rofiq - Ani
36		WG	25											Denny - Reza
37			20		end of 10, 17, 24									Fandi - Tiwi
38					5 orang - orang itu aja	752,941,176	752,941,176							Dian - Maisah (110%)
39					50% 1 team libur
40					65% 1 team libur									Kalau sampai akhir bulan presentase nya terkecil wajib kasih barang ke SPV yang menang
41					75% 1 team libur									Harga barang minimal 100K
42
43					2w
44					12	45	2000000000		15	666,666,667				012025_KMB G_Supreme 4
45					7-11	40	1600000000		13.33333333	533,333,333				012025_KMB G_Supreme 3
46					4-6	35	1600000000	40	11.66666667	533,333,333	13			012025_KMB G_Supreme 1
47					1-3	30	1400000000	35	10	466,666,667	12			012025_KMB G_Supreme 2
48					0	30	1400000000	30	10	466,666,667	10			012025_KMB G_Supreme 7
49														012025_KMB G_Supreme 8
50						2.647058824	117647058.8	0	3	133333333	0			012025_KMB G_Supreme 5
51						2.352941176	94117647.06	0	3	106666667	0			012025_KMB G_Supreme 6
52						2.058823529	94117647.06	2.352941176	2	106666667	3
53						1.764705882	82352941.18	2.058823529	2	93333333	2
54						1.764705882	82352941.18	1.764705882	2	93333333	2
55						0	0	0	0	0	0
56
57					Pulang Jam 4	KMB	KMOB	WG
58					12	43	1,923,529,412
59					7-11	38	1,558,823,529
60					4-6	34	1,558,823,529	38
61					1-3	29	1,376,470,588	34
62					0	29	1,376,470,588	29
63
64					Closing minimal	3	2	4
65
66
67
68						KMB	KMOB	WG
69					Minimal Funding
70					12	3	200,000,000
71					7-11	3	185,000,000				17,080,790,859
72					4-6	2	150,000,000	3			656,953,494.58
73					1-3	1	90,000,000	2
74					0	1	90,000,000	2
75					minimal closing
76					12	0	1	0			KMOB : 450jt dpt bingkisan
77					7-11	0	1	0			WG : 14
78					4-6	0	1	3			10-12 tambahan kocokan
79					1-3	0	1	3
80					0	2	1	3
81
82
83
84
85									22-: 13, 28 : 25
86					Irwansyah	38	3.04	25			LOB	Masa Joint Cat	COUNTA of Masa Joint Cat	12,872,281,500	>=12 bln
87					M Agung Khatami	32	2.56	25					0	11400000	7-11 bln
88					Feronika	26	2.08	25			Total		0	1129	4-6 bln
89					Sherlly Ayuandini Muzaki	26	2.08	25			KMB	<0	28	11.52191327	1-3 bln
90					Citra Aghis Nazella	25	2	25				>12	13		<1 bln
91					Seftia Maelani	24	1.92	25				1-3	26
92					Desi Ratna Sari	23	1.84	25				4-6	19	779
93					Muhammad	22	1.76	25				7-12	9	479
94					Evi Linduwati Siagian	21	1.68	25			KMB Total		95	-253
95					Novita Sari Silaban	21	1.68	25			KMOB	<1	4
96					Debora Graci Kristina Daeli	20	1.6	25				>12	9
97					Muhammad Imam Ardhi	19	1.52	25				1-3	2	54
98					Dahlia Megawati	19	1.52	25				4-6	7
99					Naped Wahyudi	18	1.44	25				7-12	2
100					Fiqh			350			KMOB Total		24
101											WG	<0	13
102									22 : 8, 28 :15			1-3	8
103					Isye Rosiani	17	1.36	15				4-6	3
104					Herin Heryanto Maulana	17	1.36	15				7-12	1
105					Maretha Sastra Marsudi	17	1.36	15			WG Total		25
106					Siska Seftalia Utami	16	1.28	15			Grand Total		144
107					Premilenia Ramadhani Sudarsono	16	1.28	15
108					Daniati Marcelina Tambun	15	1.2	15
109					Syarifah Munawarah	15	1.2	15