{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["FFY 18 Budget Summary","FFY 18 Annual Budget Detail","Indirect Double Check","Fringe Double Check"],"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":"FFY 18 Budget Summary","index":0,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,3],[22,0,22,3],[2,0,2,3],[3,0,3,3],[4,0,4,3],[5,0,5,3],[6,0,6,3]]}
[]
[]
["BUDGET SUMMARY"]
["(OFFICIAL NAME OF SUBCONTRACTING AGENCY)"]
["Subcontracted Under (NAME OF CONTRACTOR)"]
["October 1, 2017 through September 30, 2018"]
["(FFY 2018)"]
[]
[]
["Budget Line Categories","State Share           (Not Reimbursable)","Federal Share (Reimbursable)","Total Program Costs"]
["Personnel Salaries",{"$f":"D11-C11","v":0},{"$f":"ROUND(D11*$D$25,0)","v":0},{"$f":"'FFY 18 Annual Budget Detail'!J39","v":0}]
["Fringe Benefits",{"$f":"D12-C12","v":0},{"$f":"ROUND(D12*$D$25,0)","v":0},{"$f":"'FFY 18 Annual Budget Detail'!J70","v":0}]
["Operating Expenses",0,0,{"$f":"'FFY 18 Annual Budget Detail'!J107","v":0}]
["Equipment (Not Allowable) ",0,0,{"$f":"'FFY 18 Annual Budget Detail'!J112","v":0}]
["Travel and Per Diem",0,0,{"$f":"'FFY 18 Annual Budget Detail'!J129","v":0}]
["Subcontractors (Not Applicable)",0,0,{"$f":"'FFY 18 Annual Budget Detail'!J134","v":0}]
["Other Costs",0,0,{"$f":"'FFY 18 Annual Budget Detail'!J171","v":0}]
["Indirect Costs",0,0,{"$f":"'FFY 18 Annual Budget Detail'!J189","v":0}]
["TOTALS",0,{"$f":"ROUND(D19*$D$25,0)","v":0},{"$f":"'FFY 18 Annual Budget Detail'!J192","v":0}]
[]
[]
[]
["Note: This summary worksheet will be automatically populated by data entered from the Annual Budget Detail worksheet. Please check to ensure that all data transfers properly and that all calculations are correct."]
[]
["Percent of Total Program Costs to be Reimbursed by Contractor:",null,null,0.33333333329999998]

