merchmix

Publish Date :

Aged Stock: Mark Down, Transfer or Write Off?

The best route for aged stock depends on condition, supported demand, the cost of moving or selling it and what remains afterwards. Merchmix Core helps compare the commercial assumptions, while Core Plus supports a proposed movement where another location has a credible selling opportunity.

A young stock planner inspecting rust-coloured coats and comparing recovery paperwork.
Editorial image: a young stock planner inspecting rust-coloured coats and comparing recovery paperwork.

THE MERCHMIX DECISION / Core + Core Plus

Age identifies a review, not a route

Aged inventory needs a comparison of feasible recovery, route costs and residual stock, rather than an automatic discount or transfer based on age alone.

Independent retail planning example. Financial amounts are US dollars. Forecasts, quantities and proposals are assumptions for this decision, not customer results.

merchmix.Core + Core Plus / Rust coats / recovery route comparison
Condition and scopeCurrent assumptions

Rust coats / recovery route comparison

Condition and scopeDecision comparison
Held80 units
Recorded cost$4,800
Review horizon4 weeks
Inspect stock
Compare recovery
Authorise a route
Age identifies a review, not a route
RouteEvidence needed
MarkdownLocal demand at the proposed price
TransferDestination demand and route capacity
Write offCondition, policy and accounting review
Start with condition and a feasible selling route

All quantities and costs are independent assumptions.

Age identifies a review, not a route

Eighty rust coats remain at a $60 recorded goods cost.

THE KEY IDEA

Choose the route by supported recovery, the cost of action and the residual stock, with valuation and disposal authority reviewed separately.

Inspect what can still be sold before ranking the routes

Age is a useful review signal, but stock can be old for different reasons. A sound coat in the wrong location presents a different decision from a damaged coat or a product that can no longer be offered. Establish condition, ownership and the remaining opportunity before comparing prices.

The independent example reviews eighty rust coats over four weeks, with a recorded $60 goods cost each. No retailer performance is claimed. Core supports a price and stock comparison, and Core Plus supports a scoped movement review; neither establishes the product’s condition or the accounting value automatically.

Product evidence and planning referencesMerchmix Core: merchandise planning and price comparisons Merchmix Core Plus: allocation and transfer context IFRS Foundation: IAS 2 inventory valuation context

Use future cash recovery to compare the next action

The markdown case assumes 64 coats sell locally at $70. Revenue is $4,480. Preparing those sold units costs $128 and a separate campaign costs $120, leaving $4,232 after these stated future costs. Sixteen coats remain and still need a plan.

The transfer case moves sixty coats and assumes all sixty sell at $95. Revenue is $5,700; movement costs $420 and preparation $120, leaving $5,160. Twenty coats remain at the original location. Different sold quantities and residual balances mean the two estimates are not complete outcomes for all eighty units.

Keep cash recovery distinct from product profit

The markdown’s sold goods cost is $3,840, giving $640 product gross profit before its $248 preparation and campaign costs. After those costs, $392 remains. The stronger transfer case has $3,600 sold goods cost, $2,100 product gross profit and $1,560 after its $540 route costs.

The original recorded stock cost is not a second future payment merely because the retailer reviews a route today. It remains relevant to the accounting result. Core can compare the assumptions on a consistent basis, while finance confirms valuation and expense treatment rather than treating cash recovery as synonymous with profit.

THE FIGURES BEHIND THE DECISION

Aged Stock: Mark Down, Transfer or Write Off?: Markdown: 64 × $70 less $128 preparation and $120 campaign = $4,232 cash recovery. Transfer: 60 × $95 less $540 route costs = $5,160. These leave sixteen and twenty coats respectively.
ComparisonCash after stated costsUnsold units
Markdown / 64 sales$4,23216
Transfer / 60 sales$5,16020
Transfer / 40 sales$3,26040

