Retail Formulas

For every dollar your store earns in sales, Gross Profit Margin tells you how many cents you actually keep after paying for the products themselves. It does NOT include wages, rent or other running costs — just the difference between what you sell it for and what you paid for it.

If this number is too low, your buying price or selling price is broken. Most retail categories sit between 30–60%. Grocery is lower (~25%), fashion higher (~55%).

Typical retail: 30–60%

Markup is how much you add ON TOP of what you paid for a product to arrive at the selling price. It is expressed as a percentage of your COST — not the selling price. This is different to margin!

Confusing markup with margin is one of the most common pricing mistakes in retail. A 50% markup does NOT equal 50% margin.

Fashion: 100–300% | Electronics: 10–40% | Grocery: 5–25%

Out of every 100 people who walk into your store, how many actually buy something? That is your conversion rate. A store with heavy foot traffic but poor conversion is losing money on every customer who leaves empty-handed.

Improving conversion by even 2–3% can dramatically increase revenue without spending a cent more on marketing.

Bricks-and-mortar retail average: 20–40%

The average amount a customer spends each time they buy from you. Also called Average Basket Size. Increasing ATV is one of the fastest ways to grow revenue without needing more customers.

Training staff to recommend add-ons or upsells directly lifts ATV. A $5 increase across 500 daily transactions = $2,500 extra per day.

Varies by category — track your own trend over time.

How many individual items does each customer buy per visit on average? A UPT of 1.2 means most customers only buy one item. A UPT of 3.5 means customers are filling their baskets.

Low UPT suggests staff are not suggesting related products. Improving UPT from 1.5 to 2.0 is a 33% increase in units sold with no new customers.

Fashion: 1.5–2.5 | Supermarket: 8–15 | Specialty: 1.2–2.0

How much revenue does each square metre of your store floor generate? This helps you understand whether your space is being used efficiently and compare performance across multiple locations.

Low-performing areas of a store might be better used for higher-margin products, events, or reduced altogether.

Fashion: $3,000–$8,000/m² p.a. | Grocery: $10,000+/m² p.a.

For every hour your team works on the shop floor, how much revenue do they generate? This measures how productively your roster converts staffing into sales.

Helps optimise rostering — schedule more staff during high-traffic periods, less during slow periods.

Benchmark varies widely; track your own trend weekly.

How much has your sales revenue grown (or declined) compared to the same period last year? This is the most common metric used to evaluate store performance and set budgets.

Comparing to last year removes seasonal fluctuations. A store doing well in absolute terms may actually be going backwards vs. the prior year.

Healthy growth: 5–10%+ above CPI/inflation.

How many units do you need to sell before your store stops losing money and starts making profit? Below break-even = loss. Above break-even = profit. Simple and critical.

Every store manager should know their break-even. It shapes pricing strategy, cost control and promotional decisions.

The lower your break-even, the more resilient your business.

Shrinkage is the difference between what your records say you should have and what is actually on the shelf. It includes theft, admin errors, supplier fraud and damage. It is money disappearing silently.

Even 1–2% shrinkage on a $1M turnover store costs $10,000–$20,000 per year in pure profit.

World-class: <0.5% | Industry average: ~1.5% | Problem: >2%

How many times per year does your entire inventory sell through and get replaced? A stock turn of 6 means your inventory cycles 6 times in a year — roughly every 2 months. Low stock turn = cash sitting idle on shelves.

Dead stock ties up cash, costs storage space, and often must be marked down. High turnover = efficient cash use.

Fashion: 4–6x | Grocery: 20–30x | Electronics: 4–8x

At your current rate of selling, how many weeks until you run out of stock? This is the single most important day-to-day inventory metric for a buyer or store manager.

Too many weeks of supply = overstock and cashflow risk. Too few = lost sales from stockouts.

Fashion: 8–12 weeks | FMCG: 2–4 weeks | Seasonal: varies.

Of all the stock you received (or started the season with), what percentage has actually sold? A 70% sell-through means 30% is still sitting there. Crucial for fashion and seasonal ranges.

Low sell-through triggers markdowns and margin erosion. Tracking it weekly lets you take corrective action before end-of-season.

Target: 80%+ by end of season | 60% is a warning sign.

For every $1 you invest in inventory, how many dollars of gross profit do you get back? A GMROI of $2.50 means every dollar tied up in stock earns $2.50 in gross profit. It combines profitability AND inventory efficiency into one number.

The best inventory investment metric. Use it to compare departments, categories, or suppliers against each other.

GMROI > $1.00 = covering cost | > $2.50 = strong performer

