Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
07 BUDGET REVIEW 03-06-06
AGENDA REPORT MEETING DATE: MARCH 6, 2006 TO: WILLIAM A. HUSTON, CITY MANAGER FROM: RONALD A. NAULT, FINANCE DIRECTOR SUBJECT: FISCAL YEAR 2005-06 MID YEAR BUDGET REVIEW SUMMARY: The following is a review of the City's first six months of operations under the adopted FY 2005-06 Budget, with projected revenues and expenditures through year end. Although the City is realizing a $1,773,580 shortfall in the Motor Vehicle In Lieu Fee and Sales and Use Tax revenue exacted by the State's Budget crisis, proactive management actions per City Council direction have balanced the budget for the remainder of the fiscal year and the City Council's reserve policy will be met. RECOMMENDATION: Approve the following adjustments to the authorized FY 2005-06 Budget: a. Approve a supplemental appropriation of $15,000 from the Unappropriated Reserve of the Measure M Turnback Fund for Tustin Commuter Rail Station Bicycle locker Installation, CIP Project #1060. The increase will cover the cost of additional construction work needed to complete the project. b. Approve a supplemental appropriation of $100,000 from the Unappropriated Reserve of the Water Capital Improvement Fund for Edinger Avenue Water Main Replacement, CIP Project #6147. The increase will cover the cost of additional construction work needed to complete the project. c. Approve a supplemental appropriation of $50,000 from the Unappropriated Reserve of the Water Capital Improvement Fund for Liane, Valhalla & Highview Water Main Replacement, CIP Project #6154. The increase will cover the cost of additional construction work needed to complete the project. d. Approve a supplemental appropriation of $38,000 from the Unappropriated Reserve of the Water Capital Improvement Fund for Main Street Well #4 Rehabilitation, CIP Project #6157. The increase will cover the cost of additional construction work needed to complete the project. Page 2 e. Approve a supplemental appropriation of $82,000 from the Unappropriated Reserve of the Water Capital Improvement Fund for Newport Avenue / SR55 Northbound Ramp Reconfiguration, CIP Project #7130. The increase will cover the cost of additional construction work needed to complete the project. f. Approve a supplemental appropriation of $38,000 from the Unappropriated Reserve of the General Fund for City wide news letter. The increase will cover the cost to include a four page insert that will be stapled into the middle of the "Tustin Today" publication and have its own page numbers. g. Approve a supplemental appropriation of $94,300 from the Unappropriated Reserve of the Marine Base Redevelopment Agency for various operational expenses: Professional & Consulting $20,000, Legal Services $74,000, Meetings $300. h. Approve a supplemental Appropriation of $278,527.36 from the Unappropriated Reserves of East Tustin Developer Fees in Fund 01 for Irvine Blvd and Newport Avenue Intersection Enhancement Project, CIP Project #7118. The increase will cover the cost of additional construction work needed to complete the project. Approve the inclusion of two Police Services Officers and one Police Support Specialist as designated part-time positions with benefits consistent with TPSSA MOU language. No additional appropriation is required at this time. FISCAL IMPACT: The attached Mid Year Budget Review follows the same format as the adopted FY 2005-06 Budget. Each department has reviewed its areas of responsibility and has provided the projections that are presented in this report. The FY 2005-06 Current Budget column reflects any supplemental appropriations approved by the City Council through 12-31-05 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. For the second year the City is realizing a significant shortfall in the Motor Vehicle In Lieu Fee revenue driven by the passing of Proposition 1A on the November 2004 ballot in which Governor Schwarzenegger proposed that cities, counties, special districts and redevelopment agencies make a two year contribution of $1.3 billion per year to solving the State's budget deficit. In exchange, the Governor pledged to lead a campaign to secure revenue and mandate protections for cities, counties and special districts. The agreement includes the permanent elimination of the Vehicle License Fee backfill to be replaced with a like amount of property tax revenue to cities and counties (except for the two year State budget contributions). In both 2004-05 and 2005-06 Tustin will make a 1.1 million dollar contribution each year to the State general fund. These contributions will come from reductions to Tustin's "property taxes in lieu of VLF". The beginning Fund Balances that appear on Page 1 have been adjusted to reflect audited balances as of 6-30-05. The projected 6-30-06 General Fund Balance is $10,664,231. City Council policy requires a minimum 15% reserve in the General Fund. The following discussion will focus on the significant changes that have had an impact on the various funds of the City. Page 3 General Fund The ending Fund Balance at 6-30-05 was $12,526,869 which is $2,698,113 greater than the projected number used for the FY 2005-06 budget preparations. This increase is a result of the AB 1457 Backfill Gap Loan Amount of $1,182,838 being paid early by the State and other factors including salary savings and reduced departmental operating expenses that exceeded original estimates. 2005-06 Revenues Projected General Fund Revenues for the FY 2005-06 are $40,035,926. This is a $227,501, 0.56% decrease from the original budget estimate of $40,263,427. Motor Vehicle In Lieu Fees will decrease by $1.1 million again this year as part of a loan from the cities to the State from the voter approved ballet in November 2004 election (Prop 1A). Also in March 2004, the voters of California approved Proposition 57, the California Economic Recovery Bond Act. Legislative provisions implementing Proposition 57 provide for a swapping of 1/4 cent of local sales tax to be used by the State to repay the bonds effective July 1, 2004. The so called "triple flip" consists of 1) a reduction of the Bradley Burns Local Sales Tax Rate by 1/4% in tandem with a new 1/4% State rate to fund the fiscal recovery bond repayments, 2) payment to cities and counties with additional local property tax previously allocated to schools, and 3) payment to local schools from the State general fund. The net Sales Tax income for FY 2005-06 is projected to be $14,522,000 and the "property tax in lieu of sales tax" is projected to be $4,099,000 for a total of $18.6 million. Property Tax In Lieu of VLF is estimated to be $4,556,483 and Motor Vehicle License Tax should reach $450,000. Property Tax will increase by 5.5% from the original budget of $6,240,000. All other revenue estimates are projected to be met at year end. 2005-06 Expenditures Projected General Fund Expenditures of $41,898,564 will be slightly below the original budget of $43,314,892. On average, departments are projecting a 3.3% salary savings across the board for the current year. Also, this does include yeariy transfers to the Capital Projects Funds. We have been within three to five percent of budgeted expenditures for over ten years. Salary and benefit savings from vacant positions existed for various periods during the year in Planning, Public Works, and Police. Capital Projects Fund The Fund Balance for the Capital Projects Fund at year-end is projected to be $9,351,268. Construction in Progress for current appropriations is $3,192,601. This amount is what will be spent on capital projects by the end of FY 2005-06. The reserved but undesignated amount is $6,158,667. 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. Page 4 Community Development Block Grants Projected CDBG revenues for FY 2005-06 are $987,144. The actual figures for 2004-05 were $784,496. The nature of the 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 $10,437,201 in estimated capital improvement expenditures. The two major projects are Newport Avenue 1 SR55 North Bound Ramp Reconfiguration and Edinger Avenue Widening between SR55 and 1400' EIO Red Hill Avenue. Park Development Fund The Park Development Fund Balance at 6-30-06 is projected to be $4,719,814. The major park projects budgeted for fiscal year 2005-06 is the design of the Citrus Ranch Park. Redevelopment Agency The Town Center Set Aside fund will have a projected fund balance of $4,086,352. Projected expenditures of $391,094 consist of land acquisition previously approved by the Agency. Water Enterprise The projected Water Enterprise Operating Fund balance of $1,270,465 is slightly below 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. The projected Capital Projects Fund reserves of $3,917,030 will provide sufficient resources to the Enterprise Fund to complete several major projects in the Water Capital Improvement Plan. The Enterprise Fund has adequate capital reserves to complete the projects as presented in the current capital improvement budget. Staff will conduct a complete review of water rates and financing options during the FY 2005-06 budget year and will bring recommendations to the City Council prior to June 30, 2006. Risk Management Fund The City is a member of the California Insurance Pool Authority, a risk sharing pool made up of thirteen 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 $400,000 of each Workers' Compensation Page 5 claim. The City is fully self-insured for all unemployment claims. We are currently working with an actuarial to develop the appropriate reserve levels for the Liability and Workers' Compensation funds. The resulting analysis will be reflected in our 2006-07 budget presentation. These issues will be considered as we prepare the 2006-07 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. Ronald A. Nault Finance Director Keith D. Neves Senior Management Analyst City of Tustin Mid-Year Budget Review Fiscal Year 05-06 March 6, 2006 Prepared by the Finance Department City of Tustin City Council Doug Davert, Mayor Tracy Worley Hagen, Mayor Pro Tem Lou Bone, Councilmember Tony Kawashima, Councilmember Jerry Amante, Councilmember George W. Jeffries, City Treasurer Pamela Stoker, City Clerk Lois E. Jeffrey, City Attorney Management Staff William A. Huston, City Manager Christine A. Shingleton, Assistant City Manager Elizabeth A. Binsack, Director of Community Development Scott Jordan, Chief of Police Kristi Recchia, Director of Human Resources Ronald A. Nault, Director of Finance Patrick Sanchez, Director of Parks and Recreation Services Tim D. Serlet, 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 Special Districts Redevelopment Agency Water Services Other 4 5 6 7 8 9 10 11 12-14 15 16-17 17-18 18-21 22.23 23-24 CIP Summary by Project 25-29 City of Tustin FY 05-06 Mid Year Budget Review Year End Projected Fund Balance 06/30/2006 04/05 04105 05106 05106 Actual Bal Actual Actual Actual Bal Projected Projected Pro Bal Fund Oescription 06130/04 Revenues Expenditure 06130105 Revenues Expenditure 06130106 00 Pooled Cash Admin 1,288 (1,288) 0 0 0 0 0 01 General Fund 10,619,260 39,074,738 37,167,130 12,526,869 40,035,926 41,898,564 10,664,231 02 Capital Protects Fund-CIP 9,315,487 3,958,932 3,150,124 10,124,296 2,419,573 3,192,601 9,351,268 03 SCAQMD 82,045 85,925 29,772 138,197 85,500 125,178 98,519 04 Asset Forfeiture 31,717 59,200 27,388 63,529 27,500 25,000 66,029 05 Public Salety Augmentation 0 284,298 284,296 0 242,000 240,500 1,500 08 Measure M.Competltlve (1,337,052) 1,666,232 1,090,548 (761,385) 10,976,240 10,214,875 0 09 Measure M Turnback 3,300,005 1,032,078 3,234,410 1,097,673 1,074,255 222,326 1,949,602 10 Gas Tax 3,153,917 1,386,654 2,241,293 2,299,279 1,637,185 1,718,976 2,217,488 11 Park Development 3,995,576 1,108,117 370,113 4,733,581 796,000 809,767 4,719,814 16 Supplemental Law Enlorcement 88,657 137,627 204,562 21,722 104,021 38,420 87,323 17 Marine Base Closure (2,019) 0 (2,019) 0 0 0 0 18 Tustin Legacy 189,966,731 10,575,734 2,171,890 198,370,575 2,967,012 13,441,986 187,895,599 2x CDBG 0 784,496 784,496 0 987,144 967,144 0 30 95-1 Construction 4,227,836 29,505 162,669 4,094,672 28,000 4,857 4,117,815 33 Community Facilities Dist 04-01 0 3,554,971 519,981 3,034,990 900,000 555,832 3,379,158 34 Community Facilities Dist 04-01 0 7,978,395 2,679,154 5,299,241 62,187 5,381,428 {OJ 41 Tustin LLD 301,391 474,520 481,667 314,244 480,000 540,000 254,244 42 Tustin SLD 2,498,907 570,501 1,359,878 1,709,530 530,000 377,000 1,862,530 50 Special Deposit Trust (485) 485 0 0 0 0 0 51 South Central Debt Svs 11,487,200 2,703,371 212,165 13,978,406 2,561,947 610,892 15,929,461 52 South Central RDA 566,611 53,639 1,004,653 (384,403) 458,594 74,191 0 53 South Central Set Aside 6,045,935 1,067,039 80,286 7,032,667 897,487 93,496 7,836,678 54 Marine Base Debt Service (305,597) 2,300,291 58,638 1,938,057 3,304,576 1,189,248 4,051,387 55 Marine Base RDA (857,143) 0 95,317 (952,460) 1,125,393 172,933 0 56 Marine Base Set Aside 0 805,543 10,166 795,377 901,144 110,011 1,586,5tO 57 Town Center Debt Service 6,097,242 2,628,525 1 ,945,220 6,780,547 2,575,842 2,703,840 6,652,549 58 Town Center RDA 491,115 42,548 1 ,096,957 (563,295) 766,540 205,245 0 59 Town Center Set Aside 3,239,400 850,899 481,073 3,629,227 848,219 391,094 4,086,352 70 Water Utility Fund 2,664,218 8,769,976 8,954,296 2,479,898 9,334,586 10,544,019 1,270,485 73 Water CIP 6,524,941 175,456 296,226 6.402,170 155,000 2,640,140 3,917,030 81 Workers Compensation 827,317 770,598 822,744 775,171 1,260,859 602,353 1,433,677 82 Liability 1,440,587 30,138 485,119 985,606 1,079,000 559,250 1,505,356 83 Unemployment 290,932 0 21,678 269,254 0 5,000 264,254 84 Replacement Fund 3,063,611 808,430 244,704 3,627,337 1,074,583 973,090 3,728,830 TOTAL ALL FUNDS 267,517,435 93,767,575 71,728,592 289,858,612 89,698,313 100,629,256 278,927,669 Fund Balance City of Tustin FY 05-06 Mid Year Budget Review Revenue Summary 03/04 04/05 05/06 Year-End Year-End Year-End (By Fund) Actual Actual Cur Bud Projection Variance Percent 00 Pooled Cash Admin 1,288 (1,288) 0 o 0 01 General Fund 36,602,691 39,074,738 40,263,427 40,035,926 (227,501) 99.4% 02 Capital Projects Fund-CIP 1,605,277 3,958,932 14,574,368 2,419,573 (12,154,795) 16.6% 03 SCAQMD 80,840 85,925 83,000 85,500 2,500 103.0% 04 Asset Forfeiture 44,340 59,200 51,000 27,500 (23.500) 53.9% 05 Public Salety Augmentation 256,381 284,298 240,500 242,000 1,500 100.6% 08 Measure M-Competitive 551,520 1,666,232 17,403,312 10,976,240 (6,427,072) 63.1% 09 Measure M Turnback 966,108 1,032,078 1,074,255 1,074,255 0 100.0% 10 Gas Tax 1,316,373 1 ,386,654 1,337,185 1,637,185 300,000 122.4% 11 Park Development 2,562,457 1,108,117 1,932,127 796,000 (1,136,127) 41.2% 16 Supplemental Law Enlorcement 205,485 137,627 131,500 104,021 (27,479) 79.1% 17 Marine Base Closure 58,665 0 0 ° 0 18 Tustin Legacy 6,523,613 10,575,734 68,450,795 2,967,012 (65,483,783) 4.3% 2x CDBG 1,118,672 784,496 923,725 987,144 63,419 106.9% 30 95-1 Construction 24,708 29,505 0 28,000 28,000 33 Community Facilities Dist 04-61 0 3,554,971 900,000 900,000 0 100.0% 34 Community Facilities Dist 04-61 0 7,978,395 0 62,187 62,187 41 Tustin LLD 466,724 474,520 480,000 480,000 0 100.0% 42 Tustin SLD 533,310 570,501 530,000 530,000 0 100.0% 50 Special DeposR Trust (485) 485 0 o 0 51 South Central Debt Svs 2,140,348 2,703,371 2,385,000 2,561,947 176,947 107.4% 52 South Central RDA (23,320) 53,639 40,000 458,594 418,594 1146.5% 53 South Central Set Aside 739,481 1,067,039 897,000 897,487 487 100.1% 54 Marine Base Debt Service 0 2,300,291 3,300,000 3,304,576 4,576 100.1% 55 Marine Base RDA 0 0 0 1,125,393 1,125,393 56 Marine Base Set Aside 0 805,543 900,000 901,144 1,144 100.1% 57 Town Center Debt Service 2,497,357 2,628,525 2,522,614 2,575,842 53,228 102.1% 58 Town Center RDA (4,202) 42,548 48,700 768,540 719,840 1578.1% 59 Town Center Set Aside 731,804 850,899 800,000 848,219 48,219 106.0% 70 Water Utility Fund 9,071,634 8,769,976 9,277,100 9,334,586 57,486 100.6% 73 Water CIP 95,986 175,456 80,000 155,000 75,000 193.8% 81 Workers Compensation 678,649 770,598 1,240,859 1,280,859 20,000 101.6% 82 Liability 1,391,549 30,138 1,079,000 1,079,000 0 100.0% 83 Unemployment 0 0 0 ° 0 84 Replacement Fund 761,489 808,430 947,083 1,074,583 127,500 113.5% TOTAL ALL FUNDS 70,998,740 93,767,575 171,892,550 89,698,313 (82,194,237) 52.2% 2 Revenue Summaries City of Tustin FY 05-06 Mid Year Budget Review Revenue Summary 03104 04/05 05/06 Year-End Year-End Year-End (By Fund) Actual Actual Cur Bud Projection Variance Percent 01 General Fund Property Tax in Lieu olVLF 0 4,012,563 3,826,306 4,556,483 730,177 119.1% Contribution Reduction in Lieu 0 (1,012,334) (1,032,580) (1,032,580) 0 100.0% Property Taxes 5,879,715 6,398,890 6,240,000 6,600,000 360,000 105.8% Property Tax Fee. Orange 9,325 4,803 9,400 9,400 0 100.0% Property Tax Fee - Flanders 6,335 6,462 6,500 6,500 0 100.0% AB 1290 Pass Thru 0 30,731 0 30,800 30,800 Franchise Fees 1,288,054 1,320,209 1,230,000 1,360,000 130,000 110.6% Property Tax in Lieu 01 Sales and Use Tax 0 4,392,851 4,840,000 4,099,000 (741,000) 84.7% Sales and Use Tax 18,071,342 13,958,356 14,522,000 14,522,000 0 100.0% Transient Occupancy Tax 150,759 139,879 150,000 150,000 0 100.0% Business License Fees 332,447 325,914 300,000 330,000 30,000 110.0% Real Property TranslerTax 458,349 612,216 450,000 650,000 200,000 144.4% New Construction Tax 89,091 142,288 332,500 302,900 (29,600) 91.1% Building Permits-E. Tustin 36,834 50,735 15,000 35,465 20,465 236.4% Bldg Plan Check Fees-E. Tustin 21,260 33,229 8,000 17,268 9,268 215.9% Planning Plan Ck East Tustin 1,818 6,584 1,600 3,393 1,793 212.1% Planning Permit/Inspection EastTustin 1,805 6,676 3,000 3,000 0 100.0% Planning Plan Check 9,679 61,243 100,200 100,200 0 100.0% Planning Permit Inspection 1,347 36,941 282,700 253,870 (28,830) 89.8% Licenses and Permits 1,445,427 1,302,157 2,765,000 2,599,670 (165,330) 94.0% Fines and Forfeitures 978,865 895,816 876,000 650,000 (226,000) 74.2% Interest Income 152,250 71,759 175,000 20,000 (155,000) 11.4% Use of property 71,517 79,979 71,501 72,501 1,000 101.4% Motor Vehicle In-Lieu Fees 3,183,494 1,638,083 611,690 450,000 (161,690) 73.6% Revenue Irom Other Agencies 179,860 205,832 96,500 141,551 45,051 146.7% State Grants 4,211 45,125 0 33,808 33,808 County Grants 25,882 45,115 0 8,717 8,717 Federal Grants 0 0 0 0 0 Sports Fees 271,770 299,448 286,500 287,500 1,000 100.3% Class Fees 385,160 367,107 410,000 315,000 (95,000) 76.8% Other Recreation Fees 126,382 159,923 165,610 163,945 (1,665) 99.0% Current Service Charges 206,465 256,884 196,000 200,821 4,821 102.5% Translers in Irom Other Funds 2,747,106 2,714,246 2,830,000 2,677,113 (152,887) 94.6% All Other Sources 486,145 465,031 495,000 417,601 (77,399) 84.4% 01 General Fund Total 36,602,691 39,074,738 40,263,427 40,035,926 (227,501) 99.4% 3 Revenue Summaries City of Tustin FY 05-06 Mid Year Budget Review Expenditure Summary 03104 04/05 05106 Year-End Year-End Year-End (By Fund) Actual Actual Cur Bud Projection Variance Percent 01 General Fund Legislation 932.860 829,451 864.084 860,084 4,000 99.5% Administration 2,237,950 2,370,969 2,940,632 2,626,041 314,591 89.3% Community Development 1,748,087 2,187,504 2,835,562 2,453,442 382,120 86.5% Public Works 6,715,658 6,803,864 8,172,812 7,964,130 205,662 97.4% Police Services 15,375,565 16,554,151 18,818,350 18,233,811 584,539 96.9% Fire Services 4,289,981 4,422,245 4,620,000 4,620,000 0 100.0% Parks and Recreation 2,341,832 2,423,759 2,678,670 2,667,220 11,450 99.6% Non-Departmental, Other 1,432,008 1,575,166 2,481,150 2,473,836 (12,686) 100.5% 01 General Fund 35,071,942 37,167,130 43,391,260 41,898,564 1,492,696 96.6% 02 Capital Projects Fund-CIP 3,856,305 3,150,124 17,017,334 3,192,601 13,824,733 18.8% 03 SCAQMD 256,202 29,772 199,741 125,178 74,563 62.7% 04 Asset Forfeiture 34,259 27,388 25,000 25,000 0 100.0% 05 Public Salety Augmentation 256,381 284,298 240,500 240,500 0 100.0% 08 Measure M-Competltlve 1,888,572 1,090,548 16,058,886 10,214,875 5,844,011 63.6% 09 Measure M Turnback 535,851 3,234,410 2,832,256 222,326 2,609,930 7.8% 10 Gas Tax 1,436,753 2,241,293 3,005,035 1,718,976 1,286,059 57.2% 11 Park Development 3,603,129 370,113 6,428,631 809,767 5,618,864 12.6% 16 Supplemental Law Enlorcement 184,407 204,562 0 38,420 (38,420) 17 Marine Base Closure 391,444 (2,019) 0 0 0 18 Tustin Legacy 5,079,102 2,171,890 69,311,470 13,441,988 55,869,482 19.4% 2x CDBG 1,118,672 784,496 1,042,417 987,144 55,273 94.7% 30 95-1 Construction 36,260 162,869 0 4,857 (4,857) 33 Community Facilities Dlst 04-01 0 519,961 535,000 555,832 (20,832) 103.9% 34 Community Facilities Dial 04-01 0 2,679,154 (1,179,154) 5,361,428 (6,540,582) -454.7% 41 Tustin LLD 431,894 481,867 550,088 540,000 10,088 98.2% 42 Tustin SLD 228,497 1,359,878 412,000 377,000 35,000 91.5% 51 South Central Debt Svs 135,645 212,165 152,000 610,892 (458,892) 401.9% 52 South Central RDA 317,910 1 ,004,653 958,271 74,191 884,080 7.7% 53 South Central Set Aside 107,574 80,286 116,496 93,496 23,000 80.3% 54 Marine Base Debt Service 20,797 58,638 0 1,189,248 (1,189,248) 55 Marine Base RDA 28,587 95,317 187,933 172,933 15,000 92.0% 56 Marine Base Set Aside 0 10,166 105,011 110,011 (5,000) 104.8% 57 Town Center Debt Service 1,959,511 1,945,220 1,984,000 2,703,840 (719,840) 136.3% 58 Town Center RDA 1,073,506 1,096,957 344,935 205,245 139,690 59.5% 59 Town Center Set Aside 1,611,548 481,073 191,916 391,094 (199,178) 203.8% 70 Water Fund 7,966,913 8,954,296 10,938,122 10,544,019 394,103 96.4% 73 Water CIP 710,641 298,226 5,851,159 2,640,140 3,211,019 45.1% 81 Workers Compensation 645,531 822,744 770,549 602,353 188,196 78.2% 82 LIability 996,624 485,119 509,000 559,250 (50,250) 109.9% 83 Unemployment 3,675 21,678 20,000 5,000 15,000 25.0% 84 Replacement Fund 364,513 244,704 1,024,067 973,090 50,977 95.0% TOTAL ALL FUNDS 70,352,644 71,728,592 183,023,923 100,629,256 82,394,667 55.0% Expenditure Summaries 4 City of Tustin FY 05-06 Mid Year Budget Review Expenditure Summary 03104 04/05 05106 Year-End Year-End Year-End (By Fund) Actual Actual Cur Bud Projection Variance Percent Legislation 01-101 Thru 01-103 City Council Personnel 113,528 115,739 146,600 146,600 0 100.0% Operations 40,993 48,m 41,300 37,300 4,000 90.3% Capital 0 0 0 0 0 01-101 154,521 162,516 189,900 185,900 4.000 97.9% City Clerk Personnel 267,571 282,578 285,784 285,784 0 100.0% Operations 53,707 86,091 77,400 77,400 0 100.0% Capital 5,531 1,442 10,500 10,500 0 100.0% 01-102 326,809 350,111 373,684 373,684 0 100.0% City Attorney Personnel 0 0 0 0 Operations 451,530 316,824 300,500 300,500 100.0% Capital 0 0 0 0 01-103 451,530 316,824 300,500 300,500 100.0% TOTAL Personnel 381,099 398,316 434,384 434,384 0 100.0% Operations 548,230 429,692 419,200 415,200 4,000 99.0% Capital 5,531 1,442 10,500 10,500 0 100.0% Legislation Total: 932,860 829,451 864,084 860,084 4,000 99.5% Expenditure Summaries 5 City of Tustin FY 05-06 Mid Year Budget Review Expenditure Summary 03104 04/05 05106 Year-End Year-End Year-End (By Fund) Actual Actual Cur Bud Projection Variance Percent Administration 01-201 Thru 01-204 City Manager Personnel 321,474 350,889 579,892 405,924 173,968 70.0% Operations 24,017 27,237 34,785 28,735 6,050 82.6% Capital 1,499 118 12,169 12,928 (759) 106.2% 01-201 348,990 378,244 626,848 447,587 179,259 71.4% Finance Personnel 627,617 656,206 690,738 677,064 13,674 98.0% Operations 77,839 98,244 107,100 106,970 130 99.9% Capital 0 500 0 0 0 01-202 705,457 754,950 797,838 784,034 13,804 98.3% Human Resources Personnel 390,099 406,396 480,933 369,948 90,985 80.3% Operations 110,372 148,433 172,200 172,200 0 100.0% Capital 1,021 0 0 0 0 01-203 501,492 552,829 633,133 542,148 90,985 85.6% Inlormalion Technology Personnel 334,104 321,192 415,415 378,502 36,913 91.1% Operations 162,638 179,817 222,400 228,770 (6,370) 102.9% Capital 187,271 183,937 245,000 245,000 0 100.0% 01.204 684,012 664,948 882,815 852,272 30,543 96.5% TOTAL Personnel 1,673,294 1,734,684 2,148,978 1,831,438 315,540 85.3% Operations 374,865 451,731 538,485 536,675 (190) 100.0% Capital 189,791 184,554 257,169 257,928 (759) 100.3% Administration Total: 2,237,950 2,370,969 2,940,632 2,626,041 314,591 89.3% Expenditure Summaries 6 City of Tustin FY 05-06 Mid Year Budget Review Expenditure Summary 03104 04/05 05106 Year-End Year-End Year-End (By Fund) Actual Actual Cur Bud Projection Variance Percent Community Development 01-301 Thru 01-302 Planning Personnel 828,710 870,093 1,063,261 971,394 111,867 89.7% Operations 39,039 184,586 161,421 92,763 68,658 57.5% Capital 3,073 8,450 8,000 8,000 0 100.0% 01-301 870,823 1,063,129 1,252,662 1,072,157 180,525 85.6% Building Personnel 655,904 808,435 1,030,386 828,771 201,595 80.4% Operations 219,361 314,966 551,514 551,514 0 100.0% Capital 0 974 1,000 1,000 0 100.0% 01-302 875,265 1,124,375 1,582,880 1,381,285 201,595 87.3% TOTAL Personnel 1,484,614 1,678,528 2,113,627 1,800,165 313,482 85.2% Operations 258,400 499,552 712,935 644,277 66,658 90.4% Capital 3,073 9,424 9,000 9,000 0 100.0% Community Development Total: 1,746,087 2,187,504 2,835,562 2,453,442 382,120 86.5% Expenditure Summaries 7 City of Tustin FY 05-06 Mid Year Budget Review Expenditure Summary 03104 04/05 05106 Year-End Year-End Year-End (By Fund) Actual Actual Cur Bud Projection Variance Percent Public Works 01-401 Thru 01-410 Administration Personnel 327,382 350,150 373,360 373,360 0 100.0% Operations 171,014 144,474 264,150 262,515 1,635 99.4% Capital 0 0 0 0 0 01-401 496,396 494,624 637,510 635,875 1,635 99.7% Engineering Personnel 897,588 1,030,459 1,163,273 1,163,673 (400) 100.0% Operations 1,217,185 918,296 1,053,075 883,m 169,298 83.9% Capital 0 0 0 0 0 01-402 2,114,773 1,948,755 2,216,348 2,047,450 166,898 92.4% Streets Personnel 365,869 435,760 483,010 483,010 0 100.0% Operations 119,021 126,489 248,257 220,257 26,000 89.4% Capital 797 1,913 11,000 11,000 0 100.0% 01-403 485,687 564,142 740,267 714,267 26,000 96.5% Landscape Personnel 1,001,988 1,077,243 1,287,137 1,287,137 0 100.0% Operations 856,489 897,121 962,294 953,886 28,408 97.1% Capital 24,097 38,748 69,900 67,000 2,900 95.9% 01-404 1,882,575 2,013,113 2,339,331 2,308,023 31,308 96.7% Vehicles Personnel 438,360 417,374 509,692 509,692 0 100.0% Operations 353,451 375,366 487,033 524,759 (37,726) 107.7% Capital 0 0 5,200 5,200 0 100.0% 01-406 791,811 792,740 1,001,925 1,039,651 (37,726) 103.8% Facilities Personnel 214,271 230,712 247,481 247,481 0 100.0% Operations 668,153 695,556 890,118 867,618 22,500 97.5% Capital 0 0 10,000 10,000 0 100.0% 01-407 882,424 926,266 1,147,599 1,125,099 22,500 98.0% Emergency Services Personnel 55,227 56,866 60,062 60,082 0 100.0% Operations 4,765 7,376 29,750 33,683 (3,933) 113.2% Capital 0 0 0 0 0 01-410 59,991 64,242 89,832 93,765 (3,933) 104.4% TOTAL Personnel 3,300,768 3,596,648 4,124,117 4,124,435 (318) 100.0% Operations 3,390,160 3,164,740 3,952,759 3,746,495 206,264 94.8% Capüal 24,976 40,743 96,182 93,200 2,962 96.9% Public Works Total: 6,715,658 6,803,884 8,172,812 7,964,130 208,682 97.4% Expenditure Summaries 8 City of Tustin FY 05-06 Mid Year Budget Review Expenditure Summary 03/04 04/05 05/06 Year-End Year-End Year-End (By Fund) Actual Actual Cur Bud Projection Variance Percent Police 01-501 Thru 01-504 Administration Personnel 790,944 815,826 928,652 928,652 0 100.0% Operations 65,377 72,432 210,657 210,657 0 100.0% Capital 0 0 0 0 0 01-501 856,320 888,258 1,139,309 1,139,309 0 100.0% Patrol Personnel 7,201,460 7,790,098 8,996,994 8,881,646 115,348 98.7% Operations 1,053,663 1,043,731 1,129,659 1,031,555 98,104 91.3% Capital 37,499 251,509 0 0 0 01-502 8,292,542 9,085,338 10,126,653 9,913,201 213,452 97.9% Investigative Services Personnei 3,286,900 3,286,077 3,641,225 3,448,072 193,153 94.7% Operations 239,298 206,839 232,543 217,044 15,499 93.3% Capital 0 0 7,273 7,273 0 100.0% 01-503 3,526,199 3,492,916 3,881,041 3,672,389 208,652 94.6% Administrative Services Personnel 2,317,895 2,606,448 3,202,533 3,057,918 144,615 95.5% Operations 382,509 481,191 466,814 450,994 17,820 96.2% Capitai 0 0 0 0 0 01-504 2,700,404 3,087,639 3,671,347 3,508,912 162,435 95.6% TOTAL Personnel 13,597,199 14,496,449 16,769,404 16,316,288 453,116 97.3% Operations 1,740,867 1,804,193 2,041,673 1,910,250 131,423 93.6% Capital 37,499 251,509 7,273 7,273 0 100.0% Police Department Total: 15,375,565 16,654,151 18,818,350 18,233,811 584,539 96.9% Fire Services 01-550 Personnel 0 0 0 0 0 Operations 4,289,981 4,422,245 4,620,000 4,620,000 0 100.0% Capital 0 0 0 0 0 Fire Services Total: 4,289,981 4,422,245 4,620,000 4,620,000 0 100.0% Expenditure Summaries 9 City of Tustin FY 05-06 Mid Year Budget Review Expenditure Summary 03104 04105 05/06 Year-End Year-End Year-End (By Fund) Actual Actual Cur Bud Projection Variance Percent Parks & Recreation Services 01-701 Thru 01-707 Administration Personnel 309,212 326,869 349,627 349,627 0 100.0% Operations 41,799 49,630 45,598 45,933 (335) 100.7% Capital 0 495 1,200 1,200 0 100.0% 01-701 351,011 376,994 396,425 396,760 (335) 100.1% Sports Personnel 427,621 475,306 538,515 536,515 0 100.0% Operations 231,904 244,143 309,625 296,965 12,660 95.9% Capital 4,537 4,745 38,900 38,900 0 100.0% 01-702 664,063 724,194 885,040 872,380 12,660 98.6% Cla8888lCuiturai Services Personnel 152,054 153,327 164,645 164,645 0 100.0% Operations 319,763 318,433 382,435 362,435 0 100.0% Capital 21,743 12,157 8,550 8,550 0 100.0% 01-703 493,580 483,917 535,630 535,630 0 100.0% Senior Citizens Personnel 164,664 189,054 217,073 217,073 0 100.0% Operations 95,899 80,153 92,195 91,595 600 99.3% Capital 5,051 4,120 4,500 4,500 0 100.0% 01-705 265,634 273,327 313,766 313,168 600 99.8% Support Services Personnel 268,172 285,437 296,677 296,677 0 100.0% Operations 5,329 6,633 7,795 6,595 1,200 84.6% Capital 0 1,220 4,000 4,000 0 100.0% 01-706 273,501 293,291 308,472 307,272 1,200 99.6% Tustin Youth Center Personnel 205,665 191,596 188,052 188,052 0 100.0% Operations 86,179 80,439 49,263 51,958 (2,675) 105.4% Capital 2,200 0 2,000 2,000 0 100.0% 01-707 294,044 272,037 239,335 242,010 (2,675) 101.1% TOTAL Personnel 1,527,408 1 ,621 ,590 1,752,589 1,752,589 0 100.0% Operations 780,893 779,431 866,931 855,481 11,450 98.7% Capital 33,532 22,738 59,150 59,150 0 100.0% Parks & Recreation Total: 2,341,832 2,423,759 2,678,670 2,667,220 11,450 99.6% Expenditure Summaries 10 City of Tustin FY 05-06 Mid Year Budget Review Expenditure Summary 03104 04/05 05106 Year-End Year-End Year-End (By Fund) Actual Actual Cur Bud Projection Variance Percent Non-Departmental 01-801 Personnel 97,366 116,524 132,000 134,790 (2,790) 102.1% Operations 1.334.641 1.455.630 2,329,150 2,338,979 (9.829) 100.4% Capital 0 48 0 67 (67) Non-Departmental Total: 1,432,008 1,572,200 2,461,150 2,473,836 (12,686) 100.5% Miscellaneous Personnel 0 2,968 0 0 0 Operations 0 0 0 0 0 Capital 0 0 0 0 0 Miscellaneous 0 2,968 0 0 0 TOTAL Personnel 22,061,747 23,649,705 27,473,099 26,394,089 1,079,010 96.1% Operations 12,716,038 13,007,214 15,479,133 15,067,357 411,776 97.3% Capital 294,403 510,457 439,274 437,118 2,156 99.5% 01 General Fund Total: 35,071,942 37,167,130 43,391,260 41,898,564 1,492,696 96.6% Expenditure Summaries 11 City of Tustin FY 05-06 Mid Year Budget Review Expenditure Summary 03104 04/05 05106 Year-End Year-End Year-End (By Fund) Actual Actual Cur Bud ProJection Variance Percent Capital Improvement Projects 02.801 Thru 02-999 CIP Non-Departmental Personnel 0 0 0 0 0 Operations 287,145 198,424 207,640 207,733 (93) 100.0% Capital 0 0 0 0 0 02-801 287,145 198,424 207.640 207,733 (93) 100.0% CIP,CIP Personnel 0 0 0 0 0 Operations 406,417 574,398 0 1,162,671 (1,162,671) Capital 3,162,743 2,377,302 16,809,694 1,822,197 14,987,497 10.8% 02-999 3,569,159 2,951,700 16,809,694 2,984,868 13,824,826 17.8% TOTAL Personnel 0 0 0 0 0 Operations 693,562 772,822 207,640 1,370,404 (1,162,764) 660.0% Capital 3,162,743 2,377,302 16,809,694 1,822,197 14,967,497 10.8% 02 tiP Total: 3,856,305 3,150,124 17,017,334 3,192,801 13,824,733 18.8% SCAQMD 03.999 SCAQMD, Non-Departmental Personnel 0 0 0 0 0 Operations 256,202 19,512 60,000 60,000 0 100.0% Capital 0 0 0 0 0 03-801 256,202 19,512 60,000 60,000 0 100.0% SCAQMD, CIP Personnel 0 0 0 0 0 Operations 0 0 0 0 0 Capital 0 10,259 139,741 65,178 74,563 48.6% 03-999 0 10,259 139,741 65,178 74,563 48.6% TOTAL Personnel 0 0 0 0 0 Operations 256,202 19,512 60,000 60,000 0 100.0% Capital 0 10,259 139,741 65,178 74,563 48.6% 03 SCAQMD Total: 256,202 29,772 199,741 125,178 74,563 62.7% Asset Forfeit, Non-Dept 04-801 TOTAL Personnel 0 0 0 0 0 Operations 0 0 0 0 0 Capital 34,259 27,388 25,000 25,000 0 100.0% 04 Asset Forfeit Total: 34,259 27,388 25,000 25,000 0 100.0% Expenditure Summaries 12 City of Tustin FY 05-06 Mid Year Budget Review Expenditure Summary 03104 04/05 05106 Year-End Year-End Year-End (By Fund) Actual Actual Cur Bud Projection Variance Percent Public Safety, Non-Dept 05-801 TOTAL Personnel 0 0 0 0 0 Operations 256,381 284,298 240,500 240,500 0 100.0% Capital 0 0 0 0 0 05 Publ Safety Fund Total: 256,381 284,298 240,500 240,500 0 1 00.0% Measure M-Comp, CIP 08-999 TOTAL Personnel 0 0 0 0 0 Operations 0 0 0 0 0 Capital 1,888,572 1,090,548 16,058,886 10,214,875 5,844,011 63.6% 08 Meas M-C Total: 1,888,572 1,090,548 16,058,886 10,214,875 5,844,011 63.6% Measure M-T, CIP 09-801 Thru 09-999 Meas M-T, Non-Dept Personnel 0 0 0 0 0 Operations 50,000 900,097 50,000 (962,348) 1,012,348 -1924.7% Capital 0 0 0 0 0 09-801 50,000 900,097 50,000 (962,346) 1,012,348 -1924.7% Meas M-T, CIP Personnel 0 0 0 0 0 Operations 283,009 96,862 0 200,000 (200,000) Capital 202,843 2,237,450 2,782,256 984,672 1,797,584 35.4% 09-999 485,851 2,334,312 2,782,256 1,184,672 1,597,584 42.6% TOTAL Personnel 0 0 0 0 0 Operations 333,009 996,960 50,000 (762,346) 812,348 -1524.7% Capital 202,843 2,237,450 2,782,256 984,672 1,797,584 35.4% 09 Meas M-T Total: 535,851 3,234,410 2,832,256 222,326 2,609,930 7.8% Expenditure Summaries 13 City of Tustin FY 05-06 Mid Year Budget Review Expenditure Summary 03104 04105 05/06 Year-End Year-End Year-End (By Fund) Actual Actual Cur Bud Projection Variance Percent Gas Tax, tiP 10-801 Thru 10-999 Gas Tax, Non-Depl Personnel 0 0 0 0 Operations 584,494 589,093 575,000 575,000 100.0% Capital 0 0 10-801 584,494 589,093 575,000 575,000 100.0% Gas Tax, tiP Personnel 0 0 0 0 0 Operations 118,557 102,562 0 20,087 (20,087) Capital 733,701 1,549,638 2,430,035 1,123,889 1,306,148 48.2% 10-999 852,258 1,652,199 2,430,035 1,143,976 1,286,059 47.1% TOTAL Personnel 0 0 0 0 0 Operations 703,052 691,655 575,000 595,087 (20,087) 103.5% Capital 733,701 1,549,638 2,430,035 1,123,889 1,306,148 48.2% 10 Gas Tax Total: 1,436,753 2,241,293 3,005,035 1,718,976 1,286,059 57.2% Park Development, tiP 11-801 Thru 11-999 Park Development, Non-Dept Personnel 0 0 0 0 0 Operations 142,794 143,686 143,119 143,186 (67) 100.0% Capital 0 0 0 0 0 11-801 142,794 143,666 143,119 143,186 (67) 100.0% Park Development, tiP Personnel 0 0 0 0 0 Operations 54,938 79,612 0 205,937 (205,937) Capital 3,405,397 148,814 6,285,512 480,644 5,824,668 7.3% 11-999 3,480,335 226,426 6,285,512 668,581 5,618,931 10.6% TOTAL Personnel 0 0 0 0 0 Operations 197,732 223,299 143,119 349,123 (206,004) 243.9% Capital 3,405,397 148,814 6,285,512 460,644 5,824,868 7.3% 11 Park Dev Total: 3,603,129 370,113 6,428,631 809,767 5,618,864 12.6% Suppl Law Enforcement, tiP 16-502 Thru 16-999 TOTAL Personnel 0 0 0 0 0 Operations (1,168) 80,571 0 0 0 Capital 185,575 123,991 0 38,420 (38,420) 16 Suppl Law Total: 184,407 204,562 0 38,420 (38,420) Expenditure Summaries 14 City of Tustin FY 05-06 Mid Year Budget Review Expenditure Summary 03104 04105 05/06 Year-End Year-End Year-End (By Fund) Actual Actual Cur Bud Projection Variance Percent Marine Base Closure, CIP 17-801 Thru 17-999 MCAS, Non-Depl Personnel 0 0 0 Operations 366,031 (2,019) 0 Capital 0 0 0 17-801 366,031 (2,019) 0 MCAS, Non-Dept Personnel 5,200 0 0 0 0 0 Operations 213 0 0 0 0 0 Capital 0 0 0 0 0 17-805 5,413 0 0 0 0 TOTAL Personnel 5,200 0 Operations 386,244 (2,019) Capital 0 0 17 Marine Base Closure Total: 391,444 (2,019) Tustin Legacy 18-805 thru 18-999 Tustin Legacy, Non-Dept Personnel 345,147 373,426 524,842 524,842 0 100.0% Operations 4,682,110 1,515,865 1,037,190 917,146 120,044 88.4% Capital 0 0 0 0 0 18-805 5,027,257 1,889,291 1,562,032 1,441,988 120,044 92.3% Tustin Legacy, tiP Personnel 0 0 0 0 0 Operations 0 0 0 0 0 Capital 51,845 282,598 67,749,438 12,000,000 55,749,438 17.7% 18-999 51,845 282,598 67,749,438 12,000,000 55,749,438 17.7% TOTAL Personnel 345,147 373,426 524,842 524,842 0 100.0% Operations 4,682,110 1,515,865 1,037,190 917,146 120,044 88.4% Capital 51,845 282,598 67,749,438 12,000,000 55,749,438 17.7% 18 Tustin Legacy Total: 5,079,102 2,171,890 69,311,470 13,441,988 55,869,482 19.4% Expenditure Summaries 15 City of Tustin FY 05-06 Mid Year Budget Review Expenditure Summary 03104 D4IO5 05/06 Year-End Year-End Year-End (By Fund) Actual Actual Cur Bud Projection Variance Percent 2X CDBG, tiP 20-305 Thru 29.999 CDBG FY 99-00, Admin Personnel 0 0 0 0 0 Operations 3,590 0 0 1,237 (1,237) Capital 0 0 0 0 0 20-305 3,590 0 0 1,237 (1,237) CDBG FY 99-00, CIP Personnel 0 0 0 0 0 Operations 7,647 30,752 0 0 0 Capital 0 0 0 0 0 20-999 7,647 30,752 0 0 0 CDBG FY 01.()2, Admin Personnel 0 0 0 0 0 Operations 0 496 0 0 0 Capital 0 0 0 0 0 22-305 0 496 0 0 0 CDBG FY 01-02, CIP Personnel 0 0 0 0 0 Operations 0 0 0 0 0 Capital 358,950 0 0 4,636 (4,638) 22-999 358,950 0 0 4,636 (4,636) CDBG FY 02-03, Admin Personnel 15,039 0 0 0 Operations 16,654 0 0 0 Capital 0 0 0 0 23-305 31,693 0 0 0 CDBG FY 02-03, CIP Personnel 0 0 0 0 Operations 0 0 0 0 Capital 412,372 0 0 0 23-999 412,372 0 0 0 Expenditure Summaries 16 City of Tustin FY 05-06 Mid Year Budget Review Expenditure Summary 03104 04/05 05/06 Year-End Year-End Year-End (By Fund) Actual Actual Cur Bud ProjectIon Variance Percent CDBG FY 03-04, Admin Personnel 111,203 16,004 0 0 0 Operations 160,433 201,260 0 150,000 (150,000) Capital 32,784 0 0 0 0 24-305 304,420 217.263 0 150,000 (150.000) CDBG FY 03-04, CIP Personnel 0 0 Operations 0 0 Capital 0 27,580 24-999 0 27,580 CDBG FY 04-05, Admin Personnel 0 222,942 26,717 (26,717) Operations 0 58,354 0 0 Capital 0 0 0 0 25-305 0 281,296 26,717 (26,717) CDBG FY 04-05, CIP Personnel 0 0 0 0 0 Operations 0 0 0 0 0 Capital 0 227,109 0 160,548 (160,548) 25-999 0 227,109 0 160,548 (160,548) CDBG FY 05-06, Admin Personnel 0 0 87,609 87,609 0 100.0% Operations 0 0 0 70,201 (70.201) Capital 0 0 0 0 0 26-305 0 0 87,609 157,810 (70,201) 180.1% CDBG FY 05-06, CIP Personnel 0 0 0 0 Operations 0 0 0 0 Capital 0 0 954,806 486,196 488,612 50.9% 26-999 0 954,808 486,196 488,612 50.9% TOTAL Personnel 126,242 238,948 87,609 114,326 (26,717) 130.5% Operations 188,324 290,862 0 221,438 (221,438) Capital 804,106 254,668 954,808 651,380 303,428 68.2% 2x CDBG Total: 1,118,672 784,496 1,042,417 987,144 55,273 94.7% Expenditure Summaries 17 City of Tustin FY 05-06 Mid Year Budget Review Expenditure Summary 03104 04/05 05106 Year-End Year-End Year-End (By Fund) Actual Actual Cur Bud ProJection Variance Percent AD 95-1, tiP 30-999 TOTAL Personnel 0 0 0 0 0 Operations 36,260 3,340 0 4,857 (4,857) Capital 0 159,328 0 0 0 30 AD95-1,CIPTOTAL: 36,260 162,669 0 4,857 (4,857) Community Facilities District 04-01 TOTAL Personnel 0 0 0 0 0 Operations 0 519,981 535,000 555,832 (20,832) 103.9% Capital 0 0 0 0 0 33 CFD 04-01 Total: 0 519,981 535,000 555,832 (20,832) 103.9% Community Facilities District 04-01, tiP 34-999 TOTAL Personnel 0 0 0 0 Operations 0 0 0 0 Capital 2,679,154 (1,179,154) 5,361,428 (6,540,582) -454.7% 34 CFD 04-01,CIP 2,679,154 (1,179,154) 5,361,428 (6,540,582) -454.7"A. Tustin LLD, Special District 41-805 Tustin LLD, Special District Personnel 0 0 0 0 0 Operations 431,894 481,667 550,088 540,000 10,068 98.2% Capital 0 0 0 0 0 41.805 431,894 481,867 550,086 540,000 10,088 98.2% TOTAL Personnel 0 0 0 0 0 Operations 431,894 481,667 550,088 540,000 10,088 96.2% Capital 0 0 0 0 0 41 Tustin LLD Total: 431,894 461,667 550,088 540,000 10,088 98.2% Expenditure Summaries 18 City of Tustin FY 05-06 Mid Year Budget Review Expenditure Summary 03/04 04/05 05106 Year-End Year-End Year-End (By Fund) Actual Actual Cur Bud Projection Variance Percent Tustin SLD, Special District 42-805 Thru 42-999 Tustin SLD, Special District Personnel 0 0 0 0 0 Operations 228,497 1,359,878 0 412,000 377,000 35,000 91.5% Capital 0 0 0 0 0 42.805 228,497 1,359,878 412,000 377,000 35,000 91.5% Tustin SLD, Special District, tiP Personnel 0 0 0 0 0 Operations 0 0 0 0 0 Capital 0 0 0 0 0 42.999 0 0 0 0 0 TOTAL Personnel 0 0 0 0 0 Operations 228,497 1,359,878 412,000 377,000 35,000 91.5% Capital 0 0 0 0 0 42 Tustin SLD Total: 228,497 1,359,878 412,000 377,000 35,000 91.5% SC Debt Svs 51-600 TOTAL Personnel 0 0 0 0 0 Operations 135,645 212,165 152,000 610,892 (458,892) 401.9% Capital 0 0 0 0 0 51 SC Debt Svs Total: 135,645 212,165 152,000 610,892 (458,892) 401.9% SC RDA, Admin 52-600 Thru 52-999 SC RDA, Admin Personnel 47,879 50,145 43,965 43,958 27 99.9% Operations 55,393 18,885 27,484 27,233 231 99.2% Capital 0 5,156 10,270 3,000 7,270 29.2% 52-600 103,272 74,186 81,719 74,191 7,528 90.8% SC ADA, CIP Personnel 0 0 0 0 0 Operations 53,391 3,823 0 0 0 Capital 161,247 926,644 876,552 0 876,552 0.0% 52-999 214,638 930,487 876,552 0 876,552 0.0% TOTAL Personnel 47,879 50,145 43,985 43,958 27 99.9% Operations 108,784 22,707 27,484 27,233 231 99.2% Capital 161,247 931,600 886,822 3,000 883,822 0.3% 52 SC RDA Total: 317,910 1,004,653 958,271 74,191 884,080 7.7% Expenditure Summaries 19 City of Tustin FY 05-06 Mid Year Budget Review Expenditure Summary 03/04 04/05 05/06 Year-End Year-End Year-End (By Fund) Actual Actual Cur Bud Projection Variance Percent SC Set-Aside, Admin 53-600 Thru 53-999 TOTAL Personnel 38,059 40,278 57,230 57,230 0 100.0% Operations 69.515 40,008 59,286 36,266 23,000 61.2% Capital 0 0 0 0 0 53 SC Set-Aside Total: 107,574 80,286 116,496 93,496 23,000 80.3% Marine Base Debt Svs, Admin 54-600 TOTAL Personnel 0 0 0 0 0 Operations 20,797 58,638 0 1,189,246 (1,189,248) Capital 0 0 0 0 0 54 Marine Base Debt Total: 20,797 58,638 0 1,189,246 (1,189,246) Marine Base RDA, Admin 55-600 TOTAL Personnel 23,481 26,387 35,047 35,047 0 100.0% Operations 5,107 68,931 152,866 137,886 15,000 90.2% Capital 0 0 0 0 0 55 Marine Base RDA Total: 28,587 95,317 187,933 172,933 15,000 92.0% Marine Base Set Aside 56-600 TOTAL Personnel 0 105,011 105,011 0 100.0% Operations 10,166 0 5,000 (5,000) Capital 0 0 0 0 56 Marine Base Set Aside Total: 10,166 105,011 110,011 (5,000) 104.8% Town Center Debt Svs, RDA 57-000 Thru 57-600 TOTAL Personnel 0 0 0 0 0 Operations 1,959,511 1,945,220 1,984,000 2,703,840 (719,840) 136.3% Capnal 0 0 0 0 0 57 Town Center Debt Total: 1,959,511 1,945,220 1,984,000 2,703,840 (719,840) 136.3% Expenditure Summaries 20 City of Tustin FY 05-06 Mid Year Budget Review Expenditure Summary 03/04 04105 05/06 Year.End Year.End Year.End (By Fund) Actual Actual Cur Bud Projection Variance Percent Town Center RDA, RDA Admin 58-600 Thru 58-999 Town Center RDA, RDA Personnel 67,903 66,348 47,131 47,131 0 100.0% Operations 354,195 101,795 131,848 127,713 4,135 96.9% Capital 18,350 1,212 10,070 10,070 0 100.0% 58-600 440,448 169,353 189,049 184,914 4,135 97.8% Town Center ADA, CIP Personnel 0 0 0 0 0 Operations 0 23,156 0 19,881 (19,881) Capital 633,058 904,448 155,886 450 155,436 0.3% 58.999 633,058 927,604 155,886 20,331 135,555 13.0% TOTAL Personnel 67,903 66,348 47,131 47,131 0 100.0% Operations 354,195 124,951 131,848 147,594 (15,748) 111.9% Capital 651,408 905,661 165,956 10,520 155,436 6.3% 58 Town Center RDA Total: 1,073,506 1,096,957 344,935 205,245 139,690 59.5% Town Center Set Aside, RDA 59-600 Thru 59.999 Town Center Set Aside, ADA Personnel 29,731 32,040 47,645 47,645 0 100.0% Operations 81,815 15,255 55,196 328,371 (273,175) 594.9% Capital 1,300,000 (1,300,000) 0 0 0 59-600 1,411,548 (1,252,704) 102,841 376,016 (273,175) 365.6% Town Center Set Aside, CIP Personnel 0 0 0 0 0 Operations 0 12,716 0 15,078 (15,078) Capital 200,000 1,701,061 89,075 0 89,075 0.0% 59.999 200,000 1,713,777 89,075 15,078 73,997 16.9% TOTAL Personnel 29,731 32,040 47,645 47,645 0 100.0% Operations 81,815 27,972 55,196 343,449 (288,253) 622.2% Capital 1,500,000 401,061 89,075 0 89,075 0.0% 59 Town Center Set Aside Total: 1,611,546 481,073 191,916 391,094 (199,178) 203.8% Expenditure Summaries 21 City of Tustin FY 05-06 Mid Year Budget Review Expenditure Summary 03104 04/05 05106 Year-End Year-End Year-End (By Fund) Actual Actual Cur Bud ProJection Variance Percent Water, Service Billing 70-451 Thru 70-459 Water, Service Billing Personnel 157,592 137,999 183,033 183,033 0 100.0% Operations 1,108,219 1,173,793 1,295,400 1,140,417 154,963 88.0% Capital 0 500 10,500 5,500 5,000 52.4% 70-451 1,265,812 1,312,293 1,488,933 1,328,950 159,983 89.3% Water, Operations Personnel 910,964 860,023 1,315,952 1,315,905 47 100.0% Operations 610,165 694,035 733,663 669,794 63,869 91.3% Capital 5,619 0 132,736 137,458 (4,722) 103.6% 70-452 1,526,748 1 ,554,057 2,182,351 2,123,157 59,194 97.3% Water Fund, Debt Svs Personnel 0 0 0 0 Operations 1,113,591 816,170 707,910 707,910 100.0% Capital 0 0 0 0 70-453 1,113,591 816,170 707,910 707,910 100.0% Ionization Personnel 67,151 (588) 0 0 0 Operations 325,676 87 0 0 0 Capital 0 0 0 0 0 70-456 392,827 (501) 0 0 0 Reverse Osmosis Personnel 49,230 105,354 117,567 117,567 0 100.0% Operations 290,602 518,355 618,498 589,112 29,386 95.2% Capital 0 0 0 0 0 70-457 339,831 623,709 736,065 706,679 29,386 96.0% 17th Street DesaRer Personnel 89,306 97,323 106,732 106,732 0 100.0% Operations 979,556 555,970 1,101,170 1,029,469 71,701 93.5% Capital 0 0 277,938 277,938 0 100.0% 70-458 1,068,662 653,293 1,485,840 1,414,139 71,701 95.2% Water Production Personnel 111,945 124,742 111,199 111,199 0 100.0% Operations 2,147,298 3,663,952 4,225,824 4,151,985 73,839 98.3% Capital 0 0 0 0 0 70-459 2,259,243 3,988,694 4,337,023 4,263,184 73,839 98.3% Expenditure Summaries 22 City of Tustin FY 05-06 Mid Year Budget Review Expenditure Summary 03104 04/05 05/06 Year-End Year-End Year-End (By Fund) Actual Actual Cur Bud ProJection Variance Percent Water, CIP Personnel 0 0 0 0 Operations 6,581 0 0 0 Capital 0 0 0 0 70-999 6,581 0 0 0 TOTAL Personnel 1,386,187 1,324,852 1,834,483 1,834,436 47 100.0% Operations 6,575,106 7,628,944 8,682,485 8,288,687 393,778 95.5% Capital 5,619 500 421,174 420,896 278 99.9% 70 Water Utility Fund Total: 7,966,913 8,954,296 10,938,122 10,544,019 394,103 96.4% Water CIP, Operations 73-453 Thru 73-999 Water CIP, Operations Personnel 0 0 0 0 0 Operations 713,860 0 0 0 0 Capital 0 0 0 0 0 73.453 713,860 0 0 0 0 Water CIP, CIP Personnel 0 0 0 0 0 Operations 35,331 516,983 0 118,617 (118,617) Capital (38,550) (218,757) 5,851,159 2,521,523 3,329,636 43.1% 73-999 (3,219) 298,226 5,851,159 2,640,140 3,211,019 45.1% TOTAL Personnel 0 0 0 0 0 Operations 749,191 516,983 0 118,617 (118,617) Capital (38,550) (218,757) 5,851,159 2,521,523 3,329,636 43.1% 73 Water CIP Total: 710,641 298,226 5,851,159 2,640,140 3,211,019 45.1% Workers Comp 81-850 Workers Comp, Seltlnsurance Personnel 61,522 89,387 103,549 103,549 0 100.0% Operations 583,715 733,357 667,000 498,804 168,196 74.8% Capital 294 0 0 0 0 81-850 645,531 822,744 770,549 602,353 166,196 78.2% TOTAL Personnel 61,522 89,387 103,549 103,549 0 100.0% Operations 583,715 733,357 667,000 498,804 168,196 74.8% Capital 294 0 0 0 0 81 Workers Comp Total: 645,531 822,744 770,549 602,353 168,196 78.2% Expenditure Summaries 23 City of Tustin FY 05-06 Mid Year Budget Review Expenditure Summary 03104 04/05 05/06 Year-End Year-End Year-End (By Fund) Actual Actual Cur Bud ProJection Variance Percent Liability 82-801 Thru 82-850 LiabilRy, SeR Insurance Personnel 0 0 0 0 0 Operations 996,624 485,119 509,000 559,250 (50.250) 109.9% Capital 0 0 0 0 0 82-850 996,624 485,119 509,000 559,250 (50,250) 109.9% TOTAL Personnel 0 0 0 0 0 Operations 996,624 485,119 509,000 559,250 (50,250) 109.9% Capital 0 0 0 0 0 82 Liability Total: 996,624 485,119 509,000 559,250 (50,250) 109.9% Unemployment 83-801 Thru 83-850 Unemployment, Sell Insurance Personnel 0 0 0 0 0 Operations 3,675 21,678 20,000 5,000 15,000 25.0% Capital 0 0 0 0 0 83-850 3,675 21,678 20,000 5,000 15,000 25.0% TOTAL Personnel 0 0 0 0 0 Operations 3,675 21,678 20,000 5,000 15,000 25.0% Capital 0 0 0 0 0 83 Unemployment: 3,675 21,678 20,000 5,000 15,000 25.0% Replacement 84-801 Thru 84-850 TOTAL Personnel 0 0 0 0 0 Operations 0 0 0 0 0 Capital 364,513 244,704 1,024,067 973,090 50,977 95.0% 84 ReplacementTotal: 364,513 244,704 1,024,067 973,090 50,977 95.0% TOTAL ALL FUNDS Personnel 24,193,099 25,891,512 30,359,631 29,307,264 1,052,367 96.5% Operations 32,751,816 32,122,743 31,730,795 34,208,162 (2,477,367) 107.8% Capital 13,407,974 13,714,583 120,933,743 37,113,830 83,819,913 30.7% TOTAL ALL FUNDS: 70,352,644 71,728,592 183,023,923 100,629,256 82,394,667 55.0% Expenditure Summaries 24 Cily 01 Tustin FYO5-06 Mid Year Process CIP .~~IJY",*" 04105 04105 04105 05105 05106 Final Audited Audited Cuneot Veer-End JLt Descn~ion Fund Budget E'penditures Ca_er Budget Projeçtion Annuailialor Sulldlna Mllntanence 1032 CityCIPFund O2.99\) 62.259.00 7.273.19 0.00 151.000.00 151.000.00 1032 WaterCtPFund 73-999 21,480.00 2.607.1B 0.00 0.00 0.00 83,739.00 9,880.37 0.00 151.000.00 151.000.00 CI1v Coonoll Chlmbers Renovationl 1039 CityCIPFund O2-99\) 482,629.00 483,389.83 .760.83 19,239.37 15.000.00 482,629.00 483,389.83 .760.83 19,239.37 15,000.00 City P_lmorovements" 460 EI CImino Reel 1040 CDBG Fund 26-999 0.00 0.00 0.00 100,000.00 0.00 1040 RDA-TCCtPFund 58-999 50.000.00 0.00 50.000.00 20,000.00 20,000.00 50.000.00 0.00 50.000.00 120,000.00 20.000.00 TuaHn UbralV Exoanllon 1045 CityCIPFund O2-99\) 930.000.00 42.14 929.957.66 929.957.66 31.38 1045 CityCIPFundlDeveloperCootribution O2-99\) 1,000.000.00 170.636.42 629,363.58 829.363.58 829.363.58 1045 RDA-TCFund 58-600 24,710.00 24,710.00 0.00 0.00 1.385.00 1045 RDA.TC REL CtP Fund 56-99\) 853,490.00 927,604.17 -74,114.17 135.885.83 20.331.05 1045 RDA-TC REL Fund 59-600 344,873.75 344,873.75 0.00 0.00 192.50 1045 RDA-TC REL CtP Fund 59.99\) 327,626.25 238,751.22 89,075.03 89,075.03 15.077.50 1045 UnFunded tJO.OOO 1.150,000.00 0.00 1.150,000.00 0.00 0.00 4.630,900.00 1.706,817.70 2.924,262.30 1,964,262.30 666,361.01 Tuatln Commuler Rail Station Blevcle Locker Installation 1060 City CtP Fund. TEA Grant 02-999 22.500.00 0.00 22.500.00 22,500.00 22,500.00 1060 MeasureMTumback 09-999 7.500.00 0.00 7.500.00 22.500.00 22.500.00 30.000.00 0.00 30.000.00 45.000.00 45.000.00 Jlmboree Road Irriootlon SYStem 1538 CityCtPFund O2-99\) 50.000.00 55.51 49,944.49 229.944.49 95.000.00 1538 CityCIP Fund -Irvine Ranch Water DisItic1's Share O2-99\) 50.000.00 0.00 50,000.00 230.000.00 0.00 1538 P8/k Development Fund 11.99\) 0.00 16.41 0.00 0.00 0.00 1538 RDA-TCCIPFund 59.99\) 0.00 26.04 0.00 0.00 0.00 100,000.00 97.96 99,944.49 459.944.49 95.000.00 Tuatln Lealev P,rI< 2043 Park Development Fund 11.999 857,851.00 0.00 657,851.00 890,000.00 55,000.00 2O4S CDBG Fund 22.999 83.214.00 0.00 83.214.00 0.00 0.00 721.065.00 0.00 721.065.00 890,000.00 55,000.00 Cltrul Ranch Pari< 2046 P8/k Development Fund 11-99\) 380.000.00 71.069.75 289.930.25 5.148.930.25 400.000.00 380.000.00 71.069.75 288.930.25 5,148.930.25 400.000.00 Pioneer Rood PlrI< 2053 Park De,elopment Fund 11-99\) 0.00 9,280.50 0.00 0.00 0.00 0.00 9,280.50 0.00 0.00 0.00 Annual Mllor Pari< Mal_,nce 2054 Park Development Fund 11-99\) 97.000.00 39,418.62 57.581.48 211,581.48 211,581.48 97.000.00 39,41B.62 57.581.48 211,581.48 211,581.48 Centennial Pari< Renovotlon 2056 Park Development Fund 11-999 122.994.00 106.424.13 0.00 0.00 0.00 122.994.00 106.424.13 0.00 0.00 0.00 Soorts Reid Uohtlnol UIt Middle School 2057 Park Development Fund II.99\) 0.00 217.14 0.00 0.00 0.00 0.00 217.14 0.00 0.00 0.00 F & V Centa< Par~na Lot & PllvQroond Imorovements 2058 CDBG Fund 24-99\) 70,000.00 27,579.50 0.00 0.00 0.00 70,000.00 27,579.50 0.00 0.00 0.00 TotLotRenovotions/EIClmlnaReel PIne Tree TultinSoortsParl< 2059 P8/k De'ek>pment Fund 11.999 0.00 0.00 0.00 35,000.00 0.00 0.00 0.00 0.00 35,000.00 0.00 25 CIP Sy ProJ"" Cily of Tustin FYO5-06 Mid Year Process CIP ~ ~!'J!Ianøn1 y ~ 04105 04105 04105 05106 05106 Fin~ Audited Audited Cuneot Year-End JL# Description Fund Budget Expenditu"" Carryover Budget Projection Traffic Sianalln&tallation at Portda Parkwav/AlierICnrus Ranch Park 4026 95-1G"""tructionG/PFund 30-999 0.00 0.00 0.00 200.000.00 0.00 0.00 0.00 0.00 200.000.00 0.00 AltadenaiPasadena Pedeat.an Enhancements 4IJ63 CityGtPFund 02.999 0.00 7.200.00 -7,200.00 0.00 0.00 4IJ63 Gity G/PFund-SR2S Safe Roote to School Gran/ 02.999 BI.000.00 0.00 BI,OOO-OO BI.000-00 BI.000.00 4063 Measu,. M Tumback Fund 09-999 54,000.00 890.00 53,110.00 53.110.00 1.67B.27 4063 GDBG Fund 25.999 133,914.00 8O,4æ-85 T3,445-15 22.158.24 22.158.24 268,914_00 68,558-85 200,355-15 156,268.24 104.836.51 NewDOrt Avenue at EI Camino Real: Modllv/UDOrade Traffic Sional 4064 GiIyG/PFund 02.999 0.00 595.00 0.00 0.00 0.00 4064 Messu,.MTumbackFund 09-999 2O9,O2B.00 185,133.12 0.00 0.00 0.00 2O9,O2B.00 185,72B.12 0.00 0.00 0.00 Old Town TusHn Commercial District Sion PrDOram 4065 Messu,. M Tumback Fund 09-999 65,000.00 0.00 65.000.00 65,000.00 10,383.09 4065 GDBG Fund 25-999 185.000.00 96,640.00 68.360.00 139,646.91 139,646.91 250.000.00 96,640.00 153.360.00 204.646.91 150.000.00 Red Hili Avenue/Olwvn D.ve Pedestrian Enhancements 4067 Gity G/P Fund 02-999 0.00 0.00 0.00 75.000.00 0.00 4O6T AB276ôFund 03-999 00.000.00 10.259.30 69.740.70 99.740.70 99.740.70 00.000.00 10.259.30 69.740-70 174,740.70 99.740.70 FIrst StreetIB Street Pedest.an Enhancements 4O6B City G/P Fund 02-999 0.00 0.00 0.00 52.790.00 0.00 4O6B City G/P Fund - SR2S Safe Roote /0 School Gran/ 02-999 0.00 0.00 0.00 177.210.00 30.000.00 4O6B AB276ô SCAOMD 03-999 0-00 0-00 0-00 40.000-00 40.000.00 0-00 0-00 0-00 270,000-00 70.000.00 Tuatln Laaaev Run-Off Manaaement Plan/Enalneerlna StudY 5025 GiIyC/PFund 02-999 0.00 12,391.53 0.00 0.00 0.00 0.00 12,391.53 0.00 0.00 0.00 Pasadeaa Avenue Storm Drain Imorovements 5032 COBG Fund 26-999 0.00 0.00 0.00 121,265.00 121,285.00 0.00 0.00 0.00 121,265.00 121,285.00 Lear Roaewood & Cameton Water Main Reolacements BI06 WaterC/PFund 70-999 0.00 0.00 0.00 0.00 0.00 6106 Wa/erC/PFund 73-999 17.436.00 130.00 17.306.00 0.00 0.00 17.436.00 130.00 17.306-00 0.00 0.00 Simon Reservoir AnalYsla and Reconstruction 6114 We/ere/PFund 73-999 335.000.00 30.582.50 304,417.50 354.417.50 150.000.00 335,000.00 30.582.50 304,417.50 354.417.50 150.000.00 Pasadena Avenue Well 6130 WaterG/PFund 73-999 1,735,738.00 B,554.00 1.727,184.00 2,042,184.00 150,000.00 1.735,738.00 B,554-00 1.727,184.00 2,042,184-00 150,000.00 Water Caollallmorovement Program Manaaement 6134 We/erC/PFund 73-999 138.472.00 23,803.50 114.668.50 206,196.50 100,000.00 138.472.00 23,803.50 114.668.50 206,196.50 100,000.00 Rawllnaa Reservoir Reaalra and Realacement 6138 Wa/erG/PFund 73-999 338.515.00 101.849.40 238.665.80 1.238.665.80 550,000.00 338.515.00 101.849.40 238.665.80 1.238.665.80 550.000.00 Tuatln Avenue and 17th Street Water Main Realacements 6146 WaterC/PFund 73-999 173.976-00 7.556-57 166,419-43 0.00 0.00 173,976-00 7.556.57 166.419-43 0.00 0.00 Edlnaer Avonue Water Main Reolacement 6147 WaterG/PFund 73-999 383,000.00 0.00 383,000.00 550,000.00 550.000.00 383,000.00 0.00 383,000.00 550,000.00 550,000-00 John LvtII. Reservoir Tank Evaluation Site lmorove and Satetv UDOrades BI48 We/erG/PFund 73-999 69,050.00 0.00 69,050.00 0.00 0.00 69.050.00 0.00 69.050.00 0.00 0.00 26 CIP By Project Ci~ofTustin FYO5-06 Mid Year Process CIP ~~~"'\,. 04105 04105 04105 05106 05106 Final A"'",d A,"lad C"",nl Vear-End JL# Descripllon F"d Bodgel Expon"t""" Carryover BLJdget Projection NewDOrt Avenue Reservoir Reoalrs 6149 WaterCIPF,nd 73-999 142.866.00 4.000.00 0.00 0.00 0.00 142.866.00 4.000.00 0.00 0.00 0.00 Orilla.. Install Water Weiland Wellhead at 1822 N. Tustin Avenue 6150 WaterCIPFund 73-999 1,795,000.00 0.00 1.795,000.00 195,000.00 50,000.00 1.795,000.00 0.00 1.795,000.00 195.000.00 50.000.00 Proooect Ave Water Meln Reolecement Between Sanll Clare/Falrhaven Ave 6151 WaterC/PF,nd 73.999 114.706.00 2,657.00 112.049.00 152.049.00 140.00 114.706.00 2,657.00 112.049.00 152.049.00 140.00 Columbus Tustin Well Eleçtrical P,nel Reolscament 6152 WaterCIPF,nd 73-999 64.918.00 76.262.44 0.00 0.00 0.00 64,918.00 76.262.44 0.00 0.00 0.00 Zone 3 Automated Emeroency Interconnect 6153 WaterCIPFund 73-999 169,000.00 0.00 169,000.00 0.00 0.00 169,000.00 0.00 169.000.00 0.00 0.00 Uane Vslhalla & Hlohvlew Water Main Reolacemenll 6154 WaterCIPF,nd 73-999 313.000.00 40.353.82 272.646.18 559.646.18 550.000.00 313.000.00 40.353.82 272.646.18 559.646.18 550,000.00 Main Street Reverse Oamoalallon Exchanoe Faclllti..lmorovemen1l 6156 WaterCIPFund 73-999 75,000.00 0.00 75,000.00 0.00 0.00 75,000.00 0.00 75,000.00 0.00 0.00 Msln Street Well No.4 Rehabilitation 6157 WeterC/PFund 73-999 92,000.00 0.00 92.000.00 155.000.00 140.000.00 92.000.00 0.00 92.000.00 155.000.00 140.000.00 Newoort Avenue Well Electrical Panel UDOrades 6158 WaterCIPFund 73-999 44.000.00 0.00 44,000.00 0.00 0.00 44.000.00 0.00 44,000.00 0.00 0.00 Prol"" to FIxed AaseIs 6999 WaterC/PFund 73-999 0.00 6,451.49 0.00 0.00 0.00 0.00 6,451.49 0.00 0.00 0.00 Annual Malor Pavement Malntenanca 7001 CilyCIPFund 02-999 600.000.00 599,999.60 0.00 600.000.00 600.000.00 7001 MeasureMTumbackFund 09-999 30.000.00 30.000.00 0.00 15.000.00 15.000.00 530.000.00 629.999.60 0.00 615.000.00 615.000.00 Pha.. V Realonal Trails 7085 95-1 Construction tiP Fund 30-999 300,000.00 158.880.75 141,119.25 141,119-25 8,82802 300,000.00 158,680-75 141,119.25 141,119.25 8,828.02 Prolect Inc:ldenlals 7096 95-tConstructionC/PFund 30-999 63,110.00 3,7B7.89 59.922.11 59.922.11 10.000.00 63.110.00 3,787.89 59.922.11 59.922.11 10.000.00 Tustin Ranch Rood Extension: Wslnut Avenue to ValencIa North Looo Road. 1100 City CIP F,nd 02-999 111.509.00 64.661.60 45,647.40 0.00 0.00 1100 Gas Tax Fund 1(>999 30,000.00 0.00 30,000.00 0.00 0-00 7too Gas Tax f1f Fund 1(>999 452,375.00 61.324.50 391,050.50 0.00 0-00 593,884.00 125.986.10 457,897.90 0.00 0.00 Irvine SI.. and Newoort Avenue Interaeçtion Enhancement Proleçt 7118 CilyC/PFund 02-999 40,219.00 1,432.50 38,766.50 38,766.50 17.730.04 7118 CilyC/PFund/Deve/operFees 02-999 0.00 0.00 0.00 278.527.38 0.00 1118 MeesureMCompetmveFund 08-999 987.821.00 832,945.59 154.875.41 154.875.41 154.875.41 7118 MeasureMTumbackFund 09.999 1.148.898.00 690,270.12 458.625.88 458.625.88 458.625.88 7118 Gas Tax f1f Fund 1(>999 761.085.00 599.045.89 162.039.11 362.039.11 362.039.11 7118 Gas Tax Fund 1(>999 1,300.000.00 213.310.65 1,086.669.15 1,086.669.15 500.000.00 4,238,021.00 2,337.004.95 1,901,016.05 2,379,543-41 1.493,270.44 27 CIP 8y projeçt CityofTustin FVO5-06 Mid Vear Process CIP CIpn.I ~.I'rogrmnBy Pro tet 04105 04105 04105 05106 05/06 Final Audited Audited Currant Year.End JL# Description FurO Budget Expenditures Canyovnr Budgat proJectton Newoort Ave I SR55 Northbound Ramo Reconllauratlon 7130 CityCIPFund 02.999 2.043,856.00 42.544.75 2,001,311.25 2,001,311.25 0.00 7130 CityCIPFund.De""loperBond 02.999 0.00 0.00 0.00 4,500,000.00 500,000.00 7130 MeasureMCompeti/i""Fund 08-999 6.965,986.00 0.00 6,965,986.00 9,965,986.00 6.500,000.00 7130 Me..ureMTumbackFund 09-999 1.347,188.00 123,153.99 1,224,034.01 1,224,034.01 100,000.00 7130 Gas Tax Fund 10-999 699,370.00 0.00 699,370.00 699,370.00 0.00 7130 RDA.SCCIPFund 52.999 1.354,992.00 926,356.81 428,635.19 428,635.19 0.00 7130 WaterCIPFund 73-999 318,000.00 0.00 318,000.00 400.000.00 400.000.00 12.729.392.00 1,092,055.55 11.637,336.45 19.219.336.45 7.500.000.00 NewoOll Avenue Extension North Of Edlnaer Avenue 7131 MeasureMTumbackFund 09.999 199.997.00 0.00 199.997.00 199.997.00 0.00 7131 CDBG Fund 25-999 70.000.00 70,000.00 0.00 0.00 0.00 7131 CDBGFund 26-999 0.00 0.00 0.00 199.877.00 60.000.00 7131 RDA-5CC/PFund 52.999 451.983.00 4.110.00 447.873.00 447,873.00 0.00 721,980.00 74.110.00 647,870.00 847,747.00 60,000.00 Red Hili Avenue Wldanlna Pro/ect at1hal-5 F_BY 7133 CityCIPFund 02-999 406,800.00 383.558.53 23,211.47 273,211.47 175,000.00 7133 CityCIPFund.De""loperShare 02-999 0.00 0.00 0.00 0.00 0.00 7133 City CIP Fund. TSIA Trensporlation System/mprovemen1Authority 02.999 29,079.00 29,079.00 0.00 0.00 0.00 7133 Me..ure M Compeütive Fund 08-999 257,600.00 257,800.00 0.00 0.00 0.00 7133 Me..ureMTumbackFund 09.999 1.126,293.00 1,067,383.36 36,900.64 38.900.64 2.000.00 7133 GasTaxFund 10-999 350,000.00 350,000.00 0.00 0.00 0.00 2.189.m.00 2.107,650.89 62,121.11 312.121.11 177.000.00 Valancla North Loco Road and Armstrona Avenue within Tustin Leoacv 7139 CityC/PFund 02-999 377.558.00 190,324.79 187.233.21 0.00 0.00 7139 Gas Tax Fund 10-999 300.000.00 92,981.86 207.018.14 0.00 0.00 7139 TusünLegacyFund 16-999 23,363,788.00 282.598.48 23,081.189.52 23,132,430.52 10,000,000.00 7139 CDBGFund 20-999 33.228.00 30.752.10 2.475.90 0.00 0.00 7139 Community Fa"liües District 04.01 CIPFund 34-999 7,963,000.00 2,679.153.60 5,283,846.40 5,283,846.40 5.283,846.40 32,037,574.00 3,275.BI0.83 26,761,763.17 28,416,276.92 15.283,846.40 Edlnaer Avenue Wldenlna beMftn SR55 and 14DD' !YO Red Hili Avenue 7147 CityCIPFund 02.999 0.00 0.00 0.00 0.00 0.00 7147 City C/P Fund. CDSA Citro/San/sAna Sma~StreetReimbursment 02.999 177,554.00 51,270.17 128,283.83 128,283.83 128,283.83 7147 City C/P Fund. TSIA Trsnsporta/ion System Impro""ment Authority 02-999 3.041,458.00 90,399.88 2.951,058.12 5.051.058.12 100.000.00 7147 CityC/PFund.Deve1operBond 02.999 178.715.00 0.00 17B.715.00 17B.715.00 0.00 7147 MeasureMCompe/itiveFund 08-999 3.677.565.00 0.00 3.877.585.00 5.336.025.00 3.000.000.00 7147 MeasureMTumbackFund 09.999 34.641.00 9,736.49 24.904.51 24.904.51 4.485.00 7147 RDA-SCCIPFund 52.999 44.00 0.00 44.00 44.00 44.00 7,109.997.00 151,406.54 8.958.590.48 10,719.030.48 3,230.812.83 Jamboree Road Median Ba"ler InslallaUon 7162 CityCIPFund-CDICityofllVine 02.999 129,200.00 115.971.43 0.00 0.00 0.00 7162 CityCIPFund-HESHezaniEliminetionSy"emGrent 02-999 355,501.00 355.501.00 0.00 0.00 0.00 7162 Gas Tax Fund 10-999 342,807.00 297.453.07 0.00 0.00 0.00 827,508.00 788.925.50 0.00 0.00 0.00 Newoort Avo RahabllltaUon between Sycamore Ave and Mcfadden Ave 7165 CityC/PFund 02.999 21,334.00 127.50 21,206.50 21,206.50 200.00 7165 MeasureMTumbackFund 09-999 0.00 0.00 0.00 350.000.00 350.000.00 7165 Gas Tax Fund -AB2928 10-999 20.00 905.00 .885.00 169.115.00 169.115.00 21.354.00 1,032.50 20,321.50 540.321.50 519.315.00 Tuatln CommunitY FaclllUea Dlat~e! ~1tJol1n laino Homes! 7188 Community Facilities District 04.01 CIP Fund 34-999 0.00 0.00 0.00 1,624.007.00 1,000.000.00 0.00 0.00 0.00 1.824.007.00 1.000.000.00 Tha Dilkie! at Tustin Laaaov 7169 TustinLegacyC/PFund.De""loperFunds 16-999 0.00 0.00 0.00 36,330.000.00 2,000,000.00 0.00 0.00 0.00 36,330,000.00 2.000,000.00 2B CIP By Pro ecI City o! Tustin FYO5-06 Mid Year Process CIP CI¡)IÞI~ ProQrem By ~ 04105 04105 04105 05106 05106 Fi"'" Audited Audited Current Vear.End JL# Description Fund Budget Expenditures Conyover Budget Projection Red Hili Avenue Grade Seoaratlon at OCTAlSCRRA Rallwav/Edln... Avenue 7175 CilyCIP Funds. RSTP/STP ReØnaJ Su~oce Tmnpo~afion P"'fJf8I1I 02-999 332,080.00 22,291.08 309,788.92 309,788.92 309,788.92 7175 MeasuraMGroWfhFund-GMA-7 08-999 90,000.00 0.00 90,000.00 90,000.00 50,000.00 7175 Messura M Tumback Fund 09-999 127,920.00 7,744.90 120,175.10 120,175.10 10,000.00 550,000.00 30,035.98 519,964.02 519,964.02 369,788.92 eaa' AllOY ImDrovements - Main Street and Third Street 7176 CDBG Fund 24-999 220,000.00 0.00 220,000.00 220,000.00 0.00 7176 CDBG Fund 25.999 110,000.00 0.00 110,000.00 110,000.00 0.00 7176 TustínLiQlltingDístrict(AdValoram}CIPFund 42-999 110,000.00 0.00 110,000.00 0.00 0.00 440,000.00 0.00 440,000.00 330,000.00 0.00 Proa.... Avenue Imorovemenfs betwæn Main Street and TIIlrd Street 7177 CDBG Fund 24-999 384,612.00 0.00 384,612.00 384,612.00 0.00 7177 CDBG Fund 25-999 165,386.00 0.00 165,386.00 165,386.00 0.00 7177 Tusnn LiQllfing District (Ad Va~ram) CIP Fund 42.999 40,000.00 0.00 40,000.00 0.00 0.00 7177 Wate' CIP Fund 73-999 125,386.00 0.00 125,386.00 0.00 0.00 715,386.00 0.00 715,386.00 550,000.00 0.00 Walnut Ave Rehabilitation between Red Hili Ave end Srownln. Ave 7176 CílyCIPFund 02-999 420,079.00 322,924.75 0.00 0.00 0.00 7176 MeasuraMTumbackFund 09-999 200,000.00 200,000.31 0.00 0.00 0.00 7176 Gas Tax Fund 1()'999 0.00 0.00 0.00 0.00 0.00 620,079.00 622,925.06 0.00 0.00 0.00 Tustin Rançh Road Rehabilitation between 1-5 and BlYan Avenue 7179 CilyCIPFund 02-999 0.00 0.00 0.00 310,000.00 0.00 7179 MeasuraMCompetitíveFundlAHRP 08-999 0.00 0.00 0.00 240,000.00 240,000.00 7179 Gas Tax Fund 1()'999 50,000.00 37,17B.OO 12,822.00 12,822.00 12,822.00 50,000.00 37,178.00 12,822.00 562,822.00 252,822.00 Tustin Ranch Road Rehabilitation - Walnut Ave and 1-5 7180 CilyCIPFund 02.999 0.00 0.00 0.00 330,000.00 30,000.00 7180 MeasuraMCompetmveFundlAHRP 08-999 0.00 0.00 0.00 270,000.00 270,000.00 7180 Gas Tax Fund 1().999 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 600,000.00 300,000.00 Irvine Blvd Rehabilitation 8etween Rançhwood Rd and Jamboree Rd 7181 Gas Tax Fund 1().999 0.00 0.00 0.00 100,000.00 100,000.00 0.00 0.00 0.00 100,000.00 100,000.00 Jamboree Rd Rehab between IlYlne Blvd and Petera Canvon Wash Sridae 7182 MeasuraMTumbackFund 09-999 0.00 0.00 0.00 80,000.00 80,000.00 0.00 0.00 0.00 80,000.00 80,000.00 Jamboree Rd Rehab - Peters Canvon Wash Srid.. and Portala Parkwav 7183 MeasuraMTumbackFund 09.999 0.00 0.00 0.00 70,000.00 70,000.00 0.00 0.00 0.00 70,000.00 70,000.00 Jamboree Rd Rehab between PorIoie Pkwv and 13501... NIO of Tustin Ranch Rd 7184 MessuraMTumbackFund 09-999 0.00 0.00 0.00 80,000.00 60,000.00 0.00 0.00 0.00 80,000.00 60,000.00 Svcamore Avenue Sidewalk Enhancement 7185 COBG Fund 26-999 0.00 0.00 0.00 45,000.00 30,000.00 0.00 0.00 0.00 45,000.00 30,000.00 Walnut Avenue Sidewalk Enhancement 7188 CDBGFund 26-999 0.00 0.00 0.00 88,735.00 78,375.00 0.00 0.00 0.00 88,735.00 78,375.00 Wlllla... Street lmorovemeorts 1156001 7187 CDBG Fund 26-999 0.00 0.00 0.00 75,000.00 45,000.00 0.00 0.00 0.00 75,000.00 45,000.00 TOTAL 77,378,605.00 14,446,543.88 62,499,036.97 120,129,003.75 37,929,013.31 29 CIP By Project