Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2004-06-22; City Council; Resolution 2004-195
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 Exhibit 4 RESOLUTION NO. 2004-195 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF CARLSBAD, CALIFORNIA, ADOPTING THE FINAL OPERATING BUDGET AND CAPITAL IMPROVEMENT OF CARLSBAD AND ESTABLISHING CONTROLS ON CHANGES IN APPROPRIATIONS FOR THE VARIOUS FUNDS. PROGRAM FOR THE FISCAL YEAR 2004-05 FOR THE CITY WHEREAS, the City Council of the City of Carlsbad, California has reviewed the proposed final Operating Budget and Capital Improvement Program for fiscal year 2004-05 and has held such public hearings as are necessary prior to adoption of the final budgets. WHEREAS, the Planning Commission made a finding of General Plan Consistency for all projects receiving an allocation of funds for fiscal year 2004-05 on May 5, 2004 pursuant to Planning Commission Resolution No. 5600. NOW, THEREFORE, BE IT RESOLVED, by the City Council of the City of Carlsbad, California, as follows: 1. That certain documents now on file in the office of the City Clerk of the City of Carlsbad entitled, “City of Carlsbad, 2004-05 Operating Budget and 2004-05 to Buildout Capital Improvement Program - Preliminary” as amended in accordance with Exhibits A through C attached hereto and incorporated by reference herein, is hereby adopted as the Operating and Capital Improvement Budgets for the City of Carlsbad for the fiscal year. 2. That the amounts reflected as estimated revenues for fiscal year 2004-05 as shown in Exhibits A and B are hereby adopted as the budgeted revenues for 2004-05. 3. That the amounts designated as the 2004-05 Budget request in Exhibits A and B are hereby appropriated to the department or fund for which they are designated, and such appropriation shall not be increased except as provided herein. 4. That total appropriations for each fund may only be increased or decreased by the City Council by passage of a resolution amending the budget except as provided herein. 5. That the following controls are hereby placed on the use and transfers of budget funds: Page 2 of Resolution # 2004-195 Exhibit 4 A. No expenditure of funds shall be authorized unless sufficient funds have been appropriated by the City Council or City Manager as described below. i. The City Manager may authorize all transfers of funds from account to account within any department. ii. The City Manager may authorize transfers of funds between departments within the same fund in an amount up to $1 00,000 per transfer. iii. The City Manager may delegate the authority to make budget transfers and adjustments. iv. The City Manager may authorize budget adjustments involving offsetting revenues and expenditures; the City Manager may authorize increases in an appropriation for a specific purpose where the appropriation is offset by unbudgeted revenue, which is designated for said specific purpose. v. The City Manager may authorize budget adjustments to increase the appropriations for the Sanitation Fund operating budget in an amount equal to the increases in costs of Carlsbad’s share of the Encina Wastewater Authority’s budget, as approved by the EWA Board. vi. The City Manager may authorize budget adjustments to increase the appropriations for Workers Compensation and liability funds operating budget in an amount equal to the increases in costs of claims expenses. vii.The City Council must authorize all transfers of funds from the budgeted Contingency Account. B. The City Manager may authorize emergency out of state travel for public safety or emergency services purposes. C.The City Council must authorize any increase in the number of authorized permanent personnel positions above the level identified in Exhibit C. D. The City Manager may authorize the hiring of temporary or part time staff as necessary, within the limits imposed by the controls listed above. 6. That the legal level of budgetary control is the fund level. Budgets may not legally be 37 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 I9 20 2Y 22 23 24 25 26 27 28 Page 3 of Resolution # 2004-195 Exhibit 4 exceeded at the fund level without appropriate authorization by the City Council. 7. That all appropriations for Capital Improvement Projects remaining unexpended at June 30,2004, are hereby appropriated for such capital projects for the 2004-05 fiscal year. 8. That interest earned on grants may be appropriated during the year and all appropriations for grants remaining unexpended at June 30, 2004, are hereby appropriated for the 2004-05 fiscal year. 9. That all appropriations in the Operating Budget remaining unexpended at June 30, 2004, are hereby appropriated to the 2004-05 fiscal year Operating Budget. 10. That all appropriations for outstanding encumbrances as of June 30, 2004, are hereby continued into 2004-05 for such contracts or obligations. PASSED, APPROVED AND ADOPTED at a regular meeting of the Carlsbad City Council held on the 22nd day of June ,2004 by the following vote, to wit: AYES: Council Members Lewis, Finnila, Kulchin, Hall and Packard NOES: None ABSENT: None " (SEAL) CITY OF CARLSBAD OPERATING FUNDS PROJECTED FUND BALANCES EXHIBIT A PROJECTED UNRESERVED BALANCE ESTIMATED ESTIMATED FUND BALANCE JUNE 30,2004 FUND JULY 1,2003 REVENUES EXPENDITURES TRANSFERS GENERAL FUND I SPECIAL REVENUE POLICE ASSET FORFEITURE COPS GRANT POLICE GRANTS HOUSING SECTION 8 HOUSING TRUST FUND LIBRARY ENDOWMENT FUND LIBRARY GIFWBEQUESTS TREE MAINTENANCE MEDIAN MAINTENANCE STREET LIGHTING BUENA VISTA CRK CHNL MNT LLD #2 ARTS SPECIAL EVENTS RECREATION DONATIONS SENIOR DONATIONS CDBG ENTITLEMENT COMMUNITY ACTIVITY GRANTS CULTURAL ARTS PROGRAM SISTER CITY DONATIONS ARTS GENERAUGALLERY DONATIONS 61,447,666 594,639 180,190 137,538 414,501 4,231,427 26,279 1 16,094 875.691 (68,072) 1,103.1 54 893,628 14,172 51,090 57,123 178,469 0 1,057,579 231,214 5,331 94.223 TOTAL 10,194,270 ENTERPRISE 1 WATER OPERATIONS 12,453,950 RECYCLED WATER OPERATIONS 1,633,871 SANITATION OPERATIONS 5,399,577 SOLID WASTE MANAGEMENT 4,951,124 GOLF COURSE 1,029,856 TOTAL 25.468.378 INTERNAL SERVICE I WORKERS COMP SELF INSURANCE 1.21 1,510 RISK MANAGEMENT 2,022,498 HEALTH INSURANCE 1,084,542 RECORDS MANAGEMENT (2) 91,293 VEHICLE MAINTENANCE 388,509 VEHICLE REPLACEMENT 6,317,425 INFORMATION TECHNOLOGY 2,960,223 TOTAL 14,076,000 REDEVELOPMENT I VILLAGE OPERATIONS / DEBT SVC 1,104,246 VILLAGE LOW/MOD INCOME HOUSING 1,685,412 SCCRA OPERATIONS / DEBT SVC (739,151) SCCRA LOWIMOD INCOME HOUSING 144.230 TOTAL 2,194,737 91,216,000 155,000 140,000 50,000 5,492,000 3,367,750 8,650 115,000 616.408 459,096 923,460 28,027 600 28.000 3,600 29,000 765,461 32,000 7,150 750 10.000 79,118.066 230,000 230,000 130,000 5,873,505 246,774 12,000 115,000 644.815 461,100 1,002,093 70.600 16,000 50,000 10,000 20,000 765,461 50,000 20,000 0 1 .ooo 12,231,952 21.640.700 2,090,700 6,604,500 1,657,900 75,000 32,468,800 3,325,000 720,000 920,000 958,000 1,786.000 1,675,000 4,479,500 13,863,500 1,797,978 537,000 735,273 242,924 3,313,175 9.950.348 20,827,346 2,038,893 7,732.819 1.31 1,085 233,510 32,143,653 2,596,429 1,495,051 1,521,636 958,945 1,816,783 828,000 5,475,520 14,692,364 1,546.043 51,300 347,964 24,000 1,969,307 73.91 6.1 48 370.548 519,639 90,190 57,538 32,996 7,350,403 22,929 116,094 847.284 (70,076) 1,024,521 851,055 (1,228) 29,090 50,723 167,469 0 39,579 218.364 6.081 103,223 11.475,874 8,900 6,400 13,276,204 1,685,678 4,477,658 5,497,939 871.346 25.808.625 1,940,081 1.247.447 482,906 (90,346) 0 357,726 27,089 4,500 770.503 4,825,752 (300,000) 1,056,181 2,171.1 12 (351,842) 363.154 3.238.605 TOTAL OPERATING FUNDS $1 13,381,051 $153,093,427 $1 37,873,738 $0 $0 $1 19,265,204 EXHIBIT A CITY OF CARLSBAD OPERATING FUNDS PROJECTEDFUNDBALANCES PROJECTED PROJECTED BALANCE ESTIMATED PRELIMINARY FUND RESERVED BALANCE FUND JULY 1,2004 REVENUES BUDGET TRANSFERS BALANCES JUNE 30,2005 GENERAL FUND I SPECIAL REVENUE I POLICE ASSET FORFEITURE COPS GRANT POLICE GRANTS HOUSING SECTION 8 HOUSING TRUST FUND LIBRARY ENDOWMENT FUND LIBRARY GIFTS/BEQUESTS TREE MAINTENANCE MEDIAN MAINTENANCE STREET LIGHTING BUENA VISTA CRK CHNL MNT LLD #2 ARTS SPECIAL EVENTS RECREATION DONATIONS SENIOR DONATIONS CDBG ENTITLEMENT COMMUNITY ACTIVITY GRANTS CULTURAL ARTS PROGRAM SISTER CITY DONATIONS 73,916,148 519,639 90,190 57.538 32,996 7,350,403 22,929 116,094 847.284 (70,076) 1.024.521 851,055 (1,228) 29,090 50,723 187.469 0 39,579 218.364 6,081 ARTS GENERAL DONATIONS 103,223 TOTAL 11,475,874 ]ENTERPRISE WATER OPERATIONS 13,276,204 RECYCLED WATER OPERATIONS 1,685,678 SANITATION OPERATIONS 4.477.658 SOLID WASTE MANAGEMENT 5,497,939 GOLF COURSE 871.346 TOTAL 25808.825 INTERNAL SERVICE WORKERS COMP SELF INSUR 1,940,081 RISK MANAGEMENT 1,247.447 HEALTH INSURANCE 482.906 RECORDS MANAGEMENT (2) 0 VEHICLE MAINTENANCE 357,726 VEHICLE REPLACEMENT 27,089 INFORMATION TECHNOLOGY 770,503 TOTAL 4,825.752 IREDEVELOPMENT VILLAGE OPERATIONS / DEBT SVC 1,056,181 VILLAGE LOW/MOD INCOME HOUSING 2,171,112 SCCRA OPERATIONS / DEBT SVC (351.842) SCCRA LOW/MOD INCOME HOUSING 363,154 TOTAL 3.238.605 96,076,000 70,000 145,000 0 6,056,728 462,750 8,ooo 76,000 582,068 435,794 899.371 130.000 73,200 35.000 10,m 20,000 688.1 11 30,000 7.000 200 13,000 9,742,222 20.980.820 2,320,000 6,961,800 2,426,000 75,000 32,763,620 - 2,020.000 1,240.000 905,700 0 1,709,076 1,780,911 4,244,400 11.900.087 ~ 1,936,055 526.000 936.497 310,833 3,709.385 90,464,488 57.000 233,710 0 6,042,631 256,983 12,m 0 742.682 701,469 985,400 171.800 28,205 45,596 8.700 0 688,111 50,000 15,000 3.400 14,000 10,056,687 20,945,004 1.730.385 8,859,054 1,784,312 230.000 31,548.755 2,223,498 1.494.712 1.013.268 0 1,889.696 1,808.ooo 5,010,367 13,439,541 1,530,922 117,005 435.526 54,293 2,137,746 (335,751) 79,191,909 532.639 1.480 57.538 47.093 7,556,170 18.929 192,094 686,670 0 938,492 809.255 43.767 18.494 52,023 207,469 0 19,579 210,364 2,881 102,223 11.497.160 13,312,020 2,275,293 4,560,404 6,139,627 716,346 27,023,690 (3,135,000) (1,398.41 7) (743,493) 249,242 375,338 0 177,106 (7.1 37,336) 0 (1.198.200) 4.536 (592,195) 1,461.314 2,580.107 149,129 619,694 4,810.244 TOTAL OPERATING FUNDS $119,265,204 $154.191.314 $1 47,647,217 $0 $121,930308 EXHIBIT A ACTUAL PROJECTED REVENUE REVENUE REVENUE SOURCE 2002-03 2003-04 CITY OF CARLSBAD OPERATING FUNDS REVENUE ESTIMATES ESTIMATED REVENUE 2004-05 GENERAL FUND 1 TAXES PROPERTY TAX $24,973,532 $26,800,000 SALES TAX TRANSIENT TAX FRANCHISE TAX BUSINESS LICENSE TAX TRANSFERTAX TOTAL TAXES INTERGOVERNMENTAL VEHICLE LICENSE FEES OTHER TOTAL INTERGOVERNMENTAL 25,542,844 25,080,000 8,387,388 8,800,000 3,729,713 5,003,000 2,305,178 2,900,000 1,126,804 1,200,000 66,065,459 69,783,000 5,066,902 4,050,000 1,562.21 5 1,318,000 6,629,117 5,368.000 LICENSES AND PERMITS BUILDING PERMITS 986.890 1 ,000.000 OTHER LICENSES & PERMITS 1,055,639 1.000,ooo TOTAL LICENSES & PERMITS 2,042,529 2,000.000 CHARGES FOR SERVICES PLANNING FEES 1,029.582 600,000 BUILDING DEPT. FEES 707,691 775,000 ENGINEERING FEES 2,220,695 1,800,000 AMBULANCE FEES 1,316,956 1,440,000 RECREATION FEES 1,440,530 1,310,000 993,896 1,000,000 OTHER CHARGES OR FEES TOTAL CHARGES FOR SERVICES 7,709,350 6,925,000 FINES AND FORFEITURES 860,692 930,000 INCOME FROM INVESTMENTS AND PROPERTY' 4,483,932 2,910,000 1NTERDEPARTMENTAL CHARGES 2,686,817 2,600,000 OTHERREVENUESOURCES 650,339 700,000 $28,156,000 26,410,000 9,220,000 4,670,000 2,900,ooo 1,230,000 72,586,000 5,080,000 1,140,000 6,220,000 1,440,000 1,440,000 2,880,000 600,000 1,120,000 1,500,000 1,500,000 1,340,000 1,020,000 7,080,000 950,000 2,910,000 2.700.000 750,000 I-- TOTAL GENERAL FUND 91.128.235 91,216,000 I 96,076,000 * Interest is calculated on an amortized cost basis. AS % DIFFERENCE OF FY 03-04 2003-04 TO PROJECTED 2004-05 5.1% 1,356,000 5.3% 1,330,000 4.8% 420,000 -6.7% (333,000) 0.0% 0 2.5% 30,000 4.0% 2,803,000 25.4% 1,030,000 -13.5% (178,000) 15.9% 852.000 44.0% 440,000 44.0% 440,000 44.0% 880,000 0.0% 0 44.5% 345,000 -16.7% (300,000) 4.2% 60,000 2.3% 30,000 2.0% 20,000 2.2% 155,000 2.2% 20,000 0.0% 0 3.9% 100,000 7.1% 50,000 5.3% 4,860,000 EXHIBIT A ESTIMATED REVENUE 2004-05 CITY OF CARLSBAD OPERATING FUNDS REVENUE ESTIMATES AS % DIFFERENCE OF FY 03-04 2003-04 TO PROJECTED 2004-05 ACTUAL PROJECTED REVENUE REVENUE REVENUE SOURCE 2002-03 2003-04 /SPECIAL REVENUE FUNDS I POLICE ASSET FORFEITURE ASSET FORFEITURES 62,376 INTEREST 27,000 TOTAL 89,376 130,000 25,000 155,000 50,000 -61.5% (80,000) -20.0% (5,000) -54.8% (85,000) COPS GRANT STATE FUNDING (AB3229) 174,795 135,000 5,000 140,000 140,000 3.7% 5,000 0.0% 0 3.6% 5,000 INTEREST TOTAL 7.462 182,257 POLICE GRANTS STATE GRANT 80,931 INTEREST 7,084 TOTAL 88,015 45,000 5,000 50.000 -100.0% (45,000) -100.0% (5.000) -100.0% (50,000) - HOUSING - SECTION 8 INTEREST FEDERAL GRANT TOTAL 2,659 5,084,652 5,087,311 12,000 5,480,000 5,492,000 -16.7% (2.000) 10.3% 566,728 10.3% 564.728 6,056,728 239,000 223,750 HOUSING TRUST FUND INTEREST 620,397 AFFORDABLE HOUSING FEES 647,355 OTHER 454,024 TOTAL 1,721,776 210,500 415,550 2,741,700 3,367,750 13.5% 28,500 -46.2% (191,800) -1 00.0% (2,741,700) (2,905,000) -86.3% 462,750 7 LIBRARY ENDOWMENT FUND INTEREST 12.591 8,650 8.650 8,000 8,000 71,000 76,000 TOTAL 12,591 LIBRARY GIFTEYBEQUESTS GI FTS/BEQUESTS 5,821 INTEREST 72,045 TOTAL 77,866 50,000 65,000 1 15,000 -90.0% (45,000) 9.2% 6.000 -33.9% (39,000) EXHIBIT A CITY OF CARLSBAD OPERATING FUNDS REVENUE ESTIMATES ACTUAL PROJECTED REVENUE REVENUE REVENUE SOURCE 2002-03 2003-04 ESTIMATED REVENUE 2004-05 AS % DIFFERENCE OF FY 03-04 2003-04 TO PROJECTED 2004-05 TREE MAINTENANCE INTEREST TREE MAINTENANCE FEES INTERDEPARTMENTAL TOTAL 40,638 28,000 28,000 448.068 106.000 0.0% 0 -1 0.1 % (50,340) 17.8% 16,000 -5.6% (34,340) 502,628 90,Ooo 633,266 498,408 90,Ooo 616,408 582,068 MEDIAN MAINTENANCE INTEREST MEDIAN MAINTENANCE FEES OTHER TOTAL 0 451,869 n 0.0% 0 0 459,096 0 459,096 0 41 1,297 24,497 435,794 -1 0.4% (47,799) 0.0% 24,497 -5.1% (23,302) 451.869 STREET LIGHTING INTEREST INTERDEPARTMENTAL STREET LIGHTING FEES TOTAL 49,010 38,590 794,178 881,778 36,400 38,500 848,560 923,460 31,000 28,000 840,371 899,371 -14.8% (5,400) -27.3% (1 0,500) -1 .O% (8,189) -2.6% (24,089) BUENA VISTA CREEK CHNL MAlNT INTEREST BUENA VISTA FEES TOTAL 40,235 99,997 140,232 28,000 27 30,000 100,Ooo 130,000 7.1% 2.000 370270.4% 99,973 363.8% 101,973 28,027 LLD #2 INTEREST LLD #2 FEES TOTAL 150.0% 0.0% 900 71.700 600 0 600 1,500 71,700 73,200 . -- 121 00.0% 72,600 ARTS SPECIAL EVENTS INTEREST DONATIONS TOTAL 2,769 25.700 2,500 25.500 3,000 32,000 35,000 20.0% 500 25.5% 6,500 25.0% 7,000 28,469 28,000 RECREATION DONATIONS INTEREST DONATIONS TOTAL 2,532 15,374 3,000 600 3,000 7,000 10,000 0.0% 0 0.0% 6,400 177.8% 6,400 17,906 3,600 - EXHIBIT A CITY OF CARLSBAD OPERATING FUNDS REVENUE ESTIMATES ACTUAL PROJECTED REVENUE REVENUE REVENUE SOURCE 2002-03 2003-04 SENIOR DONATIONS INTEREST 8,379 5,000 DONATIONS 18,766 24.000 OTHER 190 0 TOTAL 27,355 29,000 CDBG ENTITLEMENT INTEREST 32,906 30,000 GRANT REVENUE 791,094 735,461 TOTAL 824,000 765,461 COMMUNITY ACTIVITY GRANTS OPERATING TRANSFER IN 25,000 0 INTEREST 47,706 32,000 TOTAL 72,706 32,000 CULTURAL ARTS PROGRAM INTEREST 10,495 7,150 TOTAL 10,495 7,150 ~~ ARTS GENERAUGALLERY DONATIONS INTEREST 4,511 3,000 DONATIONS 16,439 7,000 TOTAL 20,950 10,000 ARTS GENERAUGALLERY DONATIONS INTEREST 4,511 3,000 DONATIONS TOTAL 16.439 7.000 ,... -. - 20,950 10,000 SISTER CITY DONATIONS INTER EST 235 250 DONATIONS 500 500 OTHER 0 0 TOTAL 735 750 10,368,953 12,231,952 TOTAL SPECIAL REVENUE FUNDS ESTIMATED AS % DIFFERENCE REVENUE OF FY 03-04 2003-04 TO 5,000 15,000 -7 30,000 688,111 -i 30,000 30,000 7,000 7,000 3,000 10,000 13,000 0.0% 0 -37.5% (9,000) 0.0% 0 -31 .O% (9,000) 0.0% 0 -10.5% (77,350) -1 0.1 % (77,350) 0.0% 0 -6.3% (2,000) -6.3% (2,000) -2.1% (1501 I --I 0.0% 0 42.9% 3.000 30.0% 3,000 -20.0% -1 00.0% 0.0% .. . 9,742,222 I -20.4% (2,489,730) EXHIBIT A CITY OF CARLSBAD OPERATING FUNDS REVENUE ESTIMATES ACTUAL PROJECTED REVENUE REVENUE REVENUE SOURCE 2002-03 2003-04 ENTERPRISE FUNDS I WATER OPERATIONS WATER SALES 13,081,345 13,377,000 READY TO SERVE CHARGES 3,705,974 3,786,000 PROPERTY TAXES 1,697,040 1,782,000 NEW ACCOUNT CHARGES 103,430 103,000 BACK-FLOW PROGRAM FEES 105,390 109,000 PENALTY FEES 260,709 200,000 INTEREST 744,491 689,000 ENGINEERING & PLAN CHECK FEES 3,510 3,500 ENGINEERING OVERHEAD 31 8,987 329,000 SERVICE CONNECTION FEES 140,885 140,000 AGRICULTURAL CREDITS 153,647 153,200 OTHER 787,507 969,000 TOTAL 21,102,915 21,640.700 RECYCLED WATER WATER SALES 1,090,230 1,200,000 READY-TO-SERVE CHARGE 86.223 85,700 RECYCLED WATER CREDITS 342,055 425,000 INTEREST OTHER TOTAL 652,908 365,000 10,297 15,000 2,181,713 2,090,700 SANITATION OPERATIONS SERVICE CHARGES 6,177,845 6,200,000 MlSC SEWER 43.814 54,500 ENGINEERING OVERHEAD 257,590 230,000 PENALTY FEES 64,557 55,000 INTEREST 324,892 250,000 OTHER 129,206 15,000 TOTAL 6,997,906 6,804,500 SOLID WASTE MANAGEMENT INTEREST 220,565 206,000 RECYCLING FEES (AB939) 240,463 240,000 PENALTY FEES 41,296 40,000 NONJURISDICTIONAL FEES 586,574 600,000 STATE GRANT 57,861 51,900 TRASH SURCHARGE OTHER TOTAL GOLF COURSE 0 720,000 7,851 0 1,154,610 1,857,900 TRANSFER FROM GENERAL FUND 600,000 INTEREST TOTAL 0 125,230 75,000 725,230 75,000 TOTAL ENTERPRISE FUNDS 32,162,374 32,468.800 ESTIMATED REVENUE 2004-05 13,387.000 3,868.000 1,871 ,OOO 100,000 11 1,000 175,000 771,920 3,500 338,000 137,000 147,000 71.400 20,980,820 1,340,000 102,000 578,000 300,000 0 2,320,000 6,334,000 55,600 236,900 56,000 264,000 15,300 6,961,800 210,000 235,000 40,000 614,000 27,000 1,300,000 0 2,426,000 0 75,000 75,000 32,763,620 DIFFERENCE 2003-04 TO 2004-05 AS % OF FY 03-04 PROJECTED 0.1 % 10,000 2.2% 82,000 5.0% 89,000 -2.9% (3.000) 1.8% 2,000 -12.5% (25,000) 12.0% 82,920 0.0% 0 2.7% 9,000 -2.1% (3.000) -4.1% (6,200) -92.6% (897.600) -3.1% (659,880) 1 1.7% 140,000 19.0% 16,300 36.0% 153,000 -17.8% (65,000) -1 00.0% (15,000) 11 .ova 229,300 2.2% 134,000 2.0% 1,100 3.0% 6,900 1 3% 1,000 5.6% 14,000 2.0% 300 2.3% 157.300 1.9% 4,000 -2.1% (5,000) 0.0% 0 2.3% 14,000 -48.0% (24,900) 80.6% 580,000 0.0% 0 .. 30.6% 568,100 0.0% 0 0.0% 0 0 0 0.9% 294,820 EXHIBIT A ACTUAL PROJECTED REVENUE REVENUE REVENUE SOURCE 2002-03 2003-04 IINTERNAL SERVICE FUNDS I CITY OF CARLSBAD OPERATING FUNDS REVENUE ESTIMATES ESTIMATED REVENUE 2004-05 AS % DIFFERENCE OF FY 03-04 2003-04 TO PROJECTED 2004-05 WORKERS COMP SELF-INSURANCE INTEREST INTERDEPARTMENTAL OTHER (OP TRANS IN) TOTAL 2.000,00( 2,020.00c F 1,200.00( 56,154 600,231 16,276 672.661 20,000 750,000 2,555,000 3,325,000 0.0% 0 166.7% 1,250,000 -100.0% (2,555,000) (1,305,000) -39.3% LIABILITY SELF-INSURANCE INTEREST INTERDEPARTMENTAL OTHER TOTAL 99,833 603,009 34,214 737,056 60,000 650,000 10,000 720,000 -33.3% ~20,000) -100.0% (10,000) 84.6% 550,000 72.2% 520,000 1,240,OOC F HEALTH INSURANCE INTEREST INTERDEPARTMENTAUREIMB. TOTAL 49,365 2,994,636 3.044.001 30,000 890,000 920,000 30,OOC 0.0% 0 -1 6% -100.0% -1 6% (14,300) RECORDS MANAGEMENT (2) INTEREST INTERDEPARTMENTAL OTHER TOTAL p 25 1,030,400 613 2,500 955,500 0 -1 00.0% (2,500) -100.0% (955,500) 0.0% 0 -100.0% (958,000) 1,031,037 958,000 VEHICLE MAINTENANCE INTERDEPARTMENTAL INTER EST OTHER TOTAL 1,466,615 17,840 100.569 1,675,000 11,000 100,000 1,786,000 1,699,076 10,000 0 1,709,076 1,580,911 200,000 0 1,780,911 100,000 4,144,400 0 4,244,400 1.4% 24,076 -9.1% (1,000) -1 00.0% (100,000) -107.7% (76,924) 1,565,024 VEHICLE REPLACEMENT INTERDEPARTMENTAL INTEREST OTHER TOTAL 1,429,945 1,467,000 208,000 0 1,675,000 7.8% 113,911 -3.9% (8,000) 0.0% 0 6.3% 105,911 295,315 137,313 1,862,573 INFORMATION TECHNOLOGY INTEREST INTERDEPARTMENTAL OPERATING TRANSFER IN TOTAL 139,208 3,896,817 589 11 5,000 3,601,500 563,000 4,479,500 -1 3.0% (15.000) 9.0% 342.900 -100.0% (563,000) -5.3% (235,100) 4,036,594 TOTAL INTERNAL SERVICE FUNDS 12,968,946 13,863,500 I 11,900,087 -14.2% (1,963,413) EXHIBIT A CITY OF CARLSBAD OPERATING FUNDS REVENUE ESTIMATES ACTUAL PROJECTED REVENUE REVENUE REVENUE SOURCE 2002-03 2003-04 IREDEVELOPMENT FUNDS VILLAGE OPERATIONS I DEBT SERVICE RENTAL INCOME TAX INCREMENT ADMINISTRATIVE FEES INTEREST OTHER OPERATING TRANSFER IN TOTAL VILLAGE LOW AND MOD INCOME HSNG TAX INCREMENT INTEREST OTHER TOTAL SCCRA OPERATIONS/ DEBT SERVICE TAX INCREMENT INTEREST OPERATING TRANSFER IN TOTAL SCCRA LOW AND MOD INCOME HSNG TAX INCREMENT INTEREST TOTAL 1 14,388 1,594.51 1 0 61,462 273,906 0 1,944,267 398,628 133,502 n 532.1 30 130,955 19,476 0 150,431 43,652 6,847 43,652 45,755 1,692,000 0 56,800 3,623 n 1,797.978 444,000 93,000 n 537,000 712,273 23,000 0 735,273 237,424 5.500 242,924 TOTAL REDEVELOPMENT FUNDS 2,670,460 3,313,175 ESTIMATED REVENUE 2004-05 83,055 1,776,000 0 73,000 4.000 0 1,936,055 466,000 60,000 n 526,000 91 1,497 25,000 0 936,497 303.833 7,000 310,833 3,709,385 AS % DIFFERENCE OF FY 03-04 2003-04 TO PROJECTED 2004-05 81.5% 37,300 5.0% 84,000 0.0% 0 29.0% 16,400 10.4% 377 0.0% 0 7.1% 138,077 5.0% 22,000 -35.5% (33,000) 0.0% 0 -2.1% (1 1,000) 28.0% 199,224 8,756 2,000 0.0% 0 0 201,224 28.0% 66,409 27.3% 1,500 28.0% 67,909 12.0% 396,210 TOTAL OPERATING $1 49,298,988 $1 53,093,427 $154,191,314 0.7% $ 1,097,887 I EXHIBIT A CITY OF CARLSBAD OPERATING FUNDS BUDGET EXPENDITURE SCHEDULE 2003-04 2003-04 2001-02 2002-03 ESTIMATED ADOPTED DEPARTMENT ACTUALS ACTUALS EXPENDITURES (1) BUDGET GENERAL FUND POLICY AND LEADERSHIP GROUP CITY COUNCIL 272,275 CITY MANAGER 1,080,772 COMMUNICATIONS 246,248 CITY CLERK 280,226 CITY ATTORNEY 939,657 CITY TREASURER 114,341 TOTAL POLICY/LEADERSHIP GROUP 2,933,519 ADMINISTRATIVE SERVICES ADMINISTRATION 386,758 FINANCE 2.1 57,099 HUMAN RESOURCES 1,461,503 RECORDS MANAGEMENT (2) 0 TOTAL ADMINISTRATIVE SERVICES 4,005,360 PUBLIC SAFETY POLICE 14,957,749 FIRE 10,293,823 TOTAL PUBLIC SAFETY 25,251,572 COMMUNITY DEVELOPMENT COMMUNITY DEVEL ADMlN 329,304 GEOGRAPHIC INFORMATION 273,199 ECONOMIC DEVELOPMENT 226,252 PLANNING 2,813,766 BUILDING 1.766.613 273,211 1,023,959 472.185 290,790 880,954 138.M)6 3.079.705 561,949 2,434.191 1,336,418 0 4.332.558 15,994,680 11,046,901 27,041,581 512,251 260,266 177,090 2,989,663 1.658.872 TOTAL COMMUNITY DEVELOPMENT 5,409,134 COMMUNITY SERVICES LIBRARY 6,936,523 CULTURAL ARTS PROGRAM 554,206 RECREATION 3,994,199 TRAILS MAINTENANCE 0 SENIOR PROGRAMS 401,419 5.598.162 7,454.751 664,406 4,256,322 739 558,141 265.809 305,953 1,192,248 1,162,763 635.888 780.71 1 285,400 309.1 37 950,530 971,382 147,339 168,950 3,477,214 3,698,896 563,763 710.648 2,449,541 2,601,498 1,598,802 2,028,938 0 0 4,612,106 5,341,084 17,515,613 17,646,410 11,924,210 11,595,742 29,439,823 29,242,152 469,7 16 636,600 291,079 31 1,772 182,228 183,735 3,363,521 3,230,939 1,660.987 1,809,656 5,987,531 6,172,702 6,256,927 8,162,232 668,810 711,739 4,535,969 4,611,663 46,185 69,925 511.572 697,114 TOTAL COMMUNITY SERVICES 11,888,347 12,934,359 14,019,463 14,252,673 2004-05 'RELIMINAR) BUDGET 332,40: 1,228,707 810,97C 124,215 1,010,674 161,684 3,668,653 610,743 2,599,435 1,963,055 792.656 5,985,889 19,640,247 13,256,073 33,098,320 528,556 296,850 185,073 3,415,121 1.906.938 6,332,536 8,343,336 691,099 4,934,953 76,269 786.817 14,832,476 7oIlYLK (UCL) 03-04 BUD TO 04-05 BUD 8.8% 5.7% 3.9% -59.8% 4.0% -4.3% -0.8% -14.1% -0.1% -2.3% 12.1% 12.4% 14.3% 13.2% -17.0% -4.8% 0.7% 5.7% 5.4% 2.6% 2.2% -2.9% 7.0% 9.1% 12.9% 4.1% EXHIBIT A CITY OF CARLSBAD OPERATING FUNDS BUDGET EXPENDITURE SCHEDULE ' 2003-04 2003-04 2001-02 2002-03 ESTIMATED ADOPTED DEPARTMENT ACTUALS ACTUALS EXPENDITURES (1) BUDGET PUBLIC WORKS PUBLIC WORKS ADMIN 492,064 757,423 ENGINEERING 4,312,623 5,652,977 FACILITIES MAINTENANCE 2,145,904 2,343,466 PARK MAINTENANCE 2,692,390 3,127,449 STREET MAINTENANCE 2,272,808 2,331,712 TRAFFIC SIGNAL MINT 584.348 502,210 TOTAL PUBLIC WORKS 12,500,137 14,715,239 NON-DEPARTMENTAL COMMUNITY PROMOTION BEACH PARKING COMMUNITY CONTRIBUTIONS HIRING CENTER HOSP GROVE PAYMENT PROPERTY TAX ADMIN FEE DUES 8 SUBSCRIPTIONS MlSC I TRANSFERS OUT ASSESSMENT SERVICES INFRASTRUCTURE REPLACE TRANh GOLF COURSE TRANSFER TRANSFER TO CIP TRANS TO STORM WATER PGM MANAGEMENT INCENTIVE PAY LEGAL SERVICES OTHER TOTAL NON-DEPARTMENTAL SUBTOTAL GENERAL FUND CONTINGENCIES TOTAL GENERAL FUND 308,798 0 65,235 83,400 800,000 285,775 46,386 1,302 13,923 3,000,000 25,000 0 21.840 83,475 800,000 326,069 48,379 24.918 15,121 3,500.000 0 600,000 1,500,000 35,000,000 1,873.19O 0 0 0 0 109,900 17 421 324.443 722,308 800,032 5,963,777 5,210,161 2,625,742 2,803,465 3,130,574 3,532,676 2,540,365 2,611,249 737.087 776.198 0 0 102.000 82.506 800,000 332,000 72,150 563,000 35.400 3,605,000 0 0 0 0 250.000 0 509,100 36,000 0 85,849 800,000 332,000 72,150 563,000 35,400 3,605,000 0 0 1,263,600 575.000 250,000 0 . - . , . . . 7,995,430 40,879,145 5,842,056 8,127,299 69,963,499 108,580,749 79,116,066 82,568,587 0 0 0 2,300,000 69,963,499 108,580,749 79,118,066 84,868,567 2004-05 'RELI MI NAR) BUDGET 869,734 6,262,145 2,967,015 3,557,094 2,496,233 720.991 16,693,212 509,100 36,000 0 85,000 800.000 355,000 72,900 0 35,400 3,830.000 0 800.000 0 580,000 250,000 0 7,353,400 88,164,488 2.300.000 90,464,488 %INCR (DEC) 03-04 BUD TO 04-05 BUD 8.7% 20.2% 6.5% 0.7% 4.4% -7.1% 7.4% 0.0% 0.0% -1.0% 0.0% 6.9% 1 .O% -100.0% 0.0% 6.2% -1 00.0% 0.9% 0.0% -9.5% 6.8% 0.0% 6.6% EXHIBIT A CITY OF CARLSBAD OPERATING FUNDS BUDGET EXPENDITURE SCHEDULE 2003-04 2003-04 2001-02 2002-03 ESTIMATED ADOPTED DEPARTMENT ACTUALS ACTUALS EXPENDITURES (1) BUDGET SPECIAL REVENUE FUNDS I POLICE ASSET FORFEITURE COPS FUND POLICE GRANTS HOUSING SECTION 8 HOUSING TRUST LIBRARY ENDOWMENT FUND LIBRARY GIFTSIBEQUESTS LIBRARY STATE GRANTS TREE MAINTENANCE MEDIAN MAINTENANCE STREET LIGHTING BUENA VISTA CRK CHNL MNT LLD #2 ARTS SPECIAL EVENTS SENIOR NUTRITION (3) SENIOR DONATIONS CDBG ENTITLEMENT COMMUNITY ACTIVITY GRANTS CULTURAL ARTS PROGRAM SISTER CITY DONATIONS ARTS GENIGALLERY DONATIONS RECREATION DONATIONS TOTAL SPECIAL REVENUE FUNDS 5,724 286.734 180.975 3,867,573 185,874 9.875 30,537 0 642,800 533,901 882,780 25,809 0 19,087 207,044 35,557 477,163 57.714 34,144 15 58,120 6,735 7,548,161 ENTERPRISE FUNDS WATER OPERATIONS 18,892,192 RECYCLED WATER OPERATIONS 1,476.399 SANITATION OPERATIONS 6,498,962 SOLID WASTE MANAGEMENT (4) 983,111 GOLF COURSE 168,967 TOTAL ENTERPRISE FUNDS 28,019,631 INTERNAL SERVICE FUNDS I WORKERS COMP SELF INSURANCE 1,093,092 RISK MANAGEMENT 1,373,974 HEALTH INSURANCE 2,464.031 RECORDS MANAGEMENT (2) 969,761 VEHICLE MAINTENANCE 1,640,651 VEHICLE REPLACEMENT 1 ,179,122 INFORMATION TECHNOLOGY 3,631,939 78,210 180,152 190,410 5,019,097 207.488 11,850 80,326 56.248 674,596 536,782 934,503 88,418 0 60,109 0 25,425 805,721 95,355 5,174 0 19,563 16,969 9,086,396 19.038.158 1,552,164 6,248,394 231 1,923 93,341 29,443,984 2.124,381 1,331,903 2.674,714 905,870 1,644,950 1,140,044 4,082,886 230,000 230,000 130,000 5,873,505 248.774 12,000 115,000 0 644.815 461,100 1,002,093 70,600 16,000 50,000 0 20,000 765,461 50,000 20,000 0 1,000 10,000 9,950,348 403,900 182,915 30,000 5,549,702 256,340 6,000 67,620 0 697,979 504,841 1,165,034 1,629 0 36,103 0 0 654,408 60,000 20,000 2,000 13,500 n 9,651,971 20,827,346 20,874.869 2,038,893 1,913.1 17 7,732.819 8,029.909 1,311,085 1,521,511 233,510 300,000 32,143,653 32,639,406 2,596,429 1,327,605 1,495,051 1,505,019 1,521,636 1,521,636 958.945 1,126,466 1,816,783 1,889,420 828.000 873,000 5,475,520 5,461,325 TOTAL INTERNAL SERVICE FUNDS 12,352,570 13,904,748 14,692.364 13,704,471 2004-05 'RELIMINAR' BUDGET 57,OOC 233.71C c 6,042,631 256,983 12,000 0 0 742,682 701,469 985.400 171,800 28,205 45,596 0 0 688,111 50,000 15,000 3,400 14,000 8,700 10,056,687 20,945,004 1,730,385 6,859.054 1,784.312 230.000 31,548,755 2.223,498 1,494,712 1,013,268 0 1.889.696 1.808,ooo 5,010,367 13,439,541 %INCR (DEC) 03-04 BUD TO 04-05 BUD -85.9% 27.8% -100.0% 8.9% 0.3% 100.0% -100.0% 6.4% 38.9% -15.4% 10446.3% 26.3% 0.0% 5.2% -16.7% -25.0% 70.0% 3.7% 4.2% 0.3% -9.6% -14.6% 17.3% -23.3% -3.3% 67.5% -0.7% -33.4% -100.0% 0.0% 107.1% -8.3% -1.9% EXHIBIT A 2004-05 PRELIMINARY BUDGET 1,530,922 117,005 435,526 54,293 2.1 37,746 CITY OF CARLSBAD OPERATING FUNDS BUDGET EXPENDITURE SCHEDULE 03-04 BUD TO 04-05 BUD -2.1% 18.2% 137.3% 42.4% 13.5% 2003-04 2003-04 2001-02 2002-03 ESTIMATED ADOPTED DEPARTMENT ACTUALS ACTUALS EXPENDITURES (I) BUDGET REDEVELOPMENT VILLAGE OPERATIONS I DEBT SVC 2,102,507 2,286,765 1,546,043 1,563,217 VILLAGE LOWlMOD INCOME HSNG 45,170 107,646 51,300 98,948 SCCRA OPERATIONS I DEBT SVC 63,072 168,527 347,964 183,528 SCCRA LOWlMOD INCOME HSNG 19,345 16,496 24,000 38,117 TOTAL REDEVELOPMENT 2,230,094 2,579,434 1,969,307 1,883.810 TOTAL OPERATING FUNDS 120,133,955 163,595,307 137,873,738 142.748,245 147.647,217 3.4% (1) Estimated expenditures may exceed Adopted budget since they include prior year budget carryforwards. (2) Records Management was converted to an Internal Service fund in FY02 and converted back to a General fund in FY05. (3) Senior Nutrition Grant was moved to the General fund in 2002-03. (4) Storm Water Protection Program was converted from a Special Revenue fund to an Enterprise fund during N04. Exhibit B CITY OF CARLSBAD CAPITAL FUNDS PROJECTED FUND BALANCES FOR FY 2003-2004 JULY I, 2003 ESTIMATED JUNE 30,2004 UNRESERVED ESTIMATED ESTIMATED DEBT SERVICE PROJECTED FUND BALANCE REVENUES EXPENDITURES LOANS & OTHER BALANCE ASSESSMENT DISTRICTS BTD#2 - POINSElTIA LANOAVIARA PKWh BTD#3 - CANNON ROAD WEST CFD #I -CITYWIDE CFD #2 - RANCHO SANTA FE ROAD GAS TAX GENERAL CAPITAL CONST. GOLF COURSE GRANTS - FEDERAL GRANTS - STATE INFRASTRUCTURE REPLACEMENT OTHER PARK FEE ZONES 5,13,16 PARK-IN-LIEU NE PARK-IN-LIEU NW PARK-IN-LIEU SE PARK-IN-LIEU SW PLANNED LOCAL DRAIN'G PUBLIC FACILITIES FEE REDEVELOPMENT VILLAGE REDEVELOPMENT SCCRDA SEWER BENEFIT AREAS SEWER CONNECTION SEWER REPLACEMENT TDA TRAFFIC IMPACT FEE TRANSNETBIKE TRANSNET/HIGHWAY TRANSNET/LOCAL TRANSNETKTP WATER - MAJOR FACILITY WATER - RECYCLED WATER 652.205 5,078,146 3,304,294 32,973,206 26,472,040 4,521,749 47,224,449 1,390,000 67,587 31 6,217 10,844,364 2,226,222 71 9,956 1,747,320 1,300,790 1,445,177 667,453 7,951,336 33,992,248 1,397,050 1 ,I 06,000 5,1 54,252 32,266,072 18,972,792 305,389 7,783,846 42,352 1,880,369 8,059,803 358,132 10,093,861 14,725,000 334,300 2,870,247 42,213 5,090,033 10,471,582 2,700,901 1,955,370 0 1,969,499 5,637 4,022,503 43,106 54,092 52,934 582,541 257,875 700,025 1,094,823 5,498,664 0 0 2,039,522 2,450,964 4,236,406 3,240 952,059 698 35,484 3,453,321 6,558 2,600,991 24,427,256 323,968 1,134,518 1,222,341 147,424 27,791,687 713,327 2,620,615 949,406 155,905 0 449,151 50,913 452 25,473 0 0 0 149,156 12,177,050 15,205 5 4,142,920 570,461 1,778,312 0 99,246 20,248 70,131 5.61 9,422 87,082 950,478 15,757,760 218,779 0 1,000,000 331,309 0 0 0 0 0 0 0 0 0 0 704,000 1,000,000 0 0 0 0 0 0 936,256 1,500,000 158,560 0 0 0 0 0 2,030,428 3,862,078 443,758 6,813,875 1,124,166 37,584,506 9,151,935 6,509,323 46,559,204 440,594 1,881,181 321,854 14,417,716 2,218,415 773,596 1,774,781 1,179,331 703,052 1,367,478 8,897,003 27,313,862 1,381,845 1,105,995 3,050,854 33,210,319 19,930,886 150,069 8,636,659 22,802 1,845,722 5,893,702 277,608 9,713,946 19,532,418 WATER - REPLACEMENT 13,050,001 3,536,722 946,106 2,163,790 13,476,827 TOTAL 298,089,678 81,489,565 77,968,762 13,905,200 287,705,281 Exhibit 6 CITY OF CARLSBAD CAPITAL FUNDS PROJECTED FUND BALANCES FOR PI 2004-2005 JULY 1,2004 PROJECTED ESTIMATED FUND BALANCE REVENUES ASSESSMENT DISTRICTS BTD#2 - POINSETTIA LANE/AVIARA PKWY BTD#3 - CANNON ROAD WEST CFD #1 - CITYWIDE CFD #2 - RANCHO SANTA FE ROAD GAS TAX GENERAL CAPITAL CONST. GOLF COURSE GRANTS - FEDERAL GRANTS - STATE INFRASTRUCTURE REPLACEMENT OTHER PARK FEE ZONES 5,13,16 PARK-IN-LIEU NE PARK-IN-LIEU NW PARK-IN-LIEU SE PARK-IN-LIEU SW PLANNED LOCAL DRAIN'G PUBLIC FACILITIES FEE REDEVELOPMENT VILLAGE REDEVELOPMENT SCCRDA SEWER BENEFIT AREAS SEWER CONNECTION SEWER REPLACEMENT TDA TRAFFIC IMPACT FEE TRANSNET/BlKE TRANSNET/HlGHWAY TRANSNET/LOCAL TRANSNETKTP WATER - MAJOR FACILITY WATER - RECYCLED WATER 443,758 6,813,875 1,124,166 37,584,506 9,151,935 6,509,323 46,559,204 440,594 1,881,181 321,854 14,417.71 6 2,218,415 773,596 1,774,781 1,179,331 703,052 1,367,478 8,897,003 27,313,862 1,381,845 1,105,995 3,050,854 33,210,319 19,930,886 150,069 8,636,659 22,802 1,845,722 5,893,702 277,608 9,713,946 19,532,418 0 2,148,660 0 7,336,242 28,781 2,519,687 2,430,854 0 1,870,000 0 3,713,150 986,854 85,364 459,985 151,235 491,095 461,097 1,951,925 5,903,080 0 0 71 6,106 1,818,348 2,200,000 0 1,395,075 120,000 0 3,019,678 0 2,855,013 6,792,997 WATER - REPLACEMENT 13,476,827 2,396,860 TOTAL 287,705,281 51,852,086 2003-2004 CONTINUING NEW APPROPR. APPROPR. 357,751 1,397,831 30,177 64,895 7,510,696 4,206,837 3,537,986 90,205 1,866,004 0 669,905 451,693 0 1,660,251 0 0 216,005 4,619,040 22,923,882 1,845 254,995 1,786,616 7,512,096 10,094,863 0 2,414,634 21,137 1,753,831 3,918,699 220,749 4,593,610 16,545,052 0 1,190,000 925,000 210,000 0 805,000 9,033,800 350,000 1,870,000 35,000 1,037.000 1,041,854 0 0 0 0 550.000 1,365,524 6,158,308 1,380,000 851,000 0 12,309,941 2,406,014 0 1,937,708 120,000 0 3,963,000 0 853,500 159,527 7,550,802 3,960,488 106,272,087 52,512,664 2004-2005 TOTAL CIP APPROPR. 357,751 2,587,831 955,177 274,895 7,510,696 5,011,837 12,571,786 440,205 3,736,004 35,000 1,706,905 1,493,547 0 1,660,251 0 0 766,005 5,984,564 29,082,190 1,381,845 1,105,995 1,786,616 19,822,037 12,500,877 0 4,352,342 141,137 1,753,831 7,881,699 220,749 5,447,110 16,704,579 11,511,290 158,784,751 JUNE 30,2005 PROJECTED BALANCE 86,007 6,374,704 168,989 44,645,853 1,670,020 4,017,173 36,418,272 389 15,177 286,854 16,423,961 1,711,722 858,960 574,515 1,330,566 1,194,147 1,062,571 4,864,364 4,134,752 0 0 1,980,344 15,206,630 9,630,009 150,069 5,679,391 1,665 91.891 1,031,681 56,859 7,121,848 9,620,836 4,362,397 180,772,616 53 Exhibit B CITY OF CARLSBAD CAPITAL FUNDS REVENUES ACTUAL AND ESTIMATED 2000-2001 2001 -2002 2002-2003 2003-2004 2004-2005 ACTUAL ACTUAL ACTUAL ESTIMATED ESTIMATED FUND REVENUES REVENUE REVENUE REVENUE REVENUE ASSESSMENT DISTRICTS BTD#2 - POINSETTIA LANVAVIARA PKWY BTD#3 - CANNON ROAD WEST CFD #1 - CITYWIDE CFD #2 - RANCHO SANTA FE ROAD GAS TAX GENERAL CAPITAL CONST. GOLF COURSE GRANTS - FEDERAL GRANTS - STATE INFRASTRUCTURE REPLACEMENT OTHER PARK FEE ZONES 5,13,16 PARK-IN-LIEU NE PARK-IN-LIEU NW PARK-IN-LIEU SE PARK-IN-LIEU SW PLANNED LOCAL DRAIN’G PUBLIC FACILITIES FEE REDEVELOPMENT VILLAGE REDEVELOPMENT SCCRDA SEWER BENEFIT AREAS SEWER CONNECTION SEWER REPLACEMENT TDA TRAFFIC IMPACT FEE TRANSNET/BIKE TRANSNET/HIGHWAY TRANSNET/LOCAL TRANSNETKTP WATER - MAJOR FACILITY WATER - RECYCLED WATER 99,664 1,196,818 294,547 13,431,776 1,817,868 2,058,987 5,470,004 0 17,008 1,593,186 3,415,471 328,364 197,908 107.109 299,488 575,018 327,437 818,567 11,200,696 65,394 0 1,193,530 6,273,019 3,517,708 216,490 2,274,739 0 85,482 2,186,597 127,491 4,746,830 652,387 1,254,130 3,850,521 200,151 8,150,245 3,268,765 2,078,795 4,278,498 0 342,827 1,070,012 3,676,384 146,865 108,709 532,417 282,916 538,255 979,445 1,177,836 6,741,413 130,718 0 800,554 9,472,325 3,171,976 7,941 1,242,674 0 52,570 2,508,640 70,313 2,546,628 16,722,716 196,887 926,437 404,647 6,500,700 14,050,Ol 8 1,851 ,I 18 36,905,004 600,000 208,914 244,735 4,114,930 1,098,283 64,865 245,976 1,520,779 475,468 9,593 739,807 6,436,638 18,552 146,305 1,308,913 4,855,445 3,115,527 302,968 1,762,612 11 3,689 1,205,103 2,878,396 15,933 2,192,288 6,869,702 334,300 2,870,247 42,213 5,090,033 10,471,582 2,700,901 1,955,370 0 1,969,499 5,637 4,022,503 43,106 54,092 52,934 582,541 257,875 700,025 1,094,823 5,498,664 0 0 2,039,522 2,450,964 4,236,406 3,240 952,059 698 35,484 3,453,321 6,558 2,600,991 24,427,256 0 2,148,660 0 7,336,242 28,781 2,519,687 2,430,854 0 1,870,000 0 3,713,l 50 986,854 85,364 459,985 151,235 491,095 46 1,097 1,951,925 5,903,080 0 0 716,106 1,818,348 2,200,000 0 1,395,075 120,000 0 3,019,678 0 2,855,013 6,792,997 WATER - REPLACEMENT 4,159,407 3,457,473 4,667,424 3,536,722 2,396,860 TOTAL CAPITAL FUNDS 69,570,013 79,l 53,030 106,047,656 81,489,565 51,852,086 Note: Revenues include interfund loans and transfers in. Exhibit B CITY OF CARLSBAD CAPITAL FUNDS BUDGET EXPENDITURE SCHEDULE ASSESSMENT DISTRICTS BTD#2 - POINSETTIA LANWAVIARA PKWL BTD#3 - CANNON ROAD WEST CFD #1 - CITYWIDE CFD #2 - RANCHO SANTA FE ROAD GAS TAX GENERAL CAPITAL CONST. GOLF COURSE GRANTS - FEDERAL GRANTS - STATE INFRASTRUCTURE REPLACEMENT OTHER PARK FEE ZONES 5,13,16 PARK-IN-LIEU NE PARK-IN-LIEU NW PARK-IN-LIEU SE PARK-IN-LIEU SW PLANNED LOCAL DRAIN'G PUBLIC FACILITIES FEE REDEVELOPMENT VILLAGE REDEVELOPMENT SCCRDA SEWER BENEFIT AREAS SEWER CONNECTION SEWER REPLACEMENT TDA TRAFFIC IMPACT FEE TRANSNET/BIKE TRANSNET/HlGHWAY TRANSNET/LOCAL TRANSNETKTP WATER - MAJOR FACILITY WATER - RECYCLED WATER 1,136,432 1,169,980 133,140 17,048,549 1,100,912 1.874.437 1,475,917 81,387 342,827 2,449,474 842,691 296,300 3,868 204,833 424,109 624,978 130,995 394,569 5,954,871 497,112 0 332,469 9,321,046 2,081,600 146,114 193,236 0 113,126 5,470,554 699,451 2,494.1 92 533.672 2001 -2002 2002-2003 2003-2004 FUND ACTUAL ACTUAL ESTIMATED 542,747 398.374 1,089,644 366,929 563,394 6,849,077 3,069,646 702,114 93,341 208,510 475,336 1,290,712 199,220 14,447 59,593 366,504 4,379,059 0 574,220 3,758,660 53,069 0 1,219,939 2,337.279 955.688 136,933 402,011 70,104 128,474 1,030,601 486,421 1,839,043 9,973,773 1,134,518 2,222,341 478,733 27,791,687 713,327 2,620,615 949,406 155,905 0 449,151 50,913 452 25,473 704,000 1,000,000 0 149,156 12,177,050 15,205 5 4,142,920 1,506,717 3,278,312 158,560 99,246 20,248 70,131 5,619,422 87,082 2,980,906 19,619,838 WATER - REPLACEMENT 1,643,575 3,155,390 3,109,896 TOTAL CAPITAL FUNDS 59,882,858 46,247,505 91,873,962 2004-2005 CONTINUING NEW TOTAL CIP APPROPR. APPROPR. APPRO P R. 2003-2004 2004-2005 357,751 1,397,831 30,177 64,895 7,510,696 4,206,837 3,537,986 90,205 1,866,004 0 669,905 451,693 0 1,660,251 0 0 216,005 4,619,040 22,923,882 1,845 254,995 1,786,616 7,512,096 10,094,863 0 2,414,634 21,137 1,753,831 3,918,699 220,749 4,593,610 16,545,052 0 1,190,000 925,000 210,000 0 805,000 350,000 1,870,000 35,000 1,037,000 1,041,854 0 0 0 0 550,000 1,365,524 1,380,000 851,000 0 12,309,941 2,406,014 0 i,937,7oa 120,000 0 3,963,000 0 853,500 159,527 9,033,aoo 6,158,308 357,751 2,587,831 955,177 274,895 7,510,696 5,011,837 12,571,786 440,205 3,736,004 35,000 1,706,905 1,493,547 0 1,660,251 0 0 766,005 5,984,564 29,082,190 1,381,845 1,105,995 1,786,616 19,822,037 12,500,877 0 4,352,342 141,137 1,753,831 7,881,699 220,749 5,447,110 16,704,579 7,550,802 3,960,4aa 11,511,290 106,272,087 52,512,664 158,784,751 Exhibit B CITY OF CARLSBAD CAPITAL FUNDS ANALYSIS OF AVAILABLE BALANCES 2004 TO BUILDOUT )YEAR 1 2004 - 2005 I FUND ASSESSMENT DISTRICTS BTD#2 - POINSETTIA LANWAVIARA PKWY BTDW - CANNON ROAD WEST CFD #1 - CITYWIDE CFD #2 - RANCHO SANTA FE ROAD GAS TAX GENERAL CAPITAL CONST. GOLF COURSE GRANTS - FEDERAL GRANTS - STATE INFRASTRUCTURE REPLACEMENT OTHER PARK FEE ZONES 5,13,16 PARK-IN-LIEU NE PARK-IN-LIEU NW PARK-IN-LIEU SE PARK-IN-LIEU SW PLANNED LOCAL DRAIN'G PUBLIC FACILITIES FEE REDEVELOPMENT VILLAGE REDEVELOPMENT SCCRDA SEWER BENEFIT AREAS SEWER CONNECTION SEWER REPLACEMENT TDA TRAFFIC IMPACT FEE TRANSNET/BIKE TRANSNETIHIGHWAY TRANSNET/LOCAL TRANSNETETP WATER - MAJOR FACILITY WATER - RECYCLED WATER BEGINNING BAL 7/1/2003 86,007 5,416,044 1,093,989 37,519,611 1,641,239 2,302,486 43,021,218 350,389 15,177 321,854 13,747,811 1,766,722 773,596 114,530 1,179,331 703,052 1,151,473 4,277,963 4,389,980 1,380,000 851,000 1,264,238 25,698,223 9,836,023 150,069 6,222,025 1,665 91,891 1,975,003 56,859 5,120,336 2,987,366 REVENUE 0 2,148,660 0 7,336,242 28,781 2,519,687 2,430,854 0 1,870,000 0 3,713,150 986,854 85,364 459,985 151,235 491,095 461,097 1,951,925 5,903,080 0 0 71 6,106 1,818,348 2,200,000 0 1,395,075 120,000 0 3,019,678 0 2,855,013 6,792,997 EXPENDITURES 0 1,190,000 925,000 210,000 0 805,000 9,033,800 350,000 1,870,000 35,000 1,037,000 1,041,854 0 0 0 0 550,000 1,365,524 6,158,308 1,380,000 851,000 0 12,309,941 2,406,014 0 1,937,708 120,000 0 3,963,000 0 853,500 159,527 ENDING 86,007 6,374,704 168,989 44,645,853 1,670,020 4.01 7,173 36,418,272 389 15,177 286,854 16,423,961 1,711,722 858,960 574,515 1,330,566 1,194,147 1,062,571 4,864,364 4,134,752 0 0 1,980,344 15,206,630 9,630,009 150,069 5,679,391 1,665 91,891 1,031,681 56,859 7,121,848 9,620,836 WATER - REPLACEMENT 5,926,025 2,396,860 3,960,488 4,362,397 TOTAL 181,433,194 51,852,086 52,512,664 180,772,616 (1) Beginning balance on 7/1/2004 is net of continuing appropriations. Exhibit B CITY OF CARLSBAD CAPITAL FUNDS ANALYSIS OF AVAILABLE BALANCES 2004 TO BUILDOUT YEAR 2 2005 - 2006 I BEGINNING FUND BAL 7/1/2004 REVENUE EXPENDITURES ENDING ASSESSMENT DISTRICTS 86,007 0 0 86,007 BTD#3 - CANNON ROAD WEST 168,989 558,206 0 727,195 CFD #1 - CITYWIDE 44,645,853 4,888,71 i 9,460,000 40,074,563 CFD #2 - RANCHO SANTA FE ROAD 1,670,020 58,964 0 1,728,984 GAS TAX 4,017,173 1,700,000 785,000 4,932,173 GENERAL CAPITAL CONST. 36,418,272 1,060,000 312,500 37,165,772 GRANTS - FEDERAL 15,177 1,804,000 1,804,000 15,177 GRANTS - STATE 286,854 0 0 286,854 INFRASTRUCTURE REPLACEMENT 16,423,961 3,824,545 985,000 19,263,506 OTHER 1,711,722 15,060,000 16,568,000 203,722 PARK FEE ZONES 5,13,16 858,960 137,544 0 996,503 PARK-IN-LIEU NE 574,515 191,105 0 765,620 PARK-IN-LIEU SE 1.1 94,147 491,095 0 1,685,242 PARK-IN-LIEU SW 1,062,571 298,880 0 1,361,451 PLANNED LOCAL DRAIN'G 4,864,364 1,419,895 0 6,284,259 PUBLIC FACILITIES FEE 4,134,752 5,197,810 5,436,000 3,896,563 REDEVELOPMENT VILLAGE 0 0 0 0 REDEVELOPMENT SCCRDA 0 0 0 0 SEWER BENEFIT AREAS 1,980,344 912,526 0 2,892,870 SEWER CONNECTION 15,206,630 5,509,838 11,392,034 9,324,434 TDA 150,069 0 0 150,069 TRAFFIC IMPACT FEE 5,679,391 1,680,286 1,078,430 6,281,247 TRANSNEnBlKE 1,665 0 0 1,665 TRANSNET/HIGHWAY 91,891 0 0 91,891 TRANSNET/LOCAL 1,031,681 2,550,000 2,600,000 981,681 TRANSNETETP 56,859 0 0 56,859 8,561,240 WATER - MAJOR FACILITY 7,121,848 2,856,091 1,416,700 WATER - RECYCLED WATER 9,620,836 7,795,625 7,929,932 9,486,529 WATER - REPLACEMENT 4,362.397 9,691,597 5,899,500 8,154,494 180,772,616 99,779,590 99,190,284 181,361,922 TOTAL BTD#2 - POINSETTIA LANWAVIARA PKWY 6,374,704 1,133,153 0 7,507,857 GOLF COURSE 389 28,650,000 28,650,000 389 PARK-IN-LIEU NW 1,330,566 109,720 860,000 580,286 SEWER REPLACEMENT 9,630,009 2,200,000 4,013,188 7,816,821 Exhibit B CITY OF CARLSBAD CAPITAL FUNDS ANALYSIS OF AVAILABLE BALANCES 2004 TO BUILDOUT YEAR 3 2006 - 2007 I BEG INN I NG FUND BAL 7/1/2005 REVENUE EXPENDITURES ENDING ASSESSMENT DISTRICTS 86,007 0 0 86,007 BTD#2 - POINSETTIA LANWAVIARA PKWY 7,507,857 11 4,003 0 7,621,860 BTD#3 - CANNON ROAD WEST 727,195 602,918 600,000 730,113 CFD #1 - CITYWIDE 40,074,563 3,829,559 10,752,000 33,152,122 CFD #2 - RANCHO SANTA FE ROAD 1,728,984 690,146 0 2,419,130 GAS TAX 4,932,173 1,750,000 985,000 5,697,173 1,250,000 0 38,415,772 GENERAL CAPITAL CONST. 37,165,772 GOLF COURSE 389 0 0 389 GRANTS - FEDERAL 15,177 0 0 15,177 GRANTS - STATE 286,854 0 0 286,854 INFRASTRUCTURE REPLACEMENT 19,263,506 3,939,281 0 23,202,786 OTHER 203,722 60,000 60,000 203,722 PARK FEE ZONES 5,13,16 996,503 197,551 0 1,194,054 PARK-IN-LIEU NE 765,620 453,319 0 1,218,939 PARK-IN-LIEU NW 580,286 269,851 0 850,137 PARK-IN-LIEU SE 1,685,242 457,763 1,250,000 893,005 PARK-IN-LIEU SW 1,361,451 32,222 0 1,393,673 PLANNED LOCAL DRAIN'G 6,284,259 1,185,160 0 7,469,419 8,397,788 PUBLIC FACILITIES FEE 3,896,563 4,501,225 0 REDEVELOPMENT VILLAGE 0 0 0 0 REDEVELOPMENT SCCRDA 0 0 0 0 SEWER BENEFIT AREAS 2,892,870 799,240 2,000,000 1,692,110 SEWER CONNECTION 9,324,434 5,292,253 5,933,944 8,682,743 SEWER REPLACEMENT 7,816,821 4,200,000 2,707,523 9,309,298 TDA 150,069 0 0 150,069 TRAFFIC IMPACT FEE 6,281,247 1,648,903 370,000 7,560,150 TRANSN ET/BI KE 1,665 0 0 1,665 TRANSN ET/HlGH WAY 91,891 0 0 91,891 TRANSNET/LOCAL 981,681 3,609,000 3,459,000 1,131,681 TRANSN ET/STP 56,859 0 0 56,859 WATER - MAJOR FACILITY 8,561,240 2,241,676 355,000 10,447,916 WATER - RECYCLED WATER 9,486,529 160,000 7,409,527 2,237,002 WATER - REPLACEMENT 8,154,494 9,737,229 500,000 17,391,723 181,361,922 47,021,299 36,381,994 192,001,227 TOTAL Exhibit B CITY OF CARLSBAD CAPITAL FUNDS ANALYSIS OF AVAILABLE BALANCES 2004 TO BUILDOUT YEAR 4 2007 - 2008 i BEGINNING FUND BAL 7/1/2006 REVENUE EXPENDITURES ENDING ASSESSMENT DISTRICTS 86,007 0 0 86,007 BTD#2 - POINSETTIA LANWAVIARA PKWY 7,621,860 0 0 7,621,860 BTD#3 - CANNON ROAD WEST 730,113 384,740 0 1,114,853 CFD #1 - CITYWIDE 33,152,122 2,725,541 10,752,000 25,125,664 CFD #2 - RANCHO SANTA FE ROAD 2,419,130 41 1,000 0 2,830,130 GAS TAX 5,697,173 1,800,000 800,000 6,697,173 GENERAL CAPITAL CONST. 38,415,772 320,000 0 38,735,772 GOLF COURSE 389 0 0 389 GRANTS - FEDERAL 15,177 0 0 15,177 GRANTS - STATE 286,854 0 0 286,854 INFRASTRUCTURE REPLACEMENT 23,202,786 4,057,459 0 27,260,246 OTHER 203,722 80,000 80,000 203,722 PARK-IN-LIEU NE 1,218,939 191,105 0 1,410,043 PARK-IN-LIEU NW 850,137 62,273 320,000 592,411 PARK-IN-LIEU SE 893,005 0 0 893,005 PARK-IN-LIEU SW 1,393,673 2,222 0 1,395,895 PLANNED LOCAL DRAIN'G 7,469,419 447,054 0 7,916,473 PUBLIC FACILITIES FEE 8,397,788 3,168,491 0 11,566,279 REDEVELOPMENT VILLAGE 0 0 0 0 REDEVELOPMENT SCCRDA 0 0 0 0 SEWER BENEFIT AREAS 1,692,110 341,790 100,000 1,933,900 SEWER CONNECTION 8,682,743 668,518 935,506 8,415,754 SEWER REPLACEMENT 9,309,298 2,200,000 704,555 10,804,743 TDA 150,069 0 0 150,069 8,159,105 TRAFFIC IMPACT FEE 7,560,150 968,955 370,000 TRANSNET/BlKE 1,665 0 0 1,665 TRANSNEnHlGHWAY 91,891 0 0 91,891 981,681 TRANSNET/LOCAL 1,131,681 2,450,000 2,600,000 TRANSN ET/STP 56,859 0 0 56,859 WATER - MAJOR FACILITY 10,447,916 936,659 2,012,300 9,372,275 WATER - RECYCLED WATER 2,237,002 160,000 159,527 2,237,475 WATER - REPLACEMENT 17,391,723 2,401,249 652,900 19,140,072 TOTAL 192,001,227 23,920,808 19,486,788 196,435,247 PARK FEE ZONES 5,13,16 1,194,054 143,751 0 1,337,805 Exhibit B CITY OF CARLSBAD CAPITAL FUNDS ANALYSIS OF AVAILABLE BALANCES 2004 TO BUILDOUT YEAR 5 2008 - 2009 I BEGINNING FUND BAL 7/1/2007 REVENUE EXPENDITURES ENDING ASSESSMENT DISTRICTS 86,007 0 0 86,007 BTD#2 - POINSETTIA LANWAVIARA PKWY 7,621,860 0 0 7,621,860 CFD #1 -CITYWIDE 25,125,664 2,834,136 110,000 27,849,800 CFD #2 - RANCHO SANTA FE ROAD 2,830,130 248,250 0 3,078,380 GAS TAX 6,697,173 2,050,000 2,230,000 6,517,173 38,735,772 0 0 38,735,772 GENERAL CAPITAL CONST. GOLF COURSE 389 0 0 389 GRANTS - FEDERAL 15,177 0 0 15,177 GRANTS - STATE 286,854 0 0 286,854 INFRASTRUCTURE REPLACEMENT 27,260,246 4,179,183 0 31,439,429 OTHER 203,722 0 0 203,722 PARK FEE ZONES 5,13,16 1,337,805 143,751 0 1,481,556 PARK-IN-LIEU NE 1,410,043 191,105 0 1,601,148 PARK-IN-LIEU NW 592.41 1 121,581 0 713,992 PARK-IN-LIEU SE 893,005 0 0 893,005 PARK-IN-LIEU SW 1,395,895 2,222 0 1,398,117 PLANNED LOCAL DRAIN'G 7,916,473 552,752 0 8,469,225 11,566,279 2,417,954 0 13,984,234 PUBLIC FACILITIES FEE REDEVELOPMENT VILLAGE 0 0 0 0 REDEVELOPMENT SCCRDA 0 0 0 0 SEWER BENEFIT AREAS 1,933,900 341,790 355,000 1,920,690 SEWER CONNECTION 8,415,754 650,686 937,169 8,129,271 SEWER REPLACEMENT 10,804,743 2,200,000 673,543 12,331,200 TDA 150,069 0 0 150,069 8,847,139 TRAFFIC IMPACT FEE 8,159,105 1,058,034 370,000 TRANSNET/BIKE 1,665 0 0 1,665 TRANSNET/HIGHWAY 91,891 0 0 91,891 TRANSNET/LOCAL 981,681 1,193,154 1,370,000 804,835 TRANSNETKTP 56,859 0 0 56,859 WATER - MAJOR FACILITY 9,372,275 4,010,862 11,475,000 1,908,137 WATER - RECYCLED WATER 2,237,475 160,000 159,527 2,237,948 17,699,572 WATER - REPLACEMENT 19,140,072 2,460,000 3,900,500 TOTAL 196,435,247 25,200,201 21,580,739 200,054,709 BTD#3 - CANNON ROAD WEST 1,114,853 384,740 0 1,499,593 Exhibit B CITY OF CARLSBAD CAPITAL FUNDS ANALYSIS OF AVAILABLE BALANCES 2004 TO BUILDOUT YEAR 6-1 0 2009 - 201 4 I BEGINNING FUND BAL 7/1/2008 REVENUE EXPENDITURES ENDING ASSESSMENT DISTRICTS 86,007 0 0 86,007 BTD#2 - POINSETTIA LANWAVIARA PKWY 7,621,860 2,900,160 0 10,522,020 BTD#3 - CANNON ROAD WEST 1,499,593 1,547,241 1,000,000 2,046,834 CFD #1 -CITYWIDE 27,849,800 4,396,342 14,918,000 17,328,142 CFD #2 - RANCHO SANTA FE ROAD 3,078,380 628,900 0 3,707,280 1,842,173 GAS TAX 6,517,173 10,510,000 15,185,000 GENERAL CAPITAL CONST. 38,735,772 0 31 ,116,000 7,619,772 GOLF COURSE 389 0 0 389 GRANTS - FEDERAL 15,177 0 0 15,177 GRANTS - STATE 286,854 0 0 286,854 INFRASTRUCTURE REPLACEMENT 31,439,429 20,500,000 2,500,000 49,439,429 OTHER 203,722 0 0 203,722 PARK FEE ZONES 5,13,16 1,481,556 870,642 0 2,352,198 PARK-IN-LIEU NE 1,601,148 1,168,851 0 2,769,999 PARK-IN-LIEU NW 713,992 71 1,696 600,000 825,688 PARK-IN-LIEU SE 893,005 0 0 893,005 PARK-IN-LIEU SW 1,398,117 573,315 0 1,971,432 PLANNED LOCAL DRAING 8,469,225 3,279,291 2,283,000 9,465,516 PUBLIC FACILITIES FEE 13,984,234 12,440,389 29,287,177 (2,862,555) REDEVELOPMENT VILLAGE 0 851,215 851,215 0 REDEVELOPMENT SCCRDA 0 0 0 0 SEWER BENEFIT AREAS 1,920,690 2,032,852 0 3,953,542 SEWER CONNECTION 8,129,271 2,826,742 4,656,782 6,299,231 SEWER REPLACEMENT 12,331,200 11,000,000 4,504,612 18,826,588 TDA 150,069 0 0 150,069 TRAFFIC IMPACT FEE 8,847,139 5,254,696 4,085,000 10,016,835 TRANSNET/BIKE 1,665 0 0 1,665 TRANSNET/HlGHWAY 91,891 0 0 91,891 TRANSN ET/LOCAL 804,835 0 0 804,835 TRANSNETKTP 56,859 0 0 56,859 1,282,800 WATER - MAJOR FACILITY 1,908,137 6,673,762 7,299,100 WATER - RECYCLED WATER 2,237,948 765,000 764,013 2,238,935 WATER - REPLACEMENT 17,699,572 12,800,000 3,625,660 26,873,912 TOTAL 200,054,709 101,731,093 122,675,559 179,110,243 Exhibit B CITY OF CARLSBAD CAPITAL FUNDS ANALYSIS OF AVAILABLE BALANCES 2004 TO BUILDOUT 2014 to Bulldout I BEGINNING FUND ASSESSMENT DISTRICTS BTD#2 - POINSETTIA LANUAVIARA PKWY BTD#3 - CANNON ROAD WEST CFD #1 - CITYWIDE CFD #2 - RANCHO SANTA FE ROAD GAS TAX GENERAL CAPITAL CONST. GOLF COURSE GRANTS - FEDERAL GRANTS - STATE INFRASTRUCTURE REPLACEMENT OTHER PARK FEE ZONES 5,13,16 PARK-IN-LIEU NE PARK-IN-LIEU NW PARK-IN-LIEU SE PARK-IN-LIEU SW PLANNED LOCAL DRAIN'G PUBLIC FACILITIES FEE REDEVELOPMENT VILLAGE REDEVELOPMENT SCCRDA SEWER BENEFIT AREAS SEWER CONNECTION SEWER REPLACEMENT TDA TRAFFIC IMPACT FEE TRANSNET/BIKE TRANSNET/HIGHWAY TRANSNET/LOCAL TRANSNETETP WATER - MAJOR FACILITY WATER - RECYCLED WATER BAL 7/1/2013 86,007 10,522,020 2,046,834 17,328,142 3,707,280 1,842,173 7,619,772 389 15,177 286,854 49,439,429 203,722 2,352,198 2,769,999 825,688 893,005 1,971,432 9,465,516 (2,862,555) 0 0 3,953,542 6,299,231 18,826,588 150,069 10,016,835 1,665 91,891 804,835 56,859 1,282,800 2,238,935 REVENUE 0 2,213,460 27,600 2,205,255 0 16,643,344 0 17,737,200 0 0 25,200,000 430,000 569,950 1,312,458 907,412 0 415,542 3,687,669 6,523,499 0 451,000 1,513,994 1,758,276 16,477,592 0 2,913,848 0 0 0 0 3,913,226 0 EXPENDITURES 0 9,583,344 400,000 10,778,000 0 16,000,000 0 17,737,200 0 0 5,000,000 430,000 2,626,000 4,000,000 1,280,000 800,000 2,300,000 12,215,000 5,193,000 0 451,000 3,277,592 2,172,191 7,989,076 0 6,030,000 0 0 0 0 3,624,900 0 ENDING 86,007 3,152,136 1,674,434 8,755,397 3,707,280 2,485,517 7,619,772 389 15,177 286,854 69,639,429 203,722 296,148 82,457 453,101 93,005 86,974 938,185 (1,532,056) 0 0 2,189,944 5,885,316 27,315,104 150,069 6,900,683 1,665 91,891 804,835 56,859 1,571,126 2,238,935 WATER - REPLACEMENT 26,873,912 21,620,000 2,762.1 00 45,731,812 TOTAL 179,110,243 126,521,325 114,649,403 190,982,165 Exhibit E CITY OF CARLSBAD CAPITAL FUNDS ANALYSIS OF AVAILABLE BALANCES 2004 TO BUILDOUT GRAND TOTALS ALL YEARS 1 BEGINNING TOTAL TOTAL FUND BALANCE REVENUE EXPENDITURES ENDING ASSESSMENT DISTRICTS 86,007 0 0 86,007 BTD#2 - POINSETTIA LANWAVIARA PKWY BTD#3 - CANNON ROAD WEST CFD #1 - CITYWIDE CFD #2 - RANCHO SANTA FE ROAD GAS TAX GENERAL CAPITAL CONST. GOLF COURSE GRANTS - FEDERAL GRANTS - STATE INFRASTRUCTURE REPLACEMENT OTHER PARK FEE ZONES 5,13,16 PARK-IN-LIEU NE PARK-IN-LIEU NW PARK-IN-LIEU SE PARK-IN-LIEU SW PLANNED LOCAL DRAIN'G PUBLIC FACILITIES FEE REDEVELOPMENT VILLAGE REDEVELOPMENT SCCRDA SEWER BENEFIT AREAS SEWER CONNECTION SEWER REPLACEMENT TDA TRAFFIC IMPACT FEE TRANSNETBIKE TRANSNET/HIGHWAY TRANSNET/LOCAL TRANSNETKTP WATER - MAJOR FACILITY WATER - RECYCLED WATER 5,416,044 1,093,989 37,519,611 1,641,239 2,302,486 43,021,218 350,389 15,177 321,854 13,747,811 1,766,722 773,596 11 4,530 1,179,331 703,052 1,151,473 4,277,963 4,389,980 1,380,000 851,000 1,264,238 25,698,223 9,836,023 150,069 6,222,025 1,665 91,891 1,975,003 56,859 5,120,336 2,987,366 8,509,436 3,505,445 28,215,787 2,066,041 36,973,031 5,060,854 46,387,200 3,674,000 0 65,413,618 16,616,854 2,148,552 3,967,927 2,333,770 1,439,953 1,785,500 12,523,746 40,152,449 851,215 451,000 6,658,298 18,524,660 40,477,592 0 14,919,796 120,000 0 12,821,832 0 23,487,290 15,833,622 10,773,344 2,925,000 56,980,000 0 36,790,000 40,462,300 46,737,200 3,674,000 35,000 9,522,000 18,179,854 2,626,000 4,000,000 3,060,000 2,050,000 2,850,000 15,863,524 46,074,485 2,231,215 1,302,000 5,732,592 22,998,511 0 14,241,138 120,000 0 13,992,000 0 27,036,500 16,582,053 38,337,567 3,152,136 1,674,434 8,755,397 3,707,280 2,485,517 7,619,772 389 15,177 286,854 69,639,429 203,722 296,148 82,457 453,101 93,005 86,974 938,185 (1,532,056) 0 0 2,189,944 5,885,316 27,315,104 150,069 6,900,683 1,665 91,891 804,835 1,571,126 2,238,935 56,859 WATER - REPLACEMENT 5,926,025 61,106,935 21,301,148 45,731,812 TOTAL 181,433,194 476,026,403 466,477,431 igo,ga2,165 hibit B bq I t e c 0 E I c c I I C c Exhibit B hibit B .- E e e n m U C aJ E e E CI U - m n .- d m s t 0 0 N '0 n e n 3 a r f a $ I i a 3 5 i a 3 I I i P 5 1 f iibit B 6% LL c W 0 L d Y sit B z E i ! I I 1 ! ! I Exhibit B EXHIBIT C ADJUSTED OVER FINAL PRELIMINARY (UNDER) BUDGET BUDGET 2003-04 MAJOR SERVICE AREA 2003-04 2004-05 ALLOCATED )POLICY AND LEADERSHIP GROUP I CITY COUNCIL 1 .oo 1 .oo 0.00 CITY MANAGER 6.00 6.00 0.00 COMMUNICATIONS 2.75 2.75 0.00 CITY TREASURER 0.75 0.75 0.00 CITY CLERK 0.00 0.00 0.00 CITY AlTORNEY 7.00 7.00 0.00 )ADMINISTRATIVE SERVICES i I I ADMINISTRATION RECORDSMANAGEMENT INFORMATION TECHNOLOGY FINANCE RISK MANAGEMENT HUMAN RESOURCES &WORKERS COMP (PUBLIC SAFETY I POLICE FIRE )COMMUNITY DEVELOPMENT 1 COMMUNITY DEVELOPMENT ADMINISTRATION BUILDING INSPECTION ECONOMIC DEVELOPMENT GEOGRAPHIC INFORMATION PLANNING HOUSING AND REDEVELOPMENT )COMMUNITY SERVICES I LIBRARY CULTURAL ARTS RECREATION SENIOR PROGRAM .2.00 8.00 16.00 28.00 2.00 10.00 148.00 79.75 2.00 8.00 16.00 28.00 2.00 10.00 148.00 79.75 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3.00 3.00 0.00 13.00 13.00 0.00 1 .oo 1 .oo 0.00 2.00 2.00 0.00 25.00 25.00 0.00 10.00 10.00 0.00 48.00 48.00 0.00 5.00 5.00 0.00 31 .OO 31 .OO 0.00 2.00 2.00 0.00 )PUBLIC WORKS 3 ADMINISTRATION 6.00 7.00 1 .oo ENGINEERING SERVICES 57.00 57.00 0.00 GENERAL SERVICES 58.75 57.75 (1 .OO) MAINTENANCE & OPERATIONS 73.00 73.00 0.00 FULL AND 314 TIME LABOR FORCE 646.00 646.00 0.00 EXHIBIT C PERSONNEL ALLOCATIONS FOR 2003-04 AND 2004-05 (Continued) 'LIMITED TERM EMPLOYEES Difference 2003/04 2004/05 ISUMMARY OF REQUESTED LABOR FORCE BY CATEGORY i Full Time Personnel I 314 Time Personnel in Full Time Equivalents 2003104 2004/05 Difference 640.00 640.00 6.00 6.00 0.00 I Hourly Full Time Eauivalent Personnel 148.27 147.93 \- - , TOTAL LABOR FORCE 794.27 793.93 (0.34) Management Interns Building Inspector Intern Division Chief Overstaff GIS Intern 2.00 1.50 2.00 2.00 1 .oo 0.00 0.50 0.50 (0.50) 0.00 (1 .OO) 0.00 Planning Technician Intern 1 .oo 1 .oo 0.00 TOTAL LIMITED TERM EMPLOYEES 6.50 5.00 (1.50)