{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"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":"Sheet1","index":0,"n_rows":198,"n_cols":12,"rows_kept":198,"cut":false,"hidden":false,"merged":[[157,6,157,7],[157,8,157,9],[0,0,0,4],[7,6,7,11],[92,6,92,7],[107,9,107,10],[156,6,156,9]]}
["FY23 Contract Budget"]
[null,"Contractor : ","Subgrantee 3 - To be procured","Contract # "," "]
[null,"DFPS PAC #  "," ","Budget Preparer: "]
[null,"PEI Program :"," ","Certifying Approver: "," "]
[null,"Total DFPS Contractual Obligation : ",{"$f":"B50+B93+B108+B116+B129+B135+B153+B169+B177","v":0}]
[null,"Total Match : ",{"$f":"D50+D93+D108+D116+D129+D135+D153+D169+D177","v":0}]
[null,"Funding Period : ","10/01/2022 to 08/31/2023",null," "]
[null,null," ",null," ",null,"FTE Allocations"]
["PERSONNEL - SALARIES","DFPS Contract Budget","Methodology for \nContract Budget Narrative","Match \nBudget","Methodology for \nMatch Budget Narrative",null," Total Salary","FTE","% Time Allocated to DFPS Contract","% Time Allocated to  Match","Number of months on contract","Direct Service or Admin?"]
["1",{"$f":"IF(K10=0,\"0\",ROUND((G10/12)*H10*I10*K10,2))","v":"0"},null,{"$f":"IF(K10=0,\"0\",ROUND((G10/12)*H10*J10*K10,2))","v":"0"},null,null,0,0,0,0,0]
["2",{"$f":"IF(K11=0,\"0\",ROUND((G11/12)*H11*I11*K11,2))","v":"0"},null,{"$f":"IF(K11=0,\"0\",ROUND((G11/12)*H11*J11*K11,2))","v":"0"},null,null,0,0,0,0,0]
["3","0",null,"0",null,null,0,0,0,0,0]
[4,"0",null,"0",null,null,0,0,0,0,0]
[5,"0",null,"0",null,null,0,0,0,0,0]
[6,"0",null,"0",null,null,0,0,0,0,0]
[7,"0",null,"0",null,null,0,0,0,0,0]
[8,"0",null,"0",null,null,0,0,0,0,0]
[9,"0",null,"0",null,null,0,0,0,0,0]
[10,"0",null,"0",null,null,0,0,0,0,0]
[11,"0",null,"0",null,null,0,0,0,0,0]
[12,"0",null,"0",null,null,0,0,0,0,0]
[13,"0",null,"0",null,null,0,0,0,0,0]
[14,"0",null,"0",null,null,0,0,0,0,0]
[15,"0",null,"0",null,null,0,0,0,0,0]
[16,"0",null,"0",null,null,0,0,0,0,0]
[17,"0",null,"0",null,null,0,0,0,0,0]
[18,"0",null,"0",null,null,0,0,0,0,0]
[19,"0",null,"0",null,null,0,0,0,0,0]
[20,"0",null,"0",null,null,0,0,0,0,0]
[21,"0",null,"0",null,null,0,0,0,0,0]
[22,"0",null,"0",null,null,0,0,0,0,0]
[23,"0",null,"0",null,null,0,0,0,0,0]
[24,"0",null,"0",null,null,0,0,0,0,0]
[25,"0",null,"0",null,null,0,0,0,0,0]
[26,"0",null,"0",null,null,0,0,0,0,0]
[27,"0",null,"0",null,null,0,0,0,0,0]
[28,"0",null,"0",null,null,0,0,0,0,0]
[29,"0",null,"0",null,null,0,0,0,0,0]
[30,"0",null,"0",null,null,0,0,0,0,0]
[31,"0",null,"0",null,null,0,0,0,0,0]
[32,"0",null,"0",null,null,0,0,0,0,0]
[33,"0",null,"0",null,null,0,0,0,0,0]
[34,"0",null,"0",null,null,0,0,0,0,0]
[35,"0",null,"0",null,null,0,0,0,0,0]
[36,"0",null,"0",null,null,0,0,0,0,0]
[37,"0",null,"0",null,null,0,0,0,0,0]
[38,"0",null,"0",null,null,0,0,0,0,0]
[39,"0",null,"0",null,null,0,0,0,0,0]
[40,"0",null,"0",null,null,0,0,0,0,0]
["Total",{"$f":"SUM(B10:B49)","v":0},null,{"$f":"SUM(D10:D49)","v":0},null,null,{"$f":"SUM(G10:G49)","v":0}]
[]
["FRINGE by EMPLOYEE","DFPS Contract Budget","Methodology for \nContract Budget Narrative","Match \nBudget","Methodology for \nMatch Budget Narrative",null,"Total Fringe per Employee","FTE","% Fringe Allocated to DFPS Contract","% Fringe Allocated to  Match","Number of months on contract","Fringe % of Salary "]
[{"$f":"A10","v":"1"},{"$f":"IF(K53=0,\"0\",ROUND((G53/12)*H53*I53*K53,2))","v":"0"},null,{"$f":"IF(K53=0,\"0\",ROUND((G53/12)*H53*J53*K53,2))","v":"0"},null,null,{"$f":"G10*L53","v":0},{"$f":"H10","v":0},0,0,0,0]
["2",{"$f":"IF(K54=0,\"0\",ROUND((G54/12)*H54*I54*K54,2))","v":"0"},null,{"$f":"IF(K54=0,\"0\",ROUND((G54/12)*H54*J54*K54,2))","v":"0"},null,null,0,0,0,0,0,0]
["3","0",null,"0",null,null,0,0,0,0,0,0]
[4,"0",null,"0",null,null,0,0,0,0,0,0]
[5,"0",null,"0",null,null,0,0,0,0,0,0]
[6,"0",null,"0",null,null,0,0,0,0,0,0]
[7,"0",null,"0",null,null,0,0,0,0,0,0]
[8,"0",null,"0",null,null,0,0,0,0,0,0]
[9,"0",null,"0",null,null,0,0,0,0,0,0]
[10,"0",null,"0",null,null,0,0,0,0,0,0]
[11,"0",null,"0",null,null,0,0,0,0,0,0]
[12,"0",null,"0",null,null,0,0,0,0,0,0]
[13,"0",null,"0",null,null,0,0,0,0,0,0]
[14,"0",null,"0",null,null,0,0,0,0,0,0]
[15,"0",null,"0",null,null,0,0,0,0,0,0]
[16,"0",null,"0",null,null,0,0,0,0,0,0]
[17,"0",null,"0",null,null,0,{"$f":"H26","v":0},0,0,0,0]
[18,"0",null,"0",null,null,0,0,0,0,0,0]
[19,"0",null,"0",null,null,0,0,0,0,0,0]
[20,"0",null,"0",null,null,0,0,0,0,0,0]
[21,"0",null,"0",null,null,0,0,0,0,0,0]
[22,"0",null,"0",null,null,0,0,0,0,0,0]
[23,"0",null,"0",null,null,0,0,0,0,0,0]
[24,"0",null,"0",null,null,0,0,0,0,0,0]
[25,"0",null,"0",null,null,0,0,0,0,0,0]
[26,"0",null,"0",null,null,0,0,0,0,0,0]
[27,"0",null,"0",null,null,0,0,0,0,0,0]
[28,"0",null,"0",null,null,0,0,0,0,0,0]
[29,"0",null,"0",null,null,0,0,0,0,0,0]
[30,"0",null,"0",null,null,0,0,0,0,0,0]
[31,"0",null,"0",null,null,0,0,0,0,0,0]
[32,"0",null,"0",null,null,0,0,0,0,0,0]
[33,"0",null,"0",null,null,0,{"$f":"H42","v":0},0,0,0,0]
[34,"0",null,"0",null,null,0,0,0,0,0,0]
[35,"0",null,"0",null,null,0,0,0,0,0,0]
[36,"0",null,"0",null,null,0,0,0,0,0,0]
[37,"0",null,"0",null,null,0,0,0,0,0,0]
[38,"0",null,"0",null,null,0,0,0,0,0,0]
[39,"0",null,"0",null,null,0,0,0,0,0,0]
[40,"0",null,"0",null,null,0,0,0,0,0,0]
["Total",{"$f":"ROUND(SUM(B53:B92),2)","v":0},null,{"$f":"SUM(D53:D92)","v":0},null,null,"Total Fringe % (of Salary)",null,{"$f":"IF(B50=0,0,B93/B50)","v":0},{"$f":"IF(B50=0,0,D93/B50)","v":0}]
[]
["FRINGE by TYPE of BENEFIT","DFPS Contract Budget","Methodology for \nContract Budget Narrative","Match \nBudget","Methodology for \nMatch Budget Narrative",null,"Total Fringe for DFPS Program Benefits","% Fringe Allocated to DFPS Contract","% Fringe Allocated to  Match"]
["Social Security (FICA)",{"$f":"G96*H96","v":0},null,{"$f":"G96*I96","v":0},null,null,0,0,0]
["State Unemployment Tax Act (SUTA)",{"$f":"G97*H97","v":0},null,{"$f":"G97*I97","v":0},null,null,0,0,0]
["Retirement",0,null,0,null,null,0,0,0]
["Insurance- Medical",0,null,0,null,null,0,0,0]
["Insurance- Dental",0,null,0,null,null,0,0,0]
["Insurance- Vision",0,null,0,null,null,0,0,0]
["Insurance- Worker's Compensation ",0,null,0,null,null,0,0,0]
["Insurance- Unemployment ",0,null,0,null,null,0,0,0]
["Short-Term Disability",0,null,0,null,null,0,0,0]
["Long-Term Disability",0,null,0,null,null,0,0,0]
["Life Insurance",0,null,0,null,null,0,0,0]
["Other Fringe",0,null,0,null,null,0,0,0]
["Total",{"$f":"SUM(B96:B107)","v":0},null,{"$f":"SUM(D96:D107)","v":0},null,null,null,{"$f":"B108/B50","v":{"$error":"#DIV/0!"}},{"$f":"D108/B50","v":{"$error":"#DIV/0!"}},"Total Fringe % (of Salary)"]
[]
["TRAVEL  ","DFPS Contract Budget","Methodology for \nContract Budget Narrative","Match \nBudget","Methodology for \nMatch Budget Narrative"]
["Mileage",null," ",0," "]
["Airfare",0," ",0," "]
["Meals",0," ",0," "]
["Lodging",0," ",0," "]
["Miscellaneous Transportation",0," ",0," "]
["Total",{"$f":"SUM(B111:B115)","v":0},null,{"$f":"SUM(D111:D115)","v":0}]
[]
["SUPPLIES and CONTROLLED ASSETS","DFPS Contract Budget","Methodology for \nContract Budget Narrative","Match \nBudget","Methodology for \nMatch Budget Narrative"]
["Office Supplies",0,null,0]
["Program Curriculum",0,null,0]
["Outreach Materials/Program Literature",0,null,0]
["Technology (controlled assets)",0,null,0]
["other supplies and controlled assets",0,null,0]
["other supplies and controlled assets",0,null,0]
["other supplies and controlled assets",0,null,0]
["other supplies and controlled assets",0,null,0]
["other supplies and controlled assets",0,null,0]
["other supplies and controlled assets",0,null,0]
["Total",{"$f":"SUM(B119:B128)","v":0},null,{"$f":"SUM(D119:D128)","v":0}]
[]
["CAPITAL EQUIPMENT (greater than $5K)","DFPS Contract Budget","Methodology for \nContract Budget Narrative","Match \nBudget","Methodology for \nMatch Budget Narrative"]
[null,0,null,0]
[null,0,null,0]
[null,0,null,0]
["Total",{"$f":"SUM(B132:B134)","v":0},null,{"$f":"SUM(D132:D134)","v":0}]
[]
["OTHER","DFPS Contract Budget","Methodology for \nContract Budget Narrative","Match \nBudget","Methodology for \nMatch Budget Narrative"]
["Other",0," ",0," "]
["Other",0," ",0," "]
["Other",0," ",0," "]
["Other",0," ",0," "]
["Other",0," ",0," "]
["Other",0," ",0," "]
["Other",0," ",0," "]
["Other",0," ",0," "]
["Other",0," ",0," "]
["Other",0," ",0," "]
["Other",0," ",0," "]
["Other",0," ",0," "]
["Other",0," ",0," "]
["Other",0," ",0," "]
["Other",0," ",0," "]
["Total",{"$f":"SUM(B138:B152)","v":0},null,{"$f":"SUM(D138:D152)","v":0}]
[]
["SUBTOTAL \nExcluding Subcontractors","DFPS Contract Budget","Methodology for \nContract Budget Narrative","Match \nBudget","Methodology for \nMatch Budget Narrative"]
[" ",{"$f":"B50+B93+B108+B116+B129+B135+B153","v":0},null,{"$f":"D50+D93+D108+D116+D129+D135+D153","v":0}]
[null,null,null,null,null,null,"Subcontractor Expenses Added to Indirect Cost Budget"]
["CONTRACTUAL - \nSubcontractors","DFPS Contract Budget","Methodology for \nContract Budget Narrative","Match \nBudget","Methodology for \nMatch Budget Narrative",null,"Reimburseable Amount Subject to Indirect Cost Rate",null,"Match Amount \nSubject to Indirect Cost Rate"]
[null,null,"see corresponding tab for budget details",null,"see corresponding tab for budget details",null,null,0,null,0]
[null,null,"see corresponding tab for budget details",null,"see corresponding tab for budget details",null,null,0,null,0]
[null,null,"see corresponding tab for budget details",null,"see corresponding tab for budget details",null,null,0,null,0]
[null,null,"see corresponding tab for budget details",null,"see corresponding tab for budget details",null,null,0,null,0]
[null,null,"see corresponding tab for budget details",null,"see corresponding tab for budget details",null,null,0,null,0]
[" ",0,"see corresponding tab for budget details",0,"see corresponding tab for budget details",null,null,0,null,0]
[" ",0,"see corresponding tab for budget details",0,"see corresponding tab for budget details",null,null,0,null,0]
[" ",0,"see corresponding tab for budget details",0,"see corresponding tab for budget details",null,null,0,null,0]
[" ",0,"see corresponding tab for budget details",0,"see corresponding tab for budget details",null,null,0,null,0]
[" ",0,"see corresponding tab for budget details",0,"see corresponding tab for budget details",null,null,0,null,0]
["Total",{"$f":"SUM(B159:B168)","v":0},null,{"$f":"SUM(D159:D168)","v":0}]
[]
["Subcontractor Costs added to the Indirect Cost Calculation"]
[" ",{"$f":"SUM(H159:H168)","v":0},null,{"$f":"SUM(J159:J168)","v":0}]
[]
["INDIRECT COSTS","DFPS Contract Budget","Methodology for \nContract Budget Narrative","Match \nBudget","Methodology for \nMatch"]
[0,{"$f":"ROUND(B156+B172,2)*A175","v":0}," ",{"$f":"ROUND(D156+D172,2)*A175","v":0}," "]
["Indirect Cost Rate adjustment",0,null,0]
["Total",{"$f":"SUM(B175:B176)","v":0},null,{"$f":"SUM(D175:D176)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Direct Service or Admin?"]
["Direct Service"]
["Admin"]