{"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","2024 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":false,"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,'2024 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":2083}]
[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":2083}]
[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":2083}]
[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":2083}]
[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":2083}]
[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,"2023 Funding Rates"]
[]
[null,"Salary On Costs",null,null,"L 2.5 Supplement",null,null,null,null,"2024 Rates"]
[null,"Workcover",1.4999999999999999E-2,null,"Standard (Grant - excl, GST)",{"$f":"IF(OR($O$7=\"T1\",$O$7=\"T3\"),'2024 Funding Rates'!$C$40,0)","v":275},null,"Ratio Supplement - Standard",null,{"$f":"IF($O$7=\"T1\",'2024 Funding Rates'!$C$36,IF($O$7=\"T2\",'2024 Funding Rates'!$C$83,IF($O$7=\"T3\",'2024 Funding Rates'!$C$119,IF($O$7=\"T4\",'2024 Funding Rates'!$C$165))))","v":557}]
[null,"Superannuation",0.115,null,"Rural (Grant - excl. GST)",{"$f":"IF(OR($O$7=\"T1\",$O$7=\"T3\"),'2024 Funding Rates'!$C$42,0)","v":340},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\",'2024 Funding Rates'!$C$37,IF($O$7=\"T2\",'2024 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\"),'2024 Funding Rates'!$C$41,0)","v":482}]
[null,"Accident Mark Up",4.0000000000000001E-3,null,"Rural",{"$f":"IF(OR($O$7=\"T1\",$O$7=\"T3\"),'2024 Funding Rates'!$C$43,0)","v":594},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\",'2024 Funding Rates'!$C$27,IF($O$7=\"T2\",'2024 Funding Rates'!$C$71,IF($O$7=\"T3\",'2024 Funding Rates'!$C$110,IF($O$7=\"T4\",'2024 Funding Rates'!$C$153))))","v":4233}]
[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\",'2024 Funding Rates'!$C$28,IF($O$7=\"T2\",'2024 Funding Rates'!$C$72,IF($O$7=\"T3\",'2024 Funding Rates'!$C$111,IF($O$7=\"T4\",'2024 Funding Rates'!$C$154))))","v":5235}]
[null,null,null,null,"Standard (Grant - excl, GST)",{"$f":"IF(OR($O$7=\"T1\",$O$7=\"T3\"),'2024 Funding Rates'!$C$44,0)","v":688},null,"Kindergarten Fee Subsidy",null,{"$f":"IF(OR($O$7=\"T3\",$O$7=\"T4\"),0,'2024 Funding Rates'!$C$77)","v":2083}]
[null,"Provision for Bad Debts",0.05,null,"Rural (Grant - excl. GST)",{"$f":"IF(OR($O$7=\"T1\",$O$7=\"T3\"),'2024 Funding Rates'!$C$45,0)","v":853}]
[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\",'2024 Funding Rates'!$C$113,'2024 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":4233},{"$f":"Profile!$J$43","v":5235},{"$f":"$D$5","v":5235},null,null,{"$f":"Profile!$F$36","v":275},{"$f":"Profile!$F$37","v":340},null,null,{"$f":"Profile!$F$40","v":482},{"$f":"Profile!$F$41","v":594},null,null,{"$f":"Profile!$F$44","v":688},{"$f":"Profile!$F$45","v":853}]
[null,1,{"$f":"$B6*C$5","v":4233},{"$f":"$B6*D$5","v":5235},{"$f":"$B6*E$5","v":5235},null,1,{"$f":"$G6*H$5","v":275},{"$f":"$G6*I$5","v":340},null,1,{"$f":"$K6*L$5","v":482},{"$f":"$K6*M$5","v":594},null,1,{"$f":"$O6*P$5","v":688},{"$f":"$O6*Q$5","v":853}]
[null,2,{"$f":"$B7*C$5","v":8466},10470,10470,null,2,{"$f":"$G7*H$5","v":550},680,null,2,{"$f":"$K7*L$5","v":964},1188,null,2,{"$f":"$O7*P$5","v":1376},1706]
[null,3,12699,15705,15705,null,3,825,1020,null,3,1446,1782,null,3,2064,2559]
[null,4,16932,20940,20940,null,4,1100,1360,null,4,1928,2376,null,4,2752,3412]
[null,5,21165,26175,26175,null,5,1375,1700,null,5,2410,2970,null,5,3440,4265]
[null,6,25398,31410,31410,null,6,1650,2040,null,6,2892,3564,null,6,4128,5118]
[null,7,29631,36645,36645,null,7,1925,2380,null,7,3374,4158,null,7,4816,5971]
[null,8,33864,41880,41880,null,8,2200,2720,null,8,3856,4752,null,8,5504,6824]
[null,9,38097,47115,47115,null,9,2475,3060,null,9,4338,5346,null,9,6192,7677]
[null,10,42330,52350,52350,null,10,2750,3400,null,10,4820,5940,null,10,6880,8530]
[null,11,46563,57585,57585,null,11,3025,3740,null,11,5302,6534,null,11,7568,9383]
[null,12,50796,62820,62820,null,12,3300,4080,null,12,5784,7128,null,12,8256,10236]
[null,13,55029,68055,68055,null,13,3575,4420,null,13,6266,7722,null,13,8944,11089]
[null,14,59262,73290,73290,null,14,3850,4760,null,14,6748,8316,null,14,9632,11942]
[null,15,63495,78525,78525,null,15,4125,5100,null,15,7230,8910,null,15,10320,12795]
[null,16,67728,83760,83760,null,16,4400,5440,null,16,7712,9504,null,16,11008,13648]
[null,17,71961,88995,88995,null,17,4675,5780,null,17,8194,10098,null,17,11696,14501]
[null,18,76194,94230,94230,null,18,4950,6120,null,18,8676,10692,null,18,12384,15354]
[null,19,80427,99465,{"$f":"$B24*D$5","v":99465},null,19,5225,6460,null,19,9158,11286,null,19,13072,16207]
[null,20,84660,104700,104700,null,20,5500,6800,null,20,9640,11880,null,20,13760,17060]
[null,21,88893,109935,109935,null,21,5775,7140,null,21,10122,12474,null,21,14448,17913]
[null,22,93126,115170,115170,null,22,6050,7480,null,22,10604,13068,null,22,15136,18766]
[null,23,97359,120405,120405,null,23,6325,7820,null,23,11086,13662,null,23,15824,19619]
[null,24,101592,125640,125640,null,24,6600,8160,null,24,11568,14256,null,24,16512,20472]
[null,25,105825,130875,130875,null,25,6875,8500,null,25,12050,14850,null,25,17200,21325]
[null,26,110058,136110,136110,null,26,7150,8840,null,26,12532,15444,null,26,17888,22178]
[null,27,114291,141345,141345,null,27,7425,9180,null,27,13014,16038,null,27,18576,23031]
[null,28,118524,146580,146580,null,28,7700,9520,null,28,13496,16632,null,28,19264,23884]
[null,29,122757,151815,151815,null,29,7975,9860,null,29,13978,17226,null,29,19952,24737]
[null,30,126990,157050,157050,null,30,8250,10200,null,30,14460,17820,null,30,20640,25590]
[null,31,131223,162285,162285,null,31,8525,10540,null,31,14942,18414,null,31,21328,26443]
[null,32,135456,167520,167520,null,32,8800,10880,null,32,15424,19008,null,32,22016,27296]
[null,33,139689,172755,172755,null,33,9075,11220,null,33,15906,19602,null,33,22704,28149]
[null,34,143922,177990,177990,null,34,9350,11560,null,34,16388,20196,null,34,{"$f":"$O39*P$5","v":23392},29002]
[null,35,148155,183225,183225,null,35,9625,11900,null,35,16870,20790,null,35,24080,29855]
[null,36,152388,188460,188460,null,36,9900,12240,null,36,17352,21384,null,36,24768,30708]
[null,37,156621,193695,193695,null,37,10175,12580,null,37,17834,21978,null,37,25456,31561]
[null,38,160854,198930,198930,null,38,10450,12920,null,38,18316,22572,null,38,26144,32414]
[null,39,165087,204165,204165,null,39,10725,13260,null,39,18798,23166,null,39,26832,33267]
[null,40,169320,209400,209400,null,40,11000,13600,null,40,19280,23760,null,40,27520,34120]
[null,41,173553,214635,214635,null,41,11275,13940,null,41,19762,24354,null,41,28208,34973]
[null,42,177786,219870,219870,null,42,11550,14280,null,42,20244,24948,null,42,28896,35826]
[null,43,182019,225105,225105,null,43,11825,14620,null,43,20726,25542,null,43,29584,36679]
[null,44,186252,230340,230340,null,44,12100,14960,null,44,21208,26136,null,44,30272,37532]
[null,45,190485,235575,235575,null,45,12375,15300,null,45,21690,26730,null,45,30960,38385]
[null,46,194718,{"$f":"$D$50+($B51-45)*C$5","v":239808},{"$f":"$D51","v":239808},null,46,12650,15640,null,46,22172,{"$f":"$M$50+($K51-45)*L$5","v":27212},null,46,31648,39238]
[null,47,198951,244041,{"$f":"$D52","v":244041},null,47,12925,15980,null,47,{"$f":"$K52*L$5","v":22654},27694,null,47,32336,40091]
[null,48,203184,248274,248274,null,48,13200,16320,null,48,23136,28176,null,48,33024,40944]
[null,49,207417,252507,252507,null,49,13475,16660,null,49,23618,28658,null,49,33712,41797]
[null,50,211650,256740,256740,null,50,13750,17000,null,50,24100,29140,null,50,34400,42650]
[null,51,215883,260973,260973,null,51,14025,17340,null,51,24582,29622,null,51,35088,43503]
[null,52,220116,265206,265206,null,52,14300,17680,null,52,25064,30104,null,52,35776,44356]
[null,53,224349,269439,269439,null,53,14575,18020,null,53,25546,30586,null,53,36464,45209]
[null,54,228582,273672,273672,null,54,14850,18360,null,54,26028,31068,null,54,37152,46062]
[null,55,232815,277905,277905,null,55,15125,18700,null,55,26510,31550,null,55,37840,46915]
[null,56,237048,282138,282138,null,56,15400,19040,null,56,26992,32032,null,56,38528,47768]
[null,57,241281,286371,286371,null,57,15675,19380,null,57,27474,32514,null,57,39216,48621]
[null,58,245514,290604,290604,null,58,15950,19720,null,58,27956,32996,null,58,39904,49474]
[null,59,249747,294837,294837,null,59,16225,20060,null,59,28438,33478,null,59,40592,50327]
[null,60,253980,299070,299070,null,60,16500,20400,null,60,28920,33960,null,60,41280,51180]
[null,61,258213,303303,303303,null,61,16775,20740,null,61,29402,34442,null,61,41968,52033]
[null,62,262446,307536,307536,null,62,17050,21080,null,62,29884,34924,null,62,42656,52886]
[null,63,266679,311769,311769,null,63,17325,21420,null,63,30366,35406,null,63,43344,53739]
[null,64,270912,316002,316002,null,64,17600,21760,null,64,30848,35888,null,64,44032,54592]
[null,65,275145,320235,320235,null,65,17875,22100,null,65,31330,36370,null,65,44720,55445]
[null,66,{"$f":"$B71*C$5","v":279378},324468,324468,null,66,{"$f":"$G71*H$5","v":18150},22440,null,66,31812,36852,null,66,{"$f":"$O71*P$5","v":45408},56298]
[null,67,283611,328701,328701,null,67,18425,22780,null,67,32294,37334,null,67,46096,57151]
[null,68,287844,332934,332934,null,68,18700,23120,null,68,32776,37816,null,68,46784,58004]
[null,69,292077,337167,337167,null,69,18975,23460,null,69,33258,38298,null,69,47472,58857]
[null,70,296310,341400,341400,null,70,19250,23800,null,70,33740,38780,null,70,48160,59710]
[null,71,300543,345633,345633,null,71,19525,24140,null,71,34222,39262,null,71,48848,60563]
[null,72,304776,349866,349866,null,72,19800,24480,null,72,34704,39744,null,72,49536,61416]
[null,73,309009,354099,354099,null,73,20075,24820,null,73,35186,40226,null,73,50224,62269]
[null,74,313242,358332,358332,null,74,20350,25160,null,74,35668,40708,null,74,50912,63122]
[null,75,317475,362565,362565,null,75,20625,25500,null,75,36150,41190,null,75,51600,63975]
[null,76,321708,366798,366798,null,76,20900,25840,null,76,36632,41672,null,76,52288,64828]
[null,77,325941,371031,371031,null,77,21175,26180,null,77,37114,42154,null,77,52976,65681]
[null,78,330174,{"$f":"$D$50+($B83-45)*C$5","v":375264},375264,null,78,21450,26520,null,78,37596,{"$f":"$M$50+($K83-45)*L$5","v":42636},null,78,53664,66534]
[null,79,334407,379497,379497,null,79,21725,26860,null,79,38078,43118,null,79,54352,67387]
[null,80,338640,383730,383730,null,80,22000,27200,null,80,38560,43600,null,80,55040,68240]
[null,81,342873,387963,387963,null,81,22275,27540,null,81,39042,44082,null,81,55728,69093]
[null,82,347106,392196,392196,null,82,22550,27880,null,82,39524,44564,null,82,56416,69946]
[null,83,351339,396429,396429,null,83,22825,28220,null,83,40006,45046,null,83,57104,70799]
[null,84,355572,400662,400662,null,84,23100,28560,null,84,40488,45528,null,84,57792,71652]
[null,85,359805,404895,404895,null,85,23375,28900,null,85,40970,46010,null,85,58480,72505]
[null,86,364038,409128,409128,null,86,23650,29240,null,86,41452,46492,null,86,59168,73358]
[null,87,368271,413361,413361,null,87,23925,29580,null,87,41934,46974,null,87,59856,74211]
[null,88,372504,417594,417594,null,88,24200,29920,null,88,42416,47456,null,88,60544,75064]
[null,89,376737,421827,421827,null,89,24475,30260,null,89,42898,47938,null,89,61232,75917]
[null,90,380970,426060,426060,null,90,24750,30600,null,90,43380,48420,null,90,61920,76770]
[null,91,385203,430293,430293,null,91,25025,30940,null,91,43862,48902,null,91,62608,77623]
[null,92,389436,434526,434526,null,92,25300,31280,null,92,44344,49384,null,92,63296,78476]
[null,93,393669,438759,438759,null,93,25575,31620,null,93,44826,49866,null,93,63984,79329]
[null,94,397902,442992,442992,null,94,25850,31960,null,94,45308,50348,null,94,64672,80182]
[null,95,402135,447225,447225,null,95,26125,32300,null,95,45790,50830,null,95,65360,81035]
[null,96,406368,451458,451458,null,96,26400,32640,null,96,46272,51312,null,96,66048,81888]
[null,97,410601,455691,455691,null,97,26675,32980,null,97,46754,51794,null,97,66736,82741]
[null,98,414834,459924,459924,null,98,26950,33320,null,98,47236,52276,null,98,{"$f":"$O103*P$5","v":67424},83594]
[null,99,419067,464157,464157,null,99,27225,33660,null,99,47718,52758,null,99,68112,84447]
[null,100,423300,468390,468390,null,100,27500,34000,null,100,48200,53240,null,100,68800,85300]
[null,101,427533,472623,472623,null,101,27775,34340,null,101,48682,53722,null,101,69488,86153]
[null,102,431766,476856,476856,null,102,28050,34680,null,102,49164,54204,null,102,70176,87006]
[null,103,435999,481089,481089,null,103,28325,35020,null,103,49646,54686,null,103,70864,87859]
[null,104,440232,485322,485322,null,104,28600,35360,null,104,50128,55168,null,104,71552,88712]
[null,105,444465,489555,489555,null,105,28875,35700,null,105,50610,55650,null,105,72240,89565]
[null,106,448698,493788,493788,null,106,29150,36040,null,106,51092,56132,null,106,72928,90418]
[null,107,452931,498021,498021,null,107,29425,36380,null,107,51574,56614,null,107,73616,91271]
[null,108,457164,502254,502254,null,108,29700,36720,null,108,52056,57096,null,108,74304,92124]
[null,109,461397,506487,506487,null,109,29975,37060,null,109,52538,57578,null,109,74992,92977]
[null,110,465630,{"$f":"$D$50+($B115-45)*C$5","v":510720},510720,null,110,30250,37400,null,110,53020,{"$f":"$M$50+($K115-45)*L$5","v":58060},null,110,75680,93830]
[null,111,469863,514953,{"$f":"$D116","v":514953},null,111,30525,37740,null,111,{"$f":"$K116*L$5","v":53502},58542,null,111,76368,94683]
[null,112,474096,519186,519186,null,112,30800,38080,null,112,53984,59024,null,112,77056,95536]
[null,113,478329,523419,523419,null,113,31075,38420,null,113,54466,59506,null,113,77744,96389]
[null,114,482562,527652,527652,null,114,31350,38760,null,114,54948,59988,null,114,78432,97242]
[null,115,486795,531885,531885,null,115,31625,39100,null,115,55430,60470,null,115,79120,98095]
[null,116,491028,536118,536118,null,116,31900,39440,null,116,55912,60952,null,116,79808,98948]
[null,117,495261,540351,540351,null,117,32175,39780,null,117,56394,61434,null,117,80496,99801]
[null,118,499494,544584,544584,null,118,32450,40120,null,118,56876,61916,null,118,81184,100654]
[null,119,503727,548817,548817,null,119,32725,40460,null,119,57358,62398,null,119,81872,101507]
[null,120,507960,553050,553050,null,120,33000,40800,null,120,57840,62880,null,120,82560,102360]
[null,121,512193,557283,557283,null,121,33275,41140,null,121,58322,63362,null,121,83248,103213]
[null,122,516426,561516,561516,null,122,33550,41480,null,122,58804,63844,null,122,83936,104066]
[null,123,520659,565749,565749,null,123,33825,41820,null,123,59286,64326,null,123,84624,104919]
[null,124,524892,569982,569982,null,124,34100,42160,null,124,59768,64808,null,124,85312,105772]
[null,125,529125,574215,574215,null,125,34375,42500,null,125,60250,65290,null,125,86000,106625]
[null,126,533358,578448,578448,null,126,34650,42840,null,126,60732,65772,null,126,86688,107478]
[null,127,537591,582681,582681,null,127,34925,43180,null,127,61214,66254,null,127,87376,108331]
[null,128,541824,586914,586914,null,128,35200,43520,null,128,61696,66736,null,128,88064,109184]
[null,129,546057,591147,591147,null,129,35475,43860,null,129,62178,67218,null,129,88752,110037]
[null,130,{"$f":"$B135*C$5","v":550290},595380,595380,null,130,{"$f":"$G135*H$5","v":35750},44200,null,130,62660,67700,null,130,{"$f":"$O135*P$5","v":89440},110890]
[null,131,554523,599613,599613,null,131,36025,44540,null,131,63142,68182,null,131,90128,111743]
[null,132,558756,603846,603846,null,132,36300,44880,null,132,63624,68664,null,132,90816,112596]
[null,133,562989,608079,608079,null,133,36575,45220,null,133,64106,69146,null,133,91504,113449]
[null,134,567222,612312,612312,null,134,36850,45560,null,134,64588,69628,null,134,92192,114302]
[null,135,571455,616545,616545,null,135,37125,45900,null,135,65070,70110,null,135,92880,115155]
[null,136,575688,620778,620778,null,136,37400,46240,null,136,65552,70592,null,136,93568,116008]
[null,137,579921,625011,625011,null,137,37675,46580,null,137,66034,71074,null,137,94256,116861]
[null,138,584154,629244,629244,null,138,37950,46920,null,138,66516,71556,null,138,94944,117714]
[null,139,588387,633477,633477,null,139,38225,47260,null,139,66998,72038,null,139,95632,118567]
[null,140,592620,637710,637710,null,140,38500,47600,null,140,67480,72520,null,140,96320,119420]
[null,141,596853,641943,641943,null,141,38775,47940,null,141,67962,73002,null,141,97008,120273]
[null,142,601086,{"$f":"$D$50+($B147-45)*C$5","v":646176},646176,null,142,39050,48280,null,142,68444,{"$f":"$M$50+($K147-45)*L$5","v":73484},null,142,97696,121126]
[null,143,605319,650409,650409,null,143,39325,48620,null,143,68926,73966,null,143,98384,121979]
[null,144,609552,654642,654642,null,144,39600,48960,null,144,69408,74448,null,144,99072,122832]
[null,145,613785,658875,658875,null,145,39875,49300,null,145,69890,74930,null,145,99760,123685]
[null,146,618018,663108,663108,null,146,40150,49640,null,146,70372,75412,null,146,100448,124538]
[null,147,622251,667341,667341,null,147,40425,49980,null,147,70854,75894,null,147,101136,125391]
[null,148,626484,671574,671574,null,148,40700,50320,null,148,71336,76376,null,148,101824,126244]
[null,149,630717,675807,675807,null,149,40975,50660,null,149,71818,76858,null,149,102512,127097]
[null,150,634950,680040,680040,null,150,41250,51000,null,150,72300,77340,null,150,103200,127950]
[null,151,639183,684273,684273,null,151,41525,51340,null,151,72782,77822,null,151,103888,128803]
[null,152,643416,688506,688506,null,152,41800,51680,null,152,73264,78304,null,152,104576,129656]
[null,153,647649,692739,692739,null,153,42075,52020,null,153,73746,78786,null,153,105264,130509]
[null,154,651882,696972,696972,null,154,42350,52360,null,154,74228,79268,null,154,105952,131362]
[null,155,656115,701205,701205,null,155,42625,52700,null,155,74710,79750,null,155,106640,132215]
[null,156,660348,705438,705438,null,156,42900,53040,null,156,75192,80232,null,156,107328,133068]
[null,157,664581,709671,709671,null,157,43175,53380,null,157,75674,80714,null,157,108016,133921]
[null,158,668814,713904,713904,null,158,43450,53720,null,158,76156,81196,null,158,108704,134774]
[null,159,673047,718137,718137,null,159,43725,54060,null,159,76638,81678,null,159,109392,135627]
[null,160,677280,722370,722370,null,160,44000,54400,null,160,77120,82160,null,160,110080,136480]
[null,161,681513,726603,726603,null,161,44275,54740,null,161,77602,82642,null,161,110768,137333]
[null,162,685746,730836,730836,null,162,44550,55080,null,162,78084,83124,null,162,{"$f":"$O167*P$5","v":111456},138186]
[null,163,689979,735069,735069,null,163,44825,55420,null,163,78566,83606,null,163,112144,139039]
[null,164,694212,739302,739302,null,164,45100,55760,null,164,79048,84088,null,164,112832,139892]
[null,165,698445,743535,743535,null,165,45375,56100,null,165,79530,84570,null,165,113520,140745]
[null,166,702678,747768,747768,null,166,45650,56440,null,166,80012,85052,null,166,114208,141598]
[null,167,706911,752001,752001,null,167,45925,56780,null,167,80494,85534,null,167,114896,142451]
[null,168,711144,756234,756234,null,168,46200,57120,null,168,80976,86016,null,168,115584,143304]
[null,169,715377,760467,760467,null,169,46475,57460,null,169,81458,86498,null,169,116272,144157]
[null,170,719610,764700,764700,null,170,46750,57800,null,170,81940,86980,null,170,116960,145010]
[null,171,723843,768933,768933,null,171,47025,58140,null,171,82422,87462,null,171,117648,145863]
[null,172,728076,773166,773166,null,172,47300,58480,null,172,82904,87944,null,172,118336,146716]
[null,173,732309,777399,777399,null,173,47575,58820,null,173,83386,88426,null,173,119024,147569]
[null,174,736542,{"$f":"$D$50+($B179-45)*C$5","v":781632},781632,null,174,47850,59160,null,174,83868,{"$f":"$M$50+($K179-45)*L$5","v":88908},null,174,119712,148422]
[null,175,740775,785865,{"$f":"$D180","v":785865},null,175,48125,59500,null,175,{"$f":"$K180*L$5","v":84350},89390,null,175,120400,149275]
[null,176,745008,790098,790098,null,176,48400,59840,null,176,84832,89872,null,176,121088,150128]
[null,177,749241,794331,794331,null,177,48675,60180,null,177,85314,90354,null,177,121776,150981]
[null,178,753474,798564,798564,null,178,48950,60520,null,178,85796,90836,null,178,122464,151834]
[null,179,757707,802797,802797,null,179,49225,60860,null,179,86278,91318,null,179,123152,152687]
[null,180,761940,807030,807030,null,180,49500,61200,null,180,86760,91800,null,180,123840,153540]
[null,181,766173,811263,811263,null,181,49775,61540,null,181,87242,92282,null,181,124528,154393]
[null,182,770406,815496,815496,null,182,50050,61880,null,182,87724,92764,null,182,125216,155246]
[null,183,774639,819729,819729,null,183,50325,62220,null,183,88206,93246,null,183,125904,156099]
[null,184,778872,823962,823962,null,184,50600,62560,null,184,88688,93728,null,184,126592,156952]
[null,185,783105,828195,828195,null,185,50875,62900,null,185,89170,94210,null,185,127280,157805]
[null,186,787338,832428,832428,null,186,51150,63240,null,186,89652,94692,null,186,127968,158658]
[null,187,791571,836661,836661,null,187,51425,63580,null,187,90134,95174,null,187,128656,159511]
[null,188,795804,840894,840894,null,188,51700,63920,null,188,90616,95656,null,188,129344,160364]
[null,189,800037,845127,845127,null,189,51975,64260,null,189,91098,96138,null,189,130032,161217]
[null,190,804270,849360,849360,null,190,52250,64600,null,190,91580,96620,null,190,130720,162070]
[null,191,808503,853593,853593,null,191,52525,64940,null,191,92062,97102,null,191,131408,162923]
[null,192,812736,857826,857826,null,192,52800,65280,null,192,92544,97584,null,192,132096,163776]
[null,193,816969,862059,862059,null,193,53075,65620,null,193,93026,98066,null,193,132784,164629]
[null,194,{"$f":"$B199*C$5","v":821202},866292,866292,null,194,{"$f":"$G199*H$5","v":53350},65960,null,194,93508,98548,null,194,133472,165482]
[null,195,825435,870525,870525,null,195,53625,66300,null,195,93990,99030,null,195,134160,166335]
[null,196,829668,874758,874758,null,196,53900,66640,null,196,94472,99512,null,196,134848,167188]
[null,197,833901,878991,878991,null,197,54175,66980,null,197,94954,99994,null,197,135536,168041]
[null,198,838134,883224,883224,null,198,54450,67320,null,198,95436,100476,null,198,136224,168894]
[null,199,842367,887457,887457,null,199,54725,67660,null,199,95918,100958,null,199,136912,169747]
[null,200,846600,891690,891690,null,200,55000,68000,null,200,96400,101440,null,200,137600,170600]

