We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy

Benefits of Fleet Management Data Integration Essay Sample

essay
The whole doc is available only for registered users OPEN DOC
  • Pages:
  • Word count: 1029
  • Category: data

Get Full Essay

Get access to this section to get all help you need with your essay and educational issues.

Get Access

Benefits of Fleet Management Data Integration Essay Sample

Abstract

Huffman Trucking maintains extensive vehicle fleet maintenance logs, with data on vehicles, parts, tires, maintenance, warranty, costs and dates of service. Management wants to know whether it would be strategically advisable to integrate this information into their current data warehouse and how to leverage it. Investigation shows that there could be significant benefits in efficiency and cost reduction by this consolidation and the appropriate analysis techniques. Regression analysis is recommended for this data mining, to understand the relationships among independent and dependent variables across large numbers of components and their associated data. Off the shelf software for this purpose was not evaluated, but white papers issued by these companies provided significant data about potential advantages to be gained. The study committee recommends that the data integration and mining be approved for implementation without delay.

Benefits of Fleet Management Data Integration

Huffman Trucking owns extensive fleet truck maintenance information which is not being fully utilized. This data should be mined and analyzed to provide the business intelligence which the company needs to improve efficiencies and fleet performance. Managers need this information about their operations to use in their decision-making.

“All the records in the world won’t do a thing for you if you don’t analyze the data,” says Robert Johnson, fleet management liaison for the National Truck Equipment Association (NTEA). http://www.govengr.com/ArticlesJan06/optimizing.pdf

Regression analysis is recommended for this data mining, to understand the relationships among independent and dependent variables across large amounts of data. For example, the analysis could show the relationship of tire lifetime costs to the frequency of rotation, the vendor and the vehicle type. This same type of analysis could be used to determine the reliability and costs of any of thousands of parts, including the warranty coverage and costs. This could drive a change in vendors, how often the tires are rotated and the inspection of parts – ensuring that proactive maintenance is provided only as often as needed and failures are minimized. Such analysis for a particular part could correlate the quantity on hand required to avoid out of stock issues with the cost savings of quantity purchases. This could be used to determine how often and in what quantity parts are purchased, generating savings in procurement and avoiding excess inventory.

There are operational advantages to be gained by knowing the optimal maintenance intervals for vehicles and using that to reduce downtime and unscheduled repairs. Regression analysis against the fleet maintenance data should provide the organization a new means to objectively measure the effects of planned maintenance to engineer optimal maintenance plans (Allen, 1997). Knowing just how often a particular type of scheduled, or preventative, maintenance is required and ensuring its completion will maximize the useful life of the vehicles.

Corrective maintenance (repairs due to failure), scheduled maintenance and date of service records would be examined for their relationships to costs, usage and vendor. Sub-optimal maintenance schedules can also drive indirect costs in vehicle downtime and unavailability. In addition to scheduled maintenance, running costs (fuel consumption, engine oil consumption, tire costs, etc) are significant expenditures and good targets for full data analysis using control charts and regression techniques. Such operational research techniques can manage the correlation of hundreds to thousands of pieces of equipment, groups, asset types, far more than less robust types of information reporting.

The data can also be used to track warranty, failure rate and return information. Are warranties cost-justified for their coverage of failures? Are certain core parts specific to a vendor prone to failure? Are defective parts returns being handled properly? Too frequent scheduled inspections and maintenance increase labor costs. Poor scheduling can result in fleet support staff being over or under-utilized. Due to the highly skilled personnel involved, there could be significant costs involved in not understanding the best use of their time. The vehicle fleet and its operational support is the major cost driver in this industry.

Optimal management is critical. There has been much written on the different approaches to such data mining as described above. Much is available from the vendors of data management and analysis software, including some customized for fleet management. The company could decide to use one of these packages or utilize in-house personnel to report against the new data in the expanded database. (Oracle, Collective Data) The United States Navy Submarine Maintenance Engineering, Planning and Procurement (SUBMEPP) completed a study in 1962 in which the majority of components analyzed by SUBMEPP did not demonstrate an age and reliability relationship and consequently, many existing time directed component overhauls have been deleted from class maintenance plans, eliminating significant costs and downtime (Allen, 1997).

