Automated Brewery Production vs Plan Report
Every Monday, WebRun opens Crafted ERP, pulls last week's actual production volumes by batch and product line, compares them against the planned volumes in the production schedule, calculates the variance in barrels and percentage, logs everything to a Google Sheet, and posts a summarized production-vs-plan report to Slack for your leadership team.
How do I automatically compare actual brewery production against my production plan?
WebRun pulls actual production volumes from Crafted ERP every Monday, compares them against the planned schedule, and calculates barrel and percentage variances by product line. Results are logged to Google Sheets with cumulative totals and posted to Slack so leadership can review the week's production performance before the Monday standup.
- Leadership sees last week's production variance before the Monday meeting, without a manual pull
- Over-runs and under-runs are flagged automatically so planning conversations stay grounded in data
- Year-to-date variance builds in Google Sheets for annual target tracking
Built for craft breweries · wineries · distilleries · production managers · brewery owners · operations directors
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
app.craftederp.comin a real browser with your saved login - no setup, no API keys. -
1
Crafted ERP - pull actual production volumes for the week
craftederp.com
WebRun opens Crafted ERP to pull actual production volumes for the week. - Open Crafted ERP and navigate to production reporting
- Pull actual batch volumes completed in the prior week, grouped by product line
- Pull the planned production volumes for the same week from the production schedule
- Capture any batches that were deferred, cancelled, or started late
Done when Actual and planned volumes for the prior week are captured by product line and batch.
-
2
Google Sheets - calculate and log production-vs-plan variance
google.com
WebRun opens Google Sheets to calculate and log production-vs-plan variance. - Open the production-vs-plan Google Sheet
- Add a new weekly row for each product line with actual barrels, planned barrels, variance in barrels, and variance as a percentage
- Flag any product line where the variance exceeds 10% in either direction
- Update the cumulative monthly and year-to-date variance totals
Done when This week's production variance data is logged with flags and running totals updated.
-
3
Slack - post weekly variance summary to leadership
slack.com
WebRun opens Slack to post weekly variance summary to leadership. - Post a production-vs-plan summary to your leadership or operations Slack channel
- List each product line with actual vs planned barrels and the variance
- Call out the biggest over-runs and under-runs for discussion
- Include a link to the Google Sheet for full detail
Done when Leadership has this week's production variance summary in Slack before the Monday meeting.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Does it adjust the production plan automatically based on variances?
No. WebRun reports the variance for your leadership team to review. Any adjustments to the production plan are made by your team in Crafted ERP after reviewing the report.
What counts as a meaningful variance worth flagging?
By default it flags any product line where actual production differs from plan by more than 10%. You can adjust this threshold to match your operational tolerance during setup.
Can it show year-to-date production against annual targets?
Yes. The Google Sheet is set up with cumulative monthly and year-to-date totals, so each week's run automatically updates the rolling performance picture against your annual production targets.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.