Car Price Calculator

Authors Avatar

Rishabh Sharma        Ms. Gill        L6E/IT2

ICT Project – Car Price Calculation

I will be basing my project on a car company; the name of the company which my project will focus on is RRS Motors Ltd and is situated on North Hyde Road, Hayes. The owner of the business is Mr. Sharma and he is also its managing director. RRS Motors was established on March 19, 1999. RRS Motors currently has 5 employees. The business has faced many difficulties throughout the years but has somehow managed to save itself from termination, nowadays it is doing relatively well with profits margins increasing day by day. The main problem which they have faced over the years is that of a paper database which is extremely inconvenient because the data has to be manually entered onto paper and then filed.

RRS Motors specialises mainly in Mercedes and BMW cars and parts. When a customer visits a showroom of RRS Motors, they are asked whether they are here for a car or just to buy some parts for their car. If the customer replies in favour of buying a car, they are asked if they are looking for a second hand or brand new car and what make and model they are looking for and if they would be interested in any extra features such alloy wheels etc.

When the customer has made up his/her mind on what car to buy s/he needs to tell one of the employees so that they can fill in a form with all the customer’s details (if they’re a first time buyer from RRS Motors) as well as that details of the car that is being bought by that customer. If the customer replies in favour of buying car parts then he enquired about the make and model of his/her car so that an apt car part is installed to prevent spoiling the relationship with the customer by installing an inappropriate car part. If the customer is short of time, they can enquire about the car/car part they need by telephone, this prevents the customer’s time being wasted resulting a happier customer more likely to return.

However this creates a problem for the employees because they have to work their way through an enormous amount of filing to find out if the car/part that the customer is asking for is actually in stock, this would obviously take some time and the customer experiencing boredom and frustration, to prevent this the employee would try to hurry up s/he could be under the misconception that a car/part is in stock when it isn’t.

They face various problems on a day to day basis such as having to enter registration numbers of cars onto databases to find out their sales history such as number of the previous owners, the number of accidents it has had and it’s MOT etc. This is frustratingly boring and unnecessarily time consuming. This becomes even more problematic when some of the new employees are not familiar with the technique of filing information for that purpose, which also leads to mistakes and by extension lack of accuracy to their cars’ (paper) database.

Another problem has arisen over time which is that fact that over the years as their customer database has increased, so has the amount of filing which needs to be done to keep track of all their customers. This leads to an enormous paper database which can be very badly organised and attention diverting so they get less time to concentrate on the actual business.

There is also a serious deficiency of security because records of customer details can easily be stolen after closing times and if this data was on a computer, serious security measures could be put into place to insure that the data remains safe.

Join now!

Installing an ICT based system also has another advantage; it will prevent employees with little or no experience from making wrong decisions on how much is worth after it has been sold twice or has had a numerous number of re-sprays for example because a computer system can be set up to calculate these automatically.

The task I am going to provide a solution for is decreasing the workload for the employees and overall reducing the amount of headache for Mr. Sharma by introducing a computer based system which can eliminate the problem of human error. If there is ...

This is a preview of the whole essay