Difference between revisions of "Sales Report 2010"
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, | + | *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.