SFY14 DES AMENDMENT 9 ISB ATTACHMENTS A AND B.XLSX

Attachment A
ITEMIZED SERVICE BUDGET
CONTRACT SERVICE: Case Management (CMG-CAP) Agency: Maricopa County HSD
Contract Period: 07/01/2013 - 06/30/2014
1. PERSONNEL
TOTAL
Number of FTE Total Salary for the SERVICE DES
Positions Level Position Title Contract Period COST COST
1 0.50 CS Operations Supv. $60,258 $30,129 $30,129
1 1.00 CS Program Spec. $36,712 $36,712 $36,712
1 1.00 Emerg. Assist. Spec. $33,280 $33,280 $33,280
1 1.00 Prog Support Spec. $33,280 $33,280 $33,280
subtotal $133,401 $133,401
5% pay-for-performance increases $6,670 $6,670
TOTAL PERSONNEL $140,071 $140,071
2. EMPLOYEE RELATED EXPENSES
TOTAL DES
ITEM BASIS COST COST
% of Total Personnel
FICA Service Cost 36.00% $50,426 $50,426
Unemployment Insurance
Health Benefits
Life Insurance
Retirement
etc…
TOTAL EMPLOYEE RELATED EXPENSES $50,426 $50,426
3. PROFESSIONAL AND OUTSIDE SERVICES
TOTAL DES
ITEM BASIS COST COST
Sub-Contracted Providers of $541,386 $247,002
Crisis Case Mgt & Financial Asst Services
Database Consultant $85/hour x 1500 $127,500 $127,500
AZ State Requirements,CAP60, etc.
Fiscal Monitoring of subcontracted entities Per SFY 2013 estimate $30,000 $30,000
TOTAL PROFESSIONAL AND OUTSIDE SERVICES $698,886 $404,502
4. TRAVEL
TOTAL DES
ITEM BASIS COST COST
Staff Mileage 475 miles X 12 mo X $12,882 $12,882
4 FTEs X .565 per mile
TOTAL TRAVEL $12,882 $12,882
5. SPACE
TOTAL DES
ITEM BASIS COST COST
TOTAL SPACE $0 $0
9/24/13

6. EQUIPMENT TOTAL DES
COST COST
ITEM BASIS
TOTAL EQUIPMENT $0 $0
7. MATERIALS AND SUPPLIES
TOTAL DES
ITEM BASIS COST COST
CSD Staff General Office Materials & Ave. $3117.75 per month $29,046 $29,046
Supplies/Postage/forms x 12 mo x 77.64%
TOTAL MATERIALS AND SUPPLIES $29,046 $29,046
8. OPERATING SERVICES
TOTAL DES
ITEM BASIS COST COST
Fingerprint Clearance (card) staff & volunteers estimated 20x$100 $2,000 $2,000
Conference/Training registrations 90 registrations X $240 ave. $21,600 $21,600
(Gov. Office on Aging Annual Conf, Alzheimer’s Annual Conference, SAMHSA, etc)
Reprographics (printing forms etc.) estimated cost $14,000 $14,000
Monthly Parking $77 X 3.5 FTE X 12 mo $3,234 $3,234
Parking Validation for 5000 stamps @$1.00 per hr. $5,000 $5,000
Community/Meeting/Training-
CS Signature Pads $130.14 per unit X 70 units $9,110 $9,110
(electronic signature pads)
Records Mgt Storage/Destruction Based on SFY13 estimate-to-date $4,396 $4,396
TOTAL OPERATING EXPENSES $59,340 $59,340
9 INDIRECT COSTS
TOTAL DES
ITEM BASIS COST COST
Maricopa County Human Services 18.80% $35,813 $35,813
provisional indirect cost rate is 18.8% of
Personnel and ERE only
TOTAL INDIRECT COSTS $35,813 $35,813
10 SUBTOTAL ADMIN COST $1,026,464 $732,080
11. VOUCHERS
TOTAL DES
ITEM COST COST
TANF $557,179 $557,179
LIHEAP $2,836,904 $2,836,904
NHN $6,763 $6,763
TOTAL VOUCHERS $3,400,846 $3,400,846
12. TOTAL SERVICE COST/DES TOTAL COST: $4,427,310 $4,132,926
REVENUE SOURCES:
Maricopa County General Fund $294,384
DES/DAAS $4,132,926 $4,132,926
TOTAL REVENUE: $4,427,310 $4,132,926
9/24/13

