Independent investor planning tool · v3Dairy Don · Pune
Not saved yet
Site feasibility · Unit economics · Investment · Risk

Footfall, Profitability, Payback & Risk

A single model that goes from people walking past the storefront to bills, menu-mix revenue, GST, royalty, aggregator costs, fixed costs, seasonality, ramp-up, capital investment, payback and the probability of making money. Every input is editable; results update instantly.

Example data only: pedestrian counts, menu prices, costs, royalty and capex are illustrative placeholders, not measured Pune data or Dairy Don's actual terms. Replace them with on-site counts, franchisor-confirmed terms and real quotations before any investment decision.

Who passes the shop?

Count people walking past the proposed storefront for 15 minutes in each time block, separately on weekdays and weekends. Do not count cars as pedestrians.

Time blockOpen hours
in block
Weekday
passers / 15 min
Weekend
passers / 15 min
12–4 PM
Afternoon
4–7 PM
Evening
7–11 PM
Peak dessert hours
Counts are de-seasonalised using this month's index in Section 06, so a November count isn't treated like a May count.
Feeds the risk simulation — more samples, narrower uncertainty.

A 15-minute sample is multiplied by 4 to estimate passers per hour. Average several samples taken on different days; avoid counting the same person repeatedly.

How many people walk in — and how many bills?

These factors convert relevant passers into walk-ins and bills. They are assumptions to test; calibrate them against an existing Dairy Don outlet below.

65%

Share of pedestrians likely to consider an ice-cream purchase.

4.0%

Of relevant passers, how many enter at an average site?

Footfall counts people; a family of 3 pays one bill. Read from POS: covers ÷ bills.
78%

Share of people entering who are part of a purchasing group.

People who come specifically for Dairy Don and were NOT counted passing the storefront.

Calibrate capture from an existing Dairy Don outlet NEW

The single biggest accuracy gain: count passers outside a running Pune outlet and take its bill count from the POS for the same days. The model back-solves the capture rate instead of guessing it.

Enter reference outlet data to see the implied capture rate.

What does each bill earn?

Instead of one average bill and one margin, the bill is built from the menu mix. Food cost % is on the GST-exclusive price and should include cones, cups, toppings and packaging.

Category% of billsAvg ticket (₹, menu)Food + pack cost %
—
Bills adding toppings, extra scoop, waffle cone.
Restaurant/parlour service: 5% without input tax credit (GST 2.0, Sept 2025). Confirm with your CA.
Placeholder — confirm with Dairy Don.
Placeholder — confirm with Dairy Don.
Blended: UPI is mostly free; cards ~1.5–2%.

Revenue that isn't footfall

Aggregator economics are itemised because the true take-rate (commission + GST on commission + discounts + packaging) is far higher than the headline commission.

Platform collects & pays the 5% GST.
Swiggy/Zomato typically ~18–30%.
A cost, as no ITC at 5% restaurant rate.
—

Fixed costs — item by item

Monthly estimates in ₹ (Year-1 levels). Escalation rates drive the 5-year projection.

A. Premises & utilities

—

B. Staff salaries & employer costs

—
Employee / roleSalary per month (₹)

C. Administration & marketing

—
Total monthly operating expenses—
Applies to food cost, utilities, admin.

A Pune year, month by month

Index of demand vs a normal month (1.00). Defaults assume a hot-summer peak (Mar–May) and a monsoon dip (Jul–Sep) — replace with Dairy Don's own month-wise sales from Pune outlets if they share them.

New outlets take time to build habit.
Repeat customers, loyalty, area growth.

What it costs to open — and how it's funded

Placeholders sized to a 500–600 sq ft parlour. A public franchise listing quotes a ₹3 lakh brand fee and ₹30–50 lakh total investment; confirm every line with Dairy Don and vendors.

Refundable; returned at the end of the term in the IRR.
Total investment incl. deposit—
Listing shows a 5-year renewable term.

Can the counter serve the demand — and does the area support it?

Capacity limits sales at peak hours (bills above capacity are lost). The catchment method is an independent second estimate of demand — if both methods agree, confidence rises.

From society counts / ward data.

Month by month: sales, profit and cash

Includes opening month, ramp-up, seasonality, price and volume growth, cost escalation, capacity limits and loan repayment. Pre-tax.

Net salesEBITDALoss month
Cumulative project cash (vs total investment)Cumulative owner cash after EMI (vs equity)

Ratios vs common parlour / QSR rules of thumb

Mature year (Year 2). Bands are general industry rules of thumb, not Dairy Don standards — ask Dairy Don for their outlet benchmarks.

How likely is this to make money?

Monte Carlo: 1,500 runs varying traffic (by count reliability), capture ±35%, conversion ±8 pts, group size ±15%, prices ±10%, food cost −3/+4 pts, fixed costs −5/+10%, delivery −50/+30%.

