Gas Agency Management System

ABSTRACT

The system shows the work of our gas agency. Provides new gas refill connections. And it also trades full refills instead of empty refills. For this, it gives all the information to the client. It can provide various tools related to the gas department. Such as regulators, heating plates, burners, tubes, etc.

For this I have to give some data. This is how the current system works. Provides some information such as written information. Collect customer information, stock and reservations. The information is very useful for the system to work on it. Customer information, such as customer name, customer address, telephone number, or other connection number, provides identification such as user identification. Through it you can enter data. In it we indicate how many references the client has, when it was issued, etc. Other information is stock information where we have information about stock items. Through it we know how much we have, how much has been given. Etc. Stock is also very important. The last information we collect is the reservation. In it we collect the information from the reservation extract. Name of the client when ordering the second top-up, etc.

Then you have to report something. Reports are also an important feature. In these reports we consider all the information and all the data. Are important. The report also considers balance. Therefore, the reports are usually the main idea where we cover all the work of the organisation.

Existing System

By the existing system, we can say that the actual work of some agencies are not automated such as "Vineet gas agency","Bharat gas agency" etc.
The current work is very difficult, because each record is written in the minute book, adding, deleting, changing, etc. complicate the job. We also collect customer information. In the customer record, when a user comes to fill the cylinder, they must first verify its accuracy. They will then reserve a raffle at registration, which is time consuming. If a customer changes their address, it is difficult to update their profile or change their registration. It is also important to keep stock records. Daily stock records should also be updated regularly.

For the counting the cost it have to done some below things:

The category of the system is “organic “ for this x = 3.2 and y = 1.05 are constant.

The size of the system is 2.5 KDL(thousand of delivered line of code).

Initial cost estimation Ei = x * (size)^y

= 3.2 * (2.5)^1.05

= 8.375

EAF is effort adjustment factor.

Reliability is high à 1.15

Database size is normal à 1.00

Complexity is very low à 0.70

Programmer experience is very low à 1.29

Programmer capacity is normal à 1.00

Language experience is low à 1.07

Analyst capacity is normal à 1.00

EAF = 1.15 * 1.00 * 0.70 * 1.29 * 1.00 * 1.07 * 1.00

= 1.11

Final cost E = Ei * EAF

= 8.375 * 1.11

= 9.30 PM

Proposed System

The new gas agency system has added a few more benefits and removed the problems of the existing system. So after understanding the problems of the current system, we are creating a new system to make the work easier and more accurate. So it actually works:

when a customer requests to refill the gas, first check its accuracy and prepare the bill and give those bills to the designated delivery man.
In order to perform all tasks correctly, the system keeps a record of all types of users, which does not take much time and we do not have to search for such documents.
This stock includes other registered items and the stock is kept in an orderly manner.
All documents and reports of all discrepancies are ready.
It doesn't take long to calculate the balance and it is very accurate, so there can be no such error.
The system has security and some password support to unlock the work.

System Design

In this system we can work on following modules such as

User Details
Customer Details
Product Details
Booking Details
Stock Record Detail

The above modules are basic modules you can also add any new module according to requirement.

Detail of Modules

User Details
- User Id
  - String (Datatype)
  - Primary Key (Constraint)
- User Name
  - String type (Datatype)
  - Not NULL (Constraint)
- Password
  - String type (Datatype)
  - Not NULL (Constraint)
Customer Details
- Customer Number
  - Numeric type (Datatype)
  - Primary Key (Constraint)
- Customer Name
  - String type (Datatype)
  - Not NULL (Constraint)
- Customer Address
  - String type (Datatype)
  - Not NULL (Constraint)
- Customer City
  - String type (Datatype)
  - Not NULL (Constraint)
- Customer Phone
  - Numeric type (Datatype)
  - Not NULL (Constraint)
- Cylinder Type
  - String type (Datatype)
  - Not NULL (Constraint)
- Rationcard Number
  - String type (Datatype)
  - Not NULL (Constraint)
- New connection charge
  - Numeric type (Datatype)
  - Not NULL (Constraint)
- Subscription Number
  - Numeric type (Datatype)
  - Not NULL (Constraint)
- Passbook Number
  - Numeric type (Datatype)
  - Not NULL (Constraint)
- Date of Issue
  - Date type (Datatype)
  - Not NULL (Constraint)
- Total Amount
  - Numeric (Datatype)
  - Not NULL (Constraint)
Product Details
- Product Number
  - Numeric type (Datatype)
  - Primary Key (Constraint)
- Cylinder Deposite
  - String type (Datatype)
  - Not NULL (Constraint)
- Depreciation Amount
  - String type (Datatype)
  - Not NULL (Constraint)
- With Hoteplate charge
  - Numeric type (Datatype)
  - Not NULL (Constraint)
- Without Hoteplate charge
  - Datetime type (Datatype)
  - Not NULL (Constraint)
- Instolation charge
  - Datetime type (Datatype)
  - Not NULL (Constraint)
- Stamp charge
  - Datetime type (Datatype)
  - Not NULL (Constraint)
- Lighter charge
  - Datetime type (Datatype)
  - Not NULL (Constraint)
- Tube charge
  - Datetime type (Datatype)
  - Not NULL (Constraint)
- Administrative charge
  - Datetime type (Datatype)
  - Not NULL (Constraint)
- Lpg charge
  - Datetime type (Datatype)
  - Not NULL (Constraint)
Booking Details
- Consumer Number
  - Numeric type (Datatype)
  - Foreign Key (Constraint)
- Booking Number
  - String type (Datatype)
  - Primary Key (Constraint)
- Booking Date
  - Date type (Datatype)
  - Not NULL (Constraint)
- Total Quantity
  - Numeric type (Datatype)
  - Not NULL (Constraint)
- Total Amount
  - Numeric type (Datatype)
  - Not NULL (Constraint)
Stock Record Detail
- Stock Number
  - Numeric type (Datatype)
  - Composite Primary Key (Constraint)
- Stock Date
  - Date type (Datatype)
  - Composite Primary (Constraint)
- Opening Stock
  - Numeric type (Datatype)
  - Not NULL (Constraint)
- Receipt from company
  - Numeric type (Datatype)
  - Not NULL (Constraint)
- Total Numbers of Cylinders
  - Numeric type (Datatype)
  - Not NULL (Constraint)
- Refill Perday
  - Numeric type (Datatype)
  - Not NULL (Constraint)
- New Connection Perday
  - Numeric type (Datatype)
  - Not NULL (Constraint)
- Total delivered
  - Numeric type (Datatype)
  - Not NULL (Constraint)
- Total Numbers of Empty Cylinders
  - Numeric type (Datatype)
  - Not NULL (Constraint)
- Closing Stock
  - Numeric type (Datatype)
  - Not NULL (Constraint)

Feature Enhancement

This system automates the entire gas agency process. We may store, update and delete records of employees, products, customer reservations, etc. We can develop this system as desktop based or web based. In the feature, we will implement some tracking system so that we can easily track the delivery process. We can easily track locations. We will periodically implement new government policies regarding consumer benefits.

Conclusion

This application provides a faster and more efficient way to manage costs. Its objective is to improve inter-institutional communication with clients by providing information on the current status of expenditures. This system eliminates most of the manual work and therefore reduces the risk of cost overruns. The system has a simple and easy to use user interface. Provides flexibility to customise based on changing business needs.

Gas Agency Management System | Project