Quick Summary
A coffee bean inventory plan starts with a consumption estimate based on regular drinkers, attendance rate, cups per person and grams per cup, not total headcount. Once you know daily bean use, set a par level, a reorder point and a small safety stock. Then record deliveries and weekly counts so variance shows up early.
- Count regular coffee drinkers and their attendance, not total headcount.
- Use your machine’s grams per cup setting rather than a generic average.
- Set the reorder point as weekly use times supplier lead time, plus a buffer.
- Count stock weekly and investigate usage gaps above about 10 percent.
- Use oldest bags first and label opening dates to limit freshness waste.
Table of Contents
- Why Office Coffee Inventory Goes Wrong
- Working Out Your Office Coffee Consumption
- Setting Par Levels, Reorder Points and Safety Stock
- Tracking Deliveries, Usage and Variance
- Best Practices for Coffee Bean Storage
- Cutting Coffee Bean Waste Across Your Sites
- Booking Your Coffee Setup and Supply Plan
- Frequently Asked Questions
Why Office Coffee Inventory Goes Wrong
Most offices run out of coffee beans at the worst possible moment, or they quietly throw away half a bag every month, and a proper coffee bean inventory system stops both problems before they start.
Admiral Vending supplies bean to cup machines across the UK. Stock gets ordered when someone notices the bin is empty, not when the numbers say it is time.
The fix does not need a complicated system. It needs three things: a clear estimate of use, a reorder point and a simple way to check what is left.
Working Out Your Office Coffee Consumption
Most guides tell you to multiply headcount by cups per day. That overstates demand in any office where people work from home, come in three days a week or spend part of the month on site visits. A forecast based on attendance is usually more reliable than one based on the staff list.
Start with four inputs:
- Regular coffee drinkers: the number of people who take coffee most working days, not total headcount.
- Attendance rate: the average share of those drinkers actually in the building on a given day. Attendance often varies by day of the week, so use your own records to set this figure.
- Cups per attendee per day: usually two to four, depending on meeting load and whether the office has a morning rush.
The formula is:
Regular drinkers × attendance rate × cups per attendee per day × grams per cup = daily bean use in grams.
Divide by 1,000 for kilograms, then multiply by working days in the month.
Worked example: a 150-person office on hybrid attendance
Take 150 staff, 60 percent of whom drink coffee regularly, giving 90 regular drinkers. Attendance averages 60 percent across the month, so about 54 drinkers are in on a typical day.
- 90 regular drinkers × 60% attendance = 54 attendees per day
- 54 × 3 cups = 162 cups per day
- 162 × 9 grams = 1,458 grams per day, or about 1.46 kg
That is a very different number from a headcount-only estimate, which would have produced roughly 51 kg. The attendance adjustment is the single biggest correction most offices need to make.
Adjusting for brew method and equipment
Bean use per cup varies widely by equipment, and ignoring this is a common source of forecast error:
- Bean to cup machines: dose is set in the recipe, so usage is predictable once you know the grams per drink. Check the machine settings rather than assuming a default.
- **
- **
If your machine has been re-programmed to a stronger recipe, your historical usage figures will understate future demand, so re-check dose settings whenever you review your forecast.
Building a monthly attendance calendar
A single average attendance rate hides the weeks that break your stock plan. Build a simple calendar with three adjustments:
- Holiday and closure weeks: reduce forecast to zero or near zero, and bring forward any deliveries that would otherwise sit in the building.
- Event and meeting weeks: add a percentage for all-day meetings, training sessions and client visits, which can lift consumption on the affected days.
- Seasonal patterns: many offices see a dip in late summer and a rise in the colder months, when more staff switch from cold drinks to hot coffee.
Review the calendar monthly against actual stock counts. After two or three months you will have a forecast that reflects your office rather than a generic formula, and that is the number you should use to set par levels and reorder points.
The table below sets out the four inputs needed to forecast your office’s bean use, using the same figures the worked example relies on.
| Input | What it measures | Note |
|---|---|---|
| Regular coffee drinkers | Staff who take coffee most working days | Not total headcount |
| Attendance rate | Share of drinkers in the building on a given day | Set from your own records |
| Cups per attendee per day | Typical cups per person | Usually two to four |
| Grams per cup | Bean dose per drink | Set by your machine and recipe |
Setting Par Levels, Reorder Points and Safety Stock
Once you know your daily use, set three figures:
Commercial Bean to Cup Coffee Machines UK | Barista-Quality Coffee Made Easy
Admiral Vending Systems
- Par level: the amount you aim to keep on hand, usually four to six weeks of use.
- Reorder point: the stock level that triggers a new order. Set it at your average weekly use multiplied by your supplier’s lead time in weeks, plus a buffer.
- Safety stock: a small extra reserve for busy periods or late deliveries, often one week of use.
A useful rule is to order when you reach the reorder point, not when you are out. That gives the delivery time to arrive before the cupboard is empty.
Keep the reorder point honest. If your supplier takes ten working days to deliver, your reorder point must cover at least ten working days of use plus your safety stock.
Tracking Deliveries, Usage and Variance
Good inventory control means recording three things every time: what arrives, what goes out, and what is left. A simple spreadsheet is enough for most offices:
- Date and quantity of each delivery
- Weekly stock count, done on the same day each week
- Calculated usage, which is opening stock plus deliveries minus closing stock
Then compare calculated usage with your expected figure from the consumption estimate. A gap of more than about 10 percent is worth investigating. It may mean over-serving, waste, a machine setting that uses more beans per cup, or a stock count that was not done properly.
This comparison is where most offices find their real savings. Small variances, repeated over a year, add up to a large bill.
Best Practices for Coffee Bean Storage
Freshness matters as much as quantity. Beans lose flavour once they are opened and exposed to air, heat and light. Store them well and the stock you hold will taste better and last longer.
- Keep beans in their original sealed bag or an airtight container until you use them.
- Store them somewhere cool, dry and dark, away from heat sources and direct sunlight.
- Use the oldest bags first (first in, first out) so nothing sits too long.
Storage is also where waste often starts. A bag opened on Monday and forgotten until the following month is a bag you are paying for and not using.
Cutting Coffee Bean Waste Across Your Sites
Running one office well is a forecasting problem. Running several is a coordination problem, and the waste usually hides in the gaps between sites. The fix is a central plan with site-level controls, not a single par level copied everywhere.
Set site-level par levels, not one company-wide figure
Each site should have its own par level and reorder point, calculated from its own attendance and brew method. A head office with a busy bean to cup machine and 200 attendees needs a very different par level from a satellite office with 15 staff and a filter machine. Central purchasing can hold the budget, but the trigger points must be local.
A workable structure is:
- Central buyer: negotiates supplier terms, holds the master order calendar and approves transfers between sites.
- Site lead: does the weekly stock count, records usage and flags when the reorder point is reached.
- Shared spreadsheet or inventory tool: one row per site, one column per week, so variance is visible across the estate.
Compare usage per attendee, not per site
Raw usage figures mislead because sites differ in size. Divide monthly bean use by attendee days to get grams per attendee, then compare like with like. A site that uses far more grams per attendee than its peers is either over-serving, wasting stock, running a stronger recipe or counting stock badly. A site that uses far less may be under-recording deliveries or running out and sending staff to buy retail bags, which is the most expensive way to stock an office.
Run a simple transfer process
Stock transfers between sites reduce both stockouts and expired bags, but only if they are recorded. A transfer that leaves one site’s spreadsheet and never arrives on another’s creates a phantom variance that takes weeks to unpick.
- Record the transfer on both sites’ sheets on the same day, with quantity and date.
- Move only sealed, in-date bags, and label them with the original roast or best before date.
- Keep transfers small and frequent rather than large and occasional, so no site ends up holding another site’s surplus.
Control opened and partially used bags
Freshness waste is the quiet cost in multi-site operations. A bag opened for a meeting and left in a cupboard is paid for twice: once when it was bought and again when it is thrown away. Set a workplace freshness limit, commonly two to three weeks from opening for best flavour, and enforce it with a simple label.
- Write the opening date on every bag when it is first used.
- Rotate opened bags to the front of the shelf and use them before opening new ones.
- At the weekly count, check opened bags against the freshness limit and remove any that are past it.
Review variance monthly across the estate
A monthly review of grams per attendee by site is where the savings appear. Look for sites that are consistently out of line, check machine dose settings and cleaning schedules, and confirm that stock counts are being done on the same day each week.
Cutting waste across sites does not mean cutting quality. It means every bag is used while it is still fresh, every site holds the right amount and no office is quietly funding another’s surplus.
Booking Your Coffee Setup and Supply Plan
Your inventory plan works best alongside the right equipment. A bean to cup machine grinds fresh beans for each drink, which keeps flavour consistent and makes stock easier to track, because you are measuring beans rather than pre-ground packs.
At Admiral Vending, we help businesses choose a machine sized to their real demand, install it, train staff and set up a supply plan that matches their consumption figures. Our commercial bean to cup coffee machines cover a range of workplace sizes, and our team can help you work out the right model for your numbers. See our shortlist of office machines to compare options suited to workplaces like yours.
Ready to get the right setup for your office? Get Your Instant Quote from Admiral Vending. Our AI powered instant quote system gives you a clear starting point, and our team handles delivery, installation, training and ongoing support so you can stop chasing empty bean bags.
Last Updated: November 14, 2026
Frequently Asked Questions
How much coffee should I order for my office per month?
Start with the number of cups your team drinks in a typical week, then multiply by the average bean dose per drink and the number of weeks you plan to cover. Add a buffer for attendance spikes and for lead time from your supplier. Because delivery timing and order quantities vary, check current pricing and minimum order details directly with Admiral Vending or request a quote before committing to a monthly figure.
What is the best way to track office coffee bean usage?
Record the weight of beans delivered, count what remains at a fixed time each week, and divide the difference by the number of cups served over the same period. Comparing this against your expected usage shows variance quickly. A simple spreadsheet with dated entries is enough for most offices, and consistency matters more than sophistication.
How long do coffee beans stay fresh in an office environment?
Whole beans keep their best flavour for a relatively short window after roasting, and freshness falls faster once a bag is opened. Store opened bags in a sealed, airtight container away from heat, light and moisture, and avoid buying more than you can use within that window. Ask your supplier for roast dates so you can rotate stock first in, first out.
How do I calculate buffer stock for office coffee?
Buffer stock covers the gap between a delivery being ordered and arriving, plus unexpected rises in demand. Multiply your average daily usage by the supplier lead time in days, then add a margin for busy periods such as events or holidays. Review the figure after each quarter, because attendance patterns change.
