The URL can be used to link to this page

Home My WebLink AboutRes 026 - Adopt DC Supplemental Budget 2011-12Deschutes County Board of Commissioners 1300 NW Wall St., Suite 200, Bend, OR 97701-1960 (541) 388-6570 -Fax (541) 385-3202 -www.deschutes.org AGENDA REQUEST & STAFF REPORT For Board Business Meeting of April 11, 2012 Please see directions for completing this document on the next page. DATE: Apri14,2012 FROM: Marty Wynne Finance (541) 388-6559 TITLE OF AGENDA ITEM: Consideration and signature of Resolution #2012-026, adopting a supplemental budget of the Deschutes County Budget for F iscal Year 2011-2012. PUBLIC HEARING ON THIS DATE? YES BACKGROUND AND POLICY IMPLICATIONS: Consideration of Resolution #2012-026 to adopt a supplemental budget and make appropriations totaling $29,201,944. Funds included on the supplemental budget are the General Fund (001), the General County Projects Fund (142), the Special Transportation Fund (150), the Community Development Fund (295), the Road Department Fund (325), the Sisters Health Clinic Fund (464), the Full Faith & Credit Ref Series 2012 Fund (535), the RV Park Fund (601), the Solid Waste Fund (610), the Fair & Expo Center Fund (618), the Building Services Fund (620), the Administrative Services Fund (625), the Board of County Commissioners Fund (628), the Finance Department Fund (630), the Legal Department Fund (640), the Personnel Department Fund (650), the Information Technology Fund (660), and the Insurance-Risk Management Fund (670). FISCAL IMPLICATIONS: The supplemental budget will increase the budget by $29,201,944. The total of the County budget after adoption of the supplemental will be $298,818,903. RECOMMENDATION & ACTION REOUESTED: Approval and signature of Resolution #2012-026. ATTENDANCE: Marty Wynne DISTRIBUTION OF DOCUMENTS: Marty Wynne, Finance Department 388-6559 Teri Maerki, Finance Department 388-6536 REVIEWED LEGAL COUNSEL For Recording Stamp Only BEFORE THE BOARD OF COUNTY COMMISSIONERS OF DESCHUTES COUNTY, OREGON A Resolution Adopting a Supplemental * Budget of the Deschutes County Budget for * RESOLUTION NO. 2012-026 Fiscal Year 2011-2012 and Making Appropriations. * WHEREAS, there are several funds in the Deschutes County 2011-2012 Budget that have additional resources which were not ascertained at the time of the preparation of the budget which requires a change in financial planning; and WHEREAS, these additional revenues and expenditures must now be appropriated; and WHEREAS, ORS 294.480 authorizes the adoption of a Supplemental Budget; and WHEREAS, Notice of Supplemental Budget Hearing and Summary was published in the Bulletin on April 5,2012; now, therefore, BE IT RESOLVED BY THE BOARD OF COUNTY COMMISSIONERS OF DESCHUTES COUNTY, OREGON, as follows: Section 1. The Board of County Commissioners hereby adopts the attached Supplemental Budget for Fiscal Year 2011-2012, marked as Attachment "A," attached hereto and by this reference, incorporated herein. Section 2. The amounts set forth in the Adopted Supplemental Budget are hereby appropriated in the amounts set forth in Section 1 of this Resolution. Section 3. That the Finance Director makes the appropriate modifications to the 2011-2012 Fiscal Year Budget to reflect the adoption of the Supplemental Budget as set forth in Section 1 of this Resolution. DATED this ___th day of April, 2012. BOARD OF COUNTY COMMISSIONERS OF DESCHUTES COUNTY, OREGON ANTHONY DEBONE, Chair ATTEST: ALAN UNGER, Vice-Chair Recording Secretary TAMMY BANEY, Commissioner PAGE I OF I-RESOLUTION :-lO. 2012-026 (4/11112) Deschutes County FY 2012 Supplemental Budget -Attachment A J J Adjusted I I Revised IFund Account Code Budget Supplemental Budget Comments 001 General Fund Transfers Out-Building Services (620) 001-4500-491.96-32 -33,105 33,105 Assist in reducing future internal service charges to departments Transfers Out-Information Technology (660) 001-4500-491.96-38 66,000 31,851 91,851 Assist in reducing future internal service charges to departments Transfers Out-Community Development (295) 001-4500-491.96-41 1,124,985 100,000 1.224,985 COD beginning net working capital lower than budget Transfers Out-General County Projects (142) 001-4500-491.96-54 103,219 250,000 953,219 Reserve for future capital projects Transfers Out-Risk Management (670) 001-4500-491.96-61 -200,000 200,000 Workers' compensation claims higher than anticipated Transfers Out-Admin Services (625) 001-4500-491.96-72 40,000 13,211 .. n:::::=::~:HAssist in reducing future Internal service charges to departments Transfers Out-Admin Services (625) 001-4500-491.96-12 :,', 143,900 191.111 Personnel and Software expenditures higherthan anticipated Transfers Out-RV Park (601) 001-4500-491.96-15 -110,000 110,000 RV Park beginning net working capital and revenues lower than budget Transfers Out-Legal (640) 001-4500-491.96-71 -10,809 10,809 Assist in reducing future internal service charges to departments Transfers Out-Finance (630) 001-4500-491.96-86 -16,154 16,154 Assist in reducing future internal service charges to departments Transfers Out-BOCC (628) 001-4500-491.96-81 -5,801 5,801 Assist in reducing future internal service charges to departments Transfers Out-Personnel (650) 001-4500-491.96-88 -12,463 12,463 Assist in reducing future internal service charges to departments Transfers Out Category Totals 12,945,110 927,900 13,873/010 Contingency 001-4500-501.97-01 6,692,025 {921,900) 5,764,125 Transfers Out increased to County funds Contingency Category Totals 6,692,025 (927/900) 5/764,125 Total General Fund Requirements 32.672.802 -321612.802 142 General County Prolects Transfers In-General Fund 142-0000-391.11-00 703,279 250,000 953,219 Reserve for future capital projects Total General County Projects Resources 4.6601298 2501000 4.910 1298 Contingency 142-0800-501.91-01 2,851,201 250,000 3,107,207 Resources increased for future capital projects Contingency Category Totals 2/857/207 250,000 3,107,207 Total General County Projects Requirements 41660.298 2501000 4,910.298 295 Community Development Transfers In-General Fund 295-3601-391.11-00 629,625 100,000 729,625 Cash transfer for negative Beginning Net budget to actual variance Total Community Development Resources 4 1316,213 100,000 414161213 Contingency 295-3601-501.91-01 252,128 100,000 352,128 Resources increased for transfer Contingency Category Totals 252/128 100,000 352,128 Total Community Development Requirements 4,316,213 100,000 4,416.213 601 RV Park Transfers In-General Fund 601-0000-391.11-00 -110,000 110,000 Cash transfer for negative budget to actual variance Total RV Park Resources 343.493 110,000 453,493 Contingency 601-1000-501.91-01 14,942 110,000 124,942 Resources increased for transfer Contingency Category Totals 14,942 110/000 124,942 Total RV Park Requirements 343.493 110.000 453.493 Page 1 of 4 Deschutes County FY 2012 Supplemental Budget -Attachment A I Adjusted Revised Fund I Account Code Budget 1sUPPlementall Budget I Comments 620 Building Services Transfers In-General Fund Total Building Services Resources 620-0000-391.11-00 - 2,783,625 33.705 33105 33.705 2,817,330 Assist in reducing future internal service charges to departments Contingency Contingency Category Totals Total Building Services Requirements 620-1000-501.97-01 300.682 300,682 2,783,625 33.705 33,705 33,705 334,387 334,387 2,817,330 Resources Increased for transfer 625 Administrative Services Transfers In-General Fund Transfers In-General Fund 625-0000-391.11-00 625-0000-391.11-00 40,000 :::::~:j:;:;" :':-::::::::~;. 13,217 143,900 197,117 in reducing future internal service charges to departments Transfer for Personnel and Software expenditures Total Administrative Services Resources 1,104,738 157,117 1,281,855 County Administrator Time Management Life & Long Term Disability FICA/Medicare PERS 625-0800-413.10-01 625-0800-413.18-72 625-0800-413.21-10 625-0800-413.22-01 625-0800-413.23-01 167,446 6,000 3,674 42,543 77,732 96,000 24,000 4,000 1,000 15,000 263,446 30,000 7,674 43,543 92,732 Costs of severance and time management payout at termination Costs of severance and time management payout at termination Costs of severance and time management payout at termination Costs of severance and time management payout at termination Costs of severance and time management payout at termination Personnel Services Category Totals 861,269 140,000 1,001,269 Software Licenses 625-0800-413.50-70 900 3,900 4,800 Internal audit software Materials & Services Category Totals 108,648 3,900 112,548 Contingency Contingency Category Totals Total Administrative Services Requirements 625-0800-501.97-01 131,121 131,121 1,104,738 13,217 13,217 157,117 144,338 144,338 11281 1855 Resources increased for transfer reducing future department charges 628 Board of CounW Commissioners {BOCCl Transfers In-General Fund Total Board of County Commissioners Resources 62B-OOOO-391.11-00 - 478,320 5,801 5,801 5,801 482,121 Assist in redUCing future intemal service charges to departments Contingency 628-0800-501.97-01 Contingency Category Totals Total Board of County Commissioners Requirements 48,995 48,995 476,320 5,801 5,801 5,801 54,796 54,796 4821121 Resources increased for transfer 630 Finance Transfers In-General Fund 630-0000-391.11-00 -16,154 16,154 Assist in reducing future internal service charges to departments Total Finance Resources 11502,470 18,154 1,518,824 Contingency 630-1400-501.97-01 312,437 16,154 328,591 Resources increased for transfer Contingency Category Totals Total Finance Requirements 312,437 1,502,470 16,154 181154 328,591 1,518,624 I 640 .!.!D!! Transfers In-General Fund Total Legal Resources 640-0000-391.11-00 - 915,432 10,809 10,809 10,809 928,241 Assist in reducing future internal service charges to departments Contingency Contingency Category Totals Total Legal Requirements ~ 640-2700-501.97-01 -_ ....... 119,171 119,171 915,432 10,809 10,809 10,809 129,980 129,980 928,241 Resources increased for transfer ~......- Page 2 of4 OMf .; ;lIfP h,!!,lbH"N $.414 !i¥ "~I,M u.n.,jtII. _.fW«W?lAM Z;';JP:;:;;U;:; ,i£}jf§f#Al4k;;:;:;.L,~.h,'JPt ,QJ\4WJU\U bf'!!'\( Deschutes County FY 2012 Supplemental Budget -Attachment A I Adjusted Revised Fund I Account Code Budget 1sUPp'ementa,l Budget I Comments 650 Personnel Transfers In-General Fund 650-0000-391.11-00 -12,463 12,463 Assist in reducing future internal service charges to departments Total Personnel Resources 1,034,830 12,463 1,047,293 Contingency Contingency Category Totals Total Personnel Requirements 650-3100-501.97-01 116,737 116,737 1,034,830 12,463 12,463 12.463 129,200 129,200 1,047,293 Resources increased for transfer 660 Information Technology Transfers In-General Fund 660-0000-391.11-00 66,000 31,851 97,851 Assist in reducing future internal service charges to departments Total Information Technology Resources 2,627,245 31,851 21659,096 Contingency Contingency Category Totals Total Information Technology Requirements 660-0900-501.97-01 280,898 280,898 2,627,245 31,851 31,851 31,851 312,749 312,749 2,659,096 Resources increased for transfer 670 Insurance-Risk Management Transfers In-General Fund Total Insurance Resources 670-0000-391.11-00 - 4,626,775 200,000 200,000 200.000 4,826,775 Transfer for Workers' Compensation expenditures Workers' Compensation Losses Materials & Services Category Totals Total Insurance Requirements 670-7100-415.52-45 800,000 2,019,425 4,626,775 200,000 200,000 200,000 1,000,000 2,219,425 4,826,775 Workers' Compensation expenditures higher than anticipated 535 Full Faith & Credit, 2003 Bond Issuance Proceeds Premium-Bond Issuance Total Full Faith & Credit, 2003 Resources 535-0000-393.12-00 535-0000-393.12-01 - - 1,652,359 21,226,795 668,028 21,894,823 21,226,795 668,028 23,547,182 Bond proceeds from refunding Full Faith & Credit Series 2003 Bond premium from refunding Full Faith & Credit Series 2003 Bond Issuance Costs Materials & Services Category Totals 535-1400-415.33-28 - 1,000 372,817 372,817 372,817 373,817 Costs associated with bond issue Principal Interest Debt Service Category Totals Total Full Faith & Credit, 2003 Requirements 535-1400-471.81-01 535-1400-472.81-02 668.592 943,393 1,611,985 1,652,359 20.634,588 887,418 21,522,006 21,894.823 21.303.180 1,830,811 23,133,991 23.547.182 Refunding of the bond issue Refunding of the bond issue 610 Solid Waste Bond Issuance Proceeds 610-0000-393.12-00 -5,034,300 5,034,300 Bond proceeds from refunding Full Faith & Credit Series 2003 Premium-Bond Issuance 610-0000-393.12-01 -158,434 158,434 Bond premium from refunding Full Faith & Credit Series 2003 Total Solid Waste Resources 7,624,009 5,192,734 12,816.743 Bond Issuance Costs 610-6200-432.33-28 -881420 88,420 Costs associated with bond issue Materials & Services Category Totals 2,893,052 88,420 2,981,472 Principal 610-6200-471.81-01 464,008 4,893,848 5.357.856 Refunding of the bond issue Interest 610-6200-472.81-02 507.225 210,466 717,691 Refunding of the bond issue Debt Service Category Totals 971,233 5,104,314 6,075,547 Total Solid Waste Requirements 7,624,009 5,192,734 12.816,743 All·",., "41 Page 30f 4 is' ~,K::;,"'fRLC$%*\I4@.¥ "$ $4¥.1PA.({J4H ,*-,tf4$HM!ll m'OIIioa;.,*'$Q,W\lCi.iUOO!'S¥"''''''M\ ~~"'1~""""""""""""'~'''.',·~;n''~,.~.-''> I Deschutes County FY 2012 Supplemental Budget -Attachment A Fund I Account Code I Adjusted Budget I Supplemental I Revised IBudget Comments 618 Fair and Expo Center Bond Issuance Proceeds Premium-Bond Issuance Total Fair and Expo Center Resources Bond Issuance Costs Materials & Services Category Totals Principal Interest Debt Service Category Totals Total Fair and Expo Center Requirements 618-0000-393.12-00 618-0000-393.12-01 618-9600-453.33-28 618-9600-471.81-01 618-9600-472.81-02 - - 1,659,951 - 636,060 59,548 55,520 115,068 1,659.951 83,905 2,641 86,546 1,474 1,474 81,564 3,508 85,072 86.546 83,905 Bond proceeds from refunding Full Faith & Credit Series 2003 2,641 Bond premium from refunding Full Faith & Credit Series 2003 1.746,497 1,474 Costs associated with bond issue 637,534 141,112 Refunding of the bond issue 59,028 Refunding of the bond issue 200,140 1,746,497 150 Special Transportation Beginning Net Working Capital Total Special Transportation Resources Transportation Materials & Services Category Totals Total Special Transportation Requirements 150-0000-301.00-00 150-0800-444.34-40 - 338,062 335.712 337,962 338,062 17,503 17,503 17.503 17,503 17,503 17,503 Grants were not fully expended at the end of FY 2011 3551565 353,215 Allows resources to be expended that were not expended in FY 2011 355,465 355,565 I 325 Road Beginning Net Working Capital Total Road Resources Preservation/Overlays Materials & Services Category Totals Total Road Requirements 325-0000-301.00-00 325-5000-431.65-98 2,834,720 19,643,840 2,800,000 10,172,674 191643,640 582,438 582,438 582,438 582,438 582.438 3,417 .158 Additional resources unexpended in FY 2011 20,226,278 3,382,438 Allows resources to be expended that were not expended in FY 2011 10,755,112 20,226,278 464 Sisters Health Clinic Federal Grants Total Sisters Health Clinic Resources Architect and Design Fees and Permits Materials & Services Category Totals New Construction Capital Outlay Category Totals Total Sisters Health Clinic Requirements 464-0000-331.01-00 464-0800-419.33-15 464-0800-419.51-10 464-0800-419.92-20 - - - - - - - - 500,000 500,000 50,000 50,000 100,000 400,000 400,000 500,000 500,000 Grant awarded for School Based Health Center 500,000 50,000 Anticipated costs for project 50,000 Anticipated costs for project 100,000 400,000 Anticipated costs for project 400,000 500 1°00 SUPPLEMENTAL BUDGET TOTAL $ 29,201,944 FISCAL YEAR 2012 ADJUSTED BUDGET 269,616,959 TOTAL REVISED 2012 BUDGET $ 298,818,903 Page 4 of 4 Deschutes County Supplemental Budget Request REQUIREMENTS Item 1 2 3 4 5 6 7 8 9 10 11 12 Line Number (HTE 14 digit code) 001-4500-491.96-32 001-4500-491.96-38 001-4500-491.96-41 001-4500-491.96-54 001-4500-491.96-67 001-4500-491.96-72 001-4500-491.96-75 001-4500-491.96-77 001-4500-491.96-86 001-4500-491.96-87 001-4500-491.96-88 001-4500-501.97-01 Project Code Category {Pers, M&S, Cap Out, Contingency) Transfers Out Transfers Out Transfers Out Transfers Out Transfers Out Transfers Out Transfers Out Transfers Out Transfers Out Transfers Out Transfers Out Contingency Description (Element-Object, e.g. Time Mgmt. Temp Help, Computer Hardware) Building Services (620) Information Technology (660) Community Development (295) General County Projects (142) Risk Management (670) Admin Services (625) RV Park (601) Legal (640) Finance (630) BOCC (628) Personnel (650) TOTAL Current Budgeted Amount - 66,000 1,124,985 703.279 - 40,000 - - - - - 6,692,025 8,626,289 To (From) 33,705 31,851 100,000 250,000 200,000 157,117 110,000 10,809 16.154 5,801 12,463 (927,900' - Revised Budget 33,705 97,851 1,224,985 953,279 200,000 197,117 110,000 10,809 16,154 5,801 12,463 5.764,125 - 8,626,289 A supplemental budget is required for the following reason and will be used for the following purpose: To reduce future internal service charges to County departments, reserve funds for county projects. and assist funds with resources lower than budgeted or expenditures higher than budgeted. Fund: Dept: Requested by: Date: 001 Non Departmental Erik Kropp 3130/2012 Deschutes County Supplemental Budget Request RESOURCES Line Number Item (HTE 14 digit code) Project Code Description Current Budgeted Amount To (From) Revised Budget 1 142-0000-391.11-00 Transfers In General Fund 703.279 250,000 953,279 - TOTAL 703,279 250,000 953,279 REQUIREMENTS Line Number Category Description Item (HTE 14 digit code) Project Code (Pers. M&S. Cap Out, Contingency) (Element-Object. e.g. Time Mgmt. Temp Help. Computer Hardware) Current Budgeted Amount To (From) Revised Budget 2 142-0800-501.97-01 Contingency 2,857,207 250,000 3,107,207 - TOTAL 2,857,207 250,000 3,107,207 A supplemental budget is required for the following reason and will be used for the following purpose: Additional General Fund transfer for future capital projects. Fund: Dept: Requested by: Date: 142 General County Projects Erik Kropp 3130/2012 Deschutes County Supplemental Budget Request RESOURCES Line Number Item (HTE 14 digit code) Project Code Description Current Budgeted Amount To (From) Revised Budget 1 295-3601-391.11-00 Transfers In General Fund 629.625 100.000 729.625 - TOTAL 629,625 100,000 729,625 REQUIREMENTS Line Number Category Description Item (HTE 14 digit code) Project Code (Pers. M&S. Cap Out, Contingency) (Element-Object. e.g. Time Mgmt. Temp Help. Computer Hardware) Current Budgeted Amount To (From) Revised Budget 2 295-3601-501.97-01 Contingency 252.128 100,000 352,128 - TOTAL 252,128 100,000 352,128 A supplemental budget is required for the following reason and will be used for the following purpose: Actual Beginning Net Working Capital was $98.046 below budget. Additional General Fund transfer supplies the cash required to replace the budget to actual variance. Fund: Dept: Requested by: Date: 295 COD Erik Kropp 3/30/2012 ~'~~~~~~~~~"Ii.iiM'& 'sf"""H'liI"';'~ Deschutes County Supplemental Budget Request RESOURCES Line Number Item (HTE 14 digit code) Project Code Description Current Budgeted Amount To (From) Revised Budget 1 601-0000-391.11-00 Transfers In General Fund -110,000 110,000 - TOTAL -110,000 110,000 REQUIREMENTS Item 2 Line Number (HTE 14 digit codel 601-1000-501.97-01 Project Code Cat~o(}l (Pers, M&S, Cap Out, ContingencI') Contingency Description (Element-Object, e.g. Time Mgmt, Temp Help, Computer Hardware) Current Budgeted Amount 14,942 To (FromJ 110,000 Revised Budget 124,942 - TOTAL 14,942 110,000 124,942 A supplemental budget is required for the following reason and will be used for the following purpose: Actual Beginning Net Working Capital was $38,000 below budget. RV Park Fee revenue is trending to be $72,000 less than budget. The General Fund transfer supplies the cash required to replace the budget to actual variances. Fund: Dept: Requested by: Date: 601 RVPark Erik Kropp 3/30/2012 __ Deschutes County Supplemental Budget Request RESOURCES Line Number Item (HTE 14 digit code) Project Code Description Current Budgeted Amount To (From) Revised Budget 1 620-0000-391.11-00 Transfers In General Fund -33.705 33.705 - TOTAL -33,705 33,705 REQUIREMENTS Line Number Category Description Item (HTE 14 digit code) Project Code (Pers. M&S. Cap Out. Contingency) (Element-Object. e.g. Time Mgmt. Temp HelQ. Computer Hardware) Current Budgeted Amount To (From) Revised Budget 2 620-1000-501.97-01 Contingency 300,682 33,705 334.387 - TOTAL 300,682 33,705 334,387 A supplemental budget is required for the following reason and will be used for the following purpose: Additional General Fund transfer to reduce future internal service charges to County departments. Fund: Dept: Requested by: Date: 620 Building Services Erik Kropp 3/30/2012 lea I."IJ48.UI.4!l9kiiAi$l(.,,«;,L,9P....,R·Fir(U"# C!!M4 A iYW ~~!';'~"'''JI!·'p'''1'·r.,:'lll'J' )"'W ,,,""",,, -..,"""--- Deschutes County Supplemental Budget Request RESOURCES Line Number Item (HTE 14 digit code) Project Code Description Current Budgeted Amount To (From) Revised Budget 1 625-0000-391.11-00 Transfers In General Fund 40,000 13,217 53,217 - TOTAL 40,000 13,217 53,217 REQUIREMENTS Line Number Item (HTE 14 digit code) 2 625-0800-501.97-01 Project Code Category Description Current (Pers, M&S, Cap Out, (Element-Object, e.g. Time Mgmt, Temp Budgeted Revised Contingency) Help, Computer Hardware) Amount To (From) Budget Contingency 131,121 13,217 144,338 - TOTAL 131,121 13,217 144,338 A supplemental budget is required for the following reason and will be used for the following purpose: Additional General Fund transfer to reduce future internal service charges to County departments. Fund: Dept: Requested by: Date: 625 Admin Services Erik Kropp 3/30/2012 ;:"'W~\;Irii'i'",.j(.i~'.t,,·d>fH"'lI."-~'<A'4~~~~~~~~ Deschutes County Supplemental Budget Request RESOURCES Line Number Item (HTE 14 digit code) Project Code Description Current Budgeted Amount To (From) Revised Budget 1 625-0000-391 .11-00 Transfer In-General Fund 53,217 143,900 197,117 - - - TOTAL 53,217 143,900 197,117 REQUIREMENTS Line Number Category Description (Element-Object, e.g. Time Current Project (Pers, M&S, Cap Out, Mgmt, Temp Help, Computer Budgeted Revised Item (HTE 14 digit code) Code Contin9_ency) Hardware) Amount To (From) Budget 2 625-0800-413.10-01 Personnel Services County Administrator 167,446 96,000 263,446 3 625-0800-413.18-72 Personnel Services Time Management 6,000 24,000 30,000 4 625-0800-413.21-10 Personnel Services Life & Long Term Disability 3,674 4,000 7,674 5 625-0800-413.22-01 Personnel Services FICA/Medicare 42,543 1,000 43,543 6 625-0800-413.23-01 Personnel Services PERS 77,732 15,000 92,732 7 625-0800-413.50-70 Materials & Services Software Licenses 900 3,900 4,800 TOTAL 298,295 143,900 442,195 A supplemental budget is required for the following reason and will be used for the following purpose: 2-6 Severance and time management pay to the County Administrator occurred in August and September. The total expense of these payouts was not included in the Personnel Services budget and will result in expenditures exceeding the budgeted category total. 7 Purchase of internal audit software will streamline current processes, improve tracking ability and allow electronic workpaper capabilities. Health Services may also find the software beneficial. Fund: Dept: Requested by: Date: 625 Administrative Svcs David Inbody 1/28/2012 Deschutes County Supplemental Budget Request RESOURCES Line Number Item (HTE 14 digit code) Project Code Description Current Budgeted Amount To (From) Revised Budget 1 628-0000-391 .11-00 Transfers In General Fund -5,801 5,801 - TOTAL . 5,801 5,801 REQUIREMENTS Line Number Category Description Item (HTE 14 digit code] Project Code (Pers, M&S, Cap Out, Contingen~ (Element-Object, e.g. Time Mgmt, Temp Help, Computer Hardware) Current Budgeted Amount To {From} Revised Budget 2 628-0800-501.97-01 Contingency 48.995 5,801 54,796 - TOTAL 48,995 5,801 54,796 A supplemental budget is required for the following reason and will be used for the following purpose: Additional General Fund transfer to reduce future internal service charges to County departments. Fund: Dept: Requested by: Date: 628 Board of County Comm. Erik Kropp 3/30/2012 ,.,.,"'..;,;;" ~~ ~\i"~~~~,~~.~•••",.:~.."",d;":lAi!m"iAAri\\:'1;i¥".¥~~.,,~~~~~.:.....~~~~~~PiM~"""""~.''''''';'''''H& ,...~~_" 'idW';~\\i\.A'ilIo~_ Deschutes County Supplemental Budget Request RESOURCES Item 1 Line Number (HTE 14 digit code) 630-0000-391.11-00 Project Code Transfers In General Fund Description Current Budgeted Amount - To (From) 16.154 Revised Budget 16,154 - TOTAL -16,154 16,1541 REQUIREMENTS Line Number Category Description Item (HTE 14 digit code) Project Code (Pers, M&S, Cap Out, Contingency) (Element-Object. e.g. Time Mgmt. Temp Help. Computer Hardware) Current Budgeted Amount To (From) Revised Budget 2 630-1400-501.97-01 Contingency 312,437 16,154 328.591 - TOTAL 312,437 16,154 328,591 A supplemental budget is required for the following reason and will be used for the following purpose: Additional General Fund transfer to reduce future internal service charges to County departments. Fund: Dept: Requested by: Date: 630 Finance Erik Kropp 3/30/2012 ~..i..","""~~,~~",.","""~'.t-~Iiort~...."'.....o4I-~""'''';'lW'''''~,~,,,,,;,",,,,,,1,''lIl~)II~'''''',''''~~~~*'''''''1r~kJ.j.1~,;..,..<j..y,o\oi<'O~~)~;LoiI.~"""'""'~&~~~~~'I'Jpjt\o4l!i~~~~~~·_""".Ml~~"*""",""",,,,~~~'~'''''''''~1""'~~"""""'",~iI'~~';;;..;,ifo~_,<1ii.!IimI.""''''~~>-' Deschutes County Supplemental Budget Request RESOURCES Line Number Current Project Budgeted Revised Item 1 (HTE 14 digit code) 640-0000-391.11-00 Code Transfers In Description General Fund TOTAL Amount - - To (From) 10,809 10,809 Budget 10,809 - 10,809 REQUIREMENTS Line Number Category Description Item (HTE 14 digit code) Project Code (Pers, M&S, Cap Out, Contingency) (Element-Object, e.g. Time Mgmt, Temp Help, Computer Hardware) Current Budgeted Amount To (From) Revised Budget 2 640-2700-501.97-01 Contingency 119,171 10,809 129,980 - TOTAL 119,171 10,809 129,980 A supplemental budget is required for the following reason and will be used for the following purpose: Additional General Fund transfer to reduce future internal service charges to County departments. Fund: Dept: Requested by: Date: 640 Legal Erik Kropp 3/30/2012 ~ ~ ~ __IIr< ___ U;:~"",i;~'~.r~__ ....u,.~~"a.""","~"_~'.,0#"","iSf:OI!I;:.,~~,,,~\li4;f"""'J·*,''li$)ot;£;"·M\""tlM'-4:r...yw"''''~~~I'Io'IK,~~~_~~'_·~·~$______ Deschutes County Supplemental Budget Request RESOURCES Line Number Item (HTE 14 digit code) Project Code Description Current Budgeted Amount To (From) Revised Budget 1 650-0000-391.11-00 Transfers In General Fund -12,463 12,463 - TOTAL . 12,463 12,463 REQUIREMENTS Line Number Category Description Item (HTE 14 digit code) Project Code (Pers, M&S, Cap Out. Contingency) (Element-Object. e.g. Time Mgmt, Temp Help, Computer Hardware) Current Budgeted Amount To (From) Revised Budget 2 650-3100-501.97-01 Contingency 116,737 12.463 129,200 - TOTAL 116,737 12,463 129,200 A supplemental budget is required for the following reason and will be used for the following purpose: Additional General Fund transfer to reduce future internal service charges to County departments. Fund: Dept: Requested by: Date: 650 Personnel Erik Kropp 3/30/2012 Deschutes County Supplemental Budget Request RESOURCES Line Number Item (HTE 14 digit code) Project Code Description Current Budgeted Amount To (From) Revised Budget 1 660-0000-391.11-00 Transfers In General Fund 66,000 31,851 97,851 - TOTAL 66,000 31,851 97,851 REQUIREMENTS Line Number Category Description Item (HTE 14 digit code) Project Code (Pers, M&S. Cap Out. Contingency} (Element-Object. e.g. Time Mgmt. Temp Help. Computer Hardware) Current Budgeted Amount To (From) Revised Budget 2 660-0900-501.97-01 Contingency 280,898 31,851 312,749 - TOTAL 280,898 31,851 312,7491 A supplemental budget is required for the following reason and will be used for the following purpose: Additional General Fund transfer to reduce future internal service charges to County departments. Fund: Dept: Requested by: Date: 660 Information Technology Erik Kropp 3/30/2012 Deschutes County Supplemental Budget Request RESOURCES Line Number Item (HTE 14 digit code) Project Code Description Current Budgeted Amount To (From) Revised Budget 1 670-0000-391.11-00 Transfers In General Fund -200,000 200,000 - TOTAL -200,000 200,000 i REQUIREMENTS Line Number Category Description Item (HTE 14 digit code) Project Code (Pers, M&S, Cap Out, Contingency) (Element-Object, e.g. Time Mgmt, Temp Help, Computer Hardware) Current Budgeted Amount To (From) Revised Budget 2 670-7100-415.52-45 Materials & Services Workers' Compensation Losses 800,000 200,000 1,000,000 - TOTAL 800,000 200,000 1,000,000 A supplemental budget is required for the following reason and will be used for the following purpose: Workers' Compensation losses are trending to exceed the original budget of $800,000. The General Fund transfer covers the majority of the budget to actual variance. Fund: Dept: Requested by: Date: 670 Risk Management Erik Kropp 3/30/2012 Deschutes County Supplemental Budget Request RESOURCES Line Number Current Budgeted Revised Item (HTE 14 digit code) Description Amount To (From) Budget 1 535-0000-393.12-00 Revenues Bond Issuance Proceeds -21,226,795 21,226,795 2 610-0000-393-12.00 Revenues Bond Issuance Proceeds -5,034,300 5,034,300 3 618-0000-393.12-00 Revenues Bond Issuance Proceeds -83,905 83,905 4 535-0000-393.12-01 Revenues Premium -Bond Issuance -668,028 668,028 5 610-0000-393.12-01 Revenues Premium -Bond Issuance -158,434 158,434 6 618-0000-393.12-01 Revenues Premium -Bond Issuance -2,641 2,641 i TOTAL -27,174,103 27,174,103 ! REQUIREMENTS Line Number Category Description Item (HTE 14 digit code) (Pers, M&S, Cap Out. Contingency) (Element-Object, e.g. Time Mgmt, Temp Help, Computer Hardware) Current Budgeted Amount To (From) Revised Budget 7 535-1400-415.33-28 Materials & Services Bond Issuance Costs -372,817 372,817 8 610-6200-432.33-28 Materials & Services Bond Issuance Costs -88,420 88,420 9 618-9600-45;3.33-28 Materials & Services Bond Issuance Costs -1,474 1,474 10 535-1400-47Z81-01 Debt Service Debt Service -Principal 668,592 20,634,588 21,303,180 11 610-6200-471.81-01 Debt Service Debt Service -Principal 464,008 4,893,848 5,357,856 12 618-9600-471.81-01 Debt Service Debt Service -Principal 59,548 81,564 141,112 13 535-1400-472.81-02 Debt Service Debt Service -Interest 943,393 887,418 1,830,811 14 610-6200-472.81-02 Debt Service Debt Service -Interest 507,225 210,466 717,691 15 618-9600-472.81-02 Debt Service Debt Service -Interest 55,520 3,508 59,028 TOTAL 2,698,286 27,174,103 29,872,389 A supplemental budget is required for the following reason and will be used for the following purpose: Bonds were issued during FY 2012 to refund the Full Faith & Credit Series 2003. The proceeds of the new issue will be appropriated as Materials & Services and Debt Service. The proceeds of the new issue and the refunding of the previous issue have been allocated, proportionately, based on the principal balances of the refunded debt Fund: Dept: Requested by: Date: Full Faith & Credit, 2003 (FF&C Ref 2012)/SW/F&E I Finance Marty Wynne 3/16/2012 _...,..~~~~~7~'"," iA'W',i"lh'!I!II'!iI"!"*(".""'i'!I"!1..MfAMi\lAiiifll4::;." J _$}# "t,~ • ,Hi ,ON.1. if", , __________________ .. ____ ... _'jl' 'lilli' '" 1l ... n.UIIWiM "'l'~"1 1110 W 'hllW:N!d" ~HIIl>iWf~.u.;;:_'~ __ Q~ .... _. __ _ Deschutes County Supplemental Budget Request RESOURCES Line Number Item (HTE 14 digit code) Project Code Description Current Budgeted Amount To (From) Revised Budget 1 150-0000-301.00-00 Resources Beginning Net Working Capital -17,503 17,503 - - - TOTAL -17,503 17,503 REQUIREMENTS Line Number Category Description Item (HTE 14 digit code) Project Code (Pers, M&S, Cap Out, Contingency) (Element-Object, e.g. Time Mgmt, Temp Help, Computer Hardware) Current Budgeted Amount To (From) Revised Budget 2 150-0800-444.34-40 Materials & Services Transportation 335,712 17,503 353,215 - - - - - TOTAL 335,712 17,503 353,215 A supplemental budget is required for the following reason and will be used for the following purpose: Resources in excess of the amount estimated for the FY 2012 budget will be expended in FY 2012. Therefore, these additional resources need to be appropriated. Fund: Dept: Requested by: Date: 150-Special Transport BOCC i ation Judith Ure 9/3/2011 Deschutes County Supplemental Budget Request RESOURCES Line Number Item (HTE 14 digit code) Project Code Description Current Budgeted Amount To (From) Revised Budget 1 325-0000-301.00-00 Beginning Net Working Capital 2,834,720 582,438 3,417,158 - • - -I TOTAL 2,834,720 582,438 . 3,417,158 REQUIREMENTS 2 (HTE 14 digit code) 325-5000-431.65-98 Project Code (Pers, M&S, Cap Out, Contingency) Materials & Services (Element-Object, e.g. Time Mgmt, Temp Help, Comput Hardware) Preservation/Overlays er Current Budgeted Amount 2,800,000 To (From) 582,438 Revised Budget 3,382,438 - - - - - TOTAL 2,800,000 582,438 3,382,438 Item Line Number Categ_~ry Description A supplemental budget is required for the following reason and will be used for the following purpose: Appropriation is required for resources unexpended in Fiscal Year 2011. Fund: Dept: Req uested by: Date: 325 Road George Kolb 12/28/2011 ......,....,........~~'*~'hll '9 • WI') ,t +..~..w.. "lr*,"''''~~,"lwi&i''~:a""~$ljfo$iI'$ "Ww4r ;;'$".............,,4$1; :lIl-_.:oliidi~'~i<f.' "f~):'i'ilrr • ".~~i""~~"'*~:~~j'"'11. j'n't-\~·ili~wIiill!liIIli")";'2 II Deschutes County Supplemental Budget Request RESOURCES Line Number Item (HTE 14 digit code) 1 464-0000-331-01-00 Project Code Revenue Description Federal Grants TOTAL Current Budgeted Amount - - To (From) 500,000 500,000 Revised Budget 500,000 - - 500,000 REQUIREMENTS Line Number Categ~ry Description Item (HTE 14 digit code) Project Code (Pers, M&S, Cap Out, Contingency) (Element-Object, e.g. Time Mgmt, Temp Help, Computer Hardware) Current Budgeted Amount To (From) Revised Budget 1 464-0800-419-3315 M&S Architect/Design -SO,OOO 50,000 2 464-0800-419-5110 M&S Fees & Permits -50,000 50,000 3 464-0800-419-9220 Capital Outlay New Construction -400,000 400,000 - - - TOTAL . 500,000 500,000 A supplemental budget is required for the following reason and will be used for the following purpose: Deschutes County received a grant to construct a school-based health care clinic in Sisters, and a new construction fund with appropriation for expenditures needs to be established. Fund: Dept: Requested by: Date: New Property & Facilities Susan Ross 1217/2011