Skip to content
Inventory

Restaurant Stock Usage Calculator

Measure how much stock your restaurant actually consumed in a period — from inventory counts or purchase records — with daily usage, per-cover and per-sales-dollar rates, waste and shrinkage share, and weekly/monthly/annual projections.

Stock usage formulas

Formula
Inventory counts mode:
  Usage = Beginning + Purchases + Transfers In
          − Ending − Transfers Out − Returns

From purchases mode:
  Usage = Purchases − Returned Inventory − Ending Inventory Adjustment

Shared:
  Adjusted Usage = Usage + Waste + Shrinkage
  Average Daily Usage = Adjusted Usage ÷ Period Days (default 7)
  Usage per Customer = Adjusted Usage ÷ Covers
  Usage per Sales $ = Adjusted Usage ÷ (Daily Sales × Period Days)

What it means

Both modes answer the same question — how much stock left the shelf — from different records. The counts method reconciles two physical counts with everything that entered and exited between them, which makes it the accurate one. The purchases method approximates usage when you only have purchase records: it assumes what you bought was consumed unless it was returned or is still on hand. Waste and shrinkage are then added on top, because wasted and stolen stock was still consumed from the shelf even though it never reached a plate. The loss benchmark compares waste plus shrinkage against adjusted usage: at or below 2% is excellent, up to 4% good, up to 7% average, up to 12% high, and beyond that critical.

Good to know

  • All stock fields share one consistent measure — either units of one item/category or dollar values.
  • Counts are accurate and taken at consistent points (before deliveries, same day of week).
  • The purchases method assumes purchasing roughly tracks consumption over the period.

Ideal range

  • The purchases method is an estimate — it cannot detect shrinkage the way two physical counts can.
  • Projections assume the daily rate holds; seasonality, menu changes, and events will move it.
  • The loss benchmark bands are practical restaurant guidance, not an accounting standard — concept and category norms differ.

Variables

Beginning / EndingBeginning and ending inventory
Stock on hand at the start and end of the period, from physical counts. Units or dollars — just keep every field consistent.
PurchasesPurchases during period
Everything received into stock during the period, from invoices or receiving logs.
Waste / ShrinkageWaste and shrinkage
Documented waste and unexplained loss. Both are added to usage because they consumed stock without generating sales.
Period DaysPeriod length
Days the period covers. Drives the daily rate and the weekly, monthly, and annual projections. Defaults to 7.

Assumptions

  • Waste and shrinkage entries are for the same period as the counts or purchases.

Limitations

  • Negative usage from a bad count is reported as-is so you can spot the count error rather than hide it.

Worked examples

Real numbers through the same formula this tool uses.

  1. 1
    Restaurant scenarioExample 1

    Weekly usage from inventory counts

    Beginning 1,000 + purchases 800 + transfers in 50 − ending 600 − transfers out 20 − returns 30 = 1,200 units used. Adding 40 waste and 20 shrinkage gives adjusted usage of 1,260 — an average of 180 per day over the 7-day period.

  2. 2
    Restaurant scenarioExample 2

    Usage estimated from purchase records

    Purchases of 900 minus 50 returned to the supplier and 100 still on the shelf gives usage of 750. With 30 of logged waste, adjusted usage is 780 across 10 days — 78 per day.

  3. 3
    Restaurant scenarioExample 3

    Per-cover and per-sales-dollar rates

    A 5-day period with usage of 700 (adjusted 715 after 10 waste and 5 shrinkage), 250 covers, and $2,000 daily sales works out to 2.86 usage per customer and 0.0715 usage per sales dollar.

  4. 4
    Restaurant scenarioExample 4

    Tightly controlled loss share

    Usage of 1,100 with only 5 waste and 5 shrinkage puts adjusted usage at 1,110 and the loss share near 0.9% — comfortably in the excellent band.

How to use this calculator

Turn a count sheet or a purchase log into a usage rate you can plan purchasing around.

  1. Pick a calculation method

    Use Inventory counts when you have beginning and ending counts — it is the accurate method. Use From purchases when purchase records are all you have.

  2. Counts mode: enter the count sheet numbers

    Beginning inventory, ending inventory, and purchases are required. Add transfers in/out and supplier returns if stock moved between locations or went back on the truck.

  3. Purchases mode: enter what you bought

    Enter total purchases, then subtract anything returned to suppliers and anything from those purchases still sitting on the shelf at period end.

  4. Add documented waste and shrinkage

    Waste and shrinkage are consumed stock too. Entering them separately shows their share of usage and drives the loss benchmark.

  5. Optionally add period, sales, and covers

    Period days sets the daily rate (7 if blank). Daily sales unlocks usage per sales dollar; covers unlock usage per customer.

  6. Read the rates and act on the loss share

    Use average daily usage to size orders with the Purchase Order and EOQ calculators, and chase a high waste/shrink share with the Food Waste Calculator.

What is stock usage?

