Order Tracking System for Gypsy Renaissance, Inc'

1
Order Tracking System for Gypsy Renaissance, Inc.

• Zach Popkin, Jeff Hausknecht,
• Eric Wolfe, John Grace

2
Gypsy Renaissance

• Founded by Alexis Seepo in San Francisco, 1976
• Incorporated 1986 in New York
• Company began as entirely wholesale
• Sold to over 400 retail outlets and boutiques
• Founded www.gypsyrenaissance.com in 2002, which
  allowed for retail sale

3
Wearable Works of Art

• 100 hand-crafted original designs
• Ideal for Mardi Gras, New Years Eve, or
  Halloween
• Client list includes MGM, Disney, Cirque de
  Soleil, Donald Trump, and Big Apple Circus
• Custom designs for weddings, galas, or other
  special events
• 12 Styles Over 130 individual designs

4
Current Order Tracking System

• Approx. 90 retail, 10 wholesale
• Retail orders from website tracked through
  third-party system
• Wholesale orders taken over phone, tracked by pen
  and paper
• Susceptible to human error
• Time intensive, inefficient

5
Wholesale Order Solution

• Creation of a database with Microsoft Access
• Used to collect, organize and evaluate work
  (orders)
• Will provide information on
• Deadlines
• Order prices
• Customers

6
Communication with Client

• Find out what she needed
• Simple interface, user friendly
• Ability to effectively meet deadlines
• System to help manage production decisions
• Find out what she wanted in addition
• Ability to generate additional reports involving
  revenue and customers

7
Database Capabilities

• View all past and present orders
• View upcoming deadlines
• View customer activity
• View total annual orders/revenue

8
Renaissance order tracking DB

• Demonstration

9
Implementation

• TAM
• Prior to implementation
• Ensure perceived usefulness and ease of use
• Infrastructure is already in place
• Pc, Windows XP, Microsoft Access etc.
• Place existing orders in DB
• Wait until year end?

10
Advantages (specific)

• Simple, User friendly interface
• Effectively manage large amounts of orders
  (on-time)
• Maintain customer order records
• Evaluate yearly revenue and success

11
Advantages

• Process control
• Ensure operational procedures are carried out
  appropriately
• Improve personal performance (monitoring)
• Job design is informated
• Workers are provided with access to information
  that allows them to go beyond the requirements of
  a job to understand the larger picture and more
  abstract concepts (M U IS)

12
A look to the future

• Scalable
• Using a miniscule fraction of Accesss
  capabilities
• Functionality and space
• Transferability
• Simple interface
• Possible Further Implementation

13
Further Implementation

• Include online orders (web form extraction)
• Phased approach
• Include mask materials and inventory
• Include costs as well as price

14
Thank You.
15
Resources

• Managing Using Information Systems Pearlson
  and Saunders
• Access 2003 All-in-One Desk Reference for
  Dummies Simpson, Young, Barrows
• www.gypsyrenaissance.com