Open-to-Buy is the buying budget available to a buyer for a given period. It tells you how much you CAN spend on new stock without creating an overstock situation. It accounts for what you plan to sell, what you already have, and what's on order.

Buying without an OTB is how retailers end up over-stocked and cash-strapped. It's the fundamental discipline of buying.

OTB should never be ignored — a negative OTB means cancel orders.

The stock level at which you should place a new order. If your stock drops to this number before your order arrives, you risk running out. It factors in how long your supplier takes to deliver AND a safety buffer.

Without a reorder point, you react to stockouts instead of preventing them. Every stockout is lost revenue.

Set per SKU — the more variable the demand, the higher the safety stock.

The ideal quantity to order each time you reorder a product — balancing the cost of ordering too frequently against the cost of holding too much stock. Too small orders = frequent delivery fees. Too large orders = cash tied up in warehouse.

Used heavily in distribution and head-office buying to optimise purchase quantities and minimise total inventory cost.

Revisit EOQ when demand patterns or costs change significantly.

What percentage of your total inventory has not sold in more than 12 months (or your defined period)? Dead stock is a silent profit killer — it ties up cash, takes up space, and usually ends up being written off.

Identifying dead stock early means you can take action — promote it, bundle it, return it, or liquidate it — before writing it off completely.

Target: <5% | Warning: 10%+ | Problem: 20%+

On average, how many days does it take for your inventory to sell through completely? Also called "Days in Stock." A DIO of 60 means on average your stock takes 60 days to sell. Lower is better.

High DIO means cash is locked up in stock for a long time. Reducing DIO from 90 to 60 days on $500K inventory frees up ~$167K in cash.

Fashion: 60–90 days | Grocery: 15–30 days | Furniture: 120+ days

What percentage of your product range is currently out of stock and unavailable to buy? Every product out of stock is a potential lost sale — and a customer who may go to a competitor.

Research shows 30–40% of customers will not wait for an out-of-stock item — they simply buy elsewhere.

Best-in-class: <1% | Good: <3% | Unacceptable: >5%

After paying for ALL costs — products, wages, rent, utilities, marketing, taxes, everything — what percentage of every dollar of revenue is actual profit? This is the ultimate bottom-line measure of a business.

A business can have great gross margins and still have a terrible net profit if overheads are out of control.

Retail net profit: 2–6% is typical. Above 10% is excellent.

The total cost of all the products you sold during a period. It is calculated from your stock records — what you started with, plus what you bought, minus what you have left. This is NOT what you paid for your stock generally — it is only the cost of what actually sold.

Getting COGS right is critical for calculating true gross profit. Under or over-valuing stock distorts your entire P&L.

Compare COGS % to revenue — aim to reduce it over time through better buying.

What percentage of your revenue is consumed by operating expenses (wages, rent, utilities, marketing — everything except cost of goods)? The lower this number, the more efficiently you are running the business.

If gross margin is 50% and OER is 48%, you're barely breaking even. Most businesses focus on growing sales but ignore the OER creeping up.

Target OER: 25–35% for specialty retail | Grocery: 15–20%

How much did sales grow in stores that were open in BOTH periods being compared? This removes the distortion of new store openings and gives the truest picture of underlying business performance. Used by every major retailer worldwide.

A company can show total sales growth just by opening new stores while existing stores decline. Comp sales strips that out.

Positive comp sales = genuine growth. Negative = store health problems.

How much total revenue will an average customer generate for your business over their entire relationship with you? A CLV of $1,200 means it is worth spending up to that amount to acquire (and keep) a customer before losing money.

CLV justifies your marketing spend. If your CLV is $1,200 but you're only spending $10 to acquire a customer, you have enormous room to invest more in growth.

The higher the CLV vs. acquisition cost, the healthier the business model.

How much does it cost you to bring in one new customer? This includes all marketing spend — social media ads, print, promotions, events, agency fees, everything. When compared to CLV, it tells you if your marketing is profitable.

If your CAC is $200 and your CLV is $150, you are losing money on every customer. The ratio must be CAC << CLV.

Healthy ratio: CLV should be 3x+ your CAC.

For every dollar you invested in something (a campaign, a fit-out, a new system), how much net profit did you get back? ROI can be applied to any investment decision — new stores, marketing campaigns, technology, staff training.

Use ROI to compare options and prioritise spending. A 50% ROI beats a 10% ROI every time, assuming similar risk.

Positive ROI = good. > 20% = strong. Negative ROI = stop doing it.

