Dog daycare pricing calculator for owners

Tags:

Dog daycare

Operations

Ana Malhotra, co-founder and CEO of Tato

Published:

What rate should you charge for dog daycare?

Start with the cost of serving the paid visits you realistically expect, then calculate the rate needed for your target operating margin. Use that result to test your prices against your service, demand and local alternatives.

Your cost floor per dog-day is monthly fixed costs divided by paid dog-days, plus variable cost per dog-day. To model a target margin, divide that floor by one minus the margin. Margin here means the operating remainder as a share of revenue, not a markup on costs.

The SBA’s break-even guide separates fixed and variable costs and treats the result as an estimate. The worksheet below applies that approach to daycare visits. It gives you a planning number, not a universal recommended rate or a profitability promise.

What counts as a paid dog-day, and how much attendance should you expect?

For this worksheet, count one paid dog attending one full day as one paid dog-day, including a visit redeemed from a prepaid pack. Count visits delivered, not packs sold or booking requests received.

Use your attendance records to estimate average paid dogs per open day. Multiply that average by the days you expect to open that month. Allow for quiet weekdays, seasonal changes and cancellations instead of assuming every available space will sell.

Keep free visits outside the paid count, but include their cost in your budget. If you offer half-days or services with different costs, model them separately or build an explicit weighted mix. Do not assume a half-day costs exactly half as much to provide.

Your usable capacity is a check on the forecast, not the attendance forecast itself. Compare expected dogs with the space, staffing and group arrangements you can actually support. Do not divide monthly costs by your licensed capacity unless you realistically expect that many paid visits.

Which monthly costs belong in your daycare pricing model?

Include the recurring costs needed to deliver the daycare service, with a consistent share of expenses you split with boarding, grooming or another service.

Build your monthly fixed-cost input from rent, insurance, software and the baseline staffing you plan to schedule. Include owner labor if you work those shifts. Use actual payroll records, employer costs, benefits, bills and local quotes to build a loaded labor budget. Count each cost once.

Put costs that rise with each additional dog-day into the variable input, such as incremental supplies or genuinely visit-dependent labor. Keep baseline payroll out of that input if it is already in your monthly total.

An extra shift is a separate staffing step: add its full loaded cost when your attendance scenario requires it. Do not assume your current staff budget can support every increase in attendance.

The simplified example excludes percentage-of-revenue processing fees, tax, financing and any unallocated shared-service costs. It therefore shows a modeled operating remainder, not take-home profit. Before setting prices, account for those exclusions and review your cost allocation with your accountant.

How do you build a copyable daycare rate calculator?

Paste the tab-separated worksheet below into cell A1 of a blank Google Sheet or Excel sheet, then replace the six inputs in B1:B6 with your assumptions.

The first line belongs in row 1; there is no header row. Paste only the contents of the code block. Labels go in column A and values or formulas in column B. These formulas use English function names and comma separators. If your spreadsheet uses another locale, adjust its formula separators before using them.

Monthly fixed costs	18000
Variable cost per paid dog-day	6
Expected paid dogs per open day	20
Open days per month	22
Target modeled margin	15%
Realized revenue per paid dog-day	50
Input check	=IF(COUNT(B1:B6)<>6,"Enter six numeric inputs",IF(OR(B1<0,B2<0,B3<=0,B4<=0,B5<0,B5>=1,B6<=0),"Use nonnegative costs, positive attendance/days/rate, and margin from 0% to below 100%","OK"))
Paid dog-days	=IF(B7<>"OK",B7,B3*B4)
Modeled monthly costs	=IF(B7<>"OK",B7,B1+B2*B8)
Cost floor per dog-day	=IF(B7<>"OK",B7,B9/B8)
Rate for target margin	=IF(B7<>"OK",B7,B10/(1-B5))
Monthly revenue at realized rate	=IF(B7<>"OK",B7,B6*B8)
Modeled operating remainder	=IF(B7<>"OK",B7,B12-B9)
Modeled operating margin	=IF(B7<>"OK",B7,B13/B12)
Monthly fixed costs	18000
Variable cost per paid dog-day	6
Expected paid dogs per open day	20
Open days per month	22
Target modeled margin	15%
Realized revenue per paid dog-day	50
Input check	=IF(COUNT(B1:B6)<>6,"Enter six numeric inputs",IF(OR(B1<0,B2<0,B3<=0,B4<=0,B5<0,B5>=1,B6<=0),"Use nonnegative costs, positive attendance/days/rate, and margin from 0% to below 100%","OK"))
Paid dog-days	=IF(B7<>"OK",B7,B3*B4)
Modeled monthly costs	=IF(B7<>"OK",B7,B1+B2*B8)
Cost floor per dog-day	=IF(B7<>"OK",B7,B9/B8)
Rate for target margin	=IF(B7<>"OK",B7,B10/(1-B5))
Monthly revenue at realized rate	=IF(B7<>"OK",B7,B6*B8)
Modeled operating remainder	=IF(B7<>"OK",B7,B12-B9)
Modeled operating margin	=IF(B7<>"OK",B7,B13/B12)
Monthly fixed costs	18000
Variable cost per paid dog-day	6
Expected paid dogs per open day	20
Open days per month	22
Target modeled margin	15%
Realized revenue per paid dog-day	50
Input check	=IF(COUNT(B1:B6)<>6,"Enter six numeric inputs",IF(OR(B1<0,B2<0,B3<=0,B4<=0,B5<0,B5>=1,B6<=0),"Use nonnegative costs, positive attendance/days/rate, and margin from 0% to below 100%","OK"))
Paid dog-days	=IF(B7<>"OK",B7,B3*B4)
Modeled monthly costs	=IF(B7<>"OK",B7,B1+B2*B8)
Cost floor per dog-day	=IF(B7<>"OK",B7,B9/B8)
Rate for target margin	=IF(B7<>"OK",B7,B10/(1-B5))
Monthly revenue at realized rate	=IF(B7<>"OK",B7,B6*B8)
Modeled operating remainder	=IF(B7<>"OK",B7,B12-B9)
Modeled operating margin	=IF(B7<>"OK",B7,B13/B12)

