toolbox
Home / Food, Cooking & Hospitality / Bar Inventory Revenue per Available Unit Calculator

Bar Inventory Revenue per Available Unit Calculator

Calculate bar revenue per available inventory unit to normalize sales against the average number of beverage units held or made available for sale during a period. The metric is useful when raw sales growth could simply reflect carrying more inventory, expanding the assortment, or increasing stock depth. By dividing revenue by the inventory units available, managers can compare how product availability is being converted into sales.

The calculator also shows revenue per unit sold and unit sell-through, giving context to the main revenue-per-available-unit figure. It is best used with consistent unit definitions—such as bottles, cans, kegs, or standardized case-equivalent units—rather than mixing unlike measures without conversion. Revenue per available unit is an operating productivity metric, not a valuation of inventory or a substitute for gross margin.

Revenue and inventory inputs

$
units
units
Result
—
Revenue per available unit
Revenue per unit sold—
Unit sell-through—
Unsold available units—

1. Enter bar revenue
Use revenue generated by the inventory pool during the selected period.

2. Enter average available units
Use the average quantity of sellable beverage inventory available during the same period, measured in one consistent unit.

3. Enter units sold
Provide the number of units sold from that pool to add sell-through and revenue-per-sold-unit context.

4. Check unit consistency
Do not mix bottles, cases, and kegs unless they have first been converted to a common equivalent unit.

5. Compare periods
Use the main ratio to compare how efficiently different inventory levels support revenue, then review sell-through to understand the volume component.

Revenue per available unit = Bar revenue ÷ Average available inventory unitsRevenue per unit sold = Bar revenue ÷ Units soldUnit sell-through = Units sold ÷ Average available inventory units × 100

Where:

Bar revenue = sales associated with the inventory pool for the period
Average available inventory units = average count of sellable units available during the period
Units sold = quantity sold using the same unit definition as available inventory

Assumptions: The calculator uses a simple period-average inventory quantity. If inventory changes sharply during the period, a daily or weekly average can give a more representative denominator.

What the result means

A higher revenue-per-available-unit value means the same amount of available inventory is supporting more sales, but it does not by itself reveal margin, stockout risk, or customer mix.

Use the metric with food or beverage cost, contribution margin, and service-level measures before changing safety stock or assortment depth.

Given:
$48,500 bar revenue
1,650 average available inventory units
1,280 units sold

Calculation:
Revenue per available unit = $48,500 ÷ 1,650 = $29.39
Revenue per unit sold = $48,500 ÷ 1,280 = $37.89
Sell-through = 1,280 ÷ 1,650 × 100 = 77.58%

Result:
Revenue per available unit ≈ $29.39

Interpretation:
Each available inventory unit supported about $29.39 of bar revenue during the period, while 77.58% of the modeled units were sold.

Should I use ending inventory as available units?

A period average is usually more representative than a single ending count when stock levels change during the period. If only one count is available, note that the ratio may be sensitive to timing.

Can I combine bottles and draft beer?

Only after converting them to a common unit that makes operational sense. Otherwise the denominator combines unlike quantities and the result becomes difficult to interpret.

What if units sold are zero?

The main revenue-per-available-unit result can still be calculated from revenue and available inventory, but revenue per unit sold is not meaningful when zero units are sold.

Does a higher value always mean inventory should be reduced?

No. A high value can indicate productive inventory, but cutting stock too far can cause stockouts, lost sales, or reduced assortment.

How is this different from inventory turnover?

Inventory turnover typically compares cost of goods sold with average inventory value. This tool compares sales revenue with available physical units, so it focuses on revenue productivity rather than accounting turnover.