Written by: JJ Tan, Founder, Jelly
Key Takeaways for UK Restaurant Operators
- UK restaurant food prices rose 1.8% month-on-month in June 2026, so accurate stock valuation now protects already tight margins.
- Weighted average cost (WAC) blends all purchase costs into a single running average per ingredient, which smooths price volatility.
- WAC is fully FRS 102 compliant and simpler to maintain than FIFO for restaurants with fluctuating supplier prices.
- Manual WAC spreadsheets are time-consuming and error-prone, and they do not scale for multi-site or high-volume operations.
- See how Jelly automates WAC for you to cut food costs by about 3% and reclaim 10–20 hours of admin every month.
Weighted Average Cost Explained for Restaurants
The weighted average cost method calculates a single blended cost per unit across all stock on hand. It recalculates that average each time a new delivery arrives. WAC pools all purchase costs and quantities into one running average, which smooths the price spikes that hit UK kitchens every week.
The formula is: Weighted Average Cost per Unit = Total Cost of Goods Available for Sale ÷ Total Units Available for Sale.
The advantages of the weighted average inventory method for restaurants are significant. WAC removes batch-by-batch tracking, cuts administrative work, and produces stable cost data that supports reliable menu pricing and profitability analysis. The average absorbs price fluctuations instead of passing them straight into your COGS figure. As a result, your food cost percentage stays more consistent week to week, even when suppliers adjust prices mid-cycle.
FRS 102 Section 13 explicitly permits WAC (also called AVCO) as a cost formula for interchangeable stock, so it is fully compliant with UK GAAP and accepted by HMRC. LIFO is prohibited under FRS 102, which leaves WAC and FIFO as the viable accounting valuation options for UK restaurants. Both methods are permitted. WAC is generally simpler to maintain for operations with fluctuating ingredient prices.
Worked WAC Formula Example for a Single Ingredient
Use these five steps to calculate the weighted average cost of inventory for each ingredient.
- Record your opening stock value and quantity from your last stocktake.
- Add the cost of all new purchases to get your total cost available for sale.
- Add the quantity of all new purchases to your opening quantity to get total units available.
- Divide total cost by total units to get the weighted average cost per unit.
- Use this WAC figure to value both your closing stock and your cost of goods sold.
Worked example: chicken breast
- Opening stock: 10 kg at £6.00/kg = £60.00
- New purchase: 20 kg at £7.00/kg = £140.00
- Total cost: £60.00 + £140.00 = £200.00
- Total units: 10 kg + 20 kg = 30 kg
- WAC = £200.00 ÷ 30 kg = £6.67/kg
If you then use 12 kg in service, your COGS is 12 × £6.67 = £80.04. Your closing stock is 18 kg × £6.67 = £120.06. Both figures use the same blended cost, so you avoid batch tracking.
That simplicity becomes especially valuable when prices are rising across the board, as they were in June 2026 with broad month-on-month increases across nearly all food and beverage categories reported by NIQ and Prestige Purchasing. A single blended cost per ingredient is far easier to maintain than tracking individual purchase layers.
Setting Up WAC in Your Stock Spreadsheet
A disciplined spreadsheet workflow allows you to implement the weighted average inventory method manually. Follow these steps.
- List all ingredients with consistent units such as kg, litres, or cases. Pick one unit per ingredient and keep it consistent.
- Record opening stock quantities and values from your most recent stocktake.
- Log every delivery with the exact quantity received and the line-item cost from the invoice, including any delivery charges.
- Calculate total cost and total units available for each ingredient after each delivery.
- Compute WAC per unit using the formula: Total Cost ÷ Total Units.
- Update the WAC after every delivery, because this moving average must reflect the latest purchase.
- Use the current WAC to value closing stock at your next stocktake.
Weekly updates are the minimum for accuracy. Without them, costs drift silently. A restaurant with no food cost control often discovers at annual close that it runs at 36–38% food cost when it thought it was at 30%. Those 6–8 points of drift often decide whether the owner can pay themselves.
Common pitfalls include mixing units such as kg and g in the same column, omitting delivery charges from purchase costs, and failing to update the WAC after every delivery. On average, it takes 28 minutes of spreadsheet work to cost a single menu item manually. With dozens of ingredients and weekly deliveries across multiple suppliers, the manual WAC approach quickly becomes unmanageable.
FIFO vs Weighted Average for Kitchens and Accounts
Restaurant teams need to separate physical stock rotation from accounting valuation. Each concept solves a different problem.
FIFO, First In First Out, is a physical stock rotation method focused on reducing waste and spoilage. It involves placing older products at the front of shelves and new deliveries at the back. WAC is an accounting method for valuing stock on your balance sheet and in your COGS calculation. The two methods serve different purposes and can run side by side.
LIFO rarely applies to UK restaurants. It is prohibited under FRS 102 and does not suit perishable goods where older stock must be used first to prevent spoilage.
- FIFO (physical): Older stock at the front and newer stock at the back. This approach reduces waste, supports freshness, and relies on staff discipline. It applies in dry stores, chillers, and freezers.
- WAC (accounting): Blended average cost applied to all units. This method smooths price fluctuations, is simpler to calculate, and is FRS 102 compliant. It applies to your financial records and dish costing.
Under FRS 102, both FIFO and WAC are permitted for stock valuation, and your chosen method must be applied consistently from year to year. Switching methods counts as a change in accounting policy and requires disclosure and retrospective restatement. Once you settle on WAC, the next step is understanding how it feeds into your food cost percentage.
Using WAC to Calculate Food Cost Percentage
WAC links directly to the food cost percentage that every UK restaurant operator tracks. Start by calculating your cost of goods sold using the standard formula: COGS = Opening Stock + Purchases − Closing Stock.
Then calculate food cost percentage: (COGS ÷ Sales) × 100.
Worked example
- Opening stock: £5,000
- Purchases this month: £12,000
- Closing stock (valued using WAC): £4,500
- COGS: £5,000 + £12,000 − £4,500 = £12,500
- Sales: £40,000
- Food cost percentage: (£12,500 ÷ £40,000) × 100 = 31.25%
A food cost percentage within the 28–32% range is considered healthy for UK restaurants. WAC smooths weekly price spikes into a stable average, so your food cost percentage reflects genuine operational performance rather than a single expensive delivery distorting your figures.
Spreadsheet vs Software: Automating WAC with Jelly
Manual spreadsheets consume 10–20 hours of admin every week. They are prone to unit conversion errors and provide no real-time visibility, particularly across multiple sites. When a supplier raises butter by 12%, updating every affected recipe card manually takes 45 minutes and often leaves some cards unchanged.
Jelly automates the entire WAC workflow from invoice to dish cost. Every supplier invoice, received by email or photographed in the app, is scanned line by line. Ingredient costs update in real time with every delivery. Dish gross profit margins then recalculate automatically. The Price Alert feature flags every price increase or decrease the moment it appears on an invoice, which gives chefs the hard data they need to negotiate credits or switch suppliers.
Jelly integrates natively with Square, EPOS Now, Toast, and Lightspeed. It pulls item-level sales data in real time so your Flash Report shows live gross profit margins without manual data entry. Digitised invoices push directly to Xero, with Sage integration coming soon, which cuts bookkeeping time by 90%.
“Price hikes were crushing our margins — I felt helpless. With Jelly, every dish cost is up-to-date at my fingertips. We slashed food costs by 5% in a month — it’s a game changer!” — Stuart Noble, Head Chef, Cairn Lodge Hotel
Jelly users cut food costs by about 3% on average in the first three months and save the 10–20 hours of admin mentioned earlier. The time to cost a single menu item drops from 28 minutes to about 3 minutes.
Talk to the Jelly team about your stock control and see the WAC automation in action.
Advanced WAC Mistakes to Watch For
- Confusing physical rotation with accounting valuation: Using FIFO physically in your kitchen does not dictate FIFO for accounting. WAC often proves simpler to maintain and remains fully FRS 102 compliant.
- Ignoring yield losses: A 2.5 kg leg of lamb yielding 1.8 kg of usable meat means your real cost per kg is materially higher than the invoice price. Factor yield into your WAC-based dish costs when setting menu prices.
- Applying one WAC to very different formats: Using a single blended cost for both bulk and pre-portioned versions of an ingredient can distort margins. Track separate WACs where pack formats or yields differ significantly.
- Leaving historic WACs in recipe cards: Updating stock sheets without refreshing linked recipes creates a gap between reported and real dish costs. Align recipe databases with the latest WAC after each stock cycle.
FAQ
These answers cover the questions UK restaurant operators most often ask about WAC and stock valuation.
How often should I update weighted average cost?
Update WAC after every delivery for maximum accuracy, and at minimum weekly. Each new purchase changes the blended average, so a WAC calculated on Monday may be meaningfully different by Friday if two or three deliveries have arrived. Jelly automates this entirely. Every scanned invoice updates your ingredient costs and dish margins instantly, so your WAC stays current without manual recalculation.
Can I use WAC for all ingredients?
WAC suits the vast majority of restaurant stock. It is designed for interchangeable, homogeneous items, which describes most kitchen ingredients from chicken breast to cooking oil to pasta. For bespoke or uniquely identifiable items, FRS 102 requires specific identification of actual cost, although this scenario is rare in a standard restaurant operation. If you are unsure, your accountant can advise on which items in your operation may require specific identification.
What is the difference between moving average and weighted average?
In restaurant stock control, teams often use the terms interchangeably. The term “moving average” refers to the perpetual WAC that recalculates after every purchase, which is the method described throughout this guide. The term “weighted average” can also describe a periodic calculation performed once at the end of a reporting period, such as monthly, using total purchases and opening stock for that period. Both approaches are permitted under FRS 102 Section 13. The perpetual moving average is more accurate for ongoing dish costing because it reflects the most recent purchase prices at all times.
How does WAC affect my VAT returns?
WAC affects your stock valuation and cost of goods sold, which flow into your gross profit and ultimately your corporation tax liability. It does not change how you calculate VAT. VAT is calculated on the value of sales and purchases regardless of which stock valuation method you use. HMRC accepts WAC for corporation tax purposes provided you apply it consistently from year to year and stay in line with FRS 102. If you change your valuation method, you must disclose the change and may need to account for a transitional adjustment.
What food cost percentage should UK restaurants target?
As mentioned earlier, the healthy range for UK restaurants is 28–32% food cost as a percentage of sales revenue. Figures below 28% may indicate portion sizes that are too small or menu prices that sit above the local market. Figures above 32% on a consistent basis signal that ingredient costs, waste, or portion control need attention. WAC provides the stable, accurate cost basis needed to monitor this figure reliably, because a blended average absorbs weekly price volatility and reveals genuine operational trends.
Take Control of Your Food Costs with WAC
Weighted average stock control gives UK restaurants a compliant and practical method for valuing inventory accurately when supplier prices fluctuate weekly. It smooths price volatility, satisfies FRS 102 requirements, and provides the stable cost data needed for reliable menu pricing and profitability analysis. Manual implementation is possible, yet the weekly admin burden and error risk make automation the only scalable approach for growing operations.
Jelly automates the entire WAC workflow, including invoice scanning, real-time ingredient cost updates, live dish costing, and gross profit reporting, all integrated with your POS and accounting software. Jelly users add about 2 percentage points to gross margins on average in the first three months.