Childcare Center Waitlist Capacity Analysis Builder

You are an operations data analyst helping a childcare center understand waitlist demand and classroom capacity. Build an analysis plan for:

Program type: [infant care, toddler rooms, preschool, mixed-age center, Montessori, after-school care, multi-site provider]
Location and licensing context: [state/country, licensing rules to verify, classroom ratio constraints, age bands]
Data sources: [waitlist form, inquiry CRM, enrollment system, classroom roster, staff schedule, sibling priority list, tour records, withdrawal notices]
Time period: [current waitlist, last 6 months, enrollment cycle, school year, year-over-year]
Age groups: [infant, young toddler, older toddler, preschool, pre-K, school-age]
Capacity constraints: [licensed capacity, staff availability, room size, nap space, part-time schedules, transition dates, holidays]
Demand details: [preferred start date, full-time vs part-time, days requested, sibling status, subsidy status if allowed, location preference]
Operational questions: [which age group is constrained, when seats open, whether to hire staff, how many tours to schedule, how to reduce stale waitlist entries]
Data quality issues: [duplicate families, outdated start dates, missing birthdates, no response, multiple children, manual notes]
Stakeholders: [director, enrollment coordinator, owner, finance, classroom leads, families]
Output needs: [dashboard, weekly enrollment forecast, staffing discussion, board report, family communication plan]

Create:
1. Data cleaning checklist for family, child, age band, start date, priority, and status fields.
2. KPI definitions for active waitlist, qualified demand, age-band demand, conversion, response rate, stale leads, and projected seat openings.
3. Capacity model that separates licensed capacity, staffed capacity, scheduled attendance, and practical classroom constraints.
4. Age-transition forecast showing when children move rooms and how that affects openings.
5. Scenario analysis for hiring, room reallocation, part-time matching, and start-date batching.
6. Dashboard layout with age group, desired start date, source, priority, and conversion filters.
7. Family communication recommendations for updates, confirmation requests, and realistic timelines.
8. Staffing and finance questions to answer before changing capacity.
9. Data privacy and fairness cautions, including sensitive family information and priority policies.
10. Executive summary template with assumptions, constraints, and next decisions.

Do not invent licensing ratios, eligibility rules, subsidy rules, or family priority policies. Mark anything requiring director, legal, licensing, or finance verification.