The URL can be used to link to this page

Home My WebLink AboutItem 4.10 FinancialRptMarch04 CITY C'LERK F,, #1 AGENDA STATEMENT CITY COUNCIL MEETING DATE: April 20, 2004 SUBJECT: Financial Reports for the Month of March 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 March 2004 RECOMMENDAT!ON: ~~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 March. 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 March 2004 Revenue and Expenditure Report The March report represents the reporting of revenues and expenditures for the first nine months of the Fiscal Year. It should be noted that there is not an even distribution of revenues and expenditures on a monthly basis. Major amounts of Property Taxes and Sales Taxes are not received until later in the Fiscal Year. There is also a lag with the reporting of expenditures due to the significant amount of services provided to the City by independent contractors. General Fund Revenues Total General Fund Revenues collected through March are comparable to what occurred in the ninth month of the previous Fiscal Year. Through March 2004, the City had collected approximately 69% of the total budgeted General Fund Revenues, which was 1% more than the percentage collected in the prior Fiscal Year. Sales Tax revenues continue to be slightly ahead when compared to the same period in the prior year. The amount of sales tax reported through the end of March includes actual sales taxes received through December 2003. 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; the amount of real property transfers in March 2004 was approximately $60,000 higher than in the same month from the prior year. 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. Licenses and Permits are COPIES TO: l)ocument in FSCOLOR 03-2004[~'~ ITEM NO. ~.10 higher than in the same period of the prior year due to an increase in the valuation of building permits on new residential and commercial projects. Interest Revenue is lower than in the same period in the prior year due to significant market value increases that occurred in the City's investments in the prior year, a change in the method of allocating interest to all fimds (from semi annually to quarterly) and. timing differences in the receipt of interest payments. 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. As of the writing of this report, the status of fimding the VLF backfill is still not settled. As mentioned in the 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. Unless the State does pass legislation that provides funding to reestablish the payment of the backfill portion of the fee, the City could still realize an additional loss of approximately $180,000 in VLF for Fiscal Year 2003-04, as previously reported to Council as part of the mid year report for the current Fiscal Year. 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 Sheriffs department are handling calls for emergency service at the Santa Rita location, which is offset by the increase in zoning and subdivision fees. Fines and Forfeitures are higher than in the same period of the prior year due to an increase in parking fines. Other Revenue is lower than in the same period of the prior year due to the fact that reimbursements from the City of Pleasanton for design of improvements to the Fallon Road I 580 Interchange are not expected to be received until later in the Fiscal Year. General Fund Expenditures Overall, through the month of March expenditures in the General Fund totaled $20.1 million and represented approximately 49% of the total budgeted expenditures in the General Fund. Of this amount, a total of approximately $1,860,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 iMarch 2004 was slightly higher when compared to the amounts expended for the same period in the prior Fiscal Year. Through the end of March 2004, the City had expended 53% of the General Fund Operating Budget, which was 10% more 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 due to timing differences in the billing by Alameda County for contract police services. Health and Welfare is higher than in the same period of the prior year due to timing differences in the payments for contract child care support services and expenditures incurred for an update to the City's housing element that was originally anticipated to occur in Fiscal Year 2002-2003. Culture and Community Services are lower than in the same period of the prior year due to timing differences on expenditures incurred for Special Events programs. 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 carded over to Fiscal Year 2004-2005, including the Geographic Information System, CTV Studio Remodel, Senior Center and 1580 / Fallon Road Interchange projects, the latter to be funded by reimbursements from the City of Pleasanton as previously discussed. 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. City of Dublin 2003-2004 YTD Revenues and Budget Comparison For the Period Ending March 31, 2004 Total General Fund Revenues 68% Property Taxes :ii'. 168 Yo Sales Taxes 0% · Fy 2003/04 Real Property Transfer Tax ~...,,~ I 11,)% [] FY 2002/03 - - 59% Transient Occupancy Taxes :~ /66% Franchise Taxes 44~o~ Licenses and Permits i~ ~ 1 i5% Interest and Rentals ~ 18~,% Intergovernmental from State 68% Charges for Services il 63 73% Fines and Forfeitures 7o Other Revenues i ~5, [%0 0% 30% 60% 90% 120% 150% 75% of Year Complete FY 2003/04 FY 2003/04 % of FY 2002/03 % of Total for . Budget YTD Actual Budget YTD Actual FY 2002/03 Property Taxes 11,274,729 7,722,089 68% 6,776,841 68% Sales Taxes 13,036,000 9,588,981 74% 9,179,195 70% Real Property Transfer Tax 334,000 366,842 110% 226,220 60% Transient Occupancy Taxes 719,550 424,821 59% 470,103 66% Franchise Taxes 1,414,237 641,987 45% 608,330 44% Licenses and Permits 2,025,003 2,334,848 115% 1,927,976 80% Interest and Rentals 897,550 443,964 49% 1,328,017 82% Intergovernmental 1,916,900 1,113,699 58% 1,521,305 68% Charges for Services 5,072,788 3,008,418 59% 2,978,618 63% Fines and Forfeitures 106,500 78,079 73% 69,537 50% Other Revenues 551,071 125,168 23% 221,176 54% Total General Fund Revenues 37,348,328 25,848,896 69% 25,307,318 68% ATTACHMENT 1 Date Printed: 4/5/2004 2:41 PM City of Dublin 2003-2004 YTD Expenses and Budget Comparison For the Period Ending March 31, 2004 Total General Fund Expenses General Government 61% 64% Police Fire Other Public Safety · FY 2003/04. [] FY 2002/03 Transportation Health and Welfare Culture & Community Services Community Development Capital Improv. Projects 0% 20% 40% 60% 80% 100% 120% 75% of Year Complete 2003104 2003104 % of FY 2002/03 % of Total for Budget YTD Actual Budget YTD Actual FY 2002~03 General Government 5,034,541 3,094,794 61% 2,790,382 64% Police 8,605,571 4,395,806 51% 703,621 9% Fire 7,159,187 2,259,585 32% 1,437,808 29% Other Public Safety 351,758 134,190 38% 109,367 38% Transportation 1,607,102 955,753 59% 794,292 59% Health and Welfare 47,941 36,393 76% 23,851 59% Culture and Community Services 5,355,601 3,217,245 60% 2,987,565 65% Community Development 6,623,591 4,175,368 63% 3,567,455 66% Capital Improvement Projects 6,057,383 1,863,755 31% 2,087,249 54% Total General Fund Expenses 40,842,675 20,132,889 49% 14,501,590 44% General Fund Operating Expenses 34,785,292 18,269,134 53% 12,414,341 43% ATTACHMENT 2 Date Pdnted: 4/5~2004 2:45 PM CITY OF DUBLIN'S PRO FORMA FINANCIAL STATEMENTS FOR THE MONTH OF MARCH 2004 Prepared by The Finance Department April 5, 2004 ATTACHMENT 3 CiTY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31Mar2004 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 (42,294,526) 3,494,744 410,844 31,989,940 98,733 (6,300.265) (19,159,666) CASH WITH FISCAL AGENT 172,779 172,779 171,989 AMOUNT HELD IN ESCROW INVESTMENTS AT COST 95,104,441 95,104,441 92,495,028 RECEIVABLES: TAXES ACCOUNTS 138,985 37,776 176,761 500,688 INTEREST 200,330 200,330 542,48t ASSESSMENTS DUE FROM OTHERS 308,720 308.720 INVENTORY AT COST PREPAID ITEMS 8.040 8,040 10,065 FIXED ASSETS AMOUNT TO BE PROVIDED 1,447,500 1,447,500 1,553,500 TOTAL ASSETS 53,465,991 3,532,520 410,844 31,989,940 1,719,012 91,118,306 76,114,084 LIABILITIES/FUND EQUITY DEPOSITS FOR PRIVATE DEVEL (825,046) (825,046) (1,013,697) DEPOSITS FOR AB1600 FEES (21,341) (97,375) (118,716) (1,390,821) DEPOSITS OTHERS (1,450,079) (1,450,079) (926,761) PAYABLES: ACCOUNTS (863,842) (177,579) (5,031) (247,076) (1,293,529) (386,308) INTEREST PAYROLL (499,633) (499,633) (415,265) DUE TO OTHERS (19,403) (308,720) (328,124) (49,537) DEFERRED REVENUE (127,768) (127,768) (127,768) DEBT INSTRUMENTS PAYABLE (1,565.000) (1,565,000) (1,671,000) TOTAL LIABILITIES (3,807,113) (486,300) (5,031) (344,451) (1.565,000) (6,207,895) (5,981.156) FUND BALANCES (49,658,878) (3,046,220) (405,813) (31,645,488) (154,012) (84,910,411) (64,172,272) TOTAL FUND E (49,658,878) (3,046,220) (405,813) (31.645,488) (154,012) (84,910,411) (64,172,272) TOTAL LIABILITIES/EQUITY (53,465,991) (3,532,520) (410,844) (31,989,940) (1,719,012) (91,118,306) (70,153,428) CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31Mar2004 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 7,871,847 (20) 7,871,827 6,812,602 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,614,106 TOTAL ASSETS 55,137,480 (20) 19,466,456 68,676,545 143,280,461 106,103,054 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,614.106) TOTAL LIABILITIES (17,215) (68.676,545) (68,693,760 (50,614,106) FUND BALANCES (55,120.265) 20 (19;466,456) (74,586,701 (54,989,573) TOTAL FUND E (55,120,265) 20 (19,466,456) (74,586,701 (54.989,573) TOTAL LIABILITIES/EQUITY (55,137,480) 20 (19,466,456) (68,676.545) (143,280,461)(105,603.679) THE CITY OF DUBLIN STATEMENTSHOWING ~--~t REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2003 THROUGH 03/31/2004 GENERAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********************* PROPERTY TAXES 11,274,729.00 7,722,088.64 3,552,640.36 10,039,542.89 6,776,840.82 3,262,702.07 SALES TAX 13,036,000.00 9,588,980.75 3,447,019.25 13,193,407.37 9,179,195.04 4,014.212.33 REAL PROPERTY TRANSFER TAX 334,000.00 366,841.60 (32,841.60) 379,088.81 226,220.43 152,868.28 HOTEL TRANSIENT OCCUPANCY TAX 719,550.00 424,821.01 294,728.99 717,083.07 470,102.54 246,980.53 FRANCHISE TAXES 1,414,237~00 641,986.72 772,250.28 1,394,953.26 608.329.71 786,623.55 LICENSES & PERMITS 2,025 003.00 2,334.847.56 (309,844.56) 2,421,884.99' 1,927,976.12 493,908.87 FINES & FORFEITURES 106 500.00 78,078.79 28,421.21 139,614.86 69,536.65 70,078.21 USE/MONEY & PROP-INTEREST 751 710.00 349,368.92 402,341.08 1,487,493.37 1.235,355.79 252.137.58 USE/MONEY & PROP-RENTALS 145 840.00 94,595.57 51,244.43 139,019.25 92,661.12 46,358.13 INTERGOVERNMENTAL 1,916 900.00 1,113,698.94 803,201.06 2,234,178.93 1,52t,305.28 712,873.65 CHARGES FOR SERVICES 5,072 788.00 3,008,418.04 2,064,369.96 4,760,254.62 2.978,618.37 1,781,636.25 OTHER SOURCES OF REVENUE 551 071.00 125,167.57 425,903.43 410,713.57 221,176.38 1891537.19 TOTAL REVENUE 37,248,328.00 25,848,894.11 11,499,433.89 37,317.234.99 25,307.318.25 12,009,916.74 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: CITY COUNCIL 248,650.00 157,435.94 91,214.06 196 233.20 155,121.84 41,111.36 CITY MANAGER 823,204.00 578,941.71 244,262.29 740856.35 534,131.35 206,725.00 CENTRAL SERVICES 369,960.00 245,783.14 124,176.86 292 316.29 207,788.31 84,527.98 CITY A-FFORNEY 809,047.00 448,863.12 360,183.88 850 821.87 520,798.98 330,022.89 ADMIN SERVICES 1,360.195.00 895,654.14 464,540.86 982.221.59 697,198.39 285,023.20 BUILDING MANAGEMENT 717,595.00 484,597.56 232,997.44 757~323.39 478,994.64 278,328.75 INSURANCE COST CENTER 430,405.00 281,129.65 149,275.35 362,022.64 175.779.83 186,242.81 ELECTIONS COST CENTER 2,800.00 2,388.31 411~69 10,918.84 10,668.84 250.00 NON-DEPARTMENTAL 272,685.00 272,685.00 146,605.38 9,900.00 136,705.38 ACTIVITY TOTAL 5,034,541.00 3,094,793.57 1,939,747.43 4,339,319.55 2,790,382.18 1,548,937.37 PUBLIC SAFETY POLICE 8,605,571.00 4,395,805.70 4,209,765.30 7,947,078.88 703,620~80 7,243,458.08 CROSSING GUARDS 71.462.00 33 513.12 37,948.88 61,878.80 36,60Z. 06 25,271.74 ANIMAL CONTROL 197,194.00 57 513.37 139,680.63 164.564.93 361194.97 128,369.96 TRAFFIC SIGNALS & STREET LIGHTIN 11,150.00 2 690.34 8,459.66 DISASTER PREPAREDNESS 71,952.00 40 472.80 31,479.20 59,237.80 36,564.64 22.673.16 FIRE SERVICES 7,159,187.00 2,259 584.70 4,899,602.30 4,951.374.82 1,437,808.22 3,513,566.60 ACTIVITY TOTAL 16,116,516.00 6,789 580.03 9,326,935.97 13,184,135.23 2,250,795.69 10,933,339.54 TRANSPORTATION PUBLIC WORKS 694,417.00 488,266.73 206,150.27 632,481.15 436,075.07 196,406.08 STREET MAINTENANCE 10,004.00 3,703.99 6,300.01 9,868.95 5,973.33 3,895.62 STREET SWEEPING 145,676.00 77,438.64 68,237.36 122,569.70 73,164.78 49,404.92 STREET TREE MAINTENANCE 118,188.00 52,819.81 65,368.19 76,662.73 37,911.38 38,751.35 STREET LANDSCAPING MAINTENAN 638,817.00 333,523.45 305,293.55 495,105.08 241.166.96 253,938.12 ACTIVITY TOTAL 1,607,102.00 955,752.62 651,349.38 1,336.687.61 794.291.52 542,396.09 HEALTH & WELFARE WASTE MANAGEMENT 8,691.00 8,691.00 1,798.28 51.78 1,746.50 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2003 THROUGH 03/31/2004 G E'N E RAL 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 10,587.00 4,413.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 7,211.74 10,290.00 ACTIVITY TOTAL 47,941.00 36,393.18 11,547.~2 40,300.02 23,850.52 16,449.50 CULTURE & LEISURE SERVICES LIBRARY SERVICES 553,662.00 258,126.33 295 535.67 485,281.21 239,659.00 245,622.21 CULTURAL ACTIVITIES 138,088'.00 93,342.94 44 745.06 121,198.29 94,261.16 26,937.13 HERITAGE CENTER 114,188.00 72,623.77 41 564.23 92,803.62 61,442.78 31,360.84 DUBLIN CEMETERY 54,858.00 32,693.86 22 164.14 31,341.84 17.070.97 14,270.87 PARK MAINTENANCE 1,457,804.00 777,445.77 680 358.23 1,200~226.46 703,851.04 496,375 42 COMMUNITY TV 64 634.00 58,816.22 5 817.78 76,233']17 72,344131 31888.86 RECREATION ADMIN 541 383.00 371,000.47 170 382.53 452,646.88 319,684.86 132,962.02 PLAYGROUNDS 281 699.00 163,486.26 118 212.74 220,269.67 157,110.64 73,159.03 SHANNON CENTER 291 253.00 199,789.20 91 463.80 266,989.58 188,658.21 78,331.37 PRESCHOOL 82 383.00 55,897.77 26485.23 74,354.14 53,515.30 20,838.84 TEENS PROGRAM 111 392.00 56,126.57 55265.43 100,141.63 66,005.49 34,136.14 ADULT SPORTS 105 034.00 67,118.01 37,915.99 97,087.23 63,679.10 33,408.13 YOUTH SPORTS 113 604.00 85,707.89 27,896.11 93,209.26 69,338.00 23,871.36 COMMUNITY GYM 41 560.00 23,268.13 18,291.87 46,605.98 30,144.35 16,461.63 EMERALD GLEN ACTIVITY CENTER 4,039.00 4,039.00 SPECIAL EVENTS 361,928.00 233,864.16 128.063.84 356,425.65 252,435.93 103,989.72 SENIOR CENTER 219,073.00 152,188.17 66,884.83 183,985.64 123,773.55 601212.09 RECREATION INSTRUCTION 190,418.00 129,789.03 60,628.97 152,581.45 113,781.68 39,799.77 AQUATICS 379,122.00 207,367.49 171,754.51 338,055.61 211,867.45 126,t88.16 PARKS/FACILITIES MANAGEMENT 249,479.00 178,593.14 70,885.86 211,125:63 148,940.78 62,184.85 ACTIVITY TOTAL 5,355,601.00 3,217,245.18 2,138,355.82 4,611,563.04 2,987,564.60 1,623,998.44 COMMUNITY DEVELOPMENT PLANNING 2,451,689.00 1,490,220.52 961,468.48 1,767,026.63 1,163,423~49 603,603.14 BUILDING SAFETY 1,961,288.00 1.183,315.80 777,972.20 1,467,363.47 919,185.64 548,177.83 ENGINEERING 1,900,705.00 1,241,708.79 658,996.21 1,865,709.85 1,254,107.95 611,601.90 ECONOMIC DEVELOPMENT 309,909.00 260,122.67 49.786.33 278,982.20 220,738.22 48,244.98 ACTIVITY TOTAL 6,623,591.00 4.175,367.78 2,448,223.22 5,379,082.15 3,567,455.30 1,811,627.85 CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 1,087,442.00 163 503.61 923,938.39 2,258,752.04 1,367,402.85 891,249.19 COMMUNITY IMPROVEMENTS 989,845.00 621 625.22 368,219.78 442,108.93 224,846.71 217,262.22 PARKS 2,869,563.00 821 983.45 2,047,579.55 669,566.48 278,811.41 390,755.07 STREET CONSTRC/IMPROVEMENTS 1,110,533.00 256 642.49 853,890.51 464,048.31 216,188.08 247~860.23 ACTIVITY TOTAL 6,057,383.00 1,863 754.77 4,193,628.23 3,834,475.76 2,087,249.05 1,747,226.71 TOTAL EXPENDITURES 40,842,675.00 20,132 887.13 20,709,787.87 32,725,564.36 14,501,588.86 18,223,975.50 EXCESS REVENUE (EXPENDITURES) (3,494,347.00) 5,716,006.98 (9,210,353.98') 4,591,670.63 10,805,729.39 (6,214,058.76) 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 (3,494,347.00 5,722,606.98 (9,216,953.98) 4,610,210.78 10',812,229.39 (6,202,118.61) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2003 THROUGH 03/31/2004 spEcIAL REVENUE FUNDS CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.~.D. VARIANCE *********************** PROPERTY TAXES 108,192.00 67,410.93 40,781.07 103,107.58 65,092.95 38,014.63 SALES TAX/OTHER TAXES 333,000.00 212,942.44 120,057.56 380,199.02 232,783.66 147,415.36 FINES & FORFEITURES 149,000.00 98,606.11 50,393.89 134,670.06 87.377.34 47,292.72 USES/MONEY & PROPERTY 36,949.00 20,255.06 16,593.94 87,896.70 72,893.73 15,002.97 INTERGOVERNMENTAL FROM STATE 2,002,309.00 2,137,215.85 (134,906.85) 8,768,700.98 5,466,982.26 3,301,718.72 INTERGOVERNMENTAL FROM COUNTY 282,829.00 113,161.00 169,668.00 276,556.50 121,495.50 1~5,061.00 INTERGOVERNMENTAL FROM FEDERAL 957,394.00 52,371.14 905,022.86 133,137.78 77,701.14 55,436.64 CHARGES FOR SERVICES 981,937.00 648,209.71 333,727.29 920,648.29 599,221.14 321,427.15 OTHER SOURCES OF REVENUE 102,000.00 102,000.00 251,582.51 1,939.28 249,643.23 TOTAL REVENUE 4,953,610.00 3,350,272.24 1,603,337.76 11,056,499.42 6,725,487.00 4,331,012.42 ************************** PUBLIC SAFETY: POLICE 165,481.00 149,232.85 16,148.15 210.229.18 40,271.14 169,958.04 TRAFFIC SIGNALS & STREET LTG 189,500.00 91,772.48 97,727.52 137,632.61 71,257.96 66,374.65 DISASTER PREPAREDNESS 7,000.00 6,409.97 590.03 7,258.78 7,258.78 FIRE SERVICES 250,579.00 27,318.67 223,260.33 204,076.36 51,160.25 152,916.11 ACTIVITY TOTAL 612,560.00 274,833.97 337,726.03 559,!96.93 162,689.35 396,507.58 TRANSPORTATION: STREET MAINTENANCE 237,579.00 118,498.55 119,080.45 228,621.60 101,767.51 136,854.09 STREET SWEEPING ACTIVITY TOTAL 237,579.00 118,498.55 119,080.45 228,621.60 101,767.51 136,854.09 HEALTH & WELFARE: WASTE MANAGEMENT 1,295,325.00 609,434.26 685,890.74 1,063,584.65 511,936.28 551,648.27 SOCIAL SERVICES 44,935.00 30,137.37 14,797.63 28,427.00 16,998190 11,428.10 HOUSING PROGRAMS ACTIVITY TOTAL 1,340,260.00 639,571.63 700,688.37 1,092,011.65 528,935.28 563,076.37 COMMUNITY DEVELOPMENT: ENGINEERING 6,000.00 6,000.00 6,000.00 1,407.00 4,593.00 ACTIVITY TOTAL 6,000.00 6.000.00 6,000.00 1,407.00 4,593.00 CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS 50.000.00 50,000.00 COMMUNITY PROJECTS 770,167.00 770,167.00 36,200.00 36,200.00 PARKS 341,928.00 6,000.00 335,928.00 426,095.00 292,132.00 133,963.00 STREET CONSTRUCTION/IMPROVEMENT 2,443,522.00 1,714,880.97 728,641.03 8,733,595.34 2,240,618.29 6,492,977.05 ACTIVITY TOTAL 3,605,617.00 1,720,880.97 t.884,736.03 9,195,890.34 2,532,750.29 6,663.140.05 T 0 T A L EXPENDITURES 5,802,016.00 2,759,785.12 3,042,230.88 11,091,720.52 3,327,549.43 7,764.171.09 EXCESS REVENUE (EXPENDITURES) (848,406.00) 590~487.12 (1,438,893.12) (35,221.10) 3,397,937.57 (3,433,158.67) TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS 6,600.00 (6,600.00) 18,560.15 856.531.16 (837,97i.01) REVENUES OVER (UNDER) EXPENDITURES (848,406.00) 583,887.12 (1,432,293.12) (53,781.25) 2,541,406.41 (2,595,187.66) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2003 THROUGH 03/31/2004 SPECIAL ASSESSMENT FUNDS CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********************** SPECIAL BENEFITS ASSESSMENTS 630,482.00 357,259.41 273,222.59 501,425.07 307,885.97 1931539.10 USES/MONEY & PROP-INTEREST 13,704.00 2,558.64 11,145.36 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 359,962.24 288,223.66 526,073.87 326,090.74 199,983.13 *******EXPENDITURES******* PUBLIC SAFETY: TRAFFIC SIGNALS & STREET LIG 269,686.00 144,704.74 124,981.26 204,778.18 105,607.22 99,170.95 ACTIVITY TOTAL 269,686.00 144,704.74 124,981.26 204,778118 105,607.23 99,170195 TRANSPORTATION PUBLIC WORKS 1,791.00 1,108.60 682.40 1,393.46 1,111.49 281.97 STREET TREE MAINTENANCE 29,768.00 7,602.69 22,165.21 9,437.02 7,203.51 2,233.51 STREET LANDSCAPE MAINTENANCE 355,333.00 158,662.00 196,671.00 264,802.70 170,328.68 94,474.02 ACTIVITY TOTAL 386,892.00 167,373.29 219,518.71 275,633.18 178,643.68 96.989.50 COMMUNITY DEVELOPMENT ENGINEERING 15,250.00 9,255.50 5,994.50 14,565~20 9,452.20 5,113.00 ACTIVITY TOTAL 15,250.00 9,255.50 5,994.50 14,565.20 9,452.20 5,113.00 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS STREET CONSTRUCTION/IMPRVMNT 77,584.00 52,103.68 25,480.32 56,000.00 56,000.00 ACTIVITY TOTAL 77,584.00 52,103.68 25,480.32 56,000.00 56,000.00 T 0 T A L EXPENDITURES 749,412.00 373,437.21 375,974.79 550,976.56 293,703.11 257,273.45 EXCESS REVENUE (EXPENDITURES) (101,226.00) (13,474.87) (87,751.13) (24,902.69) 22,387.63 (57,290.32) REVENUES OVER (UNDER) EXPENDITURES (101,226.00) (13,474.87) (87,751.t3) (24,902.69) 32,387.63 (57,290.32) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2003 THROUGH 03/31/2004 CAPITAL IMPROVEMENT FUNDS CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUE******** USES/MONEY & PROP-INTEREST 759,951.00 234,346.93 525,604.07 1,120,018.43 1,041,798.88 78,219.55 OTHER SOURCES OF REVENUE 19,169,000.00 9,287,768.38 9,881,231.62 10,195,565.15 10,195,565.15 TOTAL REVENUE: 19,928,951.00 9,522,115.31 10,406,835.69 11,315,583.58 1,041,798.88 10,273,784.70 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: CITY ATTORNEY 28,800.00 11,848.44 16,951.56 23,902.29 17,996.86 5,905.'43 ACTIVITY TOTAL 28,800.00 11,848.44 16,951.56 23,902.29 17,996.86 5,905.43 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: HOUSING PROGRAMS 2,496,948.00 1,822,838.93 674,109.07 219,771.73 85,335.22 124,436.51 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,177.63 (3.05,290.63) 10,3151973.90 7,716,783.24 2,599:'190.66 COMMUNITY IMPROVEMENTS PARKS 5,513,453.00 2,762,463.89 2,750,989.11 1,274,709.53 994,418.32 280,291.21 STREET CONSTRUCTION/IMPROVEMENT 17,409,516.00 2,625,732.45 14,783,783.55 9,091,559.57 7,854,005.70 1,237,552.87 ACTIVITY TOTAL 23,979,856.00 6,750,373.97 17,229,482.03 20,682,243.00 16,565,207.26 4,117,035.74 T 0 T A L EXPENDITURES 26.505,604.00 8,585,061.34 17,920,542.66 20,925.917.02 16,671,100.65 4,254,816.37 EXCESS REVENUE (EXPENDITURES) (6,576,653.00) 937,053.97 (7,513,706.97) (9,610,333.44)(15,629,301.77) 6,018,968.33 TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS REVENUES OVER (UNDER) EXPENDITURES (6,576.653.00) 937,053.97 (7,513,706.97) (9,610,333.44)(15,629,301.77) 6,018,968.33 THE CITY OF DUBLIN STATEMENT SHOWING i~,,,'q-~_~)'\~ REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2003 THROUGH 03/31/2004 TRUST/AGENCY FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE *********************** SPECIAL ASSESSMENTS 133,291.58 (133,291.58) 238,107.33 135,354.44 102,752.89 USES/MONEY & PROP-INTEREST 915.07 (915.07) 5,009.96 3,586.00 1,423.96 TOTAL REVENUE 134,206.65 (134,206.65) 243,117.29 138,940.44 104,176.85 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 229,893.50 (229,893.50) 233,949.42 231,594.42 2,355.00 ACTIVITY 'TOTAL 229,893.50 (229,893.50) 233,949.42 231,594.42 2,355.00 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS T 0 T A L EXPENDITURES 229,893.50 (229,892.50) 233,949.42 231,594.42 2,355.00 EXCESS REVENUE (EXPENDITURES) (95.686.85) 95,686.85 9,167.87 (92,653.98) 101,821.85 REVENUES OVER (UNDER) EXPENDITURES (95.686.85) 95,686.85 9,167.87 (92.653.98) 101,821.85 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2003 THROUGH 03/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 48,228.05 97,104.95 209,125.89 178,599.72 30,526.17 ~HARGES FOR SERVICES 1,590,277.00 1,207,943.54 382,233.46 1,326,711.49 980,159.01 346,552.48 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,261,751.59 494,858.41 14,165,259.91 1,176,389.26 12,988,870.65 ************************** GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL 1,496,152.00 377,605.68 1,118,546.32 2,344,963.06 652,246.98 1,692,716.08 ACTIVITY TOTAL 1,496,152.00 377,605.68 1,118,546.32 2,344,963.06 652,246.98 1,692,716.08 PUBLIC SAFETY: FIRE 64,285.00 26,587.31 37,697.69 57,775.63 24,747.47 33,028.16 ACTIVITY TOTAL 64,285.00 26,587.31 37,697.69 57,775.63 24,747.47 33,028.16 TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS T 0 T A L EXPENDITURES 1,560,437.00 404,192.99 1,156,244.01 2,402.738.69 676,994.45 1,725,744:24 EXCESS REVENUE (EXPENDITURES 196,173.00 857,558.60 (661,385.60) 11,762,521.22 499.394.81 11,263,126.41 TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS REVENUES OVER (UNDER) EXPENDITURES 196.173.00 857,558.60 (661,385.60) 11,762,521.22 499,394.81 11,263.126.41 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2003 THROUGH 03/31/2004 EN ERPRISE 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