HomeMy WebLinkAboutItem 4.10 FinanceReport 2-01CITY CLERK
FILE # 330-50
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: (March 20, 2001)
SUBJECT:
Financial Reports For the Month of February 2001
Report Prepared by: Oarde Perry, Administrative Services Director
and Fred Marsh, Finance Manager
ATTACHMENTS:/~ 1.
2.
3.
RECOMMENDATION:
FINANCIAL STATEMENT:
YTD Revenues and Budget Comparison
YTD Expenses and Budget Comparison
Financial Statements for the Month of February 2001
Receive the reports.
See reports for detail of monthly financial activity.
DESCRIPTION: This item provides the report of the preliminary financial statements for the month
of February 2001. The budget changes presented in the Mid Year Financial Report and approved at the
City Council meeting on March 6, 2001 are included in the February 2001 Report. 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 February 2001 Revenue and Expenditure Report
The February report represents the reporting of revenues and expenditures for the first eight months of the
Fiscal Year. It should be noted that there is not an even distribution of revenues and expenditures on a
monthly basis. For example, the expenditures for major contracts such as Police and Fire Services lag
since the City is billed on a quarterly basis. 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 higher than what occurred in the eighth
month of the previous Fiscal Year. The City had collected through February 2001 approximately 61% of
the total budgeted General Fund Revenues compared to approximately 52% in the prior Fiscal Year.
Property Taxes are higher than in the same period of the prior year as the assessed valuation increased
over the prior year, primarily due to the sales of properties and additions of several commercial and
residential developments during the past year in Eastern Dublin.
Sales Tax is higher than in the same period of the prior year. The State has raised the amount of monthly
sales tax advances to the City as a result of the increased sales activity within the City, primarily related to
tax collections from motor vehicle sales. It should be noted that a major portion of the annual sales tax is
a result of the Christmas retail season, for which the City will not receive data until April.
COPIES TO:
G:MMonthly Financials\022001 agenda statement monthly ~nancials.doc
ITEM NO.
Real Property Transfer Tax is higher than the same period of the prior year due to increased sales of
residential and commercial properties within the City. Transient Occupancy Taxes are higher than in the
same period in' the prior year due to higher room rates and higher than expected occupancy rates.
Franchise Taxes are higher than in the same period in the prior year due to an increase in cable rates that
occurred during the year as well as a larger than expected increase in the number of new residential
customers in Eastern Dublin.
Licenses and Permits are higher than in the same period in the prior year due to an increase in the
valuation of building permits issued during the first eight months of Fiscal Year 2000/2001. The data
presented regarding Interest and Rental revenue is somewhat skewed in the current report as a portion of
the interest earnings reported in the General Fund still needs to be allocated to all of the City's fimds on a
pro rata basis. This allocation will be done prior to the year end closing. In addition, the City has more
cash available in the .first eight months of the year than was assumed in the budget calculations.
Intergovemmental is higher than in the same period of the prior year due to an increase in the allocation of
State Motor Vehicle In Lieu Fees and an increase in the amount of the ERAF repayment from the State.
Charges for services are higher than in the same period of the prior year as there were delays that occurred
on. some development projects during the same time period in the prior year, resulting in lower than
expected year to date revenue for engineering plan checking services. The amount of revenue recorded is
based upon the payments made to date to outside contractors for these services.
Other Revenue is lower than the same period in the prior year, as a developer's contribution for
construction on the City's new library is scheduled to be received later in the Fiscal Year.
General Fund Ex!~enditures
Overall, through the month of February expenditures in the General Fund totaled $9,865,809 and
represented approximately 35% of the total budgeted expenditures in the General Fund. Of this amount, a
total of $696,160 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 at only General Fund Operating Expenditures, the activity through February 2001 was lower
than the amounts expended for the same period in the prior Fiscal Year. As of February 2001, the City
had expended 39% of the General Fund Operating Budget compared to 46% in the prior Fiscal Year. As
previously noted there are some timing differences with payment for contract services which complicate
comparisons between one year to the next.
General Governmental is lower than in the prior year as the amount budgeted for technical support for
"Computers for Our Schools" has not yet been spent. Police Services are lower than in the prior year due
to timing differences in payments for contract police services. Other Public Safety is lower than in the
prior year due to timing differences in payments for contract animal control services.
Transportation is lower than in the prior year due to lower than expected year to date charges for water
and sewer services in the Street Landscaping division. Culture and Leisure Services are lower than in the
same period of the prior year due to lower than expected part time personnel expense to date for
Playgrounds and Youth Sports and timing differences in payments for contract services in the Special
Events division. Community Development is lower than in the same period of the prior year due to timing
differences in the payment of development related contract services in the Engineering division.
Capital Improvement Project expenditures are lower than in the same period of the prior year as several of
the capital projects funded by the General Fund in Fiscal Year 2000-2001 will not incur major
expenditures until later in the Fiscal Year, including the DUSD Technology Project, Civic Center Library,
Freeway Underpass Art and Sidewalk Reconstruction, LED Traffic Signal Conversion, and the Alamo
Canal Bikepath project. In addition, there may be a .delay in the Dublin Boulevard Undergrounding
project due to a delay in the receipt of reimbursement funds. 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 2000-2001 YTD Revenues and Budget Comparison .
For the Period Ending February 28, 2001
Total General Fund Revenues
Property Taxes
Sales Taxes
Real Property Transfer Tax
Transient Occupancy Taxes
Franchise Taxes
Licenses and Permits
Interest and Rentals
Intergovernmental from State
Charges for Services
Fines and Forfeitures
Other Revenues ~ll 5%
123%
30%
156%
161%
61%
]67%
63%
i1%
175%
83%
71%
93%
125%
60% 90% 120% 150%
· FY 2000/2001
[] FY 1999/2000
67% of Year Complete
Property Taxes
Sales Taxes
Real Property Transfer Tax
Transient Occupancy Taxes
Franchise Taxes
Licenses and Permits
Interest and Rentals
Intergovernmental
Charges for Services
Fines and Forfeitures
Other Revenues
Total General Fund Revenues
FY 200012001
Budget
6, 168,350
11,300,000
288,000
910,000
1,017,840
3, 124,088
1,513,259
1,813,500
3,434, 158
68,755
2,935,654
32,573,604
FY 2000/2001 % of
YTD Actual Budget
3,755,596 61%
7,610,974 67%
360,379 125%
574,268 63%
616,086 61%
2,338,200 75%
1,260,675 83%
1,290,411 71%
1,930,939 56%
63,744 93%
154,122 5%
19,955,394 61%
FY 99~00
YTD Actual
% of Total for
FY 99~00
2,831,485
6,045,160
222,847
394,574
493,900
2,190,090
827,534
1,038,750
1,582,015
48,844
166,735
15,841,934
47%
52%
60%
49%
51%
56%
62%
64%
48%
58%
23%
52%
=~. ~.,.: ~,0, 3~,3 .. ATTACH M E N T 1
City of Dublin 2000-2001 YTD Expenses and Budget Comparison
For the Period Ending February 28, 2001
Total General Fund
Expenses
General Government
44%
52%
57%
Police
22%
50%
]q~ire
Other Public Safety
!26%
21%
33%
Transportation
52%
58%
Health and Welfare
35%
Culture & Community
Services
Community
Devdopment
Capital Improy.
Projects
40%
53%
69%
0% 20% 40% 60% 80% 100%
67% of Year Complete
[] FY 2000/2001
· FY 1999/2000
General Government
Police
Fire
Other Public Safety
Transportation
Health and Welfare
Culture and Community Services
Community Development
Capital Improvement Projects
FY 2000/2001
Budget
3,060,557
6, 125,924
4,448,831
283,619
960,383
19,390
3,472,989
4,894,262
5,028, 145
Total General Fund Expenses 28,294,100
General Fund Operating Expenses 23,265,955
FY 2000/2001 % of
YTD Actual Budget
1,597,659 52%
1,362,512 22%
1,147,710 26%
48,443 17%
496,035 52%
6,797 35%
1,839,375 53%
2,671,120 55%
696,160 14%
9,865,809 35%
9, 169,649 39%
FY 99~00
YTD Actual
1,298,479
2,533,640
869,135
63,155
446,987
5,063
1,550,299
2,186,710
712,058
9,665,726
8,953,668
% of Total for
FY 99/00
57%
50%
21%
33%
58%
30%
69%
61%
40%
44%
46%
~teP ......~0~ ~:~,~ ATTACHMENT 2
CITY OF DUBLIN'S
FINANCIAL STATEMENTS
FOR
THE MONTH OF FEBRUARY 2001
Prepared by
The Finance Department
March 9, '2001
ATTACHMENT 3
GENERAL
REVENUE
FUNDS
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 28Feb2001
SPECIAL SPECIAL CAPITAL TRUST/
REVENUE ASSESSMENT IMPROVEMENT AGENCY
FUNDS FUNDS FUND FUND
TOTALS
---MEMORANDUM ONLY---
CURRENT PRIOR
ASSETS
CASH
CASH WITH FISCAL AGENT
AMOUNT HELD IN ESCROW
(29,133,177)
INVESTMENTS AT COST
RECEIVABLES: TAXES
ACCOUNTS (NE
INTEREST
ASSESSMENTS
65,590,765
179,827
302,286
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS
FIXED ASSETS
AMOUNT TO BE PROVIDED
TOTAL ASSETS
4,143
14.604
36,958.449
LIAL/FND BAL/RETND ERNGS
DEPOSITS FOR PRIVATE DEVEL (850,465)
DEPOSITS FOR AB1600 FEES (7,323)
DEPOSITS OTHERS (479.309)
PAYABLES: ACCOUNTS (181,234)
INTEREST
PAYROLL (268,261)
DUE TO OTHERS (20,790)
DEFERRED REVENUE (149,497)
DEBT INSTRUMENTS PAYABLE
TOTAL LIABILITIES (1.956.879)
FUND BALANCES (35,001,570)
TOTAL FUND E (35.001,570)
TOTAL LIAB. FND BAL. RETD (36.958.449)
2,165,383
20,646
(114)
2.185,915
(32,558)
(32,558)
(2,153,356)
(2,153,356)
(2,185,915)
368.710
368.710
(368,710)
(368,710)
(368.710)
24,408,026
515,300
24.923,326
(29.878,982)
(155,063)
(4,143)
(30,038,~88)
5,114,862
5,114,862
24,923,326)
124.227
161,931
(2,066,831) (10,431,784)
161,931 157,925
515,300 4.267,787
65,590,765 49,227,117
200,473 2.365,857
302,286 718.499
1,745,500
2,031,658
4,029 61.210
14,604 13.144
1,745,500 1,745,500
66,468.058 48.125,255
(850,465) (663,000)
(29,886,306) (12.455,564)
(479,309) (354,683)
(368.855) (4,536,975)
(268,261) (446,756)
(20.790) (233,477)
(153.640) (153,640)
1,863,000) (1,863,000) (1,863,000)
1,863,000) (33,890.626) (20,707.095)
(168,658) (32,577.432) (27,418,160)
(168,658) (32,577,432) (27,418,160)
(2,031,658) (66,468,058) (48,125,255)
INTERNAL
SERVICE
FUNDS
ENTERPRISE
FUNDS
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 28Feb2001
FIXED ASSETS GENERAL LONG
GROUP OF TERM DEBT
ACCOUNTS ACCOUNT GROUP
TOTALS
- - -MEMORANDUM- - -
CURRENT PRIOR
ASSETS
CASH
CASH WITH FISCAL AGENT
AMOUNT HELD IN ESCROW
2.635.311
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
21,t05.766
23.741.078
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)
(23.741,077)
TOTAL FUND E (23.741.077)
8.626.020
48,252,553
8.626.020 48.252.553
(8.626.020)
(8.626.020)
(48.252.553)
(48.252.553)
2.635.311 2.384.683
29.731,786 29.731,786
48,252,553 48.653,563
80,619,650 80.770.032
(1) (6.353)
(48,252,553) (48,653.563)
(48.252,553) (48.659,916)
(32.367.097) (32.110.116)
(32.367,097) (32.110.116)
TOTAL LIAB. FND BAL. RETD (23.741.078) (8.626.020) (48.252.553) (80,619.650) (80,770,032)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 02/28/2001
GENERAL REVENUE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR 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
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
CITY COUNCIL
CITY MANAGER
CENTRAL SERVICES
CITY ATTORNEY
ADMIN SERVICES
BUILDING MANAGEMENT
INSURANCE COST CENTER
.ELECTIONS COST CENTER
NON-DEPARTMENTAL
ACTIVITY TOTAE
PUBLIC SAFETY POLICE
CROSSING GUARDS
ANIMAL CONTROL
DISASTER PREPAREDNESS
FIRE SERVICES
ACTIVITY TOTAL
TRANSPORTATION
PUBLIC WORKS
STREET MAINTENANCE
STREETSWEEPING
STREET TREE MAINTENANCE
STREET LANDSCAPING MAINTENAN
ACTIVITY TOTAL
HEALTH & WELFARE
6,168 350.00
11,300 000.00
288 000.00
910 000.00
1,017 840.00
3,124 088.00
68 755.00
1.411 205.00
102 054.00
1.813 500.00
3.434.158.00
2,935.654.00
32,573,604.00
3,755,595.96 2,412.754.04 5,991,813.80 2,831,485.26 3.160,328.54
7,610,974.38 3.689.025..62 11,548,901.00 6,045,159.65 5,503,741.35
· 360,379.38 (72.379.38) 370,945.99 222,847.00 148.098.99
574,267.53 335,732.47 808,688.14 394,574.18 414,113.96
616,086.38 401,753.62 963,069.84 493,899.98 469,169.86
2,338,200.36 785,887.64 3.897.965.22 2.190.089.98 1,707,875.24
63,743.55 5,011.45 84,542.77 48,843.64 35,699.13
1,203,236.74 207,968.26 1.254.906.26 788.259.91 466,646.35
57,438.23 44,615.77 85.831.12 39,274.20 46,556.92
1,290,411.26 523,088.74 1,629,846.86 1,038.749.80 591,097.06
2,594.33 2.594.33
1,930.938.76 1,503.219.24 3.308.263.42 1,582,014.89 1,726.248.53
154.121.91 2,781.532.09 726,524.45 166,735.21 559,789.24
19,955,394.44 12,618,209.56 30,673.893.20 15.841,933.70 14,831,959.50
172,905.00 105,506.55 67,398.45 144,214.76 94,203.39 50.011.37
445,805.00 266,122.11 179,682.89 368,092.08 221,750.12 146,341.96
250,000.00 152,556.26 97.443.74 202,489.29 122.246.91 80,242.38
405,882.00 219,808.18 186.073.82 301,446.94 145.610.94 155,836.00
889,601.00 441,626.48 447,974.52 606.030.20 343.160.00 262.870.20
516,021.00 282.471.50 233,549.50 482,597.30 255.244.94 227.352.36
245,493.00 117,556.94 127,936.06 169.061.86 115,432.02 53,629.84
7,350.00 12,010.96 (4,660.96) 904.34 752.50 151.84
127.500.00 127,500.00 77.83 77.83
3.060,557.00 1.597,658.98 1,462.898.02 2,274,914.60 1,298.478.65 976,435.95
6,125,924.00 1,362,511.69 4,763,412.31 5,106.215.64 2.533,840.00 2,572,375.64
63,760.00 22,214.51 41,545.49 47,608.15 17,985.07 29,623.08
177,595.00 (558.00) 178,153.00 107.720.18 22.622.97 85,097.21
42,264.00 26,786.21 15.477.79 37,094.46 22,546.91 14,547.55
4,448,831.00 1,147,709.84 3.301,121.16 4,186,527.66 869.135.07 3.317,392.59
10,858,374.00 2,558,664.25 8,299,709.75 9,485.166.09 3.466.130.02 6,019,036.07
508.071.00 291,750.93 216,320.07 406,083.23 236.110.86 169,972.37
861.00 861.00 11.513.70 26.10 11,487.60
107,031.00 53,253.18 53,777.82 82,440.23 52,409.13 30,031.10
45.768.00 17.151.83 28,616.17 40,288.40 13,214.54 27.073.86
298,652.00 133,878.58 164,773.42 286,816.64 145,226.84 141.589.80
960,383.00 496,034.52 464,348.48 827,142.20 446.987.47 380,154.73
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 02/28/2001
GENERAL REVENUE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
WASTE MANAGEMENT 7,390.00 1.469.88 5,920.12 7,085.81 2.173.70 4.9i2.11
CHILD CARE 12.000.00 5,327.00 6,673.00 12,000.00 2.888.98 9.11t.02
ACTIVITY TOTAL 19,390.00 6,796.88 12,593.12 19,085.81 5,062.68 14,023.13
CULTURE & LEISURE SERVICES
LIBRARY SERVICES 362,922.00 181,461.00 181,461.00 342.557.00 154,565.50 187,991.50
CULTURAL ACTIVITIES 55.408.00 38,067.63 17,340.37 53,367.37 7.342.16 46,025.21
HERITAGE CENTER 67.861.00 34,886.18 32,974.82 56,071.79 31,095.63 24.976.16
DUBLIN CEMETERY 33,337.00 16.593.91 16,743.09 30,225.33 12,661.33 17,564.00
PARK MAINTENANCE 863.907.00 396,465.04 467,441.96 633,590.64 297,791.11 335,799.53
COMMUNITY TV 69.852.00 58,854.35 10.997.65 66,950.70 58.458.59 8,492.11
RECREATION ADMIN 312,313.00 176,698.83 135,614.17 269,725.81 161,385.91 108,339.90
PLAYGROUNDS 213.209.00 109.606.16 103,602.84 145,380.76 84.962.29 60,418.47
SHANNON CENTER 233.841.00 129,291.02 104,549.98 t95,927.57 105,041.92 90,885.65
PRESCHOOL 55,790.00 33,816.25 21.973.75 47.479.90 27,977.42 19,502.48
TEENS PROGRAM 105,053.00 59,856.51 45,196.49 75,134.57 38,206.12 36,928.45
ADULT SPORTS 76,562.00 39,082~97 37,479.03 63,823.38 32,145.96 31,677.42
YOUTH SPORTS 75,044.00 48.742.18 26.301.82 67,900.31 46,729.74 21.170.57
COMMUNITY GYM 34,035.00 9,899.54 24.135.46 28,795.78 8,565.35 20,230.43
SPECIAL EVENTS 264,524.00 123,279.10 141,244.90 218,102.49 168,732.54 49,369.95
SENIOR CENTER 1451236.00 84,311'.55 60,924.45 115,715.37 66,201.82 49,513.55
RECREATION INSTRUCTION 129,585.00 71.580.04 58,004.96 102,256.75 58,009.74 44,247.01
AQUATICS 278,195.00 168.570.82 109,624.18 228.879.72 140,255.42 88,624.30
PARKS/FACILITIES MANAGEMENT 96,315.00 58,311.86 38,003.14 85,735.46 50,170.88 35,564.58
ACTIVITY TOTAL 3.472,989.00 1,839.374.94 1,633.614.06 2,827,620.70 1.550,299.43 1,277,321.27
COMMUNITY DEVELOPMENT
PLANNING 1.376,095.00 786,777.51 589.317.49 1.252,774.61 644,428.26 608,346.35
BUILDING SAFETY 1,401,919.00 749,658.45 652,260.55 1.144,717.07 620,034.05 524,683.02
ENGINEERING 1,816,058.00 940,232.17 875,825.83 1,462,847.69 781,329.67 681,518.02
ECONOMIC DEVELOPMENT 300,190.00 194,451.68 105,738.32 255.690.44 140,918.21 114,772.23
ACTIVITY TOTAL 4.894.262.00 2,671,119.81 2,223,142.19 4,116,029.81 2.186,710.19 1,929,319.62
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS 2,646.604.00 233,848.77 2,412,755.23 1,297,739.34 297,960.89 999,778.45
COMMUNITY IMPROVEMENTS 381,901.00 70,493.10 311,407.90 234,272.83 73.968.92 160,303.91
PARKS 545,201.00 357.869.72 187.331.28 722,642.96 302.974.50 419,668.46
STREET CONSTRC/IMPROVEMENTS 1.454,439.00 33,947.95 1,420,491.05 111,551.69 37,153.'64 74,398.05
ACTIVITY TOTAL 5,028,145.00 696,t59.54 4,331,985.46 2,366,206.82 712,057.95 t.654,148.87
TOTAL EXPENDITURES
EXCESS REVENUE (EXPENDITURES)
TRANSFERS IN FROM OTHER FUNDS
TRANSFERS OUT FROM OTHER FUNDS
REVENUES OVER(UNDER) EXPENDITURES
28,294,100.00
4,279,504.00
22,850.00
(2,400,010.00)
1,902,344.00
9,865,808.92 18.428,291.08
10,089,585.52 (5.810,081.52)
22,850.00
(2.400,010.00)
10.089,585.52 (8,187.241.52)
21,916.166.03
8.757,727.17
17,869.13
(931,640.50)
7,843,955.80
9,665,726.39
6.176,207.31
6.176,207.31
12,250,439.64
2.581,519.86
17,869.13
(931,640.50)
1.667.748.49
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 02/28/200t
SPECIAL REVENUE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
********REVENUES********
PROPERTY TAXES
SALES TAX/OTHER TAXES
FINES & FORFEITURES
USES/MONEY & PROPERTY
INTERGOVERNMENTAL FROM STATE
INTERGOVERNMENTAL FROM COUNTY
INTERGOVERNMENTAL FROM FEDE~L
CHARGES FOR SERVICES
OTHER SOURCES OF REVENUE
TOTAL REVENUE
~'***EXPENDITURES*******
PUBLIC SAFETY: POLICE
TRAFFIC SIGNALS & STREET LTG
FIRE SERVICES
ACTIVITY TOTAL
T~NSPORTATION:
STREET MAINTENANCE
STREET SWEEPING
ACTIVITY TOTAL
HEALTH & WELFARE:
WASTE MANAGEMENT
SENIOR SUPPORT CARE
HOUSING PROGR/~4S
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
82,850.00 40,620.93 42,229.07 78,715.14 39,810.33 38,904.81
194,000.00 145,089.31 48,910.69 192,662.02 121,649.55 71.012.47
89.475.00 62.334.30 27,140.70 113.370.96 53.573.47 59,797.49
100,676.00 87,213.13 13,462.87 103,772.70 24.019.31 79.753.39
2,367,881.00 819,084.36 1,548,796.64 1,158,533.84 383,756.51 774,777.33
137,780.00 10t,310.00 36,470.00 177,904.00 50,924.00 126,980.00
1,026,394.00 63,667.38 962.726.62 87,679.67 27.554.07 60,125.60
763,302.00 381,326.58 381.975.42 733,208.99 367,819.69 365,389.30
5.000.00 5,000.00 40.60t.31 31,609.31 8,992.00
4,767,358.00 1,700,645.99 3,066.712.01 2,686,448.63 1,100,716.24 1,585,732.39
210.840.00
141,645.00
89,125.00
441.610.00
659,896.00
659,896.00
1,169,535.00
7,500.00
10,000.00
1,187,035.00
6,000.00
6,000.00
285,004.00
8,820.00
2,692.305.00
2,986,129.00
5,280,670.00
513,312.00
22,850.00
60.144.18 150,695.82 88.258.42 44,162.07 44,096.35
42,426.62 99.218.38 121,790.46 65,389.47 56.400.99
975.00 88,150.00 79,100.67 975.00 78.125.67
103,545.80 338.064.20 289,149.55 110,526.54 178.623.01
110,386.70 549,509.30 533,583.10 58,694.91 474,888.19
110,386.70 549,509.30 533,583.10 58,694.91 474,888.19
660,601.51 508,933.49 866,219.67 437,660.31 429,159.36
3,750.00 3,750.00
6,202.30 3,797.70
670.553.81 516,481.19 866.219.67 437,060.31 429,159.36
6,000.00
6,000.00
6,000.00
6,000.00
- 6,000.00
6,000.00
13,997.81 13,997.81
33,328.18 251,675.82 59,617.41 6,548.21 53,069.20
8,820.00 20,517.41 3,577.66 16,939.75
387,050.30 2,305,254.70 429.360.36 14,654.91 414,705.45
420,378.48 2,565,750.52 523,492.99 24,780.78 498,712.21
1,304.864.79 3,975,865.21 2,218.445.3t 631.062.54 1,587,382.77
(395,781.20) 909,093.20 (468,003.32) (469,653.70) 1,650.38
17,869.13
22,850.00
17,869.13
EXCESS <REVENUE> EXPENDITURE ~ 536,162.00 (395.781.20) 931.943.20 (450,134.19) (469,653.70) 19,519.51
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 02/28/2001
SPECIAL ASSESSMENT FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
********REVENUES********
SPECIAL BENEFITS ASSESSMENTS
USES/MONEY & PROP-INTEREST
OTHER SOURCES OF REVENUE
TOTAL REVENUE
390,388.00 198.337.84 192.050.16 318,354.40 151,797.31 166.557.09
13,589.00 10,955.35 2,633.65 16,637.02 3,797.92 12.839.10
6,000.00 2,300.37 3,699.63 668.85 668.85
409,977.00 211,593.56 198,383.44 335,660.27 156,264.08 i79.396.19
*******EXPENDITURES*******
PUBLIC SAFETY:
TRAFFIC SIGNALS & STREET LIG 172,115.00 56,676.60 115,438.40 118,667.18 50,935.83 67,731.35
ACTIVITY TOTAL 172,115.00 56.676.60 115,438.40 118,667.18 50,935.83 67,731.35
TRANSPORTATION
PUBLIC WORKS 4,480.00 1,529.02 2,950.98 3,613.20 1,905.19 1.708.01
STREET TREE MAINTENANCE 12,039.00 2,474.81 9,564.19 4,219.57 1,864.24 2,355.33
STREET LANDSCAPE MAINTENANCE 239,352.00 82,665.90 156,686.10 131.200.04 69,611.11 61,588.93
ACTIVITY TOTAL 255,871.00 86,669.73 169,201.27 139,032.8t 73,380.54 65,652.27
HEALTH & WELFARE:
ENGINEERING 4.760.00 4,300.08 459.92 4,495.98 4,336.86 159.12
ACTIVITY TOTAL 4,760.00 4,300.08 459.92 4,495.98 4,336.86 159.12
CAP'iTAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS 52,840.00 2.6t3.44 50,226.56 28.139.83 46.41 28.093.42
STREET CONSTRUCTION/IMPRVMNT 46.752.16 620.68 46,131.48
ACTIVITY TOTAL 52,840.00 2,613.44 50.226.56 74,891.99 667.09 74,224.90
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
EXCESS <REVENUE>EXPENDITURE
485,586.00 150,259.85 335,326.15 337,087.96 129,320.32 207,767.64
75,609.00 (61.333.71) 136,942.71 1,427.69 (26,943.76) "~8,371.45
75,609.00 (61,333.71) 136,942.71 1,427.69
26.943.76)
28,371.45
THE CITY OF DUBLIN STATiMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 02/28/2001
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:
19,061,493.75
19,061,493.75
789,214.44 (789,214.44.)
19,061,493.75
789,214.44 18,272,279.31
10.337,149.24
10.337.149.24
196,773.67
196,773.67
(196.773.67)
10,337,149.24
10,140.375.57
~*~***EXPENDITURES*******
GENEP-AL GOVERNMENT ACTIVITIES:
ACTIVITY TOTAL
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
RECREATION ADMINISTRATION
ACTIVITY TOTAL
COMMUNITY DEVELOPMENT
PLANNING
ACTIVITY TOTAL
CAPITAL IMPROVEMENT PROJECTS
GENEP, AL 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
37,834.00 23.722.47 14,111.53 12,389.68 602.80
37,834.00 23,722.47 14,111.53 12.389.68 602.80
1,747,473.75
545,493.50 1,201.980.25 1,859,640.67
821.399.49
11.786.88
11,786.88
1,038,241,18
1,412,999.00 11,262.11 1.401,736.89 6,057,184.37 5.474,623.52 582.~60.85
20,483,791.00 5.739,997.03 14,743,793.97 2,433,845.51 964.256.61 1.469,588.90
23.644,263.75 6.296,752.64 17,347,511.11 10,350.670.55 7,260,279.62 3,090,390.93
23,682,097.75 6.320.475.11 17,361,622.64 10,363,060.23 7,260,882.42 3,102,177.81
4,620,604.00 5.531.260.67 (910,656.67) 25,910.99 7,064.108.75 (7,038,197.76)
EXCESS <REVENUE>EXPENDITURE 4,620,604.00 5,53t,260.67 (910,656.67) 25.910.99 7,064,108.75 (7,038.197.76)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 02/28/2001
TRUST/AGENCY FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
********REVENUES********
SPECIAL ASSESSMENTS
USES/MONEY & PROP-INTEREST
TOTAL REVENUE
118~586.28 (118,586.28) 233,189.54 116.594.77 116.594.77
5.939.51 (5,939.51) 13,281.66 769.85 12,511.81
124.525.79 (124,525.79) 246,471.20 117.364.62 t29,106.58
*******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
165.149.61 (165,149.61) 261,375.75 190,256.00 71,119.75
165,149.61 (165,149.61) 261,375.75 190,256.00 71,1t9.75
165,149.61 (165,149.61) 261,375.75 190,256.00 71,119.75
40,623.82 (40.623.82) 14,904.55 72,891.38 (57,986.83
EXCESS <REVENUE>EXPENDITURE 40,623.82 (40,623.82) 14.904.55 72,891.38 (57.986.83)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 02/28/2001
INTERNAL SERVICE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
********REVENUES********
USES/MONEY & PROP-INTEREST
CHARGES FOR SERVICES
OTHER SOURCES OF REVENUE
TOTAL REVENUE
187,672.00 96,664.80 91,007.20 65,324.17 14,165.24 51,158.93
919,498.00 629,325.37 290,172.63 580,974.63 385,862.24 195,112.39
17,000.00 17,000.00 42,214.73 28,607.44 13,607.29'
1,124,170.00 725,990.17 398,179.83 688,513.53 428,634.92 259,878.61
*******EXPENDITURES*******
GENE~L GOVERNMENT ACTIVITIES
NON-DEPARTMENTAL
ACTIVITY TOTAL
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
1,014,920.00 251,239.99 763,680.01 865,319.44 156,310.34 709,009.10
1,014,920.00 251,239.99 763,680.01 865,319.44 156,310.34 709,009.10
28,825.00 20,576.74 8,248.26
5,590.00
(5,590.00)
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
TRANSFER INFROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
EXCESS <REVENUE>EXPENDITURE
1,043,745.00 271,816.73 771,928.27
(80,425.00) (454,173.44) 373,748.44
(2,480,425.00)
(454,173.44) (2,026,251.56)
865,319.44
176,805.91
931,286.00
754,480.09)
161,900.34
(266,734.58)
(266,734.58)
703,419.10
443,540.49
931,286.00
487,745.51)
THE CITY OF DUBLIN STATEMENT SHO~ING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/0t/2000 THROUGH 02/28/2001
ENTERPRISE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.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
EXCESS <REVENUE>EXPENDITURE
10.00
10.00
10.00
10.00
(10.00)
10.00
10.00
10.00
10.00
(10.00)
10.00
344.50
354.50
354.50
354.50
(354.50)
10.00
10.00
10.00
10.00
10.00
344.50
344.50
344.50
344.50
(354.50)
(10.00)