Automotive

Manufacturing

Stock Tracking

Problem Statement

Vehicle status’s and locations change on a regular basis through physical movements, route changes and holds applied/released. As the vehicle’s location can change across 5 sites and various parking locations the information is quickly out of date. The location is only as good as when the app was last updated.

 

Process Overview

When a vehicle has been built  leaves the plant for handover, the current site and parking locations is manually updated in the Yard Management System via a report extracted. This provides the team a view of the vehicle status and its last location. Vehicle status’s and locations change on a regular basis through physical movements, route changes and holds applied / released. As the vehicles location can change across 5 sites and various parking locations the information is quickly out of date.

 

Solution

The robot will launch and run the Enquiry report. This will produce an excel document. The robot will filter out sites, dependent on which site the report is currently being run for. The robot will save this as a CSV and import. It is proposed that this process will run 24 hours a day, 7 days a week, every 15 minutes. This will ensure that the team has up-to-date, real-time information on where a vehicle is being stored.