Transcript Sam’s Salvage Yard

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.
 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

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.)

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
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
Home page of SAS Customer Web Site
M. Ivory, J. Parsons, C. Thomason, K. Trent, & E. Watkins - Capstone Project
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 Design
Home page of SAS Employee Web Site
M. Ivory, J. Parsons, C. Thomason, K. Trent, & E. Watkins - Capstone Project
Database Design
SAS Database Entity Relationship Diagram
M. Ivory, J. Parsons, C. Thomason, K. Trent, & E. Watkins - Capstone Project
Website Walkthrough
Demonstration to begin…
M. Ivory, J. Parsons, C. Thomason, K. Trent, & E. Watkins - Capstone Project
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
M. Ivory, J. Parsons, C. Thomason, K. Trent, & E. Watkins - Capstone Project
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
M. Ivory, J. Parsons, C. Thomason, K. Trent, & E. Watkins - Capstone Project
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