Sales Report 2010

From FreekiWiki
Revision as of 15:23, 21 January 2011 by Tonyc (talk | contribs) (moving SQL stuff to discussion tab)
Jump to navigation Jump to search

Currently proposing a TOC, to be populated soon.

Overview

  • Summary of the year, with general trends in sales income streams
    • store
    • bulk
    • online
    • other (rentals, ?)

Thrift Store Narrative

Summarize big changes/events/trends that occurred over the course of the year

Gizmo stream

  • What did we see more/less of?
  • Any thoughts on 'why'?
  • Any changes in testing procedures that affected sales?
  • Cell phones

Policies

  • What changes in policy were implemented?
  • What was the perceived impact of each?
    • Store Returns
    • Warranties

Procedures

  • What did we change about our operations?
  • How did these pan out?
    • System pricing
    • Store returns
    • Established Working Group
    • Communications w/in this group/Sales Committee/FG

Infrastructure

  • Sales Floor Layout
  • The new counter and cases
    • ergonomic changes
    • two printers
  • third terminal
  • cameras
  • back room (overstock model)
  • anything else?

Promotions/Offers

  • Chinook Book
  • KBOO
  • People's
  • Citybikes/PAWC/ABC
  • Give Guide swag
  • Ubuntu Book
  • Bike Lights
  • Paco's Penguin suit and sandwich board (in 2011?)
  • Shirts/Swag
    • New Designs/Styles
    • Make/lose money on these? Cover Costs?

Other Events worth Mentioning

  • Lucid Rollout
  • Tony's medical leave

Thrift Store Sales Trends

  • Any trends in store sales that are worthy of exploration, along with some analysis of each (cause/effects)

Thrift Store Staffing

  • from db: Hours breakdown by category (see discussion tab for specific reports)
  • Trends and comparisons with store income
  • Volunteer Internships
    • from db: total volunteer hours by month? (see discussion tab)

data mining

specific reports that would be useful (that involve sql)

Monthly breakdown by work category, by all workers
Thrift Store
Sales Admin
Thrift Store Admin
Safari
Monthly breakdown only for Sales regular staff
Meeting
Mtg Prep (small, but what the heck?)
Training (I've used this sometimes while training interns, but it'll be trivial)
Thrift Store regular staff

(would want to look at all hours from above categories, by month)

Leah
Paco
Ian
Mike
Tony
Luiz (before Day X)
Store/Sales Part timers

(These folks have other primary focus, so we should only look at the sales-specific categories)

Ebeth
Sergio
Luiz (after Day X)

Online Sales Narrative

What happened/changed here?

  • Story (saga) of the online sales commission position
  • State of oversight
    • no more official Online Sales Coordinator
    • Sales committee and AT juggle responsibilities currently (right?)
  • Hours (see discussion tab for SQL ideas)
  • Income
  • Types of items we tried and results
  • Policy considerations, BAN

Bulk Sales Narrative

What happened/changed here?

  • Scraptops eliminated as-is laptops "from the back" and from Safari
  • Safari (RIP) moved to Saturdays, then killed in November due to....
  • Gentech for printers:
    • Total sales in 2010 of $20,872.45 (yowza!)
  • some policies put together, but no current bulk buyers except Gentech
  • Totals for any known bulk buyers (MG?)
  • Luiz' role of "handler" not filled
  • Jake handles printer bulk sales, including Gentech, but out of Sales discussions
  • Nobody at the wheel

Other

  • Rentals? Serge...you have any data on this?

Looking Ahead

  • Do we want to include 2011 planning as part of this, or take it on as separate. I'm leaning toward the latter.