Stock usage is the amount of inventory your kitchen actually consumed over a period — everything that left the shelf for prep, plates, waste, or unexplained loss. It is the single number that connects your count sheet to your purchasing plan: whatever you used is roughly what you need to buy back.

  • Usage is what disappeared between two points in time

    Start with what you had, add what came in, subtract what is still there — the difference is what got used. That difference includes the burger that sold, the trim that hit the bin, and the bottle that vanished. Usage does not judge how stock left; it just measures that it left.

  • Why usage is worth tracking weekly

    Usage is the demand signal every purchasing decision depends on. Order quantities, par levels, safety stock, and reorder points are all multiples of how much you consume per day. A kitchen that knows its daily usage orders with confidence; one that guesses swings between stockouts and spoilage.

  • Two ways to measure it

    The counts method reconciles beginning and ending physical counts with purchases, transfers, and supplier returns — it is exact, and it is the only method that exposes shrinkage. The purchases method estimates usage from buying records alone, assuming what you bought was consumed unless it was returned or is still on hand. Use purchases as a bridge between counts, not a replacement for them.

  • Usage vs inventory turnover

    Usage is an amount; turnover is a speed. Consuming 1,260 units in a week is usage. Cycling your average inventory four times a month is turnover. You need usage to size the next order and turnover to judge whether the shelf is carrying too much or too little between orders. The two tools answer different questions from the same count sheet.

  • Usage vs food cost percentage

    Food cost percentage divides consumption dollars by sales dollars — it is a profitability ratio. Usage is the raw consumption underneath it. When food cost percentage spikes, usage analysis tells you whether the cause is real consumption growth, rising waste and shrink, or simply a bad count inflating the numerator.

  • The formula, in plain terms

    Counts mode: beginning + purchases + transfers in − ending − transfers out − returns. Purchases mode: purchases − returns − what is still on the shelf. Either way, adding documented waste and shrinkage gives adjusted usage — the true drain on inventory — and dividing by the period length gives the daily rate that drives every projection.

Habits that make usage numbers trustworthy

The math takes seconds; the discipline around counting and logging is what makes the result mean something.

  • Anchor the period to real count dates

    Usage is only defined between two counts. Count on the same weekday, before deliveries land, and enter the actual day span — a '7-day' period that was really 9 days understates daily usage by over 20%.

  • Pick units or dollars and stay consistent

    Track a single item in its natural unit (cases, pounds, bottles) and whole-storeroom usage in dollars. Mixing measures inside one calculation — counting cases but entering purchase dollars — produces a number that looks precise and means nothing.

  • Log waste and shrinkage as their own lines

    Lumping loss into usage hides the problem you can actually fix. A waste log at the bin and a shrink figure from count variance let this calculator show what share of consumption never earned a dollar — and whether it is trending the wrong way.

  • Watch usage per cover, not just totals

    Total usage rises with a busy week — that is success, not a problem. Usage per customer strips traffic out. If it climbs while the menu is unchanged, look at portioning, prep yields, and the back door before blaming volume.

  • Feed the daily rate into your purchasing tools

    Average daily usage is the input the Purchase Order, EOQ, Safety Stock, and Reorder Point calculators are all waiting for. Recalculate it after menu changes and season shifts so those tools plan from current consumption, not last quarter's.

  • Act on the loss share by band

    Under 4% of adjusted usage, maintain the routine. In the 4–7% band, tighten prep and receiving. Above 7%, treat it as a project: daily waste logs, spot counts on high-value items, and a hard look at portioning. Above 12%, something specific is wrong — find it this week.

Common mistakes

Ways stock usage calculations go wrong in practice.

  • Treating the purchases method as the truth

    Buying 900 units does not mean 900 were consumed — some are still on the shelf, and the method cannot see theft at all. If purchase-based usage and count-based usage keep disagreeing, the gap itself is your shrinkage estimate.

  • Forgetting transfers between locations

    Stock sent to a second site or the catering kitchen did not get 'used' at this one. Skipping transfers out inflates usage; skipping transfers in hides it. Multi-unit operators should reconcile transfers before comparing usage across sites.

  • Quietly netting waste out of the counts

    Reducing the ending count to 'account for' spoilage makes the loss invisible — usage looks clean while money leaks. Count what is physically there and enter waste in its own field so the loss share stays measurable.

  • Comparing periods of different lengths

    A 10-day period will always show more total usage than a 7-day one. Compare daily rates, not period totals — that is exactly what the average daily usage figure is for.

  • Explaining away negative usage

    If the math says usage is negative, stock appeared out of nowhere — which means a count error, an unlogged delivery, or a period mismatch. Fix the records instead of rationalizing the number.

  • Budgeting from one week's projection

    The annual projection multiplies one period's daily rate by 365. It is a useful order-of-magnitude check, not a budget — average several periods across seasons before committing supplier contracts to it.

People also ask

