Xyz quick lube co
Xyz quick lube co.XYZ QUICK LUBE Co.
The purpose of this exercise is to design a single user system, to solve the needs of a startup business. The business I chose is a service oriented, automotive oil change company. This system will need to satisfy the business needs of a small company, including database queries, inventory management, customer tracking, form generating, accounting, and many other functions. This must be accomplished in an easy to use, simple, single user format.
This system should be a point of sale system utilizing separate databases. One for customer tracking used to notify previous customers via postcard printouts. In addition, these should be sent after a three-month period from their last service. There could be coupons issued as well. Accounting and inventory information, such as daily, weekly, monthly, etc. sales, current inventory needs, cost of inventory, profit margins, employee records, sales tax, etc. should also be stored. Another, dynamic database would hold manufacture specifications. This would provide real-time query access for make/model vehicle specifications for referencing filter part numbers as well as other technical information. This would need to be updated as manufacturers change specifications.
This system should contain redundant features as it is business critical, providing dual, mirrored disk drives, as well as an efficient backup device. This would reduce down time due to drive failure. The need for this amount of safety lies in the necessity of maintaining fast, uninterrupted service.
There would need to be two printers. One, a dot matrix for printing customer receipts, as well as a hard copy for business purposes. The second printer would be for the service personnel. This would print out the work orders with specific information, such as the make and model of the vehicle as well as the filter numbers and quantity of oil needed. This printer would be located in the service area.
This system should be capable of printing and displaying timely accounting reports including sales figures and current inventory quantities. These should be available on screen (a color VGA monitor would be required), as well as in printed form.
All this must be extremely user friendly. With very little training required. The projected employee skill and pay level is expected to be entry level minimum wage.
When researching a business solution to fit this need, one company was mentioned in most interviews and research. Auto Data� was highly recommended by the independent area shops that provide this service. Auto Data� provides a complete software system specifically engineered for this market. This package is called POS-I-LUBE�. This is a all-encompassing point of sale software package that provides complete support of an automotive service company. This system provides comparative accounting reports, real-time inventory management, work order creation, reliable specification information via a secured connection, employee time-clock accounting functions, full...
To view the complete essay, you be registered.