Open AccessDesign of Stock Control System for Petrol Station
Author(s) -
Hnin Yu Yu Win,
Htwe Htwe Pyone,
Thi Thi Soe,
Zarni Sann
Publication year - 2019
Publication title -
international journal of scientific research in science, engineering and technology
Language(s) - English
Resource type - Journals
eISSN - 2395-1990
pISSN - 2394-4099
DOI - 10.32628/ijsrset19634
Subject(s) - stock (firearms) , stock control , stock management , computer science , sql server , inventory control , sql , database , operations research , business , engineering , mechanical engineering , archaeology , plan (archaeology) , history
A stock control system is basically a database; it must keep the up-to-date records of all the stock. Adequate stock must be maintained to supply the customers with their needs and minimum delay. In manual inventory system, the information is difficult to share from one person to another and unexpected difficult is human error. To alleviate these difficulties and to ascertain the exact stock level of a company, this paper presents a design of stock control system on a petrol station using stock levels of inventory system such as reorder level, economic order quantity, and maximum level. To demonstrate the presented system, we apply it to a number of sale data in Lucky 7 petrol station in Mandalay. The stock control system is implemented by C# programming language and SQL server database.