me and part-time employees currently working in his business. In the Lilydale location, there is and Kim, who looks after customer enquiries, maintain (Create, Retrieve, Update, Delete) mer profiles, generate customer invoices, process invoices and payments. Bill and Ben are car anics. Peter looks after the ordering processes. When customers come to have their cars red, their initial contact is with Kim or Mary. Before Kim or Mary accept their requests, they the database system to ensure any previous work that the customer has requested has been for satisfactorily. This can be generated by their current computer system (when customer's car tration number is entered into the computer, the system will provide relevant feedback). If Akk e are outstanding payment issues with the car registration number, the customer will be ired to pay all outstanding bills before their new requests are accepted. Customer details are in a Customer file, and details of each job are kept in a Job file under-car registration numbers. is ok, Kim or Mary will accept the vehicles and pass the jobs to the mechanics: Bill and Ben. They heck the car and identify problems, parts required and estimated completion time. They will ricca New to complete forms which include all relevant information and forward to Kim or Mary, who will to complete fo the lists and calculate the cost. They will then call the customer for confirmation. If customers Kam wwwwww e, Mary or Kim will notify the mechanics to go ahead and repair the car. After the job i 2000 200 p -pon are leted, labour hours and parts used are recorded in the Job file. The mechanics will notify Mary econoce men m, who will prepare invoices and call the customer to collect the cars. Customers can pay when 13 indor emai pick up cars or within 30 days. Reminder emails will be sent to customers a week before the 2012 date. If payment is not made within 30 days, the follow-up emails will be sent to customer ing of a 10% penalty. At the end of every week, computer systems will generate reports, e.g., and used parts, Customer Payment report... Acme needs to keep stock of frequently used parts spark plugs, oil filters, air filters) which are purchased regularly from suppliers. Acme's liers are mainly local, however for some special parts for expensive cars, they also purchase overseas suppliers. The computer system will monitor the stock level automatically. For those from local suppliers where the inventory level drops down to quantities of 3, then a ication will be sent to Peter, who supervisors the ordering processes. Peter has to contact liers and lodge a replacement order. However, for those parts from overseas suppliers, the ication will be sent when the inventory level drops to a quantity of 5. Less frequently used parts rdered as required. Once they have a reliable supplier, they tend to stick with them, so they ever have one supplier for each part. Supplier details are recorded and filed in the database. In ase where stock is ordered, details of the order are recorded in the Order file. Peter works in ffice and maintains the ordering processes. All parts are recorded in the database 'Parts' file. parts database should be identified to the supplier allowing Peter to create, add, update, delete modify both supplier and part tables. If ordered parts haven't arrived within 10 days, the system matically notifies Peter, who will contact suppliers immediately. The computer system will rate several reports by the end of each month, e.g., ordering parts with the suppliers, delivered rs, an unpaid invoice report and an unfilled orders report. These reports will be sent to the e's owner Geoff. A copy of all orders is stored in an Order file, where invoices and parts are women ked against the goods received and are then attached to the order. If everything is correct, eu again P will update the order and stock details on the system. He will then pass the invoices, (including ost of the parts) to Mary or Kim who looks after accounting and payments. Mary or Kim will pay after the voices within 10 days after the delivery. If invoices haven't been paid in 10 days, the auto- ication will be sent to their email to remind them that the orders are outstanding. At the end of nonth, the system will generate reports on invoices paid during the month, the parts list which Is the names of the parts, quantities, single costs and total costs. Most of the data entry mentioned previously, a variety of information is extracted from the system through enquiries and the generation of periodic reports. This information is used by Geoff, the owner of the garage, to manage the business.