HomeMy WebLinkAbout4.08 FinRpts 3-01 CITY CLERK
FILE # 330-50
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: (April 17, 2001)
SUBJECT:
ATTACHMENTS:
RECOMMENDATION:~
FINANCIAL STATEMENT:
Financial Reports For the Month of March 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 March 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 March 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 March 2001 Revenue and Expenditure Report
The March report represents the reporting of revenues and expenditures for the first nine 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 March are higher than what occurred in the ninth month
of the previous Fiscal Year. The City had collected through March 2001 approximately 79% of the total
budgeted General Fund Revenues compared to approximately 65% 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 prioryear. 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 detailed data until the latter part
of April.
COPIES TO:
G:MMonthly Financials\032001 agenda statement monthly ~nancials.doc
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 nine 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 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 nine months of the year than was assumed in the budget calculations.
Intergovernmental 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 the City has not yet received any
reimbursements from PG&E for the Dublin Boulevard Underground Utilities project.
General Fund Ex!~enditures
Overall, 'through the month of March expenditures in the General Fund totaled $11.,985,642 and
represented approximately 42% of the total budgeted expenditures in the General Fund. Of this amount, a
total of $818,966 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 March 2001 was lower than
the amounts expended for the same period in the prior Fiscal Year. As of March 2001, the City had
expended 42% of the General Fund Operating Budget compared to 58% 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 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.
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
0%
City of Dublin 2000-2001 YTD Revenues and Budget Comparison
For the Period Ending March 31, 2001
794/o
I 76%
;61%
80%
~69%
72%
:~5o~5%
81%
~63%
82%
;74%
66%
'.64%
76%
106%
114%
30% 60% 90% 120% 150%
· FY 2000/2001
[] FY 1999/2000
75% 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 2000/2001
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 200012001 % of
YTD Actual Budget
4,668,423 76%
9,084,471 80%
428,040 149%
656,938 72%
664,040 65%
2,519,622 81%
1,597,177 106%
1,492,310 82%
2,279,362 66%
78,470 114%
2,216,457 76%
25,685,310 79%
FY 99~00
YTD Actual
3,660,335
7,508,520
255,618
469,797
533,928
2,742,472
846,411
1,206~619
1,902,220
54,111
638,098
19,818,129
% of Total for
FY 99~00
61%
65%
69%
58%
55%
70%
63%
74%
57%
64%
88%
65%
ATTACHMENT I
City of Dublin 2000-2001 YTD Expenses and Budget Comparison
For the Period Ending March 31, 2001
Total General Fund
Expenses
General Government
Police
Fire
42%
~8%
60%
67%
51%
46%
51%
Other Public Safety
TransportatiOn
Health and Welfare
Culture & Community
Services
Community
Development
Capital Improy.
Projects
0%
20%
55%
40%
60%
40% 60%
75% of Year Complete
74%
83%
76%
80% 100%
[] 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
Total General Fund Expenses
General Fund Operating Expenses
FY 200012001
Budget
3,065,557
6,125,924
4,448,831
283,619
960,383
19,390
3,472,989
4,894,262
5,055,978
28,326,933
23,270,955
FY 200012001 % of
YTD Actual Budget
1,846,267 60%
1,395,995 23%
2,066,126 46%
73,340 26%
579,063 60%
7,810 40%
2,087,783 60%
3,110,292 64%
818,966 16%
11,985,642 42%
11,166,676 48%
FY 99/00
YTD Actual
1,532,789
2,585,607
2,135,057
104,425
513,487
5,595
1,857,362
2,651,544
1,344,012
12,729,877
11,385,865
% of Total for
FY 99100
67%
51%
51%
55%
66%
33%
83%
74%
76%
58%
58%
ATTACHMENT 2
CITY OF DUBLIN'S '
FINANCIAL STATEMENTS
FOR
THE MONTH OF MARCH 2001
Prepared by
The Finance Department
April 10, 2001
ATTACHMENT 3
GENERAL
REVENUE
FUNDS
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 31Mar2001
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,853,329)
INVESTMENTS AT COST
RECEIVABLES: TAXES
ACCOUNTS (NE
INTEREST
ASSESSMENTS
69.747.182
179,827
302,286
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS
FIXED ASSETS
AMOUNT TO BE PROVIDED
TOTAL ASSETS
4,143
11,258
40.391,368
LIAL/FND BAL/RETND ERNGS
DEPOSITS FOR PRIVATE DEVEL (692,451)
DEPOSITS FOR AB1600 FEES (3.344)
DEPOSITS OTHERS (469.209)
PAYABLES: ACCOUNTS (160,520)
INTEREST
PAYROLL (285,989)
DUE TO OTHERS (18,705)
DEFERRED REVENUE (149,497)
DEBT INSTRUMENTS PAYABLE
TOTAL LIABILITIES (1.779,715)
,653)
,653)
FUND BALANCES (38.611
TOTAL FUND E (38,611
TOTAL LIAB. FND BAL. RETD (40,391.368)
2,155.532
20,646
(114)
2,176,064
(36,586)
(36.586)
(2,139,477)
(2,139,477)
(2,176.064)
377,122 25,078.168 64,666
161,931
515.300
1.745.500
377,122 25.593.468 1,972.097
(31,070,229)
(10,875)
(2.177,842) (10.431.784)
161,931 157.925
515,300 4.267.787
69,747,182 49,227,117
200,473 2,365,857
302,286 718.499
4.029 61.210
11.258 13.144
1,745,500 1,745.500
70,510,118 48,125.255
(692.451) (663,000)
(31.073,573) (12,455,564)
(469,209) (354.683)
(207.982) (4.536.975)
(285.989) (446.756)
(18.705) (233.477)
(4,143) (153.640) (153.640)
(1,863.000) (1.863.000) (1.863.000)
(31,085,247) (1.863,000) (34.764,548) (20.707.095)
(377.122) 5.491,779 (109,097) (35.745.569) (27.418.160)
(377,122) 5.491,779 (109,097) (35.745,569) (27,418.160)
(377,122) (25.593.468)
(1,972,097) (70.510,118)
(48,125.255)
INTERNAL
SERVICE
FUNDS
ENTERPRISE
FUNDS
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 31Mar2001
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,649,280
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,755,046
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,755,045)
TOTAL FUND E (23,755,045)
TOTAL LIAB. FND BAL. RETD (23,755,046)
8,626,020
48,245,595
8,626,020 48,245,595
(8,626,020)
(8,626,020)
(48,245,595)
(48,245,595)
(8,626,020) (48,245,595)
2,649,280 2,384,683
29,731,786 29,731,786
48,245,595 48,653,563
80,626,661 80,770,032
(1) (6,353)
(48,245,595) (48,653,563)
(48,245,596) (48,659,916)
(32,381,065) (32,110,116)
(32,381,065) (32,110,116)
(80,626,661) (80,770,032)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 03/31/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 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 4,668,423.12 1,499,926.88
11,300,000.00 9,084.471.27 2,215,528.73
288,000.00 428,040.08 (140.040.08)
910,000.00 656,937.63 253,062.37
1,017,840.00 664,040.38 353,799.62
3,124,088.00 2,519,621.76 604,466.24
68,755.00 78,469.56 (9,714.56)
1,411,205.00 1,528,591.72
102,054.00 68,585.66 33,468.34
1,813,500.00 1,492,309.82 321,190.18
3,434,158.00 2.279,362.01 1,154,795.99
2,935,654.00 2,216,457.12 719,196.88
32,573,604.00 25,685,310.13 6,888,293.87
177.905.00 119,668.26 58,236.74
445,805.00 312,458.30 133.346.70
250,000.00 177.626.21 72,373.79
405,882.00 253,558.62 152.323.38
889,601.00 520,124.73 369,476.27
516,021.00 333,078.69 182,942.31
245,493.00 117.740.96 127,752.04
7,350.00 12,010.96 (4.660.96)
127,500.00 127,500.00
3.065,557.00 1,846,266.73 1,219,290.27
6,125,924.00 1,395.995.04 4,729,928.96
63,760.00 27.767.26 35,992.74
177,595.00 14,616.94 .162,978.06
42.264.00 30,956.17 11,307.83
4,448,831.00 2,066,125.52 2.382.705.48
10,858,374.00 3,535,460.93 7,322,913.07
508.071.'00 343,701.74 164,369.26
861.00 861.00
107,031.00 61,366.13 45.664.87
45,768.00 18,407.71 27,360.29
298.652.00 155,587.70 143,064.30
960,383.00 579.063.28 381,319.72
5,991,813.80
11,548,901.00
370,945.99
808,688.14
963.069.84
3,897,965.22
84,542.77
(117,386.72) 1,254,906.26
85,831.12
1,629,846.86
2,594.33
3,308,263.42
726,524.45
30,673,893.20
144 214.76
368 092.08
202 489.29
301 446.94
606 030.20
482 597.30
169 061.86
904.34
77.83
2,274,914.60
5.106,215.64
47,608.15
107,720.18
37,094.46
4,186,527.66
9,485,166.09
406,083.23
11,513.70
82,440.23
40,288.40
286.816.64
827.142.20
3,660,334.96
7,508,520.27
.255,618.23
469,796.54
533,927.98
2,742,471.67
54.110.59
797,727.24
48.684.25
1,206.619.27
1,902.219.70
638.098.07
19,818,128.77
109.147.95
257,813.20
141.328.60
201,958.55
412.447.82
288,663.70
120,519.20
831.77
77.83
1.532,788.62
2,585.607.05
25.419.91
51,131.97
27.873.49
2,135.056.69
4,825,089.11
279,673.47
26.10
52,409.13
20,523.10
160.854.82
513,486.62
2,331.478.84
4,040,380.73
115,327.76
338,891.60
429.141.86
1,155,493.55
30,432.18
457,179.02
37,146.87
423,227.59
2,594.33
1.406,043.72
88,426.38
10,855,764.43
35,066.81
110,278.88
61,160.69
99,488.39
193,582.38
193,933.60
48,542.66
72.57
742,125.98
2,520.608.59
22.188.24
56.588.21
9.220.97
2,051.470.97
4,660,076.98
126,409.76
11,487.60
30,031.10
19,765.30
125,961.82
313,655.58
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 03/31/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.912.11
CHILD CARE 12,000.00 6.340.00 5,660.00 12,000.00 3,421.77 8,578.23
ACTIVITY TOTAL 19,390.00 7,809.88 11.580.12 19,085.81 5,595.47 13,490.34
CULTURE & LEISURE SERVICES
LIBRARY SERVICES 362.922.00 181.461.00 181,461.00 342,557.00 248,561.25 93,995.75
CULTURAL ACTIVITIES 55,408.00 41,471.35 13,936.65 53,367.37 20,644.52 32,722.85
HERITAGE CENTER 67,861.00 41,124.11 26,736.89 56,'071.79 37,346.46 18,725.33
DUBLIN CEMETERY 33,337.00 18,408.48 14,928.52 30.225.33 14.572.06 15,653.27
PARK MAINTENA.NCE 863,907.00 462,992.56 400,914.44 633,590.64 328,520.32 305,070.32
COMMUNITY TV 69,852.00 59,304.35 10,547.65 66,950.70 58,915.09 8,035.61
RECREATION ADMIN 312,313.00 211,552.35 t00.760.65 269,725.81 191,998.68 77,727.13
PLAYGROUNDS 213,209.00 130.838.32 82,370.68 145,380.76 98,895.51 46,485.25
SHANNON CENTER 233.841.00 149.691.21 84,149.79 195,927.57 i24,702.52 71.225.05
PRESCHOOL 55,790.00 39,726.13 16,063.87 47,479.90 33.502.51 13~977.39
TEENS PROGRAM 105,053.00 70,159.88 34,893.12 75,134.57 44,980.57 30,154.00
ADULT SPORTS 76.562.00 44.102.49 32,459.51 63,823.38 35,100.72 28,722.66
YOUTH SPORTS 75,044.00 57,393.37 17,650.63 67,900.31 56,149.51 11,750.80
COMMUNITY GYM 34,035.00 13,002.88 21,032.12 28,795.78 10,736.60 18.059.18
SPECIAL EVENTS 264,524.00 137,848.87 126.675.13 218,102.49 190,860.42 27,242.07
SENIOR CENTER 145,236.00 96,626.48 48,609.52 115,715.37 77,241.10 38,474.27
RECREATION INSTRUCTION 129,585.00 82,449.71 47.135.29 102,256.75 73,107.46 29,149.29
AQUATICS 278,195.00 180.677.76 97,517.24 228,879.72 151,496.71 77,383.01
PARKS/FACILITIES MANAGEMENT 96,315.00 68,951.64 27,363.36 85,735.46 60,029.97 25,705.49
ACTIVITY TOTAL 3,472.989.00 2,087,782.94 1,385.206.06 2,827,620.70 1.857,361.98 970,258.72
COMMUNITY DEVELOPMENT
PLANNING 1,376,095.00 923,355.36 452,739.64 1,252,774.61 804,395.77 448,378.84
BUILDING SAFETY 1.401,919.00 866.103.16 535,815.84 1,144,717.07 651.968.05 492,749.02
ENGINEERING 1,816,058.00 1.103,581.93 712,476.07 1,462,847.'69 927,496.06 535,351.63
ECONOMIC DEVELOPMENT 300,190.00 217,251.41 82,938.59 255,690.44 267,683.73 (11,993.29)
· ACTIVITY TOTAL 4.894,262.00 3,110,291.86 1,783,970.14 4,116,029.81 2,651,543.61 1,464,486.20
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS 2,646.604.00 309,339.08 2.337,264.92 1,297,739.35 868,976.27 428,763.07
COMMUNITY IMPROVEMENTS 381,901.00 99,757.90 282.143.10 234,272.83 108.969.14 125,303.69
PARKS 545,201.00 366.282.88 178.918.12 722,642.96 309,184.82 413,458.14
STREET CONSTRC/IMPROVEMENTS 1,482,272.00 43,586.05 1.438,685.95 111.551.69 56,881.83 54,669.86
ACTIVITY TOTAL 5,055,978.00 818.965.91 4,237,012.09 2.366.206.82 1,344.012.06 1,022,194.76
TOTAL EXPENDITURES
EXCESS REVENUE (EXPENDITURES)
TRANSFERS IN FROM OTHER FUNDS
TRANSFERS OUT FROM OTHER FUNDS
REVENUES OVER(UNDER) EXPENDITURES
28,326,933.00
4,246.671.00
22,850.00
(2.400,010.00)
1,869,511.00
11,985,641.53 16.341,291.47
13,699,668.60 (9,452,997.60)
22,850.00
(2,400,010.00)
13,699,668.60 (11.830,157.60)
21,916,166.03
8.757,727.17
17,869.13
(931,640.50)
7,843,955.80
12,729.877.47
7.088,251.30
7.088,251.30
9,186,288.56
1.669,475.87
17,869.13
(931,640.50)
755,704.50
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 03/31/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 CtP 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
82,850.00
194.000.00
89,475.00
100,676.00
2,367,881.00
137,780.00
1,026,394.00
763,302.00
5,000.00
4,767,358.00
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
47,592.36 35,257.64
166.994.08 27,005.92
77,272.86 12,202.14
87,213.13 13,462.87
934,753.05 1.433.127.95
128,820.00 8,960.00
64,286.02 962,107.98
457,431.56 305,870.44
5,259.25 (259.25)
1,969,622.31 2,797,735.69
78 715.14
192 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
45,875.19
143.256.80
61,256,89
24,019.31
479,384.94
75,388.00
27.554.07
432,223.75
31,609.31
1,320,568.26
32,839.95
49.405.22
52,114.07
79,753.39
679,148.90
102~516.00
60,125.60
300.985.24
8,992.00
1,365,880.37
60,216.83 150.623.17 88.258.42 50,320.60 37,937.82
48,215.75 93,429.25 121,790.46 77,043.65 44,746.81
131,419.58 (42,294.58) 79,100.67 40,698.75 38,401.92
239,852.16 201,757.84. 289,149:55 168,063.00 121,086.55
126,931.31 532.964.69 533,583.10 64,258.88 469.324.22
126,931.31 532,964.69' 533,583.10 64,258.88 469,324.22
660,601.51 508,933.49 866,219.67 437.074.29 429.145.38
3,750.00 3,750.00
6,202.30 3,797.70
670,553.81 516,481.19 866,219.67 437.074.29 429,145.38
6,000.00
6,000.00
6,000.00
6,000.00
6,000.00
6,000.00
13,997.81 13,997.81
36,202.98 248,801.02 59,617.41 7.141.62 52,475.79
8,820.00 20,517.41 3,577.66 16,939.75
514,179.74 2,181,109.26 429,360.36 16,702.26 412,658.10
550,382.72 2.438,730.28 523,492.99 27,421.54 496,071.45
1,587,720.00 3,695,934.00 2,218,445.31 696,817.71 1,521,627.60
(381.902.31) 898,198.31 (468.003.32) (623,750.55) 155,747.23
17,869.13
22,850.00
17,869.13
539,146.00 (381,902.31) 921,048.31 (450,134.19) (623,750.55) 173.616.36
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 03/31/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 220,822.96 169,565.04 318,354.40 169,025.72 149,328.68
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 234,078.68 175,898.32 335,660.27 173,492.49 162.167.78
*******EXPENDITURES*******
PUBLIC SAFETY:
TRAFFIC SIGNALS & STREET LIG
ACTIVITY TOTAL
TRANSPORTATION PUBLIC WORKS
STREET TREE MAINTENANCE
STREET LANDSCAPE MAINTENANCE
ACTIVITY TOTAL
HEALTH & WELFARE:
ENGINEERING
ACTIVITY TOTAL
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS
STREET CONSTRUCTION/IMPRVMNT
ACTIVITY TOTAL
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
EXCESS <REVENUE>EXPENDITURE
172,115.00 66,240.83 105,874.17 118.667.18
172,115.00 66,240.83 105,874.17 118,667.18
4,480.00 1,706.73 2,773.27 3,613.20
12,039.00 2,495.99 9,543.01 4,219.57
239,352.00 86.976.16 152,375.84 131,200.04
255,871.00 91,178.88 164,692.12 139.032.81
4,760.00 4,300.08 459.92 4,495.98
4,760.00 4,300.08 · 459.92 4,495.98
52,840.00 2.613.44 50,226.56 28,139.83
46,752.16
52,840.00 2,613.44 50.226.56 74,891.99
68,836.68
68,836.68
2,125.10
2.115.04
81,912.44
86,152.58
4,336.86
4,336.86
1.215.46
1,215.46
49,830.50
49,830.50
1.488.10
2.104.53
49.287.60
52,880.23
159.12
159.12
28,139.83
45,536.70
73,676.53
75,609.00 (69,745.45) 145,354.45 1,427.69 (12,950.91) 14,378.60
485,586.00 164,333.23 321,252.77 337,087.96 160,541.58 176,546.38
75,609.00 (69.745.45) 145,354.45 1,427.69 (12.950.91) 14,378.60
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 03/31/2001
CAPITAL IMPROVEMENT' FUND
CURRENT
BUDGET
CURRENT
ACTUAL
PRIOR PRIOR
VARIANCE FISCAL YEAR 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
789,214.44)
19,061,493.75
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*******
GENERAL GOVERNMENT ACTIVITIES:
ACTIVITY TOTAL
PUBLIC SAFETY:
TP~ANSPORTATION:
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
EXCESS <REVENUE>EXPENDITURE
37,834.00
37.834.00
1,747.473.75
1,412,999.00
20,483,791.00
23.644.263.75
23.682,097.75
4,620,604.00
4,620,604.00
24,820.65
24,820.65
629,295.06
11,262.11
6.032,014.43
6,672.571.60
6,697,392.25
5,908,177.81
5,908.177.81
13,013.35
13,013.35
1,118,178.69
1,401,736.89
14,451,776.57
16.971,692.15
16,984,705.50
(1,287,573.81)
(1,287,573.81)
12,389.68
12,389.68
1,859,640.67
6.057,184.37
2.433,845.51
10,350,670.55
10,363,060.23
25.910.99
25.910.99
946.64
946.64
1,013,143.79
5,531,139.47
1,339,472.12
7,883.755.38
7,884.702.02
7,687,928.35
7,687,928.35
11,443.04
11,443.04
846,496,88
526,044.90
1,094,373.39
2,466,915.17
2,478,358.21
(7,662,017.36)
(7,662,017.36)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 03/31/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
125,910.80 (125,910.80) 233,189.54 123,796.42 109,393.12
5,939.51 (5.939.51) 13,281.66 5.575.23 7,706.43
131,850.31 (131,850.31) 246,471.20 129,371.65 117,099.55
*******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,035.86 (232,035.86) 261.375.75 260,375.75
232,035.86 (232.035.86) 261,375.75 260,375.75
1,000.00
1,000.00
100,185.55 (100,185.55) 14,904.55 131,004.10 (116,099.55)
232,035.86 (232,035.86) 261.375.75 260,375.75 1,000.00
100,185.55 (100.185.55) 14,904.55 131,004.10 (116,099.55)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 03/31/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 690,544.75 228,953.25 580,974.63 435,504.40 145,470.23
17.000.00 17,000.00 42.214.73 28,607.44 13,607.29
1,124,170.00 787,209.55 386,960.45 688,513.53 478,277.08 210.236.45
*******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 273.952.44 745,785.56 865,319.44 187,463.63 677,855.81
1,019,738.00 273,952.44 745,785.56 865,319.44 187,463.63 677,855.81
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
EXCESS <REVENUE>EXPENDITURE
1,048,563.00 294,529.18 754,033.82
(75.607.00) (492.680.37) 417,073.37
(2,475.607.00)
(492.680.37) (1,982,926.63)
865,319.44
176,805.91
931,286.00
(754.480.09)
193,053.63
(285,223.45)
(285,223.45)
672,265.81
462,029.36
931.286.00
(469.256.64)
CURRENT
BUDGET
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2000 THROUGH 03/31/2001
EN ERPRISE
'FUND
CURRENT
ACTUAL
VARIANCE
PRIOR
FISCAL YEAR
PRIOR
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:
C. APITAL 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
· (i0.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
(354.50)
(354.50)