{"sheet":"FFY 18 Annual Budget Detail","index":1,"n_rows":222,"n_cols":10,"rows_kept":222,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9],[2,0,2,9],[3,0,3,9],[4,0,4,9],[5,0,5,9],[7,0,7,9],[161,1,161,7],[162,1,162,7],[141,1,141,7],[142,1,142,7],[143,1,143,7],[144,1,144,7],[145,1,145,7],[146,1,146,7],[147,1,147,7],[148,1,148,7],[149,1,149,7],[137,1,137,6],[140,1,140,7],[29,4,29,6],[27,4,27,6],[30,1,30,3],[31,1,31,3],[163,1,163,7],[164,1,164,7],[165,1,165,7],[166,1,166,7],[167,1,167,7],[150,1,150,7],[151,1,151,7],[152,1,152,7],[155,1,155,7],[156,1,156,7],[157,1,157,7],[158,1,158,7],[159,1,159,7],[160,1,160,7],[88,1,88,7],[91,1,91,7],[92,1,92,7],[93,1,93,7],[94,1,94,7],[30,4,30,6],[28,1,28,3],[17,4,17,6],[33,4,33,6],[33,1,33,3],[35,4,35,6],[42,1,42,9],[31,4,31,6],[35,1,35,3],[86,1,86,7],[87,1,87,7],[32,1,32,3],[34,1,34,3],[34,4,34,6],[32,4,32,6],[38,1,38,8],[43,1,43,9],[52,1,52,9],[57,1,57,9],[15,1,15,3],[15,4,15,6],[29,1,29,3],[28,4,28,6],[18,4,18,6],[27,1,27,3],[16,1,16,3],[16,4,16,6],[18,1,18,3],[17,1,17,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[19,4,19,6],[20,4,20,6],[21,4,21,6],[22,4,22,6],[23,4,23,6],[24,4,24,6],[79,1,79,7],[80,1,80,7],[81,1,81,7],[82,1,82,7],[53,1,53,9],[54,1,54,9],[55,1,55,9],[56,1,56,9],[83,1,83,7],[66,1,66,8],[67,1,67,8],[125,1,125,7],[116,1,116,7],[117,1,117,7],[118,1,118,7],[119,1,119,7],[121,1,121,7],[115,1,115,7],[95,1,95,7],[100,1,100,7],[101,1,101,7],[102,1,102,7],[103,1,103,7],[96,1,96,7],[97,1,97,7],[98,1,98,7],[99,1,99,7],[120,1,120,7],[122,1,122,7],[123,1,123,7],[124,1,124,7],[191,1,191,8],[170,1,170,8],[188,1,188,8],[11,1,11,5],[12,1,12,5],[13,1,13,5],[41,1,41,9],[133,1,133,8],[69,1,69,8],[106,1,106,8],[111,1,111,8],[128,1,128,8],[134,1,134,8],[73,1,73,6],[76,1,76,7],[77,1,77,7],[58,1,58,9],[59,1,59,9],[60,1,60,9],[36,0,36,9],[64,1,64,5],[84,1,84,7],[85,1,85,7],[78,1,78,7],[51,1,51,9],[25,4,25,6],[26,4,26,6],[44,1,44,9],[45,1,45,9],[46,1,46,9],[47,1,47,9],[48,1,48,9],[49,1,49,9],[50,1,50,9]]}
[]
["Annual Budget Detail"]
["(OFFICIAL NAME OF SUBCONTRACTING AGENCY)"]
["Subcontracted Under (NAME OF CONTRACTOR)"]
["October 1, 2017 through September 30, 2018"]
["(FFY 2018)"]
[]
["Note: This budget represents Total Dollars to be expended on CalFresh outreach efforts by the subcontractor.  Total Dollars are split into State Share costs (not reimbursable) and Federal Share costs (reimbursable by USDA)  on the Budget Summary Worksheet. Budgetary dollars designated as State Share must be from non-Federal sources, as defined by the USDA Guidance, to be used to conduct allowable CalFresh outreach activities.  Please double-check that all data are accurate, represent annual program costs, and transferred accurately and completely to the Budget Summary worksheet."]
[]
[null,"PERSONNEL SALARIES: (Add as many lines as necessary to include all outreach staff, actual or proposed)"]
[]
[null,"Total FTE for All Staff Listed:",null,null,null,null,0]
[null,"Organization's Total FTEs for Proration:",null,null,null,null,0]
[null,"Percent FTE for Proration:",null,null,null,null,{"$f":"IF(G13=0,0,G12/G13)","v":0}]
[]
[null,"Name",null,null,"Position Title",null,null,"Annual Salary","Total FTE                                  (as a decimal) ","Total Dollars     "]
["1.",null,null,null,null,null,null,0,0,{"$f":"ROUND(H17*I17,0)","v":0}]
["2.",null,null,null,null,null,null,0,0,{"$f":"ROUND(H18*I18,0)","v":0}]
["3.",null,null,null,null,null,null,0,0,0]
["4.",null,null,null,null,null,null,0,0,0]
["5.",null,null,null,null,null,null,0,0,0]
["6.",null,null,null,null,null,null,0,0,0]
["7.",null,null,null,null,null,null,0,0,0]
["8.",null,null,null,null,null,null,0,0,0]
["9.",null,null,null,null,null,null,0,0,0]
["10.",null,null,null,null,null,null,0,0,0]
["11.",null,null,null,null,null,null,0,0,0]
["12.",null,null,null,null,null,null,0,0,0]
["13.",null,null,null,null,null,null,0,0,0]
["14.",null,null,null,null,null,null,0,0,0]
["15.",null,null,null,null,null,null,0,0,0]
["16.",null,null,null,null,null,null,0,0,0]
["17.",null,null,null,null,null,null,0,0,0]
["18.",null,null,null,null,null,null,0,0,0]
["19.",null,null,null,null,null,null,0,0,0]
["20.",null,null,null,null,null,null,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,"Total Dollars     "]
[null,"TOTAL PERSONNEL SALARIES",null,null,null,null,null,null,null,{"$f":"SUM(J17:J36)","v":0}]
[]
[null,"POSITION DESCRIPTIONS for each position/staff person listed above"]
["1."]
["2."]
["3."]
["4."]
["5."]
["6."]
["7."]
["8."]
["9."]
["10."]
["11."]
["12."]
["13."]
["14."]
["15."]
["16."]
["17."]
["18."]
["19."]
["20."]
[]
[null,"FRINGE BENEFITS "]
[]
[null,"Benefits Rate (percent of salary):",null,null,null,null,0]
[]
[null,"Double-Check the correct percent calculation in the \"Fringe Double Check\" tab."]
[null,"Fringe Benefit Rate must be adjusted to the corrected percent."]
[null,null,null,null,null,null,null,null,null,"Total Dollars     "]
[null,"FRINGE BENEFITS:",null,null,null,null,null,null,null,{"$f":"$G$65*J39","v":0}]
[]
[null,"OPERATING EXPENSES: (add as many lines as necessary)"]
[]
[null,"Proration Percentage (as calculated in Personnel section):",null,null,null,null,null,{"$f":"G14","v":0}]
[]
[null,"FIXED COSTS:"]
[null,"Description",null,null,null,null,null,null,"Annual Cost","Total Dollars     "]
["1.",null,null,null,null,null,null,null,0,{"$f":"ROUND(I78,0)","v":0}]
["2.",null,null,null,null,null,null,null,0,{"$f":"ROUND(I79,0)","v":0}]
["3.",null,null,null,null,null,null,null,0,0]
["4.",null,null,null,null,null,null,null,0,0]
["5.",null,null,null,null,null,null,null,0,0]
["6.",null,null,null,null,null,null,null,0,0]
["7.",null,null,null,null,null,null,null,0,0]
["8.",null,null,null,null,null,null,null,0,0]
["9.",null,null,null,null,null,null,null,0,0]
["10.",null,null,null,null,null,null,null,0,0]
["11.",null,null,null,null,null,null,null,0,0]
["12.",null,null,null,null,null,null,null,0,0]
[]
[null,"PRORATED COSTS:"]
[null,"Description",null,null,null,null,null,null,"Annual Cost","Total Dollars     "]
["1.",null,null,null,null,null,null,null,0,{"$f":"ROUND(I93*$H$74,0)","v":0}]
["2.",null,null,null,null,null,null,null,0,{"$f":"ROUND(I94*$H$74,0)","v":0}]
["3.",null,null,null,null,null,null,null,0,0]
["4.",null,null,null,null,null,null,null,0,0]
["5.",null,null,null,null,null,null,null,0,0]
["6.",null,null,null,null,null,null,null,0,0]
["7.",null,null,null,null,null,null,null,0,0]
["8.",null,null,null,null,null,null,null,0,0]
["9.",null,null,null,null,null,null,null,0,0]
["10.",null,null,null,null,null,null,null,0,0]
["11.",null,null,null,null,null,null,null,0,0]
["12.",null,null,null,null,null,null,null,0,0]
[]
[null,null,null,null,null,null,null,null,null,"Total Dollars     "]
[null,"OPERATING EXPENSES:  ",null,null,null,null,null,null,null,{"$f":"SUM(J93:J104,J78:J89)","v":0}]
[]
[null,"EQUIPMENT: (This line item is not allowed in subcontracts)"]
[]
[null,null,null,null,null,null,null,null,null,"Total Dollars     "]
[null,"EQUIPMENT: unallowable",null,null,null,null,null,null,null,0]
[]
[null,"TRAVEL AND PER DIEM: (add as many lines as necessary)"]
[]
[null,"Description",null,null,null,null,null,null,"Estimated Cost","Total Dollars     "]
["1.",null,null,null,null,null,null,null,0,{"$f":"ROUND(I117,0)","v":0}]
["2.",null,null,null,null,null,null,null,0,{"$f":"ROUND(I118,0)","v":0}]
["3.",null,null,null,null,null,null,null,0,0]
["4.",null,null,null,null,null,null,null,0,0]
["5.",null,null,null,null,null,null,null,0,0]
["6.",null,null,null,null,null,null,null,0,0]
["7.",null,null,null,null,null,null,null,0,0]
["8.",null,null,null,null,null,null,null,0,0]
["9.",null,null,null,null,null,null,null,0,0]
["10.",null,null,null,null,null,null,null,0,0]
[]
[null,null,null,null,null,null,null,null,null,"Total Dollars     "]
[null,"TRAVEL AND PER DIEM:  ",null,null,null,null,null,null,null,{"$f":"SUM(J117:J126)","v":0}]
[]
[null,"SUBCONTRACTS: (Only allowed for Applicants and Prime Subcontractors)"]
[]
[null,null,null,null,null,null,null,null,null,"Total Dollars     "]
[null,"SUBCONTRACTS: See RFA for Prime Subcontractor instructions",null,null,null,null,null,null,null,0]
[]
[null,"OTHER COSTS: (add as many lines as necessary)"]
[]
[null,"Proration Percentage (as calculated in Personnel section):",null,null,null,null,null,{"$f":"G14","v":0}]
[]
[null,"FIXED COSTS:"]
[null,"Description",null,null,null,null,null,null,"Annual Cost","Total Dollars     "]
["1.",null,null,null,null,null,null,null,0,{"$f":"ROUND(I142,0)","v":0}]
["2.",null,null,null,null,null,null,null,0,{"$f":"ROUND(I143,0)","v":0}]
["3.",null,null,null,null,null,null,null,0,0]
["4.",null,null,null,null,null,null,null,0,0]
["5.",null,null,null,null,null,null,null,0,0]
["6.",null,null,null,null,null,null,null,0,0]
["7.",null,null,null,null,null,null,null,0,0]
["8.",null,null,null,null,null,null,null,0,0]
["9.",null,null,null,null,null,null,null,0,0]
["10.",null,null,null,null,null,null,null,0,0]
["11.",null,null,null,null,null,null,null,0,0]
["12.",null,null,null,null,null,null,null,0,0]
[]
[null,"PRORATED COSTS:"]
[null,"Description",null,null,null,null,null,null,"Annual Cost","Total Dollars     "]
["1.",null,null,null,null,null,null,null,0,{"$f":"ROUND(I157*$H$138,0)","v":0}]
["2.",null,null,null,null,null,null,null,0,{"$f":"ROUND(I158*$H$138,0)","v":0}]
["3.",null,null,null,null,null,null,null,0,0]
["4.",null,null,null,null,null,null,null,0,0]
["5.",null,null,null,null,null,null,null,0,0]
["6.",null,null,null,null,null,null,null,0,0]
["7.",null,null,null,null,null,null,null,0,0]
["8.",null,null,null,null,null,null,null,0,0]
["9.",null,null,null,null,null,null,null,0,0]
["10.",null,null,null,null,null,null,null,0,0]
["11.",null,null,null,null,null,null,null,0,0]
["12.",null,null,null,null,null,null,null,0,0]
[]
[null,null,null,null,null,null,null,null,null,"Total Dollars     "]
[null,"OTHER COSTS:",null,null,null,null,null,null,null,{"$f":"SUM(J157:J168,J142:J153)","v":0}]
[]
[null,"INDIRECT COSTS:"]
[]
[null,"Check the line items on which indirect costs are to be applied:"]
[null,null,null,null,null,null,null,null,null,"Total Dollars"]
[null,null,null,null,"Personnel Salaries",null,null,null,null,{"$f":"IF($C$218=TRUE,$J$39*$D$183,0)","v":0}]
[null,null,null,null,"Fringe Benefits",null,null,null,null,{"$f":"IF($C$219=TRUE,$J$70*$D$183,0)","v":0}]
[null,null,null,null,"Operating Expenses",null,null,null,null,{"$f":"IF($C$220=TRUE,$J$107*$D$183,0)","v":0}]
[null,null,null,null,"Travel and Per Diem",null,null,null,null,{"$f":"IF($C$221=TRUE,$J$129*$D$183,0)","v":0}]
[null,null,null,null,"Other Costs",null,null,null,null,{"$f":"IF($C$222=TRUE,$J$171*$D$183,0)","v":0}]
[null,null,null,null,null,null,null,null,"Total",{"$f":"ROUND(SUM(J177:J181),0)","v":0}]
[null,"Enter Indirect Rate:",null,0,"Indirect Costs (between 10 and 26%)"]
[]
[null,"Double-Check the correct percent calculation in the \"Indirect Double Check\" tab."]
[null,"Indirect Costs rate must be adjusted to the corrected percent. Not to exceed 26.0000%"]
[]
[null,null,null,null,null,null,null,null,null,"Total Dollars     "]
[null,"INDIRECT COSTS:",null,null,null,null,null,null,null,{"$f":"J182","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Total Dollars     "]
[null,"TOTAL EXPENSES: ",null,null,null,null,null,null,null,{"$f":"J39+J70+J107+J112+J129+J134+J171+J189","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,false]
[null,null,false]
[null,null,false]
[null,null,false]
[null,null,false]

{"sheet":"Indirect Double Check","index":2,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,"INDIRECT COSTS DOUBLE CHECK:"]
[]
[null,"Double-Check Percent Calculation:"]
[]
[null,null,null,null,"Total Dollars     "]
[null,null,"Personnel Salaries",null,{"$f":"IF('FFY 18 Annual Budget Detail'!$C$218=TRUE,'FFY 18 Annual Budget Detail'!$J$39,0)","v":0}]
[null,null,"Fringe Benefits",null,{"$f":"IF('FFY 18 Annual Budget Detail'!$C$219=TRUE,'FFY 18 Annual Budget Detail'!$J$70,0)","v":0}]
[null,null,"Operating Expenses",null,{"$f":"IF('FFY 18 Annual Budget Detail'!$C$220=TRUE,'FFY 18 Annual Budget Detail'!$J$107,0)","v":0}]
[null,null,"Travel and Per Diem",null,{"$f":"IF('FFY 18 Annual Budget Detail'!$C$221=TRUE,'FFY 18 Annual Budget Detail'!$J$129,0)","v":0}]
[null,null,"Other Costs",null,{"$f":"IF('FFY 18 Annual Budget Detail'!$C$222=TRUE,'FFY 18 Annual Budget Detail'!$J$171,0)","v":0}]
[null,null,"Total",null,{"$f":"ROUND(SUM(E6:E10),0)","v":0}]
[]
[null,"Corrected Percent:",null,null,{"$f":"'FFY 18 Annual Budget Detail'!J182/'Indirect Double Check'!E11","v":{"$error":"#DIV/0!"}}]

{"sheet":"Fringe Double Check","index":3,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,"FRINGE BENEFITS DOUBLE CHECK:"]
[]
[null,"Double-Check Percent Calculation:"]
[]
[null,null,null,null,"Total Dollars"]
[null,null,"Personnel Salaries",null,{"$f":"'FFY 18 Annual Budget Detail'!J39","v":0}]
[]
[]
[null,null,null,null,"Total Dollars"]
[null,null,"Fringe Benefits",null,{"$f":"'FFY 18 Annual Budget Detail'!J70","v":0}]
[]
[]
[null,"Corrected Percent:",null,null,{"$f":"E10/E6","v":{"$error":"#DIV/0!"}}]