{"sheet":"2024 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,"2024 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,2024]
[]
[]
[null,null,2024]
[null,"Per capita - EA services*"]
[null,"Standard per capita - EA services",4233]
[null,"Rural per capita - EA services",5235]
[null,"Kindergarten Fee Subsidy"]
[null,"Kindergarten Fee Subsidy",2083]
[null,"Early Start Kindergarten and Access to Early Learning**"]
[null,"ESK Standard",6796]
[null,"ESK Rural",7798]
[null,"ESK Extension (equivalent to KFS)",2083]
[null,"Ratio Supplement"]
[null,"Ratio Supplement - Standard",557]
[null,"Ratio Supplement - KFS",0]
[null,"Ratio Supplement - ESK***",557]
[null,"Early Childhood Teacher Supplement"]
[null,"Standard rate - Level 2.5",275]
[null,"Standard rate - Level 3.1",482]
[null,"Rural rate - Level 2.5",340]
[null,"Rural rate - Level 3.1",594]
[null,"Standard rate - Level 3.2-3.6",688]
[null,"Rural rate - Level 3.2-3.6",853]
[null,"Pre-Purchased Places"]
[null,"Pre-Purchased Places",6796]
[]
[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,2024]
[]
[]
[null,null,2024]
[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",656]
[null,"Independent schools Type 2",2128]
[null,"Kindergarten Fee Subsidy"]
[null,"Kindergarten Fee Subsidy",2083]
[null,"Early Start Kindergarten and Access to Early Learning*"]
[null,"ESK Standard",6796]
[null,"ESK Rural",7798]
[null,"ESK Extension (equivalent to KFS)",2083]
[null,"Ratio Supplement"]
[null,"Ratio Supplement - Standard",557]
[null,"Ratio Supplement - KFS",0]
[null,"Ratio Supplement - ESK**",557]
[null,"Pre-Purchased Places***"]
[null,"Pre-Purchased Places",6796]
[]
[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,2024]
[]
[]
[null,null,2024]
[null,"Per capita - EA services*"]
[null,"Standard per capita - EA services",4233]
[null,"Rural per capita - EA services",5235]
[null,"Free Kindergarten Funding"]
[null,"Free Kindergarten Funding",2563]
[null,"Early Start Kindergarten and Access to Early Learning**"]
[null,"ESK Standard",{"$f":"$C$32","v":6796}]
[null,"ESK Rural",{"$f":"$C$33","v":7798}]
[null,"ESK Extension (equivalent to KFS)",0]
[null,"Ratio Supplement"]
[null,"Ratio Supplement - Standard",{"$f":"$C$36","v":557}]
[null,"Ratio Supplement - ESK***",{"$f":"$C$38","v":557}]
[null,"Early Childhood Teacher Supplement"]
[null,"Standard rate - Level 2.5",{"$f":"$C$40","v":275}]
[null,"Standard rate - Level 3.1",482]
[null,"Rural rate - Level 2.5",{"$f":"$C$42","v":340}]
[null,"Rural rate - Level 3.1",{"$f":"$C$43","v":594}]
[null,"Standard rate - Level 3.2-3.6",{"$f":"$C$44","v":688}]
[null,"Rural rate - Level 3.2-3.6",{"$f":"$C$45","v":853}]
[null,"Pre-Purchased Places"]
[null,"Pre-Purchased Places",{"$f":"$C$47","v":6796}]
[]
[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,2024]
[]
[]
[null,null,2024]
[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":656}]
[null,"Independent schools Type 2",{"$f":"$C$75","v":2128}]
[null,"Free Kindergarten Funding"]
[null,"Free Kindergarten Funding",2563]
[null,"Early Start Kindergarten and Access to Early Learning*"]
[null,"ESK Standard",{"$f":"$C$79","v":6796}]
[null,"ESK Rural",{"$f":"$C$80","v":7798}]
[null,"ESK Extension (equivalent to KFS)",0]
[null,"Ratio Supplement"]
[null,"Ratio Supplement - Standard",{"$f":"$C$83","v":557}]
[null,"Ratio Supplement - ESK**",{"$f":"$C$85","v":557}]
[null,"Pre-Purchased Places***"]
[null,"Pre-Purchased Places",{"$f":"$C$87","v":6796}]
[]
[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,2023]
[null,"Annual grant: sessional kindergarten services",15785]
[null,"Annual grant: long day care services",11239]
[null,"Additional Support loading \n(for sessional services in rural and/or disadvantaged services) ",3600]
[null,"Start-up grant (100% of annual grant depending on service type)","$15,785 / $11,239"]
[null,"Transition grant (100% of annual grant)","$15,785 / $11,239"]
[null,"New provider grant (for newly established and","up to $75,000"]
[null,"approved Early Years Management organisations)"]