Transcript product locator - ODU Computer Science

PRODUCT LOCATOR
Presented
By
Richard Raehl
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
PROJECT MANAGEMENT
PLANNING

Resource Management

Planning and Control Management

Communication and Coordination
Management
RESOURCE MANAGEMENT

Development Team

External Expertise

Facilities

Equipment / Technology

Financial
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
PLANNED PROJECT
OBJECTIVES and TASK
Website
 Information for Database
 Test Database
 Code
 Implementation

MANAGEMENT CONTROL

Monitor results

Delegate responsibilities
COMMUNICATION and
COORDINATION
MANAGEMENT

Communication

Contact

Coordination
PROJECT MANAGEMENT
FEASIBILTY

Communication skills

Experience large technical projects

Organization
SOCIETAL CONCERNS

Locating products in warehouse type stores

Finding coupons for those products
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
SOLUTION

Provide the customer with a computer based
user friendly product locator and coupon
dispenser
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
EASY TO USE

Survey showed that people were
comfortable with menu driven commands,
keyboards and the mouse.

Fonts 12 - 18
BENEFIT to SOCIETY

Save customers time and money

Increase use of coupons

Decrease customer complaints

Increase sales
TECHNICAL CONCERNS

Project components overview

Scope

Technical

Feasibility
PROJECT COMPONENTS
OVERVIEW
SCOPE

Store selection

Scope diagram

Components not in scope
HOME DEPOT
SCOPE DIAGRAM
TECHNICAL ISSUES

User interface

Search mechanism / database access

Results / Display

Feasibility
EXAMPLE USER
INTERFACE
SEARCH MECHANISM /
DATABASE ACCESS

Centralized database

Database fields

Queries
CENTRALIZED DATABASE
CENTRALIZED DATABASE

Components connect to database using a
hub

Physical placement of kiosks not limited

Number of kiosks unlimited
DATABASE FIELDS and
QUERIES

Name, description, SKU#

One search box

Return list of possible results, user select
best one
EXAMPLE RESULTS /
DISPLAY
STORE DIAGRAM
FEASIBILITY

Existing location-inclusive database

Hardware off-the-shelf

Cost are relatively low
FINANCE

Development / Implementation

Maintenance

Cost / Benefit Analysis
DEVELOPMENT /
IMPEMENTATION

Software

Hardware

Implementation
MAINTENANCE

Database

Software

Hardware
COST / BENEFIT ANALYSIS

Total cost over 10 years

Return on investment
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

CONTACT INFORMATION
Web site
http://cs.odu.edu/~aungvars/shoppingasst/
 Andrew Ungvarsky [email protected]
 Ali Miamee [email protected]
 Sadina Little [email protected]
 David Zhai [email protected]
 Richard Raehl [email protected]
