Cocktail
Atlas

Are you 18 or older?

By choosing “Yes, I am 18 or older”, you confirm your age and accept the terms of use.

Alcohol is bad for your health.

Data processing policyTerms of use
Cocktail
Atlas

Menu

My account
QR code to support the Atlas via T-Bank

Support the Atlas

You choose the amount.

Support the project

Bartending course · Behind the bar

How to work out usage from two stock counts

How much stock did the bar use this week? Add the value on the shelf at the start to the value of the deliveries, then subtract what is left at the end. That gives you the value used. The shift records help explain what was sold, spilled or written off.

Step by step

  1. Set a consistent boundary

    Choose one stock category and one period. Value the opening stock at purchase cost, log that category’s deliveries and value the closing stock on the same basis. This example assumes no transfers between bars.

    Opening stock
    ₽9,000
    Purchases during the week
    ₽4,000
    Closing stock
    ₽8,300
    A sample week, with all stock valued at cost.
  2. Subtract the stock still on hand

    A total of 13,000 roubles of stock was available. Of that, 8,300 remains for next week. The 4,700-rouble difference is actual usage, including any breakage or waste recorded during the period.

    Left on the shelf
    ₽8,300
    Used
    ₽4,700
    Where the available stock ended up.
  3. Match usage with sales for the same week

    Sales of drinks in the corresponding category came to 23,500 roubles. Divide usage of 4,700 by 23,500 and multiply by 100. If a result looks high, check dates, categories, part-bottle counts and waste records before drawing conclusions.

    Usage at cost
    ₽4,700
    Sales
    ₽23,500
    Actual cost percentage
    20%
    Usage as a share of sales over the same period.

Try it yourself

During a recount you find another 500 roubles’ worth of stock. The stock left at the end of the week is now worth 8,800 roubles. Recalculate the value used and its percentage of sales. Opening stock, purchases and sales stay the same.

How it works

Subtract the corrected closing stock of 8,800 from the 13,000 available. Usage is 4,200 roubles, about 17.9% of sales. Check the shift records to establish what caused the original discrepancy.

What is the revised value of stock used during the week?

  1. ₽4,200
  2. ₽4,700
  3. ₽5,200
Open the recipe