Proposal: SR-ht-003 for Huffman Trucking Proposal: SR-ht-003 for Huffman Trucking
Huffman Trucking 's central maintenance facility in Cleveland, Ohio and presently has hubs in Los Angeles, California, St. Louis, Missouri, and Bayonne, New Jersey. To effectively manage their business, it is critical that Huffman Trucking can share information regarding vehicles maintenance with each of its hubs, including parts inventory and vendor data.
Huffman Trucking needs a solution that would allow them to share information amongst their various locations. Smith Consulting was engaged to deliver an entity and attribute proposal to Huffman that outlines a database solution. The objective is to bring the proposed database to life and implement a…show more content… Reduced parts and labor overhead connected with inventory and ordering.
Less likely to miss maintenance leading to reduced unscheduled maintenance.
Allow data sharing across Huffman Trucking Corporation.
Standardized record keeping across all of the companies locations
Establishing an environment that will support a new record keeping front-end that can be made available through the intranet website great
There will also be several opportunities that will grow from this project. In the future, analysis of this data will lead to even more improvements in the maintenance program here at Huffman. Opportunities regarding this effort include but are not limited to the following:
Automated parts ordering
Automated settlement with parts vendors
Automated maintenance schedule proposals based on historical trends.
Enable maintenance to be performed in any of Huffman 's hubs regardless of the vehicles home hub location very good.
If this project is not implemented, it will not be possible to automatically share data for each of the trucking hubs. Parts ordering and settlement will continue to be done in an inefficient and decentralized way. Parts inventory will not be able to be shared between hubs and maintenance schedules will be inconsistent between hubs.
Deliverables and Measurement
The required deliverables are Entity Relationship Diagram 's for the