I was a software developer in a past life so.....
I used MySQL and created an extensive coffee database that tracks everything.
o Suppliers
o Inbound bags of green beans
o Roasts
o Customers
o Outbound bags of roasted beans
What this allows me to do is .... just about anything I want, including:
1. Track green & roasted inventory at the push of a button.
2. Look at my month-on-month sales and profitability.
3. Track customer usage (with automatic loyalty program).
4. Compare roast losses with different bags of the same green coffee.
5. Find previous similar old roasts, so I know how a current roast should behave.
I'm currently working on an HTML front-end so data entry is more friendly.
I'm also trying to add a new thermocouple to my roaster so the roast data not only shows up using Artisan but also is recorded automatically in my database.
It's all a labor of love and I probably couldn't justify the amount of work I have done on this.
I just couldn't stand not really knowing how my business was going.
I used to keep stuff on paper. Lots and lots of paper.