HCCBG Budget Page 1
<br />North Carolina Division of Aging DOA -732A FY 2013
<br />Service Cost Computation Worksheet C:732A.xls
<br />Provider: Cabarrus County Human Services
<br />County: Cabarrus
<br />Budget Period: July 1, 2012 through June 30, 2013
<br />Revision yes, _X no, revision date
<br />I. Projected Revenues
<br />Grand Total
<br />Congregate 180
<br />Supplemental
<br />182
<br />Adult Day
<br />Care 030
<br />Adult Day
<br />Health 155
<br />Info &Assist
<br />040
<br />n- ome -
<br />Personal Care
<br />042
<br />Trans 250
<br />A- Fed /State Funding From the Division of Aging
<br />546,678
<br />/ / / / / / / ///
<br />99,025
<br />10,122
<br />60,081
<br />81,639
<br />51,398
<br />122,652
<br />121,761
<br />Required Minimum Match - Cash
<br />1 County General Fund
<br />60,742
<br />/ / / / / / / ///
<br />11,003
<br />1,125
<br />6,676
<br />9,071
<br />5,711
<br />13,628
<br />13,529
<br />2
<br />0
<br />3
<br />0
<br />Total Required Minimum Match Cash
<br />60,742
<br />/ / / / / / / ///
<br />11,003
<br />1,125
<br />6,676
<br />9,071
<br />5,711
<br />13,628
<br />13,529
<br />Required Minimum Match - In Kind
<br />1
<br />0
<br />2
<br />0
<br />3
<br />0
<br />Total Required Minimum Match - In Kind
<br />0
<br />/ / / / / / / ///
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />B- Total Re Minimum Match cash +in -bnd
<br />60,742/////////
<br />/
<br />11,003
<br />1,125
<br />6,676
<br />9,071
<br />5,711
<br />13,628
<br />13,529
<br />c. Subtotal, Fed /State /Required Match Revert
<br />607,420
<br />/ / / / / / / ///
<br />110,028
<br />11,247
<br />66,757
<br />90,710
<br />57,109
<br />136,280
<br />135,290
<br />D. USDA Cash Subsidy /Commodity Valuation
<br />27,500
<br />/ / / / / / / ///
<br />25,000
<br />2,500
<br />F. OAA Title V Worker Wages, Fringe Benefits
<br />Local Cash, Non Match
<br />1) County General Fund
<br />928,718
<br />/ / / / / / / ///
<br />148,011
<br />15,706
<br />765,001
<br />2 Medicaid
<br />350,000
<br />/ / / / / / / ///
<br />350,000
<br />3
<br />0
<br />4
<br />0
<br />F. Subtotal, Local Cash, Non -Match
<br />1,278,718
<br />/ / / / / / / ///
<br />148,011
<br />0
<br />0
<br />0
<br />15,706
<br />0
<br />1,115,001
<br />Other Revenues, Non Match
<br />1 City of Concord
<br />22,000
<br />/ / / / / / / ///
<br />22,070
<br />2 5311 Admin
<br />385,432.8/88/8
<br />385,432
<br />3 Roap
<br />245,632
<br />/ / / / / / / ///
<br />245,632
<br />G- Subtotal, Other Revenues, Non -Match
<br />653,064
<br />/ / / / / / / ///
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />653,064
<br />Local In Kind Resources Includes Volunteer Resources)
<br />1
<br />0
<br />2
<br />0
<br />3)
<br />0
<br />IT Subtotal, Local In -kind Resources, Non-Mal
<br />0
<br />/ / / / / / / ///
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />LClient Program Income
<br />35,350
<br />/ / / / / / /
<br />34,000
<br />300
<br />500
<br />500
<br />0
<br />50
<br />0
<br />d Total Projected Revenues (Sum I C, D, E, F, G,
<br />2,602,052
<br />/ / / / / / / ///
<br />317,039
<br />14,047
<br />67,257
<br />91,2101
<br />72,8151
<br />136,3301
<br />1,903,355
<br />Percent of Grand Total
<br />1 100%
<br />1
<br />1 1218"0
<br />0-541
<br />259%
<br />351%1
<br />290%1
<br />5249/61
<br />7315%.
<br />D
<br />v
<br />3
<br />m
<br />c
<br />3
<br />tT
<br />N
<br />F -3 Page 63
<br />
|