When you reduce the price of a product, what percentage of the original price have you discounted away? Markdowns are sometimes necessary — seasonal clearance, end-of-life product — but every markdown directly reduces your margin.

Tracking total markdown spend as a % of sales shows whether your buying strategy is delivering the right product at the right time.

Markdown spend: < 5% of sales = excellent | 10–15% = review buying.

How far off your budget are you — and in which direction? A favourable variance means you did better than planned (more sales, less cost). An unfavourable variance means you missed the budget. This is the core of management reporting.

Understanding WHY you have a variance is as important as knowing the number. Variance analysis drives operational decisions.

±5% = within tolerance | > ±10% = requires explanation.

Similar to net profit margin, ROS measures how much operating profit is generated per dollar of sales. It is used in head-office reporting to compare efficiency across departments, divisions or stores.

ROS lets you compare a $2M store vs a $10M store on equal terms. It strips out scale and focuses on efficiency.

Specialty retail target: 8–15% ROS.

What percentage of your revenue is being spent on staff costs? This is one of the most closely managed metrics in retail. Too high = your staffing model is unsustainable. Too low = understaffed, poor service, high turnover.

Labour is typically the largest controllable cost in retail after COGS. Even a 1% reduction on a $1M sales store saves $10,000/year.

Fashion/specialty: 15–25% | Supermarket: 10–15% | QSR: 25–35%

On average, how much revenue does each employee generate? This is a high-level productivity measure used to benchmark stores, compare departments, and assess headcount efficiency. Use FTE (full-time equivalent) for a fair comparison.

Comparing sales per employee across locations identifies high-performing stores and those needing operational support.

Fashion: $150K–$300K per FTE | Electronics: $400K–$800K per FTE

What percentage of your workforce left during a period? High turnover is extremely expensive — recruitment, training, lost productivity, and impact on customer experience all add up. Industry studies estimate replacing one retail employee costs 20–50% of their annual salary.

If your turnover rate is 60%, you are essentially replacing your entire team every 20 months. That is a culture and cost problem.

Retail industry average: 40–60% p.a. | Best-in-class: <20%

What percentage of scheduled working days are lost due to unplanned absences (sick leave, no-shows)? High absenteeism disrupts rosters, reduces service quality, increases unplanned overtime costs, and is often an early indicator of poor morale or poor management.

Proactively managing absenteeism — through engagement, wellness, and fair rostering — is far cheaper than the disruption it causes.

Target: < 3% | Warning: 5–7% | Problem: > 8%

What percentage of all hours worked were overtime? Some overtime is unavoidable, but consistently high overtime indicates poor rostering, chronic understaffing, or workload management problems. Overtime hours cost 1.5–2x the regular rate.

Even a 5% overtime rate on a 200-hour-per-week store adds up to significant unbudgeted cost across a year.

Target: < 5% | Warning: > 10% consistently

How accurately does your roster match actual hours worked? A score near 100% means you planned your staffing well. Well above 100% means you consistently underplan (staff end up working more than rostered). Well below 100% means you overplan (staff are underutilised).

Roster efficiency drives both labour cost control and service level. Over-rostering wastes money. Under-rostering loses sales.

Target: 95–105% | > 110% = under-rostered | < 90% = over-rostered

An FTE (Full-Time Equivalent) converts part-time and casual hours into a standardised unit of 1 full-time employee (typically 38 hours/week). Revenue per FTE allows you to compare workforce productivity across stores of different sizes and staffing mixes.

A store with 5 FTEs doing $500K and a store with 10 FTEs doing $600K have very different productivity profiles. Revenue per FTE reveals this.

Track year-on-year improvement within your own business.

What does it actually cost your business every time someone leaves and you need to replace them? This includes recruitment advertising, agency fees, management time interviewing, onboarding, training, and the productivity lost while the role is vacant and while the new person learns.

Making the true cost of turnover visible often motivates investment in retention. Even a $1,000 wage increase is cheap if it prevents a $15,000 replacement cost.

Estimated 20–50% of annual salary per replacement in retail.

Was the money you spent on staff training worth it? This formula measures the measurable financial benefits from training (increased sales, reduced errors, lower turnover) against what the training cost. It is the business case for investing in your people.

Training ROI makes the case for L&D investment to senior leadership in language they understand — dollars.

Industry average: $4–$6 return for every $1 spent on sales training.

How much revenue is your total headcount responsible for generating? Unlike revenue per FTE which uses full-time equivalents, this uses raw headcount (the number of people on the payroll). It is useful for quick capacity planning and HR forecasting.

Used in workforce planning to project headcount needs when setting sales targets for a new period.

Track trends within your own business over time.