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
36026.0	ADMIN	BRANCH	December	1767172591522	WOCE253080	VOLVO CONSTRUCTION EQUIPMENT AND SERVICE INDONESIA, PT	+62 811-3111-0411	Pak PETRUS	VCE	A60H	320738	10570	NON WARRANTY	RUNNING	2025-12-31 00:00:00.0000000	POBOYA	PALU	Replace SPrit level A60H TD9178 SN320738	BRAKE	REPAIR	WARRANTY	RNI	Remove & Install	Removing and installing specific components or parts	LEADER	COMPLETED	-	-	Muhammad Gesit Amanu	Palu Admin	81271778109	palu.sbs@indotruck-utama.co.id	2025-12-31 16:16	2025-12-31 16:16	2025-12-31 16:18	2026-01-01 16:35	2025-12-31 16:19	2026-01-01 16:35	2026-01-04 17:59	2026-01-04 18:00	2026-02-06 11:32	169.0	1459.0	97.0	YES
36027.0	ADMIN	BRANCH	December	1767174144947	WO25252194	DAMRI, PT	-	-	VB	B11R	214402	-	NON WARRANTY	STANDBY	2025-12-31 00:00:00.0000000	MALANG	SURABAYA	Engine Low Power	ENGINE	INSPECTION	FIELD CALL/EXTERNAL	TS	Troubleshoot	Checking system due to errors or abnormal conditions	LEADER	COMPLETED	-	-	Reynaldi Gilang Prayoga	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2025-12-31 16:42	2025-12-31 16:42	2026-01-01 09:10	2026-01-01 09:33	2026-01-01 09:10	2026-01-01 09:33	2026-01-01 12:20	2026-01-01 12:54	2026-01-08 13:59	169.0	1011.0	19.0	YES
36028.0	ADMIN	BRANCH	December	1767174453664	WO25252249	SGN JAYA GEMILANG, PT	-	-	VB	B11R-430 6X2	199307	-	NON WARRANTY	STANDBY	2025-12-31 00:00:00.0000000	MALANG	SURABAYA	Troubleshoot Air Suspension	ENGINE	INSPECTION	FIELD CALL/EXTERNAL	TS	Troubleshoot	Checking system due to errors or abnormal conditions	LEADER	COMPLETED	-	-	Faisal Abdul Rosid	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2025-12-31 16:47	2025-12-31 16:47	2026-01-05 09:40	2026-01-05 09:41	2026-01-05 09:40	2026-01-05 09:41	2026-01-05 16:59	2026-01-05 17:00	2026-01-08 13:59	169.0	6774.0	120.0	YES
36029.0	ADMIN	BRANCH	December	1767174622967	WO25252393	KACEBE MURNI TRANSPORT, PT	-	-	VB	B11R	212380	-	NON WARRANTY	STANDBY	2025-12-31 00:00:00.0000000	MALANG	SURABAYA	Overhaul Gearbox	TRANSMISSION	OVERHAUL	FIELD CALL/EXTERNAL	RPR2	Repair, major	Repairing major components, Cylinder head, MCV, etc.	LEADER	COMPLETED	-	-	Faisal Abdul Rosid	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2025-12-31 16:50	2025-12-31 16:50	2026-01-02 13:33	2026-01-02 13:34	2026-01-07 07:56	2026-01-07 07:57	2026-01-07 18:19	2026-01-07 18:20	2026-01-12 10:13	169.0	2684.0	120.0	YES
36030.0	ADMIN	BRANCH	December	1767174828172	WO25253223	TRANS ADIPUTERA LOGISTIK, PT	-	-	VT	FMX48064T	715151	-	NON WARRANTY	STANDBY	2025-12-31 00:00:00.0000000	MOJOKERTO	SURABAYA	Replace Steering Shaft	STEERING	REPAIR	FIELD CALL/EXTERNAL	RPR1	Repair, minor	Repairing small components. Alternator, Compressor, etc.	LEADER	COMPLETED	-	-	Faisal Abdul Rosid	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2025-12-31 16:53	2025-12-31 16:53	2026-01-02 11:05	2026-01-02 11:06	2026-01-02 11:05	2026-01-02 11:06	2026-01-02 16:03	2026-01-02 16:03	2026-01-08 13:58	169.0	2533.0	47.0	YES
36031.0	ADMIN	BRANCH	December	1767175010953	WO25252736	PQ SILICAS INDONESIA, PT	-	-	VT	FM37064T-ISHIFT-AS	334134	-	NON WARRANTY	STANDBY	2025-12-31 00:00:00.0000000	PASURUAN	SURABAYA	Annual Service	ENGINE	INTERNAL SERVICE	FIELD CALL/EXTERNAL	OTH	Other	Performing tasks not listed above	LEADER	COMPLETED	-	-	Nur Riyanto	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2025-12-31 16:56	2025-12-31 16:57	2026-01-05 11:48	2026-01-06 08:44	2026-01-05 11:48	2026-01-06 08:44	2026-01-06 16:59	2026-01-06 19:31	2026-01-08 13:52	169.0	8148.0	144.0	YES
36032.0	ADMIN	BRANCH	December	1767175154842	WO25253093	ANUGERAH MAS, PT	-	-	VB	B11R	213372	-	NON WARRANTY	STANDBY	2025-12-31 00:00:00.0000000	SURABAYA	SURABAYA	Troubleshoot Engine Low Power	ENGINE	INSPECTION	FIELD CALL/EXTERNAL	TS	Troubleshoot	Checking system due to errors or abnormal conditions	LEADER	COMPLETED	-	-	Akhry Maulana Irsyad	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2025-12-31 16:59	2025-12-31 16:59	2025-12-31 17:03	2025-12-31 17:39	2025-12-31 17:03	2025-12-31 17:39	2026-01-01 00:56	2026-01-01 02:09	2026-01-08 13:51	169.0	40.0	7.0	YES
36033.0	ADMIN	BRANCH	December	1767175333576	WO25253204	KACEBE MURNI TRANSPORT, PT	-	-	VB	B11R	217051	-	NON WARRANTY	STANDBY	2025-12-31 00:00:00.0000000	MALANG	SURABAYA	Spooring System Adjust toe in-out	STEERING	REPAIR	FIELD CALL/EXTERNAL	RPR1	Repair, minor	Repairing small components. Alternator, Compressor, etc.	LEADER	COMPLETED	-	-	Aldani Hendi Prasetyo	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2025-12-31 17:02	2025-12-31 17:02	2026-01-06 07:36	-	2026-01-06 07:36	-	2026-01-12 14:26	2026-01-12 14:26	2026-01-13 10:06	169.0	-	285.0	YES
36034.0	ADMIN	BRANCH	December	1767175464771	WO25253205	KACEBE MURNI TRANSPORT, PT	-	-	VB	B11R	213402	-	NON WARRANTY	STANDBY	2025-12-31 00:00:00.0000000	MALANG	SURABAYA	Spooring System Adjust toe in-out	STEERING	REPAIR	FIELD CALL/EXTERNAL	RPR1	Repair, minor	Repairing small components. Alternator, Compressor, etc.	LEADER	COMPLETED	-	-	Aldani Hendi Prasetyo	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2025-12-31 17:04	2025-12-31 17:04	2026-01-06 07:36	2026-01-07 18:23	2026-01-06 07:36	2026-01-07 18:23	2026-01-12 14:25	2026-01-12 14:25	2026-01-13 10:06	169.0	10159.0	285.0	YES
36035.0	ADMIN	BRANCH	December	1767175580863	WO25253208	GUNUNG HARTA, PT	-	-	VB	B11R	220777	-	WARRANTY	STANDBY	2025-12-31 00:00:00.0000000	BALI	SURABAYA	Warranty Sensor	ELECTRICAL	REPAIR	WARRANTY	RPR1	Repair, minor	Repairing small components. Alternator, Compressor, etc.	LEADER	COMPLETED	-	-	Reynaldi Gilang Prayoga	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2025-12-31 17:06	2025-12-31 17:06	2026-01-01 09:02	2026-01-01 09:06	2026-01-01 09:02	2026-01-01 09:06	2026-01-01 10:40	2026-01-01 10:59	2026-01-08 13:50	169.0	961.0	17.0	YES