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
4760.0	ADMIN	BRANCH	May	1685502789409	WO23180047	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX44064R	894956	3279	NON WARRANTY	RUNNING	-	PENDINGIN	SAMARINDA	SERVICE 250 HRS VT 076	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	ps250 complete	Tulus Setrio	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-05-31 10:13	2023-05-31 10:13	2023-05-31 10:14	2023-05-31 11:56	2023-05-31 10:14	2023-05-31 11:56	2023-05-31 16:23	2023-06-02 09:02	2023-06-02 09:07	1124.0	104.0	6.0	YES	0.0
4761.0	ADMIN	BRANCH	May	1685328946206	WO23179648	MAKMUR ALAM SEIWAMPU, PT	-	-	SDLG	L956F	624515	5	NON WARRANTY	RUNNING	-	BINJAI	MEDAN	Mandatory Service 100 Hours Unit L956 F	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Completed	Ferdian Dinata	Medan Admin	81366256197	medan.sbs@indotruck-utama.co.id	2023-05-29 09:55	2023-05-29 09:56	2023-05-29 18:43	2023-05-29 21:05	2023-05-29 18:43	2023-05-29 21:05	2023-05-30 10:37	2023-05-30 14:09	2023-05-30 14:09	1126.0	670.0	24.0	YES	0.0
4762.0	ADMIN	BRANCH	May	1685329241647	WO23179913	BONGKOTAN JATI UTAMA, PT.	-	-	VB	B11R	YV3T2T429LA199263	-	NON WARRANTY	RUNNING	-	JEPARA	SEMARANG	YV3T2T429LA199263 WO23179913 T/S ELECTRICAL SYSTEM VB B11R VB BONGKOTAN JATI UTAMA, PT. 2696 ITU-000009727 SRWE Created Triyono Smg 5/29/2023 9.00	ELECTRICAL	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Semarang Admin	Semarang Admin	82354650320	semarang.sbs@indotruck-utama.co.id	2023-05-29 10:00	2023-05-29 10:00	2023-05-29 10:00	2023-05-29 10:01	2023-05-29 10:00	2023-05-29 10:01	2023-05-30 17:09	2023-05-30 17:09	2023-05-30 17:10	1126.0	0.0	31.0	YES	0.0
4763.0	ADMIN	BRANCH	May	1685329867345	WO23179914	INDOTRUCK UTAMA, PT.	-	-	VT	FMX40064R	B408070	169	WARRANTY	STANDBY	-	AMGA - CIKARANG	JAKARTA	Replace engine cooling fan, warranty. Loc; AMGA - Cikarang	ENGINE	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	job done	Eko Suharyanto	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-05-29 10:11	2023-05-29 10:11	2023-05-29 12:05	2023-05-29 19:07	2023-05-29 12:05	2023-05-29 19:07	2023-05-29 19:09	2023-05-29 22:10	2023-05-29 22:10	1126.0	536.0	8.0	YES	0.0
4764.0	ADMIN	BRANCH	May	1685330287756	WO23175806	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	898900	4000	NON WARRANTY	RUNNING	-	BATUAH	SAMARINDA	SERVICE 4000 HRS VT072	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	done	Muhammad Ishak	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-05-29 10:18	2023-05-29 10:18	2023-05-29 10:18	2023-05-29 12:38	2023-05-29 10:18	2023-05-29 12:38	2023-05-30 04:01	2023-05-30 06:15	2023-05-30 06:15	1126.0	141.0	17.0	YES	0.0
4765.0	ADMIN	BRANCH	May	1685333924483	WO23179820	AEK TARUM, PT	-	-	SDLG	LG936L	606700	2234	NON WARRANTY	RUNNING	-	MESUJI	PALEMBANG	REPLACE RECOMENDATION PART	ECT	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	arrive office palembang	Edy Nugroho	Palembang Admin	81271778108	palembang.sbs@indotruck-utama.co.id	2023-05-29 11:18	2023-05-29 11:19	2023-05-30 11:11	2023-05-30 14:09	2023-05-30 11:11	2023-05-30 14:09	2023-05-31 08:37	-	2023-06-02 08:55	1126.0	179.0	21.0	YES	0.0
4766.0	ADMIN	BRANCH	May	1685334632322	WO23179925	ALIRAN KETAHUN PERDANA, CV	-	-	SDLG	L956F	WO23179925	255	WARRANTY	RUNNING	2023-05-29 00:00:00.0000000	pelabuhan	BENGKULU	service 250	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	close	Agus Nugroho	Bengkulu Admin	85228555522	bengkulu.sbs@indotruck-utama.co.id	2023-05-29 11:30	2023-05-29 11:30	2023-05-29 14:27	2023-05-29 15:09	2023-05-29 14:27	2023-05-29 15:09	2023-05-29 16:38	2023-05-30 08:23	2023-05-30 08:23	1126.0	219.0	5.0	YES	0.0
4767.0	ADMIN	BRANCH	May	1685336632971	WO23179904	LANGGENG DAYA AGRINDO, PT.	-	-	VCE	A40G	324771	1200	WARRANTY	RUNNING	-	BGG	MUARA ENIM	PM 1200 H AD73 PT LDA	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	Sampai di PT ITU ENIM	Aditya Ryan Saputra	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-05-29 12:03	2023-05-29 14:11	2023-05-31 08:22	2023-05-31 21:26	2023-05-31 08:22	2023-05-31 21:26	2023-06-01 06:24	2023-06-01 07:21	2023-06-01 07:24	1126.0	927.0	24.0	YES	127.0
4768.0	ADMIN	BRANCH	May	1685345076836	WO23179259	MANGGALA USAHA MANUNGGAL, PT	-	-	VCE	TR60	1443	8628	NON WARRANTY	RUNNING	-	TANJUNG LALANG	MUARA ENIM	Engine Low Power	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	arrive in branch office	Dedi Ermanto Pribowo	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-05-29 14:24	2023-05-29 14:24	2023-05-29 14:27	2023-05-29 14:34	2023-05-29 15:42	2023-05-29 14:34	2023-05-29 15:47	2023-05-29 15:48	2023-05-29 15:49	1126.0	9.0	1.0	YES	0.0
4769.0	ADMIN	BRANCH	May	1685345359047	WO23179909	BALIKPAPAN READYMIX, PT	-	-	VCE	EC210D	253389	948	WARRANTY	RUNNING	-	BULURI	PALU	SERVICE 1000HM EC210D SN253389	ENGINE	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	arrive in branch office	Ahmad Jafar M	Palu Admin	81271778109	palu.sbs@indotruck-utama.co.id	2023-05-29 14:29	2023-05-29 14:29	2023-05-29 14:31	2023-05-29 15:28	2023-05-29 14:31	2023-05-29 15:28	2023-05-30 07:27	2023-05-30 07:29	2023-05-30 10:29	1126.0	59.0	16.0	YES	0.0