{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["A-Budget Summary","C-CERT Staff","D-CLASS Staff","MSOC","B-ADMIN Staff","SAL_BEN_INFO","menus","Indirect Rates"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":75,"comments":2,"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":"A-Budget Summary","index":0,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[null,"KENT SCHOOL DISTRICT #415"]
[null,"2019-20 BUDGET DEVELOPMENT",null,null,null,null,null,null,"BUDGET BUILDER 2019-20"]
[null,"PROGRAM, DEPARTMENT and BUILDING ALLOCATIONS"]
[]
[]
[null,null,"Select from pull-down menus:",null,null,"Included worksheets:"]
[null,"Program Manager:","Popp, Rona",null,null,"TAB A - Budget Summary"]
[null,"Program:","Title 1 - Prog 5150",null,null,"TAB B - Administrative staffing detail and costs"]
[null,"Dept/Location:","719-Student & Family Support",null,null,"TAB C - Certificated/Instructional staffing detail and costs"]
[null,"Building Location (if applicable):","136-Kent",null,null,"TAB D - Classified staffing detail and costs"]
[null,"Cost Center:","Kent",null,null,"TAB E - MSOC detail and costs"]
[]
[null,"Prgm Start Date:","2019-09-01"]
[null,"Prgm End Date:","2020-08-31"]
[]
[null,"Source of Funding:"]
[null,"Revenue Type:"]
[]
[]
[]
[]
[null,"2019-20  Budget Allocation:",297992,"        Enter BUDGET ALLOCATION here"]
[]
[null,"Expenditure Budget:"]
[null,"Salaries & Benefits:",null,"FTE:"]
[null,"Certificated Staff",{"$f":"'B-ADMIN Staff'!Q39+'C-CERT Staff'!R49","v":133321.29123734412},{"$f":"'B-ADMIN Staff'!P25+'C-CERT Staff'!P24","v":1}]
[null,"Classified Staff",{"$f":"'D-CLASS Staff'!P53","v":122444.36601196154},{"$f":"'D-CLASS Staff'!O29","v":1.6355769230769228}]
[null,"Total Personnel Costs",{"$f":"SUM(C26:C27)","v":255765.65724930566},{"$f":"SUM(D26:D27)","v":2.6355769230769228}]
[]
[]
[null,"Total Non-Personnel Costs / MSOC",{"$f":"MSOC!C29","v":42226}]
[]
[null,"Indirect Rate",0,"        Enter indirect rate here",null,null,null,"Last Updated:",{"$f":"TODAY()","v":"2020-04-03"}]
[null,"Indirect Costs",{"$f":"(C22-ROUNDUP(C22/(100%+C33),0))","v":0}]
[]
[null,"Total Expenditure Budget:"]
[null,"Personnel, Non-Personnel, Indirects",{"$f":"C28+C31+C34","v":297991.65724930563},null,"Submitted By:","Mickey Mouse","Date:","2019-05-17","(Preparer)"]
[null,null,null,null,"Reviewed By:","Minnie Mouse","Date:",null,"(Reviewer)"]
[null,"(Over) / Under Allocated",{"$f":"(C22-C37)","v":0.34275069436989725},null,"Approved By:","Rona Popp","Date:",null,"(Prgm Mgr)"]
[null,null,null,null,"Received By:",null,"Date:",null,"(Budget/Finance)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"                                                      "]

{"sheet":"C-CERT Staff","index":1,"n_rows":49,"n_cols":28,"rows_kept":49,"cut":false,"hidden":false,"merged":[[8,3,8,4],[8,19,8,25],[8,17,9,17],[8,6,8,10]]}
[null,"PRGM MGR",{"$f":"'A-Budget Summary'!C7","v":"Popp, Rona"}]
[null,"PROGRAM",{"$f":"'A-Budget Summary'!C8","v":"Title 1 - Prog 5150"}]
[null,"LOC/DEPT",{"$f":"'A-Budget Summary'!C9","v":"719-Student & Family Support"}]
[null,"LOC/SCHOOL",{"$f":"'A-Budget Summary'!C10","v":"136-Kent"}]
[null,"COST CENTER",{"$f":"'A-Budget Summary'!C11","v":"Kent"}]
[]
[null,"CERTIFICATED INSTRUCTIONAL SALARY DETAIL "]
[]
[null,null,null,"Employee",null,null,"PLEASE ENTER THIS DATA",null,null,null,null,null,null,"Total Base",null,null,null,"Total Salary ",null,"Account Code"]
[null,"Position/Title",null,"Last Name","First Name",null,"Days/ Yr (187)",null,"Hrs/Day (7.5 = 1.0)",null,"FY19 Hourly Rate",null,"Hourly Rate + COLA","Salary",null,"FTE",null,null,null,"Prgm","Act","Obj","Loc","CC","Proj","Sub Fund","Commt Stpd","Calc Stpd"]
[null,"SALARIES:",null,null,null,null,null,null,null,null,null,null,4.4999999999999998E-2]
[null,"Literacy Specialist",null,"Unfilled",null,null,187,null,7.5,null,58.89,null,{"$f":"K12*(100%+$M$11)","v":61.540049999999994},null,null,{"$f":"I12/7.5","v":1},null,{"$f":"(G12*I12*M12)","v":86309.92012499999},null,5150,"27-Teaching",2000,136,1360,0,0,2600,{"$f":"AA12*P12","v":2600}]
[null,null,null,null,null,null,0,0,0,null,0,null,{"$f":"K13*(100%+$M$11)","v":0},null,null,{"$f":"I13/7.5","v":0},null,{"$f":"(G13*I13*M13)","v":0},null,null,"27-Teaching",2000,null,null,0,0]
[null,null,null,null,null,null,0,null,0,null,0,null,0,null,null,0,null,0,null,null,"27-Teaching",2000,null,null,0,0]
[null,null,null,null,null,null,0,null,0,null,0,null,{"$f":"K15*(100%+$M$11)","v":0},null,null,{"$f":"I15/7.5","v":0},null,{"$f":"(G15*I15*M15)","v":0},null,null,"27-Teaching",2000,null,null,0,0]
[null,null,null,null,null,null,0,null,0,null,0,null,0,null,null,0,null,0,null,null,"27-Teaching",2000,null,null,0,0]
[null,null,null,null,null,null,0,null,0,null,0,null,0,null,null,0,null,0,null,null,"27-Teaching",2000,null,null,0,0]
[null,null,null,null,null,null,0,null,0,null,0,null,0,null,null,0,null,0,null,null,"27-Teaching",2000,null,null,0,0]
[null,null,null,null,null,null,0,null,0,null,0,null,0,null,null,0,null,0,null,null,"27-Teaching",2000,null,null,0,0]
[null,null,null,null,null,null,0,null,0,null,0,null,{"$f":"K20*(100%+$M$11)","v":0},null,null,{"$f":"I20/7.5","v":0},null,{"$f":"(G20*I20*M20)","v":0},null,null,"27-Teaching",2000,null,null,0,0]
[null,null,null,null,null,null,0,null,0,null,0,null,0,null,null,0,null,0,null,null,"27-Teaching",2000,null,null,0,0]
[null,null,null,null,null,null,0,null,0,null,0,null,0,0,null,0,null,0,null,null,"27-Teaching",2000,null,null,0,0]
[null,null,null,null,null,null,0,null,0,null,0,null,0,0,null,0,null,0,null,null,"27-Teaching",2000,null,null,0,0]
[null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(I12:I23)","v":7.5},null,{"$f":"IF(K12=0,0,(AVERAGEIF(K12:K23,\">0\")))","v":58.89},null,{"$f":"IF(M12=0,0,(AVERAGEIF(M12:M23,\">0\")))","v":61.540049999999994},null,null,{"$f":"SUM(P12:P23)","v":1},null,{"$f":"SUM(R12:R23)","v":86309.92012499999}]
[null,null,null,null,null,null,null,null,null,null,"Avg Rate",null,"Avg Rate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AB12:AB24)","v":2600}]
[]
[]
[null,"ADDITIONAL SALARY COSTS:"]
["Auto-Calc!","Principal Effective Education (3 Days)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(M24*P24*7.5)*3","v":1384.6511249999999},null,5150,"27-Teaching",2171,136,3490,0,0]
["Auto-Calc!","Professional Learning/Enrichment Stipend",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R24=0,0,R24*0.0509)","v":4393.1749343624997},null,5150,"27-Teaching",2170,136,3490,0,0]
[]
[null,"OTHER SALARY ITEMS:"]
[null,"Special Projects",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,5150,"27-Teaching",2060,136,1360,0,0]
[null,"Commitment Stipend",null,"$2,000 or $2,600, depending on seniority; see input note",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB25","v":2600},null,5150,"27-Teaching",2241,136,{"$f":"3710","v":3710},0,0]
[null,"Other Stipends",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,5150,"27-Teaching",0,136,null,0,0]
["Auto-Calc!","Cert Substitutes - General Purpose (Estimated based on FTE)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P24*154)*4","v":616},null,5150,"27-Teaching",2010,136,null,0,0]
[null,"Temporary Help",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,5150,"27-Teaching",2145,136,null,0,0]
[null,"Cert Substitutes-Prof Dev (Act 31 only)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,5150,"31-Prof Dev",2210,136,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(R29:R38)","v":8993.8260593625}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Instructional Salaries",null,{"$f":"R24+R39","v":95303.746184362491}]
[]
[null,"BENEFITS:"]
["Auto-Calc!","Payroll Taxes - Salary, PEE, PLE, Special Proj, Stipends",null,{"$f":"SAL_BEN_INFO!C9","v":0.25147000000000003},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R24+R29+R30+R33+R34+R35)*D43","v":23811.127532981638},null,5150,"27-Teaching",4200,136,1360,0,0]
["Auto-Calc!","Payroll Taxes - Subs,Temp",null,{"$f":"SAL_BEN_INFO!C11","v":8.3470000000000003E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R37+R36)*D44","v":51.417520000000003},null,5150,"27-Teaching",4200,136,1360,0,0]
["Auto-Calc!","Payroll Taxes - Subs,Temp",null,{"$f":"SAL_BEN_INFO!C11","v":8.3470000000000003E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R38)*D45","v":0},null,5150,"31-Prof Dev",4200,136,1360,0,0]
["Auto-Calc!","Medical/Dental/Vision",null,{"$f":"SAL_BEN_INFO!D13","v":14155},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P24*D46","v":14155},null,5150,"27-Teaching",4200,136,1360,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Instructional Benefits",null,{"$f":"SUM(R43:R46)","v":38017.545052981637}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Instructional Salaries & Benefits",null,{"$f":"R40+R47","v":133321.29123734412}]

{"sheet":"D-CLASS Staff","index":2,"n_rows":53,"n_cols":24,"rows_kept":53,"cut":false,"hidden":false,"merged":[[8,3,8,4],[8,17,8,23],[8,15,9,15],[8,6,8,10]]}
[null,"PRGM MGR",{"$f":"'A-Budget Summary'!C7","v":"Popp, Rona"}]
[null,"PROGRAM",{"$f":"'A-Budget Summary'!C8","v":"Title 1 - Prog 5150"}]
[null,"LOC/DEPT",{"$f":"'A-Budget Summary'!C9","v":"719-Student & Family Support"}]
[null,"LOC/SCHOOL",{"$f":"'A-Budget Summary'!C10","v":"136-Kent"}]
[null,"COST CENTER",{"$f":"'A-Budget Summary'!C11","v":"Kent"}]
[]
[null,"CLASSIFIED SALARY DETAIL "]
[]
[null,"Position",null,"Employee",null,null,"PLEASE ENTER THIS DATA",null,null,null,null,null,null,null,null,"Total Salary",null,"Account Code"]
[null,"Title",null,"Last Name","First Name",null,"Days/Yr",null,"Hrs/ Day",null,"FY19 Hourly Rate",null,"Hourly Rate + COLA",null,"FTE",null,null,"Prgm","Act","Obj","Loc","CC","Proj","Sub Fund"]
[null,"SALARIES:",null,null,null,null,null,null,null,null,null,null,0.05]
[null,null,null,null,null,null,189,null,null,null,null,null,{"$f":"K12*(100%+$M$11)","v":0},null,{"$f":"SUM(G12*I12)/2080","v":0},{"$f":"(G12*I12*M12)","v":0},null,5150,"27-Teaching",3000,136,1360,0,0]
[null,"Title I  Paraeducator",null,"Unfilled",null,null,189,null,6,null,19.86,null,{"$f":"K13*(100%+$M$11)","v":20.853000000000002},null,{"$f":"SUM(G13*I13)/2080","v":0.54519230769230764},{"$f":"(G13*I13*M13)","v":23647.302000000003},null,5150,"27-Teaching",3000,136,1360,0,0]
[null,"Title I  Paraeducator",null,"Bird","Big",null,189,null,6,null,20.82,null,{"$f":"K14*(100%+$M$11)","v":21.861000000000001},null,{"$f":"SUM(G14*I14)/2080","v":0.54519230769230764},24790.374,null,5150,"27-Teaching",3000,136,1360,0,0]
[null,"Title I  Paraeducator",null,"Duck","Donald",null,189,null,6,null,20.82,null,21.861000000000001,null,{"$f":"SUM(G15*I15)/2080","v":0.54519230769230764},24790.374,null,5150,"27-Teaching",3000,136,1360,0,0]
[null,null,null,null,null,null,189,null,0,null,0,null,0,null,0,0,null,null,"27-Teaching",3000,null,null,0,0]
[null,null,null,null,null,null,0,null,0,null,0,null,0,null,{"$f":"SUM(G17*I17)/2080","v":0},0,null,null,"27-Teaching",3000,null,null,0,0]
[null,null,null,null,null,null,0,null,0,null,0,null,0,null,0,0,null,null,"27-Teaching",3000,null,null,0,0]
[null,null,null,null,null,null,0,null,0,null,0,null,0,null,{"$f":"SUM(G19*I19)/2080","v":0},0,null,null,"27-Teaching",3000,null,null,0,0]
[null,null,null,null,null,null,0,null,0,null,0,null,0,null,{"$f":"SUM(G20*I20)/2080","v":0},0,null,null,"27-Teaching",3000,null,null,0,0]
[null,null,null,null,null,null,0,null,0,null,0,null,0,null,0,0,null,null,"27-Teaching",3000,null,null,0,0]
[null,null,null,null,null,null,0,null,0,null,0,null,{"$f":"K22*(100%+$M$11)","v":0},null,{"$f":"SUM(G22*I22)/2080","v":0},{"$f":"(G22*I22*M22)","v":0},null,null,"27-Teaching",3000,null,null,0,0]
[null,null,null,null,null,null,0,null,0,null,0,null,0,null,0,0,null,null,"27-Teaching",3000,null,null,0,0]
[null,null,null,null,null,null,0,null,0,null,0,null,0,null,0,0,null,null,"27-Teaching",3000,null,null,0,0]
[null,null,null,null,null,null,0,null,0,null,0,null,0,null,0,0,null,null,"27-Teaching",3000,null,null,0,0]
[null,null,null,null,null,null,0,null,0,null,0,null,0,null,0,0,null,null,"27-Teaching",3000,null,null,0,0]
[null,null,null,null,null,null,0,null,0,null,0,null,0,null,0,{"$f":"(G27*I27*K27)","v":0},null,null,"27-Teaching",3000,null,null,0,0]
[]
[null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(I12:I27)","v":18},null,{"$f":"IF(K12=0,0,(AVERAGEIF(K12:K27,\">0\")))","v":0},null,{"$f":"IF(M12=0,0,(AVERAGEIF(M12:M27,\">0\")))","v":0},null,{"$f":"SUM(O12:O27)","v":1.6355769230769228},{"$f":"SUM(P12:P27)","v":73228.05}]
[null,null,null,null,null,null,null,null,{"$f":"IF(I12=0,0,(AVERAGEIF(I12:I27,\">0\")))","v":0},null,"Avg Rate",null,"Avg Rate"]
[null,"OTHER SALARY ITEMS:",null,null,null,null,null,null,"Avg Hrs/Day"]
["Auto-Calc!","Addt'l Salary - Effective Ed (Act 31 only) ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I29*4)*M29","v":0},null,5150,"31-Prof Dev",3171,136,3480,0,0]
[null,"Extra Time",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"27-Teaching",3020,null,null,0,0]
[null,"Overtime",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"27-Teaching",3050,null,null,0,0]
[null,"Commitment Stipend (Eliminated for Non-Rep/Prof Tech positions, 2019-20)",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"27-Teaching",3240,null,3750,0,0]
[null,"Stipend",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"27-Teaching",0,null,null,0,0]
[null,"Substitutes-Paraeducators",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"27-Teaching",3145,null,null,0,0]
[null,"Substitutes-Office Staff",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"27-Teaching",3010,null,null,0,0]
[null,"Substitutes-Sick Leave",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"27-Teaching",3140,null,null,0,0]
[null,"Substitutes-Prof Dev (Act 31 only)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"31-Prof Dev",3210,null,null,0,0]
[null,null,null,null,null,null,null,null,"Subtotal",null,null,null,null,null,null,{"$f":"SUM(P32:P40)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Classified Salaries",{"$f":"P29+P41","v":73228.05}]
[]
[null,"BENEFITS:"]
["Auto-Calc!","Payroll Taxes - Salary, Extra Time, OT, Add'l Sal, Stipends",null,{"$f":"SAL_BEN_INFO!C10","v":0.22827},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P29+P33+P34+P35+P36)*D45","v":16715.766973500002},null,5150,"27-Teaching",4300,136,1360,0,0]
["Auto-Calc!","Payroll Taxes - Effective Ed Act 31",null,{"$f":"SAL_BEN_INFO!C10","v":0.22827},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P32)*D46","v":0},null,5150,"31-Prof Dev",4300,136,1360,0,0]
["Auto-Calc!","Payroll Taxes - Subs,Temp,other",null,{"$f":"SAL_BEN_INFO!C11","v":8.3470000000000003E-2},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P37+P38+P39)*D47","v":0},null,5150,"27-Teaching",4300,136,1360,0,0]
["Auto-Calc!","Payroll Taxes - Subs,Temp,other",null,{"$f":"SAL_BEN_INFO!C12","v":8.3470000000000003E-2},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P40)*D48","v":0},null,5150,"31-Prof Dev",4300,136,1360,0,0]
["Auto-Calc!","Medical/Dental/Vision",null,{"$f":"SAL_BEN_INFO!D14","v":19871},null,null,null,null,null,null,null,null,null,null,null,{"$f":"O29*D49","v":32500.549038461533},null,5150,"27-Teaching",4300,136,1360,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Classified Benefits",{"$f":"SUM(P45:P49)","v":49216.316011961535}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Classified Salaries & Benefits",{"$f":"P42+P50","v":122444.36601196154}]

{"sheet":"MSOC","index":3,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":false,"merged":[[8,4,8,9],[8,11,9,11]]}
[null,"PRGM MGR",{"$f":"'A-Budget Summary'!C7","v":"Popp, Rona"}]
[null,"PROGRAM",{"$f":"'A-Budget Summary'!C8","v":"Title 1 - Prog 5150"}]
[null,"LOC/DEPT",{"$f":"'A-Budget Summary'!C9","v":"719-Student & Family Support"}]
[null,"LOC/SCHOOL",{"$f":"'A-Budget Summary'!C10","v":"136-Kent"}]
[null,"COST CENTER",{"$f":"'A-Budget Summary'!C11","v":"Kent"}]
[]
[null,"Materials, Supplies, Oper Costs (MSOC) DETAIL"]
[]
[null,"ENTER REQUESTED BUDGET -",null,null,"Account Code",null,null,null,null,null,null,"List expenditure description, detail, etc. as needed:"]
[null,"Object/Description","Amount",null,"Prgm","Act","Obj","Loc","CC","Proj"]
[null,"Enter amounts in categories shown below, or select other Obj/Category from Pull-Down menus:"]
[null,"0490 - KSD-Food Services",0,null,5150,"27-Teaching",490,136,1360,0]
[null,"0590 - KSD-Student Transportation",4726,null,5150,"27-Teaching",590,136,1360,0,null,"Transportation for extended learning"]
[null,"0730 - KSD-Print Shop",500,null,5150,"27-Teaching",730,136,1360,0]
[null,"5000 - General Materials & Supplies",17000,null,5150,"27-Teaching",5000,136,1360,0,null,"low level literacy books"]
[null,"5010 - Food & Beverage",0,null,5150,"27-Teaching",5010,136,1360,0]
[null,"5080 - Postage",0,null,5150,"27-Teaching",5080,136,1360,0]
[null,"5700 - Textbooks (Act 33 only)",0,null,5150,"33-Curriculum",5700,136,1360,0]
[null,"5710 - Clsrm Resource Matl's (Act 33 only)",0,null,5150,"33-Curriculum",5710,136,1360,0]
[null,"5900 - Theft Sensitive Items",0,null,5150,"27-Teaching",5900,136,1360,0]
[null,"7000 - Contractual Services",15000,null,5150,"27-Teaching",7000,136,1360,0,null,"Literacy Guest speaker/coach"]
[null,"7030 - Personal Services Contracts",null,null,5150,"27-Teaching",7030,136,1360,0]
[null,"7050 - Registration/Other Fees",5000,null,5150,"27-Teaching",7050,136,1360,0,null,"Conference fees"]
[null,"8000 - Out-of-District Travel",0,null,5150,"27-Teaching",8000,136,1360,0]
[null,"8010 - In-District Travel",0,null,5150,"27-Teaching",8010,136,1360,0]
[null,"9000 - Capital Equipment > $5,000",0,null,5150,"27-Teaching",9000,136,1360,0]
[null,null,0,null,5150,"27-Teaching",0,136,1360,0]
[null,null,0,null,5150,"27-Teaching",0,136,1360,0]
[null,"Total Non-Personnel",{"$f":"SUM(C12:C28)","v":42226}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"           "]

{"sheet":"B-ADMIN Staff","index":4,"n_rows":39,"n_cols":25,"rows_kept":39,"cut":false,"hidden":false,"merged":[[8,3,8,5],[8,18,8,24],[8,7,8,11]]}
[null,"PRGM MGR",{"$f":"'A-Budget Summary'!C7","v":"Popp, Rona"}]
[null,"PROGRAM",{"$f":"'A-Budget Summary'!C8","v":"Title 1 - Prog 5150"}]
[null,"LOC/DEPT",{"$f":"'A-Budget Summary'!C9","v":"719-Student & Family Support"}]
[null,"LOC/SCHOOL",{"$f":"'A-Budget Summary'!C10","v":"136-Kent"}]
[null,"COST CENTER",{"$f":"'A-Budget Summary'!C11","v":"Kent"}]
[]
[null,"CERTIFICATED ADMINISTRATIVE SALARY DETAIL"]
[]
[null,"Position",null,"Employee",null,null,null,"PLEASE ENTER THIS DATA",null,null,null,null,null,null,null,null,"Calculated",null,"Account Code"]
[null,"Title",null,"Last Name",null,"First Name",null,"Days/Yr",null,"Hrs/Day",null,"Total Base Salary",null,"Base Salary + COLA",null,"FTE","Salary",null,"Prgm","Act","Obj","Loc","CC","Proj","Sub Fund"]
[null,"SALARIES:",null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,260,null,0,null,0,null,{"$f":"L12*(100%+$N$11)","v":0},null,{"$f":"SUM(H12*J12)/2080","v":0},{"$f":"(N12*P12)","v":0},null,null,"21-Supervision",2000,null,null,0,0]
[null,null,null,null,null,null,null,260,null,0,null,0,null,{"$f":"L13*(100%+$N$11)","v":0},null,0,{"$f":"(N13*P13)","v":0},null,null,"21-Supervision",2000,null,null,0,0]
[null,null,null,null,null,null,null,260,null,0,null,0,null,0,null,0,0,null,null,"21-Supervision",2000,null,null,0,0]
[null,null,null,null,null,null,null,260,null,0,null,0,null,0,null,0,0,null,null,"21-Supervision",2000,null,null,0,0]
[null,null,null,null,null,null,null,260,null,0,null,0,null,0,null,0,0,null,null,"21-Supervision",2000,null,null,0,0]
[null,null,null,null,null,null,null,260,null,0,null,0,null,0,null,0,0,null,null,"21-Supervision",2000,null,null,0,0]
[null,null,null,null,null,null,null,260,null,0,null,0,null,0,null,0,0,null,null,"21-Supervision",2000,null,null,0,0]
[null,null,null,null,null,null,null,260,null,0,null,0,null,{"$f":"L19*(100%+$N$11)","v":0},null,{"$f":"SUM(H19*J19)/2080","v":0},{"$f":"(N19*P19)","v":0},null,null,"21-Supervision",2000,null,null,0,0]
[null,null,null,null,null,null,null,260,null,0,null,0,null,0,null,0,0,null,null,"21-Supervision",2000,null,null,0,0]
[null,null,null,null,null,null,null,260,null,0,null,0,null,0,null,0,0,null,null,"21-Supervision",2000,null,null,0,0]
[null,null,null,null,null,null,null,260,null,0,null,0,null,0,null,0,0,null,null,"21-Supervision",2000,null,null,0,0]
[null,null,null,null,null,null,null,260,null,0,null,0,null,0,null,0,0,null,null,"21-Supervision",2000,null,null,0,0]
[]
[null,null,null,null,null,null,null,null,null,"Subtotal",null,null,null,null,null,{"$f":"SUM(P12:P23)","v":0},{"$f":"SUM(Q12:Q23)","v":0}]
[]
[null,"OTHER SALARY ITEMS:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O12:O25)","v":0}]
[null,"Commitment Stipend (Eliminated for Non-Rep positions 2019-20)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"21-Supervision",2241,null,3710,0,0]
[null,"TSA (Tax Sheltered Annuity)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"21-Supervision",2280,null,2255,0,0]
[null,null,null,null,null,null,null,null,null,"Subtotal",null,null,null,null,null,null,{"$f":"Q29","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Administrative Salaries",{"$f":"Q25+Q30","v":0}]
[]
[null,"BENEFITS:"]
["Auto-Calc!","Payroll Taxes - Base Salary",null,{"$f":"SAL_BEN_INFO!C9","v":0.25147000000000003},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(Q32*D35)","v":0},null,null,"21-Supervision",4200,null,null,{"$f":"X12","v":0},0]
["Auto-Calc!","Medical/Dental/Vision",null,{"$f":"SAL_BEN_INFO!D13","v":14155},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D36*P25","v":0},null,null,"21-Supervision",4200,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Administrative Benefits",{"$f":"Q35+Q36","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Administrative Salaries & Benefits",{"$f":"Q32+Q37","v":0}]

{"sheet":"SAL_BEN_INFO","index":5,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":false,"merged":[[6,2,6,3],[17,2,17,5]]}
["AVERAGE SALARY and BENEFIT RATES"]
["2019-2020"]
["As of 3/12/19"]
[]
[]
[]
[null,null,"Mandatory Benefits"]
[null,null,"Rate","Amount"]
["Certificated Staff",null,0.25147000000000003]
["Classified Staff",null,0.22827]
["Certificated Hourly, Extra-Time, Substitutes",null,8.3470000000000003E-2]
["Classified Hourly, Extra-Time, Substitutes",null,8.3470000000000003E-2]
["Medical Benefits - Amount for 1.0 FTE / CERT",null,null,14155]
["Medical Benefits - Amount for 1.0 FTE / CLASS",null,null,19871]
[]
[]
[]
[null,null,"ANNUAL AVERAGE",null,null,null,null,null,"ANNUAL AVERAGE"]
["Salary Type:",null,"SALARY","Professional Learning","OTHER","TOTAL","PAYROLL TAXES &","MEDICAL","TOTAL"]
[null,"FY20 COLA","1.0 FTE","Enrichment","SALARY*","SALARY","OTHER BENEFITS","BENEFITS","COMPENSATION"]
["Certificated Instructional Staff - 1.0 FTE",4.4999999999999998E-2,{"$f":"79477","v":79477},{"$f":"4262","v":4262},{"$f":"3111.25","v":3111.25},{"$f":"SUM(C21:E21)","v":86850.25},{"$f":"F21*$C$9","v":21840.232367500001},{"$f":"D13","v":14155},{"$f":"SUM(F21:H21)","v":122845.48236749999}]
["Certificated Admin Staff (not Principals) - 1.0 FTE",0,{"$f":"118617.59*(100%+B22)","v":118617.59},{"$f":"1804.25","v":1804.25},{"$f":"688.82","v":688.82},{"$f":"SUM(C22:E22)","v":121110.66},{"$f":"F22*$C$9","v":30455.697670200003},{"$f":"D13","v":14155},{"$f":"SUM(F22:H22)","v":165721.3576702}]
["Classified Staff (KAEOP) - 1.0 FTE",0,{"$f":"44038.74*(100%+B23)","v":44038.74},"n/a","n/a",{"$f":"SUM(C23:E23)","v":44038.74},{"$f":"F23*$C$10","v":10052.723179799999},{"$f":"D14","v":19871},73962.46317979999]
["Classified Staff (KAP) - 1.0 FTE",0.05,{"$f":"41942.76*(100%+B24)","v":44039.898000000001},"n/a","n/a",44039.898000000001,{"$f":"F24*$C$10","v":10052.98751646},{"$f":"D14","v":19871},73963.885516459995]
["Classified Staff (Prof Tech) - 1.0 FTE",0,{"$f":"74851.56*(100%+B25)","v":74851.56},"n/a",{"$f":"365","v":365},{"$f":"SUM(C25:E25)","v":75216.56},17169.684151199999,{"$f":"D14","v":19871},112257.24415119999]
[]
[null,null,null,"  * Avg CIS Salary, not incl PLE",null,{"$f":"C21+E21","v":82588.25},{"$f":"F27*C9","v":20768.467227500001},{"$f":"H21","v":14155},{"$f":"SUM(F27:H27)","v":117511.7172275}]
[null,null,null,null,"Avg Hrly Rate, CIS",{"$f":"F27/SUM(187*7.5)","v":58.886452762923348},null,null,{"$f":"I27/SUM(187*7.5)","v":83.787320661319072}]
["(rates unknown at this time 3/4/19)","TBD!"]
[null,null,null,null,"*other salary includes, commitment, longevity, and other stipends for Average Salary"]
[]
[null,null,null,"AVERAGE",null,null,"AVERAGE","AVERAGE"]
[null,null,"DAILY","HOURLY","PAYROLL TAXES &","MEDICAL","DAILY","HOURLY"]
[null,null,"RATE","RATE","OTHER BENEFITS","BENEFITS","COMPENSATION","COMPENSATION"]
["Classified / Para",null,null,{"$f":"20.17","v":20.170000000000002},{"$f":"D35*C10","v":4.6042059000000002},{"$f":"D13/1345","v":10.524163568773234},null,{"$f":"SUM(D35:F35)","v":35.298369468773238}]
[]
[]
["Certificated Substitute - Full Day",null,154,null,{"$f":"C38*C11","v":12.854380000000001},"n/a",{"$f":"C38+E38","v":166.85437999999999}]
["Certificated Substitute - Half Day",null,88,null,{"$f":"C39*C11","v":7.3453600000000003},"n/a",{"$f":"C39+E39","v":95.345359999999999}]
[]
["Classified Substitute - Title, LAP, ELL, IP, IC",null,null,14.6,{"$f":"D41*C12","v":1.2186619999999999},null,null,{"$f":"SUM(D41:F41)","v":15.818662}]
["Classified Substitute - SC, SA, ASC, ECE, LINK, BLSP",null,null,15.01,{"$f":"D42*C12","v":1.2528847000000001},null,null,{"$f":"SUM(D42:F42)","v":16.262884700000001}]

{"sheet":"menus","index":6,"n_rows":180,"n_cols":17,"rows_kept":180,"cut":false,"hidden":true,"merged":[]}
[null,"New Prgm-Type In",null,"Type-In / Overwrite","Type-In / Overwrite","Type-In / Overwrite",null,"Type-In / Overwrite",null,"Type-In / Overwrite",260,null,"n/a",null,null,null,"n/a"]
[164,"0164 - Basic Ed-Dual Language Support",535,"535-Career & Tech Ed (CTE)","21-Supervision","0100-Superintendent",490,"0490 - KSD-Food Services",null,"Corbley, Christine",212,null,"100-Carriage Crest",100,"Superintendent",null,"0100-Superintendent"]
[165,"0165 - Basic Ed: ELL Support",706,"706-Finance","22-Library","0200-District Operations",590,"0590 - KSD-Student Transportation",null,"Fields, Teresa",190,null,"103-Cedar Valley",110,"Minority Achievement",null,"0110-Minority Achievement"]
[2100,"2100 - Special Education",708,"708-Food Services","23-Principal's Ofc","0320-Textbook Adoption",730,"0730 - KSD-Print Shop",null,"Harmon, Jewelle",189,null,"106-Covington",200,"District Operations",null,"0200-District Operations"]
[2110,"2110 - SpEd One on One",709,"709-Human Resources","24-Guidance","0500-Dir of Early Learning",5000,"5000 - General Materials & Supplies",null,"Heath, Randy",null,null,"109-Crestwood",320,"Textbook Adoption",null,"0320-Textbook Adoption"]
[2120,"2120 - SpEd - SLP Assistants",710,"710-Info Technology (IT)","25-Pupil Mgmt/Safety","0550-SIO, HS",5010,"5010 - Food & Beverage",null,"Jones, Jennifer",null,null,"112-East Hill",500,"Dir of Early Learning",null,"0500-Dir of Early Learning"]
[2130,"2130 - SpEd - COTA/PTA",711,"711-Teaching & Learning","26-Health Svcs","0590-Kinder to College",5080,"5080 - Postage",null,"Martin, Moriah",null,null,"115-Emerald Park",530,"Summer School",null,"530-Summer School"]
[2200,"2200 - SpEd - Infants & Toddlers",713,"713-ELL","27-Teaching","0600-Chief Accountability Ofcr",5700,"5700 - Textbooks (Act 33 only)",null,"Pan, Spencer",null,null,"118-Fairwood",550,"SIO, HS",null,"0550-SIO, HS"]
[2450,"2450 - SpEd - IDEA B",718,"718-Inclusive Education","28-Extracurricular","0620-Chief Op's & Acad Supp",5710,"5710 - Clsrm Resource Matl's (Act 33 only)",null,"Paxton, Lori",null,null,"121-G. Daniel",590,"Kinder to College",null,"0590-Kinder to College"]
[2451,"2451 - SpEd - Preschool Sctn 619",719,"719-Student & Family Support","31-Prof Dev","0650-iGrad",5900,"5900 - Theft Sensitive Items",null,"Popp, Rona",null,null,"124-Glenridge",600,"Chief Accountability Officer",null,"0600-Chief Accountability Officer"]
[3151,"3151 - CTE, Admin",720,"720-Superintendent",null,"0700-SIO, MS",7000,"7000 - Contractual Services",null,"Vela, Israel",null,null,"127-Grass Lake",650,"iGrad",null,"0650-iGrad"]
[3152,"3152 - CTE, Secondary Support",721,"721-Staff Development",null,"0850-SIO, Elem #1",7030,"7030 - Personal Svcs Contracts",null,"West, DeNelle",null,null,"130-Horizon",700,"SIO, MS",null,"0700-SIO, MS"]
[3154,"3154 - CTE, Computer Sci",null,null,null,"0880-SIO, Elem #2",7050,"7050 - Registration/Other Fees",null,"Williams, Nina (Will)",null,null,"133-Jenkins Creek",850,"SIO, Elem#1",null,"0850-SIO, Elem#1"]
[3155,"3155 - CTE, Career Centers",null,null,null,"1000-Carriage Crest",8000,"8000 - Out-of-District Travel",null,null,null,null,"136-Kent",880,"SIO, Elem#2",null,"0880-SIO, Elem#2"]
[3156,"3156 - CTE, Aviation",null,null,null,"1030-Cedar Valley",8010,"8010 - In-District Travel",null,null,null,null,"139-Kent Valley ELC",1000,"Carriage Crest",null,"1000-Carriage Crest"]
[3157,"3157 - CTE, Horticulture",null,null,null,"1060-Covington",9000,"9000 - Capital Equipment > $5,000",null,null,null,null,"142-Lake Youngs",1030,"Cedar Valley",null,"1030-Cedar Valley"]
[3158,"3158 - CTE, Business Ed",null,null,null,"1090-Crestwood",null,null,null,null,null,null,"145-Martin Sortun",1060,"Covington",null,"1060-Covington"]
[3159,"3159 - CTE, Marketing",null,null,null,"1120-East Hill",null,null,null,null,null,null,"148-Meadow Ridge",1090,"Crestwood",null,"1090-Crestwood"]
[3160,"3160 - CTE , Auto Tech",null,null,null,"1150-Emerald Park",null,null,null,null,null,null,"151-Meridian",1120,"East Hill",null,"1120-East Hill"]
[3161,"3161 - CTE, Visual Comm",null,null,null,"1180-Fairwood",null,null,null,null,null,null,"154-Millennium",1150,"Emerald Park",null,"1150-Emerald Park"]
[3162,"3162 - CTE, Health Careers",null,null,null,"1210-G. Daniel",null,null,null,null,null,null,"157-Neely O'Brien",1180,"Fairwood",null,"1180-Fairwood"]
[3163,"3163 - CTE, Culinary Arts",null,null,null,"1240-Glenridge",null,null,null,null,null,null,"160-Panther Lake",1210,"G. Daniel",null,"1210-G. Daniel"]
[3164,"3164 - CTE, American Sign Lang",null,null,null,"1270-Grass Lake",null,null,null,null,null,null,"163-Park Orchard",1240,"Glenridge",null,"1240-Glenridge"]
[3165,"3165 - CTE, Engineering",null,null,null,"1300-Horizon",null,null,null,null,null,null,"166-Pine Tree",1270,"Grass Lake",null,"1270-Grass Lake"]
[3166,"3166 - CTE, Family & Consumer Sci",null,null,null,"1330-Jenkins Creek",null,null,null,null,null,null,"169-Ridgewood",1300,"Horizon",null,"1300-Horizon"]
[3167,"3167 - CTE, Manufacturing",null,null,null,"1360-Kent",null,null,null,null,null,null,"172-Sawyer Woods",1330,"Jenkins Creek",null,"1330-Jenkins Creek"]
[3168,"3168 - CTE, Applied Programs",null,null,null,"1390-Kent Valley ELC",null,null,null,null,null,null,"175-Scenic Hill",1360,"Kent",null,"1360-Kent"]
[3169,"3169 - CTE, Cosmetology",null,null,null,"1420-Lake Youngs",null,null,null,null,null,null,"178-Soos Creek",1390,"Kent Valley ELC",null,"1390-Kent Valley ELC"]
[3170,"3170 - CTE, Media & Theatre Tech",null,null,null,"1450-Martin Sortun",null,null,null,null,null,null,"181-Springbrook",1420,"Lake Youngs",null,"1420-Lake Youngs"]
[3171,"3171 - CTE, Welding",null,null,null,"1480-Meadow Ridge",null,null,null,null,null,null,"184-Sunrise",1450,"Martin Sortun",null,"1450-Martin Sortun"]
[3172,"3172 - CTE, Wood Tech",null,null,null,"1510-Meridian",null,null,null,null,null,null,"300-Cedar Heights MS",1480,"Meadow Ridge",null,"1480-Meadow Ridge"]
[3173,"3173 - CTE, Public Service",null,null,null,"1540-Millennium",null,null,null,null,null,null,"305-Mattson MS",1510,"Meridian",null,"1510-Meridian"]
[3860,"3860 - C.Perkins, Voc Fed",null,null,null,"1570-Neely O'Brien",null,null,null,null,null,null,"310-Meeker MS",1540,"Millennium",null,"1540-Millennium"]
[3901,"3901 - NSF Aerospace Career Ed, KPA",null,null,null,"1600-Panther Lake",null,null,null,null,null,null,"315-Meridian MS",1570,"Neely O'Brien",null,"1570-Neely O'Brien"]
[5150,"5150 - Title I-A, Basic Prgm",null,null,null,"1630-Park Orchard",null,null,null,null,null,null,"320-Mill Creek MS",1600,"Panther Lake",null,"1600-Panther Lake"]
[5151,"5151 - Title I-A, Homeless",null,null,null,"1660-Pine Tree",null,null,null,null,null,null,"325-Northwood MS",1630,"Park Orchard",null,"1630-Park Orchard"]
[5152,"5152 - Title I-A, Early Lrng",null,null,null,"1690-Ridgewood",null,null,null,null,null,null,"400-Kent -Meridian HS",1660,"Pine Tree",null,"1660-Pine Tree"]
[5153,"5153 - Title I-A, Parent Engagement Req",null,null,null,"1720-Sawyer Woods",null,null,null,null,null,null,"401-TOP (Outreach Program)",1690,"Ridgewood",null,"1690-Ridgewood"]
[5154,"5154 - Title I-A, Foster Care",null,null,null,"1750-Scenic Hill",null,null,null,null,null,null,"410-Kentlake HS",1720,"Sawyer Woods",null,"1720-Sawyer Woods"]
[5155,"5155 - Title I-A, Neglected Children",null,null,null,"1780-Soos Creek",null,null,null,null,null,null,"415-Kentridge HS",1750,"Scenic Hill",null,"1750-Scenic Hill"]
[5156,"5156 - Title I-A, Private Schools",null,null,null,"1810-Springbrook",null,null,null,null,null,null,"420-Kentwood HS",1780,"Soos Creek",null,"1780-Soos Creek"]
[5159,"5159 - Title I-A, Schl/Dist Prof Dev",null,null,null,"1840-Sunrise",null,null,null,null,null,null,"500-Kent Mtn View Academy",1810,"Springbrook",null,"1810-Springbrook"]
[5161,"5161 - Title I-A, Parent Engagement",null,null,null,"2000-Business Services",null,null,null,null,null,null,"503-Kent Phoenix Academy",1840,"Sunrise",null,"1840-Sunrise"]
[5175,"5175 - Title I - Focus Schools",null,null,null,"2020-Grant Indirects Budget",null,null,null,null,null,null,"504-iGrad",2000,"Business Services",null,"2000-Business Services"]
[5213,"5213 - Title IIA, Professional Dev",null,null,null,"2050-Finance Department",null,null,null,null,null,null,"505-Regional Justice Center",2020,"Grant Indirects Budget",null,"2020-Grant Indirects Budget"]
[5214,"5214 - Title IIA, Private Schools",null,null,null,"2050-Finance (Budget Only)",null,null,null,null,null,null,"520-Summer School Elem.",2050,"Finance Department",null,"2050-Finance Department"]
[5234,"5234 - Title IV-A, Student Support",null,null,null,"2190-Section 125 Svc Fees",null,null,null,null,null,null,"530-Summer School",2050,"Finance (Budget Only)",null,"2050-Finance (Budget Only)"]
[5520,"5520 - LAP Base Allocation",null,null,null,"2240-SL/VL Buy-Back",null,null,null,null,null,null,"All Elementary",2190,"Section 125 Svc Fees",null,"2190-Section 125 Svc Fees"]
[5521,"5521 - Readiness to Learn (LAP)",null,null,null,"2250-Reimbursed Mileage",null,null,null,null,null,null,"All Middle",2240,"SL/VL Buy","Back","2240-SL/VL Buy-Back"]
[5522,"5522 - LAP High Poverty",null,null,null,"2255-TSA Matching",null,null,null,null,null,null,"All High",2250,"Reimbursed Mileage",null,"2250-Reimbursed Mileage"]
[5802,"5802 - Non-Title I Focus Schools",null,null,null,"2550-Homeless Transportation",null,null,null,null,null,null,"All Secondary",2255,"TSA Matching",null,"2255-TSA Matching"]
[5803,"5803 - Non-Title I Priority Schools",null,null,null,"2950-ECEAP",null,null,null,null,null,null,"All Schools",2550,"Homeless Transportation",null,"2550-Homeless Transportation"]
[5820,"5820 - Nat'l Board Certification",null,null,null,"2970-School Improv Prgms",null,null,null,null,null,null,null,2950,"ECEAP",null,"2950-ECEAP"]
[5830,"5830 - WA First, Robotics",null,null,null,"3000-Cedar Heights MS",null,null,null,null,null,null,null,2950,"ECEAP",null,"2950-ECEAP"]
[5840,"5840 - Beg. Ed Support Team (BEST)",null,null,null,"3050-Mattson MS",null,null,null,null,null,null,null,2970,"School Improv Prgms",null,"2970-School Improv Prgms"]
[5874,"5874 - Educ Leadership Intern Prgm",null,null,null,"3100-Meeker MS",null,null,null,null,null,null,null,3000,"Cedar Heights MS",null,"3000-Cedar Heights MS"]
[5880,"5880 - TPEP Teacher Trng Funds",null,null,null,"3150-Meridian MS",null,null,null,null,null,null,null,3050,"Mattson MS",null,"3050-Mattson MS"]
[5885,"5885 - TPEP Admin. Training",null,null,null,"3200-Mill Creek MS",null,null,null,null,null,null,null,3100,"Meeker MS",null,"3100-Meeker MS"]
[6418,"6418 - Title III, Limited English Prof.",null,null,null,"3250-Northwood MS",null,null,null,null,null,null,null,3150,"Meridian MS",null,"3150-Meridian MS"]
[6500,"6500 - Transitional Bilingual (ELL)",null,null,null,"3330-Substitute Salaries",null,null,null,null,null,null,null,3200,"Mill Creek MS",null,"3200-Mill Creek MS"]
[6899,"6899 - Title VII, Indian Ed",null,null,null,"3340-Overload Sub Pay",null,null,null,null,null,null,null,3250,"Northwood MS",null,"3250-Northwood MS"]
[6995,"6995 - ECEAP",null,null,null,"3430-Class Coverage",null,null,null,null,null,null,null,3330,"Substitute Salaries",null,"3330-Substitute Salaries"]
[7400,"7400 - Highly Capable",null,null,null,"3450-Staff Contingency/Unfilled",null,null,null,null,null,null,null,3340,"Overload Sub Pay",null,"3340-Overload Sub Pay"]
[7902,"7902 - Native American Support",null,null,null,"3480-Class-Extra Pay",null,null,null,null,null,null,null,3430,"Class Coverage",null,"3430-Class Coverage"]
[7904,"7904 - EWIS - ESD Reimbursement",null,null,null,"3490-Cert-Extra Pay",null,null,null,null,null,null,null,3450,"Staff Contingency/Unfilled",null,"3450-Staff Contingency/Unfilled"]
[7906,"7906 - Homeless Support",null,null,null,"3500-Principals-Travel",null,null,null,null,null,null,null,3480,"Class","Extra Pay","3480-Class-Extra Pay"]
[7914,"7914 - Refugee School Impact Grant",null,null,null,"3510-EDL Incentive",null,null,null,null,null,null,null,3490,"Cert","Extra Pay","3490-Cert-Extra Pay"]
[7922,"7922 - PSESD - Gates Early Math",null,null,null,"3530-Attendance Incentive",null,null,null,null,null,null,null,3500,"Principals","Travel","3500-Principals-Travel"]
[7938,"7938 - Schoolhouse WA Homeless",null,null,null,"3710-Committment Stipend",null,null,null,null,null,null,null,3510,"EDL Incentive",null,"3510-EDL Incentive"]
[7958,"7958 - GYO Infrastructure",null,null,null,"3720-Longevity Stipend",null,null,null,null,null,null,null,3530,"Attendance Incentive",null,"3530-Attendance Incentive"]
[7982,"7982 - Refugee Support",null,null,null,"3730-Completion Stipend",null,null,null,null,null,null,null,3710,"Committment Stipend",null,"3710-Committment Stipend"]
[null,null,null,null,null,"3750-Para Annual Stipend",null,null,null,null,null,null,null,3720,"Longevity Stipend",null,"3720-Longevity Stipend"]
[null,null,null,null,null,"3760-Ed Staff Assoc Stipends",null,null,null,null,null,null,null,3730,"Completion Stipend",null,"3730-Completion Stipend"]
[null,null,null,null,null,"3770-Employee Assist Prgm",null,null,null,null,null,null,null,3750,"Para Annual Stipend",null,"3750-Para Annual Stipend"]
[null,null,null,null,null,"3780-IEP Stipends",null,null,null,null,null,null,null,3760,"Ed Staff Assoc Stipends",null,"3760-Ed Staff Assoc Stipends"]
[null,null,null,null,null,"4000-Kent -Meridian HS",null,null,null,null,null,null,null,3770,"Employee Assist Prgm",null,"3770-Employee Assist Prgm"]
[null,null,null,null,null,"4001-TOP (Outreach Program)",null,null,null,null,null,null,null,3780,"IEP Stipends",null,"3780-IEP Stipends"]
[null,null,null,null,null,"4100-Kentlake HS",null,null,null,null,null,null,null,4000,"Kent ","Meridian HS","4000-Kent -Meridian HS"]
[null,null,null,null,null,"4150-Kentridge HS",null,null,null,null,null,null,null,4001,"TOP (Outreach Program)",null,"4001-TOP (Outreach Program)"]
[null,null,null,null,null,"4200-Kentwood HS",null,null,null,null,null,null,null,4100,"Kentlake HS",null,"4100-Kentlake HS"]
[null,null,null,null,null,"4420-Itinerant Specialists",null,null,null,null,null,null,null,4150,"Kentridge HS",null,"4150-Kentridge HS"]
[null,null,null,null,null,"4500-Language Arts",null,null,null,null,null,null,null,4200,"Kentwood HS",null,"4200-Kentwood HS"]
[null,null,null,null,null,"4505-Secondary Lang Arts",null,null,null,null,null,null,null,4420,"Itinerant Specialists",null,"4420-Itinerant Specialists"]
[null,null,null,null,null,"4510-Social Studies",null,null,null,null,null,null,null,4500,"Language Arts",null,"4500-Language Arts"]
[null,null,null,null,null,"4515-Secondary Social Studies",null,null,null,null,null,null,null,4505,"Secondary Lang Arts",null,"4505-Secondary Lang Arts"]
[null,null,null,null,null,"4520-World Language",null,null,null,null,null,null,null,4510,"Social Studies",null,"4510-Social Studies"]
[null,null,null,null,null,"4530-Math",null,null,null,null,null,null,null,4515,"Secondary Social Studies",null,"4515-Secondary Social Studies"]
[null,null,null,null,null,"4540-Science",null,null,null,null,null,null,null,4520,"World Language",null,"4520-World Language"]
[null,null,null,null,null,"4550-Health Fitness",null,null,null,null,null,null,null,4530,"Math",null,"4530-Math"]
[null,null,null,null,null,"4560-Fine Arts",null,null,null,null,null,null,null,4540,"Science",null,"4540-Science"]
[null,null,null,null,null,"4580-Gifted Curriculum",null,null,null,null,null,null,null,4550,"Health Fitness",null,"4550-Health Fitness"]
[null,null,null,null,null,"4600-Cert/Class Staff Dev",null,null,null,null,null,null,null,4560,"Fine Arts",null,"4560-Fine Arts"]
[null,null,null,null,null,"4630-Classified Staff Development",null,null,null,null,null,null,null,4580,"Gifted Curriculum",null,"4580-Gifted Curriculum"]
[null,null,null,null,null,"4640-Dist/Centralized Cert Training",null,null,null,null,null,null,null,4600,"Cert/Class Staff Dev",null,"4600-Cert/Class Staff Dev"]
[null,null,null,null,null,"4650-Cert Bld-Based Trnr Of Trnrs",null,null,null,null,null,null,null,4630,"Classified Staff Development",null,"4630-Classified Staff Development"]
[null,null,null,null,null,"4660-Teacher Assistance Program",null,null,null,null,null,null,null,4640,"Dist/Centralized Cert Training",null,"4640-Dist/Centralized Cert Training"]
[null,null,null,null,null,"4690-Diversity Training",null,null,null,null,null,null,null,4650,"Cert Bld","Based Trnr Of Trnrs","4650-Cert Bld-Based Trnr Of Trnrs"]
[null,null,null,null,null,"4800-Curriculum Alignment",null,null,null,null,null,null,null,4660,"Teacher Assistance Program",null,"4660-Teacher Assistance Program"]
[null,null,null,null,null,"4810-Research",null,null,null,null,null,null,null,4690,"Diversity Training",null,"4690-Diversity Training"]
[null,null,null,null,null,"4820-Assessment",null,null,null,null,null,null,null,4800,"Curriculum Alignment",null,"4800-Curriculum Alignment"]
[null,null,null,null,null,"4840-Report Cards",null,null,null,null,null,null,null,4810,"Research",null,"4810-Research"]
[null,null,null,null,null,"4860-Title I",null,null,null,null,null,null,null,4820,"Assessment",null,"4820-Assessment"]
[null,null,null,null,null,"4870-LAP",null,null,null,null,null,null,null,4840,"Report Cards",null,"4840-Report Cards"]
[null,null,null,null,null,"4880-Student Services",null,null,null,null,null,null,null,4860,"Title I",null,"4860-Title I"]
[null,null,null,null,null,"4881-Race to the Top",null,null,null,null,null,null,null,4870,"LAP",null,"4870-LAP"]
[null,null,null,null,null,"4900-Homeless",null,null,null,null,null,null,null,4880,"Student Services",null,"4880-Student Services"]
[null,null,null,null,null,"4910-Health Services",null,null,null,null,null,null,null,4881,"Race to the Top",null,"4881-Race to the Top"]
[null,null,null,null,null,"4990-Running Start",null,null,null,null,null,null,null,4900,"Homeless",null,"4900-Homeless"]
[null,null,null,null,null,"5000-Kent Mtn View Academy",null,null,null,null,null,null,null,4910,"Health Services",null,"4910-Health Services"]
[null,null,null,null,null,"5030-Kent Phoenix Academy",null,null,null,null,null,null,null,4990,"Running Start",null,"4990-Running Start"]
[null,null,null,null,null,"5040-iGrad",null,null,null,null,null,null,null,5000,"Kent Mtn View Academy",null,"5000-Kent Mtn View Academy"]
[null,null,null,null,null,"5050-Regional Justice Center",null,null,null,null,null,null,null,5030,"Kent Phoenix Academy",null,"5030-Kent Phoenix Academy"]
[null,null,null,null,null,"5100-Indian Education",null,null,null,null,null,null,null,5040,"iGrad",null,"5040-iGrad"]
[null,null,null,null,null,"5200-SpEd Administration",null,null,null,null,null,null,null,5050,"Regional Justice Center",null,"5050-Regional Justice Center"]
[null,null,null,null,null,"5210-SpEd Support",null,null,null,null,null,null,null,5100,"Indian Education",null,"5100-Indian Education"]
[null,null,null,null,null,"5220-SpEd In-Service Training",null,null,null,null,null,null,null,5200,"SpEd Administration",null,"5200-SpEd Administration"]
[null,null,null,null,null,"5230-Student Transp",null,null,null,null,null,null,null,5200,"SpEd Administration",null,"5200-SpEd Administration"]
[null,null,null,null,null,"5240-SpEd Unfilled & Unassigned",null,null,null,null,null,null,null,5210,"SpEd Support",null,"5210-SpEd Support"]
[null,null,null,null,null,"5250-SpEd Pymt Out of District",null,null,null,null,null,null,null,5210,"SpEd Support Services",null,"5210-SpEd Support Services"]
[null,null,null,null,null,"5270-SpEd Extended Schl Year",null,null,null,null,null,null,null,5220,"SpEd In","Service Training","5220-SpEd In-Service Training"]
[null,null,null,null,null,"5290-SpEd Portion, Sch Based Med",null,null,null,null,null,null,null,5230,"Student Transp",null,"5230-Student Transp"]
[null,null,null,null,null,"5310-SpEd Birth to 3 Agency Co",null,null,null,null,null,null,null,5240,"SpEd Unfilled & Unassigned",null,"5240-SpEd Unfilled & Unassigned"]
[null,null,null,null,null,"5330-Home & Hospital Instr",null,null,null,null,null,null,null,5250,"SpEd Pymt Out of District",null,"5250-SpEd Pymt Out of District"]
[null,null,null,null,null,"5340-Assistive Technology",null,null,null,null,null,null,null,5270,"SpEd Extended Schl Year",null,"5270-SpEd Extended Schl Year"]
[null,null,null,null,null,"5350-SpEd Suppl Costs",null,null,null,null,null,null,null,5290,"SpEd Portion, Sch Based Med",null,"5290-SpEd Portion, Sch Based Med"]
[null,null,null,null,null,"5360-Compensatory Time",null,null,null,null,null,null,null,5310,"SpEd Birth to 3 Agency Co",null,"5310-SpEd Birth to 3 Agency Co"]
[null,null,null,null,null,"5380-Developmentally Disabled",null,null,null,null,null,null,null,5330,"Home & Hospital Instr",null,"5330-Home & Hospital Instr"]
[null,null,null,null,null,"5390-SpEd Summer Assessment",null,null,null,null,null,null,null,5340,"Assistive Technology",null,"5340-Assistive Technology"]
[null,null,null,null,null,"5400-Bilingual/ELL",null,null,null,null,null,null,null,5350,"SpEd Suppl Costs",null,"5350-SpEd Suppl Costs"]
[null,null,null,null,null,"5510-CTE, Admin",null,null,null,null,null,null,null,5360,"Compensatory Time",null,"5360-Compensatory Time"]
[null,null,null,null,null,"5520-CTE, Prgm Support",null,null,null,null,null,null,null,5380,"Developmentally Disabled",null,"5380-Developmentally Disabled"]
[null,null,null,null,null,"5530-CTE, Career Centers",null,null,null,null,null,null,null,5390,"SpEd Summer Assessment",null,"5390-SpEd Summer Assessment"]
[null,null,null,null,null,"5540-CTE, Unfilled & Unassigned",null,null,null,null,null,null,null,5400,"Bilingual/ELL",null,"5400-Bilingual/ELL"]
[null,null,null,null,null,"5550-CTE, Landscaping",null,null,null,null,null,null,null,5400,"Bilingual Ed/ELL",null,"5400-Bilingual Ed/ELL"]
[null,null,null,null,null,"5570-CTE, Business Ed",null,null,null,null,null,null,null,5510,"CTE, Admin",null,"5510-CTE, Admin"]
[null,null,null,null,null,"5610-CTE, Marketing",null,null,null,null,null,null,null,5520,"CTE, Prgm Support",null,"5520-CTE, Prgm Support"]
[null,null,null,null,null,"5650-CTE , Auto Tech",null,null,null,null,null,null,null,5530,"CTE, Career Centers",null,"5530-CTE, Career Centers"]
[null,null,null,null,null,"5690-CTE, Culinary Arts",null,null,null,null,null,null,null,5540,"CTE, Unfilled & Unassigned",null,"5540-CTE, Unfilled & Unassigned"]
[null,null,null,null,null,"5710-CTE, Engineering",null,null,null,null,null,null,null,5550,"CTE, Landscaping",null,"5550-CTE, Landscaping"]
[null,null,null,null,null,"5720-CTE, Visual Comm",null,null,null,null,null,null,null,5570,"CTE, Business Ed",null,"5570-CTE, Business Ed"]
[null,null,null,null,null,"5730-CTE, Manufacturing",null,null,null,null,null,null,null,5610,"CTE, Marketing",null,"5610-CTE, Marketing"]
[null,null,null,null,null,"5740-CTE, Applied Programs",null,null,null,null,null,null,null,5650,"CTE , Auto Tech",null,"5650-CTE , Auto Tech"]
[null,null,null,null,null,"5750-CTE, Cosmetology",null,null,null,null,null,null,null,5690,"CTE, Culinary Arts",null,"5690-CTE, Culinary Arts"]
[null,null,null,null,null,"5760-CTE, Ind.Co-Op Ed (Ice)",null,null,null,null,null,null,null,5710,"CTE, Engineering",null,"5710-CTE, Engineering"]
[null,null,null,null,null,"5780-CTE, Welding",null,null,null,null,null,null,null,5720,"CTE, Visual Comm",null,"5720-CTE, Visual Comm"]
[null,null,null,null,null,"5850-CTE, Wood Tech",null,null,null,null,null,null,null,5730,"CTE, Manufacturing",null,"5730-CTE, Manufacturing"]
[null,null,null,null,null,"5870-CTE, Health Careers",null,null,null,null,null,null,null,5740,"CTE, Applied Programs",null,"5740-CTE, Applied Programs"]
[null,null,null,null,null,"5930-CTE, School-To-Work",null,null,null,null,null,null,null,5750,"CTE, Cosmetology",null,"5750-CTE, Cosmetology"]
[null,null,null,null,null,"5960-C.Perkins, Voc Fed",null,null,null,null,null,null,null,5760,"CTE, Ind.Co","Op Ed (Ice)","5760-CTE, Ind.Co-Op Ed (Ice)"]
[null,null,null,null,null,"5980-CTE, Family & Consumer Sci",null,null,null,null,null,null,null,5780,"CTE, Welding",null,"5780-CTE, Welding"]
[null,null,null,null,null,"6000-CTE, Media & Theatre Tech",null,null,null,null,null,null,null,5850,"CTE, Wood Tech",null,"5850-CTE, Wood Tech"]
[null,null,null,null,null,"6020-CTE, Aviation",null,null,null,null,null,null,null,5870,"CTE, Health Careers",null,"5870-CTE, Health Careers"]
[null,null,null,null,null,"6030-CTE, American Sign Lang",null,null,null,null,null,null,null,5930,"CTE, School","To","5930-CTE, School-To-Work"]
[null,null,null,null,null,"7290-Becca Bill Expenses",null,null,null,null,null,null,null,5960,"C.Perkins, Voc Fed",null,"5960-C.Perkins, Voc Fed"]
[null,null,null,null,null,"7300-Contract School",null,null,null,null,null,null,null,5980,"CTE, Family & Consumer Sci",null,"5980-CTE, Family & Consumer Sci"]
[null,null,null,null,null,"7330-Int'l Baccalaureate",null,null,null,null,null,null,null,6000,"CTE, Media & Theatre Tech",null,"6000-CTE, Media & Theatre Tech"]
[null,null,null,null,null,"7331-IB Admin Fees",null,null,null,null,null,null,null,6020,"CTE, Aviation",null,"6020-CTE, Aviation"]
[null,null,null,null,null,"7380-Credit Recovery",null,null,null,null,null,null,null,6030,"CTE, American Sign Lang",null,"6030-CTE, American Sign Lang"]
[null,null,null,null,null,"7400-H/R General Admin.",null,null,null,null,null,null,null,7290,"Becca Bill Expenses",null,"7290-Becca Bill Expenses"]
[null,null,null,null,null,"7440-Labor Relations",null,null,null,null,null,null,null,7300,"Contract School",null,"7300-Contract School"]
[null,null,null,null,null,"7470-New Teacher Training",null,null,null,null,null,null,null,7330,"Int'l Baccalaureate",null,"7330-Int'l Baccalaureate"]
[null,null,null,null,null,"7540-Title II, Instructional Svc",null,null,null,null,null,null,null,7331,"IB Admin Fees",null,"7331-IB Admin Fees"]
[null,null,null,null,null,"7550-Prgm/ Staff Development",null,null,null,null,null,null,null,7380,"Credit Recovery",null,"7380-Credit Recovery"]
[null,null,null,null,null,"7560-Core Curriculum",null,null,null,null,null,null,null,7400,"H/R General Admin.",null,"7400-H/R General Admin."]
[null,null,null,null,null,"7570-Program Evaluation",null,null,null,null,null,null,null,7440,"Labor Relations",null,"7440-Labor Relations"]
[null,null,null,null,null,"7580-Curriculum/TOSA",null,null,null,null,null,null,null,7470,"New Teacher Training",null,"7470-New Teacher Training"]
[null,null,null,null,null,"7600-Reading/TOSA",null,null,null,null,null,null,null,7540,"Title II, Instructional Svc",null,"7540-Title II, Instructional Svc"]
[null,null,null,null,null,"7610-Boeing Math/Science Grants",null,null,null,null,null,null,null,7550,"Prgm/ Staff Development",null,"7550-Prgm/ Staff Development"]
[null,null,null,null,null,"7620-Medicaid Costs",null,null,null,null,null,null,null,7560,"Core Curriculum",null,"7560-Core Curriculum"]
[null,null,null,null,null,"7630-Summer School,Gen'l Oper.",null,null,null,null,null,null,null,7570,"Program Evaluation",null,"7570-Program Evaluation"]
[null,null,null,null,null,"7635-AVID Summer Institute",null,null,null,null,null,null,null,7580,"Curriculum/TOSA",null,"7580-Curriculum/TOSA"]
[null,null,null,null,null,"7640-Summer School-Elem",null,null,null,null,null,null,null,7600,"Reading/TOSA",null,"7600-Reading/TOSA"]
[null,null,null,null,null,"7650-Summer School-MS",null,null,null,null,null,null,null,7610,"Boeing Math/Science Grants",null,"7610-Boeing Math/Science Grants"]
[null,null,null,null,null,"7660-Summer School-HS",null,null,null,null,null,null,null,7620,"Medicaid Costs",null,"7620-Medicaid Costs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,7630,"Summer School,Gen'l Oper.",null,"7630-Summer School,Gen'l Oper."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,7635,"AVID",null,"7635-AVID "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,7640,"Summer School Elem.",null,"7640-Summer School Elem."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,7640,"Summer School","Elem","7640-Summer School-Elem"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,7650,"Summer School","MS","7650-Summer School-MS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,7660,"Summer School","HS","7660-Summer School-HS"]

{"sheet":"Indirect Rates","index":7,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[[2,0,2,2],[26,0,26,2],[0,0,0,2],[25,0,25,2]]}
["Kent School District Indirect Rates 2019-20"]
[]
["School districts may claim a percentage of selected federal and state grant awards in order to recover indirect expenses associated with general program operations.  KSD requires allowable indirects be taken on all grant and categorical programs unless the district’s Exec. Director of Finance has approved an exception. Below is a list of district grants with their 2019-20 indirect percentage rates."]
["4.05% Indirects – KSD Federal Restricted Indirect Rate for 2019-20",null,"Prog. #"]
["LAP - Learning Assistance Program",null,"5520-5522"]
["OSSI Targeted 3+ Schools (Title I)",null,5174]
["Perkins",null,3860]
["Refugee School Impact Grant",null,7914]
["Special Ed IDEA-B Sec 611 & Preschool Sec 619 Flow-Thru",null,"2450-2451"]
["Title I-A Improving Basic Programs",null,"5150-5161"]
["Title II-A Professional Development",null,"5213-5214"]
["Title III Limited English Proficiency",null,6418]
["Title IV-A Student Support & Academic Enrichment",null,5234]
["Title VI Indian Ed",null,6899]
["Title X-C Homeless Mini-Grant",null,5172]
[]
[]
["7% Indirects – % Determined by State or Federal Agency",null,"Prog. #"]
["BEST - Beginning Educator Support Team",null,5840]
["OSSI Comprehensive Low Grad (Non-Title I)",null,5804]
["OSSI Targeted 3+ (Non-Title I)",null,5806]
["OSSI Comprehensive School (Non-Title I)",null,5808]
["TPEP Teacher Training Funds",null,5880]
[]
[]
["Calculating Indirect Amounts"]
["To calculate indirect amounts, divide the grant award by 1.00 plus the indirect percentage rate.  The difference between the calculated amount and the total grant is the amount used for indirect expenditures."]
[]
["Example - Total grant award is $750,000 and the indirect rate is 4.05%"]
[]
["$750,000 ¸ 1.0405 = $720,808 (round up) ® amount of award available for direct program expenditures               "]
["$750,000 - $720,808 = $29,192®  amount of award that may be claimed for indirect expenditures "]