HomeMy WebLinkAbout4.07 Feb 2000 Fin Report CITY CLERK
File # 0330-50
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: (March 21, 2000)
SUBJECT:
Preliminary Financial Report For the Month of February 2000
Report Prepared by: Fred Marsh, Finance Manager
EXHIBITS ATTACHED: Pro Forma Balance Sheet and Income Statements for
the Month of February 2000
RECOMMENDATION: ~"/Receive the reports.
FINANCIAL STATEMENT:
See reports for detail of monthly financial activity.
DESCRIPTION: This item provides the report of the financial statements for the month of February.
The budget changes presented in the Mid Year Financial Report and approved at the City Council Budget
Study Session on February 29, 2000 will be included in next month's financial 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_ 2000 Revenue and Expenditure Report
Through the first eight months of the fiscal year the revenue collections and expenses have been tracking
similar to thc previous fiscal year. It should be noted that there is not an even distribution of revenues and
expenditures on a monthly basis. For example, in the revenue category, the City receives significant
property tax reVenues in the months of December and April, and the expenditures for major contracts such
as Police and Fire Services lag since thc 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 comparable to what occurred in the eight
months of the previous Fiscal Year. The City had collected through February 2000 approximately 60% of
the total budgeted General Fund Revenues compared to approximately 59% in the prior Fiscal Year.
Sales Tax is higher than in the same period of the prior year. The State has raised the amount of the
monthly sales tax advances to the City as a result of the increased sales activity within the City, primarily
related to autos. 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. Transient Occupancy Taxes are higher
than in the same period of the prior year due to additional revenues received from the City's two new
hotels.
The percentage of Franchise Fees collected is reflective of growth in the City. This report includes 100%
of the Cable TV franchise taxes and Garbage franchise taxes through the month ended January 2000. As
the subscription to these services increase the total revenue also increases. Similar trends are also
COPIES TO:
G:XMONTHFS\022000 agenda statement month financials.doc
ITEM NO.
reflected in the issuance of building permits. Through the month of February permits issued represented
improvements valued in excess of $166 million.
The data presented regarding Interest and Rental revenue is somewhat skewed in the current report as the
interest earnings reported in the General Fund have not been allocated to all of the City's funds on a pro
rata basis. This allocation is done on an annual basis. In addition, the City has had more cash available in
the first eight months for investment than was assumed in the budget calculations.
Intergovernmental Revenue is higher than in the same period in the'prior year due to an increase in the
allocation of State Motor Vehicle In Lieu Fees from the State and the receipt of a one time ERAF
repayment from the State of $63,700, out of a total of $150 million allocated by the State. The ERAF
rebate was allocated to cities based upon each city's population.
Charges for services are lower than in the same period in the prior year. This is due to a lower than
expected amount of revenue for reimbursements received from developers for engineering plan checking
services due to delays that have occurred on some development projects. The amount of the revenue
recorded is based upon the payments made to date to outside contractors for these services. In the Other
Revenue category, the amount budgeted to be received from the sale of a Fire Engine to Alameda County
was billed in February and received in March.
General Fund Expenditures
Overall, through the month of February expenditures in the General Fund totaled $9,646,371 and
represented approximately 41% of the total budgeted expenditures in the General Fund. Of this amount, a
total of $711,945 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, activity through February 2000 was below the
amounts expended for the same period in the prior Fiscal Year, primarily due to timing differences in the
payment for contract fire services and several capital projects scheduled to be completed later in the Fiscal
Year. Through February 2000, the City had expended 43% of the General Fund Operating Budget
compared to 55% 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. Police Services is higher than in the same period
of the prior year due to timing differences in the payment for contract police services. Fire Services is
lower than the same period in the prior year due to timing differences in payments for contract fire
services. Parks and Community Services Expenditures are lower than the same period in the prior year
due to lower than expected expenditures to date for Park Maintenance. Community Development
Expenditures are lower than in the prior Fiscal Year due to lower than expected expenditures incurred on
new development for engineering professional services.
Capital Improvements Projects 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 1999-2000 will not incur major
expenditures until later in the Fiscal Year, including the purchase of a new fire apparatus, the Civic Center
Design Modification and Roof Replacement Projects, the Downtown Median Paver Repair project, the
Heritage Center Storage Building; the Alamo Canal Bike Path and the Swim Center Project. All
expenditures to date are within the authorized budget.
It is recommended that the City Council receive and file these reports as authorized by Section 41004 of
the California Government Code.
City of Dublin 1999-2000 YTD Revenues and Budget Comparison
For the Period Ending February 29, 2000 - Unaudited
Total General Fund
Revenues
60%
59%
Property Taxes
Sales Taxes
Transient
Occupancy Taxes
Franchise Taxes
Licenses and
Permits
Interest and Rentals
Intergovernmental
from State
Charges for Services
Other Revenues
66%
68%
72%
;7%
lm FY 1999/2000
[]FY 1998/1999
0% 30% 60% 90% 120% 150%
67% of Year Complete
FY 199912000
Budget
Property Taxes
Sales Taxes
Transient Occupancy Taxes
Franchise Taxes
Licenses and Permits
Interest and Rentals
Intergovernmental
Charges for Services
Other Revenues
Total General Fund Revenues
5,643,600
9,200,000
580,000
872,400
3,041,520
1,223,214
1,437,181
3,917,844
855,582
26,771,341
FY 199912000 % of
YTD Actual Budget
3,054,332 54%
6,045,160 66%
394,574 68%
493,900 57%
2,190,090 72%
1,066,369 87%
1,038,750 72%
1,582,848 40%
215,579 25%
16,081,602 60%
FY 98199
YTD Actual
2,650,650
5,179,394
188,549
430,267
1,466,806
906,858
837,567
1,897,549
199,147
13,756,787
% of Total for
FY 98199
51%
60%
48%
51%
59%
67%
62%
54%
64%
59%
ATTACHMENT 1
Date Printed: 03/03/200012:11 PM
City of Dublin 1999-2000 YTD Expenses and Budget Comparison
For the Period Ending February 29, 2000 - Unaudited
Total General Fund Expenses
General Government
Civic Center Lease
Police
Fire
Other Public Safety
Transportation
Health and Welfare
Culture & Community Services
Community Development
caPital Improv. Projects
0%
20%
40% 60% 80%
67% of Year Complete
100%
· FY 1999/2000
[] FY 1998/1999
120%
General Government
Civic Center Lease
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 1999/2000 FY 1999/2000 % of
Budget YTD Actual Budget
2,501,322 1,297,243 52%
4,991,209 2,519,940 50%
4,209,712 869,135 21%
208,427 63,080 30%
827,008 446,500 54%
19,360 5,063 26%
3,059,288 1,549,061 51%
4,974,683 2,184,404 44%
2,883,472 711,945 25%
23,674,481 9,646,371 41%
20,791,009 8,934,426 43%
FY 98199
YTD Actual
1,297,622
1,614,407
1,249,332
2,544,881
69,168
371,261
727
1,282,100
2,092,173
532,516
11,054,187
10,521,671
% of Total for
FY 98199
61%
100%
28%
62%
36%
48%
4%
57%
58%
30%
53%
55%
Elate Pti ...... 03/ ..... F~M ATTACH M E NT 2
CITY OF DUBLIN'S
FINANCIAL STATEMENTS
FOR
THE MONTH OF FEBRUARY 2000
Prepared by
The Finance Department
March 3, 2000
ATTACHMENT 3
City of Dublin General Fund Income Statement Showing
Revenues Versus Expenditures
For the Period 7199 Through 2/00
Revenues
Property Taxes
Sales Taxes
Real Property Transfer Tax
Hotel Transient Occupancy Tax
Franchise Taxes
Licenses and Permits
Fines and Forfeitures
Use Money and Property - Interest
Use Money and Property - Rentals
Intergovernmental from State
Charges for Services
Other Sources of Revenue
Total Revenue
Expenditures
General Government
City Council
City Manager
Central Services
City Attorney
Administrative Services
Building Management
Facility Rental
Insurance Cost Center
Elections Cost Center
Non Departmental
Activity Total
Public Safety Police
Crossing Guards
Animal Control
Disaster Preparedness
Fire Services
Activity Total
Transportation
Public Works
Street Maintenance
Street Sweeping
Street Tree Maintenance
Street Landscaping Maintenance
Activity Total
Health and Welfare
Waste Management
Child Care
Activity Total
Current Current Prior Prior
Budget Actual % Variance Fiscal Year YTD % Variance
5,346,600 2,831,485 53% 2,515,115 4,866,093 2,494,015 51% 2,372,078
9,200,000 6,045,160 66% 3,154,840 8,687,091 5,179,394 60% 3,507,697
297,000 222,847 75% 74,153 282,733 156,635 55% 126,098
580,000 394,574 68% 185,426 389,664 188,549 48% 201,115
872,400 493,900 57% 378,500 649,959 430,267 51% 419,692
3,041,520 2,190,090 72% 851,430 2,472,217 1,466,806 59% 1,005,411
57,200 48,644 85% 8,356 60,876 40,487 67% 20,389
1,128,164 1,027,095 91% 101,059 1,262,400 864,927 69% 397,473
95,060 39,274 41% 55,786 90,539 41,931 46% 48,608
1,437,181 1,038,750 72% 398,431 1,356,234 837,567 62% 518,667
3,917,844 1,582,848 40% 2,334,996 3,482,983 1,897,549 54% 1,585,434
798,382 166,735 21% 631,647 250,889 158,660 63% 92,229
26,771,341 16,081,602 60% 10,689,739 24,051,678 13,756,787 57% 10,294,891
150,305 94,203 63% 56,102 145,936 90,148 62% 55,788
376,735 221,221 59% 155,514 331,437 213,722 64% 117,715
222,712 122,065 55% 100,647
300,140 145,611 49% 154,529 310,558 151,649 49% 158,709
723,174 342,635 47% 380,539 687,654 414,996 60% 272,658
550,831 255,245 46% 295,586 531,167 335,122 63% 196,045
1,614,407 1,614,407 100%
152,185 115,432 76% 36,753 125,622 85,480 68% 40,142
940 753 80% 187 6,335 6,305 100% 30
24,300 78 24,222 1,029 1,029
2,501,322 1,297,243 52% 1,204,079 3,754,145 2,912,029 78% 842,116
4,991,209 2,519,940 50% 2,471,269 4,505,598 1,249,332 28% 3,256,266
54,760 17,985 33% 36,775 51,697 25,007 48% 26,690
118,735 22,623 19% 96,112 104,137 21,865 21% 82,272
34,932 22,472 64% 12,460 35,022 22,296 64% 12,726
4,209,712 869,135 21% 3,340,577 4,109,003 2,544,881 62% 1,564,122
9,409,348 3,452,155 37% 5,957,193 8,805,457 3,863,381 44% 4,942,076
411,653 235,623 57% 176,030 389,595
500 26 5% 474 112,085
98,580 52,409 53% 46,171
46,320 13,215 29% 33,105 49,395
269,955 145,227 54% 124,728 225,855
827,008 446,500 54% 380,508 77.6,930
237,191 61% 152,404
114 111,971
20,071 41% 29,324
113,885 50% 111,970
371,261 48% 405,669
7,360 2,174 30% 5,186 4,969 727 4,242
12,000 2,889 24% 9,111 12,000 12,000
19,360 5,063 26% 14,297 16,969 727 4% 16,242
City of Dublin General Fund Income Statement Showing
Revenues Versus Expenditures
For the Period 7~99 Through 2/00
Culture and Leisure Services
Library Services
Cultural Activities
Heritage Center
Dublin Cemetery
Park Maintenance
Community TV
Recreation Admin
Playgrounds
Shannon Center
Preschool
Teens Program
Adult Sports
Youth Sports
Community Gym
Special Events
Senior Center
Recreation Instruction
Aquatics
Parks / Facility Management
Activity Total
Community Development
Planning
Building Safety
Engineering
Economic Development
Activity Total
Capital Improvement Projects
General CIP Projects
Community Improvements
Parks
Street Construction / Improvements
Activity Total
Total Expenditures
Excess Revenues (Expenditures)
Transfers In From Other Funds
Transfers Out From Other Funds
Appropriations to Reserves
Current Current Prior Prior
Budget Actual % Variance Fiscal Year YTD
Variance
1,556,662 297,961 19% 1,258,701 252,013 89,085 35% 162,928
304,646 73,897 24% 230,749 63,272 10,388 16% 52,864
863,815 302,955 35% 560,860 1,110,304 194,493 18% 915,811
158,349 37,132 23% 121,217 353,570 238,550 67% 115,020
2,883,472 711,945 25% 2,171,527 1,779,159 532,516 30% 1,246,643
23,674,481 9,646,371 41% 14,028,110 20,987,642 11,064,187 53% 9,933,455
3,096,860 6,435,231 208% -3,338,371 3,064,036 2,702,600 88% 361,436
39,874
-12,219,723 -12,134,212
3,096,860 6,435,231 208% -3,338,371 -9,115,813 -9,431,612
1,007,854 643,383 64% 364,471 1,010,015 588,272 58% 421,743
1,105,134 619,857 56% 485,277 795,025 454,523 57% 340,502
2,649,357 780,302 31% 1,769,055 1,685,599 941,950 56% 743,649
312,338 140,862 45% 171,476 115,762 107,428 93% 8,334
4,974,683 2,164,404 44% 2,790,279 3,606,401 2,092,173 58% 1,514,228
342,994 154,566 45% 188,428 255,689 112,124 44% 143,565
55,285 7,342 13% 47,943 20,000 20,000 100%
55,074 31,034 56% 24,040 43,004 27,897 65% 15,107
22,397 12,661 57% 9,736 15,010 5,515 37% 9,495
757,818 297,791 39% 460,027 533,105 263,598 49% 269,507
71,886 58,459 81% 13,427 58,047 48,542 84% 9,505
280,456 161,032 57% 119,424 264,382 168,812 64% 95,570
145,318 84,912 58% 60,406 137,577 85,300 62% 52,277
201,388 104,941 52% 96,447 164,547 96,674 59% 67,873
48,586 27,946 58% 20,640 49,314 32,781 66% 16,533
83,391 38,156 46% 45,235 44,993 25,644 57% 19,149
75,330 32,098 43% 43,232 60,291 31,429 52% 28,862
62,015 46,681 75% 15,334 63,730 38,838 61% 24,892
37,360 8,565 23% 28,795
240,908 168,631 70% 72,277 105,170 47,185 45% 57,985
117,796 66,103 56% 51,693 99,729 62,072 62% 37,657
114,863 57,908 50% 56,955 115,191 70,838 61% 44,353
256,508 140,161 55% 116,347 218,802 144,651 66% 74,151
89,915 50,074 56% 39,641
3,059,288 1,649,061 51% 1,510,227 2,248,581 1,282,100 57% 966,481
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/1999 THROUGH 02/29/2000
SPECIAL' REVENUE FUND
CURRENT CURRENT PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR
/¢
********REVENUES~***
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
82,965.00 39,810.33 43.154.67 76.684.53
183.800.00 121.649.55 62.150.45 172.561.75
59.000.00 53.573.47 5.426.53 65.857.76
90,160.00 90.160.00 93,371.12
2,515~457.00 383,756.51 2,131.700.49 753.103.27
136,650.00 50,924.00 85,726.00 149.244.00
402.336.00 27,554.07 374,781.93 374.449.92
729.650.00 367,819.69 361.830.31 706.992.33
30.000.00 31.609.31 (1.609.21) 22.439.87
4.230.018.00 1.076.696.93 3.153,321.07 2.414.704.55
******~EXPENDITURES~*****
PUBLIC SAFETY:
POLICE 87,959.00 44,162.07
TRAFFIC SIGNALS & STREET LTG 128,770.00 65,389.47
FIRE SERVICES 88.143.00 975.00
ACTIVITY TOTAL 304.872.00 110,526.54
TRANSPORTATION:
STREET MAINTENANCE 410,056.00 58,694.91
STREET SWEEPING
ACTIVITY TOTAL 410,056.00 58.694.91
HEALTH & WELFARE:
WASTE MANAGEMENT 870,570.00 437,060.31
SENIOR SUPPORT CARE
ACTIVITY TOTAL 870.570.00 437,060.31
COMMUNITY DEVELOPMENT:
ENGINEERING 6.000.00
ACTIVITY TOTAL 6,000.00
CAPITAL IMPROVEMENT PROJECTS:
GENERAL CIP PROJECTS 17.665.00
COMMUNITY PROJECTS 189,895.00 6,542.73
PARKS 21.119.00 3,577.66
STREET CONSTRUCTION/IMPROVEMENT 2,246,122.00 14,604.01
ACTIVITY TOTAL 2,474,801.00 24.724.40
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
TRANSFER tN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
43.796.93
63,380.53
87,168.00
194,345.46
351.361.09
351,361.09
433.509.69
433,509.69
6,000.00
6.000.00
17.665.00
183,352.27
17,541.34
2.231.517.99
2.450.076.60
4,066,299~00 63t.006.16 3,435.292.84
(163,719.00) (445.690.77) 28t.971.77
78.444.67
72.476.39
81.444.13
232,365.19
265.92O.49
81.727.11
347.647.60
827,685.54
7.044.00
834.729.54
44,166.79
44.166.79
56.548.31
51.300.97
674.931.01
782.780.29
2,241,689.41
(173,015.14)
(130.265.91)
62,370.78
EXCESS <REVENUE> EXPENDITURE (163.719.00) (445,690.77) 281.971.77 (240.910.27)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/1999 THROUGH 02/29/2000
CAPITAL- IMPROVEMENT
CURRENT CURRENT
BUDGET ACTUAL VARIANCE
FUND
.PRIOR
FISCAL YEAR
***~==*REVENUE***~*x
USES/MONEY & PROP-INTEREST
OTHER SOURCES OF REVENUE
TOTAL REVENUE:
73,785.00
27.856,145.00
27.929,930.00
73.785.00
27,856.145.00
27.929.930.00
2.257.954.64
2.257.954.64
*******EXPENDITURES***=***
GENERAL GOVERNMENT ACTIVITIES:
ACTIVITY TOTAL
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
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 OLFF TO OTHER FUNDS
61.886.00
61,886.00
2,206.938.00
9.443,800.00
16,623.429.00
28.274,167.00
28,336.053.00
406.123.00
602.80
602.80
821,390.36
5,474,623.52
964.110.95
7.260,124.83
7,260,727.63
7,260,727.63
61,283.20
61.283.20
1.385,547.64
3.969,176.48
15.659,318.05
21.014.042.17
21.075,325.37
(6.854,604.63)
16,915.01
16,915.01
145.14
145.14
124,753.27
1,180.149.86
744.202.34
2,049.t05.47
2,066,165.62
(191,789.02)
17,586.84
EXCESS <REVENUE>EXPENDITURE 406.123.00 7,260,727.63 (6,854.604.63) (174,202.18)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/1999 THROUGH 02/29/2000
S P E C I'AL' AS~S E SSM E NT
CURRENT CURRENT
BUDGET ACTUAL VARIANCE
FUND
PRIOR
FISCAL YEAR
~xx~XXXREVENUES~***
SPECIAL BENEFITS ASSESSMENTS
USES/MONEY & PROP-INTEREST
OTHER SOURCES OF REVENUE
TOTAL REVENUE
309.093.00 151.797.31 157.295.69 253.t75.40
15.027.00 15.027.00 16.381.44
2.500.00 668.85 1.831.15 2.736.05
326.620.00 152.466.t6 174,153.84 272.292.89
x~x~EXPENDITURES***~x*
PUBLIC SAFETY:
TRAFFIC SIGNALS & STREET LIG
ACTIVITY TOTAL
TRANSPORTATION PUBLIC WORKS
STREET TREE MAINTENANCE
STREET LANDSCAPE MAINTENANCE
ACTIVITY TOTAL
qEALTH & WELFARE:
ENGINEERING
ACTIVITY TOTAL
]APITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS
STREET CONSTRUCTION/tMPRVMNT
ACTIVITY TOTAL
~ 0 T A L EXPENDITURES
!XCESS <REVENUE>EXPENDITURE
145.005.00 50,935.83 94,069.17
145.005.00 50.935.83 94.069.17
2,945.00 1.905.19 1.039.81
13.210.00 1.864.24 11.345.76
160.990.00 69.611.11 91,378.89
177~145.00 73,380.54 103.764.46
4.200.00 4.336.86 (136.86)
4.200.00 4,336.86 (136.86)
18,700.00 46.41 18.653,59
82.600.00 620.68 81.979.32
101,300.00 667.09 100,632.91
107,525.57
107.525.57
2.246.99
7,694.38
105.652.77
t15,594.14
3.084.88
3.084.88
427.650.00 129.320.32 298,329.68 226,204.59
101,030.00 (23,145.84.) 124.175.84 (46,088.30)
:XCESS <REVENUE>EXPENDITURE 101,030.00 (23.145.84) 124.175.84 (46,088.30)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/1999 THROUGH 02/29/2000
TRUST/AG'ENCY. FUND
CURRENT CURRENT PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR
********REVENUES~*~,¢*
SPECIAL ASSESSMENTS
USES/MONEY & PROP-INTEREST
TOTAL REVENUE
116,594.77 (116,594.77) 235.672.36
12.637.55
116,594.77 (116.594.77) 248.309.91
*******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
190,256.00 (t90,256.00) 231.864.50
190,256.00 (t90,256.00) 231,864.50
t90,256.00 (190.256.00) 231,864.50
73,661.23 (73.661.23) (16,445.41)
EXCESS <REVENUE>EXPENDITURE 73.661.23 (73,661.23) (16,445.41)
THE CItY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/0t/1999 THROUGH 02/29/2000
t NTE RNA-L SE RV I CE FUND
CURRENT CURRENT PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR
~REVENUES**-*~
USES/MONEY & PROP-INTEREST
CHARGES FOR SERVICES
OTHER SOURCES OF REVENUE
TOTAL REVENUE
56.832.00 56.832.00 40.084.94
589.275.00 371.607.90 217.667.10 726.998.50
25,700.00 28,607.44 (2,907.44) 17.455.06
671.807.00 400,215.34 27t,591.66 784.538.50
***~EXPENDITURES**~'****
GENERAL GOVERNMENT ACTIVITIES
NON-DEPARTMENTAL
ACTIVITY TOTAL
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH'& WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
706.909.00 156.310.34 550.598.66 794,802.16
706.909.00 161.900.34 545.008.66 794,802.16
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
706.909.00 161,900.34 545.008.66
35.102.00 (238.315.00) 273.417.00
794,802.16
10,263.66
13.582.460.94
EXCESS <REVENUE>EXPENDITURE. 25.102.00 (238.315.00) 273.417.00 (13.572,197.28)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/1999 THRUGH 02/29/2000
E NT-E R-P R I S E FUND
CURRENT CURRENT PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR
***********************
USES/MONEY & PROP-INTEREST
TOTAL REVENUE
1.671.632.89
1.671,632.89
****~*x~EXPENDITURES*~*~
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL
FINANCE
ACTIVITY TOTAL
PUBLIC SAFETY:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
SOMMUNITY DEVELOPMENT:
SAPITAL IMPROVEMENT PROJECTS:
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
TP~ANSFERS IN FROM OTHER FUNDS
TRANSFERS ObrF TO OTHER FUNDS
10.00
IO.O0
10.00
10.00
10.00
10.00
10.00
10.00
935,724.30
500.00
936.'224.30
936,224.30
(735.408.59)
(12.134.212.45)
13.587.133.27
EXCESS <REVENUE>EXPENDITURE 10.00 10.00 717,512.23
GENERAL
REVENUE
FUNDS
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 29Feb2000
SPECIAL SPECIAL CAPITAL TRUST/
REVENUE ASSESSMENT IMPROVEMENT AGENCY
FUNDS FUNDS FUND FUND
TOTALS
---MEMORANDUM ONLY---
CURRENT PRIOR
ASSETS
CASH
CASH WITH FISCAL'AGENT
UNAMORTIZED BOND DISCOUNT
(16.109,992)
INVESTMENTS AT COST
RECEIVABLES: TAXES
ACCOUNTS (NE
INTEREST
ASSESSMENTS
41.051,425
149,497
205.076
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS
FIXED ASSETS
AMOUNT TO BE PROVIDED
TOTAL ASSETS
5.849
19.746
25,321,602
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
(649,197)
(19,380)
(597.119)
(154,355)
(210,273)
(38,520)
(149.497)
(1.818,342)
(23,503.261)
TOTAL FUND E (23,503,261)
1.960,558
311
28.347
1.989.217
(1,989,217)
(1.989,217)
331.950 13,557,871
331.950 13.557.871
(20.271.025)
(99,415)
(5.849)
(20.376.289)
(331,950) 6.818,418
(331,950) 6,818,418
118.262 (141,350) (8.211,129)
1491763 149,763 149,763
41,051,425
149,808
205,076
t,860,500
2.128.525
34,196
19,746
1,860,500
43,329.165
(649,197)
(20.290,406)
(597,119)
(253.770)
(210,273)
(38,520)
(t55,346)
(1.978,000) (1,978,000)
(1,978,000) (24,172,630)
(150.525) (19,156.535)
(150,525) (19,156.535)
34.556,969
1,399,589
502,727
212,897
7.O27
1.860,500
30,478,344
(498,812)
(4.882,178)
(468,866)
(2,895,909)
(309.574)
(150,963)
(155,346)
(1,978,000)
(11,339,647)
(19.138,697)
(19,138,697)
TOTAL LIAB. FND BAL. RETD (25,321,602) (1,989,217) (331,950) (13.557,871) (2,128,525) (43,329.165) (30,478,344)
INTERNAL
SERVICE
FUNDS
ENTERPRISE
FUNDS
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 29Feb2000
FIXED ASSETS GENERAL LONG
GROUP OF TERM DEBT
ACCOUNTS ACCOUNT GROUP
TOTALS
---MEMORANDUM---
CURRENT PRI OR
ASSETS
CASH
CASH WITH FISCAL AGENT
UNAMORTIZED BOND DISCOUNT
1.241,016
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
19,491.955
20,732,970
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 (20.732,970)
TOTAL FUND E (20.732,970)
(10)
6,388,993
28.663.249
(10) 6,388.993 28.663.249
10 (6,388,993)
10 (6,388,993)
(28.663,249)
(28.663,249)
1,241,006 1.023.507
25,880,948 25,880,948
28,663,249 29,519,398
55.785.203 56.423.853
(20.806)
(28,663,249) (29,519,398)
(28,663.249) (29,540.205)
(27,121.954) (26,883,649)
(27.121.954) (26.883.649)
TOTAL LIAB. FND BAL. RETD (20.732.970) 10 (6.388,993) (28,663,249) (55.785,203) (56,423.853)