Call for Paper - January 2023 Edition
IJCA solicits original research papers for the January 2023 Edition. Last date of manuscript submission is December 20, 2022. Read More

Efficient Scheduling System for a Company’s Dispatch Trucks

Print
PDF
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Year of Publication: 2017
Authors:
M. O. Babatunde, E. A. Adedokun, Ajayi Ore-ofe
10.5120/ijca2017915357

M O Babatunde, E A Adedokun and Ajayi Ore-ofe. Efficient Scheduling System for a Company’s Dispatch Trucks. International Journal of Computer Applications 173(7):13-17, September 2017. BibTeX

@article{10.5120/ijca2017915357,
	author = {M. O. Babatunde and E. A. Adedokun and Ajayi Ore-ofe},
	title = {Efficient Scheduling System for a Company’s Dispatch Trucks},
	journal = {International Journal of Computer Applications},
	issue_date = {September 2017},
	volume = {173},
	number = {7},
	month = {Sep},
	year = {2017},
	issn = {0975-8887},
	pages = {13-17},
	numpages = {5},
	url = {http://www.ijcaonline.org/archives/volume173/number7/28346-2017915357},
	doi = {10.5120/ijca2017915357},
	publisher = {Foundation of Computer Science (FCS), NY, USA},
	address = {New York, USA}
}

Abstract

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.

References

  1. A. Q.-A. Juan A. Vera-Gómez, Carmelo R. García, Raúl Suárez Moreno, Fernando Guerra Hernández, : An Intelligent Parking Management System for Urban Areas. Sensors 2016 vol. 16: pp 4-8,.
  2. "Texas Instruments Incorporated, CC2530 (Rev. B)," Available online: http://www.ti.com/product/CC2530/ technicaldocuments (accessed on 23 April 2017).
  3. M. Geoff, "The 6LoWPAN architecture," In Proceedings of the 4th Workshop on Embedded Networked Sensors, EmNets ’07, Cork, Ireland, pp. 25–26 June 2007.
  4. "SHARP Corporation, GP2Y0D02YK0F," Available online: http://www.sharp.co.jp/products/device/doc/opto/ gp2y0d02yk_e.pdf (accessed on 23 April 2017).
  5. "Contiki-Developers, Contiki 2.6.," Available online: http://contiki.sourceforge.net/docs/2.6/ (accessed on 23 April 2017).
  6. H. L. Jie Tang, Yunbo Cao, and Zhaohui Tang, (2005) : Email data cleaning : In Proceedings of the eleventh ACM SIGKDD international conferenceon Knowledge discovery in data mining KDD '05, vol. ACM, New York, NY, USA, , pp. 489-498.
  7. P. J. R. Leonard Koufman, Vojtech Juhász (2012): Clustering by means of medoids: Full-text search in email archives using social evaluation, attached and linked resource.
  8. R. Tolley, B. J. Turton, "Transport systems, policy and planning: a geographical approach", 2014.
  9. "Smart Task Scheduling for a Truck Company" Available online: http://library.ndsu.edu/.../Smart%20 Task%20Scheduling%20for%20a%20Truck%20Company.pdf (accessed on 23 April 2017).

Keywords

Scheduling, Programming language, Manufacturing, Design, ODBC.