Decision software for grocery chains

What replacement cost is, how to calculate it and how to price with it

Last updated: 5 October 20268 min read

Who it is forGrocery chain purchasing, category and pricing teams, cost accounting and finance

When inflation and exchange rates move, the most expensive mistake is a sale that looks profitable on paper. The margin looks healthy because the stock came from an old, cheap batch; the goods sell, and when it is time to resupply, the money does not stretch. Replacement cost answers exactly that question: what would it cost to buy this product again today. This guide covers the definition, three ways to calculate it, how currency and landed costs enter on imported goods, and how a price is built from it.

What replacement cost is and how it differs from last purchase cost

Replacement cost does not say what the goods on hand cost to buy; it says what the same goods would cost today. That makes it a decision figure rather than an accounting figure: it prices the next order, not the past one.

It is often confused with last purchase cost, because in most businesses that is the closest available estimate. The difference is time: last purchase cost is an amount that was actually paid on a particular day, while replacement cost is the amount payable today. On a product bought three months ago, the two differ by whatever the supplier's increase and the exchange rate have done since.

The third figure, weighted average cost, blends every open batch and by definition carries the oldest information. All three are correct; what is wrong is using one in place of another.

Three costs, three questions
CostQuestion it answersData sourceHow current it is
Weighted averageWhat did the stock I hold cost me in total?All open batchesCarries the oldest information
Last purchase costWhat did I last pay for it?The latest goods receipt invoiceFrozen at the date of the last purchase
Replacement costWhat would it cost to buy again today?Current quote, list price, exchange rateAs of today

In the glossary, replacement cost appears as an alias of last purchase cost; in practice the two can be the same number, but they separate as soon as the supplier raises prices or the exchange rate moves. From that moment on, pricing should read replacement cost rather than last purchase cost.

How replacement cost is calculated

The calculation has three inputs: the current price of the goods, the cost of bringing them into the warehouse, and the exchange rate if the purchase is in foreign currency. All three are taken at today's values; only the ratios carry over from the past invoice.

For the current price of the goods, three sources are used in order: an open quote if there is one, otherwise the supplier's current list price, and failing that the last purchase invoice. In the third case the figure is an estimate and its date is recorded; the older it gets, the less it can be trusted.

Products with a long lead time need one more step. If the order is placed today but the goods arrive in two months, the relevant cost is the cost at the date of arrival, not today's. The expected increase is therefore built in, and the fact that it is an assumption is stated in the report.

Replacement cost
Current supply price + Landed costs
On imported goods
(Current price in foreign currency × Today's rate) + Freight + Customs + Insurance
With a long lead time
Current price × (1 + Expected increase) + Landed costsThe expected increase is an assumption; the report should show which rate was used.
  1. Find the current priceIn order: an open quote, the current list price, the last purchase invoice. Which source was used, and its date, is visible on the product record.
  2. Allocate landed costsFreight, customs, insurance and any agency fees. The allocation key must match the one used on past purchases; change the key and two periods stop being comparable.
  3. Convert currency at today's rateUse today's rate for whichever currency the contract is in. The rate on the historical invoice is not used in this calculation.
  4. Add the expected increase on long lead timesThe price and currency movement expected before the goods arrive. The rate is a written assumption, not a hunch.
  5. Store it as a separate fieldNext to average cost, never in place of it. Keep the date and the source with it, and flag the figure in reports once it ages.

How a price is built from replacement cost

The usual pricing mistake runs like this: read the average cost on the product record, apply the customary mark-up, print the ticket. Because average cost carries old batches, that price may not cover replacing the goods.

The correct order is the reverse: build the price from replacement cost, then show the margin calculated on average cost separately for reporting. With the two margins side by side, it becomes visible how much of the reported profit disappears when the stock runs out.

This is not a rule for raising prices. Price is not set by cost alone; competition, demand and the category's role all weigh in. Replacement cost gives the floor: any decision that goes below that floor should be deliberate and time-limited.

Price from replacement cost
Replacement cost ÷ (1 − Target margin)
Replacement margin
(Selling price − Replacement cost) ÷ Selling price × 100
Reported margin
(Selling price − Weighted average cost) ÷ Selling price × 100

The same floor applies to markdowns. A markdown that goes below replacement cost grows the loss as sales grow, so the markdown ladder is capped against replacement cost, not average cost.

Where it is not used

Replacement cost is a management figure; it does not enter the accounting records or the financial statements. Stock valuation, cost of goods sold and the tax base are built with the methods the regulations accept, namely weighted average or FIFO, and the chosen method is not switched between periods.

It should also not be confused with inflation restatement. In Turkey, financial statements are restated under TMS 29 (IAS 29) during periods of high inflation; that is a separate mechanism that brings past figures to today's purchasing power and is not built for product-level pricing.

The practical conclusion: replacement cost belongs on the product record and the pricing screen, not in the income statement. Showing both figures on the same screen is not confusion, it is the comparison.

This section is general information, not tax or accounting advice. Method selection and any change of method are handled with your accountant.

Where replacement cost appears in Mindpera

Mind Cost calculates weighted average cost as a moving average, recalculated on every goods receipt; last purchase cost sits in a separate column on the same row. The pricing screen reads that second column.

The gap between the two is not left as a single number: it is broken down into purchase batch, expense item and currency effect. Whoever makes the pricing decision can see whether the gap comes from a price increase, the exchange rate or freight.

For products bought in foreign currency, the rate table is read into the same data model through the ERP integration, and when last purchase cost crosses its threshold a task goes to the pricing owner. Where data is also scattered outside the ERP, the sources are brought into the same model during installation.

  • Weighted average and last purchase cost side by side on the product record
  • The gap split into batch, expense item and currency effect
  • Freight and price-difference invoices that arrive later are allocated back to the batch
  • An alert to the pricing owner when last purchase cost crosses its threshold

Frequently asked questions

Are replacement cost and last purchase cost the same thing?
They are often close but not the same. Last purchase cost is an amount actually paid in the past; replacement cost is the amount payable today. They separate when the supplier raises prices, the exchange rate moves or freight changes. If months have passed since the last purchase, last purchase cost is a weak estimate of replacement cost.
What data is replacement cost calculated from?
In order: an open quote, the supplier's current list price, then the last purchase invoice. Landed costs such as freight, customs and insurance are added with the same allocation key, and for foreign-currency purchases today's rate is applied. The source used and its date stay on the product record, because a stale figure quietly breaks the decision.
Is pricing on replacement cost the same as raising prices?
No. A price rise lifts the price independently of cost; pricing on replacement cost is about being able to replace the goods. Price is still set together with competition, demand and the category's role. Replacement cost gives the floor; a decision below that floor is taken deliberately and with an end date.
Can replacement cost be used in the financial statements?
No. Stock valuation and cost of goods sold are built with the methods the regulations accept, weighted average or FIFO, and the method is not switched between periods. Replacement cost lives in management reporting, on the product record and the pricing screen. This is general information; the application is handled with your accountant.
How often is replacement cost updated?
The trigger is an event rather than a calendar: a new supplier price list, a new quote, a currency move beyond a set threshold, or a change in freight tariffs. For foreign-currency products the rate is read daily. The figure carries its last update date, and the older that date, the less weight it should carry in a pricing decision.

Let us build this calculation on your data

Knowing the formula is not enough; the data has to sit at the right grain. Our team does the installation. We will go through your current setup together in 30 minutes.