{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Provider Information","Provider Total Budget by Serv","Provider Service Area","Analysis Tool","Home Delivered Meal Budget","Unit Rate Calculation HDM","Certification HDM","In-Kind Certification HDM","Congregate Meal Budget","Unit Rate Calculation CM","Certification CM","In-Kind Certification CM","Participant Assessment Budget","Unit Rate Calculation PA","Certification PA","In-Kind Certification PA","Transportation Budget","Unit Rate Calculation Transp","Certification Transp","In-Kind Certification Transp"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":283,"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":"Provider Information","index":0,"n_rows":544,"n_cols":78,"rows_kept":544,"cut":false,"hidden":false,"merged":[[0,7,0,8],[0,9,0,10],[12,5,12,10],[21,3,21,7],[24,5,24,9],[7,5,7,10],[8,5,8,10],[9,5,9,6],[11,1,11,4],[7,1,7,4],[8,1,8,4],[9,1,9,4],[10,1,10,4],[10,5,10,6],[11,5,11,9],[1,1,1,10],[26,4,26,7],[20,3,20,7],[25,4,25,5],[17,5,17,10],[12,1,12,4],[13,1,13,4],[13,5,13,10],[2,1,2,10],[5,1,5,4],[5,5,5,10],[6,1,6,4],[6,5,6,10],[4,1,4,10],[3,1,3,4],[3,5,3,8]]}
[null,{"$f":"NOW()","v":"2020-07-23T18:20:44.220"},null,null,null,null,null,"Submission #",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"101ƒ"]
[null,"Texas Health and Human Services"]
[null,"Uniform Rate Negotiation Workbook/Budget "]
[null,"Federal Contract Period:",null,null,null,"10-01-19 / 09-30-20"]
[null,{"$f":"IF(AND(D20=\"Yes\",F24=\"Yes\"),\"Common Provider\",+AA5)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D20=\"\",F24=\"\"),\"\",+AB5)","v":""},{"$f":"IF(AND(D20=\"Yes\",F24=\"No\"),\"AAA Provider Only\",+AC5)","v":""},{"$f":"IF(AND(D20=\"No\",F24=\"Yes\"),\"Community Services Provider Only\",\"\")","v":""}]
[1,"Nutrition Providers Legal Business Name:"]
[2,"Street Address:"]
[3,"Mailing Address:"]
[4,"City:"]
[5,"Zip Code:"]
[6,"Phone Number:"]
[7,"E-mail Address:"]
[8,"Contact Name:"]
[9,"Nutrition Providers website address:"]
[]
[]
[10,"Did this Nutrition provider complete a rate setting workbook last year?",null,null,null,null,null,{"$f":"IF(G17=\"\",\"Either Yes or No must be selected\",\"\")","v":"Either Yes or No must be selected"}]
[11,"If Yes, what was the provider name listed on the workbook?"]
[null,null,null,null,null,{"$f":"AA19","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G17=\"No\",\"\",+AB19)","v":""},{"$f":"IF(G17=\"\",\"\",+AC19)","v":""}]
[12,"Is the Provider a AAA Provider?",null,null,{"$f":"+AB20","v":"Either Yes or No must be selected"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D20=\"No\",(IF(D21>\"\",\"Either select Yes or delete AAA name\",+AC20)),+AC20)","v":"Either Yes or No must be selected"},{"$f":"IF(D20=\"\",\"Either Yes or No must be selected\",+AD20)","v":"Either Yes or No must be selected"},{"$f":"IF(D20=\"Yes\",\"\",\"\")","v":""}]
[13,"If Yes, select the AAA Name:",null,null,null,null,null,null,{"$f":"IF(D20=\"yes\",(IF(D21=\"\",\"AAA Name Must be Selected\",\"\")),\"\")","v":""}]
[14,"If Yes, contact name at AAA:",null,null,null,null,null,null,{"$f":"IF(D20=\"yes\",(IF(D22=\"\",\"AAA Contact Name Must be Entered\",\"\")),\"\")","v":""}]
[15,"If Yes, is it a contract or subrecipient?",null,null,null,{"$f":"IF(AND(D20=\"Yes\",E23=\"\"),\"Either Contract or Vendor must be selected.\",\"\")","v":""}]
[16,"Is the Provider a HHS Contracted Community Services Provider?",null,null,null,null,{"$f":"+AB24","v":"Either Yes or No must be selected"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F24=\"No\",(IF(E26>\"\",\"Either select Yes or delete DADS Region Number\",+AC24)),+AC24)","v":"Either Yes or No must be selected"},{"$f":"IF(F24=\"\",\"Either Yes or No must be selected\",+AD24)","v":"Either Yes or No must be selected"},{"$f":"IF(F24=\"Yes\",\"\",\"\")","v":""}]
[17,"If Yes, Contract Manager name at HHS Contracted Community Services:",null,null,null,null,null,null,null,null,{"$f":"IF(F24=\"yes\",(IF(F25=\"\",\"Community Services Contact Name Must be Entered\",\"\")),\"\")","v":""}]
[18,"If Yes, select the HHS Region Number:",null,null,null,null,{"$f":"IF(F24=\"yes\",(IF(E26=\"\",\"DADS Region Number Must be Selected\",\"\")),\"\")","v":""}]
[19,"If Yes, enter the HHS contract number:",null,null,null,null,null,null,{"$f":"IF(AND(F24=\"Yes\",E27=\"\"),\"Contract number must be entered.\",\"\")","v":""}]
[]
[null,"Service Delivery Information"]
[null,"Home Delivered Meals"]
[20,"Does this Nutrition provider serve home delivered meals paid for by HHS or the AAA?",null,null,null,null,null,null,null,{"$f":"+AC31","v":"Either Yes or No must be selected"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I31=\"\",\"Either Yes or No must be selected\",+AD31)","v":"Either Yes or No must be selected"},{"$f":"IF(I31=\"Yes\",\"\",\"\")","v":""}]
[21,"Does this Nutrition provider have an approved Home Delivered Nutrition Waiver for 2019?",null,null,null,null,null,null,null,{"$f":"+AC32","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(I31=\"Yes\",I32=\"\"),\"Either Yes or No must be selected\",+AD32)","v":""},{"$f":"IF(I32=\"Yes\",\"\",\"\")","v":""}]
[22,"Is this Nutrition provider requesting a Home Delivered Nutrition Waiver for 2020?",null,null,null,null,null,null,{"$f":"+AB33","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(H32=\"Yes\",H33=\"\"),\"Either Yes or No must be selected\",+AC33)","v":""},{"$f":"IF(H33=\"Yes\",\"\",\"\")","v":""}]
[23,"Total number of home delivered meal routes for this provider:",null,null,null,null,null,{"$f":"IF(AND(G34=\"\",I31=\"Yes\"),\" The number of meal routes must be entered\",\"\")","v":""}]
[24,"Total number of meal preparation sites used by this provider:",null,null,null,null,null,{"$f":"IF(AND(G35=\"\",I31=\"Yes\"),\" The number of meal preparation sites must be entered\",\"\")","v":""}]
[]
[null,"Congregate Meals"]
[25,"Does this Nutrition provider  serve congregate meals paid for by the AAA?",null,null,null,null,null,null,{"$f":"+AB38","v":"Either Yes or No must be selected"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H38=\"\",\"Either Yes or No must be selected\",+AC38)","v":"Either Yes or No must be selected"},{"$f":"IF(H38=\"Yes\",\"\",\"\")","v":""}]
[26,"Does this Nutrition provider have an approved Congregate Nutrition Waiver for 2019?",null,null,null,null,null,null,{"$f":"+AB39","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(H38=\"Yes\",H39=\"\"),\"Either Yes or No must be selected\",+AC39)","v":""},{"$f":"IF(H39=\"Yes\",\"\",\"\")","v":""}]
[27,"Is this Nutrition provider requesting a Congregate Waiver for 2020?",null,null,null,null,null,null,{"$f":"+AB40","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(H38=\"Yes\",H40=\"\"),\"Either Yes or No must be selected\",+AC40)","v":""},{"$f":"IF(H40=\"Yes\",\"\",\"\")","v":""}]
[28,"Total number of meal preparation sites used by this provider:",null,null,null,null,null,{"$f":"IF(AND(G41=\"\",H38=\"Yes\"),\" The number of meal preparation sites must be entered\",\"\")","v":""}]
[29,"Total number of meal sites used by this provider:",null,null,null,null,null,{"$f":"IF(AND(G42=\"\",H38=\"Yes\"),\" The number of meal sites must be entered\",\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Yes",null,null,"Area Agency on Aging of the Alamo Area"]
[null,"No",null,null,"Area Agency on Aging of Ark-Tex",null,"Region 1/10"]
[null,null,null,null,"Area Agency on Aging of Bexar County",null,"Region 2/9"]
[null,"Subrecipient",null,null,"Area Agency on Aging of Brazos Valley",null,"Region 3"]
[null,"Contract",null,null,"Area Agency on Aging of the Capital Area",null,"Region 4"]
[null,null,null,null,"Area Agency on Aging of Central Texas",null,"Region 5"]
[null,null,null,null,"Area Agency on Aging of the Coastal Bend",null,"Region 6"]
[null,null,null,null,"Area Agency on Aging of Concho Valley",null,"Region 7"]
[null,null,null,null,"Area Agency on Aging of Dallas County",null,"Region 8"]
[null,null,null,null,"Area Agency on Aging of Deep East Texas",null,"Region 11"]
[null,null,null,null,"Area Agency on Aging of East Texas"]
[null,null,null,null,"Area Agency on Aging of the Golden Crescent Region"]
[null,null,null,null,"Area Agency on Aging of Harris County"]
[null,null,null,null,"Area Agency on Aging of the Heart of Texas"]
[null,null,null,null,"Area Agency on Aging of Houston-Galveston"]
[null,null,null,null,"Area Agency on Aging of the Lower Rio Grande Valley"]
[null,null,null,null,"Area Agency on Aging of the Middle Rio Grande Area"]
[null,null,null,null,"Area Agency on Aging of North Central Texas"]
[null,null,null,null,"Area Agency on Aging of North Texas"]
[null,null,null,null,"Agency on Aging of the Panhandle Area"]
[null,null,null,null,"Area Agency on Aging of the Permian Basin"]
[null,null,null,null,"Agency on Aging of the Rio Grande Area"]
[null,null,null,null,"Area Agency on Aging of Southeast Texas"]
[null,null,null,null,"Area Agency on Aging of South Plains"]
[null,null,null,null,"Area Agency on Aging of South Texas"]
[null,null,null,null,"Area Agency on Aging of Tarrant County"]
[null,null,null,null,"Area Agency on Aging of Texoma"]
[null,null,null,null,"Area Agency on Aging of West Central Texas"]

{"sheet":"Provider Total Budget by Serv","index":1,"n_rows":497,"n_cols":15,"rows_kept":497,"cut":false,"hidden":false,"merged":[[0,1,0,6],[37,1,37,9],[54,1,54,9],[93,1,93,9],[115,1,115,9],[1,2,1,6],[5,1,5,9],[2,7,2,8],[1,7,1,8],[2,9,2,10],[297,1,297,4],[299,1,299,3],[298,1,298,3],[162,1,162,9],[204,1,204,9],[276,1,276,9],[279,1,279,7]]}
[null,"Provider Total Budget by Service"]
[null,"Provider Name: ",{"$f":"IF(ISBLANK('Provider Information'!F6),\"\",+'Provider Information'!F6)","v":""},null,null,null,null,"AAA Name:",null,{"$f":"+'Provider Information'!D21","v":0}]
[null,{"$f":"NOW()","v":"2020-07-23T18:20:44.220"},null,null,null,null,null,"Region Number:",null,{"$f":"+'Provider Information'!E26","v":0}]
[null,"Cost Area ","Total Agency Budget","Home Delivered Meal Program","Nutrition Education - AAA Clients","Nutrition Education CCS Clients","Congregate Meal Program","Other Meal Programs\n(non-HHS/AES)","Agency Budget not Applicable to Programs","Participant Assessment","Transportation","If applicable replace with title of other agency program","If applicable replace with title of other agency program","If applicable replace with title of other agency program","Balance not budgeted"]
[]
[null,"Personnel"]
[null,"Salaries (Identified by Job Title)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C8-(SUM(D8:N8))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C12-(SUM(D12:N12))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Total Salaries",{"$f":"SUM(C7:C16)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Payroll Taxes & Benefits (Employer Paid)"]
[null,"Federal Insurance compensation Act (FICA)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C19-(SUM(D19:N19))","v":0}]
[null,"Texas Unemployment Compensation Act (TUCA)",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Federal Unemployment  Tax Act (FUTA)",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Workers Compensation",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Health Insurance",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Retirement",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Total Payroll Taxes & Benefits (Employer Paid)",{"$f":"SUM(C18:C28)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Contract staff (Identify by Position)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C31-(SUM(D31:N31))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C32-(SUM(D32:N32))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C33-(SUM(D33:N33))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C34-(SUM(D34:N34))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C35-(SUM(D35:N35))","v":0}]
[null,"Total Contract staff",{"$f":"SUM(C30:C35)","v":0},0,0,0,0,0,{"$f":"SUM(I30:I35)","v":0},0,0,{"$f":"SUM(L30:L35)","v":0},{"$f":"SUM(M30:M35)","v":0},{"$f":"SUM(N30:N35)","v":0},{"$f":"SUM(O30:O35)","v":0}]
[null,"Total Personnel ",{"$f":"+C17+C29+C36","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"+C37-(SUM(D37:N37))","v":0}]
[null,"Professional Development"]
[null,"Conference (list Conference & Attendees)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C40-(SUM(D40:N40))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C41-(SUM(D41:N41))","v":0}]
[]
[null,"Total Conferences",{"$f":"SUM(C39:C42)","v":0},0,0,0,0,0,{"$f":"SUM(I39:I42)","v":0},0,0,{"$f":"SUM(L39:L42)","v":0},{"$f":"SUM(M39:M42)","v":0},0,0]
[null,"Dues (list Organization Name)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C45-(SUM(D45:N45))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C46-(SUM(D46:N46))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C47-(SUM(D47:N47))","v":0}]
[null,"Total Dues",{"$f":"SUM(C44:C47)","v":0},0,0,0,0,0,{"$f":"SUM(I44:I47)","v":0},0,0,{"$f":"SUM(L44:L47)","v":0},{"$f":"SUM(M44:M47)","v":0},0,{"$f":"+C48-(SUM(D48:N48))","v":0}]
[null,"Materials (list Items)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C50-(SUM(D50:N50))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C51-(SUM(D51:N51))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C52-(SUM(D52:N52))","v":0}]
[null,"Total Materials",{"$f":"SUM(C49:C52)","v":0},0,0,0,0,{"$f":"SUM(H49:H52)","v":0},{"$f":"SUM(I49:I52)","v":0},0,{"$f":"SUM(K49:K52)","v":0},{"$f":"SUM(L49:L52)","v":0},{"$f":"SUM(M49:M52)","v":0},{"$f":"SUM(N49:N52)","v":0},{"$f":"+C53-(SUM(D53:N53))","v":0}]
[null,"Total Professional Development",{"$f":"SUM(C53,C48,C43)","v":0},0,0,0,0,0,{"$f":"SUM(I53,I48,I43)","v":0},0,0,{"$f":"SUM(L53,L48,L43)","v":0},{"$f":"SUM(M53,M48,M43)","v":0},0,{"$f":"+C54-(SUM(D54:N54))","v":0}]
[null,"Meals/Food"]
[null,"Raw Food"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C57-(SUM(D57:N57))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C58-(SUM(D58:N58))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C59-(SUM(D59:N59))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C60-(SUM(D60:N60))","v":0}]
[null,"Total Raw Food",{"$f":"SUM(C56:C60)","v":0},0,0,0,0,{"$f":"SUM(H56:H60)","v":0},{"$f":"SUM(I56:I60)","v":0},0,{"$f":"SUM(K56:K60)","v":0},{"$f":"SUM(L56:L60)","v":0},{"$f":"SUM(M56:M60)","v":0},{"$f":"SUM(N56:N60)","v":0},{"$f":"+C61-(SUM(D61:N61))","v":0}]
[null,"Purchased Meals"]
[null,"Hot Prepared Meals Purchased from a Supplier or Central Kitchen",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C63-(SUM(D63:N63))","v":0}]
[null,"Frozen Meals ",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Chilled Meals",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Shelf Stable Meals",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Total Purchased Meals",{"$f":"SUM(C62:C67)","v":0},0,0,0,0,0,{"$f":"SUM(I62:I67)","v":0},0,0,{"$f":"SUM(L62:L67)","v":0},{"$f":"SUM(M62:M67)","v":0},0,0]
[null,"Freight"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C70-(SUM(D70:N70))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C71-(SUM(D71:N71))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C72-(SUM(D72:N72))","v":0}]
[null,"Total Freight",{"$f":"SUM(C69:C72)","v":0},0,0,0,0,{"$f":"SUM(H69:H72)","v":0},{"$f":"SUM(I69:I72)","v":0},0,{"$f":"SUM(K69:K72)","v":0},{"$f":"SUM(L69:L72)","v":0},{"$f":"SUM(M69:M72)","v":0},{"$f":"SUM(N69:N72)","v":0},{"$f":"+C73-(SUM(D73:N73))","v":0}]
[null,"Storage Cost (Food or Supply)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C75-(SUM(D75:N75))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C76-(SUM(D76:N76))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C77-(SUM(D77:N77))","v":0}]
[null,"Total Storage Cost",{"$f":"SUM(C74:C77)","v":0},0,0,0,0,{"$f":"SUM(H74:H77)","v":0},{"$f":"SUM(I74:I77)","v":0},0,{"$f":"SUM(K74:K77)","v":0},{"$f":"SUM(L74:L77)","v":0},{"$f":"SUM(M74:M77)","v":0},{"$f":"SUM(N74:N77)","v":0},{"$f":"+C78-(SUM(D78:N78))","v":0}]
[null,"Consumables (identify by type)"]
[null,"Non-Capital Equipment (less that $5,000 per item)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C80-(SUM(D80:N80))","v":0}]
[null,"Paper/plastic goods (napkins, plates, utensils, etc)",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Meal Delivery Consumable Supplies",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Pots/Pans/Cooking Utensils",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Total Consumables",{"$f":"SUM(C79:C86)","v":0},0,0,0,0,{"$f":"SUM(H79:H86)","v":0},{"$f":"SUM(I79:I86)","v":0},0,{"$f":"SUM(K79:K86)","v":0},{"$f":"SUM(L79:L86)","v":0},{"$f":"SUM(M79:M86)","v":0},{"$f":"SUM(N79:N86)","v":0},0]
[null,"Other (Identify Individually all items over $100.)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C89-(SUM(D89:N89))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C90-(SUM(D90:N90))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C91-(SUM(D91:N91))","v":0}]
[null,"Total Other",{"$f":"SUM(C88:C91)","v":0},0,0,0,0,{"$f":"SUM(H88:H91)","v":0},{"$f":"SUM(I88:I91)","v":0},0,{"$f":"SUM(K88:K91)","v":0},{"$f":"SUM(L88:L91)","v":0},{"$f":"SUM(M88:M91)","v":0},{"$f":"SUM(N88:N91)","v":0},{"$f":"+C92-(SUM(D92:N92))","v":0}]
[null,"Total Meals/Food",{"$f":"SUM(C61+C68+C73+C78+C87+C92)","v":0},{"$f":"SUM(D61+D68+D73+D78+D87+D92)","v":0},{"$f":"SUM(E92,E87,E78,E73,E61,E68)","v":0},0,0,0,{"$f":"SUM(I92,I87,I78,I73,I61,I68)","v":0},0,0,{"$f":"SUM(L92,L87,L78,L73,L61,L68)","v":0},{"$f":"SUM(M92,M87,M78,M73,M61,M68)","v":0},0,0]
[null,"Equipment"]
[null,"Depreciation (identify item, year purchased, cost)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C96-(SUM(D96:N96))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C97-(SUM(D97:N97))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C98-(SUM(D98:N98))","v":0}]
[null,"Total Depreciation",{"$f":"SUM(C95:C98)","v":0},0,0,0,0,{"$f":"SUM(H95:H98)","v":0},{"$f":"SUM(I95:I98)","v":0},0,{"$f":"SUM(K95:K98)","v":0},{"$f":"SUM(L95:L98)","v":0},{"$f":"SUM(M95:M98)","v":0},{"$f":"SUM(N95:N98)","v":0},{"$f":"+C99-(SUM(D99:N99))","v":0}]
[null,"Interest (Identify Item, year purchased, cost)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C101-(SUM(D101:N101))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C102-(SUM(D102:N102))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C103-(SUM(D103:N103))","v":0}]
[null,"Total Interest",{"$f":"SUM(C100:C103)","v":0},0,0,0,0,{"$f":"SUM(H100:H103)","v":0},{"$f":"SUM(I100:I103)","v":0},0,{"$f":"SUM(K100:K103)","v":0},{"$f":"SUM(L100:L103)","v":0},{"$f":"SUM(M100:M103)","v":0},{"$f":"SUM(N100:N103)","v":0},{"$f":"+C104-(SUM(D104:N104))","v":0}]
[null,"Leasing (identify Item, year leased)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C106-(SUM(D106:N106))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C107-(SUM(D107:N107))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C108-(SUM(D108:N108))","v":0}]
[null,"Total Leasing",{"$f":"SUM(C105:C108)","v":0},0,0,0,0,{"$f":"SUM(H105:H108)","v":0},{"$f":"SUM(I105:I108)","v":0},0,{"$f":"SUM(K105:K108)","v":0},{"$f":"SUM(L105:L108)","v":0},{"$f":"SUM(M105:M108)","v":0},{"$f":"SUM(N105:N108)","v":0},{"$f":"+C109-(SUM(D109:N109))","v":0}]
[null,"Maintenance (Identify Item, year purchased, cost)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C111-(SUM(D111:N111))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C112-(SUM(D112:N112))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C113-(SUM(D113:N113))","v":0}]
[null,"Total Maintenance",{"$f":"SUM(C110:C113)","v":0},0,0,0,0,{"$f":"SUM(H110:H113)","v":0},{"$f":"SUM(I110:I113)","v":0},0,{"$f":"SUM(K110:K113)","v":0},{"$f":"SUM(L110:L113)","v":0},{"$f":"SUM(M110:M113)","v":0},{"$f":"SUM(N110:N113)","v":0},{"$f":"+C114-(SUM(D114:N114))","v":0}]
[null,"Total Equipment",{"$f":"SUM(C114,C109,C104,C99)","v":0},0,0,0,0,{"$f":"SUM(H114,H109,H104,H99)","v":0},{"$f":"SUM(I114,I109,I104,I99)","v":0},0,{"$f":"SUM(K114,K109,K104,K99)","v":0},{"$f":"SUM(L114,L109,L104,L99)","v":0},{"$f":"SUM(M114,M109,M104,M99)","v":0},{"$f":"SUM(N114,N109,N104,N99)","v":0},{"$f":"+C115-(SUM(D115:N115))","v":0}]
[null,"Occupancy/Building"]
[null,"Rent"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C118-(SUM(D118:N118))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C119-(SUM(D119:N119))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C120-(SUM(D120:N120))","v":0}]
[null,"Total Rent",{"$f":"SUM(C117:C120)","v":0},0,0,0,0,{"$f":"SUM(H117:H120)","v":0},{"$f":"SUM(I117:I120)","v":0},0,{"$f":"SUM(K117:K120)","v":0},{"$f":"SUM(L117:L120)","v":0},{"$f":"SUM(M117:M120)","v":0},{"$f":"SUM(N117:N120)","v":0},{"$f":"+C121-(SUM(D121:N121))","v":0}]
[null,"Utilities"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C123-(SUM(D123:N123))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C124-(SUM(D124:N124))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C125-(SUM(D125:N125))","v":0}]
[null,"Total Utilities",{"$f":"SUM(C122:C125)","v":0},0,0,0,0,{"$f":"SUM(H122:H125)","v":0},{"$f":"SUM(I122:I125)","v":0},0,{"$f":"SUM(K122:K125)","v":0},{"$f":"SUM(L122:L125)","v":0},{"$f":"SUM(M122:M125)","v":0},{"$f":"SUM(N122:N125)","v":0},{"$f":"+C126-(SUM(D126:N126))","v":0}]
[null,"Depreciation (identify item, year purchased, cost)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C128-(SUM(D128:N128))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C129-(SUM(D129:N129))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C130-(SUM(D130:N130))","v":0}]
[null,"Total Depreciation",{"$f":"SUM(C127:C130)","v":0},0,0,0,0,{"$f":"SUM(H127:H130)","v":0},{"$f":"SUM(I127:I130)","v":0},0,{"$f":"SUM(K127:K130)","v":0},{"$f":"SUM(L127:L130)","v":0},{"$f":"SUM(M127:M130)","v":0},{"$f":"SUM(N127:N130)","v":0},{"$f":"+C131-(SUM(D131:N131))","v":0}]
[null,"Mortgage Interest"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C133-(SUM(D133:N133))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C134-(SUM(D134:N134))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C135-(SUM(D135:N135))","v":0}]
[null,"Total Mortgage Interest",{"$f":"SUM(C132:C135)","v":0},0,0,0,0,{"$f":"SUM(H132:H135)","v":0},{"$f":"SUM(I132:I135)","v":0},0,{"$f":"SUM(K132:K135)","v":0},{"$f":"SUM(L132:L135)","v":0},{"$f":"SUM(M132:M135)","v":0},{"$f":"SUM(N132:N135)","v":0},{"$f":"+C136-(SUM(D136:N136))","v":0}]
[null,"Insurance (identify type of insurance)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C138-(SUM(D138:N138))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C139-(SUM(D139:N139))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C140-(SUM(D140:N140))","v":0}]
[null,"Total Insurance",{"$f":"SUM(C137:C140)","v":0},0,0,0,0,{"$f":"SUM(H137:H140)","v":0},{"$f":"SUM(I137:I140)","v":0},0,{"$f":"SUM(K137:K140)","v":0},{"$f":"SUM(L137:L140)","v":0},{"$f":"SUM(M137:M140)","v":0},{"$f":"SUM(N137:N140)","v":0},{"$f":"+C141-(SUM(D141:N141))","v":0}]
[null,"Security"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C143-(SUM(D143:N143))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C144-(SUM(D144:N144))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C145-(SUM(D145:N145))","v":0}]
[null,"Total Security",{"$f":"SUM(C142:C145)","v":0},0,0,0,0,{"$f":"SUM(H142:H145)","v":0},{"$f":"SUM(I142:I145)","v":0},0,{"$f":"SUM(K142:K145)","v":0},{"$f":"SUM(L142:L145)","v":0},{"$f":"SUM(M142:M145)","v":0},{"$f":"SUM(N142:N145)","v":0},{"$f":"+C146-(SUM(D146:N146))","v":0}]
[null,"Janitorial"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C148-(SUM(D148:N148))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C149-(SUM(D149:N149))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C150-(SUM(D150:N150))","v":0}]
[null,"Total Security",{"$f":"SUM(C147:C150)","v":0},0,0,0,0,{"$f":"SUM(H147:H150)","v":0},{"$f":"SUM(I147:I150)","v":0},0,{"$f":"SUM(K147:K150)","v":0},{"$f":"SUM(L147:L150)","v":0},{"$f":"SUM(M147:M150)","v":0},{"$f":"SUM(N147:N150)","v":0},{"$f":"+C151-(SUM(D151:N151))","v":0}]
[null,"Repair (Identify all items over $100.)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C153-(SUM(D153:N153))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C154-(SUM(D154:N154))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C155-(SUM(D155:N155))","v":0}]
[null,"Total Repair",{"$f":"SUM(C152:C155)","v":0},0,0,0,0,{"$f":"SUM(H152:H155)","v":0},{"$f":"SUM(I152:I155)","v":0},0,{"$f":"SUM(K152:K155)","v":0},{"$f":"SUM(L152:L155)","v":0},{"$f":"SUM(M152:M155)","v":0},{"$f":"SUM(N152:N155)","v":0},{"$f":"+C156-(SUM(D156:N156))","v":0}]
[null,"Taxes (Identify Type of Tax)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C158-(SUM(D158:N158))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C159-(SUM(D159:N159))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C160-(SUM(D160:N160))","v":0}]
[null,"Total Taxes",{"$f":"SUM(C157:C160)","v":0},0,0,0,0,{"$f":"SUM(H157:H160)","v":0},{"$f":"SUM(I157:I160)","v":0},0,{"$f":"SUM(K157:K160)","v":0},{"$f":"SUM(L157:L160)","v":0},{"$f":"SUM(M157:M160)","v":0},{"$f":"SUM(N157:N160)","v":0},{"$f":"+C161-(SUM(D161:N161))","v":0}]
[null,"Total Occupancy/Building",{"$f":"SUM(C161,C156,C151,C146,C141,C136,C131,C126,C121)","v":0},{"$f":"SUM(D161,D156,D151,D146,D141,D136,D131,D126,D121)","v":0},0,0,0,{"$f":"SUM(H161,H156,H151,H146,H141,H136,H131,H126,H121)","v":0},{"$f":"SUM(I161,I156,I151,I146,I141,I136,I131,I126,I121)","v":0},0,{"$f":"SUM(K161,K156,K151,K146,K141,K136,K131,K126,K121)","v":0},{"$f":"SUM(L161,L156,L151,L146,L141,L136,L131,L126,L121)","v":0},{"$f":"SUM(M161,M156,M151,M146,M141,M136,M131,M126,M121)","v":0},{"$f":"SUM(N161,N156,N151,N146,N141,N136,N131,N126,N121)","v":0},{"$f":"+C162-(SUM(D162:N162))","v":0}]
[null,"Transportation/Travel"]
[null,"Mileage Reimbursement"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C165-(SUM(D165:N165))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C166-(SUM(D166:N166))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C167-(SUM(D167:N167))","v":0}]
[null,"Total Mileage Reimbursement",{"$f":"SUM(C164:C167)","v":0},0,0,0,0,{"$f":"SUM(H164:H167)","v":0},{"$f":"SUM(I164:I167)","v":0},0,{"$f":"SUM(K164:K167)","v":0},{"$f":"SUM(L164:L167)","v":0},{"$f":"SUM(M164:M167)","v":0},{"$f":"SUM(N164:N167)","v":0},{"$f":"+C168-(SUM(D168:N168))","v":0}]
[null,"Delivery"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C170-(SUM(D170:N170))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C171-(SUM(D171:N171))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C172-(SUM(D172:N172))","v":0}]
[null,"Total Delivery",{"$f":"SUM(C169:C172)","v":0},0,0,0,0,{"$f":"SUM(H169:H172)","v":0},{"$f":"SUM(I169:I172)","v":0},0,{"$f":"SUM(K169:K172)","v":0},{"$f":"SUM(L169:L172)","v":0},{"$f":"SUM(M169:M172)","v":0},{"$f":"SUM(N169:N172)","v":0},{"$f":"+C173-(SUM(D173:N173))","v":0}]
[null,"Gas & Oil"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C175-(SUM(D175:N175))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C176-(SUM(D176:N176))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C177-(SUM(D177:N177))","v":0}]
[null,"Total Gas & Oil",{"$f":"SUM(C174:C177)","v":0},0,0,0,0,{"$f":"SUM(H174:H177)","v":0},{"$f":"SUM(I174:I177)","v":0},0,{"$f":"SUM(K174:K177)","v":0},{"$f":"SUM(L174:L177)","v":0},{"$f":"SUM(M174:M177)","v":0},{"$f":"SUM(N174:N177)","v":0},{"$f":"+C178-(SUM(D178:N178))","v":0}]
[null,"Repairs (Identify Item & year purchased)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C180-(SUM(D180:N180))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C181-(SUM(D181:N181))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C182-(SUM(D182:N182))","v":0}]
[null,"Total Repair",{"$f":"SUM(C179:C182)","v":0},0,0,0,0,{"$f":"SUM(H179:H182)","v":0},{"$f":"SUM(I179:I182)","v":0},0,{"$f":"SUM(K179:K182)","v":0},{"$f":"SUM(L179:L182)","v":0},{"$f":"SUM(M179:M182)","v":0},{"$f":"SUM(N179:N182)","v":0},{"$f":"+C183-(SUM(D183:N183))","v":0}]
[null,"Insurance (identify type of insurance)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C185-(SUM(D185:N185))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C186-(SUM(D186:N186))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C187-(SUM(D187:N187))","v":0}]
[null,"Total Insurance",{"$f":"SUM(C184:C187)","v":0},0,0,0,0,{"$f":"SUM(H184:H187)","v":0},{"$f":"SUM(I184:I187)","v":0},0,{"$f":"SUM(K184:K187)","v":0},{"$f":"SUM(L184:L187)","v":0},{"$f":"SUM(M184:M187)","v":0},{"$f":"SUM(N184:N187)","v":0},{"$f":"+C188-(SUM(D188:N188))","v":0}]
[null,"Depreciation/Lease (identify item, year purchased, cost)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C190-(SUM(D190:N190))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C191-(SUM(D191:N191))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C192-(SUM(D192:N192))","v":0}]
[null,"Total Depreciation",{"$f":"SUM(C189:C192)","v":0},0,0,0,0,{"$f":"SUM(H189:H192)","v":0},{"$f":"SUM(I189:I192)","v":0},0,{"$f":"SUM(K189:K192)","v":0},{"$f":"SUM(L189:L192)","v":0},{"$f":"SUM(M189:M192)","v":0},{"$f":"SUM(N189:N192)","v":0},{"$f":"+C193-(SUM(D193:N193))","v":0}]
[null,"Interest"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C195-(SUM(D195:N195))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C196-(SUM(D196:N196))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C197-(SUM(D197:N197))","v":0}]
[null,"Total Interest",{"$f":"SUM(C194:C197)","v":0},0,0,0,0,{"$f":"SUM(H194:H197)","v":0},{"$f":"SUM(I194:I197)","v":0},0,{"$f":"SUM(K194:K197)","v":0},{"$f":"SUM(L194:L197)","v":0},{"$f":"SUM(M194:M197)","v":0},{"$f":"SUM(N194:N197)","v":0},{"$f":"+C198-(SUM(D198:N198))","v":0}]
[null,"Tags & Licenses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C200-(SUM(D200:N200))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C201-(SUM(D201:N201))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C202-(SUM(D202:N202))","v":0}]
[null,"Total Tags & Licenses",{"$f":"SUM(C199:C202)","v":0},0,0,0,0,{"$f":"SUM(H199:H202)","v":0},{"$f":"SUM(I199:I202)","v":0},0,{"$f":"SUM(K199:K202)","v":0},{"$f":"SUM(L199:L202)","v":0},{"$f":"SUM(M199:M202)","v":0},{"$f":"SUM(N199:N202)","v":0},{"$f":"+C203-(SUM(D203:N203))","v":0}]
[null,"Total Transportation/Travel",{"$f":"SUM(C203,C198,C193,C188,C183,C178,C173,C168)","v":0},0,0,0,0,{"$f":"SUM(H203,H198,H193,H188,H183,H178,H173,H168)","v":0},{"$f":"SUM(I203,I198,I193,I188,I183,I178,I173,I168)","v":0},0,{"$f":"SUM(K203,K198,K193,K188,K183,K178,K173,K168)","v":0},{"$f":"SUM(L203,L198,L193,L188,L183,L178,L173,L168)","v":0},{"$f":"SUM(M203,M198,M193,M188,M183,M178,M173,M168)","v":0},{"$f":"SUM(N203,N198,N193,N188,N183,N178,N173,N168)","v":0},{"$f":"+C204-(SUM(D204:N204))","v":0}]
[null,"Administrative & General"]
[null,"Advertising"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C207-(SUM(D207:N207))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C208-(SUM(D208:N208))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C209-(SUM(D209:N209))","v":0}]
[null,"Total Advertising",{"$f":"SUM(C206:C209)","v":0},0,0,0,0,{"$f":"SUM(H206:H209)","v":0},{"$f":"SUM(I206:I209)","v":0},0,{"$f":"SUM(K206:K209)","v":0},{"$f":"SUM(L206:L209)","v":0},{"$f":"SUM(M206:M209)","v":0},{"$f":"SUM(N206:N209)","v":0},{"$f":"+C210-(SUM(D210:N210))","v":0}]
[null,"Printing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C212-(SUM(D212:N212))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C213-(SUM(D213:N213))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C214-(SUM(D214:N214))","v":0}]
[null,"Total Printing",{"$f":"SUM(C211:C214)","v":0},0,0,0,0,{"$f":"SUM(H211:H214)","v":0},{"$f":"SUM(I211:I214)","v":0},0,{"$f":"SUM(K211:K214)","v":0},{"$f":"SUM(L211:L214)","v":0},{"$f":"SUM(M211:M214)","v":0},{"$f":"SUM(N211:N214)","v":0},{"$f":"+C215-(SUM(D215:N215))","v":0}]
[null,"Copying"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C217-(SUM(D217:N217))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C218-(SUM(D218:N218))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C219-(SUM(D219:N219))","v":0}]
[null,"Total Copying",{"$f":"SUM(C216:C219)","v":0},0,0,0,0,{"$f":"SUM(H216:H219)","v":0},{"$f":"SUM(I216:I219)","v":0},0,{"$f":"SUM(K216:K219)","v":0},{"$f":"SUM(L216:L219)","v":0},{"$f":"SUM(M216:M219)","v":0},{"$f":"SUM(N216:N219)","v":0},{"$f":"+C220-(SUM(D220:N220))","v":0}]
[null,"Office Supplies"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C222-(SUM(D222:N222))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C223-(SUM(D223:N223))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C224-(SUM(D224:N224))","v":0}]
[null,"Total Office supplies",{"$f":"SUM(C221:C224)","v":0},0,0,0,0,{"$f":"SUM(H221:H224)","v":0},{"$f":"SUM(I221:I224)","v":0},0,{"$f":"SUM(K221:K224)","v":0},{"$f":"SUM(L221:L224)","v":0},{"$f":"SUM(M221:M224)","v":0},{"$f":"SUM(N221:N224)","v":0},{"$f":"+C225-(SUM(D225:N225))","v":0}]
[null,"Contractual Agreements"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C227-(SUM(D227:N227))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C228-(SUM(D228:N228))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C229-(SUM(D229:N229))","v":0}]
[null,"Total Contractual Agreements",{"$f":"SUM(C226:C229)","v":0},0,0,0,0,{"$f":"SUM(H226:H229)","v":0},{"$f":"SUM(I226:I229)","v":0},0,{"$f":"SUM(K226:K229)","v":0},{"$f":"SUM(L226:L229)","v":0},{"$f":"SUM(M226:M229)","v":0},{"$f":"SUM(N226:N229)","v":0},{"$f":"+C230-(SUM(D230:N230))","v":0}]
[null,"Postage"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C232-(SUM(D232:N232))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C233-(SUM(D233:N233))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C234-(SUM(D234:N234))","v":0}]
[null,"Total Postage",{"$f":"SUM(C231:C234)","v":0},0,0,0,0,{"$f":"SUM(H231:H234)","v":0},{"$f":"SUM(I231:I234)","v":0},0,{"$f":"SUM(K231:K234)","v":0},{"$f":"SUM(L231:L234)","v":0},{"$f":"SUM(M231:M234)","v":0},{"$f":"SUM(N231:N234)","v":0},{"$f":"+C235-(SUM(D235:N235))","v":0}]
[null,"Telecommunications"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C237-(SUM(D237:N237))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C238-(SUM(D238:N238))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C239-(SUM(D239:N239))","v":0}]
[null,"Total Telecommunication",{"$f":"SUM(C236:C239)","v":0},0,0,0,0,{"$f":"SUM(H236:H239)","v":0},{"$f":"SUM(I236:I239)","v":0},0,{"$f":"SUM(K236:K239)","v":0},{"$f":"SUM(L236:L239)","v":0},{"$f":"SUM(M236:M239)","v":0},{"$f":"SUM(N236:N239)","v":0},{"$f":"+C240-(SUM(D240:N240))","v":0}]
[null,"Liability Insurance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C242-(SUM(D242:N242))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C243-(SUM(D243:N243))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C244-(SUM(D244:N244))","v":0}]
[null,"Total Liability Insurance",{"$f":"SUM(C241:C244)","v":0},0,0,0,0,{"$f":"SUM(H241:H244)","v":0},{"$f":"SUM(I241:I244)","v":0},0,{"$f":"SUM(K241:K244)","v":0},{"$f":"SUM(L241:L244)","v":0},{"$f":"SUM(M241:M244)","v":0},{"$f":"SUM(N241:N244)","v":0},{"$f":"+C245-(SUM(D245:N245))","v":0}]
[null,"Legal Fees"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C247-(SUM(D247:N247))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C248-(SUM(D248:N248))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C249-(SUM(D249:N249))","v":0}]
[null,"Total Legal Fees",{"$f":"SUM(C246:C249)","v":0},0,0,0,0,{"$f":"SUM(H246:H249)","v":0},{"$f":"SUM(I246:I249)","v":0},0,{"$f":"SUM(K246:K249)","v":0},{"$f":"SUM(L246:L249)","v":0},{"$f":"SUM(M246:M249)","v":0},{"$f":"SUM(N246:N249)","v":0},{"$f":"+C250-(SUM(D250:N250))","v":0}]
[null,"Accounting Fees"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C252-(SUM(D252:N252))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C253-(SUM(D253:N253))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C254-(SUM(D254:N254))","v":0}]
[null,"Total Accounting Fees",{"$f":"SUM(C251:C254)","v":0},0,0,0,0,{"$f":"SUM(H251:H254)","v":0},{"$f":"SUM(I251:I254)","v":0},0,{"$f":"SUM(K251:K254)","v":0},{"$f":"SUM(L251:L254)","v":0},{"$f":"SUM(M251:M254)","v":0},{"$f":"SUM(N251:N254)","v":0},{"$f":"+C255-(SUM(D255:N255))","v":0}]
[null,"Consulting Fees"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C257-(SUM(D257:N257))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C258-(SUM(D258:N258))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C259-(SUM(D259:N259))","v":0}]
[null,"Total Consulting Fees",{"$f":"SUM(C256:C259)","v":0},0,0,0,0,{"$f":"SUM(H256:H259)","v":0},{"$f":"SUM(I256:I259)","v":0},0,{"$f":"SUM(K256:K259)","v":0},{"$f":"SUM(L256:L259)","v":0},{"$f":"SUM(M256:M259)","v":0},{"$f":"SUM(N256:N259)","v":0},{"$f":"+C260-(SUM(D260:N260))","v":0}]
[null,"Other Fees (Explain)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C262-(SUM(D262:N262))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C263-(SUM(D263:N263))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C264-(SUM(D264:N264))","v":0}]
[null,"Total Other Fees",{"$f":"SUM(C261:C264)","v":0},0,0,0,0,{"$f":"SUM(H261:H264)","v":0},{"$f":"SUM(I261:I264)","v":0},0,{"$f":"SUM(K261:K264)","v":0},{"$f":"SUM(L261:L264)","v":0},{"$f":"SUM(M261:M264)","v":0},{"$f":"SUM(N261:N264)","v":0},{"$f":"+C265-(SUM(D265:N265))","v":0}]
[null,"Audit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C267-(SUM(D267:N267))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C268-(SUM(D268:N268))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C269-(SUM(D269:N269))","v":0}]
[null,"Total Audit",{"$f":"SUM(C266:C269)","v":0},0,0,0,0,{"$f":"SUM(H266:H269)","v":0},{"$f":"SUM(I266:I269)","v":0},0,{"$f":"SUM(K266:K269)","v":0},{"$f":"SUM(L266:L269)","v":0},{"$f":"SUM(M266:M269)","v":0},{"$f":"SUM(N266:N269)","v":0},{"$f":"+C270-(SUM(D270:N270))","v":0}]
[null,"Other Misc. (Explain)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C272-(SUM(D272:N272))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C273-(SUM(D273:N273))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+C274-(SUM(D274:N274))","v":0}]
[null,"Total other Misc.",{"$f":"SUM(C271:C274)","v":0},{"$f":"SUM(D271:D274)","v":0},0,0,0,{"$f":"SUM(H271:H274)","v":0},{"$f":"SUM(I271:I274)","v":0},0,{"$f":"SUM(K271:K274)","v":0},{"$f":"SUM(L271:L274)","v":0},{"$f":"SUM(M271:M274)","v":0},{"$f":"SUM(N271:N274)","v":0},{"$f":"+C275-(SUM(D275:N275))","v":0}]
[null,"Total Administrative & General",{"$f":"SUM(C275,C270,C265,C260,C255,C250,C245,C240,C235,C230,C225,C220,C215,C210)","v":0},{"$f":"SUM(D275,D270,D265,D260,D255,D250,D245,D240,D235,D230,D225,D220,D215,D210)","v":0},0,0,0,0,{"$f":"SUM(I275,I270,I265,I260,I255,I250,I245,I240,I235,I230,I225,I220,I215,I210)","v":0},0,0,0,{"$f":"SUM(M275,M270,M265,M260,M255,M250,M245,M240,M235,M230,M225,M220,M215,M210)","v":0},0,0]
[null,"Total"]
[null,"Total of all Cost Areas",{"$f":"SUM(C37+C54+C93+C115+C162+C204+C276)","v":0},0,0,0,0,0,{"$f":"SUM(I37+I54+I93+I115+I162+I204+I276)","v":0},0,0,0,{"$f":"SUM(M37+M54+M93+M115+M162+M204+M276)","v":0},0,0]
[null,"Percentage of Total Cost  ",{"$f":"SUM(D279:O279)","v":0},{"$f":"IF(Total_Total_All_Cost_Areas=0,0,+HD_Total_All_Cost_Areas/Total_Total_All_Cost_Areas)","v":0},{"$f":"IF(Total_Total_All_Cost_Areas=0,0,+NE_AAA_Total_All_Cost_Areas/Total_Total_All_Cost_Areas)","v":0},{"$f":"IF(Total_Total_All_Cost_Areas=0,0,+NE_RLS__Total_All_Cost_Areas/Total_Total_All_Cost_Areas)","v":0},{"$f":"IF(Total_Total_All_Cost_Areas=0,0,C_Total_All_Cost_Areas/Total_Total_All_Cost_Areas)","v":0},{"$f":"IF(Total_Total_All_Cost_Areas=0,0,H278/Total_Total_All_Cost_Areas)","v":0},0,0,0,0,{"$f":"IF(Total_Total_All_Cost_Areas=0,0,M278/Total_Total_All_Cost_Areas)","v":0},0]
[null,"Budgeted Meals"]
[null,"Provider Prepared Meals"]
[null,"Hot Meals ",{"$f":"+D282+G282+H282","v":0}]
[null,"Frozen Meals ",0]
[null,"Chilled Meals",{"$f":"+D284+G284+H284","v":0}]
[null,"Shelf Stable Meals"]
[null,"Total Provider Prepared Meals",{"$f":"+D286+G286+H286","v":0},{"$f":"SUM(D282:D285)","v":0},null,null,{"$f":"SUM(G282:G285)","v":0},{"$f":"SUM(H282:H284)","v":0}]
[null,"Purchased Meals"]
[null,"Hot Prepared Meals Purchased from a Supplier or Central Kitchen",{"$f":"+D288+G288+H288","v":0}]
[null,"Frozen Meals ",{"$f":"+D289+G289+H289","v":0}]
[null,"Chilled Meals",{"$f":"+D290+G290+H290","v":0}]
[null,"Shelf Stable Meals",{"$f":"+D291+G291+H291","v":0}]
[null,"Total Purchased Meals",{"$f":"SUM(C288:C291)","v":0},{"$f":"SUM(D288:D291)","v":0},null,null,{"$f":"SUM(G288:G291)","v":0},{"$f":"SUM(H288:H291)","v":0}]
[]
[null,"Total Budgeted Meals",{"$f":"+Total_MealsPreparedByProvider+Total_TotalPurchasedMeals","v":0},{"$f":"+HD_MealsPreparedByProvider+HD_TotalPurchasedMeals","v":0},null,null,{"$f":"+C_MealsPreparedByProvider+C_TotalPurchasedMeals","v":0},{"$f":"+H286+H292","v":0}]
[null,"% of Total Meals",null,{"$f":"IF(C294=0,0,+D294/C294)","v":0},null,null,{"$f":"IF(C294=0,0,+G294/C294)","v":0},{"$f":"IF(C294=0,0,+H294/C294)","v":0}]
[null,"Whole Unit Rate",null,{"$f":"IF(AND(HD_Total_All_Cost_Areas=0,HD_TotalBudgetedMeals=0),0,(IF(E300=\"N\",(HD_Total_All_Cost_Areas+NE_RLS__Total_All_Cost_Areas)/HD_TotalBudgetedMeals,(+HD_Total_All_Cost_Areas+(NE_AAA_Total_All_Cost_Areas*D303)+NE_RLS__Total_All_Cost_Areas)/HD_TotalBudgetedMeals)))","v":0},null,null,{"$f":"IF(AND(C_Total_All_Cost_Areas=0,C_TotalBudgetedMeals=0),0,(IF(E300=\"N\",C_Total_All_Cost_Areas/C_TotalBudgetedMeals,(C_Total_All_Cost_Areas+(NE_AAA_Total_All_Cost_Areas*D304))/C_TotalBudgetedMeals)))","v":0},{"$f":"IF(AND(H278>0,H294>0),H278/H294,\"\")","v":""}]
[]
[null,"AAA Contractors/Subrecipients may choose to provide required Nutrition Education as a separate service and exclude costs related to Nutrition Education from the meal rate."]
[null,"If the cost of Nutrition Education is to be provided as a separate service, enter an N. This will"]
[null,"exclude Nutrition Education costs from the meal rate.\n"]
[]
[null,null,null,{"$f":"+HD_TotalBudgetedMeals+C_TotalBudgetedMeals","v":0}]
[null,null,"HDM",{"$f":"+D294/D302","v":{"$error":"#DIV/0!"}}]
[null,null,"CM",{"$f":"+C_TotalBudgetedMeals/D302","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Yes"]
[null,null,"No"]
[null,null,"NA"]

{"sheet":"Provider Service Area","index":2,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[[16,1,16,6],[19,1,19,6],[8,1,9,6],[6,1,6,6],[11,1,12,6],[14,1,14,6],[15,1,15,6],[18,1,18,6],[17,1,17,6]]}
[null,{"$f":"NOW()","v":"2020-07-23T18:20:44.220"}]
[null,"Provider Name: ",{"$f":"IF(ISBLANK('Provider Information'!F6),\"\",+'Provider Information'!F6)","v":""}]
[null,"AAA Name:",{"$f":"+'Provider Information'!D21","v":0}]
[null,"Region Number:",{"$f":"+'Provider Information'!E26","v":0}]
[null,"Type of Provider:",{"$f":"+'Provider Information'!B5","v":""}]
[]
[null,"Provider Service Area"]
[]
[null,"This section is used to identify the nutrition provider's service area for FFY 2020. This will assist HHS in defining unserved areas of the state. \n"]
[]
[]
[null,"Please specify the provider's service area by geographical location (county, city, zip code, etc.) If the provider serves an entire county, record the name of the county. City, zip code, and other designations can be used when the provider agency is not serving an entire county. \n\nExamples: 1) City of El Paso; 2) Harris County; 3) Two mile radius of the city limits of Rockdale and Cameron; 4) City of Cedar Park, Leander Zip Codes 78745 and 78746. "]
[]
[]
[null,"Congregate Meals Service Area:"]
[]
[null,"Home Delivered Meals - AAA Service Area: "]
[]
[null,"Home-Delivered Meals - CSS Service Area: "]

{"sheet":"Analysis Tool","index":3,"n_rows":71,"n_cols":12,"rows_kept":71,"cut":false,"hidden":false,"merged":[[3,2,3,6],[2,2,2,7],[1,2,1,6],[10,4,10,5],[11,4,11,5],[12,4,12,5],[49,5,49,6],[4,1,4,7],[24,4,24,5],[16,4,16,5],[17,4,17,5],[47,5,47,6],[48,5,48,6],[8,2,9,5],[5,1,5,7],[27,1,27,7],[35,2,36,3],[33,1,33,10],[35,9,36,10],[38,5,38,6],[37,5,37,6],[22,4,22,5],[23,4,23,5],[35,5,36,7],[20,4,20,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[18,4,18,5],[19,4,19,5],[21,4,21,5],[70,1,70,10],[50,5,50,6],[51,5,51,6],[69,1,69,10],[54,5,54,6],[52,5,52,6],[61,5,61,6],[59,5,59,6],[62,5,62,6],[58,5,58,6],[53,5,53,6],[46,5,46,6],[39,5,39,6],[40,5,40,6],[45,5,45,6],[32,1,32,10],[41,5,41,6],[42,5,42,6],[43,5,43,6],[44,5,44,6]]}
[null,{"$f":"NOW()","v":"2020-07-23T18:20:44.220"}]
[null,"Provider Name: ",{"$f":"IF(ISBLANK('Provider Information'!F6),\"\",+'Provider Information'!F6)","v":""}]
[null,"AAA Name:",{"$f":"+'Provider Information'!D21","v":0}]
[null,"Region Number:",{"$f":"+'Provider Information'!E26","v":0}]
[null,"Section 1"]
[null,"This section is used to compare the amounts budgeted/allocated to each program by cost area. \nExample: What percent of the agencies personnel cost is budgeted/allocated to home delivered meals versus congregate meals and other agency programs? The information should be used as a review tool to gain an understanding of the agencies overall budget and operations. "]
[]
[]
[null,null,"Percentage of the Total Cost Area Budgeted to:"]
[]
[null,"Cost Area ","Home Delivered Meals","Congregate Meals","Other Programs"]
[null,"Total Personnel ",{"$f":"IF('Provider Total Budget by Serv'!D37>0,'Provider Total Budget by Serv'!D37/'Provider Total Budget by Serv'!C37,0)","v":0},{"$f":"IF('Provider Total Budget by Serv'!G37>0,'Provider Total Budget by Serv'!G37/'Provider Total Budget by Serv'!C37,0)","v":0},{"$f":"IF('Provider Total Budget by Serv'!C37-'Provider Total Budget by Serv'!D37-'Provider Total Budget by Serv'!G37>0,('Provider Total Budget by Serv'!C37-'Provider Total Budget by Serv'!D37-'Provider Total Budget by Serv'!G37)/'Provider Total Budget by Serv'!C37,0)","v":0}]
[null,"Total Professional Development",{"$f":"IF('Provider Total Budget by Serv'!D54>0,'Provider Total Budget by Serv'!D54/'Provider Total Budget by Serv'!C54,0)","v":0},{"$f":"IF('Provider Total Budget by Serv'!G54>0,'Provider Total Budget by Serv'!G54/'Provider Total Budget by Serv'!C54,0)","v":0},{"$f":"IF('Provider Total Budget by Serv'!C54-'Provider Total Budget by Serv'!D54-'Provider Total Budget by Serv'!G54>0,('Provider Total Budget by Serv'!C54-'Provider Total Budget by Serv'!D54-'Provider Total Budget by Serv'!G54)/'Provider Total Budget by Serv'!C54,0)","v":0}]
[null,"Total Raw Food",{"$f":"IF('Provider Total Budget by Serv'!D61>0,'Provider Total Budget by Serv'!D61/'Provider Total Budget by Serv'!C61,0)","v":0},{"$f":"IF('Provider Total Budget by Serv'!G61>0,'Provider Total Budget by Serv'!G61/'Provider Total Budget by Serv'!C61,0)","v":0},{"$f":"IF('Provider Total Budget by Serv'!C61-'Provider Total Budget by Serv'!D61-'Provider Total Budget by Serv'!G61>0,('Provider Total Budget by Serv'!C61-'Provider Total Budget by Serv'!D61-'Provider Total Budget by Serv'!G61)/'Provider Total Budget by Serv'!C61,0)","v":0}]
[null,"Total Purchased Meals",{"$f":"IF('Provider Total Budget by Serv'!D68>0,'Provider Total Budget by Serv'!D68/'Provider Total Budget by Serv'!C68,0)","v":0},{"$f":"IF('Provider Total Budget by Serv'!G68>0,'Provider Total Budget by Serv'!G68/'Provider Total Budget by Serv'!C68,0)","v":0},{"$f":"IF('Provider Total Budget by Serv'!C68-'Provider Total Budget by Serv'!D68-'Provider Total Budget by Serv'!G68>0,('Provider Total Budget by Serv'!C68-'Provider Total Budget by Serv'!D68-'Provider Total Budget by Serv'!G68)/'Provider Total Budget by Serv'!C68,0)","v":0}]
[null,"Total Freight",{"$f":"IF('Provider Total Budget by Serv'!D73>0,'Provider Total Budget by Serv'!D73/'Provider Total Budget by Serv'!C73,0)","v":0},{"$f":"IF('Provider Total Budget by Serv'!G73>0,'Provider Total Budget by Serv'!G73/'Provider Total Budget by Serv'!C73,0)","v":0},{"$f":"IF('Provider Total Budget by Serv'!C73-'Provider Total Budget by Serv'!D73-'Provider Total Budget by Serv'!G73>0,('Provider Total Budget by Serv'!C73-'Provider Total Budget by Serv'!D73-'Provider Total Budget by Serv'!G73)/'Provider Total Budget by Serv'!C73,0)","v":0}]
[null,"Total Storage Cost",{"$f":"IF('Provider Total Budget by Serv'!D78>0,'Provider Total Budget by Serv'!D78/'Provider Total Budget by Serv'!C78,0)","v":0},{"$f":"IF('Provider Total Budget by Serv'!G78>0,'Provider Total Budget by Serv'!G78/'Provider Total Budget by Serv'!C78,0)","v":0},{"$f":"IF('Provider Total Budget by Serv'!C78-'Provider Total Budget by Serv'!D78-'Provider Total Budget by Serv'!G78>0,('Provider Total Budget by Serv'!C78-'Provider Total Budget by Serv'!D78-'Provider Total Budget by Serv'!G78)/'Provider Total Budget by Serv'!C78,0)","v":0}]
[null,"Total Consumables",{"$f":"IF('Provider Total Budget by Serv'!D87>0,'Provider Total Budget by Serv'!D87/'Provider Total Budget by Serv'!C87,0)","v":0},{"$f":"IF('Provider Total Budget by Serv'!G87>0,'Provider Total Budget by Serv'!G87/'Provider Total Budget by Serv'!C87,0)","v":0},{"$f":"IF('Provider Total Budget by Serv'!C87-'Provider Total Budget by Serv'!D87-'Provider Total Budget by Serv'!G87>0,('Provider Total Budget by Serv'!C87-'Provider Total Budget by Serv'!D87-'Provider Total Budget by Serv'!G87)/'Provider Total Budget by Serv'!C87,0)","v":0}]
[null,"Total Other Meal/Food",{"$f":"IF('Provider Total Budget by Serv'!D92>0,'Provider Total Budget by Serv'!D92/'Provider Total Budget by Serv'!C92,0)","v":0},{"$f":"IF('Provider Total Budget by Serv'!G92>0,'Provider Total Budget by Serv'!G92/'Provider Total Budget by Serv'!C92,0)","v":0},{"$f":"IF('Provider Total Budget by Serv'!C92-'Provider Total Budget by Serv'!D92-'Provider Total Budget by Serv'!G92>0,('Provider Total Budget by Serv'!C92-'Provider Total Budget by Serv'!D92-'Provider Total Budget by Serv'!G92)/'Provider Total Budget by Serv'!C92,0)","v":0}]
[null,"Total Meals/Food",{"$f":"IF('Provider Total Budget by Serv'!D93>0,'Provider Total Budget by Serv'!D93/'Provider Total Budget by Serv'!C93,0)","v":0},{"$f":"IF('Provider Total Budget by Serv'!G93>0,'Provider Total Budget by Serv'!G93/'Provider Total Budget by Serv'!C93,0)","v":0},{"$f":"IF('Provider Total Budget by Serv'!C93-'Provider Total Budget by Serv'!D93-'Provider Total Budget by Serv'!G93>0,('Provider Total Budget by Serv'!C93-'Provider Total Budget by Serv'!D93-'Provider Total Budget by Serv'!G93)/'Provider Total Budget by Serv'!C93,0)","v":0}]
[null,"Total Equipment",{"$f":"IF('Provider Total Budget by Serv'!D115>0,'Provider Total Budget by Serv'!D115/'Provider Total Budget by Serv'!C115,0)","v":0},{"$f":"IF('Provider Total Budget by Serv'!G115>0,'Provider Total Budget by Serv'!G115/'Provider Total Budget by Serv'!C115,0)","v":0},{"$f":"IF('Provider Total Budget by Serv'!C115-'Provider Total Budget by Serv'!D115-'Provider Total Budget by Serv'!G115>0,('Provider Total Budget by Serv'!C115-'Provider Total Budget by Serv'!D115-'Provider Total Budget by Serv'!G115)/'Provider Total Budget by Serv'!C115,0)","v":0}]
[null,"Total Occupancy/Building",{"$f":"IF('Provider Total Budget by Serv'!D162>0,'Provider Total Budget by Serv'!D162/'Provider Total Budget by Serv'!C162,0)","v":0},{"$f":"IF('Provider Total Budget by Serv'!G162>0,'Provider Total Budget by Serv'!G162/'Provider Total Budget by Serv'!C162,0)","v":0},{"$f":"IF('Provider Total Budget by Serv'!C162-'Provider Total Budget by Serv'!D162-'Provider Total Budget by Serv'!G162>0,('Provider Total Budget by Serv'!C162-'Provider Total Budget by Serv'!D162-'Provider Total Budget by Serv'!G162)/'Provider Total Budget by Serv'!C162,0)","v":0}]
[null,"Total Transportation/Travel",{"$f":"IF('Provider Total Budget by Serv'!D204>0,'Provider Total Budget by Serv'!D204/'Provider Total Budget by Serv'!C204,0)","v":0},{"$f":"IF('Provider Total Budget by Serv'!G204>0,'Provider Total Budget by Serv'!G204/'Provider Total Budget by Serv'!C204,0)","v":0},{"$f":"IF('Provider Total Budget by Serv'!C204-'Provider Total Budget by Serv'!D204-'Provider Total Budget by Serv'!G204>0,('Provider Total Budget by Serv'!C204-'Provider Total Budget by Serv'!D204-'Provider Total Budget by Serv'!G204)/'Provider Total Budget by Serv'!C204,0)","v":0}]
[null,"Total Administrative & General",{"$f":"IF('Provider Total Budget by Serv'!D276>0,'Provider Total Budget by Serv'!D276/'Provider Total Budget by Serv'!C276,0)","v":0},{"$f":"IF('Provider Total Budget by Serv'!G276>0,'Provider Total Budget by Serv'!G276/'Provider Total Budget by Serv'!C276,0)","v":0},{"$f":"IF('Provider Total Budget by Serv'!C276-'Provider Total Budget by Serv'!D276-'Provider Total Budget by Serv'!G276>0,('Provider Total Budget by Serv'!C276-'Provider Total Budget by Serv'!D276-'Provider Total Budget by Serv'!G276)/'Provider Total Budget by Serv'!C276,0)","v":0}]
[null,"Total of all Cost Areas",{"$f":"IF('Provider Total Budget by Serv'!D278>0,'Provider Total Budget by Serv'!D278/'Provider Total Budget by Serv'!$C$278,0)","v":0},{"$f":"IF('Provider Total Budget by Serv'!G278>0,'Provider Total Budget by Serv'!G278/'Provider Total Budget by Serv'!$C$278,0)","v":0},{"$f":"IF('Provider Total Budget by Serv'!C278-'Provider Total Budget by Serv'!D278-'Provider Total Budget by Serv'!G278>0,('Provider Total Budget by Serv'!C278-'Provider Total Budget by Serv'!D278-'Provider Total Budget by Serv'!G278)/'Provider Total Budget by Serv'!C278,0)","v":0}]
[]
[null,"Example of how to use this information:"]
[null,"Compare the percentage of total personnel budgeted to the meal programs and other programs. Based on the percentages of total cost does the percentages appear reasonable and equitably distributed between programs? If the percentages are not easily identified as equitable a further review of the salaries may be necessary. There are many reasons for variances in percentage for example the agency may use volunteers for some of the programs this may cause  the overall percentages appear out of line.\n\nREMEMBER: There are no right or wrong percentages. The reviewer through analysis of the budget and discussions with the provider must determine if the allocation is acceptable. \n\nThe reviewers notes detailing budget review, discussions with the provider, and decisions made should be included in the work file. "]
[]
[]
[]
[]
[null,"Section 2"]
[null,"This section is a summary of information to use to analyze the cost and how they are allocated between Congregate and Home Delivered Meals. The information is presented in three different ways:\n\u0097 Total Cost: Amount budgeted by cost area\n\u0097 Percentage of total cost: Percentage of the total of cost area for the two meal programs applied to each program\n\u0097 Cost per unit: How much of the unit cost is used to pay for each cost area. $X.XX of the cost of each meal is for XX cost area.\n\nBelow the cost area summary information is additional information showing:\n\u0097 Percentage of the total budgeted meal cost applied to the home delivered and congregate meal programs\n\u0097 Percentage of the total budgeted meals (home delivered & congregate) applied to the home delivered and congregate programs.\n\u0097 Whole Unit rate for each meal program\n\u0097 Calculated meal rate based on information entered on the home delivered and congregate meal budget worksheets."]
[]
[null,null,"Total Cost",null,null,"Percentage of Total Cost",null,null,null,"Cost per unit"]
[]
[null,"Cost Area ","Home Delivered Meals","Congregate Meals",null,"Home Delivered Meals",null,"Congregate Meals",null,"Home Delivered Meals","Congregate Meals"]
[null,"Total Personnel ",{"$f":"+'Provider Total Budget by Serv'!D37","v":0},{"$f":"+'Provider Total Budget by Serv'!G37","v":0},null,{"$f":"IF(C39=0,0,C39/(C39+D39))","v":0},null,{"$f":"IF(D39=0,0,D39/(C39+D39))","v":0},null,{"$f":"IF(C39>0,(+C39/C$57)*C$65,0)","v":0},0]
[null,"Total Professional Development",{"$f":"+'Provider Total Budget by Serv'!D54","v":0},{"$f":"+'Provider Total Budget by Serv'!G54","v":0},null,0,null,{"$f":"IF(D40=0,0,D40/(C40+D40))","v":0},null,0,0]
[null,"Total Raw Food",{"$f":"+'Provider Total Budget by Serv'!D61","v":0},{"$f":"+'Provider Total Budget by Serv'!G61","v":0},null,0,null,0,null,{"$f":"IF(C41>0,(+C41/HD_MealsPreparedByProvider),0)","v":0},{"$f":"IF(D41>0,(+D41/C_MealsPreparedByProvider),0)","v":0},{"$f":"IF(K41<>J41,\"?\",0)","v":0}]
[null,"Purchased Meals"]
[null,"Hot Prepared Meals Purchased from a Supplier or Central Kitchen",{"$f":"+HD_Purchased_Hot_Meals","v":0},{"$f":"+C_Purchased_Hot_Meals","v":0},null,{"$f":"IF(C43=0,0,C43/(C43+D43))","v":0},null,{"$f":"IF(D43=0,0,D43/(C43+D43))","v":0},null,{"$f":"IF(C43>0,+C43/HD_HotPrepMealsPurchfromSupplierCentralKitch,0)","v":0},{"$f":"IF(D43>0,+D43/C_HotPrepMealsPurchfromSupplierCentralKitch,0)","v":0}]
[null,"Frozen Meals ",{"$f":"+HD_Purchased_Frozen_Meals","v":0},{"$f":"+C_Purchased_Frozen_Meals","v":0},null,0,null,0,null,{"$f":"IF(C44>0,+C44/HD_PurchasedFrozenMeals,0)","v":0},{"$f":"IF(D44>0,+D44/C_PurchasedFrozenMeals,0)","v":0}]
[null,"Chilled Meals",{"$f":"+HD_Purchased_ChilledMeals","v":0},{"$f":"+C_Purchased_ChilledMeals","v":0},null,0,null,0,null,{"$f":"IF(C45>0,+C45/HDM_Purchased_Chilled_Meals,0)","v":0},{"$f":"IF(D45>0,+D45/CM_Purchased_Chilled_Meals,0)","v":0}]
[null,"Shelf Stable Meals",{"$f":"+HD_Purchased_ShelfStableMeals","v":0},{"$f":"+C_Purchased_ShelfStableMeals","v":0},null,0,null,0,null,{"$f":"IF(C46>0,+C46/HD_PurchasedShelfStableMeals,0)","v":0},{"$f":"IF(D46>0,+D46/C_PurchasedShelfStableMeals,0)","v":0}]
[]
[null,"Total Consumables",{"$f":"+'Provider Total Budget by Serv'!D87","v":0},{"$f":"+'Provider Total Budget by Serv'!G87","v":0},null,0,null,0,null,{"$f":"IF(C48>0,(+C48/C$57)*C$65,0)","v":0},{"$f":"IF(D48>0,(+D48/D$57)*D$65,0)","v":0}]
[null,"Total Other Meal/Food",{"$f":"+'Provider Total Budget by Serv'!D92","v":0},{"$f":"+'Provider Total Budget by Serv'!G92","v":0},null,0,null,0,null,0,0]
[null,"Total Meals/Food",{"$f":"+'Provider Total Budget by Serv'!D93","v":0},{"$f":"+'Provider Total Budget by Serv'!G93","v":0},null,0,null,0,null,0,0]
[null,"Total Equipment",{"$f":"+'Provider Total Budget by Serv'!D115","v":0},{"$f":"+'Provider Total Budget by Serv'!G115","v":0},null,0,null,0,null,0,0]
[null,"Total Occupancy/Building",{"$f":"+'Provider Total Budget by Serv'!D162","v":0},{"$f":"+'Provider Total Budget by Serv'!G162","v":0},null,0,null,0,null,0,0]
[null,"Total Transportation/Travel",{"$f":"+'Provider Total Budget by Serv'!D204","v":0},{"$f":"+'Provider Total Budget by Serv'!G204","v":0},null,0,null,0,null,0,0]
[null,"Total Administrative & General",{"$f":"+'Provider Total Budget by Serv'!D276","v":0},{"$f":"+'Provider Total Budget by Serv'!G276","v":0},null,0,null,0,null,0,0]
[null,"Subtotal",{"$f":"+'Provider Total Budget by Serv'!D278","v":0},{"$f":"+'Provider Total Budget by Serv'!G278","v":0},null,0,null,0,null,0,0]
[null,"Nutrition Education",{"$f":"+'Home Delivered Meal Budget'!I22","v":{"$error":"#DIV/0!"}},{"$f":"+'Congregate Meal Budget'!I22","v":{"$error":"#DIV/0!"}},null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Total",{"$f":"+'Home Delivered Meal Budget'!I80","v":{"$error":"#DIV/0!"}},{"$f":"+'Congregate Meal Budget'!I80","v":{"$error":"#DIV/0!"}},null,null,null,null,null,{"$f":"+J55+J56","v":{"$error":"#DIV/0!"}},{"$f":"+K55+K56","v":{"$error":"#DIV/0!"}}]
[]
[null,"Total Budgeted Cost",{"$f":"+'Provider Total Budget by Serv'!D278","v":0},{"$f":"+'Provider Total Budget by Serv'!G278","v":0},null,{"$f":"SUM(C59:D59)","v":0}]
[null,"Percentage of Total Budgeted Meal Cost",{"$f":"+C59/F59","v":{"$error":"#DIV/0!"}},{"$f":"+D59/F59","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(C60:D60)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Total Budgeted Meals",{"$f":"+'Provider Total Budget by Serv'!D294","v":0},{"$f":"+C_TotalBudgetedMeals","v":0},null,{"$f":"SUM(C62:D62)","v":0}]
[null,"Percentage of Total Budgeted Meals",{"$f":"+C62/F62","v":{"$error":"#DIV/0!"}},{"$f":"+D62/F62","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(C63:D63)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Whole Unit Rate (Full Cost per Meal)",{"$f":"+C57/C62","v":{"$error":"#DIV/0!"}},{"$f":"+D57/D62","v":{"$error":"#DIV/0!"}}]
[]
[null,"Calculated Rate",{"$f":"+'Home Delivered Meal Budget'!I88","v":0},{"$f":"+'Congregate Meal Budget'!I93","v":0}]
[]
[]
[null,"Example of how to use this information:"]
[null,"Review each of the cost areas based on the three different ways the information is presented. Determine if  the dollar amount is reasonable for each of the cost areas. Is the percentage of the cost allocation between congregate and home delivered comparable to the percentage of total budgeted meals for each program?  \n\nReview examples:  \n\n\u0097  Occupancy/Building cost is expected to be higher for congregate than home delivered because the home delivered program should only be charged a share of the cost for the kitchen and delivery preparation area for the time those areas are used to prepare and disburse meals. The congregate program would be charged a share of the cost for the kitchen area for the time those areas are used to prepare meals and include the cost associated with the area used to consume meals.\n\n\u0097  How are Personnel costs allocated between the two meal programs?  Is the allocation based on the percentage of meals, percentage of total cost, or actual time spent between the two programs?\n\n\u0097 Review the cost per unit of raw food. Is the amount the same for both programs? If not, why are they different?\n\n\u0097 Review  the total cost per unit rates,  are the rates for the programs similar? Because the program requirements are different, small variances are expected. If the variances cannot be explained by program differences, you need to explain in your review papers why they are different.\n"]

{"sheet":"Home Delivered Meal Budget","index":4,"n_rows":104,"n_cols":15,"rows_kept":104,"cut":false,"hidden":false,"merged":[[0,1,0,14],[91,10,91,12],[90,10,90,12],[89,10,89,12],[88,10,88,12],[87,10,87,12],[8,8,11,8],[8,9,11,9],[5,1,6,1],[5,2,6,2],[79,12,79,14],[28,12,34,14],[36,12,40,14],[42,12,51,14],[53,12,61,14],[63,12,77,14],[97,10,97,12],[95,10,95,12],[94,10,94,12],[93,10,93,12],[92,10,92,12],[96,10,96,12],[22,1,22,6],[8,10,11,10],[4,12,4,14],[7,12,7,14],[11,12,11,14],[12,1,12,6],[16,1,16,6],[4,2,4,6],[5,3,6,6],[7,2,7,6],[4,8,4,10],[5,8,6,10],[8,12,8,13],[9,12,9,13],[10,12,10,13],[8,1,11,1],[13,12,15,14],[1,8,3,14],[5,12,6,14],[8,6,11,6],[8,2,11,2],[8,3,11,3],[8,4,11,4],[8,5,11,5],[1,2,1,6],[2,2,2,6],[3,2,3,6],[103,1,103,4],[96,1,96,4],[97,1,97,4],[89,1,89,4],[94,1,94,4],[95,1,95,4],[92,1,92,4],[102,1,102,4],[93,1,93,4],[17,12,21,14],[90,1,90,4],[98,1,98,4],[99,1,99,4],[101,1,101,4],[91,1,91,4],[88,1,88,4],[27,1,27,6],[23,12,26,14],[87,1,87,4],[86,1,86,4],[35,1,35,6],[41,1,41,6],[52,1,52,6],[62,1,62,6],[78,1,78,6]]}
[null,"Home Delivered Meal Budget Worksheet"]
[null,"Provider Name: ",{"$f":"'Provider Information'!$F$6","v":0},null,null,null,null,null,"Review of Most Recent Completed Year Approved Budget to Actual Year End Expense and Current Proposed Budget"]
[null,"AAA Name:",{"$f":"+'Provider Information'!D21","v":0}]
[null,"Region Number:",{"$f":"+'Provider Information'!E26","v":0}]
[null,null,{"$f":"NOW()","v":"2020-07-23T18:20:44.220"},{"$f":"NOW()","v":"2020-07-23T18:20:44.220"},{"$f":"NOW()","v":"2020-07-23T18:20:44.220"},{"$f":"NOW()","v":"2020-07-23T18:20:44.220"},{"$f":"NOW()","v":"2020-07-23T18:20:44.220"},null," "]
[null,"Most Recent Completed Budget Year",2018,null,null,null,null,null," Proposed Budget",null,null,null,"Explanation of Variances"]
[]
[]
[null,"Cost Area"," Expense per General Ledger","Approved Budget ","Variance\nBudget\nminus\nExpenses","Percentage of Variance","Percentage of Unit Cost",null,"Proposed Budget ","Percentage Variance - Prior Year Actual to Proposed Budget","Percentage of Unit Cost",null,"Inflation Factor 2018 to 2019",null,1.022E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,"Inflation Factor 2019 to 2020",null,1.0211E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,"Combined Inflation Factor",null,{"$f":"SUM(O9:O10)","v":2.0430999999999998E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,"1. An explanation of variance must be provided for each cost area where the expenses per General Ledger varies from the approved budget for the most recent completed year  by 10% or more; and\n 2. An explanation of variance must be provided for each cost area where the proposed budget amount exceeds the prior year actual amount by more than the two year combined inflation factor."]
[null,"Personnel"]
[null,"Salaries, PR Taxes & Benefits",null,null,{"$f":"+D14-C14","v":0},{"$f":"IF(+C14+D14=0,0,(IF(AND(+C14=0,D14>0),1,(IF(AND(+C14>0,D14=0),-1,+C14/+D14-1)))))","v":0},null,null,{"$f":"+'Provider Total Budget by Serv'!D17+'Provider Total Budget by Serv'!D29","v":0},{"$f":"IF(I14+C14=0,0,(IF(AND(I14=0,C14>0),-1,(IF(AND(I14>0,C14=0),1,+I14/C14-1)))))","v":0}]
[null,"Contract staff, Compensation",null,null,{"$f":"+D15-C15","v":0},{"$f":"IF(+C15+D15=0,0,(IF(AND(+C15=0,D15>0),1,(IF(AND(+C15>0,D15=0),-1,+C15/+D15-1)))))","v":0},null,null,{"$f":"+'Provider Total Budget by Serv'!D36","v":0},{"$f":"IF(I15+C15=0,0,(IF(AND(I15=0,C15>0),-1,(IF(AND(I15>0,C15=0),1,+I15/C15-1)))))","v":0}]
[null,"Total",{"$f":"SUM(C14:C15)","v":0},{"$f":"SUM(D14:D15)","v":0},{"$f":"+D16-C16","v":0},0,{"$f":"IF(AND(C16>0,C$80>0),+C16/C$80,0)","v":0},null,{"$f":"SUM(I14:I15)","v":0},{"$f":"IF(I16+C16=0,0,(IF(AND(I16=0,C16>0),-1,(IF(AND(I16>0,C16=0),1,+I16/C16-1)))))","v":0},{"$f":"IF(AND(I16>0,I$80>0),+I16/I$80,0)","v":{"$error":"#DIV/0!"}}]
[null,"Nutrition Education"]
[null,"Salaries, PR Taxes & Benefits",null,null,{"$f":"+D18-C18","v":0},{"$f":"IF(+C18+D18=0,0,(IF(AND(+C18=0,D18>0),1,(IF(AND(+C18>0,D18=0),-1,+C18/+D18-1)))))","v":0},null,null,{"$f":"IF('Provider Total Budget by Serv'!E300=\"N\",+'Provider Total Budget by Serv'!F17+'Provider Total Budget by Serv'!F29,((+'Provider Total Budget by Serv'!E17+'Provider Total Budget by Serv'!E29)*'Provider Total Budget by Serv'!D303)+'Provider Total Budget by Serv'!F17+'Provider Total Budget by Serv'!F29)","v":{"$error":"#DIV/0!"}},{"$f":"IF(I18+C18=0,0,(IF(AND(I18=0,C18>0),-1,(IF(AND(I18>0,C18=0),1,+I18/C18-1)))))","v":{"$error":"#DIV/0!"}}]
[null,"Contract staff, Compensation",null,null,{"$f":"+D19-C19","v":0},0,null,null,{"$f":"IF('Provider Total Budget by Serv'!E300=\"N\",+'Provider Total Budget by Serv'!F36,(+'Provider Total Budget by Serv'!E36*'Provider Total Budget by Serv'!D303)+'Provider Total Budget by Serv'!F36)","v":{"$error":"#DIV/0!"}},{"$f":"IF(I19+C19=0,0,(IF(AND(I19=0,C19>0),-1,(IF(AND(I19>0,C19=0),1,+I19/C19-1)))))","v":{"$error":"#DIV/0!"}}]
[null,"Materials",null,null,{"$f":"+D20-C20","v":0},0,null,null,{"$f":"IF('Provider Total Budget by Serv'!E300=\"N\",+'Provider Total Budget by Serv'!F53,(+'Provider Total Budget by Serv'!E53*'Provider Total Budget by Serv'!D303)+'Provider Total Budget by Serv'!F53)","v":{"$error":"#DIV/0!"}},{"$f":"IF(I20+C20=0,0,(IF(AND(I20=0,C20>0),-1,(IF(AND(I20>0,C20=0),1,+I20/C20-1)))))","v":{"$error":"#DIV/0!"}}]
[null,"Conference",null,null,{"$f":"+D21-C21","v":0},0,null,null,{"$f":"IF('Provider Total Budget by Serv'!E300=\"N\",+'Provider Total Budget by Serv'!F43,(+'Provider Total Budget by Serv'!E43*'Provider Total Budget by Serv'!D303)+'Provider Total Budget by Serv'!F43)","v":{"$error":"#DIV/0!"}},{"$f":"IF(I21+C21=0,0,(IF(AND(I21=0,C21>0),-1,(IF(AND(I21>0,C21=0),1,+I21/C21-1)))))","v":{"$error":"#DIV/0!"}}]
[null,"Total",{"$f":"SUM(C18:C21)","v":0},{"$f":"SUM(D18:D21)","v":0},{"$f":"+D22-C22","v":0},0,{"$f":"IF(AND(C22>0,C$80>0),+C22/C$80,0)","v":0},null,{"$f":"SUM(I18:I21)","v":{"$error":"#DIV/0!"}},{"$f":"IF(I22+C22=0,0,(IF(AND(I22=0,C22>0),-1,(IF(AND(I22>0,C22=0),1,+I22/C22-1)))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(I22>0,I$80>0),+I22/I$80,0)","v":{"$error":"#DIV/0!"}}]
[null,"Professional Development"]
[null,"Conference",null,null,{"$f":"+D24-C24","v":0},{"$f":"IF(+C24+D24=0,0,(IF(AND(+C24=0,D24>0),1,(IF(AND(+C24>0,D24=0),-1,+C24/+D24-1)))))","v":0},null,null,{"$f":"+'Provider Total Budget by Serv'!D43","v":0},{"$f":"IF(I24+C24=0,0,(IF(AND(I24=0,C24>0),-1,(IF(AND(I24>0,C24=0),1,+I24/C24-1)))))","v":0}]
[null,"Dues",null,null,{"$f":"+D25-C25","v":0},0,null,null,{"$f":"+'Provider Total Budget by Serv'!D48","v":0},{"$f":"IF(I25+C25=0,0,(IF(AND(I25=0,C25>0),-1,(IF(AND(I25>0,C25=0),1,+I25/C25-1)))))","v":0}]
[null,"Materials",null,null,{"$f":"+D26-C26","v":0},0,null,null,{"$f":"+'Provider Total Budget by Serv'!D53","v":0},{"$f":"IF(I26+C26=0,0,(IF(AND(I26=0,C26>0),-1,(IF(AND(I26>0,C26=0),1,+I26/C26-1)))))","v":0}]
[null,"Total",{"$f":"SUM(C24:C26)","v":0},{"$f":"SUM(D24:D26)","v":0},{"$f":"+D27-C27","v":0},0,{"$f":"IF(AND(C27>0,C$80>0),+C27/C$80,0)","v":0},null,{"$f":"SUM(I24:I26)","v":0},{"$f":"IF(I27+C27=0,0,(IF(AND(I27=0,C27>0),-1,(IF(AND(I27>0,C27=0),1,+I27/C27-1)))))","v":0},{"$f":"IF(AND(I27>0,I$80>0),+I27/I$80,0)","v":{"$error":"#DIV/0!"}}]
[null,"Meals/Food"]
[null,"Raw Food",null,null,{"$f":"+D29-C29","v":0},{"$f":"IF(+C29+D29=0,0,(IF(AND(+C29=0,D29>0),1,(IF(AND(+C29>0,D29=0),-1,+C29/+D29-1)))))","v":0},null,null,{"$f":"+'Provider Total Budget by Serv'!D61","v":0},{"$f":"IF(I29+C29=0,0,(IF(AND(I29=0,C29>0),-1,(IF(AND(I29>0,C29=0),1,+I29/C29-1)))))","v":0}]
[null,"Purchased Meals",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!D68","v":0},0]
[null,"Freight",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!D73","v":0},0]
[null,"Storage",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!D78","v":0},0]
[null,"Consumables",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!D87","v":0},0]
[null,"Other",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!D92","v":0},0]
[null,"Total",{"$f":"SUM(C29:C34)","v":0},{"$f":"SUM(D29:D34)","v":0},0,0,{"$f":"IF(AND(C35>0,C$80>0),+C35/C$80,0)","v":0},null,{"$f":"SUM(I29:I34)","v":0},0,{"$f":"IF(AND(I35>0,I$80>0),+I35/I$80,0)","v":{"$error":"#DIV/0!"}}]
[null,"Equipment"]
[null,"Depreciation",null,null,{"$f":"+D37-C37","v":0},{"$f":"IF(+C37+D37=0,0,(IF(AND(+C37=0,D37>0),1,(IF(AND(+C37>0,D37=0),-1,+C37/+D37-1)))))","v":0},null,null,{"$f":"+'Provider Total Budget by Serv'!D99","v":0},{"$f":"IF(I37+C37=0,0,(IF(AND(I37=0,C37>0),-1,(IF(AND(I37>0,C37=0),1,+I37/C37-1)))))","v":0}]
[null,"Interest",null,null,{"$f":"+D38-C38","v":0},0,null,null,{"$f":"+'Provider Total Budget by Serv'!D104","v":0},{"$f":"IF(I38+C38=0,0,(IF(AND(I38=0,C38>0),-1,(IF(AND(I38>0,C38=0),1,+I38/C38-1)))))","v":0}]
[null,"Leasing",null,null,{"$f":"+D39-C39","v":0},0,null,null,{"$f":"+'Provider Total Budget by Serv'!D109","v":0},{"$f":"IF(I39+C39=0,0,(IF(AND(I39=0,C39>0),-1,(IF(AND(I39>0,C39=0),1,+I39/C39-1)))))","v":0}]
[null,"Maintenance",null,null,{"$f":"+D40-C40","v":0},0,null,null,{"$f":"+'Provider Total Budget by Serv'!D114","v":0},{"$f":"IF(I40+C40=0,0,(IF(AND(I40=0,C40>0),-1,(IF(AND(I40>0,C40=0),1,+I40/C40-1)))))","v":0}]
[null,"Total",{"$f":"SUM(C37:C40)","v":0},{"$f":"SUM(D37:D40)","v":0},{"$f":"+D41-C41","v":0},0,{"$f":"IF(AND(C41>0,C$80>0),+C41/C$80,0)","v":0},null,{"$f":"SUM(I37:I40)","v":0},{"$f":"IF(I41+C41=0,0,(IF(AND(I41=0,C41>0),-1,(IF(AND(I41>0,C41=0),1,+I41/C41-1)))))","v":0},{"$f":"IF(AND(I41>0,I$80>0),+I41/I$80,0)","v":{"$error":"#DIV/0!"}}]
[null,"Occupancy/Building"]
[null,"Rent",null,null,{"$f":"+D43-C43","v":0},{"$f":"IF(+C43+D43=0,0,(IF(AND(+C43=0,D43>0),1,(IF(AND(+C43>0,D43=0),-1,+C43/+D43-1)))))","v":0},null,null,{"$f":"+'Provider Total Budget by Serv'!D121","v":0},{"$f":"IF(I43+C43=0,0,(IF(AND(I43=0,C43>0),-1,(IF(AND(I43>0,C43=0),1,+I43/C43-1)))))","v":0}]
[null,"Utilities",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!D126","v":0},0]
[null,"Depreciation",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!D131","v":0},0]
[null,"Mortgage Interest",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!D136","v":0},0]
[null,"Insurance",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!D141","v":0},0]
[null,"Security",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!D146","v":0},0]
[null,"Janitorial",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!D151","v":0},0]
[null,"Repair",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!D156","v":0},0]
[null,"Taxes",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!D161","v":0},0]
[null,"Total",{"$f":"SUM(C43:C51)","v":0},{"$f":"SUM(D43:D51)","v":0},0,0,{"$f":"IF(AND(C52>0,C$80>0),+C52/C$80,0)","v":0},null,{"$f":"SUM(I43:I51)","v":0},0,{"$f":"IF(AND(I52>0,I$80>0),+I52/I$80,0)","v":{"$error":"#DIV/0!"}}]
[null,"Transportation/Travel"]
[null,"Mileage Reimbursement",null,null,{"$f":"+D54-C54","v":0},{"$f":"IF(+C54+D54=0,0,(IF(AND(+C54=0,D54>0),1,(IF(AND(+C54>0,D54=0),-1,+C54/+D54-1)))))","v":0},null,null,{"$f":"+'Provider Total Budget by Serv'!D168","v":0},{"$f":"IF(I54+C54=0,0,(IF(AND(I54=0,C54>0),-1,(IF(AND(I54>0,C54=0),1,+I54/C54-1)))))","v":0}]
[null,"Delivery",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!D173","v":0},0]
[null,"Gas & Oil",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!D178","v":0},0]
[null,"Repairs",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!D183","v":0},0]
[null,"Insurance",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!D188","v":0},0]
[null,"Depreciation/Lease",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!D193","v":0},0]
[null,"Interest",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!D198","v":0},0]
[null,"Tags & Licenses",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!D203","v":0},0]
[null,"Total",{"$f":"SUM(C54:C61)","v":0},{"$f":"SUM(D54:D61)","v":0},0,0,{"$f":"IF(AND(C62>0,C$80>0),+C62/C$80,0)","v":0},null,{"$f":"SUM(I54:I61)","v":0},0,{"$f":"IF(AND(I62>0,I$80>0),+I62/I$80,0)","v":{"$error":"#DIV/0!"}}]
[null,"Administrative & General"]
[null,"Advertising",null,null,{"$f":"+D64-C64","v":0},{"$f":"IF(+C64+D64=0,0,(IF(AND(+C64=0,D64>0),1,(IF(AND(+C64>0,D64=0),-1,+C64/+D64-1)))))","v":0},null,null,{"$f":"+'Provider Total Budget by Serv'!D210","v":0},{"$f":"IF(I64+C64=0,0,(IF(AND(I64=0,C64>0),-1,(IF(AND(I64>0,C64=0),1,+I64/C64-1)))))","v":0}]
[null,"Printing",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!D215","v":0},0]
[null,"Copying",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!D220","v":0},0]
[null,"Office Supplies",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!D225","v":0},0]
[null,"Contractual Agreements",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!D230","v":0},0]
[null,"Postage",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!D235","v":0},0]
[null,"Telecommunications",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!D240","v":0},0]
[null,"Liability Insurance",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!D245","v":0},0]
[null,"Legal Fees",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!D250","v":0},0]
[null,"Accounting Fees",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!D255","v":0},0]
[null,"Consulting Fees",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!D260","v":0},0]
[null,"Other Fees (Explain)",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!D265","v":0},0]
[null,"Audit",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!D270","v":0},0]
[null,"Other Misc. (Explain)",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!D275","v":0},0]
[null,"Total",{"$f":"SUM(C64:C77)","v":0},{"$f":"SUM(D64:D77)","v":0},0,0,{"$f":"IF(AND(C78>0,C$80>0),+C78/C$80,0)","v":0},null,{"$f":"SUM(I64:I77)","v":0},0,{"$f":"IF(AND(I78>0,I$80>0),+I78/I$80,0)","v":{"$error":"#DIV/0!"}}]
[null,"Total"]
[null,"Total of all Cost Areas",{"$f":"+C16+C22+C27+C35+C41+C52+C62+C78","v":0},{"$f":"+D16+D22+D27+D35+D41+D52+D62+D78","v":0},{"$f":"+D80-C80","v":0},{"$f":"IF(+C80+D80=0,0,(IF(AND(+C80=0,D80>0),1,(IF(AND(+C80>0,D80=0),-1,+C80/+D80-1)))))","v":0},{"$f":"IF(AND(C80>0,C$80>0),+C80/C$80,0)","v":0},null,{"$f":"+I16+I22+I27+I35+I41+I52+I62+I78","v":{"$error":"#DIV/0!"}},{"$f":"IF(I80+C80=0,0,(IF(AND(I80=0,C80>0),-1,(IF(AND(I80>0,C80=0),1,+I80/C80-1)))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(I80>0,I$80>0),+I80/I$80,0)","v":{"$error":"#DIV/0!"}}]
[null,"Total Number of Meals ",null,null,null,null,null,null," "]
[null,"Whole Cost per Meal",{"$f":"IF(C81=0,0,+C80/C81)","v":0},{"$f":"IF(D81=0,0,+D80/D81)","v":0}]
[null,"Approved Meal Rate (Title III & Title XX)",{"$f":"+D83","v":0}]
[null,"Approved Meal Rate (Title XIX)",{"$f":"+D84","v":0}]
[]
[]
[null,"Funding Source",null,null,null,"Proposed Meals",null,null,"Calculated Rate","Revenue"]
[null,"HHS - OAAA",null,null,null,null,null,null,{"$f":"IF(F89+F90+F91=0,'Unit Rate Calculation HDM'!F29,'Unit Rate Calculation HDM'!F34)","v":0},{"$f":"+F88*I88","v":0},"Proposed Meals * Calculated Units"]
[null,"HHS  - Title XX",null,null,null,null,null,null,{"$f":"+'Unit Rate Calculation HDM'!F34","v":0},{"$f":"+F89*I89","v":0},"Proposed Meals * Calculated Units"]
[null,"DADS  - Title XIX (CBA)",null,null,null,null,null,null,{"$f":"IF(F90>0,+'Unit Rate Calculation HDM'!H34,0)","v":0},{"$f":"+F90*I90","v":0},"Proposed Meals * Calculated Units"]
[null,"DADS  - Title XIX ",null,null,null,null,null,null,null,null,"Proposed Meals * Calculated Units"]
[null,"Program Income",null,null,null,null,null,null,{"$f":"+'Unit Rate Calculation HDM'!K18","v":0},{"$f":"+F92*I92","v":0},"Proposed Meals * Calculated Units"]
[null,"Other Funds - Eligible Meals",null,null,null,null,null,null,{"$f":"+'Unit Rate Calculation HDM'!K18","v":0},{"$f":"+F93*I93","v":0},"Proposed Meals * Calculated Units"]
[null,"Other Funds - Non-Eligible Meals",null,null,null,null,null,null,{"$f":"+'Unit Rate Calculation HDM'!K18","v":0},{"$f":"+F94*I94","v":0},"Proposed Meals * Calculated Units"]
[null,"Local Funds - Required Match",null,null,null,"NA",null,null,{"$f":"+'Unit Rate Calculation HDM'!F28","v":0},{"$f":"(+F88+F89)*I95","v":0},"HHS OAAA Proposed Meals +Title XX Proposed Meals *Calculated Rate"]
[null,"Local Funds - Cap Limit Exceeded HHS OAAA & Title XX",null,null,null,"NA",null,null,{"$f":"-'Unit Rate Calculation HDM'!F32","v":0},{"$f":"IF(F89=0,0,(+F88+F89)*I96)","v":0},"HHS OAAA Proposed Meals +Title XX Proposed Meals *Calculated Rate"]
[null,"Local Funds - Cap Limit Exceeded Title XIX ",null,null,null,"NA",null,null,{"$f":"-'Unit Rate Calculation HDM'!H32","v":0},{"$f":"+F90*I97","v":0},"HHS Title XIX Proposed Meals *Calculated Rate"]
[null,"Total Meals by Funding Source",null,null,null,{"$f":"SUM(F88:F94)","v":0},null,null,null,{"$f":"SUM(J88:J97)","v":0}]
[null,"Provider Total Budgeted Home Delivered Meals",null,null,null,{"$f":"+'Provider Total Budget by Serv'!D294","v":0}]
[null,"Variance (Provider Total Budgeted Home Delivered Meals - Total Meals by Funding Source) ",null,null,null,{"$f":"+F99-F98","v":0}]
[]
[null,"Estimated Number of Nutrition Education Units AAA Clients"]
[null,"Nutrition Education Budget - AAA Clients",null,null,null,{"$f":"+'Provider Total Budget by Serv'!E278*'Provider Total Budget by Serv'!D303","v":{"$error":"#DIV/0!"}}]
[null,"Calculated Cost per Unit",null,null,null,{"$f":"IF(F102>0,+F103/F102,0)","v":0}]

{"sheet":"Unit Rate Calculation HDM","index":5,"n_rows":112,"n_cols":11,"rows_kept":112,"cut":false,"hidden":false,"merged":[[1,3,1,7],[45,2,45,4],[44,6,44,8],[50,6,50,8],[48,2,48,4],[48,6,48,8],[49,2,49,4],[49,6,49,8],[45,6,45,8],[21,1,21,4],[22,1,22,10],[24,1,24,10],[23,1,23,4],[27,1,27,4],[23,8,23,10],[21,8,21,10],[101,2,101,8],[57,2,57,4],[57,6,57,8],[61,2,61,4],[61,6,61,8],[60,2,60,4],[60,6,60,8],[53,2,53,4],[53,6,53,8],[28,1,28,4],[31,1,31,4],[31,8,31,10],[28,8,28,10],[29,1,29,4],[33,8,33,10],[34,8,34,10],[33,1,33,4],[52,6,52,8],[52,2,52,4],[41,2,41,4],[40,2,40,4],[40,6,40,8],[41,6,41,8],[26,1,26,3],[18,1,18,10],[19,1,19,10],[12,1,12,10],[14,1,14,10],[13,1,13,2],[17,1,17,8],[15,1,15,10],[16,1,16,10],[11,1,11,2],[11,8,11,10],[2,3,2,8],[3,3,3,7],[5,1,5,10],[3,9,3,10],[8,1,8,10],[9,1,9,10],[10,1,10,10],[4,1,4,10],[6,1,6,10],[7,1,7,8]]}
[null,null,{"$f":"NOW()","v":"2020-07-23T18:20:44.220"}]
[null,null,"Provider Name: ",{"$f":"+'Provider Information'!F6","v":0}]
[null,null,"AAA Name:",{"$f":"+'Provider Information'!D21","v":0}]
[null,null,"Region Number:",{"$f":"+'Provider Information'!E26","v":0}]
[null,"Home Delivered Meals"]
[null,"BUDGET WORKSHEET CALCULATION OF THE PER MEAL UNIT RATE"]
[]
[null,"1.  Total Budgeted Expenses for Contract Year ",null,null,null,null,null,null,null,"1.",{"$f":"+'Home Delivered Meal Budget'!I80","v":{"$error":"#DIV/0!"}}]
[]
[null,"2.  Total Number of Anticipated Meals to be Provided  by Funding Source"]
[]
[null,"HHS OAAA",null,{"$f":"+'Home Delivered Meal Budget'!F88","v":0},"Title XX",{"$f":"+'Home Delivered Meal Budget'!F89","v":0},"Title XIX",{"$f":"+'Home Delivered Meal Budget'!F90+'Home Delivered Meal Budget'!F91","v":0}]
[]
[null,"Program Income",null,{"$f":"+'Home Delivered Meal Budget'!F92","v":0},"Other Funds Eligible Meals",{"$f":"+'Home Delivered Meal Budget'!F93","v":0},"Other Funds - \nNon-Eligible Meals",{"$f":"+'Home Delivered Meal Budget'!F94","v":0},null,"2.",{"$f":"IF('Home Delivered Meal Budget'!F98>0,+D12+F12+H12+D14+F14+H14,0)","v":0}]
[]
[]
[]
[null,"3.  Whole Unit Rate (Line 1 divided by Line 2)",null,null,null,null,null,null,null,"3.",{"$f":"ROUND(IF(K14=0,0,+K8/K14),2)","v":0}]
[]
[null,"Reimbursement Calculation"]
[null,null,null,null,null,"HHS OAAA & Title XX",null,"Title XIX"]
[null,"4.  Projected NSIP per Meal Value",null,null,null,0.73,null,"N/A"]
[]
[null,"5.  Rate Less NSIP per Meal Value",null,null,null,{"$f":"ROUND(IF(K18=0,0,+K18-F22),2)","v":0},null,"N/A"]
[]
[null,"6.  Mandatory Local Match of 10%",null,null,{"$f":"ROUND(IF(F24=\"\",\"\",+F24*0.1),2)","v":0}]
[null,"  **  If Applicable, Match Reduction \n       From the In-kind Match \n       Certification form",null,null,{"$f":"-I111","v":0}]
[null,"      Required Cash Match",null,null,null,{"$f":"IF(+E26=\"\",0,+E26+E27)","v":0},null,"N/A"]
[null,"7.  Proposed Meal Rate (Line 3 minus Line 6)",null,null,null,{"$f":"ROUND(IF(K18>0,K18-F28,0),2)","v":0},null,{"$f":"ROUND(IF(K18>0,K18,0),2)","v":0}]
[null,"8.  Rate Cap Applicable to Title XIX, Title XX \n     and HHS OAAA Common Providers ",null,null,null,4.95,null,6.12]
[]
[null,"9.   Excess of Cap Rate Reduction ",null,null,null,{"$f":"ROUND(IF(+F29>0,(IF(F29>F30,F30-F29,0)),0),2)","v":0},null,{"$f":"ROUND(IF(+H29>0,(IF(H29>H30,H30-H29,0)),0),2)","v":0}]
[]
[null,"Accepted Unit Rate for Current Year ",null,null,null,{"$f":"IF(C112=0,F29,(IF(F30>F29,F29,F30)))","v":0},null,{"$f":"IF(C112=0,\"NA\",(IF(H30>H29,H29,H30)))","v":"NA"}]
[]
[]
[null,"**  If any portion of the required match is in-kind, you must complete an In-Kind Match Certification form. "]
[null,null,"By signing below, the provider acknowledges that all related records are subject to audit in accordance with contract "]
[null,null,"requirements and all applicable federal and state laws."]
[]
[null,null,{"$f":"'Provider Information'!$F$6","v":0}]
[null,null,"Legal Name of Contracted Provider",null,null,null,"Printed/Typed Name of Signer"]
[]
[]
[]
[null,null,"Signature",null,null,null,"Date"]
[]
[]
[null,null,{"$f":"'Provider Information'!$D$21","v":0},null,null,null,{"$f":"'Provider Information'!$E$26","v":0}]
[null,null,"Name of Area Agency on Aging",null,null,null,"Health and Human Services"]
[]
[]
[null,null,{"$f":"'Provider Information'!$D$22","v":0},null,null,null,{"$f":"'Provider Information'!$F$25","v":0}]
[null,null,"Printed/Typed Name of Signer",null,null,null,"Printed/Typed Name of Signer"]
[]
[]
[]
[null,null,"Signature",null,null,null,"Signature"]
[]
[]
[]
[null,null,"Date",null,null,null,"Date"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Calculation of In-Kind Value"]
[null,null,"1. Required Match Rate",null,null,null,null,null,{"$f":"+E26","v":0}]
[null,null,"2. TDoA units + DHS units",null,null,null,null,null,{"$f":"IF(D12+F12=0,K14,+D12+F12)","v":0}]
[null,null,"3. Required Match Rate (1) Multiplied by the anticipated number of TDoA units (2)",null,null,null,null,null,{"$f":"+I103*I104","v":0}]
[null,null,"4. Total Valuation from the In-Kind Certification",null,null,null,null,null,{"$f":"+'In-Kind Certification HDM'!G26","v":0}]
[null,null,"5. Balance of Required Match (3-4)",null,null,null,null,null,{"$f":"+I105-I106","v":0}]
[null,null,"6. TDoA units + DHS units",null,null,null,null,null,{"$f":"IF(+D12+F12=0,K14,+D12+F12)","v":0}]
[null,null,"7. Balance of Required Match (5) Divided by TDoA units (6)",null,null,null,null,null,{"$f":"IF(I107=0,0,+I107/I108)","v":0}]
[null,null,"8. Required Match Rate",null,null,null,null,null,{"$f":"+E26","v":0}]
[null,null,"9. Reduced Required Match If (8) is equal to or less than 0 this will equal (8) or else (8-7)",null,null,null,null,null,{"$f":"IF(+I109<=0,+I110,+I110-I109)","v":0}]
[null,null,{"$f":"+'Home Delivered Meal Budget'!F89+'Home Delivered Meal Budget'!F90+'Home Delivered Meal Budget'!F91","v":0}]

{"sheet":"Certification HDM","index":6,"n_rows":48,"n_cols":7,"rows_kept":48,"cut":false,"hidden":false,"merged":[[1,3,1,7],[41,2,41,4],[41,6,41,9],[36,2,36,4],[36,6,36,9],[4,1,4,10],[39,2,40,4],[39,6,40,9],[6,1,6,4],[6,6,6,10],[5,1,5,10],[37,2,37,4],[37,6,37,9],[2,3,2,8],[3,3,3,7]]}
[null,null,{"$f":"NOW()","v":"2020-07-23T18:20:44.220"}]
[null,null,"Provider Name: ",{"$f":"+'Provider Information'!F6","v":0}]
[null,null,"AAA Name:",{"$f":"+'Provider Information'!D21","v":0}]
[null,null,"Region Number:",{"$f":"+'Provider Information'!E26","v":0}]
[null,"Home Delivered Meals"]
[null,"BUDGET WORKSHEET CERTIFICATION"]
[]
[null,"        AS SIGNER OF THIS BUDGET WORKSHEET, I HEREBY CERTIFY THAT:"]
[]
[null,"·","I have read the note below and the instructions applicable to this budget worksheet."]
[]
[null,"·","I have reviewed this budget worksheet after its preparation."]
[]
[null,"·","To the best of my knowledge and belief, this budget worksheet is true, correct and"]
[null," ","complete, and was prepared in accordance with the instructions applicable to this"]
[null," ","budget worksheet."]
[]
[null,"·","This budget worksheet was prepared from the books and records of the contracted"]
[null," ","provider."]
[]
[null,"·","I acknowledge that all books and records related to this rate setting process are"]
[null," ","subject to audit in accordance with contract requirements and all applicable federal "]
[null,null,"and state laws."]
[]
[]
[]
[]
[]
[null,"    Note: ","The person legally responsible for the conduct of the contracted provider must"]
[null,null,"sign this Budget Worksheet Certification.  If a sole proprietor, the owner"]
[null,null,"must sign the Budget Worksheet Certification.  If a partnership, a partner must "]
[null,null,"sign the Budget Worksheet Certification.  If a corporation, the person authorized by the "]
[null,null,"Board of Directors Resolution must sign the Budget Worksheet Certification.  "]
[null,null,"Misrepresentation of information contained in the budget worksheet may result in "]
[null,null,"adverse action, up to and including contract termination.  Furthermore, falsification of "]
[null,null,"information in the budget worksheet may result in a referral for prosecution."]
[null,null,{"$f":"'Provider Information'!$F$6","v":0}]
[null,null,"Name of Contracted Provider",null,null,null,"Printed/Typed Name of Signer"]
[]
[]
[]
[null,null,"Date",null,null,null,"Signature"]
[]
[]
[]
[null,null,"Signer Authority:",null,"Sole Proprietor",null,"Association Officer"]
[null,null,"    (check one)",null,"Partner",null,"Board Member"]
[null,null,null,null,"Corporate Officer",null,"Governmental Official           "]

{"sheet":"In-Kind Certification HDM","index":7,"n_rows":49,"n_cols":7,"rows_kept":49,"cut":false,"hidden":false,"merged":[[44,5,44,6],[44,1,44,3],[50,1,50,7],[48,1,48,3],[48,5,48,6],[45,1,45,3],[45,5,45,6],[47,1,47,3],[7,1,7,2],[34,9,34,13],[35,3,35,6],[22,1,22,4],[23,1,23,4],[24,1,24,4],[25,1,25,4],[27,2,27,5],[32,3,32,6],[18,1,18,4],[19,1,19,4],[0,1,0,2],[1,3,1,6],[2,3,2,6],[7,3,7,4],[21,1,21,4],[14,1,14,4],[15,1,15,4],[16,1,16,4],[17,1,17,4],[9,1,9,6],[12,1,12,4],[13,1,13,4],[20,1,20,4],[3,1,3,6],[4,0,4,7],[5,2,5,4]]}
[null,{"$f":"NOW()","v":"2020-07-23T18:20:44.220"},{"$f":"NOW()","v":"2020-07-23T18:20:44.220"}]
[null,null,"AAA Name:",{"$f":"+'Provider Information'!D21","v":0}]
[null,null,"Region Number:",{"$f":"+'Provider Information'!E26","v":0}]
[null,"Home Delivered Meals"]
["IN-KIND MATCH CERTIFICATION"]
[null,"Provider: ",{"$f":"IF(ISBLANK('Provider Information'!F6),\"\",+'Provider Information'!F6)","v":""}]
[]
[null,"In-kind Contribution(s):",null,{"$f":"+G26","v":0}]
[]
[null,"For any item identified below, the provider must maintain monthly supporting documentation."]
[]
[]
[null,"ITEM",null,null,null,"DATE OF RECEIPT","VALUE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"TOTAL",{"$f":"SUM(G14:G25)","v":0}]
[]
[null,"Note:","All contributions must meet the requirements of IRS Publication 561  \nhttp://www.irs.gov/pub/irs-pdf/p561.pdf"]
[]
[null,"Examples of Documentation Include:"]
[]
[null,"Rent:","1.","Letter of Agreement with Owner"]
[null,null,"2.","Adequate Valuation of Property on a Current Basis (this should be reviewed at least every two years and if senior center, based on property value and center participation)"]
[]
[null,"Labor:","1.","Minimum wage"]
[null,null,"2.","Documented prevailing wage in the Area. For prevailing wage information visit the Texas Workforce Commission’s website at  http://www.tracer2.com/."]
[]
[]
[null,"All in-kind labor must be required for the service to be provided.  If you would not hire someone to perform the labor if it "]
[null,"were not in-kind then you cannot count it."]
[]
[null,"Utilities: ","1.","Copy of Bill"]
[null,null,"2.","Agreement of Amount Paid if Partial"]
[]
[null,{"$f":"IF(ISBLANK('Provider Total Budget by Serv'!C2),\"\",'Provider Total Budget by Serv'!C2)","v":""}]
[null,"        Name of Contracted Provider",null,null,null,"Printed/Typed Name of Signer"]
[]
[]
[null,"Date",null,null,null,"Signature"]

{"sheet":"Congregate Meal Budget","index":8,"n_rows":106,"n_cols":15,"rows_kept":106,"cut":false,"hidden":false,"merged":[[0,1,0,14],[92,1,92,5],[96,1,96,5],[91,8,91,9],[92,8,92,9],[95,11,95,14],[95,1,95,5],[94,11,94,14],[94,8,94,9],[95,8,95,9],[53,12,61,14],[63,12,77,14],[79,12,79,14],[28,12,34,14],[93,8,93,9],[92,11,92,14],[97,11,97,14],[96,11,96,14],[96,8,96,9],[97,8,97,9],[93,11,93,14],[94,1,94,5],[93,1,93,5],[5,1,6,1],[5,2,6,2],[5,3,6,6],[91,1,91,5],[52,1,52,6],[8,1,11,1],[62,1,62,6],[78,1,78,6],[27,1,27,6],[35,1,35,6],[41,1,41,6],[8,2,11,2],[8,3,11,3],[99,11,99,14],[98,8,98,9],[98,11,98,14],[103,1,103,5],[98,1,98,5],[100,1,100,5],[99,1,99,5],[104,1,104,5],[105,1,105,5],[101,1,101,5],[99,8,99,9],[97,1,97,5],[42,12,51,14],[12,1,12,6],[13,12,15,14],[16,1,16,6],[17,12,21,14],[22,1,22,6],[23,12,26,14],[36,12,40,14],[8,8,11,8],[1,8,3,14],[4,8,4,10],[4,12,4,14],[5,8,6,10],[5,12,6,14],[8,9,11,9],[8,10,11,10],[10,12,10,13],[11,12,11,14],[8,12,8,13],[9,12,9,13],[7,12,7,14],[1,2,1,6],[2,2,2,6],[3,2,3,6],[4,2,4,6],[8,5,11,5],[8,6,11,6],[7,2,7,6],[8,4,11,4]]}
[null,"Congregate Meal Budget Worksheet"]
[null,"Provider Name: ",{"$f":"'Provider Information'!$F$6","v":0},null,null,null,null,null,"Review of Most Recent Completed Year Approved Budget to Actual Year End Expense and Current Proposed Budget"]
[null,"AAA Name:",{"$f":"+'Provider Information'!D21","v":0}]
[]
[null,null,{"$f":"NOW()","v":"2020-07-23T18:20:44.220"},null,null,null,null,null," "]
[null,"Most Recent Completed Budget Year",2018,null,null,null,null,null," Proposed Budget",null,null,null,"Explanation of Variances"]
[]
[]
[null,"Cost Area"," Expense per General Ledger","Approved Budget ","Variance\nBudget\nminus\nExpenses","Percentage of Variance","Percentage of Unit Cost",null,"Proposed Budget ","Percentage Variance - Prior Year Actual to Proposed Budget","Percentage of Unit Cost",null,"Inflation Factor 2018 to 2019",null,1.022E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,"Inflation Factor 2019 to 2020",null,1.0211E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,"Combined Inflation Factor",null,{"$f":"SUM(O9:O10)","v":2.0430999999999998E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,"1. An explanation of variance must be provided for each cost area where the expenses per General Ledger varies from the approved budget for the most recent completed year  by 10% or more; and\n 2. An explanation of variance must be provided for each cost area where the proposed budget amount exceeds the prior year actual amount by more than the two year combined inflation factor."]
[null,"Personnel"]
[null,"Salaries, PR Taxes & Benefits",null,null,{"$f":"+D14-C14","v":0},{"$f":"IF(+C14+D14=0,0,(IF(AND(+C14=0,D14>0),1,(IF(AND(+C14>0,D14=0),-1,+C14/+D14-1)))))","v":0},null,null,{"$f":"+'Provider Total Budget by Serv'!G17+'Provider Total Budget by Serv'!G29","v":0},{"$f":"IF(I14+C14=0,0,(IF(AND(I14=0,C14>0),-1,(IF(AND(I14>0,C14=0),1,+I14/C14-1)))))","v":0}]
[null,"Contract staff, Compensation",null,null,{"$f":"+D15-C15","v":0},{"$f":"IF(+C15+D15=0,0,(IF(AND(+C15=0,D15>0),1,(IF(AND(+C15>0,D15=0),-1,+C15/+D15-1)))))","v":0},null,null,{"$f":"+'Provider Total Budget by Serv'!G36","v":0},{"$f":"IF(I15+C15=0,0,(IF(AND(I15=0,C15>0),-1,(IF(AND(I15>0,C15=0),1,+I15/C15-1)))))","v":0},null,null,{"$f":"+'Home Delivered Meal Budget'!M17","v":0}]
[null,"Total",{"$f":"SUM(C14:C15)","v":0},{"$f":"SUM(D14:D15)","v":0},{"$f":"+D16-C16","v":0},0,{"$f":"IF(AND(C16>0,C$80>0),+C16/C$80,0)","v":0},null,{"$f":"SUM(I14:I15)","v":0},{"$f":"IF(I16+C16=0,0,(IF(AND(I16=0,C16>0),-1,(IF(AND(I16>0,C16=0),1,+I16/C16-1)))))","v":0},{"$f":"IF(AND(I16>0,I$80>0),+I16/I$80,0)","v":{"$error":"#DIV/0!"}},null,{"$f":"+'Home Delivered Meal Budget'!M18","v":0}]
[null,"Nutrition Education"]
[null,"Salaries, PR Taxes & Benefits",null,null,{"$f":"+D18-C18","v":0},{"$f":"IF(+C18+D18=0,0,(IF(AND(+C18=0,D18>0),1,(IF(AND(+C18>0,D18=0),-1,+C18/+D18-1)))))","v":0},null,null,{"$f":"IF('Provider Total Budget by Serv'!E$300=\"N\",0,(+'Provider Total Budget by Serv'!E17+'Provider Total Budget by Serv'!E29)*'Provider Total Budget by Serv'!D$304)","v":{"$error":"#DIV/0!"}},{"$f":"IF(I18+C18=0,0,(IF(AND(I18=0,C18>0),-1,(IF(AND(I18>0,C18=0),1,+I18/C18-1)))))","v":{"$error":"#DIV/0!"}}]
[null,"Contract staff, Compensation",null,null,{"$f":"+D19-C19","v":0},0,null,null,{"$f":"IF('Provider Total Budget by Serv'!E$300=\"N\",0,(+'Provider Total Budget by Serv'!E36*'Provider Total Budget by Serv'!D$304))","v":{"$error":"#DIV/0!"}},{"$f":"IF(I19+C19=0,0,(IF(AND(I19=0,C19>0),-1,(IF(AND(I19>0,C19=0),1,+I19/C19-1)))))","v":{"$error":"#DIV/0!"}}]
[null,"Materials",null,null,{"$f":"+D20-C20","v":0},0,null,null,{"$f":"IF('Provider Total Budget by Serv'!E$300=\"N\",0,(+'Provider Total Budget by Serv'!E53*'Provider Total Budget by Serv'!D$304))","v":{"$error":"#DIV/0!"}},{"$f":"IF(I20+C20=0,0,(IF(AND(I20=0,C20>0),-1,(IF(AND(I20>0,C20=0),1,+I20/C20-1)))))","v":{"$error":"#DIV/0!"}}]
[null,"Conference",null,null,{"$f":"+D21-C21","v":0},0,null,null,{"$f":"IF('Provider Total Budget by Serv'!E$300=\"N\",0,(+'Provider Total Budget by Serv'!E43*'Provider Total Budget by Serv'!D$304))","v":{"$error":"#DIV/0!"}},{"$f":"IF(I21+C21=0,0,(IF(AND(I21=0,C21>0),-1,(IF(AND(I21>0,C21=0),1,+I21/C21-1)))))","v":{"$error":"#DIV/0!"}},null,null,{"$f":"+'Home Delivered Meal Budget'!M24","v":0}]
[null,"Total",{"$f":"SUM(C18:C21)","v":0},{"$f":"SUM(D18:D21)","v":0},{"$f":"+D22-C22","v":0},0,{"$f":"IF(AND(C22>0,C$80>0),+C22/C$80,0)","v":0},null,{"$f":"SUM(I18:I21)","v":{"$error":"#DIV/0!"}},{"$f":"IF(I22+C22=0,0,(IF(AND(I22=0,C22>0),-1,(IF(AND(I22>0,C22=0),1,+I22/C22-1)))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(I22>0,I$80>0),+I22/I$80,0)","v":{"$error":"#DIV/0!"}}]
[null,"Professional Development"]
[null,"Conference",null,null,{"$f":"+D24-C24","v":0},{"$f":"IF(+C24+D24=0,0,(IF(AND(+C24=0,D24>0),1,(IF(AND(+C24>0,D24=0),-1,+C24/+D24-1)))))","v":0},null,null,{"$f":"+'Provider Total Budget by Serv'!G43","v":0},{"$f":"IF(I24+C24=0,0,(IF(AND(I24=0,C24>0),-1,(IF(AND(I24>0,C24=0),1,+I24/C24-1)))))","v":0}]
[null,"Dues",null,null,{"$f":"+D25-C25","v":0},0,null,null,{"$f":"+'Provider Total Budget by Serv'!G48","v":0},{"$f":"IF(I25+C25=0,0,(IF(AND(I25=0,C25>0),-1,(IF(AND(I25>0,C25=0),1,+I25/C25-1)))))","v":0},null,null,{"$f":"+'Home Delivered Meal Budget'!M27","v":0}]
[null,"Materials",null,null,{"$f":"+D26-C26","v":0},0,null,null,{"$f":"+'Provider Total Budget by Serv'!G53","v":0},{"$f":"IF(I26+C26=0,0,(IF(AND(I26=0,C26>0),-1,(IF(AND(I26>0,C26=0),1,+I26/C26-1)))))","v":0},null,null,{"$f":"+'Home Delivered Meal Budget'!M28","v":0}]
[null,"Total",{"$f":"SUM(C24:C26)","v":0},{"$f":"SUM(D24:D26)","v":0},{"$f":"+D27-C27","v":0},0,{"$f":"IF(AND(C27>0,C$80>0),+C27/C$80,0)","v":0},null,{"$f":"SUM(I24:I26)","v":0},{"$f":"IF(I27+C27=0,0,(IF(AND(I27=0,C27>0),-1,(IF(AND(I27>0,C27=0),1,+I27/C27-1)))))","v":0},{"$f":"IF(AND(I27>0,I$80>0),+I27/I$80,0)","v":{"$error":"#DIV/0!"}},null,{"$f":"+'Home Delivered Meal Budget'!M29","v":0}]
[null,"Meals/Food"]
[null,"Raw Food",null,null,{"$f":"+D29-C29","v":0},{"$f":"IF(+C29+D29=0,0,(IF(AND(+C29=0,D29>0),1,(IF(AND(+C29>0,D29=0),-1,+C29/+D29-1)))))","v":0},null,null,{"$f":"+'Provider Total Budget by Serv'!G61","v":0},{"$f":"IF(I29+C29=0,0,(IF(AND(I29=0,C29>0),-1,(IF(AND(I29>0,C29=0),1,+I29/C29-1)))))","v":0}]
[null,"Purchased Meals",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!G68","v":0},0,null,null,{"$f":"+'Home Delivered Meal Budget'!M32","v":0}]
[null,"Freight",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!G73","v":0},0,null,null,{"$f":"+'Home Delivered Meal Budget'!M33","v":0}]
[null,"Storage",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!G78","v":0},0,null,null,{"$f":"+'Home Delivered Meal Budget'!M34","v":0}]
[null,"Consumables",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!G87","v":0},0,null,null,{"$f":"+'Home Delivered Meal Budget'!M35","v":0}]
[null,"Other",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!G92","v":0},0,null,null,{"$f":"+'Home Delivered Meal Budget'!M36","v":0}]
[null,"Total",{"$f":"SUM(C29:C34)","v":0},{"$f":"SUM(D29:D34)","v":0},0,0,{"$f":"IF(AND(C35>0,C$80>0),+C35/C$80,0)","v":0},null,{"$f":"SUM(I29:I34)","v":0},0,{"$f":"IF(AND(I35>0,I$80>0),+I35/I$80,0)","v":{"$error":"#DIV/0!"}},null,{"$f":"+'Home Delivered Meal Budget'!M37","v":0}]
[null,"Equipment"]
[null,"Depreciation",null,null,{"$f":"+D37-C37","v":0},{"$f":"IF(+C37+D37=0,0,(IF(AND(+C37=0,D37>0),1,(IF(AND(+C37>0,D37=0),-1,+C37/+D37-1)))))","v":0},null,null,{"$f":"+'Provider Total Budget by Serv'!G99","v":0},{"$f":"IF(I37+C37=0,0,(IF(AND(I37=0,C37>0),-1,(IF(AND(I37>0,C37=0),1,+I37/C37-1)))))","v":0}]
[null,"Interest",null,null,{"$f":"+D38-C38","v":0},0,null,null,{"$f":"+'Provider Total Budget by Serv'!G104","v":0},{"$f":"IF(I38+C38=0,0,(IF(AND(I38=0,C38>0),-1,(IF(AND(I38>0,C38=0),1,+I38/C38-1)))))","v":0},null,null,{"$f":"+'Home Delivered Meal Budget'!M40","v":0}]
[null,"Leasing",null,null,{"$f":"+D39-C39","v":0},0,null,null,{"$f":"+'Provider Total Budget by Serv'!G109","v":0},{"$f":"IF(I39+C39=0,0,(IF(AND(I39=0,C39>0),-1,(IF(AND(I39>0,C39=0),1,+I39/C39-1)))))","v":0},null,null,{"$f":"+'Home Delivered Meal Budget'!M41","v":0}]
[null,"Maintenance",null,null,{"$f":"+D40-C40","v":0},0,null,null,{"$f":"+'Provider Total Budget by Serv'!G114","v":0},{"$f":"IF(I40+C40=0,0,(IF(AND(I40=0,C40>0),-1,(IF(AND(I40>0,C40=0),1,+I40/C40-1)))))","v":0},null,null,{"$f":"+'Home Delivered Meal Budget'!M42","v":0}]
[null,"Total",{"$f":"SUM(C37:C40)","v":0},{"$f":"SUM(D37:D40)","v":0},{"$f":"+D41-C41","v":0},0,{"$f":"IF(AND(C41>0,C$80>0),+C41/C$80,0)","v":0},null,{"$f":"SUM(I37:I40)","v":0},{"$f":"IF(I41+C41=0,0,(IF(AND(I41=0,C41>0),-1,(IF(AND(I41>0,C41=0),1,+I41/C41-1)))))","v":0},{"$f":"IF(AND(I41>0,I$80>0),+I41/I$80,0)","v":{"$error":"#DIV/0!"}},null,{"$f":"+'Home Delivered Meal Budget'!M43","v":0}]
[null,"Occupancy/Building"]
[null,"Rent",null,null,{"$f":"+D43-C43","v":0},{"$f":"IF(+C43+D43=0,0,(IF(AND(+C43=0,D43>0),1,(IF(AND(+C43>0,D43=0),-1,+C43/+D43-1)))))","v":0},null,null,{"$f":"+'Provider Total Budget by Serv'!G121","v":0},{"$f":"IF(I43+C43=0,0,(IF(AND(I43=0,C43>0),-1,(IF(AND(I43>0,C43=0),1,+I43/C43-1)))))","v":0}]
[null,"Utilities",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!G126","v":0},0,null,null,{"$f":"+'Home Delivered Meal Budget'!M46","v":0}]
[null,"Depreciation",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!G131","v":0},0,null,null,{"$f":"+'Home Delivered Meal Budget'!M47","v":0}]
[null,"Mortgage Interest",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!G136","v":0},0,null,null,{"$f":"+'Home Delivered Meal Budget'!M48","v":0}]
[null,"Insurance",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!G141","v":0},0,null,null,{"$f":"+'Home Delivered Meal Budget'!M49","v":0}]
[null,"Security",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!G146","v":0},0,null,null,{"$f":"+'Home Delivered Meal Budget'!M50","v":0}]
[null,"Janitorial",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!G151","v":0},0,null,null,{"$f":"+'Home Delivered Meal Budget'!M51","v":0}]
[null,"Repair",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!G156","v":0},0,null,null,{"$f":"+'Home Delivered Meal Budget'!M52","v":0}]
[null,"Taxes",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!G161","v":0},0,null,null,{"$f":"+'Home Delivered Meal Budget'!M53","v":0}]
[null,"Total",{"$f":"SUM(C43:C51)","v":0},{"$f":"SUM(D43:D51)","v":0},0,0,{"$f":"IF(AND(C52>0,C$80>0),+C52/C$80,0)","v":0},null,{"$f":"SUM(I43:I51)","v":0},0,{"$f":"IF(AND(I52>0,I$80>0),+I52/I$80,0)","v":{"$error":"#DIV/0!"}},null,{"$f":"+'Home Delivered Meal Budget'!M54","v":0}]
[null,"Transportation/Travel"]
[null,"Mileage Reimbursement",null,null,{"$f":"+D54-C54","v":0},{"$f":"IF(+C54+D54=0,0,(IF(AND(+C54=0,D54>0),1,(IF(AND(+C54>0,D54=0),-1,+C54/+D54-1)))))","v":0},null,null,{"$f":"+'Provider Total Budget by Serv'!G168","v":0},{"$f":"IF(I54+C54=0,0,(IF(AND(I54=0,C54>0),-1,(IF(AND(I54>0,C54=0),1,+I54/C54-1)))))","v":0}]
[null,"Delivery",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!G173","v":0},0,null,null,{"$f":"+'Home Delivered Meal Budget'!M57","v":0}]
[null,"Gas & Oil",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!G178","v":0},0,null,null,{"$f":"+'Home Delivered Meal Budget'!M58","v":0}]
[null,"Repairs",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!G183","v":0},0,null,null,{"$f":"+'Home Delivered Meal Budget'!M59","v":0}]
[null,"Insurance",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!G188","v":0},0,null,null,{"$f":"+'Home Delivered Meal Budget'!M60","v":0}]
[null,"Depreciation/Lease",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!G193","v":0},0,null,null,{"$f":"+'Home Delivered Meal Budget'!M61","v":0}]
[null,"Interest",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!G198","v":0},0,null,null,{"$f":"+'Home Delivered Meal Budget'!M62","v":0}]
[null,"Tags & Licenses",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!G203","v":0},0,null,null,{"$f":"+'Home Delivered Meal Budget'!M63","v":0}]
[null,"Total",{"$f":"SUM(C54:C61)","v":0},{"$f":"SUM(D54:D61)","v":0},0,0,{"$f":"IF(AND(C62>0,C$80>0),+C62/C$80,0)","v":0},null,{"$f":"SUM(I54:I61)","v":0},0,{"$f":"IF(AND(I62>0,I$80>0),+I62/I$80,0)","v":{"$error":"#DIV/0!"}},null,{"$f":"+'Home Delivered Meal Budget'!M64","v":0}]
[null,"Administrative & General"]
[null,"Advertising",null,null,{"$f":"+D64-C64","v":0},{"$f":"IF(+C64+D64=0,0,(IF(AND(+C64=0,D64>0),1,(IF(AND(+C64>0,D64=0),-1,+C64/+D64-1)))))","v":0},null,null,{"$f":"+'Provider Total Budget by Serv'!G210","v":0},{"$f":"IF(I64+C64=0,0,(IF(AND(I64=0,C64>0),-1,(IF(AND(I64>0,C64=0),1,+I64/C64-1)))))","v":0}]
[null,"Printing",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!G215","v":0},0,null,null,{"$f":"+'Home Delivered Meal Budget'!M67","v":0}]
[null,"Copying",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!G220","v":0},0,null,null,{"$f":"+'Home Delivered Meal Budget'!M68","v":0}]
[null,"Office Supplies",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!G225","v":0},0,null,null,{"$f":"+'Home Delivered Meal Budget'!M69","v":0}]
[null,"Contractual Agreements",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!G230","v":0},0,null,null,{"$f":"+'Home Delivered Meal Budget'!M70","v":0}]
[null,"Postage",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!G235","v":0},0,null,null,{"$f":"+'Home Delivered Meal Budget'!M71","v":0}]
[null,"Telecommunications",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!G240","v":0},0,null,null,{"$f":"+'Home Delivered Meal Budget'!M72","v":0}]
[null,"Liability Insurance",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!G245","v":0},0,null,null,{"$f":"+'Home Delivered Meal Budget'!M73","v":0}]
[null,"Legal Fees",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!G250","v":0},0,null,null,{"$f":"+'Home Delivered Meal Budget'!M74","v":0}]
[null,"Accounting Fees",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!G255","v":0},0,null,null,{"$f":"+'Home Delivered Meal Budget'!M75","v":0}]
[null,"Consulting Fees",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!G260","v":0},0,null,null,{"$f":"+'Home Delivered Meal Budget'!M76","v":0}]
[null,"Other Fees (Explain)",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!G265","v":0},0,null,null,{"$f":"+'Home Delivered Meal Budget'!M77","v":0}]
[null,"Audit",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!G270","v":0},0,null,null,{"$f":"+'Home Delivered Meal Budget'!M78","v":0}]
[null,"Other Misc. (Explain)",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!G275","v":0},0,null,null,{"$f":"+'Home Delivered Meal Budget'!M79","v":0}]
[null,"Total",{"$f":"SUM(C64:C77)","v":0},{"$f":"SUM(D64:D77)","v":0},0,0,{"$f":"IF(AND(C78>0,C$80>0),+C78/C$80,0)","v":0},null,{"$f":"SUM(I64:I77)","v":0},0,{"$f":"IF(AND(I78>0,I$80>0),+I78/I$80,0)","v":{"$error":"#DIV/0!"}},null,{"$f":"+'Home Delivered Meal Budget'!M80","v":0}]
[null,"Total"]
[null,"Total of all Cost Areas",{"$f":"+C16+C22+C27+C35+C41+C52+C62+C78","v":0},{"$f":"+D16+D22+D27+D35+D41+D52+D62+D78","v":0},{"$f":"+D80-C80","v":0},{"$f":"IF(+C80+D80=0,0,(IF(AND(+C80=0,D80>0),1,(IF(AND(+C80>0,D80=0),-1,+C80/+D80-1)))))","v":0},{"$f":"IF(AND(C80>0,C$80>0),+C80/C$80,0)","v":0},null,{"$f":"+I16+I22+I27+I35+I41+I52+I62+I78","v":{"$error":"#DIV/0!"}},{"$f":"IF(I80+C80=0,0,(IF(AND(I80=0,C80>0),-1,(IF(AND(I80>0,C80=0),1,+I80/C80-1)))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND(I80>0,I$80>0),+I80/I$80,0)","v":{"$error":"#DIV/0!"}}]
[null,"Total Number of Meals ",null,null,null,null,null,null," "]
[null,"Whole Cost per Meal",{"$f":"IF(C81=0,0,+C80/C81)","v":0},{"$f":"IF(D81=0,0,+D80/D81)","v":0}]
[null,"Approved Meal Rate Title III",{"$f":"+D83","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Funding Source",null,null,null,null,"Proposed Meals",null,"Calculated Rate",null,"Revenue"]
[null,"HHS OAAA - Match Required",null,null,null,null,null,null,{"$f":"IF(G93=0,0,'Unit Rate Calculation CM'!F28)","v":0},null,{"$f":"+G93*I93","v":0},"Proposed Meals * Calculated Units"]
[null,"Program Income",null,null,null,null,null,null,{"$f":"IF(G94=0,0,'Unit Rate Calculation CM'!$K$17)","v":0},null,{"$f":"+G94*I94","v":0},"Proposed Meals * Calculated Units"]
[null,"Other Funds - Eligible Meals",null,null,null,null,null,null,{"$f":"IF(G95=0,0,'Unit Rate Calculation CM'!$K$17)","v":0},null,{"$f":"+G95*I95","v":0},"Proposed Meals * Calculated Units"]
[null,"Other Funds - Non-Eligible Meals",null,null,null,null,null,null,{"$f":"IF(G96=0,0,'Unit Rate Calculation CM'!$K$17)","v":0},null,{"$f":"+G96*I96","v":0},"Proposed Meals * Calculated Units"]
[null,"Local Funds - Required Match",null,null,null,null,"NA",null,{"$f":"IF(G97=0,0,'Unit Rate Calculation CM'!$F$27)","v":0},null,{"$f":"+G93*I97","v":0},"Proposed Meals * Calculated Units"]
[null,"Other Sources 5",null,null,null,null,null,null,{"$f":"+'Unit Rate Calculation CM'!K17","v":0},null,{"$f":"+G98*I98","v":0},"Proposed Meals * Calculated Units"]
[null,"Other Sources 6",null,null,null,null,null,null,{"$f":"+'Unit Rate Calculation CM'!K17","v":0},null,{"$f":"+G99*I99","v":0},"Proposed Meals * Calculated Units"]
[null,"Total Meals by Funding Source",null,null,null,null,{"$f":"SUM(G93:G99)","v":0},null,null,null,{"$f":"SUM(K93:K99)","v":0},"Total Revenue"]
[null,"Provider Total Budgeted Congregate Meals",null,null,null,null,{"$f":"+C_TotalBudgetedMeals","v":0}]
[null,"Variance (Provider Total Budgeted Congregate Meals - \nTotal Meals by Funding Source) ",null,null,null,null,{"$f":"+G101-G100","v":0}]
[]
[null,"Estimated Number of Nutrition Education Units AAA Clients",null,null,null,null,100]
[null,"Nutrition Education Budget - AAA Clients",null,null,null,null,{"$f":"++'Provider Total Budget by Serv'!E278*'Provider Total Budget by Serv'!D304","v":{"$error":"#DIV/0!"}}]
[null,"Calculated Cost per Unit",null,null,null,null,{"$f":"IF(G104>0,+G105/G104,0)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Unit Rate Calculation CM","index":9,"n_rows":103,"n_cols":11,"rows_kept":103,"cut":false,"hidden":false,"merged":[[1,3,1,7],[2,9,2,10],[17,1,17,10],[18,1,18,10],[7,1,7,10],[8,1,8,10],[9,1,9,10],[3,1,3,10],[5,1,5,10],[6,1,6,8],[4,1,4,10],[11,1,11,10],[13,1,13,10],[14,1,14,10],[12,1,12,2],[10,1,10,2],[10,8,10,10],[15,1,15,10],[16,1,16,8],[93,2,93,8],[49,2,49,4],[49,6,49,8],[53,2,53,4],[53,6,53,8],[52,6,52,8],[41,6,41,8],[42,2,42,4],[38,6,38,8],[45,2,45,4],[45,6,45,8],[52,2,52,4],[48,2,48,4],[44,6,44,8],[44,2,44,4],[41,2,41,4],[42,6,42,8],[37,2,37,4],[2,3,2,8],[20,8,20,10],[38,2,38,4],[27,8,27,10],[20,1,20,4],[21,1,21,10],[22,1,22,4],[22,8,22,10],[26,1,26,4],[25,1,25,3],[34,2,34,4],[27,1,27,4],[33,2,33,4],[33,6,33,8],[37,6,37,8],[34,6,34,8]]}
[null,null,{"$f":"NOW()","v":"2020-07-23T18:20:44.220"}]
[null,null,"Provider Name: ",{"$f":"+'Provider Information'!F6","v":0}]
[null,null,"AAA Name:",{"$f":"+'Provider Information'!D21","v":0}]
[null,"Congregate Meals"]
[null,"BUDGET WORKSHEET CALCULATION OF THE PER MEAL UNIT RATE"]
[]
[null,"1.  Total Budgeted Expenses for Contract Year ",null,null,null,null,null,null,null,"1.",{"$f":"+'Congregate Meal Budget'!I80","v":{"$error":"#DIV/0!"}}]
[]
[null,"2.  Total Number of Anticipated Meals to be Provided  by Funding Source"]
[]
[null,"HHS OAAA",null,{"$f":"+'Congregate Meal Budget'!G93","v":0},"Other Funds Eligible Meals",{"$f":"+'Congregate Meal Budget'!G95","v":0},{"$f":"+'Congregate Meal Budget'!B98","v":"Other Sources 5"},{"$f":"+'Congregate Meal Budget'!G98","v":0}]
[]
[null,"Program Income",null,{"$f":"+'Congregate Meal Budget'!G94","v":0},"Other Funds - Non-Eligible Meals",{"$f":"+'Congregate Meal Budget'!G96","v":0},{"$f":"+'Congregate Meal Budget'!B99","v":"Other Sources 6"},{"$f":"+'Congregate Meal Budget'!G99","v":0},null,"2.",{"$f":"IF('Congregate Meal Budget'!G100>0,+D11+F11+H11+D13+F13+H13,0)","v":0}]
[]
[]
[]
[null,"3.   Whole Unit Rate  (Line 1 divided by Line 2)",null,null,null,null,null,null,null,"3.",{"$f":"ROUND(IF(K13=0,0,+K7/K13),2)","v":0}]
[]
[null,"Reimbursement Calculation"]
[null,null,null,null,null,"HHS OAAA"]
[null,"4.  Projected NSIP per Meal Value",null,null,null,0.73]
[]
[null,"5.  Rate Less NSIP per Meal Value",null,null,null,{"$f":"ROUND(IF(K17=0,0,+K17-F21),2)","v":0}]
[]
[null,"6.  Mandatory Local Match of 10%",null,null,{"$f":"ROUND(IF(F23=\"\",\"\",+F23*0.1),2)","v":0}]
[null,"  **  If Applicable, Match Reduction \n       From the In-kind Match \n       Certification form",null,null,{"$f":"-I103","v":0}]
[null,"      Required Cash Match",null,null,null,{"$f":"IF(+E25=\"\",0,+E25+E26)","v":0}]
[null,"7.  Proposed Meal Rate (Line 3 minus Line 6)",null,null,null,{"$f":"ROUND(IF(K17>0,K17-F27,0),2)","v":0}]
[]
[null,"**  If any portion of the required match is in-kind, you must complete an In-Kind Match Certification form. "]
[null,null,"By signing below, the provider acknowledges that all related records are subject to audit in accordance with"]
[null,null,"contract requirements and all applicable federal and state laws."]
[null,null," "]
[null,null,{"$f":"+'Congregate Meal Budget'!C2","v":0}]
[null,null,"Legal Name of Contracted Provider",null,null,null,"Printed/Typed Name of Signer"]
[]
[]
[]
[null,null,"Signature",null,null,null,"Date"]
[]
[]
[null,null,{"$f":"+'Congregate Meal Budget'!C3:G3","v":0}]
[null,null,"Name of Area Agency on Aging"]
[]
[null,null,{"$f":"'Provider Information'!$D$22","v":0}]
[null,null,"Printed/Typed Name of Signer"]
[]
[]
[]
[null,null,"Signature"]
[]
[]
[]
[null,null,"Date"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Calculation of In-Kind Value"]
[null,null,"1. Required Match Rate",null,null,null,null,null,{"$f":"+E25","v":0}]
[null,null,"2. TDoA units + DHS units",null,null,null,null,null,{"$f":"IF(D11+F11=0,K13,+D11+F11)","v":0}]
[null,null,"3. Required Match Rate (1) Multiplied by the anticipated number of TDoA units (2)",null,null,null,null,null,{"$f":"+I95*I96","v":0}]
[null,null,"4. Total Valuation from the In-Kind Certification",null,null,null,null,null,{"$f":"+'In-Kind Certification CM'!G25","v":0}]
[null,null,"5. Balance of Required Match (3-4)",null,null,null,null,null,{"$f":"+I97-I98","v":0}]
[null,null,"6. TDoA units + DHS units",null,null,null,null,null,{"$f":"IF(+D11+F11=0,K13,+D11+F11)","v":0}]
[null,null,"7. Balance of Required Match (5) Divided by TDoA units (6)",null,null,null,null,null,{"$f":"IF(I99=0,0,+I99/I100)","v":0}]
[null,null,"8. Required Match Rate",null,null,null,null,null,{"$f":"+E25","v":0}]
[null,null,"9. Reduced Required Match If (8) is equal to or less than 0 this will equal (8) or else (8-7)",null,null,null,null,null,{"$f":"IF(+I101<=0,+I102,+I102-I101)","v":0}]

{"sheet":"Certification CM","index":10,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[[1,3,1,7],[37,2,37,4],[37,6,37,9],[36,2,36,4],[32,2,32,4],[32,6,32,9],[3,1,3,10],[36,6,36,9],[5,1,5,4],[5,6,5,10],[4,1,4,10],[33,2,33,4],[33,6,33,9],[2,3,2,8]]}
[null,null,{"$f":"NOW()","v":"2020-07-23T18:20:44.220"}]
[null,null,"Provider Name: ",{"$f":"+'Provider Information'!F6","v":0}]
[null,null,"AAA Name:",{"$f":"+'Provider Information'!D21","v":0}]
[null,"Congregate Meals"]
[null,"BUDGET WORKSHEET CERTIFICATION"]
[]
[null,"        AS SIGNER OF THIS BUDGET WORKSHEET, I HEREBY CERTIFY THAT:"]
[]
[null,"·","I have read the note below and the instructions applicable to this budget worksheet."]
[]
[null,"·","I have reviewed this budget worksheet after its preparation."]
[]
[null,"·","To the best of my knowledge and belief, this budget worksheet is true, correct and"]
[null," ","complete, and was prepared in accordance with the instructions applicable to this"]
[null," ","budget worksheet."]
[]
[null,"·","This budget worksheet was prepared from the books and records of the contracted"]
[null," ","provider."]
[]
[null,"·","I acknowledge that all books and records related to this rate setting process are"]
[null," ","subject to audit in accordance with contract requirements and all applicable federal "]
[null,null,"and state laws."]
[]
[]
[null,"    Note: ","The person legally responsible for the conduct of the contracted provider must"]
[null,null,"sign this Budget Worksheet Certification.  If a sole proprietor, the owner"]
[null,null,"must sign the Budget Worksheet Certification.  If a partnership, a partner must "]
[null,null,"sign the Budget Worksheet Certification.  If a corporation, the person authorized by the "]
[null,null,"Board of Directors Resolution must sign the Budget Worksheet Certification.  "]
[null,null,"Misrepresentation of information contained in the budget worksheet may result in "]
[null,null,"adverse action, up to and including contract termination.  Furthermore, falsification of "]
[null,null,"information in the budget worksheet may result in a referral for prosecution."]
[null,null,{"$f":"+'Congregate Meal Budget'!C2","v":0}]
[null,null,"Name of Contracted Provider",null,null,null,"Printed/Typed Name of Signer"]
[]
[]
[]
[null,null,"Date",null,null,null,"Signature"]
[]
[]
[]
[null,null,"Signer Authority:",null,"Sole Proprietor",null,"Association Officer"]
[null,null,"    (check one)",null,"Partner",null,"Board Member"]
[null,null,null,null,"Corporate Officer",null,"Governmental Official           "]

{"sheet":"In-Kind Certification CM","index":11,"n_rows":48,"n_cols":7,"rows_kept":48,"cut":false,"hidden":false,"merged":[[26,2,26,5],[31,3,31,6],[21,1,21,4],[22,1,22,4],[33,9,33,13],[2,1,2,6],[3,1,3,6],[8,1,8,6],[11,1,11,4],[12,1,12,4],[6,3,6,4],[4,2,4,4],[6,1,6,2],[19,1,19,4],[20,1,20,4],[13,1,13,4],[14,1,14,4],[15,1,15,4],[16,1,16,4],[0,2,0,3],[1,3,1,6],[49,1,49,7],[47,1,47,3],[47,5,47,6],[44,1,44,3],[44,5,44,6],[23,1,23,4],[24,1,24,4],[46,1,46,3],[43,5,43,6],[43,1,43,3],[46,5,46,6],[34,3,34,6],[17,1,17,4],[18,1,18,4]]}
[null,null,{"$f":"NOW()","v":"2020-07-23T18:20:44.220"}]
[null,null,"AAA Name:",{"$f":"+'Provider Information'!D21","v":0}]
[null,"Congregate Meals"]
[null,"IN-KIND MATCH CERTIFICATION"]
[null,"Provider: ",{"$f":"IF(ISBLANK('Provider Information'!F6),\"\",+'Provider Information'!F6)","v":""}]
[]
[null,"In-kind Contribution(s):",null,{"$f":"+G25","v":0}]
[]
[null,"For any item identified below, the provider must maintain monthly supporting documentation."]
[]
[]
[null,"ITEM",null,null,null,"DATE OF RECEIPT","VALUE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"TOTAL",{"$f":"SUM(G13:G24)","v":0}]
[]
[null,"Note:","All contributions must meet the requirements of IRS Publication 561  \nhttp://www.irs.gov/pub/irs-pdf/p561.pdf"]
[]
[null,"Examples of Documentation Include:"]
[]
[null,"Rent:","1.","Letter of Agreement with Owner"]
[null,null,"2.","Adequate Valuation of Property on a Current Basis (this should be reviewed at least every two years and if senior center, based on property value and center participation)"]
[]
[null,"Labor:","1.","Minimum wage"]
[null,null,"2.","Documented prevailing wage in the Area. For prevailing wage information visit the Texas Workforce Commission’s website at  http://www.tracer2.com/."]
[]
[]
[null,"All in-kind labor must be required for the service to be provided.  If you would not hire someone to perform the labor if it "]
[null,"were not in-kind then you cannot count it."]
[]
[null,"Utilities: ","1.","Copy of Bill"]
[null,null,"2.","Agreement of Amount Paid if Partial"]
[]
[null,{"$f":"+'Provider Total Budget by Serv'!C2","v":""},null,null,null,{"$f":"'Provider Information'!$F$13","v":0}]
[null,"        Name of Contracted Provider",null,null,null,"Printed/Typed Name of Signer"]
[]
[]
[null,"Date",null,null,null,"Signature"]

{"sheet":"Participant Assessment Budget","index":12,"n_rows":119,"n_cols":21,"rows_kept":119,"cut":false,"hidden":false,"merged":[[0,14,80,14],[0,1,0,13],[27,1,27,6],[1,7,3,7],[13,12,15,13],[17,12,21,13],[23,12,26,13],[1,8,3,13],[5,1,6,1],[5,2,6,2],[5,12,6,13],[4,8,4,10],[5,3,6,6],[36,12,40,13],[11,12,11,13],[8,8,11,8],[42,12,51,13],[28,12,34,13],[95,2,95,3],[53,12,61,13],[63,12,77,13],[88,2,88,3],[89,2,89,3],[89,7,89,8],[88,7,88,8],[81,12,81,13],[82,12,82,13],[79,12,79,13],[94,7,94,8],[90,2,90,3],[91,2,91,3],[92,2,92,3],[93,2,93,3],[94,2,94,3],[94,5,94,6],[90,5,90,6],[92,5,92,6],[91,5,91,6],[95,5,95,6],[93,5,93,6],[96,5,96,6],[100,5,100,6],[97,5,97,6],[98,5,98,6],[99,5,99,6],[96,2,96,3],[97,2,97,3],[98,2,98,3],[99,2,99,3],[100,2,100,3],[5,8,6,10],[8,9,11,9],[98,7,98,8],[99,7,99,8],[100,7,100,8],[96,7,96,8],[7,8,7,10],[97,7,97,8],[95,7,95,8],[90,7,90,8],[91,7,91,8],[92,7,92,8],[93,7,93,8],[8,10,11,10],[78,1,78,6],[52,1,52,6],[16,1,16,6],[22,1,22,6],[41,1,41,6],[4,2,4,3],[1,2,1,6],[2,2,2,6],[3,2,3,6],[89,5,89,6],[7,1,7,6],[8,6,11,6],[8,1,11,1],[8,2,11,2],[8,3,11,3],[8,4,11,4],[8,5,11,5],[35,1,35,6],[62,1,62,6],[12,1,12,6],[88,5,88,6]]}
[null,{"$f":"+'Provider Total Budget by Serv'!J4","v":"Participant Assessment"}]
[null,"Provider Name: ",{"$f":"'Provider Information'!$F$6","v":0},null,null,null,null,null,"Review of Most Recent Completed Year Approved Budget to Actual Year End Expense and Current Proposed Budget"]
[null,"AAA Name:",{"$f":"+'Provider Information'!D21","v":0}]
[]
[null,null,{"$f":"NOW()","v":"2020-07-23T18:20:44.220"}]
[null,"Most Recent Completed Budget Year",2018,null,null,null,null,null," Proposed Budget",null,null,null,"Explanation of Variances"]
[]
[]
[null,"Cost Area"," Expense per General Ledger","Approved Budget ","Variance\nBudget\nminus\nExpenses","Percentage of Variance","Percentage of Unit Cost",null,"Proposed Budget ","Percentage Variance - Prior Year Actual to Proposed Budget","Percentage of Unit Cost",null,"Inflation Factor 2018 to 2019",1.022E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,"Inflation Factor 2019 to 2020",1.0211E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,"Combined Inflation Factor",{"$f":"SUM(N9:N10)","v":2.0430999999999998E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,"1. An explanation of variance must be provided for each cost area where the expenses per General Ledger varies from the approved budget for the most recent completed year  by 10% or more; and \n 2. An explanation of variance must be provided for each cost area where the proposed budget amount exceeds the prior year actual amount by more than the two year combined inflation factor."]
[null,"Personnel"]
[null,"Salaries, PR Taxes & Benefits",null,null,{"$f":"+D14-C14","v":0},{"$f":"IF(+C14+D14=0,0,(IF(AND(+C14=0,D14>0),1,(IF(AND(+C14>0,D14=0),-1,+C14/+D14-1)))))","v":0},null,null,{"$f":"+'Provider Total Budget by Serv'!J17+'Provider Total Budget by Serv'!J29","v":0},{"$f":"IF(I14+C14=0,0,(IF(AND(I14=0,C14>0),-1,(IF(AND(I14>0,C14=0),1,+I14/C14-1)))))","v":0}]
[null,"Contract staff, Compensation",null,null,{"$f":"+D15-C15","v":0},{"$f":"IF(+C15+D15=0,0,(IF(AND(+C15=0,D15>0),1,(IF(AND(+C15>0,D15=0),-1,+C15/+D15-1)))))","v":0},null,null,{"$f":"+'Provider Total Budget by Serv'!J36","v":0},{"$f":"IF(I15+C15=0,0,(IF(AND(I15=0,C15>0),-1,(IF(AND(I15>0,C15=0),1,+I15/C15-1)))))","v":0}]
[null,"Total",{"$f":"SUM(C14:C15)","v":0},{"$f":"SUM(D14:D15)","v":0},{"$f":"+D16-C16","v":0},0,{"$f":"IF(AND(C16>0,C$80>0),+C16/C$80,0)","v":0},null,{"$f":"SUM(I14:I15)","v":0},{"$f":"IF(I16+C16=0,0,(IF(AND(I16=0,C16>0),-1,(IF(AND(I16>0,C16=0),1,+I16/C16-1)))))","v":0},{"$f":"IF(AND(I16>0,I$80>0),+I16/I$80,0)","v":0}]
[null,"Nutrition Education"]
[null,"Salaries, PR Taxes & Benefits",null,null,{"$f":"+D18-C18","v":0},{"$f":"IF(+C18+D18=0,0,(IF(AND(+C18=0,D18>0),1,(IF(AND(+C18>0,D18=0),-1,+C18/+D18-1)))))","v":0}]
[null,"Contract staff, Compensation",null,null,{"$f":"+D19-C19","v":0},0]
[null,"Materials",null,null,{"$f":"+D20-C20","v":0},0]
[null,"Conference",null,null,{"$f":"+D21-C21","v":0},0]
[null,"Total",{"$f":"SUM(C18:C21)","v":0},{"$f":"SUM(D18:D21)","v":0},{"$f":"+D22-C22","v":0},0,{"$f":"IF(AND(C22>0,C$80>0),+C22/C$80,0)","v":0},null,{"$f":"SUM(I18:I21)","v":0},null,{"$f":"IF(AND(I22>0,I$80>0),+I22/I$80,0)","v":0}]
[null,"Professional Development"]
[null,"Conference",null,null,{"$f":"+D24-C24","v":0},{"$f":"IF(+C24+D24=0,0,(IF(AND(+C24=0,D24>0),1,(IF(AND(+C24>0,D24=0),-1,+C24/+D24-1)))))","v":0},null,null,{"$f":"+'Provider Total Budget by Serv'!J43","v":0},{"$f":"IF(I24+C24=0,0,(IF(AND(I24=0,C24>0),-1,(IF(AND(I24>0,C24=0),1,+I24/C24-1)))))","v":0}]
[null,"Dues",null,null,{"$f":"+D25-C25","v":0},0,null,null,{"$f":"+'Provider Total Budget by Serv'!J48","v":0},{"$f":"IF(I25+C25=0,0,(IF(AND(I25=0,C25>0),-1,(IF(AND(I25>0,C25=0),1,+I25/C25-1)))))","v":0}]
[null,"Materials",null,null,{"$f":"+D26-C26","v":0},0,null,null,{"$f":"+'Provider Total Budget by Serv'!J53","v":0},{"$f":"IF(I26+C26=0,0,(IF(AND(I26=0,C26>0),-1,(IF(AND(I26>0,C26=0),1,+I26/C26-1)))))","v":0}]
[null,"Total",{"$f":"SUM(C24:C26)","v":0},{"$f":"SUM(D24:D26)","v":0},{"$f":"+D27-C27","v":0},0,{"$f":"IF(AND(C27>0,C$80>0),+C27/C$80,0)","v":0},null,{"$f":"SUM(I24:I26)","v":0},{"$f":"IF(I27+C27=0,0,(IF(AND(I27=0,C27>0),-1,(IF(AND(I27>0,C27=0),1,+I27/C27-1)))))","v":0},{"$f":"IF(AND(I27>0,I$80>0),+I27/I$80,0)","v":0}]
[null,"Meals/Food"]
[null,"Raw Food",null,null,{"$f":"+D29-C29","v":0},{"$f":"IF(+C29+D29=0,0,(IF(AND(+C29=0,D29>0),1,(IF(AND(+C29>0,D29=0),-1,+C29/+D29-1)))))","v":0},null,null,{"$f":"+'Provider Total Budget by Serv'!J61","v":0},{"$f":"IF(I29+C29=0,0,(IF(AND(I29=0,C29>0),-1,(IF(AND(I29>0,C29=0),1,+I29/C29-1)))))","v":0}]
[null,"Purchased Meals",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!J68","v":0},0]
[null,"Freight",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!J73","v":0},0]
[null,"Storage",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!J78","v":0},0]
[null,"Consumables",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!J87","v":0},0]
[null,"Other",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!J92","v":0},0]
[null,"Total",{"$f":"SUM(C29:C34)","v":0},{"$f":"SUM(D29:D34)","v":0},0,0,{"$f":"IF(AND(C35>0,C$80>0),+C35/C$80,0)","v":0},null,{"$f":"SUM(I29:I34)","v":0},0,{"$f":"IF(AND(I35>0,I$80>0),+I35/I$80,0)","v":0}]
[null,"Equipment"]
[null,"Depreciation",null,null,{"$f":"+D37-C37","v":0},{"$f":"IF(+C37+D37=0,0,(IF(AND(+C37=0,D37>0),1,(IF(AND(+C37>0,D37=0),-1,+C37/+D37-1)))))","v":0},null,null,{"$f":"+'Provider Total Budget by Serv'!J99","v":0},{"$f":"IF(I37+C37=0,0,(IF(AND(I37=0,C37>0),-1,(IF(AND(I37>0,C37=0),1,+I37/C37-1)))))","v":0}]
[null,"Interest",null,null,{"$f":"+D38-C38","v":0},0,null,null,{"$f":"+'Provider Total Budget by Serv'!J104","v":0},{"$f":"IF(I38+C38=0,0,(IF(AND(I38=0,C38>0),-1,(IF(AND(I38>0,C38=0),1,+I38/C38-1)))))","v":0}]
[null,"Leasing",null,null,{"$f":"+D39-C39","v":0},0,null,null,{"$f":"+'Provider Total Budget by Serv'!J109","v":0},{"$f":"IF(I39+C39=0,0,(IF(AND(I39=0,C39>0),-1,(IF(AND(I39>0,C39=0),1,+I39/C39-1)))))","v":0}]
[null,"Maintenance",null,null,{"$f":"+D40-C40","v":0},0,null,null,{"$f":"+'Provider Total Budget by Serv'!J114","v":0},{"$f":"IF(I40+C40=0,0,(IF(AND(I40=0,C40>0),-1,(IF(AND(I40>0,C40=0),1,+I40/C40-1)))))","v":0}]
[null,"Total",{"$f":"SUM(C37:C40)","v":0},{"$f":"SUM(D37:D40)","v":0},{"$f":"+D41-C41","v":0},0,{"$f":"IF(AND(C41>0,C$80>0),+C41/C$80,0)","v":0},null,{"$f":"SUM(I37:I40)","v":0},{"$f":"IF(I41+C41=0,0,(IF(AND(I41=0,C41>0),-1,(IF(AND(I41>0,C41=0),1,+I41/C41-1)))))","v":0},{"$f":"IF(AND(I41>0,I$80>0),+I41/I$80,0)","v":0}]
[null,"Occupancy/Building"]
[null,"Rent",null,null,{"$f":"+D43-C43","v":0},{"$f":"IF(+C43+D43=0,0,(IF(AND(+C43=0,D43>0),1,(IF(AND(+C43>0,D43=0),-1,+C43/+D43-1)))))","v":0},null,null,{"$f":"+'Provider Total Budget by Serv'!J121","v":0},{"$f":"IF(I43+C43=0,0,(IF(AND(I43=0,C43>0),-1,(IF(AND(I43>0,C43=0),1,+I43/C43-1)))))","v":0}]
[null,"Utilities",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!J126","v":0},0]
[null,"Depreciation",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!J131","v":0},0]
[null,"Mortgage Interest",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!J136","v":0},0]
[null,"Insurance",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!J141","v":0},0]
[null,"Security",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!J146","v":0},0]
[null,"Janitorial",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!J151","v":0},0]
[null,"Repair",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!J156","v":0},0]
[null,"Taxes",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!J161","v":0},0]
[null,"Total",{"$f":"SUM(C43:C51)","v":0},{"$f":"SUM(D43:D51)","v":0},0,0,{"$f":"IF(AND(C52>0,C$80>0),+C52/C$80,0)","v":0},null,{"$f":"SUM(I43:I51)","v":0},0,{"$f":"IF(AND(I52>0,I$80>0),+I52/I$80,0)","v":0}]
[null,"Transportation/Travel"]
[null,"Mileage Reimbursement",null,null,{"$f":"+D54-C54","v":0},{"$f":"IF(+C54+D54=0,0,(IF(AND(+C54=0,D54>0),1,(IF(AND(+C54>0,D54=0),-1,+C54/+D54-1)))))","v":0},null,null,{"$f":"+'Provider Total Budget by Serv'!J168","v":0},{"$f":"IF(I54+C54=0,0,(IF(AND(I54=0,C54>0),-1,(IF(AND(I54>0,C54=0),1,+I54/C54-1)))))","v":0}]
[null,"Delivery",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!J173","v":0},0]
[null,"Gas & Oil",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!J178","v":0},0]
[null,"Repairs",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!J183","v":0},0]
[null,"Insurance",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!J188","v":0},0]
[null,"Depreciation/Lease",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!J193","v":0},0]
[null,"Interest",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!J198","v":0},0]
[null,"Tags & Licenses",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!J203","v":0},0]
[null,"Total",{"$f":"SUM(C54:C61)","v":0},{"$f":"SUM(D54:D61)","v":0},0,0,{"$f":"IF(AND(C62>0,C$80>0),+C62/C$80,0)","v":0},null,{"$f":"SUM(I54:I61)","v":0},0,{"$f":"IF(AND(I62>0,I$80>0),+I62/I$80,0)","v":0}]
[null,"Administrative & General"]
[null,"Advertising",null,null,{"$f":"+D64-C64","v":0},{"$f":"IF(+C64+D64=0,0,(IF(AND(+C64=0,D64>0),1,(IF(AND(+C64>0,D64=0),-1,+C64/+D64-1)))))","v":0},null,null,{"$f":"+'Provider Total Budget by Serv'!J210","v":0},{"$f":"IF(I64+C64=0,0,(IF(AND(I64=0,C64>0),-1,(IF(AND(I64>0,C64=0),1,+I64/C64-1)))))","v":0}]
[null,"Printing",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!J215","v":0},0]
[null,"Copying",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!J220","v":0},0]
[null,"Office Supplies",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!J225","v":0},0]
[null,"Contractual Agreements",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!J230","v":0},0]
[null,"Postage",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!J235","v":0},0]
[null,"Telecommunications",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!J240","v":0},0]
[null,"Liability Insurance",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!J245","v":0},0]
[null,"Legal Fees",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!J250","v":0},0]
[null,"Accounting Fees",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!J255","v":0},0]
[null,"Consulting Fees",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!J260","v":0},0]
[null,"Other Fees (Explain)",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!J265","v":0},0]
[null,"Audit",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!J270","v":0},0]
[null,"Other Misc. (Explain)",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!J275","v":0},0]
[null,"Total",{"$f":"SUM(C64:C77)","v":0},{"$f":"SUM(D64:D77)","v":0},0,0,{"$f":"IF(AND(C78>0,C$80>0),+C78/C$80,0)","v":0},null,{"$f":"SUM(I64:I77)","v":0},0,{"$f":"IF(AND(I78>0,I$80>0),+I78/I$80,0)","v":0}]
[null,"Total"]
[null,"Total of all Cost Areas",{"$f":"+C16+C22+C27+C35+C41+C52+C62+C78","v":0},{"$f":"+D16+D22+D27+D35+D41+D52+D62+D78","v":0},{"$f":"+D80-C80","v":0},{"$f":"IF(+C80+D80=0,0,(IF(AND(+C80=0,D80>0),1,(IF(AND(+C80>0,D80=0),-1,+C80/+D80-1)))))","v":0},{"$f":"IF(AND(C80>0,C$80>0),+C80/C$80,0)","v":0},null,{"$f":"+I16+I27+I41+I52+I62+I78+I22+I35","v":0},{"$f":"IF(I80+C80=0,0,(IF(AND(I80=0,C80>0),-1,(IF(AND(I80>0,C80=0),1,+I80/C80-1)))))","v":0},{"$f":"IF(AND(I80>0,I$80>0),+I80/I$80,0)","v":0}]
[null,"Total Number Units",null,null,{"$f":"+D81-C81","v":0},{"$f":"IF(+C81+D81=0,0,(IF(AND(+C81=0,D81>0),1,(IF(AND(+C81>0,D81=0),-1,+D81/+C81-1)))))","v":0},null,null," ",null," "]
[null,"Whole Cost per Unit",{"$f":"IF(C81=0,0,+C80/C81)","v":0},{"$f":"IF(D81=0,0,+D80/D81)","v":0},{"$f":"IF(E81=0,0,+E80/E81)","v":0},{"$f":"IF(+C82+D82=0,0,(IF(AND(+C82=0,D82>0),1,(IF(AND(+C82>0,D82=0),-1,+D82/+C82-1)))))","v":0},null,null,"Budgeted  Units",null,"Budgeted Cost per Unit"]
[null,"Approved Unit Rate",null,null,null,null,null,null,{"$f":"+C101","v":0},null,{"$f":"IF(I83=0,\"\",+I80/I83)","v":""}]
[]
[]
[]
[]
[]
[null,"Funding Source","Proposed Units",null,null,"Calculated Rate",null,"Revenue"]
[null,"HHS OAAA - 10 % Match Required",null,null,null,{"$f":"IF(C90=0,0,'Unit Rate Calculation PA'!L24)","v":0},null,{"$f":"+C90*F90","v":0}]
[null,"HHS OAAA - 25 % Match Required",null,null,null,{"$f":"IF(C91=0,0,'Unit Rate Calculation PA'!$L$31)","v":0},null,{"$f":"+C91*F91","v":0}]
[null,"HHS OAAA - Full Unit Rate ",null,null,null,{"$f":"IF(C92=0,0,'Unit Rate Calculation PA'!$L$16)","v":0},null,0]
[null,"Program Income ",null,null,null,{"$f":"IF(C93=0,0,'Unit Rate Calculation PA'!$L$16)","v":0},null,0]
[null,"Local Funds ",null,null,null,{"$f":"IF(C94=0,0,'Unit Rate Calculation PA'!$L$16)","v":0},null,0]
[null,"Other Funds ",null,null,null,{"$f":"IF(C95=0,0,'Unit Rate Calculation PA'!$L$16)","v":0},null,0]
[null,"Local Funds - Required Match 10%","NA",null,null,{"$f":"IF(C96=0,0,'Unit Rate Calculation PA'!$L$23)","v":0},null,{"$f":"+C90*F96","v":0}]
[null,"Local Funds - Required Match 25%","NA",null,null,{"$f":"IF(C97=0,0,'Unit Rate Calculation PA'!$L$30)","v":0},null,{"$f":"+C91*F97","v":0}]
[null,"Other Sources 6",null,null,null,{"$f":"IF(C98=0,0,'Unit Rate Calculation PA'!$L$16)","v":0},null,0]
[null,"Other Sources 7",null,null,null,{"$f":"IF(C99=0,0,'Unit Rate Calculation PA'!$L$16)","v":0},null,0]
[null,"Other Sources 8",null,null,null,{"$f":"IF(C100=0,0,'Unit Rate Calculation PA'!$L$16)","v":0},null,0]
[null,"Total Units by Funding Source",{"$f":"SUM(C90:C100)","v":0},null,null,null,null,{"$f":"SUM(H90:I100)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Revenue"]

{"sheet":"Unit Rate Calculation PA","index":13,"n_rows":111,"n_cols":12,"rows_kept":111,"cut":false,"hidden":false,"merged":[[1,4,1,8],[51,3,51,5],[51,7,51,10],[23,2,23,5],[21,2,21,7],[22,2,22,5],[48,3,48,5],[17,2,17,11],[13,2,13,11],[10,2,10,3],[12,2,12,11],[48,7,48,10],[47,3,47,5],[47,7,47,10],[30,2,30,5],[29,2,29,5],[101,3,101,9],[52,3,52,5],[52,7,52,10],[54,7,54,10],[55,3,55,5],[55,7,55,10],[59,7,59,10],[58,3,58,5],[58,7,58,10],[59,3,59,5],[54,3,54,5],[0,3,0,4],[2,4,2,9],[19,2,19,11],[28,2,28,7],[16,2,16,11],[3,2,3,11],[5,2,5,11],[6,2,6,9],[4,2,4,11],[7,2,7,11],[8,2,8,11],[9,2,9,3],[11,2,11,3],[15,2,15,9],[14,2,14,11],[10,9,10,11]]}
[null,null,null,{"$f":"NOW()","v":"2020-07-23T18:20:44.220"}]
[null,null,null,"Provider Name: ",{"$f":"+'Provider Information'!F6","v":0}]
[null,null,null,"AAA Name:",{"$f":"+'Provider Information'!D21","v":0}]
[null,null,{"$f":"+'Provider Total Budget by Serv'!J4","v":"Participant Assessment"}]
[null,null,"BUDGET WORKSHEET CALCULATION OF THE UNIT RATE"]
[]
[null,null,"1.Total Budgeted Expenses for Contract Year ",null,null,null,null,null,null,null,"1.",{"$f":"+'Participant Assessment Budget'!I80","v":0}]
[]
[null,null,"2.Total Number of Anticipated Units to be Provided "]
[null,null,{"$f":"+'Participant Assessment Budget'!B90","v":"HHS OAAA - 10 % Match Required"},null,{"$f":"+'Participant Assessment Budget'!C90","v":0},{"$f":"+'Participant Assessment Budget'!B93","v":"Program Income "},{"$f":"+'Participant Assessment Budget'!C93","v":0},{"$f":"+'Participant Assessment Budget'!B98","v":"Other Sources 6"},{"$f":"+'Participant Assessment Budget'!C98","v":0}]
[null,null,{"$f":"+'Participant Assessment Budget'!B91","v":"HHS OAAA - 25 % Match Required"},null,{"$f":"+'Participant Assessment Budget'!C91","v":0},{"$f":"+'Participant Assessment Budget'!B94","v":"Local Funds "},{"$f":"+'Participant Assessment Budget'!C94","v":0},{"$f":"+'Participant Assessment Budget'!B99","v":"Other Sources 7"},{"$f":"+'Participant Assessment Budget'!C99","v":0}]
[null,null,{"$f":"+'Participant Assessment Budget'!B92","v":"HHS OAAA - Full Unit Rate "},null,{"$f":"+'Participant Assessment Budget'!C92","v":0},{"$f":"+'Participant Assessment Budget'!B95","v":"Other Funds "},{"$f":"+'Participant Assessment Budget'!C95","v":0},{"$f":"+'Participant Assessment Budget'!B100","v":"Other Sources 8"},{"$f":"+'Participant Assessment Budget'!C100","v":0},null,"2.",{"$f":"+E10+E11+E12+G10+G11+G12+I10+I11+I12","v":0}]
[]
[]
[]
[null,null,"3. Cost per unit (Line 1 divided by Line 2) - Full Unit Rate",null,null,null,null,null,null,null,"3.",{"$f":"ROUND(IF(L12=0,0,+L7/L12),2)","v":0}]
[]
[null,null,"Reimbursement Calculation for Contracts Requiring Unit Rate Match Reduction"]
[]
[]
[null,null,"4. Mandatory Local Match of",null,0.1,null,null,null,{"$f":"ROUND(IF(L16=\"\",\"\",+L16*E21),2)","v":0}]
[null,null,"**  If Applicable, Match Reduction  From the In-kind Match  Certification form",null,null,null,null,null,{"$f":"ROUND(-J111,2)","v":0}]
[null,null,"    Required Match",null,null,null,null,null,null,null,"4.",{"$f":"IF(+I21=\"\",0,+I21+I22)","v":0}]
[null,null,"5.Full Unit Rate Less Required Match (Line 3 minus Line 4)",null,null,null,null,null,null,null,"5.",{"$f":"ROUND(IF(L16>0,L16-L23,0),2)","v":0}]
[]
[]
[]
[null,null,"4. Mandatory Local Match of",null,0.25,null,null,null,{"$f":"ROUND(IF(L16=\"\",\"\",+L16*E28),2)","v":0}]
[null,null,"**  If Applicable, Match Reduction  From the In-kind Match  Certification form",null,null,null,null,null,{"$f":"ROUND(-J111,2)","v":0}]
[null,null,"    Required Match",null,null,null,null,null,null,null,"4.",{"$f":"IF(+I28=\"\",0,+I28+I29)","v":0}]
[null,null,"5.Full Unit Rate Less Required Match (Line 3 minus Line 4)",null,null,null,null,null,null,null,"5.",{"$f":"ROUND(IF(L16>0,L16-L30,0),2)","v":0}]
[]
[]
[]
[null,null,"**If any portion of the required match is in-kind, you must complete an In-Kind Match Certification form. "]
[]
[]
[]
[null,null,"Contract Reimbursed at Full Cost Per Unit Rate. Match Requirements Will Be Met Through Provision of Additional Units"]
[]
[null,null,null,{"$f":"+L16","v":0}]
[null,null,null,null,null,"Contractor Initial",null,"AAA Initial"]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"IF('Participant Assessment Budget'!C2=0,\"\",'Participant Assessment Budget'!C2)","v":""},null,null,null,{"$f":"IF('Participant Assessment Budget'!C3=0,\"\",'Participant Assessment Budget'!C3)","v":""}]
[null,null,null,"Legal Name of Contracted Provider",null,null,null,"Name of Area Agency on Aging"]
[]
[]
[]
[null,null,null,"Signature",null,null,null,"Signature"]
[]
[null,null,null,{"$f":"'Provider Information'!$F$13","v":0},null,null,null,{"$f":"'Provider Information'!$D$22","v":0}]
[null,null,null,"Printed/Typed Name of Signer",null,null,null,"Printed/Typed Name of Signer"]
[]
[]
[]
[null,null,null,"Date",null,null,null,"Date"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Calculation of In-Kind Value"]
[null,null,null,"1. Required Match Rate",null,null,null,null,null,{"$f":"+I21","v":0}]
[null,null,null,"2. TDoA units",null,null,null,null,null,{"$f":"IF(E10=0,L12,+E10)","v":0}]
[null,null,null,"3. Required Match Rate (1) Multiplied by the anticipated number of TDoA units (2)",null,null,null,null,null,{"$f":"+J103*J104","v":0}]
[null,null,null,"4. Total Valuation from the In-Kind Certification",null,null,null,null,null,{"$f":"+'In-Kind Certification PA'!G25","v":0}]
[null,null,null,"5. Balance of Required Match (3-4)",null,null,null,null,null,{"$f":"+J105-J106","v":0}]
[null,null,null,"6. TDoA units + DHS units",null,null,null,null,null,{"$f":"IF(+E10=0,L12,+E10)","v":0}]
[null,null,null,"7. Balance of Required Match (5) Divided by TDoA units (6)",null,null,null,null,null,{"$f":"IF(J107=0,0,+J107/J108)","v":0}]
[null,null,null,"8. Required Match Rate",null,null,null,null,null,{"$f":"+I21","v":0}]
[null,null,null,"9. Reduced Required Match If (8) is equal to or less than 0 this will equal (8) or else (8-7)",null,null,null,null,null,{"$f":"IF(+J109<=0,+J110,+J110-J109)","v":0}]

{"sheet":"Certification PA","index":14,"n_rows":46,"n_cols":7,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,2,0,3],[1,3,1,7],[39,2,39,4],[39,6,39,9],[38,2,38,4],[34,2,34,4],[34,6,34,9],[3,1,3,10],[38,6,38,9],[5,1,5,4],[5,6,5,10],[4,1,4,10],[35,2,35,4],[35,6,35,9],[2,3,2,8]]}
[null,null,{"$f":"NOW()","v":"2020-07-23T18:20:44.220"}]
[null,null,"Provider Name: ",{"$f":"+'Provider Information'!F6","v":0}]
[null,null,"AAA Name:",{"$f":"+'Provider Information'!D21","v":0}]
[null,{"$f":"+'Provider Total Budget by Serv'!J4","v":"Participant Assessment"}]
[null,"BUDGET WORKSHEET CERTIFICATION"]
[]
[null,"        AS SIGNER OF THIS BUDGET WORKSHEET, I HEREBY CERTIFY THAT:"]
[]
[null,"·","I have read the note below and the instructions applicable to this budget worksheet."]
[]
[null,"·","I have reviewed this budget worksheet after its preparation."]
[]
[null,"·","To the best of my knowledge and belief, this budget worksheet is true, correct and"]
[null," ","complete, and was prepared in accordance with the instructions applicable to this"]
[null," ","budget worksheet."]
[]
[null,"·","This budget worksheet was prepared from the books and records of the contracted"]
[null," ","provider."]
[]
[null,"·","I acknowledge that all books and records related to this rate setting process are"]
[null," ","subject to audit in accordance with contract requirements and all applicable federal "]
[null,null,"and state laws."]
[]
[]
[null,"    Note: ","The person legally responsible for the conduct of the contracted provider must"]
[null,null,"sign this Budget Worksheet Certification.  If a sole proprietor, the owner"]
[null,null,"must sign the Budget Worksheet Certification.  If a partnership, a partner must "]
[null,null,"sign the Budget Worksheet Certification.  If a corporation, the person authorized by the "]
[null,null,"Board of Directors Resolution must sign the Budget Worksheet Certification.  "]
[null,null,"Misrepresentation of information contained in the budget worksheet may result in "]
[null,null,"adverse action, up to and including contract termination.  Furthermore, falsification of "]
[null,null,"information in the budget worksheet may result in a referral for prosecution."]
[]
[]
[null,null,{"$f":"+'Participant Assessment Budget'!C2","v":0},null,null,null,{"$f":"'Provider Information'!$F$13","v":0}]
[null,null,"Name of Contracted Provider",null,null,null,"Printed/Typed Name of Signer"]
[]
[]
[]
[null,null,"Date",null,null,null,"Signature"]
[]
[]
[]
[null,null,"Signer Authority:",null,"Sole Proprietor",null,"Association Officer"]
[null,null,"    (check one)",null,"Partner",null,"Board Member"]
[null,null,null,null,"Corporate Officer",null,"Governmental Official           "]

{"sheet":"In-Kind Certification PA","index":15,"n_rows":48,"n_cols":7,"rows_kept":48,"cut":false,"hidden":false,"merged":[[46,5,46,6],[46,1,46,3],[43,5,43,6],[43,1,43,3],[18,1,18,4],[19,1,19,4],[49,1,49,7],[47,1,47,3],[47,5,47,6],[4,2,4,4],[6,1,6,2],[44,1,44,3],[44,5,44,6],[26,2,26,5],[31,3,31,6],[17,1,17,4],[12,1,12,4],[6,3,6,4],[20,1,20,4],[13,1,13,4],[14,1,14,4],[15,1,15,4],[0,2,0,3],[1,3,1,6],[33,9,33,13],[34,3,34,6],[21,1,21,4],[22,1,22,4],[23,1,23,4],[24,1,24,4],[2,1,2,6],[3,1,3,6],[8,1,8,6],[11,1,11,4],[16,1,16,4]]}
[null,null,{"$f":"NOW()","v":"2020-07-23T18:20:44.220"}]
[null,null,"AAA Name:",{"$f":"+'Provider Information'!D21","v":0}]
[null,{"$f":"+'Provider Total Budget by Serv'!J4","v":"Participant Assessment"}]
[null,"IN-KIND MATCH CERTIFICATION"]
[null,"Provider: ",{"$f":"IF(ISBLANK('Provider Information'!F6),\"\",+'Provider Information'!F6)","v":""}]
[]
[null,"In-kind Contribution(s):",null,{"$f":"+G25","v":0}]
[]
[null,"For any item identified below, the provider must maintain monthly supporting documentation."]
[]
[]
[null,"ITEM",null,null,null,"DATE OF RECEIPT","VALUE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"TOTAL",{"$f":"SUM(G13:G24)","v":0}]
[]
[null,"Note:","All contributions must meet the requirements of IRS Publication 561  \nhttp://www.irs.gov/pub/irs-pdf/p561.pdf"]
[]
[null,"Examples of Documentation Include:"]
[]
[null,"Rent:","1.","Letter of Agreement with Owner"]
[null,null,"2.","Adequate Valuation of Property on a Current Basis (this should be reviewed at least every two years and if senior center, based on property value and center participation)"]
[]
[null,"Labor:","1.","Minimum wage"]
[null,null,"2.","Documented prevailing wage in the Area. For prevailing wage information visit the Texas Workforce Commission’s website at  http://www.tracer2.com/."]
[]
[]
[null,"All in-kind labor must be required for the service to be provided.  If you would not hire someone to perform the labor if it "]
[null,"were not in-kind then you cannot count it."]
[]
[null,"Utilities: ","1.","Copy of Bill"]
[null,null,"2.","Agreement of Amount Paid if Partial"]
[]
[null,{"$f":"+'Participant Assessment Budget'!C2","v":0},null,null,null,{"$f":"'Provider Information'!$F$13","v":0}]
[null,"        Name of Contracted Provider",null,null,null,"Printed/Typed Name of Signer"]
[]
[]
[null,"Date",null,null,null,"Signature"]

{"sheet":"Transportation Budget","index":16,"n_rows":98,"n_cols":14,"rows_kept":98,"cut":false,"hidden":false,"merged":[[11,12,11,13],[7,8,7,10],[81,12,81,13],[1,7,3,7],[1,8,3,13],[12,8,12,10],[79,12,79,13],[78,12,78,13],[63,12,77,13],[8,9,11,9],[8,10,11,10],[52,12,52,13],[62,12,62,13],[53,12,61,13],[0,14,80,14],[5,12,6,13],[7,12,7,13],[16,12,16,13],[13,12,15,13],[80,12,80,13],[42,12,51,13],[35,12,35,13],[28,12,34,13],[36,12,40,13],[22,12,22,13],[0,1,0,13],[22,1,22,6],[27,1,27,6],[4,8,4,10],[5,8,6,10],[35,1,35,6],[41,1,41,6],[17,12,21,13],[23,12,26,13],[8,4,11,4],[8,5,11,5],[8,6,11,6],[12,1,12,6],[16,1,16,6],[8,1,11,1],[8,2,11,2],[8,3,11,3],[41,12,41,13],[12,12,12,13],[27,12,27,13],[8,8,11,8],[52,1,52,6],[80,8,80,10],[97,1,97,5],[94,1,94,5],[96,1,96,5],[93,1,93,5],[95,1,95,5],[91,1,91,5],[92,1,92,5],[62,1,62,6],[78,1,78,6],[82,12,82,13],[90,1,90,5],[89,1,89,5],[88,1,88,5],[86,1,86,5],[85,1,85,5],[87,1,87,5],[1,2,1,6],[2,2,2,6],[3,2,3,6],[7,1,7,6],[4,1,4,2],[4,3,4,4],[4,5,4,6],[5,1,6,1],[5,2,6,2],[5,3,6,6]]}
[null,{"$f":"+'Provider Total Budget by Serv'!K4","v":"Transportation"}]
[null,"Provider Name: ",{"$f":"'Provider Information'!$F$6","v":0},null,null,null,null,null,"Review of Most Recent Completed Year Approved Budget to Actual Year End Expense and Current Proposed Budget"]
[null,"AAA Name:",{"$f":"+'Provider Information'!D21","v":0}]
[]
[null,null,null,{"$f":"NOW()","v":"2020-07-23T18:20:44.220"}]
[null,"Most Recent Completed Budget Year",2018,null,null,null,null,null," Proposed Budget",null,null,null,"Explanation of Variances"]
[]
[]
[null,"Cost Area"," Expense per General Ledger","Approved Budget ","Variance\nBudget\nminus\nExpenses","Percentage of Variance","Percentage of Unit Cost",null,"Proposed Budget ","Percentage Variance - Prior Year Actual to Proposed Budget","Percentage of Unit Cost",null,"Inflation Factor 2018 to 2019",1.022E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,"Inflation Factor 2019 to 2020",1.0211E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,"Combined Inflation Factor",{"$f":"SUM(N9:N10)","v":2.0430999999999998E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,"1. An explanation of variance must be provided for each cost area where the expenses per General Ledger varies from the approved budget for the most recent completed year  by 10% or more; and\n 2. An explanation of variance must be provided for each cost area where the proposed budget amount exceeds the prior year actual amount by more than the two year combined inflation factor."]
[null,"Personnel"]
[null,"Salaries, PR Taxes & Benefits",null,null,{"$f":"+D14-C14","v":0},{"$f":"IF(+C14+D14=0,0,(IF(AND(+C14=0,D14>0),1,(IF(AND(+C14>0,D14=0),-1,+C14/+D14-1)))))","v":0},null,null,{"$f":"+'Provider Total Budget by Serv'!K17+'Provider Total Budget by Serv'!K29","v":0},{"$f":"IF(I14+C14=0,0,(IF(AND(I14=0,C14>0),-1,(IF(AND(I14>0,C14=0),1,+I14/C14-1)))))","v":0}]
[null,"Contract staff, Compensation",null,null,{"$f":"+D15-C15","v":0},{"$f":"IF(+C15+D15=0,0,(IF(AND(+C15=0,D15>0),1,(IF(AND(+C15>0,D15=0),-1,+C15/+D15-1)))))","v":0},null,null,{"$f":"+'Provider Total Budget by Serv'!K36","v":0},{"$f":"IF(I15+C15=0,0,(IF(AND(I15=0,C15>0),-1,(IF(AND(I15>0,C15=0),1,+I15/C15-1)))))","v":0}]
[null,"Total",{"$f":"SUM(C14:C15)","v":0},{"$f":"SUM(D14:D15)","v":0},{"$f":"+D16-C16","v":0},0,{"$f":"IF(AND(C16>0,C$80>0),+C16/C$80,0)","v":0},null,{"$f":"SUM(I14:I15)","v":0},{"$f":"IF(I16+C16=0,0,(IF(AND(I16=0,C16>0),-1,(IF(AND(I16>0,C16=0),1,+I16/C16-1)))))","v":0},{"$f":"IF(AND(I16>0,I$80>0),+I16/I$80,0)","v":0}]
[null,"Nutrition Education"]
[null,"Salaries, PR Taxes & Benefits",null,null,{"$f":"+D18-C18","v":0},{"$f":"IF(+C18+D18=0,0,(IF(AND(+C18=0,D18>0),1,(IF(AND(+C18>0,D18=0),-1,+C18/+D18-1)))))","v":0}]
[null,"Contract staff, Compensation",null,null,{"$f":"+D19-C19","v":0},0]
[null,"Materials",null,null,{"$f":"+D20-C20","v":0},0]
[null,"Conference",null,null,{"$f":"+D21-C21","v":0},0]
[null,"Total",{"$f":"SUM(C18:C21)","v":0},{"$f":"SUM(D18:D21)","v":0},{"$f":"+D22-C22","v":0},0,{"$f":"IF(AND(C22>0,C$80>0),+C22/C$80,0)","v":0},null,{"$f":"SUM(I18:I21)","v":0},null,{"$f":"IF(AND(I22>0,I$80>0),+I22/I$80,0)","v":0}]
[null,"Professional Development"]
[null,"Conference",null,null,{"$f":"+D24-C24","v":0},{"$f":"IF(+C24+D24=0,0,(IF(AND(+C24=0,D24>0),1,(IF(AND(+C24>0,D24=0),-1,+C24/+D24-1)))))","v":0},null,null,{"$f":"+'Provider Total Budget by Serv'!K43","v":0},{"$f":"IF(I24+C24=0,0,(IF(AND(I24=0,C24>0),-1,(IF(AND(I24>0,C24=0),1,+I24/C24-1)))))","v":0}]
[null,"Dues",null,null,{"$f":"+D25-C25","v":0},0,null,null,{"$f":"+'Provider Total Budget by Serv'!K48","v":0},{"$f":"IF(I25+C25=0,0,(IF(AND(I25=0,C25>0),-1,(IF(AND(I25>0,C25=0),1,+I25/C25-1)))))","v":0}]
[null,"Materials",null,null,{"$f":"+D26-C26","v":0},0,null,null,{"$f":"+'Provider Total Budget by Serv'!K53","v":0},{"$f":"IF(I26+C26=0,0,(IF(AND(I26=0,C26>0),-1,(IF(AND(I26>0,C26=0),1,+I26/C26-1)))))","v":0}]
[null,"Total",{"$f":"SUM(C24:C26)","v":0},{"$f":"SUM(D24:D26)","v":0},{"$f":"+D27-C27","v":0},0,{"$f":"IF(AND(C27>0,C$80>0),+C27/C$80,0)","v":0},null,{"$f":"SUM(I24:I26)","v":0},{"$f":"IF(I27+C27=0,0,(IF(AND(I27=0,C27>0),-1,(IF(AND(I27>0,C27=0),1,+I27/C27-1)))))","v":0},{"$f":"IF(AND(I27>0,I$80>0),+I27/I$80,0)","v":0}]
[null,"Meals/Food"]
[null,"Raw Food",null,null,{"$f":"+D29-C29","v":0},{"$f":"IF(+C29+D29=0,0,(IF(AND(+C29=0,D29>0),1,(IF(AND(+C29>0,D29=0),-1,+C29/+D29-1)))))","v":0},null,null,{"$f":"+'Provider Total Budget by Serv'!K61","v":0},{"$f":"IF(I29+C29=0,0,(IF(AND(I29=0,C29>0),-1,(IF(AND(I29>0,C29=0),1,+I29/C29-1)))))","v":0}]
[null,"Purchased Meals",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!K68","v":0},0]
[null,"Freight",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!K73","v":0},0]
[null,"Storage",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!K78","v":0},0]
[null,"Consumables",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!K87","v":0},0]
[null,"Other",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!K92","v":0},0]
[null,"Total",{"$f":"SUM(C29:C34)","v":0},{"$f":"SUM(D29:D34)","v":0},0,0,{"$f":"IF(AND(C35>0,C$80>0),+C35/C$80,0)","v":0},null,{"$f":"SUM(I29:I34)","v":0},0,{"$f":"IF(AND(I35>0,I$80>0),+I35/I$80,0)","v":0}]
[null,"Equipment"]
[null,"Depreciation",null,null,{"$f":"+D37-C37","v":0},{"$f":"IF(+C37+D37=0,0,(IF(AND(+C37=0,D37>0),1,(IF(AND(+C37>0,D37=0),-1,+C37/+D37-1)))))","v":0},null,null,{"$f":"+'Provider Total Budget by Serv'!K99","v":0},{"$f":"IF(I37+C37=0,0,(IF(AND(I37=0,C37>0),-1,(IF(AND(I37>0,C37=0),1,+I37/C37-1)))))","v":0}]
[null,"Interest",null,null,{"$f":"+D38-C38","v":0},0,null,null,{"$f":"+'Provider Total Budget by Serv'!K104","v":0},{"$f":"IF(I38+C38=0,0,(IF(AND(I38=0,C38>0),-1,(IF(AND(I38>0,C38=0),1,+I38/C38-1)))))","v":0}]
[null,"Leasing",null,null,{"$f":"+D39-C39","v":0},0,null,null,{"$f":"+'Provider Total Budget by Serv'!K109","v":0},{"$f":"IF(I39+C39=0,0,(IF(AND(I39=0,C39>0),-1,(IF(AND(I39>0,C39=0),1,+I39/C39-1)))))","v":0}]
[null,"Maintenance",null,null,{"$f":"+D40-C40","v":0},0,null,null,{"$f":"+'Provider Total Budget by Serv'!K114","v":0},{"$f":"IF(I40+C40=0,0,(IF(AND(I40=0,C40>0),-1,(IF(AND(I40>0,C40=0),1,+I40/C40-1)))))","v":0}]
[null,"Total",{"$f":"SUM(C37:C40)","v":0},{"$f":"SUM(D37:D40)","v":0},{"$f":"+D41-C41","v":0},0,{"$f":"IF(AND(C41>0,C$80>0),+C41/C$80,0)","v":0},null,{"$f":"SUM(I37:I40)","v":0},{"$f":"IF(I41+C41=0,0,(IF(AND(I41=0,C41>0),-1,(IF(AND(I41>0,C41=0),1,+I41/C41-1)))))","v":0},{"$f":"IF(AND(I41>0,I$80>0),+I41/I$80,0)","v":0}]
[null,"Occupancy/Building"]
[null,"Rent",null,null,{"$f":"+D43-C43","v":0},{"$f":"IF(+C43+D43=0,0,(IF(AND(+C43=0,D43>0),1,(IF(AND(+C43>0,D43=0),-1,+C43/+D43-1)))))","v":0},null,null,{"$f":"+'Provider Total Budget by Serv'!K121","v":0},{"$f":"IF(I43+C43=0,0,(IF(AND(I43=0,C43>0),-1,(IF(AND(I43>0,C43=0),1,+I43/C43-1)))))","v":0}]
[null,"Utilities",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!K126","v":0},0]
[null,"Depreciation",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!K131","v":0},0]
[null,"Mortgage Interest",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!K136","v":0},0]
[null,"Insurance",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!K141","v":0},0]
[null,"Security",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!K146","v":0},0]
[null,"Janitorial",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!K151","v":0},0]
[null,"Repair",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!K156","v":0},0]
[null,"Taxes",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!K161","v":0},0]
[null,"Total",{"$f":"SUM(C43:C51)","v":0},{"$f":"SUM(D43:D51)","v":0},0,0,{"$f":"IF(AND(C52>0,C$80>0),+C52/C$80,0)","v":0},null,{"$f":"SUM(I43:I51)","v":0},0,{"$f":"IF(AND(I52>0,I$80>0),+I52/I$80,0)","v":0}]
[null,"Transportation/Travel"]
[null,"Mileage Reimbursement",null,null,{"$f":"+D54-C54","v":0},{"$f":"IF(+C54+D54=0,0,(IF(AND(+C54=0,D54>0),1,(IF(AND(+C54>0,D54=0),-1,+C54/+D54-1)))))","v":0},null,null,{"$f":"+'Provider Total Budget by Serv'!K168","v":0},{"$f":"IF(I54+C54=0,0,(IF(AND(I54=0,C54>0),-1,(IF(AND(I54>0,C54=0),1,+I54/C54-1)))))","v":0}]
[null,"Delivery",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!K173","v":0},0]
[null,"Gas & Oil",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!K178","v":0},0]
[null,"Repairs",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!K183","v":0},0]
[null,"Insurance",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!K188","v":0},0]
[null,"Depreciation/Lease",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!K193","v":0},0]
[null,"Interest",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!K198","v":0},0]
[null,"Tags & Licenses",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!K203","v":0},0]
[null,"Total",{"$f":"SUM(C54:C61)","v":0},{"$f":"SUM(D54:D61)","v":0},0,0,{"$f":"IF(AND(C62>0,C$80>0),+C62/C$80,0)","v":0},null,{"$f":"SUM(I54:I61)","v":0},0,{"$f":"IF(AND(I62>0,I$80>0),+I62/I$80,0)","v":0}]
[null,"Administrative & General"]
[null,"Advertising",null,null,{"$f":"+D64-C64","v":0},{"$f":"IF(+C64+D64=0,0,(IF(AND(+C64=0,D64>0),1,(IF(AND(+C64>0,D64=0),-1,+C64/+D64-1)))))","v":0},null,null,{"$f":"+'Provider Total Budget by Serv'!K210","v":0},{"$f":"IF(I64+C64=0,0,(IF(AND(I64=0,C64>0),-1,(IF(AND(I64>0,C64=0),1,+I64/C64-1)))))","v":0}]
[null,"Printing",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!K215","v":0},0]
[null,"Copying",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!K220","v":0},0]
[null,"Office Supplies",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!K225","v":0},0]
[null,"Contractual Agreements",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!K230","v":0},0]
[null,"Postage",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!K235","v":0},0]
[null,"Telecommunications",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!K240","v":0},0]
[null,"Liability Insurance",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!K245","v":0},0]
[null,"Legal Fees",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!K250","v":0},0]
[null,"Accounting Fees",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!K255","v":0},0]
[null,"Consulting Fees",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!K260","v":0},0]
[null,"Other Fees (Explain)",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!K265","v":0},0]
[null,"Audit",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!K270","v":0},0]
[null,"Other Misc. (Explain)",null,null,0,0,null,null,{"$f":"+'Provider Total Budget by Serv'!K275","v":0},0]
[null,"Total",{"$f":"SUM(C64:C77)","v":0},{"$f":"SUM(D64:D77)","v":0},0,0,{"$f":"IF(AND(C78>0,C$80>0),+C78/C$80,0)","v":0},null,{"$f":"SUM(I64:I77)","v":0},0,{"$f":"IF(AND(I78>0,I$80>0),+I78/I$80,0)","v":0}]
[null,"Total"]
[null,"Total of all Cost Areas",{"$f":"+C16+C22+C27+C35+C41+C52+C62+C78","v":0},{"$f":"+D16+D22+D27+D35+D41+D52+D62+D78","v":0},{"$f":"+D80-C80","v":0},{"$f":"IF(+C80+D80=0,0,(IF(AND(+C80=0,D80>0),1,(IF(AND(+C80>0,D80=0),-1,+C80/+D80-1)))))","v":0},{"$f":"IF(AND(C80>0,C$80>0),+C80/C$80,0)","v":0},null,{"$f":"+I16+I27+I41+I52+I62+I78+I22+I35","v":0},{"$f":"IF(I80+C80=0,0,(IF(AND(I80=0,C80>0),-1,(IF(AND(I80>0,C80=0),1,+I80/C80-1)))))","v":0},{"$f":"IF(AND(I80>0,I$80>0),+I80/I$80,0)","v":0}]
[null,"Total Number One Way Trips",null,null,{"$f":"+D81-C81","v":0},{"$f":"IF(+C81+D81=0,0,(IF(AND(+C81=0,D81>0),1,(IF(AND(+C81>0,D81=0),-1,+D81/+C81-1)))))","v":0}]
[null,"Whole Cost per Trip",{"$f":"IF(C81=0,0,+C80/C81)","v":0},{"$f":"IF(D81=0,0,+D80/D81)","v":0},{"$f":"IF(E81=0,0,+E80/E81)","v":0},{"$f":"IF(+C82+D82=0,0,(IF(AND(+C82=0,D82>0),1,(IF(AND(+C82>0,D82=0),-1,+D82/+C82-1)))))","v":0},null,null,"Budgeted  Units",null,"Budgeted Cost per Unit"]
[null,"Approved One Way Trip Unit Rate",null,null,null,null,null,null,{"$f":"+G98","v":0},null,{"$f":"IF(I83=0,\"\",+I80/I83)","v":""}]
[]
[]
[null,"Funding Source",null,null,null,null,"Proposed One Way Trips",null,"Calculated Rate","Revenue"]
[null,"HHS OAAA - 10 % Match Required",null,null,null,null,null,null,{"$f":"IF(G87=0,0,'Unit Rate Calculation Transp'!L24)","v":0},{"$f":"+G87*I87","v":0}]
[null,"HHS OAAA - 25 % Match Required",null,null,null,null,null,null,{"$f":"IF(G88=0,0,'Unit Rate Calculation Transp'!$L$31)","v":0},0]
[null,"HHS OAAA - Full Unit Rate ",null,null,null,null,null,null,{"$f":"IF(G89=0,0,'Unit Rate Calculation Transp'!$L$16)","v":0},0]
[null,"Program Income ",null,null,null,null,null,null,{"$f":"IF(G90=0,0,'Unit Rate Calculation Transp'!$L$16)","v":0},0]
[null,"Local Funds - Eligible Trips",null,null,null,null,null,null,{"$f":"IF(G91=0,0,'Unit Rate Calculation Transp'!$L$16)","v":0},0]
[null,"Other Funds - Non-Eligible Trips",null,null,null,null,null,null,{"$f":"IF(G92=0,0,'Unit Rate Calculation Transp'!$L$16)","v":0},0]
[null,"Local Funds - Required Match 10%",null,null,null,null,"NA",null,{"$f":"IF(G93=0,0,'Unit Rate Calculation Transp'!$L$23)","v":0},{"$f":"+G87*I93","v":0}]
[null,"Local Funds - Required Match 25%",null,null,null,null,"NA",null,{"$f":"IF(G94=0,0,'Unit Rate Calculation Transp'!$L$30)","v":0},{"$f":"+G88*I94","v":0}]
[null,"Other Sources 6",null,null,null,null,null,null,{"$f":"IF(G95=0,0,'Unit Rate Calculation Transp'!$L$16)","v":0},{"$f":"+G95*I95","v":0}]
[null,"Other Sources 7",null,null,null,null,null,null,{"$f":"IF(G96=0,0,'Unit Rate Calculation Transp'!$L$16)","v":0},{"$f":"+G96*I96","v":0}]
[null,"Other Sources 8",null,null,null,null,null,null,{"$f":"IF(G97=0,0,'Unit Rate Calculation Transp'!$L$16)","v":0},{"$f":"+G97*I97","v":0}]
[null,"Total One Way Trips by Funding Source",null,null,null,null,{"$f":"SUM(G87:G97)","v":0},null,"Total Revenue",{"$f":"SUM(J87:J97)","v":0}]

{"sheet":"Unit Rate Calculation Transp","index":17,"n_rows":111,"n_cols":12,"rows_kept":111,"cut":false,"hidden":false,"merged":[[19,2,19,11],[28,2,28,7],[51,3,51,5],[51,7,51,10],[47,7,47,10],[23,2,23,5],[21,2,21,7],[22,2,22,5],[48,3,48,5],[48,7,48,10],[47,3,47,5],[30,2,30,5],[29,2,29,5],[101,3,101,9],[52,3,52,5],[52,7,52,10],[54,7,54,10],[55,3,55,5],[55,7,55,10],[54,3,54,5],[58,3,58,5],[59,3,59,5],[59,7,59,10],[58,7,58,10],[17,2,17,11],[13,2,13,11],[10,2,10,3],[12,2,12,11],[6,2,6,9],[9,2,9,3],[11,2,11,3],[15,2,15,9],[14,2,14,11],[16,2,16,11],[10,9,10,11],[0,3,0,4],[4,2,4,11],[1,4,1,8],[2,4,2,9],[8,2,8,11],[7,2,7,11],[3,2,3,11],[5,2,5,11]]}
[null,null,null,{"$f":"NOW()","v":"2020-07-23T18:20:44.220"}]
[null,null,null,"Provider Name: ",{"$f":"+'Provider Information'!F6","v":0}]
[null,null,null,"AAA Name:",{"$f":"+'Provider Information'!D21","v":0}]
[null,null,{"$f":"+'Provider Total Budget by Serv'!K4","v":"Transportation"}]
[null,null,"BUDGET WORKSHEET CALCULATION OF THE UNIT RATE"]
[]
[null,null,"1.Total Budgeted Expenses for Contract Year ",null,null,null,null,null,null,null,"1.",{"$f":"+'Transportation Budget'!I80","v":0}]
[]
[null,null,"2.Total Number of Anticipated Units to be Provided "]
[null,null,{"$f":"+'Transportation Budget'!B87","v":"HHS OAAA - 10 % Match Required"},null,{"$f":"+'Transportation Budget'!G87","v":0},{"$f":"+'Transportation Budget'!B90","v":"Program Income "},{"$f":"+'Transportation Budget'!G90","v":0},{"$f":"+'Transportation Budget'!B95","v":"Other Sources 6"},{"$f":"+'Transportation Budget'!G95","v":0}]
[null,null,{"$f":"+'Transportation Budget'!B88","v":"HHS OAAA - 25 % Match Required"},null,{"$f":"+'Transportation Budget'!G88","v":0},{"$f":"+'Transportation Budget'!B91","v":"Local Funds - Eligible Trips"},{"$f":"+'Transportation Budget'!G91","v":0},{"$f":"+'Transportation Budget'!B96","v":"Other Sources 7"},{"$f":"+'Transportation Budget'!G96","v":0}]
[null,null,{"$f":"+'Transportation Budget'!B89","v":"HHS OAAA - Full Unit Rate "},null,{"$f":"+'Transportation Budget'!G89","v":0},{"$f":"+'Transportation Budget'!B92","v":"Other Funds - Non-Eligible Trips"},{"$f":"+'Transportation Budget'!G92","v":0},{"$f":"+'Transportation Budget'!B97","v":"Other Sources 8"},{"$f":"+'Transportation Budget'!G97","v":0},null,"2.",{"$f":"+E10+E11+E12+G10+G11+G12+I10+I11+I12","v":0}]
[]
[]
[]
[null,null,"3. Cost per unit (Line 1 divided by Line 2) - Full Unit Rate",null,null,null,null,null,null,null,"3.",{"$f":"ROUND(IF(L12=0,0,+L7/L12),2)","v":0}]
[]
[null,null,"Reimbursement Calculation for Contracts Requiring Unit Rate Match Reduction"]
[]
[]
[null,null,"4. Mandatory Local Match of",null,0.1,null,null,null,{"$f":"ROUND(IF(L16=\"\",\"\",+L16*E21),2)","v":0}]
[null,null,"**  If Applicable, Match Reduction  From the In-kind Match  Certification form",null,null,null,null,null,{"$f":"ROUND(-J111,2)","v":0}]
[null,null,"    Required Match",null,null,null,null,null,null,null,"4.",{"$f":"IF(+I21=\"\",0,+I21+I22)","v":0}]
[null,null,"5.Full Unit Rate Less Required Match (Line 3 minus Line 4)",null,null,null,null,null,null,null,"5.",{"$f":"ROUND(IF(L16>0,L16-L23,0),2)","v":0}]
[]
[]
[]
[null,null,"4. Mandatory Local Match of",null,0.25,null,null,null,{"$f":"ROUND(IF(L16=\"\",\"\",+L16*E28),2)","v":0}]
[null,null,"**  If Applicable, Match Reduction  From the In-kind Match  Certification form",null,null,null,null,null,{"$f":"ROUND(-J111,2)","v":0}]
[null,null,"    Required Match",null,null,null,null,null,null,null,"4.",{"$f":"IF(+I28=\"\",0,+I28+I29)","v":0}]
[null,null,"5.Full Unit Rate Less Required Match (Line 3 minus Line 4)",null,null,null,null,null,null,null,"5.",{"$f":"ROUND(IF(L16>0,L16-L30,0),2)","v":0}]
[]
[]
[]
[null,null,"**If any portion of the required match is in-kind, you must complete an In-Kind Match Certification form. "]
[]
[]
[]
[null,null,"Contract Reimbursed at Full Cost Per Unit Rate. Match Requirements Will Be Met Through Provision of Additional Units"]
[]
[null,null,null,{"$f":"+L16","v":0}]
[null,null,null,null,null,"Contractor Initial",null,"AAA Initial"]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"IF(+'Transportation Budget'!C2=0,\"\",'Transportation Budget'!C2)","v":""},null,null,null,{"$f":"IF(+'Transportation Budget'!C3=0,\"\",+'Transportation Budget'!C3)","v":""}]
[null,null,null,"Legal Name of Contracted Provider",null,null,null,"Name of Area Agency on Aging"]
[]
[]
[]
[null,null,null,"Signature",null,null,null,"Signature"]
[]
[null,null,null,{"$f":"'Provider Information'!$F$13","v":0},null,null,null,{"$f":"'Provider Information'!$D$22","v":0}]
[null,null,null,"Printed/Typed Name of Signer",null,null,null,"Printed/Typed Name of Signer"]
[]
[]
[]
[null,null,null,"Date",null,null,null,"Date"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Calculation of In-Kind Value"]
[null,null,null,"1. Required Match Rate",null,null,null,null,null,{"$f":"+I21","v":0}]
[null,null,null,"2. TDoA units",null,null,null,null,null,{"$f":"IF(E10=0,L12,+E10)","v":0}]
[null,null,null,"3. Required Match Rate (1) Multiplied by the anticipated number of TDoA units (2)",null,null,null,null,null,{"$f":"+J103*J104","v":0}]
[null,null,null,"4. Total Valuation from the In-Kind Certification",null,null,null,null,null,{"$f":"+'In-Kind Certification Transp'!G25","v":0}]
[null,null,null,"5. Balance of Required Match (3-4)",null,null,null,null,null,{"$f":"+J105-J106","v":0}]
[null,null,null,"6. TDoA units + DHS units",null,null,null,null,null,{"$f":"IF(+E10=0,L12,+E10)","v":0}]
[null,null,null,"7. Balance of Required Match (5) Divided by TDoA units (6)",null,null,null,null,null,{"$f":"IF(J107=0,0,+J107/J108)","v":0}]
[null,null,null,"8. Required Match Rate",null,null,null,null,null,{"$f":"+I21","v":0}]
[null,null,null,"9. Reduced Required Match If (8) is equal to or less than 0 this will equal (8) or else (8-7)",null,null,null,null,null,{"$f":"IF(+J109<=0,+J110,+J110-J109)","v":0}]

{"sheet":"Certification Transp","index":18,"n_rows":46,"n_cols":7,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,2,0,3],[39,2,39,4],[39,6,39,9],[3,1,3,10],[4,1,4,10],[5,1,5,4],[5,6,5,10],[34,2,34,4],[34,6,34,9],[1,3,1,7],[35,2,35,4],[35,6,35,9],[38,2,38,4],[38,6,38,9],[2,3,2,8]]}
[null,null,{"$f":"NOW()","v":"2020-07-23T18:20:44.220"}]
[null,null,"Provider Name: ",{"$f":"+'Provider Information'!F6","v":0}]
[null,null,"AAA Name:",{"$f":"+'Provider Information'!D21","v":0}]
[null,{"$f":"+'Provider Total Budget by Serv'!K4","v":"Transportation"}]
[null,"BUDGET WORKSHEET CERTIFICATION"]
[]
[null,"        AS SIGNER OF THIS BUDGET WORKSHEET, I HEREBY CERTIFY THAT:"]
[]
[null,"·","I have read the note below and the instructions applicable to this budget worksheet."]
[]
[null,"·","I have reviewed this budget worksheet after its preparation."]
[]
[null,"·","To the best of my knowledge and belief, this budget worksheet is true, correct and"]
[null," ","complete, and was prepared in accordance with the instructions applicable to this"]
[null," ","budget worksheet."]
[]
[null,"·","This budget worksheet was prepared from the books and records of the contracted"]
[null," ","provider."]
[]
[null,"·","I acknowledge that all books and records related to this rate setting process are"]
[null," ","subject to audit in accordance with contract requirements and all applicable federal "]
[null,null,"and state laws."]
[]
[]
[null,"    Note: ","The person legally responsible for the conduct of the contracted provider must"]
[null,null,"sign this Budget Worksheet Certification.  If a sole proprietor, the owner"]
[null,null,"must sign the Budget Worksheet Certification.  If a partnership, a partner must "]
[null,null,"sign the Budget Worksheet Certification.  If a corporation, the person authorized by the "]
[null,null,"Board of Directors Resolution must sign the Budget Worksheet Certification.  "]
[null,null,"Misrepresentation of information contained in the budget worksheet may result in "]
[null,null,"adverse action, up to and including contract termination.  Furthermore, falsification of "]
[null,null,"information in the budget worksheet may result in a referral for prosecution."]
[]
[]
[null,null,{"$f":"+'Transportation Budget'!C2","v":0},null,null,null,{"$f":"'Provider Information'!$F$13","v":0}]
[null,null,"Name of Contracted Provider",null,null,null,"Printed/Typed Name of Signer"]
[]
[]
[]
[null,null,"Date",null,null,null,"Signature"]
[]
[]
[]
[null,null,"Signer Authority:",null,"Sole Proprietor",null,"Association Officer"]
[null,null,"    (check one)",null,"Partner",null,"Board Member"]
[null,null,null,null,"Corporate Officer",null,"Governmental Official           "]

{"sheet":"In-Kind Certification Transp","index":19,"n_rows":48,"n_cols":7,"rows_kept":48,"cut":false,"hidden":false,"merged":[[46,1,46,3],[43,5,43,6],[43,1,43,3],[6,3,6,4],[20,1,20,4],[13,1,13,4],[14,1,14,4],[15,1,15,4],[16,1,16,4],[49,1,49,7],[47,1,47,3],[47,5,47,6],[4,2,4,4],[6,1,6,2],[44,1,44,3],[44,5,44,6],[26,2,26,5],[31,3,31,6],[17,1,17,4],[18,1,18,4],[19,1,19,4],[46,5,46,6],[8,1,8,6],[11,1,11,4],[12,1,12,4],[0,2,0,3],[1,3,1,6],[33,9,33,13],[34,3,34,6],[21,1,21,4],[22,1,22,4],[23,1,23,4],[24,1,24,4],[2,1,2,6],[3,1,3,6]]}
[null,null,{"$f":"NOW()","v":"2020-07-23T18:20:44.220"}]
[null,null,"AAA Name:",{"$f":"+'Provider Information'!D21","v":0}]
[null,{"$f":"+'Provider Total Budget by Serv'!K4","v":"Transportation"}]
[null,"IN-KIND MATCH CERTIFICATION"]
[null,"Provider: ",{"$f":"IF(ISBLANK('Provider Information'!F6),\"\",+'Provider Information'!F6)","v":""}]
[]
[null,"In-kind Contribution(s):",null,{"$f":"+G25","v":0}]
[]
[null,"For any item identified below, the provider must maintain monthly supporting documentation."]
[]
[]
[null,"ITEM",null,null,null,"DATE OF RECEIPT","VALUE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"TOTAL",{"$f":"SUM(G13:G24)","v":0}]
[]
[null,"Note:","All contributions must meet the requirements of IRS Publication 561  \nhttp://www.irs.gov/pub/irs-pdf/p561.pdf"]
[]
[null,"Examples of Documentation Include:"]
[]
[null,"Rent:","1.","Letter of Agreement with Owner"]
[null,null,"2.","Adequate Valuation of Property on a Current Basis (this should be reviewed at least every two years and if senior center, based on property value and center participation)"]
[]
[null,"Labor:","1.","Minimum wage"]
[null,null,"2.","Documented prevailing wage in the Area. For prevailing wage information visit the Texas Workforce Commission’s website at  http://www.tracer2.com/."]
[]
[]
[null,"All in-kind labor must be required for the service to be provided.  If you would not hire someone to perform the labor if it "]
[null,"were not in-kind then you cannot count it."]
[]
[null,"Utilities: ","1.","Copy of Bill"]
[null,null,"2.","Agreement of Amount Paid if Partial"]
[]
[null,{"$f":"+'Transportation Budget'!C2","v":0},null,null,null,{"$f":"'Provider Information'!$F$13","v":0}]
[null,"        Name of Contracted Provider",null,null,null,"Printed/Typed Name of Signer"]
[]
[]
[null,"Date",null,null,null,"Signature"]