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
4470.0	ADMIN	BRANCH	May	1684303722956	WO23179282	AINUN	-	-	SDLG	E690F	600948	2043	WARRANTY	BREAKDOWN	-	TIPO-PALU	PALU	INSPECTION UNIT BREAKDOWN E690F SN600948	ENGINE	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	tiba di Kantor	Ahmad Jafar M	Palu Admin	81271778109	palu.sbs@indotruck-utama.co.id	2023-05-17 13:08	2023-05-17 13:09	2023-05-17 13:10	2023-05-17 13:56	2023-05-17 13:10	2023-05-17 13:56	2023-05-18 12:21	2023-05-18 13:41	2023-05-19 07:46	1138.0	48.0	23.0	YES	0.0
4471.0	MECHANIC	MECHANIC	May	1684307900542	CC23178824	BUKIT ASAM ( Persero ) TBK., PT	-	-	VT	FMX40064R-IShift	BB408249	1224	WARRANTY	RUNNING	2023-05-17 00:00:00.0000000	Msf bangko barat	MUARA ENIM	schedule service pm 400 hours DT3010-11	ETC	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	complete and ready	M. Riski Ibrahim	M. Riski Ibrahim	0895610719859	mriskiibrahim999@gmail.com	2023-05-17 14:18	2023-05-17 14:18	2023-05-17 14:34	2023-05-17 14:49	2023-05-17 14:34	2023-05-17 14:49	2023-05-17 16:57	2023-05-18 07:18	2023-05-18 07:18	1138.0	31.0	2.0	YES	0.0
4472.0	MECHANIC	MECHANIC	May	1684312745584	23178877	BUKIT ASAM ( Persero ) TBK., PT	-	-	VCE	EC480DL	275473	-	NON WARRANTY	BREAKDOWN	2023-05-17 00:00:00.0000000	MSF Bangko	MUARA ENIM	• PM 21.750 hours • Replace cyl boom RH • Reseal cyl boom LH	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	breakdown continue install cyl boom RH LH	Muhammad Akhyar Alfarizi	Muhammad Akhyar Alfarizi	085878305740	akhyaralfarizi12@gmail.com	2023-05-17 15:39	2023-05-17 15:39	2023-05-17 15:39	2023-05-17 15:40	2023-05-17 15:39	2023-05-17 15:40	2023-05-17 23:07	2023-05-17 23:07	2023-05-17 23:07	1138.0	1.0	7.0	NO	0.0
4473.0	ADMIN	BRANCH	May	1684383233048	WOCE179328	PRIMA SARANA GEMILANG, PT	-	-	VCE	EC950E	370152	5809	WARRANTY	BREAKDOWN	2023-05-18 00:00:00.0000000	Muara Teweh, Kalimantan Tengah	MUARA TEWEH	ENGINE LOW POWER	ENGINE	OTHER	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	Unit RFU	ade Putra	Muara Teweh Admin	81366256198	muarateweh.sbs@indotruck-utama.co.id	2023-05-18 11:13	2023-05-18 11:14	2023-05-21 09:32	2023-05-21 09:32	2023-05-21 09:32	2023-05-21 09:32	2023-05-21 09:33	2023-05-21 09:33	2023-05-21 09:33	1137.0	4219.0	70.0	YES	1.0
4474.0	MECHANIC	MECHANIC	May	1684400718028	WO23178960	KARYA SIKUI ABADI, CV	-	-	SDLG	E6210F	609326	500	WARRANTY	RUNNING	2023-05-18 00:00:00.0000000	balai	PONTIANAK	service 500 HM	ETC	INTERNAL SERVICE	INTERNAL	-	-	-	NON LEADER	COMPLETED	COMPLETED	ARRIVED	Dian Sigit Purwito	Dian Sigit Purwito	085210531886	chindyrizky65@gmail.com	2023-05-18 16:05	2023-05-18 16:08	2023-05-18 16:08	2023-05-18 16:09	2023-05-18 16:08	2023-05-18 16:09	2023-05-18 16:10	2023-05-19 12:53	2023-05-22 09:16	1137.0	4.0	0.0	YES	3.0
4475.0	MECHANIC	MECHANIC	May	1684454954490	.	HILLCONJAYA SAKTI, PT	-	-	VCE	R60D	111029	-	NON WARRANTY	BREAKDOWN	2023-05-19 00:00:00.0000000	Kotabaru	BANJARMASIN	Replace Floating Seal Hub & Replace Hoist RH	BRAKE	REPAIR	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	.	Widianto	Widianto	085705256615	widi10anto@gmail.com	2023-05-19 07:09	2023-05-19 07:09	2023-05-19 07:09	2023-05-19 07:09	2023-05-19 07:09	2023-05-19 07:09	2023-05-22 09:17	2023-05-22 09:17	2023-05-22 09:17	1137.0	1.0	74.0	YES	0.0
4476.0	MECHANIC	MECHANIC	May	1684458981399	CC23178832	BUKIT ASAM ( Persero ) TBK., PT	-	-	VT	FMX40064R-IShift	AA302864	2836	WARRANTY	RUNNING	2023-05-19 00:00:00.0000000	Msf Bangko barat	MUARA ENIM	Schedule service pm400 hours DT 3010-06	ETC	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	Complete and Ready	M. Riski Ibrahim	M. Riski Ibrahim	0895610719859	mriskiibrahim999@gmail.com	2023-05-19 08:16	2023-05-19 08:18	2023-05-19 08:33	2023-05-19 08:46	2023-05-19 08:33	2023-05-19 08:46	2023-05-19 11:07	2023-05-19 12:35	2023-05-19 12:44	1137.0	30.0	2.0	YES	1.0
4477.0	MECHANIC	MECHANIC	May	1684460099492	CC23178832	BUKIT ASAM ( Persero ) TBK., PT	-	-	VT	FMX40064R-IShift	AA302864	2863	WARRANTY	RUNNING	2023-05-19 00:00:00.0000000	Bangko Barat, Muara Enim	MUARA ENIM	Schedule service 400 hours DT 3010-06	ETC	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	RFU	Muhammad Zohran	Muhammad Zohran	082307126013	muhzohran@gmail.com	2023-05-19 08:34	2023-05-19 08:35	2023-05-19 10:23	2023-05-19 12:35	2023-05-19 10:23	2023-05-19 12:35	2023-05-19 14:01	2023-05-19 14:14	2023-05-20 07:45	1137.0	240.0	5.0	YES	0.0
4478.0	ADMIN	BRANCH	May	1684461976091	WO23179317	BINTANG UTARA PUTRA, PT	-	-	VB	B11R	A208557	111404	WARRANTY	RUNNING	-	MEDAN	MEDAN	Engine blowby Unit B11R SN A208557	ENGINE	REPAIR	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	completed	Didik Choiril	Medan Admin	81366256197	medan.sbs@indotruck-utama.co.id	2023-05-19 09:06	2023-05-19 09:06	2023-05-19 10:05	2023-05-20 17:54	2023-05-19 10:05	2023-05-20 17:54	2023-05-20 20:22	2023-05-21 08:31	2023-05-21 08:31	1136.0	1968.0	35.0	YES	0.0
4479.0	ADMIN	BRANCH	May	1684462570678	WO23178591	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	898876	4750	NON WARRANTY	RUNNING	-	BATUAH	SAMARINDA	SERVICE 250 HRS VT 071	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	done	Muhammad Ishak	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-05-19 09:16	2023-05-19 09:16	2023-05-19 09:16	2023-05-19 11:17	2023-05-19 09:16	2023-05-19 11:17	2023-05-19 17:18	2023-05-19 20:52	2023-05-19 20:52	1136.0	121.0	8.0	YES	0.0