Adjacent questions operators raise about measuring stock consumption — different angles from the core FAQ.

  • How often should I calculate stock usage?

    Match your count cadence: weekly for high-value categories like proteins and liquor, at least monthly for the full storeroom. Usage between counts is invisible, so the categories that hurt most when they leak deserve the shortest measurement windows.

  • Can I calculate usage for a single ingredient?

    Yes — that is often the most useful way to run it. Count one item in its natural unit (cases of fries, pounds of brisket, bottles of well vodka), enter its purchases in the same unit, and you get a per-item daily rate you can order against directly.

  • Is stock usage the same as cost of goods sold?

    They are close cousins. When you run this calculator in dollars, adjusted usage approximates COGS for the period — beginning plus purchases minus ending is the standard COGS formula. COGS is the accounting label; usage is the operational one that also splits out waste and shrink.

  • What is the difference between actual and theoretical usage?

    Actual usage is what this calculator measures from counts. Theoretical usage is what your recipes say you should have consumed given what you sold. The gap between them is your variance — waste, over-portioning, and theft. Costing recipes with the Recipe Cost Calculator gives you the theoretical side.

  • Where do I get the covers number from?

    Your POS. Most systems report guest count or ticket count per day — sum it across the same dates as your count period. If your POS only tracks tickets, tickets-per-period still works as long as you use it consistently.

  • What does usage per sales dollar tell me?

    How much stock it takes to generate one dollar of revenue. If you run the calculator in dollars, a value of 0.07 means seven cents of inventory consumed per sales dollar for that category. Rising usage per sales dollar with stable prices means consumption is outpacing revenue — portioning, waste, or shrink.

  • How do I handle prepped items like sauces and stocks?

    Count them like anything else, valued at ingredient cost. A batch of demi-glace in the walk-in is inventory; using it is usage. If prepped items are a big share of your stock, cost the batches first so their dollar values are consistent between counts.

  • My usage came out negative. What happened?

    Your ending stock exceeds everything that was available — physically impossible, so a record is wrong. Usual suspects: a delivery received after the count but invoiced inside the period, a transfer in that was never logged, or a counting error (a case counted as ten cases). The calculator flags the clearest version of this as an error on ending inventory.

  • How do I use this to plan for a big event or holiday week?

    Take usage per customer from a normal period and multiply by the covers you expect. If you serve 2.9 units per cover and expect 800 covers, plan for roughly 2,300 units plus a safety buffer — the Safety Stock Calculator can size that buffer properly.

  • Does stock usage work for bar inventory?

    Very well — bottles and kegs are standard units, so counts are fast and the math is clean. Run the bar as its own calculation. Bar shrinkage is notoriously higher than kitchen shrinkage, and blending them lets the bar problem hide inside kitchen numbers.

  • How should multi-location operators use this?

    Run one calculation per location and use the transfers fields to keep inter-site movements from double counting. Comparing usage per cover across locations with the same menu is one of the fastest ways to spot which site has a portioning or shrink problem.

  • Are the loss benchmark bands an industry standard?

    They are practical restaurant guidance, not a published accounting standard. A scratch kitchen breaking down whole animals will naturally carry more documented waste than an assembly concept opening bags. Use the bands to track your own trend — the direction matters more than which band you sit in.

References & further reading

Related RestaurantMetric tools that sit upstream and downstream of stock usage — not endorsements of third-party vendors.

  • Usage as the demand signal

    Stock usage is the operational read of consumption between counts. Every purchasing quantity — order size, buffer, trigger point — is ultimately a multiple of it, which is why count accuracy compounds through the whole planning chain.

  • Restaurant Inventory Valuation Calculator

    Put a defensible dollar value on the beginning and ending counts before running usage in dollars.

  • Restaurant Purchase Order Calculator

    Turn the daily usage rate into a supplier-ready PO quantity with MOQ and case-pack rules applied.

  • Restaurant EOQ Calculator

    Use annual usage projections to find the order batch size that balances ordering and holding costs.

  • Restaurant Safety Stock Calculator

    Size the buffer against usage variability so busy weeks do not become stockouts.

  • Restaurant Reorder Point Calculator

    Combine daily usage with lead time to set the on-hand level that triggers the next order.

  • Restaurant Inventory Turnover Calculator

    Check how fast average inventory cycles once you know how much of it you consume.

  • Restaurant Inventory Days Calculator

    Translate usage into days of stock on hand — how long the shelf lasts at the current rate.

  • Restaurant Food Waste Calculator

    Quantify the waste side of adjusted usage in dollars when the loss share runs high.

  • Food Cost Percentage Calculator

    Divide dollar usage by sales to get the food cost percentage that drives menu decisions.

  • Recipe Cost Calculator

    Build theoretical usage from recipes to compare against the actual usage measured here.

Frequently asked questions

You may also need

Complementary calculators that often pair with this workflow.

Continue exploring

More tools to browse after you finish this calculation.