The URL can be used to link to this page

Home My WebLink About4.03 FinancialRptsMay04 CITY CLERK AGENDA STATEMENT CITY COUNCIL MEETING DATE: June 28, 2004 SUBJECT: Financial Reports for the Month of May 2004 Report Prepared by: Fred W. Marsh, Finance Manager and Lisa Hisatomi, Administrative Analyst II ATTACHMENTS: 1. YTD Revenues and Budget Comparison 2. YTD Expenses and Budget Comparison 3. Financial Statements for the Months of May 2004 REcOMMENDATION:~ Receive the reports. FINANCIAL STATEMENT: See reports for detail of monthly financial activity. DESCRIPTION: This item provides the report on the preliminary financial statements for the month of May. Consistent with prior reports the focus will be on General Fund Revenues and Expenditures, which represent the most significant portion of the City's operations. Analysis-of May 2004 Revenue and Expenditure Report The May report represents the reporting of revenues and expenditures for eleven months of the Fiscal Year. It should be noted that there is not an even distribution of revenues and expenditures on a monthly basis. There is also a lag with the reporting of expenditures due to the significant amount of services provided to the City by independent contractors, including Police and Fire Services. General Fund Revenues Total General Fund Revenues collected through May are comparable to what occurred in the elevertth month of the previous Fiscal Year. Through May 2004, the City had collected approximately 92% of the total budgeted General Fund Revenues, which was 5% m.ore than the percentage collected in the prior Fiscal Year. Property Taxes are higher than in the same period of the prior year due to timing differences related to deductions of property tax receipts for monies due to the Alameda County Surplus Property Authority under its revenue sharing agreement with the City. Sales Tax revenues continue to be slightly ahead when compared to the same period in the prior year. The City experienced a good holiday season, with sales up in the Autos and Transportation, General Consumer Goods and Building and Construction categories over the same quarter for the previous year. Real Property Transfer Tax is higher than in the same period of the prior year due to an increase in the dollar amount of residential and commercial property sales transactions within the City. Transient Occupancy Taxes are lower than in the same period of the prior year due to timing differences and lower than expected tax collections at some of the City's hotels. Franchise Taxes are slightly higher than in the same period of the prior year due to higher collections in Gas and Garbage Franchise taxes. Licenses and COPIES TO: Document in FSCOLOR 05-2004 ITEM NO. Permits are higher than in the same period o~the Pr~°r ~ar due {0 an increase in the valuation of building permits on new residential and commercial projects. Interest Revenue is higher than in the same period in the prior year due to a higher actual rate of return and average cash balance than assumed in the budget. Initially all interest revenue is recorded in the General Fund and is then allocated quarterly to other funds on a pro rata basis. The amount of Vehicle License Fee (VLF) received in the current Fiscal Year has declined from the prior Fiscal Year due to lower car sales Statewide and the State not paying the backfill portion of the VLF for the first three months of the Fiscal Year. Although, as of the writing of this report, the status of funding the VLF backfill is still not settled, there is more published data about the proposal. This material is provided here for information only, since it does not specifically impact the May Financial Report. Under the proposed budget agreement, the VLF backfill will disappear in Fiscal Year 2004-2005. The city and county shares of all lost VLF revenues will be replaced by in lieu property taxes. A cash flow timing differential will occur, since VLF revenues are distributed monthly and property taxes are distributed twice a year. The VLF payment gap amount for the current fiscal year (2003-2004) will be repaid in August 2006, and would be constitutionally protected in the proposed agreement. And, as mentioned in prior monthly financial reports, Council already approved a budget adjustment at the September 16, 2003, Council Meeting reducing the VLF revenue budget by $456,000 to compensate for this expected loss of revenue in Fiscal Year 2003-2004. In the Charges for Services category, as noted in previous financial reports, the City expects to receive approximately $267,000 less in revenue for the fire charges for services revenue item due to a change in how the Alameda County Sheriff's Office is handling calls for emergency service at the Santa Rita location. This is offset, however, by an increase in zoning and subdivision fees. Fines and Forfeitures are higher than in the same period of the prior year due to higher collections of parking fines. Other Revenue is lower than in the same period of the prior year as a significant portion of reimbursements budgeted to be received from the City of Pleasanton, for design of the Fallon Road Freeway Interchange, will not become due until Fiscal Year 2004-2005. General Fund Expenditures Overall, through the month of May expenditures in the General Fund totaled $26.0 million and represented approximately 63% of the total budgeted expenditures in the General Fund. Of this amount, a total of approximately $2,580,000 was related to Capital Improvement Projects and the remainder was related to Operating Costs reported in the General Fund. Capital Project expenditures typically do not follow an even distribution due to differences in project timing. In looking only at General Fund Operating Expenditures, the activity through May 2004 was lower when compared to the amounts expended for the same period in the prior Fiscal Year. Through the end of May 2004, the City had expended 67% of the General Fund Operating Budget, which was 5% less than the percentage expended in the prior Fiscal Year. As previously noted there are some timing differences with payment for contract services, which complicate comparisons from one year to the next. Police is higher than in the same period of the prior year; the City has paid three quarters of contract police services to Alameda County, as opposed to two quarterly payments at this same point in the prior year. Fire Services is lower than same period of the prior year due to timing differences in the billing by Alameda County for contract fire services. Health and Welfare is lower than in the same period of the prior year due to expenditures for consultant services related to a new solid waste franchise agreement not anticipated to be completed until Fiscal Year 2004-2005. Culture and Community Services is lower than in the same period of the prior year due to timing differences in the payment for contract library and park maintenance services. Community Development is lower than in the same period of the prior year due to the carryover of Specific Plan Amendments for the Historic District and Scarier Court to Fiscal Year 2004-2005. Capital Improvement Projects are lower than in the same period of the prior year. Several of the capital projects funded by the General Fund in Fiscal Year 2003-2004 will either not incur major expenditures until later in the Fiscal Year and/or will be carried over to Fiscal Year 2004-2005, including the CTV Studio Remodel, Downtown Improvement Implementation, Senior Center and 1580 / Fallon Road Interchange projects, the latter to be funded by reimbursements fi:om the City of Pleasanton. All expenditures are within the authorized budget. It is recommended that the City Council receive these reports as authorized by Section 41004 of the California Government Code. 3%3 City of Dublin 2003-2004 YTD Revenues and Budget Comparison For the Period Ending May' 31, 2004 Total General Fund Revenues ~i~::~i~i~::~i~i~i::iii:~ii:ii!ii::~?:i::::iiii::i::i::~ii:~iii~::i::i:::.iii~:::.iiiiii::~ii:~i~::i::~i::i::i::?:~ii::::ii::i::i:iii::iii:i:::~i::~:]7 '/o Property Taxes ~~~ 978O~oO- | / _ Sales Taxes ~]~8~°/° :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: 8!~ '/o . · FY 2003/04 ~~ 125% ?:i::?:?: FY 2002/03 Real Property Transfer Tax :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: 7 - ~ 74~°~/~ /° Transient Occupancy Taxes :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: 79 [ oo Franchise Taxes ,~9~ ~~~146°/o Licenses and Permits Interest and Rentals :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: 80 ~o 94% · '~-'"~' '"' '" ' ' I Intergovernmental from State Charges for Services ~ii.-':789; ~o ~'~' '- I'"'"'"'" I Fines and Forfeitures ~~93% - I / Other Revenues ~: :::~:~...-.0....~: ................... 8 0% 30% 60% 90% 120% 150% 92% of Year Complete FY 2003/04 FY 2003/04 % of FY 2002~03 % of Total for Budget YTD Actual Budget YTD Actual FY 2002103 Property Taxes 11,274,729 11,01 7,665 98% 9,700,313 97% Sales Taxes 13,036,000 11,652,449 89% 11,095,595 84% Real Property Transfer Tax 334,000 416,913 125% 277,165 73% Transient Occupancy Taxes 719,550 532,679 74% 566,653 79% Franchise Taxes 1,414,237 1,291,991 91% 1,205,899 86% Licenses and Permits 2,025,003 2,951,663 146% 2,294,108 95% Interest and Rentals 897,550 842,511 94% 1,299,705 80% Intergovernmental 1,916,900 1,483,511 77% 1,875,833 84% Charges for Services 5,072,788 4,008,668 79% 3,872,390 81% Fines and Forfeitures 106,500 98,696 93% 108,843 78% Other Revenues 569,369 247,343 43% 347,099 85% Total General Fund Revenues 37,366,626 34,544,089 92% 32,643,603 87% ATTACHMENT 1 Date Printed: 6114/2004 3:59 PM City of Dublin 2003-2004 YTD Expenses and Budget Comparison For the Period Ending May 31, 2004 Total General Fund ~ 63% Expenses ii!i!i::ili!iiiiiiiiiiiiiiiiiii!ii 73! 1 46% Other Public Safety ~ ~ !!!i::i!?:?:i::iiiiiiiii!iii!ii!i!!i!i!iii?~iiiiiiiiiiiiii!! 64% · FY 2003/04 ~::i::~ FY 2002/03 Transportation .. ~: ', o Culture & Community Community ~ ~9% Development Capital Improv. .............. ................................. 0% 20% 40% 60% 80% 100% 120% 92% of Year Complete 2003~04 2003/04 % of FY 2002103 % of Total for Budget YTD Actual Budget YTD Actual FY 2002103 General Government 4,949,030 3,852,998 78% 3,472,290 80% Police 8,607,117 6,501,266 76% 4,232,246 53% Fire 7,159,187 2,325,629 32% 3,708,155 75% Other Public Safety 351,807 161,095 46% 182,074 64% Transportation 1,610,509 1,216,724 76% 1,038,766 78% Health and Welfare 74,591 38,093 51% 34,538 86% Culture and Community Services 5,371,054 4,060,807 76% 3,751,342 81% Community Development 6,667,757 5,261,801 79% 4,458,421 83% Capital Improvement Projects 6,801,531 2,583,701 38% 3,166,632 83% Total General Fund Expenses 41,592,583 26,002,114 63% 24,044,464 73% General Fund Operating Expenses 34,791,052 23,418,413 67% 20,877,832 72% ATTACHMENT 2 Date Printed: 6/14/2004 3:59 PM CITY OF DUBLIN'S PRO FORMA FINANCIAL STATEMENTS FOR THE MONTH OF MAY 2004 Prepared by The Finance Department June 4, 2004 ATTACHMENT 3 CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31May2004 GENERAL SPECIAL SPECIAL CAPITAL TRUST/ T 0 T A L S REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY ---MEMORANDUM ONLY--- FUNDS FUNDS FUNDS FUNDS FUND CURRENT PRIOR ASSETS CASH (46.028,651) 4.046.064 495.101 33,088.444 170,628 (8.228,414) (21,635,985) CASH WITH FISCAL AGENT 172.779 172.779 172,101 AMOUNT HELD IN ESCROW INVESTMENTS AT COST 102,019.215 102.019.215 90.247.099 RECEIVABLES: TAXES' ACCOUNTS 138.985 37.776 176,761 500,688 INTEREST 542,481 ASSESSMENTS DUE FROM OTHERS 308.720 308 720 INVENTORY AT COST PREPAID ITEMS 13.962 13.962 14.784 FIXED ASSETS AMOUNT TO BE PROVIDED 1.447.500 1 447.500 1.553.500 TOTAL ASSETS 56.452.232 4.083.840 495.101 33 088.444 1.790.907 95.910.523 71.394.669 LIABILITIES/FUND EQUITY DEPOSITS FOR PRIVATE DEVEL (640.186) (640.186) (761.709) DEPOSITS FOR AB1600 FEES (53.685) (53.685) (1.860.579) DEPOSITS OTHERS (1.755.205) (1,755.205) (852.539) PAYABLES: ACCOUNTS (832.885) (187.557) (289.411) (1 309.853) (371.603) INTEREST PAYROLL (473,449) 473.449) (402.757) DUE TO OTHERS (84.209) (308.720) 392.929) (48.928) DEFERRED REVENUE (127.768) 127.768) (127.768) DEBT INSTRUMENTS PAYABLE (1.565.000) (1.565.000) (1.671.000) TOTAL LIABILITIES (3.967.387) (496.277) (289.411) (1.565.000) (6.318.075) (6.097,882) FUND BALANCES (52.484,845) (3.587.562) (495.101) 32.799.034) (225.907) (89.592.448) (64.172.272) TOTAL FUND E (52.484.845) (3.587.562) (495.101) 32.799.034) (225,907) (89.592.448) (64.172.272) TOTAL LIABILITIES/EQUITY (56,452.232) (4.083.840) (495.101) (33.088.444) (1.790.907) (95,910.523) (70.270.154) CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31May2004 INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG T 0 T A L S SERVICE FUND GROUP OF TERM DEBT ---MEMORANDUM--- FUNDS ACCOUNTS ACCOUNT GROUP CURRENT PRIOR ASSETS CASH 8,137,540 (20) 8,137,520 6,876,671 CASH WITH FISCAL AGENT AMOUNT HELD IN ESCROW INVESTMENTS AT COST RECEIVABLES: TAXES ACCOUNTS INTEREST ASSESSMENTS DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS 47.265,633 19.466,456 66.732,089 48.676,346 AMOUNT TO BE PROVIDED 68,676.545 68,676,545 50,612.604 TOTAL ASSETS 55,403,174 (20) 19,466,456 68.676,545 143,546,154 106,165.621 LIABILITIES/FUND EQUITY DEPOSITS FOR PRIVATE DEVEL DEPOSITS FOR AB1600 FEES DEPOSITS OTHERS PAYABLES: ACCOUNTS (17.215) (17,215) INTEREST PAYROLL DUE TO OTHERS DEFERRED REVENUE DEBT INSTRUMENTS PAYABLE (68.676.545) (68,676.545) (50.612,604) TOTAL LIABILITIES (17,215) (68.676,545) (68.693,760) (50,612,604) FUND BALANCES (55.385,959) 20 (19.466.456) (74.852.395) (54,989,573) TOTAL FUND E (55,385,959) 20 (19,466.456) (74,852,395) (54,989,573) TOTAL LIABILITIES/EQUITY (55,403.174) 20 (19.466,456) (68,676,545) (143.546,154)(105 602,177) THE CI'~Y OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2003 THROUGH 05/31/2004 GENERAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********************** PROPERTY TAXES 11,274,729.00 11,017,664.77 257,064.23 10,039,542.89 9,700,313.05 339,229.84 SALES TAX 13,036,000.00 11,652,448.89 1,383,551.11 13,193,407.37 11,095,595.04 2,097,812.33 REAL PROPERTY TRANSFER TAX 334,000.00 416,913.17 (82,913,17) 379,088.81 277,165.46 101,923.35 HOTEL TRANSIENT OCCUPANCY TAX 719,550.00 532,678.95 186,871.05 717,083.07 566,653.10 150,429.97 FRANCHISE TAXES t,414,237.00 1,291,991.49 1~22,245.51 1,394,953.26 1,2051899.27 189,053.99 LICENSES & PERMITS 2,025,003.00 2,951,662.84 (926,659.84) 2,421,884:99 2,294,107.56 127,777.43 FINES & FORFEITURES 106,500.00 98,695.55 7,804.45 139,614.86 108,843.24 30,771.62 USE/MONEY & PROP-INTEREST 751,710.00 726,423.81 25,286.19 1,487,493.37 1,187,719.92 299,773.45 USE/MONEY & PROP-RENTALS 145,840.00 116,086.87 29,753.13 139,019.25 111,985.52 27,033.73 INTERGOVERNMENTAL 1,916,900.00 1,483,510.67 433,389.33 2,234,178.93 1,875,833.22 358,345~71 CHARGES FOR SERVICES 5,072,788.00 4,008,667.88 1,064,120.12 4,760,254.62 3,872,389.55 887,865.07 OTHER SOURCES OF REVENUE 569,369.00 247,343.12 322,025.88 410,713.57 347;099.12 63,614.45 TOTAL REVENUE 37,366,626.00 34,544,088.01 2,822,537.99 37,317,234.99 32,643,604.05 4,673,630.94 ************************** GENERAL GOVERNMENT ACTIVITIES: CITY COUNCIL 250,580.00 189,654.04 60 925.96 196 233.20 177,718.85 18 514.35 CITY ~ANAGER 828.110.00 707 527.27 120,582.73 740 856.35 643.622.74 97 233.61 CENTRAL SERVICES 370,244.00 291 911.12 78.332.88 292 316.29 250.684.83 41 631.46 CITY ATTORNEY 809,047.00 594,058.10 214.988.90 850 821.87 652.142.22 198 679.65 ADMIN SERVICES 1,361,492.00 1.076,672.84 284.819.16 982 221.59 850,117.93 132 103.66 BUILDING MANAGEMENT 717,955.00 668.345.94 49.609.06 757 323.39 598.143.57 159 179.82 INSURANCE COST CENTER 430.405.00 322,440.48 107,964.52 362 022.64 269,691.14 92 331.50 ELECTIONS COST CENTER 2.800.00 2.388.31 411.69 10.91~.84 10,668.84 250.00 NON-DEPARTMENTAL 178,397.00 178.397.00 146.605.38 19.500.00 127,105.38 ACTIVITY TOTAL 4,949 030.00 3.852 998.10 1.096.031.90 4.339.319.55 3.472,290.12 867,029.43 PUBLIC SAFETY POLICE 8.607,117.00 6.501 265.97 2,105.851.03 7,947,078.88 4,232,246.42 3,714,832.46 CROSSING GUARDS 71.462.00 48.914.37 22,547.63 61,878.80 50,242.30 11.636.50 ANIMAL CONTROL 197.194.00 57 513.37 139.680.63 164,564.93 87.887.97 76,676.96 TRAFFIC SIGNALS & STREET LIGHTIN 11,150.00 4.279.16 6.870.84 DISASTER PREPAREDNESS 72,001.00 50 387.87 21.613.13 59.237.80 43,943.46 15.294.34 FIRE SERVICES 7.159,187.00 2,325,629.01 4,833,557.99 4,951,374.82 3.708,154.52 1,243.220.30 ACTIVITY TOTAL 16.118.111.00 8,987.989.75 7.130,121.25 13,184,135.23 8.122,474.67 5.061,660.56 TP, ANSPORTATION PUBLIC WORKS 697,824.00 596.244.04 101,579.96 632.481.15 535 691.02 96.790.13 STREET MAINTENANCE 10,004.00 3.703.99 6,300.01 9,868.95 7 927.19 1,941.76 STREET SWEEPING 145,676.00 98,565.20 47.110.80 122 569.70 92,542.87 30,026.83 STREET TREE MAINTENANCE 118,188.00 80,262.37 37,925.63 76 662.73 51,342.07 25 320.66 STREET LANDSCAPING MAINTENAN 638.817.00 437.948.21 200,868.79 495 105.08 351,263.12 143.841.96 ACTIVITY TOTAL 1.610,509.00 1,216.723.81 393,785.19 1.336,687.61 1.038.766.27 297.921.34 HEALTH & WELFARE WASTE MANAGEMENT 35,341.00 1.700.00 33,641.00 1.798.28 182.78 1,615.50 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2003 THROUGH 05/31/2004 GENERAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE CHILD CARE 18,500.00 18,500.00 15,000.00 13,603.00 1,397.00 SOCIAL SERVICES 1,000.00 1,000.00 6,000.00 6,000.00 HOUSING PROGRAMS 19,750.00 16,893.18 2,856.82 17,501.74 14,751.74 2,750.00 ACTIVITY TOTAL 74,591.00 38,093.18 36,497.82 40,300.02 34,537.52 5,762.50 CULTURE & LEISURE SERVICES LIBRARY SERVICES 553,662.00 386,728.32 166,933.68 485,281.21 373,839.97 111,441.24 CULTURAL ACTIVITIES 138,563.00 102,660.23 35,902.77 121 198.29 105,083.54 16,114.75 HERITAGE CENTER 114,773.00 83,909.23 30,863.77 92 803.62 81,144.18 11,659.44 DUBLIN CEMETERY 54,858.00 43,063.87 11,794.13 31 341.84 21,029.43 10,312.41 PARK MAINTENANCE 1,457,804.00 971,635.55 486,168.45 1,200 226.46 862,347.76 337,878.70 COMMUNITY TV 64,634.00 59,270.72 5,363.28 76 233.17 74,500.07 1,733.10 RECREATION ADMIN 546,233.00 458,303.62 87,929.38 452 646.88 389,843.01 62,803.87 PLAYGROUNDS 281,699.00 195,695.25 86,003.75 230 269.67 192.014.05 38,255.62 SHANNON CENTER 291,253.00 242,003.16 49,249.84 266 989.58 230,765.70 36,223.88 PRESCHOOL 82,780.00 67,287.84 15,492.16 74 354.14 65,084.71 9,269.43 TEENS PROGRAM 111.792.00 73,605.70 38,186.30 100 141.63 80.536.70 19,604.93 ADULT SPORTS 106,190.00 78,525.24 27,664.76 97,087.23 78,928.40 18,158.83 YOUTH SPORTS 113,604.00 102,988.48 10,615.52 93,209.36 83,141.55 10;067.81 COMMUNITY GYM 41,560.00 30,980.53 10,579.47 46,605.98 41,499.89 5,106.09 EMERALD GLEN ACTIVITY CENTER 4,039.00 4,039.00 SPECIAL EVENTS 362,291.00 330,308.91 31,982.09 356,425.65 337,860.49 18,565.16 SENIOR CENTER 222,494.00 188,401.40 34,092.60 183,985.64 154,841.04 29,144.60 RECREATION INSTRUCTION 190,418.00 158,848.98 31,569.02 153,581.45 139,495.80 14,085.65 AQUATICS 379,122.00 271,644.97 107,477.03 338,055.61 258,453.72 79,601.89 PARKS/FACILITIES MANAGEMENT 253,285.00 214,945.46 38.339.54 211,125.63 180,932.48 30,193.15 ACTIVITY TOTAL 5,371,054.00 4,060,807.46 1,310,246.54 4,611,563.04 3,751,342]49 860,220.55 COMMUNITY DEVELOPMENT PLANNING 2,467,581.00 1,896,682.78 570,898.22 1,767,026.63 1,481,805.41 285,221.22 BUILDING SAFETY 1,966,628.00 1,483,969.43 482,658.57 1,467,363.47 1,180,268.84 287,094.63 ENGINEERING 1,923,433.00 1,597,763.21 325,669.79 1,865,709.85 1,541,008.13 324,701.72 ECONOMIC DEVELOPMENT 310,115.00 283,385.24 26,729.76 278,983.20 255,338.48 23,644.72 ACTIVITY TOTAL 6,667,757.00 5,261,800.66 1.405,956.34 5,379,083.15 4,458,420.86 920,662.29 CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 1,798,792.00 202,488.95 1,596,303.05 2,258,752.04 2,057,857.97 200,894.07 COMMUNITY IMPROVEMENTS 989,845.00 639,969.47 349,875.53 442,108.93 400,527.03 41.581.90 PARKS 2,877,063.00 1,336,368.34 1,540,694.66 669,566.48 445,295.94 224,270.54 STREET CONSTRC/IMPROVEMENTS 1,135,831.00 404,874.30 730,956.70 464,048.31 262,950.81 201,097.50 ACTIVITY TOTAL 6,801,531.00 2,583,701.06 4,217,829.94 3,834,475.76 3,166,631.75 667,844.01 TOTAL EXPENDITURES 41,592,583.00 26,002,114.02 t5,590,468.98 32,725,564.36 24.044,463.68 8,681,100.68 EXCESS REVENUE (EXPENDITURES) (4,225,957.00) 8,541,973.99 (12,767,930.99) 4,591,670.63 8,599.140.37 (4,007,469.74) TRANSFERS IN FROM OTHER FUNDS 6,600.00 (6,600.00) 18,560.15 6.600.00 11,960.15 TRANSFERS OUT FROM OTHER FUNDS (20.00) (20.00) REVENUES OVER(UNDER) EXPENDITURES (4,225,957.00) 8,548,573.99 (12,774.530.99) 4,610,210.78 8,605,740.37 3,995,529.59) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2003 THROUGH 05/31/2004 S P E C I AL R E V E'N U E FUNDS CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ************************ PROPERTY TAXES t08,192.00 98,939.83 9,252.17 103,107.58 96,049.33 7,058.25 SALES TAX/OTHER TAXES 333,000.00 237,458.27 95,541.73 380.199.02 300,163.26 80,035.76 FINES & FORFEITURES 149,000.00 126,172.76 22,827.24 134,670.06 98,313.06 36,357.00 USES/MONEY & PROPERTY 36,949.00 41,878.93 (4,929.93) 87,896.70 72,893.73 15.002.97 INTERGOVERNMENTAL FROM STATE 2.002,309.00 2 287.215.30 (284.906.30) 8.768,700.98 6,264,996.98 2,503,704.00 INTERGOVERNMENTAL FROM COUNTY 282.829.00 175.756.00 107.073.00 276.556.50 147.542.00 129.014.50 INTERGOVERNMENTAL FROM FEDERAL 957.394.00 63.322.33 894.071.67 133.137.78 81.348.95 51.788.83 CHARGES FOR SERVICES 981.937.00 942.279.96 39.657.04 920.648.29 875.768.87 ~.879.42 OTHER SOURCES OF REVENUE 102 000.00 110.405.00 (8,405.00) 251.582.51 12.315.28 239.267.23 TOTAL REVENUE 4.953 610.00 4.083.428.38 870,181.62 11.056,499.42 7.949,391.46 3,107.107.96 ************************** PUBLIC SAFETY: POLICE 165,481.00 161,544.96 3,936.04 210.229.18 90.243.93 119.985.25 TRAFFIC SIGNALS & STREET LTG 189.500.00 113.318.61 76,181.39 137.632.61 102.616.00 35.016.61 DISASTER PREPAREDNESS 7.000.00 7.000.00 7.258.78 7.258.78 FIRE SERVICES 250.579.00 27.318.67 223.260.33 204.076.36 217.119.80 (13.043.44) ACTIVITY TOTAL 612.560.00 309.182.24 303.377.76 559.196.93 409,979.73 149.217.20 TRANSPORTATION: STREET MAINTENANCE 237.579.00 150,159.59 87,419.41 238.621.60 120 9t3.37 117.708.23 STREET SWEEPING ACTIVITY TOTAL 237.579.00 150.159.59 87,419.41 238.621.60 120.913.37 117.708.23 HEALTH & WELFARE: WASTE MANAGEMENT 1.295.325.00 609.462.07 685.862.93 1.063.584.65 512.501,72 551.082.93 SOCIAL SERVICES 44.935.00 32.145.11 12.789.89 28,427.00 23.382.38 5.044.62 HOUSING PROGRAMS ACTIVITY TOTAL 1.340.260.00 641.607,18 698 652.82 1,092,011.65 535.884.10 556,127.55 COMMUNITY DEVELOPMENT: ENGINEERING 6.000.00 6.000.00 6.000.00 6.000.00 ACTIVITY TOTAL 6.000.00 6,000.00 6,000.00 6.000.00 CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS 50.000.00 50.000.00 COMMUNITY PROJECTS 773.435.00 773.435.00 36.200.00 36.200.00 PARKS 341.928.00 6.000.00 335,928.00 426.095.00 254.440.00 171.655.00 STREET CONSTRUCTION/IMPROVEMENT 2.443.522.00 1.838.650.02 604.871.98 8.733.595.34 2.312.570.61 6,421.024.73 ACTIVITY TOTAL 3.608.885.00 1,844.650.02 1.764.234.98 9.195.890.34 2.603.210.61 6.592.679.73 - 0 T A L EXPENDITURES 5.805,284,00 2.951,599.03 2,853.684.97 11.091.720.52 3.675.987.81 7.415.732.71 EXCESS REVENUE (EXPENDITURES) (851.674.00) I 131.829.35 (1.983.503.35) (35,221.10) 4.273.403.65 (4.308.624.75) TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER :UNDS 6.600.00 (6.600.00) 18,560.15 3.662.410.97 (3.643,850.82) REVENUES OVER (UNDER) EXPENDITURES (851.674.00) 1,125,229.35 (1,976.903.35) (53,781.25) 610,992.68 664,773.93) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2003 THROUGH 05/31/2004 SPECIAL ASSESSMENT FUNDS CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T,D. VARIANCE *********************** SPECIAL BENEFITS ASSESSMENTS 630.482.00 535,375.93 95,106.07 501,425.07 457,610,11 43,814.96 USES/MONEY & PROP-INTEREST 13.704.00 5,569.63 8 134.37 14,049.83 11,341.69 2.708.14 OTHER SOURCES OF REVENUE 4.000,00 144.29 3 855.71 10,598.97 6,863.08 3,735.89 TOTAL REVENUE 648,186,00 541,089.85 107 096.15 526.073,87 475,814.88 50,258.99 *******EXPENDITURES******* PUBLIC SAFETY: TRAFFIC SIGNALS & STREET LIG 269,686.00 183,327.63 86.358.37 204,778.18 158.874.27 45.903.91 ACTIVITY TOTAL 269,686.00 183,327.63 86.358.37 204,778.18 158.874.27 45.903.91 TRANSPORTATION ~UBLIC WORKS 1.791.00 1,143.85 647.15 1.393.46 1.224.71 168.75 STREET TREE MAINTENANCE 29,768.00 17,320.27 12.447.73 9.437.02 8.390.99 1,046.03 STREET LANDSCAPE MAINTENANCE 355.333.00 198,051.01 157.281.99 264,802.70 200.214.34 64.588,36 ACTIVITY TOTAL 386.892.00 216.515.13 170,376.87 275.633.18 209.830.04 65.803.14 COMMUNITY DEVELOPMENT ENGINEERING 15 250.00 11,555.50 3.694.50 14.565.20 11,752.20 2.813.00 ACTIVITY TOTAL 15 250.00 11,555.50 3.694.50 14.565.20 11,752.20 2,813.00 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS STREET CONSTRUCTION/IMPRVMNT 77 584.00 53,878,94 23,705.06 56,000.00 56.000.00 ACTIVITY TOTAL 77.584.00 53,878.94 23,705.06 56.000.00 56,000.00 T 0 T A L EXPENDITURES 749,412.00 465.277.20 284.134.80 550,976.56 380.456'.51 170.520.05 EXCESS REVENUE (EXPENDITURES) (101,226.00) 75.812.65 (177.038.65) (24,902.69) 95.358.37 (120,261.06) REVENUES OVER (UNDER) EXPENDITURES (101,226~00) 75,812.65 (177,038.65) (24,902.69) 95,358.37 (120.261.06) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2003 THROUGH 05/31/2004 CAPITAL IMPqOVEMENT =UNDS CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********************** USES/MONEY & PROP-INTEREST 759.951.00 480.573.82 279.377.18 1.120.018.43 1.041.798.88 78.219.55 OTHER SOURCES OF REVENUE 19,169,000.00 11.894.096.82 7.274.903.18 10,195,565.15 10.195.565.15 TOTAL REVENUE: 19.928 951.00 12.274.670.64 7.554.280.36 11.315.583.58 1.041.798.88 10.273.784.70 ************************** GENERAL GOVERNMENT ACTIVITIES: CITY ATTORNEY 28.800.00 39.203.44 (10.403.44) 23.902.29 18.691.06 5.211.23 ACTIVITY TOTAL 28.800.00 39.203.44 (10,403.44) 23.902.29 18.691.06 5.211.23 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: HOUSING PROGRAMS 2.505.917.00 1.911.762.80 594.154.20 219.771.73 144.914.61 74.857.12 CULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION ACTIVITY TOTAL COMMUNITY DEVELOPMENT PLANNING 2.561.31 (2.561.31) ACTIVITY TOTAL 2.561.31 (2.561.31) CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 1.056.887.00 1.362.965.43 (306,078.43) 10.315.973.90 8.776,558.67 1.539.415.23 COMMUNITY IMPROVEMENTS PARKS 5.513.453.00 3.138.120.73 2.375~332.27 1.274.709.53 1.081.903.85 192,805.68 STREET CONSTRUCTION/IMPROVEMENT 17.497:892.14 3.832.018.77 13.665 873.37 9 091.559.57 8.687.598.01 403.961.56 ACTIVITY TOTAL 24.068.232.14 8.333.104.93 15.735 127.21 20 682.243.00 18.546.060.53 2.136.182.47 T 0 T A L EXPENDITURES 26,602.949.14 10.284.071.17 16.318 877.97 20.925.917.02 18.712.227.51 2.213.689.51 EXCESS REVENUE (EXPENDITURES) (6,673,998.14) 2.090.599.47 (8.764.597.61) (9.610.333.44)(17.670.428.63) 8.060.095.19 TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS REVENUES OVER (UNDER) EXPENDITURES (6,673.998.14) 2.090.599.47 (8.764.597.61) (9.610.333.44)(17.670.428.63) 8.060.095.19 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2002 THROUGH 05/31/2004 TRUST/AGENCY FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** SPECIAL ASSESSMENTS 204.527.28 (204,527.28) 238,107.33 207,689.64 30,417.69 USES/MONEY & PROP-INTEREST 1,574.51 (1,574.51) 5,009.96 3,698.90 1,311.06 TOTAL REVENUE 206,101.79 (206,101.79) 243,117.29 211,388.54 31,728.75 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 229.893.50 (229,893.50) 233,949.42 232.559.42 1,390.00 ACTIVITY TOTAL 229.893.50 (229,892.50) 233,949.42 232,559.42 1,390.00 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS T 0 T A L EXPENDITURES 229,893.50 (229,893.50) 233,949.42 232,559.42 1,390.00 EXCESS REVENUE (EXPENDITURES) (23,791.71) 23,791.71 9,167.87 (21,170.88) 30,338.75 REVENUES OVER (UNDER) EXPENDITURES (23,791.71) 23,791.71 9.167.87 (21,170.88) 30,338.75 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2003 THROUGH 05/31/2004 INTERNAL SERVICE FUNDS CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ************************ USES/MONEY & PROP-INTEREST 145,333.00 102,560.75 42,772.25 209.125.89 178,599.72 30,526.17 CHARGES FOR SERVICES 1,590,277.00 1,468,207.42 122,069.58 1,326,711.49 1,215,936.16 110,775.33 OTHER SOURCES OF REVENUE 21,000.00 5,580.00 15,420.00 12.629.422.53 17,630.53 12,611,792.00 TOTAL REVENUE 1,756,610.00 1,576,348.17 180,261.83 14,165,259.91 1,412,166.41 12,753,093.50 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL 1,496,152.00 426,508.77 1,069,643.23 2.344,963.06 808,141.90 1,536,821.16 ACTIVITY TOTAL 1,496,152.00 426.508.77 1,069,643.23 2.344,963.06 808,141.90 1,536,821.16 PUBLIC SAFETY: FIRE 64,285.00 26,587.31 37,697.69 57,775.63 40,560.59 17,215.04 ACTIVITY TOTAL 64,285.00 26.587.31 37,697.69 57,775.63 40,560.59 17,215.04 TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: T 0 T A L EXPENDITURES 1,560,437.00 453,096.08 1,107,340.92 2,402,738.69 848,702.49 t,554,036.20 EXCESS REVENUE (EXPENDITURES) 196,173.00 1,123,252.09 (927,079.09) 11,762,521.22 563,463.92 11,199,057.30 TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHERFUNDS REVENUES OVER (UNDER) EXPENDITURES 196.173.00 1.123,252.09 (927,079.09) 11,762.521.22 563.463.92 11.199.057.30 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2003 THROUGH 05/31/2004 ENTERPRISE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********************** USES/MONEY & PROP-INTEREST TOTAL REVENUE ********EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 20.00 20.00 20.00 20.00 FINANCE ACTIVITY TOTAL 20.00 20.00 20.00 20.00 PUBLIC SAFETY: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: T 0 T A L EXPENDITURES 20.00 20.00 20.00 20.00 EXCESS REVENUE (EXPENDITURES) (20.00) (20.00) (20.00) 20.00) TRANSFERS IN FROM OTHER FUNDS (20.00) (20.00) TRANSFERS OUT TO OTHER FUNDS REVENUES OVER (UNDER) EXPENDITURES (20.00) (20.00) (20.00) 20.00