Free OpenClaw Skill for Craft Breweries: Production and Distribution Agent (Download)

What this skill does for your craft breweries

• Drafts the next 4-week production schedule from Ekos Brewmaster or Beer30 against forecasted demand, tank turn rate, and yeast generation count.
• Reconciles distributor depletion reports (RNDC, Southern Glazer's, Breakthru, Reyes) against your shipment manifest and flags any account-level inventory cliff before the order goes out.
• Runs the weekly taproom event operations: trivia, brewery tours, beer release crowd estimates, with Arryved POS-driven staffing forecasts.
• Compiles the monthly TTB excise tax report and Brewers Association BBL tracker, with the variance from last month called out by SKU.
• Drafts the wholesale-rep weekly check-in across distributors with the depletion trend, the next week's release calendar, and a one-line ask per rep.

What's inside this OpenClaw skill

The full file you download, indexed below for search engines and for operators who want to read before they install.

---
name: brewery-production-and-distribution
description: Brewhouse production scheduling, distributor depletion reconciliation, taproom event operations, and Brewers Association reporting for craft breweries. Integrates with Ekos Brewmaster, Beer30, Arryved, RNDC, Southern Glazer's, Breakthru, Reyes.
version: 1.0.0
author: OpenClaw Consult (Adhiraj Hangal)
license: MIT
url: https://openclawconsult.com/skills/craft-breweries
---

# OpenClaw Skill: Craft Brewery Production and Distribution Coordinator

## Overview

This skill turns the OpenClaw agent into a production and distribution
coordinator for a craft brewery. It owns the 4-week brewhouse production
schedule, the weekly distributor depletion reconciliation, the taproom
event staffing, and the monthly TTB excise and Brewers Association BBL
reporting. The brewmaster still makes the beer. The agent absorbs the
spreadsheet work.

Designed for production craft breweries running 500 to 15,000 BBL annual
volume on Ekos Brewmaster, Beer30, Five x 5, or OrchestratedBEER, with
Arryved, Toast, or Square at the taproom and distribution through RNDC,
Southern Glazer's, Breakthru, Reyes, or a regional independent distributor.

## What this skill does

1. Drafts the rolling 4-week production schedule keyed to tank turn rate, yeast generation, and forecasted depletion
2. Reconciles weekly distributor depletion against shipments, flags account-level cliffs
3. Runs taproom event ops: trivia, tours, release-day staffing forecasts off Arryved
4. Compiles monthly TTB excise tax tracker and Brewers Association BBL ledger
5. Drafts weekly wholesale-rep check-in across all distributors
6. Flags tier-system compliance issues before the operator commits to a deal

## Triggers

```yaml
triggers:
  - type: heartbeat
    schedule: "0 7 * * 1"            # Mondays 7am, production schedule draft
    action: weekly_production_schedule_draft

  - type: heartbeat
    schedule: "0 9 * * 2"            # Tuesdays 9am, distributor reconciliation
    action: distributor_depletion_reconcile

  - type: heartbeat
    schedule: "0 14 * * 3"           # Wednesdays 2pm, wholesale rep check-ins
    action: wholesale_rep_check_in_draft

  - type: heartbeat
    schedule: "0 10 1 * *"           # 1st of month 10am, TTB tracker
    action: monthly_ttb_and_ba_tracker

  - type: on_event
    event: ekos.brew_logged
    action: update_tank_state

  - type: on_event
    event: arryved.event_scheduled
    action: forecast_event_staffing

  - type: on_event
    event: distributor.depletion_report_received
    action: trigger_reconciliation
```

## Workflow: production schedule

Every Monday at 7am the agent:

1. Reads tank state from Ekos Brewmaster or Beer30 (fermenting, brite, packaging, empty)
2. Reads yeast generation count for each strain
3. Pulls forecasted depletion from the distributor 4-week trailing average plus seasonal adjustment
4. Reads taproom forecast for the upcoming 4 weeks (festivals, releases, regular cadence)
5. Drafts the next 4 weeks of brew dates by SKU, mapped to tank assignments
6. Routes to the brewmaster for approval

The schedule respects:

```yaml
production_rules:
  - yeast_generation_max: 8
  - tank_turn_minimum_days: 14
  - dry_hop_window_days: [4, 7]
  - lager_lagering_minimum_days: 28
  - sour_residency_minimum_days: 45
  - allergen_segregation: peanut_porter_isolated_to_tank_5_only
```

## Workflow: distributor depletion reconciliation

Each Tuesday morning, the agent processes the weekly depletion reports:

1. Parses the RNDC, Southern Glazer's, Breakthru, Reyes weekly CSV or PDF
2. Reconciles against your shipment manifest for the same week
3. Computes net inventory change at the distributor level
4. Computes account-level depletion vs the 4-week trailing average
5. Flags accounts +/-25% from trailing average for a wholesale-rep call
6. Drafts the Slack summary and the rep-by-rep follow-up notes

Accounts on the watchlist:

```yaml
watchlist_logic:
  - cliff_threshold: -25%   # depletion below 4-week average
  - spike_threshold: +35%   # depletion above 4-week average
  - inventory_aging_threshold: 35d
  - SKU_release_proximity_days: 30
```

## Workflow: taproom event operations

When an event is scheduled in Arryved or on the taproom calendar:

1. Pulls historical comparable events (same day-of-week, same season, similar marketing reach)
2. Estimates crowd from the comparable basis
3. Drafts the staffing plan: pourers, kitchen, security if needed
4. Drafts the social and email push 7 days and 24 hours before
5. Forecasts the beer pull-through and flags any keg shortage risk
6. Logs the actuals after the event for next time's comparable basis

## Workflow: wholesale rep check-in

Every Wednesday at 2pm the agent drafts a one-message-per-rep check-in:

- Recent depletion trend (last 4 weeks, last week)
- Account cliffs the rep should call this week
- Release calendar for the next 4 weeks
- One specific ask (placement at X account, ride-along at Y account, etc.)

The operator approves each message before send. After two weeks of clean
drafts, the operator can flip the standard depletion-summary section to
autonomous and keep the asks human-approved.

## Workflow: TTB and Brewers Association reporting

On the 1st of each month the agent:

1. Aggregates the previous month's production by SKU from Ekos or Beer30
2. Maps each SKU to its tax class (regular, low ABV, etc.)
3. Computes the excise liability per TTB Form 5130.9 categories
4. Compares against the previous 3 months for variance
5. Flags any variance above the operator-set threshold
6. Drafts the BA BBL tracker entry for the annual survey

The operator does the final TTB filing. The skill's job is to surface the
variance and to keep the BA tracker current so the annual survey is one
afternoon, not one week.

## Message templates

```yaml
templates:
  production_schedule_draft:
    channel: slack
    body: |
      WEEK OF {week_start} PRODUCTION SCHEDULE
      Mon: {monday_brews}
      Tue: {tuesday_brews}
      Wed: {wednesday_brews}
      Thu: {thursday_brews}
      Fri: {friday_brews}
      Total BBL: {total_bbl_planned}
      Tank assignments: {tank_assignments}
      Yeast generation notes: {yeast_notes}

  distributor_reconciliation_summary:
    channel: slack
    body: |
      DISTRIBUTOR RECONCILIATION (week of {week_start})
      RNDC: {rndc_net_inventory_change} BBL
      Southern Glazer's: {sgws_net_inventory_change} BBL
      Breakthru: {bkn_net_inventory_change} BBL
      Reyes: {reyes_net_inventory_change} BBL
      Watchlist accounts: {watchlist_count}
      Calls to make this week: {calls_to_make}
      Full account-level detail: {memory_link}

  wholesale_rep_check_in:
    channel: email
    subject: "{brewery_name} weekly update for {rep_first_name}"
    body: |
      Hi {rep_first_name},

      Quick weekly update:

      Last 4 weeks depletion (your book): {rep_book_depletion_trend}
      Account cliffs to call this week:
      {watchlist_accounts_for_rep}

      Releases in the next 4 weeks:
      {release_calendar_for_distributor}

      One ask from us this week: {weekly_ask}

      Reach back any time.

      {brewery_name} wholesale team

  release_event_social:
    channel: instagram_draft
    body: |
      RELEASING {release_date}: {beer_name}

      {beer_description_short}

      Pours start {open_time} at the taproom. Limited cans on the line at
      noon ({can_count} cases).

      {beer_hashtags}

  ttb_excise_variance_alert:
    channel: slack
    body: |
      TTB MONTHLY EXCISE VARIANCE
      Month: {month}
      Total BBL produced: {bbl_produced}
      Excise liability estimated: {excise_liability}
      Variance vs trailing 3-month: {variance_percent}
      Driver: {top_sku_variance}
      Action: {recommended_action}
```

## Memory keys

```yaml
memory:
  - key: brewery.tank_state[{tank_id}]
    description: Current tank status, beer in tank, target packaging date
    schema: { status: string, beer: string, started: date, target_pkg: date }

  - key: brewery.yeast_generation[{strain]
    description: Current yeast generation count per strain
    schema: { generation: number, last_pitched: date, max_generation: number }

  - key: brewery.distributor_depletion[{distributor_id}][{week}]
    description: Weekly depletion vs shipment per distributor
    schema: { depletion_bbl: number, shipment_bbl: number, net_change: number }

  - key: brewery.account_depletion[{account_id}]
    description: 4-week trailing depletion average per account
    schema: { trailing_4w: number, last_week: number, watchlist: bool }

  - key: brewery.ttb_monthly[{month}]
    description: Production and excise per SKU per month
    schema: { sku_totals: object, excise_liability: number, variance: number }

  - key: brewery.event_actuals[{event_id}]
    description: Actual crowd, pull-through, staffing for past events
    schema: { crowd: number, bbl_pulled: number, staff_count: number }
```

## Required integrations

| Integration              | Purpose                                          | Read | Write |
|--------------------------|--------------------------------------------------|------|-------|
| Ekos Brewmaster / Beer30 | Tank state, yeast log, packaging                 | yes  | optional |
| Five x 5 / OrchestratedBEER | Production schedule (CSV)                     | yes  | no    |
| Arryved / Toast / Square | Taproom transactions and event calendar          | yes  | optional |
| RNDC / Southern Glazer's / Breakthru / Reyes | Weekly depletion reports     | yes  | no    |
| Twilio                   | Outbound SMS for taproom staff                   | no   | yes   |
| Email provider           | Outbound email for wholesale reps                | no   | yes   |
| Slack                    | Operator alerts and standup                      | no   | yes   |
| OpenClaw Memory          | Tank state, distributor depletion, TTB tracker   | yes  | yes   |
| OpenClaw Heartbeat       | Weekly and monthly cadences                      | yes  | yes   |

Write-backs to Ekos Brewmaster or Beer30 are optional. Most breweries
start read-only and have the brewmaster commit any changes manually.

## Compliance notes

The skill compiles the data for TTB Form 5130.9 (monthly excise tax) and
the BA annual BBL survey. It does not file with TTB on your behalf. The
final filing call stays with the operator.

The three-tier system (producer / wholesaler / retailer) compliance is
jurisdiction-specific. The skill flags any proposed action that would
cross a tier line and cites the rule. The final compliance call stays
with the operator.

## Configuration

```yaml
config:
  brewery_name: "Your Brewery"
  annual_bbl_target: 3500
  brewhouse_size_bbl: 30
  tank_count_fermenter: 8
  tank_count_brite: 4
  distributors:
    - name: RNDC
      states: ["CA", "TX"]
    - name: Southern_Glazers
      states: ["FL", "AZ"]
  taproom_pos: arryved
  brewhouse_system: ekos_brewmaster
  approval_mode: brewmaster_approves_all   # or "autonomous_after_2_weeks"
  autonomous_template_allowlist:
    - distributor_reconciliation_summary
    - release_event_social
  watchlist_thresholds:
    cliff: -25
    spike: 35
    inventory_aging_days: 35
  yeast_generation_max: 8
  ttb_variance_alert_threshold: 0.15
```

## Quick install

```bash
mkdir -p ~/.claude/skills
mv craft-breweries.md ~/.claude/skills/brewery-production-and-distribution.md
# Edit the config block to match your brewery
```

Launch OpenClaw and the skill is live. Trigger it manually with
`run distributor reconciliation` or `draft production schedule` or wait
for Heartbeat to fire on the configured cadence.

## Want it wired to your stack?

This SKILL.md is the starting point. If you want it plugged into your
specific brewhouse system, distributor mix, taproom POS, and release
calendar on a fixed-price two-week clock, the door is at
https://www.adhirajhangal.com/work

Install in 60 seconds

1. 1

   Drop the file into your OpenClaw skills directory

   Save the downloaded craft-breweries.md as ~/.claude/skills/brewery-production-and-distribution.md (or your project-level .claude/skills/). OpenClaw picks up new skill files on next agent launch.

2. 2

   Connect Ekos Brewmaster, Beer30, or your brewhouse system plus Arryved

   Edit the integrations block to point at your Ekos Brewmaster, Beer30, or Five x 5 export, your Arryved or Toast taproom POS, and your distributor depletion reports (typically the weekly CSV or PDF from RNDC, Southern Glazer's, Breakthru, or Reyes). Read access is enough to start.

3. 3

   Launch in approval mode and flip the routine workflows to autonomous in two weeks

   Start with the production manager approving every brew schedule, distributor message, and event staffing plan for the first two weeks. The skill's defaults route any TTB excise variance, any distributor pricing issue, and any tank-related decision to a human. After two weeks, flip the wholesale-rep weekly check-in and the taproom event staffing to autonomous.

Example conversation

Common questions

Related free skills