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
4041.0	MECHANIC	MECHANIC	May	1683516604782	-	RIMBA PERKASA UTAMA, PT	-	-	VCE	A40G	324679	1962	Warranty	RUNNING	2023-05-08 00:00:00.0000000	sanga sanga	SAMARINDA	inspection	ELECTRICAL	INSPECTION	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	completed	Arif Sumardianto	Arif Sumardianto	081357952617	arifsumardianto2@gmail.com	2023-05-08 10:30	2023-05-08 10:30	-	2023-05-08 12:43	-	2023-05-08 12:43	2023-05-08 23:25	-	2023-05-08 23:25	1131.0	134.0	12.0	YES	0.0
4042.0	ADMIN	BRANCH	May	1683518223559	WO23178564	DINAS BINA MARGA DAN BINA KONSTRUKSI PROVINSI SUMATERA UTARA	-	-	VCE	EC200D	281255	834	WARRANTY	RUNNING	-	MEDAN	MEDAN	Mandatory Service 500 Hours EC 200 D SN 281255	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	bto	Andrianto	Medan Admin	81366256197	medan.sbs@indotruck-utama.co.id	2023-05-08 10:57	2023-05-08 10:57	2023-05-08 10:59	2023-05-08 13:50	2023-05-08 13:48	2023-05-08 13:50	2023-05-08 17:04	2023-05-09 08:59	2023-05-09 08:59	1131.0	174.0	6.0	YES	0.0
4043.0	ADMIN	BRANCH	May	1683521888841	WO23178571	NAWIR TAREMPO	-	-	VCE	EC210D	283660	-	NON WARRANTY	BREAKDOWN	-	MANOKWARI	SORONG	Inspection unit after accident	ECT	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	arrive in branch office	Service koordinator (Sorong - Nusa tenggara)	Sorong Admin	81240668088	sorong.sbs@indotruck-utama.co.id	2023-05-08 11:58	2023-05-08 11:58	2023-05-10 09:56	2023-05-16 15:44	2023-05-10 09:57	2023-05-16 15:44	2023-05-19 14:44	2023-05-19 14:45	2023-05-23 14:09	1131.0	11746.0	266.0	YES	0.0
4044.0	MECHANIC	MECHANIC	May	1683522187650	23178519	BUKIT ASAM ( Persero ) TBK., PT	-	-	VCE	EC480DL	284487	-	WARRANTY	RUNNING	2023-05-08 00:00:00.0000000	pit 2 PT BA	MUARA ENIM	pm service 2.500 hours	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	PM service 2.500 h Ready for use	Muhammad Akhyar Alfarizi	Muhammad Akhyar Alfarizi	085878305740	akhyaralfarizi12@gmail.com	2023-05-08 12:03	2023-05-08 12:03	2023-05-08 12:04	-	2023-05-08 12:04	-	2023-05-08 15:25	2023-05-08 15:26	2023-05-08 15:28	1130.0	-	3.0	YES	0.0
4045.0	ADMIN	BRANCH	May	1683522413490	WO23178566	SUMBER MITRA JAYA, PT	-	-	SDLG	LG936	-	-	NON WARRANTY	RUNNING	-	PEKALONGAN	SEMARANG	WO23178566 REPAIR & REPLACE ADDITIONAL PARTS BRAKE SYSTEM WL1010/WL9301 OTH 1186 ITU-000008861 SRWE Created Triyono Smg 5/8/2023 60.00	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Semarang Admin	Semarang Admin	82354650320	semarang.sbs@indotruck-utama.co.id	2023-05-08 12:06	2023-05-08 12:10	2023-05-11 09:20	2023-05-11 09:20	2023-05-11 09:20	2023-05-11 09:20	2023-05-11 17:59	2023-05-11 17:59	2023-05-11 18:00	1130.0	4154.0	77.0	YES	3.0
4046.0	ADMIN	BRANCH	May	1683522479835	WO23178576	SUMBER MITRA JAYA, PT	-	-	SDLG	LG936L	-	-	NON WARRANTY	RUNNING	-	PEKALONGAN	SEMARANG	WO23178576 REPLACE WO 21164658 GOH ENGINE WL1010 SDLG 936L OTH 1186 ITU-000008861 SRWE Created Triyono Smg 5/8/2023 139.00	ENGINE	OVERHAUL	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Semarang Admin	Semarang Admin	82354650320	semarang.sbs@indotruck-utama.co.id	2023-05-08 12:07	2023-05-08 12:09	2023-05-11 09:21	2023-05-11 09:21	2023-05-11 09:21	2023-05-11 09:21	2023-05-13 11:09	2023-05-13 11:09	2023-05-13 11:09	1130.0	2.0	49.0	YES	1.0
4047.0	ADMIN	BRANCH	May	1683525065390	WO23178579	MALLOROANG JAYA TRANS, PT	-	-	SDLG	E6210F	609701	10	WARRANTY	RUNNING	2023-05-08 00:00:00.0000000	Malili	MAKASSAR	Commissioning and Field Guidance	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	completed	wahyu sugiono	Makasar Admin	81997982056	makasar.sbs@indotruck-utama.co.id	2023-05-08 12:51	2023-05-08 12:51	2023-05-08 12:54	2023-05-09 06:55	2023-05-08 12:54	2023-05-09 06:55	2023-05-10 07:59	2023-05-11 14:54	2023-05-13 06:38	1130.0	1084.0	43.0	YES	0.0
4048.0	ADMIN	BRANCH	May	1683527593033	WO23178573	MITRA HIJAU LESTARI, PT	-	-	SDLG	E6210F	609359	506	WARRANTY	RUNNING	-	PAKNING	PEKANBARU	Service 500 hours	ECT	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	selesai	BELLIARD SUSANTO	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-05-08 13:33	2023-05-08 13:33	2023-05-08 15:03	2023-05-09 09:16	2023-05-08 15:03	2023-05-09 09:16	2023-05-09 11:45	2023-05-09 16:37	2023-05-10 09:46	1130.0	1183.0	22.0	YES	0.0
4049.0	ADMIN	BRANCH	May	1683533270677	23178584	BENAL AITI BARA PERKASA, PT	-	-	VCE	A40G	324229	3667	NON WARRANTY	BREAKDOWN	-	SAROLANGUN	JAMBI	TROUBLE SHOOTING AC & FUEL SYSTEM	ECT	OTHER	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	job completed tgl 11-05-2023 jam 21.00	Teten Kurniyawan	Jambi Admin	81366256191	jambi.sbs@indotruck-utama.co.id	2023-05-08 15:07	2023-05-08 15:08	2023-05-12 09:59	2023-05-12 10:00	2023-05-12 09:59	2023-05-12 10:00	2023-05-12 10:03	2023-05-12 10:03	2023-05-12 10:04	1130.0	5453.0	90.0	YES	0.0
4050.0	ADMIN	BRANCH	May	1683533904422	WO23178586	INDOTRUCK UTAMA, PT.	-	-	VB	B11R	YV3T2T126PA212318	-	WARRANTY	RUNNING	-	UNGARAN	SEMARANG	YV3T2T126PA212318 WO23178586 ARRIVAL INSPECTION VOLVO BUS B11R VB 9999 ITU-000017849 SRWI-SVC Created Triyono Smg 5/8/2023 8.00	ENGINE	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Semarang Admin	Semarang Admin	82354650320	semarang.sbs@indotruck-utama.co.id	2023-05-08 15:18	2023-05-08 15:18	2023-05-08 15:19	2023-05-08 15:19	2023-05-08 15:19	2023-05-08 15:19	2023-05-09 15:22	2023-05-09 15:22	2023-05-09 15:23	1130.0	1.0	24.0	YES	0.0