Loading...
HomeMy WebLinkAbout2007-06-26; City Council; Resolution 2007-154Exhibit 3 1 RESOLUTION NO. 2007-154 2 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF CARLSBAD, CALIFORNIA, ADOPTING THE FINAL 3 OPERATING BUDGET AND CAPITAL IMPROVEMENT 4 PROGRAM FOR THE FISCAL YEAR 2007-08 FOR THE CITY OF CARLSBAD AND ESTABLISHING CONTROLS 5 ON CHANGES IN APPROPRIATIONS FOR THE VARIOUS FUNDS. 6 7 WHEREAS, the City Council of the City of Carlsbad, California has reviewed the 8 proposed final Operating Budget and Capital Improvement Program for fiscal year 9 2007-08 and has held such public hearings as are necessary prior to adoption of the 10 final budgets. 11 12 WHEREAS, the Planning Commission made a finding of General Plan 13 Consistency for all projects receiving an allocation of funds for fiscal year 2007-08 on 14 May 2, 2007 pursuant to Planning Commission Resolution No. 6302. 15 NOW, THEREFORE, BE IT RESOLVED by the City Council of the City of16 Carlsbad, California, as follows: 18 1. That the above recitations are true and correct. 19 2. That certain documents now on file in the office of the City Clerk of the 20 City of Carlsbad entitled, "City of Carlsbad, 2007-08 Preliminary Operating Budget and 21 2007-08 to Buildout Capital Improvement Program - Preliminary" as amended in 22 accordance with Exhibits 3-A through 3-C attached hereto and incorporated by 23 reference herein, is hereby adopted as the Operating and Capital Improvement Budgets 24 for the City of Carlsbad for the fiscal year.25 y y 26 3. That the amounts reflected as estimated revenues for fiscal year 2007-08 27 as shown in Exhibits 3-A and 3-B are hereby adopted as the budgeted revenues for 28 Exhibit 3 1 2007-08. 2 4. That the amounts designated as the 2007-08 Budget request in Exhibits 3- 3 A and 3-B are hereby appropriated to the department or fund for which they are 4 designated, and such appropriation shall not be increased except as provided herein. 5 5. That total appropriations for each fund may only be increased or 6 decreased by the City Council by passage of a resolution amending the budget except 7 as provided herein. 8 6. That the following controls are hereby placed on the use and transfers of 9 budget funds: 10 A. No expenditure of funds shall be authorized unless sufficient funds 11 have been appropriated by the City Council or City Manager as described below. 12 i. The City Manager may authorize all transfers of funds from 13 account to account within any department. 14 ii. The City Manager may authorize transfers of funds between 15 departments within the same fund in an amount up to $100,000 per transfer. 16 iii. The City Manager may delegate any of the authority given to him 17 under this resolution. 18 iv. The City Manager may authorize budget adjustments involving 19 offsetting revenues and expenditures; the City Manager may authorize increases 20 in an appropriation for a specific purpose where the appropriation is offset by 21 unbudgeted revenue, which is designated for said specific purpose. 22 v. The City Manager may authorize the transfer of appropriations 23 between accounts and/or capital projects up to $1,000,000 for the costs 24 associated with the Encina Wastewater Facility (Encina) as authorized by the 25 Encina Wastewater Authority's staff and/or Board. Any increase to the total 26 appropriations for Encina's operating budget and capital program must be 27 28 Exhibit 3 1 approved by the City Council. 2 vi. The City Manager may authorize budget adjustments to increase 3 the appropriations for Workers Compensation, Risk, Self Insured Benefits and 4 Liability funds operating budget in an amount equal to the increases in costs of 5 claims expenses. 6 vii. The City Council must authorize all transfers of funds from the 7 Council's Contingency Account. 8 B. The City Manager may authorize emergency out of state travel for 9 public safety or emergency services purposes. 10 C. The City Council must authorize any increase in the number of 11 authorized permanent personnel positions above the level identified in 12 Exhibit 3-C. 13 D. The City Manager may authorize the hiring of temporary or part time 14 staff as necessary, within the limits imposed by the controls listed above. 15 7. That the legal level of budgetary control is the fund level. Budgets may 16 not legally be exceeded at the fund level without appropriate authorization by the City 17 Council. 18 8. That interest earned on grants may be appropriated during the year for the 19 purpose for which the grant was received. 20 9. That the Finance Director is authorized to transfer funds remaining in the 21 Traffic Congestion Relief Fund on June 30, 2008, to the Pavement Overlay Fund to be 22 used towards the Pavement Overlay program. 23 10. That all appropriations in the Operating Budget and in Capital 24 Improvement Program remaining unexpended at June 30, 2007, are hereby 25 appropriated to the 2007-08 fiscal year. 11. That all appropriations for outstanding encumbrances as of June 30,26 27 2007, are hereby continued into 2007-08 for such contracts or obligations. 28 /•> n 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 PASSED, APPROVED AND ADOPTED at a Regular Meeting of the City Council of the City of Carlsbad on the 26th day of June, 2007, by the following vote to wit: AYES: Council Members Lewis, Kulchin, Hall, Packard and Nygaard. NOES: None. ABSENT: None. 'A LEWIS, Mayor ATTEST: LORRAINE M. WOOD, City Clerk (SEAL) f \ i hi Cm OF CARLSBAD OPERATING FUNDS PROJECTED FUND BALANCES FUND [GENERAL FUND ADVANCE TO MEDIAN MAINTENANCE ADVANCE TO GOLF COURSE CAPITAL PROJECT TOTAL [SPECIAL REVENUE 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 BUEN A VISTA CRK CHNL MNT LLDK2 ARTS SPECIAL EVENTS RECREATION DONATIONS SENIOR DONATIONS CDBG ENTITLEMENT COMMUNITY ACTIVITY GRANTS CULTURAL ARTS PROGRAM TOTAL [ENTERPRISE WATER OPERATIONS RECYCLED WATER OPERATIONS SANITATION OPERATIONS SOLID WASTE MANAGEMENT GOLF COURSE TOTAL [INTERNAL SERVICE WORKER'S COMP SELF INSURANCE RISK MANAGEMENT SELF-INSURED BENEFITS VEHICLE MAINTENANCE VEHICLE REPLACEMENT INFORMATION TECHNOLOGY TOTAL [REDEVELOPMENT VILLAGE OPERATIONS / DEBT SVC VILLAGE LOW/MOD INCOME HOUSING SCCRA OPERATIONS / DEBT SVC SCCRA LOW/MOD INCOME HOUSING TOTAL [TOTAL OPERATING FUNDS UNRESERVED BALANCE JULY 1,2006 ) 66,066,490 66,066,490 D 637,158 17,657 33.186 369.197 9,264.337 265,950 84,246 588,778 234,358 745,670 945,845 111,430 86,201 100,974 194,386 224,404 991,656 202,679 15,098,110 n 11.792.644 3.463,396 5,301,024 7,146,853 0 27,703,917 u 4,510,327 699,626 715,358 (23,486) 8,350,459 3,971.237 18.223.521 H 2,075,970 2,614,839 483.224 372,699 5,546,732 5132,838,770 ESTIMATED REVENUES 114,494,000 1 14,494,000 150,000 145,800 15.700 6.136,000 977.000 11,000 101.000 490.000 389,000 983.662 142,200 297,000 35,000 30,000 17,000 682.000 64.000 9,000 10,675.382 23,056,080 3.123,350 7,748,889 2,284,723 0 38,213,042 2,577.202 1,645,709 887,000 2,555.000 1,811,000 4,608,388 14,064,299 2,745.300 790,000 28,000 16,000 3,579,300 $179,026,003 ESTIMATED FUND EXPENDITURES TRANSFERS 111,748,814 • (178,000) (7,886,174) 111,748,814 0 0 0 5,227,604 359,048 14,000 0 612,615 595,897 178.000 947,798 110,162 140,129 32,231 0 0 470,342 0 8,521 8.478,345 26,946,333 " (400,000) 3,434,343 6.836,058 2,378,543 0 41,595,275 1,817,264 1,598,795 400,000 914.000 2.485.989 0 5.913.718 12,734,764 2,979,374 76.925 228.951 45,000 3,330,250 $177.887.448 ($7,886,174) PROJECTED BALANCE JUNE 30, 2007 68,811,676 (178,000) (7,886,174) 60.747,502 787,156 163,457 48.886 1,277.593 9.882.289 262,950 185,246 486,163 245.481 781.536 977,883 268,301 88,970 130,974 211,386 436,062 1,055,656 203,158 17.473,127 7.502.391 3,152,403 4,213.857 7,053,033 0 21,921,684 5,270,265 1,146.540 668.358 45,525 10,161,459 2,660.909 19,953,058 1,841,898 3,327.914 282,273 343.699 5,795.782 $125,891,151 1 * Includes fully funding liability for retiree health. General Fund's share is $4.8 million and Water's share is $2.7 million. B-16 Exhibit 3A CITY OF CARLSBAD OPERATING FUNDS PROJECTED FUND BALANCES FUND GENERAL FUND ADVANCE FROM SOLID WASTE ADVANCE TO MEDIAN FUND ADVANCE TO SCCRA FUND TRANSFER TO SOLID WASTE TOTAL SPECIAL REVENUE 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 TOTAL ENTERPRISE WATER OPERATIONS RECYCLED WATER OPERATIONS SANITATION OPERATIONS SOLID WASTE MANAGEMENT GOLF COURSE TOTAL INTERNAL SERVICE WORKER'S COMP SELF INSUR RISK MANAGEMENT SELF-INSURED BENEFITS VEHICLE MAINTENANCE VEHICLE REPLACEMENT INFORMATION TECHNOLOGY TOTAL | REDEVELOPMENT VILLAGE OPERATIONS / DEBT SVC VILLAGE LOW/MOD INCOME HOUSING SCCRA OPERATIONS / DEBT SVC SCCRA LOW/MOD INCOME HOUSING TOTAL TOTAL OPERATING FUNDS PROJECTED BALANCE JULY 1,2007 60,747,502 60,747,502 787,156 163,457 48,886 1,277,593 9,882,289 262,950 185,246 466,163 245,461 781,536 977,883 268,301 88,970 130,974 211,386 436,062 1,055,656 203,158 17,473,127 7,502,391 3,152,403 4,213,857 7,053,033 0 21,921,684 5,270,265 1,146,540 668,358 45,525 10,161,459 2,660,909 19,953,056 1,841,896 3,327,914 282,273 343,699 5,795,782 $125,891,151 ESTIMATED REVENUES 120,999,000 120,999,000 73,000 192,000 0 5,962,679 612,000 10,000 0 485,391 365,630 950,661 143,000 476,623 121,875 0 0 672,080 40,000 7,000 10,111,939 25,118,399 3,746,016 8,739,771 3,019,853 0 40,624,039 2,075,420 1,388,887 950,666 2,712,963 2,247,598 5,355,500 14,731,034 2,766,500 806,967 4,000 14,000 3,591,467 $190,057,479 ADOPTED BUDGET 115,619,535 115,619,535 140,351 219,746 0 6,020,512 436,366 12,350 0 598,368 709,226 1,244,978 90,600 248,434 59,520 16,200 64,500 602,848 30,000 26,100 10,520,099 26,048,581 4,971,322 10,846,430 3,300,761 0 45,167,094 2,028,576 1,349,977 967,540 2,745,984 865,000 5,034,921 12,991,998 1,609,336 95,604 180,293 43,595 1,928,828 $186,227,554 PROJECTED FUND RESERVED BALANCE TRANSFERS BALANCES JUNE 30, 2008 66,126,967 136,000 136,000 (108,000) (108,000) (200,000) (200,000) (138,800) (138,800) 65,816,167 719,805 135,711 48,886 1,219,760 10,057,923 260,600 185,246 353,186 108,000 9,865 487,219 1,030,283 496,490 151,325 114,774 146,886 505,294 (1,000,000) 65,656 184,058 16,172,967 6,572,209 1,927,097 2,107,198 2,800 6,774,925 0 17,381,429 (3,400,000) 1,917,109 (750,000) 435,450 651,484 12,504 (5,000,000) 6,544,057 (1,710,601) 1,270,887 10,831,491 2,999,060 4,039,277 200,000 305,980 314,104 7,658,421 $0 ($11,860,601) $117,860,475 1 B-17 Exhibit 3A CITY OF CARLSBAD OPERATING FUNDS REVENUE ESTIMATES REVENUE SOURCE GENERAL FUND TAXES PROPERTY TAX SALES TAX TRANSIENT TAX FRANCHISE TAX BUSINESS LICENSE TAX TRANSFER TAX TOTAL TAXES INTERGOVERNMENTAL VEHICLE LICENSE FEES OTHER TOTAL INTERGOVERNMENTAL LICENSES AND PERMITS BUILDING PERMITS OTHER LICENSES & PERMITS TOTAL LICENSES & PERMITS CHARGES FOR SERVICES PLANNING FEES BUILDING DEPT. FEES ENGINEERING FEES AMBULANCE FEES RECREATION FEES OTHER CHARGES OR FEES TOTAL CHARGES FOR SERVICES FINES AND FORFEITURES INCOME FROM INVESTMENTS AND PROPERTY* INTERDEPARTMENTAL CHARGES OTHER REVENUE SOURCES TOTAL GENERAL FUND ACTUAL REVENUE 2005-06 H $38,041,495 27,294,382 11,512,552 5,429,31 1 3,039,678 1,905,842 87,223,260 587,179 515,062 1,102,241 1,375,736 1,128,284 2,504,020 890,672 998,840 1,825,354 1,685,850 1,581,370 769,587 7,751,673 1,063,268 2,411,227 2,611,380 1,280,462 105,947,531 PROJECTED REVENUE 2006-07 $44,921,000 28,000,000 12,827,000 5,324,000 3,200,000 993,000 95,265,000 604,000 1,239,000 1,843,000 930,000 1,000,000 1,930,000 1,000,000 1,036,000 1,830,000 1,500,000 1,630,000 770,000 7,766,000 1,050,000 3,710,000 2,180,000 750,000 114,494,000 * Interest Is calculated on an amortized cost basis. ESTIMATED REVENUE 2007-08 $49,963,000 28,501,000 13,648,000 5,623,000 3,280,000 1,013,000 102,028,000 625,000 2,258,000 2,883,000 721,000 875,000 1,596,000 443,000 680,000 1,025,000 1,565,000 1,685,000 796,000 6,194,000 1,086,000 3,892,000 2,570,000 750,000 120,999,000 AS% OF FY 06-07 PROJECTED 11.2% 1.8% 6.4% 5.6% 2.5% 2.0% 7.1% 3.5% 82.2% 56.4% -22.5% -12.5% -17.3% -55.7% -34.4% -44.0% 4.3% 3.4% 3.4% -20.2% 3.4% 4.9% 17.9% 0.0% 5.7% DIFFERENCE 2006-07 TO 2007-08 5,042,000 501,000 821,000 299,000 80,000 20,000 6,763,000 21,000 1,019,000 1,040,000 (209,000) (125,000) (334,000) (557,000) (356,000) (805,000) 65,000 55,000 26,000 (1,572,000) 36,000 182,000 390,000 0 6,505,000 B-18 Exhibit 3A CITY OF CARLSBAD OPERATING FUNDS REVENUE ESTIMATES REVENUE SOURCE SPECIAL REVENUE FUNDS POLICE ASSET FORFEITURE ASSET FORFEITURES INTEREST TOTAL COPS GRANT STATE FUNDING (AB3229) INTEREST TOTAL POLICE GRANTS FEDERAL GRANT INTEREST TOTAL HOUSING - SECTION 8 FEDERAL GRANT INTEREST OTHER TOTAL HOUSING TRUST FUND AFFORDABLE HOUSING FEES FEDERAL GRANT INTEREST OTHER TOTAL LIBRARY ENDOWMENT FUND INTEREST TOTAL LIBRARY GIFTS/BEQUESTS GIFTS/BEQUESTS INTEREST TOTAL ACTUAL REVENUE 2005-06 114,926 13,302 128,228 137,284 (1,237) 136,047 21,690 216 21,906 6,013,874 1,576 13,256 6,028,706 57,017 295,406 240,700 847,584 1,440,707 6,332 6,332 88,955 2,948 91,903 PROJECTED REVENUE 2006-07 125,000 25,000 150,000 140,000 5,800 145,800 15,000 700 15,700 6,100,000 10,000 26,000 6,136,000 24,000 0 450,000 503,000 977,000 11,000 11,000 96,000 5,000 101,000 ESTIMATED REVENUE 2007-08 50,000 23,000 73,000 190,000 2,000 192,000 0 0 0 5,951,179 1,500 10,000 5,962,679 57,000 0 480,000 75,000 612,000 10,000 10,000 0 0 0 AS% OF FY 06-07 PROJECTED -60.0% -8.0% -51.3% 35.7% -65.5% 31.7% -100.0% -100.0% -100.0% -2.4% -85.0% -61.5% -2.8% 137.5% 0.0% 6.7% -85.1% -37.4% -9.1% -9.1% -100.0% -100.0% -100.0% DIFFERENCE 2006-07 TO 2007-08 (75,000) (2,000) (77,000) 50,000 (3,800) 46,200 (15,000) (700) (15,700) (148,821) (8,500) (16,000) (173,321) 33,000 0 30,000 (428,000) (365,000) (1,000) (1,000) (96,000) (5,000) (101,000) B-19 Exhibit 3A CITY OF CARLSBAD OPERATING FUNDS REVENUE ESTIMATES REVENUE SOURCE TREE MAINTENANCE TREE MAINTENANCE FEES INTEREST TOTAL MEDIAN MAINTENANCE MEDIAN MAINTENANCE FEES INTEREST TOTAL STREET LIGHTING STREET LIGHTING FEES INTERDEPARTMENTAL OTHER INTEREST TOTAL BUENA VISTA CREEK CHNL MAINT BUENA VISTA FEES INTEREST TOTAL LLD#2 LLD #2 FEES INTEREST OTHER TOTAL ARTS SPECIAL EVENTS DONATIONS INTEREST TOTAL RECREATION DONATIONS DONATIONS INTEREST TOTAL ACTUAL REVENUE 2005-05 465,439 15,453 480,892 397,696 717 398,413 715,034 28,000 189,530 25,900 958,464 99,911 19,938 119,849 121,753 650 6,000 128,403 70,562 (103) 70,459 14,290 2,195 16,485 PROJECTED REVENUE 2006-07 464,000 26,000 490,000 388,000 1,000 389,000 718,000 28,000 200,662 37,000 983,662 100,200 42,000 142,200 290,000 4,000 3,000 297,000 32,000 3,000 35,000 25,000 5,000 30,000 ESTIMATED REVENUE 2007-08 460,391 25,000 485,391 365,630 0 365,630 721,574 28,000 167,087 34,000 950,661 100,000 43,000 143,000 470,423 6,200 0 476,623 121,000 875 121,875 0 0 0 AS% OF FY 06-07 PROJECTED -0.8% -3.9% •0.9% -5.8% -100.0% •6.0% 0.5% 0.0% -16.7% -8.1% -3.4% -0.2% 2.4% 0.6% 62.2% 55.0% -100.0% 60.5% 278.1% -70.8% 248.2% -100.0% 0.0% -100.0% DIFFERENCE 2006-07 TO 2007-08 (3,609) (1,000) (4,609) (22,370) (1,000) (23,370) 3,574 0 (33,575) (3,000) (33,001) (200) 1,000 800 180,423 2,200 (3,000) 179,623 89,000 (2,125) 86,875 (25,000) 0 (30,000) B-20 Exhibit 3A CITY OF CARLSBAD OPERATING FUNDS REVENUE ESTIMATES REVENUE SOURCE SENIOR DONATIONS DONATIONS INTEREST TOTAL CDBG ENTITLEMENT FEDERAL GRANT INTEREST OTHER TOTAL COMMUNITY ACTIVITY GRANTS INTEREST TOTAL CULTURAL ARTS PROGRAM INTEREST TOTAL TOTAL SPECIAL REVENUE FUNDS ACTUAL REVENUE 2005-06 10,598 4,448 15,046 1,046,363 76,622 66,572 1,189,557 23,049 23,049 4,973 4,973 11,259,419 PROJECTED REVENUE 2006-07 9,000 8,000 17,000 590,000 48,000 44,000 682,000 64,000 64,000 9,000 9,000 10,675,362 ESTIMATED REVENUE 2007-08 0 0 0 602,080 35,000 35,000 672,080 40,000 40,000 7,000 7,000 10,111,939 AS% OF FY 06-07 PROJECTED -100.0% -100.0% -100.0% 2.1% -27.1% -20.5% -1.5% -37.5% -37.5% -22.2% -22.2% -5.3% DIFFERENCE 2006-07 TO 2007-08 (9,000) (8,000) (9,000) 12,080 (13,000) (9,000) (9,920) (24,000) (24,000) (2,000) (2,000) (563,423) B-21 Exhibit 3A CITY OF CARLSBAD OPERATING FUNDS REVENUE ESTIMATES REVENUE SOURCE ENTERPRISE FUNDS WATER OPERATIONS WATER SALES READY TO SERVE CHARGES PROPERTY TAXES NEW ACCOUNT CHARGES BACK-FLOW PROGRAM FEES PENALTY FEES INTEREST ENGINEERING OVERHEAD SERVICE CONNECTION FEES AGRICULTURAL CREDITS OTHER TOTAL RECYCLED WATER WATER SALES READY-TO-SERVE CHARGE RECYCLED WATER CREDITS INTEREST OTHER TOTAL SANITATION OPERATIONS SERVICE CHARGES MISC SEWER ENGINEERING OVERHEAD PENALTY FEES INTEREST OTHER TOTAL SOLID WASTE MANAGEMENT INTEREST RECYCLING FEES (AB939) PENALTY FEES STATE GRANT TRASH SURCHARGE OTHER TOTAL GOLF COURSE OTHER OPERATIONS INTEREST TOTAL TOTAL ENTERPRISE FUNDS ACTUAL REVENUE 2005-06 1 13,689,338 3,899,822 2,257,123 136,790 109,886 245,007 343,809 169,563 168,173 100,024 177,388 21,296,923 1,324,484 108,235 588,936 90,666 11,815 2,124,136 6,707,125 19,587 159,675 74,205 155,154 26,241 7,141,987 160,058 283,280 48,403 29,214 1,561,061 12,694 2,094,710 18,996 0 532,154 551,150 33,208,906 PROJECTED REVENUE 2006-07 14,996,100 4,150,000 2,369,980 100,000 115,000 250,000 500,000 130,000 140,000 105,000 200,000 23,056,080 1,575,130 130,000 784,220 240,000 394,000 3,123,350 7,300,000 19,759 164,465 74,852 162,193 27,620 7,748,889 286,145 294,612 50,339 25,531 1,608,582 19,514 2,284,723 0 0 0 0 36,213,042 ESTIMATED REVENUE 2007-08 16,218,282 5,101,622 2,488,479 97,000 117,300 255,000 326,216 133,900 135,800 100,800 144,000 25,118,399 2,014,741 139,100 1,026,079 166,096 400,000 3,746,016 8,300,612 19,953 169,399 75,589 145,770 28,448 8,739,771 283,817 306,397 52,353 25,000 2,352,286 0 3,019,853 0 0 0 0 40,624,039 AS% OF FY 06-07 PROJECTED 8.2% 22.9% 5.0% -3.0% 2.0% 2.0% -34.8% 3.0% -3.0% -4.0% -28.0% 8.9% 27.9% 7.0% 30.8% -30.8% 1.5% DIFFERENCE 2006-07 TO 2007-08 1,222,182 951,622 118,499 (3,000) 2,300 5,000 (173,784) 3,900 (4,200) (4,200) (56,000) 2,062,319 439,611 9,100 241,859 (73,904) 6,000 19.9% 622,666 13.7% 1.0% 3.0% 1.0% -10.1% 3.0% 12.8% -0.8% 4.0% 4.0% -2.1% 46.2% -100.0% 32.2% 0.0% 0.0% 0.0% 0 12.2% 1,000,612 194 4,934 737 (16,423) 828 990,882 (2,328) 11,785 2,014 (531) 743,704 (19,514) 735,130 0 0 0 0 4,410,997 B-22 Exhibit 3A CITY OF CARLSBAD OPERATING FUNDS REVENUE ESTIMATES REVENUE SOURCE | INTERNAL SERVICE FUNDS WORKERS' COMP SELF-INSURANCE INTEREST INTERDEPARTMENTAL OTHER TOTAL LIABILITY SELF-INSURANCE INTEREST INTERDEPARTMENTAL OTHER TOTAL SELF-INSURED BENEFITS OTHER INTERDEPARTMENTAL TOTAL VEHICLE MAINTENANCE INTERDEPARTMENTAL OTHER TOTAL VEHICLE REPLACEMENT INTERDEPARTMENTAL INTEREST OTHER TOTAL INFORMATION TECHNOLOGY INTERDEPARTMENTAL INTEREST OTHER TOTAL TOTAL INTERNAL SERVICE FUNDS ACTUAL PROJECTED REVENUE REVENUE 2005-06 2006-07 83,156 210,000 2,200,238 2,350,000 70,446 17,202 2,353,840 2,577,202 21,391 20,000 1,284,458 1,375,000 31,113 250,709 1,336,962 1,645,709 44,113 50,000 804,367 817,000 848,480 867,000 2,651,519 2,532,000 (2,839) 23,000 2,648,680 2,555,000 785,771 1,400,000 205,965 380,000 39,516 31,000 1,031,252 1,811,000 4,126,814 4,388,388 86,994 177,000 29,879 43,000 4,243,687 4,608,388 12,462,901 14,064,299 ESTIMATED REVENUE 2007-08 225,000 1,850,420 0 2,075,420 15,887 1,373,000 0 1,388,887 60,666 890,000 950,666 2,712,963 0 2,712,963 1,872,598 350,000 25,000 2,247,598 5,225,500 130,000 0 5,355,500 14,731,034 AS% OF FY 06-07 PROJECTED 7.1% -21.3% -100.0% -19.5% -20.6% -0.2% -100.0% -15.6% 21.3% 8.9% 9.7% 7.2% -100.0% 6.2% 33.8% -7.9% -19.4% 24.1% 19.1% -26.6% -100.0% 16.2% 4.7% DIFFERENCE 2006-07 TO 2007-08 15,000 (499,580) (17,202) (501,782) (4,113) (2,000) (250,709) (256,822) 10,666 -100.0% 83,666 180,963 (23,000) 157,963 472,598 (30,000) (6,000) 436,598 837,112 (47,000) (43,000) 747,112 666,735 B-23 Exhibit 3A CITY OF CARLSBAD OPERATING FUNDS REVENUE ESTIMATES REVENUE SOURCE | REDEVELOPMENT FUNDS VILLAGE OPERATIONS / DEBT SERVICE RENTAL INCOME TAX INCREMENT INTEREST OTHER TOTAL VILLAGE LOW AND MOD INCOME HSNG TAX INCREMENT INTEREST OTHER TOTAL SCCRA OPERATIONS/ DEBT SERVICE TAX INCREMENT OTHER INTEREST TOTAL SCCRA LOW AND MOD INCOME HSNG TAX INCREMENT INTEREST TOTAL TOTAL REDEVELOPMENT FUNDS ACTUAL REVENUE 2005-06 _l 86,486 2,376,529 24,785 21,675 2,509,475 594,132 139,716 0 733,848 8,040 20,000 20,150 48,190 2,680 9,073 11,753 3,303,266 PROJECTED REVENUE 2006-07 45,000 2,600,000 90,000 10,300 2,745,300 650,000 140,000 0 790,000 0 10,000 18,000 28,000 0 16,000 16,000 3,579,300 ESTIMATED REVENUE 2007-08 37,500 2,648,000 70,000 11,000 2,766,500 661,967 145,000 0 806,967 0 0 4,000 4,000 0 14,000 14,000 3,591,467 AS% OF FY 06-07 PROJECTED -16.7% 1.9% -22.2% 6.8% 0.8% 1.8% 3.6% 0.0% 2.2% 0.0% -100.0% -77.8% -85.7% 0.0% -12.5% -12.5% 0.3% DIFFERENCE 2006-07 TO 2007-08 (7,500) 48,000 (20,000) 700 21,200 11,967 5,000 0 16,967 0 (10,000) (14,000) (24,000) 0 (2,000) (2,000) 12,167 ITOTAL OPERATING $166,182,023 $179,026,003 $190,057,479 6.2% $ 11,031,4761 B-24 Exhibit 3A CITY OF CARLSBAD OPERATING FUNDS BUDGET EXPENDITURE SCHEDULE DEPARTMENT GENERAL FUND POLICY AND LEADERSHIP GROUP CITY COUNCIL CITY MANAGER COMMUNICATIONS CITY CLERK CITY ATTORNEY CITY TREASURER TOTAL POLICY/LEADERSHIP GROUP ADMINISTRATIVE SERVICES ADMINISTRATION FINANCE HUMAN RESOURCES RECORDS MANAGEMENT TOTAL ADMINISTRATIVE SERVICES PUBLIC SAFETY POLICE FIRE TOTAL PUBLIC SAFETY COMMUNITY DEVELOPMENT COMMUNITY DEVEL ADMIN GEOGRAPHIC INFORMATION ECONOMIC DEVELOPMENT PLANNING BUILDING TOTAL COMMUNITY DEVELOPMENT COMMUNITY SERVICES LIBRARY CULTURAL ARTS PROGRAM RECREATION SENIOR PROGRAMS TOTAL COMMUNITY SERVICES 2004-05 ACTUALS 318.974 1,134,006 714,618 129,805 1 ,094,532 159,439 3,551 ,374 519,240 2,514,618 1,703,114 736,280 5,473,252 20,578,295 12,840,572 33,418,867 766,522 278,193 192,449 3,418,954 1,844,495 6,500,613 8,230,016 784,317 4,830,031 721,538 14,565,902 2005-06 ACTUALS 336,692 1 ,281 ,088 965,214 143,395 1,126,898 161,239 4,014,526 541 ,333 2,526,183 1,989,763 803,838 5,861,117 22,271 ,585 13,856,441 36,128,026 913,458 435,237 179,969 3,059,069 2,122,622 6,710,355 8,720,695 816,222 5,150,261 723,763 15,410,941 2006-07 ESTIMATED EXPENDITURES 359,770 1,361,030 913,199 227,179 1,198,760 167,997 4,227,935 764,155 3,002,450 2,355,561 910,839 7,033,005 24,396,773 16,453,291 40,850,064 916,529 430,034 188,768 3,218,939 2,265,928 7,020,198 9,305,149 890,794 5,682,609 800,642 16,679,194 2006-07 ADOPTED BUDGET 367,390 1 ,337,951 1,107,724 253,179 1 ,204,032 183,500 4,453,776 743,482 2,970,499 2,242,796 880,095 6,836,872 23,630,515 15,579,211 39,209,726 741,860 418,433 213,608 3,292,390 2,254,670 6,920,961 9,392,745 815,384 5,509,959 898,627 16,616,715 2007-08 PROPOSED BUDGET 392,144 1,625,349 1,048,217 163,669 1 ,264,233 192,675 4,686,287 1,054,532 3,049,051 2,844,348 924,501 7,872,432 25,864,578 17,181,178 43,045,756 706,926 556,882 321,539 3,884,556 2,344,732 7,814,635 9,636,275 842,916 5,764,780 994,046 17,238,017 %INCR (DEC) 06-07 BUD TO 07-08 BUD 6.7% 21 .5% -5.4% -35.4% 5.0% 5.0% 5.2% 41 .8% 2.6% 26.8% 5.0% 15.1% 9.5% 10.3% 9.8% -4.7% 33.1% 50.5% 18.0% 4.0% 12.9% 2.6% 3.4% 4.6% 10.6% 3.7% NOTE: Estimated expenditures may exceed Adopted Budget since they include prior year budget appropriations. B-25 Exhibit 3A CITY OF CARLSBAD OPERATING FUNDS BUDGET EXPENDITURE SCHEDULE DEPARTMENT PUBLIC WORKS PUBLIC WORKS ADMIN ENGINEERING FACILITIES MAINTENANCE PARK MAINTENANCE STREET MAINTENANCE TRAFFIC SIGNAL MAINT TRAILS MAINTENANCE TOTAL PUBLIC WORKS NON-DEPARTMENTAL COMMUNITY PROMOTION COMMUNITY CONTRIBUTIONS BEACH PARKING HOSP GROVE PAYMENT PROPERTY TAX AND OTHER ADMIN DUES & SUBSCRIPTIONS INFRASTRUCTURE REPLACE TRANS MANAGEMENT INCENTIVE PAY DISASTER PREPAREDNESS LEGAL SERVICES TRANSFER TO CIP MISC / TRANSFERS OUT TOTAL NON-DEPARTMENTAL SUBTOTAL GENERAL FUND CONTINGENCIES TOTAL GENERAL FUND 2004-05 ACTUALS 874.618 5,873,943 2,949,783 3,619,918 2,468,340 575,776 76,273 16,438,651 505,831 46,365 0 800,000 415,782 56,701 3,830,000 0 1 ,694,332 12,959 1,037,535 106,382 8,505,887 88,454,546 0 88,454,546 2005-06 ACTUALS 908,189 6,077,519 3,246,660 4,078,500 2,641 ,550 953,587 132,537 18,038,542 338,668 66,500 2,434 800,000 385,531 58,207 4,250,000 0 5,499,701 118,029 600,000 100,491 12,219,561 98,383,068 0 98,383,068 2006-07 ESTIMATED EXPENDITURES 1,173,173 7,908,284 3,715,344 4,859,426 3,599,410 743,406 274,420 22,273,463 0 0 36,000 275,000 446,150 75,200 7,200,000 560,000 0 250,000 0 4,822,605 13,664,955 111,748,814 0 111,748,814 2006-07 ADOPTED BUDGET 977,632 7,208,940 3,786,086 4,749,395 2,907,163 1,013,807 322,658 20,965,681 0 0 36,000 275,000 446,150 75,200 7,200,000 560,000 0 250,000 0 216,000 9,058,350 104,062,081 2,300,000 106,362,081 2007-08 PROPOSED BUDGET 1,123,216 8,646,684 3,823,980 5,208,007 3,060,435 738,997 338,789 22,940,108 0 0 36,000 275,000 550,600 75,700 7,900,000 635,000 0 250,000 0 0 9,722,300 113,319,535 2,300,000 115,619,535 %INCR (DEC) 06-07 BUD TO 07-08 BUD 14.9% 19.9% 1 .0% 9.7% 5.3% -27.1% 5.0% 9.4% - - 0.0% 0.0% 23.4% 0.7% 9.7% 13.4% 0.0% - -100.0% 7.3% 8.9% 0.0% 8.7% B-26 Exhibit 3A CITY OF CARLSBAD OPERATING FUNDS BUDGET EXPENDITURE SCHEDULE DEPARTMENT SPECIAL REVENUE FUNDS POLICE ASSET FORFEITURE COPS FUND POLICE GRANTS HOUSING SECTION 8 HOUSING TRUST LIBRARY ENDOWMENT FUND LIBRARY GIFTS/BEQUESTS TREE MAINTENANCE MEDIAN MAINTENANCE STREET LIGHTING BUENA VISTA CRK CHNL MNT LLD#2 ARTS SPECIAL EVENTS SENIOR DONATIONS CDBG ENTITLEMENT COMMUNITY ACTIVITY GRANTS CULTURAL ARTS PROGRAM RECREATION DONATIONS TOTAL SPECIAL REVENUE FUNDS ENTERPRISE FUNDS WATER OPERATIONS RECYCLED WATER OPERATIONS SANITATION OPERATIONS SOLID WASTE MANAGEMENT GOLF COURSE TOTAL ENTERPRISE FUNDS INTERNAL SERVICE FUNDS WORKERS COMP SELF INSURANCE LIABILITY SELF-INSURANCE SELF-INSURED BENEFITS VEHICLE MAINTENANCE VEHICLE REPLACEMENT INFORMATION TECHNOLOGY TOTAL INTERNAL SERVICE FUNDS 2004-05 ACTUALS 36,327 214,084 29,230 6,430,184 1,537,414 8,400 59,553 688,631 527,712 986,145 102,848 33,443 40,903 6,360 708,862 49,605 13,579 5,040 1 1 ,478,320 19,132,705 1 ,899,952 6,759,281 1,488,108 25,344 29,305,390 2,251 ,837 2,720,853 739,008 2,032,105 1,143,737 4,355,566 13,243,106 2005-06 ACTUALS 81 ,952 118,389 13,905 5,732,31 1 252,157 10,050 117,072 603,624 557,833 1,166,130 44,783 53,057 40,005 8,697 965,152 28,058 13,241 11,670 9,818,086 22,677,472 3,063,364 11,732,177 1 ,703,055 13,676 39,189,744 1 ,333,262 825,491 1,035,587 2,391 ,685 1 ,256,387 4,121,440 10,963,852 2006-07 ESTIMATED EXPENDITURES 0 0 0 5,227,604 359,048 14,000 0 612,615 555,897 947,796 110,162 140,129 32,231 0 470,342 0 8,521 0 8,478,345 26,946,333 3,434,343 8,836,056 2,378,543 0 41 ,595,275 1,817,264 1 ,598,795 914,000 2,485,989 0 5,918,716 12,734,764 2006-07 ADOPTED BUDGET 108,510 141,532 0 6,144,692 433,785 14,000 0 561,909 534,302 1 ,080,408 96,500 129,683 69,461 0 590,353 30,000 18,000 0 9,953,135 25,368,385 3,683,660 8,679,673 2,338,824 0 40,070,542 2,322,112 1,473,618 771 ,000 2,572,977 940,000 5,347,474 13,427,181 2007-08 PROPOSED BUDGET 140,351 219,746 0 6,020,512 436,366 12,350 0 598,368 709,226 1 ,244,978 90,600 248,434 59,520 64,500 602,848 30,000 26,100 16,200 10,520,099 26,048,581 4,971 ,322 10,846,430 3,300,761 0 45,167,094 2,028,576 1,349,977 967,540 2,745,984 865,000 5,034,921 12,991,998 %INCR (DEC) 06-07 BUD TO 07-08 BUD 29.3% 55.3% -2.0% 0.6% -11.8% - 6.5% 32.7% 15.2% -6.1% 91 .6% -14.3% - 2.1% 0.0% 45.0% - 5.7% 2.7% 35.0% 25.0% 41.1% - 12.7% -12.6% -8.4% 25.5% 6.7% -8.0% -5.8% -3.2% NOTE: Estimated expenditures may exceed Adopted budget since they include prior year budget appropriations. B-27 Exhibit 3A CITY OF CARLSBAD OPERATING FUNDS BUDGET EXPENDITURE SCHEDULE DEPARTMENT REDEVELOPMENT VILLAGE OPERATIONS / DEBT SVC VILLAGE LOW/MOD INCOME HSNG SCCRA OPERATIONS / DEBT SVC SCCRA LOW/MOD INCOME HSNG TOTAL REDEVELOPMENT 2004-05 ACTUALS 5,657,983 70,613 776,091 36,995 6,541 ,682 2005-06 ACTUALS 3,325,504 67,190 461,968 30,149 3,884,811 2006-07 ESTIMATED EXPENDITURES 2,979,374 76,925 228,951 45,000 3,330,250 %INCR (DEC) 2006-07 ADOPTED BUDGET 1 ,525,51 1 93,775 206,831 42,535 1,868,652 2007-08 PROPOSED BUDGET 1,609,336 95,604 180,293 43,595 1,928,828 06-07 BUD TO 07-08 BUD 5.5% 2.0% -12.8% 2.5% 3.2% TOTAL OPERATING FUNDS 149,023,044 162,239,561 177,887,448 171,681,591 186,227,554 8.5% B-28 Exhibit 3B CITY OF CARLSBAD CAPITAL FUNDS PROJECTED FUND BALANCES FOR FY 2006-2007 FUND BTD#2 - POINSETTIA LANE/AVIARA PKWY BTD#3 - CANNON ROAD WEST CFD#1 -CITYWIDE 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 RANCHO SANTA FE ROAD PROJECT REDEVELOPMENT VILLAGE REDEVELOPMENT SCCRDA SEWER BENEFIT AREAS SEWER CONNECTION SEWER REPLACEMENT TDA TRAFFIC IMPACT FEE TRANSNET/BIKE TRANSNET/HIGHWAY TRANSNET/LOCAL TRANSNET/STP WATER - MAJOR FACILITY WATER - RECYCLED WATER WATER - REPLACEMENT TOTAL JULY 1 , 2006 UNRESERVED BALANCE 8,374,804 1,155,699 50,375,883 5,760,304 50,915,753 2,222,293 (347,726) 16,701 22,089,463 26,541,772 1,207,366 813,511 1,178,614 2,075,205 829,979 9,731 ,604 38,839,543 11,091,168 790,506 90,280 4,776,096 30,884,082 22,285,948 0 11,231,717 228,295 1,196,773 5,010,069 305,278 18,114,885 3,008,622 18,690,445 349,484,932 ESTIMATED REVENUES 1 ,336,784 680,343 5,765,973 2,074,752 2,626,024 44,848,207 947,620 705,553 8,448,873 15,693,889 297,986 4,398,262 273,305 189,869 229,757 1,002,540 5,886,170 4,720,307 715,000 250,000 720,322 2,418,232 4,507,226 100,000 1,985,707 95,834 51,690 8,797,874 13,237 2,336,465 7,224,426 18,674,645 148,016,870 ESTIMATED EXPENDITURES 0 433,845 4,332,587 3,133,566 3,798,581 42,239,391 255,633 15,362 1 ,965,693 8,898,685 0 433,328 576,000 0 0 606,469 2,049,092 4,650,486 30,454 43,139 159,298 903,964 2,680,360 0 2,089,121 215,762 16,035 4,580,125 0 2,702,142 3,296,386 3,815,944 93,921 ,448 ESTIMATED DEBT SERVICE LOANS & OTHER 0 45,167 206,649 277,698 0 166,103 0 705,245 0 171,780 0 0 0 0 0 426,305 0 35,450 71,719 0 0 2,342,060 350,600 0 0 0 2,301 1,035,843 223,464 0 6,000,000 0 12,060,384 JUNE 30, 2007 PROJECTED BALANCE 9,711,588 1,357,030 51,602,620 4,423,792 49,743,196 4,665,006 344,261 1,647 28,572,643 33,165,196 1,505,352 4,778,445 875,919 2,265,074 1,059,736 9,701 ,370 42,676,621 11,125,539 1 ,403,333 297,141 5,337,120 30,056,290 23,762,214 100,000 11,128,303 108,367 1,230,127 8,191,975 95,051 17,749,208 936,662 33,549,146 391,519,970 I-26 CITY OF CARLSBAD CAPITAL FUNDS PROJECTED FUND BALANCES FOR FY 2007-2008 Exhibit 3B FUND BTD#2 - POINSETTIA LANE/AVIARA PKWY BTD#3 - CANNON ROAD WEST CFDt1 -CITYWIDE 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'S PUBLIC FACILITIES FEE RANCHO SANTA FE ROAD PROJECT REDEVELOPMENT VILLAGE REDEVELOPMENT SCCRDA SEWER BENEFIT AREAS SEWER CONNECTION SEWER REPLACEMENT TDA TRAFFIC IMPACT FEE TRANSNET/BIKE TRANSNET/HIGHWAY TRANSNET/LOCAL TRANSNET/STP WATER - MAJOR FACILITY WATER - RECYCLED WATER WATER - REPLACEMENT TOTAL JULY 1,2007 PROJECTED BALANCE 9,71 1 ,588 1 ,357,030 51 ,602,620 4,423,792 49,743,196 4,665,006 344,261 1,647 28,572,643 33,165,196 1,505,352 4,778,445 875,919 2,265,074 1,059,736 9,701 ,370 42,676,621 11,125,539 1,403,333 297,141 5,337,120 30,056,290 23,762,214 100,000 11,128,303 108,367 1,230,127 8,191,975 95,051 17,749,208 936,662 33,549,146 391,519,970 ESTIMATED REVENUES 131,310 54,797 1,739,179 1,918,628 750,000 0 1 ,963,578 0 7,801,000 0 44,346 0 149,905 80,187 203,140 244,733 2,388,044 7,978,743 100,000 0 151,538 4,033,935 5,280,000 0 594,781 0 0 3,722,000 0 740,931 0 3,934,010 44,004,785 06/30/2007 CONTINUING APPROPR. 349,302 0 1 ,799,345 2,515,418 23,123,305 3,907,140 344,262 0 2,056,112 31 ,006,207 0 4,550,020 0 0 219,100 2,769,097 28,012,884 4,270,438 1,227,013 292,678 1,181,774 13,196,454 10,286,739 100,000 2,841,839 90,262 964,021 2,224,135 0 2,759,024 936,662 9,461,338 150,484,569 07/01/2007 NEW APPROPR. 0 600,000 110,000 618,550 6,312,545 0 405,429 0 1,106,750 0 0 0 0 20,550 0 0 6,255,155 0 0 0 2,000,000 3,304,860 3,536,446 0 396,000 0 0 6,714,571 0 0 0 1,459,923 32,840,779 2007-2008 TOTAL CIP APPROPR. 349,302 600,000 1,909,345 3,133,968 29,435,850 3,907,140 749,691 0 3,162,862 31 ,006,207 0 4,550,020 0 20,550 219,100 2,769,097 34,268,039 4,270,438 1,227,013 292,678 3,181,774 16,501,314 13,823,185 100,000 3,237,839 90,262 964,021 8,938,706 0 2,759,024 936,662 10,921,261 183,325,348 JUNE 30, 2008 PROJECTED BALANCE 9,493,596 811,827 51,432,454 3,208,452 21,057,346 757,866 1,558,148 1,647 33,210,781 2,158,989 1 ,549,698 228,425 1,025,824 2,324,71 1 1,043,776 7,177,006 10,796,626 14,833,844 276,320 4,463 2,306,884 17,588,911 15,219,029 0 8,485,244 18,105 266,106 2,975,269 95,051 15,731,115 0 26,561,895 252,199,407 I-27 Exhibit 3B CITY OF CARLSBAD CAPITAL FUNDS REVENUES ACTUAL AND ESTIMATED FUND BTD#2 - POINSETTIA LANE/AVIARA PKWY BTD#3 - CANNON ROAD WEST CFD#1 -CITYWIDE 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 RANCHO SANTA FE ROAD PROJECT REDEVELOPMENT VILLAGE REDEVELOPMENT SCCRDA SEWER BENEFIT AREAS SEWER CONNECTION SEWER REPLACEMENT TDA TRAFFIC IMPACT FEE TRANSNET/BIKE TRANSNET/HIGHWAY TRANSNET/LOCAL TRANSNET/STP WATER - MAJOR FACILITY WATER - RECYCLED WATER WATER - REPLACEMENT TOTAL CAPITAL FUNDS 2003-2004 ACTUAL REVENUE 2,082,421 0 4,724,143 1,785,785 558,927 0 361 ,048 52,028 3,946,110 11,111,949 47,366 125,004 514,627 30,554 35,582 1,241,432 5,224,343 4,691,448 7,547 245,691 557,429 1,813,446 4,198,825 78,572 975,812 110,471 14,861 4,120,403 1,479 3,064,296 9,009,877 2,877,307 63,608,783 2004-2005 ACTUAL REVENUE 1 ,998,341 44,91 1 7,100,722 1,955,691 2,459,316 354,593 667,538 1,852 4,405,430 29,398,816 99,420 48,251 50,048 1,186,959 462,471 1,711,440 10,023,947 5,191,343 1,445,277 584,004 801,202 2,416,264 1,641,162 5,325 2,014,264 2,797 47,046 2,873,656 8,576 5,164,198 4,678,829 1,393,946 90,237,635 2005-2006 ACTUAL REVENUE 1 ,376,967 94,297 4,595,150 1 ,974,975 2,699,589 551,150 1,127,704 429,683 4,787,770 14,888,674 303,004 216,055 577,594 342,046 180,662 974,397 7,177,940 5,393,508 1,058,550 74,118 362,151 1,672,308 5,271 ,251 1-36,933 1,407,742 65,859 28,618 2,320,925 6,935 3,386,838 10,878,643 5,495,772 79,857,808 2006-2007 ESTIMATED REVENUE 1,336,784 680,343 5,765,973 2,074,752 2,626,024 44,848,207 947,620 705,553 8,448,873 15,693,889 297,986 4,398,262 273,305 189,869 229,757 1,002,540 5,886,170 4,720,307 715,000 250,000 720,322 2,418,232 4,507,226 100,000 1 ,985,707 95,834 51,690 8,797,874 13,237 2,336,465 7,224,426 18,674,645 148,016,870 2007-2008 ESTIMATED REVENUE 131,310 54,797 1,739,179 1,918,628 750,000 0 1,963,578 0 7,801,000 0 44,346 0 149,905 80,187 203,140 244,733 2,388,044 7,978,743 100,000 0 151,538 4,033,935 5,280,000 0 594,781 0 0 3,722,000 0 740,931 0 3,934,010 44,004,785 Note: Revenues include intertund loans and transfers in. I-28 CITY OF CARLSBAD CAPITAL FUNDS BUDGET EXPENDITURE SCHEDULE Exhibit 3B FUND BTD#2 - POINSETTIA LANE/AVIARA PKWY BTD#3 - CANNON ROAD WEST CFD#1 -CITYWIDE 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 RANCHO SANTA FE ROAD PROJECT REDEVELOPMENT VILLAGE REDEVELOPMENT SCCRDA SEWER BENEFIT AREAS SEWER CONNECTION SEWER REPLACEMENT TDA TRAFFIC IMPACT FEE TRANSNET/BIKE TRANSNET/HIGHWAY TRANSNET/LOCAL TRANSNET/STP WATER - MAJOR FACILITY WATER - RECYCLED WATER WATER - REPLACEMENT TOTAL CAPITAL FUNDS 2004-2005 ACTUAL 140,577 141,438 108,553 1 ,445,466 1,639,191 2,571,508 667,538 54,573 749,281 12,631,957 0 1,145,563 612,655 0 0 742,464 8,027,086 1 1 ,798,358 0 21,247 3,020,915 3,902,475 1,565,606 83,792 676,082 - 701,207 3,822,805 9,930 (68,980) 12,581,542 1,930,382 70,723,211 2005-2006 ACTUAL 116 20,312 188,281 2,735,687 2,650,728 26,426,592 1,475,430 445,294 1,459,679 19,972,734 0 216,470 0 0 0 1,230,192 7,653,585 7,944,216 24,576 225,217 629,637 1,244,997 3,927,937 136,933 509,411 32,720 76,019 4,668,118 4,905 501,035 10,004,001 3,347,918 97,752,740 2006-2007 ESTIMATED 0 479,012 4,539,236 3,41 1 ,264 3,798,581 42,405,494 255,633 720,607 1,965,693 9,070,465 0 433,328 576,000 0 0 1 ,032,774 2,049,092 4,685,936 102,173 43,139 159,298 3,246,024 3,030,960 0 2,089,121 215,762 18,336 5,615,968 223,464 2,702,142 9,296,386 3,815,944 105,981,832 2006-2007 CONTINUING APPROPR. 349,302 0 1 ,799,345 2,515,418 23,123,305 3,907,140 344,262 0 2,056,112 31 ,006,207 0 4,550,020 0 0 219,100 2,769,097 28,012,884 4,270,438 1,227,013 292,678 1,181,774 13,196,454 10,286,739 100,000 2,841,839 90,262 964,021 2,224,135 0 2,759,024 936,662 9,461,338 150,484,569 2007-2008 NEW APPROPR. 0 600,000 110,000 618,550 6,312,545 0 405,429 0 1,106,750 0 0 0 0 20,550 0 0 6,255,155 0 0 0 2,000,000 3,304,860 3,536,446 0 396,000 0 0 6,714,571 0 0 0 1,459,923 32,840,779 2007-2008 TOTAL CIP APPROPR. 349,302 600,000 1,909,345 3,133,968 29,435,850 3,907,140 749,691 0 3,162,862 31,006,207 0 4,550,020 0 20,550 219,100 2,769,097 34,268,039 4,270,438 1,227,013 292,678 3,181,774 16,501,314 13,823,185 100,000 3,237,839 90,262 964,021 8,938,706 0 2,759,024 936,662 10,921,261 183,325,348 I-29 Exhibit 3B o C£ S 5 Sa s E E I M 0) Ia g " 3° a 3 00o oo (0 1 a. Z Exhibit 3B 5 sl ID IaE a.re0 § ooIN Exhibit 3B 2 fQ. 4-1 I O. E O.5 ID £Q. fe i 8 S Exhibit 3B > ^s E2012 (U . 3 00o oofM (0 S!a I IS Exhibit 3B 8s SS 5sS s E £ V i Q. .3 00O rsoOIN ra a ItS. itSS Exhibit 3B o £ E S Ok2Q. IQ. E .3 rsooIN £a. (P! 51 Exhibit 3B Sio S I Exhibit 3C PERSONNEL ALLOCATIONS FOR 2006-07 AND 2007-08 MAJOR SERVICE AREA (POLICY AND LEADERSHIP GROUP | CITY COUNCIL CITY MANAGER COMMUNICATIONS CITY TREASURER CITY ATTORNEY [ADMINISTRATIVE SERVICES | ADMINISTRATION RECORDS MANAGEMENT INFORMATION TECHNOLOGY FINANCE RISK MANAGEMENT HUMAN RESOURCES & WORKERS COMP [PUBLIC SAFETY | POLICE FIRE (COMMUNITY DEVELOPMENT | COMMUNITY DEVELOPMENT ADMINISTRATION BUILDING & CODE ENFORCEMENT ECONOMIC DEVELOPMENT & REAL PROPERTY MGMT GEOGRAPHIC INFORMATION SYSTEMS PLANNING HOUSING AND REDEVELOPMENT (COMMUNITY SERVICES | LIBRARY CULTURAL ARTS RECREATION & SENIOR PROGRAMS (PUBLIC WORKS | ADMINISTRATION & ENVIRONMENTAL PROGRAMS ENGINEERING SERVICES GENERAL SERVICES MAINTENANCE & OPERATIONS FINAL BUDGET 2005-06 1.00 6.00 2.75 0.75 7.00 2.00 8.00 16.00 27.00 2.00 10.00 151.00 79.75 4.00 13.00 1.00 2.00 24.00 10.00 48.00 5.00 32.50 14.20 51.60 91.95 49.50 FINAL BUDGET 2006-07 1.00 7.00 3.75 0.75 7.00 2.00 8.00 19.00 28.00 2.00 10.00 157.00 87.75 5.00 13.00 1.00 3.00 27.00 10.00 48.00 5.00 30.50 18.00 54.00 95.25 47.00 PRELIMINARY BUDGET 2007-08 1.00 7.00 3.75 0.75 7.00 2.00 8.00 19.00 28.00 2.00 10.00 162.00 88.75 5.00 13.00 1.00 4.00 27.00 10.00 48.00 5.00 30.50 22.00 55.00 97.25 53.00 2007-08 REQUESTED CHANGES 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 5.00 1.00 0.00 0.00 0.00 1.00 0.00 0.00 0.00 0.00 0.00 4.00 1.00 2.00 6.00 FULL AND 3/4 TIME LABOR FORCE*660.00 690.00 710.00 20.00 B-29 PERSONNEL ALLOCATIONS FOR 2006-07 AND 2007-08 (Continued) Exhibit 3C SUMMARY OF REQUESTED LABOR FORCE BY CATEGORY Full Time Personnel 3/4 Time Personnel in Full Time Equivalents Hourly Full Time Equivalent Personnel TOTAL LABOR FORCE 2005/06 654.00 6.00 147.47 807.47 2006-07 684.00 6.00 144.12 834.12 2007-08 704.00 6.00 137.77 847.77 Difference 20.00 0.00 (6.35) 13.65 LIMITED TERM EMPLOYEES Management Interns Legal Intern Building Inspector Intern Management Analyst (HR) Division Chief Overstaff Building Inspector Limited Term GIS Intern Associate Planner Planning Technician Intern TOTAL LIMITED TERM EMPLOYEES 2005/06 1.50 0.50 0.00 0.00 0.00 2.00 0.50 0.00 1.00 5.50 2006-07 1.50 0.50 0.00 0.00 0.00 2.00 0.50 0.00 1.00 5.50 2007-08 1.50 0.50 0.00 1.00 0.00 2.00 0.50 1.00 0.00 6.50 Difference 0.00 0.00 0.00 1.00 0.00 0.00 0.00 1.00 (1.00) 1.00 * The 2006-07 headcount adopted by City Council on June 20,2006 was 827.12. There were 7 mid year adjustments approved by Council B-30