Occupancy cost and lease calculator
Occupancy cost is everything you pay to be in the building, measured against your sales. Know your number before a landlord sets it for you.
How it works
Occupancy cost = (base rent + outgoings + marketing levy + other charges) ÷ sales ex GST. Sales are converted from inc GST by dividing by 1.1.
Affordable base rent = target % × sales ex GST − all other occupancy charges. The term comparison applies the yearly increase to base rent only; outgoings are held at today's level.
Before your lease talk
Take three numbers into the room: your occupancy cost today, the rent that fits your target, and the total extra the proposed lease would cost you over its term. Landlords respond to figures, not feelings.
Franchise fees vs flat membership
Turnover-based fees grow as your shop grows. A flat fee does not. Enter the figures from a franchise agreement or offer you have seen and compare.
How it works
Each year's franchise cost = sales × (royalty % + levy %) + fixed fees × 12. Sales grow by your expected rate each year. The upfront fee is added in year one. Membership cost = monthly fee × 12, held flat.
This compares fees only. Services, buying terms and support differ between groups, so weigh those too.
Questions to ask any group
What is the fee calculated on? Does it rise with my sales? What does it cost to leave, and can I sell my business on my own terms? Get the answers in writing before you sign.
GP per square metre by department
Every square metre costs you rent. See which departments earn their space, and which are borrowing it from the rest of the shop. Edit, add or remove departments to match your floor.
For agency counters such as Lotto or post office, enter your annual commission income as sales and set GP to 100%. Tick Fixed for any space you cannot change, such as an agency counter. Fixed departments are left out of space-move suggestions.
How it works
GP ex GST = sales ÷ 1.1 × GP %. GP per m² = GP ÷ floor space. Departments below the shop average are shown in terracotta.
The space-move estimate assumes GP rises and falls in line with space. Real results are rarely that tidy, so treat it as a guide to test, not a forecast.
On the shop floor
Low GP per m² does not always mean cut it. Some departments bring people in who buy elsewhere in the shop. Check basket data before you shrink a traffic driver.
Labour cost and roster calculator
Wages are usually your biggest cost after stock. Enter a typical week's roster and the rates you actually pay to see what it costs against your sales.
How it works
Weekly wages = hours × rate for each shift type. On-costs add super, workers comp and payroll tax as a percentage of wages. Sales are converted to ex GST by dividing by 1.1.
Annual figures multiply the weekly roster by 52. Leave, sick days and seasonal peaks are not included.
Using the result
If wages are above your target, you can trim hours, move hours away from penalty-rate times, or lift sales in the hours you are already paying for. The sales-per-hour figure shows which roster hours earn their keep.
Shrinkage cost calculator
Shrinkage is stock you paid for but never sold: theft, damage, short deliveries and counting errors. Put a dollar figure on it and see how hard your sales have to work to replace it.
How it works
Using a shrink %: stock lost at retail = sales ex GST × shrink %. Its cost = retail value × (1 − gross margin).
Using a stocktake: cost of lost stock = expected − counted, scaled to a full year. Sales needed to replace it = cost of lost stock ÷ net profit margin.
Where to look first
Check high-value, small items near the door, deliveries that are not checked against invoices, and price or quantity errors at the counter. Not all shrinkage is theft, and the admin causes are often the cheapest to fix.
New category payback calculator
Before you add a range, check what it costs to start, what it needs to sell, and what it replaces on the floor. A new category only helps if it beats the space it takes.
How it works
Monthly net gain = (sales ÷ 1.1 × gross margin) − GP lost from the space it replaces − extra monthly costs. Payback is the month the running total covers your set-up costs.
Opening stock is counted as cash in. It comes back as the stock sells, but it stays tied up while you keep the range.
Before you commit
Ask the supplier about minimum orders, sale-or-return, and what happens to unsold stock. A smaller trial on a single fixture often answers the question for less.
Magazine sell-through calculator
See what your magazine section really earns after staff time, fees and the space it takes. Pick a period, then enter totals from your POS and distributor statements for that same period.
How it works
Sell-through = copies sold ÷ (copies sold + copies returned). Gross profit = revenue ÷ 1.1 × your margin. Net contribution = gross profit − staff time − fees − the share of occupancy cost for the space, all for your chosen period.
Yearly figures scale your period up: a week × 52, a month × 12. The supply estimate assumes copies sold stay the same and staff time rises and falls with copies handled.
On the shop floor
Magazines draw far fewer people into the shop than they once did, so judge the section mainly on what it earns. Less space often holds most of the sales, and the space it frees can go to a department that earns more per m². Talk to your distributor about supply as you resize.
Dead stock and opportunity cost
Dead stock is not just money sitting on a shelf. It takes floor space and cash that could be earning for you. See what clearing it could be worth if what replaces it does better.
How it works
The space now earns the GP from the dead lines' remaining sales. A replacement earns the base GP per m² × floor space, lifted by 25%, 50% or 100%. The gain is the new GP less what the space earns now.
The cash freed saves its cost of money, and you stop paying holding costs on the dead stock. The clearance loss is cost less cash back. Payback is that loss ÷ the monthly gain.
The real question
The money spent on dead stock is already gone. Holding on will not bring it back. What matters is what the space and cash could earn from today. Every month you wait costs the gain you are not making.
Open-to-buy calculator
Set a buying budget for a season before the reps arrive. It starts from what you expect to sell, takes off what you already have and have ordered, and leaves the amount you can still spend.
How it works
Planned sales = last year × (1 + planned change). Stock needed at cost = planned sales ÷ 1.1 × (1 − margin) + markdowns at cost + the stock you want left at the end.
Open-to-buy = stock needed − stock on hand − stock on order. The monthly budget follows each month’s share of sales, so stock should arrive ahead of the month it sells in.
Sensitivity check: if sales miss plan, the stock you would have sold (plus its markdowns) at cost stays on the shelf and adds to your closing stock.
With the reps
Keep some of the budget back for re-orders on lines that sell. It is easier to top up a winner mid-season than to clear a loser in January. Over-buying a season is how next year’s dead stock starts.
Basket, traffic, conversion and GP
Profit is people through the door × the share who buy × what they spend × the margin you make. Small lifts in each one multiply together. See what they add up to.
How it works
Weekly sales = people × share who buy × average sale. Gross profit = sales ÷ 1.1 × margin. Each lift is applied on its own, then all together. Yearly figures are weekly × 52.
The compounding bonus is the extra you get from combining the lifts, over and above adding up each one on its own.
Where the lifts come from
Traffic: window displays, local marketing, events. Share who buy: range in stock, help at the counter, easy to find. Average sale: add-ons at the counter, bundles, card-with-gift. Margin: buying terms, range mix, fewer markdowns.
Opening hours calculator
An extra hour, a late night or a Sunday can add sales. It also adds wages, often at penalty rates. Check whether the extra hours earn their keep before you change your door sign.
How it works
New gross profit = sales ÷ 1.1 × margin × (1 − sales that would happen anyway). Cost = staff hours × rate × (1 + on-costs) + other costs. Net = new gross profit − cost.
Break-even sales are the sales in those hours that cover the cost, after allowing for the sales you would get anyway.
Before you decide
Run a trial for six to eight weeks and track sales by hour. Count the full cost of the hours, not just the till. If the owner works the hours, decide what an hour of your time is worth.