Repeat bookings, no-shows and product usage in a small salon

Count a completed return separately from a future booking

At checkout, offer the next suitable service window based on the client's plan and preference. Record whether they book, whether that booking later changes, and whether they actually return. A future booking helps organize the calendar; it becomes service output only when the visit is performed. Avoid counting several future bookings for the same client as several retained clients.

Consider 120 distinct clients, each completing one initial visit. 72 make a next booking at checkout, a 60.0% checkout rebooking rate. Give every client 8 weeks of follow-up from their own initial visit. 66 checkout rebookers and 18 others complete at least one return inside that window.

The forward completed-return rate is 70.0%, while 36 clients have not completed a return by the cutoff. Those clients are not automatically permanent losses: they may need a longer cycle, have a future booking outside this window or choose another provider. Use service-specific intended return windows and exclude immature cohorts from the final rate. These fictional numbers demonstrate the definitions; they do not show that checkout rebooking caused the return.

Software metrics can answer a different question. Square's retention measure looks backward at returning clients among clients visiting during the report period. Its pre-booking definition allows a future appointment created within 24 hours after a visit ends; canceled and no-show appointments are excluded, and recurring appointments have stated limitations. Our checkout measure and forward cohort should therefore not be labeled as the same report. Report definitions

Measure lost time by the original slot and its replacement

Keep cancellation and attendance status separate. An advance cancellation releases time that might be filled. A late cancellation is classified against the salon's stated window. A no-show has no prior cancellation and no arrival. A reschedule creates another appointment; it does not automatically restore the abandoned slot. Use the original slot ID to link a replacement rather than deleting the history.

In the next independent worksheet, 100 original appointments each require 1 performed stylist-hour. 10 are late-canceled and 5 are no-shows, leaving 85 original visits completed. The waitlist produces 6 completed replacements for canceled slots; no no-show slot is refilled in this example.

The original appointment no-show rate is 5.0%. The canceled-slot refill rate is 60.0%, and completed service output is 91 hours. Do not put the replacement bookings into the original rate denominator, or claim every waitlist response produced a completed visit. Longer missed services should be weighted by their lost active hours; a count of visits alone hides their different effect on output.

Translate unused hours into contribution without removing fixed pay

The retained salon model assumes $95.00 service revenue per performed stylist-hour, $18.00 products per hour and 3.0% payment expense on service revenue. Its variable cost is $20.85 and contribution is $74.15 per hour, before fixed employee pay, owner pay and overhead. These are the published illustrative case values, not observed salon prices or margins.

A fully performed 100-hour book would produce $9,500.00 of service receipts. The 91 performed hours produce $8,645.00 of receipts and $6,747.65 of contribution. The 9 unused hours lose $667.35 of contribution versus that full-book comparison. Fixed shifts and owner compensation remain payable.

This comparison assumes product is not mixed for the absent client and payment fees arise only on performed service receipts. If product was already prepared, log its actual discarded cost separately; the avoided-cost assumption then overstates the savings. A no-show fee is not assumed. A reserved slot, prepaid amount or possible cancellation charge must not be added to both performed service receipts and a second recovery line.

The current base model already uses a performed/booked-hour utilization assumption. This worksheet does not subtract an additional blanket no-show percentage from that model or add a new expense row. A future input revision would need a clear demand-to-booking-to-completion bridge and a recalculated monthly ledger.

Use reminders, release rules and a duration-matched waitlist

Make the service, assigned stylist, date and cancellation route easy to confirm. Check reminder delivery and responses rather than treating a sent message as attendance. Square documents configurable email/text reminders and different indicators for confirmed and unconfirmed appointments. Those capabilities do not establish an improvement rate for this salon. Reminder controls

Before taking an appointment, show the actual cancellation window, how to change the booking, any fee or prepayment, and the circumstances for refunds or exceptions. Make a qualified review of enforceability for the salon's location part of adopting a policy. Square's card hold and enforcement controls are software mechanisms; a held card may decline and does not guarantee receipts. Record any charge, settlement, refund or waiver as it occurs. Prepayment and no-show settings

When time opens, match the requested service, available stylist, actual duration, resources and client's availability. A waitlist entry is interest, so mark a slot restored only after its replacement is completed. Square's waitlist supports service and availability information and staff follow-up; feature eligibility needs checking before purchase. Waitlist documentation

Compare several full weeks before and after a change, including booked hours, service mix and reminder delivery. A quieter period or shorter services can lower the missed count without improving the process. Calculate the contribution of additional completed hours against actual incremental software or staff costs before deciding whether to keep the change.

Cost everything mixed, then identify the portion discarded

For each relevant service, record product components, first mix, any top-up and remaining mixture. Wella's US regrowth combination example describes a one-to-one color/developer ratio; the same manufacturer article uses other ratios for other techniques. That establishes a technique-specific example, not a universal salon recipe. Follow the selected product's current instructions and measuring basis. Manufacturer technique boundaries

The independent cost worksheet assumes 30 grams of a color component and 30 grams of developer, with hypothetical landed costs of $0.16 and $0.02 per gram. Its equal-gram basis and amounts are declared assumptions, not Wella directions or supplier quotations. Do not derive gram cost from a container's milliliter label without a valid mass basis.

The 60 grams mixed cost $5.40. If 12 grams remain, 48 were applied and the discarded share is 20.0% of mixed mass. For a homogeneous mix, the leftover cost is $1.08. That cost is already inside the full mixed-product amount; adding it again would count the same material twice.

Across 20 same-scope visits, the initial mixed-product cost is $108.00, including $21.60 of discarded material. The smaller-portion trial saves $18.00 only if the same adequate application is achieved without extra mixing, waste, remakes or treatment changes. Any additional batch belongs in the cost log. Do not reduce a formula's required proportion or appropriate coverage to make the worksheet pass.

The base $18.00 allowance covers service products across the salon's whole mix. This single mixture is one possible component, not a second cost to add on top. Retail merchandise sold to clients also needs its own sales, cost and stock records if introduced; the current salon case does not include retail revenue.

Connect repeat demand and product use in the weekly review

Use repeat-client records to prepare suitable appointment windows and anticipate product needs, while allowing for changed hair length, technique and desired result. Compare product cost per completed service and per performed stylist-hour, with consistent service groups. A week with more cuts can show lower color use without any improvement in portion control.

Reconcile stock physically: opening usable stock plus receipts, less backbar issue, retail issues and disposals, must explain closing usable stock. Purchases and use occur at different times, so a lower material-use worksheet need not reduce this week's supplier payment. Investigate expiry, unmapped service issues and measurement differences before labeling the residual as waste.

Bring the completed hours back to the salon's unit-economics guide and fixed costs to the profitability guide. The weekly operating decision is which process restores worthwhile completed hours and reduces avoidable product use while keeping the service promise, with actual records replacing the hypothetical counts and cost coefficients.