Capacity and Booking Bottleneck Audit

Audit booking capacity from real records: Bookings with dates, statuses and durations: {booking_records} Staff availability and skills: {staff_records} Resource and equipment limits: {resource_limits} Cancellations, delays and rework: {exception_records} Required quality, safety, break and buffer rules: {operating_rules} Audit period and owner constraints: {period_and_constraints} Remove personal identifiers before sharing. Require real pasted data before numerical analysis. Inventory periods, units, completeness and limitations. Separate zero from missing data, flag duplicates, conflicting statuses and incomplete durations, and ask for critical omissions. Do not infer actual capacity from booked slots alone. Show usable capacity calculations after breaks, setup, cleanup, buffers, skill restrictions and resource limits. Keep bookings, completed work, cancellations and rework separate. Compare planned and actual durations where supported. Identify labor, skill, equipment, space or booking-rule bottlenecks without double-counting shared resources or overlapping staff time. Return an evidence-linked bottleneck table, calculations, labeled assumptions, evidence gaps and prioritized adjustments. For each adjustment include supporting records, quality safeguards, dependencies and human decisions. Never recommend overbooking, skipped breaks, reduced safety margins or quality shortcuts. Cancellations are not assured future spare capacity. Reconcile data, mark unsupported conclusions undetermined and require manager review of feasibility, quality and applicable work rules before changes.