Using Business Intelligence to Manage Your Fleet Danny Brashear CEM
What is ‘Business Intelligence’ Business Intelligence refers to skills, processes, technologies, applications and practices used to support decision making.
WHAT ARE WE GOING TO COVER What is Business Intelligence How well do you know your Fleet Are you tracking the right data Can you answer all of your customer’s questions Are you educating your customers with Business Intelligence Having information at your finger tips - Dashboard
How well do you know your Fleet Nobody should know your Fleet better then you You want your customers to come to you Some basic information you should know: Average age of your Fleet Average cost (per meter, per class, per asset) Best asset replacement goals Current inventory value Where is your budget dollars being spent Your next projected budget cost per department
Are you tracking the right data Tracking KPI and why Set KPI goals Processes in place to help achieve the goals Educate your staff and customers Monitor the progress of each KPI Run it like a business Priorities change
KPI – Why do I need them? Track your shops performance Show your customers how you’re doing Keep you focused to meet your standards or promises to your customers Provides needed data to write your business plan Gives you the numbers to fight privatization Identifies possible areas for additional training Tell the shop story – ‘Your Scoreboard’
Some KPI to look at Fleet availability to the customer – 90% Shop turn around time – 75% within the same day Direct labor vs in-direct labor – 90% direct PM compliance - 90% complete Scheduled repairs vs non-scheduled repairs – 80% scheduled vs 20% non scheduled Comeback – less than 2% Average age of the fleet – 3-5 years Inventory turns – average of 4 per year
More KPI to look at Utilization per class – varies per class, start with 700-per month Shop turn around time – 75% in the same day CPM (per class) that has more than 10% higher than average Non-scheduled leave – less than 2% Current fully burden labor rate Parts fill rate, when do I stock it Vendor performance meeting their promised deliveries Outstanding warranty claims
REPORT RUNNER In 6.0 there are 145 standard reports where 5.69 had 132 Version 184.108.40.206
NEW REPORTS IN 6.0 118 - Vehicle Auction Report 132 – Meter Per Gallon Exception Report 133 – Cost Per Meter Exception Report 208 – Parts Without a Vendor 209 – Parts Mean Time Between Failure (MTBF) 223 – Part Transactions Detail Report 250 – NAPA Unprocessed Requests 250 – NAPA Total Time From Part Request To Part Issue 319 – Maintenance History By Repair Group And Class 338 – Work Order Delays By Status 403 – Tank Inventory Links 615 – Purge Data Report 615 – Record Creation Audit Report
SOME RECOMMENDED REPORTS Scheduled vs. Non-Scheduled Repairs (326) Average Work Order Completion Time (327) Technician Productivity % (330) Technician Cost to Labor Dollars (331) Customer Returns (335) PM Labor % Comparison (315) Active Work Orders by Shop (311)
Parts Inventory (200) Parts Issued (201 & 201S) Parts Received (204 & 204S) (compare to invoices) Orders Not Received (205) Parts Surplus (218) Parts Obsolescence (219) Inventory Movement (222) SOME RECOMMENDED REPORTS
Answer all of your customer’s questions If not, ask questions Find out why they need to know How can you help them Can you support your answers Make sure to follow up Have regular customer meetings Bring the numbers, reports, examples, etc. Share your Business Plan and goals This will build good customer relationships
Are you educating your customers with Business Intelligence You want your customers to depend on you Any Fleet information Customer Trust Be customer driven Provide the information they need Get them involved, get their buy in Come to you because they want to not have to Use your Business Plan as a Fleet goal Update yearly
RE-CAP What is Business Intelligence How well do you know your Fleet Are you tracking the right information Can you support your customer needs Educate your customers with Business Intelligence Create and use Business Plan as your Fleet goal Having the right data at your finger tips
Thank you for attending! Danny Brashear CEM email@example.com 800-753-2783 – toll free 757-625-5114 – fax 757-623-1700 ext. 2201 – Direct I hope you enjoy the rest of the FASTER conference!