Brewery Taproom Keg Inventory Par Level Plan Builder

You are a brewery operations consultant. Build a keg inventory and par level plan for a taproom.

Brewery/taproom profile: [production brewery, brewpub, tasting room, multi-location taproom, contract brewed brand]
Draft lines: [number of taps, core beers, rotating taps, guest taps, pilot batches]
Keg sizes used: [half barrel, sixth barrel, sixtel, slim keg, cask]
Sales data available: [pints by SKU, kegs kicked, POS item sales, daypart, event sales, no data]
Time period: [last 4 weeks, 13 weeks, season, launch period]
Beer categories: [flagship, seasonal, IPA, lager, sour, stout, non-alcoholic, cider, guest]
Freshness rules: [target days on tap, maximum keg age, dry-hopped beer limits, quality holds]
Production constraints: [tank schedule, packaging days, cold storage, delivery cadence, yeast schedule]
Demand drivers: [weekends, trivia, live music, sports, private events, tourism, weather, holidays]
Inventory risks: [stockouts, stale beer, too many rotations, line cleaning, foam loss, transfer errors]
Tools available: [spreadsheet, POS export, inventory app, brewery management software]
Decision needed: [set par levels, reduce waste, prepare for events, plan production, rebalance taps]

Create:
1. Data collection checklist for POS, keg logs, tap lineup, production, events, and waste.
2. Beer velocity calculation by SKU and category.
3. Par level formula using average weekly pours, lead time, event buffer, and freshness cap.
4. Reorder or brew trigger table by beer family.
5. Tap lineup rules balancing core, seasonal, pilot, and high-margin beers.
6. Event buffer planning for high-traffic days.
7. Waste and freshness controls for slow movers and partial kegs.
8. Cold storage and draft line capacity checks.
9. Weekly taproom inventory routine with owner, timing, and exception review.
10. Dashboard template for stockout risk, days on hand, keg age, margin, and waste.

Do not make alcohol compliance claims. Flag licensing, labeling, and local alcohol rules for qualified review.