NAME
DBM 502
University of Phoenix
Benefits of Fleet Management Data Integration
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
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