What kind of data do you record as part of your shop operations? Right now
we use a somewhat abused set of spreadsheets to track our pertinent info,
but I'm in the process of creating a more task-specific database (a web
app) to handle it all better. Here is what we track now:
- Volunteer hours (to add volunteer sweat equity credit to volunteers'
records)
- Sweat equity used (to subtract credit for purchase of bikes, parts, stand
time)
- Bike sales: Bike ID, how it was paid (cash/equity), how it will be used
Our cash & credit sales are tracked independently on a POS/register.
Right now that is all done on paper, then later entered into the
spreadsheets. It's kind of a cumbersome process, but visitors are
comfortable with a paper sign-in sheet, and volunteers are comfortable with
a spreadsheet (vs. a database).
We don't track overall number of shop visitors (although we do hang on to
our paper sign-in sheets), or gross volume of stand time provided. While we
have contact info for all visitors on a waiver they fill out the first time
they come in the shop, we would probably have a difficult time if we needed
to quickly find an emergency contact for someone, since they are all just
on paper right now. I'd like to integrate that all together into the
database.
Since I'm writing this front desk app, I thought I'd ping the community to
see if these are common needs, or if there are other common needs that I
could consider as I develop it. I'd love for it to be useful enough to
offer to the broader community at some point.
-Andy
Broke Spoke Community Bike Shop
Lexington, KY