Brewery Inventory Management (Production Management)

1. Setting up new items in Inventory.
2. Adding or reducing inventory:
   • From Brooklyn brewsheets.
   • Directly in the Inventory Log tab.
   • Reducing Jack's Abby brew ingredients per brew.
   • Reducing packaging inventory from the Batch Splits tab (both BK and JA).

Key spreadsheets: the Inventory tab (master inventory center), the Inventory Log tab (feeds the Inventory tab via formulas), the Inputs tabs (source of truth for new item setup), the Wholesale Planning Worksheet in Current Wholesale Reporting, and the Batches, Batch Splits, Recipes, and Brewsheets tabs in Production Management.

Flow of info: source of truth → Inputs tabs (malt, packaging materials, labels, yeast, hops) → Inventory tab → Recipes, Grain Order, Hop Order, Inventory Log, individual Brewsheet tabs, COGS sheets.

1. Add the new item to the relevant Inputs tab (new malt goes in maltinputs, new hops in hopinputs, etc.) - this makes it available in Inventory tab dropdowns (Column B - Item ID, Column H - Cost/Unit).
2. Add a new row to the Inventory tab.
3. Fill in the black-text (input) columns: Column B "Item ID," Column C "Type," Column D "Location," Column I "Unit."
4. Pull down formulas for the red-text (formula) columns: Column A "Item ID + Location," Column E "Current Inventory," Column H "Inventory Differential," Column K "$ on Hand."
5. The price entered in the Inputs tab in step 1 is the same price pulled into Column H via formula.
6. Once set up, the item becomes a dropdown option in the Recipes, Grain Order, Hop Order, Inventory Log, and individual Brewsheet tabs.

1. On the day the action takes place, click the reduce inventory button on the brewsheet.
2. In the Inventory Log tab, click Copy Formulas From Row 7 to New Rows to pull formulas into Columns A and J (Column J checks that the item exists in the Inventory sheet). Any #N/A in Column J means the item isn't set up properly - repeat the new item setup process above.
3. In the Batches tab, find the batch ID and confirm there's an X in the relevant column (AE, AF, or AH) for the reduction you just made.

Checklist: reductions reflected line by line in Inventory Log; Column A is a formula, not text; no #N/A in Column J; correct X in Batches columns AE/AF/AH.

Use this when inventory arrives in BK or Jack's Abby, for reductions outside the brewsheet or packaging-materials buttons, or for adjustments from manual physical counts.

1. If there's an entry in the Orders Placed tab, copy and paste it into the Inventory Log tab - otherwise skip to the next step.
2. Scroll to the bottom of the Inventory Log tab and fill in Columns B through G.
3. Click Copy Formulas from Row 7 to New Rows to pull down formulas for Columns A and H.
4. If there was an Orders Placed entry, delete the original once it's in the Inventory Log.

Checklist: reductions reflected line by line with a date; Column A is a formula; no #N/A in Column J; original Orders Placed entry deleted.

BK brews reduce from individual brewsheets; Jack's Abby reduces from the Batches tab.

1. In the Batches tab, find the row for the brew you want to reduce.
2. Confirm the Recipe ID (Column T) and Batch Size (Column D) are accurate - formulas scale by batch size (e.g., a 240 bbl tank set up for a 60 bbl recipe auto-multiplies by 4x).
3. Click any cell in the row and hit Reduce Jacks Ingredient Inventory, following the prompts.
4. In the Inventory Log tab, confirm all ingredients pulled in correctly, then click Copy Formulas from Row 7 to New Rows for Columns A and H.

Checklist: reductions reflected line by line; Column A is a formula; no #N/A in Column J; correct X in Batches column AG.

1. In the Wholesale Planning Worksheet (Current Wholesale Reporting), input final packaging totals into Column H (Count) - BK numbers come from the #packaging-splits-brooklyn Slack channel, Jack's Abby numbers from an email with final packaging figures.
2. Copy Columns B through H and paste-over-values (not formulas) into the Batch Splits tab.
3. In Batch Splits, drag down formulas for Columns B-C and H-AF (red text); Columns A, D, E, F, G stay static from the pasted values.
4. Confirm no X in Column AA for the newly added rows - delete any that appear.
5. Click Reduce Inventory, enter the relevant rows and packaging details (PakTek color, bottle color if applicable), and submit.
6. Delete the old "unplanned" row for that batch (filter by batch ID to find it).
7. In the Inventory Log tab, click Copy Formulas From Row 7 to New Rows to confirm the pull-through, checking for #N/A in Column J.
8. In the Wholesale Planning Worksheet, change Column A from "Confirmed" to "Added to BS" for the rows just moved.

Checklist: Column A toggled to "Added to Batch Splits"; Batch Splits Columns I/J show total yield with no #N/A; Column AA has X's post-reduction; Inventory Log reductions accurate with no #N/A.

An #N/A almost always means an item isn't fully set up in the Inventory tab - go back to the new item setup steps rather than trying to force the formula.