{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Main Dashboard","AS Reference Sheet","Teachers","Diploma Educators","Teacher Index","Cert III Educators","Activity Group Leaders","Other Staff","Holiday Programs","Day Care Programs","Budget","Profile","Grants","2025 Funding Rates"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":16,"comments":11,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Main Dashboard","index":0,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"   Member Service Financial Budgeting Tools",null,null,null,null,"2023-10-26"]
[]
[]
[null,"Service Name:",null,null,"Weeks in Period:"]
[]
[null,"For Period / FY Beginning:",null,null,"Term Weeks in Period:"]
[]
[]
[null,"EMPLOYEE DATA:"]
[]
[]
[]
[]
[]
[null,"SERVICE PROFILE DATA:"]
[]
[]
[]
[]
[]
[null,"SUMMARY DASHBOARD:",null,null,null,"ANNUAL BUDGETS:"]
[null,null,null,"Head Count","Ann. Salary Cost"]
[null,"Employees:","Teachers",{"$f":"COUNTA(Teachers!$C$9:$H$9)","v":0},{"$f":"Teachers!$C$40","v":0}]
[null,null,"Diploma Educators",{"$f":"COUNTA('Diploma Educators'!$C$9:$H$9)","v":0},{"$f":"'Diploma Educators'!$C$43","v":0}]
[null,null,"Cert III Educators",{"$f":"COUNTA('Cert III Educators'!$C$9:$H$9)","v":0},{"$f":"'Cert III Educators'!$C$43","v":0}]
[null,null,"Activity Group Leaders",{"$f":"COUNTA('Activity Group Leaders'!$C$9:$H$9)","v":0},{"$f":"'Activity Group Leaders'!$C$42","v":0}]
[null,null,"Other Staff",{"$f":"COUNTA('Other Staff'!$C$9:$H$9)","v":0},{"$f":"'Other Staff'!$C$35","v":0}]
[]
[null,"Financials:","All Programs","4YO","3YO","All Other"]
[null,"Surplus / Deficit:",{"$f":"Budget!E$68","v":0},{"$f":"Budget!F$68","v":0},{"$f":"Budget!G$68","v":0},{"$f":"Budget!$H$68+Budget!$I$68+Budget!$J$68","v":0}]
[null,"Income:",{"$f":"Budget!E$29","v":0},{"$f":"Budget!F$29","v":0},{"$f":"Budget!G$29","v":0},{"$f":"Budget!$H$29+Budget!$I$29+Budget!$J$29","v":0}]
[null,"Expenses:",{"$f":"Budget!E$66","v":0},{"$f":"Budget!F$66","v":0},{"$f":"Budget!G$66","v":0},{"$f":"Budget!$H$66+Budget!$I$66+Budget!$J$66","v":0}]
[null,"Staff Costs:",{"$f":"Budget!E$32+Budget!E$33","v":0},{"$f":"Budget!F$32+Budget!F$33","v":0},{"$f":"Budget!G$32+Budget!G$33","v":0},{"$f":"SUM(Budget!$H$32:$J$33)","v":0}]
[null,"Other Costs:",{"$f":"Budget!E$66-Budget!E$33-Budget!E$32","v":0},{"$f":"Budget!F$66-Budget!F$33-Budget!F$32","v":0},{"$f":"Budget!G$66-Budget!G$33-Budget!G$32","v":0},{"$f":"Budget!$H$66+Budget!$I$66+Budget!$J$66-Budget!$H$32-Budget!$I$32-Budget!$J$32-Budget!$H$33-Budget!$I$33-Budget!$J$33","v":0}]

{"sheet":"AS Reference Sheet","index":1,"n_rows":28,"n_cols":5,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["Sheet","Reference","Type","Value"]
["Teachers","Row 16","Criteria Value",25.5,"Max Contact Hours for Teachers"]
["Teachers","Row 16","Output Value",38,"Max Hours per week"]
["Teachers","Row 16","Calculation Value",4]
["Teachers","Row 16","Calculation Value",60,"Hour value"]
["Teacher Index","Row 10","Calculation Value","765/38","Max Work Load Index for Teachers / Max Hours per Week"]
["Diploma Educators","Row 17","Criteria Value",30.4,"Max Contact Hours for Diploma Educators"]
["Diploma Educators","Row 17","Output Value",38,"Max Hours per week"]
["Diploma Educators","Row 17","Calculation Value",4]
["Diploma Educators","Row 17","Calculation Value",60,"Hour value"]
["Cert III Educators","Row 17","Criteria Value",30.4,"Max Contact Hours for Cert III Educators"]
["Cert III Educators","Row 17","Criteria Value",38,"Max Hours per week"]
["Cert III Educators","Row 17","Calculation Value",4]
["Cert III Educators","Row 17","Calculation Value",60,"Hour value"]
["Activity Group Leaders","Row 16","Criteria Value",25.5,"Max Contact Hours for Activity Group Leaders"]
["Activity Group Leaders","Row 16","Output Value",38,"Max Hours per week"]
["Activity Group Leaders","Row 16","Calculation Value",4]
["Activity Group Leaders","Row 16","Calculation Value",60,"Hour value"]
["Other Staff","Row 17","Criteria Value",25.5,"Max Contact Hours for Other Staff"]
["Other Staff","Row 17","Output Value",38,"Max Hours per week"]
["Other Staff","Row 17","Calculation Value",4]
["Other Staff","Row 17","Calculation Value",60,"Hour value"]
["Profile","Columns J/K/L/N/O","Calculation Value",4]
["Profile","Column Q","Criteria Value",15,"Department Funded Hours"]
["Profile","Column Q","Calculation Value",15,"Department Funded Hours"]
["Profile","Cell A51","Output String","CHECK: Total # of children by teacher category above is different from total children enrolled input in cells D10 to D20 above"]
["Profile","Cell E55","Criteria Value",15,"Department Funded Hours 4 YO"]
["Profile","Cell E56","Criteria Value",5,"Department Funded Hours 3 YO"]

{"sheet":"Teachers","index":2,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":false,"merged":[[31,3,31,4]]}
[]
[null,null,"Annual Salary Costs: TEACHERS",null,null,null,null,"2023-10-26"]
[]
[]
[null,"Member / Service Name:",{"$f":"'Main Dashboard'!$C$5","v":0},null,"Weeks in Period:",{"$f":"'Main Dashboard'!$F$5","v":0}]
[]
[null,"For Period / FY Beginning:",{"$f":"'Main Dashboard'!$C$7","v":"00:00:00"},null,"Term Weeks in Period:",{"$f":"'Main Dashboard'!$F$7","v":0}]
[]
[null,"Teacher (Name):"]
[null,"Hourly Rate"]
[null,"Increment Date"]
[null,"New Hourly Rate"]
[null,"Contact Hours"]
[null,"Four Year Old"]
[null,"Three Year Old"]
[null,"Other"]
[null,"Minimum Paid Hours",{"$f":"IF(SUM(C$14:C$16)>=25.5,38,ROUNDUP(4*(SUM(C$14:C$16))*(60+$C$32)/60,0)/4)","v":0},0,0,0,0,0]
[null,"Weekly Paid Hours"]
[null,"Additional Non-Teaching Time",{"$f":"C$18-C$17","v":0},0,0,0,0,0]
[null,"Salary"]
[null,"Weeks Before Increment",{"$f":"IF(C$11=\"\",0,ROUNDUP((C$11-$C$7)/7,0))","v":0},0,0,0,0,0]
[null,"Weekly Salary",{"$f":"ROUND(C$18*C$10,2)","v":0},0,0,0,0,0]
[null,"Weeks After Increment",{"$f":"IF(C$21=0,$F$5,$F$5-C$21)","v":0},0,0,0,0,0]
[null,"Weekly Salary",{"$f":"ROUND(C$18*C$12,2)","v":0},0,0,0,0,0]
[null,"Allowance"]
[null,"Protective Clothing Rate (Per Day)"]
[null,"Days Per Week Paid"]
[null,"Teacher In Charge Rate (Per Week)"]
[null,"Teacher In Charge Wage",{"$f":"C$28*$F$5","v":0},0,0,0,0,0]
[null,"Allowances Per Year",{"$f":"ROUNDUP(($C$26*C$27*$F$7)+C$29,0)","v":0},0,0,0,0,0]
[null,""]
[null,"Minimum Non Teaching Time:",30," minutes for each hour of teaching."]
[null,""]
[null,"Subtotals"]
[null,"Annual Salary",{"$f":"ROUNDUP(C$21*C$22+C$23*C$24+C$24*0.7,0)+C$30","v":0},0,0,0,0,0]
[null,"Four Year Old Component",{"$f":"IFERROR(IF((C$18=0),0,ROUND(C$35*C$14/(SUM(C$14:C$16)),0)),0)","v":0},0,0,0,0,0]
[null,"Three Year Old Component",{"$f":"IFERROR(IF((C$18=0),0,ROUND(C$35*C$15/(SUM(C$14:C$16)),0)),0)","v":0},0,0,0,0,0]
[null,"Other Component",{"$f":"C$35-C$36-C$37","v":0},0,0,0,0,0]
[null,""]
[null,"Total Teacher Salaries",{"$f":"SUM($C$35:$H$35)","v":0}]
[null,""]
[null,"4 YO Teacher Salaries",{"$f":"SUM($C36:$H36)","v":0}]
[null,"3 YO Teacher Salaries",{"$f":"SUM($C37:$H37)","v":0}]
[null,"Other Teacher Salaries",{"$f":"SUM($C38:$H38)","v":0}]

{"sheet":"Diploma Educators","index":3,"n_rows":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":false,"merged":[[34,3,34,5]]}
[]
[null,null,"Annual Salary Costs: Diploma Educator",null,null,null,null,"2023-10-26"]
[]
[]
[null,"Member / Service Name:",{"$f":"'Main Dashboard'!$C$5","v":0},null,"Weeks in Period:",{"$f":"'Main Dashboard'!$F$5","v":0}]
[]
[null,"For Period / FY Beginning:",{"$f":"'Main Dashboard'!$C$7","v":"00:00:00"},null,"Term Weeks in Period:",{"$f":"'Main Dashboard'!$F$7","v":0}]
[]
[null,"Diploma Educator (Name):"]
[null,"Hourly Rate"]
[null,"Increment Date"]
[null,"New Hourly Rate"]
[null,"Contact Hours"]
[null,"Four Year Old"]
[null,"Three Year Old"]
[null,"Other"]
[null,"Lunch Cover"]
[null,"Minimum Paid Hours",{"$f":"IF(SUM(C$14:C$16)>=30.4,38,ROUNDUP(4*(SUM(C$14:C$16))*(60+$C$35)/60,0)/4)+C17","v":0},0,0,0,0,0]
[null,"Weekly Paid Hours"]
[null,"Additional Non-Teaching Time",{"$f":"C$19-C$18","v":0},0,0,0,0,0]
[null,"Salary"]
[null,"Weeks Before Increment",{"$f":"IF(C$11=\"\",0,ROUNDUP((C$11-$C$7)/7,0))","v":0},0,0,0,0,0]
[null,"Weekly Salary",{"$f":"ROUND(C$19*C$10,2)","v":0},0,0,0,0,0]
[null,"Weeks After Increment",{"$f":"IF(C$22=0,$F$5,$F$5-C$22)","v":0},0,0,0,0,0]
[null,"Weekly Salary",{"$f":"ROUND(C$19*C$12,2)","v":0},0,0,0,0,0]
[null,"Allowance"]
[null,"Protective Clothing Rate (Per Day)"]
[null,"Days Per Week Paid"]
[null,"Firt Aid Rate (Per Day)"]
[null,"Days Per Week Paid"]
[null,"Toilet Cleaning Rate (Per Day)"]
[null,"Days Per Week Paid"]
[null,"Allowances Per Year",{"$f":"ROUNDUP((($C$27*C$28)+($C$29*C$30)+($C$31*C$32))*$F$7,0)","v":0},0,0,0,0,0]
[null,""]
[null,"Minimum Non Teaching Time:",15," minutes for each hour of teaching. (applies to all teachers / educators on this page)"]
[null,""]
[null,"Subtotals"]
[null,"Annual Salary",{"$f":"ROUNDUP(C$22*C$23+C$24*C$25+C$25*0.7,0)+C$33","v":0},0,0,0,0,0]
[null,"Four Year Old Component",{"$f":"IFERROR(IF((C$19=0),0,ROUND(C$38*C$14/(SUM(C$14:C$16)),0)),0)","v":0},0,0,0,0,0]
[null,"Three Year Old Component",{"$f":"IFERROR(IF((C$19=0),0,ROUND(C$38*C$15/(SUM(C$14:C$16)),0)),0)","v":0},0,0,0,0,0]
[null,"Other Component",{"$f":"C$38-C$39-C$40","v":0},0,0,0,0,0]
[null,""]
[null,"Total Diploma Educator Salaries",{"$f":"SUM($C$38:$H$38)","v":0}]
[null,""]
[null,"4 YO Diploma Educator Salaries",{"$f":"SUM($C39:$H39)","v":0}]
[null,"3 YO Diploma Educator Salaries",{"$f":"SUM($C40:$H40)","v":0}]
[null,"Other Diploma Educator Salaries",{"$f":"SUM($C41:$H41)","v":0}]

{"sheet":"Teacher Index","index":4,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Teacher Index",null,null,null,null,"2023-10-26"]
[]
[]
[null,"Member / Service Name:",{"$f":"'Main Dashboard'!$C$5","v":0},null,"Weeks in Period:",{"$f":"'Main Dashboard'!$F$5","v":0}]
[]
[null,"For Period / FY Beginning:",{"$f":"'Main Dashboard'!$C$7","v":"00:00:00"},null,"Term Weeks in Period:",{"$f":"'Main Dashboard'!$F$7","v":0}]
[]
[null,"Teachers",{"$f":"Teachers!C$9","v":0},{"$f":"Teachers!D$9","v":0},{"$f":"Teachers!E$9","v":0},{"$f":"Teachers!F$9","v":0},{"$f":"Teachers!G$9","v":0},{"$f":"Teachers!H$9","v":0}]
[null,"Total Weekly Hours",{"$f":"Teachers!C$18","v":0},{"$f":"Teachers!D$18","v":0},{"$f":"Teachers!E$18","v":0},{"$f":"Teachers!F$18","v":0},{"$f":"Teachers!G$18","v":0},{"$f":"Teachers!H$18","v":0}]
[null,"Maximum Workload Index",{"$f":"ROUNDUP(C$10*765/38,0)","v":0},0,0,0,0,0]
[null,""]
[null,"Hours, Session 1"]
[null,"Children, Session 1"]
[null,""]
[null,"Hours, Session 2"]
[null,"Children, Session 2"]
[null,""]
[null,"Hours, Session 3"]
[null,"Children, Session 3"]
[null,""]
[null,"Hours, Session 4"]
[null,"Children, Session 4"]
[null,""]
[null,"Hours, Session 5"]
[null,"Children, Session 5"]
[null,""]
[null,"Hours, Session 6"]
[null,"Children, Session 6"]
[null,""]
[null,"Hours, Session 7"]
[null,"Children, Session 7"]
[null,""]
[null,"Hours, Session 8"]
[null,"Children, Session 8"]
[null,"Teacher Index",{"$f":"C$13*C$14+C$16*C$17+C$19*C$20+C$22*C$23+C$25*C$26+C$28*C$29+C$31*C$32+C$34*C$35","v":0},0,0,0,0,0]
[null,null,{"$f":"IF((C$11-C$36)<0,\"Index is exceeded\",\" \")","v":" "}," "," "," "," "," "]

{"sheet":"Cert III Educators","index":5,"n_rows":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":false,"merged":[[34,3,34,5]]}
[]
[null,null,"Annual Salary Costs: Cert III Educator",null,null,null,null,"2023-10-26"]
[]
[]
[null,"Member / Service Name:",{"$f":"'Main Dashboard'!$C$5","v":0},null,"Weeks in Period:",{"$f":"'Main Dashboard'!$F$5","v":0}]
[]
[null,"For Period / FY Beginning:",{"$f":"'Main Dashboard'!$C$7","v":"00:00:00"},null,"Term Weeks in Period:",{"$f":"'Main Dashboard'!$F$7","v":0}]
[]
[null,"Cert III Educator (Name):"]
[null,"Hourly Rate"]
[null,"Increment Date"]
[null,"New Hourly Rate"]
[null,"Contact Hours"]
[null,"Four Year Old"]
[null,"Three Year Old"]
[null,"Other"]
[null,"Lunch Cover"]
[null,"Minimum Paid Hours",{"$f":"IF((SUM(C$14:C$16))>=30.4,38,ROUNDUP(4*(SUM(C$14:C$16))*(60+$C$35)/60,0)/4)+C$17","v":0},0,0,0,0,0]
[null,"Weekly Paid Hours"]
[null,"Additional Non-Teaching Time",{"$f":"C$19-C$18","v":0},0,0,0,0,0]
[null,"Salary"]
[null,"Weeks Before Increment",{"$f":"IF(C$11=\"\",0,ROUNDUP((C$11-$C$7)/7,0))","v":0},0,0,0,0,0]
[null,"Weekly Salary",{"$f":"ROUND(C$19*C$10,2)","v":0},0,0,0,0,0]
[null,"Weeks After Increment",{"$f":"IF(C$22=0,$F$5,$F$5-C$22)","v":0},0,0,0,0,0]
[null,"Weekly Salary",{"$f":"ROUND(C$19*C$12,2)","v":0},0,0,0,0,0]
[null,"Allowance"]
[null,"Protective Clothing Rate (Per Day)"]
[null,"Days Per Week Paid"]
[null,"Firt Aid Rate (Per Day)"]
[null,"Days Per Week Paid"]
[null,"Toilet Cleaning Rate (Per Day)"]
[null,"Days Per Week Paid"]
[null,"Allowances Per Year",{"$f":"ROUNDUP((($C$27*C$28)+($C$29*C$30)+($C$31*C$32))*$F$7,0)","v":0},0,0,0,0,0]
[null,""]
[null,"Minimum Non Teaching Time:",15," minutes for each hour of teaching. (applies to all teachers / educators on this page)"]
[null,""]
[null,"Subtotals"]
[null,"Annual Salary",{"$f":"ROUNDUP(C$22*C$23+C$24*C$25+C$25*0.7,0)+C$33","v":0},0,0,0,0,0]
[null,"Four Year Old Component",{"$f":"IFERROR(IF((C$19=0),0,ROUND(C$38*C$14/(SUM(C$14:C$16)),0)),0)","v":0},0,0,0,0,0]
[null,"Three Year Old Component",{"$f":"IFERROR(IF((C$19=0),0,ROUND(C$38*C$15/(SUM(C$14:C$16)),0)),0)","v":0},0,0,0,0,0]
[null,"Other Component",{"$f":"C$38-C$39-C$40","v":0},0,0,0,0,0]
[null,""]
[null,"Total Cert Iii Educator Salaries",{"$f":"SUM($C$38:$H$38)","v":0}]
[null,""]
[null,"4 YO Cert Iii Educator Salaries",{"$f":"SUM($C39:$H39)","v":0}]
[null,"3 YO Cert Iii Educator Salaries",{"$f":"SUM($C40:$H40)","v":0}]
[null,"Other Cert Iii Educator Salaries",{"$f":"SUM($C41:$H41)","v":0}]

{"sheet":"Activity Group Leaders","index":6,"n_rows":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":false,"merged":[[33,3,33,5]]}
[]
[null,null,"Annual Salary Costs: Activity Group Leaders",null,null,null,null,"2023-10-26"]
[]
[]
[null,"Member / Service Name:",{"$f":"'Main Dashboard'!$C$5","v":0},null,"Weeks in Period:",{"$f":"'Main Dashboard'!$F$5","v":0}]
[]
[null,"For Period / FY Beginning:",{"$f":"'Main Dashboard'!$C$7","v":"00:00:00"},null,"Term Weeks in Period:",{"$f":"'Main Dashboard'!$F$7","v":0}]
[]
[null,"Act. Grp. Leaders (Name):"]
[null,"Hourly Rate"]
[null,"Increment Date"]
[null,"New Hourly Rate"]
[null,"Contact Hours"]
[null,"Four Year Old"]
[null,"Three Year Old"]
[null,"Other"]
[null,"Minimum Paid Hours",{"$f":"IF((SUM(C$14:C$16))>=25.5,38,ROUNDUP(4*(SUM(C$14:C$16))*(60+$C$34)/60,0)/4)","v":0},0,0,0,0,0]
[null,"Weekly Paid Hours"]
[null,"Additional Non-Teaching Time",{"$f":"C$18-C$17","v":0},0,0,0,0,0]
[null,"Salary"]
[null,"Weeks Before Increment",{"$f":"IF(C$11=\"\",0,ROUNDUP((C$11-$C$7)/7,0))","v":0},0,0,0,0,0]
[null,"Weekly Salary",{"$f":"ROUND(C$18*C$10,2)","v":0},0,0,0,0,0]
[null,"Weeks After Increment",{"$f":"IF(C$21=0,$F$5,$F$5-C$21)","v":0},0,0,0,0,0]
[null,"Weekly Salary",{"$f":"ROUND(C$18*C$12,2)","v":0},0,0,0,0,0]
[null,"Allowance"]
[null,"Protective Clothing Rate (Per Day)"]
[null,"Days Per Week Paid"]
[null,"Firt Aid Rate (Per Day)"]
[null,"Days Per Week Paid"]
[null,"Toilet Cleaning Rate (Per Day)"]
[null,"Days Per Week Paid"]
[null,"Allowances Per Year",{"$f":"ROUNDUP((($C$26*C$27)+($C$28*C$29)+($C$30*C$31))*$F$7,0)","v":0},0,0,0,0,0]
[]
[null,"Minimum Non Teaching Time:",20," minutes for each hour of teaching. (applies to all teachers / educators on this page)"]
[]
[null,"Subtotals"]
[null,"Annual Salary",{"$f":"ROUNDUP(C$21*C$22+C$23*C$24+C$24*0.7,0)+C$32","v":0},0,0,0,0,0]
[null,"Four Year Old Component",{"$f":"IFERROR(IF((C$18=0),0,ROUND(C$37*C$14/(SUM(C$14:C$16)),0)),0)","v":0},0,0,0,0,0]
[null,"Three Year Old Component",{"$f":"IFERROR(IF((C$18=0),0,ROUND(C$37*C$15/(SUM(C$14:C$16)),0)),0)","v":0},0,0,0,0,0]
[null,"Other Component",{"$f":"C$37-C$38-C$39","v":0},0,0,0,0,0]
[]
[null,"Total Act. Grp. Leaders Salaries",{"$f":"SUM($C$37:$H$37)","v":0}]
[]
[null,"4 YO Act. Grp. Leaders Salaries",{"$f":"SUM($C38:$H38)","v":0}]
[null,"3 YO Act. Grp. Leaders Salaries",{"$f":"SUM($C39:$H39)","v":0}]
[null,"Other Act. Grp. Leaders Salaries",{"$f":"SUM($C40:$H40)","v":0}]

{"sheet":"Other Staff","index":7,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[[26,3,26,5]]}
[]
[null,null,"Annual Salary Costs: Other Staff",null,null,null,null,"2023-10-26"]
[]
[]
[null,"Member / Service Name:",{"$f":"'Main Dashboard'!$C$5","v":0},null,"Weeks in Period:",{"$f":"'Main Dashboard'!$F$5","v":0}]
[]
[null,"For Period / FY Beginning:",{"$f":"'Main Dashboard'!$C$7","v":"00:00:00"},null,"Term Weeks in Period:",{"$f":"'Main Dashboard'!$F$7","v":0}]
[]
[null,"Other Staff (Name):"]
[null,"Role Description:"]
[null,"Hourly Rate"]
[null,"Increment Date"]
[null,"New Hourly Rate"]
[null,"Support Allocation (Hours)"]
[null,"Four Year Old"]
[null,"Three Year Old"]
[null,"Other"]
[null,"Minimum Paid Hours",{"$f":"IF((SUM(C$15:C$17))>=25.5,38,ROUNDUP(4*(SUM(C$15:C$17))*(60+$C$27)/60,0)/4)","v":0},0,0,0,0,0]
[null,"Weekly Paid Hours"]
[null,"Additional Non-Teaching Time",{"$f":"C$19-C$18","v":0},0,0,0,0,0]
[null,"Salary"]
[null,"Weeks Before Increment",{"$f":"IF(C$12=\"\",0,ROUNDUP((C$12-$C$7)/7,0))","v":0},0,0,0,0,0]
[null,"Weekly Salary",{"$f":"ROUND(C$19*C$11,2)","v":0},0,0,0,0,0]
[null,"Weeks After Increment",{"$f":"IF(C$22=0,$F$5,$F$5-C$22)","v":0},0,0,0,0,0]
[null,"Weekly Salary",{"$f":"ROUND(C$19*C$13,2)","v":0},0,0,0,0,0]
[null,""]
[null,"Minimum Non Teaching Time:",30," minutes for each hour of teaching. (applies to all teachers / educators on this page)"]
[null,""]
[null,"Subtotals"]
[null,"Annual Salary",{"$f":"ROUNDUP(C$22*C$23+C$24*C$25+C$25*0.7,0)","v":0},0,0,0,0,0]
[null,"Four Year Old Component",{"$f":"IFERROR(IF((C$19=0),0,ROUND(C$30*C$15/(SUM(C$15:C$17)),0)),0)","v":0},0,0,0,0,0]
[null,"Three Year Old Component",{"$f":"IFERROR(IF((C$19=0),0,ROUND(C$30*C$16/(SUM(C$15:C$17)),0)),0)","v":0},0,0,0,0,0]
[null,"Other Component",{"$f":"C$30-C$31-C$32","v":0},0,0,0,0,0]
[null,""]
[null,"Total Other Staff Salaries",{"$f":"SUM($C$30:$H$30)","v":0}]
[null,""]
[null,"4 YO Other Staff Salaries",{"$f":"SUM($C31:$H31)","v":0}]
[null,"3 YO Other Staff Salaries",{"$f":"SUM($C32:$H32)","v":0}]
[null,"Other Other Staff Salaries",{"$f":"SUM($C33:$H33)","v":0}]
[null,""]

{"sheet":"Holiday Programs","index":8,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[23,1,23,2],[26,1,26,2],[29,1,29,2],[30,1,30,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[39,1,39,2],[40,1,40,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[38,1,38,2]]}
[]
[null,null,"Holiday Programs",null,null,null,null,null,"2023-10-26"]
[]
[]
[null,"Member / Service Name:",{"$f":"'Main Dashboard'!$C$5","v":0},null,"Weeks in Period:",{"$f":"'Main Dashboard'!$F$5","v":0}]
[]
[null,"For Period / FY Beginning:",{"$f":"'Main Dashboard'!$C$7","v":"00:00:00"},null,"Term Weeks in Period:",{"$f":"'Main Dashboard'!$F$7","v":0}]
[]
[]
[null,"PROFILE","Weekly Hours","Number of Children","Weeks of Operation","Hourly Rate","Gross Income"]
[null,"Program 1 ",null,null,null,null,{"$f":"ROUND($F11*$E11*$D11*$C11,0)","v":0}]
[null,"Program 2 ",null,null,null,null,{"$f":"ROUND($F12*$E12*$D12*$C12,0)","v":0}]
[null,"Program 3 ",null,null,null,null,{"$f":"ROUND($F13*$E13*$D13*$C13,0)","v":0}]
[null,"Program 4",null,null,null,null,{"$f":"ROUND($F14*$E14*$D14*$C14,0)","v":0}]
[null,null,null,null,null,"Total income   ",{"$f":"SUM($G$11:$G$14)","v":0}]
[]
[null,"STAFFING"]
[null,"Name"]
[null,"Hourly Rate"]
[null,"Contact Hours"]
[null,"Non Contact Hours"]
[null,"Weeks of Attendance"]
[]
[null,"Salary",null,{"$f":"ROUND(D$19*(D$20+D$21)*D$22,0)","v":0},{"$f":"ROUND(E$19*(E$20+E$21)*E$22,0)","v":0},{"$f":"ROUND(F$19*(F$20+F$21)*F$22,0)","v":0},{"$f":"ROUND(G$19*(G$20+G$21)*G$22,0)","v":0},{"$f":"ROUND(H$19*(H$20+H$21)*H$22,0)","v":0},"Super."]
[null,"Superannuation",null,{"$f":"D$24*$I$25","v":0},{"$f":"E$24*$I$25","v":0},{"$f":"F$24*$I$25","v":0},{"$f":"G$24*$I$25","v":0},{"$f":"H$24*$I$25","v":0},0.1]
[]
[null,"Total Salary Cost",null,{"$f":"ROUND(SUM($D$24:$H$25),0)","v":0}]
[]
[null,"OTHER EXPENDITURE"]
[null,"Additional Consumables"]
[null,"Excursion Costs"]
[null,"Food"]
[null,"Other"]
[null,"Other"]
[null,"Other"]
[null,"Total",null,{"$f":"SUM($D$30:$D$35)","v":0}]
[]
[]
[null,"Total Income",null,{"$f":"$G$15","v":0}]
[null,"Total Expenses",null,{"$f":"$D$27+$D$36","v":0}]
[null,"Surplus",null,{"$f":"$D$39-$D$40","v":0}]

{"sheet":"Day Care Programs","index":9,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[23,1,23,2],[26,1,26,2],[29,1,29,2],[30,1,30,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[39,1,39,2],[40,1,40,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[38,1,38,2]]}
[]
[null,null,"Day Care Programs",null,null,null,null,null,"2023-10-26"]
[]
[]
[null,"Member / Service Name:",{"$f":"'Main Dashboard'!$C$5","v":0},null,"Weeks in Period:",{"$f":"'Main Dashboard'!$F$5","v":0}]
[]
[null,"For Period / FY Beginning:",{"$f":"'Main Dashboard'!$C$7","v":"00:00:00"},null,"Term Weeks in Period:",{"$f":"'Main Dashboard'!$F$7","v":0}]
[]
[]
[null,"PROFILE","Weekly Hours","Number of Children","Weeks of Operation","Hourly Rate","Gross Income"]
[null,"Program 1 ",null,null,null,null,{"$f":"ROUND($F11*$E11*$D11*$C11,0)","v":0}]
[null,"Program 2 ",null,null,null,null,{"$f":"ROUND($F12*$E12*$D12*$C12,0)","v":0}]
[null,"Program 3 ",null,null,null,null,{"$f":"ROUND($F13*$E13*$D13*$C13,0)","v":0}]
[null,"Program 4",null,null,null,null,{"$f":"ROUND($F14*$E14*$D14*$C14,0)","v":0}]
[null,null,null,null,null,"Total income   ",{"$f":"SUM($G$11:$G$14)","v":0}]
[]
[null,"STAFFING"]
[null,"Name"]
[null,"Hourly Rate"]
[null,"Contact Hours"]
[null,"Non Contact Hours"]
[null,"Weeks of Attendance"]
[]
[null,"Salary",null,{"$f":"ROUND(D$19*(D$20+D$21)*D$22,0)","v":0},{"$f":"ROUND(E$19*(E$20+E$21)*E$22,0)","v":0},{"$f":"ROUND(F$19*(F$20+F$21)*F$22,0)","v":0},{"$f":"ROUND(G$19*(G$20+G$21)*G$22,0)","v":0},{"$f":"ROUND(H$19*(H$20+H$21)*H$22,0)","v":0},"Super."]
[null,"Superannuation",null,{"$f":"D$24*$I$25","v":0},{"$f":"E$24*$I$25","v":0},{"$f":"F$24*$I$25","v":0},{"$f":"G$24*$I$25","v":0},{"$f":"H$24*$I$25","v":0},0.1]
[]
[null,"Total Salary Cost",null,{"$f":"ROUND(SUM($D$24:$H$25),0)","v":0}]
[]
[null,"OTHER EXPENDITURE"]
[null,"Additional Consumables"]
[null,"Excursion Costs"]
[null,"Food"]
[null,"Other"]
[null,"Other"]
[null,"Other"]
[null,"Total",null,{"$f":"SUM($D$30:$D$35)","v":0}]
[]
[]
[null,"Total Income",null,{"$f":"$G$15","v":0}]
[null,"Total Expenses",null,{"$f":"$D$27+$D$36","v":0}]
[null,"Surplus",null,{"$f":"$D$39-$D$40","v":0}]

{"sheet":"Budget","index":10,"n_rows":74,"n_cols":11,"rows_kept":74,"cut":false,"hidden":false,"merged":[[67,1,67,3],[12,1,12,2],[14,1,14,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[37,1,37,2],[38,1,38,2],[63,1,63,2],[24,1,24,2],[62,1,62,2],[61,1,61,2],[50,1,50,2],[64,1,64,2],[23,1,23,2],[26,1,26,2],[27,1,27,2],[56,1,56,2],[57,1,57,2],[58,1,58,2],[59,1,59,2],[60,1,60,2],[51,1,51,2],[52,1,52,2],[53,1,53,2],[54,1,54,2],[55,1,55,2],[46,1,46,2],[25,1,25,2],[1,2,1,7],[13,1,13,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[36,1,36,2],[39,1,39,2],[40,1,40,2],[15,1,15,2],[16,1,16,2]]}
[]
[null,null,{"$f":"\"FINANCIAL BUDGET (\"&Profile!$J$3&\", \"&Profile!$I$7&\")\"","v":"FINANCIAL BUDGET (Standard, Table 1 - Services operating under the Early Childhood Enterprise Agreements and do not opt in to Free Kinder)"},null,null,null,null,null,null,null,"2023-10-26"]
[]
[]
[null,null,"Member / Service Name:",{"$f":"'Main Dashboard'!$C$5","v":0},null,null,"Weeks in Period:",{"$f":"'Main Dashboard'!$F$5","v":0}]
[]
[null,null,"For Period / FY Beginning:",{"$f":"'Main Dashboard'!$C$7","v":"00:00:00"},null,null,"Term Weeks in Period:",{"$f":"'Main Dashboard'!$F$7","v":0}]
[]
[]
[null,"Budget"]
[]
[null,"Income",null,"Apportion?","Total","4 YO","3 YO","Other","Day Care","Holiday","% of Total Inc."]
[null,"DE Per Capita (Including Ratio Supplement Where Applicable)",null,null,{"$f":"SUM($F13:$J13)","v":0},{"$f":"Profile!$F$16*IF(Profile!$J$3=\"Standard\",Profile!$J$42,Profile!$J$43)+Profile!$U$16","v":0},{"$f":"Profile!$I$23+Profile!$U$23+Profile!$V$23","v":0},null,null,null,{"$f":"IFERROR($E13/$E$29,0)","v":0}]
[null,"Free Kinder Funding",null,null,0,{"$f":"Profile!$J$16","v":0},{"$f":"Profile!$J$23","v":0},null,null,null,{"$f":"IFERROR($E14/$E$29,0)","v":0}]
[null,"DE Teacher Supplement",null,null,0,{"$f":"Profile!$G$16","v":0},{"$f":"Profile!$G$23","v":0},null,null,null,0]
[null,"Other Govt Funding",null,null,0,null,null,null,null,null,0]
[null,"Kindergarten Fees Subsidy",null,null,0,{"$f":"SUM(Profile!$V$16:$W$16)","v":0},{"$f":"SUM(Profile!$V$23:$W$23)","v":0},null,null,null,0]
[null,"KFS Add on Fee",null,null,0,{"$f":"SUM(Profile!$T$11:$T$15)","v":0},{"$f":"SUM(Profile!$T$19:$T$22)","v":0},null,null,null,0]
[null,"Fees Income",null,null,0,{"$f":"SUM(Profile!$S$11:$S$15)","v":0},{"$f":"SUM(Profile!$S$19:$S$22)","v":0},{"$f":"SUM(Profile!$S$26:$S$29)","v":0},{"$f":"'Day Care Programs'!$D$39","v":0},{"$f":"'Holiday Programs'!$D$39","v":0},0]
[null,"Fundraising",null,"No",null,{"$f":"IF($D20=\"Yes\",$E20*Profile!$H$16/Profile!$H$32,0)","v":0},{"$f":"IF($D20=\"Yes\",$E20*Profile!$H$23/Profile!$H$32,$F20)","v":0},{"$f":"IF($D20=\"Yes\",$E20*Profile!$H$30/Profile!$H$32,$G20)","v":0},null,null,0]
[null,"Donations",null,"Yes",null,{"$f":"IFERROR(IF($D21=\"Yes\",$E21*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D21=\"Yes\",$E21*Profile!$H$23/Profile!$H$32,$F21),0)","v":0},{"$f":"IFERROR(IF($D21=\"Yes\",$E21*Profile!$H$30/Profile!$H$32,$G21),0)","v":0},null,null,0]
[null,"Membership Fees",null,"Yes",null,{"$f":"IFERROR(IF($D22=\"Yes\",$E22*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D22=\"Yes\",$E22*Profile!$H$23/Profile!$H$32,$F22),0)","v":0},{"$f":"IFERROR(IF($D22=\"Yes\",$E22*Profile!$H$30/Profile!$H$32,$G22),0)","v":0},null,null,0]
[null,"Bank Interest",null,"No",null,{"$f":"IF($D23=\"Yes\",$E23*Profile!$H$16/Profile!$H$32,0)","v":0},{"$f":"IF($D23=\"Yes\",$E23*Profile!$H$23/Profile!$H$32,$F23)","v":0},{"$f":"IF($D23=\"Yes\",$E23*Profile!$H$30/Profile!$H$32,$G23)","v":0},null,null,0]
[null,"Other",null,"Yes",null,{"$f":"IFERROR(IF($D24=\"Yes\",$E24*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D24=\"Yes\",$E24*Profile!$H$23/Profile!$H$32,$F24),0)","v":0},{"$f":"IFERROR(IF($D24=\"Yes\",$E24*Profile!$H$30/Profile!$H$32,$G24),0)","v":0},null,null,0]
[null,"Other  ",null,"Yes",null,{"$f":"IFERROR(IF($D25=\"Yes\",$E25*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D25=\"Yes\",$E25*Profile!$H$23/Profile!$H$32,$F25),0)","v":0},{"$f":"IFERROR(IF($D25=\"Yes\",$E25*Profile!$H$30/Profile!$H$32,$G25),0)","v":0},null,null,0]
[null,"Other  ",null,"Yes",null,{"$f":"IFERROR(IF($D26=\"Yes\",$E26*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D26=\"Yes\",$E26*Profile!$H$23/Profile!$H$32,$F26),0)","v":0},{"$f":"IFERROR(IF($D26=\"Yes\",$E26*Profile!$H$30/Profile!$H$32,$G26),0)","v":0},null,null,0]
[null,"Other",null,"Yes",null,{"$f":"IFERROR(IF($D27=\"Yes\",$E27*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D27=\"Yes\",$E27*Profile!$H$23/Profile!$H$32,$F27),0)","v":0},{"$f":"IFERROR(IF($D27=\"Yes\",$E27*Profile!$H$30/Profile!$H$32,$G27),0)","v":0},null,null,0]
[null,"Other",null,"Yes",null,{"$f":"IFERROR(IF($D28=\"Yes\",$E28*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D28=\"Yes\",$E28*Profile!$H$23/Profile!$H$32,$F28),0)","v":0},{"$f":"IFERROR(IF($D28=\"Yes\",$E28*Profile!$H$30/Profile!$H$32,$G28),0)","v":0},null,null,0]
[null,"Total Income",null,null,{"$f":"IFERROR(SUM(E$13:E$28),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(SUM($K$13:$K$28),0)","v":0}]
[""]
[null,"Expenditure",null,null,"Total","4 yo","3 yo","Other","Day Care","Holiday","% of Total Exp."]
[null,"Salaries ",null,null,{"$f":"SUM($F32:$J32)","v":0},{"$f":"Teachers!$C$42+'Diploma Educators'!$C$45+'Cert III Educators'!$C$45+'Activity Group Leaders'!$C$44+'Other Staff'!$C$37","v":0},{"$f":"Teachers!$C$43+'Diploma Educators'!$C$46+'Cert III Educators'!$C$46+'Activity Group Leaders'!$C$45+'Other Staff'!$C$38","v":0},{"$f":"Teachers!$C$44+'Diploma Educators'!$C$47+'Cert III Educators'!$C$47+'Activity Group Leaders'!$C$46+'Other Staff'!$C$39","v":0},{"$f":"'Day Care Programs'!$D$27","v":0},{"$f":"'Holiday Programs'!$D$27","v":0},{"$f":"IFERROR($E32/$E$66,0)","v":0}]
[null,"On Costs",null,null,{"$f":"SUM($F33:$J33)","v":0},{"$f":"ROUND(F$32*Profile!$C$43,0)","v":0},{"$f":"ROUND(G$32*Profile!$C$43,0)","v":0},{"$f":"ROUND(H$32*Profile!$C$43,0)","v":0},{"$f":"ROUND(I$32*Profile!$C$43,0)","v":0},{"$f":"ROUND(J$32*Profile!$C$43,0)","v":0},{"$f":"IFERROR($E33/$E$66,0)","v":0}]
[null,"Advertising",null,"Yes",null,{"$f":"IFERROR(IF($D34=\"Yes\",$E34*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D34=\"Yes\",$E34*Profile!$H$23/Profile!$H$32,$F34),0)","v":0},{"$f":"IFERROR(IF($D34=\"Yes\",$E34*Profile!$H$30/Profile!$H$32,$G34),0)","v":0},null,null,0]
[null,"Audit Fees",null,"Yes",null,{"$f":"IFERROR(IF($D35=\"Yes\",$E35*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D35=\"Yes\",$E35*Profile!$H$23/Profile!$H$32,$F35),0)","v":0},{"$f":"IFERROR(IF($D35=\"Yes\",$E35*Profile!$H$30/Profile!$H$32,$G35),0)","v":0},null,null,0]
[null,"Bad Debt Allowance",null,null,{"$f":"SUM($F36:$J36)","v":0},{"$f":"(F$18+F$19)*Profile!$C$45","v":0},{"$f":"(G$18+G$19)*Profile!$C$45","v":0},{"$f":"(H$18+H$19)*Profile!$C$45","v":0},{"$f":"(I$18+I$19)*Profile!$C$45","v":0},{"$f":"(J$18+J$19)*Profile!$C$45","v":0},0]
[null,"Bank Fees & Charges",null,"Yes",null,{"$f":"IFERROR(IF($D37=\"Yes\",$E37*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D37=\"Yes\",$E37*Profile!$H$23/Profile!$H$32,$F37),0)","v":0},{"$f":"IFERROR(IF($D37=\"Yes\",$E37*Profile!$H$30/Profile!$H$32,$G37),0)","v":0},null,null,0]
[null,"Cleaning Costs",null,"Yes",null,{"$f":"IFERROR(IF($D38=\"Yes\",$E38*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D38=\"Yes\",$E38*Profile!$H$23/Profile!$H$32,$F38),0)","v":0},{"$f":"IFERROR(IF($D38=\"Yes\",$E38*Profile!$H$30/Profile!$H$32,$G38),0)","v":0},null,null,0]
[null,"Consumables",null,"Yes",null,{"$f":"IFERROR(IF($D39=\"Yes\",$E39*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D39=\"Yes\",$E39*Profile!$H$23/Profile!$H$32,$F39),0)","v":0},{"$f":"IFERROR(IF($D39=\"Yes\",$E39*Profile!$H$30/Profile!$H$32,$G39),0)","v":0},null,null,0]
[null,"Electricity",null,"Yes",null,{"$f":"IFERROR(IF($D40=\"Yes\",$E40*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D40=\"Yes\",$E40*Profile!$H$23/Profile!$H$32,$F40),0)","v":0},{"$f":"IFERROR(IF($D40=\"Yes\",$E40*Profile!$H$30/Profile!$H$32,$G40),0)","v":0},null,null,0]
[null,"Equipment Purchases",null,"Yes",null,{"$f":"IFERROR(IF($D41=\"Yes\",$E41*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D41=\"Yes\",$E41*Profile!$H$23/Profile!$H$32,$F41),0)","v":0},{"$f":"IFERROR(IF($D41=\"Yes\",$E41*Profile!$H$30/Profile!$H$32,$G41),0)","v":0},null,null,0]
[null,"Equipment Repairs",null,"Yes",null,{"$f":"IFERROR(IF($D42=\"Yes\",$E42*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D42=\"Yes\",$E42*Profile!$H$23/Profile!$H$32,$F42),0)","v":0},{"$f":"IFERROR(IF($D42=\"Yes\",$E42*Profile!$H$30/Profile!$H$32,$G42),0)","v":0},null,null,0]
[null,"Excursions/Entertainment",null,"Yes",null,{"$f":"IFERROR(IF($D43=\"Yes\",$E43*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D43=\"Yes\",$E43*Profile!$H$23/Profile!$H$32,$F43),0)","v":0},{"$f":"IFERROR(IF($D43=\"Yes\",$E43*Profile!$H$30/Profile!$H$32,$G43),0)","v":0},null,null,0]
[null,"External Consultants",null,"Yes",null,{"$f":"IFERROR(IF($D44=\"Yes\",$E44*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D44=\"Yes\",$E44*Profile!$H$23/Profile!$H$32,$F44),0)","v":0},{"$f":"IFERROR(IF($D44=\"Yes\",$E44*Profile!$H$30/Profile!$H$32,$G44),0)","v":0},null,null,0]
[null,"First Aid Training",null,"Yes",null,{"$f":"IFERROR(IF($D45=\"Yes\",$E45*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D45=\"Yes\",$E45*Profile!$H$23/Profile!$H$32,$F45),0)","v":0},{"$f":"IFERROR(IF($D45=\"Yes\",$E45*Profile!$H$30/Profile!$H$32,$G45),0)","v":0},null,null,0]
[null,"Gas",null,"Yes",null,{"$f":"IFERROR(IF($D46=\"Yes\",$E46*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D46=\"Yes\",$E46*Profile!$H$23/Profile!$H$32,$F46),0)","v":0},{"$f":"IFERROR(IF($D46=\"Yes\",$E46*Profile!$H$30/Profile!$H$32,$G46),0)","v":0},null,null,0]
[null,"Incidental/Petty Cash",null,"Yes",null,{"$f":"IFERROR(IF($D47=\"Yes\",$E47*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D47=\"Yes\",$E47*Profile!$H$23/Profile!$H$32,$F47),0)","v":0},{"$f":"IFERROR(IF($D47=\"Yes\",$E47*Profile!$H$30/Profile!$H$32,$G47),0)","v":0},null,null,0]
[null,"Insurance (Not Workcover)",null,"Yes",null,{"$f":"IFERROR(IF($D48=\"Yes\",$E48*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D48=\"Yes\",$E48*Profile!$H$23/Profile!$H$32,$F48),0)","v":0},{"$f":"IFERROR(IF($D48=\"Yes\",$E48*Profile!$H$30/Profile!$H$32,$G48),0)","v":0},null,null,0]
[null,"Service Approval & Incorp. Fees",null,"Yes",null,{"$f":"IFERROR(IF($D49=\"Yes\",$E49*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D49=\"Yes\",$E49*Profile!$H$23/Profile!$H$32,$F49),0)","v":0},{"$f":"IFERROR(IF($D49=\"Yes\",$E49*Profile!$H$30/Profile!$H$32,$G49),0)","v":0},null,null,0]
[null,"Maintenance Bldg & Grnds",null,"Yes",null,{"$f":"IFERROR(IF($D50=\"Yes\",$E50*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D50=\"Yes\",$E50*Profile!$H$23/Profile!$H$32,$F50),0)","v":0},{"$f":"IFERROR(IF($D50=\"Yes\",$E50*Profile!$H$30/Profile!$H$32,$G50),0)","v":0},null,null,0]
[null,"Photocopying",null,"Yes",null,{"$f":"IFERROR(IF($D51=\"Yes\",$E51*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D51=\"Yes\",$E51*Profile!$H$23/Profile!$H$32,$F51),0)","v":0},{"$f":"IFERROR(IF($D51=\"Yes\",$E51*Profile!$H$30/Profile!$H$32,$G51),0)","v":0},null,null,0]
[null,"Police Checks",null,"Yes",null,{"$f":"IFERROR(IF($D52=\"Yes\",$E52*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D52=\"Yes\",$E52*Profile!$H$23/Profile!$H$32,$F52),0)","v":0},{"$f":"IFERROR(IF($D52=\"Yes\",$E52*Profile!$H$30/Profile!$H$32,$G52),0)","v":0},null,null,0]
[null,"Postage",null,"Yes",null,{"$f":"IFERROR(IF($D53=\"Yes\",$E53*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D53=\"Yes\",$E53*Profile!$H$23/Profile!$H$32,$F53),0)","v":0},{"$f":"IFERROR(IF($D53=\"Yes\",$E53*Profile!$H$30/Profile!$H$32,$G53),0)","v":0},null,null,0]
[null,"Rates",null,"Yes",null,{"$f":"IFERROR(IF($D54=\"Yes\",$E54*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D54=\"Yes\",$E54*Profile!$H$23/Profile!$H$32,$F54),0)","v":0},{"$f":"IFERROR(IF($D54=\"Yes\",$E54*Profile!$H$30/Profile!$H$32,$G54),0)","v":0},null,null,0]
[null,"Rent",null,"Yes",null,{"$f":"IFERROR(IF($D55=\"Yes\",$E55*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D55=\"Yes\",$E55*Profile!$H$23/Profile!$H$32,$F55),0)","v":0},{"$f":"IFERROR(IF($D55=\"Yes\",$E55*Profile!$H$30/Profile!$H$32,$G55),0)","v":0},null,null,0]
[null,"Staff & Ctte Training",null,"Yes",null,{"$f":"IFERROR(IF($D56=\"Yes\",$E56*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D56=\"Yes\",$E56*Profile!$H$23/Profile!$H$32,$F56),0)","v":0},{"$f":"IFERROR(IF($D56=\"Yes\",$E56*Profile!$H$30/Profile!$H$32,$G56),0)","v":0},null,null,0]
[null,"Staff Travel",null,"Yes",null,{"$f":"IFERROR(IF($D57=\"Yes\",$E57*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D57=\"Yes\",$E57*Profile!$H$23/Profile!$H$32,$F57),0)","v":0},{"$f":"IFERROR(IF($D57=\"Yes\",$E57*Profile!$H$30/Profile!$H$32,$G57),0)","v":0},null,null,0]
[null,"Stationary",null,"Yes",null,{"$f":"IFERROR(IF($D58=\"Yes\",$E58*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D58=\"Yes\",$E58*Profile!$H$23/Profile!$H$32,$F58),0)","v":0},{"$f":"IFERROR(IF($D58=\"Yes\",$E58*Profile!$H$30/Profile!$H$32,$G58),0)","v":0},null,null,0]
[null,"Subscriptions (e.g. ELAA)",null,"Yes",null,{"$f":"IFERROR(IF($D59=\"Yes\",$E59*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D59=\"Yes\",$E59*Profile!$H$23/Profile!$H$32,$F59),0)","v":0},{"$f":"IFERROR(IF($D59=\"Yes\",$E59*Profile!$H$30/Profile!$H$32,$G59),0)","v":0},null,null,0]
[null,"Telephone",null,"Yes",null,{"$f":"IFERROR(IF($D60=\"Yes\",$E60*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D60=\"Yes\",$E60*Profile!$H$23/Profile!$H$32,$F60),0)","v":0},{"$f":"IFERROR(IF($D60=\"Yes\",$E60*Profile!$H$30/Profile!$H$32,$G60),0)","v":0},null,null,0]
[null,"Other  ",null,"Yes",null,{"$f":"IFERROR(IF($D61=\"Yes\",$E61*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D61=\"Yes\",$E61*Profile!$H$23/Profile!$H$32,$F61),0)","v":0},{"$f":"IFERROR(IF($D61=\"Yes\",$E61*Profile!$H$30/Profile!$H$32,$G61),0)","v":0},null,null,0]
[null,"Other",null,"Yes",null,{"$f":"IFERROR(IF($D62=\"Yes\",$E62*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D62=\"Yes\",$E62*Profile!$H$23/Profile!$H$32,$F62),0)","v":0},{"$f":"IFERROR(IF($D62=\"Yes\",$E62*Profile!$H$30/Profile!$H$32,$G62),0)","v":0},null,null,0]
[null,"Other",null,"Yes",null,{"$f":"IFERROR(IF($D63=\"Yes\",$E63*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D63=\"Yes\",$E63*Profile!$H$23/Profile!$H$32,$F63),0)","v":0},{"$f":"IFERROR(IF($D63=\"Yes\",$E63*Profile!$H$30/Profile!$H$32,$G63),0)","v":0},null,null,0]
[null,"Other",null,"Yes",null,{"$f":"IFERROR(IF($D64=\"Yes\",$E64*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D64=\"Yes\",$E64*Profile!$H$23/Profile!$H$32,$F64),0)","v":0},{"$f":"IFERROR(IF($D64=\"Yes\",$E64*Profile!$H$30/Profile!$H$32,$G64),0)","v":0},null,null,0]
[null,"Other",null,"Yes",null,{"$f":"IFERROR(IF($D65=\"Yes\",$E65*Profile!$H$16/Profile!$H$32,0),0)","v":0},{"$f":"IFERROR(IF($D65=\"Yes\",$E65*Profile!$H$23/Profile!$H$32,$F65),0)","v":0},{"$f":"IFERROR(IF($D65=\"Yes\",$E65*Profile!$H$30/Profile!$H$32,$G65),0)","v":0},null,null,0]
[null,"Total Expenditure",null,null,{"$f":"SUM(E$32:E$65)","v":0},{"$f":"IFERROR(SUM(F$32:F$65),0)","v":0},0,0,0,0,0]
[]
[null,"BUDGET SURPLUS / DEFECIT",null,null,{"$f":"E$29-E$66","v":0},0,0,0,0,0]
[]
[null,"Performance Summary Ratios:","All Programs",null,{"$f":"IFERROR($E$66/$E$29,0)","v":0}]
[null,"Costs to Income","4 YO Programs",null,{"$f":"IFERROR($F$66/$F$29,0)","v":0}]
[null,null,"3 YO Programs",null,{"$f":"IFERROR($G$66/$G$29,0)","v":0}]
[null,null,"Staff Expense to Income:",null,{"$f":"IFERROR(($E$32+$E$33)/$E$29,0)","v":0}]
[null,null,"DET Supp. to Tot. Income:",null,{"$f":"IFERROR(($E$13+$E$15)/$E$29,0)","v":0}]

{"sheet":"Profile","index":11,"n_rows":47,"n_cols":25,"rows_kept":47,"cut":false,"hidden":false,"merged":[[6,8,6,12],[34,1,34,2]]}
[]
[null,null,"Member Service Profile",null,null,null,null,null,"Grant Supplement",null,null,null,null,null,null,null,"2023-10-26"]
[null,null,null,null,null,null,null,null,"Location Type:","Standard"]
[]
[null,null,"Member / Service Name:",{"$f":"'Main Dashboard'!$C$5","v":0},null,"Weeks in Period:",{"$f":"'Main Dashboard'!$F$5","v":0},null,"Teacher Grants & Supplements"]
[null,null,null,null,null,null,null,null,"IMPORTANT: Select below the correct funding model under which this Kindergarten operates"]
[null,null,"For Period / FY Beginning:",{"$f":"'Main Dashboard'!$C$7","v":"00:00:00"},null,"Term Weeks in Period:",{"$f":"'Main Dashboard'!$F$7","v":0},null,"Table 1 - Services operating under the Early Childhood Enterprise Agreements and do not opt in to Free Kinder",null,null,null,null,null,{"$f":"VLOOKUP($I$7,'2025 Funding Rates'!$B$8:$I$11,8,FALSE)","v":"T1"}]
[]
[]
[null,"4 Year Olds",null,"Teacher Level \n(If more than 2.5)","Hours Per Week","Enrolled Children","Teacher Supplement","Cost Units",null,"Free Kinder Funding","# Child. Elig. for KFS","Term Fee","Suggested Term Fee","KFS  Add On","Fee Policy KFS Add On","Gap Fee","Hourly Rate","Hourly Add On","Fees Total","Add on Total","Ratio Supp.","KFS Supp.","KFS Total","Funded Hours","KFS Rate"]
[null,"Group A","4yo","L 2.5 Supplement",null,null,{"$f":"IFERROR(IF($D11=\"L 2.5 Supplement\",VLOOKUP($F11,Supp_2.4,IF($J$3=\"Standard\",2,3),FALSE),IF($D11=\"L 3.1 Supplement\",VLOOKUP($F11,Supp_2.5,IF($J$3=\"Standard\",2,3),FALSE),IF($D11=\"L 3.2-3.6 Supplement\",VLOOKUP($F11,Supp_3,IF($J$3=\"Standard\",2,3),FALSE),0))),0)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),$E11*$F$11,$E11*($F11-$K11))","v":0},null,{"$f":"IF(OR(Profile!$O$7=\"T3\",Profile!$O$7=\"T4\"),$J$47*$F11,0)","v":0},null,null,{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($H$16=0,0,$E11*(Budget!$F$66-Budget!$F$29+Budget!$F$19+Budget!$F$15)/$H$16/4/(1-$C$45)))","v":0},null,{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,(IF($P11<$R11,$P11,$R11))/4)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($E11>$X11,$L11*4-$Y11,0))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($E11=0,0,ROUND($L11*4/$E11,0)))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,$Q11*($E11-$X11))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,ROUND(4*($F11-$K11)*$L11,0))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,ROUND(4*$K11*$N11,0))","v":0},{"$f":"IF($F11-22>0,$J$36*$F11,0)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($K11-22>0,$J$38*($K11-22),0))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,$K11*$Y11)","v":0},{"$f":"IF($E11<15,15*($E11/15),15)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,$J$44)","v":2627}]
[null,"Group B","4yo",null,null,null,{"$f":"IFERROR(IF($D12=\"L 2.5 Supplement\",VLOOKUP($F12,Supp_2.4,IF($J$3=\"Standard\",2,3),FALSE),IF($D12=\"L 3.1 Supplement\",VLOOKUP($F12,Supp_2.5,IF($J$3=\"Standard\",2,3),FALSE),IF($D12=\"L 3.2-3.6 Supplement\",VLOOKUP($F12,Supp_3,IF($J$3=\"Standard\",2,3),FALSE),0))),0)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),$E12*$F$11,$E12*($F12-$K12))","v":0},null,{"$f":"IF(OR(Profile!$O$7=\"T3\",Profile!$O$7=\"T4\"),$J$47*$F12,0)","v":0},null,null,{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($H$16=0,0,$E12*(Budget!$F$66-Budget!$F$29+Budget!$F$19+Budget!$F$15)/$H$16/4/(1-$C$45)))","v":0},null,{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,(IF($P12<$R12,$P12,$R12))/4)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($E12>$X12,$L12*4-$Y12,0))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($E12=0,0,ROUND($L12*4/$E12,0)))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,$Q12*($E12-$X12))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,ROUND(4*($F12-$K12)*$L12,0))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,ROUND(4*$K12*$N12,0))","v":0},{"$f":"IF($F12-22>0,$J$36*$F12,0)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($K12-22>0,$J$38*($K12-22),0))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,$K12*$Y12)","v":0},{"$f":"IF($E12<15,15*($E12/15),15)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,$J$44)","v":2627}]
[null,"Group C","4yo",null,null,null,{"$f":"IFERROR(IF($D13=\"L 2.5 Supplement\",VLOOKUP($F13,Supp_2.4,IF($J$3=\"Standard\",2,3),FALSE),IF($D13=\"L 3.1 Supplement\",VLOOKUP($F13,Supp_2.5,IF($J$3=\"Standard\",2,3),FALSE),IF($D13=\"L 3.2-3.6 Supplement\",VLOOKUP($F13,Supp_3,IF($J$3=\"Standard\",2,3),FALSE),0))),0)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),$E13*$F$11,$E13*($F13-$K13))","v":0},null,{"$f":"IF(OR(Profile!$O$7=\"T3\",Profile!$O$7=\"T4\"),$J$47*$F13,0)","v":0},null,null,{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($H$16=0,0,$E13*(Budget!$F$66-Budget!$F$29+Budget!$F$19+Budget!$F$15)/$H$16/4/(1-$C$45)))","v":0},null,{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,(IF($P13<$R13,$P13,$R13))/4)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($E13>$X13,$L13*4-$Y13,0))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($E13=0,0,ROUND($L13*4/$E13,0)))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,$Q13*($E13-$X13))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,ROUND(4*($F13-$K13)*$L13,0))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,ROUND(4*$K13*$N13,0))","v":0},{"$f":"IF($F13-22>0,$J$36*$F13,0)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($K13-22>0,$J$38*($K13-22),0))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,$K13*$Y13)","v":0},{"$f":"IF($E13<15,15*($E13/15),15)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,$J$44)","v":2627}]
[null,"Group D","4yo",null,null,null,{"$f":"IFERROR(IF($D14=\"L 2.5 Supplement\",VLOOKUP($F14,Supp_2.4,IF($J$3=\"Standard\",2,3),FALSE),IF($D14=\"L 3.1 Supplement\",VLOOKUP($F14,Supp_2.5,IF($J$3=\"Standard\",2,3),FALSE),IF($D14=\"L 3.2-3.6 Supplement\",VLOOKUP($F14,Supp_3,IF($J$3=\"Standard\",2,3),FALSE),0))),0)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),$E14*$F$11,$E14*($F14-$K14))","v":0},null,{"$f":"IF(OR(Profile!$O$7=\"T3\",Profile!$O$7=\"T4\"),$J$47*$F14,0)","v":0},null,null,{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($H$16=0,0,$E14*(Budget!$F$66-Budget!$F$29+Budget!$F$19+Budget!$F$15)/$H$16/4/(1-$C$45)))","v":0},null,{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,(IF($P14<$R14,$P14,$R14))/4)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($E14>$X14,$L14*4-$Y14,0))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($E14=0,0,ROUND($L14*4/$E14,0)))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,$Q14*($E14-$X14))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,ROUND(4*($F14-$K14)*$L14,0))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,ROUND(4*$K14*$N14,0))","v":0},{"$f":"IF($F14-22>0,$J$36*$F14,0)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($K14-22>0,$J$38*($K14-22),0))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,$K14*$Y14)","v":0},{"$f":"IF($E14<15,15*($E14/15),15)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,$J$44)","v":2627}]
[null,"Group E","4yo",null,null,null,{"$f":"IFERROR(IF($D15=\"L 2.5 Supplement\",VLOOKUP($F15,Supp_2.4,IF($J$3=\"Standard\",2,3),FALSE),IF($D15=\"L 3.1 Supplement\",VLOOKUP($F15,Supp_2.5,IF($J$3=\"Standard\",2,3),FALSE),IF($D15=\"L 3.2-3.6 Supplement\",VLOOKUP($F15,Supp_3,IF($J$3=\"Standard\",2,3),FALSE),0))),0)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),$E15*$F$11,$E15*($F15-$K15))","v":0},null,{"$f":"IF(OR(Profile!$O$7=\"T3\",Profile!$O$7=\"T4\"),$J$47*$F15,0)","v":0},null,null,{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($H$16=0,0,$E15*(Budget!$F$66-Budget!$F$29+Budget!$F$19+Budget!$F$15)/$H$16/4/(1-$C$45)))","v":0},null,{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,(IF($P15<$R15,$P15,$R15))/4)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($E15>$X15,$L15*4-$Y15,0))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($E15=0,0,ROUND($L15*4/$E15,0)))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,$Q15*($E15-$X15))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,ROUND(4*($F15-$K15)*$L15,0))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,ROUND(4*$K15*$N15,0))","v":0},{"$f":"IF($F15-22>0,$J$36*$F15,0)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($K15-22>0,$J$38*($K15-22),0))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,$K15*$Y15)","v":0},{"$f":"IF($E15<15,15*($E15/15),15)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,$J$44)","v":2627}]
[null,null,null,null,"Subtotals",{"$f":"SUM($F11:$F15)","v":0},{"$f":"SUM(G$11:G$15)","v":0},{"$f":"SUM($H11:$H15)","v":0},null,{"$f":"SUM(J$11:J$15)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U$11:U$15)","v":0},{"$f":"SUM(V$11:V$15)","v":0},{"$f":"SUM(W$11:W$15)","v":0}]
[]
[null,"3 Year Olds",null,"Teacher Level \n(If more than 2.5)","Hours Per Week","Enrolled Children","Teacher Supplement","Cost Units","3yo Flexible Funding","Free Kinder Funding","# Child. Elig. for KFS","Term Fee","Suggested Term Fee","KFS  Add On","Fee Policy KFS Add On","Gap Fee","Hourly Rate","Hourly Add On","Fees Total","Add on Total","Ratio Supp.","KFS Supp.","KFS Total","Funded Hours","KFS Rate"]
[null,"Group E","3yo",null,null,6,{"$f":"IFERROR(IF($D19=\"L 2.5 Supplement\",VLOOKUP($F19,Supp_2.4,IF($J$3=\"Standard\",2,3),FALSE)/15*$E19,IF($D19=\"L 3.1 Supplement\",VLOOKUP($F19,Supp_2.5,IF($J$3=\"Standard\",2,3),FALSE)/15*$E19,IF($D19=\"L 3.2-3.6 Supplement\",VLOOKUP($F19,Supp_3,IF($J$3=\"Standard\",2,3),FALSE)/15*$E19,0))),0)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),$E19*$F19,$E19*($F19-$K19))","v":0},{"$f":"(IF($J$3=\"Standard\",$J$42,$J$43)/15*$E19)*$F19","v":0},{"$f":"IF(OR(Profile!$O$7=\"T3\",Profile!$O$7=\"T4\"),(($J$47/15)*$E19)*$F19,0)","v":0},null,null,{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($H$23=0,0,$E19*(Budget!$G$66-Budget!$G$29+Budget!$G$19+Budget!$G$15)/$H$23/4/(1-$C$45)))","v":0},null,{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,(IF($P19<$R19,$P19,$R19))/4)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($E19>$X19,$L19*4-$Y19,0))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($E19=0,0,ROUND($L19*4/$E19,0)))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,$Q19*($E19-$X19))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,ROUND(4*($F19-$K19)*$L19,0))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,ROUND(4*$K19*$N19,0))","v":0},{"$f":"IF($F19-22>0,(($J$36/15)*$E19)*$F19,0)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($K19-22>0,(($J$38/15)*$E19)*($K19-22),0))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,$K19*$Y19)","v":0},{"$f":"IF($E19<15,15*($E19/15),15)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,($J$44/15)*$E19)","v":0}]
[null,"Group F","3yo",null,null,null,{"$f":"IFERROR(IF($D20=\"L 2.5 Supplement\",VLOOKUP($F20,Supp_2.4,IF($J$3=\"Standard\",2,3),FALSE)/15*$E20,IF($D20=\"L 3.1 Supplement\",VLOOKUP($F20,Supp_2.5,IF($J$3=\"Standard\",2,3),FALSE)/15*$E20,IF($D20=\"L 3.2-3.6 Supplement\",VLOOKUP($F20,Supp_3,IF($J$3=\"Standard\",2,3),FALSE)/15*$E20,0))),0)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),$E20*$F20,$E20*($F20-$K20))","v":0},{"$f":"(IF($J$3=\"Standard\",$J$42,$J$43)/15*$E20)*$F20","v":0},{"$f":"IF(OR(Profile!$O$7=\"T3\",Profile!$O$7=\"T4\"),(($J$47/15)*$E20)*$F20,0)","v":0},null,null,{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($H$23=0,0,$E20*(Budget!$G$66-Budget!$G$29+Budget!$G$19+Budget!$G$15)/$H$23/4/(1-$C$45)))","v":0},null,{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,(IF($P20<$R20,$P20,$R20))/4)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($E20>$X20,$L20*4-$Y20,0))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($E20=0,0,ROUND($L20*4/$E20,0)))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,$Q20*($E20-$X20))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,ROUND(4*($F20-$K20)*$L20,0))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,ROUND(4*$K20*$N20,0))","v":0},{"$f":"IF($F20-22>0,(($J$36/15)*$E20)*$F20,0)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($K20-22>0,(($J$38/15)*$E20)*($K20-22),0))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,$K20*$Y20)","v":0},{"$f":"IF($E20<15,15*($E20/15),15)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,($J$44/15)*$E20)","v":0}]
[null,"Group G","3yo",null,null,null,{"$f":"IFERROR(IF($D21=\"L 2.5 Supplement\",VLOOKUP($F21,Supp_2.4,IF($J$3=\"Standard\",2,3),FALSE)/15*$E21,IF($D21=\"L 3.1 Supplement\",VLOOKUP($F21,Supp_2.5,IF($J$3=\"Standard\",2,3),FALSE)/15*$E21,IF($D21=\"L 3.2-3.6 Supplement\",VLOOKUP($F21,Supp_3,IF($J$3=\"Standard\",2,3),FALSE)/15*$E21,0))),0)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),$E21*$F21,$E21*($F21-$K21))","v":0},{"$f":"(IF($J$3=\"Standard\",$J$42,$J$43)/15*$E21)*$F21","v":0},{"$f":"IF(OR(Profile!$O$7=\"T3\",Profile!$O$7=\"T4\"),(($J$47/15)*$E21)*$F21,0)","v":0},null,null,{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($H$23=0,0,$E21*(Budget!$G$66-Budget!$G$29+Budget!$G$19+Budget!$G$15)/$H$23/4/(1-$C$45)))","v":0},null,{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,(IF($P21<$R21,$P21,$R21))/4)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($E21>$X21,$L21*4-$Y21,0))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($E21=0,0,ROUND($L21*4/$E21,0)))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,$Q21*($E21-$X21))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,ROUND(4*($F21-$K21)*$L21,0))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,ROUND(4*$K21*$N21,0))","v":0},{"$f":"IF($F21-22>0,(($J$36/15)*$E21)*$F21,0)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($K21-22>0,(($J$38/15)*$E21)*($K21-22),0))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,$K21*$Y21)","v":0},{"$f":"IF($E21<15,15*($E21/15),15)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,($J$44/15)*$E21)","v":0}]
[null,"Group H","3yo",null,null,null,{"$f":"IFERROR(IF($D22=\"L 2.5 Supplement\",VLOOKUP($F22,Supp_2.4,IF($J$3=\"Standard\",2,3),FALSE)/15*$E22,IF($D22=\"L 3.1 Supplement\",VLOOKUP($F22,Supp_2.5,IF($J$3=\"Standard\",2,3),FALSE)/15*$E22,IF($D22=\"L 3.2-3.6 Supplement\",VLOOKUP($F22,Supp_3,IF($J$3=\"Standard\",2,3),FALSE)/15*$E22,0))),0)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),$E22*$F22,$E22*($F22-$K22))","v":0},{"$f":"(IF($J$3=\"Standard\",$J$42,$J$43)/15*$E22)*$F22","v":0},{"$f":"IF(OR(Profile!$O$7=\"T3\",Profile!$O$7=\"T4\"),(($J$47/15)*$E22)*$F22,0)","v":0},null,null,{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($H$23=0,0,$E22*(Budget!$G$66-Budget!$G$29+Budget!$G$19+Budget!$G$15)/$H$23/4/(1-$C$45)))","v":0},null,{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,(IF($P22<$R22,$P22,$R22))/4)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($E22>$X22,$L22*4-$Y22,0))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($E22=0,0,ROUND($L22*4/$E22,0)))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,$Q22*($E22-$X22))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,ROUND(4*($F22-$K22)*$L22,0))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,ROUND(4*$K22*$N22,0))","v":0},{"$f":"IF($F22-22>0,(($J$36/15)*$E22)*$F22,0)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,IF($K22-22>0,(($J$38/15)*$E22)*($K22-22),0))","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,$K22*$Y22)","v":0},{"$f":"IF($E22<15,15*($E22/15),15)","v":0},{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,($J$44/15)*$E22)","v":0}]
[null,null,null,null,"Subtotals",{"$f":"SUM(F$19:F$22)","v":6},{"$f":"SUM(G$19:G$22)","v":0},{"$f":"SUM(H$19:H$22)","v":0},{"$f":"SUM(I$19:I$22)","v":0},{"$f":"SUM(J$19:J$22)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U$19:U$22)","v":0},{"$f":"SUM(V$19:V$22)","v":0},{"$f":"SUM(W$19:W$22)","v":0}]
[]
[null,"Other Programs (i.e. Extended Care)",null,null,"Hours Per Week","Enrolled Children",null,"Cost Units",null,"Term Fee","Suggested Term Fee",null,null,null,null,null,"Hourly Rate",null,"Fees Total"]
[null,"Group I","Other",null,null,null,null,{"$f":"$E26*($F26-$I26)","v":0},null,null,{"$f":"IF($H$30=0,0,$E26*(Budget!$H$66-Budget!$H$29+Budget!$H$19+Budget!$H$15)/$H$30/4/(1-$C$45))","v":0},null,null,null,null,null,{"$f":"IF($E26=0,0,ROUND($J26*4/$E26,0))","v":0},null,{"$f":"ROUND(4*($F26-$I26)*$J26,0)","v":0}]
[null,"Group J","Other",null,null,null,null,{"$f":"$E27*($F27-$I27)","v":0},null,null,{"$f":"IF($H$30=0,0,$E27*(Budget!$H$66-Budget!$H$29+Budget!$H$19+Budget!$H$15)/$H$30/4/(1-$C$45))","v":0},null,null,null,null,null,{"$f":"IF($E27=0,0,ROUND($J27*4/$E27,0))","v":0},null,{"$f":"ROUND(4*($F27-$I27)*$J27,0)","v":0}]
[null,"Group K","Other",null,null,null,null,{"$f":"$E28*($F28-$I28)","v":0},null,null,{"$f":"IF($H$30=0,0,$E28*(Budget!$H$66-Budget!$H$29+Budget!$H$19+Budget!$H$15)/$H$30/4/(1-$C$45))","v":0},null,null,null,null,null,{"$f":"IF($E28=0,0,ROUND($J28*4/$E28,0))","v":0},null,{"$f":"ROUND(4*($F28-$I28)*$J28,0)","v":0}]
[null,"Group L","Other",null,null,null,null,{"$f":"$E29*($F29-$I29)","v":0},null,null,{"$f":"IF($H$30=0,0,$E29*(Budget!$H$66-Budget!$H$29+Budget!$H$19+Budget!$H$15)/$H$30/4/(1-$C$45))","v":0},null,null,null,null,null,{"$f":"IF($E29=0,0,ROUND($J29*4/$E29,0))","v":0},null,{"$f":"ROUND(4*($F29-$I29)*$J29,0)","v":0}]
[null,null,null,null,"Subtotals",{"$f":"SUM($F26:$F29)","v":0},null,{"$f":"SUM($H26:$H29)","v":0}]
[]
[null,null,null,null,null,null,"Total",{"$f":"$H$16+$H$23+$H$30","v":0}]
[null,"Other Employee Costs",null,null,"2025 Funding Rates"]
[]
[null,"Salary On Costs",null,null,"L 2.5 Supplement",null,null,null,null,"2025 Rates"]
[null,"Workcover",1.4999999999999999E-2,null,"Standard (Grant - excl, GST)",{"$f":"IF(OR($O$7=\"T1\",$O$7=\"T3\"),'2025 Funding Rates'!$C$40,0)","v":282},null,"Ratio Supplement - Standard",null,{"$f":"IF($O$7=\"T1\",'2025 Funding Rates'!$C$36,IF($O$7=\"T2\",'2025 Funding Rates'!$C$83,IF($O$7=\"T3\",'2025 Funding Rates'!$C$119,IF($O$7=\"T4\",'2025 Funding Rates'!$C$165))))","v":571}]
[null,"Superannuation",0.115,null,"Rural (Grant - excl. GST)",{"$f":"IF(OR($O$7=\"T1\",$O$7=\"T3\"),'2025 Funding Rates'!$C$42,0)","v":349},null,"No of children in group > 22 children"]
[null,"Sick Leave",0.06,null,null,null,null,"Ratio Supplement - KFS",null,{"$f":"IF($O$7=\"T1\",'2025 Funding Rates'!$C$37,IF($O$7=\"T2\",'2025 Funding Rates'!$C$84,0))","v":0}]
[null,"Long Service Leave",0.02,null,"L 3.1 Supplement",null,null,"No of children with HCC in group > 22 children"]
[null,"Pay Increases",1.4999999999999999E-2,null,"Standard",{"$f":"IF(OR($O$7=\"T1\",$O$7=\"T3\"),'2025 Funding Rates'!$C$41,0)","v":494}]
[null,"Accident Mark Up",4.0000000000000001E-3,null,"Rural",{"$f":"IF(OR($O$7=\"T1\",$O$7=\"T3\"),'2025 Funding Rates'!$C$43,0)","v":609},null,"Per Capita Funding Grants",null,"4 YO Rates"]
[null,"Professional Development",1.4999999999999999E-2,null,null,null,null,"Standard",null,{"$f":"IF($O$7=\"T1\",'2025 Funding Rates'!$C$27,IF($O$7=\"T2\",'2025 Funding Rates'!$C$71,IF($O$7=\"T3\",'2025 Funding Rates'!$C$110,IF($O$7=\"T4\",'2025 Funding Rates'!$C$153))))","v":4339}]
[null,"Total",{"$f":"SUM($C$36:$C$42)","v":0.24399999999999999},null,"L 3.2-3.6 Supplement",null,null,"Rural",null,{"$f":"IF($O$7=\"T1\",'2025 Funding Rates'!$C$28,IF($O$7=\"T2\",'2025 Funding Rates'!$C$72,IF($O$7=\"T3\",'2025 Funding Rates'!$C$111,IF($O$7=\"T4\",'2025 Funding Rates'!$C$154))))","v":5366}]
[null,null,null,null,"Standard (Grant - excl, GST)",{"$f":"IF(OR($O$7=\"T1\",$O$7=\"T3\"),'2025 Funding Rates'!$C$44,0)","v":705},null,"Kindergarten Fee Subsidy",null,{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,'2025 Funding Rates'!$C$77)","v":2627}]
[null,"Provision for Bad Debts",0.05,null,"Rural (Grant - excl. GST)",{"$f":"IF(OR($O$7=\"T1\",$O$7=\"T3\"),'2025 Funding Rates'!$C$45,0)","v":874}]
[null,null,null,null,null,null,null,"Free Kinder",null,"4 YO Rates"]
[null,null,null,null,null,null,null,"Standard",null,{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),IF($O$7=\"T3\",'2025 Funding Rates'!$C$113,'2025 Funding Rates'!$C$159),0)","v":0}]

{"sheet":"Grants","index":12,"n_rows":205,"n_cols":17,"rows_kept":205,"cut":false,"hidden":false,"merged":[[3,10,4,10],[3,14,4,14],[3,6,4,6],[3,1,4,1]]}
[]
[null,"GRANTS CALCULATION TABLES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-26"]
[]
[null,"Children UA Grant","Metro","Rural","Small Rural",null,"Children Supp 2.5","Metro","Rural",null,"Children Supp 3.1","Metro","Rural",null,"Children Supp 3.2 - 3.6","Metro","Rural"]
[null,null,{"$f":"Profile!$J$42","v":4339},{"$f":"Profile!$J$43","v":5366},{"$f":"$D$5","v":5366},null,null,{"$f":"Profile!$F$36","v":282},{"$f":"Profile!$F$37","v":349},null,null,{"$f":"Profile!$F$40","v":494},{"$f":"Profile!$F$41","v":609},null,null,{"$f":"Profile!$F$44","v":705},{"$f":"Profile!$F$45","v":874}]
[null,1,{"$f":"$B6*C$5","v":4339},{"$f":"$B6*D$5","v":5366},{"$f":"$B6*E$5","v":5366},null,1,{"$f":"$G6*H$5","v":282},{"$f":"$G6*I$5","v":349},null,1,{"$f":"$K6*L$5","v":494},{"$f":"$K6*M$5","v":609},null,1,{"$f":"$O6*P$5","v":705},{"$f":"$O6*Q$5","v":874}]
[null,2,{"$f":"$B7*C$5","v":8678},10732,10732,null,2,{"$f":"$G7*H$5","v":564},698,null,2,{"$f":"$K7*L$5","v":988},1218,null,2,{"$f":"$O7*P$5","v":1410},1748]
[null,3,13017,16098,16098,null,3,846,1047,null,3,1482,1827,null,3,2115,2622]
[null,4,17356,21464,21464,null,4,1128,1396,null,4,1976,2436,null,4,2820,3496]
[null,5,21695,26830,26830,null,5,1410,1745,null,5,2470,3045,null,5,3525,4370]
[null,6,26034,32196,32196,null,6,1692,2094,null,6,2964,3654,null,6,4230,5244]
[null,7,30373,37562,37562,null,7,1974,2443,null,7,3458,4263,null,7,4935,6118]
[null,8,34712,42928,42928,null,8,2256,2792,null,8,3952,4872,null,8,5640,6992]
[null,9,39051,48294,48294,null,9,2538,3141,null,9,4446,5481,null,9,6345,7866]
[null,10,43390,53660,53660,null,10,2820,3490,null,10,4940,6090,null,10,7050,8740]
[null,11,47729,59026,59026,null,11,3102,3839,null,11,5434,6699,null,11,7755,9614]
[null,12,52068,64392,64392,null,12,3384,4188,null,12,5928,7308,null,12,8460,10488]
[null,13,56407,69758,69758,null,13,3666,4537,null,13,6422,7917,null,13,9165,11362]
[null,14,60746,75124,75124,null,14,3948,4886,null,14,6916,8526,null,14,9870,12236]
[null,15,65085,80490,80490,null,15,4230,5235,null,15,7410,9135,null,15,10575,13110]
[null,16,69424,85856,85856,null,16,4512,5584,null,16,7904,9744,null,16,11280,13984]
[null,17,73763,91222,91222,null,17,4794,5933,null,17,8398,10353,null,17,11985,14858]
[null,18,78102,96588,96588,null,18,5076,6282,null,18,8892,10962,null,18,12690,15732]
[null,19,82441,101954,{"$f":"$B24*D$5","v":101954},null,19,5358,6631,null,19,9386,11571,null,19,13395,16606]
[null,20,86780,107320,107320,null,20,5640,6980,null,20,9880,12180,null,20,14100,17480]
[null,21,91119,112686,112686,null,21,5922,7329,null,21,10374,12789,null,21,14805,18354]
[null,22,95458,118052,118052,null,22,6204,7678,null,22,10868,13398,null,22,15510,19228]
[null,23,99797,123418,123418,null,23,6486,8027,null,23,11362,14007,null,23,16215,20102]
[null,24,104136,128784,128784,null,24,6768,8376,null,24,11856,14616,null,24,16920,20976]
[null,25,108475,134150,134150,null,25,7050,8725,null,25,12350,15225,null,25,17625,21850]
[null,26,112814,139516,139516,null,26,7332,9074,null,26,12844,15834,null,26,18330,22724]
[null,27,117153,144882,144882,null,27,7614,9423,null,27,13338,16443,null,27,19035,23598]
[null,28,121492,150248,150248,null,28,7896,9772,null,28,13832,17052,null,28,19740,24472]
[null,29,125831,155614,155614,null,29,8178,10121,null,29,14326,17661,null,29,20445,25346]
[null,30,130170,160980,160980,null,30,8460,10470,null,30,14820,18270,null,30,21150,26220]
[null,31,134509,166346,166346,null,31,8742,10819,null,31,15314,18879,null,31,21855,27094]
[null,32,138848,171712,171712,null,32,9024,11168,null,32,15808,19488,null,32,22560,27968]
[null,33,143187,177078,177078,null,33,9306,11517,null,33,16302,20097,null,33,23265,28842]
[null,34,147526,182444,182444,null,34,9588,11866,null,34,16796,20706,null,34,{"$f":"$O39*P$5","v":23970},29716]
[null,35,151865,187810,187810,null,35,9870,12215,null,35,17290,21315,null,35,24675,30590]
[null,36,156204,193176,193176,null,36,10152,12564,null,36,17784,21924,null,36,25380,31464]
[null,37,160543,198542,198542,null,37,10434,12913,null,37,18278,22533,null,37,26085,32338]
[null,38,164882,203908,203908,null,38,10716,13262,null,38,18772,23142,null,38,26790,33212]
[null,39,169221,209274,209274,null,39,10998,13611,null,39,19266,23751,null,39,27495,34086]
[null,40,173560,214640,214640,null,40,11280,13960,null,40,19760,24360,null,40,28200,34960]
[null,41,177899,220006,220006,null,41,11562,14309,null,41,20254,24969,null,41,28905,35834]
[null,42,182238,225372,225372,null,42,11844,14658,null,42,20748,25578,null,42,29610,36708]
[null,43,186577,230738,230738,null,43,12126,15007,null,43,21242,26187,null,43,30315,37582]
[null,44,190916,236104,236104,null,44,12408,15356,null,44,21736,26796,null,44,31020,38456]
[null,45,195255,241470,241470,null,45,12690,15705,null,45,22230,27405,null,45,31725,39330]
[null,46,199594,{"$f":"$D$50+($B51-45)*C$5","v":245809},{"$f":"$D51","v":245809},null,46,12972,16054,null,46,22724,{"$f":"$M$50+($K51-45)*L$5","v":27899},null,46,32430,40204]
[null,47,203933,250148,{"$f":"$D52","v":250148},null,47,13254,16403,null,47,{"$f":"$K52*L$5","v":23218},28393,null,47,33135,41078]
[null,48,208272,254487,254487,null,48,13536,16752,null,48,23712,28887,null,48,33840,41952]
[null,49,212611,258826,258826,null,49,13818,17101,null,49,24206,29381,null,49,34545,42826]
[null,50,216950,263165,263165,null,50,14100,17450,null,50,24700,29875,null,50,35250,43700]
[null,51,221289,267504,267504,null,51,14382,17799,null,51,25194,30369,null,51,35955,44574]
[null,52,225628,271843,271843,null,52,14664,18148,null,52,25688,30863,null,52,36660,45448]
[null,53,229967,276182,276182,null,53,14946,18497,null,53,26182,31357,null,53,37365,46322]
[null,54,234306,280521,280521,null,54,15228,18846,null,54,26676,31851,null,54,38070,47196]
[null,55,238645,284860,284860,null,55,15510,19195,null,55,27170,32345,null,55,38775,48070]
[null,56,242984,289199,289199,null,56,15792,19544,null,56,27664,32839,null,56,39480,48944]
[null,57,247323,293538,293538,null,57,16074,19893,null,57,28158,33333,null,57,40185,49818]
[null,58,251662,297877,297877,null,58,16356,20242,null,58,28652,33827,null,58,40890,50692]
[null,59,256001,302216,302216,null,59,16638,20591,null,59,29146,34321,null,59,41595,51566]
[null,60,260340,306555,306555,null,60,16920,20940,null,60,29640,34815,null,60,42300,52440]
[null,61,264679,310894,310894,null,61,17202,21289,null,61,30134,35309,null,61,43005,53314]
[null,62,269018,315233,315233,null,62,17484,21638,null,62,30628,35803,null,62,43710,54188]
[null,63,273357,319572,319572,null,63,17766,21987,null,63,31122,36297,null,63,44415,55062]
[null,64,277696,323911,323911,null,64,18048,22336,null,64,31616,36791,null,64,45120,55936]
[null,65,282035,328250,328250,null,65,18330,22685,null,65,32110,37285,null,65,45825,56810]
[null,66,{"$f":"$B71*C$5","v":286374},332589,332589,null,66,{"$f":"$G71*H$5","v":18612},23034,null,66,32604,37779,null,66,{"$f":"$O71*P$5","v":46530},57684]
[null,67,290713,336928,336928,null,67,18894,23383,null,67,33098,38273,null,67,47235,58558]
[null,68,295052,341267,341267,null,68,19176,23732,null,68,33592,38767,null,68,47940,59432]
[null,69,299391,345606,345606,null,69,19458,24081,null,69,34086,39261,null,69,48645,60306]
[null,70,303730,349945,349945,null,70,19740,24430,null,70,34580,39755,null,70,49350,61180]
[null,71,308069,354284,354284,null,71,20022,24779,null,71,35074,40249,null,71,50055,62054]
[null,72,312408,358623,358623,null,72,20304,25128,null,72,35568,40743,null,72,50760,62928]
[null,73,316747,362962,362962,null,73,20586,25477,null,73,36062,41237,null,73,51465,63802]
[null,74,321086,367301,367301,null,74,20868,25826,null,74,36556,41731,null,74,52170,64676]
[null,75,325425,371640,371640,null,75,21150,26175,null,75,37050,42225,null,75,52875,65550]
[null,76,329764,375979,375979,null,76,21432,26524,null,76,37544,42719,null,76,53580,66424]
[null,77,334103,380318,380318,null,77,21714,26873,null,77,38038,43213,null,77,54285,67298]
[null,78,338442,{"$f":"$D$50+($B83-45)*C$5","v":384657},384657,null,78,21996,27222,null,78,38532,{"$f":"$M$50+($K83-45)*L$5","v":43707},null,78,54990,68172]
[null,79,342781,388996,388996,null,79,22278,27571,null,79,39026,44201,null,79,55695,69046]
[null,80,347120,393335,393335,null,80,22560,27920,null,80,39520,44695,null,80,56400,69920]
[null,81,351459,397674,397674,null,81,22842,28269,null,81,40014,45189,null,81,57105,70794]
[null,82,355798,402013,402013,null,82,23124,28618,null,82,40508,45683,null,82,57810,71668]
[null,83,360137,406352,406352,null,83,23406,28967,null,83,41002,46177,null,83,58515,72542]
[null,84,364476,410691,410691,null,84,23688,29316,null,84,41496,46671,null,84,59220,73416]
[null,85,368815,415030,415030,null,85,23970,29665,null,85,41990,47165,null,85,59925,74290]
[null,86,373154,419369,419369,null,86,24252,30014,null,86,42484,47659,null,86,60630,75164]
[null,87,377493,423708,423708,null,87,24534,30363,null,87,42978,48153,null,87,61335,76038]
[null,88,381832,428047,428047,null,88,24816,30712,null,88,43472,48647,null,88,62040,76912]
[null,89,386171,432386,432386,null,89,25098,31061,null,89,43966,49141,null,89,62745,77786]
[null,90,390510,436725,436725,null,90,25380,31410,null,90,44460,49635,null,90,63450,78660]
[null,91,394849,441064,441064,null,91,25662,31759,null,91,44954,50129,null,91,64155,79534]
[null,92,399188,445403,445403,null,92,25944,32108,null,92,45448,50623,null,92,64860,80408]
[null,93,403527,449742,449742,null,93,26226,32457,null,93,45942,51117,null,93,65565,81282]
[null,94,407866,454081,454081,null,94,26508,32806,null,94,46436,51611,null,94,66270,82156]
[null,95,412205,458420,458420,null,95,26790,33155,null,95,46930,52105,null,95,66975,83030]
[null,96,416544,462759,462759,null,96,27072,33504,null,96,47424,52599,null,96,67680,83904]
[null,97,420883,467098,467098,null,97,27354,33853,null,97,47918,53093,null,97,68385,84778]
[null,98,425222,471437,471437,null,98,27636,34202,null,98,48412,53587,null,98,{"$f":"$O103*P$5","v":69090},85652]
[null,99,429561,475776,475776,null,99,27918,34551,null,99,48906,54081,null,99,69795,86526]
[null,100,433900,480115,480115,null,100,28200,34900,null,100,49400,54575,null,100,70500,87400]
[null,101,438239,484454,484454,null,101,28482,35249,null,101,49894,55069,null,101,71205,88274]
[null,102,442578,488793,488793,null,102,28764,35598,null,102,50388,55563,null,102,71910,89148]
[null,103,446917,493132,493132,null,103,29046,35947,null,103,50882,56057,null,103,72615,90022]
[null,104,451256,497471,497471,null,104,29328,36296,null,104,51376,56551,null,104,73320,90896]
[null,105,455595,501810,501810,null,105,29610,36645,null,105,51870,57045,null,105,74025,91770]
[null,106,459934,506149,506149,null,106,29892,36994,null,106,52364,57539,null,106,74730,92644]
[null,107,464273,510488,510488,null,107,30174,37343,null,107,52858,58033,null,107,75435,93518]
[null,108,468612,514827,514827,null,108,30456,37692,null,108,53352,58527,null,108,76140,94392]
[null,109,472951,519166,519166,null,109,30738,38041,null,109,53846,59021,null,109,76845,95266]
[null,110,477290,{"$f":"$D$50+($B115-45)*C$5","v":523505},523505,null,110,31020,38390,null,110,54340,{"$f":"$M$50+($K115-45)*L$5","v":59515},null,110,77550,96140]
[null,111,481629,527844,{"$f":"$D116","v":527844},null,111,31302,38739,null,111,{"$f":"$K116*L$5","v":54834},60009,null,111,78255,97014]
[null,112,485968,532183,532183,null,112,31584,39088,null,112,55328,60503,null,112,78960,97888]
[null,113,490307,536522,536522,null,113,31866,39437,null,113,55822,60997,null,113,79665,98762]
[null,114,494646,540861,540861,null,114,32148,39786,null,114,56316,61491,null,114,80370,99636]
[null,115,498985,545200,545200,null,115,32430,40135,null,115,56810,61985,null,115,81075,100510]
[null,116,503324,549539,549539,null,116,32712,40484,null,116,57304,62479,null,116,81780,101384]
[null,117,507663,553878,553878,null,117,32994,40833,null,117,57798,62973,null,117,82485,102258]
[null,118,512002,558217,558217,null,118,33276,41182,null,118,58292,63467,null,118,83190,103132]
[null,119,516341,562556,562556,null,119,33558,41531,null,119,58786,63961,null,119,83895,104006]
[null,120,520680,566895,566895,null,120,33840,41880,null,120,59280,64455,null,120,84600,104880]
[null,121,525019,571234,571234,null,121,34122,42229,null,121,59774,64949,null,121,85305,105754]
[null,122,529358,575573,575573,null,122,34404,42578,null,122,60268,65443,null,122,86010,106628]
[null,123,533697,579912,579912,null,123,34686,42927,null,123,60762,65937,null,123,86715,107502]
[null,124,538036,584251,584251,null,124,34968,43276,null,124,61256,66431,null,124,87420,108376]
[null,125,542375,588590,588590,null,125,35250,43625,null,125,61750,66925,null,125,88125,109250]
[null,126,546714,592929,592929,null,126,35532,43974,null,126,62244,67419,null,126,88830,110124]
[null,127,551053,597268,597268,null,127,35814,44323,null,127,62738,67913,null,127,89535,110998]
[null,128,555392,601607,601607,null,128,36096,44672,null,128,63232,68407,null,128,90240,111872]
[null,129,559731,605946,605946,null,129,36378,45021,null,129,63726,68901,null,129,90945,112746]
[null,130,{"$f":"$B135*C$5","v":564070},610285,610285,null,130,{"$f":"$G135*H$5","v":36660},45370,null,130,64220,69395,null,130,{"$f":"$O135*P$5","v":91650},113620]
[null,131,568409,614624,614624,null,131,36942,45719,null,131,64714,69889,null,131,92355,114494]
[null,132,572748,618963,618963,null,132,37224,46068,null,132,65208,70383,null,132,93060,115368]
[null,133,577087,623302,623302,null,133,37506,46417,null,133,65702,70877,null,133,93765,116242]
[null,134,581426,627641,627641,null,134,37788,46766,null,134,66196,71371,null,134,94470,117116]
[null,135,585765,631980,631980,null,135,38070,47115,null,135,66690,71865,null,135,95175,117990]
[null,136,590104,636319,636319,null,136,38352,47464,null,136,67184,72359,null,136,95880,118864]
[null,137,594443,640658,640658,null,137,38634,47813,null,137,67678,72853,null,137,96585,119738]
[null,138,598782,644997,644997,null,138,38916,48162,null,138,68172,73347,null,138,97290,120612]
[null,139,603121,649336,649336,null,139,39198,48511,null,139,68666,73841,null,139,97995,121486]
[null,140,607460,653675,653675,null,140,39480,48860,null,140,69160,74335,null,140,98700,122360]
[null,141,611799,658014,658014,null,141,39762,49209,null,141,69654,74829,null,141,99405,123234]
[null,142,616138,{"$f":"$D$50+($B147-45)*C$5","v":662353},662353,null,142,40044,49558,null,142,70148,{"$f":"$M$50+($K147-45)*L$5","v":75323},null,142,100110,124108]
[null,143,620477,666692,666692,null,143,40326,49907,null,143,70642,75817,null,143,100815,124982]
[null,144,624816,671031,671031,null,144,40608,50256,null,144,71136,76311,null,144,101520,125856]
[null,145,629155,675370,675370,null,145,40890,50605,null,145,71630,76805,null,145,102225,126730]
[null,146,633494,679709,679709,null,146,41172,50954,null,146,72124,77299,null,146,102930,127604]
[null,147,637833,684048,684048,null,147,41454,51303,null,147,72618,77793,null,147,103635,128478]
[null,148,642172,688387,688387,null,148,41736,51652,null,148,73112,78287,null,148,104340,129352]
[null,149,646511,692726,692726,null,149,42018,52001,null,149,73606,78781,null,149,105045,130226]
[null,150,650850,697065,697065,null,150,42300,52350,null,150,74100,79275,null,150,105750,131100]
[null,151,655189,701404,701404,null,151,42582,52699,null,151,74594,79769,null,151,106455,131974]
[null,152,659528,705743,705743,null,152,42864,53048,null,152,75088,80263,null,152,107160,132848]
[null,153,663867,710082,710082,null,153,43146,53397,null,153,75582,80757,null,153,107865,133722]
[null,154,668206,714421,714421,null,154,43428,53746,null,154,76076,81251,null,154,108570,134596]
[null,155,672545,718760,718760,null,155,43710,54095,null,155,76570,81745,null,155,109275,135470]
[null,156,676884,723099,723099,null,156,43992,54444,null,156,77064,82239,null,156,109980,136344]
[null,157,681223,727438,727438,null,157,44274,54793,null,157,77558,82733,null,157,110685,137218]
[null,158,685562,731777,731777,null,158,44556,55142,null,158,78052,83227,null,158,111390,138092]
[null,159,689901,736116,736116,null,159,44838,55491,null,159,78546,83721,null,159,112095,138966]
[null,160,694240,740455,740455,null,160,45120,55840,null,160,79040,84215,null,160,112800,139840]
[null,161,698579,744794,744794,null,161,45402,56189,null,161,79534,84709,null,161,113505,140714]
[null,162,702918,749133,749133,null,162,45684,56538,null,162,80028,85203,null,162,{"$f":"$O167*P$5","v":114210},141588]
[null,163,707257,753472,753472,null,163,45966,56887,null,163,80522,85697,null,163,114915,142462]
[null,164,711596,757811,757811,null,164,46248,57236,null,164,81016,86191,null,164,115620,143336]
[null,165,715935,762150,762150,null,165,46530,57585,null,165,81510,86685,null,165,116325,144210]
[null,166,720274,766489,766489,null,166,46812,57934,null,166,82004,87179,null,166,117030,145084]
[null,167,724613,770828,770828,null,167,47094,58283,null,167,82498,87673,null,167,117735,145958]
[null,168,728952,775167,775167,null,168,47376,58632,null,168,82992,88167,null,168,118440,146832]
[null,169,733291,779506,779506,null,169,47658,58981,null,169,83486,88661,null,169,119145,147706]
[null,170,737630,783845,783845,null,170,47940,59330,null,170,83980,89155,null,170,119850,148580]
[null,171,741969,788184,788184,null,171,48222,59679,null,171,84474,89649,null,171,120555,149454]
[null,172,746308,792523,792523,null,172,48504,60028,null,172,84968,90143,null,172,121260,150328]
[null,173,750647,796862,796862,null,173,48786,60377,null,173,85462,90637,null,173,121965,151202]
[null,174,754986,{"$f":"$D$50+($B179-45)*C$5","v":801201},801201,null,174,49068,60726,null,174,85956,{"$f":"$M$50+($K179-45)*L$5","v":91131},null,174,122670,152076]
[null,175,759325,805540,{"$f":"$D180","v":805540},null,175,49350,61075,null,175,{"$f":"$K180*L$5","v":86450},91625,null,175,123375,152950]
[null,176,763664,809879,809879,null,176,49632,61424,null,176,86944,92119,null,176,124080,153824]
[null,177,768003,814218,814218,null,177,49914,61773,null,177,87438,92613,null,177,124785,154698]
[null,178,772342,818557,818557,null,178,50196,62122,null,178,87932,93107,null,178,125490,155572]
[null,179,776681,822896,822896,null,179,50478,62471,null,179,88426,93601,null,179,126195,156446]
[null,180,781020,827235,827235,null,180,50760,62820,null,180,88920,94095,null,180,126900,157320]
[null,181,785359,831574,831574,null,181,51042,63169,null,181,89414,94589,null,181,127605,158194]
[null,182,789698,835913,835913,null,182,51324,63518,null,182,89908,95083,null,182,128310,159068]
[null,183,794037,840252,840252,null,183,51606,63867,null,183,90402,95577,null,183,129015,159942]
[null,184,798376,844591,844591,null,184,51888,64216,null,184,90896,96071,null,184,129720,160816]
[null,185,802715,848930,848930,null,185,52170,64565,null,185,91390,96565,null,185,130425,161690]
[null,186,807054,853269,853269,null,186,52452,64914,null,186,91884,97059,null,186,131130,162564]
[null,187,811393,857608,857608,null,187,52734,65263,null,187,92378,97553,null,187,131835,163438]
[null,188,815732,861947,861947,null,188,53016,65612,null,188,92872,98047,null,188,132540,164312]
[null,189,820071,866286,866286,null,189,53298,65961,null,189,93366,98541,null,189,133245,165186]
[null,190,824410,870625,870625,null,190,53580,66310,null,190,93860,99035,null,190,133950,166060]
[null,191,828749,874964,874964,null,191,53862,66659,null,191,94354,99529,null,191,134655,166934]
[null,192,833088,879303,879303,null,192,54144,67008,null,192,94848,100023,null,192,135360,167808]
[null,193,837427,883642,883642,null,193,54426,67357,null,193,95342,100517,null,193,136065,168682]
[null,194,{"$f":"$B199*C$5","v":841766},887981,887981,null,194,{"$f":"$G199*H$5","v":54708},67706,null,194,95836,101011,null,194,136770,169556]
[null,195,846105,892320,892320,null,195,54990,68055,null,195,96330,101505,null,195,137475,170430]
[null,196,850444,896659,896659,null,196,55272,68404,null,196,96824,101999,null,196,138180,171304]
[null,197,854783,900998,900998,null,197,55554,68753,null,197,97318,102493,null,197,138885,172178]
[null,198,859122,905337,905337,null,198,55836,69102,null,198,97812,102987,null,198,139590,173052]
[null,199,863461,909676,909676,null,199,56118,69451,null,199,98306,103481,null,199,140295,173926]
[null,200,867800,914015,914015,null,200,56400,69800,null,200,98800,103975,null,200,141000,174800]

{"sheet":"2025 Funding Rates","index":13,"n_rows":194,"n_cols":9,"rows_kept":194,"cut":false,"hidden":false,"merged":[[7,1,7,5],[8,1,8,5],[9,1,9,5],[10,1,10,5]]}
[]
[null,"2025 Kindergarten Funding rates"]
[]
[null,"Kindergarten providers can find which funding rates table is applicable to them by identifying whether they have"]
[null,"opted in to Free Kinder or not and whether they operate under either of the Victorian Early Childhood Teachers’"]
[null,"and Educators’ Agreement 2020 (VECTEA) and the Early Education Employees’ Agreement 2020 (EEEA) or not."]
[]
[null,"Table 1 - Services operating under the Early Childhood Enterprise Agreements and do not opt in to Free Kinder",null,null,null,null,null,null,"T1"]
[null,"Table 2 - Services not operating under the Early Childhood Enterprise Agreements and do not opt in to Free Kinder",null,null,null,null,null,null,"T2"]
[null,"Table 3 - Services operating under the Early Childhood Enterprise Agreements and opt-in to Free Kinder",null,null,null,null,null,null,"T3"]
[null,"Table 4 - Services not operating under the Early Childhood Enterprise Agreements and opt-in to Free Kinder",null,null,null,null,null,null,"T4"]
[]
[null,null,null,null,null,null,null,null,"Teacher Level Dropdown"]
[null,null,null,null,null,null,null,null,"L 2.5 Supplement"]
[null,null,null,null,null,null,null,null,"L 3.1 Supplement"]
[null,null,null,null,null,null,null,null,"L 3.2-3.6 Supplement"]
[null,null,null,null,null,null,null,null,"N/A"]
[]
[]
[null,"Table 1 - Services operating under the Early Childhood Enterprise Agreements and do not opt in to Free Kinder"]
[]
[null,2025]
[]
[]
[null,null,2025]
[null,"Per capita - EA services*"]
[null,"Standard per capita - EA services",4339]
[null,"Rural per capita - EA services",5366]
[null,"Kindergarten Fee Subsidy"]
[null,"Kindergarten Fee Subsidy",2135]
[null,"Early Start Kindergarten and Access to Early Learning**"]
[null,"ESK Standard",6966]
[null,"ESK Rural",7993]
[null,"ESK Extension (equivalent to KFS)",2135]
[null,"Ratio Supplement"]
[null,"Ratio Supplement - Standard",571]
[null,"Ratio Supplement - KFS",0]
[null,"Ratio Supplement - ESK***",571]
[null,"Early Childhood Teacher Supplement"]
[null,"Standard rate - Level 2.5",282]
[null,"Standard rate - Level 3.1",494]
[null,"Rural rate - Level 2.5",349]
[null,"Rural rate - Level 3.1",609]
[null,"Standard rate - Level 3.2-3.6",705]
[null,"Rural rate - Level 3.2-3.6",874]
[null,"Pre-Purchased Places"]
[null,"Pre-Purchased Places",6966]
[]
[null,"*Services that are signatories to the Early Childhood Enterprise Agreements are services that will sign the new Victorian"]
[null,"Early Childhood Teachers’ and Educators’ Agreement (VECTEA) or the Early Education Employees’ Agreement (EEEA)."]
[]
[null,"**ESK Standard and Rural enrolments will be funded at the same rate"]
[]
[]
[null,"***The ESK ratio supplement will be paid at a rate equivalent to the Standard Ratio Supplement as a proportion of the ESK"]
[null,"Ratio Supplement is included in the Free Kinder funding rate."]
[]
[null,"The same rates apply to funded three-year-old and four-year-old enrolments in programs of 15 hours per week. For"]
[null,"services in funded Three-Year-Old Kindergarten roll-out areas and delivering a funded Three-Year-Old Kindergarten"]
[null,"program between five and 15 hours, child level funding will be provided on a prorated basis. For example, a kindergarten"]
[null,"delivering a ten hour Three-Year-old Kindergarten program will receive two thirds of the applicable rate of funding"]
[null,"available."]
[]
[null,"Table 2 - Services not operating under the Early Childhood Enterprise Agreements and do not opt in to Free Kinder"]
[]
[null,2025]
[]
[]
[null,null,2025]
[null,"Per capita - Non-EA services"]
[null,"Standard per capita - non-EA services",3831]
[null,"Rural per capita - non-EA services",4737]
[null,"Independent schools Standard",3831]
[null,"Independent schools Type 1",672]
[null,"Independent schools Type 2",2181]
[null,"Kindergarten Fee Subsidy"]
[null,"Kindergarten Fee Subsidy",2627]
[null,"Early Start Kindergarten and Access to Early Learning*"]
[null,"ESK Standard",6966]
[null,"ESK Rural",7993]
[null,"ESK Extension (equivalent to KFS)",2135]
[null,"Ratio Supplement"]
[null,"Ratio Supplement - Standard",571]
[null,"Ratio Supplement - KFS",0]
[null,"Ratio Supplement - ESK**",571]
[null,"Pre-Purchased Places***"]
[null,"Pre-Purchased Places",6966]
[]
[null,"*ESK Standard and Rural enrolments will be funded at the same rate"]
[]
[]
[null,"** The ESK ratio supplement will be paid at a rate equivalent to the Standard Ratio Supplement as a proportion of the ESK"]
[]
[]
[null,"***All PPP enrolments will be funded at the EA rate."]
[]
[null,"The same rates apply to funded three-year-old and four-year-old enrolments in programs of 15 hours per week. For"]
[null,"services in funded Three-Year-Old Kindergarten roll-out areas and delivering a funded Three-Year-Old Kindergarten"]
[null,"program between five and 15 hours, child level funding will be provided on a prorated basis. For example, a kindergarten"]
[null,"delivering a ten hour Three-Year-old Kindergarten program will receive two thirds of the applicable rate of funding"]
[null,"available."]
[]
[null,"Table 3 - Services operating under the Early Childhood Enterprise Agreements and opt-in to Free Kinder"]
[]
[null,2025]
[]
[]
[null,null,2025]
[null,"Per capita - EA services*"]
[null,"Standard per capita - EA services",4339]
[null,"Rural per capita - EA services",5366]
[null,"Free Kindergarten Funding"]
[null,"Free Kindergarten Funding",2627]
[null,"Early Start Kindergarten and Access to Early Learning**"]
[null,"ESK Standard",{"$f":"$C$32","v":6966}]
[null,"ESK Rural",{"$f":"$C$33","v":7993}]
[null,"ESK Extension (equivalent to KFS)",0]
[null,"Ratio Supplement"]
[null,"Ratio Supplement - Standard",{"$f":"$C$36","v":571}]
[null,"Ratio Supplement - ESK***",{"$f":"$C$38","v":571}]
[null,"Early Childhood Teacher Supplement"]
[null,"Standard rate - Level 2.5",{"$f":"$C$40","v":282}]
[null,"Standard rate - Level 3.1",494]
[null,"Rural rate - Level 2.5",{"$f":"$C$42","v":349}]
[null,"Rural rate - Level 3.1",{"$f":"$C$43","v":609}]
[null,"Standard rate - Level 3.2-3.6",{"$f":"$C$44","v":705}]
[null,"Rural rate - Level 3.2-3.6",{"$f":"$C$45","v":874}]
[null,"Pre-Purchased Places"]
[null,"Pre-Purchased Places",{"$f":"$C$47","v":6966}]
[]
[null,"*Services that are signatories to the Early Childhood Enterprise Agreements are services that will sign the new Victorian"]
[null,"Early Childhood Teachers’ and Educators’ Agreement (VECTEA) or the Early Education Employees’ Agreement (EEEA)."]
[]
[null,"**ESK Standard and Rural enrolments will be funded at the same rate"]
[]
[]
[null,"***The ESK ratio supplement will be paid at a rate equivalent to the Standard Ratio Supplement as a proportion of the ESK"]
[null,"Ratio Supplement is included in the Free Kinder funding rate."]
[]
[null,"The same rates apply to funded three-year-old and four-year-old enrolments in programs of 15 hours per week. For"]
[null,"services in funded Three-Year-Old Kindergarten roll-out areas and delivering a funded Three-Year-Old Kindergarten"]
[null,"program between five and 15 hours, child level funding will be provided on a prorated basis. For example, a kindergarten"]
[null,"delivering a ten hour Three-Year-old Kindergarten program will receive two thirds of the applicable rate of funding"]
[null,"available."]
[]
[null,"Table 4 - Services not operating under the Early Childhood Enterprise Agreements and opt-in to Free Kinder"]
[]
[null,2025]
[]
[]
[null,null,2025]
[null,"Per capita - Non-EA services"]
[null,"Standard per capita - non-EA services",{"$f":"$C$71","v":3831}]
[null,"Rural per capita - non-EA services",{"$f":"$C$72","v":4737}]
[null,"Independent schools Standard",{"$f":"$C$73","v":3831}]
[null,"Independent schools Type 1",{"$f":"$C$74","v":672}]
[null,"Independent schools Type 2",{"$f":"$C$75","v":2181}]
[null,"Free Kindergarten Funding"]
[null,"Free Kindergarten Funding",2627]
[null,"Early Start Kindergarten and Access to Early Learning*"]
[null,"ESK Standard",{"$f":"$C$79","v":6966}]
[null,"ESK Rural",{"$f":"$C$80","v":7993}]
[null,"ESK Extension (equivalent to KFS)",0]
[null,"Ratio Supplement"]
[null,"Ratio Supplement - Standard",{"$f":"$C$83","v":571}]
[null,"Ratio Supplement - ESK**",{"$f":"$C$85","v":571}]
[null,"Pre-Purchased Places***"]
[null,"Pre-Purchased Places",{"$f":"$C$87","v":6966}]
[]
[null,"*ESK Standard and Rural enrolments will be funded at the same rate"]
[]
[]
[null,"** The ESK ratio supplement will be paid at a rate equivalent to the Standard Ratio Supplement as a proportion of the ESK"]
[]
[]
[null,"***All PPP enrolments will be funded at the EA rate."]
[]
[null,"The same rates apply to funded three-year-old and four-year-old enrolments in programs of 15 hours per week. For"]
[null,"services in funded Three-Year-Old Kindergarten roll-out areas and delivering a funded Three-Year-Old Kindergarten"]
[null,"program between five and 15 hours, child level funding will be provided on a prorated basis. For example, a kindergarten"]
[null,"delivering a ten hour Three-Year-old Kindergarten program will receive two thirds of the applicable rate of funding"]
[null,"available."]
[]
[null,"Table 5 - Early Years Management"]
[]
[null,null,"Jan-Dec"]
[null,null,2025]
[null,"Annual grant: sessional kindergarten services",18963]
[null,"Annual grant: long day care services",11751]
[null,"Additional Support loading \n(for sessional services in rural and/or disadvantaged services) ",3782]
[null,"Start-up grant (100% of annual grant depending on service type)","$18,963 / $11,751"]
[null,"Transition grant (100% of annual grant)","$18,963/ $11,751"]
[null,"New provider grant (for newly established and","up to $78,797"]
[null,"approved Early Years Management organisations)"]