{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":148,"n_cols":11,"rows_kept":148}
["North Carolina Division of Aging"]
["Service Cost Computation Worksheet  c:732A.xls",{"$nulls":8},"DAAS-732A"]
["Provider: ",{"$nulls":8},"PTRC 2024"]
["County:   "]
["Budget Period:  7-1-2025  through  6-30-2026"]
["Date ____________  Revision ____ Yes"]
[]
[]
[{"$nulls":3},"Service","Service","Service","Service","Service","Service","Service","Service"]
[null,"Grand",null,"Name of","Name of","Name of","Name of","Name of","Name of","Name of","Name of"]
["I.  Projected Revenues","Total",null,"Service","Service","Service","Service","Service","Service","Service","Service"]
[" A. Fed/State Funding From the Division of Aging",{"$f":"SUM(D12:K12)","v":0},"///////////////"]
["        Required Minimum Match - Cash","////////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////"]
["        1)  ",{"$f":"SUM(D14:K14)","v":0},"///////////////"]
["        2)",{"$f":"SUM(D15:K15)","v":0},"///////////////"]
["        3)",{"$f":"SUM(D16:K16)","v":0},"///////////////"]
["        Total Required Minimum Match - Cash",{"$f":"SUM(D17:K17)","v":0},"///////////////",{"$f":"SUM(D14:D16)","v":0},{"$f":"SUM(E14:E16)","v":0},0,0,0,0,0,0]
["        Required Minimum Match - In-Kind","////////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////"]
["        1)",{"$f":"SUM(D19:K19)","v":0},"///////////////"]
["        2)",{"$f":"SUM(D20:K20)","v":0},"///////////////"]
["        3)",{"$f":"SUM(D21:K21)","v":0},"///////////////"]
["        Total Required Minimum Match - In-Kind",{"$f":"SUM(D22:K22)","v":0},"///////////////",{"$f":"SUM(D19:D21)","v":0},0,0,0,0,0,0,0]
[" B. Total Required Minimum Match  (cash + in-kind)",{"$f":"B17+B22","v":0},"///////////////",{"$f":"D17+D22","v":0},{"$f":"E17+E22","v":0},0,0,0,0,0,0]
[" C. Subtotal, Fed/State/Required Match Revenues",{"$f":"B12+B23","v":0},"///////////////",{"$f":"D12+D23","v":0},{"$f":"E12+E23","v":0},0,0,0,0,0,0]
[" D. NSIP Cash Subsidy/Commodity Valuation",{"$f":"SUM(D25:K25)","v":0},"///////////////"]
[" E. OAA Title V Worker Wages, Fringe Benefits and Costs",{"$f":"SUM(D26:K26)","v":0},"///////////////"]
[" Local Cash, Non-Match","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////"]
["  1)  ",{"$f":"SUM(D28:K28)","v":0},"///////////////"]
["  2)  ",{"$f":"SUM(D29:K29)","v":0},"///////////////"]
["  3)",{"$f":"SUM(D30:K30)","v":0},"///////////////"]
["  4)",{"$f":"SUM(D31:K31)","v":0},"///////////////"]
[" F. Subtotal, Local Cash, Non-Match",{"$f":"SUM(D32:K32)","v":0},"///////////////",{"$f":"SUM(D28:D31)","v":0},{"$f":"SUM(E28:E31)","v":0},0,0,0,0,0,0]
[" Other Revenues, Non-Match","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////"]
["  1)  ",{"$f":"SUM(D34:K34)","v":0},"///////////////"]
["  2)",{"$f":"SUM(D35:K35)","v":0},"///////////////"]
["  3)",{"$f":"SUM(D36:K36)","v":0},"///////////////"]
[" G. Subtotal, Other Revenues, Non-Match",{"$f":"SUM(D37:K37)","v":0},"///////////////",{"$f":"SUM(D34:D36)","v":0},{"$f":"SUM(E34:E36)","v":0},0,0,0,0,0,0]
[" Local In-Kind Resources (Includes Volunteer Resources)","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////"]
["  1)  ",{"$f":"SUM(D39:K39)","v":0},"///////////////"]
["  2)",0,"///////////////"]
["  3)",0,"///////////////"]
[" H. Subtotal, Local In-kind Resources, Non-Match",0,"///////////////",{"$f":"SUM(D39:D41)","v":0},{"$f":"SUM(E39:E41)","v":0},0,0,0,0,0,0]
["  I. Consumer Contribution",0,"///////////////"]
[" J. Total Projected Revenues (Sum I C,D,E,F,G,H, & I)",0,"///////////////",{"$f":"SUM(D24+D25+D26+D32+D37+D42+D43)","v":0},{"$f":"SUM(E24+E25+E26+E32+E37+E42+E43)","v":0},0,0,0,0,0,0]
[" K. Revenue Excess/(Shortage)(Cannot be negative #, must be \"0\")",{"$f":"SUM(D45:K45)","v":0},"///////////////",{"$f":"SUM(D44-D96)","v":0},0,0,0,0,0,0,0]
["     Note:  Revenue must Equal Expenses (Section I, line j = Section II, line j)"]
[]
["Division of Aging "]
["Service Cost Computation Worksheet  732A",null,null,"Service","Service","Service","Service","Service","Service","Service","Service"]
[null,"Grand ","Admin.",{"$f":"D10","v":"Name of"},"Name of","Name of","Name of","Name of","Name of","Name of","Name of"]
["II.  Line Item Expense","Total","Cost","Service","Service","Service","Service","Service","Service","Service","Service"]
[" Staff Salary From Labor Distribution Schedule","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////"]
["  1)  Full-time Staff",{"$f":"SUM(C53:K53)","v":0}]
["  2)  Part-time staff   (do not include Title V workers)",{"$f":"SUM(C54:K54)","v":0}]
["A.  Subtotal, Staff Salary",{"$f":"SUM(C55:K55)","v":0},{"$f":"SUM(C53:C54)","v":0},{"$f":"SUM(D53:D54)","v":0},0,0,0,0,0,0,0]
[" Fringe Benefits","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////"]
["  1)  FICA @ .0765%",{"$f":"SUM(C57:K57)","v":0},{"$f":"SUM(C55*0.0765)","v":0},{"$f":"SUM(D55*0.0765)","v":0},0,0,0,0,0,0,0]
["  2)  Health Ins. @ ",0]
["  3)  Retirement  @ ",0]
["  4)  Unemployment Insurance",0]
["  5)  Worker's Compensation",0]
["  6)  Other",0]
["B.  Subtotal, Fringe Benefits",{"$f":"SUM(C57:K62)","v":0},{"$f":"SUM(C57:C62)","v":0},{"$f":"SUM(D57:D62)","v":0},0,0,0,0,0,0,0]
["Local In-Kind Resources, Non-Match ","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////"]
["  1) ",{"$f":"SUM(C65:K65)","v":0}]
["  2)",{"$f":"SUM(C66:K66)","v":0}]
["  3)",{"$f":"SUM(C67:K67)","v":0}]
["C.  Subtotal, Local In-Kind Resources  Non-Match",{"$f":"SUM(C68:K68)","v":0},{"$f":"SUM(C65:C67)","v":0},0,0,0,0,0,0,0,0]
["D.  OAA Title V Worker Wages, Fringe Benefits and Costs",{"$f":"SUM(C69:K69)","v":0}]
[" Travel","//////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////"]
["  1) Per Diem  ",{"$f":"SUM(C71:K71)","v":0}]
["  2) Mileage Reimbursement ",{"$f":"SUM(C72:K72)","v":0}]
["  3) Other Travel Cost:  ",{"$f":"SUM(C73:K73)","v":0}]
["E.  Subtotal, Travel",{"$f":"SUM(C74:K74)","v":0},{"$f":"SUM(C71:C73)","v":0},0,0,0,0,0,0,0,0]
[" General Operating Expenses","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////"]
["  1)  ",{"$f":"SUM(C76:K76)","v":0}]
["  2)  ",0]
["  3)  ",0]
["  4)  ",0]
["  5) ",0]
["  6)",0]
["  7)",0]
["  8)",0]
["  9)",0]
["10)",0]
["11)",0]
["12)",0]
["13)",0]
["14)",0]
["15)",0]
[" F.  Subtotal, General Operating Expenses",0,{"$f":"SUM(C76:C90)","v":0},{"$f":"SUM(D76:D90)","v":0},0,0,0,0,0,0,0]
["G.   Subtotal, Other Administrative Cost Not Allocated","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////"]
["       in Lines II.A through F  ","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////"]
["H.  Total Proj. Expenses Prior to Admin. Distribution",{"$f":"B55+B63+B68+B69+B74+B91","v":0},{"$f":"C55+C63+C68+C69+C74+C91","v":0},{"$f":"D55+D63+D68+D69+D74+D91","v":0},{"$f":"E55+E63+E68+E69+E74+E91","v":0},{"$f":"F55+F63+F68+F69+F74+F91","v":0},0,0,0,0,0]
[" I.  Distribution of Admininistrative Cost (\"Manual Entries\")","///////////////"]
["J.  Total Proj. Expenses After Admin. Distribution",{"$f":"SUM(D96:K96)","v":0},"///////////////",{"$f":"D55+D63+D68+D69+D74+D91+D95","v":0},0,0,0,0,0,0,0]
["Note:  If costs appear in the Administrative Column, you must include an explanation for distributing these costs to the various services.  This is a requirement for budget approval."]
["Division of Aging"]
["Service Cost Computation Worksheet  732A"]
[{"$nulls":3},"Service","Service","Service","Service","Service","Service","Service","Service"]
[null,"Grand ",null,{"$f":"D10","v":"Name of"},"Name of","Name of","Name of","Name of","Name of","Name of","Name of"]
["III.  Computation of Rates","Total",null,"Service","Service","Service","Service","Service","Service","Service","Service"]
["   A. Computation of Unit Cost Rate:","////////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////","///////////////"]
["       1.  Total Expenses (equals line II.J)",{"$f":"SUM(D104:K104)","v":0},"///////////////",{"$f":"D96","v":0},0,0,0,0,0,0,0]
["       2.  Total Projected Units","////////////////","///////////////"]
["       3.  Total Unit Cost Rate","////////////////","///////////////",{"$f":"D104/D105","v":{"$error":"#DIV/0!"}},{"$f":"E104/E105","v":{"$error":"#DIV/0!"}},{"$f":"F104/F105","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["   B.  Computation of Reimbursement Rate:","////////////////","////////////////","////////////////","////////////////","////////////////","////////////////","////////////////","////////////////","////////////////","///////////////"]
["       1.  Total Revenues  (equals line I.J)",{"$f":"SUM(D108:K108)","v":0},"///////////////",{"$f":"D96","v":0},0,0,0,0,0,0,0]
["       2.  Less:    USDA   (equals line I.D)",{"$f":"SUM(D109:K109)","v":0},"///////////////",{"$f":"D25","v":0},0,0,0,0,0,0,0]
["                        Title V   (equals line I.E and II.D)",{"$f":"SUM(D110:K110)","v":0},"///////////////",0,0,0,0,0,0,0,0]
["                         Non Match In-Kind  (equals line I.H and II.C)",{"$f":"SUM(D111:K111)","v":0},"///////////////",{"$f":"D42","v":0},0,0,0,0,0,0,0]
["       3.  Expenses Subject to Unit Reimbursement",{"$f":"B108-SUM(B109:B111)","v":0},"///////////////",{"$f":"D108-SUM(D109:D111)","v":0},{"$f":"E108-SUM(E109:E111)","v":0},0,0,0,0,0,0]
["       4.  Total Projected Units (equals line III.A.2)","///////////////","///////////////",{"$f":"D105","v":0},0,0,0,0,0,0,0]
["       5.  Total Reimbursement Rate","////////////////","///////////////",{"$f":"IF(D124<=D129,D124,D129)","v":{"$error":"#DIV/0!"}},{"$f":"IF(E124<=E129,E124,E129)","v":{"$error":"#DIV/0!"}},{"$f":"IF(F124<=F129,F124,F129)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["   C.  Units Reimbursed Through HCCBG ","////////////////","///////////////",{"$f":"ROUND(D24/D124,0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["   D.  Units Reimbursed Through Program Income*","////////////////","///////////////",{"$f":"TRUNC(D43/D114,0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["   E.  Units Reimbursed Through  Remaining Revenues","////////////////","///////////////",{"$f":"TRUNC((D32+D37)/D114,0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["   F.  Total Units Reimbursed/Total Projected Units","////////////////","///////////////",{"$f":"SUM(D115:D117)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E115:E117)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F115:F117)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[{"$nulls":3},{"$f":"ROUND(VALUE(D112),0)","v":0},0,0,0,0,0,0,0]
[{"$nulls":3},0,0,0,0,0,0,0,0]
[]
[{"$nulls":3},{"$f":"ROUND(D121/D122,4)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[{"$nulls":3},{"$f":"ROUND(VALUE(D24),0)","v":0},0,0,0,0,0,0,0]
[{"$nulls":3},{"$f":"VALUE(D115)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[{"$nulls":3},{"$f":"ROUND(D126/D127,4)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["*  The Division of Aging ARMS deducts reported program"]
["    income from reimbursement paid to providers.  Line III.D"]
["    indicates the number of units that will have to be produced"]
["    in addition to those stated on line III.C in order to earn the"]
["    net revenues stated on line I.C."]
[]
[]
["Information on this form (DAAS-732A) corresponds with "]
["information stated on the Provider Services Summary"]
["(DAAS-732) as follows:"]
[null,"DAAS-732A","DAAS-732",null,null,"________________________________________________"]
["Block Grant Funding","Line I.A","Col. A",null,null,"(Signature)"]
["Required Local Match-Cash & In-Kind","Line I.B","Col. B"]
["Net Service Cost","Line I.C","Col. C",null,null,"________________________________________________"]
["USDA Subsidy","Line I.D","Col. D",null,null,"(Date)"]
["Total Funding","L. I.C+I.D","Col. E"]
["Projected HCCBG Reimbursed Units","Line III.C","Col. F"]
["Total Reimbursement Rate","Line III.B.5","Col. G"]
["Projected Total Service Units","Line III.F","   Col. I  "]