Worksheets & WorkbooksXLSXBritish Columbia version

Weekly Staff Scheduling & Ratio Planning Model

Two-sheet scheduling and ratio planning workbook. Sheet 1 organizes individual educator shift hours and break schedules. Sheet 2 dynamically analyzes room child counts against staff on the floor across 5 key daily time blocks (Drop-Off, Morning, Lunch/Breaks, Naptime, Afternoon) and alerts to ratio or qualification deficits under BC CCLR Schedule E.

Workbook preview
Monthly forecast dashboard
XLSX
Opening cash
$45k
Inflows
$58k
Outflows
$58k
Closing cash
$62k
Jan
$4,820
$4,820
$4,820
$4,820
Feb
$5,135
$5,135
$5,135
$5,135
Mar
$4,820
$4,820
$4,820
$4,820
Apr
$5,135
$5,135
$5,135
$5,135
May
$4,820
$4,820
$4,820
$4,820
Jun
$5,135
$5,135
$5,135
$5,135

What this product solves

Actively simulates ratio coverage across daily transition blocks to prevent illegal under-staffing.

Who it is for

Daycare Directors, Schedulers, Room Supervisors

What is included

Weekly Staff Scheduling & Ratio Planning Model — Quick Start & User Guide
Weekly Staff Shift Allocation & Hours
Time-Block Child-to-Staff Ratio Simulation & Qualification Hierarchy Analysis

Buyer information required

The customization flow collects jurisdiction, reusable facility profile details, branding choice, and any product-specific questions defined by the product schema.

Important limitation

Operational Template & Spreadsheet Notice: This spreadsheet workbook is an operational management template and does not replace independent legal, licensing, payroll, or accounting advice. Childcare operators are responsible for verifying formulas and adapting all records to ensure compliance with the British Columbia Child Care Licensing Regulation, WorkSafeBC OHS requirements, and Employment Standards Act.

Related resources

Forms & Records
$39 CAD
PDF + HTML

23-Card Classroom Quick Reference Pack

Complete deck of 23 single-page operational reference cards designed for classroom wall posting and clipboards.

British Columbia versionCustom branding supported
View product
Worksheets & Workbooks
$49 CAD
XLSX

ChildCareBC CCFRI, ACCB & ECE-WE Funding Reconciliation Ledger

Multi-sheet provincial childcare subsidy ledger calculating CCFRI fee reductions, parent co-pays, and ECE Wage Enhancement grants ($6.00/hr + 19.90% benefits).

British Columbia versionCustom branding supported
View product