Efficient Scheduling System for a Company’s Dispatch Trucks

This paper presents the design of an efficient scheduling system for a Company’s dispatch truck using Visual Basic as an object oriented programming language; MS SQL server as the database management system. Open Database Connectivity (ODBC) was used to connect the application to the database. SQL DML (Data Manipulation Language) expression has been used to query from the database. Stores in each state of federation have data centers connected to the central database at the factory. A photoelectric sensor is used to detect and count the number of trucks that enters the park at the factory. An update of the number of truck is regularly sent to the stores across the state to inform them about the number of truck remaining for the park to be filled. Once the trucks deliver their products, they return to their various originating states. The database is updated as the number of trucks that has entered the park is reset. Messages are sent to the states whose trucks have not brought products to the factory, informing them of parking space in the factory. As product are delivered the entire process will be repeated. The system ensured an efficient means for scheduling dispatch trucks, so that the required quantity of materials for production were always made available. General Terms Truck Scheduling, Vehicle Communication.