HomeMy WebLinkAboutItem 4.04 FinanceRept April2001CITY CLERK
FILE # 330-50
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: (May 15, 2001)
SUBJECT:
ATTACHMENTS:
RECOMMENDATION:/~
FINANCIAL STATEMENT:
Financial Reports For the Month of April 2001
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 April 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 April 2001. 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 April 2001 Revenue and Expenditure Report
The April report represents the reporting of revenues and expenditures for the first ten 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 April are higher than what occurred in the ninth month of
the previous Fiscal Year. The City had collected through April 2001 approximately 93% of the total
budgeted General Fund Revenues compared to approximately 77% 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 Eastem 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.
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.
COPIES TO:
G:MMonthly Financials\032001 agenda statement monthly ~nancials. doc
ITEM
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 ten 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 eamings reported in the General Fund still needs to be allocated to all of the City's funds 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 ten 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 in the prior year. The amount of
revenue recorded is based upon the payments made to date to outside contractors for these services.
Fines and Forfeitures is higher than the prior year due to an increase in the number of traffic citations
issued over the prior year. Other Revenue is lower than the same period in the prior year, as the City has
not yet received any reimbursements from PG&E for the Dublin Boulevard Underground Utilities project.
General Fund Exilenditures
Overall, through the month of April expenditures in the General Fund totaled $13,247,680 and
represented approximately 47% of the total budgeted expenditures in the General Fund. Of this amount, a
total of $987,852 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 April 2001 was lower than
the amounts expended for the same period in the prior Fiscal Year. As of April 2001, the City had
expended 53'% of the General Fund Operating Budget compared to 62% in the prior Fiscal Year. As
previously noted there are some timing differences with payment for contract services which complicate
comparisons between one Stear 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.
Culture and Leisure Services are lower than in the same period of the prior year due to lower than
expected personnel expense to date for Recreation Administration and Playgrounds, and timing
differences in payments for contract services in the Special Events and Shannon Center events divisions.
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 ~mded 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 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
Califomia Government Code.
f
Total General Fund Revenues
Property Taxes
City of Dublin 2000-2001 YTD Revenues and Budget Comparison
For the Period Ending April 30, 2001
~ ~ 177°~ 93%
] [9o% IIIIII 111%
Sales Taxes
Real Property Transfer Tax
88%
· FY 2000/2001
[] FY 1999/2000
Transient Occupancy Taxes
79%
Franchise Taxes
Licenses and Permits
Interest and Rentals
Intergovernmental from State
136°/~
Charges for Services
74%
Fines and Forfeitures
]123%
Other Revenues
0%
30%
60%
'88%
90%
120%
150%
83% 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
6,874,391 111%
9,925,371 88%
487,637 169%
717,043 79%
988,532 97%
2,702,406 87%
2,059,520 136%
1,655,797 91%
2,558,365 74%
84,415 123%
2,340,599 80%
30,394,075 93%
FY 99~00
YTD Actual
5,403,434
8,092,420
286,952
491,435
820,842
3,016,233
1,422,091
1,336,371
2,050,965
62,855
640,370
23,623,968
% of Total for
FY 99~00
90%
70%
77%
61%
85%
77%
106%
82%
62%
74%
88%
77%
V. ¢ I
ATTACHMENT 1
City of Dublin 2000-2001 YTD Expenses and Budget Comparison
For the Period Ending April 30, 2001
Total General Fund
Expenses
General Government
I
I
62%
68%
73%
Police
52%
Fire
Other Public Safety
Transportation
Health and Welfare
Culture & Community
Services
Community
Development
Capital Improv.
Projects
0%
20%
59%
45%
40% 60%
83% of Year Complete
)%
72%
90%
82%
81%
80%
100%
[] FY 2000/2001
· FY 1999/2000
FY 2000/2001
Budget
General Government
Police
Fire
Other Public Safety
Transportation
Health and Welfare
Culture and Community Services
Community Development
Capital Improvement Projects
3,067,557
6, 125,924
4,448,831
283,619
960,383
19,390
3,472,989
4,894,262
5,055,978
Total General Fund Expenses 28,328,933
General Fund Operating Expenses 23,272,955
FY 200012001 % of
YTD Actual Budget
2,092,809 68%
1,468, 133 24%
2,070,371 47%
106,587 38%
659,506 69%
8,716 45%
2,391,255 69%
3,462,453 71%
987,852 20%
13,247,680 47%
12,259,829 53%
FY 99~00
YTD Actual
1,666, 158
2,631,143
2,161,813
112,619
560,767
6,431
2,022,981
2,974,753
1,434,450
13,571,113
12,136,663
% of Total for
FY 99~00
73%
52%
51%
59%
72%
38%
90%
82%
81%
62%
62%
ATTACHMENT 2
CITY OF DUBLIN'S
FINANCIAL STATEMENTS
FOR
THE MONTH OF APRIL 2001
Prepared by
The Finance Department
May 2, 2001
ATTACHMENT 3
GENERAL
REVENUE
FUNDS
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 30Apr2001
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
(30,328,157)
INVESTMENTS AT COST
RECEIVABLES: TAXES
ACCOUNTS (NE
INTEREST
ASSESSMENTS
73,567,745
179,827
302,286
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS
FIXED ASSETS
AMOUNT TO BE PROVIDED
TOTAL ASSETS
4.143
8.708
43,734.553
LIAL/FND BAL/RETND ERNGS
DEPOSITS FOR PRIVATE DEVEL (613.152)
DEPOSITS FOR AB1600 FEES (5.733)
DEPOSITS OTHERS (469,793)
PAYABLES: ACCOUNTS (152,483)
INTEREST
PAYROLL (268,717)
DUE TO OTHERS (16.800)
DEFERRED REVENUE (149,497)
DEBT INSTRUMENTS PAYABLE
TOTAL LIABILITIES (1,676,174)
FUND BALANCES (42.058.378)
TOTAL FUND E (42,058,378)
2,392,535
20,646
(114)
2,413,067
(34,364)
(34,364)
(2,378.703)
(2.378.703)
486,461 24,891,045
515.300
486.461 25,406.345
(31,169,162)
(10.875)
144,208
161.931
(2.413.908) (10.431.784)
161.931 157.925
515,300 4.267.787
73,567,745 49,227,117
200,473 2,365,857
302,286 718,499
1,745;500
2,051,639
4,029 61,210
8,708 13,144
1.745,500 1,745,500
74,092,064 48,125,255
(613.152) (663.000)
(31,174.895) (12.455,564)
(469.793) (354,683)
(197.722) (4.536.975)
(268.717) (446,756)
(16.800) (233,477)
(4,143) (153,640) (153,640)
(1,863.000) (1.863.000) (1,863,000)
(31.184,180~ (1,863.000) (34.757,719) (20,707,095)
(486,461) 5,777,836 (188.639) (39:334,345) (27,418.160)
(486,461) 5,777.836 (188.639) (39,334,345) (27,418.160)
TOTAL LIAB. FND BAL. RETD (43.734,553) (2.413,067) (486.461) (25.406,345) (2,051,639) (74.092,064) (48.125.255)
INTERNAL
SERVICE
FUNDS
ENTERPRISE
FUNDS
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 30Apr2001
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,680.230
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,105.766
23,785.997
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 (1)
FUND BALANCES (23,785,996)
TOTAL FUND E (23,785,996)
(1)
8,626.020
48,192,411
8.626,020 48,192,411
(8.626.020)
(8,626,020)
(48,192,411)
(48,192,411)
2.680,230 2,384,683
29.731.786 29.731.786
48,192.411 48.653.563
80.604.428 80.770.032
(1) (6,353)
(48,192,411) (48,653,563)
(48,192,412) (48,659,916)
(32,412.016) (32,110,116)
(32,412,016) (32,110,116)
TOTAL LIAB. FND BAL. RETD (23.785,997) (8.626.020) (48.192,411) (80.604,428) (80,770,032)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 04/30/200t
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 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 MAINTENAN
ACTIVITY TOTAL
HEALTH & WELFARE
6,168,350.00 6,874,390.92 (706,040.92) 5,991,813.80 5,403,433.77 588,380.03
11,300,000.00 9,925,371.27 1,374,628.73 11,548,901.00 8,092,420.27 3,456,480.73
288,000.00 487,637.36 (199,637.36) 370,945.99 286,951.91 83,994.08
910,000.00 717,042.82 192,957.18 808,688.14 491,434.62 3t7,253.52
1,017,840.00 988,532.17 29,307.83 963,069.84 820,841.84 142,228.00
3,124,088.00 2,702,405.82 421,682.18 3,897,965.22 3,016,233.11 881,732.11
68,755.00 84,414.87 (15,659.87) 84,542.77 62,854.73 21,688.04
1,411,205.00 1,982,623.68 (571,418.68) 1,254,906.26 1,361,507.86 (106,601.60)
102,054.00 76,895.82 25,158.18 85,831.12 60,583.59 25,247.53
1,813,500.00 1,655,796.50 157,703.50 1,629,846.86 1,336,371.48 293,475.38
2,594.33 2,594.33
3,434,158.00 2,558,364.76 875,793.24 3,308,263.42 2,050,965.14 1,257,298.28
2,935,654.00 2,340,598.58 595,055.42 726,524.45 640,369.50 86,154.95
32,573,604.00 30,394,074.57 2,179,529.43 30,673,893.20 23,623,967.82 7,049,925.38
177,905.00 130,638.29 47,266.71 144,214.76
445,805.00 345,583.03 100,221.97 368,092.08
250,000.00 194,327.36 55,672.64 202,489.29
407,882.00 323,505.07 84,376.93 301.4-46.94
889,601.00 583,008.13 306,592.87 606,030.20
516,021.00 376,346.41 139,674.59 482,597.30
245,493.00 127,387.52 118,105.48 169,061.86
7,350.00 12,013.21 (4,663.21) 904.34
127,500.00 127,500.00 77.83
3,067,557.00 2,092,809.02 974,747.98 2,274,914.60
6,125,924.00 1,468,132.54 4,657,791.46 5,106,215.64
63,760.00 33,565.50 30,194.50 47,608.15
177,595.00 38,868.24 138,726.76 107,720.18
42,264.00 34,153.03 8,110.97 37,094.46
4,448,831.00 2,070,371.42 2,378,459.58 4,186,527.66
10,858,374.00 3,645,090.73 7,213,283.27 9,485,166.09
508,071.00 388,522.43 119,548.57 406,083.23
861.00 79.88 781.12 11,513.70
107,031.00 72,099.13 34,931.87 82,440.23
45,768.00 28,013.33 17,754.67 40,288.40
298,652.00 170,790.75 127,861.25 286,816.64
960,383.00 659,505.52 300,877.48 827,142.20
121 240.76
284 915.82
154 843.44
202 337.62
460 906.58
323 977.58
117 026.38
831.77
77.83
1,666,157.78
2,631,142.79
30,961.59
51,131.97
30,525.34
2,161,812.60
4,905,574.29
311,681.45
26.10
58,109.63
21,842.57
169,106.91
560,766.66
22,974.00
83,176.26
47,645.85
99,109.32
145,123.62
158,619.72
52,035.48
72.57
608,756.82
2,475,072.85
16,646.56
56,588.21
6,569.12
2,024,715.06
4,579,591.80
94,401.78
11,487.60
24,330.60
18,445.83
117,709.73
266,375.54
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 04/30/2001
GENERAL REVENUE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
WASTE MANAGEMENT
CHILD CARE
ACTIVITY TOTAL
CULTURE & 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/FACILITIES MANAGEMENT
ACTIVITY TOTAL
COMMUNITY DEVELOPMENT
PLANNING
BUILDING SAFETY
ENGINEERING
ECONOMIC DEVELOPMENT
ACTIVITY TOTAL
CAPITAL IMPROVEMENT PROJECTS
GENEP, AL CIP PROJECTS
COMMUNITY IMPROVEMENTS
PARKS
STREET CONSTRC/IMPROVEMENTS
ACTIVITY TOTAL
TOTAL EXPENDITURES
EXCESS REVENUE (EXPENDITURES)
TRANSFERS IN FROM OTHER FUNDS
TRANSFERS OUT FROM OTHER FUNDS
REVENUES OVER(UNDER) EXPENDITURES
7,390.00
12,000.00
19,390.00
362,922.00
55,408.00
67,861.00
33,337.00
868,907.00
69,852.00
312,313.00
218,209.00
238,841.00
55,790.00
105,053.00
76,562.00
75,044.00
34,035.00
264,524.00
145,236.00
129,585.00
278,195.00
96,315.00
3,472,989.00
1,376,095.00
1,401,919.00
1,816,058.00
300,190.00
4,894,262.00
2,646,604.00
381,901.00
545,201.00
1,482,272.00
5,055,978.00
28,328,933.00
4,244,671.00
22,850.00
(2,400,010.00)
1,867,511.00
1,469.88 5,920.12 7,085.81 2,173.70 4,912.11
7,246.00 4,754.00 12,000.00 4,256.94 7,743.06
8,715.88 10,674.12 19,085.81 6,430.64 t2,655.17
272,191:50
43,160.12
48 694.37
21832.11
518 914.29
60 204.35
239 459.45
142 302.80
168 146.30
43,491.00
74,953.50
48,991.27
62,583.01
15,020.48
166,250.30
107,577.00
88,008.86
193,188.48
76,286.03
2,391,255.22
1,020,887.07
976,207.96
1,236,092.79
229,264.76
3,462,452.58
320.,461.80
116,687.55
391,065.23
159,636.93
987,851.51
13,247,680.46
17,146,394.11
17,146,394.11
90,730.50
12,247.88
19,166.63
11,504.89
344,992.71
9,647.65
72 853.55
70 906.20
65 694.70
12 299.00
30 099.50
27570.73
t2 460.99
19 014.52
98273.70
37659.00
41576.14
85,006.52
20,028.97
1,081,733.78
355,207.93
425,711.04
579,965.21
70,925.24
1,431,809.42
2,326,142.20
265,213.45
154,135.77
1,322,635.07
4,068,126.49
15,081,252.54
(12,901,723.11)
22,850.00
(2,400,010.00)
(15,278,883.11)
342,557.00
53,367.37
56,071.79
30,225.33
633,590.64
66,950.70
269,725.81
145,380.76
195,927.57
47,479.90
75,134.57
63,823.38
67,900.31
28,795.78
218,102.49
115,715.37
102,256.75
228,879.72
85,735.46
2,827,620.70
1,252,774.61
1,144,717.07
1,462,847.69
255,690.44
4,116,029.81
1,297,739.34
234,272.83
722,642.96.
111,551.69
2,366,206.82
21,916,166.03
8,757,727.17
17,869.13
(931,640.50)
7,843,955.80
248,561.25
22,679.39
42,292.87
18,259.24
360,304.32
60,317.23
215,387.09
109,865.22
140,264.47
37,233.45
50,889.50
38,737.06
59,900.65
12,307.76
205,354.52
87,567.57
78,856.81
167,564.67
66,638.05
2,022,981.12
926,104'.32
768,318.53
1,001,529.02
278,800.63
2,974,752.50
887,611.93
168,743.87
309,429.63
68,664.63
1,434,450.06
13,571,113.05
10,052,854.77
10,052,854.77
93,995.75
30,687.98
13,778.92
11,966.09
273,286.32
6,633.47
54,338.72
35,515.54
55,663.10
10,246.45
24,245.07
25,086.32
7,999.66
16,488.02
12,747.97
28,147.80
23,399.94
61,315.05
19,097.41
804,639.58
326,670.29
376,398.54
461,318.67
(23,110.19)
1,141,277.31
410,127.41
65,528.96
413,213.33
42,887.06
931,756.76
8,345,052.98
(1,295,127.60)
17,869.13
(931,640.50)
(2,208,898.97)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 04/30/2001
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 FEDERAL
CHARGES FOR SERVICES
OTHER SOURCES OF REVENUE
TOTAL REVENUE
*******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
82,850.00 75,000.93 7,849.07
194,000.00 180,849.41 13,150.59
89,475.00 89,617.18 (142.18)
100,676.00 87,213.13 13,462.87
2,367,881.00 938,689.81 1,429,191.19
137,780.00 128,820.00 8,960.00
1,026,394.00 64,286.02 962,107.98
763,302.00 714,741.38 48,560.62
5,000.00 5,259.25 (259.25)
4,767,358.00 2,284,477.11 2,482,880.89
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,695,289.00
2,989,113.00
5,283,654.00
516,296.00
22,850.00
78,715.14
t92,662.02
113,370.96
103,772.70
1,158,533.84
177,904.00
87,679.67
733,208.99
40,601.31
2,686,448.63
72,296.16
155,129.05
69,656.40
24,019.31
479,384.94
75,388.00
27,554.07
676,015.01
31,609.31
1,611,052.25
6,418.98
37,532.97
43,714.56
79,753.39
679,148.90
102,516.00
60,125.60
57,193.98
8,992.00
1,075,396.38
62,998.79 t47,841.21 88,258.42 50,635.92 37,622.50
57,844.41 83,800.59 121,790.46 84,105.12 37,685.34
131,419.58 (.42,294.58) 79,100.67 40,698.75 38,401.92
252,262.78 189,347.22 289,149.55 175,439.79 113,709.76
136,302.66 523,593.34 533,583.10 76,540.17 457,042.93
136,302.66 523,593.34 533,583.10 76,540.17 457,042.93
660,632.56 508,902.44 866,219.67 437,085.67 429,134.00
3,750.00 3,750.00.
6,202.30 3,797.70
670,584.86 516,450.14 866,219.67 437,085.67 429,134.00
6,000.00
6,000.00
6,000.00
6,000.00
6,000.00
6,000.00
13,997.81 13,997.81
53,851.22 231,152.78 59,617.41 7,549.56 52,067.85
8,820.00 20,517.41 3,577.66 16~939.75
550,347.86 2,144,941.14 429,360.36 27,380.41 401,979.95
604,199.08 2,384,913.92 523,492.99 38,507.63 484,985.36
1,663,349.38 3,620,304.62 2,218,445.31 727,573.26 1,490,872.05
(621,127.73) 1,137,423.73 (468,003.32) (883,478.99) 415,475.67
17,869.13
22,850.00
17,869.13
EXCESS <REVENUE> EXPENDITURE 539,146.00 (621,127.73) 1,160,273.73 (450,134.19) (883,478.99) 433,344.80
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 04/30/2001
SPECIAL ASSESSMENT
CURRENT CURRENT
BUDGET ACTUAL VARIANCE
FUND
PRIOR
FISCAL YEAR
PRIOR
Y.T.D.
VARIANCE
********REVENUES********
SPECIAL BENEFITS ASSESSMENTS
USES/MONEY & PROP-INTEREST
OTHER SOURCES OF REVENUE
TOTAL REVENUE
390,388.00 345,216.36 45,171.64 318,354.40 281,554.49 36,799.91
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 358,472.08 51,504.92 335,660.27 286,021.26 49,639.01
*******EXPENDITURES*******
PUBLIC SAFETY:
TRAFFIC SIGNALS & STREET LIG 172,115.00 76,802.47 95,312.53 118,667.18 77,266.31 41,400.87
ACTIVITY TOTAL 172,115.00 76,802.47 95,312.53 118,667.18 77,266.31 41,400.87
TRANSPORTATION
PUBLIC WORKS 4,480.00 1,867.10 2,612.90 3,613.20 2,513.34 1,099.86
STREET TREE MAINTENANCE 12,039.00 2,495.99 9,543.01 4,219.57 2,115.04 2,104.53
STREET LANDSCAPE MAINTENANCE 239,352.00 91,403.02 147,948.98 131,200.04 86,661.22 44,538.82
ACTIVITY TOTAL 255,871.00 95,766.11 160,104.89 139,032.81 91,289.60 47,743.21
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
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS 52,840.00 2,519.14 50,320.86 28,139.83 28,139.83
STREET CONSTRUCTION/IMPRVMNT 46;752.16 1,485.20 45,266.96
ACTIVITY TOTAL 52,840.00 2,519.14 50,320.86 74,891.99 1,485.20 73,406.79
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
485,586.00 179,387.80 306,198.20 337,087.96 174,377.97 162,709.99
75,609.00 (179,084.28) 254,693.28 1,427.69 (111,643.29) 113,070.98
EXCESS <REVENUE>EXPENDITURE 75,609.00 (179,084.28) 254,693.28 1,427.69 (111,643.29) 113,070.98
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 04/30/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,t40,375.57
*******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 OUT TO OTHER FUNDS
37,834.00 26,460.81 11,373.19 12,389.68 1,108.43 11,281.25
37,834.00 26,460.81 11,373.19 12,389.68 1,108.43 11,281.25
1,747,473.75
1,412,999.00
20,483,791.00
23,644,263.75
23,682,097.75
4,620,604.00
627,111.96 1,120,361.79 1,859,640.67 1,229,269.92
17,881.46 1,395,117.54
6,311,994.27 14,171,796.73
6,956,987.69 16,687,276.06
6,983,448.50 16,698,649.25
6,194,234.06 (1,573,630.06)
6,057,184.37
2,433,845.51
10,350,670.55
10,363,060.23
25,910.99
5,686,291.34
1,544,196.80
8,459,758.06
8,460,866.49
8,264,092.82
630,370.75
370,893.03
889,648.71
1,890,912.49
1,902,193.74
(8,238,181.83)
EXCESS <REVENUE>EXPENDITURE 4,620,604.00 6,194,234.06 (1,573,630.06) 25,910.99 8,264,092.82 (8,238,181.83)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 04/30/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
206,511.07 (206,511.07) 233,189.54 203,042.46 30,147.08
5,939.51 (5,939.51) 13,281.66 5,575.23 7,706.43
212,450.58 (212,450.58) 246,471.20 208,617.69 37,853.51
*******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
233,093.57 (233,093.57) 261,375.75 261.375.75
233,093.57 (233,093.57) 261,375.75 261,375.75
233,093.57 (233,093.57) 261,375.75 261.375.75
20,642.99 (20,642.99) 14,904.55 52,758.06
20,642.99 (20,642.99) 14,904.55 52,758.06
(37,853.51)
(37.853.51)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 04/30/2001
INTERNAL SERVICE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
/5
********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 5t,158.93
919,498.00 767,650.32 151,847.68 580,974.63 483,745.56 97,229.07
17,000.00 17,000.00 42,214.73 28,607.44 13,607.29
1,124,170.00 864,315.12 259,854.88 688,513.53 526,518.24 161,995.29
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES
NON-DEPARTMENTAL
ACTIVITY TOTAL
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
1,019,738.00 298,084.35 721,653.65 865,319.44 203,831.82 661,487.62
1,019,738.00 298,084.35 721,653.65 865,319.44 203,831.82 661,487.62
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 IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
1,048,563.00 337,898.72 710,664.28
(75,607.00) (526,416.40) 450,809.40
865,319.44
176,805.91
931,286.00
209,421.82
(317,096.42)
655,897.62
493,902.33
931,286.00
EXCESS <REVENUE>EXPENDITURE (2,475,607.00) (526,416.40) (1,949,190.60) (754,480.09) (317,096.42) (437,383.67)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 04/30/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
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
344.50
354.50
354.50
354,50
(354.50)
EXCESS <REVENUE>EXPENDITURE 354.50 (354.50)