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