{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["SS Cost Limits"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":58,"comments":1,"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":"SS Cost Limits","index":0,"n_rows":47,"n_cols":51,"rows_kept":47,"cut":false,"hidden":false,"merged":[[36,1,36,24],[36,25,36,27],[36,28,36,29],[36,30,36,34],[20,0,20,37],[21,0,21,37],[19,36,19,37],[19,0,19,35],[34,1,34,24],[34,25,34,27],[35,1,35,24],[35,25,35,27],[35,28,35,29],[35,30,35,34],[31,1,31,24],[31,25,31,27],[32,1,32,24],[32,25,32,27],[33,1,33,24],[33,25,33,27],[29,30,29,34],[22,28,22,29],[22,30,22,32],[22,33,22,37],[23,0,23,27],[23,28,23,29],[23,30,23,32],[23,33,23,37],[22,0,22,7],[22,8,22,11],[22,12,22,13],[22,14,22,25],[22,26,22,27],[27,33,27,37],[45,20,45,22],[45,7,45,17],[43,7,43,17],[43,20,43,22],[24,0,24,27],[24,28,24,29],[24,30,24,32],[24,33,24,37],[25,0,25,27],[25,28,25,29],[25,30,25,32],[25,33,25,37],[30,1,30,24],[30,25,30,27],[29,0,29,27],[30,28,30,29],[30,30,30,34],[26,0,26,27],[26,28,26,29],[26,30,26,32],[26,33,26,37],[27,0,27,27],[27,28,27,29],[27,30,27,32],[44,2,44,4],[44,7,44,17],[44,20,44,22],[38,0,38,27],[41,1,41,24],[42,2,42,4],[42,7,42,17],[42,20,42,22],[39,1,39,11],[39,13,39,20],[39,22,39,24],[40,1,40,11],[40,13,40,20],[40,22,40,24],[11,30,11,34],[12,1,12,24],[12,25,12,27],[12,28,12,29],[12,30,12,34],[17,30,17,34],[18,1,18,24],[18,25,18,27],[18,28,18,29],[18,30,18,34],[16,1,16,24],[16,25,16,27],[17,1,17,24],[17,25,17,27],[17,28,17,29],[6,0,6,27],[6,28,6,29],[6,30,6,32],[6,33,6,37],[46,0,46,27],[7,0,7,27],[7,28,7,29],[7,30,7,32],[7,33,7,37],[8,0,8,27],[8,28,8,29],[8,30,8,32],[8,33,8,37],[9,0,9,27],[9,28,9,29],[9,30,9,32],[13,25,13,27],[14,1,14,24],[14,25,14,27],[15,1,15,24],[15,25,15,27],[13,1,13,24],[9,33,9,37],[11,0,11,27],[3,0,3,37],[0,1,0,15],[0,17,0,21],[2,0,2,35],[2,36,2,37],[0,22,0,37],[4,0,4,37],[5,0,5,7],[5,8,5,11],[5,12,5,13],[5,14,5,25],[5,26,5,27],[5,28,5,29],[5,30,5,32],[5,33,5,37],[1,36,1,37],[1,19,1,26],[1,0,1,18],[1,29,1,35],[1,27,1,28]]}
["Project Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HCD Contract #(s):"]
["NOTE: This Supportive Services Cost Limit tool is only used for projects subject to the 2017 UMRs or subsequent amendments. Complete all yellow shaded cells.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Has or will this Project receive HCD HOME, HOME-ARP, or NHTF funding:",null,null,null,null,null,null,null,null,null,"Has or will this Project receive only HCD VHHP funding:",null,null,null,null,null,null,null,null,null,null,null,null,"Fiscal Year","(1)(A) & (B)","(2)(A) & (B)","(3)","(3) VHHP","8314 (e)(1)","8314 (e)(2)","8314 (e)(3)","8314 (e)(4)"]
["Supportive Services Cost Limits per HCD Administrative Notice 24-05",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,"2024-12-10",null,null,null,null,"Yes",2025,10000,4000,326,997,4971,3728,1281,305]
["UMR  §8301(t):  “Supportive Services” - social, health, educational, income support and employment services and benefits, coordination of community building and educational activities, individualized needs assessment, and individualized assistance with obtaining services and benefits.",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,"No",{"$f":"+AQ3+1","v":2026},{"$f":"AR3*1.035","v":10350},4140,337.40999999999997,1031.895,{"$f":"AV3*1.025","v":5095.2749999999996},3821.2,1313.0249999999999,312.625]
["UMR  §8301(u): “Supportive Services Costs” - the costs of providing tenants service coordination, case management, and direct resident and Supportive Services. It includes: (1) the cost of providing tenants with information on and referral to social, health, educational, income support and employment services and benefits, coordination of community building and educational activities, individualized needs assessment, and individualized assistance with obtaining services and benefits; (2) salaries, benefits, contracted services, telecommunication expenses, travel costs, supplies, office expenses, staff training, maintenance of on-site equipment used in services programs, such as computer labs, incidental costs related to resident events, and other similar costs approved by the Department.",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,{"$f":"+AQ4+1","v":2027},10712.25,4284.8999999999996,349.21934999999996,1068.0113249999999,{"$f":"AV4*1.025","v":5222.6568749999988},3916.7299999999996,1345.8506249999998,320.44062499999995]
["a. Supportive Services Units:",null,null,null,null,null,null,null,"Total number units:",null,null,null,null,null,"Certification Year - select budget reporting perid year:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Units",null,"Max PUPY Expense",null,null,"Max Costs",null,null,null,null,null,null,null,null,{"$f":"+AQ5+1","v":2028},11087.178749999999,4434.8714999999993,361.44202724999991,1105.3917213749999,5353.2232968749986,4014.6482499999993,1379.4968906249997,328.45164062499992]
["(1) Total number of units: (A) for supportive housing restricted to individuals or families experiencing chronic homelessness or homelessness, as defined consistent with Health and Safety Code (HSC) §50675.141; and (B) for supportive housing units restricted to occupancy by special needs populations under HCD programs subject to Administrative Notice 24-05 (“Special needs population” has the same meaning as set forth in individual program guidelines); units anticipated to be restricted to individuals or families experiencing chronic homelessness as defined consistent with HSC §50675.14.\n\n1For units assisted by the HCD Veterans Housing and Homelessness Prevention (VHHP) program, this category includes Supportive Housing Units restricted to Veterans who are experiencing Chronic Homelessness, units restricted to persons who are experiencing Chronic Homelessness by another public agency program, Supportive Housing Units restricted to Veterans with a Disability Experiencing Homelessness, and other Units restricted to persons who are Veterans with a Disability Experiencing Homelessness. (Capitalized terms in this footnote have the same meaning as those set forth in the VHHP guidelines.) ",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,{"$f":"IFERROR(VLOOKUP($AA$6,$AQ$3:$AY$77,2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(AE7*AC7,\"\")","v":""},null,null,null,null,null,null,null,null,2029,{"$f":"AR6*1.035","v":11475.230006249998},{"$f":"AS6*1.035","v":4590.0920024999987},{"$f":"AT6*1.035","v":374.09249820374987},1144.0804316231247,{"$f":"AV6*1.025","v":5487.0538792968728},4115.0144562499991,1413.9843128906246,336.66293164062489]
["(2) Total number of other units2 where the Sponsor, their affiliate, or a service provider under contract to provide Supportive Services at the Project has both: (A) qualified staff devoted exclusively to oversight and quality control of resident services in affordable housing, including the Project; and (B) a system to track and report on tenant outcomes, such as changes in employment status and income. Do not include units counted in category (1) above.\n\n2For units assisted by the VHHP program, this category includes Units that are restricted to Extremely Low-Income households, but not to Veterans who are experiencing Chronic Homelessness or Veterans with a Disability Experiencing Homelessness. (Capitalized terms in this footnote have the same meaning as those set forth in the VHHP guidelines.) ",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,{"$f":"IFERROR(VLOOKUP($AA$6,$AQ$3:$AY$77,3,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(AE8*AC8,\"\")","v":""},null,null,null,null,null,null,null,null,2030,11876.863056468746,4750.7452225874986,387.18573564088109,{"$f":"AU7*1.035","v":1184.123246729934},{"$f":"AV7*1.025","v":5624.2302262792937},4217.8898176562489,1449.3339207128899,345.07950493164049]
["(3) Except as noted below for the VHHP program, total number of units where the Sponsor, their affiliate, or a service provider under contract does not satisfy the requirements set forth in subsection (2) above3. Do not include units counted in categories (1) and (2) above.\n\n3For units assisted by the VHHP program, the amount for this category of units will remain as currently allowed under this program. ",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,{"$f":"IFERROR(IF(AK2<>\"Yes\",VLOOKUP($AA$6,$AQ$3:$AY$77,4,FALSE),VLOOKUP($AA$6,$AQ$3:$AY$77,5,FALSE)),\"\")","v":""},null,null,{"$f":"IFERROR(AE9*AC9,\"\")","v":""},null,null,null,null,null,null,null,null,2031,{"$f":"AR8*1.025","v":12173.784632880464},{"$f":"AS8*1.025","v":4869.5138531521852},{"$f":"AT8*1.025","v":396.8653790319031},{"$f":"AU8*1.035","v":1225.5675603654815},{"$f":"AV8*1.025","v":5764.8359819362759},4323.3370630976551,1485.5672687307122,353.70649255493146]
["(4) Maximum Supportive Services Costs",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,{"$f":"SUM(AC7:AD9)","v":0},null,null,null,null,{"$f":"SUM(AH7:AL9)","v":0},null,null,null,null,null,null,null,null,2032,12478.129248702475,4991.2516994809894,406.78701350770064,{"$f":"AU9*1.035","v":1268.4624249782732},{"$f":"AV9*1.025","v":5908.9568814846825},4431.4204896750962,1522.7064504489799,362.54915486880469]
[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,2033,12790.082479920036,5116.0329919680134,416.9566888453931,{"$f":"AU10*1.035","v":1312.8586098525127},{"$f":"AV10*1.025","v":6056.6808035217991},4542.206001916973,1560.7741117102044,371.61288374052475]
["b. Budgeted Supportive Services Costs",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,"Max Allowable Amt",null,null,null,null,null,null,null,null,null,null,null,2034,13109.834541918037,5243.9338167672131,427.38060606652789,{"$f":"AU11*1.035","v":1358.8086611973506},{"$f":"AV11*1.025","v":6208.0978236098435},4655.7611519648972,1599.7934645029593,380.90320583403786]
["(1)","Staff Supervisor(s) Salaries - may not exceed 15% of on-site staff salaries* (b)(1)",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,{"$f":"(Z14+Z15)*0.15","v":0},null,null,null,null,null,null,null,null,null,null,null,2035,13437.580405465987,5375.0321621863932,438.06512121819105,{"$f":"AU12*1.035","v":1406.3669643392577},{"$f":"AV12*1.025","v":6363.3002692000891},4772.155180764019,1639.7883011155332,390.42578597988876]
["(2)","On-Site Services Coordinator Salaries",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,2036,13773.519915602636,5509.4079662410522,449.01674924864579,{"$f":"AU13*1.035","v":1455.5898080911315},{"$f":"AV13*1.025","v":6522.3827759300912},4891.4590602831186,1680.7830086434215,400.18643062938594]
["(3)","On-Site other Supportive Services Staff Salaries",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,2037,14117.8579134927,5647.1431653970776,460.2421679798619,{"$f":"AU14*1.035","v":1506.5354513743209},{"$f":"AV14*1.025","v":6685.4423453283425},5013.7455367901957,1722.8025838595067,410.19109139512057]
["(4)","Other Supportive Services Costs: (specify)",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,2038,14470.804361330016,5788.3217445320042,471.74822217935844,{"$f":"AU15*1.035","v":1559.2641921724221},{"$f":"AV15*1.025","v":6852.5784039615501},5139.0891752099506,1765.8726484559943,420.44586867999857]
["(5)","Other Supportive Services Costs: (specify)",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,2039,14832.574470363264,5933.0297881453034,483.54192773384233,{"$f":"AU16*1.035","v":1613.8384388984568},{"$f":"AV16*1.025","v":7023.8928640605882},5267.5664045901985,1810.019464667394,430.95701539699849]
["(6)","Supportive Services Administrative Overhead - may not exceed 15% of Total Supportive Services Costs* (b)(2)",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,{"$f":"SUM(Z13:Z18)*0.15","v":0},null,null,null,null,null,null,null,null,null,null,null,2040,15203.388832122344,6081.3555328489356,495.63047592718834,{"$f":"AU17*1.035","v":1670.3227842599026},{"$f":"AV17*1.025","v":7199.4901856621027},5399.255564704953,1855.2699512840786,441.73094078192344]
["(7)","  Total Budgeted Supportive Services Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z13:Z18)","v":0},null,null,"<======",null,{"$f":"AH10","v":0},null,null,null,null,null,null,null,null,null,null,null,2041,15583.473552925401,6233.3894211701581,508.02123782536802,{"$f":"AU18*1.035","v":1728.7840817089991},{"$f":"AV18*1.025","v":7379.4774403036545},5534.2369538225767,1901.6517000661804,452.77421430147149]
["Supportive Services Cost Limits - 2017 Uniform Multifamily Regulation (UMR) HOME and NHTF funded projects",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,{"$f":"AK3","v":"2024-12-10"}]
["UMR  §8301(t):  “Supportive Services” - social, health, educational, income support and employment services and benefits, coordination of community building and educational activities, individualized needs assessment, and individualized assistance with obtaining services and benefits."]
["UMR  §8301(u): “Supportive Services Costs” - the costs of providing tenants service coordination, case management, and direct resident and Supportive Services. It includes: (1) the cost of providing tenants with information on and referral to social, health, educational, income support and employment services and benefits, coordination of community building and educational activities, individualized needs assessment, and individualized assistance with obtaining services and benefits; (2) salaries, benefits, contracted services, telecommunication expenses, travel costs, supplies, office expenses, staff training, maintenance of on-site equipment used in services programs, such as computer labs, incidental costs related to resident events, and other similar costs approved by the Department."]
["a. Supportive Services Units:",null,null,null,null,null,null,null,"Total number units:",null,null,null,null,null,"Certification Year - select budget reporting perid year:",null,null,null,null,null,null,null,null,null,null,null,2025,null,"Total Units",null,"Max PUPY Expense",null,null,"Max Costs"]
["(1) UMR  §8314(e)(1):  Total number of Supportive Housing (SH) units anticipated to be restricted to individuals or families experiencing chronic homelessness as defined consistent with Health and Safety Code (HSC) §50675.14.",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,{"$f":"IFERROR(VLOOKUP($AA$23,$AQ$3:$AY$76,6,FALSE),\"\")","v":4971},null,null,{"$f":"IFERROR(AE24*AC24,\"\")","v":0}]
["(2) UMR §8314(e)(2):  Total number of Supportive Housing (SH) units (other than those restricted to individuals or families experiencing chronic homelessness pursuant to HSC §50675.14), PLUS the total number of units restricted to occupancy by Special Needs Populations (SNP)* under any HCD program. (*click here for definition - §7301(s) of the MHP Regulations). Do not include units included in (1) above.",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,{"$f":"IFERROR(VLOOKUP($AA$23,$AQ$3:$AY$76,7,FALSE),\"\")","v":3728},null,null,{"$f":"IFERROR(AE25*AC25,\"\")","v":0}]
["(3) UMR §8314(e)(3):  Total number of units where the Sponsor, their affiliate, or a service provider under contract to provide Supportive Services at the Project has both: (A) qualified staff devoted exclusively to oversight and quality control of resident services in affordable housing, including the Project; and (B) a system to track and report on tenant outcomes, such as changes in employment status and income. Do not include units included in items (1) and (2) above.",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,{"$f":"IFERROR(VLOOKUP($AA$23,$AQ$3:$AY$76,8,FALSE),\"\")","v":1281},null,null,{"$f":"IFERROR(AE26*AC26,\"\")","v":0}]
["(4) UMR §8314(e)(4):  Total number of units anticipated to be offered Supportive Services provided by the Project Sponsor, a Sponsor affiliate, or contracted service provider that do not satisfy the criteria in items (1), (2) and (3) above.",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,{"$f":"IFERROR(VLOOKUP($AA$23,$AQ$3:$AY$76,9,FALSE),\"\")","v":305},null,null,{"$f":"IFERROR(AE27*AC27,\"\")","v":0}]
["(5) Maximum Supportive Services Costs",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,{"$f":"SUM(AC24:AD27)","v":0},null,null,null,null,{"$f":"SUM(AH24:AL27)","v":0}]
[]
["b. Budgeted Supportive Services Costs",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,"Max Allowable Amt"]
["(1)","Staff Supervisor(s) Salaries - may not exceed 10% of on-site staff salaries* §8314(f)(1)",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,{"$f":"(Z32+Z33)*0.1","v":0}]
["(2)","On-Site Services Coordinator Salaries"]
["(3)","On-Site other Supportive Services Staff Salaries"]
["(4)","Other Supportive Services Costs: (specify)"]
["(5)","Other Supportive Services Costs: (specify)"]
["(6)","Supportive Services Admin. Overhead - may not exceed 15% of Total Supportive Services Costs* §8314(f)(2)",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,{"$f":"SUM(Z31:Z36)*0.15","v":0}]
["(7)","  Total Budgeted Supportive Services Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z31:Z36)","v":0},null,null,"<======",null,{"$f":"AH28","v":0}]
[]
["I certify that: I am authorized to provide the information above, and it is accurate to the best of my knowledge."]
[]
[null,"Name",null,null,null,null,null,null,null,null,null,null,null,"Title",null,null,null,null,null,null,null,null,"Date"]
[null,"For Official HCD Use Only"]
[null,null,"Approved"]
[null,null,null,null,null,null,null,"Occupancy Representative",null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[null,null,"Approved"]
[null,null,null,null,null,null,null,"Fiscal Representative",null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
["HCD AMC Occupancy and Fiscal Rep comments."]