Loading...
HomeMy WebLinkAbout10 FISCAL YEAR 2015-2016 MID-YEAR BUDGET REVIEWAgenda Item _ Reviewed: ..r..: AGENDA REPORT City Manager Finance Director MEETING DATE: FEBRUARY 16, 2016 TO: JEFFREY C. PARKER, CITY MANAGER FROM: MATTHEW S. WEST, ACTING FINANCE DIRECTOR SUBJECT: FISCAL YEAR 2015-2016 MID -YEAR BUDGET REVIEW SUMMARY: The following is staff's review of the City's first seven (7) months of operations under the adopted/amended FY 2015-16 Budget. Revenues and expenditures for each fund were reviewed and adjusted based on the current economic climate and projected expenditures reflect costs to date, service needs, and the timing of when funds would be expended. RECOMMENDATION; It is recommended that the City Council approve these supplemental appropriations: 1. Approve a supplemental appropriation of $1,443,787 from the unappropriated reserves of .he General Fund for expenditures associated with the various Memorandums of Understanding; 2. Approve a supplemental appropriation of $148,359 from the unappropriated reserves of the CDBG Fund for expenditures associated with downtown commercial core 1 old town study and Frontker Park playground renovation; 3. Approve a supplemental appropriation of $160,300 from the unappropriated reserves of the Asset Forfeiture Fund for transfer of funds to the RNSP Asset Forfeiture and Treasury RNSP Asset Forfeiture Funds; 4. Approve a supplemental appropriation of $6,400 from the unappropriated reserves of the Supplemental Law Enforcement Fund for expenditures associated with the various Memorandums of Understanding; 5. Approve a supplemental appropriation of $12,300 from the unappropriated reserves of the Information Technology Fund for expenditures assoc ated with the varous Memorandums of Understanding; and Fiscal Year 201.5-2016 Mid -Year Budget Review February 16, 20I6 Page 2 6. Approve a supplemental appropriation of $38,300 from the unappropriated reserves of the Community Facilities District 04-1 and 13-1 Funds for administrative costs. CORRELATION TO THE STRATEGIC PLAN: The recommendation correlates to the City's strategic plan by implementing Goal C, strategy #3, develop and communicate a comprehensive set of financial policies and their purpose to strengthen financial practices. FISCAL IMPACT: The attached Mid -Year Budget Review is inclusive of all operating Departments and City Funds. Each department reviewed its areas of responsibility and provided projections that are presented in this report. The projected year-end expenditures for all funds are $151,289,829, which is $41,911,690 less than the amended Fiscal Year 2015-16 budget of $193,201,519. The overall reductions in expenditures are due to a combination of operational savings and capital expenditures that were budgeted in FY 2015-16, which will be carried over to the FY 2016-17 Budget. The FY 2015-16 Amended Budget reflects any supplemental appropriations approved by the City Council through February 2, 2016 as well as prior period encumbrances carried forward. The beginning fund balances that appear on Page 1 of the attached document reflect audited balances as of the end of the last fiscal year, June 30, 2015. The fund balances that are reported primarily reflect cash balances, thereby avoiding any non-cash or restricted items. The following discussion will focus on significant Mid -Year changes that have had an impact on various funds of the City. GENERAL FUND 2015-16 General Fund Projections The projected General Fund Revenues for FY 2015-16 are $55,758,340. This is an increase of $289,040 from the adopted budget of $55,469,300. Increases in revenues were primarily due to increased interest income and administrative fees for administering the Community Facilities Districts (CFDs). Some of these increased revenues were offset by declining revenues in other categories. Fiscal Year 2015-2016 Mid -Year Budget Review February 16, 2016 Page 3 The City's two largest on-going revenue sources are sales and property taxes. The gross property tax income is projected to be $8,832,800. This amount is $157,552 more than actual FY 2014-15 property tax revenues. Property tax collection for next fiscal year is anticipated to remain relatively flat. Gross sales tax income for FY 2015-16 is projected to be $24,412,000, which is the same as the adopted budget. It is anticipated that there will be a slight decline in sales tax revenues for next fiscal year. The State's wind down of the Triple Flip will result in a cleanup payment that artificially inflated the current year's sales tax revenues. These are not new sales tax revenues, just the timing difference of revenues that the City hasn't received due to the Triple Flip. Staff will continue to monitor the process and provide updates as they are made available from the State. The projected General Fund Expenditures of $56,557,056 include supplemental appropriations approved by the City Council through February 2, 2016 as well as those in this report. Total General Fund expenses are projected to be higher than the adopted budget due to increased salary and benefit costs, referenced on page 4 of the attached report. The supplemental appropriation of $1,443,787 (General Fund), $6,400 (Supplemental Law Enforcement Fund), and $12,300 (Information Technology Fund) are for increased salary and benefit costs associated with the approval of the various Memorandum of Understanding (MOU) agreements. The June 30, 2016 General Fund Fund Balance is estimated to be $23,455,022. This amount represents 42% of General Fund operating expenditures, which meets the City Council's Reserve Policy of a minimum General Fund Balance reserve of 20%. A supplemental appropriation of $160,300 has been requested for the Asset Forfeiture Fund so that the City can transfer the previously co -mingled asset forfeiture revenues into a separate Regional Narcotic Suppression Program (RNSP) Asset Forfeiture Fund based on where the funds come from in order to meet State and Federal guidelines. A supplemental appropriation of $38,300 has been requested for the Community Facility District Funds (CFD 04-1 & CFD 13-1) for administrative costs associated with administering the CFDs. OTHER SIGNIFICANT FUNDS Capital Projects Fund The current appropriations for capital projects for all funds, which are funded through developer deposits, grants, special revenue sources (i.e. Measure M Tum -back, Measure M2 Fair -share, Gas Tax, Community Development Block Grant, Bonds, etc.), Successor Agency to the Tustin Community Redevelopment Agency (Successor Agency), land proceeds, backbone fee, and Water Enterprise are estimated to be $83M. It is anticipated that $36.7M of the appropriated amount will be expensed on capital projects during FY 2015-16. Capital projects may span multiple fiscal years and it is anticipated that the Fiscal Year 2015-2016 Mid -Year Budget Review February 16, 2016 Page 4 remaining capital expenditures will be expended in future fiscal years. Last fiscal year the City expended $36.3M on capital projects. Capital projects for current and future fiscal years include the Tustin Legacy Park, Tustin Legacy Linear Park, Bio -filtration retrofits, Park Avenue, Moffett Drive, and others as outlined in the City's Seven -Year Capital Improvement Plan (CIP). The projected year- end fund balance for the Capital Projects Fund (Fund 200) is $6,175,772. Any undesignated reserves are meant to address future projects detailed in the Seven -Year CIP. Community Development Block Grants (CDBG) The projected CDBG revenues for FY 2015-16 are $703,100. The actual revenues for FY 2014-15 were $1,122,881. The nature of ongoing CDBG programs may result in the skewing of expenditures from year to year. Some years will have much greater activity due to capital improvements as funds have been accumulated for major projects. The City receives CDBG funds on a reimbursement basis as funds are expended on approved programs. The supplemental appropriations of $148,359 are for expenditures associated with the downtown commercial core / old town study and Frontier Park playground renovation. Measure M Funds Measure M Funds include Measure M Turn -back, Measure M2 Fair -share, and project specific Competitive Funds. Measure M/M2 funded capital improvement expenditures for the current fiscal year is projected to be $2,737,400. The projects that are partially funded through Measure M/M2 include the battery backup system for various traffic signals, traffic signal controller upgrades, signal synchronization, catch basins, detention basin landscaping, and bio -filtration. Park Development Fund The Park Development Fund Balance at year end are projected to be $2,326,048. The funds are to be used for future park developments that include Veterans Sports Park, acquisition of additional park space in the southwest quadrant of the City, and playground renovations. Fiscal Year 2015-2016 Mid -Year Budget Review Pa -e 5 February 16, 2016 Tustin Community Redevelopment Agency 1 Successor Agency The Successor Agency to the former TCRDA was formed on February 1, 2012 as the TCRDA was dissolved by AB X1 26. The Successor Agency is tasked with winding down the former TCRDA. The Successor Agency can pay only those enforceable obligations that are on the Recognized Obligation Payment Schedule (ROPS) that have been approved by DoF. Previously, ROPS are prepared for six (6) month increments, however the revised HSC section 34177.7 (o) allows for the BOPS to be prepared for 1 year starting with Fiscal Year 2016-17. The 2016-17 ROPS has enforceable obligations of $11,415,205, including Administrative Cost Allocation. Water Enterprise The Water Enterprise Fund is projected to have operating revenues of $15,481,100, which is $2,929,276 less than prior fiscal year actuals. This decrease is due to the City's conservation efforts to meet the 28% State mandated conservation target. The projected year-end operating expenditures are $16,761,333. The projected year end operating Fund Balance for the Water Enterprise is $7,675,888, which will be used for operating reserves, meeting debt service requirements, and funding future capital replacements. The 2013 Water Revenue Bonds were issued in October 2013 for the construction of various capital infrastructure including Simon Ranch Reservoir and Tustin Avenue Well. The Simon Ranch Reservoir project (CIP No. 60114) and Tustin Avenue Well project (CIP No. 60146) are currently underway. Risk Management Funds The Risk Management Fund as represented in this report is a summary of the Liability, Workers' Compensation, and Unemployment Funds. The City is a member of the California Insurance Pool Authority, a risk -sharing pool made up of twelve Cities for both liability and workers' compensation coverage. The City is self-insured for the first $250,000 of each liability claim (this is referred to as a self-insured retention) and the first $400,000 of each workers' compensation claim. The City is fully self-insured for all unemployment claims. The Risk Management Funds Fund Balance was established based on actuarial analysis and the City's ability to fund it. The projected combined year end Fund Balance for all three Risk Management Funds is $1,115,055. Fiscal Year 2015-2016 Mid -Year Bud -et Review Pare 6 February 16, 2016 ECONOMIC 1 OTHE=R CONSIDERATIONS Staff will continue to monitor Sales Tax and Property Tax trends throughout the year as we update the 2"d year of the 2015-17 biennial budget. We will prioritize the City's goals and objectives based on City Council policy direction, as well as potential actions by the State that could have negative impacts on the City's future financial condition. 91,WW J - ai't M tthew S. West Acting Finance Director Attachments: Mid -Year Budget Review jean Tran Administrative Services Manager CITY OF TUSTIN MID -YEAR BUDGET REVIEW FISCAL YEAR 2015-16 TUS IN HISTORY BUILDING OUR FUTURE HONOM NG OUR PAST FEBRUARY 16, 2016 PREPARED BY THE FINANCE DEPARTMENT CITY OF TUSTIN CITY COUNCIL John Nielsen, Mayor Allan Bernstein, Mayor Pro Tem Rebecca "Beckie" Gomez, Councilmember Al Murray, Councilmember Chuck Puckett, Councilmember Jeffrey C. Parker, City Treasurer David Kendig, City Attorney MANAGEMENT STAFF Jeffrey C. Parker, City Manager Elizabeth A. Binsack, Director of Community Development Charles F. Celano, Chief of Police Matthew S. West, Acting Director of Finance David A. Wilson, Director of Parks and Recreation Services Doug Stack, Director of Public Works/City Engineer Derick Yasuda, Director of Human Resources TABLE OF CONTENTS Fund Balance Projections Page 1 Revenue Summaries 2-3 Expenditure Summaries: 4-5 Department Expenses: 12 City Council, City Clerk, and City Attorney 5 City Manager, Finance 5-6 Human Resources, Community Development 6 Public Works 7-8 Police/Fire 8-9 Parks & Recreation 9-10 Non -Departmental 10 Other Funds: Obligation Reimbursement from Succ. Agency 12 Backbone Fee Fund, Land Proceeds, CIP 12 CDBG 12-13 Cable PEG, Gas Tax 13 Park Development 1 Legacy Park 13-14 S CAQMD 14 Asset Forfeiture 14 Supplemental Law Enforcement 14 Measure M 1 M2 14-15 Lighting and Landscape District 15 Street Lighting 15 Workers' Comp 15 Liability 15 Unemployment 16 Equipment Replacement 16 Information Technology 16 Water Enterprise 16-17 Assessment District 1 CFD 18-19 Tustin Housing Authority 19 Cl P Summary by Project 20-28 City of Tustin FY 2015-16 MidYear Budget Year End Projected Fund Balance for ALL FUNDS Fund Description Audited Ending / Beginning Balance 06/30/14 14/15 Acutal One -Time Transfer In / 1 Cash 14/15 Acutal Revenues 14/15 Acutal Expenditures 14/15 Acutal One -Time Transfer Out Audited Ending Balance 06/30/15 15/16 Projected One -Time Transfer In / Cash 15/16 Projected Revenues 15/16 Projected Expenditures 15/16 Projected One -Time Transfer Out Projected Ending Balance 06/30/16 100 General Fund $18,212,579 $6,546,347 $52,586,738 48,958,698 2,572,721 $24,253,738 $910,500 $54,847,840 55,431,056 1,126,000 $23,455,022 101 General Fund - Emergency Fund 0 1,000,000 0 0 0 1,000,000 0 0 0 0 1,000,000 186 Oblg Reimb Frm Successor Agncy 1,884,478 0 14,390 1,234 0 1,897,634 0 11,800 600 0 1,908,834 187 Backbone Fee Fund 1,352,309 0 16,946,435 1,648,411 0 16,650,333 0 10,305,600 177,600 0 26,778,333 189 Land Held for Resale 6,235,423 0 49,382,458 8,800,352 6,140,000 40,677,529 0 307,200 8,953,947 5,832,500 26,198,282 200 Capital Projects Fund-CIP 5,493,536 0 2,848,851 2,401,516 0 5,940,872 0 3,430,000 3,195,100 0 6,175,772 120 CDBG (2,441) 0 1,122,881 1,122,881 0 (2,441) 0 703,100 700,659 0 0 129 Cable PEG Fees Fund 66,265 0 114,687 0 0 180,952 211,000 130,000 500,000 0 21,952 130 Gas Tax 5,335,506 0 2,225,104 2,405,721 0 5,154,888 0 1,179,800 1,798,468 0 4,536,221 131 Park Development 3,063,442 0 218,158 490,220 0 2,791,380 0 228,200 754,600 0 2,264,980 132 Park Development Tustin Legacy 5,010,687 0 38,262 3,281 0 5,045,668 0 15,400 5,000,000 0 61,068 133 SCAQMD 69,955 0 123,189 76 0 193,069 0 100,600 98,000 0 195,669 134 Asset Forfeiture 371,982 0 61,630 51,490 0 382,123 0 900 317,200 160,300 (94,477) 135 RNSP Asset Forfeiture 0 0 0 0 0 0 136,000 600 0 0 136,600 136 Supplemental Law Enforcement 70,492 0 137,143 137,309 0 70,326 0 100,200 106,500 0 64,026 137 Treasury RNSP Asset Forfeiture 0 0 0 0 0 0 24,300 100 0 0 24,400 138 Measure M 683,758 0 5,197 18,121 0 670,835 0 2,000 0 0 672,835 139 Measure M2 1,032,290 0 6,483,792 4,057,453 111,616 3,347,013 0 3,755,800 2,698,400 39,000 4,365,413 141 Tustin LLD (117,262) 210,601 535,140 715,504 0 (87,024) 745,200 540,000 1,173,200 0 24,976 142 Tustin SL 1,283,464 0 876,542 924,962 0 1,235,045 0 850,000 627,500 0 1,457,544 181 Workers Compensation 2,339,733 0 715,857 855,698 1,089,156 1,110,736 0 884,500 850,800 430,600 713,836 182 Liability 220,231 1,079,156 34,736 1,408,714 0 (74,592) 1,546,500 0 1,123,633 0 348,275 183 Unemployment 59,820 10,000 396 22,672 0 47,544 10,100 0 4,700 0 52,944 184 Equipment Replacement Fund 4,415,111 500,000 714,988 741,823 0 4,888,276 0 874,200 2,506,476 0 3,256,000 185 Information Technology 505,820 0 1,567,687 1,176,293 0 897,214 0 1,837,900 2,201,502 0 533,612 300 Water Enterprise 10,186,135 154 18,410,376 15,140,643 0 13,456,021 100 15,481,100 16,761,333 4,500,000 7,675,888 301 Water Capital Fund 3,423,606 0 1,559,760 (218,472) 0 5,201,839 2,500,000 1,552,700 1,047,600 0 8,206,939 302 Water Enterprise Emergency Fund 0 0 0 0 0 0 2,000,000 0 0 0 2,000,000 305 2011 Water Revenue Bond Fund 4,826,300 0 36,880 3,156 154 4,859,870 0 14,900 3,000,000 0 1,874,770 306 2013 Water Revenue Bond Fund 14,084,263 0 107,298 (148,206) 0 14,339,767 0 42,600 800,000 0 13,582,367 431 Assessment Dist. 95-1 Construction 3,651,209 0 6,963 55,323 210,601 3,392,248 0 1,900 0 745,200 2,648,948 433 CFD 04-1 1,022,543 0 1,269,972 1,175,833 8,498 1,108,183 0 1,278,000 1,371,200 0 1,014,983 434 CFD 06-1 Construction 7,937,537 1,560,411 336,132 8,431,878 244,923 1,157,280 0 100 1,157,300 0 80 435 CFD 06-1 Debt Service 9,220,953 0 5,523,894 5,341,227 0 9,403,620 0 5,500,500 5,442,200 0 9,461,920 436 CFD 07-1 Debt Service 1,908,686 0 1,144,865 1,117,332 2,902 1,933,317 0 1,146,100 1,127,900 0 1,951,517 437 CFD 07-1 Construction 279 214 0 0 21 472 0 0 0 0 472 438 CFD 06-1 Annex Construction 665,504 12,310 60 223,485 292,535 161,854 0 10 17,100 12,310 132,454 440 CFD 13-01 0 0 3,934 3,934 0 0 0 108,234 3,300 0 104,934 441 CFD 14-01 0 0 0 0 0 0 0 3,412,975 0 0 3,412,975 442 Special Tax B 0 0 2,833,686 0 2,833,686 0 0 3,107,800 0 0 3,107,800 443 CFD 14-01 Construction 0 0 0 0 0 0 0 26,358,551 1,000,000 0 25,358,551 561 MCAS 2010 TAB Proceeds 32,093,248 0 244,424 906,592 2,828,050 28,603,029 0 189,700 15,962,500 0 12,830,229 570 Successor Agency (Trust Fund) 0 4,356,947 48,831 3,435,575 250,000 720,204 4,112,692 0 2,213,529 0 2,619,367 575 Tustin Housing Authority 1,572,439 0 25,053 271,596 0 1,325,896 0 5,860 320,016 0.' ,,7 TOTAL ALL FUNDS $148,179,884 $15,276,140 $168,306,389 $111,682,326 $16,584,863 $201,934,716 $12,196,392 6,7 $138,3070 $138,443,919 $12,845,910 148 $201,,049 Fund Balance - MidYear 2016 1 211112016 6:26 PM City of Tustin FY 15-16 MidYear Budget Revenue Summary - All Funds Revenue Summary 12113 Actual 13114 Actual 14115 Actual 15116 Budget 15116 Projected 100 General Fund General Governmental Rev 48,080,214 48,224,578 55,705,497 51,416,800 51,653,500 Community Development 1,187,718 1,654,973 1,521,641 2,050,700 2,051,540 Public Works 50,423 83,372 67,029 57,300 57,300 Police Services 885,826 800,508 952,250 886,000 941,000 Fire Services 19,095 26,338 19,418 15,000 23,000 Parks and Recreation 906,097 944,995 867,251 1,043,500 1,032,000 100 General Fund 51,129,372 51,734,763 59,133,085 55,469,300 55,758,340 101 Emergency Fund 0 0 1,000,000 0 0 186 Oblg Reimb Frm Successor Agncy 2,113,189 10,564 14,390 0 11,800 187 Backbone Fee Fund 19,616,130 58,707 16,946,435 10,305,600 10,305,600 189 Land Held for Resale 144,183,899 352,341 49,382,458 0 307,200 200 Capital Projects Fund-CIP 15,747,280 4,684,828 2,848,851 3,424,700 3,430,000 120 CDBG 397,911 533,129 1,122,881 552,300 703,100 129 Cable PEG Fees 0 66,265 114,687 341,000 341,000 130 Gas Tax 1,743,684 2,463,784 2,225,104 1,657,800 1,179,800 131 Park Development 162,549 188,863 218,158 168,000 228,200 132 Park Development Tustin Legacy 10,635 28,268 38,262 30,000 15,400 133 SCAQMD 47,245 118,127 123,189 82,100 100,600 134 Asset Forfeiture 178,926 202,279 61,630 101,000 900 135 RNSP Asset Forfeiture 0 0 0 0 136,600 136 Supplemental Law Enforcement 102,780 146,628 137,143 173,500 100,200 137 Treasury RNSP Asset Forfeiture 0 0 0 0 24,400 138 Measure M 3,131 7,121 5,197 2,000 2,000 139 Measure M2 4,473,201 2,450,310 6,483,792 3,755,800 3,755,800 141 Tustin LLD 723,402 688,990 745,742 1,285,200 1,285,200 142 Tustin SL 944,672 854,307 876,542 850,000 850,000 181 Workers Compensation 676,150 636,343 715,857 887,100 884,500 182 Liability 722,169 122,404 1,113,892 1,546,500 1,546,500 183 Unemployment 150 470 10,396 10,100 10,100 184 Equipment Replacement Fund 971,812 1,752,360 1,214,988 874,200 874,200 185 Information Technology 1,125,446 1,240,008 1,567,687 1,837,900 1,837,900 300 Water Enterprise 15,475,341 17,609,770 18,410,530 18,991,200 15,481,200 301 Water Capital Fund 1,494,939 1,546,473 1,559,760 4,100,000 4,052,700 302 Water Enterprise Emergency Fund 0 0 0 2,000,000 2,000,000 305 2011 Water Revenue Bond Fund 30,050 6,824,586 36,880 30,000 14,900 306 2013 Water Revenue Bond Fund 0 14,072,672 107,298 30,000 42,600 430 Assessment Dist. 95-1 0 0 0 0 0 431 Assessment Dist. 95-1 Construction 44,595 (545) 6,963 1,600 1,900 432 Assessment Dist. 95-2 Debt Service 0 0 0 0 0 433 CFD 04-1 10,954,108 1,295,522 1,269,972 1,278,000 1,278,000 434 CFD 06-1 Construction 5,737,118 253,871 1,896,543 3,000 100 435 CFD 06-1 Debt Service 5,561,875 5,363,759 5,523,894 5,502,000 5,500,500 436 CFD 07-1 Debt Service 1,122,708 1,127,007 1,144,865 1,146,300 1,146,100 437 CFD 07-1 Construction 132 301 214 0 0 438 CFD 06-1 Annex Construction 214,821 292,897 12,370 100 10 440 CFD 13-1 0 0 3,934 0 108,234 441 CFD 14-1 0 0 0 13,200,000 3,412,975 442 Special Tax B 0 0 2,833,686 0 3,107,800 443 CFD 14-1 Construction 0 0 0 0 26,358,551 561 2010 MCAS TABS 69,279 182,098 244,424 0 189,700 570 Successor Agency (Trust Fund) 10,115,598 5,536,235 4,405,779 0 4,112,692 575 Tustin Housing Authority 929,262 28,021 25,053 5,600 5,860 TOTAL 296,823,562 122,473,525 183,582,529 129,641,900 150,503,162 Rev Summaries - MidYear 2016 2 2/11/2016 City of Tustin FY 15-16 MidYear Budget Revenue Summary - All Funds Revenue Summary 12113 Actual 13114 Actual 14115 Actual 15116 Budget 15116 Projected 100 General Fund Property Tax in Lieu of VLF 5,912,403 6,117,809 6,348,585 6,353,000 6,353,000 Property Taxes 8,177,456 8,311,526 8,675,248 8,842,700 8,832,800 Residual Property Taxes 1,890,121 995,274 1,103,444 1,300,000 1,300,000 In Lieu -Prop Tax 17,771 18,127 19,070 12,700 12,700 AB 1290 Pass Thru 71,518 77,227 85,256 75,000 75,000 Special Tax B 2,570,192 2,620,058 2,837,620 2,350,000 2,350,000 Franchise Fees 1,788,688 1,797,936 1,911,699 1,854,000 1,867,900 Sales Tax Backfill 5,021,322 5,910,416 5,345,304 4,173,400 4,173,400 Sales and Use Tax 16,255,670 16,065,151 16,596,817 20,238,600 20,238,600 Sales Tax - Public Safety - Prop 172 298,413 312,465 327,775 284,200 284,200 Transient Occupancy Tax 137,064 616,897 1,090,675 1,250,000 1,250,000 Business License Fees 377,498 393,241 419,148 405,000 405,000 Real Property Transfer Tax 366,790 302,916 479,892 310,000 310,000 New Construction Tax 33,346 297,948 39,201 150,000 83,900 Planning Plan Check Fees 154,691 198,936 194,850 316,500 316,500 Building Permits & Plan Checks 938,364 1,395,180 1,253,113 1,582,300 1,582,300 Fees and Other Permits 236,143 259,004 241,840 290,700 294,640 Fines and Forfeitures 678,428 631,339 752,598 726,000 776,000 Interest Income 20,336 161,924 227,204 175,000 319,200 Use of property 415,935 595,987 933,116 1,067,500 1,005,000 POST Reimbursement 53,612 26,422 43,534 35,000 35,000 Revenue from Other Agencies 35,105 5,104 5,692 5,000 191,000 State Grants 106,833 36,615 16,764 3,000 20,800 Federal Grants 51,431 40,224 129,340 25,000 37,600 Sports Fees 312,360 308,787 276,144 315,500 299,500 Class Fees 265,486 308,667 246,605 290,000 290,000 Other Recreation Fees 177,328 194,275 203,149 195,000 199,500 Transfer In 2,675,593 1,802,221 6,546,347 910,500 910,500 Reimbursement from Other Funds 1,200,000 1,200,000 1,200,000 1,300,000 1,300,000 All Other Sources 889,477 733,088 1,583,054 633,700 644,300 General Fund Total 51,129,372 51,734,763 59,133,085 55,469,300 55,758,340 Rev Summaries - MidYear 2016 3 2/11/2016 City of Tustin FY 15-16 MidYear Budget - Expenditure Summary Expenditure Summary 12/13 13/14 14/15 15/16 15/16 Actual Actual Actual Budget Projected 100 General Fund City Council 85,081 47,985 39,847 37,500 37,500 City Clerk 338,876 359,776 412,873 437,200 453,000 City Attorney 538,702 475,086 506,798 550,000 550,000 City Manager 684,347 1,272,627 1,430,382 1,500,665 1,420,900 Finance 1,051,240 1,080,104 1,095,719 1,200,490 1,239,790 Human Resources 649,527 551,769 630,456 685,100 704,200 Community Development 2,519,316 2,671,861 2,917,396 3,354,100 3,659,800 Public Works 7,532,613 7,705,945 9,232,428 11,212,114 11,185,925 Police Services 21,763,559 22,134,424 21,934,147 23,318,400 24,443,941 Fire Services 6,084,047 6,277,854 6,668,629 6,869,800 6,869,800 Parks and Recreation 2,742,497 2,881,055 2,905,565 3,455,000 3,496,400 Successor Agency / RDA 34,826 (472,599) 0 0 0 Non -Departmental, Other 146,441,507 1,706,258 3,757,180 2,492,900 2,495,800 100 General Fund 190,466,137 46,692,144 51,531,419 55,113,269 56,557,056 101 Emergency Fund 0 0 0 0 0 186 Oblg Reimb Frm Successor Agnc 3,273,302 (937,239) 1,234 0 600 187 Backbone Fee Fund 787 18,321,741 1,648,411 10,135,470 177,600 189 Land Held for Resale (20,968,042) 30,576,870 14,940,352 15,501,747 14,786,447 200 Capital Projects Fund-CIP 15,103,168 8,805,110 2,401,516 3,722,020 3,195,100 120 CDBG 402,111 533,129 1,122,881 552,300 700,659 129 Cable PEG Fees 0 0 0 500,000 500,000 130 Gas Tax 1,012,823 1,826,329 2,405,721 2,172,700 1,798,468 131 Park Development 598,192 299,197 490,220 1,736,700 754,600 132 Park Develop. Tustin Legacy 2,022 4,009 3,281 5,000,000 5,000,000 133 SCAQMD 68,550 210,499 76 98,000 98,000 134 Asset Forfeiture 109,304 243,083 51,490 317,246 477,500 135 RNSP Asset Forfeiture 0 0 0 0 0 136 Supplemntal Law Enforcement 111,530 104,574 137,309 100,100 106,500 137 Treasury RNSP Asset Forfeiture 0 0 0 0 0 138 Measure M 347,424 724,155 18,121 0 0 139 Measure M2 4,674,930 2,652,425 4,169,069 3,798,800 2,737,400 141 Tustin LLD 786,566 746,490 715,504 1,288,200 1,173,200 142 Tustin SL 546,430 1,362,728 924,962 637,500 627,500 181 Workers Compensation 1,435,011 842,187 1,944,854 1,281,400 1,281,400 182 Liability 614,448 969,357 1,408,714 1,126,000 1,123,633 183 Unemployment 26,130 35,763 22,672 30,000 4,700 184 Equipment Replacement Fund 635,078 1,481,040 741,823 2,506,476 2,506,476 185 Information Technology 1,101,052 1,172,438 1,176,293 2,189,202 2,201,502 300 Water Enterprise 12,968,860 36,323,263 15,140,643 21,730,190 21,261,333 301 Water Capital Fund 627,343 610,206 (218,472) 2,975,600 1,047,600 302 Water Emergency Fund 0 0 0 0 0 305 2011 Water Rev Bond Fund 9,293,089 305,752 3,310 4,673,000 3,000,000 306 2013 Water Rev Bond Fund 0 4,882 (148,206) 1,825,000 800,000 430 Assess Dist. 95-1 0 0 0 0 0 431 Assess Dist. 95-1 Construction 381,800 257,756 265,924 745,200 745,200 432 Assess Dist. 95-2 Debt Service 0 0 0 0 0 433 CFD 04-1 13,486,693 839,913 1,184,332 1,336,200 1,371,200 434 CFD 06-1 Construction 10,776,306 11,289,721 8,676,801 2,250,000 1,157,300 435 CFD 06-1 Debt Service 5,713,432 5,402,886 5,341,227 5,447,200 5,442,200 436 CFD 07-1 Debt Service 1,436,181 1,110,669 1,120,234 1,127,900 1,127,900 437 CFD 07-1 Construction 3,481 21 21 0 0 438 CFD 06-1 Annex Construction 343,603 947,272 516,020 44,000 29,410 Exp Summaries - MidYear 2016 4 2/11/2016 City of Tustin FY 15-16 MidYear Budget - Expenditure Summary Expenditure Summary 12113 13114 14115 15116 15116 City Council Actual Actual Actual Budget Projected 440 CFD 13-1 0 0 3,934 0 3,300 441 CFD 14-1 0 0 0 0 0 442 Special Tax B 0 0 2,833,686 0 0 443 CFD 14-1 Construction 0 0 0 13,200,000 1,000,000 561 2010 MCAS TABs 933,263 291,583 3,734,643 29,704,400 15,962,500 570 Successor Agency (Trust Fund) 52,139,641 4,535,097 3,685,575 0 2,213,529 575 Tustin Housing Authority 32,557 240,171 271,596 335,700 320,016 TOTAL 308,483,200 178,825,224 128,267,189 193,201,519 151,289,829 City Council 83,978 90,700 90,700 0 0 Personnel 67,827 22,359 9,640 0 0 Operations 17,254 25,626 30,207 37,500 37,500 Capital 0 0 0 0 0 85,081 47,985 39,847 37,500 37,500 City Clerk 2/11/2016 Personnel 249,653 253,235 293,482 326,000 341,800 Operations 89,222 86,614 104,823 110,700 110,700 Capital 0 19,927 14,568 500 500 338,876 359,776 412,873 437,200 453,000 City Attorney Personnel 0 0 0 0 0 Operations 538,702 475,086 506,798 550,000 550,000 Capital 0 0 0 0 0 538,702 475,086 506,798 550,000 550,000 Citv Manaaer's Office City Manager Personnel Operations Capital Economic Development Division Personnel Operations Capital 621,461 793,037 687,413 683,600 716,100 62,886 65,171 83,978 90,700 90,700 0 0 0 0 0 684,347 858,208 771,391 774,300 806,800 0 344,173 284,806 0 70,246 374,186 0 0 0 383,700 390,300 342,665 223,800 0 0 0 414,419 658,992 726,365 614,100 City Manager's Office Personnel 621,461 1,137,210 972,218 1,067,300 1,106,400 Operations 62,886 135,416 458,164 433,365 314,500 Capital 0 0 0 0 0 City Manager's Office Total 684,347 1,272,627 1,430,382 1,500,665 1,420,900 Exp Summaries - MidYear 2016 5 2/11/2016 City of Tustin FY 15-16 MidYear Budget - Expenditure Summary Expenditure Summary 12113 13114 14115 15116 15116 150,055 Actual Actual Actual Budget Projected Finance 2,000 2,000 649,527 551,769 630,456 Personnel 877,044 884,415 871,836 874,200 913,700 Operations 174,196 195,689 223,883 325,290 325,090 Capital 0 0 0 1,000 1,000 1,051,240 1,080,104 1,095,719 1,200,490 1,239,790 Human Resources Personnel 467,723 401,715 477,540 500,800 518,900 Operations 181,803 150,055 148,963 182,300 183,300 Capital 0 0 3,954 2,000 2,000 649,527 551,769 630,456 685,100 704,200 Community Development Planning Personnel 1,074,357 1,209,005 1,246,241 974,900 1,135,700 Operations 100,013 77,607 56,579 688,700 798,700 Capital 7,951 0 0 0 0 1,182,321 1,286,612 1,302,821 1,663,600 1,934,400 Building Personnel 533,464 384,429 403,691 773,700 811,000 Operations 711,056 911,707 1,102,214 716,700 716,700 Capital 0 0 0 0 0 1,244,521 1,296,137 1,505,904 1,490,400 1,527,700 Code Enforcement Personnel 89,060 85,928 77,737 91,500 89,100 Operations 3,414 3,184 30,934 108,600 108,600 Capital 0 0 0 0 0 92,474 89,112 108,671 200,100 197,700 Community Development Personnel Operations Capital Comm. Development Total 1,696,882 1,679,362 1,727,669 1,840,100 2,035,800 814,483 992,499 1,189,728 1,514,000 1,624,000 7,951 0 0 0 0 2,519,316 2,671,861 2,917,396 3,354,100 3,659,800 Exp Summaries - MidYear 2016 6 2/11/2016 City of Tustin FY 15-16 MidYear Budget - Expenditure Summary Expenditure Summary 12113 13114 14115 15116 15116 Actual Actual Actual Budget Projected Successor Agency / RDA Personnel 0 0 0 0 0 Operations 34,826 (472,599) 0 0 0 Capital 0 0 0 0 0 Successor Agency / RDA Total 34,826 (472,599) 0 0 0 Public Works 694,330 735,441 817,800 850,500 Operations 138,286 Administration 102,253 163,734 164,234 Capital 0 0 Personnel 302,711 434,562 482,385 397,900 394,377 Operations 472,109 474,842 509,033 598,800 598,326 Capital 0 3,819 0 0 0 Personnel 774,820 913,223 991,419 996,700 992,703 Engineering Personnel 988,255 694,330 735,441 817,800 850,500 Operations 138,286 103,451 102,253 163,734 164,234 Capital 0 0 0 15,000 15,000 1,126,541 797,781 837,694 996,534 1,029,734 Streets Personnel 513,063 647,400 695,221 611,500 642,700 Operations 162,882 131,869 102,027 139,300 130,100 Capital 0 0 1,200,000 1,910,000 1,910,000 675,945 779,269 1,997,248 2,660,800 2,682,800 Landscape Personnel 1,143,104 1,111,242 1,217,086 1,439,800 1,469,102 Operations 1,420,575 1,675,295 1,698,278 2,092,080 2,027,980 Capital 0 0 0 0 0 2,563,679 2,786,537 2,915,365 3,531,880 3,497,082 Water Quality Personnel 106,198 110,891 108,316 119,200 140,510 Operations 261,955 217,314 257,829 376,000 376,000 Capital 0 0 0 0 0 368,153 328,204 366,145 495,200 516,510 Fleet Maintenance Personnel 358,321 404,068 418,674 451,900 493,400 Operations 512,307 550,126 489,741 651,000 572,896 Capital 0 0 0 0 0 870,628 954,194 908,415 1,102,900 1,066,296 Building Facilities Personnel 186,070 179,211 190,101 340,200 282,400 Operations 925,525 966,056 1,025,452 1,087,900 1,117,900 Capital 0 0 0 0 0 1,111,595 1,145,268 1,215,553 1,428,100 1,400,300 Exp Summaries - MidYear 2016 7 2/11/2016 City of Tustin FY 15-16 MidYear Budget - Expenditure Summary Expenditure Summary 12113 13114 14115 15116 15116 Actual Actual Actual Budget Projected Emergency Services Personnel 0 0 0 0 0 Operations 41,253 1,469 590 0 500 Capital 0 0 0 0 0 41,253 1,469 590 0 500 Public Works Personnel 3,597,721 3,581,704 3,847,223 4,178,300 4,272,989 Operations 3,934,892 4,120,423 4,185,204 5,108,814 4,987,936 Capital 0 3,819 1,200,000 1,925,000 1,925,000 Public Works Total 7,532,613 7,705,945 9,232,428 11,212,114 11,185,925 Police Administration Personnel Operations Capital North Area Division Personnel Operations Capital South Area Division Personnel Operations Capital Special Operations Division Personnel Operations Capital Professional Standards Division Personnel Operations Capital Field Support Services Personnel Operations Capital 889,912 836,184 897,538 1,022,900 1,087,000 836,099 899,569 1,043,666 1,169,800 1,169,800 0 0 0 0 0 1,726,012 1,735,753 1,941,204 2,192,700 2,256,800 5,397,034 5,756,783 5,402,254 5,365,600 5,792,100 190,014 432,625 491,155 479,065 476,560 0 0 0 0 0 5,587,048 6,189,408 5,893,409 5,844,665 6,268,660 5,302,664 5,163,527 4,868,300 5,094,200 5,404,800 115,516 138,259 137,762 149,950 150,450 0 0 0 0 0 5,418,181 5,301,786 5,006,062 5,244,150 5,555,250 3,746,239 3,234,680 3,388,113 3,737,400 3,847,300 331,176 141,591 135,312 185,765 184,111 0 0 0 0 0 4,077,415 3,376,271 3,523,425 3,923,165 4,031,411 1,029,453 1,399,567 1,693,488 1,466,400 1,658,300 53,327 73,772 89,892 237,925 192,925 0 0 0 0 0 1,082,780 1,473,339 1,783,380 1,704,325 1,851,225 2,037,412 2,052,489 2,039,526 2,326,000 2,245,700 488,384 435,904 216,693 488,720 490,020 0 0 0 0 0 2,525,796 2,488,394 2,256,219 2,814,720 2,735,720 Exp Summaries - MidYear 2016 8 2/11/2016 City of Tustin FY 15-16 MidYear Budget - Expenditure Summary Expenditure Summary 12113 13114 14115 15116 15116 Actual Actual Actual Budget Projected Operations Support Services Personnel 1,184,255 1,241,372 1,291,106 1,361,200 1,456,400 Operations 162,072 328,102 239,344 233,475 288,475 Capital 0 0 0 0 0 1,346,327 1,569,474 1,530,449 1,594,675 1,744,875 Police Personnel 19,586,970 19,684,602 19,580,324 20,373,700 21,491,600 Operations 2,176,589 2,449,821 2,353,823 2,944,700 2,952,341 Capital 0 0 0 0 0 Police Total 21,763,559 22,134,424 21,934,147 23,318,400 24,443,941 Fire Service Contract Personnel 0 0 0 0 0 Operations 6,084,047 6,277,854 6,668,629 6,869,800 6,869,800 Capital 0 0 0 0 0 Fire Service Contract Total 6,084,047 6,277,854 6,668,629 6,869,800 6,869,800 Parks & Recreation Administration Personnel 390,159 416,810 417,016 434,400 448,200 Operations 131,359 149,156 163,608 369,000 354,900 Capital 366 719 700 800 800 266,700 521,885 566,684 581,324 804,200 803,900 Sports Personnel 535,991 567,984 572,451 630,100 643,500 Operations 295,547 310,558 294,046 323,300 323,000 Capital 1,688 6,078 1,228 8,500 8,500 833,225 884,620 867,726 961,900 975,000 Classes/Cultural Services Personnel 156,645 140,428 144,609 242,900 250,200 Operations 323,374 327,559 316,244 353,900 364,900 Capital 17,564 11,015 10,446 14,000 14,000 497,583 479,003 471,299 610,800 629,100 Senior Citizens Personnel Operations Capital Support Services Personnel Operations Capital 270,208 306,088 315,258 354,300 363,000 89,204 96,815 100,891 108,900 108,300 0 0 0 0 0 359,411 402,903 416,148 463,200 471,300 241,547 229,840 235,734 259,500 259,000 5,919 7,236 6,837 7,200 7,200 1,403 2,007 1,117 0 2,500 248,869 239,083 243,688 266,700 268,700 Exp Summaries - MidYear 2016 9 2/11/2016 City of Tustin FY 15-16 MidYear Budget - Expenditure Summary Expenditure Summary 12113 Actual 13114 Actual 14115 Actual 15116 Budget 15116 Projected Tustin Youth Center 909,424 1,195,100 1,191,800 22,010 20,896 Personnel 252,829 280,114 296,824 314,000 313,500 Operations 27,706 27,570 27,799 32,800 33,500 Capital 989 1,077 757 1,400 1,400 281,524 308,761 325,379 348,200 348,400 Parks & Rec Personnel Operations Capital Parks & Rec Total Non -Departmental Personnel Operations Capital General Fund Total Personnel Operations Capital 100 General Fund Total 1,847,378 1,941,264 1,981,891 2,235,200 2,277,400 873,110 918,895 909,424 1,195,100 1,191,800 22,010 20,896 14,249 24,700 27,200 2,742,497 2,881,055 2,905,565 3,455,000 3,496,400 359,551 402,276 406,274 401,800 401,800 146,069,621 1,303,844 3,339,056 2,084,100 2,087,000 12,336 138 11,850 7,000 7,000 146,441,507 1,706,258 3,757,180 2,492,900 2,495,800 29,372,210 29,988,142 30,168,098 31,797,400 33,360,389 161,051,630 16,659,223 20,118,701 21,355,669 21,233,967 42,296 44,779 1,244,621 1,960,200 1,962,700 190,466,137 46,692,144 51,531,419 55,113,269 56,557,056 Exp Summaries - MidYear 2016 10 2/11/2016 City of Tustin FY 15-16 MidYear Budget - Expenditure Summary Expenditure Summary 12113 13114 14115 15116 15116 Actual Actual Actual Budget Projected Projected General Fund Expenditures 25,000,000 — 20,000,000 15,000,000 10,000,000 5,000,000 I 0 1 FY 15-16 Budget FY 15-16 Projected as e' c� ay �� �� ay e� oc a" �� (3¢1CP ��( � � a a L` L` Q� o�N �` e Lo Exp Summaries - MidYear 2016 11 211112016 City of Tustin FY 15-16 MidYear Budget - Expenditure Summary Expenditure Summary 12113 13114 14115 15116 15116 Actual Actual Actual Budget Projected Oblg Reimb Frm Successor Agncy Personnel 811,647 0 0 0 0 Operations 2,461,655 (937,239) 1,234 0 600 Capital 0 0 0 0 0 186 Oblg Reimb Frm Successor Agnc 3,273,302 (937,239) 1,234 0 600 Backbone Fee Fund Personnel Operations Capital 187 Backbone Fee Fund Total Land Held for Resale Personnel Operations Capital 189 Land Held for Resale Total CIP, CIP Personnel Operations Capital 200 CIP Total CDBG Admin Personnel Operations Capital 0 0 0 0 0 618 54,694 91,755 0 0 169 18,267,047 1,556,657 10,135,470 177,600 787 18,321,741 1,648,411 10,135,470 177,600 0 0 0 675,213 675,213 (21,256,467) 1,926,104 8,489,934 12,826,534 13,251,534 0 28,538,488 1,758,507 2,000,000 776,400 (21,256,467) 30,464,592 10,248,441 15,501,747 14,703,147 0 0 0 0 0 5,410,667 40,609 117,147 0 0 9,692,501 8,764,500 2,284,369 3,722,020 3,195,100 15,103,168 8,805,110 2,401,516 3,722,020 3,195,100 CDBG Admin, Job Creation / Incentive 149,257 152,016 172,019 212,500 201,000 106,674 80,377 283,012 64,800 224,659 0 0 0 0 0 255,930 232,394 455,031 277,300 425,659 Personnel 0 0 0 0 0 Operations 0 0 0 0 0 Capital 0 0 0 0 0 0 0 0 0 0 CDBG Capital Personnel 0 0 0 0 0 Operations 7,609 0 0 0 0 Capital 48,387 34,470 667,850 275,000 275,000 55,996 34,470 667,850 275,000 275,000 Exp Summaries - MidYear 2016 12 2/11/2016 City of Tustin FY 15-16 MidYear Budget - Expenditure Summary Expenditure Summary 12113 13114 14115 15116 15116 Cable PEG Fees Personnel Operations Capital 129 Cable PEG Fees Total Gas Tax, Non -Dept Personnel Operations Capital Gas Tax, CIP 0 0 0 0 0 0 0 0 500,000 500,000 0 0 0 0 0 0 0 0 500,000 500,000 0 0 0 0 0 1,744 3,994 3,460 0 0 0 0 0 0 0 1,744 3,994 3,460 0 0 Personnel Actual Actual Actual Budget Projected CDBG Total 804,856 1,159,428 1,405,400 1,406,900 1,425,300 Personnel 149,257 152,016 172,019 212,500 201,000 Operations 114,282 80,377 283,012 64,800 224,659 Capital 48,387 34,470 667,850 275,000 275,000 120 CDBG Total 311,926 266,864 1,122,881 552,300 700,659 Cable PEG Fees Personnel Operations Capital 129 Cable PEG Fees Total Gas Tax, Non -Dept Personnel Operations Capital Gas Tax, CIP 0 0 0 0 0 0 0 0 500,000 500,000 0 0 0 0 0 0 0 0 500,000 500,000 0 0 0 0 0 1,744 3,994 3,460 0 0 0 0 0 0 0 1,744 3,994 3,460 0 0 Personnel 176,539 124,801 129,241 205,800 216,168 Operations 804,856 1,159,428 1,405,400 1,406,900 1,425,300 Capital 29,684 538,106 867,620 560,000 157,000 5,000,000 1,011,078 1,822,335 2,402,261 2,172,700 1,798,468 Gas Tax Total Personnel 176,539 124,801 129,241 205,800 216,168 Operations 806,600 1,163,422 1,408,860 1,406,900 1,425,300 Capital 29,684 538,106 867,620 560,000 157,000 130 Gas Tax Total 1,012,823 1,826,329 2,405,721 2,172,700 1,798,468 Park Dev Personnel 0 0 0 0 0 Operations 394,427 147,709 406,604 0 0 Capital 202,382 125,645 81,626 1,736,700 754,600 5,000,000 596,809 273,355 488,230 1,736,700 754,600 Park Dev, CIP Personnel 0 0 0 0 0 Operations 394,427 147,709 406,604 0 0 Capital 202,382 125,645 81,626 1,736,700 754,600 131 Park Dev Total 596,809 273,355 488,230 1,736,700 754,600 Legacy Park, CIP Personnel 0 0 0 0 0 Operations 2,022 4,009 3,281 0 0 Capital 0 0 0 5,000,000 5,000,000 2,022 4,009 3,281 5,000,000 5,000,000 Exp Summaries - MidYear 2016 13 2/11/2016 City of Tustin FY 15-16 MidYear Budget - Expenditure Summary Expenditure Summary 12113 13114 14115 15116 15116 Park Dev Tustin Legacy, CIP Personnel Operations Capital 132 Park Dev Tustin Legacy Total SCAQMD, Non -Departmental Personnel Operations Capital 133 SCAQMD Total Asset Forfeit, Non -Dept. Personnel Operations Capital 134 Asset Forfeit Total Suppl Law Enforcement, CIP Personnel Operations Capital 136 Suppl Law Total Measure M - Non -Dept Personnel Operations Capital Measure M - Capital Personnel Operations Capital Measure M Personnel Operations Capital 138 Measure M Total Actual Actual Actual Budget Projected 0 0 0 0 0 2,022 4,009 3,281 0 0 0 0 0 5,000,000 5,000,000 2,022 4,009 3,281 5,000,000 5,000,000 0 0 0 0 0 68,550 62,724 76 98,000 98,000 0 147,775 0 0 0 68,550 210,499 76 98,000 98,000 0 0 0 0 0 109,304 243,083 51,490 317,246 477,500 0 0 0 0 0 109,304 243,083 51,490 317,246 477,500 96,432 98,164 99,586 100,100 106,500 0 0 0 0 0 15,098 6,397 37,680 0 0 111,530 104,562 137,266 100,100 106,500 0 0 0 0 0 37,945 13,077 442 0 0 0 0 0 0 0 37,945 13,077 442 0 0 0 0 0 0 0 217,676 41,797 0 0 0 91,803 669,281 17,679 0 0 309,479 711,078 17,679 0 0 0 0 0 0 0 255,621 54,874 442 0 0 91,803 669,281 17,679 0 0 347,424 724,155 18,121 0 0 Exp Summaries - MidYear 2016 14 2/11/2016 City of Tustin FY 15-16 MidYear Budget - Expenditure Summary Expenditure Summary 12113 13114 14115 15116 15116 Actual Actual Actual Budget Projected Measure M2 - Non -Dept Personnel 0 0 0 0 0 Operations 185,178 81,138 111,616 39,000 39,000 Capital 0 0 0 0 0 Measure M2 - Capital Personnel Operations Capital Measure M2 Personnel Operations Capital 139 Measure M2 Total Tustin LLD, Special District Personnel Operations Capital 141 Tustin LLD Total Tustin SL Personnel Operations Capital 142 Tustin SL Total Workers Comp, Self Insurance Personnel Operations Capital 181 Workers Comp Total Liability, Self Insurance Personnel Operations Capital 182 Liability Total 185,178 81,138 111,616 39,000 39,000 0 0 0 0 0 26,061 22,899 153,695 0 0 4,463,692 2,548,388 3,903,758 3,759,800 2,698,400 4,489,753 2,571,287 4,057,453 3,759,800 2,698,400 0 0 0 0 0 211,238 104,037 265,310 39,000 39,000 4,463,692 2,548,388 3,903,758 3,759,800 2,698,400 4,674,930 2,652,425 4,169,069 3,798,800 2,737,400 0 0 0 0 0 786,566 746,490 715,504 1,288,200 1,173,200 0 0 0 0 0 786,566 746,490 715,504 1,288,200 1,173,200 0 0 0 0 0 545,458 563,602 603,956 627,500 627,500 344 797,627 320,283 10,000 0 545,802 1,361,229 924,239 637,500 627,500 30,043 700 700 0 0 1,404,968 836,219 1,944,154 1,276,400 1,276,400 0 5,268 0 5,000 5,000 1,435,011 842,187 1,944,854 1,281,400 1,281,400 12,885 1,000 0 0 0 601,357 967,992 1,408,714 1,126,000 1,123,633 0 0 0 0 0 614,242 968,992 1,408,714 1,126,000 1,123,633 Exp Summaries - MidYear 2016 15 2/11/2016 City of Tustin FY 15-16 MidYear Budget - Expenditure Summary Expenditure Summary 12113 13114 14115 15116 15116 Actual Actual Actual Budget Projected Unemployment, Self Insurance Personnel 0 0 0 0 0 Operations 26,082 35,697 22,639 30,000 4,700 Capital 0 0 0 0 0 183 Unemployment 26,082 35,697 22,639 30,000 4,700 Equipment Replacement 491,388 576,112 736,500 760,300 Operations 1,431,151 Personnel 0 0 0 0 0 Operations 5,939 24,711 2,508 0 0 Capital 629,139 1,456,330 739,315 2,506,476 2,506,476 184 Equip. Replacement Total 635,078 1,481,040 741,823 2,506,476 2,506,476 Information Technology 491,388 576,112 736,500 760,300 Operations 1,431,151 Personnel 353,402 272,184 341,708 348,100 360,700 Operations 507,303 592,892 702,598 1,390,540 1,390,140 Capital 240,342 307,322 131,950 450,562 450,562 185 Info. Technology Total 1,101,047 1,172,399 1,176,255 2,189,202 2,201,402 Water, Service Billing Personnel 427,835 491,388 576,112 736,500 760,300 Operations 1,431,151 22,298,603 1,438,270 6,273,190 6,197,500 Capital 44,435 15,760 1,921 83,000 13,000 1,903,420 22,805,750 2,016,304 7,092,690 6,970,800 Water, Administration Personnel 433,958 470,396 486,942 635,500 662,835 Operations 1,397,011 1,980,619 2,301,100 4,349,000 4,056,300 Capital 0 0 0 30,000 30,000 1,830,968 2,451,015 2,788,042 5,014,500 4,749,135 Water Distribution Personnel 1,004,273 909,912 907,825 1,043,400 1,084,722 Operations 111,365 159,979 153,987 183,300 186,917 Capital 0 0 0 0 0 1,115,637 1,069,891 1,061,812 1,226,700 1,271,639 Main Street Facilities Personnel 169,121 150,933 153,062 140,600 154,431 Operations 1,397,574 317,766 674,694 713,400 758,366 Capital 0 0 0 0 0 1,566,695 468,699 827,756 854,000 912,797 Exp Summaries - MidYear 2016 16 2/11/2016 City of Tustin FY 15-16 MidYear Budget - Expenditure Summary Expenditure Summary 12113 13114 14115 15116 15116 2,201,706 Actual Actual Actual Budget Projected 17th Street Desalter 0 0 1,897,818 2,279,482 2,995,450 Personnel 226,448 267,360 291,296 159,500 178,887 Operations 186,992 82,575 145,447 1,101,700 1,097,439 Capital 0 0 0 0 0 Imported Water Personnel Operations Capital Water Production 413,440 349,935 436,743 1,261,200 1,276,326 18,059 40,398 57,954 45,300 54,484 2,994,798 5,396,657 3,242,028 2,195,000 2,135,970 0 0 0 0 0 3,012,857 5,437,056 3,299,982 2,240,300 2,190,453 Personnel 114,834 77,776 90,478 206,200 166,983 Operations 1,782,984 2,201,706 2,904,972 3,834,600 3,720,200 Capital 0 0 0 0 0 1,897,818 2,279,482 2,995,450 4,040,800 3,887,183 Water Utility Fund Total Personnel Operations Capital 300 Water Utility Fund Total Water Capital Fund Personnel Operations Capital 301 Water Capital Fund Total 2011 Water Revenue Bond Fund Personnel Operations Capital Outlay 305 2011 Water Bond Fund Total 2013 Water Revenue Bond Fund Personnel Operations Capital Outlay 306 2013 Water Bond Fund Total 2,394,526 2,408,163 2,563,670 2,967,000 3,062,642 9,301,874 32,437,905 10,860,497 18,650,190 18,152,692 44,435 15,760 1,921 113,000 43,000 11,740,835 34,861,828 13,426,089 21,730,190 21,258,333 0 0 0 0 0 595,930 581,526 335,927 470,000 470,000 0 0 399,152 0 0 595,930 581,526 735,079 470,000 470,000 0 0 0 0 0 0 195 154 0 0 9,286,953 301,683 (0) 4,673,000 3,000,000 9,286,953 0 0 4,673,000 3,000,000 0 0 0 0 0 0 4,882 9,192 0 0 0 0 (157,398) 1,825,000 800,000 0 4,882 (148,206) 1,825,000 800,000 Exp Summaries - MidYear 2016 17 2/11/2016 City of Tustin FY 15-16 MidYear Budget - Expenditure Summary Expenditure Summary 12113 Actual 13114 Actual 14115 Actual 15116 Budget 15116 Projected Assess. District 95-1 0 0 0 0 0 Personnel 0 0 0 0 0 Operations 0 0 0 0 0 Capital 0 0 0 0 0 430 Assess. District 95-1 Total 0 0 0 0 0 Assess. District 95-1, Non Dept Personnel Operations Capital 430 Assess. District 95-1 Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Assess. District 95-1 Construction Personnel 0 0 0 0 0 Operations 191,658 153,301 210,601 745,200 745,200 Capital 137,238 104,455 55,323 0 0 431 District 95-1 Const. Total 328,897 257,756 265,924 745,200 745,200 Assess. District 95-1 Debt Svs Personnel 0 0 0 0 0 Operations 0 0 0 0 0 Capital 0 0 0 0 0 432 District 95-1 Debt Svs Total 0 0 0 0 0 CFD 04-1 Personnel 0 0 0 0 0 Operations 11,819,124 839,913 1,184,332 1,336,200 1,371,200 Capital 0 0 0 0 0 433 CFD 04-1 Total 11,819,124 839,913 1,184,332 1,336,200 1,371,200 CFD 06-1 Construction Personnel 0 0 0 0 0 Operations 278,913 1,103,557 1,149,270 0 0 Capital 10,220,802 9,998,834 7,278,247 2,250,000 1,157,300 434 CFD 06-1 Construction Total 10,499,715 11,102,391 8,427,517 2,250,000 1,157,300 CFD 06-1 Debt Svs Personnel Operations Capital 435 CFD 06-1 Debt Svs Total 0 0 0 0 0 5,696,102 5,395,790 5,341,227 5,447,200 5,442,200 0 0 0 0 0 5,696,102 5,395,790 5,341,227 5,447,200 5,442,200 Exp Summaries - MidYear 2016 18 2/11/2016 City of Tustin FY 15-16 MidYear Budget - Expenditure Summary Expenditure Summary 12113 13114 14115 15116 15116 Actual Actual Actual Budget Projected CFD 07-1 Debt Svs Personnel 0 0 0 0 0 Operations 1,436,181 1,110,669 1,120,234 1,127,900 1,127,900 Capital 0 0 0 0 0 436 CFD 07-1 Debt Svs Total 1,436,181 1,110,669 1,120,234 1,127,900 1,127,900 CFD 07-1 Construction Personnel Operations Capital 437 CFD 07-1 Construction Total CFD 06-1 Annex Construction Personnel Operations Capital 438 CFD 06-1 Annex Const. Total MCAS 2010 TABs Personnel Operations Capital 561 MCAS 2010 TABs Total Tustin Housing Authority Personnel Operations Capital 575 Tustin Housing Authority Total 0 0 0 0 0 21 0 0 0 0 0 0 0 21 0 0 0 0 0 0 0 0 0 214,679 292,535 0 12,310 343,603 732,592 223,485 44,000 17,100 343,603 947,272 516,020 44,000 29,410 80,740 146,198 103,915 104,400 110,800 68,276 6,549 2,848,966 0 0 784,247 138,836 781,762 29,600,000 15,851,700 933,263 291,583 3,734,643 29,704,400 15,962,500 0 157,825 199,266 245,100 257,200 32,557 82,347 72,330 90,600 62,816 0 0 0 0 0 32,557 240,171 271,596 335,700 320,016 Exp Summaries - MidYear 2016 19 2/11/2016 City of Tustin FY 15/16 CIP Capital Improvement Program by Project - Mid Year Projection 20 14/15 14/15 14/15 15/16 15/16 15/16 15/16 15/16 15/16 15/16 Final Audited Audited New/Addl Adopted Carryover Supplemental Mid -Year Current Year -End JL # Description Fund Budget Expenditures Carryover Request Budget Adjustment Adjustments Adjustments Budget Projection Annual Ma or Building Maintanence 10032 Asset Fodelture Fund 134 245,000 0 245,000 30,000 275,000 0 0 0 275,000 275,000 10032 City ClPGeneral Fund 200 820,000 410,271 409,729 185,000 417,000 177,729 0 195,271 790,000 790,000 10032 WaterCapltalFund 301 150,000 165,708 -15,708 0 0 -15,708 0 15,708 0 0 1,215,000 575,979 639,021 215,000 692,000 162,021 0 210,979 1,065,000 1,065,000 Tustin Legacy Fire Station 10048 LennarCFD06-1 Fund 434 0 Complete 0 0 0 0 0 0 0 0 0 0 Tustin Ranch Irrigation System Upgrades/Rehabilitation 10064 Tustin Ranch Maintenance Fund 431 65,138 55,323 9,815 0 0 9,815 0 -9,815 0 65,138 55,323 9,815 0 0 9,815 0 -9,815 0 0 Clifton C. Miller Community Center IGtchen Remodel 10066 Park Development Fund 131 112,500 72,152 40,348 0 0 3,848 0 0 3,848 112,500 72,152 40,348 0 0 3,848 0 0 3,848 0 City Corporate Yard Facilities Master Plan 10067 CityClP Fund - General Fund 200 100,000 87,500 12,500 500,000 500,000 12,500 0 0 512,500 200,000 10067 Water Capital Fund 301 108,000 115,000 -7,000 500,000 500,000 -7,000 0 0 493,000 200,000 208,000 202,500 5,500 1,000,000 1,000,000 5,500 0 0 1,005,500 400,000 Civic Center Alternate Power Source Improvements 10069 Equipment Replacement Fund 184 954,000 14,150 939,850 0 900,000 39,850 0 0 939,850 45,000 954,000 14,150 939,850 0 900,000 39,850 0 0 939,850 45,000 Senior Center Alternate Power Source Improvements 10073 Equipment Replacement Fund 184 500,000 0 500,000 0 470,000 30,000 0 0 500,000 50,000 500,000 0 500,000 0 470,000 30,000 0 0 500,000 50,000 Median Landscape Rehabilitation 10074 MCAS Land Proceeds Fund 189 0 0 0 1,000,000 1,000,000 0 0 0 1,000,000 120,000 0 0 0 1,000,000 1,000,000 0 0 0 1,000,000 120,000 Veterans Sports Park at Tustin Legacy 20043 Legacy Park Development Fund 132 154,980 0 154,980 5,000,000 5,000,000 154,980 0 0 5,154,980 5,000,000 20043 LennarCFD06-1 Fund 434 500,000 252,414 247,586 0 0 247,586 0 0 247,586 247,586 20043 RDA -MCAS Tax Allocation Bonds Fund 561 500,000 0 500,000 7,500,000 8,000,000 0 0 0 8,000,000 8,000,000 1,154,980 252,414 902,566 12,500,000 13,000,000 402,566 0 0 13,402,566 13,247,586 20 City of Tustin FY 15/16 CIP Capital Improvement Program by Project - Mid Year Projection Battery Backup System - Install at Existing Traffic Signal 40079 Gas Tax Fund 130 0 40079 Measure M2 Fairshare Fund 139 624,819 COMPLETE 624,819 0 0 0 0 0 0 0 21 0 0 0 6,574 0 6,574 14/15 14/15 14/15 15/16 15/16 15/16 15/16 15/16 15/16 15/16 Final Audited Audited New/Addl Adopted Carryover Supplemental Mid -Year Current Year -End JL # Description Fund Budget Expenditures Carryover Request Budget Adjustment Adjustments Adjustments Budget Projection Citrus Ranch Park Picnic Shelter 20046 Park Development Fund 131 0 0 0 280,000 280,000 0 0 0 280,000 0 0 0 280,000 280,000 0 0 0 280,000 0 Annual Ma or Park Maintenance 20054 Park Development Fund 131 240,000 64,175 175,825 725,000 875,000 25,825 0 0 900,825 300,000 240,000 64,175 175,825 725,000 875,000 25,825 0 0 900,825 300,000 FrontlerParkPlayoround Renovation 20072 CDBG Fund Year2013 120 195,000 0 195,000 0 195,000 0 0 0 195,000 195,000 195,000 0 195,000 0 195,000 0 0 0 195,000 195,000 Frontier Park Water Element 20074 Park Development Fund 131 0 20,225 -20,225 0 0 -20,225 0 0 -20,225 0 20,225 -20,225 0 0 -20,225 0 0 -20,225 0 Centennial Park Entry & Laurel Glen Park Par Course 20075 Park Development Fund 131 381,000 295,584 85,416 0 81,000 4,416 0 0 85,416 43,865 381,000 295,584 85,416 0 81,000 4,416 0 0 85,416 43,865 Frontier Park Water Play Recirculation System 20076 Park Development Fund 131 250,000 0 250,000 0 240,000 10,000 0 0 250,000 150,000 20076 Park Development Fund -Housing Related Parks Grant Program 131 260,700 0 260,700 0 260,700 0 0 0 260,700 260,700 510,700 0 510,700 0 500,700 10,000 0 0 510,700 410,700 Tustin Legacy Linear Park Between Barranca Parkway and Armstong Avenue 20077 WAS Backbone Fee Fund 187 400,000 0 400,000 3,250,000 3,550,000 100,000 0 -3,150,000 500,000 0 20077 WAS Land Proceeds Fund 189 0 147,700 -147,700 0 0 -147,700 192,900 45,200 45,200 20077 CFD 14-1 441 0 0 0 5,100,000 5,100,000 1,000,000 20077 RDA -MCAS Tax Allocation Bonds Fund 561 1,800,000 1,800,000 0 400,000 147,700 252,300 3,250,000 3,550,000 -47,700 0 3,942,900 7,445,200 1,045,200 Enderle Center Drive and Vandenberg Lane Intersection 40078 Gas Tax Fund 130 15,000 0 40078 Measure M Turnback Fund 138 26,118 0 40078 Measure M2 Fairshare Fund 139 0 0 40078 City CIP Fund - State Local Partnership Program 200 0 COMPLETE 0 41,118 0 0 0 0 0 0 0 0 0 Battery Backup System - Install at Existing Traffic Signal 40079 Gas Tax Fund 130 0 40079 Measure M2 Fairshare Fund 139 624,819 COMPLETE 624,819 0 0 0 0 0 0 0 21 0 0 0 6,574 0 6,574 City of Tustin FY 15/16 CIP Capital Improvement Program by Project - Mid Year Projection 22 14/15 14/15 14/15 15/16 15/16 15/16 15/16 15/16 15/16 15/16 Final Audited Audited New/Addl Adopted Carryover Supplemental Mid -Year Current Year -End JL # Description Fund Budget Expenditures Carryover Request Budget Adjustment Adjustments Adjustments Budget Projection Traffic Signal Equipment Upgrades & Replacement 40080 Gas Tax Fund 130 0 337 -337 0 -337 0 0 -337 0 40080 Measure M2 Fairshare Fund 139 289,482 46,828 242,654 0 165,037 -6,828 0 0 158,209 125,000 289,482 47,165 242,317 0 165,037 -7,165 0 0 157,872 125,000 Jamboree Road, Warner Ave & Tustin Ave Signal Synchronization 40081 Measure M2 Fairshare Fund 139 15,107 12,677 2,430 30,000 33,107 -677 0 0 32,430 32,430 15,107 12,677 2,430 30,000 33,107 -677 0 0 32,430 32,430 First St / Bolsa Ave Signal Synchronization 40082 Measure M2 Fairshare Fund 139 19,000 5,920 13,080 0 14,000 -920 0 0 13,080 13,080 19,000 5,920 13,080 0 14,000 -920 0 0 13,080 13,080 Newport Ave Signal Syncronization 40085 Measure M2 Fairshare Fund 139 70,000 9,291 60,709 20,000 78,000 2,709 0 58,000 138,709 138,709 70,000 9,291 60,709 20,000 78,000 2,709 0 58,000 138,709 138,709 Seventeenth Street Signal Synchronization Project 40086 Measure M2 Fairshare Fund 139 0 203 -203 65,000 65,000 -203 0 0 64,797 64,797 0 203 -203 65,000 65,000 -203 0 0 64,797 64,797 Citywide Installation of Catch Basin BMPs 50036 Measure M2 Fairshare Fund - Competitive 139 0 0 0 160,000 160,000 0 0 0 160,000 0 50036 Measure M2 Fairshare Fund 139 40,000 0 40,000 0 40,000 0 0 12,368 52,368 52,368 40,000 0 40,000 160,000 200,000 0 0 12,368 212,368 52,368 William St Storm Drain Between McFadden Ave & Alliance Ave 50037 CDBG Fund Year 2013 120 69,982 0 0 50037 CDBG Fund Year 2014 120 376,144 0 0 50037 CDBG Fund Year 20 15 120 200,000 0 0 50037 Gas Tax Fund 130 90,000 0 0 50037 Water Capital Fund 301 150,000 COMPLETE 0 0 886,126 0 0 0 0 0 0 0 0 0 Detention Basin Landscaping and Water Quality Installation at Red Hill and Barranca 50038 Measure M2 Fairshare Fund - Competitive 139 824,688 0 824,688 0 824,688 0 0 0 824,688 0 50038 MCAS Backbone Fee Fund 187 778,300 98,092 680,208 0 778,300 -98,092 0 0 680,208 80,208 1,602,988 98,092 1,504,896 0 1,602,988 -98,092 0 0 1,504,896 80,208 22 City of Tustin FY 15/16 CIP Capital Improvement Program by Project - Mid Year Projection 23 14/15 14/15 14/15 15/16 15/16 15/16 15/16 15/16 15/16 15/16 Final Audited Audited New/Addl Adopted Carryover Supplemental Mid -Year Current Year -End JL # Description Fund Budget Expenditures Carryover Request Budget Adjustment Adjustments Adjustments Budget Projection Peters Canyon Wash Water Capture and Reuse Pipeline 50039 RDA -MCAS Tax Allocation Bonds Fund 561 749,000 747,775 1,225 100,000 100,000 1,225 0 0 101,225 100,000 50039 MCAS Backbone Fee Fund 187 0 181,518 -181,518 0 0 -181,518 0 0 -181,518 0 749,000 929,293 -180,293 100,000 100,000 -180,293 0 0 -80,293 100,000 Peters Canyon Channel Improvements 50040 MCAS Backbone Fee Fund 187 0 0 0 2,600,000 2,600,000 0 0 0 2,600,000 0 50040 Lennar CFD 06-1 Fund 434 450,000 201,354 248,646 0 100,000 148,646 0 -219,165 29,481 29,481 50040 Lennar CFD 06-1 Annexation Fund 438 30,000 0 30,000 0 30,000 0 0 -30,000 0 0 50040 CFD 14-1 Fund 441 0 0 0 13,200,000 13,200,000 0 0 0 13,200,000 0 50040 RDA -MCAS Tax Allocation Bonds Fund 561 0 0 0 2,200,000 2,200,000 0 0 0 2,200,000 400,000 480,000 201,354 278,646 18,000,000 18,130,000 148,646 0 -249,165 18,029,481 429,481 Biofiltration Retrofit - Edinger / Red Hill / Valencia / Kensington Park Quadrant 50041 Measure M2FalrshareFund -Competitive 139 1,200,000 63,539 1,136,461 0 1,200,000 -63,539 0 0 1,136,461 1,136,461 50041 Measure M2 Falrshare Fund 139 400,000 400,000 0 400,000 0 0 0 400,000 400,000 1,600,000 63,539 1,536,461 0 1,600,000 -63,539 0 0 1,536,461 1,536,461 Simon Reservoir Analysis and Reconstruction 60114 Water Capital Fund 301 1,000,000 11,540 988,460 0 0 988,460 0 0 988,460 12,520 60114 2013 Water Bond Fund 306 1,000,000 157,398 842,602 1,200,000 1,700,000 342,602 0 0 2,042,602 800,000 2,000,000 168,938 1,831,062 1,200,000 1,700,000 1,331,062 0 0 3,031,062 812,520 Tustin Avenue and 17th Street Water Main Replacements 60146 2011 Water Bond Fund 305 25,000 0 25,000 0 0 25,000 0 0 25,000 0 25,000 0 25,000 0 0 25,000 0 0 25,000 0 Drill and Install Water Well and Wellhead at 1822 N. Tustin Avenue 60150 Water Enterprise Fund 300 5,886 -5,886 0 -5,886 0 0 -5,886 0 60150 2011 Water Bond Fund 305 284,848 0 284,848 0 0 0 0 0 0 0 60150 2013 Water Bond Fund 306 1,650,000 0 1,650,000 0 0 0 0 0 0 0 1,934,848 5,886 1,928,962 0 0 -5,886 0 0 -5,886 0 Tustin Ave / Santa Clara Ave Water Main Project 60155 Water Capital Fund 301 65,000 0 65,000 0 65,000 0 0 0 65,000 0 60155 2011 Water Bond Fund 305 0 0 0 0 0 0 0 0 0 0 65,000 0 65,000 0 65,000 0 0 0 65,000 0 Mardick Road Water Main Replacement btw Red Hill Ave and Beverly Glenn Drive 60160 Water Capital Fund 301 50,000 0 50,000 0 50,000 0 0 0 50,000 0 50,000 0 50,000 0 50,000 0 0 0 50,000 0 23 City of Tustin FY 15/16 CIP Capital Improvement Program by Project - Mid Year Projection JL # Description Fund 14/15 Final Budget 14/15 Audited Expenditures 14/15 Audited Carryover 15/16 New/Addl Request 15/16 Adopted Budget 15/16 Carryover Adjustment 15/16 Supplemental Adjustments 15/16 Mid -Year Adjustments 15/16 Current Budget 15/16 Year -End Projection Fire Flow Hydraulic Modeling 60162 Water Capital Fund 301 102,640 1,755 100,885 0 92,640 8,245 0 0 100,885 0 102,640 1,755 100,885 0 92,640 8,245 0 0 100,885 0 MWD Turnouts - OC 43 Improvements 60163 Water Capital Fund 301 76,000 17,762 58,238 1,024,000 1,050,000 32,238 0 0 1,082,238 120,000 76,000 17,762 58,238 1,024,000 1,050,000 32,238 0 0 1,082,238 120,000 Well Rehab Program 60164 Water Capital Fund 301 579,597 259,852 319,745 270,000 300,000 254,719 0 0 554,719 150,000 579,597 259,852 319,745 270,000 300,000 254,719 0 0 554,719 150,000 Drill & Install Wellhead - Southwest Tustin (Edinger) 60165 Water Enterprise Fund 300 0 303,240 -303,240 0 0 -303,240 0 0 -303,240 0 60165 Water Capital Fund 301 488,000 268,648 219,352 0 148,000 71,352 0 0 219,352 70,000 60165 2011 Water Bond Fund 305 3,673,000 0 3,673,000 1,000,000 4,673,000 0 0 0 4,673,000 3,000,000 4,161,000 571,888 3,589,112 1,000,000 4,821,000 -231,888 0 0 4,589,112 3,070,000 EI Camino/Newport Line Stop Program 60170 Water Capital Fund 301 0 207,787 -207,787 0 0 -207,787 0 0 -207,787 25,000 0 207,787 -207,787 0 0 -207,787 0 0 -207,787 25,000 Water Main Replacement - Simon Ranch Road to Racquet Hill 60171 2013 Water Bond Fund 306 75,000 0 75,000 50,000 125,000 0 0 0 125,000 0 75,000 0 75,000 50,000 125,000 0 0 0 125,000 0 Browning Ave Water Main Replacement - Between Beverly Glen & La Colina 60172 Water Capital Fund 301 0 0 0 300,000 300,000 0 0 0 300,000 0 0 0 0 300,000 300,000 0 0 0 300,000 0 Annual Roadway and Public Infrastructure Maintenance 70001 Gas Tax Fund 130 0 0 0 70001 CityClPFund 200 0 COMPLETE 0 0 0 0 0 0 0 0 0 0 0 0 Annual Roadway and Public Infrastructure Maintenance 70013 Gas Tax Fund 130 1,126,570 6,960 6,960 70013 Measure M Turnback Fund 138 40,000 0 0 70013 CityClPFund 200 1,300,000 COMPLETE 0 0 2,466,570 0 0 0 0 0 0 0 6,960 6,960 24 City of Tustin FY 15/16 CIP Capital Improvement Program by Project - Mid Year Projection 0 18,288,144 -18,288,144 25 0 -18,288,144 0 -18,288,144 14/15 14/15 14/15 15/16 15/16 15/16 15/16 15/16 15/16 15/16 Final Audited Audited New/Addl Adopted Carryover Supplemental Mid -Year Current Year -End JL # Description Fund Budget Expenditures Carryover Request Budget Adjustment Adjustments Adjustments Budget Projection Annual Roadway and Public Infrastructure Maintenance 70014 Gas Tax Fund 130 1,145,000 422,184 722,816 0 300,000 -77,184 0 0 222,816 90,000 70014 Measure M2 Fairshare Fund 139 70,000 53,696 16,304 300,000 510,000 6,304 0 -252,000 264,304 200,000 70014 CityCIPFund 200 1,300,000 24,880 1,275,120 0 1,225,000 -24,880 0 35,630 1,235,750 1,235,750 2,515,000 500,760 2,014,240 300,000 2,035,000 -95,760 0 -216,370 1,722,870 1,525,750 Annual Roadway and Public Infrastructure Maintenance Program 2015-16 (MOE) 70015 Gas Tax Fund 130 0 0 0 200,000 200,000 0 0 0 200,000 50,000 70015 Measure M2 Fairshare Fund 139 0 0 0 70,000 70,000 0 0 252,000 322,000 322,000 70015 City CIP Fund 200 0 0 0 0 0 0 0 570 570 570 0 0 0 270,000 270,000 0 0 252,570 522,570 372,570 SR 55 Ramp -Landscape Improvement 70200 MCAS Land Proceeds Fund 189 0 COMPLETE 0 0 0 0 0 0 0 0 0 0 0 Armstrong Ave Extension: Warner Ave to Barranca Parkway 70201 Sireet Lighting DisNct Fund 142 140,000 137,199 2,801 0 0 2,801 0 -4,442 -1,641 -1,641 70201 MCAS Backbone Fee Fund 187 1,271,000 1,270,879 121 1,000,000 1,000,000 121 0 0 1,000,121 121 70201 MCAS Land Proceeds Fund 189 2,917,000 305,358 2,611,642 0 0 2,611,642 0 -2,500,000 111,642 111,642 70201 City CIP Fund - ovine Ranch Water District - Reimbursement 200 140,000 139,433 567 0 0 567 0 0 567 567 70201 LennarCF006-1 Fund 434 2,160,000 1,715,580 444,420 0 0 444,420 0 -444,420 0 70201 LennarCF006-1 Annex Fund 438 242,000 203,059 38,941 0 0 38,941 0 -35,893 3,048 3,048 70201 RDA -MCAS Tax Allocation Bonds Fund 561 0 0 0 0 0 0 0 54,260 54,260 54,260 6,870,000 3,771,508 3,098,492 1,000,000 1,000,000 3,098,492 0 -2,930,495 1,167,997 167,997 Warner Ave Extension: Red Hill Ave to Armstrong Ave 70202 Measure M2 Fairshare Fund - Competitive Fund 139 4,961,500 3,506,582 1,454,918 0 0 1,454,918 0 0 1,454,918 154,918 70202 Sireet Lighting DisNct Fund 142 201,500 184,962 16,538 0 0 16,538 0 -16,538 0 70202 MCAS Backbone Fee Fund - ovine Co Reimbursement 187 279,000 279,121 -121 0 0 -121 0 -2,692 -2,813 -2,813 70202 MCAS Land Proceeds Fund 189 4,239,000 1,010,451 3,228,549 0 0 3,228,549 0 -3,200,000 28,549 28,549 70202 City CIP Fund - In ine Ranch Water District - Reimbursement 200 351,000 320,879 30,121 0 0 30,121 0 0 30,121 30,121 70202 LennarCF006-1 Fund 434 195,000 719,357 -524,357 0 0 -524,357 0 527,357 3,000 3,000 70202 LennarCFD06-1 Fund -Santa Ana -Tustin Trans Sys Imp Authority(TSIAJ 434 2,791,000 2,576,628 214,372 0 0 214,372 0 -199,990 14,382 14,382 70202 RDA -MCAS Tax Allocation Bonds Fund 561 0 0 0 0 0 0 0 231,387 231,387 231,387 13,018,000 8,597,980 4,420,020 0 0 4,420,020 0 -2,660,476 1,759,544 459,544 Tustin Legacy Development Tasks 70203 MCAS Land Proceeds Fund 189 0 18,288,144 -18,288,144 0 0 -18,288,144 0 0 -18,288,144 0 18,288,144 -18,288,144 25 0 -18,288,144 0 -18,288,144 City of Tustin FY 15/16 CIP Capital Improvement Program by Project - Mid Year Projection Bell Avenue Extension - Red Hill Avenue to Armstrong Avenue 14/15 14/15 14/15 15/16 15/16 15/16 15/16 15/16 15/16 15/16 70221 Lennar CFD06-1 Fund -Santa Ana- Tustin Trans Sys Imp Authonty(TSIA) 434 Final Audited Audited New/Addl Adopted Carryover Supplemental Mid -Year Current Year -End JL # Description Fund Budget Expenditures Carryover Request Budget Adjustment Adjustments Adjustments Budget Projection Barranca Parkway Improvements 438 14,000 0 14,000 0 14,000 0 0 0 14,000 14,000 70205 MCAS Backbone Fee Fund - Irvine Co Reimbursement 187 0 0 0 1,000,000 1,000,000 0 0 0 0 70205 MCAS Land Proceeds Fund 189 1,219,000 12,096 3,001,904 1,000,000 3,964,000 37,904 0 0 0 301,904 70205 City CIP Fund - ovine Ranch Water District - Reimbursement 200 605,000 0 70205 Lennar CFD06-1 Fund 434 3,286,455 COMPLETE 0 18,321 5,110,455 0 0 0 0 0 0 0 0 18,321 Tustin Ranch Road Extension: Valencia to Warner 70206 City CIP Fund - ovine Ranch Water District - Reimbursement 200 0 0 0 70206 Lennar CFD 06-1 Fund 434 0 0 319 70206 Lennar CFD 06-1 Annexation Fund 438 0 COMPLETE 0 - 0 0 0 0 0 0 0 0 0 319 McFadden Rehabilitation - Pasadena -West Citv 70213 Gas Tax Fund 130 0 0 0 70213 Measure M Turnback Fund 138 0 COMPLETE 0 0 0 0 0 0 0 0 0 0 0 0 Irvine Blvd Rehabilitation 70218 Measure M Turnback Fund 138 0 COMPLETE 0 0 0 0 0 0 0 0 0 0 0 0 Bell Avenue Extension - Red Hill Avenue to Armstrong Avenue 70221 Lennar CFD06-1 Fund -Santa Ana- Tustin Trans Sys Imp Authonty(TSIA) 434 1,500,000 12,096 1,487,904 0 1,450,000 37,904 0 0 1,487,904 287,904 70221 City CIP Fund -SOCCCD 200 1,500,000 0 1,500,000 0 1,500,000 0 0 0 1,500,000 0 70221 Lennar CFD 06-1 Annexation Fund 438 14,000 0 14,000 0 14,000 0 0 0 14,000 14,000 70221 RDA -MCAS Tax Allocation Bonds Fund 561 0 0 0 1,000,000 1,000,000 0 0 1,000,000 0 3,014,000 12,096 3,001,904 1,000,000 3,964,000 37,904 0 0 4,001,904 301,904 Area 8, 2C & 213 Grading 70222 MCAS Land Proceeds Fund 189 0 COMPLETE 0 0 IRWD Sewer Line Relocation in Tustin Ranch Road & Barranca Parkway 70223 LennarCF006-1 Fund 434 365,000 COMPLETE 0 0 365,000 0 0 0 0 0 0 0 0 0 26 City of Tustin FY 15/16 CIP Capital Improvement Program by Project - Mid Year Projection 27 14/15 14/15 14/15 15/16 15/16 15/16 15/16 15/16 15/16 15/16 Final Audited Audited New/Addl Adopted Carryover Supplemental Mid -Year Current Year -End JL # Description Fund Budget Expenditures Carryover Request Budget Adjustment Adjustments Adjustments Budget Projection Moffett Drive Extension from Park Avenue to East of Peters Canyon Channel 70224 MCAS Land Proceeds Fund 189 0 0 0 0 0 0 0 271,000 271,000 271,000 70224 City CIP Fund - Irvine Ranch Water District - Reimbursement 200 0 111,900 -111,900 0 0 -111,900 0 862,000 750,100 750,100 70224 Lennar CFD 06-1 Fund 434 800,000 518,307 281,693 0 300,000 -18,307 0 1,048,382 1,330,075 1,330,075 70224 Lennar CFD 06-1 Annexation Fund 438 41,000 0 41,000 0 0 41,000 0 -41,000 0 0 70224 RDA -MCAS Tax Allocation Bonds Fund 561 10,000,000 30,062 9,969,938 6,300,000 16,300,000 -30,062 0 0 16,269,938 5,269,938 10,841,000 660,269 10,180,731 6,300,000 16,600,000 -119,269 0 2,140,382 18,621,113 7,621,113 Park Avenue Extension from Victory Road to Moffett Drive 70225 City CIP Fund - ovine Ranch Water District - Reimbursement 200 0 2,028 -2,028 0 0 -2,028 0 190,000 187,972 187,972 70225 Lennar CFD 06-1 Fund 434 150,000 52,556 97,444 0 0 97,444 0 -97,444 0 0 70225 Lennar CFD 06-1 Annexation Fund 438 13,000 0 13,000 0 0 13,000 0 -13,000 0 0 70225 RDA -MCAS Tax Allocation Bonds Fund 561 2,000,000 3,925 1,996,075 0 2,000,000 -3,925 0 0 1,996,075 1,496,075 2,163,000 58,509 2,104,491 0 2,000,000 104,491 0 79,556 2,184,047 1,684,047 Red Hill Ave Widening between Barranca Parkway and Warner Ave 70226 Lennar CFD 06-1 Fund 434 400,000 100,750 299,250 0 200,000 99,250 0 -289,350 9,900 9,900 70226 RDA -MCAS Tax Allocation Bonds Fund 561 0 0 0 0 0 0 0 200,000 200,000 200,000 400,000 100,750 299,250 0 200,000 99,250 0 -89,350 209,900 209,900 Red Hill Ave Widening between Warner Avenue and Edinger Avenue 70227 Lennar CFD 06-1 Fund 434 0 0 0 200,000 200,000 0 0 -200,000 0 0 70227 RDA -MCAS Tax Allocation Bonds Fund 561 240,000 240,000 100,000 0 0 0 200,000 200,000 0 0 -200,000 0 0 Traffic Calming - Main Street and Bryan Ave 70228 Gas Tax Fund 130 50,000 0 50,000 0 50,000 0 0 0 50,000 0 50,000 0 50,000 0 50,000 0 0 0 50,000 0 Aston Street Extension Between Barranca Parkway and Tusfin Linear Park 70229 MCAS Backbone Fee Fund 187 200,000 0 200,000 2,000,000 2,200,000 0 0 0 2,200,000 100,000 200,000 0 200,000 2,000,000 2,200,000 0 0 0 2,200,000 100,000 Moffett Drive Extension from Armstrong Avenue to Park Avenue 70230 MCAS Land Proceeds Fund 189 0 0 0 0 0 0 175,000 175,000 100,000 0 0 0 0 0 0 175,000 0 175,000 100,000 Kensington Park Drive Extension from Valencia Avenue to future Moffett Drive Extension 70231 MCAS Land Proceeds Fund 189 0 0 0 0 0 0 175,000 0 175,000 100,000 0 0 0 0 0 175,000 0 175,000 100,000 27 City of Tustin FY 15/16 CIP Capital Improvement Program by Project - Mid Year Projection 14/15 14/15 14/15 15/16 15/16 15/16 15/16 15/16 15/16 15/16 Final Audited Audited New/Addl Adopted Carryover Supplemental Mid -Year Current Year -End JL # Description Fund Budget Expenditures Carryover Request Budget Adjustment Adjustments Adjustments Budget Projection Laurelwood Curb Ramp Construction Project 0 0 0 200,000 52,000 0 0 70232 CDBG Fund Year2016 120 0 0 0 80,000 80,000 0 0 0 80,000 80,000 70232 Gas Tax Fund 130 0 0 0 10,000 10,000 0 0 0 10,000 10,000 0 0 0 90,000 90,000 0 0 0 90,000 90,000 Main Street Improvements TBA1 AB 2766 Motor Vehic%RegistrationSubuentionFund 133 0 0 0 98,000 98,000 0 0 0 98,000 98,000 TBA1 Measure M2 Falrshare Fund 139 0 0 0 200,000 200,000 0 0 0 200,000 52,000 0 0 0 298,000 298,000 0 0 0 298,000 150,000 South Hanger Rehabilitation TBA2 WAS Land Proceeds Fund 189 0 0 0 1,000,000 1,000,000 0 0 0 1,000,000 0 0 0 0 1,000,000 1,000,000 0 0 0 1,000,000 0 TOTAL 68,436,068 36,291,620 22,650,360 53,647,000 82,942,472 -9,110,931 350,000 581,084 74,769,585 36,687,404 28