Founded in 1936 with a single tractor-trailer, Huffman Trucking (Huffman), a national transportation company, is located in Cleveland OH. Today, Huffman has over 1,400 employees, 800 tractors, expected revenue to surpass $600,000,000 and is still privately held. Huffman has hubs located in Los Angeles, CA, St. Louis, MO, Bayonne, NJ with the central maintenance facility located in Cleveland OH. Their working contracts are primarily with the US Government, automotive parts industry, electronic consumer products, raw materials, and any special customer accommodations.
Huffman’s vision is to become a model company to its stockholders, employees, customers, and stakeholders, while the mission is to be a profitable, growing, adaptive company in an intensely competitive logistical services business environment.
While Huffman Trucking has stayed on the leading edge of technology in most departments, one area still lacks in automation. Huffman has continually overlooked the automation of the fleet maintenance records and put this project on the bottom of the priority list for far too long. Now that most of Huffman’s trucks are between 10 and 18 years-old, mechanical breakdowns are occurring more frequently.
Maintenance costs have soared recently and based on the lack of information available, lost paperwork and receipts, and misfiled maintenance documentation, senior management has finally made the decision to take action. “Pen and paper” record keeping is no longer making the grade here at Huffman Trucking. The maintenance facility located in Cleveland OH needs to adopt automation and the need for a Fleet Truck Maintenance Database Management System has now become “top priority.”
Our recommended solution for the manually managed maintenance issue is a relational database, specifically Microsoft Access (Access). Access will house all the maintenance data tables for Huffman’s trucks and trailers, eliminating the need for manual management. Microsoft Access has added security options, the ability to create customized forms and reports, and database redundancy. This product also allows quick and easy methods to access data via graphical user interfaces allowing users with little or no computer skills to modify, add, or browse the database management system. Another reason for selecting, Microsoft Access is the easy to use queries and reports.
The benefits received by automating the fleet maintenance records will have numerous impacts on the entire organization. Some of the most obvious benefits will be that drivers will no longer need to find paperwork to determine when routine maintenance is required, accounting can forecast costs more accurately, and management will be able to assess vehicle needs, such as estimating when new equipment is required and when a tractor or trailer needs to be retired. Uniformity is another benefit. Today each facility creates individual reports. With the installation of the database, report...