Business

Daily break-even sales: how much a shop must sell to cover rent

Divide a made-up month's fixed costs by working days and then by average margin to get the daily sales a shop must beat, with spreadsheet formulas.

Editorial illustration for Daily break-even sales: how much a shop must sell to cover rent

Daily break-even sales is the fixed cost for one day divided by your average margin. Add up the month's fixed costs, divide by the days you trade, then divide that by the share of each sale that is left after the cost of goods. With made-up fixed costs of ₹34,000 and a 20 percent margin, a shop that opens 26 days must sell about ₹6,540 a day just to cover its costs.

What counts as a fixed cost?

Costs you pay whether or not a single customer walks in. A made-up month for a small shop: rent ₹20,000, one helper's pay ₹10,000, electricity ₹2,500, and phone, internet and other regular items ₹1,500. The total is 20,000 + 10,000 + 2,500 + 1,500 = ₹34,000. Goods you buy for resale are not fixed costs; their cost is already inside the margin.

How do I turn that into a daily number?

  1. Fixed costs for the month: ₹34,000.
  2. Days the shop opens: 26.
  3. Fixed cost per day: 34,000 ÷ 26 = ₹1,307.69.
  4. Average margin on sales: say 20 percent, which means ₹20 of every ₹100 sold is left after the goods cost.
  5. Break-even sales per day: 1,307.69 ÷ 0.20 = ₹6,538.46, about ₹6,540.

Check: ₹6,538.46 × 0.20 = ₹1,307.69, exactly the day's fixed cost. Over 26 days that is 6,538.46 × 26 = ₹1,70,000, which is the month's fixed costs divided by 0.20.

How many bills is that?

If the average bill is ₹180, then 6,538.46 ÷ 180 = 36.3, so about 37 bills a day. That number is easier to watch than a rupee figure: if you only see 25 bills by evening, you know where you stand.

What if I want to pay myself?

The figure above covers the shop's costs only. If you want to draw ₹15,000 a month for yourself, add it to the fixed costs: 34,000 + 15,000 = ₹49,000. Per day, 49,000 ÷ 26 = ₹1,884.62, and the sales needed are 1,884.62 ÷ 0.20 = ₹9,423.08. In bills of ₹180, that is 9,423.08 ÷ 180 = 52.4, so 53 bills.

CaseFixed costs a monthBreak-even sales a dayBills a day at ₹180
Shop costs only₹34,000₹6,53837
With ₹15,000 owner draw₹49,000₹9,42353
Shop costs, open 30 days₹34,000₹5,66732

The third row shows that opening more days spreads the same fixed costs over more days: 34,000 ÷ 30 = ₹1,133.33, divided by 0.20 gives ₹5,666.67. But only count days when the shop truly opens and trades normally.

What are the formulas in a spreadsheet?

In Excel or Google Sheets, put fixed costs in B1, working days in B2 and margin as a decimal in B3. Then daily break-even sales is the single formula below.

  • Daily fixed cost in B4: =B1/B2
  • Break-even sales a day in B5: =B4/B3
  • Bills a day in B7, with average bill in B6: =B5/B6

Change one input at a time to see what matters. Cutting a rent by ₹2,000 lowers the daily target by 2,000 ÷ 26 ÷ 0.20 = ₹384.62. Raising the margin from 20 to 25 percent lowers it from ₹6,538 to 1,307.69 ÷ 0.25 = ₹5,231.

How do I compare the target with last month's sales?

Take last month's total sales and multiply by your margin. If sales were ₹1,62,000 and the margin 20 percent, gross profit was 1,62,000 × 0.20 = ₹32,400. Against fixed costs of ₹34,000 that is a shortfall of ₹1,600. Break-even for the month was ₹1,70,000, so the shop sold ₹8,000 short of it. Looking at the shortfall in rupees tells you how big the gap is, and whether it is worth chasing with sales, margin or cost.

When a sheet stops being enough

If your fixed costs come from many bank payments each month, upload your bank statement to SpendixAI and review the rows to see what you actually paid, then use those totals in your sheet. Check the margin against real bills before you trust the target.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports