Loading...
HomeMy WebLinkAbout15 MID YEAR BUDGET REV 02-18-03AGENDA REPORT NO. 15 02-18-03 MEETING DATE: FEBRUARY 18, 2003 TO: FROM: SUBJECT: WILLIAM A. HUSTON, CITY MANAGER RONALD A. NAULT, FINANCE DIRECTOR FY 2002-03 MID YEAR BUDGET REVIEW SUMMARY: What follows is a review of the City's first six months of operations under the adopted FY 2002-03 Budget, and projected revenues and expenditures through year end. Although the City might realize a significant shortfall in the Motor Vehicle In Lieu Fee revenue driven by the State's Budget crisis, proactive management actions per City Council direction and the cutting of expenses have balanced the budget for the remainder of the year and the City Council's reserve policy will be met. RECOMMENDATION: Approve the following adjustments to the authorized FY 2002-03 Budget: a, Approve a supplemental appropriation of $400,000 from the Unappropriated Reserve of the Capital Projects Fund for Irvine Blvd. Storm Drain, CIP Project 5024. The increase will cover the construction contract bid price received, construction contingencies, and construction management including testing, inspection and oversight. bo Approve a supplemental appropriation of $160,000 from the Unappropriated Reserve of the Capital Projects Fund for Old Town Streetscape and Pedestrian Enhancement, CIP Project 7172. The increase will cover the cost of additional construction work needed to complete the project. C. Approve a supplemental appropriation of $1,559,500 from the Unappropriated Reserve of the Capital Projects Fund for Edinger Avenue Widening, CIP Project 7147. This is 100% reimbursable from Santa Ana through the OCTA Edinger Smart Street Project. d, Approve a supplemental appropriation of $85,350 from the Unappropriated Reserve of the Capital Projects Fund for Red Hill Widening at I-5 Fwy, CIP 7133. This is 100% Reimbursable Revenue from the developer of the Starbucks Center at the southwest corner of Red Hill Avenue and El Camino Real, to cover traffic mitigation costs. eo Approve a supplemental appropriation of $36,000 from the Projected Unappropriated Reserve of the General Fund for the retainer in connection with general strategic advice and legislative advocacy previously approved by the City Council. Approve a supplemental appropriation of $2.1 million dollars from the Unappropriated Reserve of the General Fund to transfer $1 million dollars to the Liability Fund and $1.1 million to the Capital Projects Fund. DISCUSSION: The attached Mid Year Budget Review follows the same format as the adopted FY 2002-03 budget. Each department has reviewed their areas of responsibility and has provided the projections that are presented in this report. The FY 2002-03 Current Budget column reflects supplemental appropriations approved by the City Council as well as prior period encumbrances carried forward and the current recommendations made by the City Manager that are a result of this review process. The beginning Fund Balances that appear on Page 1 have been adjusted' to reflect audited balances as of 6-30-02. The 6-30-03 General Fund Projected Fund Balance of $7,302,409 is 21% of revised expenses. City policy requires a minimum 15% reserve in the General Fund. The following discussion will focus on the significant changes that have an impact on the various funds of the City. General Fund The ending fund balance at 6-30-02 was $8,264,147 which is $1,950,244 greater than the projected number used for the FY 2002-03 budget preparations, as a result of salary savings and reduced departmental operating expenses. Actual revenues in the General Fund for FY 2001-02 were $959,143 greater than originally estimated. The only significant increase was Motor Vehicle License tax with minor increases in other sources. 2002-03 Revenues Projected General Fund Revenues for the FY 2002-03 are $33,851,569. This is a $101,000 increase from the original budget estimate of $33,750,563. Sales Tax income is projected to be $17.5 million, which is the total budgeted for FY 2002-03. Property tax will increase by 2.9% from our original budget of $5,559,000. All other revenue estimates are projected to be met at year end. There continues to be discussion in Sacramento regarding the distribution of Sales Tax and Property Tax incomes to cities that may result in changes to future allocation methods. Recent legislation on this subject, but limited to Sacramento County, is currently being debated in Sacramento. As proposed legislation becomes more fully developed, staff will prepare recommendations to the City Council that will address the impact on the City. The greatest concern we have is the $34 billion dollar State Budget deficit and the prospect of the cities losing their Motor Vehicle In Lieu Fees. 2002-03 Expenditures Projected General Fund Expenditures of $34,813,307 will be just above the original budget of $34,809,547. This includes the recommended transfers to the Liability and Capital Project Funds. On average, departments are projecting a six percent savings across the board for the current year. We have been within three to five percent of budgeted expenditures for over ten years. The projections contained in this report reflect the City Manager's direction regarding a soft hiring freeze for non safety positions. Salary and benefit savings from every department make up the majority of the projected savings. Vacant positions existed for various periods during the year in Planning, Public Works, Police, and Parks and Recreation Services. The Police Department is projecting the largest department savings of $1.1 million, followed by the Planning Department with $250,000 in savings for the year. Capital Projects Fund The fund balance for the Capital Projects Fund at year-end is projected to be $11,817,430. Construction in Progress for current appropriations is $4,924,849. This amount is what will be spent on capital projects by the end of FY 2002-03. The reserved but undesignated amount is $6,892,581. The undesignated reserve is meant to address future projects detailed in the Seven Year Capital Improvement Plan. Alternative funding resources will need to be secured in order to meet the goals of the plan. The City is also required to meet current Maintenance of Effort expenditures for Measure M Turnback allocations. Community Development Block Grants Projected CDBG revenues for FY 2002-03 are $742,097. The actual figures for 2001-02 were $617,732. The nature of some of ongoing CDBG programs may result in the skewing of expenditures from year to year. Some years will have much greater activity in capital improvements as funds have been accumulated for major projects. Measure M Funds Measure M FUnds include both the annual Turnback Revenues and Competitive Funds. These two funds are projected to have $2.6 million in estimated capital improvement expenditures. Completion of the new Tustin Commuter Rail Station was the major Measure M activity for the past two years. Park Development Fund The Park Development Fund balance at 6-30-03 is projected to be $5,138,039. The major park projects budgeted for this year are the Pioneer Road Park, the Columbus Tustin fields improvements, and the Skateboard Park. Water Enterprise The projected Water Enterprise Operating Fund balance of $2,090,864 is within the City Council's policy of six months operating expense reserves. Water Capital Improvements have focused on improvements to the distribution system with several projects currently underway at the Main Street site. The projected Capital Projects Fund reserves of $6,627,513 million will provide sufficient resources to the Enterprise Fund to complete several major projects in the Water Capital Improvement Plan. The Main Street Reservoir improvements are scheduled for completion in the spring of 2003. The Enterprise Fund has adequate operating reserves and its capital reserves are sufficient to complete the Main Street Reservoir project and other projects as presented in the current budget. Staff will conduct a complete review of water rates and financing options during the FY 2002-03 budget year and will bring recommendations to the City Council fall/winter of FY 2003-04. Risk Management Fund The City is a member of the California Insurance Pool Authority, a risk sharing pool made up of twelve Orange County cities. The Authority has established a minimum liability reserve policy of three times each city's self-insured retention ($750,000 for Tustin). This policy was established based on actuarial analysis, underwriter input and fiscal modeling. The Risk Management Fund as represented in this report is a summary of the Liability, Workers' Compensation and Unemployment Funds. 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 $300,000 of each Workers' Compensation claim. The City is fully self-insured for all unemployment claims. While the Workers' Compensation and Unemployment Funds have generally carried adequate reserves, the City's Liability Fund has required additional transfers over the past years to maintain sufficient reserves. To meet reserve requirements, the recommendations include a $1,900,000 transfer from the General Fund to the Liability Fund. Conclusion The overall financial condition of the City is currently healthy given the constraints and future uncertainties faced by the City. Reserve policies for the General and Water Enterprise Funds are being met. We are very aware of the current economic conditions which have significantly impacted the City's sales tax income. We are also monitoring the State budget process, as we fully expect that there will be some impact on cities. At this time we do not know exactly what and how much. We are recommending that all excess reserves be maintained in the General Fund to be considered available to help balance the 2003-04 and 2004-05 budgets, as we are looking forward to the potential of further reductions in local government revenue mandated by the State. While many economists are suggesting that we may have begun the recovery phase of the recession, we have to take into consideration the loss of key sales tax producers that are leaving the City. At this time staff is optimistic that we can present a balanced budget to the City Council through the use of available resources and proper management of reserves through the budget process. These issues will be considered as we prepare the FY2003-04 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 a negative impact on the City's financial condition in the future. R Finance Director Kei~-'~D. Neves -- , _ _ Senior Management Analyst Attachment BUDG&CAFR:MidYearReviewStaffReportFebruary2003.doc City of Tustin Mid-Year Budget Review Fiscal Year 02-03 February 18, 2003 Prepared by the Finance Department City of Tustin City Council Tracy Wills Wodey, Mayor Tony Kawashima, Mayor Pro Tem Jeffery M. Thomas, Councilmember Lou Bone, Councilmember Doug Davert, Councilmember George W. Jeffries, City Treasurer Pamela Stoker, City Clerk Lois E. Jeffrey, City Attorney Management Staff William A. Huston, City Mana9er Christine A. Shingleton, Assistant City Manager Elizabeth A. Binsack, Director of Community Development Steve Foster, Chief of Police Adene Marks, Director of Human Resources Ronald A. Nault, Director of Finance Patrick Sanchez, Director of Parks and Recreation Services Tim D. Sedet, Director of Public Works/City Engineer Table of Contents Fund Balance Projections Page 1 Revenue Summaries 2-3 Expenditure Summaries Department Expenses Legislation Administration Community Development Public Works Police/Fire Parks & Recreation Non-Departmental/Total Funds 02 Thru 16 Tustin Legacy Enterprise CDBG Redevelopment Agency Water Services Other 5 6 7 8 9 10 11 12-14 14 15-17 17-21 21-23 24-25 CIP Summary by Project 26-35 City of Tustin FY 02-03 Mid Year Budget Review 00/01 01/02 01/02 01/02 02/03 02~03 02/03 Actual Bal Actual Actual Actual Bal Projected Projected Proj Bal Fund Description 06/30/01 Revenues Expenditure 06/30/02 Revenues Expenditure 06~30~03 01 General Fund 7,201,700 33,937,709 32,875,262 8,264,147 33,851,569 34,813,307 7,302,409 02 Capital Projects Fund--tiP 12,406,405 2,376,652 2,880,524 11,902,533 3,792,587 3,877,690 11,817,430 03 SCAQMD 712,913 116,789 573,500 256,202 75,000 115,000 216,202 04 Asset Forfeiture 5,482 13,822 260 19,044 10,500 0 29,544 05 Public Safety Augmentation 108,768 237,599 346,655 (289) 200,700 200,000 411 08 Measure M-Competitive (2,578,269) 3,419,008 1,716,099 (875,360) 1,729,902 1,729,902 (875,360) 09 Measure M Turnback 2,483,951 1,047,601 659,236 2,872,317 769,000 753,693 2,887,624 10 Gas Tax 4,744,738 1,655,482 3,808,979 2,591,242 1,510,037 1,336,146 2,765,133 11 Park Development 5,871,373 365,175 108,291 6,128,257 133,825 1,124,043 5,138,039 16 Supplemental Law Enforcement 8,864 233,324 221,382 20,806 214,887 156,517 79,176 17 Tustin Legacy Enterprise 0 432,787 679,175 (246,388) 0 2,484,495 (2,730,883) 2x CDBG 0 617,732 617,732 0 742,097 742,097 0 30 95-1 Construction 4,088,238 111,333 0 4,199,571 75,000 5,000 4,269,571 41 Tustin LLD 277,870 437,968 447,991 267,847 430,000 499,000 198,847 42 Tustin SLD 2,821,360 514,625 1,098,624 2,237,361 500,000 545,516 2,191,845 51 South Central Debt Svs 6,041,591 2,517,537 298,224 8,260,904 2,370,500 202,000 10,429,404 52 South Central RDA 9,466,654 556,046 602,869 9,419,832 256,000 857,571 8,818,261 53 South Central Set Aside 3,981,949 916,672 73,422 4,825,198 686,800 501,591 5,010,407 54 Marine Base Debt Service (142,105) 0 103,244 (245,349) 0 3,051 (248,400) 55 Marine Base RDA (394,743) 33,227 367,043 (728,559) 0 162,677 (891,236) 56 Marine Base Set Aside (147) 0 (147) 0 0 0 0 57 Town Center Debt Service 4,523,123 2,608,386 2,101,015 5,030,494 2,477,500 2,012,450 5,495,544 56 Town Center RDA 2,363,021 53,691 622,964 1,793,747 17,000 244,965 1,565,782 59 Town Center Set Aside 2,544,708 896,049 24,878 3,415,879 670,000 103,838 3,982,041 70 Water Utility Fund 3,047,543 8,388,701 10,254,621 1,181,623 9,410,402 8,501,161 2,090,864 73 Water CIP 12,586,615 1,519,273 5,911,299 8,194,589 900,000 2,467,076 6,627,513 81 Workers Compensation 1,091,081 614,201 565,251 1,140,031 563,000 492,522 1,210,509 82 Liability 1,053,104 1,583,292 2,603,738 32,658 2,142,000 811,828 1,362,830 83 Unemployment 340,485 0 10,884 329,601 0 5,000 324,601 84 Replacement Fund 2,554,988 589,312 526,849 2,617,451 705,887 987,541 2,335,797 TOTAL ALL FUNDS 87,211,261 65,793,992 70,099,865 82,905,388 64,234,193 65,735,677 81,403,904 Projected GF Year-End Fund Balance is 15% of Current Budgeted GF Expenditure is GF Fund Balance is Over(Under) by 7,302,409 5,536,432 1,765,977 Fund Balance 1 Revenue Summary (By Fund) City of Tustin FY O2-O3 Mid Year Budget Review 00/01 01/02 02/03 Actual Actual Cur Bud Year-End Year-End Year-End Projection Variance Percent 01 General Fund 02 Capital Projects Fund--ClP 03 $CAQMD 04 Asset Forfeiture 05 Public Safety Augmentation 08 Measure M-Competitive 09 Measure M Turnback 10 Gas Tax 11 Park Development 16 Supplemental Law Enforcement 17 Tustin Legacy Enterprise 2x CDBG 30 95-1 Construction 41 Tustin LLD 42 Tustin SLD 51 South Central Debt Svs 52 South Central RDA 53 South Central Set Aside 54 Marine Base Debt Service 55 Marine Base RDA 56 Marine Base Set Aside 57 Town Center Debt Service 58 Town Center RDA 59 Town Center Set Aside 70 Water Utility Fund 73 Water ClP 81 Workers Compensation 82 Liability 83 Unemployment 84 Replacement Fund TOTAL ALL FUNDS 36,124,036 5,188,518 122,441 12,322 249,126 0 1,399,471 2,051,074 1,932,464 259,993 168,683 649,677 137,471 408,744 491,823 2,139,959 703,334 724,553 0 102,199 0 2,448,731 138,262 875,103 9,253,484 1,877,428 895,949 979,453 0 519,691 33,937,709 2,376,652 116,789 13,822 237,599 3,419,008 1,047,601 1,655,482 365,175 233,324 432,787 617,732 111333 437 968 514 625 2,517,537 556,046 916,672 0 33,227 0 2,608,386 53,691 896,049 8,388,701 1,519,273 614,201 1,583,292 0 589,312 69,853,988 65,793,992 33,750,563 7,093,198 70,000 10,500 202,500 8,630,416 1,020,986 2,695,037 1,054,500 3,700 7,000 1,779,232 75,000 430,000 500,000 2,370,500 2,343,542 786,800 0 0 0 2,557,500 50,000 730,000 9,507,500 883,885 638,643 2,162,000 0 705,887 80,058,889 33,851,569 101,006 100.3% 3,792,587 (3,300,611) 53.5% 75,000 5,000 107.1% 10,500 0 100.0% 200,700 (1,800) 99.1% 1,729,902 (6,900,514) 20.0% 769,000 (251,986) 75.3% 1,510,037 (1,185,000) 56.0% 133,825 (920,675) 12.7% 214,887 211,187 5807.8% 0 (7,000) 0.0% 742,097 (1,037,135) 41.7% 75,000 0 100.0% 430,000 0 100.0% 500,000 0 100.0% 2,370,500 0 100.0% 256,000 (2,087,542) 10.9% 686,800 (100,000) 87.3% 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! 2,477,500 (80,000) 96.9% 17,000 (33,000) 34.0% 670,000 (60,000) 91.8% 9,410,402 (97,098) 99.0% 900,000 16,115 101.8% 563,000 (75,643) 88.2% 2,142,000 (20,000) 99.1% 0 0 #DIV/O! 705,887 0 100.0% 64,234,193 (15,824,696) 80.2°,4 Revenue Summaries 2 Revenue Summary (By Fund) 01 General Fund Property Taxes Franchise Fees Sales and Use Tax Transient Occupancy Tax Business License Fees Real Property Transfer Tax New Construction Tax Building Permits-E. Tustin Plan Check Fees-E. Tustin New Construction Tax-E. Tustin Licenses and Permits Fines and Forfeitures Interest Income Use of property Motor Vehicle In-Lieu Fees Revenue from Other Agencies State Grants County Grants Federal Grants Sports Fees Class Fees Other Recreation Fees Current Service Charges Transfers In from Other Funds All Other Sources 01 General Fund Total City of Tustin FY 02-03 Mid Year Budget Review 00/01 01/02 02/03 Actual Actual Cur Bud 5,067,523 5,285,912 1,274,353 1,391,112 18,676,090 15,550,563 154,259 144,186 268,579 273,490 288,801 356,878 8,177 8,012 440,554 220,687 260,113 98,495 33,121 15,400 455,271 387,975 715,589 780,929 402,321 90,885 66,928 68,021 3,593,237 3,856,888 281,127 342,241 130,288 105,435 40,910 104,012 0 14,839 291,469 301,888 280,815 359,759 147,743 166,948 199,476 166,710 2,277,321 3,473,567 769,972 372,876 36,124,036 33,937,709 5,559,000 1,297,500 17,500,000 145 000 260 000 300 000 52 500 20 000 10 000 2 000 275 200 577 500 210 000 56 801 3,749,668 253,500 0 35,000 0 329,385 335,000 147,288 163,000 2,334,221 138,000 33,750,563 Year-End Year-End Year-End Projection Variance Percent 5,7t8,500 159,500 102.9% 1,331,500 34,000 102.6% 17,500,000 0 100.0% 145,000 0 100.0% 260,000 0 100.0% 360,000 60,000 120.0% 54,000 1,500 102.9% 23,000 3,000 115.0% 16,000 6,000 160.0% 2,000 0 100.0% 279,500 4,300 101.6% 595,000 17,500 103.0% 75,000 (135,000) 35.7% 60,301 3,500 106.2% 3,800,000 50,332 101.3% 86,500 (167,000) 34.1% 46,225 46,225 #DIV/O! 35,000 0 100.0% 0 0 #DIV/OI 323,885 (5,500) 98.3% 345,000 10,000 103.0% 124,798 (22,490) 84.7% 111,615 (51,385) 68.5% 2,324,221 (10,000) 99.6% 234,524 96,524 169.9% 33,851,569 101,006 100.3% Revenue Summaries 3 Expenditure Summary (By Fund) 01 General Fund Legislation Administration Community Development Public Works Police Services Fire Services Parks and Recreation Non-Departmental, Other 01 General Fund 02 Capital Projects Fund--ClP 03 SCAQMD 04 Asset Forfeiture 05 Public Safety Augmentation 08 Measure M-Competitive 09 Measure M Turnback 10 Gas Tax 11 Park Development 16 Supplemental Law Enforcement 17 Tustin Legacy Enterprise 2x CDBG 30 95.1 Construction 41 Tustin LLD 42 Tustin SLD 51 South Central Debt Svs 52 South Central RDA 53 South Central Set Aside 54 Marine Base Debt Service 55 Marine Base RDA 56 Marine Base Set Aside 57 Town Center Debt Service 58 Town Center RDA 59 Town Center Set Aside 70 Water Fund 73 Water ClP 81 Workers Compensation 82 Liability 83 Unemployment 84 Replacement Fund TOTAL ALLFUNDS City of Tustin FY 02-03 Mid Year Budget Review 00/01 01/02 02/03 Actual Actual Cur Bud 709,638 2,441,401 1,584,596 5,873,118 13,039,338 3,852,783 2,036,616 6,260,304 35,797,794 2,426,162 682 31,869 244 907 2,531 481 530 475 714 881 48 097 251 129 168 683 644 030 0 430,132 212,659 226,718 404,726 181,247 88,425 294,763 147 1,996,611 181,006 62,098 8,450,250 1,167,288 352,676 1,004,143 10,462 451,315 802,111 821,775 2,587,895 2,773,743 1,586,672 2,069,632 6,251,436 7,128,285 13,087,006 13,902,372 3,987,630 4,127,197 2,176,669 2,327,342 2,395,843 3,759,200 32,875,262 36,909,546 2,880,524 9,304,317 573,500 0 260 0 346,655 200,000 1,716,099 8,638,336 659,236 3,795,147 3,808,979 4,860,249 108,291 4,584,171 221,382 108,858 679,175 2,275,937 617,732 657,310 0 100,000 447,991 502,100 1,098,624 268,916 298,224 202,000 602,869 9,469,435 73,422 651,273 103,244 0 367,043 205,142 (147) 0 2,101,015 2,008,450 622,964 313,274 24,878 225,913 10,254,621 8,957,768 5,911,299 8,462,488 565,251 383,178 2,603,738 788,400 10,884 5,000 526,849 983,421 58,904,857 70,099,865 104,860,629 Year-End Year-End Year-End Projection Variance Percent 818,951 2,824 99.7% 2,616,458 157,285 94.3% 1,667,567 402,065 80.6% 7,019,103 109,182 98.5% 12,434,239 1,468,133 89.4% 4,127,197 0 100.0% 2,225,494 101,848 95.6% 3,904,298 (145,098) 103.9% 34,813,307 2,096,239 94.3% 3,877,690 5,426,627 41.7% 115,000 (115,000) #DIV/O! 0 0 #DIV/O! 200,000 0 100.0% 1,729,902 6,908,434 20.0% 753,693 3,041,454 19.9% 1,336,146 3,524,103 27.5% 1,124,043 3,460,128 24.5% 156,517 (47,659) 143.8% 2,484,495 (208,558) 109.2% 742,097 (84,787) 112.9°/o 5,000 95,000 5.0% 499,000 3,100 99.4% 545,516 (276,600) 202.9% 202,000 0 100.0% 857,571 8,611,864 9.1% 501,591 149,682 77.0% 3,051 (3,051) #DIV/0! 162,877 42,465 79.3% 0 0 #DIV/0! 2,012,450 (4,000) 100.2% 244,965 68,309 78.2% 103,838 122,075 46.0% 8,501,161 456,607 94.9% 2,467,076 5,995,412 29.2% 492,522 (109,344) 128.5% 811,828 (23,428) 103.0% 5,000 0 100.0% 987,541 (4,120) 100.4% 65,735,677 39,124,952 62.7% Expenditure Summaries 4 Expenditure Summary (By Fund) City of Tustin FY 02-03 Mid Year Budget Review 00/01 01/02 02/03 Actual Actual Cur Bud Year-End Year-End Year-End Projection Variance Percent Legislation 01-101 Thru 01-103 City Council Personnel Operations Capital 01.101 City Clerk Personnel Operations Capital 01.102 City Attorney Personnel Operations Capital 01.103 TOTAL Personnel Operations Capital Legislation Total: 78,251 94,982 81,196 33,163 29,039 43,660 0 0 0 111,414 124,021 124,856 260,544 287,979 294,559 56,644 45,537 72,950 11,813 45,664 24,000 329,000 379,180 391,509 0 0 0 269,224 298,909 305,410 0 0 0 269,224 298,909 305,410 338,794 382,961 375,755 359,031 373,486 422,020 11,813 45,664 24,000 709,638 802,111 821,775 81,196 0 100.0% 33,960 9,700 77.8% 0 0 #DIV/0! 115,156 9,700 92.2% 294,395 164 99.9% 79,990 (7,040) 109.7% 24,000 0 100.0% 398,385 (6,876) 101.8% 0 0 #DIV/0! 305,410 0 100.0% 0 0 #DIV/0I 305,410 0 100.0% 375,591 164 100.0% 419,360 2,660 99.4% 24,000 0 100.0% 818,951 2,824 99.7% Expenditure Summaries 5 Expenditure Summary (By Fund) City of Tustin FY 02-03 Mid Year Budget Review 00/01 01/02 02/03 Actual Actual Cur Bud Year-End Year-End Year-End Projection Variance Percent Administration 01-201 Thru 01.204 city Manager Personnel Operations Capital 01.201 Finance Personnel Operations Capital 01-202 Human Resources Personnel Operations Capital 01.203 Information Technology Personnel Operations Capital 01.204 TOTAL Personnel Operations Capital Administration Total: 383,337 429,164 486,619 50,880 30,412 50,412 3,286 6,826 0 437,502 466,403 537,031 593,246 642,508 649,713 390,141 239,641 293,800 16,483 20,000 0 999,870 902,150 943,513 376,231 395,576 422,759 142,740 132,588 193,000 420 5,231 0 519,391 533,396 615,759 167,808 316,741 395,690 126,944 136,607 127,850 189,885 232,599 153,900 484,637 685,947 677,440 1,520,622 1,783,990 1,954,781 710,706 539,249 665,062 210,073 264,656 153,900 2,441,401 2,587,895 2,773,743 486,619 0 100.0% 35,412 15,000 70.2% 252 (252) #DIV/0! 522,283 14,748 97.3% 649,713 0 100.0% 192,300 101,500 65.5% 0 0 #DIV/0! 842,013 101,500 89.2% 422,759 0 100.0% 161,213 31,787 83.5% 0 0 #DIV/0! 583,972 31,787 94.8% 395,690 0 100.0% 118,600 9,250 92.8% 153,900 0 100.0% 668,190 9,250 98.6% 1,954,781 0 100.0% 507,525 157,537 76.3% 154,152 (252) 100.2% 2,616,458 157,285 94.3% Expenditure Summaries 6 Expenditure Summary (By Fund) City of Tustin FY O2-O3 Mid Year Budget Review 00/01 01/02 02/03 Actual Actual Cur Bud Year-End Year-End Year-End Projection Variance Percent Community Development 01.301 Thru 01.302 Planning Personnel Operations Capital 01.301 895,101 859,620 810,914 88,768 79,983 130,606 24,989 0 15,327 1,008,858 939,603 Building Personnel Operations Capital 01-302 956,847 468,598 515,895 865,859 103,701 129,689 226,426 3,439 1,485 20,500 575,738 647,069 1,112,785 635,664 175,250 78.4% 76,066 54,540 58.2% 0 15,327 O.0% 711,730 245,117 74.4% 796,411 69,448 92.0% 158,426 68,000 70.0% 1,000 19,500 4.9% 955,837 156,948 85.9% TOTAL Personnel Operations Capital Community Development Total: 1,363,699 1,375,515 192,469 209,671 28,428 1,485 1,584,596 1,586,672 1,676,773 1,432,075 244,698 85.4% 357,032 234,492 122,540 65.7% 35,827 1,000 34,827 2.8% 2,069,632 1,667,567 402,065 80.6% Expenditure Summaries 7 Expenditure Summary (By Fund) City of Tustin FY O2-03 Mid Year Budget Review 00/01 01/02 02/03 Actual Actual Cur Bud Year-End Year-End Year-End Projection Variance Percent Public Works 01-401 Thru 01-410 Administration Personnel Operations Capital 01.401 Engineering Personnel Operations Capital 01.402 Streets Personnel Operations Capital 01.403 Landscape Personnel Operations Capital 01-404 Vehicles Personnel Operations Capital 01.406 Facilities Personnel Operations Capital 01.407 Emergency Services Personnel Operations Capital 01.410 TOTAL Personnel Operations Capital Public Works Total: 275,438 291,082 302,746 155,472 189,265 157,680 0 9,222 0 430,910 489,568 460,426 705,538 746,958 883,834 1,104,689 1,225,173 1,513,175 0 217 0 1,810,228 1,972,349 2,397,009 388,252 381,039 508,211 269,572 155,052 207,734 27,422 9,117 8,100 685,247 545,208 724,045 790,840 870,613 937,403 763,050 805,943 932,689 21,601 80,471 85,500 1,575,491 1,757,027 1,955,592 339,504 342,074 361,314 233,084 223,156 286,723 25,415 4,415 5,000 598,003 569,645 653,037 132,894 148,763 133,029 577,910 709,724 739,144 3,113 0 0 713,916 858,486 872,173 48,034 49,751 51,253 11,288 9,401 14,750 0 0 0 59,322 59,152 66,003 2,680,584 2,830,363 3,177,872 3,115,146 3,317,795 3,851,977 77,634 103,524 98,682 302,746 0 100.0% 144,710 12,970 91.8% 0 0 #DIV/0! 447,456 12,970 97.2% 813,451 70,383 92.0% 1,458,788 54,387 96.4% 0 0 #DIV/0! 2,272,239 124,770 94.8% 508,211 0 100.0% 200,724 7,010 96.6% 8,100 0 100.0% 717,035 7,010 99.0% 958,403 (21,000) 102.2% 909,639 23,050 97.5% 85,500 0 100.0% 1,953,542 2,050 99.9% 361,314 0 100.0% 294,797 (8,074) 102.8% 4,500 500 90.0% 660,611 (7,574) 101.2% 134,490 (1,461) 101.1% 771,391 (32,247) 104.4% 0 0 #DIV/0I 905,881 (33,708) 103.9% 51,253 0 100.0% 11,086 3,664 75.2% 0 0 #DIV/0I 62,339 3,664 94.4% 3,129,868 48,004 98.5% 3,791,135 60,842 98.4% 98,100 582 99.4% 5,873,118 6,251,436 7,128,285 7,019,103 109,182 98.5% Expenditure Summaries 8 Expenditure Summary (By Fund) City of Tustin FY O2-03 Mid Year Budget Review 00/01 01/02 02/03 Actual Actual Cur Bud Year-End Year-End Year-End Projection Variance Percent Police 01.501 Thru 01-504 Administration Personnel Operations Capital 01-501 Patrol Personnel Operations Capital 01-502 Investigative Services Personnel Operations Capital 01-503 Administrative Services Personnel Operations Capital 01-504 530,019 546,907 585,543 45,473 41,932 71,668 19,000 0 0 594,492 588,839 657,211 6,453,704 6,127,760 5,821,996 642,966 593,416 664,483 87,118 182,454 31,230 7,183,788 6,903,631 6,517,709 1,533,964 1,927,992 3,189,332 601,741 695,275 715,425 8,418 31,193 0 2,144,123 2,654,460 3,904,757 2,726,054 2,551,352 2,375,014 331,596 388,724 447,681 59,285 0 0 3,116,934 2,940,076 2,822,695 469,387 116,156 80.2% 62,473 9,195 87.2% 0 0 #DIV/O! 531,860 125,351 80.9% 5,590,432 231,564 96.0% 563,744 100,739 84.8% 31,230 0 100.0% 6,185,406 332,303 94.9% 2,511,865 677,467 78.8% 550,576 164,849 77.0% 0 0 #DIV/0! 3,062,441 842,316 78.4% 2,278,431 96,583 95.9% 376,101 71,580 84.0% 0 0 #DIV/0I 2,654,532 168,163 94.0% TOTAL Personnel 11,243,741 11,154,012 11,971,885 10,850,115 1,121,770 90.6% Operations 1,621,776 1,719,347 1,899,257 1,552,894 346,363 81.8% Capital 173,820 213,647 31,230 31,230 0 100.0% Police Department Total: 13,039,338 13,087,006 13,902,372 12,434,239 1,468,133 89,4% Fire Services 01.550 Personnel Operations Capital Fire Services Total: 0 0 0 3,852,783 3,987,630 4,127,197 0 0 0 3,852,783 3,987,630 4,127,197 0 0 #DIV/0! 4,127,197 0 100.0% 0 0 #DIV/0! 4,127,197 0 100.0% Expenditure Summaries 9 Expenditure Summary (By Fund) City of Tustin FY 02-O3 Mid Year Budget Review 00/01 01/02 02/03 Actual Actual Cur Bud Year-End Year-End Year-End Projection Variance Percent Parks & Recreation Services 01.701 Thru 01-707 Administration Personnel Operations Capital 01.701 271,073 277,707 288,093 49,691 45,832 58,698 15,834 3,980 4,000 336,598 327,518 Sports Personnel Operations Capital 01-702 350,791 326,237 383,844 417,905 211,095 212,740 268,729 2,002 7,450 6,940 Classes/Cultural Services Personnel Operations Capital 01-703 539,334 604,034 693,574 Senior Citizens Personnel Operations Capital 01.705 156,133 122,046 135,051 238,079 279,668 274,409 3,256 0 38,835 397,469 401,715 Support Services Personnel Operations Capital 01-706 448,295 163,831 178,538 207,328 151,389 175,028 115,528 636 0 0 Tustin Youth Center Personnel Operations Capital 01.707 315,856 353,565 224,212 232,419 6,786 6,468 12,445 2,778 TOTAL Personnel Operations Capital Parks & Recreation Total: 243,444 241,665 322,856 260,868 8,413 4,0OO 273,281 117,793 151,335 141,851 85,762 96,040 94,494 362 796 2,200 203,917 248,171 1,259,278 1,345,890 742,802 815,776 34,536 15,004 2,036,616 2,176,669 238,545 1,451,096 820,271 55,975 277,219 10,874 96.2% 58,198 500 99.1% 4,000 0 100.0% 339,417 11,374 96.8% 407,138 10,767 97.4% 268,729 0 100.0% 6,940 0 100.0% 682,807 10,767 98.4% 132,649 2,402 98.2% 282,862 (8,453) 103.1% 38,835 0 100.0% 454,346 (6,051) 101.3% 123,135 84,193 59.4% 113,187 2,341 98.0% 0 0 #DIV/0! 236,322 86,534 73.2% 260,874 (6) 100.0% 8,413 0 100.0% 4,000 0 100.0% 273,287 (6) 100.0% 142,621 (770) 100.5% 94,494 0 100.0% 2,200 0 100.0% 239,315 (770) 100.3% 1,343,636 107,460 92.6% 825,883 (5,612) 100.7% 55,975 0 100.0% 2,327,342 2,225,494 101,848 95.6% Expenditure Summaries 10 Expenditure Summary (By Fund) City of Tustin FY 02-03 Mid Year Budget Review 00/01 01/02 02/03 Actual Actual Cur Bud Year-End Year-End Year-End Projection Variance Percent Non-Departmental 01-801 Personnel Operations Capital Non. Departmental Total: Personnel Operations Capital TOTAL Personnel Operations Capital 01 General Fund Total: 50,741 67,972 70,000 70,000 6,167,527 2,188,373 3,689,200 3,778,881 456 140,242 0 55,417 6,218,725 2,396,586 3,759,200 3,904,298 (1,374) (743) 0 0 42,954 0 0 0 0 0 0 0 18,456,086 18,939,959 20,678,162 19,156,066 16,805,195 13,151,326 15,832,016 15,237,367 536,760 784,222 399,614 419,874 35,797,794 32,875,262 36,909,546 34,813,307 0 100.0% (89,681) 102.4% (55,417) #DIV/O! (145,098) 103.9°/, 0 #DIV/O! 0 #DIV/O! 0 #DIV/O! 1,522,096 594,649 (20,260) 2,096,239 92.6% 96.2% 105.1% 94.3% Expenditure Summaries 11 Expenditure Summary (By Fund) City of Tustin FY O2-O3 Mid Year Budget Review 00/01 01/02 02/03 Actual Actual Cur Bud Capital Improvement Projects 02-801 Thru 02-999 ClP Non. Departmental Personnel Operations Capital 02-801 0 0 344,908 343,436 0 0 344,908 343,436 Year-End Year-End Year-End Projection Vadance Percent 0 0 #DIV/0! 348,223 (348,223) #DIV/0! 0 0 #DIV/0! 348,223 (348,223) #DIV/0! ClP, ClP Personnel Operations Capital 02-999 TOTAL Personnel Operations Capital 02 CIP Total: 0 0 118,731 305,040 1,962,524 2,232,049 2,081,255 2,537,089 0 0 463,638 648,476 1,962,524 2,232,049 2,426,162 2,880,524 0 0 9,304,317 9,304,317 0 0 9,304,317 9,304,317 0 0 #DIV/0! 0 0 #DIV/0! 3,529,467 5,774,850 37.9% 3,529,467 5,774,850 37.9% 0 0 #DIV/0! 348,223 (348,223) #DIV/0! 3,529,467 5,774,850 37.9% 3,877,690 5,426,627 41.7% SCAQMD 03-999 SCAQMD, Non. Departmental Personnel Operations Capital 03.801 0 0 0 573,500 0 0 0 573,500 0 0 #DIV/0! 0 0 #DIV/0! 0 0 #DIV/0! 0 0 #DIV/0! SCAQMD, ClP Personnel Operations Capital 03-999 TOTAL Personnel Operations Capital 03 SCAQMD Total: Asset Forfeit, Non-Dept 04-801 TOTAL Personnel Operations Capital 04 Asset Forfeit Total: 0 0 0 0 682 0 0 0 0 0 0 115,000 682 0 0 115,000 0 0 682 573,500 0 0 682 573,500 0 0 0 0 0 0 31,869 26O 0 31,869 260 0 #DIV/O! 0 #DIV/O! (115,000) #DIV/0! (115,000) #DIV/0! 0 0 115,000 115,000 0 #DIV/O! 0 #DIV/O! (115,000) #DIV/0! (115,000) #OiV/0~ 0 0 #DIV/0! 0 0 #DIV/0! 0 0 #DIV/0! 0 0 #DlVl0! Expenditure Summaries 12 Expenditure Summary (By Fund) Public Safety, Non-Dept 05.801 TOTAL Personnel Operations Capital 05 Publ Safety Fund Total: Measure M-Comp, CIP 08-999 TOTAL Personnel Operations Capital 08 Meas M-C Total: City of Tustin FY O2-O3 Mid Year Budget Review 00/01 01102 02~03 Actual Actual Cur Bud 0 0 0 244,907 346,655 200,000 0 0 0 244,907 346,655 200,000 0 14,331 0 0 2,517,150 1,716,099 8,638,336 2,531,481 1,716,099 8,638,336 Year-End Year-End Year-End Projection Variance Percent 0 0 #DIV/0! 200,000 0 100.0% 0 0 #DIV/0! 200,000 0 100.0% 0 0 #DIV/0! 0 0 #DIV/0! 1,729,902 6,908,434 20.0% 1,729,902 6,908,434 20.0% Measure M-T, ClP 09-801 Thru 09-999 Meas M-T, Non-Dept Personnel Operations Capital 09-801 0 0 0 13,400 50,000 50,000 0 0 0 13,400 50,000 50,000 0 0 #DIV/0! 50,000 0 100.0% 0 0 #DIV/0! 50,000 0 100.0% Meas M-T, ClP Personnel Operations Capital 09.999 TOTAL Personnel Operations Capital 09 Meas M-T Total: 0 156,007 34,479 0 361,068 574,757 3,745,147 517,075 609,236 3,745,147 0 0 0 169,407 84,479 50,000 361,068 574,757 3,745,147 530,475 659,236 3,795,147 0 0 #DIV/0! 0 0 #DIV/0! 703,693 3,041,454 18.8% 703,693 3,041,454 18.8% 0 0 #DIV/0! 50,000 0 100.0% 703,693 3,041,454 18.8% 753,693 3,041,454 19.9% Gas Tax, ClP 10-801 Thru 10-999 Gas Tax, Non. Dept Personnel Operations Capital 10.801 0 0 0 562,719 572,921 550,363 0 562,719 572,921 550,363 0 0 #DIV/0! 0 550,363 0.0% 0 0 #DIV/0! 0 550,363 0.0% Gas Tax, ClP Personnel Operations Capital 10-999 0 0 0 144,467 93,631 0 7,695 3,142,426 4,309,886 152,162 3,236,057 4,309,886 0 0 #DIV/0! 0 0 #DIV/0! 1,336,146 2,973,740 31.0% 1,336,146 2,973,740 31.0% Expenditure Summaries 13 Expenditure Summary (By Fund) TOTAL Personnel Operations Capital 10 Gas Tax Total: City of Tustin FY 02-03 Mid Year Budget Review 00/01 01/02 02/03 Actual Actual Cur Bud 0 0 0 707,186 666,553 550,363 7,695 3,142,426 4,309,886 714,881 3,808,979 4,860,249 Year-End Year-End Year-End Projection Variance Percent 0 0 #DIV/0I 0 550,363 0.0% 1,336,146 2,973,740 31.0% 1,336,146 3,524,103 27.5% Park Development, ClP 11-999 TOTAL Personnel Operations Capital 11 Park Dev Total: 0 0 0 0 0 0 48,097 108,291 4,584,171 48,097 108,291 4,584,171 0 0 #DIV/0I 0 0 #DIV/0I 1,124,043 3,460,128 24.5% 1,124,043 3,460,128 24.5% Suppl Law Enforcement, CIP 16.502 Thru 16-999 TOTAL Personnel Operations Capital 16 Suppl Law Total: 0 0 0 148,189 160,832 108,858 102,940 60,550 0 251,129 221,382 108,858 Tustin Legacy Enterprise, ClP 17.801 Thru 17-999 Tustin Legacy, Non-Dept Personnel Operations Capital 17.801 0 0 168,683 106,843 0 0 168,683 106,843 0 0 #DIV/0! 137,294 (28,436) 126.1% 19,223 (19,223) #DIV/0! 156,517 (47,659) 143.8% 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! Tustin Legacy, Non-Dept Personnel Opemtions Capital 17.805 0 3,055 0 0 569,276 0 0 0 0 572,331 0 2,275,937 0 2,275,937 120,000 (120,000) #DIV/O! 2,364,495 (88,558) 103.9% 0 0 #DIV/0! 2,484,495 (208,558) 109.2% Tustin Legacy, ClP Personnel Operations Capital 17-999 TOTAL Personnel Operations Capital 0 0 0 0 0 0 0 0 0 0 0 0 0 3,055 0 168,683 676,120 2,275,937 0 0 0 17 Tustin Legacy Enterprise Total: 168,683 679,175 2,275,937 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! 120,000 (120,000) #DIV/0! 2,364,495 (88,558) 103.9% 0 0 #DIV/0! 2,484,495 (208,558) 109.2% Expenditure Summaries 14 Expenditure Summary (By Fund) 2X CDBG, ClP 20-305 Thru 29-999 CDBG FY 99-00, Admin Personnel Operations Capital 20-305 City of Tustin FY 02-03 Mid Year Budget Review 00/01 01/02 02/03 Actual Actual Cur Bud 22,291 0 0 43,774 (15,181) 16,000 0 0 0 66,065 (15,181) 16,000 Year-End Year-End Year-End Projection Vadance Percent 0 0 #DIV/0! 20,000 (4,000) 125.0% 0 0 #DIV/0! 20,000 (4,000) 125.0% CDBG FY 99-00, Non-Dept Personnel Operations Capital 20.801 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! 0 0 #DIV/0! 0 0 #DIV/0! 0 0 #DIV/0! CDBG FY 99-00, ClP Personnel Operations Capital 20.999 0 0 0 112,383 78,830 0 47,867 71,110 7,510 160,249 149,940 7,510 0 0 #DIV/O! 60,000 (60,000) #DIV/0! 7,510 0 100.0% 67,510 (60,000) 898.9% CDBG FY 00-01, Admin Personnel Operations Capital 21-305 78,161 38,237 0 121,458 5,000 45,000 0 0 0 199,619 43,237 45,000 0 0 #DIV/0! 0 45,000 0.0% 0 0 #DIV/0! 0 45,000 0.0% CDBG FY 00-01, ClP Personnel Operations Capital 21-999 0 0 0 0 0 0 10,693 60,849 31,617 10,693 60,849 31,617 0 0 #DIV/0! 0 0 #DIV/0! 0 31,617 0.0% 0 31,617 0.0% CDBG FY 01-02, Admin Personnel Operations Capital 22-305 0 64,387 0 163,959 0 0 0 228,346 135,194 0 391,164 526,358 46,428 88,766 34.3% 61 (61) #DIV/O! 0 391,164 O.0% 46,489 479,869 8.8% CDBG FY 02-03, Admin Personnel Operations Capital 23.305 0 0 0 0 0 0 0 0 0 0 0 0 58,670 (58,670) #DIV/0! 124,428 (124,428) #DIV/0! 0 0 #DIV/0! 183,098 (183,098) #DIV/0! Expenditure Summaries 15 Expenditure Summary (By Fund) City of Tustin FY O2-O3 Mid Year Budget Review 00/01 01/02 02/03 Actual Actual Cur Bud Year-End Year-End Year-End Projection Vadance Percent CDBG FY 02-03 ClP Personnel Operations Capital 23.999 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #DIV/O! 0 0 #DIV/O! 425,000 (425,000) #DIV/0! 425,000 (425,000) #DIV/0! CDBG FY 04-05 Admin Personnel Operations Capital 25.305 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! CDBG FY 05-06, Admin Personnel Operations Capital 26.305 0 6,652 0 6,652 0 210 0 210 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! CDBG FY 05-06 ClP Personnel Operations Capital 26-999 0 0 0 3 0 0 0 0 0 3 0 0 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! CDBG FY 06-07 Admin Personnel Operations Capital 27.305 0 0 2,724 23,702 0 2,724 23,7O2 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! CDBG FY 06-07 ClP Personnel Opemtions Capital 27.999 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! CDBG FY 07-08 Admin Personnel Operations Capital 28-305 0 (18,975) 0 (18,975) 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! Expenditure Summaries 16 Expenditure Summary (By Fund) City of Tustin FY 02-03 Mid Year Budget Review 00/01 01/02 02/03 Actual Actual Cur Bud Year-End Year-End Year-End Projection Variance Percent CDBG FY 07-08, ClP Personnel Operations Capital 28-999 0 0 0 38,975 0 0 0 0 0 38,975 0 0 0 0 #DIV/0! 0 0 #DIV/0I 0 0 #DIV/0~ 0 0 #DIV/0I CDBG FY 08-09, Admin Personnel Operations Capital 29.305 0 0 0 3O,634 157 0 0 0 0 30,634 157 0 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! CDBG FY08-09, Non-Dept Personnel Operations Capital 29-801 CDBG FY 08-09, ClP Personnel Operations Capital 29-999 TOTAL Personnel Operations Capital 2x CDBG Total: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 147,391 126,472 30,825 0 0 0 147,391 126,472 100,452 102,624 485,018 383,149 58,559 131,959 644,030 617,732 30,825 135,194 91,825 430,291 657,310 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/0! 0 3O,825 0.0% 0 0 #DIV/0! 0 30,825 0.0% 105,098 30,096 77.7% 204,489 (112,664) 222.7% 432,510 (2,219) 100.5% 742,097 (84,787) 112.9°/o AD 95-1, ClP 30-999 TOTAL Personnel Operations Capital 30 AD 95-1, ClP TOTAL: 0 0 0 0 0 0 0 0 0 100,000 0 100,000 0 0 #DIV/0! 5,000 95,000 5.0% 0 0 #DIV/0! 5,000 95,000 5.0% Expenditure Summaries 17 Expenditure Summary (By Fund) City of Tustin FY 02-03 Mid Year Budget Review 00/01 01/02 02/03 Actual Actual Cur Bud 95-1 Debt Svs, Non Dept 31-000 Thru 31.801 TOTAL Personnel Operations Capital 31 95-1 Debt Svs Total: 0 0 9,063,452 9,677,115 0 o 9,063,452 9,677,115 95-2 Debt Svs, Non Dept 32-000 Thru 32-801 TOTAL Personnel Operations Capital 32 95-2 Debt Svs Total: 0 0 2,797,523 4,279,210 0 0 2,797,523 4,279,210 Year-End Year-End Year-End Projection Vadance Percent 0 0 #DIV/0! 0 0 #DIV/0! 0 0 #DIV/0! 0 0 #DIVlO! 0 0 #DIV/0! 0 0 #DIV/0! 0 0 #DIV/0! 0 0 #DlVl0! Tustin LLD, ClP 41-801 Thru 41-805 Tustin LLD, Non-Dept Personnel Operations Capital 41-801 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! 0 0 #DIV/0! 0 0 #DIV/0! 0 0 #DIV/0! Tustin LLD, Special District Personnel Operations Capital 41-805 0 0 0 430,132 447,991 502,100 0 0 0 430,132 447,991 TOTAL Personnel Operations Capital 41 Tustin LLD Total: 502,100 0 0 0 430,132 447,991 502,100 0 0 0 430,132 447,991 Tustin SLD, Special District 42-805 Thru 42-999 0 0 212,659 252,124 0 846,500 212,659 1,098,624 TOTAL Personnel Operations Capital 42 Tustin SLD Total: 502,100 0 255,400 13,516 268,916 0 0 #DIV/0! 499,000 3,100 99.4% 0 0 #DIV/0! 499,000 3,100 99.4% 0 0 #DIV/0! 499,000 3,100 99.4% 0 0 #DIV/0! 499,000 3,100 99.4% 0 0 #DIV/0! 252,000 3,400 98.7% 293,516 (280,000) 2171.6% 545,516 (276,600) 202.9% Expenditure Summaries 18 Expenditure Summary (By Fund) SC Debt Svs 51-600 TOTAL Personnel Operations Capital 51 SC Debt Svs Total: City of Tustin FY O2-O3 Mid Year Budget Review 00/01 01/02 02/03 Actual Actual Cur Bud 71 0 0 226,647 298,224 202,000 0 0 0 226,718 298,224 202,000 Year-End Year-End Year-End Projection Variance Percent 0 0 #DIV/0! 202,000 0 100.0% 0 0 #DIV/0! 202,000 0 100.0% SC RDA, Admin 52-600 Thru 52-999 SC RDA, Admin Personnel Operations Capital 52.600 50,109 138,639 27,546 118,236 78,889 97,750 1,309 0 0 169,654 217,527 125,296 27,546 0 100.0% 121,805 (24,055) 124.6°/o 0 0 #DIV/0~ 149,351 (24,055) 119.2% SC RDA, ClP Personnel Operations Capital 52-999 TOTAL Personnel Operations Capital 52 SC RDA Total: SC Set-Aside, Admin 53-600 Thru 53-999 TOTAL Personnel Operations Capital 53 SC Set-Aside Total: Marine Base Debt Svs, Admin 54-600 TOTAL Personnel Operations Capital 54 Marine Base Debt Total: 0 0 0 195,156 255,568 0 39,916 129,774 9,344,139 235,071 385,341 9,344,139 50,109 138,639 27,546 313,392 334,456 97,750 41,225 129,774 9,344,139 404,726 602,869 9,469,435 24,879 26,497 70,648 156,368 46,925 580,625 0 0 0 181,247 73,422 651,273 0 0 0 88,425 103,244 0 0 0 0 88,425 103,244 0 0 0 #DIV/0I 0 0 #DIV/0I 708,220 8,635,919 7.6% 708,220 8,635,919 7.6% 27,546 0 100.0% 121,805 (24,055) 124.6% 708,220 8,635,919 7.6% 857,571 8,611,864 9.1% 70,648 0 100.0% 430,943 149,682 74.2% 0 0 #DIV/0! 501,591 149,682 77.0% 0 0 #DIV/0! 3,051 (3,051) #DIV/0! 0 0 #DIV/0! 3,051 (3,051) #DIV/0! Expenditure Summaries 19 Expenditure Summary (By Fund) Marine Base RDA, Admin 55-600 TOTAL Personnel Operations Capital 55 Marine Base RDA Total' City of Tustin FY 02-03 Mid Year Budget Review 00/01 01/02 02J03 Actual Actual Cur Bud 101,153 19,609 104,052 193,610 347,434 101,090 0 0 0 294,763 367,043 205,142 Year-End Year-End Year-End Projection Vadance Percent 104,052 0 100.0% 58,625 42,465 58.0% 0 0 #DIV/0I 162,677 42,465 79.3% Marine Base Set Aside 56-600 TOTAL Personnel Operations Capital 56 Marine Base Set Aside Total: 0 0 0 147 (147) 0 0 0 0 147 (147) 0 Town Center Debt Svs, RDA 57-000 Thru 57-600 TOTAL Personnel Operations Capital 57 Town Center Debt Total: 0 0 0 0 1,996,611 2,101,015 2,008,450 2,008,450 0 0 0 4,000 1,996,611 2,101,015 2,008,450 2,012,450 Town Center RDA, RDA Admin 58-600 Thru 58-999 Town Center RDA, RDA Personnel Operations Capital 58.600 50,854 56,375 55,294 271,259 1,309 66,O0O 107,457 393,634 27,546 201,365 0 228,911 0 0 #DIV/0I 0 0 #DIV/0I 0 0 #DIV/0! 0 0 #DIVI01 0 #OlVl0! 0 100.0% (4,000) #DIVI0! (4,000) 100.2% 27,546 129,056 4,000 160,602 0 100.0% 72,309 64.1% (4,000) #DIV/O! 68,309 70.2% Town Center RDA, ClP Personnel Operations Capital 58.999 TOTAL Personnel Operations Capital 58 Town Center RDA Total: 0 0 11,688 59,330 61,861 170,000 73,549 229,330 50,854 56,375 66,982 330,590 63,170 236,000 181,006 622,964 0 0 84,363 84,363 27,546 201,365 84,363 313,274 0 0 84,363 0 #DIV/0! 0 #DIV/0! 0 100.0% 84,363 0 100.0% 27,546 129,056 88,363 244,965 0 72,309 (4,000) 68,309 100.0% 64.1% 104.7% 78.2% Expenditure Summaries 20 City of Tustin FY 02-03 Mid Year Budget Review Expenditure Summary (By Fund) 00/01 01/02 02/03 Actual Actual Cur Bud Town Center Set Aside, RDA 59-600 Thru 59-999 Town Center Set Aside, RDA Personnel Operations Capital 59-600 24,879 26,497 70,648 37,219 (1,619) 155,265 0 0 0 62,098 24,878 225,913 Year-End Year-End Year-End Projection Variance Percent 70,648 0 100.0% 33,190 122,075 21.4% 0 0 #DIV/0! 103,838 122,075 46.0% Town Center Set Aside, ClP Personnel Operations Capital 59.999 TOTAL Personnel Operations Capital 0 0 0 0 0 0 0 0 0 0 0 0 24,879 26,497 70,648 37,219 (1,619) 155,265 0 0 0 59 Town Center Set Aside Total: 62,098 24,878 225,913 Water, Service Billing 70.451 Thru 70-459 Water, Service Billing Personnel Operations Capital 70-451 145,952 142,860 2,106,014 2,936,251 34,615 18,071 2,286,581 3,097,183 149,672 1,284,640 122,000 1,556,312 0 0 #DIV/0! 0 0 #DIV/0I 0 0 #DIV/0! 0 0 #DIV/0! 70,648 0 100.0% 33,190 122,075 21.4% 0 0 #DIV/0! 103,838 122,075 46.0% 149,672 0 100.0% 1,116,467 168,173 86.9% 17,000 105,000 13.9% 1,283,139 273,173 82.4% Water, Operations Personnel Operations Capital 70-452 757,781 791,797 1,095,937 622,690 571,794 582,892 16,670 (8,484) 50,450 1,397,140 1,355,106 1,729,279 1,095,937 0 100.0% 500,305 82,587 85.8% 45,000 5,450 89.2% 1,641,242 88,037 94.9% Water Fund, Debt Svs Personnel Operations Capital 70.453 0 0 1,324,209 1,283,867 0 0 1,324,209 1,283,867 0 503,5O0 0 503,500 0 0 #DIV/0! 481,271 22,229 95.6% 0 0 #DIV/0! 481,271 22,229 95.6% Ionization Personnel Operations Capital 70.456 41,361 71,163 46,970 67,717 149,959 215,593 0 0 0 109,078 221,122 262,563 45,623 1,347 97.1% 191,293 24,300 88.7% 0 0 #DIV/0! 236,916 25,647 90.2% Expenditure Summaries 21 Expenditure Summary (By Fund) City of Tustin FY 02-03 Mid Year Budget Review 00/01 01/02 02/03 Actual Actual Cur Bud Year-End Year-End Year-End Projection Variance Percent Reverse Osmosis Personnel Operations Capital 70-457 35,979 40,750 48,970 258,618 203,743 325,493 0 294,597 244,493 374,463 49,095 (125) 100.3% 235,778 89,715 72.4% 0 0 #DIV/0! 284,873 89,590 76.1% 17th Street Desalter Personnel Operations Capital 70.458 85,256 81,251 0 86,361 719,866 609,663 0 903,050 0 9,473 936,600 805,123 700,388 1,926,011 86,750 (389) 100.5% 695,855 207,195 77.1% 820,000 116,600 87.6% 1,602,605 323,406 83.2% Water Production Personnel Operations Capital 70-459 93,629 93,746 100,475 2,139,493 3,192,249 0 2,505,165 400 66,468 0 2,233,522 3,352,462 2,605,640 90,475 10,000 90.0% 2,880,640 (375,475) 115.0% 0 0 #DIV/0~ 2,971,115 (365,475) 114.0% TOTAL Personnel 1,159,959 1,221,567 1,528,385 1,517,552 10,833 99.3% Operations 7,238,607 8,947,526 6,320,333 6,101,609 218,724 96.5% Capital 51,685 85,528 1,109,050 882,000 227,050 79.5% 70 Water Utility Fund Total: 8,450,250 10,254,621 8,957,768 8,501,161 456,607 94.9% TOTAL Personnel Operations Capital 71 Water Debt Svs Total: Water Corp, Debt Svs 72-452 Thru 72.453 TOTAL Personnel Operations Capital 72 Water Corp Total: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 946,850 229,975 0 0 0 0 946,850 229,975 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DlVl0! 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DlVl0! Expenditure Summaries 22 Expenditure Summary (By Fund) Water ClP, Operations 73-000 Thru 73-999 Water ClP, Operations Personnel Operations Capital 73.452 City of Tustin FY O2-O3 Mid Year Budget Review 00/01 01/02 02/03 Actual Actual Cur Bud 0 0 0 0 0 0 0 0 0 0 0 0 Year-End Year-End Year-End Projection Vadance Percent 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! Water CIP, ClP Personnel Operations Capital 73.999 TOTAL Personnel Operations Capital 73 Water ClP Total: 0 0 1,752,298 6,386,649 /585,011) 1475,350) 1,167,288 5,911,299 0 0 1,752,298 6,386,649 (585,011) (475,350) 1,167,288 5,911,299 0 0 8,462,488 8,462,488 0 0 8,462,488 8,462,488 0 0 #DIV/0! 0 0 #DIV/0! 2,467,076 5,995,412 29.2% 2,467,076 5,995,412 29.2% 0 0 #DIV/0! 0 0 #DIV/0! 2,467,076 5,995,412 29.2% 2,467,076 5,995,412 29.2% Water FA, Service Billing Personnel Operations Capital 74-451 0 0 21,379 31,859 0 0 21,379 31,859 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! Water FA, Operations Personnel Operations Capital 74.452 0 0 910,082 1,002,603 0 0 910,082 1,002,603 0 0 #DI¥/O! 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! Water FA, Debt Services Personnel Operations Capital 74-453 TOTAL Personnel Opemtions Capital 74 Water Fixed Assets Total: 0 0 253,603 (718,350) 0 0 253,603 (718,350) 0 0 1,185,064 316,113 0 0 1,185,064 316,113 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DlVl0! Expenditure Summaries 23 Expenditure Summary IBy Fund) Workers Comp 81-801 Thru 81-850 Workers Comp, Non.Dept Personnel Operations Capital 81.801 City of Tustin FY O2-O3 Mid Year Budget Review 00/01 01/02 02/03 Actual Actual Cur Bud 0 0 0 0 0 0 0 0 0 0 0 0 Year-End Year-End Year-End Projection Vadance Percent 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! Workers Comp, Self Insurance Personnel Operations Capital 81-850 TOTAL Personnel Operations Capital 81 Workers Comp Total: Liability 82.801 Thru 82-850 Liability, Non. Departmental Personnel Operations Capital 82-801 0 0 0 352,676 565,251 383,178 0 0 0 352,676 565,251 383,178 0 0 0 352,676 565,251 383,178 0 0 0 352,676 565,251 383,178 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #DIV/0! 492,522 (109,344) 128.5% 0 0 #DIV/0! 492,522 (109,344) 128.5% 0 0 #DIV/O! 492,522 (109,344) 128.5% 0 0 #DIV/0! 492,522 (109,344) 128.5% 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! 0 0 #DIV/O! Liability, Selflnsurance Personnel Operations Capital 82-850 TOTAL Personnel Operations Capital 82 Liability Total: o o 1,004,143 2,603,738 0 0 1,004,143 2,603,738 0 0 1,004,143 2,603,738 0 0 1,004,143 2,603,738 0 788,4OO 0 788,400 0 788,4OO 0 788,400 0 0 #DIV/0! 811,828 (23,428) 103.0% 0 0 #DIV/0! 811,828 (23,428) 103.0% 0 0 #DIV/0! 811,828 (23,428) 103.0% 0 0 #DIV/0! 811,828 (23,428) 103.0% Expenditure Summaries 24 Expenditure Summary (By Fund) City of Tustin FY 02-03 Mid Year Budget Review 00/01 01/02 02/03 Actual Actual Cur Bud Year-End Year-End Year-End Projection Vadance Percent Unemployment, Non-Department Personnel Operations Capital 83-801 0 0 0 0 0 0 0 0 0 0 0 0 0 0 #DIV/0I 0 0 #DIV/0I 0 0 #DIV/0I 0 0 #DIV/0I Unemployment, Self Insurance Personnel Operations Capital 83.850 TOTAL Personnel Operations Capital 0 0 0 10,462 10,884 5,000 0 0 0 10,462 10,884 5,000 0 0 0 10,462 10,884 5,000 0 0 0 10,462 10,884 5,000 0 0 #DIV/O! 5,000 0 100.0% 0 0 #DIV/O! 5,000 0 100.0% 0 0 #DIV/O! 5,000 0 100.0% 0 0 #DIV/O! 5,000 0 100.0% TOTAL Personnel 0 0 0 Operations 0 0 0 Capital 451,315 526,849 983,421 ~i~~[ii ii 451,315 526,849 983,421 0 0 #DIV/0! 0 0 #DIV/0! 987,541 (4,120) 100.4% 987,541 (4,120) 100.4% Expenditure Summaries 25 City of Tustin FY2002-2003 Mid Year Process JL# Description 02-CIP 03-SCAQMD 08-Measure M Competitive 09-Measure M Turnback 10-Gas Tax 11-Park Development 20-29 CDBG 30-RAD 95-1 42-Tustin Lighting District 52-S Central RDA 58-Town Ctr RDA 59-Town Ctr RDA Set-Aside 73-Water C IP Fund 01/02 01/02 01/02 Final Audited Audited Budget Expenditures Carryover 02~03 Suppl/ Adjustments 02~03 Current Budget 02/03 Year-End Projection 02-999 8,888,537 2,549,422 5,185,499 4,463,818 9,304,317 3,529,467 03-999 463,631 0 0 0 0 115,000 08-999 3,180,417 1,716,099 3,067,750 5,570,586 8,638,336 1,729,902 09-999 2,579,185 591,215 1,994,648 1,750,500 3,745,148 703,693 10-999 6,303,379 3,355,590 2,950,559 1,359,327 4,309,886 1,336,146 11-999 3,885,000 108,288 3,777,171 807,000 4,584,171 1,124,043 2X-999 1,216,184 316,462 928,332 412,372 1,340,704 477,372 30-999 318,308 0 318,308 (218,308) 100,000 5,000 42-805 1,137,786 844,270 293,516 0 293,516 293,516 52-999 8,515,395 388,141 8,127,254 1,216,885 9,344,139 708,220 58-999 278,693 229,330 49,363 35,000 84,363 84,363 59-999 0 66,468 0 0 0 0 73-999 13,990,578 5,911,524 8,203,513 258,975 8,462,488 2,467,076 50,757,093 16,076,808 34,895,913 15,656,155 50,207,067 12,573,798 Revenue Reimbursements 02-CIP 03-SCAQMD 08-Measure M Competitive 09-Measure M Tumback lO-Gas Tax 11-Park Development 20-29 CDBG 52-S Central RDA 73-Water CIP 01/02 01/02 01/02 02/03 Final Audited Audited SuppY Fund Budget Expenditures Carryover A~ustmen~ 02-000 2,915,661 832,272 1,988,224 3,474,998 03-000 463,631 0 0 0 08-000 3,180,417 1,716,099 3,067,750 5,570,586 09-000 0 0 0 100,000 10-000 1,400,000 0 1,400,000 (300,000) 11-000 812,000 0 812,000 0 2x-000 1,216,184 316,462 928,332 412,372 52-000 1,900,000 0 1,900,000 0 73-000 956,885 621,639 335,246 0 12,844,778 3,486,472 10,431,553 9,257,956 O2/O3 Current Budget 5,463,222 0 8,638,336 100,000 1,100,000 812,000 1,340,704 1,900,000 335,248 19,689,509 02/03 Year-End Projection 2,257,698 115,000 1,729,902 10,000 0 0 477,372 0 260,000 4,849,972 CIP By Fund 26 City of Tustin FY2OO2-2OO3 Mid Year Process JL# Description Fund 01/02 01/02 01/02 Final Audited Audited Budget Expenditures Carryover 02/03 Suppl/ Adjustments 02~03 Current Budget 02/03 Year-End Projection 1032 1033 1036 1038 1039 1538 2039 2048 4057 4060 4060 4061 5O24 7001 7100 7118 7118 7125 7125 7132 7132 7133 7133 7133 Major Building Maint Fuel Tank R & R Street Sweeper Canopy 800mhz for Public Works City Council Chambers Renovation Jamboree Rd. Irrigation Replacement Magnolia Tr/Pepper Tr Pk Rst Rms Columbus-Tustin Ballfield Renovation Traffic Signal Mods McFadden/Williams Pioneer Road & Way Traffic Signal Mod Developer Share (Revenue) Signal Mod at Newport Ave & Main St Irvine Blvd Storm Drain-Holt to 55 Annual Major Street Maintenance Program Tustin Rch Rd Extension Irvine/Newport TSIA (Revenue) Walnut Rehab/Browning to Uyford LSTP (Revenue) Edinger Widen E. of Red Hill to W. of Jamb IRWD (Revenue Reimbursable) Redhill Widen at I-5 Fwy Developer Share (Revenue) TSIA (Revenue) 7138 Commuter Rail Station 7138 Commuter Rail Station 7139 Valencia/Armstrong 7147 Santa Ana Smart St. Reimb (Revenue) 7147 TSIA (Revenue) 7161 Prospect Rehab-Btwn lst/4th 7162 Jamboree Median Barrier Instal 7162 (Irvine Reimbursable) 7162 (HES Reimbursable) 7163 Main Street Rehabilitation-Stoneglass/SR55 7163 LSTP (Revenue) 7164 Bryan Ave Rehab-Redhill/Browning 7164 LSTP (Revenue) 7166 Bryan Ave Rehab-NewportJRedhill 7166 LSTP (Revenue) 7167 Main Street Rehab-NewportJBryan 7171 Jamboree Reconstruction - N. of TRR 7171 LSTP (Revenue) 7172 Old Town Streetscape & Pedestrian 7174 LSTP (Revenue) 7175 RH Grade Sep/Rail/Eding/RSTP (Revenue) 02-999 232,895 79,518 153,377 52,105 205,482 131,000 02-999 56,903 20,368 36,535 0 36,535 6,000 02-999 0 1,275 0 0 0 0 02-999 22,003 7,155 0 0 0 0 02-999 0 0 0 265,000 265,000 20,000 02-999 90,300 0 90,300 (7,800) 82,500 25,000 02-999 0 3 0 0 0 0 02-999 68,837 10,541 58,296 0 58,296 40,000 02-999 164,101 238,406 0 0 0 0 02-999 67,448 57,794 0 0 0 0 02-999 75,000 7~000 0 0 0 0 02-999 160,000 151,115 0 0 0 0 02-999 444,692 0 444,692 400,000 844,692 250,000 02-999 616,994 565,138 0 600,000 600,000 535,000 02-999 204,993 54,987 150,006 0 150,006 22,500 02-999 900,000 0 900,000 (900,000) 0 0 02-999 104000 246 99,754 0 9~754 9~754 02-999 382,019 305,738 7&281 0 76,281 6,794 02-999 32~280 21~827 108,453 0 10&453 53,452 02-999 345,000 0 345,000 0 0 0 02-999 145,000 110,647 34,353 0 34353 0 02-999 406,800 0 406,800 0 406,800 0 02-999 0 0 0 85,350 8~350 8~350 02-999 38&381 114,209 272,172 0 272,172 22~172 02-999 (6,774) 0 0 0 0 0 02-999 824,648 16,092 0 0 0 0 02-999 40,000 855 39,145 0 39,145 475 02-999 0 0 0 1,559,500 1,55~500 1,20~000 02-999 1,104,000 0 1,104,000 909,583 ~01&583 0 02-999 0 4,160 0 0 0 0 02-999 20,000 10,509 9,491 0 9,491 2,000 02-999 24000 14508 9,492 0 ~492 ~000 02-999 360,000 0 364000 (360,00~ 0 0 02-999 25,000 11,648 13,352 44,515 57,867 28,500 02-999 0 0 0 4~515 4~515 2~000 02-999 70,000 52,384 17,616 0 17,616 4,000 02-999 0 0 0 12~970 12~970 12~970 02-999 60,000 42,145 17,855 375,000 392,855 197,000 02-999 0 0 0 375,000 375,000 18~000 02-999 40,000 18,291 21,709 0 21,709 3,500 02-999 251,171 0 0 0 0 0 02-999 404000 304,835 0 0 0 0 02-999 485,846 69,027 416,819 160,000 576,819 0 02-999 0 0 0 404000 40~000 20~000 02-999 0 0 0 332,080 33~080 50,000 8,888,537 2,549,422 5,185,499 4,463,818 9,304,317 3,529,467 ~91~661 83~272 1,98&224 &474,998 ~463,222 ~25~698 Fund 02. CIP Revenue Reimbursable 7138 Commuter Rail Station AB2766 (Revenue) 03-999 Fund 03 - SCAQMD 463,631 0 0 0 0 463,631 0 0 0 0 115,000 115,000 ClP By Fund 27 City of Tustin FY2OO2-2OO3 Mid Year Process JL # Description Fund 01/02 01/02 01/02 Final Audited Audited Budget Expenditures Carryover 02~03 Suppl/ Adjustments 02~03 Current Budget 02/03 Year-End Projection 4057 Traffic Signal Mods McFadden/Williams 7118 Irvine / Newport 7130 Newport/SR55 Northbound Ramp Reconfig 7133 Redhill Widen at I-5 Fwy 7138 Commuter Rail Station 7147 Edinger /SR55 to E. of Red Hill (RDA-SC) 7175 RH Grade Sep/Rail/Eding/RSTP (Revenue) 08-999 112,667 0 0 0 0 08-999 2,110,150 0 2,110,150 0 2,110,150 08-999 700, 000 0 700, 000 1,509, 586 2, 209, 586 08-999 257, 600 0 257, 600 0 257,600 08-999 0 1,716,099 0 0 0 08-999 0 0 0 4,061,000 4,061,000 08-999 0 0 0 0 0 3,180,417 1,716,099 3,067,750 5,570,586 8,638,336 3,180,417 1,716,099 3,067,750 5,570,586 8,638,336 Fund 08 - Measure M Competitive Revenue Reimbursable 0 1,200,000 0 lOO, OOO 0 429,902 1,729,902 1,729,902 4058 4062 7001 7116 7118 7124 7125 7130 7131 7132 7133 7147 7164 7174 7175 1st @ Prospect Signal Modification Red Hill Ave/San Juan St Modify/upgrade Annual Street Maintenance Program El Camino Widening Irvine / Newport Pave Rehab Red Hill/EdnNVln Caltran Walnut Rehab Newport/SR55 Northbound Ramp Reconfig Newport Extension No. of Edinger Edinger Widen E. of Red Hill to W. of Jamb Redhill Widen at I-5 Fwy Edinger/SR55 to E. of Red Hill Bryan Ave Rehab-Redhill/Browning Jamboree Rd Rehab from I-5 to Irvine Blvd RH Grade Sep/Rail/Eding/RSTP (Revenue) 09-999 0 6,676 0 0 0 0 09-999 0 0 0 185,000 185,000 150,000 09-999 0 0 0 80,000 80,000 70,000 09-999 31,929 726 31,204 (31,204) 0 0 09-999 1,183,135 62,933 1,120,202 0 1,120,202 90,000 09-999 0 2 0 0 0 0 09-999 7,140 7,209 (69) 0 (69) 0 09-999 0 0 0 600,000 600,000 150,000 09-999 0 0 0 200,000 200,000 0 09-999 1,074,295 499,751 574,544 0 574,544 19,693 09-999 282,686 13,919 268,767 75,000 343,767 80,000 09-999 0 0 0 35,000 35,000 24,000 09-999 0 0 0 416,703 416,703 70,000 09-999 0 0 0 90,000 90,000 40,000 09-999 0 0 0 100,000 100,000 10,000 2,5i9,185 591,215 1,994,646 1,750,500 3,745,148 703,693 0 0 0 100,000 100,000 10,000 Fund 09- Measure M Turnback Revenue Reimbursable 7100 G,T. 111 (Revenue) 7118 Irvine / Newport (G.T, 111 Revenue) 7118 Irvine / Newport 7132 Edinger Widen E. of Red Hill to W. of Jamb 7139 Valencia/Armstrong 7139 Econ. Dev. Admin (Revenue) 7139 Trade/Commerce Grant (Revenue) 7164 TCRF AB2928 (Revenue) 7167 Main Street Rehabilitation-Newport/Bryan 7171 TCRF AB2928 (Revenue) 7172 Old Town Streetscape & Pedestrian 7174 Jamboree Rd Rehab from I-5 to Irvine Bird 10-999 586,617 43,907 542,710 0 10-999 907,573 49,724 857,849 0 10-999 0 0 0 900,000 10-999 2,500,000 2,500,000 0 0 10-999 150,000 0 150,000 0 10-999 1,100,000 0 1,100,000 0 10-999 300, 000 0 300, 000 (300, 000) 10-999 0 0 0 157,327 10-999 0 0 0 105,000 10-999 486, 943 489, 713 0 0 10-999 272,246 272,246 0 0 10-999 0 0 0 497,000 6,303,379 3,355,590 2,950,559 1,359,327 1,400, 000 0 1,400, 000 (300, 000) Fund 10 - Gas Tax Revenue Reimbursable 542,710 857,849 900,000 0 150,000 1,100,000 0 157,327 lo5,ooo 0 0 497,000 4,309,886 1,100,000 75,000 160,000 0 0 0 0 0 157,327 70,000 0 576,819 297,000 1,336,146 0 CIP By Fund 28 City of Tustin FY2OO2-2OO3 Mid Year Process JL# Description Fund 01/02 01/02 01/02 Final Audited Audited Budget Expenditures Carryover 02/03 Suppl/ Adjustments 02~03 Current Budget 02~03 Year. End Projection 2043 2048 2050 2051 2052 2053 2053 2054 2056 2057 MCAS Tustin Legacy Park - Phase I Columbus-Tustin Ballfield Renovation Sports Park Ballfield Renovation Tustin Center Senior Center Modification Frontier Skateboard Park Prop 12 Park Develop Grant(Revenue) Pioneer Road Park Major Park Maintenance Centennial Park Renovation Sports Field Lighting at Utt Middle School 11-999 118,000 0 118,000 0 118,000 11-999 995,000 13,077 981,923 0 981,923 11-999 0 459 0 0 0 11-999 300,000 35,999 264,001 0 264,001 11-999 510,000 10,643 499,357 0 499,357 11-999 812,000 0 812,000 0 81~000 11-999 1,150,000 48,110 1,101,890 0 1,101,890 11-999 0 0 0 87,000 87,000 11-999 0 0 0 640,000 640,000 11-999 0 0 0 80,000 80,000 3,885,000 108,288 3,777,171 807,000 4,584,171 81~000 0 81~000 0 81~000 Fund 11 - Park Development Revenue Reimbursable 0 200,000 0 260,000 43 0 302,000 87,000 195,000 80,000 1,124,043 0 7139 CDBG Reallocation 7172 Old Town Streetscape & Pedestrian 2047 Frontier Park Phase II 2047 Frontier Park Phase II 2052 Frontier Skateboard Facility 7139 Valencia/Armstrong 7130 Newport/SR55 Northbound Ramp Reconfig 7139 Valencia/Armstrong 20-999 0 88,031 (88,031) 0 20-999 (13,274) 0 (13,274) 0 20-999 12,500 41,110 0 0 21-999 60,849 60,849 0 0 21-999 36,120 0 36,120 0 22-999 909,164 0 909,164 0 23-999 0 0 0 412,372 29-999 210,825 126,472 84,353 0 1,216,184 316,462 928,332 412,372 1,2`16,184 3`16,462 928,332 4`12,372 Fund 20-29 - CDBG Revenue Reimbursable (88,03`1) (`13,274) 0 0 36,'120 909,`164 4t2,372 84,353 1,340,704 `1,340,704 6~000 0 0 0 ~ooo 0 41~372 0 477,372 47~372 7085 Regional Trail- Phase V 30-999 7096 Incidental Project Costs 30-999 Fund 30 - 95-1 Construction 250,000 0 250,000 68,308 0 68,308 318,308 0 318,308 (250,000) 31,692 (218,308) 0 100,000 100,000 0 5,000 5,000 7172 Old Town Streetscape & Pedestrian 42-805 1,137,786 Fund 42- Street Lighting District 1,137,786 844,270 293,516 844,270 293,516 293,516 293,516 293,516 293,516 7130 7130 7131 7147 NewportJSR55 Northbound Ramp Reconfig 52-999 Developer Share (Revenue) 52-999 Newport Extension No. of Edinger 52-999 Edinger/SR55 to E. of Red Hill 52-999 Fund 52 - South Central RDA Revenue Reimbursable 6,027,542 1,904000 517,352 70,501 8,515,395 `1,90~000 207,604 5,819,938 0 1,904000 120,261 397,091 60,276 10,225 388,141 8,127,254 0 1,90~000 0 0 1,216,885 0 1,216,885 0 5,819,938 `1,90~000 1,613,976 10,225 9,344,139 1,900,000 547,995 0 150,000 10,225 708,220 0 5024 Irvine Blvd SD/Holt To 55 (Ph I) 58-999 7172 Old Town Streetscape & Pedestrian 58-999 Fund 58 - Town Center RDA 108,693 59,330 49,363 0 170,000 170,000 0 35,000 278,693 229,330 49,363 35,000 49,363 35,000 84,363 49,363 35,000 84,363 6999 Presto FixedAssets 70-999 Fund 70- MISC 66,468 0 0 0 0 66,468 0 0 0 0 ClP By Fund 29 City of Tustin FY2OO2-2OO3 Mid Year Process JL# Description Fund 01/02 01/02 01/02 02~03 Final Audited Audited Suppl/ Budget Expenditures Carryover Adjustments 02/03 02/03 Current Year. End Budget Projection 6077 6103 6106 6108 6113 6129 6130 6134 6140 6141 6143 6145 6146 6147 6148 6149 6150 6151 7130 7130 Automatic Chlorination Equip. OCWD Conjunctive Loan Uisc Water Mains Replacements Main Street Reservoir Foothill Reservoir Repairs Reconstruct Simon Booster Station Well @ Pasadena So. of 1st. Water CIP Management Portable Well Generator Prospect Ave. main RJR Maintenance Yard Remodel Water Main Replace-Various Well & Main RJR -Ponderosa Edinger Main RJR Lyttle & Newport Reservoir Repairs Newport Ave Reservoir Repairs Well and Wellhead at 1822 N. Tustin Ave. Prospect Ave. Water Main Replacement Newport Ave-SR55 North Newport Ave-SR55 North 73-999 0 195 0 0 0 0 73-999 956, 885 621,639 335, 246 0 335, 246 260, 000 73-999 78,000 4,716 73,284 37,000 110,284 31,000 73-999 5,598,006 4,196,984 1,401,022 250,000 1,651,022 1,525,000 73-999 720,165 549,515 170,650 0 170,650 28,080 73-999 1,062,843 36,898 1,025,945 110,000 1,135,945 5,000 73-999 1,688,480 28,714 1,659,766 111,130 1,770,896 135,000 73-999 84,919 22,649 62,270 0 62,270 50,000 73-999 275,000 7,865 267,135 0 267,135 160,563 73-999 0 2,170 0 0 0 0 73-999 0 122,094 0 0 0 0 73-999 403,058 304,736 98,322 0 98,322 66,834 73-999 40,000 0 40,000 148,067 188,067 8,000 73-999 360,222 0 360,222 2,778 363,000 10,000 73-999 5,000 950 4,050 20,000 24,050 5,000 73-999 5,000 0 5,000 10,000 15,000 5,000 73-999 120,000 3,610 116,390 1,550,000 1,666,390 121,390 73-999 265,000 8,791 256,209 20,000 276,209 46,209 73-999 328,000 0 328,000 0 328,000 10,000 73-999 2,000,000 0 2,000,000 (2,000,000) 0 0 13,990,578 5,911,524 8,203,513 258,975 8,462,488 2,467,076 956,885 621,639 335,246 0 335,246 260,000 Fund 73- Water ClP Revenue Reimbursable TOTAL 50,757,093 16,076,808 34,895,913 15,656,155 Revenue Reimbursable 12,381,147 3,466,472 10,431,553 9,257,956 50,207,067 12,573,798 19,689,509 4,849,972 ClP By Fund 3O City of Tustin FY 02-03 Mid Year Budget Review JL# Description 1032 Major Building Maint 1033 Fuel Tank R & R 1036 Street Sweeper Canopy 1038 800mhz for Public Works 1039 City Council Chambers Renovation 1538 Jamboree Rd. Irrigation Replacement 2039 Magnolia TflPepper Tr Pk Rst Rms 2043 MCAS Tustin Legacy Park Phase I 2047 Frontier Park Phase II 2047 Frontier Park Phase II 2048 Columbus-Tustin Ballfield Renovation 2048 Columbus-Tustin Ballfield Renovation 2050 Sports Park Ballfield Renov 2051 Tustin Area Senior Center Modification 2052 Frontier Skateboard Park 2052 Frontier Skateboard Park 01/02 01/02 01/02 Final Audited Audited Fund Budget Expenditures Carryover 02-999 232,895 79,518 153,377 02-999 56,903 20,368 36,535 02-999 0 1,275 Completed 02-999 22,003 7,155 Completed 02-999 0 0 0 02-999 90,300 0 90,300 02-999 0 3 Completed 0 3 0 11-999 118,000 0 118,000 118,000 0 118,000 20-999 12,500 41,110 Completed 21-999 60,849 60,849 Completed 73,349 101,959 0 02-999 68,837 10,541 58,296 11-999 995,000 13,077 981,923 1,063,837 23,618 1,040,219 11-999 0 459 Completed 11-999 300,000 35,999 264,001 11-999 510,000 10,643 499,357 21-999 36,120 0 36,120 546,120 10,643 535,477 02/03 Suppl/ Adjustments 52,105 0 0 0 265,000 (7,800) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 02/03 Current Budget 205,482 36,535 0 0 265,000 82,500 0 0 118,000 118,000 0 0 0 58,296 981,923 1,040,219 0 264,001 499,357 36,120 535,477 02/03 Year-End Projection 131,000 6,000 0 0 20,000 25,000 0 0 0 0 0 0 0 40,000 200,000 240,000 0 260,000 43 5,000 5,043 2053 Pioneer Road Park 2053 Prop 12 Park Dev. Grant (Revenue) 2054 Major Park Maintenance 2056 Centennial Park Renovation 2057 Sports Field Lighting at Utt Middle School 4057 Traffic Signal Mods McFaddenNVilliams 4057 M-C (Revenue) CIP By Project 11-999 1,150,000 48,110 1,101,890 0 1,101,890 302,000 11-999 812,000 812,000 0 812,000 0 1,962,000 48,110 1,913,890 0 1,913,890 302,000 11-999 0 0 0 87,000 87,000 87,000 11-999 0 0 0 640,000 640,000 195,000 11-999 0 0 0 80,000 80,000 80,000 02-999 164,101 238,406 Completed 0 0 0 08-999 112, 667 0 Completed 0 0 0 276,768 238,406 0 0 0 0 City of Tustin FY 02-03 Mid Year Budget Review JL# 4058 4060 4060 Description 1st @ Prospect Signal Modification Pioneer Road & Way Traffic Signal Mod Developer Share (Revenue) 4061 Signal Mod at Newport Ave and Main St 4062 Red Hill/San Juan Traffic Signal Mod 5024 Irvine Blvd SD/Holt To 55 (Ph I) 5024 Irvine Blvd SD/Holt To 55 (Ph I) 6077 Automatic Chlorination Equip. 6103 Wells @ 245 Main St. 6103 OCWD Conjunctive Loan 6106 Misc Water Mains Replacements 6108 Main Street Reservoir 6113 Foothill Reservoir Repairs 6129 Reconstruct Simon Booster Station 6130 Well @ Pasadena So. of 1st. 6134 Water CIP Management 6140 Portable Well Generator 6141 Prospect Ave. Main RJR 6143 Maintenance Yard Remodel 6145 Water Main Replace-Various 6146 Ponderosa Water Main Replacement 6147 Edinger Water Main Replacement 6148 John Lyttle Reservoir Repairs 6149 Newport Ave Reservoir Repairs Fund 01/02 01/02 01/02 02/03 02/03 02/03 Final Audited Audited Suppl/ Current Year-End Budget Expenditures Carryover Adjustments Budget Projection 09-999 0 6,676 Completed 02-999 67,448 57,794 Completed 02-999 75, 000 75, 000 Completed 142,448 132,794 0 02-999 160,000 151,115 Completed 09-999 0 0 0 02-999 58-999 73-999 444,692 0 444,692 108,693 59,330 49,363 553,385 59,330 494,055 0 195 Completed 73-999 73-999 95~885 621,639 33~246 956,885 621,639 335,246 73-999 78,000 4,716 73,284 73-999 5,598,006 4,196,984 1,401,022 73-999 720,165 549,515 170,650 73-999 1,062,843 36,898 1,025,945 73-999 1,688,480 28,714 1,659,766 73-999 84,919 22,649 62,270 73-999 275,000 7,865 267,135 73-999 0 2,170 Comple~d 73-999 0 122,094 Comple~d 73-999 403,058 304,736 98,322 73-999 40,000 0 40,000 73-999 360,222 0 360,222 73-999 5,000 950 4,050 73-999 5,000 0 5,000 0 0 0 0 0 0 0 0 0 0 0 0 185,000 400,OO0 0 400,000 0 0 0 37,000 250,000 0 110,000 111,130 0 0 0 0 0 148,067 2,778 20,000 10,000 185,000 844,692 49,363 894,055 0 33~246 335,246 110,284 1,651,022 170,650 1,135,945 1,770,896 62,270 267,135 0 0 98,322 188,067 363,000 24,050 15,000 150,000 250,000 49,363 299,363 0 26~000 260,000 31,000 1,525,000 28,080 5,000 135,000 50,000 160,563 0 0 66,834 8,000 10,000 5,000 5,000 CIP By Project 32 City of Tustin FY 02-03 Mid Year Budget Review JL # Description 6150 Well and Wellhead at 1822 N. Tustin Ave. 6151 Prospect Ave. Water Main Replacement 6999 Projs to Fixed Assets 7001 Annual Major Street Maintenance Program 7001 Annual Major Street Maintenance Program 7085 Regional Trail- Phase V 7096 Incidental Project Costs 7100 Tustin Rch Rd Extension 7100 G.T.- 111 (Revenue) 7116 El Camino Widening 7118 Irvine / Newport 7118 M-C (Revenue) 7118 TSIA (Revenue) 7118 M-T (Revenue) 7118 G.T. 111 (Revenue) 7118 G.T. (Revenue) 7124 Pave Rehab Red Hill M-T (Revenue) 7125 Walnut Rehab/Browning to Uyford 7125 LSTP (Revenue) 7125 Measure M Turnback 7130 Newport/SR55 Northbound Ramp Reconfig 7130 M-C (Revenue) 7130 M-T (Revenue) 7130 CDBG 7130 RDA-SC 7130 Developer Share (Revenue) 7130 WCIP 7130 Future Assessment District (FAD) 7131 Newport Extension No. of Edinger 7131 Newport Extension No. of Edinger(RDA-SC) ClP By Project Fund 01/02 01/02 01/02 02/03 02/03 02~03 Final Audited Audited Suppl/ Current Year-End Budget Expenditures Carryover Adjustments Budget Projection 73-999 120,000 3,610 73-999 70-999 02-999 09-999 30-999 30-999 02-999 10-999 09-999 02-999 08-999 02-999 09-999 10-999 10-999 09-999 02-999 02-999 09-999 02-999 08-999 09-999 23-999 52-999 52-999 73-999 UF-999 09-999 52-999 116,390 1,550,000 1,666,390 121,390 265,000 8,791 256,209 20,000 616,994 0 616,994 250,000 68,308 204,993 586,617 791,610 31,929 31,929 900,000 2,114150 100,000 1,183,135 90L573 0 5,200,858 382,019 325,280 7,140 714,439 0 70~000 0 0 6,027,542 1,90~000 328,000 2,000,000 10,955,542 0 517,352 517,352 0 66,468 276,209 46,209 565,138 0 565,138 54,987 43,907 98,894 0 0 0 0 0 600,000 600,000 535,000 0 80,000 80,000 70,000 0 680,000 680,000 605,000 0 250,000 (250,000) 0 68,308 31,692 100,000 5,000 150,006 0 542,710 0 692,716 0 726 31,204 (31,204) 726 31,204 (31,204) 900,000 (900,000) 2,11~150 0 99,754 0 1,12~202 0 85~849 0 0 90~000 5,087,955 0 150,006 542,710 692,716 0 ~50 94754 1,12~202 85~849 90~000 5,087,955 0 0 246 62,933 49,724 0 112,903 22,500 75,000 97,500 0 L20~O00 94754 9~ooo ~6~000 0 1,549,754 305,738 216,827 7,209 529,773 Completed 0 0 0 76,281 0 108,453 0 (69) 0 184,666 0 76,281 ~08,453 (69) 184,666 0 0 0 0 700,000 1,509,586 0 0 600,000 0 0 412,372 207,604 5,819,938 0 0 1,90~000 0 0 328,000 0 0 2,000,000 (2,000,000) 207,604 10,747,938 521,958 0 120,261 120,261 0 Z20~586 60~000 41~372 5,819,938 ~,90~000 328,000 0 11,269,896 0 200,000 200,000 397,091 1,216,885 1,613,976 397,091 1,416,885 1,813,976 6,794 53,452 0 60,246 0 0 15o, ooo 41~372 547,995 0 10,000 0 1,120,367 0 150,000 150,000 33 City of Tustin FY 02-03 Mid Year Budget Review JL # Description 7132 Edinger Widen E. of Red Hill to W. of Jamb 7132 IRWD (Revenue Reimbursable) 7132 Edinger Widen 7132 Edinger Widen 7133 Redhill Widen at I-5 Fwy 7133 Developer Share (Revenue) 7133 TSIA (Revenue) 7133 M-C (Revenue) 7133 M-T (Revenue) 7138 Commuter Rail Station 7138 TCIP (Revenue) 7138 Commuter Rail Station AB2766 (Revenue) 7138 M-C (Revenue) 7138 GMA-7 (Revenue) 7138 GMA-8 (Revenue) 7138 M-Rail (Revenue) 7139 Valencia/Armstrong 7139 Econ. Dev. Admin (Revenue) 7139 G.T. 7139 Trade/Commerce Grant (Rev) 7139 CDBG Reallocation 7139 Valencia/Armstrong 7139 Valencia/Armstrong 7147 Santa Ana Smart St. Reimb (Revenue) 7147 TSIA (Revenue) 7147 M-C (Revenue) 7147 M-T (Revenue) 7147 Edinger/SR55 to E. of Red Hill (RDA-SC) 7161 Prospect Rehab-Btwn lst/4th 7162 Jamboree Median Barrier Instal 7162 (Irvine Reimbursable) 7162 (HES Grant Reimbursable) 7163 Main Street Rehab-Stoneglass/SR55 7163 LSTP (Revenue) Fund 01/02 01/02 01/02 02/03 02103 02103 Final Audited Audited Suppl/ Current Year-End Budget Expenditures Carryover Adjustments Budget Projection 02-999 345,000 0 345,000 02-999 145,000 110,647 34,353 09-999 1,074,295 499,751 574,544 10-999 2,500,000 2,500,000 0 4,064,295 3,110,398 953,897 02-999 02-999 02-999 08-999 09-999 406,800 0 406,800 0 0 85,350 386,381 114,209 272,172 0 257,600 0 257,600 0 282,686 13,919 268,767 75,000 1,333,467 128,127 1,205,340 160,350 02-999 (6,774) 0 0 02-999 824,648 1~092 0 03-999 463,631 0 0 08-999 0 1,716,099 0 08-999 0 0 0 08-999 0 0 0 08-999 0 0 0 1,281,505 1,732,192 0 02-999 10-999 10-999 10-999 20-999 22-999 29-999 40,000 855 39,145 1,104000 0 1,104000 154000 0 154000 304000 0 300,000 0 88,031 (88,031) 909,164 0 909,164 210,825 126,472 84,353 2,709,989 215,358 2,494,631 02-999 0 0 0 02-999 1,104,000 0 1,104,000 08-999 0 0 0 09-999 0 0 0 52-999 70,501 60,276 10,225 1,174,501 60,276 1,114,225 02-999 02-999 02-999 02-999 02-999 02-999 0 4,160 Completed 0 4,160 0 20,000 20,000 364000 400,000 0 0 0 0 0 0 0 0 0 0 (300,000) 0 0 0 (3OO,OO0) 1,559,500 909,583 4,061,000 35,000 0 6,565,083 0 34,353 574,544 0 608,897 406,800 8~350 272,172 257,600 343,767 1,365,690 0 o 0 0 0 0 0 0 39,145 1,10~000 1~0,000 0 (8~0~ 909,164 84,353 2,194,631 1,559,500 2,013,583 4,061,000 35,000 10,225 7,679,308 0 0 19,693 0 19,693 0 ~350 22~72 100,000 80,000 492,522 0 0 11~ooo o o o o 115,000 475 0 0 0 6~000 0 0 60,475 1,200,000 0 429,902 24,000 10,225 1,664,127 10,509 9,491 0 9,491 2,000 10,508 9,492 0 9,492 2,000 0 360,000 (360,000) 0 0 21,017 378,983 (360,000) 18,983 4,000 25,000 11,648 13,352 44,515 57,867 28,500 0 0 0 47,515 47,515 25,000 25,000 11,648 13,352 92,030 105,382 53,500 34 CIP By Project City of Tustin FY 02-03 Mid Year Budget Review JL # Description 7164 Bryan Ave Rehab-Red Hill/Browning 7164 LSTP (Revenue) 7164 M-T 7164 TCRF AB2928 (Revenue) 7166 Bryan Ave Rehab-NewportJRed Hill 7166 LSTP (Revenue) 7167 Main Street Rehab-Newport/Bryan 7167 GT Fund 02-999 02-999 09-999 10-999 02-999 02-999 02-999 10-999 01/02 01/02 01/02 02/03 02/03 02~03 Final Audited Audited Suppl/ Current Year-End Budget Expenditures Carryover Adjustments Budget Projection 70,000 52,384 17,616 0 17,616 4,000 0 0 0 125,970 125,970 125,970 0 0 0 416,703 416,703 70,000 0 0 0 157,327 157,327 157,327 70,000 52,384 17,616 700,000 717,616 357,297 60,000 42,145 17,855 375,000 392,855 197,000 0 0 0 375,000 375,000 189,000 60,000 42,145 17,855 750,000 767,855 386,000 40,000 18,291 21,709 0 21,709 3,500 0 0 0 105,000 10~000 70,000 40,000 18,291 21,709 105,000 126,709 73,500 7171 7171 7171 Jamboree Reconstruction- N. of TRR LSTP (Revenue) TCRF (Revenue) AB2928 7172 Old Town Streetscape & Pedestrian 7172 GT 7172 CDBG 7172 Tustin Lighting District 7172 RDA-TC 7174 Jamb Rehab-l-5 to Irvine/L S TP (Revenue) 7174 M-T 7174 G-T (Revenue) 7175 RH Grade Sep/Rail/Eding/RSTP (Revenue) 7175 RH Grade Sep/Rail/Eding/M-T (Revenue) 02-999 02-999 10-999 02-999 10-999 20-999 42-805 58-999 02-999 09-999 10-999 251,171 0 Completed 0 0 0 400,000 304,835 Completed 0 0 0 486,943 489, 713 Completed 0 0 0 1,138,114 794,548 0 0 0 0 485,846 69,027 416,819 160,000 576,819 576,819 272,246 272,246 0 0 0 0 (13,274) 0 (13,274) 0 (13,274) 0 1,137,786 844,270 293,516 0 293,516 293,516 170,000 170,000 0 35,000 35,000 35,000 2,052,604 1,355,543 697,061 195,000 892,061 905,335 0 0 0 404000 40~000 20~000 0 0 0 94000 9~000 4~000 0 0 0 49~000 49~000 29~000 0 0 0 987,000 987,000 537,000 02-999 0 0 0 332,080 332,080 50,000 09-999 0 0 0 100,000 100,000 10,000 0 0 0 432,080 432,080 60,000 TOTAL 50,757,093 16,076,808 34,895,913 15,656,155 50,207,067 12,573,798 ClP By Project 35