ABSTRACT 

The project entitled “Two Wheeler Showroom Management” is to be developed for maintaining the show room activities like, customer maintenance, customer quotation generation, vehicle sales, customer dues maintaining for the instalment customers,  vehicle service and spare parts sales, Customer follow ups details, customer feedback form entry and employee details. The system is efficient in generating reports which will help in the maintenance of the showroom easily.

Existing System 

The existing system is not automated fully as only the accounts are automated with the accounting software. The Customer follow-ups are maintained in excel which will take more time to search from the long lists, service details are not maintained through system so it is very difficult to maintain the details.  As the current data is maintained through ledgers and excel sheet so there is no proper reports for facilitation of the administration of the showroom.

Disadvantages of the Existing System 

  • Only accounts is systemized
  • Lack of reports
  • Vehicle Sales & Services are maintained in excel Sheet which leads to the inaccurate information.
  • Customer data are not maintained properly which leads the follow-ups slow.

Proposed System 

The proposed system overcomes the disadvantages of the existing system and records the entire activities happening in the show room. The reports generated will enhance the efficiency of the application. The service registration alerts and completion are recorded which will be easy to maintain the service details.

Advantages of the proposed System

  • Entire activities of the show room are recorded through the system.
  • Customer Data is maintained.
  • Reports generated will be more useful for management to take the quick business decisions.
  • Customer database is maintained which will be helpful for intimating the service completion details and new offers
  • Customer follow-ups are maintained which will be an added advantage of this system.

Modules

  • Administration
  • Inventory
  • Order Processing
  • Payroll Processing
  • Payment
  • Profit and Loss
  • Reports
  1. Administration 

The administration module is used for registering the user details for accessing the system i.e. the login details are created in this module. The change password is used to change the existing password with new password.  The information about the vehicles available in the show rooms is recorded in the module.

II   Inventory

This module records the information about the purchase of vehicles and spare parts from the company based on the customer order and need for the spare parts for the service order. The stock of the spare parts and vehicles are maintained.This module also contains the information about the sales of the vehicle such as type of the vehicle, vehicle cost, customer information, mode of payment loan or cash and the bill is generated according to the vehicles and extra fittings purchased.This module also handles the sales of the spare part sales to the customers and generated the bill for the sales.

  1. Ordering Processing

This module records the complete customer information like the customer name, address, phone no, mobile number, type of the vehicle purchased. This module also handles the customer follow up activity i.e. if a customer comes and enquires about the vehicles sold in the showroom. This will be useful for the marketing team to follow up the customer and convert into the sale of new vehicle.

  1. Payroll Processing

This module handles the complete information of the employees and their salary details. The salary is divided into two types such as daily wages and monthly salary.

This module records the employee information like Employee name, address, phone no, mobile no, email, Date of Birth, Employee Salary Type like Monthly or Daily wages and Salary Details.

This module captures monthly or Daily Salary disbursement details of the employee.

  1. Reports

The various forms of reports such as employee information, salary report, stock reports for spare parts, sales report, purchase report, Customer Report, follow up report, Installment details of the customer and service details are available in this module.