Weighted average cost is the average unit cost of a product, calculated according to the units bought at different prices. It is used to value inventory and usage without relying only on the last purchase price.
Weighted average cost, known in Spain as precio medio ponderado (PMP), is a method for calculating the unit cost of an item when the restaurant has bought that product at different times and at different prices. In hospitality it is especially useful because food and drink prices change often: oil, fish, meat, coffee, wine, fruit or imported products can vary with the season, the supplier, volume, negotiation or the urgency of the purchase. If the restaurant values all its inventory at the last price received, it may overstate or understate the real cost of what it has in store. If it uses only the earliest historical price, the figure becomes outdated.
Weighted average cost solves this by giving more weight to the purchases with the largest quantities. It is not a simple average of prices, but an average weighted by units. Buying 10 kg at €8 and 90 kg at €10 does not mean the average cost is €9; since almost all the stock was bought at €10, the real average price is much closer to €10. This method helps value inventory, calculate actual usage, compare standard cost with actual cost, review recipe costings and see whether a supplier price rise is already affecting margin.
It also prevents hasty conclusions. A dish may look less profitable because the last purchase was expensive, but if stock bought at a lower price is still being used, the real impact will be gradual. Conversely, a sustained price rise may take a while to show if the system does not update costs as new purchases come in.
Weighted average cost = Total value of stock on hand / Total units on hand
To calculate it, add up the monetary value of all units of an item on hand and divide by the total number of units. If you have 20 litres of oil bought at €5.80 and receive another 30 litres at €6.40, the total value is €116 + €192 = €308. Total units are 50 litres. The weighted average cost is 308 / 50 = €6.16 per litre.
If you then use 12 litres, that usage is valued at 12 × €6.16 = €73.92. When a new purchase comes in, the weighted average is recalculated using the remaining stock and the new cost received. This logic differs from FIFO, where the oldest units are used first, and from LIFO, where the most recent receipts take priority. In hospitality, weighted average cost is usually practical for financial reporting and overall valuation, while FIFO remains essential for physical rotation, expiry and food safety.
A restaurant buys cured cheese for one of its signature tapas. It starts the week with 8 kg in stock valued at €12 per kg, or €96. On Wednesday it buys another 12 kg at €13.50 per kg, for a total of €162. It now has 20 kg with a total value of €258, so the weighted average cost is €12.90 per kg.
The tapa's recipe costing uses 40 g of cheese, so the ingredient cost becomes €0.516 per portion. If the restaurant kept using the old price of €12, it would calculate €0.48 and underestimate the cost. If it used only the latest price of €13.50, it would calculate €0.54 and might overreact. Weighted average cost gives an intermediate reading that is more faithful to the stock on hand.
At month-end, management sees that the cheese's weighted average cost has risen from €12 to €13.10 over three consecutive purchases. With that information, it decides to renegotiate with the supplier, review the portion weight and check whether the tapa's selling price still delivers the expected contribution margin.
Weighted average cost matters because a restaurant's margin depends on real costs, not remembered prices. When purchases are recorded at varying prices and inventory is not valued correctly, food cost, standard cost, gross margin and dish profitability can all be distorted. That leads to bad decisions: raising prices unnecessarily, keeping loss-making dishes, buying too early for fear of inflation or failing to notice that a supplier is making a critical category more expensive. It also helps separate price problems from quantity problems.
If actual usage shoots up but the weighted average cost stays stable, there is probably waste, over-portioning or inventory errors. If usage rises because the weighted average cost increases, the problem lies closer to purchasing, the supplier or the market. In multi-site groups, using a consistent valuation method allows fairer comparison between sites and shows where buying is worse or negotiation better.
Zindra helps you calculate and update weighted average cost by linking purchases, goods received, inventory, usage, recipe costings and financial reporting. Each new receipt can update the item's unit cost, and each usage can be valued consistently. You can see how supplier price changes affect food cost, review dish margins with up-to-date data, compare standard cost with actual cost and make purchasing or pricing decisions without relying on manual spreadsheets.
Tools and content to go deeper into this concept.
Food cost is the percentage of a dish's selling price that goes on the cost of its ingredients. It is the single most important indicator of how profitable your menu is.
Cash flow in a restaurant is the movement of money in and out of the business. Managing cash well is vital for the restaurant's survival, even if it is profitable on paper.
Perpetual inventory is a stock control system that updates stock levels in real time with every movement in and out, unlike periodic inventory, which is only checked at set points in time.
FIFO (First In, First Out) and LIFO (Last In, First Out) are stock rotation methods. In hospitality, FIFO is compulsory: what comes in first goes out first, keeping produce fresh and reducing waste.
Inventory turnover measures how many times a restaurant completely renews its stock over a period. The better it is tuned, the less cash is tied up and the lower the risk of expired products or stock-outs.
The purchases-to-sales ratio measures what percentage of revenue is being spent on buying ingredients in a period. It is a quick signal for spotting food cost variances, excess stock or planning problems.
Standard cost is the expected cost of producing a dish, service or period using recipes, agreed prices, yields and expected usage. It acts as a benchmark against which actual cost is compared.
Every hospitality term with formulas, examples and benchmarks in a handy PDF.
Try Zindra free and keep food cost, staff, inventory and much more under control from a single platform.