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
5740.0	ADMIN	BRANCH	June	1687766948411	WO23182173	LANGGENG DAYA AGRINDO, PT.	-	-	VCE	A40G	324219	7600	WARRANTY	RUNNING	-	MUARA LAWAI	MUARA ENIM	PM service 7600 jam AD58 SN 324219 LDA	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	sampai di kantor	M. Bimo Tegar Setiawan	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-06-26 15:09	2023-06-26 15:12	2023-06-28 11:41	2023-06-28 12:13	2023-06-28 11:41	2023-06-28 12:13	2023-06-28 19:01	2023-06-28 19:55	2023-06-29 20:22	1098.0	74.0	8.0	YES	3.0
5741.0	ADMIN	BRANCH	June	1687768076643	WO23182187	PAMA PERSADA NUSANTARA, PT	-	-	VCE	A40G	324875	5	WARRANTY	STANDBY	-	PAMA SITE KPC	SANGATTA	COMMISIONING UNIT VOLVO A40G SN.324875	ECT	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Sangatta Admin	Sangatta Admin	82354650329	sangatta.sbs@indotruck-utama.co.id	2023-06-26 15:27	2023-06-26 15:57	2023-06-26 16:10	-	2023-06-26 16:10	-	2023-06-28 08:32	2023-06-28 15:34	2023-06-28 15:34	1098.0	-	41.0	YES	30.0
5742.0	ADMIN	BRANCH	June	1687771670640	WO23182191	HUTAMA KARYA INFRASTRUKTUR PT	-	-	VCE	SD110	58692	4659	NON WARRANTY	RUNNING	-	PRABUMULIH	PALEMBANG	REPLACE INJECTOR	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	READY	Bayu Pradana	Palembang Admin	81271778108	palembang.sbs@indotruck-utama.co.id	2023-06-26 16:27	2023-06-26 16:28	2023-06-27 11:56	2023-06-29 09:10	2023-06-27 11:56	2023-06-29 09:10	2023-06-29 09:11	2023-07-01 15:50	2023-07-01 15:50	1098.0	2715.0	45.0	YES	0.0
5743.0	ADMIN	BRANCH	June	1687788253834	WOSD182180	KOTO ALAM SEJAHTERA, PT	-	-	SDLG	L956F	624559	1678	WARRANTY	BREAKDOWN	-	PANGKALAN	PEKANBARU	Brake problem	BRAKE	REPAIR	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	sampai dikantor	GALIH PERMADI	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-06-26 21:04	2023-06-26 21:04	2023-06-27 08:52	2023-06-27 14:07	2023-06-27 08:52	2023-06-27 14:07	2023-06-27 16:52	2023-06-28 16:07	2023-06-30 11:07	1098.0	1024.0	19.0	YES	0.0
5744.0	ADMIN	BRANCH	June	1687824145195	WO23182230	WAHYU NUGRAHA	-	-	SDLG	E660FL	625948	7	WARRANTY	RUNNING	-	SAUSU	PALU	PDI Unit E660FL SN625948	ECT	OTHER	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	tiba di kantor	Marcel Kelvin	Palu Admin	81271778109	palu.sbs@indotruck-utama.co.id	2023-06-27 07:02	2023-06-27 07:03	2023-06-27 07:04	2023-06-27 11:42	2023-06-27 07:04	2023-06-27 11:42	2023-06-27 13:31	2023-06-27 15:18	2023-06-27 15:19	1098.0	280.0	6.0	YES	0.0
5745.0	ADMIN	BRANCH	June	1687826239825	WO23182215	INDOTRUCK UTAMA, PT.	-	-	SDLG	LG933L	606649	-	WARRANTY	RUNNING	2023-06-27 00:00:00.0000000	Makassar	MAKASSAR	Arrival Inspection Program	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	completed	Rudini	Makasar Admin	81997982056	makasar.sbs@indotruck-utama.co.id	2023-06-27 07:37	2023-06-27 07:37	2023-06-27 08:04	2023-06-27 09:09	2023-06-27 08:04	2023-06-27 09:09	2023-06-27 14:15	2023-06-27 16:06	2023-06-27 17:32	1098.0	92.0	6.0	YES	0.0
5746.0	ADMIN	BRANCH	June	1687828473483	WO23182143	INDOTRUCK UTAMA, PT.	-	-	SDLG	E660FL	625866	6	STOCK	RUNNING	-	PALU	PALU	MAINTENANCE UNIT STOCK E660FL SN625866	ENGINE	OTHER	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	tiba di kantor	Ahmad Jafar M	Palu Admin	81271778109	palu.sbs@indotruck-utama.co.id	2023-06-27 08:14	2023-06-27 08:14	2023-06-27 08:15	2023-06-27 08:27	2023-06-27 08:18	2023-06-27 08:27	2023-06-27 10:46	2023-06-27 15:13	2023-06-28 09:35	1098.0	13.0	2.0	YES	0.0
5747.0	ADMIN	CALL CENTER	June	1687830853307	wo23181277	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FM40084R	898749	5750	NON WARRANTY	RUNNING	-	BATUAH	SAMARINDA	Service 250	ECT	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	done	Muhammad Ishak	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-06-27 08:54	2023-06-27 08:54	2023-06-27 15:15	2023-06-27 17:16	2023-06-27 15:15	2023-06-27 17:16	2023-06-27 22:07	2023-06-28 12:03	2023-06-28 12:04	1098.0	502.0	13.0	YES	0.0
5748.0	MECHANIC	MECHANIC	June	1687831157529	23182154	HUTAMA KARYA INFRASTRUKTUR PT	-	-	VCE	EC210D	282777	5500	NON WARRANTY	RUNNING	2023-06-27 00:00:00.0000000	Banyumas	SEMARANG	PM 500H	ENGINE	OTHER	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	clear	Ahmad Saimin	Ahmad Saimin	081317964331	simon.saimin@gmail.com	2023-06-27 08:59	2023-06-27 18:10	2023-06-27 08:59	2023-06-27 16:52	2023-06-27 08:59	2023-06-27 16:52	2023-06-28 09:50	2023-06-28 15:32	2023-06-28 15:33	1098.0	473.0	24.0	YES	551.0
5749.0	ADMIN	BRANCH	June	1687831903106	WO23182206	KOSTEC PRIMA BAJA, PT	-	-	VT	FH1655064T	A751958	40355	NON WARRANTY	BREAKDOWN	2023-06-27 00:00:00.0000000	Cilegon	CILEGON	FH16-Replace & programming E-ECU	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Job Completed	Pujiyanto	Cilegon Admin	85219742046	cilegon.sbs@indotruck-utama.co.id	2023-06-27 09:11	2023-06-27 09:11	2023-06-27 09:14	2023-06-27 10:35	2023-06-27 09:14	2023-06-28 08:32	2023-06-27 14:50	-	2023-06-28 08:35	1097.0	84.0	5.0	YES	0.0