sam s auto salvage
Download
Skip this Video
Download Presentation
Sam’s Auto Salvage

Loading in 2 Seconds...

play fullscreen
1 / 15

Sam’s Auto Salvage - PowerPoint PPT Presentation


  • 107 Views
  • Uploaded on

Sam’s Auto Salvage. Capstone Project: Database & Web Site Design and Functions ITEC 495 Team 5. Project Goals. Design and develop an attractive website for Sam’s Auto Salvage. Design and develop a database that meets the business and customer needs of Sam’s Auto Salvage.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Sam’s Auto Salvage' - telma


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
sam s auto salvage

Sam’s Auto Salvage

Capstone Project: Database & Web Site Design and Functions

ITEC 495 Team 5

project goals
Project Goals
  • Design and develop an attractive website for Sam’s Auto Salvage.
  • Design and develop a database that meets the business and customer needs of Sam’s Auto Salvage.
  • Integrate the website and database components into a full-functioning resource for Sam’s Auto Salvage.

M. Ivory, J. Parsons, C. Thomason, K. Trent, & E. Watkins - Capstone Project

needs assessment
Needs Assessment
  • Established 1988 in Columbus, OH
    • New location in Dayton, OH
    • Plan to add 5 additional in next ten years
  • Business Transactions
    • Customer walk 8+ acre lots to locate parts
    • Customers pull parts
    • Cash and check only
    • Hours 8-5 Mon-Fri, 8-Noon Saturday
    • Customers can negotiate price
    • Phone calls

M. Ivory, J. Parsons, C. Thomason, K. Trent, & E. Watkins - Capstone Project

needs assessment cont
Needs Assessment (cont.)
  • Limited Equipment
  • Accounting
    • Handwritten carbon copy receipts
    • No checks and balances between receipts and cash register sales
    • History of employee theft
  • Purchases
    • Buys all vehicles driven onto lot

M. Ivory, J. Parsons, C. Thomason, K. Trent, & E. Watkins - Capstone Project

sas customer feedback
SAS Customer Feedback
  • Locating Part too time consuming
  • Business hours too restrictive
  • Requesting ability to use credit cards
  • Reserving parts not always guaranteed
  • Requesting parts that are not available
  • Prices inconsistent

M. Ivory, J. Parsons, C. Thomason, K. Trent, & E. Watkins - Capstone Project

website design
Website Design

Home page of SAS Customer Web Site

M. Ivory, J. Parsons, C. Thomason, K. Trent, & E. Watkins - Capstone Project

website design1
Website Design

Navigation of SAS Customer Web Site

Simple

Navigation

Returning customer login

Search Part Inventory

Simple

Navigation

M. Ivory, J. Parsons, C. Thomason, K. Trent, & E. Watkins - Capstone Project

website design2
Website Design

Home page of SAS Employee Web Site

M. Ivory, J. Parsons, C. Thomason, K. Trent, & E. Watkins - Capstone Project

database design
Database Design

Database Design

SAS Database Entity Relationship Diagram

M. Ivory, J. Parsons, C. Thomason, K. Trent, & E. Watkins - Capstone Project

website walkthrough
Website Walkthrough

Demonstration to begin…

M. Ivory, J. Parsons, C. Thomason, K. Trent, & E. Watkins - Capstone Project

website design3
Website Design
  • Customer Interface Testing
    • Extensive testing of the registration
    • Ability to search all available parts in database
  • Employee Interface Testing
    • Add new vehicles
    • Create and view invoices
    • Search inventory

M. Ivory, J. Parsons, C. Thomason, K. Trent, & E. Watkins - Capstone Project

problems addressed
Centralized location for available parts

Established consistent pricing

Customer convenience

Increased available hours without increasing staff

Reservations are guaranteed for two weeks

Problems Addressed

M. Ivory, J. Parsons, C. Thomason, K. Trent, & E. Watkins - Capstone Project

problems addressed cont
Problems Addressed (cont.)
  • Minimize accounting errors
  • Reduced risks of internal theft
  • Eliminated excess phone calls from customers and between sites
  • Consistent customer service
  • Improved employee training
  • Data available to make purchasing decisions

M. Ivory, J. Parsons, C. Thomason, K. Trent, & E. Watkins - Capstone Project

future releases
Phase Five

Implemented April 08

Includes online shopping cart

Secure online transactions

Allow for use of credit cards

Additional staff on site

Expansion for additional sites

Customized reporting

Integration with accounting software

Asset management

Sales Projections

Future Releases

M. Ivory, J. Parsons, C. Thomason, K. Trent, & E. Watkins - Capstone Project

team 5 consulting
Team 5 Consulting

-Highly trained professional staff stand behind their work and are dedicated to meet your business needs.

-Flexible and “low cost” in meeting any problems you have by phone, email or remote access.

Contact us:1-800-TEA-M05 or

Email: [email protected]

M. Ivory, J. Parsons, C. Thomason, K. Trent, & E. Watkins - Capstone Project

ad