Attachment B
ITEMIZED SERVICE BUDGET
CONTRACT SERVICE: Community Services (CSV-CAP) Agency: Maricopa County
Contract Period: 07/01/2013 - 06/30/2014
1. PERSONNEL
TOTAL
Number of FTE Total Salary for the SERVICE DES
Positions Level Position Title Contract Period COST COST
1 1.00 Assistant Director $73,445 $73,445 $55,084
1 0.50 CS Operations Supv. $60,258 $30,129 $30,129
1 1.00 CS Contract Admin. $52,853 $52,853 $52,853
1 1.00 Admin. Specialist $32,053 $32,053 $32,053
1 0.75 Sr. Grant Accountant $42,037 $31,528 $31,528
1 1.00 Office Assistant $26,624 $26,624 $26,624
1 1.00 Family Self-Suff. Spec. $29,245 $29,245 $29,245
1 1.00 Family Self-Suff. Spec. $35,360 $35,360 $35,360
1 0.75 Weatherization Prog.Spec $34,944 $34,944 $26,208
1 1.00 SAIL Cs Mgt Supv. $49,920 $49,920 $49,920
SAIL Case Mgt Prog.
27 27.00 SAIL Case Managers $1,371,162 $1,371,162 $0
1 1.00 SAIL Cs Mgt Supv. $49,920 $49,920 $0
37.00 subtotal $1,817,183 $369,004
Approximate 5% pay-for-performance increases $90,858 $18,449
TOTAL PERSONNEL $1,908,041 $387,453
2. EMPLOYEE RELATED EXPENSES
TOTAL DES
ITEM BASIS COST COST
FICA % of Total Personnel Service Cost 36.00% $686,895 $139,483
Unemployment Insurance
Health Benefits
Life Insurance
Retirement
TOTAL EMPLOYEE RELATED EXPENSES $686,895 $139,483
3. PROFESSIONAL AND OUTSIDE SERVICES
TOTAL DES
ITEM BASIS COST COST
Notice of Application/ Contracted Direct Service/ $57,910 $57,910
Program Support Program Support
Database Consultant $85/hour x 674.1176 hours $57,300 $57,300
AZ State Requirements,CAP60, DARS, etc.
Community Needs Assessment (CAA requirement) $22,000 $22,000
Aging Services - SAIL Case Management Program Evaluation $21,293 $21,293
Check Writing Fees/Issuance - 753 checks @ $18 $13,554 $13,554
(Voucher Assistance)
TOTAL PROFESSIONAL AND OUTSIDE SERVICES $172,057 $172,057

4. TRAVEL
TOTAL DES
ITEM BASIS COST COST
CSD Staff Mileage 475 miles X 12 mo X $116,743 $16,781
36.25 FTEs X .565 per mile
Staff & Advisory Board: conference / 10 ind./events X avg cost $30,000 $30,000
training related lodging/travel
Weatherization: DOE
recommended/required
conf/training/tech intensives 6 staff x $1,250 estimated $7,500 $7,500
TOTAL TRAVEL $154,243 $54,281
5. SPACE
TOTAL DES
ITEM BASIS COST COST
TOTAL SPACE $0 $0
6. EQUIPMENT TOTAL DES
COST COST
ITEM BASIS
TOTAL EQUIPMENT $0 $0
7. MATERIALS AND SUPPLIES
TOTAL DES
ITEM BASIS COST COST
CAP/Staff General Office Materials & Avg $3117.25 per month $8,366 $8,366
Supplies/Postage/forms x 12 mo x 22.36%
SAIL General Office Mat's/Supplies Avg $1498.33 per month $17,980 $0
TOTAL MATERIALS AND SUPPLIES $26,346 $8,366
8. OPERATING SERVICES
TOTAL DES
ITEM BASIS COST COST
Advisory Board Meeting support $300 per meeting X 9 meetings $2,700 $2,700
Conference/Training registrations est. 90 registrations X $200 avg $18,000 $18,000
(ACAA, ACEH, ADOH, Family Self-Sufficiency,etc)
Weatherization: DOE required
training /certifications 5 staff x $1360 estimated $6,800 $6,800
Records Mgt Storage/Destruction Based on SFY13 estimate-to-date $4,000 $2,975
Reprographics (printing forms etc.) estimated cost $300 per month $3,600 $760
Monthly Parking $77 X 27 FTE X 12 mo. $34,188 $34,188
Telecom: Estimated charges Based on SFY13 estimate-to-date $19,006 $19,006
Risk and Workmen's Comp. Based on SFY13 estimate-to-date $12,595 $3,153
TOTAL OPERATING EXPENSES $100,889 $87,582

9 INDIRECT COSTS
TOTAL DES
ITEM BASIS COST COST
Maricopa County Human Services 18.80% $487,848 $99,064
provisional indirect cost rate is 18.8% of
Personnel and ERE only
TOTAL INDIRECT COSTS $487,848 $99,064
10 SUBTOTAL ADMIN COST $3,536,319 $948,286
11. VOUCHERS
TOTAL DES
ITEM COST COST
CSBG - On Site - Home Weatherization plus Health & Safety $27,000 $27,000
CSBG - Prevention Rental Eviction/Mortgage Foreclosure/Move-in rent & deposit $100,000 $100,000
TOTAL VOUCHERS $127,000 $127,000
12. TOTAL SERVICE COST/DES TOTAL COST: $3,663,319 $1,075,286
REVENUE SOURCES:
Maricopa County General Fund $1,198,744
Area Agency on Aging Region One $1,373,172
GOEP/DOE $16,117
DES/DAAS $1,075,286 $1,075,286
10/1/2013
TOTAL REVENUE: $3,663,319 $1,075,286