The URL can be used to link to this page

Home My WebLink About12/10/2013 05A 3rd Quarter 2013 Financial Trend Monitoring ReportBUSINESS OF THE CITY COUNCIL YAKIMA, WASHINGTON AGENDA STATEMENT Item No. For Meeting of: 12/10/2013 IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII ITEM TITLE: SUBMITTED BY: SUMMARY EXPLANATION: 3rd Quarter 2013 Financial Trend Monitoring report Cindy Epperson, Director of Finance and Budget The Financial Trend Monitoring System (FTMS) report format was presented for the first time for the 1st quarter of 2013. It is designed to provide a "performance at a glance" of budgetary and revenue trends, and reviews key financial and economic indicators as an "early warning system" regarding the financial and economic health of the city, and assigns "positive", "normal", "warning", and "negative" labels to revenues and expenditures. At the end of the third quarter, we are seeing typical variances tied to timing --such as debt service contributions and progress on capital projects. All of the funds were reviewed carefully during budget preparation, as we estimate year end results to arrive at a beginning fund balance that becomes part of the available resources for the 2014 budget. This review identified two funds that require a budget amendment (that ordinance was a separate agenda item at the December 3 meeting). Most categories received a "normal" ranking, as actual results are within 5% of expected levels at this point in time. There were no categories receiving a "warning" or "negative" designation. Overall, year to date results through the third quarter of 2013 are as anticipated. Resolution: Ordinance: Other (Specify): Report Contract: Contract Term: Start Date: End Date: Item Budgeted: NA Amount: Funding Source/Fiscal Impact: Strategic Priority: Insurance Required? No Mail to: Phone: Public Trust and Accountability APPROVED FOR SUBMITTAL: RECOMMENDATION: Accept Report City Manager ATTACHMENTS: Description 3rd Quarter 2013 Financial Trend Monitoring Report Upload Date Type 12/2/2013 Cover Memo MEMORANDUM December 2, 2013 TO: The Honorable Mayor and Members of the City Council FROM: Tony O'Rourke, City Manager Cindy Epperson, Director of Finance & Budget SUBJECT: 2013 3rd Quarter Financial Monitoring Report We are submitting for your review the City of Yakima's 2013 3rd Quarter actual compared to budgeted Revenue and Expenditure Report for all city funds. It should be noted that the budget information for the Yakima Air Terminal (YAT) is not yet incorporated into the operating and capital components of this report because of the 2 month timing difference for January and February. The operating fund results are summarized in the same format as the other funds, but are presented separately. YAT is continuing to rebuild its cash reserves after making the scheduled County SIED loan repayment in June. This report is summarized by type of fund, and reported by functional type, in the following order: > Performance at a Glance - Financial Monitoring System > City -Wide Overview > General Fund Revenue Analysis > General Fund Expenditure Analysis > Other Funds Analysis > Top 10 Capital Project > Exhibits - Fund detail that supports the summaries: • Exhibit I - Other Operating/Enterprise Funds • Exhibit II - Capital Improvement Funds • Exhibit III - Reserve and Other Funds • Exhibit IV - Bond Redemption Funds FIN Report 3rd Qrtr 1 of 14 PERFORMANCE AT A GLANCE STATUS PAGE General Fund Revenues Expenditures Operating/Enterprise Funds (1) Capital Funds (1) Reserve, Trust & Agency Funds (1) Bond Redemption Funds (1) Legend: Revenues exceed budget >5%, Expenditures below budget >5% Revenues exceed budget <5%, Expenditures below budget <5% Revenues below budget between 3-5% Revenues below budget >5% (1) These funds are graded on a net Revenue measurement. 3 / 4-5 3 / 6-7 8-9/11 8-10 / 12 9/13 9/14 ti 11$ 100„,„„,„„1,„0„„,„ 0 00,„0i1„,„ 00, r rffifiri o��io i oom WARNING IIII �IIIIII 11111111111111111111111111111 llllllllllllllllll11111111111111111111111111111111111111111111 FIN Report 3rd Qrtr 2 of 14 CITY WIDE OVERVIEW REVENUE COMPARISON (Budget vs. Actual - 75% of year) 2012 2013 3rd Qtr Percent Amended 3rd Qtr Percent YTD Actual Rec'd Budget YTD Actual Rec'd General $37,627,130 74.6% $53,173,249 $38,589,206 72.6% Parks and Recreation 2,874,794 71.0% 4,083,765 2,771,854 67.9% Street & Traffic Operations 3,047,952 60.3% 5,411,260 3,309,389 61.2% General Government Subtotal 43,549,876 73.1% 62,668,274 44,670,449 71.3% Operating/Enterprise Funds 46,221,232 71.4% 65,814,691 48,550,759 Capital Funds 8,943,637 27.6% 52,657,141 23,054,665 G.O. Bond Redemption Funds 2,282,435 65.0% 3,812,383 2,244,840 Water/Sewer Redemption Funds 1,777,841 64.6% 2,129,686 1,224,533 Employee Benefit Reserves 9,715,184 69.5% 14,630,500 9,786,550 Operating Reserves 2,640,976 26.5% 3,586,500 2,964,841 Trust and Agency Funds 594,904 109.5% 528,200 535,577 Total $115,726,085 61.7% $205,827,375 $133,032,214 EXPENDITURE COMPARISON (Budget vs. Actual - 75% of year) 73.8% 43.8% 58.9% 57.5% 66.9% 82.7% 101.4% 64.6% 2012 2013 3rd Qtr Percent Amended 3rd Qtr Percent YTD Actual Spent Budget YTD Actual Spent General $36,192,774 70.2% $54,053,972 $38,913,214 72.0% Parks and Recreation 3,016,213 74.5% 4,132,425 3,243,801 78.5% Street & Traffic Operations 3,883,701 74.7% 5,490,823 3,848,266 70.1% General Government Subtotal 43,092,688 70.9% 63,677,220 46,005,281 72.2% Operating/Enterprise Funds Capital Funds G.O. Bond Redemption Funds Utility Revenue Bond Redemption Funds Employee Benefit Reserves Operating Reserves Trust and Agency Funds Total 44,870,714 11,990,875 1,170,641 1,975,394 10,372,208 2,376,160 143,840 $115,992,520 68.3% 66,236,497 46,483,625 22.9% 62,336,449 26,051,938 33.1% 3,831,384 1,212,952 47.7% 2,127,561 619,532 71.1% 14,634,979 8,758,849 23.3% 3,918,264 3,062,625 28.6% 517,200 531,104 60.3% $217,279,554 $132,725,906 70.2% 41.8% 31.7% 29.1% 59.8% 78.2% 102.7% 61.1% FIN Report 3rd Qrtr 3 of 14 GENERAL GOVERNMENT REVENUE ANALYSIS General Sales Tax Crim. Justice Sales Tax Property Tax Franchise & Utility Taxes Charges for Services State Shared Revenue Other Intergovernmental Fines and Forfeitures Other Taxes Transfers from other Funds Licenses and Permits Other Revenue Total Revenue Beginning Fund Balance Total Resources GENERAL GOVERNMENT REVENUES Revenues through 9/30 2011 2012 2013 $9,460,280 1,994,395 8,581,369 8,763,020 5,102,648 2,069,372 763,598 1,165,827 1,149,237 838,847 647,654 592,953 41,129,200 9,514,193 $9,901,593 1,962,403 8,784,541 10,670,475 4,425,408 2,352,200 783,517 1,163,424 1,152,336 1,088,101 609,380 656,498 43,549,876 9,948,220 $10,603,688 2,118,531 9,288,887 10,853,277 4,539,339 1,919,876 1,009,662 1,184,825 1,190,025 957,456 576,328 428,555 44,670,449 10,908,094 $50,643,393 $53,498,096 $55,578,543 2013 2012 Amended Percent vs. 2013 Budget Rec'd 7.1% 8.0% 5.7% 1.7% 2.6% (18.4%) 28.9% 1.8% 3.3% (12.0%) (5.4%) (34.7%) 2.6% 9.6% 3.9% $14,000,000 2,747,000 15,329,000 14,530,000 6,379,205 2,611,000 1,445,219 1,555,000 1,396,500 1,370,000 731,700 573,650 62,668,274 10,908,094 75.7% 77.1% 60.6% 74.7% 71.2% 73.5% 69.9% 76.2% 85.2% 69.9% 78.8% 74.7% 71.3% $73,576,368 75.5% Status III1li i II III }Iiiftii iii Sales Tax - The third quarter continued the acceleration seen in the second half of 2012 and the first half of 2013. 2012 ended 7.2% ahead of 2011 actual. Through the third quarter of 2013, sales tax is 7.1% more than the prior year, and is staying at that percentage through November actual results. In reviewing sales tax history, there is only one time in the past 20 years when annual growth exceeded 7% --that was in 1994. Two years in a row is unprecedented. We are finally on track to exceed 2008 levels in 2013. The year-end estimate was set at $14,100,000 -considering October and November actual results, this major revenue source will likely produce a better variance. Property Tax - The first half of the Property Tax assessment is due to the Yakima County Treasurer by April 30, and the second half is due October 31. Therefore, the third quarter receipts are typically slightly more than 50% of the annual budget, because of accounts that are paid when due in April and payments in full when property sells. The budget is set based on assumptions of new construction and collection rates - the 2013 actual levy was very close to the levy assumptions made, so this major revenue should meet or slightly exceed budget, depending on the final collection rate. Other Taxes - This category consists primarily of Business Licenses and Gambling Taxes. Business licenses are due in January for the year, so that almost 100% of this category has been collected by the end of the 3rd quarter. Gambling taxes are up year over year through the 21d quarter, however, Council recently amended the ordinance to exclude taxes on certain non-profit corporations. These revenues are expected to approximate the budget by year end. The last three categories all contain timing exceptions, and are still expected to meet the budget. Overall, general government revenues are up by about $1,120,573 or 2.6% over 2012, and we anticipate year end to exceed the budget by about 1% -- within the 5% range which maintains the "normal" ranking. FIN Report 3rd Qrtr 4 of 14 10,000,000 8,000,000 6,000,000 4,000,000 2,000,000 0 GENERAL GOVERNMENT REVENUES - By Month 2011 2012 2013 January 4,204,721 3,668,912 4,451,264 February 3,875,777 4,206,186 4,267,636 March 4,078,448 4,861,758 4,896,583 April 9,178,647 9,388,842 9,758,283 May 4,565,077 4,833,268 4,733,408 June 3,929,664 4,146,240 4,168,515 July 3,536,362 4,636,431 3,962,439 August 3,405,624 3,574,114 3,798,660 September 4,354,881 4,250,150 4,633,660 October 8,531,924 9,673,506 November 3,925,532 4,263,220 December 4,035,837 4,016,944 57,622,494 61,519,571 44,670,448 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec GENERAL GOVERNMENT REVENUES - Cumulative By Month 2011 2012 2013 January 4,204,721 3,668,912 4,451,264 February 8,080,498 7,875,098 8,718,900 March 12,158,946 12,736,856 13,615,483 April 21,337,593 22,125,698 23,373,766 May 25,902,670 26,958,966 28,107,174 June 29,832,334 31,105,206 32,275,689 July 33,368,696 35,741,637 36,238,128 August 36,774,320 39,315,751 40,036,788 September 41,129,201 43,565,901 44,670,448 October 49,661,125 53,239,407 November 53,586,657 57,502,627 December 57,622,494 61,519,571 60,000,000 40,000,000 20,000,000 0 I ...■r11 lain 11411 it Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec ■ 2011 ■ 2012 ■ 2013 FIN Report 3rd Qrtr 5 of 14 GENERAL GOVERNMENT EXPENDITURE ANALYSIS GENERAL GOVERNMENT EXPENDITURES 2013 ----- -- Expenditures through 9/30 ------- 2012 Amended Percent 2011 2012 2013 vs. 2013 Budget Spent Police $16,529,955 $17,254,228 $18,509,094 7.3% $25,880,899 71.5% Fire 6,262,588 6,668,241 7,030,665 5.4% 9,909,477 70.9% Transfers To Other Funds 1,777,743 1,849,474 1,820,373 (1.6%) 3,002,275 60.6% Information Technology 1,695,182 1,587,448 1,693,116 6.7% 2,435,038 69.5% Financial Services 988,284 1,045,959 1,070,925 2.4% 1,478,418 72.4% Code Administration 915,904 843,962 988,428 17.1% 1,389,047 71.2% Municipal Court 851,691 856,251 970,018 13.3% 1,384,004 70.1% Utility Services 906,371 964,059 963,417 (0.1%) 1,324,950 72.7% Police Pension 1,140,904 944,769 1,020,409 8.0% 1,297,225 78.7% Legal 760,357 788,629 917,868 16.4% 1,287,573 71.3% Indigent Defense 350,139 353,825 393,529 11.2% 833,500 47.2% Engineering 537,424 486,232 495,078 1.8% 686,172 72.2% Purchasing 325,056 363,912 402,960 10.7% 541,244 74.5% Planning 496,504 422,697 401,450 (5.0%) 534,116 75.2% Records - City Clerk 329,283 448,249 340,575 (24.0%) 461,070 73.9% Human Resources 327,033 318,743 336,660 5.6% 459,969 73.2% Economic Development 0 0 397,392 n/a 457,217 86.9% City Hall Maintenance 273,247 247,355 290,090 17.3% 372,923 77.8% City Manager 353,748 257,812 273,149 5.9% 366,555 74.5% City Council 157,734 195,164 237,674 21.8% 284,751 83.5% Intergovernmental 235,021 219,024 259,255 18.4% 261,549 99.1% State Examiner 75,339 61,312 77,723 26.8% 110,000 70.7% Urban Area Hearings Exam. 10,837 15,429 23,366 51.4% 26,000 89.9% Position Vacancy Savings 193,841 0 0 n/a ('7; 0,000) 0.0% Total General Fund 35,494,185 36,192,774 38,913,214 7.5% 54,053,972 72.0% Parks & Recreation Fund 3,360,426 3,016,213 3,243,801 7.5% 4,132,425 78.5% Street & Traffic Ops. 3,638,135 3,883,701 3,848,266 (0.9%) 5,490,823 70.1% Total General Government $42,492,746 $43,092,688 $46,005,281 6.8% $63,677,220 72.2% Total General Government Fund Expenditures -2.8% Below 75% FIN Report 3rd Qrtr Status II LIE„, II dLIE„, IIS �� mI�� TJ 1141411,1A11 i 11 l Iiuiu IIi:i nLii„,ii II1: 1111A ifinii IIiR i1 n1miiu II1R i 11 111r ii ifin n II' i1 n miA ifin i II' i1 n EA,„ n 11::11a,11„,1 II'R i nmih�ii ifin i II'� nmih�ii ifin n II i : nmih�ii ifin i i IIIII1rialdi r //rte/.4/41(4/ 6 of 14 SIGNIFICANT EXPENDITURE VARIANCES Positive • Indigent Defense - The contract increase to comply with a new mandate was budgeted to begin in mid -year. The implementation date of the new rule has been moved back to 2015 - savings will extend through the end of the year. Normal - Over/under 75% in third quarter, yet comparable to prior years or payment timing variance. • Transfers to Other Funds - Local match of $500,000 to be paid into the Yakima Redevelopment Area will be done at year end. • Police Pension - There are currently 4 retirees in long-term care facilities - the budget typically includes 2 retirees. This is estimated to exceed budget by year end by about $50,000, still under 5%. • Economic Development - Much of the activity in this fund is programmed in the summer months. We anticipate this will come in within budget by year end. • City Hall Maintenance - Annual transfer to Risk Management Fund to pay for property insurance is made in the first quarter - $107,000. • City Council - Annual Association of Washington Cities (AWC) dues of $62,000 paid in the first quarter, and the Citizen Survey of $37,000 is paid in the second quarter. This account is anticipated to end the year within budget. • Intergovernmental - Most annual dues are paid in full by the end of the third quarter - we anticipate very little activity in the fourth quarter. • Hearing Examiner - There were several complex cases that reached the Hearing Examiner this year. This account is expected to slightly exceed budget by year end. • Parks and Recreation - There is currently an appropriation before Council to increase this budget by $143,000. The main drivers to the additional costs are extended hours at Lions Pool; additional usage of the new Upper Kiwanis ballfields; a slump in revenue at Tahoma Cemetery requiring additional subsidy; and additional water usage because of the extremely hot summer. Many of the programs are not as active in the fourth quarter, and we anticipate ending the year within the new budget amount. Position Vacancy Savings - Shown for fund total purposes only - no "actual" will be charged here. Since General Government is about 68% staffing, events affecting total payroll have a significant impact on budgets. Position vacancies can start being an "overage" because of the cashout of earned accrued leave balances, but then can produce savings when the position is vacant for any length of time. Most other variances are the result of position vacancies. FIN Report 3rd Qrtr 7 of 14 OTHER FUNDS ANALYSIS Operating/Enterprise Funds Capital Funds Reserve, Trust & Agency Funds Bond Redemption Funds Total Revenue Beginning Fund Balance Total Resources Operating/Enterprise Funds Capital Funds Reserve, Trust & Agency Funds Bond Redemption Funds Total Expenditures OTHER FUNDS REVENUES 2013 Revenues through 9/30 Amended Percent 2011 2012 2013 Budget Spent $42,570,372 $46,221,232 $48,550,759 $65,814,691 73.8% 17,494,901 8,943,637 23,054,665 52,657,141 43.8% 12,048,510 12,951,064 13,286,968 18,745,200 70.9% 4,823,070 4,060,276 3,469,373 5,942,069 58.4% 76,936,853 72,176,209 88,361,765 143,159,101 61.7% 47,566,161 45,711,333 47,394,784 47,394,784 $124,503,014 $117,887,542 $135,756,549 $190,553,885 71.2% OTHER FUNDS EXPENDITURES Status IIIIIII i��l i o7�oi�l�iioii 2013 Expenditures through 9/30 Amended Percent 2011 2012 2013 Budget Spent Status $45,828,088 $44,870,714 $46,483,625 $66,236,497 70.2% 18,460,093 11,990,875 26,051,938 62,336,449 41.8% 12,647,823 12,892,208 12,352,578 19,070,443 64.8% 1,920,841 3,146,035 1,832,484 5,958,945 30.8% $78,856,845 $72,899,832 $86,720,625 $153,602,334 56.5% Third quarter results are performing as expected. Most variances at this time of the year are related to timing, especially in capital funds and bond redemption funds, which is why they are getting a Normal status. The Employees' Health Benefit Fund is experiencing savings of over $1.5 million through September 30, bringing that category into a Positive status. Most Operating/Enterprise Funds are close to the 75% mark for both revenue and expenditures at September 30. Significant variances are related to timing (i.e. Irrigation operating fund pays all of its ditch charges to outside irrigation companies in the first half of the year, so it is showing 79.5% spent— this is not unusual, and the budget is not in jeopardy to be overspent by year end.) Fund balances are within expected levels at this time of the year for all of these funds. The one exception is that the Police Grants Fund is over 90% spent, and the appropriation ordinance going to Council on December 3 increases that budget by $130,000. In working through the budget estimates, all operating funds are estimated to be within budget (as amended), and end 2013 within targeted reserve levels. Capital Fund budgets include the full project, and are not expected to be 100% completed in the current year. The $5 million bond for major Street grind and overlay projects was received in June, but fortunately, the bid was under the budget, so the balance of the project is rebudgeted into 2014. The Martin Luther King Blvd railroad underpass project was active through the summer, using fund balance until the grant reimbursement arrives. Wastewater has several major projects in process, and FIN Report 3rd Qrtr 8 of 14 has also used capital reserves in accordance with the budgeted plan. A listing of the top ten budgeted projects and their first quarter expenses follow. Reserve Funds are ahead in revenue compared to prior year, but under 75% at the end of the third quarter due in part to position vacancies which reduce the "premiums" paid into the health benefit and Workers' Compension funds, and the timing of property tax collections that are allocated to the Firefighters' pension funds. Expenses are down primarily because of lower claim costs in the Medical Insurance Fund -last year included a major claim in this time frame. The employee benefit related funds are all doing well in 2013, and at this point in time, we anticipate no rate increases in 2014 for unemployment and workers' compensation, while a 15% reduction is programmed in the medical fund. Risk management continues to have challenges, the 2014 budget includes a 7% increase in contributions from the operating funds. Revenues in Bond Redemption Funds are deposited/transferred ratably throughout the year, but mainly interest payments are made in the first three quarters of the year - the bulk of debt service principal payments are made in the last quarter. Fund YAKIMA AIR TERMINAL ANALYSIS Actual Revenue Appropriations Ending Beg Bal Amended Actual % Amended Actual % Balance 3/1/2013 Budget Revenue Rec'd Budget Exp Exp'd 9/30/2013 Airport Operating Fund (1) 226,962 1,074,027 762,024 71.0% 1,071,192 893,552 83.4% 95,434 The YAT summary is included as a separate analysis - not included in City totals at this time. The budget is for the full year, but the revenues and expenditures are only for the 7 months the City has been sole owner, starting March 1, 2013. The airport is slowly adding to its cash reserves, which is demonstrated by the fact that it started with $226,962 on March 1, but was able to repay $256,000 SIED loan in June, and have over $95,000 at the end of the third quarter. FIN Report 3rd Qrtr 9 of 14 TOP 10 BUDGETED CAPITAL PROJECTS Project Number/Description 1818 Railroad Grade Separation Martin Luther King Blvd 2341 Regional Wastewater Treatment Plant UASB and Electrical Impr Total 2013 Actual 2013 Dept Budget Expended Funding Source ST $12,409,500 $5,078,994 State & Federal Grants Public Works Trust Fund Loan WW 6,510,000 5,417,638 Capital Reserves Revenue Bond (2014) 2353 City Streets Project Impr ST 5,000,000 1,823,908 General Obligation Bond (Proceeds received in June, 2013) WW 5,000,000 226,721 State Revolving Fund Loan W/WW 4,911,586 2,801,787 Public Works Trust Fund Loan WW 2,200,000 1,386,397 Public Works Trust Fund Loan FY 2013/14 1,700,000 378,324 Wastewater Capital Reserves FY 2013/14 1,558,021 239,777 Drinking Water State FY 2014 Revolving Fund Loan 2267 WW NPDES/TMDL Dschrg/Load WW 1,300,000 961,300 Wastewater Capital Reserves FY 2014/15 2308 Biosolids Improvement 2261 Automated Meter Reading 2327 Ind Waste Line Boise Site 2264 Speedway/Race Street (2nd Ph) WW 2259 Water Treatment Plant Lagoons W Expected Completion FY 2014 FY 2013/14 FY 2013 FY 2014/15 FY 2013 2314 River Road Improvement Dept. Legend: ST - Street Improvement WW - Wastewater Capital W - Water Capital ST 1,204,421 594,535 State & Federal Grants FY 2013 FIN Report 3rd Qrtr 10 of 14 EXHIBITS Fund Exhibit I OTHER OPERATING/ENTERPRISE FUNDS Actual Revenue Appropriations Ending Beg Bal Amended Actual % Amended Actual % Balance 1/1/2013 Budget Revenue Rec'd Budget Exp Exp'd 9/30/2013 Economic Development $253,488 $229,000 $195,781 85.5% $277,332 $212,233 76.5% $237,036 Neighborhood Development 193,121 2,538,741 1,439,313 56.7% 2,564,724 1,462,100 57.0% 170,334 Community Relations 902,872 521,750 448,410 85.9% 922,855 721,951 78.2% 629,331 Cemetery 35,219 252,550 180,605 71.5% 267,327 208,587 78.0% 7,237 Emergency Services 106,982 1,195,026 738,125 61.8% 1,189,923 724,015 60.8% 121,092 Public Safety Communication 535,778 3,268,328 2,515,994 77.0% 3,520,154 2,360,974 67.1% 690,798 Police Grants 431,407 707,911 526,165 74.3% 708,078 693,052 97.9% 264,520 P.B.I.A. (Parking & Bus Impr) 83,656 205,340 137,586 67.0% 287,522 166,397 57.9% 54,845 Trolley 19,986 64,926 2,085 3.2% 77,246 15,631 20.2% 6,440 Front Street Bus Impr Area 8,750 3,535 2,384 67.4% 5,000 4,489 89.8% 6,645 Cony Center (Tourist Promo) 314,510 1,468,250 1,057,965 72.1% 1,460,299 1,161,813 79.6% 210,662 Capitol Theatre 108,960 359,177 221,363 61.6% 348,300 282,568 81.1% 47,755 PFD- Convention Center 193,585 700,750 550,621 78.6% 684,000 510,150 74.6% 234,056 Tourism Promotion Area 414 667,000 455,799 68.3% 667,000 455,799 68.3% 414 PFD- Capitol Theatre 53,337 528,500 416,857 78.9% 517,000 388,125 75.1% 82,069 Stormwater Operating Fund 1,365,147 2,035,000 1,648,806 81.0% 2,087,622 1,209,344 57.9% 1,804,609 Transit 603,916 8,049,195 6,225,684 77.3% 8,042,761 5,776,608 71.8% 1,052,992 Refuse 533,131 5,473,500 4,030,328 73.6% 5,654,199 4,145,097 73.3% 418,362 Wastewater Operating 1,495,206 20,653,916 14,967,484 72.5% 19,525,178 14,005,512 71.7% 2,457,178 Water Operating 2,910,120 8,258,100 6,382,978 77.3% 8,546,883 5,929,364 69.4% 3,363,734 Irrigation 662,115 1,683,100 1,387,588 82.4% 1,509,163 1,200,520 79.5% 849,183 Equipment Rental 4,602,251 5,653,658 4,158,260 73.5% 5,978,336 3,974,333 66.5% 4,786,178 Environmental 438,798 150,000 0 0.0% 192,950 45,403 23.5% 393,395 Public Works Admin. 474,218 1,147,438 860,578 75.0% 1,202,645 829,560 69.0% 505,236 Total Other Operating Funds $16,326,967 $65,814,691 $48,550,759 73.8% $66,236,497 $46,483,625 70.2% $18,394,101 FIN Report 3rd Qrtr 11 of 14 Fund CAPITAL IMPROVEMENT FUNDS Actual Revenue Beg Bal Amended Actual 1/1/2013 Budget Revenue Rec'd Appropriations Amended Actual Budget Exp Arterial Street Central Bus District Capital Capitol Theatre Construction Yakima Redevelopment Area Parks and Recreation Capital Fire Capital Law and Justice Capital Public Works Trust Constr REET 2 Capital Transit Capital Reserve Convention Center Cap Impr Reserve for Capital Impr Stormwater Capital Fund Wastewater Capital Domestic Water Improvement Irrigation System Impr Total Capital Impr Funds FIN Report 3rd Qrtr $400,600 $8,870,322 $7,235,228 81.6% $8,935,977 $3,546,201 335,424 0 44,163 n/a 229,500 143,345 619 0 0 n/a 0 0 671,283 3,350,000 396,413 11.8% 2,509,240 557,387 156,544 75,000 82,996 n/a 100,000 99,950 470,817 1,309,750 553,231 42.2% 1,246,896 230,728 272,377 5,086,513 1,525,758 30.0% 5,289,102 1,697,408 695,613 611,306 460,407 75.3% 958,782 624,439 437,954 527,000 460,407 87.4% 506,822 378,411 1,231,995 618,250 380,627 61.6% 545,500 46,391 537,767 220,500 165,000 74.8% 295,000 68,684 2,667,858 10,728,000 3,888,713 36.2% 12,537,058 5,177,497 992,090 320,000 149,313 46.7% 503,424 111,787 8,692,828 15,132,000 6,372,802 42.1% 20,455,000 9,432,226 3,810,836 4,600,000 368,716 8.0% 7,150,896 3,155,944 58,847 1,208,500 970,891 80.3% 1,073,252 781,540 $21,433,452 $52,657,141 $23,054,665 43.8% $62,336,449 $26,051,938 Exhibit II Ending Balance Exp'd 9/30/2013 39.7% $4,089,627 62.5% 236,242 n/a 619 22.2% 510,309 100.0% 139,590 18.5% 793,320 32.1% 100,727 65.1% 531,581 74.7% 519,950 8.5% 1,566,231 23.3% 634,083 41.3% 1,379,074 22.2% 1,029,616 46.1% 5,633,404 44.1% 1,023,608 72.8% 248,198 41.8% $18,436,179 12 of 14 Exhibit III RESERVE AND OTHER FUNDS Actual Revenue Appropriations Ending Beg Bal Amended Actual % Amended Actual % Balance Fund 1/1/2013 Budget Revenue Rec'd Budget Exp Exp'd 9/30/2013 Employee Benefit Reserves Unemployment Comp Res $358,948 $177,000 $140,851 79.6% $293,796 $82,359 28.0% $417,440 Employees Health Ben Res 2,471,682 11,995,000 7,965,872 66.4% 11,628,854 6,903,758 59.4% 3,533,796 Worker's Compensation Res 1,092,471 1,018,000 850,403 83.5% 1,244,636 782,911 62.9% 1,159,963 Wellness/EAP 126,438 60,000 952 1.6% 120,200 75,051 62.4% 52,339 Firemens' Relief and Pension 892,140 1,380,500 828,472 60.0% 1,347,493 914,770 67.9% 805,842 Total Employee Ben Reserve $4,941,679 $14,630,500 $9,786,550 66.9% $14,634,979 $8,758,849 59.8% $5,969,380 Operating Reserves Capitol Theatre Reserve 251,922 500 0 0.0% 71,927 0 0.0% 251,922 Risk Management Reserve 1,030,191 3,586,000 2,964,841 82.7% 3,846,337 3,062,625 79.6% 932,407 Total Operating Reserve $1,282,113 $3,586,500 $2,964,841 82.7% $3,918,264 $3,062,625 78.2% $1,184,329 Trust and Agency Funds Cemetery Trust $612,724 $16,500 $7,504 45.5% $5,500 $0 0.0% $620,228 Agency Fund-YAKCORPS 392,200 511,700 528,073 103.2% 511,700 531,104 103.8% 389,169 Total Other Funds $1,004,924 $528,200 $535,577 101.4% $517,200 $531,104 102.7% $1,009,397 FIN Report 3rd Qrtr 13 of 14 Exhibit IV BOND REDEMPTIONS FUNDS Actual Revenue Appropriations Ending Beg Bal Amended Actual % Amended Actual % Balance Fund 1/1/2013 Budget Revenue Rec'd Budget Exp Exp'd 9/30/2013 GO Bond Redemption LID Guaranty $60,164 $50 $0 0.0% $0 $0 n/a $60,164 2002 GO Convention Center 168,506 1,017,594 732,736 72.0% 1,017,000 543,600 53.5% 357,642 2005 GO Parks and Rec Bond 14,739 1,286,989 587,803 45.7% 1,290,844 518,279 40.2% 84,263 1994 GO LTD Police & Streets 96,934 512,000 299,997 58.6% 515,625 7,813 1.5% 389,118 1995 GO Street, Parks & Fire 189,345 293,000 173,499 59.2% 294,600 9,800 3.3% 353,044 1996 GO LTD- Cony Center 65,220 428,750 317,694 74.1% 428,315 49,158 11.5% 333,756 LID Debt Service Control 54,154 274,000 133,111 48.6% 285,000 84,302 29.6% 102,963 Total G.O. Bond Redemption $649,062 $3,812,383 $2,244,840 58.9% $3,831,384 $1,212,952 31.7% $1,680,950 Water/Sewer Revenue Bond Redemption 1997 Water Rev Bond Res $271,407 $400 $0 0.0% $0 $0 n/a $271,407 1996 Revenue Bond Reserve 147,763 700 0 0.0% 0 0 n/a 147,763 Water/Sewer Revenue Bonds 114,528 0 0 n/a 0 0 n/a 114,528 1997 Water Revenue Bonds 4,916 232,725 116,350 50.0% 232,700 26,350 11.3% 94,916 2008 Water/Sewer Rev Bond 1 414,813 207,407 50.0% 414,813 94,906 22.9% 112,502 Water/Sewer Rev Bond Res 972,700 1,000 0 0.0% 0 0 n/a 972,700 2003 Irrigation Bond Red 35,436 321,504 321,504 100.0% 321,504 321,504 100.0% 35,436 2003 Wastewater Bond Red 965 1,158,544 579,272 50.0% 1,158,544 176,772 15.3% 403,465 2003 Sewer Rev Bond Res 208,871 0 0 n/a 0 0 n/a 208,871 Total W/S Rev Bond Red $1,756,587 $2,129,686 $1,224,533 57.5% $2,127,561 $619,532 29.1% $2,361,588 FIN Report 3rd Qrtr 14 of 14