Company
Huffman Trucking is a privately owned transportation company that has been in business for 60 years. The company has grown into a multi million-dollar company with over 1,400 employees and hundreds of vehicles. Huffman Trucking needs a better way to track the maintenance on their fleet of tractors, trailer and the roll-on/roll-offs. The fleet has to undergo periodic maintenance.
Plan
Putting the equipment's maintenance history, the parts used and vendor information into one database will save Huffman Trucking time and money. The database can include parts inventory information, parts catalogue information, the vendors used and their associated information, and parts purchasing history. The database will include all the maintenance history on each piece of equipment, such as the maintenance of the equipment itself, tire maintenance, the type of maintenance and the maintenance work orders.
Conclusion
Building a database saves money on maintenance by reducing redundant information and improving record keeping. Both the service and accounting departments will be able to utilize this database to keep track of parts purchases and costs. Having all the information in one central database would allow the diverse facilities to use the database. This type of centralization would bring more accuracy in Huffman Trucking's record keeping and would save money, time and manpower.
Huffman Trucking Fleet Maintenance Database Solution
Introduction
Huffman Trucking is a privately held national transportation company with just under 1,400 employees and facilities across the United States. Huffman Trucking has benefited from a relationship with US Government that started in the late 1930's. During the Second World War, shipping of materiel between manufacturers and port cities increased business to the point that Huffman was eventually able to purchase and absorb several other trucking companies (http://aapd.phoenix.edu/CIST/VIP).
Huffman Trucking has recently hired a consultant company, Smith Systems Consulting, to design a database that will enable Huffman Trucking to better organize and track the truck maintenance for their fleet. Smith Systems Consulting has done an analysis of Huffman Trucking to develop a basic plan for integrating information into a database. Entities and attributes have been defined by Smith Systems, but the relationships and tables of the database still need to be defined.
Smith Systems Consulting has identified eleven entities which will be included in the database. These are: Tire Maintenance, Maintenance Descriptions, Vehicle Types, Vehicles, Maintenance Work Order, Parts Inventory Add To Stores, Parts Inventory Issues, Parts Catalogue, Vendors, Parts Purchasing History and Vehicle Maintenance. We will describe the entities, their attributes and the relationships among them in relation to the business needs of Huffman Trucking.
...to deal with inbound and outbound logistics, one that is made up mostly of the personnel from outbound logistics. These professionals deal with the second core competency of Deere, logistics, separate from the manufacturing of tractors and lawnmowers. The creation of this team helps eliminate the risk Fedex’s poor performance (managers were not pleased with Fedex’s centralized transportation management service) and need to measure performance of a 3rd part continuously. As a result, performance is self-managed. We expect as the IT system is used to optimize and plan transportation routes amongst inbound and outbound trucks, cost savings will increase more rapidly. We believe internal continuous improvement, leaner logistics operations and synergies amongst all logistics activities will lead to the $69 million goal being met by the third year after implementation.
Thomas Burns is the owner of Burns Auto. Thomas has twelve years experience in the automobile industry and bought the dealerships as a five-year investment. He wants to take on a new method of managing inventories and forecasting sales, especially now that all manufacturers have mandated the "turn and earn" approach. Richard Settle is Burns' Corporate President and Sales Manager. Richard has fifteen years experience in the automobile industry working for a larger company, he acquired the position of senior vice president at that company before coming to work for Thomas. He has since been with Burns for five years and feels that the responsibility of forecasting should be a one-man job so that one man is held accountable. Peter Reardon is a potential consultant Thomas is taking into consideration. John Peterson is the consultant that has helped Richard in the past. Lisa Hopkins is the Corporate Vice President at Burns.
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.”
Trucking has been a relevant career in the United States ever since the 19th century during WWI the army used trucks to transport goods to the soldiers. People in the towns and cities saw they were good transporter so as roads were built and paved more people start owning them. The Interstate Highway System was a big movement for truckers now they could haul there companies goods farther to other cities. The Motor Carrier Act of 1980 helped drivers who went on strike because of the price of gas to run and operate the trucks. Alex Debogorski was a long haul trucker introduced to trucking when he was looking to earn more money to do for his family. As he drove he realized how good the open road looks as the road meet the sky. Now he is on some of CMT’s episodes of Ice Road Truckers, he said If it wasn’t for his parents and wife he wouldn’t have made it. He also open the door for most of the truckers with criminal records. He helped pas the law that states if your drving record is good you can go in for the long haul.
A database management system, or DBMS, gives the user access to their data and helps them transform the data into information. Such database management systems include dBase, Paradox, IMS, and Oracle. These systems allow users to create, update, and extract information from their databases. Compared to a manual filing system, the biggest advantages to a computerized database system are speed, accuracy, and accessibility.
UPS’ core competency is efficient and reliable package delivery. However, over the last two decades, UPS invested heavily in Information Technology to develop its capabilities. With this new technology driven approach UPS managed to integrate UPS and client’s info systems. This business process integration benefitted both by exponentially increasing the business value, also these collaborative Info systems unlocked tremendous potential making UPS the world’s most admired company in the year 2000.
truck-stop station with 5+ employees. Responsible for day-to-day operation ordering, scheduling, training, supervising employees, store image, profit, all controllable expenses, labor, inventory, cash and shortage.
When our country was at war, the military identified the need for trucks. Trucks were very important because it was difficult to find away to transport all the supplies, troops, and food. After WW1, this brought an increase in good roads plus an expanding economy. This helped grow the trucking industry. The 1920’s were the years of innovation. The balloon tires were introduced along with the rail road’s that were established “piggy-back” service. The first mechanically refrigerated van was introduced. In 1925, there were 500,000 miles of hard surface roads in the U.S. In 1926, a fully loaded 2 ton truck was driven from New York to San Francisco in five days.
The United Parcel Service is a global leader in shipping and logistics. UPS was founded in 1907 as the American Messenger Company with a value proposition that still holds true today: best service and lowest rates (UPS History, 2014). After rapid growth and mergers with competition, the company became the United Parcel Service in 1919. Throughout the next decades they continued to broaden their services and horizons. In 1953 they started offering two-day air service to major cities in the United States (UPS History, 2014). Another notable event occurred in 1975 when they obtained authorization to ship freely in all 48 contiguous states. Prior to this, some packages had to be transferred between several carriers before reaching their final destination. (UPS History, 2014) This undoubtedly created challenges in their operations and supply chain. Their ability to overcome this issue is just one example of their determination to be the best shipping company. To compete with some of its largest competitors, UPS started their Next-Day-Air service in 1982. In the late 1980s, they streamlined their air services with the creation of UPS Airlines. This has been an important component of their supply chain, especially with the use of the Computerized Operations Monitoring, Planning and Scheduling System (COMPASS). (UPS History, 2014) During the 1980s UPS also expanded their international services. The 1990s saw more advances in technology as well as services. UPS realized that they were in a strategic position to offer supply chain solutions. The UPS Logistics Group was formed in 1995 with the purpose of providing global supply chain management solutions and consulting services (UPS History, 2014). Over the last decade, UPS has continued to ...
SupplyOn, n.d, Vendor managed inventory at Robert Bosch North America, viewed at 1 May 2014, .
The benefits of work vehicle organization are many because they are the key element to success. Many contractors are always
Today, Information systems have come a long way in creating new services and provided solutions and a better chance for certain issues facing automobile industry. Automobile Industries have taken advantage of this to bring into more desirable and excellent operations, improve value to their products and to their customers, as well as enable new business standard, style and image. In this research paper, we will explore the use of Information Systems in vehicles, the arrangement of Information Systems to sustain business operations of manufacturers, and the effect of doing so on automobile industries.
The business of Smitty’s Lil Hauler remains extremely important and related to the today’s competitive business environment. Jeff Malott must clearly explore the advantages and disadvantages of buying the business of Smitty’s Lil Hauler. The business is essentially successful and diversified; therefore, Jeff Malott seems interested and positi...
Databases are becoming as common in the workplace as the stapler. Businesses use databases to keep track of payroll, vacations, inventory, and a multitude of other taske of which are to vast to mention here. Basically businesses use databases anytime a large amount of data must be stored in such a manor that it can easily be searched, categorized and recalled in different means that can be easily read and understood by the end user. Databases are used extensively where I work. In fact, since Hyperion Solutions is a database and financial intelligence software developing company we produce one. To keep the material within scope I shall narrow the use of databases down to what we use just in the Orlando office of Hyperion Solutions alone.
Information system can replace the previous manual handling operations to save a lot of time and labor costs.