Skip to main content
ExactPour logo

Public tools

Transparent beverage inventory calculators

Change the inputs and inspect the math. Calculations run in your browser and are not saved to an ExactPour account. These are simplified teaching versions (no transfers, credits, or multi-location rollups). ExactPour applies the fuller identities from your counts and POS. See bar inventory software.

Pour cost calculator

Estimate period beverage cost used and express it as a share of beverage sales. A shorter Toast-owner planner also lives at /pour-cost-calculator.

Pour cost period values
Cost used$2,700.00Pour cost22.50%

Formula

Cost used = beginning inventory cost + purchases − ending inventory cost

Pour cost % = cost used ÷ beverage sales × 100

Assumptions and limits

All values cover the same period, location, and beverage categories. This simplified version assumes transfers, credits, and returns are zero or already reflected in the entered values. Beverage sales exclude any amounts your accounting policy does not treat as beverage revenue.

Read the method

Par level calculator

Turn counted usage into a well or cage par. A dedicated planner also lives at /par-level-calculator.

Par level inputs
Average daily usage2.00Coverage need8.00Suggested par10.00

Formula

Daily usage = usage in the period / days in the period

Par = daily usage * coverage days + safety stock

Assumptions and limits

Usage must come from a counted period (beginning plus receiving minus ending). Coverage days should match the real delivery gap. Safety stock is extra units for a late truck or a spike night, not a month of fear.

Read the method

Variance diagnostic

Compare measured usage with recipe-based usage in one consistent quantity unit.

Variance period values in one consistent unit
Actual / projected65.00 / 55.00Usage variance8.00Measured usage is higher.Cost equivalent$6.40

Formula

Actual usage = beginning quantity + received − ending quantity

Projected usage = items sold × recipe quantity

Usage variance = actual usage − projected usage − documented waste

Assumptions and limits

Transfers and returns are zero or already reflected. Every quantity uses the same unit. A positive result indicates excess measured usage after the entered waste adjustment; it does not determine a cause.

Read the method

Shrinkage dollar impact

Translate the gap between actual and projected beverage cost into dollars and percent of sales.

Shrinkage dollar impact inputs
Cost gap (actual − projected)$300.00Actual cost is higher than projected (unfavorable).Gap as % of sales2.50%Gap as % of projected16.67%

Formula

Cost gap = actual beverage cost used − projected beverage cost

Gap % of sales = cost gap ÷ beverage sales × 100

Gap % of projected = cost gap ÷ projected beverage cost × 100

Assumptions and limits

Projected cost should come from recipe-mapped POS sales for the same period as actual cost used. A positive gap is unexplained cost pressure, not a proven theft figure.

Read the method

Inventory days on hand

Estimate how many days of beverage usage your ending inventory represents.

Days on hand inputs
Daily cost usage$96.43Days on hand49.8

Formula

Daily usage = beverage cost used ÷ period days

Days on hand = ending inventory cost ÷ daily usage

Assumptions and limits

Cost used and ending inventory must use the same valuation method and beverage scope. Results are planning averages, not a reorder recommendation by themselves.

Read the method

Inventory cadence planner

Estimate the recurring labor implied by a chosen count interval.

Planned inventory count cadence
Average counts / month4.35Labor hours / month5.44Estimated labor / month$119.59

Formula

Average counts per month = 30.44 ÷ days between counts

Labor hours per month = counts per month × minutes per count × people ÷ 60

Labor cost per month = labor hours per month × loaded hourly labor cost

Assumptions and limits

30.44 is the average number of days per month in a 365.24-day year. Results are planning averages, not a schedule or a recommendation. They exclude setup, review, correction, and follow-up time unless included in minutes per count.

Read the method

Full-page tool

Bar ROI calculator

Estimate what shrinkage and manual count labor could be costing your bar each year. Three sliders, transparent assumptions you can audit, and results that update live in your browser (no email required to see them).

Open the ROI calculator
Optional

Get a copy + occasional inventory tips

The calculators above are free and never require an email. If you want these formulas and assumptions for later, leave your details and we will follow up with a copy plus occasional beverage inventory tips. No spam, unsubscribe anytime.

Calculator FAQ

Are these calculators free to use?
Yes. They run in your browser, are not saved to an ExactPour account, and do not require a trial signup.
How do these tools relate to ExactPour bar inventory software?
They teach the same formulas ExactPour computes automatically from barcode counts and POS sales. Use them to sanity-check a period, then see the full workflow on /bar-inventory-software.
Does a positive shrinkage gap prove theft?
No. A gap between actual and projected cost can come from over-pouring, comps, transfers, recipe errors, timing, or measurement error. Investigate before assigning a cause.

Related: Bar inventory software · 2026 inventory research notes · Guides

These educational estimates are not accounting, tax, legal, or employment advice. See the methodology and corrections policy.

Estimate, investigate, then automate

01

Estimate the period

Run pour cost, variance, or days-on-hand with numbers you already trust from a count or invoice.

02

Investigate the gap

Use the diagnostic views and linked guides before you assign a cause like theft or over-pour.

03

Automate the loop

ExactPour computes the same formulas from barcode counts and POS sales so you are not retyping them weekly.

Talk with ExactPour

Stop retyping the same formulas

These calculators are the same math ExactPour runs from barcode counts and POS sales. Book a walkthrough to see it on your bar.

14-day trial available · No credit card · Typical reply within one business day

Start tonight

Stop guessing where
your liquor money went.

Run ExactPour on your own bar for two weeks. See the leaks, the over-pours, and the dollars you can still save.

14 days free · No credit card · From $59/mo