Sam’s Salvage Yard
Download
Report
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