Separate data for draft vs. bottled beer
I want to calculate a separate pour cost for draft beer and bottled beer.
Thank you all for your feedback.
If you want break down beer cost to draft beer on hand vs. bottle beer on hand, just follow these steps:
1) One-time setup: Put the ‘Draft’ or ‘Bottle’ in the Product Code field for each beer you carry at partender.com/setup
2) From then on, every time you get your inventory report, sort by Product Code
3) Highlight all the wholesales values that pair with the respective product code, then you will easily see your total beer cost for draft vs. bottle.
We are planning ability to filter in the Analytics portal (partnder.com) by containers (e.g. keg vs. bottle), to easily see COGS as well as Value on Hand by additional filters. You’ll be able to export this data to Excel if needed.
If you’re using Value on Hand on the inventory spreadsheet to calculate your beverage cost, you’re doing extra steps and manual cacluations!
If you use the Partender Beverage Cost calculator and send all your orders via Partender, we’ll do all that number crunching for you automatically!
Same problem. What we have done to track Draft v/s Bottle is when entering new draft beer, we label them all as Beer: Type: ALE.
Thus when looking at out reports, all the ALE is draft, and all other beer is bottle. IT's not perfect, but it's a solution
Same here. This is the one major flaw in this inventory program.
Yes same here.