# Home Bar Inventory & Cocktail Batch Calculator

Free template by [Knot & Style](https://knotandstyle.com), makers of 18 x 12 in rubber bar mats.

## Inventory (make this a database)
Properties: Item (title), Category (select), Bottle size ml (number), On hand (number), Par (number), Price (number).
Formulas:
- To buy: `max(0, prop("Par") - prop("On hand"))`
- Restock cost: `prop("To buy") * prop("Price")`
- Status: `if(prop("On hand") < prop("Par"), "Restock", "OK")`

| Item | Category | Bottle size ml | On hand | Par | Price |
|---|---|---|---|---|---|
| Vodka | Spirit | 750 | 1 | 2 | 25 |
| Gin | Spirit | 750 | 1 | 1 | 30 |
| White rum | Spirit | 750 | 0 | 1 | 20 |
| Tequila blanco | Spirit | 750 | 1 | 1 | 35 |
| Bourbon | Spirit | 750 | 2 | 1 | 35 |
| Triple sec | Liqueur | 750 | 1 | 1 | 20 |
| Sweet vermouth | Fortified wine | 750 | 0 | 1 | 15 |
| Simple syrup | Mixer | 500 | 1 | 2 | 5 |
| Club soda | Mixer | 1000 | 2 | 4 | 2 |

## Batch calculator (make this a database)
Properties: Ingredient (title), Per drink oz (number), Servings (number), Dilution (number, e.g. 0.2).
Formulas:
- Batch oz: `prop("Per drink oz") * prop("Servings")`
- Batch ml: `round(prop("Batch oz") * 29.5735)`
- Water for dilution oz: `prop("Batch oz") * prop("Dilution")`

| Ingredient | Per drink oz | Servings | Dilution |
|---|---|---|---|
| Bourbon | 2 | 12 | 0.2 |
| Sweet vermouth | 1 | 12 | 0.2 |
| Angostura bitters (≈2 dashes) | 0.06 | 12 | 0.2 |

Tip: stirred drinks usually take about 20–25% water and shaken drinks about 25–30%. Chill the batch, and set a bar mat under the pitcher to catch drips. [knotandstyle.com](https://knotandstyle.com)