Markdown: 64 × $70 less $128 preparation and $120 campaign = $4,232 cash recovery. Transfer: 60 × $95 less $540 route costs = $5,160. These leave sixteen and twenty coats respectively.

Challenge destination demand before moving old stock

If only forty of the sixty moved coats sell at $95, revenue is $3,800. With the same $540 movement and preparation costs incurred for the sixty-unit move, cash recovery is $3,260. Forty coats remain across the network: twenty never moved and twenty not sold at the destination.

That is below the markdown case’s cash recovery and leaves more stock unresolved. Core Plus therefore needs matching product demand, receiving capacity and arrival timing before a movement is proposed. A higher ticket elsewhere does not establish a better route if the units cannot sell there within the selected window.

THE PLANNING REFERENCERead the retail markdown guide

Treat disposal as a controlled decision with its own cost

An assumed $3 handling cost for each of eighty coats creates a $240 disposal outlay. It is not a positive recovery, and the $4,800 recorded goods cost must not be silently converted into a complete accounting-loss figure without reviewing the applicable basis.

IAS 2 distinguishes inventory cost and net realisable value when assessing carrying amounts. Actual write-downs or write-offs need the retailer’s finance process and applicable policy. The article compares operating choices; it does not determine a tax result or assert that every aged item should be removed.

Make Core and Core Plus support one coherent route choice

Retain the selected horizon, prices, route costs and expected sold units in the Core comparison. If a transfer remains credible, Core Plus provides the movement context with the relevant locations and quantities. Keep its authorisation and confirmed receipt separate from the recovery forecast.

Review the entire eighty-unit scope after the proposed route. The stronger transfer estimate still leaves twenty coats and the markdown leaves sixteen. A route is incomplete if its attractive result depends on ignoring those residual units or assuming they can later be cleared at an unsupported price.

SignalMerchmix workspaceDecision to review
Condition and scopeCore / evidenceEighty rust coats remain at a $60 recorded goods cost.
Recovery comparisonCore Plus / comparisonThe route estimates concern different assumed sold quantities.
Demand sensitivityCore / decision reviewA higher expected selling price is not proof that enough units will sell.

Review the recovery against the assumptions that justified it

After an authorised action, compare the actual costs, realised price, sell-through and remaining units with the retained case. A transfer that completes physically can still miss its commercial objective. A markdown that sells more may still recover less after its costs.

Use that evidence to improve the next exit decision and the next buy. Core and Core Plus help connect the commercial comparison and stock response, while condition, finance treatment and final authority remain explicit responsibilities rather than conclusions drawn from stock age alone.

BEFORE THE NEXT DECISION

  • Planning owner

    Disposal would remove eighty units with $240 assumed handling cost; accounting treatment is separate.

  • Commercial owner

    Original book cost is not another future payment, but it still matters to the accounting comparison.

  • Decision owner

    A higher expected selling price is not proof that enough units will sell.

Common questions

Is the highest selling price always the best route?

No. Feasible unit demand, movement costs, timing and the stock left unsold all affect the comparison.

Why does the stronger transfer recover $5,160?

Sixty sales at $95 generate $5,700, less $420 movement and $120 preparation costs.

Does that mean all eighty coats are resolved?

No. The stronger transfer leaves twenty and the markdown case leaves sixteen.

What if only forty transferred coats sell?

With the same $540 route costs, $3,260 is recovered and forty coats remain across the network.

Does the example prescribe an accounting write-off?

No. Finance must assess carrying value, condition and the applicable accounting policy separately from the operating-route comparison.

core

Eighty rust coats remain at a $60 recorded goods cost.

Explore
core plus

The route estimates concern different assumed sold quantities.

Explore

Continue reading: How to plan an exit before the next buy

Read the retail planning glossary

FROM THE ARTICLE TO YOUR OWN RETAIL PLAN

Review the decision.
See the workflow.

Bring your planning questions to a demo, or explore a proof of concept on your own data.

Book a demo Explore the proof of concept