All templates
For ice cream plant managers, frozen dessert production leads & operations finance

Flag yield variance before it hits your margin

Every night, WebRun opens Mar-Kov, compares each batch's actual yield to its formulated expected yield, pulls the ingredient cost per unit from QuickBooks to estimate the dollar impact of any shortfall, and logs a variance report to Google Sheets ranked by cost impact so the biggest losses get looked at first.

  • No credit card
  • Under $0.01 per run
  • Cancel anytime
14,115 templates Safe automation No code
Every night after production close WebRun
1 Mar-Kov compare actual to expected yield
2 QuickBooks price the yield gap
3 Google Sheets log the variance report
Run a sample
In short

How do I catch production yield variance before it erodes margin?

WebRun compares each batch's actual yield to its formulated expected yield in Mar-Kov every night, then reads the per-unit ingredient cost from QuickBooks to estimate the dollar impact of any shortfall. It logs the results to a Google Sheet ranked by cost impact, so plant management can see which flavors, shifts, or batches are eating into margin first.

  • Yield losses are ranked by dollar impact instead of buried in a raw output list
  • The biggest margin risk gets reviewed the next morning instead of at month end
  • Nothing is posted to QuickBooks, so your books stay exactly as your accountant left them

Built for ice cream plant managers · frozen dessert production leads · operations finance · co-packers tracking COGS

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens mar-kov.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    Mar-Kov - compare actual to expected yield
    mar-kov.com How to Automate Mar-Kov
    WebRun in Mar-Kov: compare actual to expected yield
    WebRun opens Mar-Kov to compare actual to expected yield.
    • Open Mar-Kov and pull every batch run today with its actual output and its formulated expected yield
    • Calculate the variance in gallons or units for each batch
    • Note the flavor and shift for each batch with a variance

    Done when Every batch run today has its actual yield, expected yield, and variance calculated.

  3. 2
    QuickBooks - price the yield gap
    • Look up the current per-unit ingredient cost for each flavor with a yield variance
    • Multiply the shortfall by the per-unit cost to estimate the dollar impact
    • Read costs only. Do not create or post any entry in QuickBooks

    Done when Every variance has an estimated dollar impact based on current ingredient costs.

  4. 3
    Google Sheets - log the variance report
    google.com How to Automate Google Sheets
    WebRun in Google Sheets: log the variance report
    WebRun opens Google Sheets to log the variance report.
    • Open the Yield Variance Report sheet
    • Add a row per batch with flavor, shift, variance amount, and estimated dollar impact
    • Sort the day's batches by dollar impact, highest first

    Done when Today's variance report is logged and sorted by cost impact.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
mar-kov.com
ScheduleRuns automatically on this cadence
Every night after production close
DeliveryHow each run's result reaches you
Variance report · Google Sheets
OutputWhat each run produces - A daily variance report ranked by dollar impact, with the flavor, shift, and shortfall for every batch that missed expected yield.
Spreadsheet
Setup & safety

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.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Does it post anything to my accounting in QuickBooks?

No. WebRun only reads the current per-unit ingredient cost from QuickBooks to estimate dollar impact. It never creates, edits, or posts a journal entry or bill.

What counts as a yield variance?

Any batch whose actual output falls short of the expected yield calculated from its Mar-Kov formulation. Even a small shortfall is logged, though the sheet ranks the biggest dollar impacts first.

Is the dollar impact exact?

It's an estimate based on current per-unit ingredient cost from QuickBooks, useful for spotting trends and prioritizing which batches to investigate, not a substitute for a full cost accounting review.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.