Difference between revisions of "Sales Report 2010"

From FreekiWiki
Jump to navigation Jump to search
(saving bc sergio is interrupting me)
 
(4 intermediate revisions by the same user not shown)
Line 15: Line 15:
 
*Any thoughts on 'why'?
 
*Any thoughts on 'why'?
 
*Any changes in testing procedures that affected sales?
 
*Any changes in testing procedures that affected sales?
 +
*Cell phones
  
 
===Policies===
 
===Policies===
Line 61: Line 62:
  
 
==Thrift Store Staffing==
 
==Thrift Store Staffing==
*from db: Hours breakdown by "sales admin," "thrift store" over the year, monthly
+
*from db: Hours breakdown by category (see discussion tab for specific reports)
 
*Trends and comparisons with store income
 
*Trends and comparisons with store income
 
*Volunteer Internships
 
*Volunteer Internships
**from db: total volunteer hours by month?
+
**from db: total volunteer hours by month? (see discussion tab)
**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 category, totalls
 
**
 
  
 
==Online Sales Narrative==
 
==Online Sales Narrative==
Line 80: Line 75:
 
**no more official Online Sales Coordinator
 
**no more official Online Sales Coordinator
 
**Sales committee and AT juggle responsibilities currently (right?)
 
**Sales committee and AT juggle responsibilities currently (right?)
*Hours
+
*Hours (see discussion tab for SQL ideas)
 
*Income
 
*Income
 
*Types of items we tried and results
 
*Types of items we tried and results

Latest revision as of 15:23, 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?
  • 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)


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.