Resolution No. 10-04 CITY OF TIGARD, OREGON
TIGARD CITY COUNCIL
RESOLUTION NO. 10_O Ll
A RESOLUTION TO ADOPT A SUPPLEMENTAL BUDGET TO 1) RE-APPROPRIATE
EXPENDITURES ASSOCIATED WITH THE REORGANIZATION OF ENGINEERING SERVICES;
2) BUDGET $1,730,500 OF AMERICAN RECOVERY & REINVESTMENT ACT (ARRA) FUNDS; 3)
BUDGET 5425,629 OF CARRY-OVER COSTS; AND 4) BUDGET $198,251 OF UNANTICIPATED
REQUIREMENTS
WHEREAS,the City hired an outside consulting film to conduct a review of its engineering services;and
WHEREAS,as a result of the engineering review, the Engineering Services appropriated budget in die amount
of $1,655,195 for 14.5 full-time equivalents (FTE) is being transferred from tine Community Development
Department to the Public Works Department;and
WHEREAS, tine Capital Improvement Program, in addition to 1.5 FTE in the amount of $110,263 of
appropriated budget is being transferred from the Community Development Department to the Finance &
Information Services Department due to the engineering reorganization;and
WHEREAS,an additional cost of 598,782 of expenses were dre result of the engineering reorganization;and
WHEREAS, the City applied for and obtained a 52,398,000 grant and a $2,398,000 safe drinking water
revolving loan as part of the federal government's American Recovery and Reinvestment Act(AIUZA);and
WHEREAS,the City applied for and obtained a$230,500 grant from die Department of Energy;and
WHEREAS,the City expects to spend$1,730,500 of ARRA funds during the current fiscal year,and
WHEREAS, the City recognizes a total of$425,629 in carry-over expenditures and $198,251 in unanticipated
requirements into tine existing budget.
NOW,THEREFORE,BE IT RESOLVED by the Tigard City Council that:
SECTION 1: The FY 2009-10 Budget is hereby amended as detailed in Attachment #1-Supplemental
Budget#10-02 includung Exhibit A.
SECTION 2: This resolution is effective immediately upon passage.
PASSED: This Z' }h day of 2010. ZVI
M- r Ciry of Tigazd
ATTEST:
City Recorder-City of Tigard
1:AOry�oideACounol Rrlcea\Pocka'illAIOUI laA0.esQUU')-SII Supplememntdoe.
RESOLUTION NO. 10 -Oy
Page 1
q ,9,efl -je-4 106�z /
Fiscal Year 2009-10 Budget
lLeee%ved 0 : 1")
Supplemental Budget#10-02
1.a. Engineering Reorganization
Tmnsfer of 14.50 FTE staff msoumes including personal services,mateuals and services,and
capital oudap from Commurnp,Development to Public\ c k,
Transfer of staffing costs for L5 ITE including personal services,and matedsls and services
from Community Development to Finance&Informndon Services.
Revised Revised
Budget Amendment Budget
Genetal Fund
Resources
Beginning Fund Balance $ 8,545,876 $ 8,545,876
Total Resources $ 36,793,430 $ $ 36,793,430
Requi ements
C.umm�ip•Dcvclopmcni S 5,325,778 S (1,765,458) S 3,560,320
Public\corks S 4,581,525 S 1,65,195 S 6,236,720
Program Expenditures Total $ 30,781,088 $ (110,263) $ 30,670,825
Loans S 150,000 S 150,000
Cnpiml P'."m S 768,667 S 768,667
Transfers to Otber Pond, S 971,607 S 110,263 S 1,081,870
Total Budgcr $ 33,421,362 $ $ 33,421,362
Ending Fund Balance $ 3,372,068 $ $ 3,372,068
Total Requirements $ 36,793,430 $ $ 36,793,430
Revised Revised
Budget Amendment Budget
Central Services
Resources
Beginning Fund Balance $ 533,750 $ 533,750
Traasf¢s In from Other Food, S 6,600,899 S 110,263 S 6,711,163
Tonl Resources $ 7,141,987 $ 110,263 $ 7,252,250
Requirements
Po&}m,d Adminisundan S 6,617,284 S 110,263 S 6,727,547
Program Expenditures Taut $ 6,617,284 $ 110,263 $ 6,727,547
Total Budget $ 7,132,710 $ 110,263 $ 7,242,973
Ending Fund Balance $ 9,278 $ $ 9,278
Total Requirements $ 7,141,988 $ 110,263 $ 7,252,251
Page 1
Fiscal Year 2009-10 Budget
Supplemental Budget#10-02
1. b. Engineering Reorganization
Actual costs incurred as a result of the engineering review including report development,
space planning,employee transition costs and expenses for working lunch meetings;plus
anticipated costs for study dmt willallow internal staff costs to be applied to CIP costs for future
capitalization.
Revised Revised
Budget Amendment Budget
Central Services
Resources
Beginning Fund Balance $ 533,750 $ 533,750
Total Resources $ 7,141,988 $ $ 7,141,988
Requirements
City Admimurauon $ 6,617,284 S 92,570 S 6,709,854
Program Expenditures Total $ 6,617,284 $ 92,570 $ 6,709,854
Transfers to Othcc Funds S 265,426 $ 265,426
Conungency S 250,000 $ (92,570) $ 157,430
Total Budget $ 7,132,710 $ $ 7,132,710
Ending Fund Balance $ 9,278 $ $ 9,278
Total Requirements $ 7,141,988 $ $ 7,141,988
Page 2
Fiscal Year 2009-10 Budget
Supplemental Budget#10-02
I.e. Engineering Reorganization
Costs incurred by Conunutilty Development for employee executive coaclung as a result of the
engineering review.
Revised Revised
Budget Amendment Budget
General Fund
Resources
Beginning Fund Balance $ 8,545,876 $ 8,545,876
Property Tves $ 11,640,610 $ 11,640,610
Gmnrs $ 367,492 $ 367,492
Iu mgeney Revenues $ 5,299,942 $ 5,299,942
Fees&Charges $ 1,358,518 $ 1,358,518
Fines and Forfeitures $ 880,876 $ 880,876
Fmncluse Fees $ 4,192,242 $ 4,192,242
I uerest and Rental Eartdngs $ 140,685 $ 140,685
Odter Revenues $ 30,000 $ 30,000
Transfers In from Other Funds $ 4,337,189 $ 4,337,189
Total Resources $ 36,793,430 $ $ 36,793,430
Requirements
Commmtity Development $ 5,325,778 $ 6,212 $ 5,331,990
Program Expenditures Total $ 30,781,087 $ 6,212 $ 30,787,299
Contingency $ 750,000 S (6,212) $ 743,789
Total Budget $ 33,421,362 $ $ 33,421,362
Ending Fund Balance $ 3,372,068 $ $ 3,372,068
Total Requirements $ 36,793,430 $ $ 36,793,430
Page 3
Fiscal Year 2009-10 Budget
Supplemental Budget#10-02
2.a.American Reinvestment& Recovery Act Funds
Recognition of federal funds associated with water-related capital improvement projects.
Total federal funds are$4,796,000. Anticipate spending S75 tnil in FY 2010 midi remainder
in FY 2011.
Revised Revised
Budget Amendment Budget
Water CIP
Resources
Beginning Fund Balance $ 38,486 $ 38,486
Gents $ - $ 750,000 $ 750,000
` Pees&Charges $ 90,000 $ 90,000
Interest and Rental Eanvngs S 34,564 $ 24,564
Bond/Note Proceeds S 2,600,000 S 750,000 $ 3,350,000
Tnmsfers In from Other Funds S 4,961,585 $ 4,961,585
Total Resources $ 7,714,635 $ 1,500,000 $ 9,2142635
Requirements
Program Eapenditutes Total $ - $ - $ -
Loans S 150,000 $ 150,000
Capind Projects 5 7,558,611 S 1,500,000 $ 9,058,611
Total Budget $ 7,708,611 $ 1,500,000 $ 9,208,611
Ending Fund Balance $ 6,024 $ - $ 6,024
Total Requirements $ 7,714,635 $ 19500,000 $ 9,214,635
Page 4
Fiscal Year 2009-10 Budget
Supplemental Budget#10-02
2.6.American Reinvestment& Recovery Act Funds
Recognition of Department of Energy grant funding associated with facility-related capital
improvement projects.
Revised Revised
Budget Amendment Budget
Facilities Fund
Resources
Beginning Fund Balance $ 348,440 $ 348,440
Gtants _ S - $ 230,500 $ 230,500
Interestand Rewal Eetaings $ 3,932 S 3,932
Transfers 1v from Otlrer Funds $ 350,000 5 350,000
Total Reson aces $ 702,372 $ 230,500 $ 932,872
Requirements
Program Expenditures Total $ $ $
capital Projects $ 155,000 $ 230,500 $ 385,500
Total Budget $ 178,250 $ 230,500 $ 408,750
Ending Fund Balance $ 6,024 $ $ 6,024
Tocol Requirements $ 184,274 $ 230,500 $ 414,774
Page 5
Fiscal Year 2009-10 Budget
Supplemental Budget#10-02
3.a-d Carry Forward Adjustments
Recogtudon of items that were incurred in FY 08-09 and weve not adequately carried over to
the F1 2009-10 budget.
A total of$23,000 for the Nbcrosoft Enterprise agreement and$17,000 for Ammunition will be
expensed from the General Fund;$135,629 in Park SDC funds wiu be expensed for the Fano
Creek Park project;and 5250,000 from the Traffic Impact Fee Fund will be utilized for the
Burnham St.project.
Revised Revised
Budget Amendmenr Budget
General Fund
Resources Beginning Fund Balance $ 8,545,876 $ 40,000 $ 8,585,876
Total Be sources $ 36,793,430 $ 40,000 $ 36,833,430
Requirements
Poli',and Admi.wenon S 321,237 S 23,000 S 344,237
Camnnohy Services S 20,068,571 S 17,000 S 20,085,571
Program Expenditures Total $ 30,781,088 $ 4'000 $ 30,821,088
Total Budget $ 33,421,362 $ 40,000 $ 33,461,362
Ending Fund Balance $ 3,372,068 8 $ 3,372,068
Total Requirements $ 36,793,430 $ 40,000 $ 36,833,430
Page 6
Revised Raised
Budget Amendment Budget
Parks SDC
Resources
Beginning Fund Balance $ 2,185,472 $ 135,629 $ 2,321,101
Total Resources $ 2,391,772 $ 135,629 $ 2,527,401
Requirements
Program Expenditures Total $ $ $
C,tphA Pmj," S 580,016 S 135,629 S 715,645
Total Budget $ 1,397,674 $ 135,629 $ 1,533,303
Ending Fund Balance $ 994,098 $ $ 994,098
Total Requirements $ 2,391,772 $ 135,629 $ 2,527,401
Revised Revised
Budget Amendment Budget
Traffic Impact Fee
Resourres Beginning Fund Balance $ 1,167,220 $ 250,000 $ 1,417,220
Total Resources $ 1,329,822 $ 250,000 $ 1,579,822
Requirements
Program Expenditures Total $ $ $
Capiml Pmjects S 950,000 S 250,000 S 1,00,000
Total Budget $ 1,305,294 $ 250,000 $ 1,555,294
Ending Fund Balance $ 24,528 $ $ 24,528
Total Requirements $ 1,329,822 $ 250,000 $ 1,579,822
Page 7
Fiscal Year 2009-10 Budget
Supplemental Budget#10-02
4.a-d.Unanticipated Requirements
Recogtdtion of unanticipated items that should be included in the n-2009-10 budget.
A total of$15,251 for costs related to die November 3,2009 elections and$95,000 for die strategic
damp initiative vill be appfied to the General Fund;and$28,000 for die Ash Creek
Forest Mvcagement and$60,000 for die Community.Tree Maintenance Progmms ivill be
expensed in die Storm Water Fund.
Revised Revised
Budget Amendment Budget
General Fund
Rcsaur
cs Beginning Fund Balance $ 8,545,876 $ 95,000 S 8,640,876
Total Resources $ 36,793,430 $ 95,000 $ 36,888,430
Requirements
Cim Administradac S 483,976 S 15,251 5 499,227
CommuniqDevelopment 5 5,325,778 5 31,666 S 5,357,444
Program Expendimres Total $ 30,781,087 $ 46,917 $ 30,828,004
Tcae,L,s to Other funds S 971,608 S 63,334 S 1,034,912
Condngcocy S 750,000 S (15251) 5 734,749
Total Budget $ 33,421,362 $ 95,000 $ 33,516,362
Ending Fund Balance $ 3,372,068 $ $ 3,372,068
Total Requirements $ 36,793,430 $ 95,000 $ 36,888,430
Revised lievised
Budget Amendment Budget
Centtal Services
Resources
Beginning Fund Balance $ 533,750 $ 533,750
'1'rnasfcrs In from Othcr Funds S 6,600,900 S 63,334 S 6,664,234
Total Rcsourcru $ 7,141,988 $ 63,334 $ 7,205,322
Requi ,mems
Policy and Adminlstrarion S 6,617,284 S 63,334 5 6,680,618
Program Expendimrcs Total $ 6,617,284 $ 63,334 $ 6,680,618
Total Budget $ 7,132,710 $ 63,334 $ 7,196,044
Ending Fund Balance $ 9,278 $ $ 9,278
Total Requirements $ 7,141,988 $ 63,334 $ 7,205,322
Rcviscd Rcviscd
Budget Amendment Budget
st..,rttcr
Resources Beginning Fund Balance $ 441,292 $ 88,000 $ 529,292
'1'mnefurs In from Othur Funds 5 S
Total Resources $ 2,211,251 $ 88,000 $ 2,299,251
Regatremenrs
Pablic Works S 1,409,117 S 88,000 S 1,497,117
Prngmm Expenditures Total $ 1,409,117 $ 88,000 $ 1,497,117
Total Budget $ 2,186,052 $ 88,000 $ 2,274,052
Ending Fund Balance $ 25,199 $ $ 25,199
Total Requirements $ 2,211,251 $ 88,000 $ 2,299,251
Page 9
City of Tigard Exhibit A
Schedule of Appropriations
Project/Contract Description Dept/Div. Amount Comments
Requested
1. Engineering Reorgmaizatian Costs
a. Enginaedng P.euryarriaa¢on of Depnronent Badgers CD/PW/PIN S 1765,458 Indcdcs personal scnices, M&S,and riatio,.
b.Eonnecdng Rcarg Cosrs CD/PW 5 92,570 Addidood mars n= .rnccdwirh rhe Engineering Renrganbadon.
a Lseeudve Coaching Setvieea CD 5 6,212 Addition,]cox amciared airh it,P.np ing Reorganianion.
Total Reaganizadon Costs $ 1,864,240
2. Amerman Reinocsm.ent&Recovery Aa Rr—r n,
a. 10 MG] ,,I: PW S 1,500,000 ARRA Fcdenl Grant
Dcpa,enem oC linergy fending for the ins colla tion of v:Eu-,Sue roof un rhe Permit
b- DOE Energy EEfiarnep Bloelr Gnor Rnvcnoc AV 5 230,500 Cenm,.
Total ARRA Funds 5 1,730,500
3. Carry Cvif Arnounta
a. M¢nsoft T?nrcrprae.Agreemen,(pontic side) [.ihmry/IT $ 23,000 Service—pndCur by IT bat u-.s rmr cintird fomInd&om FY 08-09.
h. Ammnnitinn Pohre $ 17,0110 Or,]- a.not n,t,id prior tu]o:a 30,11 doe m nndrnnhde supply and demand pmbitru
e. Eninu Cree!t Pndt PW S 135,629 Fanno Cce k Poek,.fn ah design plans.
d. Burnham St Acyni,idons PW S 250,000 To noon remaining acquisitions that umre budgeted in FY 08-09.
Toral Carry OverA ,naris 5 425,629
4. UnondcMatcd R,gahcmcnu
. Ash Ctccic Faresv Mamgcmcnr PW s 28TOn Rt, go:cft,n scraiacs
h. Community Tree Flooring\4ainrenance PW S 60,000 Re-veye,tiun services
e Washington County Ass,.mem&Taavd-r 1 .AJr'n/NTa,, S 15,251 Nov.3,2009 dccdoo cows
d. Smaeync Clarity Initiadve CD/FWAdmin $ 95,000 Roiiout of Corrigio study for CD,Finance,and City Admitistndon
Total Unandd atcd Rc a cats 5 198,251