{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Salary Schedule","Adult+DW Participant Cost sched","ADULT","Dislocated Worker","Youth Staffing WBL schedule","Youth","GRAND TOTAL ","example completed form"],"read":"whole","date_system":"1900"}

{"sheet":"Salary Schedule","index":0,"n_rows":38,"n_cols":9,"rows_kept":38,"merged":[[17,4,17,6]]}
["              WORKFORCE INNOVATION AND OPPORTUNITY ACT"]
["                                                   GRANT BUDGET"]
["               SALARY SCHEDULE – _____/____/_____ to ___/___/_____"]
[null,null,"WIOA 2022-01- ADY-OSO"]
["NAME OF ORGANIZATION (GRANTEE PROPOSER):________________________________________"]
[]
["Staff Position Title (do NOT list names of staff)","Location /County","Wages per Hour (A)","Hours per week (B)","Annualized Wages         ((AxB)x52)","Program Wages (C)","Administration Wages            (D)"]
{"$rows_empty":9}
["TOTAL"]
[{"$nulls":4},"Annualized Wages Total must equal PROGRAM WAGES  + ADMINISTRATION WAGES (C) + (D)"]
[]
[]
[]
["              WORKFORCE INNOVATION AND OPPORTUNITY ACT"]
["                                                   GRANT BUDGET"]
["               SALARY ALLOCATION SCHEDULE – _____/____/_____ to ___/___/_____"]
[null,null,"WIOA 2022-01- ADY-OSO"]
["NAME OF ORGANIZATION (GRANTEE PROPOSER):________________________________________"]
[]
["Staff Position Title (do NOT list names of staff)","Location /County","Annualized Wages         ","Allocation of Annualized Wages to PROGRAM ADULT                  ","Allocation of Annualized Wages to PROGRAM  DISLOCATED WORKER                ","Allocation of Annualized Wages to PROGRAM YOUTH          ","Allocation of Annualized Wages to AMINISTRATION  ADULT                  ","Allocation of Annualized Wages to ADMINISTRATION  DISLOCATED WORKER                ","Allocation of Annualized Wages to ADMINISTRATION YOUTH          "]
{"$rows_empty":9}
["TOTAL"]

{"sheet":"Adult+DW Participant Cost sched","index":1,"n_rows":16,"n_cols":3,"rows_kept":16}
["              WORKFORCE INNOVATION AND OPPORTUNITY ACT"]
["WIOA 2022-01- ADY-OSO"]
["               PARTICIPANT COST SCHEDULE (ADULT + DW) "]
["_____/____/_____ to ___/___/_____"]
[]
["NAME OF ORGANIZATION (GRANTEE PROPOSER):________________________________________"]
[]
["Total Participant Costs Adult",null," (a)"]
["Total Participant Costs Dislocated Worker",null," (b)"]
["Grand Total Participant Costs (Adult + Dislocated Worker)",null," (a) + (b) = C"]
[]
["Total Program Costs Adult",null,"(d)"]
["Total Program Costs Dislocated Worker",null,"(e)"]
["Grand Total Program Costs (Adult + Dislocated Worker)",null,"(d) + (e) = F"]
[]
["Participant Cost Rate                      (Grand Total Participant Costs/Grand Total Program Costs (C/F))","_______%"]

{"sheet":"ADULT","index":2,"n_rows":36,"n_cols":4,"rows_kept":36}
["              WORKFORCE INNOVATION AND OPPORTUNITY ACT"]
["                                                 ADULT  GRANT BUDGET"]
["         ",null,"_____/____/_____ to ___/___/_____"]
[null,null,"WIOA 2022-01- ADY-OSO"]
["NAME OF ORGANIZATION (GRANTEE PROPOSER):________________________________________"]
[]
["Adult  (CDFA 17.258)"," Budget","% Applicable","Calculation Formula"]
["ADMINISTRATION"]
["Salaries"]
["Fringe Benefits",null,"__________","x ______________"]
["Indirect Cost",null,"__________","x ______________"]
["Operating Expenses"]
["Profit",null,"__________","x ______________"]
["Administration Sub-Total",{"$f":"SUM(B9:B13)","v":0}]
["PROGRAM"]
["Salaries"]
["Fringe Benefits",null,"__________","x ______________"]
["Indirect Cost",null,"__________","x ______________"]
["Operating Expenses"]
["Profit",null,"__________","x ______________"]
["Total Non-Participant Costs",{"$f":"B16+B17+B18+B19+B20","v":0},"__________","of TOTAL PROGRAM"]
[]
["Participant Costs"]
["  Assessment",null,"# ______ @ $________/PER"]
["  High School Equivalency",null,"# ______ @ $________/PER"]
["  Occ. Skills Training",null,"# ______ @ $________/PER"]
[]
["  Supportive Services",null,"# ______ @ $________/PER"]
["    Transportation"]
["    Childcare"]
["    Books, Supplies, Uniforms"]
["    Other"]
[null,null,"# ______ @ $________/PER"]
["Total Participant Costs (a)",{"$f":"SUM(B23:B33)","v":0},"________%","of TOTAL PROGRAM"]
["Program Sub-Total (d)",{"$f":"B34+B21","v":0}]
["Total Grant Cost",{"$f":"B35+B14","v":0}]

{"sheet":"Dislocated Worker","index":3,"n_rows":36,"n_cols":4,"rows_kept":36}
["              WORKFORCE INNOVATION AND OPPORTUNITY ACT"]
["                          DISLOCATED WORKER GRANT BUDGET"]
["         ",null,"_____/____/_____ to ___/___/_____"]
[null,null,"WIOA 2022-01- ADY-OSO"]
["NAME OF ORGANIZATION (GRANTEE PROPOSER):________________________________________"]
[]
["Dislocated Worker                      (CDFA 17.278)"," Budget","% Applicable","Calculation Formula"]
["ADMINISTRATION"]
["Salaries"]
["Fringe Benefits",null,"__________","x ______________"]
["Indirect Cost",null,"__________","x ______________"]
["Operating Expenses"]
["Profit",null,"__________","x ______________"]
["Administration Sub-Total",{"$f":"SUM(B9:B13)","v":0}]
["PROGRAM"]
["Salaries"]
["Fringe Benefits",null,"__________","x ______________"]
["Indirect Cost",null,"__________","x ______________"]
["Operating Expenses"]
["Profit",null,"__________","x ______________"]
["Total Non-Participant Costs",{"$f":"SUM(B16:B20)","v":0},"__________","of TOTAL PROGRAM"]
[]
["Participant Costs"]
["  Assessment",null,"# ______ @ $________/PER"]
["  High School Equivalency",null,"# ______ @ $________/PER"]
["  Occ. Skills Training",null,"# ______ @ $________/PER"]
[]
["  Supportive Services",null,"# ______ @ $________/PER"]
["    Transportation"]
["    Childcare"]
["    Books, Supplies, Uniforms"]
["    Other"]
[null,null,"# ______ @ $________/PER"]
["Total Participant Costs (b)",{"$f":"SUM(B23:B33)","v":0},"________%","of TOTAL PROGRAM"]
["Program Sub-Total (e)",{"$f":"B34+B21","v":0}]
["Total Grant Cost",{"$f":"B35+B14","v":0}]

{"sheet":"Youth Staffing WBL schedule","index":4,"n_rows":15,"n_cols":4,"rows_kept":15,"merged":[[12,0,12,1],[14,0,14,3]]}
["              WORKFORCE INNOVATION AND OPPORTUNITY ACT"]
[]
["               YOUTH STAFFING WORK-BASED LEARNING COST SCHEDULE "]
[{"$nulls":3},"_____/____/_____ to ___/___/_____"]
[null,null,"WIOA 2022-01- ADY-OSO"]
["NAME OF ORGANIZATION (GRANTEE PROPOSER):________________________________________"]
[]
["PROGRAM","Of Staff Working to Develop and Manage Youth Work-Based Learning (A)","Balance of  Youth Staff cost (B)","TOTAL COST (A+B, MUST MATCH TOTAL YOUTH PROGRAM BUDGET)"]
["Salaries*"]
["Fringe Benefits*"]
["    TOTALS"]
[]
["* $40,000 is maximum allowable expenditure for Work Based Learning Front-line Youth Staff Salary & Fringe costs"]
[]
["As stated in TEGL No. 23-14, program expenditures on the work experience program element can be more than just wages paid to youth in work experience. Allowable expenditures beyond wages can include staff time spent identifying potential work experience opportunities, staff time working with employers to develop the work experience, staff time spent working with employers to ensure a successful work experience, staff time spent evaluating the work experience, participant work experience orientation sessions, classroom training or the required academic education component directly related to the work experience, and orientations for employers."]

{"sheet":"Youth","index":5,"n_rows":41,"n_cols":4,"rows_kept":41,"merged":[[36,0,36,1]]}
["              WORKFORCE INNOVATION AND OPPORTUNITY ACT"]
["                         YOUTH GRANT BUDGET"]
["_____/____/_____ to ___/___/_____                                          "]
["WIOA 2022-01- ADY-OSO"]
["NAME OF ORGANIZATION (GRANTEE PROPOSER):________________________________________"]
[]
["Youth (CDFA 17.259)"," Budget","% Applicable","Calculation Formula"]
["ADMINISTRATION"]
["Salaries"]
["Fringe Benefits",null,"__________","x ______________"]
["Indirect Cost",null,"__________","x ______________"]
["Operating Expenses"]
["Profit",null,"__________","x ______________"]
["Administration Sub-Total",{"$f":"SUM(B9:B13)","v":0}]
["PROGRAM"]
["Salaries*",{"$f":"'Youth Staffing WBL schedule'!D9","v":0}]
["Fringe Benefits*",{"$f":"'Youth Staffing WBL schedule'!D10","v":0},"__________","x ______________"]
["Indirect Cost",null,"__________","x ______________"]
["Operating Expenses"]
["Profit",null,"__________","x ______________"]
["Total Non-Participant Costs",{"$f":"B16+B17+B18+B19+B20","v":0},"__________","of TOTAL PROGRAM"]
[]
["DETAIL - Participant Costs             "]
["  Assessment",null,"# ______ @ $________/PER"]
["  High School Equivalency",null,"# ______ @ $________/PER"]
["  Occ. Skills Training",null,"# ______ @ $________/PER"]
["  Youth Incentives",null,"# ______ @ $________/PER"]
["  Supportive Services",null,"# ______ @ $________/PER"]
["    Transportation"]
["    Childcare"]
["    Books, Supplies, Uniforms"]
["    Other"]
["  Youth Work Experience     ",null,"# ______ @ $________/PER"]
["Total Participant Costs",{"$f":"B26+B33+B28","v":0},"__________%","of TOTAL PROGRAM"]
["Program Sub-Total",{"$f":"B21+B34","v":0}]
["Total Grant Cost",{"$f":"B35+B14","v":0}]
["* $40,000 is maximum allowable expenditure for Work Based Learning Front-line Youth Staff Salary & Fringe costs"]
[]
["Only a Total of Support Services is need for the Budget. "]
["HOWEVER, the successful proposer will be required to track and report expenditures"]
["by the detailed type of support services "]

{"sheet":"GRAND TOTAL ","index":6,"n_rows":37,"n_cols":4,"rows_kept":37}
["              WORKFORCE INNOVATION AND OPPORTUNITY ACT"]
[]
["              GRAND TOTAL - ALL GRANTS (ADULT + DISLOCATED WORKER + YOUTH)"]
[{"$nulls":3},"_____/____/_____ to ___/___/_____"]
[null,"WIOA 2022-01- ADY-OSO"]
["NAME OF ORGANIZATION (GRANTEE PROPOSER):________________________________________"]
[]
["Total Non-Participant Costs","Budget"]
["ADMINISTRATION"]
["Salaries"]
["Fringe Benefits"]
["Indirect Cost"]
["Operating Expenses"]
["Profit"]
["Administration Sub-Total",{"$f":"SUM(B10:B14)","v":0}]
["PROGRAM"]
["Salaries*"]
["Fringe Benefits*"]
["Indirect Cost"]
["Operating Expenses"]
["Profit"]
["Total Non-Participant Costs",{"$f":"B17+B18+B19+B20+B21","v":0}]
[]
["DETAIL - Participant Costs             "]
["  Assessment"]
["  High School Equivalency"]
["  Occ. Skills Training"]
["  Youth Incentives"]
["  Supportive Services"]
["    Transportation"]
["    Childcare"]
["    Books, Supplies, Uniforms"]
["    Other"]
["  Youth Work Experience     "]
["Total Participant Costs",{"$f":"B27+B34+B29","v":0}]
["Program Sub-Total",{"$f":"B22+B35","v":0}]
["Total Grant Cost",{"$f":"B36+B15","v":0}]

{"sheet":"example completed form","index":7,"n_rows":45,"n_cols":4,"rows_kept":45}
["              WORKFORCE INNOVATION AND OPPORTUNITY ACT"]
["                         YOUTH GRANT BUDGET"]
[null,"06/30/2023 - 06/30/2024","     "]
[null,"WIOA 2022-01- ADY-OSO"]
["NAME OF ORGANIZATION (GRANTEE PROPOSER): XYZ, INC."]
{"$rows_empty":11}
["Youth (CDFA 17.259)"," Budget","% Applicable","Calculation Formula"]
["ADMINISTRATION"]
["Salaries",{"v":8500,"d":"8,500.00"}]
["Fringe Benefits",{"$f":"B19*0.2","v":{"v":1700,"d":"1,700.00"}},{"$f":"B20/B19","v":{"v":0.2,"d":"0.20"}}," x  Salaries"]
["Indirect Cost",{"$f":"(B19+B20+B22)*0.1","v":{"v":1020,"d":"1,020.00"}},{"v":0.1,"d":"0.10"}," x  (Salaries + Fringe + Operating)"]
["Operating Expenses",0]
["Profit",{"$f":"(B19+B20)*0.08","v":{"v":816,"d":"816.00"}},0.08," x (Salaries + Fringe)"]
["Administration Sub-Total",{"$f":"SUM(B19:B23)","v":{"v":12036,"d":"12,036.00"}},{"$f":"B24/B45","v":{"v":0.04457777777777778,"d":"0.04"}}]
["PROGRAM"]
["Salaries*",{"v":90000,"d":"90,000.00"}]
["Fringe Benefits*",{"v":25500,"d":"25,500.00"},{"$f":"B27/B26","v":{"v":0.2833333333333333,"d":"0.28"}}," x  Salaries"]
["Indirect Cost",{"$f":"(B26+B27+B29)*0.1","v":{"v":12660,"d":"12,660.00"}},{"v":0.1,"d":"0.10"}," x (Salaries + Fringe + Operating)"]
["Operating Expenses",{"v":11100,"d":"11,100.00"}]
["Profit",{"$f":"(B26+B27)*0.08","v":{"v":9240,"d":"9,240.00"}},0.08," x (Salaries + Fringe)"]
["Total Non-Participant Costs",{"$f":"B26+B27+B28+B29+B30","v":{"v":148500,"d":"148,500.00"}},{"$f":"B31/B44","v":{"v":0.5756617202400335,"d":"0.58"}},"of total program"]
["Participant Costs                 "]
["  Assessment"]
["  High School Equivalency"]
["  Occ. Skills Training",{"v":40000,"d":"40,000.00"},"8 @ 5000"]
["  Youth Incentives"]
["  Supportive Services",{"v":9464,"d":"9,464.00"},"8  @ 1183"]
["    Transportation"]
["    Childcare"]
["    Books, Supplies, Uniforms"]
["    Other"]
["  Youth Work Experience     ",{"v":60000,"d":"60,000.00"}]
["Total Participant Costs",{"$f":"B35+B42+B37","v":{"v":109464,"d":"109,464.00"}},{"$f":"B43/B44","v":{"v":0.4243382797599665,"d":"42.4%"}},"of total program"]
["Program Sub-Total",{"$f":"B31+B43","v":{"v":257964,"d":"257,964.00"}}]
["Total Grant Cost",{"$f":"B44+B24","v":{"v":270000,"d":"270,000.00"}}]