Distribution of Year-2 (mature) EBITDA
——
P10 · bad case—
P50 · median—
P90 · good case—
Chance Year-1 EBITDA > 0—
Chance payback ≤ 36 months—
Chance payback within term—

—

What moves profit most?

Change in Year-2 EBITDA when each input moves ±10%, others fixed (red = profit falls, green = profit rises). Spend due-diligence effort on the top bars.

Practical actions, ranked by ₹ impact

Each action applied alone to the current model; impact on Year-2 EBITDA per year.

Do two independent methods agree?

Footfall method: in-store bills / month—
Catchment method: bills / month—
Gap (footfall vs catchment)—
—
Service capacity (bills / hour)—
Peak-hour demand, weekend in peak season—
Peak utilisation—
Bills lost to queues in Year 1—
—

Compare candidate sites side by side

Use “Save site for comparison” after entering each location's counts and costs. Saved sites are stored in the database with the model; download a file to keep a backup.

What to ask Dairy Don & how to grow footfall and profit

Data to request from Dairy Don

  • Month-wise bills and sales of 2–3 existing Pune outlets (replaces Section 06 defaults)
  • Bill count, covers per bill and add-on attach rate from POS (calibrates Sections 02–03)
  • Actual royalty, brand fund, supply-chain mark-up and minimum purchase terms
  • Recipe-level food cost per category and their standard wastage allowance
  • Approved equipment list, fit-out spec and vendor quotations
  • Territory exclusivity radius, term, renewal fee and exit/transfer clauses

Footfall levers

  • Frontage: lit signage visible from both traffic directions, open counter view of softy swirl
  • Google Business Profile with photos, hours and a steady flow of reviews — drives destination visits
  • Launch sampling and combo offers aimed at nearby colleges, gyms and societies
  • Late-night hours on weekends if the 7–11 PM block is the strongest
  • Monsoon menu (hot brownie sundaes, hot chocolate) to soften the Jul–Sep dip

Profit levers

  • Menu engineering: push high-margin signatures and combos; toppings as default upsell prompts at POS
  • Take-home tubs and festival packs (Diwali, Raksha Bandhan, birthdays) lift ticket size
  • Party, corporate and society event orders — high value, schedulable, little counter load
  • Direct ordering via WhatsApp catalogue or ONDC-based apps to reduce aggregator take-rate
  • Stock control: FIFO, batch prep sized to hour-of-day demand from POS reports

Measure after opening

  • Weekly: bills/day by hour, avg bill, attach rate, food cost % vs recipe standard
  • Monthly: rent and staff % of sales, delivery take-rate, review rating
  • Loyalty/CRM (phone number at billing) to track repeat rate — the real driver of volume growth
  • Re-run this model with actuals after month 3 to update payback

How the model works

Passers/day = Σ(15-min count × 4 × open hours) ÷ seasonal index of the month counted.

Walk-in people = Passers × relevant share × base capture × visibility × access × competition × appeal × marketing + destination visitors.

Bills = Walk-in people × purchase rate ÷ people per bill, capped by counter capacity in the busiest hour.

Month m = Bills × seasonal index × ramp-up × volume growth; prices, rent, salaries and other costs escalate yearly.

EBITDA = Net sales (ex-GST) − food & wastage − royalty & brand fund − aggregator commission (+GST), discounts & packaging − payment fees − fixed costs. EMI, interest and depreciation are shown below EBITDA. Income tax is not modelled.

IRR uses −total investment at opening, monthly EBITDA for the term, and the deposit refunded at the end; equity payback uses cash after EMI vs owner's equity.

Market reference notes used for defaults (verify before relying on them)
  • Dairy Don franchise listing: ~₹3 lakh brand fee, ₹30–50 lakh investment, 500–600 sq ft, 5-year renewable term — franchiseindia.com. Royalty is not stated there; the 4% + 1% defaults are placeholders.
  • GST 2.0 (from 22 Sep 2025): ice cream goods moved from 18% to 5%; standalone restaurant/parlour service stays 5% without input tax credit — Petpooja, Motilal Oswal.
  • Aggregator commissions: roughly 18–30% plus 18% GST on commission, with restaurant-funded discounts and packaging on top — DineOpen, Petpooja. Lower-commission alternatives (ONDC-based apps) are emerging.
Sampling guidance & limitations
  • Count at the exact shop frontage; a busy junction 100 m away is not the same as your entrance.
  • Take several 15-minute observations per block on multiple weekdays and weekends; record the month.
  • Capture, conversion and multipliers are assumptions until calibrated against a running outlet.
  • Destination visits must exclude anyone already counted passing.
  • Risk ranges in the simulation are judgement-based triangular distributions, not fitted from data.
  • Not modelled: income tax, GST compliance cash timing, equipment replacement, renewal fee, cannibalisation by another Dairy Don outlet.