1 / 77

Overview of Databases*

Overview of Databases*. Vehicle Fleet Management. Virtual Vehicle Sales. Extended Insurance Warranty. Click on topic of interest. Site Inventory Control. Import / Export. Brick Transportation. Bulk Product Management. Healthcare. Computer Assets Monitoring.

jory
Download Presentation

Overview of Databases*

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Overview of Databases* Vehicle Fleet Management Virtual Vehicle Sales Extended Insurance Warranty Click on topic of interest Site Inventory Control Import / Export Brick Transportation Bulk Product Management Healthcare Computer Assets Monitoring * See separate presentation on ‘The Employee Database’

  2. Vehicle Fleet Management A database written for a substantial furniture retailerthat controls all costs, insurance claims and the report-ing needs of several hundred branches.

  3. Provide actual vs. budget cost information for fuel, maintenancefines, licencing etc. Import data facility from enterprise system controlling petrol cards Maintain fiscal year history Improve communication to several hundred branches on vehicle cost All branch reports sent via e-mail in HTML format, automatically on a monthly basis Program Objectives

  4. All vehicle costs and driver performance presented on one form.All details of this vehicle/driver can be e-mailed to branch manager.

  5. All insurance claim details entered here. E-mail a document to the relevant person regarding this claim.

  6. Program reports all aspects of fleet costs/performance

  7. Program automatically e-mails in HTML format a monthly reportdetailing all vehicle costs, performance, licence renewals anddriver details by location to branch managers. Reports are archived for future reference. Main Menu

  8. Virtual Sales Database Query web site at frequent intervals for new leads.Prepare quotation, purchase vehicle from dealer, invoice client or bank, book payment and deliver vehicle.

  9. This workflow chart is the menufor working through the program.Hovering over a graphic informsuser of topic.A web site is queried every half-hour.If new enquiries are in the databasethe message below is displayed.

  10. New web enquiries are converted to quotes. E-mail, fax, phone orwritten enquiries are also catered for. Vehicle (or vehicles) is/are quoted with preliminary assessment of trade-in. Supervisor allocates respons-ibility to team member via e-mail. Quote is sent to client via e-mailor fax. Users have access to web sites from within the program anda payment calculator. Both new and used vehicles can be entered.Team actions to secure the quote are entered here.

  11. Person responsible e-mails colleague a question related to quote.Response can be viewed by double clicking on question.

  12. An overview of all actions completedor outstanding is viewable by resp-onsible person or department.

  13. Once approved, vehicle is purchased from dealer.

  14. Client or bank is invoiced.

  15. Full reporting on all transactions Main Menu

  16. Extended Warranty Database Built on the powerful MS SQL Serverplatform, this program can serve manyusers and high volumes of data

  17. Easy access to data for call centre personnel Maintain record of insurance companies, products offeredand current rates Provide data validation to comply with rules determinedby insurance companies Input all claims, calculate entitlements and costing of repairs Access to historical data of claims by vehicle/policy owner Allocate policies to dealers Financial and statistical reporting Program Objectives

  18. New policies are entered then assignedto a dealer.Policies are sold to clients.Program holds many insurancecompanies and many types of cover.

  19. All details against policy presented on one form. Customer,vehicle, current and historical claims plus service history instantly available to call centre staff.

  20. Details of claims

  21. Staff protected from entering incorrect or invaliddata through several key validations.

  22. Each communication related to a claim is recorded.

  23. Database searches conducted by policy numberor vehicle registration number.

  24. Claims are immediately costed. A gearbox problem opensa list of gearbox components that may need replacing.A standard cost of all components and spares held in system. Main Menu

  25. Site Inventory Control A large construction group controls all site stock movements through this program

  26. Program Objectives • Manage all in-coming/out-going equipment and materials • on large construction sites • All hired equipment booked against return date, leasing or hire cost monitored against standard • All items booked into stock and issued to departments on site • Maintain record of current stock, minimum quantities, actual cost, budgeted cost and stock losses • Provide means of entering physical stock count • Full reporting facility

  27. Requisition entered into system, goodspurchased from supplier, on orderquantity updated in inventory.

  28. Goods received against requisition, price variance recorded withamount on back order if applicable.

  29. Goods issued to department, document producedfor signature. Inventory reduced accordingly. Warning that negativestock will result ifproceeding with thisissue.

  30. Inventory maintains, current, budgeted and alternative priceplus previous purchase price. Records note quantity on order,units on hand, stock value and physical stock details.

  31. Entry of physical stock details. Report prints actual, theoreticalstock amounts and value. Stock losses can be determined. Main Menu

  32. Import / Export Manages all documentation related to the movement of materials between countries, monitors stock and allows multi-currency invoicing

  33. Program Objectives • Quote local/foreign customer for product • Import product to bonded warehouse • Stock transfers between warehouses • Invoice/purchase orders in any currency • Monitors actions related to each import/ • export transaction • Auto-order against re-order stock levels

  34. Actions colour coded to immediately see outstanding documentation and communications. Imports, exports, purchases and invoices viewed on one form for all transactions against a file number.

  35. Quotation input form

  36. Invoices auto-raised against quote.

  37. Product purchase in any currency, product allocated to specific customer and warehouse.

  38. Status of outstanding actions viewed when database is opened.

  39. Automatic reminder of products below re-order level. Items marked for ordering generate a purchase order.

  40. Menu lists all database maintenance activities.

  41. Complete data on each inventory item. Review stock position, quantities at each location and to whom the product is allocated.

  42. Review all file numbers for actions outstanding.

  43. Receive product into relevant warehouse.

  44. Receive product into relevant warehouse.

  45. Custom reports provide information exactly as the user specifies. Main Menu

  46. Brick Transportation Manages large scale deliveries to siteswith complete client information

  47. Program Objectives • Quote customer against enquiry • Prepare a planned delivery schedule • Invoice customer and receipt payment • Purchase product from supplier • Confirm delivery schedule and print delivery notes • Collect and deliver product • Multi- units of measure by product

More Related