Skip to content
Astera Technology

Unused booking capacity calculator

Estimate unused slots and hours under your no-show and refill assumptions, without treating averages as actual bookings.

Rates are assumptions. Fractional expected slots are averages; refilled slots have the same duration. This tool does not calculate revenue or fees.

Expected unused capacity 15 slots, or 11.25 hours.

Expected unused slots
15
Unused hours
11.25
Scheduled slots split by assumed attendance and refill
Expected quantities under the entered assumptions
ComponentExpected slots
Attended as scheduled180
Refilled missed slots5
Unused slots15

Separate missing attendance from refilled capacity

Start with slots already scheduled within one chosen period. The assumed no-show rate gives expected missed slots. The refill rate applies to those missed slots, not to the whole scheduled total. Refilled slots have the same duration. The model neither creates a waitlist booking nor decides whether a customer may cancel.

Synthetic 200-slot period
Assumption or resultValue
Scheduled slots200
Assumed no-show rate10%
Expected missed slots20
Refill share of missed slots25%
Expected refilled slots5
Expected unused slots15
Download editable CSV ↓

Is the 25% refill share applied to 200 scheduled slots or twenty expected missed slots?

Show the worked answer

To the twenty missed slots: 20 × 25%=5 refilled, leaving fifteen unused. Applying it to all two hundred would invent fifty refills from only twenty missed slots.

Keep expected capacity separate from observed attendance

Convert unused slots to time
QuantityCalculationResult
Unused slots20 − 515
Unused minutes15 × 45675 minutes
Unused hours675 ÷ 6011.25 hours
Download editable CSV ↓

Expected values may have fractions: three slots at a ten-percent no-show rate produce 0.3 expected missed slots. That is an average under the assumption, not a partial booking or an attendance record. The chart partitions scheduled capacity into attended-as-scheduled, refilled and unused components; the table preserves exact reading without relying on colour.

If all twenty missed slots can be refilled, how much capacity remains unused?

Show the worked answer

Zero under this model: the refill rate is 100%, so twenty are refilled and no missed capacity remains unused. This does not mean no one missed the original booking.

Measure attendance and successful refill separately when reviewing the assumptions. This calculator has no revenue, refund, fee or staffing-cost model and gives no actual customer outcome. Use the separate booking planner when you need feasible start times and resource availability.

Related resources