Regression analysis against Huffman’s fleet maintenance data could discover any relationships in scheduled maintenance and failure rates. Because all data manipulation and analysis have limitations, the literature emphasizes that the construction of the database and the regression analysis reports should involve those who understand the data and the business it represents, to ensure that the results are derived and interpreted correctly. Used correctly, these powerful optimization algorithms can be invaluable. With the implementation of the database and its analysis, management must commit to full use of the results to gain the expected benefits.

Conclusions and Future Study

Huffman Trucking owns the vehicle fleet maintenance data which could be merged into the data warehouse. The potential savings from the analysis is anticipated to far outweigh the costs of the integration and manipulation. Management can use the information provided to strategically reduce fleet costs, minimize downtime and optimize support personnel time and costs.

References
Allen, Timothy M. (1997). U. S. Navy Analysis of Submarine Maintenance Data
and the
Development of Age and Reliability Profiles. Department of the Navy, SUBMEPP,
Portsmouth, NH,
Braeutigam, R. R. (1999). Learning About Transport Costs. J. Gómez-Ibáñez, W. B.Tye, C. Winston (Eds.), Essays in Transportation Economics and Policy: A Handbook in Honor of John R. Meyer. Washington, D.C.: The Brookings Institution.

Collective Data. White Paper (2012). Justifying Fleet Management. www.collectivedata.com
Davenport, Thomas H. Working Knowledge: How Organizations Manage What They Know. Prusak, Laurence. 1998. Harvard Business School Press. Boston, Mass.
Oracle Corporation, Oracle Data Sheet (2009). Oracle Transportation Management. http://www.oracle.com/us/industries/public-sector/021097.pdf

We can write a custom essay

According to Your Specific Requirements

Order an essay

You May Also Find These Documents Helpful

Roles and responsibilities of data users

In order to successfully gather data from the users, conducting an interview must be a good idea. Hence that may insufficient as users may not able to describe everything by themselves as the ideal meaning may not portrays only by words. So that it is better if the user can be observed while they use an interface they currently use which may portrays much information....

Data Handling - ICT

Choice of Problem When asked to think of ideas to base my ICT course work on I came up with the following; * Make over salon * Modelling agency * School health centre * Job centre * A tracing family trees agency I decided on the job centre for a number of reasons; * This idea was original; no one else in my year was...

Estate Agents - Problems of a Paper...

Introduction An estate agent based in a paper-based office comes across a lot of problems. It necessary to solve these problems and try to bring the system of the basic system and improve to be more efficient and more reliable in a working area. The firm is in an area that is equally part urban and part rural. Further more because of this area people...

Database Analysis and Database Design Project -...

Moving Images operates a DVD library. The library has a large number of titles, each title having at least one copy. Each title falls into a specific category some of these are adventure, thriller, fantasy, action or education. (There are others) All titles are loan only to registered members of Moving Images. Information is keep about the members is only personal details including name, address...

The ICT Theory

Data All the data for the new system will have to be collected together. All the names, addresses and phone numbers of all the client's contacts will need to be put together so that it will be easier to input the data to the new system. To collect the data together there will need to be a data sheet designed. One of the client members...

Get Access To The Full Essay
icon
300+
Materials Daily
icon
100,000+ Subjects
2000+ Topics
icon
Free Plagiarism
Checker
icon
All Materials
are Cataloged Well

Sorry, but copying text is forbidden on this website. If you need this or any other sample, we can send it to you via email.

By clicking "SEND", you agree to our terms of service and privacy policy. We'll occasionally send you account related and promo emails.
Sorry, but only registered users have full access

How about getting this access
immediately?

Become a member

Your Answer Is Very Helpful For Us
Thank You A Lot!

logo

Emma Taylor

online

Hi there!
Would you like to get such a paper?
How about getting a customized one?

Couldn't Find What You Looking For?

Get access to our huge knowledge base which is continuously updated

Next Update Will Be About:
14 : 59 : 59
Become a Member