HomeMy WebLinkAbout4.07 FinRpt Feb2002CITY CLERK FILE # 330-50
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: March 19, 2002
SUBJECT:
ATTACHMENTS:
RECOMMENDATION: F~
FINANCIAL STATEMENT:
Financial Reports For the Month of February 2002
Report Prepared by: Carole Perry, Administrative Services Director
and Fred Marsh, Finance Manager
YTD Revenues and Budget Comparison
YTD Expenses and Budget Comparison
Financial Statements for the Month of February 2002
Receive the reports.
See reports for detail of monthly financial activity.
DESCRIPTION: This item provides the report of the financial statements for the month of February.
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. The budget changes presented in the Mid
Year Financial Report and approved at the City Council Meeting on March 5, 2002 will be included in the
March 2002 report.
Analysis of February 2002 Revenue and Expenditure Report
The February report represents the reporting of revenues and expenditures for the first eight months of the
Fiscal Year. A more detailed analysis of General Fund Revenue and Expenditures is shown on the
attached reports and discussed below.
General Fund Revenues
Total General Fund Revenues collected through February are comparable to what occurred in the eight
months of the previous Fiscal Year. The City had collected through February 2002 approximately 52% of
the total budgeted General Fund Revenues compared to approximately 54% in the prior Fiscal Year.
Property Tax Revenue is lower than in the same, period of the prior year due to timing differences in
deductions of property tax receipts for monies due to the Alameda County Surplus Property Authority
under its revenue sharing agreement with the City.
Real Property Transfer Tax is lower than in the same period of the prior year as the valuation from the
sales of new and existing residential properties in the City had dropped significantly in comparison to the
prior year. Transient Occupancy Tax is lower than in the same period of the prior year due to a decline in
occupancy rates for the City's hotels.
COPIES TO:
G:'cMonthly Financials\022002 agenda statement monthly financials.doc
ITEM
Licenses and Permits are lower than in the same period of the prior year due to a decline in the valuation
of building permits issued on new residential and commercial projects. Interest and Rentals are higher
than the same period of the prior year due to timing differences. However, the City has actually
experienced a significant decline in interest rates when compared to the prior year. Initially, all interest
revenue is recorded in the General Fund and allocated to other funds on a semi annual basis.
Charges for Services are higher than in the same period of the prior year due to the receipt of one time
monies from AT&T for cable equipment, and additional monies received for plan check fees for work
performed by staff and consultants on new development occurring within the City. Fines and Forfeitures
are higher than in the prior year due to an increase in the number of traffic citations issued over the prior
year. Other Revenue is higher than in the same period of the prior year due to reimbursements received
from DSRSD for costs incurred on the Dublin Boulevard Widening project from Dougherty Road to
Scarlett Drive.
General Fund Expenditures
Overall, through the month of February expenditures in the General Fund totaled $14.9 million and
represented approximately 41% of the total budgeted expenditures in the General Fund. Of this amount, a
total of $3.8 million 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 February 2002 was
comparable to the amounts expended for the same period in the prior Fiscal Year. As 'of February 28,
2002, the City had expended 41% of the General Fund Operating Budget compared to 41% in the prior
Fiscal Year.
As previously noted there are some timing differences with payment for contract services, which
complicate comparisons between Fiscal Years. Other Public Safety is higher than in the ~same period in
the prior year due to timing differences in payments for contract Animal Control services and for the semi
annual lease payments on the Animal Shelter building. Health and Welfare is lower than in the same
period of the prior year as the review of the City's housing element is expected to be completed later in
the current Fiscal Year.
Community Development is lower than in the same period of the prior year due to delays in filling staffing
vacancies in the Planning Division. The amount spent on Capital Projects is higher than in the same
period of the prior year due to expenditures incurred in the initial stages of construction of the City's new
library. All expenditures to date 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 2001-2002 YTD Revenues and Budget Comparison
For the Period Ending February 28, 2002
5 :%
Total General Fund Revenues ~ ~oz
Property Taxes 43°~
-- ~,,, 57%
Sales Taxes ~I :!!!!!! ~' ~ ',', ::,i'll;; i~,il i}~ ;!59% m FY 2001/2002
Real Property Transfer Tax 54% o FY 2000/2001
_ 63
Transient Occupancy Taxes 57%
Franchise Taxes ~:~
~ 37%
Licenses and Permits '. i?! 779
-
Interest and Rentals ~ 7
48
64%
IntergoVernmental from State ,;~:~' I1!! ~ 64
Charges for Services _ ~,~ ~g?~ ~ ~.., :%66%
Fines and Forfeitures : ~ ~: ::::'~¢~ ~ 60°Yo 75%
Other Revenues ~l 33%
i6%
0% 30% 60% 90% 120% 150%
67% of Year Complete
Property Taxes
Sales Taxes
Real Property Transfer Tax
Transient Occupancy Taxes
Franchise Taxes
Li=enses and Permits
Interest and Rentals
Intergovernmental
Charges for Services
Fines and Forfeitures
Other Revenues
Total General Fund Revenues
FY 2001/02 FY 2001/02 % of FY 2000/01 % of Total for
Budget YTD Actual Budget YTD Actual FY 2000101
8,258,100 3,587,733 43% 3,755,596 52%
13,200,000 7,548,908 57% 7,610,974 59%
450,000 242,224 54% 360,379 63%
1,035,000 434,453 42% 574,268 57%
1,254,830 569,217 45% 616,086 47%
2,957,140 1,080,148 37% 2,338,200 77%
1,787,578 1,016,095 57% 1,260,675 48%
1,948,150 1,248,992 64% 1,290,411 64%
3,893,691 2,569,357 66% 1,930,939 52%
102,000 76,878 75% 63,744 60%
1,164,072 382,130 33% 154,122 6%
36,050,561 18,756,135 52%
19,955,394 54%
ATTACHMENT
City of DUblin 2001-2002 YTD EXpenses and Budget Comparison
For the Period Ending February 28, 2002
Total General Fund
Expenses
General Government
Police
Fire
Other Public Safety
Transportation
Health and Welfare
Culture & Community
Services
Community
Development
Capital Improv.
Projects
41%
39%
~28%
30% ~~ 40%
~~ ~ 50%
~~~ ~!i 59%
~142%
26%
0% 20% 40% 60% 80% 100%
67% of Year Complete
· FY 2001/02
~ FY 2000/01
General Government
Police
Fire
Other Public Safety
Transportation
Health and Welfare
Culture and Community Services
Community Development
Capital Improvement Projects
Total General Fund Expenses
General Fund Operating Expenses
FY 2001102 FY 2001/02
Budget YTD Actual
3,917,768 2,149,629
6,802,424 1,998,797
4,672,577 1,322,038
292,463 87,731
1,127,147 576,004
64,495 25,496
4,352,294 2,216,072
5,669,915 2,734,370
9,056,489 3,798,807
35,955,572 14,908,944
26,899,083 11,110,137
% of
Budget
55%
29%
28%
30%
51%
40%
51%
48%
42%
41%
41%
FY 2000101
YTD Actual
1,597,659
1,362,512
1,147,710
48,443
496,035
6,797
1,839,375
2,671,120
696,160
9,865,811
9,169,651
% of Total for
FY 2000101
52%
23%
26%
21%
52%
50%
55%
59%
26%
39%
41%
ATTACHMENT 2
CITY OF DUBLIN'S
FINANCIAL STATEMENTS
FOR
THE MONTH OF FEBRUARY 2002
Prepared by
The Finance Department
March 11, 2002
ATTACHMENT 3
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 28Feb2002
GENERAL SPECIAL SPECIAL CAPITAL TRUST/
REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY
'FUNDS FUNDS FUNDS FUND FUND
TOTALS
---MEMORANDUM ONLY---
CURRENT PRIOR
ASSETS
CASH
CASH WITH FISCAL AGENT
AMOUNT HELD IN ESCROW
(49.684,938)
INVESTMENTS AT COST
RECEIVABLES: TAXES
ACCOUNTS (NE
INTEREST
ASSESSMENTS
89.784.895
157,651
312,860
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS
FIXED ASSETS
/~flOUNT TO BE PROVIDED
TOTAL ASSETS
14,848
40,585,316
LIAL/FND BAL/RETND ERNGS
DEPOSITS FOR PRIVATE DEVEL (679.992)
DEPOSITS FOR AB1600 FEES (76,191)
DEPOSITS OTHERS (550,930)
PAYABLES: ACCOUNTS (141,241)
INTEREST
PAYROLL (327.037)
DUE TO OTHERS (26,476)
DEFERRED REVENUE (146.433)
DEBT INSTRUMENTS PAYABLE
TOTAL LIABILITIES (1,948.301)
FUND BALANCES (38,637,015)
TOTAL FUND E (38,637,015)
TOTAL LIAB. FND BAL. RETD (40,585,316)
1,666.863
1,666,863
(115.102)
(115,102)
(1,551.761)
(1,551.761)
(1,666.863)
444.883 41,468,719
109.300
444.883 41.578,019
(43.107.608)
(12.089)
(43.119~698)
(444,883) 1,541.678
(444.883) 1,541,678
(444,883) (41,578,019)
131,952
167,304
(6,016,079) (24,052,805)
167,304 166,814
109,300 109,300
89.784.895 76.149.328
157,651 3,517.725
312,860 744,407
1,652,500
1,951,756
14,848
1.652,500
86.183,279
550,856
5,175
1.652.500
58,843,299
(679.992) ' (512,334)
(43.183.800) (11,556,340)
(550.930) (414,923)
(227,104) (5,323.868)
(327,037) (547,869)
(26,476) (603,122)
(146.433) (147.203)
(1,770,000) (1.770.000) (1,770,000)
(1,770,000) (46,911.772) (20,875,659)
(181,756) (39.271,507) (37,967.640)
(181,756) (39,271,507) (37.967,640)
il.951,756) (86,183.279) (58.843.299)
INTERNAL
SERVICE
FUNDS
ENTERPRISE
FUNDS
CiTY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 28Feb2002
FIXED ASSETS GENERAL LONG
GROUP OF TERM DEBT
ACCOUNTS ACCOUNT GROUP
TOT'ALS
---MEMORANDUM---
CURRENT PRIOR
ASSETS
CASH
CASH WITH FISCAL AGENT
AMOUNT HELD IN ESCROW
5,918,705
INVESTMENTS AT COST
RECEIVABLES: TAXES
ACCOUNTS (NE
INTEREST
ASSESSMENTS
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS
FIXED ASSETS
AMOUNT TO BE PROVIDED
TOTAL ASSETS
22,149,264
28,067,969
LIAL/FND BAL/RETND ERNGS
DEPOSITS FOR PRIVATE DEVEL
DEPOSITS FOR AB1600 FEES
DEPOSITS OTHERS
PAYABLES: ACCOUNTS
INTEREST
PAYROLL
DUE TO OTHERS
DEFERRED REVENUE
DEBT INSTRUMENTS PAYABLE
TOTAL LIABILITIES
FUND BALANCES
(1)
(1)
(28.067.969)
TOTAL FUND E (28,067,969)
TOTAL LIAB. FND BAL. RETD (28,067,969)
15,987,209
41,550,537
15,987.209 41.550,537
(41.550,537)
(41,550,537)
(15.987,209)
(15,987,209)
(15,987,209) (41.550,537)
2,964,413 2,694,870
6,495
38,136,473 38,136,473
41,550.537 41,688,500
82,651,423 82.526.337
(1) (4.446)
(41,550,537) (4t.688,500)
(41,550,538) (41,692.946)
(41.100,885) (40,833,391)
(41,100,885) (40.833,391)
(82,651,423) (82,526,337)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2001 THROUGH 02/28/2002
GENERAL REVENUE
CURRENT CURRENT
BUDGET ACTUAL VARIANCE
FUND
PRIOR
FISCAL YEAR
PRIOR
Y.T.D.
VARIANCE
*******REVENUES*******
PROPERTY TAXES
SALES TAX
REAL PROPERTY TRANSFER TAX
HOTEL TRANSIENT OCCUPANCY TAX
FRANCHISE TAXES
LICENSES & PERMITS
FINES & FORFEITURES
USE/MONEY & PROP-INTEREST
USE/MONEY & PROP-RENTALS
INTERGOVERNMENTAL FROM STATE
INTERGOVERNMENTAL FROM COUNTY
CHARGES FOR SERVICES
OTHER SOURCES OF REVENUE
TOTAL REVENUE
8.258,100]00 3,587,732.94 4,670,367.06 7,174.289.56 3,755,595.96 3,418,693.60
13,200.000.00 7.548,907.80 5,651,092.20 12,985.986.39 7,610,974.38 5.375.012.01
450.000.00 242,224.14 207,775.86 575.281.78 360.379.38 214,902.40
1.035,000.00 434.452.61 600.547.39 1.010.799.01 574,267.53 436,531.48
1,254.830.00 569.216.96 685,613.04 1,313,086.74 616,086.38 697,000.36
2.957,140.00 1,080,147.61 1,876,992.39 3.028,655.28 2.338.200.36 690,454.92
102,000.00 76,878.41 25.121.59 106,233.99 63,743.55 42,490.44
1,688,988.00 972,232.52 716,755.48 2.512,223.69 1,203.236.74 t.308.986.95
98,590.00 43,862.20 54.727.80 114,614.48 57.438.23 57,176.25
1,948.150.00 1.248,992.22 699,157.78 2,006.116.43 1,290,411.26 715.705.17
3,893.691.00 2.569.356.93 1.324.334.07 3,719,568.13 1.930,938.76 1,788.629.37
1.164.072.00 382,130.21 781.941.79 2,715,619.50 154,121.91 2,561,497.59
36,050,561.00 18,756,134.55 17,294,426.45 37.262.474.98 19,955.394.44 17,307,080.54
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
CITY COUNCIL 266,439.00 165,907.78 100.531.22 157.649.46 105.506.55 52,142.91
'CITY MANAGER 684,838.00 299.723.20 385.114.80 451,460.84 266,122.11 185,338.73
CENTRAL SERVICES 298.657.00 207.346.14 91,310.86 .254,490.40 152.556.26 101,934.14
CITY A1-FORNEY 469,339.00 415,310.62 54.028.38 566,876.47 219,808.18 347,068.29
ADMIN SERVICES 958.814.00 556.926.29 401,887.71 755,484.16 441.626.48 313.857.68
BUILDING MANAGEMENT 681,962.00 345,410.95 336,551.05 561.347.95 282,471.50 278.876.45
INSURANCE COST CENTER 389,315.00 147,939.78 241,375.22 273,267.70 117.556.94 155.710.76
ELECTIONS COST CENTER 22,532.00 1,064.30 21.467.70 12,013.21 12.010.96 2.25
NON-DEPARTMENTAL 145,872.00 10,000.00 135,872.00 53,136.03 53,136.03
ACTIVITY TOTAL 3,917,768.00 2.149.629.06 1,768,138.94 3,085,726.22 1,597,658.98 1.488,067.24
PUBLIC SAFETY
POLICE 6,802,424.00 1,998.796.56 4,803.627.44 5,842,597.93 1,362,511.69 4,480,086.24
CROSSING GUARDS 63,495.00 27,228.57 36.266.43 49.327.13 22,214.51 27,112.62
ANIMAL CONTROL 180,757.00 32,068.87 148.688.13 136.903.24 (558.00) 137.46t.24
DISASTER PREPAREDNESS 48.211.00 28,433.13 19.777.87 41.743.47 26.786.21 14.957.26
FIRE SERVICES 4,672,577.00 1,322,038.00 3,350.539.00 4,331,237.29 1.147,709.84 3,183.527.45
ACTIVITY TOTAL 11.767,464:00 3,408,565.13 8.358.898.87 10.401.809.06 2,558.664.25 7,843,144.81
TRANSPORTATION
PUBLIC WORKS 574,025.00 334.721.42 239,303.58 504,545.32 291,750.93 212,794.39
STREET MAINTENANCE 6,406.00 617.55 5.788.45 79.88 79.88
STREET SWEEPING 139.200.00 63,333.26 75,866.74 105.015.72 53,253.18 51.762.54
STREET TREE MAINTENANCE 55,629.00 20.147.64 35,481.36 52,929.17 17,151.83 35.777.34
STREET LANDSCAPING MAINTENAN 351.887.00 157,184.25 194,702.75 297.191.50 133.878.58 163.312.92
ACTIVITY TOTAL 1.127,147.00 576.004.12 551.142.88 959.761.59 496.034.52 463.727.07
HEALTH & WELFARE
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2001 THROUGH 02/28/2002
GENERAL REVENUE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
WASTE MANAGEMENT 8,395.00 46.38 8',348.62 1,483.29 1.469.88 13.41
CHILD CARE 15,000.00 6,629.00 8.371.00 12,000.00 5,327.00 6.673.00
HOUSING PROGRAMS · 41,100.00 18,820.50 22.279.50
ACTIVITY TOTAL 64,495.00 25,495.88 38,999.12 13.483.29 6,796.88 6,686.41
CULTURE & LEISURE SERVICES
LIBRARY SERVICES 400,725.00 200.362.50 200,362.50 362,922.00 181,461.00 181,461.00
CULTURAL ACTIVITIES 149,328.00 96,591.29 52,736.7t 48.979.05 28.067.63 10,911.42
HERITAGE CENTER 84,170.00 42,196.58 41,973.42 64,337.03 34,886.18 29,450.85
DUBLIN CEMETERY 39.687.00 15.146.27 24,540.73 35,168.63 16,593.91 18.574.72
PARK MAINTENANCE 1,142,023.00 542,385.33 599.637.67 863,488.51 396,465.04 467.023.47
COMMUNITY TV 88,982.00 58,067.95 30,914.05 65,376.81 58,854.35 6,522.46
RECREATION ADMIN 398,810.00 212,124.45 186,685.55 299.517.33 176,698.83 122,818.50
PLAYGROUNDS 236,890.00 122,259.58 114.630.42 179,746.06 109,606.16 70.139.90
SHANNON CENTER 265.856.00 141,954.72 123,901.28 223.534.64 129,291.02 94,243.62
PRESCHOOL 58,975.00 34,015.35 24,959.65 54.261.57 33,816.25 20.445.32
TEENS PROGRAM 108,839.00 56,817.63 52,021.37 95,263.42 59,856.51 35,406.91
ADULT SPORTS 80,704.00 43,895,89 36,808.11 74,298.29 39,082.97 35.215.32
YOUTH SPORTS 93,023.00 46,017.09 47,005.91 76,437.85 48,742.18 27.695.67
COMMUNITY GYM 37,990.00 10,661.63 27,328.37 37,226.81 9.899.54 27,327.27
SPECIAL EVENTS 320,247.00 169,204.88 151,042.12 200,963.28 123,279.10 77.684.18
SENIOR CENTER 167.065.00 82.643.43 84,421.57 137,807.83 84.311.55 53,496.28
RECREATION INSTRUCTION 130,122,00 90,911.46 39.210.54 116,758.13 71,580.04 45.178.09
AQUATICS 368.05t.00 183.056.83 184,994.17 300,625.35 168.570.82 132.054.53
PARKS/FACILITIES MANAGEMENT 180,807.00 67,759.39 113,047.61 95,707.64 58.311.86 37,395.78
ACTIVITY TOTAL 4,352,294.00 2.216,072.25 2,136,221.75 3.332,420.23 1,839,374.94 1,493.045.29
COMMUNITY DEVELOPMENT
PLANNING 1.764,970.00 877,949.94 887.020.06 1,330,195.42 786.777.51 543,417.91
BUILDING SAFETY 1.622,000.00 ~ 719,426.55 902,573.45 1,334.934.18 749,658.45, 585,275.73
ENGINEERING 1.999.416.00 939,093.94 1,060,322.06 1,606.493.94 940,232.17 666,261.77
ECONOMIC DEVELOPMENT 283,529.00 197.899.66 85,629.34 254.453.24 194,451.68 60.001.56
ACTIVITY TOTAL 5.669.915.00 2,734,370.09 2,935,544.91 4,526,076.78 2,671,119.81 1,854.956.97
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS 6,089.010.00 3,029.120.27 3,059,889.73 1,435,693.51 233,848.77 1,201.844.74
COMMUNITY IMPROVEMENTS 1.198,376.00 112,079.14 1,086,296.86 180,763.51 70.493.10 110,270.41
PARKS 665,863.00 342.083.72 323,779.28 462,208.60 357,869.72 104.338.88
STREET CONSTRC/IMPROVEMENTS 1,103,240.00 315,523.62 787,716.38 603,894.29 33.947.95 569,946.34
ACTIVITY TOTAL 9.056,489.00 3,798,806.75 5.257,682.25 2,682.559.91 696,159.54 1.986,400.37
TOTAL EXPENDITURES
EXCESS REVENUE (EXPENDITURES)
TRANSFERS IN FROM OTHER FUNDS
TRANSFERS OUT FROM OTHER FUNDS
REVENUES OVER(UNDER) EXPENDITURES
35,955,572.00
94.989.00
94.989.00
14,908,943.28
3,847,191.27
3,847,191.27
21.046.628.72 25,001.837.08
(3,752,202.27) 12.260,637.90
17,201.67
(2.400.000.00)
(3,752.202.27) 9,877.839.57
9,865,808.92
10,089,585.52
10.089,585.52
15.136,028.16
2.171.052.38
17.201.67
(2,400,000.00)
(211.745.95)
THE CITY OF DUBLIN ~TATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD '
07/01/2001 THROUGH 02/28/2002
SPECIAL REVENUE FUND
PRIOR
CURRENT CURRENT
BUDGET ACTUAL VARIANCE FISCAL YEAR
PRIOR
Y.T.D.
VARIANCE
**********************
PROPERTY TAXES
SALES TAX/OTHER TAXES
FINES & FORFEITURES
USES/MONEY & PROPERTY
iNTERGOVERNMENTAL FROM STATE
INTERGOVERNMENTAL FROM COUNTY
INTERGOVERNMENTAL FROM FEDERAL
CHARGES FOR SERVICES
OTHER SOURCES OF REVENUE
TOTAL REVENUE
90,175.00 45,429.96 44,745.04 81,587.21 40,620.93 40,966.28
230,500.00 116.843.81 113,656.19 218,443.36 t45,089.31 73,354.05
145.155.00 70,892.91 74.262.09 136,129.03 62,334.30 73,794.73
110,312.00 63,876.34 46,435.66 186,396.07 87,213.13 99,182.94
3.303,769.00 572,081.54 2,731,687.46 1.401,011.82 819,084.36 581,927.46
234.000.00 106.732.00 127,268.00 235,575.00 101,310.00 134,265.00
1.122,338.00 24,398.80 1,097,939.20 486,386.87 63,667.38 422.719.49.
876,760.00 430,184.18 446.575.82 766.872.19 381.326.58 385,545.61
5,000.00 15,525.13 (10,525.13) 17.930.25 17.930.25
6,11B.009.00 1,445,964.67 4,672,044.33 3.530,331.80 1,700,645.99 1,829.685.81
*******EXPENDITURES*******
PUBLIC SAFETY:
POLICE
TRAFFIC SIGNALS & STREET LTG
FIRE SERVICES
ACTIVITY TOTAL
TRANSPORTATION:
STREET MAINTENANCE
STREET SWEEPING
ACTIVITY TOTAL
HEALTH & WELFARE:
WASTE MANAGEMENT
SENIOR SUPPORT CARE
HOUSING PROGRAMS
ACTIVITY TOTAL
COMMUNITY DEVELOPMENT:
ENGINEERING
ACTIVITY TOTAL
CAPITAL IMPROVEMENT PROJECTS:
GENERAL CIP PROJECTS
COMMUNITY PROJECTS
PARKS
STREET CONSTRUCTION/IMPROVEMENT
ACTIVITY TOTAL
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
EXCESS <REVENUE> EXPENDITURE
302,730.00 131,502.45 171,227.55 163,769.23
175.041.00 53.769.84 121,271.16 87,789.56
177,100.00 55,413.89 121,686.11 188.299.58
654.871.00 240,686.18 414,184.82 439.858.37
175,084.00 79.054.24 96,029.76 348,601.71
175,084.00 79,054.24 96.029.76 348,601.71
1,049,577.00 520.750.50 528,826.50 1.108,496.91
7.500.00 3,750.00 3,750.00 7,500.00
10,000.00 2,496.40 7.503.60 9,918.66
1,067.077.00 526,996.90 540,080.10 1,125,915.57
6.000.00 2,398.50 3,601.50 4,999.00
6.000.00 2,398.50 3,601.50 4,999.00
80,373.00 19,958.55 60,414.45 86.648.98
411,119.00 411,119.00
4,744,341.00 1,767,498.48 ,2,976,842.52 760.517.95
5,235.833.00 1,787,457.03 3.448,375.97 847.166.93
7,138,865.00 2,636,592:85 4,502,272.15 2,766,541.58
1.020,856.00 1.,190,62B.18 (169,772.t8) (763,790.22)
15.061.59
1,020,856.00 1.190,628.18 (169.772.18) (748,728.63)
60,144.18
42,426.62
975.00
103.545.80
110,386.70
110,386.70
660.601.51
.3.750.00
6.202.30
670,553.81
103.625.05
45,362.94
187,324.58
336,312.57
238.215.01
238,215.01
447,895.40
3,750.00
3,716.36
455,361.76
4.999.00
4,999.00
33,328.18
387,050.30
420:378.48
1,304.864.79
(395.781.20}
(395,781.20)
53.320.80
373,467.65
426,788.45
1.461.676.79
(368,009.02)
15,061.59
(352,947.43)
THE CITY OF DUBLiN ~~A%EMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2001 THROUGH 02/28/2002
SPECIAL ASSESSMENT
CURRENT CURRENT
BUDGET ACTUAL VARIANCE
FUND
PRIOR
FISCAL YEAR
PRIOR
Y.T.D.
VARIANCE .
***********************
SPECIAL BENEFITS ASSESSMENTS
USES/MONEY & PROP-INTEREST
OTHER SOURCES OF REVENUE
TOTAL REVENUE
429.448.00 217.332.02 212,115.98 384.648.76 198.337.84 186,310.92
20,187.00 9,125.20 11.061.80 26.456.80 10,955.35 15,501.45
6,000.00 1,995.50 4.004.50 2,300.37 2,300.37
455,635.00 228,452.72 227,182.28 413,405.93 211,593.56 201,812.37
*******EXPENDITURES*******
PUBLIC SAFETY:
TRAFFIC SIGNALS & STREET LIG
ACTIVITY TOTAL
TRANSPORTATION
PUBLIC WORKS
STREET TREE MAINTENANCE
STREET LANDSCAPE MAINTENANCE
ACTIVITY TOTAL
COMMUNITY DEVELOPMENT
ENGINEERING'
ACTIVITY TOTAL
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS
STREET CONSTRUCTION/IMPRVMNT
ACTIVITY TOTAL
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
230,635.00 95,645.21 134,989.79 119,085.13 56,676.60
230.635.00 95,645.21 134.989.79 119.085.13 56,676.60
62.408.53
62,408.53
4,807.00 2.554.47 2,252.53 2,753.02 1,529.02 1.224.00
15.065.00 3,543.34 11,521.66 4.175.26 2.474.81 1,700.45
280,667.00 122,156.69 158.510.31 130,649.00 82.665.90 47,983.10
300,539.00 128,254.50 172,284.50 137,577.28 86,669.73 50.907.55
7.115.00 10.220.76 (3.105.76) 11.050.38 4,300.08
7.115.00 10.220.76 (3,105.76) 11,050.38 4,300.08
2.519.14
2,613.44
2,613.44
2,519.14
538.289.00 234,120.47 304.168.53 270,231.93 150.259.85
82,654.00 5,667,75 76.986.25 (143.174.00) (61,333.71)
(143,174.00)
(61.333.71)
5,667.75 76.986.25
6,750.30
6,750.30
(94.30)
(94.30)
119.972.08
(81,840.29)
(81,840.29)
EXCESS <REVENUE>EXPENDITURE 82,654.00
THE CITY OF DUBLIN ~?AT~MENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2001 THROUGH 02/28/2002
CAPITAL IMPROVEMENT
CURRENT CURRENT
BUDGET ACTUAL VARIANCE
FUND
PRIOR
FISCAL YEAR
PRIOR
Y.T.D.
VARIANCE
********REVENUE********
USES/MONEY & PROP-INTEREST
OTHER SOURCES OF REVENUE
TOTAL REVENUE:
1.640,682.00
37.719,269.00
39,359.951.00
766.333.51 874,348.49
37,719,269.00
766,333.51 38.593.617.49
8.882.376.17
8,882,376.17
789,214.44
789.214.44
(789,214.44)
8.882,376.17
8,093,161.73
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
ACTIVITY TOTAL .
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
HOUSING PROGR/~flS
CULTURE & LEISURE SERVICES:
RECREATION ADMINISTRATION
ACTIVITY TOTAL
COMMUNITY DEVELOPMENT
PLANNING
ACTIVITY TOTAL
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS
COMMUNITY IMPROVEMENTS
PARKS
STREET CONSTRUCTION/IMPROVEMENT
ACTIVITY TOTAL
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
EXCESS <REVENUE>EXPENDITURE
1.854,726.00
12.867,967.00
1.422.224.00
15.659,638.00
29.949,829.00
31.804.555.00
(7.555,396.00)
(7.555,396.00)
30.468.33 1,824,257.67
8.398.57 (8.398.57) 30,854.96 23,722.47 7,132.49
8,398.57 (8,398.57) 30.854.96 23.722.47 7.132.49
452.780.18 12,415,186.82 936.862.45 545,493.50 391.368.95
13,125.00 1,409.099.00 18,854.85 11.262.11 7.592.74
2,223,781.44 13,435,856.56 7,890.520.72 5.739,997.03 2,150.523.69
2,689,686.62 27,260,142.38 8,846,238.02 6,296.752.64 2,549.485.38
2.728,553.52 29.076.001.48 8,877.092.98 6,320.475.11 2,556,617.87
1,962,220.01 (9,517,616.01) (5,283.19) 5,531.260.67 (5,536,543.86)
1.140.08 1,140.08
1.962.220.01 (9,517.616.01) (4.143.11) 5,531.260.67 (5.535,403.78)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2001 THROUGH 02/28/2002
TRUST/AGENCY FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
**********************
SPECIAL ASSESSMENTS
USES/MONEY & PROP-INTEREST
TOTAL REVENUE
118.632.21 (118.632.21) 237,172.56 118.586.28 118.586.28
1.767.78 (1.767.78) 16.539.29 5,939.51 10.599.78
120,399.99 (120,399.99) 253.711.85 124,525.79 129.186.06
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL
ACTIVITY TOTAL
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
EXCESS <REVENUE>EXPENDITURE
232,578.00 167,544.06 65,033.94 234.093.57 165,149.61 68,943.96
232.578.00 167,544.06 65,033.94 234.093.57 165,149.61 68,943.96
2321578.00 167.544.06 65,033.94 234,093.57 165,149.61 68,943.96
232.578.00 47,144.07 185,433.~3 (19.618.28) 40,623.82 (60,242.10)
232,578.00 47,144.07 185.433.93 (19,618.28) 40,623.82
(60.242.10)
THE CITY OF DUBLIN STATEM~N~ ~HOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2001 THROUGH 02/28/2002
INTERNAL SERVICE FUND'
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
***********************
USES/MONEY& PROP-INTEREST
CHARGES FOR SERVICES
OTHER SOURCES OF REVENUE
TOTAL REVENUE
298.835.00 121.730.05 177.104.95 205.273.76 96.664.80 108,608.96
1,171,448.00 726.724.38 ,444.723.62 944.535.35 629.325.37 315.209.98
17.000.00 19.744.05 (2.744.05) 6.495.00 6,495.00
1.487.283.00
868,198.48 619.084.52
1.156.304.11
725,990.17 430.313.94
*******EXPENDITURES*******
GENEP, AL GOVERNMENT ACTIVITIES
NON-DEPARTMENTAL
ACTIVITY TOTAL
PUBLIC SAFETY:
FIRE
ACTIVITY TOTAL
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
EXCESS <REVENUE>EXPENDITURE
1.140.046.00
1,140,046.00
45.828.00
45.828.00
189.750.00
303,817.48 836.228.52 1,018.788.52 251.239.99 767.548.53
303.817.48 836.228.52 1.018.788.52 251.239.99 767.548.53
14.260.06 31.567.94 40,700.28
14.260.06 31.567.94 40,700.28
189.750.00
40.700.28
40.700.28
20.576.74 (20.576.74)
1.375.624.00 318.077.54 1.057.546.46 1.059.488.80 271.816.73 787.672.07
(111,659.00) (550.120.94) 438.461.94 (96.815.31) (454,173.44) 357.358.13
2.400,000.00 2.400.000.00
(2.496.815.31)
(550.120.94) 438,461.94
(111.659.00)
(454,173.44) (2,042,641.87)
CURRENT
BUDGET
THE CITY O~ DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2001 THROUGH 02/28/2002
ENTERPRISE
FUND
CURRENT
ACTUAL
VARIANCE
PRIOR
FISCAL YEAR
PRIOR
¥.T.D.
VARIANCE
********REVENUES********
USES/MONEY & PROP-INTEREST
TOTAL REVENUE
********EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL
FINANCE
ACTIVITY TOTAL
PUBLIC SAFETY:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
TRANSFERS IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
20.00
20.00
20.00
20.00
20.00
20.00
20.00
20.00
20.00
EXCESS <REVENUE>EXPENDITURE 20.00