Format B5 and B14 as percentages. Format money outputs B9:B13 as currency with two decimal places. Leave the formulas unrounded so later calculations use their full values. B7 must say “OK” before you use the outputs; blank inputs, negative costs, nonpositive attendance or rates, and margins outside the allowed range produce a correction message.

Every input shown is hypothetical, not an industry benchmark. In this example, 20 paid dogs across 22 open days gives 440 paid dog-days. Monthly costs are $18,000 plus $6 multiplied by 440, or $20,640. That produces a $46.91 cost floor and a $55.19 modeled rate for a 15% target margin, rounded for display.

At a realized rate of $50, the same example produces $22,000 in revenue and a $1,360 modeled operating remainder. Divide that remainder by revenue and the modeled margin is 6.18%.

Percentage processing fees need a separate adjustment. If you model a fee fraction f of all revenue, the target-rate denominator becomes 1 minus margin minus f. That denominator must stay positive. Do not use the worksheet’s target-rate output unchanged when those fees are material or count the same fee in two places.

How do packages and discounts change your realized rate?

Check revenue per redeemed visit after discounts, rather than assuming your posted day rate is what every visit earns.

In a hypothetical 10-visit pack priced at $500, each visit earns $50 if all 10 are used. You can check that in any empty cell with =500/10. Against the worksheet’s assumptions, that rate produces the 6.18% modeled margin above, not the 15% target.

For a mix of full-price visits and packs, allocate the pack price across its included visits, add the revenue assigned to visits delivered, and divide by those visits. Use the result in B6. Keep refunds and credits consistent with that allocation; do not divide all cash collected from new packs by this month’s attendance. Some prepaid visits may happen later.

Before approving a discount, rerun the worksheet at the proposed realized rate and realistic attendance. More visits only help this model if their revenue covers the added costs, including any extra staffing step. Test packages assuming every included visit is used rather than relying on unused credits to make the price work.

When should you rerun the calculator?

Rerun it whenever your staffing plan, recurring costs, attendance forecast or package mix changes.

Save a quieter-month scenario alongside your expected month. Change paid dogs per day and opening days, then check whether fixed costs still fit the resulting revenue. For a busier scenario, add any required staff costs before judging the result.

Keep a short note beside each saved scenario explaining its attendance source, staffing assumption and excluded costs. Review actual attendance and realized revenue against those assumptions so your next pricing decision uses what happened in your facility.

What should you bring to a Tato demo?

Bring your worksheet, current rate sheet and one real package policy so you can test how your pricing decisions would work for staff and parents.

Tato supports staff daycare bookings, request review, check-ins, check-outs and payments. Parents can browse portal-visible plans and inspect their passes and packs. Confirm which products and settings fit your location during the demo.

Ask to walk through a full-price visit, a pack redemption, a discount and a refund scenario. Check what a staff member reviews, what the parent sees and how you would trace the visit and its payment afterward. Treat these as demonstrations to request, not assumptions about your setup.

Use the dog daycare software guide to prepare your broader workflow questions. Then book a Tato demo and bring the rate and package you want to test.