UNI UNIFIED WORK PROGRAM
Fiscal Year 2012
July y 1, 2011 through June 30, 2012
East Central Intergovernmental Association Dubuque Metropolitan Area Transportation Study E.C.I.A. Regional Planning Affiliation E.C.I.A. Business Growth, Inc. East Central Iowa Economic Development District Eastern Iowa Regional Housing Authority Eastern Iowa Regional Housing Corporation Eastern Iowa Development Corporation Region 1 Employment and Training Eastern Iowa Regional Utility Service Systems Commission Prosperity Eastern Iowa Region 8 Regional Transit Authority Jule Transit East Central Intergovernmental Association 7600 Commerce Park Dubuque, Iowa 52002 www.ecia.org
COST ALLOCATION PLAN General The Cost Allocation Plan of ECIA is the basis of assigning costs equitably to all projects during each fiscal year. Under the plan, the total costs assigned to each project are comprised of both direct and indirect costs. All direct and indirect costs are further identified as to personnel and non-personnel costs. The distinctions of cost allocation are described in the following definitions: Definitions Direct Personnel Costs are costs of all personnel activities identifiable to specific projects. Examples of Direct Personnel Costs include personnel time spent on planning activities, administration of housing assistance and Community Development Block Grant Programs. (see Schedule A) Direct Non-Personnel Costs are the costs of non-personnel items or service clearly incurred by specific projects. Direct non-personnel costs include project related items such as contracted services, data processing, project report publishing, reproductions, travel, supplies, reference materials, staff development, long-distance telephone calls, project audit fees, project inspection fees, advertising, postage, memberships, and other costs similarly identifiable to specific projects. (see Schedule B) Indirect Personnel Costs are costs of all personnel activities that are not identifiable to specific projects but support all project activities. Examples of Indirect Personnel Costs include personnel time spent on producing the Unified Work Program, policy meetings, and agency general and fiscal management. (see Schedule C) Indirect Non-Personnel Costs are the costs of all non-personnel items or service that are not directly attributed to specific projects but rather are attributed to overall operation of the agency including all projects. Indirect non-personnel costs include such items as office rent, equipment rental, base telephone and overall agency long-distance calls, postage, advertising, travel, staff development, insurance-bonds, office supplies, reproductionspublications, agency memberships, reference materials, agency audit, and other such costs similarly attributed to total agency and all project support. (see Schedule D) Cost Allocation to Projects Each project that is active during the fiscal year receives an allocation for costs as follows: A. Direct personnel costs for the month B. Direct non-personnel costs for the month C. A share of all indirect costs for the month The monthly share of indirect costs charged to each project is determined by the ratio of each respective project’s direct personnel costs relative to the total direct personnel costs of all projects. Monthly timesheets are maintained by all agency personnel and serve as the basis for such allocations.
2
Cognizant Agency The Federal Agency from which the most direct federal funds are received. Responsible for establishing the accounting rules for the receipt and expenditure of federal funds and approving the cost allocation plan. Supporting Data Following are the schedules which clarify all cost items embraced by the Cost Allocation Plan: Schedule A - Direct Personnel Activities Schedule B - Direct Non-Personnel Costs Schedule C - Indirect Personnel Activities Schedule D - Indirect Non-Personnel Costs Schedule A Direct Personnel Activities
Schedule C Indirect Personnel Activities
Transportation Planning and Grant Administration Transit Planning and Grant Administration Regional Development Local Comprehensive Planning Housing Assistance Programs Community Development Block Grant Contract Administration Community Technical Assistance Contracted Services Leaves for personnel involved in direct activities
Unified Work Program Project Notification and Review Policy Meetings Filing and Library System Census Program Agency Information Maintenance Agency Newsletter Agency Fiscal Management Agency General Management Leaves for personnel involved in indirect activities
Schedule B Direct Non-Personnel
Schedule D Indirect Non-Personnel
Project-related Office Supplies Project-related Operating Materials, Books Project-related Conference and Training Expenses Project-related Business Expense Project-related Printing and Binding of Publications Project-related Insurance and Bonds Project-related Professional Memberships Project-related Telephone Expense Project-related Postage and Shipping Project-related Advertising Project-related Professional Services Project-related Equipment
Overall Agency Office Supplies Overall Agency Operating Materials and Books Overall Agency Conference and Training Expense Overall Agency Business Expense Overall Agency Printing and Binding of Publications Equipment Rent and Maintenance Overall Agency Insurance and Bonds Overall Agency Professional Memberships Office Utilities Base Telephone and Overall Agency Cellular and Long-Distance Services Overall Agency Postage and Shipping Office Rent Overall Agency Advertising Overall Agency Professional Services Overall Agency Equipment
ECIA Workforce Housing Program Participants
3
Timesheet Codes 000 INDIRECT ACTIVITIES 13990 ECIA Fiscal Management 15990 ECIA Gen Management 16990 Building Maintenance 030 TRANSPORTATION (MPO) 13990 Program Fiscal Management 15990 ECIA Gen Management 35329 Gen Coordination 35341 LRTP 35342 Research & Database Mgmt 35344 Traffic Count Program 35352 Short Range Planning 35361 TIGER I Grant Admin 35366 Misc Mapping Projects 35369 Mississippi River Partnership 35400 Dbq County Sustainable Comp Plan 35450 Clean Fuels Grant Admin 35500 3D Web Design 35550 Jule Google Transit Project
050 ECONOMIC DEVELOPMENT 11970 Local Govt Mtgs 11980 Conference & Training 12910 Info Dissemination 13950 Grant/Loan Apps 13990 Program Fiscal Management 15990 ECIA General Management 54110 Econ Dev Tech Asst 54120 Data Center 54130 CEDS 54214 ECO-EI/Petal 055 EIRHA 11980 Conference & Training 13990 Program Fiscal Management 15990 ECIA General Management 55100 Public Hsg Maintenance 55250 ROSS FSS Service Coord 55300 Sect 8 Admin 55350 Sect 8 Home Ownership 55400 Sect 8 FSS Service Coord #1 55450 Sect 8 FSS Service Coord #2
040 GENERAL TA 11970 Local Govt Mtgs 11980 Conference & Training 056 EIRHC-USDA 12910 Info Dissemination 56000 Worthington Site Management 13910 Budget/Financial Asst 56050 Worthington Management Fee 13950 Grant/Loan Apps 56100 Worthington Maintenance 13990 Program Fiscal Management 56200 Grand Mound Site Management 15910 Ordinances 56250 Grand Mound Management Fee 15920 Codification 56300 Grand Mound Maintenance 15930 Community Assistance 15970 Annexation 065 EIDC-TAX CREDIT 15980 Mgmt Tech Asst 65000 Evergreen Meadows Mgt 15990 ECIA General Management 65100 Evergreen Meadows Maint 41166 CAT Grant Writing 65200 Asbury Meadows Mgt 41175 Small City Actg/Utility Billing 65300 Asbury Meadows Maint 41176 ASAC Grant Writing 41180 Special Projects 066 EIRHC-EIDC 41181 Dub Acq/Relocation 66500 NP3 Housing Counseling 41185 Environmental Assessments 41187 Strategic Planning 067 IFA COMPLIANCE 41191 Zoning Asst 67100 IFA File Review/Inspections 41193 Land Use Plans 67500 HPRP Compliance Reviews 41196 Peosta Inspection 41197 Asbury Inspections Americorps Member ECIA Intern facilitating the Fun for Kids program 41198 Other Inspections 41200 Clinton Sustainable Comp Plan 41300 Delaware Co Sustainable Comp Plan 41400 Bus Livability Grant 41401 State of Good Repair Grant 41402 TIGGER Grant 41403 TIGER Grant
4
045 ECIA BUSINESS GROWTH 13990 Program Fiscal Management 15990 ECIA General Management 45800 HQS Inspections 45930 Bus. Growth - SBA 504 45950 Bus. Growth - EDA/RLF
Timesheet Codes 075 PROMISE JOBS 13990 Program Fiscal Management 15990 Program Gen Management 75000 Promise Jobs 75100 Workplace Essentials 75300 PJ Admin 080 TRANSPORTATION (RPA) 13990 Program Fiscal Management 15990 ECIA General Management 35370 General Prog Coordination 35372 RPA LRTP 35373 Research & Database Mgmt 35374 Mapping Projects 35377 Short Range Planning 35378 Maquoketa Model Maint. 35379 Clinton Model Maint. 35387 Traffic Count Program 35388 Safe Routes to School-Del Cnty 35389 Safe Routes to School-W Dbq 35390 Safe Routes to School-Jackson County 35391 Safe Routes to School-Clinton County 35400 Dbq County Sustainable Comp Plan 085 CDBG ADMINISTRATION 11980 Conference & Training 13990 Program Fiscal Management 15990 ECIA General Management
Delaware County 87009 Delaware County HMGP 87013 Edgewood Emergency Response Center 87014 Edgewood Safe Room 87025 Hopkinton 2010 HMGP 87026 Hopkinton PA Demo 87027 Delaware County PA Demo 87065 Manchester 2010 HMGP 87071 Manchester Water System Imp 87072 Manchester 2010 HOAP Gen Admin 87080 Colesburg WWTF 87092-97 Manchester Hoap Rehab and LBP Admin Dubuque County 88120 Cascade Rehab-Gen Admin 88121 Cascade Rehab-Rehab Admin 88122 Cascade Rehab-LBP Admin 88215 Dyersville CDBG Buyout 88220 Dubuque County EECBG 88250 CARADCO 88300 West Dbq Safe Room Jackson County 89010 Jackson County HMGP 89101 Sabula Levee Project 89200 Leisure Lake-WIRB 89228 Maquoketa 2010 Rehab Gen Admin 89229 Maquoketa 2010 Rehab and LBP Admin
Flood Recovery Programs 14990 New Production 15000 Iowans Helping Iowans 14997 Jumpstart Federal Gen Mgt 14998 Jumpstart Federal Project Delivery 15994 FEMA Buyout Gen-Dyersville 15996 FEMA Buyout Gen-Cedar County 17994 FEMA Demo General-Dyersville 17995 FEMA Demo General-Manchester 17996 FEMA Demo Gen-Cedar County New Production Program 70100 NP3 Program Admin 70200 NP3 Project Delivering Cedar County 85030 Cedar County CDBG Buyout Clinton County 86008 Clinton County HMGP 86069 Clinton ASAC/New Directions 86072 Camanche WWS Improve 86091 Low Moor WWTF
Construction in Dyersville under the New Production Program
5
Timesheet Codes 100 WIA 13990 Program Fiscal Management 15990 ECIA General Management 01100 Admin 01200 Adult Formula 01300 Youth In-School Formula 01400 Youth Out-School Formula 01500 Dislocated Worker Formula 108 EAGLE/FEATHERLITE NEG 11100 Admin 11400 Program Management 109 SEVERE STORMS NEG 11100 Admin 11400 Program Management 119 THERMO FISHER NEG 11100 Admin 11900 Program Management 120 OJT NEG 12100 Admin 12900 Program Management 140 GREEN JOBS GRANT 11100 Admin 13990 Fiscal Management 11400 Program Management 145 SESP Grant 13990 Fiscal Management 11400 Program Management
300 EIRUSS 13990 Program Fiscal Management 15990 ECIA General Management 03000 Program Administration 03002 Fairview 03003 Elvira 03004 Leisure Lake 03005 Lake Delhi 03006 Petersburg 03008 Morley 03100 DNR Grant Admin 03200 Center Junction Operations 03300 Andover Operations 400 RTA 11980 Conference & Training 13990 Program Fiscal Management 15990 ECIA General Management 04000 Program Administration 04500 Dispatch 04600 Mobility Coordinator 04900 Grant Writing 410 THE JULE 11980 Conference & Training 13990 Program Fiscal Management 15990 ECIA General Management 04000 Program Administration 500 ECIA/IWD 28-E-REGIONAL COORD 15990 ECIA General Management
200 EDSA/PFSA 13990 Program Fiscal Management 15990 ECIA General Management 02300 HUSCO (Jackson County)
New Jule Sprinter bus with advertising
6
ECIA Budget REVENUES * MEMBERSHIP FEES
FY2009
FY2010
FY2011
FY2011
FY2012
ACTUAL
ACTUAL
BUDGET
AMENDED
BUDGET
$90,242
$94,166
$98,089
$95,982
$99,835
DMATS (FWHA, FTA) City of Dubuque /County/EDBQ Misc. Contracts/3D Web Safe Rt. To School Google Transit Project
$133,315 $11,000 $9,211 $24,609
$133,927 $11,000 $23,031 $14,616
$138,081 $13,299 $0 $62,324
$148,780 $13,385 $27,255 $0
$164,838 $16,299 $10,666 $0 $40,000
STP RURAL Misc. GIS Projects Service Fees Safe Routes to School
$92,737
$96,527
$104,570
$106,296
$105,798
$1,375 $15,000
$1,375 $48,777
$1,375 $34,045
$1,375 $95,000
$3,375 $70,000
EDA
$43,612
$71,629
$62,000
$63,700
$35,480
STATE
$9,412
$8,470
$9,000
$10,294
$9,000
WIA PROGRAMS
$262,097 $45,082 $245,386
$289,040 $128,039 $261,354 $51,029
$326,705 $28,598 $255,981
$501,305 $0 $354,544 $70,000
$149,682
$166,963
$286,481
$376,216 $23,913 $324,119 $90,071 $2,319 $203,796
BUS GROWTH GREEN JOBS GRANT
$242,581
$246,545 $3,735
$267,425
$258,527 $16,864
$289,781 $3,136
EIRHA EIRP Housing EIRHC USDA Housing IFA Tax Credit Compliance Housing Counseling
$1,197,438 $36,155
$1,220,777 $15,423
$1,334,105 $15,000
$38,675
$19,079
$27,235
$1,268,065 $17,313 $4,473 $29,925 $16,067
$1,273,173 $17,000 $5,000 $15,519 $101,210
RTA CITY OF DUBUQUE JULE Jule Mobility Coordinator Grant
$367,775
$412,422
$440,290 $290,760
$409,448 $290,760
$504,323 $305,298 $91,879
CDBG CONTRACTS FEMA Buyouts Flood/New Productions/FEMA EDA Flood Cedar County FEMA CDBG EDSA, PFSA EIRUSS UTILITY
$300,682 $1,039 $27,498 $72,338 $12,568 $2,110 $57,988
$362,123 $104,616 $120,304 $37,706 $17,323 $280 $57,318
$361,688
$345,000
$510,214
$312,802 $49,025
$343,373 $67,956
$395,678
$9,616 $34,045
$2,507 $26,520
$9,446 $30,000
SERVICE FEES Misc. Land Use Contracts Misc. Contracts and Plans Utility Billing Misc. Prog. 40 Service Fees Misc. grant writing/strategic planning Asbury Inspections City Codes Dubuque Acquisition/Relocation Proj. 50 Serv. Fees CAT/EDA Grants IDED Partnership Grants EDA Technical Assistance Grant Peosta Inspections IDED Partner Match
$245,818 $2,834 $11,590 $1,413 $2,115
$186,090 $1,259
$142,250 $11,500
$27,975
$1,581 $2,525 $5,422 $44,196 $8,948 $8,543 $4,103 $17,135 $68,141 $0 $0 $24,237
$5,000 $52,750 $0 $0 $21,000
$197,200 $3,716 $4,401 $1,000 $8,856 $3,497 $69,445 $5,315 $2,958 $3,714 $0 $52,860 $0 $2,194 $39,244
$257,429 $58,027 $76,000 $0 $0 $2,000 $42,000 $7,500 $2,958 $0 $5,000 $20,000 $2,000 $8,194 $33,750
INT.-OTHER
$6,131 $308,220 $4,049,776
$2,887 $41,707 $4,248,278
$2,500 $25,000 $4,732,289
$1,251 $30,405 $4,908,155
$1,500 $22,000 $5,483,759
$3,955,575 $1,013,052
$2,170,458 $1,524,821 $66,766
$2,000,000 $1,000,000 $70,000
$1,350,000 $1,050,000 $21,426
$1,000,000 $1,000,000 $2,000,000
$4,527 $55,965 $21,199 $18,427 $8,110,441
$4,000 $53,000
$2,372 $58,532
$55,000
$7,859,289
$164 $7,390,649
$9,538,759
WIA STIMULUS PJ REGIONAL COORDINATOR 28E SESP DISCRETIONARY
Proceeds from LT Borrowing Subtotal Pass Thru - Flood WIA Program Costs Pass-through NP3 Downpayment Flood Recovery Funds Business Growth for Signage Proceeds from vehicle sale Agency Vehicle usage XRF Grant and Useage Other Miscellaneous TOTAL
$33,648 $9,687 $41,586 $150 $2,459 $96,000 $16,361
$2,000 $40,000 $10,000
$170,033
$20,129 $10,613
$10,086 $9,059,231
Billable hours based on updated rates of $73 Program Directors (grade 16 and up); $58 Project Managers (grades 12-15); $45 Administrative Support Staff (grades 2-11).
7
ECIA Budget, continued EXPENDITURES Salaries/Benefits
FY2009 ACTUAL
FY2010 ACTUAL
FY2011 BUDGET
FY2012 BUDGET
$2,990,557
$3,433,561
$3,884,913
$4,081,000
$4,575,120
Office Supplies/Materials
$44,330
$67,871
$70,000
$61,000
$70,000
** Conferences & Training
$51,762
$36,932
$46,100
$48,000
$56,400
Business Travel & Expense (WIA Travel, mileage, cars)
$106,675
$163,020
$159,500
$159,000
$165,500
Printing (Brochures, cards, stationary, signs)
$14,490
$15,352
$25,000
$12,800
$16,000
Equipment Rental & Maintenance
$17,120
$10,398
$12,000
$8,000
$12,000
Insurance
$23,719
$21,440
$24,000
$20,675
$40,000
Dues and Subscriptions
$15,128
$16,146
$22,000
$23,600
$27,000
Telephone
$29,757
$31,929
$40,000
$33,700
$36,000
Postage
$42,466
$41,824
$45,000
$35,000
$38,000
***Building Rent & Property Taxes
$63,517
$30,339
$31,000
$25,936
$28,000
Utilities & Maintenance
$26,773
$37,523
$35,000
$29,400
$33,000
Building Loan Interest
$66,176
$75,958
$72,000
$69,915
$68,200
$6,000
$13,200
$15,000
Interest on Line of Credit Advertising
$4,635
$5,900
$15,000
$17,000
$20,000
Professional Services/Computer
$62,071
$75,620
$66,000
$77,200
$82,000
Equipment / car
$66,321
$59,642
$68,000
$66,600
$56,800
$284,959
$0
$0
$0
$0
$3,470
$20,999
$0
$0
$0
$13,924
$0
$0
$0
$0
$43,357
$43,600
$46,000
Land/Building Construction Grant Funded Equipment Purchase Relocation Expenses WIA & ECIA WIA IWD Site Coordinator Collaborative Marketing (Direct expenses mrkt no staff)
$96,837
$51,300
$35,000
$35,018
$40,000
$9,339
$3,616
$5,900
$4,625
$9,250
$35,904
$49,611
$50,000
$68,300
$68,300
Subtotal
$4,069,930
$4,248,981
$4,755,770
$4,933,569
$5,502,570
Pass-through Flood WIA Program Costs Pass-through NP3 Downpayment Total
$3,955,575 $1,013,052 $9,038,557
$2,170,458 $1,524,821 $66,766 $8,011,026
$2,000,000 $1,000,000 $70,000 $7,825,770
$1,350,000 $1,050,000 $21,426 $7,354,995
$1,000,000 $1,000,000 $2,000,000 $9,502,570
$20,674
$99,415
$33,519
$35,654
$36,189
$253,976
$274,650
$374,065
$374,065
$409,719
$0
$20,000
$10,000
$10,000
$10,000
$274,650
$354,065
$377,584
$379,719
$405,908
$20,000
$30,000
$30,000
$40,000
$274,650
$374,065
$407,584
$409,719
$445,908
$56,973
$73,944
$67,000
$73,926
$73,926
Miscellaneous (Team Bldg, Misc., Bldg, GEDDUP) Long Term Debt (principal)
Excess Revenue/Expenses Fund Balance at Beginning of Year Transfer to Bldg. Reserve fund Unrestricted Fund Balance at End of Year Restricted Fund Balance at End of Year Total Fund Balance at End of Year
8
FY2011 AMENDED
Depreciation Expense