Difference between revisions of "Sales Report 2010"

From FreekiWiki
Jump to navigation Jump to search
(saving bc sergio is interrupting me)
Line 71: Line 71:
 
specific reports that would be useful (that involve sql)
 
specific reports that would be useful (that involve sql)
  
*Monthly breakdown by category, totalls
+
*Monthly breakdown by work category, by each worker
**
+
**Thrift Store
 +
**Sales Admin
 +
**Thrift Store Admin
 +
**Safari
 +
**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
 +
 
 +
Store/Sales Part timers
 +
(These folks have other primary focus, so we should only look at the sales-specific categories)
 +
*Ebeth
 +
*Sergio
 +
*Luiz
  
 
==Online Sales Narrative==
 
==Online Sales Narrative==

Revision as of 15:02, 21 January 2011

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?

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 "sales admin," "thrift store" over the year, monthly
  • Trends and comparisons with store income
  • Volunteer Internships
    • from db: total volunteer hours by month?
    • from db: total # of interns, with total hours from each (are we relying on a couple "super" interns? Are they all putting in about the same before they move on?)


data mining

specific reports that would be useful (that involve sql)

  • Monthly breakdown by work category, by each worker
    • Thrift Store
    • Sales Admin
    • Thrift Store Admin
    • Safari
    • 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

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

  • Ebeth
  • Sergio
  • Luiz

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
  • 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.