Monthly Report Dashboard

Sl No	Inquiry Source	Input Source	Job Created Month	Booking Id	WO Number	Customer Name	Customer Phone	Customer PIC	Product	Unit Model	Serial Number	Hour Meter	Unit Status	Unit Condition	Failure Date	Location	Branch Support	Issue	Function Group	Service Code	Service Type	Job Code	Job Group	Job Description	Creator Group	Status	Status Note	Note	Mechanic Name	Creator Name	Creator Phone	Creator Email	Job Created	First Responce Time	OTW to Site	Arrive On Site	OTW to Site Final	Arrive On Site Final	Back To Office	Arrive in Branch Office	Completed Date	Aging	ART	MTTR	FTF	FRT
5460.0	ADMIN	BRANCH	June	1687249527706	WO23181792	MANDIRI BARA SUKSES, PT	-	-	VCE	EC210D	232107	500	WARRANTY	RUNNING	-	BATURAJA	MUARA ENIM	PM 500 H EC210D SN 232107 PT MBS	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	sampai di office	M. Bimo Tegar Setiawan	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-06-20 15:25	2023-06-20 15:25	2023-06-21 08:16	2023-06-21 13:36	2023-06-21 08:16	2023-06-21 14:06	2023-06-21 13:46	2023-06-21 15:30	2023-06-21 21:32	1104.0	324.0	5.0	YES	0.0
5461.0	ADMIN	BRANCH	June	1687312742761	WOCE181684	JASA TAMBANG , CV.	-	-	VCE	EC210D	252815	780	WARRANTY	RUNNING	-	GEUMPANG	MEDAN	TroubleShooting Fueling System EC210 D SN 252815	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	tiket tertunda karena: 1) Otw to site terkendala dikarenakan pekerjaan sebelumnya ada accident 2) Perjalanan dari kota menuju lokasi sangat jauh.	Joys Alfedro Siregar	Medan Admin	81366256197	medan.sbs@indotruck-utama.co.id	2023-06-21 08:59	2023-06-21 09:01	2023-07-03 08:21	2023-06-30 13:32	2023-07-03 08:21	2023-07-03 08:21	2023-07-03 08:22	2023-07-03 08:22	2023-07-03 08:23	1104.0	13233.0	287.0	YES	2.0
5462.0	ADMIN	BRANCH	June	1687317420839	WOCE181836	ASTON PRIMA RAYA, PT	-	-	VCE	DD100	50947	180	WARRANTY	RUNNING	-	KARAWANG	JAKARTA	Checking parking brake switch burn in DD100 SN. 50947	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	otw	Ismail Fauzi	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-06-21 10:17	2023-06-21 10:17	2023-06-23 09:34	2023-06-23 11:00	2023-06-23 09:34	2023-06-23 11:00	2023-06-23 15:42	2023-06-28 14:28	2023-06-28 14:29	1103.0	2923.0	53.0	YES	0.0
5463.0	BRANCH	BRANCH	June	1687319247075	WO23180720	SIMASSAWIT ALIANTAN PT	-	-	SDLG	G9138	600440	0	NON WARRANTY	STANDBY	-	NANGA TAYAP	PONTIANAK	troubleshooting hydraulic	ENGINE	REPAIR	RE-DO	-	-	-	LEADER	COMPLETED	COMPLETED	back to office	Doni Ardiansyah	Ferlya Juliza Admin Pontianak	081545464290	ferlyajulizaa@gmail.com	2023-06-21 10:47	2023-06-21 10:47	2023-06-21 10:47	2023-06-22 21:08	2023-06-21 10:47	2023-06-22 21:08	2023-06-23 08:45	2023-06-26 08:27	2023-06-26 08:28	1103.0	2061.0	45.0	NO	0.0
5464.0	ADMIN	BRANCH	June	1687319357213	WO23181301	HASLUN HAMADO	-	-	SDLG	E690F	600952	560	WARRANTY	RUNNING	-	PARIGI	PALU	FREE SERVICE & PART 500HM SN600952 E690F	ENGINE	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	tiba di kantor palu	Ahmad Jafar M	Palu Admin	81271778109	palu.sbs@indotruck-utama.co.id	2023-06-21 10:49	2023-06-21 10:49	2023-06-21 10:50	2023-06-21 12:04	2023-06-21 10:50	2023-06-21 12:04	2023-06-21 13:54	2023-06-21 14:36	2023-06-22 09:40	1103.0	75.0	3.0	YES	0.0
5465.0	MECHANIC	MECHANIC	June	1687331757634	23181623	BUKIT ASAM ( Persero ) TBK., PT	-	-	VCE	EC210D	284488	22534.5	NON WARRANTY	STANDBY	2023-06-21 00:00:00.0000000	pit 2 PT BA	MUARA ENIM	pm service 22.500 hm	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	RFU	Muhammad Akhyar Alfarizi	Muhammad Akhyar Alfarizi	085878305740	akhyaralfarizi12@gmail.com	2023-06-21 14:15	-	2023-06-21 14:16	2023-06-21 14:16	2023-06-21 14:16	2023-06-21 14:16	2023-06-21 16:30	2023-06-23 19:06	2023-06-23 19:07	1103.0	1.0	2.0	YES	-
5466.0	ADMIN	BRANCH	June	1687336407302	WO23181878	ULIMA NITRA, PT	-	-	VCE	EC480DL	284807	1750	WARRANTY	RUNNING	-	KKA	MUARA ENIM	PM service 1750 jam AB286 SN 284807 UN KKA	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	sampai kantor jam 17.00	M. Bimo Tegar Setiawan	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-06-21 15:33	2023-06-21 15:34	2023-06-22 09:08	2023-06-22 15:16	2023-06-22 09:08	2023-06-22 15:16	2023-06-22 16:22	2023-06-22 20:03	2023-06-24 15:54	1103.0	387.0	7.0	YES	1.0
5467.0	ADMIN	BRANCH	June	1687338252852	WO23180403	INDOTRUCK UTAMA, PT.	-	-	VCE	SD110	059461	3	STOK	STANDBY	2023-06-21 00:00:00.0000000	Balikpapan	BALIKPAPAN	Pre Delivery Inspect SD110 SN59461	ETC	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	p	earlyana pamilu	Balikpapan Admin	81331838430	balikpapan.sbs@indotruck-utama.co.id	2023-06-21 16:04	2023-06-21 16:04	2023-06-21 16:05	2023-06-21 16:05	2023-06-21 16:05	2023-06-21 16:05	2023-06-24 12:14	2023-06-24 12:14	2023-06-24 12:14	1103.0	1.0	68.0	YES	0.0
5468.0	ADMIN	BRANCH	June	1687338488415	WOCE180404	INDONESIA PRATAMA, PT	-	-	VCE	A40G	324672	360	WARRANTY	BREAKDOWN	2023-06-21 00:00:00.0000000	Tabang	BALIKPAPAN	Problem Front Diff Noise A40G SN324672 HM360 PTIP	BRAKE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	complated campaign	Chandra Wijaya S	Balikpapan Admin	81331838430	balikpapan.sbs@indotruck-utama.co.id	2023-06-21 16:08	2023-06-21 16:08	2023-06-21 16:08	2023-06-28 09:27	2023-06-21 16:08	2023-06-28 09:27	2023-06-30 18:30	2023-06-30 18:32	2023-06-30 18:32	1103.0	9680.0	218.0	YES	0.0
5469.0	ADMIN	BRANCH	June	1687393173846	WO23181949	CELLO KARYA PRATAMA, PT.	-	-	VCE	SD110	59174	266	WARRANTY	RUNNING	-	MOROWALI	PALU	HM MATI	ELECTRICAL	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	tiba di kantor	Marcel Kelvin	Palu Admin	81271778109	palu.sbs@indotruck-utama.co.id	2023-06-22 07:19	2023-06-22 07:19	2023-06-22 07:22	2023-06-22 13:58	2023-06-22 07:22	2023-06-22 13:58	2023-06-23 18:33	2023-06-25 21:19	2023-06-26 08:32	1103.0	399.0	35.0	YES	0.0