PRODUCT LOCATOR

1
PRODUCT LOCATOR

• Presented
• By
• Richard Raehl

2
INTRODUCTION

• Large stores with diverse inventories
• Provide to the customer a computer terminal that
  has a searchable system requiring only one query
  field that will return product location relevant
  coupons and product information.
• Product Locator

3
PROJECT MANAGEMENT PLANNING

• Resource Management
• Planning and Control Management
• Communication and Coordination Management

4
RESOURCE MANAGEMENT

• Development Team
• External Expertise
• Facilities
• Equipment / Technology
• Financial

5
PLANNING and CONTROL MANAGEMENT

• Complete the functional specifications of a
  Product Locating System during the Fall semester
• 30 days based on a time multiplier of 2

6
PLANNED PROJECT OBJECTIVES and TASK

• Website
• Information for Database
• Test Database
• Code
• Implementation

7
MANAGEMENT CONTROL

• Monitor results
• Delegate responsibilities

8
COMMUNICATION and COORDINATION MANAGEMENT

• Communication
• Contact
• Coordination

9
PROJECT MANAGEMENT FEASIBILTY

• Communication skills
• Experience large technical projects
• Organization

10
SOCIETAL CONCERNS

• Locating products in warehouse type stores
• Finding coupons for those products

11
CONSUMER SURVEY

• 88 had problems locating a product
• 96 forgot coupons they intended to use
• 24 did not use coupons
• 44 of those who did not use coupons was because
  they could not find them

12
SOLUTION

• Provide the customer with a computer based user
  friendly product locator and coupon dispenser

13
COMPUTER BASED

• 86 of consumers surveyed know how to use a
  computer
• US Census Bureau 1999
• 54 million households have computers
• 94 million use/have internet access

14
EASY TO USE

• Survey showed that people were comfortable with
  menu driven commands, keyboards and the mouse.
• Fonts 12 - 18

15
BENEFIT to SOCIETY

• Save customers time and money
• Increase use of coupons
• Decrease customer complaints
• Increase sales

16
TECHNICAL CONCERNS

• Project components overview
• Scope
• Technical
• Feasibility

17
PROJECT COMPONENTS OVERVIEW
18
SCOPE

• Store selection
• Scope diagram
• Components not in scope

19
HOME DEPOT
20
SCOPE DIAGRAM
21
TECHNICAL ISSUES

• User interface
• Search mechanism / database access
• Results / Display
• Feasibility

22
EXAMPLE USER INTERFACE
23
SEARCH MECHANISM / DATABASE ACCESS

• Centralized database
• Database fields
• Queries

24
CENTRALIZED DATABASE
25
CENTRALIZED DATABASE

• Components connect to database using a hub
• Physical placement of kiosks not limited
• Number of kiosks unlimited

26
DATABASE FIELDS and QUERIES

• Name, description, SKU
• One search box
• Return list of possible results, user select
  best one

27
EXAMPLE RESULTS / DISPLAY
28
STORE DIAGRAM
29
FEASIBILITY

• Existing location-inclusive database
• Hardware off-the-shelf
• Cost are relatively low

30
FINANCE

• Development / Implementation
• Maintenance
• Cost / Benefit Analysis

31
DEVELOPMENT / IMPEMENTATION

• Software
• Hardware
• Implementation

32
MAINTENANCE

• Database
• Software
• Hardware

33
COST / BENEFIT ANALYSIS

• Total cost over 10 years
• Return on investment

34
SUMMARY

• Problem locating products and associated coupons
• Provide product location, information, and
  coupons
• Professional experienced team
• Benefit to consumers
• Technically feasible
• Positive cost / benefit analysis

35
CONTACT INFORMATION

• Web site http//cs.odu.edu/aungvars/shoppingasst/
  
• Andrew Ungvarsky pxpx_at_mindspring.com
• Ali Miamee alimiamee_at_hotmail.com
• Sadina Little mowtcoofr_at_aol.com
• David Zhai dzhai_at_cs.odu.edu
• Richard Raehl rraeh001_at_odu.edu