Dealer Management System for Petroleum Refineries
Abstract & Synopsis
Aim:
Dealer Management System is to bring much needed efficiency to dealership operations, department by department, person by person. Whether it may be large dealer group with multiple franchises and locations, even spanning geographic boundaries. This tools help’s to reduce operating costs and will help Dealer to focus on their area of expertise.
Description:
Dealer Management System delivers complete, fully integrated, dealer management systems to dealers across the Geographical location. The full featured, Dealer Management System can save a dealership thousands of dollars a month in support and maintenance, without giving up any important functions. Dealer Management System is the Internet based Application with all of the same features. They include Employee details, sales prospecting, Bank Transaction, service, Balance Sheet, monthly sales details, service tracking, daily sales details, shop detail, accounting and payroll etc.
They can be installed in small dealerships with only a few workstations, as well as large dealerships with multiple franchises and over a hundred users. Dealer Management System is scheduled in six modules which are further categorized according to the requirement, and flexibility of the user.
The first sub-module is New Entry module, under which we have New Item, New Credit Customer, New Employee and New Expenses as sub modules. Through New Item sub-module the user will add new item name to be added and its purchases rate and cost rate. Through New Credit Customer sub-module the information of Customer such as customer name, company name, address and the amount of deposit paid by that particular customer is retrieved and stored.
In New Employee sub-module the complete information of the new employee is stored and retrieved, such as date of birth, address, salary etc. New Expenses sub-module is to maintain complete information of expenses along with employee name and type of expenses.
The second part is Employee Details, in which the complete set of employee information is displayed to the user references, with employee ID, salary, and other personal information.

The third part is Update Entries, in which we have seven sub-modules, which is as follows. The first is Tank Reading which gives the capacity of Petrol and Diesel. The second sub-module is Load Reading which gives information about tank number, its capacity, difference in DIP, Stock before and after the service and the receipt for the following.
The third sub-module is Credit Sales in which Customer name, bill number, date, vehicle number and amount is stored and processed. The fifth sub-module is Item Rate in which Item number, Item Purchase and its selling price is entered and processed.
The sixth and seventh sub-module is Expanses and other Receipts. In which the information of expenses and the income through other receipts are entered and processed and the last sub-module is Item Sales in which the Code of the item, cost price and quantity of the item is entered and processed.
In Bank Transaction Module a user can get complete information about the transaction made by him by entering his password, where as the user id is got through the login form while the user enters in to the private area of the web page.
Daily Sales Details Module is further classified in to six sub-modules, and their description is as follows. The first sub-module is Lubricant sales in which the user gets information such as item code, quantity, unit price and total price. The second sub-module is Credit Sales here the user gets Information such as customer code, bill number, vehicle number and the amount paid by that particular customer is retrieved. In the same way other sub-modules diesel details and petrol details gives information to the user.
This project also supports to maintain monthly sales details and balance sheet details, through which a user can maintain sales details monthly wise and balance sheet for the month is maintained without user interface.

1. New Entry module:
The first sub-module is New Entry module, under which we have New Item, New Credit Customer, New Employee and New Expenses as sub modules. Through New Item sub-module the user will add new item name to be added and its purchases rate and cost rate. Through New Credit Customer sub-module the information of Customer such as customer name, company name, address and the amount of deposit paid by that particular customer is retrieved and stored.
Functional Requirements:
New Item-Product name of the new one which your going to introduce first in this site
New Credit Customer-New customer name
New Employee- New Employees details and their salary details

New Employee sub-module:
In New Employee sub-module the complete information of the new employee is stored and retrieved, such as date of birth, address, salary etc. New Expenses sub-module is to maintain complete information of expenses along with employee name and type of expenses.
Functional Requirements:
date of birth
address
salary

2. Employee Details:
The second part is Employee Details, in which the complete set of employee information is displayed to the user references, with employee ID, salary, and other personal information.
Functional Requirements:
employee ID
salary
Address
Phone number

3. Update Entries:
The third part is Update Entries, in which we have seven sub-modules, which is as follows. The first is Tank Reading which gives the capacity of Petrol and Diesel. The second sub-module is Load Reading which gives information about tank number, its capacity, difference in DIP, Stock before and after the service and the receipt for the following.

Functional Requirements:
tank number
capacity
difference in DIP,
Stock before and after the service

4. Credit Sales
The forth sub-module is Credit Sales in which Customer name, bill number, date, vehicle number and amount is stored and processed. The fifth sub-module is Item Rate in which Item number, Item Purchase and its selling price is entered and processed.
Functional Requirements:
Item Rate
Item number
Item Purchase
selling price

5. Expanses and other Receipts
The fifth and sixth sub-module is Expanses and other Receipts. In which the information of expenses and the income through other receipts are entered and processed and the last sub-module is Item Sales in which the Code of the item, cost price and quantity of the item is entered and processed.
Functional Requirements
Code of the item
Cost price
Quantity.

 

6. Bank Transaction Module
In Bank Transaction Module a user can get complete information about the transaction made by him by entering his password, where as the user id is got through the login form while the user enters in to the private area of the web page.

Functional Requirements:
Date
Particular
Transaction type
Amount

7. Daily Sales Details
Daily Sales Details Module is further classified in to six sub-modules, and their description is as follows. The first sub-module is Lubricant sales in which the user gets information such as item code, quantity, unit price and total price. The second sub-module is Credit Sales here the user gets Information such as customer code, bill number, vehicle number and the amount paid by that particular customer is retrieved. In the same way other sub-modules diesel details and petrol details gives information to the user.
Functional Requirements:
Lubricant sales
Credit Sales
customer code
petrol details
diesel details

This project also supports to maintain monthly sales details and balance sheet details, through which a user can maintain sales details monthly wise and balance sheet for the month is maintained without user interface.

Download Source code Dealer Management System for Petroleum Refineries 

Leave a Comment