Abstract:This project gives the complete information about the company products to the customer requirements. It makes the job of the stock in-charge easy. He encounters for any updates in the information of the products into the database. All the details starting from placing the indent to delivery of the products is being maintained.

This project is having five modules:

1.Details about MS & HSD

            2.Details about Lubricants

3.Details about Customers

4.Details about Fuel used by the company vehicles

             5.Details about Reports

First we will collect all the product’s details. Both MS (petrol) and HSD (diesel) stock information will be collected from underground tanks. We will maintain this information in tables. After updating the stock details we will enter the customer’s Indents into the table. At last we search our stock for the customer’s indents. If stock is available then we will deliver necessary stock (petrol or diesel). While delivering the stock we will charge some charges like License fee, sales tax. And we subtract dealer commission from that amount which is calculated after adding the charges.

While dealing with the Engine oils we have several products. So, based on that product we have to enter the stock details into the table. Then we will enter customer’s Indent into the table. We will check whether particular grade is available are not. If it is available we will deliver.

At last we will maintain a table to store the consuming of our own products for the employee’s vehicles.

SYSTEM ENVIRONMENT

HARDWARE SPECIFICATION

PROCESSOR : INTEL’S PENTIUMIII 550MHZ

RAM : 64 MB

HARD DISK : 10.2GB

FLOPPY DRIVE : 1.44 MB

SOFTWARE SPECIFICATION

            ENVIRONMENT : MICROSOFT WINDOWS 98

BACKEND : MS ACCESS(7.0)

FRONTEND : VISUAL BASIC 5

            REPORT : CRYSTAL REPORTS

CONCLUSION:

In a petroleum company stock in-charge job is very tedious because it is very difficult to know the available stock in filling stations and lubricant products. Because the filling stations will be updated from refinery stations. So it is difficult to the stock in-charge to remember available stock at all filling stations. Company will produce various lubricant products like 2- stroke engine oils, 4-stroke engine oils, chassis greases, bearing greases. So it is not easy to remember all the product details.

This project helps to the stock in-charge and supervisors to know the available stock in the company. So that they can deliver the stock to the required customers without delay.

FUTURE ENHANCEMENTS:

The system may be further updated or modified at will owing to its simple structure. If the company is willing the administrator might add a new module that would allow the customer to login to the petroleum ordering system. Moreover the developed system does not provide any kind of facility for online purchase of petroleum products. If the customer is allowed to access our site then online purchase of petroleum products may be included. Also payments can be made online for the purchase of petroleum products.