Loading...
HomeMy WebLinkAboutItem 4.11 FinancialRptJan2004 CITY CLERK AGENDA STATEMENT CITY COUNCIL MEETING DATE: March 16, 2004 SUBJECT: Financial Reports for the Month of January 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 January 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 January. 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. Anal,ysis of.lannarv 2004 Revenue and Expenditure Report Given that this is only the seventh month of Fiscal Year 2003-2004, there is limited data on which to base any major prOjections or identify significant trends. For example, the receipt of revenues does not typically follow an even distribution throughout the Fiscal Year. 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 January are comparable to what occurred in the seventh month of the previous Fiscal Year. Through January 2004, the City had collected approximately 53% of the total budgeted General Fund Revenues, which was 2% more 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. Currently, sales tax collected to date is slightly ahead when compared to the same period in the prior year. It is important to note, however, that the retail holiday activity is still not captured in the information presented in the January report. Therefore, this increase could be positively or negatively impacted, depending on the actual collections for the holiday season. 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 COPIES TO: Document in FSCOLOR 01-2004 [O~5~ ITEM l~TOo 4'11 than expected tax collections at some of the CitY's hotels. Franchise taxes are higher than in the same period of the prior year due to timing differences in the collection of Cable Franchise Fees. Licenses and Permits are 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. Due to significant market value increases that occurred in the City's investments last year, Interest Revenue this year is lower, when compared to the same period from the prior year. Also, a change in the method of allocating interest to all funds (from semi annually to quarterly) and timing differences in the receipt of interest payments have impacted Interest Revenue (note: this revenue is recorded in the General Fund and is then allocated quarterly to other funds on a pro rata basis). The amount of VLF received in the current Fiscal Year has declined from the prior Fiscal Year due to lower car sales statewide and the fact that the State has not disbursed the backfill portion of the VLF for the first three months of the Fiscal Year. It should be noted that 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. The status of funding the VLF backfill is still not settled. HoWever, the Governor has directed that the State make partial payments for the VLF backfill to the counties and cities for the months of November through January. As of the date of this report, although the State Bond legislation has been approved by the voters, Staff does not yet have definitive data that there will be any positive effort to provide funding to reestablish the payment of the backfill portion of the VLF fee. The City could realize additional losses of VLF for Fisca1 Year 2003-2004, as was previously reported to Council as part of the mid year report for Fiscal Year 2003-2004. In the Charges for Services category, it should be noted that by fiscal year-end, 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 Office is handling calls for emergency service at the Santa Rita location. Other Revenue is lower than in the same period of the prior year due to timing differences in the receipt of a reimbursement from the School District for partial reimbursement of the costs of a School Resource Officer in the prior Fiscal Year. General Fund Expenditures Overall, through the month of January expenditures in the General Fund totaled $14.8 million and represented about 36% of the total budgeted expenditures in the General Fund. Of this amount, approximately $1,300,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. General Fund Operating Expenditures through Jmmary 2004 were Slightly higher than the amounts expended for the same period in the prior Fiscal Year. Through the end of January 2004, the City had expended 39% of the General Fund Operating Budget, which was 4% 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 (i.e. two quarters of police contract service have already been paid in this fiscal year). Other Public Safety is higher than in the same period of the prior year due to timing differences in the billing by Alameda County for contract animal control 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. Capital Improvement Projects are lower than in the same period of the prior year due to expenditures incurred to date in the prior year for construction of the City's new library. It is also important to note that part of the expenditures incurred last year for construction of the City's new library were reclassified to the Public Facilities Fund later in the prior Fiscal Year. 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 January 31, 2004 Total General Fund Revenues Property Taxes Sales Taxes ;% [] FY 2003/04 Real Property Transfer Tax [] FY 2002/03 Transient Occupancy Taxes 137% Franchise Taxes 30% Licenses and Permits ..... 170% 91% Interest and Rentals Intergovernmental from State Charges for Services Fines and Forfeitures Other Revenues 0% 30% 60% 90% 120% 150% 58% of Year Complete FY 2003104 FY 2003/04 % of FY 2002/03 % of Total for Budget YTD Actual Budget YTD Actual FY 2002~03 Property Taxes 11,274,729 5,942,512 53% 4,759,016 47% Sales Taxes 13,036,000 7,109,373 55% 6,933,950 53% Real Pro perty Transfer Tax 334,000 289,105 87% 166,492 44% Transient Occupancy Taxes 719,550 302,348 42% 365,355 51% Franchise Taxes 1,414,237 521,517 37% 415,786 30% Licenses and Permits 2,025,003 1,836,563 91% 1,686,117 70% Interest and Rentals 897,550 409,401 46% 1,060,516 65% Intergovernmental 1,916,900 793,490 41% 1,127,856 50% Charges for Services 4,868,788 2,204,000 45% 2,126,161 45% Fines and Forfeitures 106,500 50,407 47% 53,351 38% Other Revenues 551,071 118,392 21% 182,941 45% Total General Fund Revenues 37,144,328 19,577,108 53% 18,877,541 51% -~-~-o ~ ATTACHMENT 1 3ate Printed: 2/3~'2004 10:32 AM City of Dublin 2003-2004 YTD Expenses and Budget Comparison For the Period Ending January 31, 2004 Total General Fund 111111llllilllll.3.~%.. o Expenses iiiiiiiiiiiiiiiiiiiiiiiiiiil 47 ¥o General Government iiiiiii 52 ~ ~ Police ~/27%o ~13~% Other Public Safety19%1 31 ~ · FY 2003/04 45% ~::~ FY 2002/05 tha We are Culture & Community 49% Community ~ 48% Capital Improv. 0% 20% 40% 60% 80% '100% 120% 58% of Year Complete 2003/04 2003~04 % of FY 2002/03 % of Total for Budget YTD Actual Budget YTD Actual FY 2002~03 General Government 4,871,541 2,393,418 49% 2,249,401 52% Police 8,604,571 2,360,268 27% 564,417 7% Fire 7,159,187 2,153,713 30% 1,384,192 28% Other Public Safety 351,758 110,722 31% 54,050 19% Transportation 1,607,102 730,339 45% 591,993 44% Health and Welfare 47,941 36,393 76% 24,322 60% Culture and Community Services 5,329,601 2,602,546 49% 2,434,201 53% Community Development 6,498,591 3,133,553 48% 2,715,248 50% Capital Improvement Projects 6,125,677 1,269,899 21% 5,395,052 140% Total General Fund Expenses 40,595,969 14,790,851 36% 15,412,876 47% General Fund Operating Expenses 34,470,292 13,520,952 39% 10,017,824 35% * reclassification of eligible expen~Rures to the Pub][c Facilities Fund occurred later in the FY. CITY OF DUBLIN'S PRO FORMA FINANCIAL STATEMENTS FOR THE MONTH OF JANUARY 2004 Prepared by The Finance Department February 3, 2004 ATTACHMENT 3 CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31Jan2004 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 (43,332,226) 4,098,848 513,783 32,181,702 138,058 (6,399,834) (25,879,099) CASH WITH FISCAL AGENT 172,779 172,779 171,289 AMOUNT HELD IN ESCROW INVESTMENTS AT COST 94.761 254 94,761,254 93,168,169 RECEIVABLES: TAXES ACCOUNTS 232 566 37 776 270,342 500,688 INTEREST 200 330 200,330 542,481 ASSESSMENTS DUE FROM OTHERS 308.720 308,720 INVENTORY AT COST PREPAID ITEMS 12.448 12,448 14,006 FIXED ASSETS AMOUNT TO BE PROVIDED 1,447,500 1,447,500 1,553,500 TOTAL ASSETS 52,183,093 4,136.624 513,783 32,181,702 1,758,337 90,773,539 70,071,033 LIABILITIES/FUND EQUITY DEPOSITS FOR PRIVATE DEVEL (702.364) (702,364) (853,632) DEPOSITS FOR AB1600 FEES (22.692) (7,423,786) (7,446.478) (1.613.279) DEPOSITS OTHERS (1.272.098) (1,272.098) (896,592) PAYABLES: ACCOUNTS (852.851) (315,458) (210.623) (1.378,933) (268,579) INTEREST PAYROLL (463.388) (463,388) (397,304) DUE TO OTHERS (19.403) (208.720) (328,124) (29,712) DEFERRED REVENUE (127,768) (127,768) (127,768) DEBT INSTRUMENTS PAYABLE (1,565,000) (1,565,000) (1.671,000) TOTAL LIABILITIES (3.460,563) (624.179) (7,634,409) (1.565,000) (13,284.151) (5.857,866) FUND BALANCES (48.722,529) (3.512,446) (513,783) (24,547,293) (193,337) (77,489,388) (64,213,167) TOTAL FUND E (48.722.529) (3.512,446) (513,783) (24,547.293) (193,337) (77,489,388) (64,213,167) TOTAL LIABtLI.TIES/EQUITY (52.183.093) (4.136.624) (513,783) (32,181,702) (1.758.337) (90,773.539) (70,071.033) CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31Jan2004 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,543,927 (20) 7.543,907 6.626.679 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,683.627 68.683,627 50,624.278 TOTAL ASSETS 54.809.561 (20) 19.466.456 68.683.627 142.959.623 105.927,303 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.683,627) (68.683.627) (50.624.278) TOTAL LIABILITIES (17.215) (68.683,627) (68.700.842) (50.624.278) FUND BALANCES (54.792.346) 20 (19,466.456) (74,258.782) (55.303.025) TOTAL FUND E (54.792,346) 20 (19,466,456) (74.258.782) (55.303,025) TOTAL LIABILITIES/EQUITY (54.809;561) 20 (19,466,456) (68,683.627) 142,959.623)(105.927.303) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2003 THROUGH 01/31/2004 GENERAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR. Y.T.D. VARIANCE ********************** PROPERTY TAXES 11,274,729.00 5,942,512.05 5.332.216.95 10,039 542.89 4,759,015.58 5,280,527.31 SALES TAX 13,036,000.00 7,109,373.15 5,926,626.85 13,193 407.37 6,933,949.56 6,259,457.81 REAL PROPERTY TRANSFER TAX 334,000.00 289,105.02 44.894.98 379 088.81 166,492.33 212,596.48 HOTEL TRANSIENT OCCUPANCY TAX 719 550.00 302,347.86 417,202.14 717 083.07 365,355.36 351,727.71 FRANCHISE TAXES 1.414 237.00 521,516.72 892,720.28 1,394 953.26 415,786.21 979,167.05 LICENSES & PERMITS 2,025 003.00 1,836,562.88 188,440.12 2,421 884.99 1,686,117.12 735,767,87 FINES & FORFEITURES' 106 500.00 50,407.40 56,092.60 139 614.86 53,350.63 86,264.23 USE/MONEY & PROP-INTEREST 751 710.00 331,616.31 420,093.69 1,487 493.37 1,002,615.35 484,878.02 USE/MONEY & PROP-RENTALS 145 840.00 77,784.92 68.055.08 139 019.25 57.900.62 81,118.63 INTERGOVERNMENTAL 1,916 900.00 793,490.20 1,123,409.80 2,234 178.93 1,127,856.30 1,106,322.63 CHARGES FOR SERVICES 4.868,788.00 2,204,000.35 2,664,787.65 4,760 254.62 2,126.160.54 2,634.094,08 OTHER SOURCES OF REVENUE 551,071.00 118,392.02 432,678.98 410 713.57 182.940.86 227.772.71 TOTAL REVENUE 37,144,328.00 19,577,108.88 17,567,219.12 37,317 234.99 18.877,540.46 18,439,694.53 ************************** GENERAL GOVERNMENT ACTIVITIES: CITY COUNCIL 248,650.00 101,410.68 147,239.32 196 233.20 136,311.69 59,921.51 CITY MANAGER 823,204,00 448,354.29 374,849.71 740 856.35 417,451.36 323,404.99 CENTRAL SERVICES 369,960,00 192,148.37 177,811.63 292 316.29 164,363.76 127,952.53 CITY ATTORNEY 646,047.00 391,741.31 254,305.69 850 821.87 453,681.21 397,140.66 ADMIN SERVICES 1,360,195,00 674,596.06 685,598.94 982 221.59 548,920.00 433,301.59 BUILDING MANAGEMENT 717.595.00 332,360.62 385,234.38 757 323.39 352,996.67 404,326.72 INSURANCE COST CENTER 430,405.00 250,418.65 179,986.35 362 022.64 165,007.57 197,015.07 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 146.605.38 ACTIVITY TOTAL 4.871.541.00 2.393 418.29 2.478.122.71 ~.339.319.55 2.249,40t.10 2.089,918.45 PUBLIC SAFETY ~OLICE 8,604,571.00 2,360 267.98 6,244.303,02 7.947.078.88 564.416.96 7.382,661.92 CROSSING GUARDS 71,462.00 22 246.25 49.215.75 61.878.80 25,326.50 36 552.30 ANIMAL CONTROL 197,194.00 57 513.37 139.680.63 164.564.93 164 564.93 TRAFFIC SIGNALS & STREET LIGHTIN 11.150.00 579.31 10.570.69 DISASTER PREPAREDNESS 71,952.00 30.382.95 41.569.05 59.237.80 28,723.77 30.514.03 FIRE SERVICES 7.159,187.00 2 153.712.77 5.005.474.23 4,951,374.82 1,384,192.34 3.567.182.48 ACTIVITY TOTAL 16.115.516.00 4,624,702.63 11.490.813.37 13.184.135.23 2,002,659.57 11 181.475.66 TRANSPORTATION PUBLIC WORKS 694.417.00 382,102.79 312.314.21 632.481.15 338.306.01 294.175.14 STREET MAINTENANCE 10,004.00 312.50 9.691.50 9.868.95 5.917.68 3.951.27 STREET SWEEPING 145,676.00 52.814.95 92.861.05 122.569.70 51 669.22 70.900.48 STREET TREE MAINTENANCE 118.188.00 49.535.93 68,652.07 76,662.73 20 589.50 56.073.23 STREET LANDSCAPING MAINTENAN 638.817.00 245.572.37 393.244.63 495.105.08 175.511.01 319.594.07 ACTIVITY TOTAL 1,607,102.00 730.338.54 876.763.46 1,336.687.61 591.993.42 744.694.19 HEALTH & WELFARE WASTE qANAGEMENT 8 691.00 8.691.00 1.798.28 3.551.78 (1.753.50) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2003 THROUGH 01/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 7.558.81 7,441.19 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.82 40,300.02 24.322.33 15,977.69 CULTURE & LEISURE SERVICES LIBRARY SERVICES 553,662.00 247 551.49 306,110.51 485.281.21 239,659.00 245,622.21 CULTURAL ACTIVITIE~ 138,088.00 83 848.87 54,239.13 121,198.29 83,316.76 37 881.53 HERITAGE CENTER 114,188.00 57 822.07 56,365.93 92,803.62 48,356.94 44 446.68 DUBLIN CEMETERY 43,858.00 27 238.17 16,619.83 31,341.84 14,352.52 16 989.32 PARK MAINTENANCE 1,457,804.00 640 027.36 817,776.64 1,200,226.46 576,952.37 623 274.09 COMMUNITY TV 64,634.00 58 006.22 6,627,78 76,233.17 70,655.58 5 577.59 RECREATION ADMIN 541,383.00 287 238.68 254,144.32 452,646.88 247,893.63 204 753.25 PLAYGROUNDS 281,699.00 129 937.00 151,762.00 230,269.67 125,629.15 104 640.52 SHANNON CENTER 291,253.00 150 218.10 141,034.90 266,989.58 139,589.12 127 400.46 PRESCHOOL 82,383.00 41 021.37 41,361.63 74,354.14 42.276.85 32 077.29 TEENS PROGRAM 111,392.00 43 329.20 68,062.80 100,141.63 50,949.21 49 192.42 ADULT SPORTS 105,034.00 55 802.08 49,231~92 97,087.23 52.118.09 44 969.14 YOUTH SPORTS 113,604.00 57 662.74 55,941.26 93.209.36 47,849.23 45 360.13 COMMUNITY GYM 41,560.00 19 016.21 22,543.79 46.605.98 18.300.40 28 305.58 EMERALD GLEN ACTIVITY CENTER 4,039.00 4,039.00 SPECIAL EVENTS 361,928.00 178,699.55 183,228.45 356,425.65 194,751.84 161,673.81 SENIOR CENTER 219,073.00 107,813.71 111,259.29 183.985.64 92,276.10 91,609.54 RECREATION INSTRUCTION 190,418.00 98,504.14 91,913.86 153,581.45 83,662.71 69,918.74 AQUATICS 364,122.00 182,968.28 181,153.72 338,055.61 188.316.31 149,739.30 PARKS/FACILITIES MANAGEMENT 249,479.00 135,840.48 113,638.52 211,125.63 117,195.39 93,930.24 ACTIVITY-TOTAL 5,329,601.00 2,602,545.72 2,727,055.28 4,611,563.04 2,434,201.20 2.177,361.84 COMMUNITY DEVELOPMENT PLANNING 2,451,689.00 1,132,029.31 1.319,659.69 1,767,026.63 881,094.33 885,932.30 BUILDING SAFETY 1,836,288.00 834,742.54 1,001.545.46 1.467,363.47 703,609117 763,754.30 ENGINEERING 1,900,705.00 931,787.25 968,917.75 1,865.709.85 921,270.74 944,439.11 ECONOMIC DEVELOPMENT 309,909.00 234,994.00 74,915.00 278,983.20 209.273.94 69,709.26 ACTIVITY TOTAL 6,498,591.00 3,133,553.10 3.365,037.90 5,379,083.15 2,715,248.18 2,663,834.97 CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 1,155,736,00 150,120.04 1,005,615.96 2,258,752.04 4.999,047.98 (2,740,295.94) COMMUNITY IMPROVEMENTS 989,845,00 331,024.12 658,820.88 442,108.93 167,538.94 274,569.99 PARKS 2,869,563.00 438.655.73 2,430,907.27 669,566.48 118,247.21 551,319.27 STREET CONSTRC/IMPROVEMENTS 1,110.533.00 350,098.77 760,434.23 464.048.31 110,217.81 353,830.50 ACTIVITY TOTAL 6,125,677.00 1,269.898.66 4,855,778.34 3,834,475.76 5,395,051.94 (1,560.576.18) TOTAL EXPENDITURES 40,595,969.00 14,790,850.12 25,805.118.88 32,725,564,36 15,412,877.74 17.312,686.62 EXCESS REVENUE (EXPENDITURES) (3,451,641.00) 4,786,258.76 (8,237,899.76) 4,591,670.63 3,464,662.72 1,127.007.91 TRANSFERS IN FROM OTHER FUNDS 18,560.15 6,600.00 11,960.15 TRANSFERS OUT FROM OTHER FUNDS (20.00) (20.00) REVENUES OVER(UNDER) EXPENDITURES (3,451.641.00) 4,786,258.76 (8,237,899.76) 4,6t0,210.78 3,47t,262.72 1,138,948.06 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2003 THROUGH 01/31/2004 SPECIAL REVENUE FUNDS CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ************************ PROPERTY TAXES 108.,192.00 53,194.09 54,997.91 103.107,58 51,268.30 51,839.28 SALES TAX/OTHER TAXES 333.000.00 149,067.63 183.932.37 380.199.02 195,322.23 t84,876.79 FINES & FORFEITURES 149,000.00 65,910.87 83.089,13 134 670.06 60,375.60 74,294.46 USES/MONEY & PROPERTY 36,949.00 20,355.06 16,593.94 87 896.70 46,054.73 41,841.97 INTERGOVERNMENTAL FROM STATE 1,287,011.00 2,025,046.54 (738,035.54) 8,768 700.98 3,472,390.67 5,296,310.31 INTERGOVERNMENTAL FROM COUNTY 282,829.00 52,093.00 230,736.00 276 556.50 78,008.25 198,548.25 INTERGOVERNMENTAL FROM FEDERAL 1,672,692.00 39,408.42 1,633,283.58 133 137.78 65.563.31 67,574.47 CHARGES FORSERVICE$ 981,937.00 497,885.40 484,051.60 920 648.29 458,063.84 462,584.45 OTHER SOURCES OF REVENUE 102,000.00 102,000.00 251 582.51 25t,582.51 TOTAL REVENUE 4,953,610.00 2,902,961.01 2.050,648.99 11,056 499.42 4,427,046.93 6,629,452.49 ************************** PUBLIC SAFETY: POLICE 165,481.00 87,850.86 77,630.14 210,229.18 38.455.39 171,773.79 ' TRAFFIC SIGNALS & STREET LTG 189.500.00 631759.14 125,740.86 137,632.61 60,177.22 77,455.39 DISASTER PREPAREDNESS 7,000.00 2,175.00 4,825.00 7,258.78 7,258.78 FIRE SERVICES 250,579.00 27,068.67 223,510.33 204.076.36 51,160.25 152.916.11 ACTIVITY TOTAL 612,560.00 180,853.67 431,706.33 559,196.93 149,792.86 409,404.07 TRANSPORTATION: STREET MAINTENANCE 237,579.00 74,704.48 162,874.52 238,621.60 65,689.43 172,932.17 STREET SWEEPING ACTIVITY TOTAL 237,579.00 74,704.48 162,874.52 238,621.60 65,689.43 172,932.17 HEALTH & WELFARE: WASTE MANAGEMENT 1.295,325.00 18,716.57 1,276,608.43 1,063,584.65 506,956.38 556,628.27 SOCIAL SERVICES 44.935.00 21,626.55 23,308.45 28,427.00 11,043.17 17,383.83 HOUSING PROGRAMS ACTIVITY TOTAL 1,340,260.00 40,343.12 1,299,916.88 1,092,011,65 517,999.55 574,012.10 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 122,119.00 303,976.00 STREET CONSTRUCTION/IMPROVEMENT 2,443,522.00 1,544,946.88 898,575.12 8,733,595.34 1,640,073.09 7,093:522.25 ACTIVITY TOTAL 3,605,617.00 1.550,946.88 2,054,670.12 9,195,890.34 1,762.192.09 7,433,698.25 T 0 T A L EXPENDITURES 5.802,016.00 1,852,848.15 3,949,167.85 11.091,720.52 2,497,080.93 8,594,639.59 EXCESS <REVENUE>EXPENDITURE 848,406.00 (1,050.112.86) 1.898,518.86 35,221.10 (1,929,966.00) 1,965,187.10 TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS 18,560.15 856,531.16 (837,971.01) EXCESS <REVENUE> EXPENDITURE 848,406.00 (1.050,112.86) 1,898,518.86 53,781.25 (1,073,434.84) 1,127,216.09 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2003 THROUGH 01/31/2004 SPECIAL ASSESSMENT FUNDS CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ************************ SPECIAL BENEFITS ASSESSMENTS 630,482.00 297,924.67 332,557.33 501,425.07 247,790.91 253,634.16 USES/MONEY & PROP-INTEREST 13,704,00 2,558.64 11,145,36 14,049,83 6,787.02 7,262.81 OTHER SOURCES OF REVENUE 4,000.00 100.00 ~ 3,900.00 10,598.97 5,070.54 5,528.43 TOTAL REVENUE 648,186.00 300,583.31 347,602.69 526.073,87 259,648.47 266,425.40 ************************** PUBLIC SAFETY: TRAFFIC SIGNALS & STREET LIG 269,686.00 73,759.72 195,926.28 204,778.18 ' 87,704.74 117.073.44 ACTIVITY TOTAL 269,686.00 73,759.72 195,926.28 204.778.18 87,704.74 117,072.44 TRANSPORTATION PUBLIC WORKS 1,791.00 774.82 1,016.18 1,393.46 857.66 535.80 STREET TREE MAINTENANCE 29,768.00 2,166.81 27,601.19 9,437.02 5,041.88 4,395.14 STREET LANDSCAPE MAINTENANCE 355,333.00 121,280.99 234.052.01 264,802.70 141.858.22 122,944.48 ACTIVITY TOTAL 386,892.00 124,222.62 262,669.38 275,633.18 147,757.76 127,875.42 COMMUNITY DEVELOPMENT ENGINEERING 15,250.00 8,105.50 7,144.50 14,565.20 8,709.56 5.855,64 ACTIVITY TOTAL 15,250.00 8,105,50 i 7,144.50 14,565.20 8,709.56 5,855.64 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS STREET CONSTRUCTION/IMPRVMNT 77,584.00 77,584.00 56,000.00 56,000.00 ACTIVITY TOTAL 77,584.00 77,584.00 56,000.00 56,000.00 T 0 T A L EXPENDITURES 749,412,00 206,087.84 543,324.16 550,976.56 244.172~06 306,804.50 EXCESS <REVENUE>EXPENDITURE 101,226.00 (94.495.47) 195,721.47 24,902.69 (151476.41) 40,379.10 EXCESS <REVENUE>EXPENDITURE 101,226.00 (94,495.47) 195,721.47 24,902.69 (15,476.41) 40,379.10 THE CITY OF DUBLIN STATEMENT SHOWING REVENUE VERSUS EXPENDITURES FOR THE PERIOD 07/01/2003 THROUGH 01/31/2004 CAPITAL IMPROVEMENT FUNDS CURRENT CURt(ENT PRIOR PRIOR BUDGET ACTUAL VARIANCE Y.T.D. FISCAL YEAR VARIANCE ********REVENUE******** USES/MONEY & PROP-INTEREST 759,951.00 234,346.93 525,604.07 690,013.13 1,120,018.43 430,005.30 OTHER SOURCES OF REVENUE 19,079,000.00 7,423,785.89 11,655,214.11 - 10,195,565.15 10,195,565.15 TOTAL REVENUE: 19,838,951.00 7,658,132.82 12,180,818.18 690,013.13 11,315,583.58 10,625,570.45 ************--******** GENERAL GOVERNMENT ACTIVITIES: CITY ATTORNEY 28,800.00 11,848.44 16,951:56 8,153.46 23,902.29 15,748.83 ACTIVITY TOTAL 28,800.00 11,848.44 16,951.56 8,153.46 23,902.29 15,748.83 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: HOUSING PROGRAMS 758,876.00 395,686.71 363,189.29 65,476.65 219,771.73 154,295.08 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 117,894.00 1,361,810.39 (1,243,916.39) 1,982,528.16 10,315,973.90 8,333,445.74 COMMUNITY IMPROVEMENTS - - PARKS 5,513,453.00 2,506,267.01 3,007,185.99 952,361.60 1,274,709.53 322,347.93 STREET CONSTRUCTION/IMPROVEME1~ 17,400,716.00 2,119,876.03 15,280,839.97 4,817,614.40 9,091,559.57 4,273,945.17 ACTIVITY TOTAL 23,032,063.00 5,987,953.43 17,044,109.57 7,752,504.16 20,682,243.00 12,929,738.84 T O T A L EXPENDITURES 23,819,739.00 6,395,488.58 17,424,250.42 7,828,695.58 20,925,917.02 13,097,221.44 EXCESS <REVENUE>EXPENDITURE 3,980,788.00 (1,262,644.24) 5,243,432.24 7,138,682.45 9,610,333.44 2,471,650.99 TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS EXCESS <REVENUE>EXPENDITURE ' 3,980,788.00 (1,262,644.24) 5,243,432.24 7,138,682.45 9,610,333.44 2,471,650.99 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2003 THROUGH 01/31/2004 TRUST/AGENCY FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ************************ SPECIAL ASSESSMENTS 116,856.56 (116,856.56) 238.107.33 118,659.03 119,448.30 USES/MONEY & PROP-INTEREST 915.07 (915.07) 5,009.96 1,898.30 3,111.66 TOTAL REVENUE 117,771.63 (117,771.63) 243,117.29 120,5!57.33 122,559.96 ************************** GENEF~AL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 174,133.25 (174,133.25) 233,949.42 171,936.17 62.013.25 ACTIVITY TOTAL 174,133.25 (174,133.25) 233,949.42 171,936.17 62,013.25 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS T 0 T A 'L EXPENDITURES 174,133.25 (174,133.25) 233,949.42 171,936,17 62,013.25 EXCESS <REVENUE>EXPENDITURE 56,361.62 (56,361.62) (9,167.87) 51,378.84 (60,546.71) EXCESS <REVENUE>EXPENDITURE 56,361.62 (56,361.62) (9,167,87) 51,378.84 (60,546.71) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2003 THROUGH 12/31/2003 INTE'RNAL 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 1tl,500.94 97,624.95 CHARGES FOR SERVICES i,590,277.00 807,580.40 782,696,60 1,326,711.49 773,567.79 553,143.70 OTHER SOURCES OF REVENUE 21,000.00 21,000.00 12,629,422.53 13,560.00 12,615,862.53 TOTAL REVENUE 1,756,610.00 855,808.45 900,801.55 14,165~259.91 898,628.73 13,266,631.18 ************************** GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL 1,484,152.00 326,169.38 1,157,982,62 2,344,963.06 572,678.60 1,772,284.46 ACTIVITY TOTAL 1,484.152.00 326,169.38 1,157,982.62 2,344,963.06 572,678.60 1,772,284,46 PUBLIC SAFETY: FIRE 64,285.00 64,285.00 57,775.63 12,478.21 45,297,42 ACTIVITY TOTAL 64,285.00 64.285.00 57,775.63 12,478.21 45,297.42 TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: T 0 T A L EXPENDITURES 1,548.437.00 326,169.38 1,222,267.62 2,402,738.69 585 156.81 1,817,581.88 EXCESS <REVENUE>EXPENDITURE (208.173.00) (529,639.07) 321,466.07 (11,762,521.22) (313,471.92)(11,449,049.30) TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS EXCESS <REVENUE>EXPENDITURE (208,173.00) (529,639.07) 321,466.07 (1t,762,521.22) (3t3,471.92)(11,449,049.30) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2002 THROUGH 01/21/2004 ENTERPRISE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ************************ USES/MONEY & PROP-INTEREST TOTAL REVENUE *************************** 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>EXPENDITURE 20.00 20.00 20.00 20.00 TRANSFERS IN FROM OTHER FUNDS (20.00) (20.00) TRANSFERS OUT TO OTHER FUNDS EXCESS <REVENUE>EXPENDITURE 20.00 20.00 20.00 (20.00)