HomeMy WebLinkAbout4.02 April Fin Report CITY CLERK
File # 0330-50
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: (May 16, 2000)
SUBJECT:"
', Preliminary Financial Report For the Month of April 2000
~4~ Report Prepared by: Fred Marsh, Finance Manager
EXHIBITS ATTACHED:
Pro Forma Balance Sheet and Income Statements for
the Month of April 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 April.
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 2000 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, 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 ahead of What occurred in the ten months of the
previous Fiscal Year. The City had collected through April 2000 approximately 86% of the total
budgeted General Fund Revenues compared to approximately 81% in the prior Fiscal Year.
Property Tax is higher than in the same period in the prior year as the City's assessed valuation was higher
than what was anticipated in the budget due to residential and commercial growth occurring in Eastern
Dublin as well as a higher than expected increase in property values throughout the City. 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.
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, Gas and Electric franchise taxes and Garbage franchise taxes through the month ended
March 2000. As the subscription to these services increase the total revenue also increases. Similar
trends are also reflected in the issuance of building permits. Through the month of April permits issued
represented improvements valued in excess of $227 million.
COPIES TO:
G:\MONTHFS\042000 agenda statement month financiais.doc
ITEM NO.
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 ten 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 fi.om 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 as reimbursement from PG&E for the
undergrounding of utilities on Dublin Blvd from Village Parkway to Sierra Court is not expected to be
received until Fiscal Year 2000-2001.
General Fund Expenditures
Overall, through the month of April expenditures in the General Fund totaled $13,571,113 and
represented approximately 55% of the total budgeted expenditures in the General Fund. Of this amount, a
total of $1,434,450 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 April 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 April 2000, the City had expended 58% of the General Fund Operating Budget compared
to 71% 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 Government is lower than in the same
period in the prior year due to staffing vacancies in the Finance Department. 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 Civic Center Design Modification and Roof
Replacement Projects, the Heritage Center Storage Building 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 April 30, 2000 - Unaudited
Total General Fund
Revenues
Property Taxes
Sales Taxes
Transient
Occupancy Taxes
Franchise Taxes
Licenses and
Permits
Interest and Rentals
Intergovernmental
from State
Charges for Services
Other Revenues
;%
94%
;6%
99%
92%
16%
· FY 1999/2000
[] FY 1998/1999
O%
30%
60% 90%
83% of Year Complete
120%
150%
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
FY 1999/2000
Budget
5,643,60O
9,200,000
580,000
872,400
3,041,520
1,223,214
1,439,880
4,142,844
1,454,515
27,597,973
FY 1999/2000 %of
YTD Actual Budget
5,700,157 101%
8,092,420 88%
491,435 85%
820,842 94%
3,016,233 99%
1,421,637 116%
1,326,600 92%
2,051,065 50%
703,279 48%
23,623,669 86%
FY 98199
YTD Actual
4,613,516
6,4O8,796
253,623
733,475
1,795,830
1,355,257
1,088,983
2,400,120
281,798
18,931,398
% of Total for
FY 98/99
90%
74%
65%
86%
73%
100%
80%
69%
90%
81%
City of Dublin 1999-2000 YTD Expenses and Budget Comparison
For the Period Ending April 30, 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% 100% 120%
83% of Year Complete
· FY 1999/2000
[] FY 1998/1999
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 199912000 % of FY 98/99
Budget YTD Actual Budget YTD Actual
2,573,322 1,666,158 65% 1,608,183
1,614,407
4,992,259 2,631,143 53% 2,272,868
4,209,712 2,161,813 51% 3,324,873
208,427 112,619 54% 96,306
827,008 560,767 68% 458,399
19,360 6,431 33% 8,375
3,061,223 2,022,981 66% 1,625,372
5,188,683 2,974,753 57% 2,663,039
3,530,957 1,434,450 41% 1,076,326
24,610,951 13,571,113 55% 14,748,148
21,079,994 12,136,663 58% 13,671,822
% of Total for
FY 98199
75%
100%
50%
81%
50%
59%
49%
72%
74%
60%
70%
71%
ATTACHMENT 2
Dale Printed: 0,~05/2000 10:34 AM
CITY OF DUBLIN'S
FINANCIAL STATEMENTS
FOR
THE MONTH OF APRIL 2000
Prepared by
The Finance Department
May 4, 2000
ATTACHMENT 3
GENERAL
REVENUE
FUNDS
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 30Apr2000
SPECIAL SPECIAL CAPITAL TRUST/
REVENUE ASSESSMENT IMPROVEMENT AGENCY
FUNDS FUNDS FUND FUND
T 0 T A L S
---MEMORANDUM ONLY---
CURRENT PRIOR
ASSETS
CASH
CASH WITH FISCAL AGENT
AMOUNT HELD IN ESCROW
(18.410.647)
INVESTMENTS AT COST
RECEIVABLES: TAXES
ACCOUNTS (NE
INTEREST
ASSESSMENTS
47.121.002
149.497
205.076
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS
FIXED ASSETS
AMOUNT TO BE PROVIDED
TOTAL ASSETS
5.849
9.262
29.080.039
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
(739.266)
(26,277)
(634.483)
(158.885)
(209,297)
(41.850)
(149.497)
(1.959,555)
(27,120.484)
TOTAL FUND E (27,120,484)
2.426,027
311
667
2,427,005
(2.427.005)
(2.427.005)
420.448 14.719,515 134,360 (710.297)
154,569 154,569
4,267.787 4.267.787
420.448 18.987,302
(26.689.072)
(114.165)
(5.849)
(26,809.086)
(420,448) 7,821.783
(420.448) 7,821,783
47,121.002
149.808
205.076
1.860.500
2.149,429
6,516
9,262
1.860.500
53.064.223
(739.266)
(26,715,349)
(634.483)
(273.050)
(209.297)
(41,850)
(155.346)
(1,978.000) (1,978.000)
(1,978.000) (30,746,641)
(171.429) (22,317,582)
(171,429) (22.317.582)
(8.211.129)
149.763
34,556.969
1.399,589
502,727
212.897
7.027
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 (29.080,039) (2.427,005) (420.448) (18,987,302) (2.149.429) (53,064.223) (30.478,344)
INTERNAL
SERVICE
FUNDS
ENTERPRISE
FUNDS
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 30Apr2000
FIXED ASSETS
GROUP OF
ACCOUNTS
GENERAL LONG
TERM DEBT
ACCOUNT GROUP
TOTALS
---MEMORANDUM---
CURRENT PRI OR
ASSETS
CASH
CASH WITH FISCAL AGENT
AMOUNT HELD IN ESCROW
1,319,797
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,811.752
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
FUNDBALANCES (20,811,752)
TOTAL FUND E (20,811,752)
(355)
6,388,993
28,638,383
(355) 6,388,993 28,638,383
355 (6.388,993)
355 (6,388.993)
(28,638.383)
(28.638.383)
1,319.443 1,023.507
25,880,948 25,880,948
28.638,383 29,519,398
55.838,774 56,423,853
(20,806)
(28,638,383) (29,519,398)
(28,638,383) (29,540,205)
(27.200.391) (26,883,649)
(27.200,391) (26,883.649)
TOTAL LIAB. FND ~AL. RETD (20.811,752) 355 (6,388,993) (28,638,383) (55,838,774) (56,423,853)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/1999 THROUGH 04/30/2000
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
5,346,600.00 5,413,204.84 (66,604.84) 4,866,093.29 4,429,935.26 436,158.03
9,200,000.00 8,092,420.27 1,107,579.73 8,687,090.90 6,408,796.41 2,278,294.49
297,000.00 286,951.91 10,048.09 282,732.72 183,581.04 99,151.68
580,000.00 491,434.62 88,565.38 389,663.83 253,622.50 136,041.33
872,400.00 820,841.84 51,558.16 849,959.28 733,475.28 116,484.00
3,041,520.00 3,016,233.11 25,286.89 2,472,217.26 1,795,829.76 676,387.50
57,200.00 62,909.73 (5,709.73) 60,875.88 50,645.67 10,230.21
1,128,154.00 1,361,053.67 (232,899.67) 1,262,400.02 1,300,155.69 (37,755.67)
95,060.00 60,583.59 34,476.4t 90,539.48 55,101.31 35,438.17
1,437,181.15 1,326,600.4t 110,580.74 1,356,234.32 1,088,982.88 267,251.44
2,699.00 2,699.00
4,142,844.00 2,051,065.14 2,091,778.86 3,482,982.60 2,400,1t9.58 1,082,863.02
1,397,315.50 640,369,50 756,946.00 250,889.12 231,152.64 19,736.48
27,597,973.65 23,623,668.63 3,974,305.02 24,051,678:70 18,931,398.02 5,120,280.68
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
CITY COUNCIL 152,305.00 121,240,76 31,064.24 145,936.01 114,244.16 31,691.85
CITY MANAGER 376,735.00 284,915.82 91,819.18 331,437.26 266,261.07 65,176.19
CENTRAL SERVICES 222,712.00 154,843.44 67.868.56
CITY ATTORNEY 300,140.00 202,337.62 97,802.38 310,557.97 209,190.07 101,367.90
ADMIN SERVICES 793,174.00 460,906.58 332,267.42 687,654.23 523,994.39 163,659.84
BUILDING MANAGEMENT 550,831.00 323,863.58 226,967.42 531,817.85 402.406.32 129,411.53
FACILITY RENTAL 114.00 (114.00) 1,614,407.09 1,614,407.09
INSURANCE COST CENTER 152,185.00 117,026.38 35,158.62 125,621.86 85,779.10 39,842.76
ELECTIONS COST CENTER 940.00 831.77 108.23 6,335.24 6,308.27 26.97
NON-DEPARTMENTAL 24,300.00 77.83 24,222.17 377.71 377.71
ACTIVITY TOTAL 2,573,322.00 1,666,157.78 907,164.22 3,754,145.22 3,222,590.47 531,554.75
PUBLIC SAFETY
POLICE 4,992,259.00 2,631,142.79 2,361,116.21 4,505,598.49 2,272,867.72 2,232,730.77
CROSSING GUARDS 54,760.00 30,961.59 23,798.41 51,696.91 36,455.41 15,241.50
ANIMAL CONTROL 118,735.00 51,131.97 67,603.03 104,136.76 31,530.50 72,606.26
DISASTER PREPAREDNESS 34,932.00 30,525.34 4,406.66 35,021.96 28,320.51 6,701.45
FIRE SERVICES 4,209,712.00 2,161,812.60 2,047,899.40 4,109,003.33 3,324,872.87 784,130.46
ACTIVITY TOTAL 9,410,398.00 4,905.574.29 4,504,823.71 8,805,457.45 5,694,047.01 3,1tl,410.44
TRANSPORTATION
PUBLIC WORKS 411,653.00 311,681.45 99,971.55 389,594.78 297,921.26 91,673.52
STREET MAINTENANCE 500.00 26.10 473.90 112,085.18 114.30 111,970.88
STREET SWEEPING 98,580.00 58,109.63 40,470.37
STREET TREE MAINTENANCE 46,320.00 21,842.57 24,477.43 49,394.83 23,776.10 25,618.73
STREET LANDSCAPING MAINTENAN 269,955.00 169,106.91 100,848.09 225,854.52 136,587.61 89,266.91
ACTIVITY TOTAL 827,008.00 560,766.66 266,24t.34 776,929.31 458,399.27 318,530.04
HEALTH & WELFARE
THE CITY OF DUBLIN STATEMENT sHoWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/1999 THROUGH 04/30/2000
GENERAL REVENUE FUND
CURRENT CURRENT
BUDGET ACTUAL VARIANCE
PRIOR PRIOR
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
GENERAL 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
7,360.00 2.173.70 5,186.30
12.000.00 4,256.94 7,743.06
19.360.00 6,420.64 12,929.36
342.994.00 248,561.25 94,432.75
55.285.00 22,679.39 32.605.61
55,074.00 42.292.87 12,781.13
22.397.00 18,259.24 4,137.76
757.818.00 360,304.32 397.513.68
71,886.00 60,317.23 11,568.77
280.456.00 215,387.09 65,068.91
145,318.00 109,865.22 35,452.78
201,388.00 140,264.47 61.123.53
48,586.00 37.233.45 11,352.55
83,291.00 50.889.50 32.501.50
75,330.00 38,737106 36,592.94
62.015.00 59,900.65 2.114.35
37.360.00 12,307.76 25,052.24
240,908.00 205,354.52 35.553.48
1t9.730.50 87,567.57 32.162.93
114,863.00 78.856.81 36.006.19
256.508.00 167.564.67 88.943.33
89,915.00 66.638.05 23,276.95
3.061,222.50 2.022,981.12 1.038,241.38
1.221,854.00 926.104.32 295.749.68
1,105.134.00 768.318.53 336,815.47
2,549,357.00 1,001.529.02 1,547.827.98
312,338.00 278,800.63 33,537.37
5,188,683.00 2,974,752.50 2,213,930.50
1,556,662.00 887,611.93 669,050.07
309,056.00 168,743.87 140,312.13
906,890.00 309,429.63 597,460.37
758,349.00 68.664.63 689.684.37
3,530.957.00 1.434,450.06 2.096.506.94
24,610,950.50
2,987,023.15
13.571,113.05
10,052,555.58
4,968.90 726.50 4,242.40
12.000.00 7,648.26 4,351.74
16.968.90 8,374.76 8.594.14
255,689.00 182,326.75 73,362.25
20.000.00 20,000.00
43,003.52 34.041.44 8.962.08
15.010.17 10,217.26 4,792.91
532,104.94 328,112.39 204,992.55
58,046.52 51.908.52 6,138.00
264,38t.74 21t,538.08 52,842.66
137,577.04 103,868.09 33,708.95
164,547.25 117,588.63 46.958.62
49,314.09 39.997.62 9,316.46
44,993.27 34.836.57 10,156.70
60,291.18 40.573.26 19.717.92
63.730.01 48.627.84 15,102.t7
105,169.65 79,222.84 25,946.81
99,728.89 75.877.09 23.851.80
115.191.14 92,142.47 23,048.67
218,80t.72 154,493.16 64,308.57
2.248,580.14 1,625.372.02 623,208.12
1.010,015.03 746,055.79 263.959.24
795,024.52 589,089.22 205.935.31
1.685.599.49 1,216.724.42 468.875.07
115,762.34 111,169.21 4.593.13
3.606.401.39 2,663,038.64 943,362.75
252,012.63 171.515.49 80,497.14
63,272.48 tl,340.64 51,931.84
1,110,303.64 652,566.16 457.737.48
353,570.03 240.903.50 112.666.53
1,779,158.78 1.076,325.79 702,832.99
11,029.837.45 20.987,641.19 14.748.147.96 6.239,493.23
(7.065.532.43) 3,064.037.51 4.183.250.06 (1,119.212.55)
39,874.17 39.874.17
(t2,219,722.58)(12,134,212.45) (85,510.13)
REVENUES OVER(UNDER) EXPENDITURES 2,987,023.15 10,052.555.58 (7.065,532.43) (9,115,810.90) (7,950,962.39) (1,164,848.51)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/1999 THROUGH 04/30/2000
SPECIAL REVENUE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
**********************
PROPERTY TAXES
SALES TAX/OTHER TAXES
FINES & FORFEITURES
USES/MONEY & PROPER-FY
INTERGOVERNMENTAL FROM STATE
INTERGOVERNMENTAL FROM COUNTY
INTERGOVERNMENTAL FROM FEDERAL
CHARGES FOR SERVICES
OTHER SOURCES OF REVENUE
TOTAL REVENUE
82,965.00 72,296.16 10,668.84 76,684.53 70,116.13 6,568.40
183,800.00 155,129.05 28,670.95 172,561.75 141,481.55 31,080.20
59,000.00 69.656.40 (10,656.40) 65,857.76 47,571.43 18,286.33
90,160.00 24,019.31 66,140.69 93,371.12 29,979.50 63,391.62
2,515,457.00 479,384.94 2,036,072.06 753,103.27 503,233.65 249,869.62
136,650.00 75,388.00 61,262.00 149,244.00 118,444.00 30,800.00
402,336.00 27,554.07 374,781.93 374,449.92 16,435.96 358,013.96
729,650.00 676,015.01 53,634.99 706,992.33 653,002.17 53,990.16
30,000.00 31,609.31 (1,609.31) 22,439.87 22,150.01 289.86
4,230,018.00 1.611,052.25 2,618,965.75 2,414,704.55 1,602,414.40 812,290.15
**************************
PUBLIC SAFETY:
POLICE 93,034.00 50,635.92 42,398.08 78.444.67 40,916.57 37,528.10
TRAFFIC SIGNALS & STREET LTG 128,770.00 84,105.12 44,664.88 72,476.39 48,387.70 24.088~69
FIRE SERVICES 88,143.00 40,698]75 47,444.25 81,444.13 38,986.96 42,457.17
ACTIVITY TOTAL 309.947.00 175.439.79 134,507.21 232,365.19 128,291.23 104,073.96
TRANSPORTATION:
STREET MAINTENANCE 410,056.00 76.540.17 333,515.83 265,920.49 75,147.17 190,773.32
STREET SWEEPING 81,727.11 62,661.67 19.065.44
ACTIVITY TOTAL 410.056.00 76,540.17 333,515.83 347,647.60 137,808.84 209,838.76
HEALTH & WELFARE:
WASTE MANAGEMENT 870,570.00 437,085.67 433,484.33 827,685.54 406,234.85 421,450.69
SENIOR SUPPORT CARE 7,044.00 5,283.00 1,761.00
ACTIVITY TOTAL 870,570.00 437,085.67 433,484.33 834,729.54 411,517.85 423,211.69
COMMUNITY DEVELOPMENT:
ENGINEERING 6,000.00 6,000.00 44,166.79 6,049.79 38,117.00
ACTIVITY TOTAL 6,000.00 6,000.00 44,166.79 6,049.79 38,117.00
CAPITAL IMPROVEMENT PROJECTS:
GENERAL CIP PROJECTS 17,665.00 17.665.00
COMMUNITY PROJECTS 189,895.00 7.549.56 182,345.44 56,548.31 9.067.50 47,480.81
PARKS 21,119.00 3,577.66 17,541.34 51,300.97 39,854.05 11,446.92
STREET CONSTRUCTION/IMPROVEMENT 2,246,122.00 27,380.41 2,218,741.59 674,931.01 410,108.60 264,822.41
ACTIVITY TOTAL 2,474,801.00 38,507.63 2,436,293.37 782,780.29 459,030.15 223,750.14
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
4,071,374.00 727,573.26 3,343,800.74
(158,644.00) (883,478.99) 724.834.99
2,241,689.41
(173,015.14)
(130,265.91)
62,370.78
1,142,697.86
(459,716.54)
1,098,991.55
286,701.40
(130,265.91)
62,370.78
EXCESS <REVENUE> EXPENDITURE (158,644.00) (883,478.99) 724,834.99 (240,910.27) (459,716.54) 218.806.27
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/t999 THROUGH 04/20/2000
SPECIAL ASSESSMENT FUND
CURRENT
BUDGET
CURRENT PRIOR PRIOR
ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
********REVENUES********
SPECIAL BENEFITS ASSESSMENTS
USES/MONEY & PROP-INTEREST
OTHER SOURCES OF REVENUE
TOTAL REVENUE
309,093.00 281,554,49 27,538.51 253,175.40 225,494.50 27,680.90
15,027.00 3,797,92 11,229.08 16,381.44 4,691.75 11,689.69
2,500.00 668.85 1,821.15 2,736.05 2,736.05
326,620.00 286,021.26 40,598.74 272,292.89 232,922.30 39,370.59
*******EXPENDITURES*******
PUBLIC SAFETY:
TRAFFIC SIGNALS & STREET LIG 145,005.00 77,266.31 67,738.69 107,525.57 60,566,69 46,958.88
ACTIVITY TOTAL 145,005.00 77,266.31 67,738.69 107,525.57 60,566,69 46,958.88
TRANSPORTATION
PUBLIC WORKS 2,945.00 2,513.34 431.66 2,246.99 1,673.32 573.67
STREET TREE MAINTENANCE 13,210.00 2,115.04 11,094.96 7,694.38 3,755.71 3,928.67
STREET LANDSCAPE MAINTENANCE 160,990.00 86,661.22 74,328.78 105,652.77 67,290.53 38,362.24
ACTIVITY TOTAL 177,145.00 91,289.60 85,855.40 115,594.14 72,719.56 42,874.58
HEALTH & WELFARE:
ENGINEERING 4,200.00 4,236.86 (136.86) 3,084.88 2,957.04 127.84
ACTIVITY TOTAL 4,200.00 4,336.86 (136.86) 3,084.88 2,957.04 127.84
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS 27,972.00 27,972.00
STREET CONSTRUCTION/IMPRVMNT 82,600.00 t,485.20 81,114.80
ACTIVITY TOTAL 110,572.00 1,485.20 109,086.80
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
436,922.00 174,377.97' 262,544.03 226,204.59 136,243.29 89,961.30
110.302.00 (111,643.29) 221,945.29 (46,088.30) (96.679.01) 50,590.71
EXCESS <REVENUE>EXPENDITURE 110,302.00 (111,643.29) 221,945.29 (46,088.30) (96,679.01) 50,590.71
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/1999 THROUGH 04/30/2000
CAPITAL I MP.ROV EMENT
CURRENT CURRENT
BUDGET ACTUAL VARIANCE
FUND
?RIOR
FISCAL YEAR
PRIOR
Y.T.D.
VARIANCE
~***REVENUE********
USES/MONEY & PROP-INTEREST
OTHER SOURCES OF REVENUE
TOTAL REVENUE:
73.785.00
27,856.145.00
27.929,930.00
196,773.67 (122,988.67)
27.856,145.00
196,773.67 27,733,156.33
2,257,954.64
2.257,954.64
188,344.68
557,789.74
746.134.42
(188,344.68)
1,700.164.90
1.511,820.22
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
ACTIVITY TOTAL
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
RECREATION ADMINIST~TION
ACTIVITY TOTAL
COMMUNITY DEVELOPMENT
PLANNING
ACTIVITY TOTAL
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS
COMMUNITY IMPROVEMENTS
PARKS
STREET CONSTRUCTION/IMPROVEMENT
ACTIVITY TOTAL
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO,OTHER FUNDS
EXCESS <REVENUE>EXPENDITURE
61,886.00 1,108.43 60,777.57
61.886.00 1.108.43 60,777.57
16,915.01
16.915.01
145.14
145.14
14,7,37.06
14.727.06
145.14
145.14
2.177.95
2,177.95
2,206,938.00 1.229.263.92 977,668.08 124,753.27 100,737.79 24,015.48
9,443.800.00 5.686.291.34 3,757,508.66 1,180.149.86 340.311.38 839.838.48
t6.623.429.00 1.544.196.80 15,079.232.20 744.202.34 371,164.81 373,037.53
28.274.167.00 8,459,758.06 t9,814,408.94 2.049.105.47 812,213.98 1,236,891.49
28,336.053.00 8.460,866.49 19.875,186.51 2,066,165.62 827.096.18 1,239.069.44
406.123.00 8.264,092.82 (7.857,969.82) (191,789.02) 80.961.76 (272.750.78)
17,586.84 17.586.84
406.123.00 8,264,092.82 (7,857,969.82) (174,202.18) 80.961.76 (255.163.94
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/1999 THROUGH 04/20/2000
TRUST/AGENCY FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D.
VARIANCE
****--****************
SPECIAL ASSESSMENTS
USES/MONEY & PROP-INTEREST
TOTAL REVENUE
203,042.46 (203,042.46) 235,672.36 199,386.71 36,285.65
5,575.23 (5,575.23) 12,627.55 7,010.09 5,627.46
208.617.69 (208,617.69) 248,309.91 206,396.80 41,913.11
*******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
261,375.75 (261,375.75) 231,864.50 231,864.50
261,375.75 (261,375.75) 231,864.50 231,864.50
261,375.75 (261,375.75) 231,864.50 231,864.50
52,758.06 (52,758.06) (16,445.41) 25,467.70
52.758.06 (52,758.06) (16,445.41) 25,467.70
(41,913.11)
(41,913.11)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/1999 THROUGH 04/30/2000
INTERNAL SERVICE FUND
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
**********************
USES/MONEY & PROP-INTEREST
CHARGES FOR SERVICES
OTHER SOURCES OF REVENUE
TOTAL REVENUE
56,832.00 14,165.24 42,666.76 40,084.94 11,928.19 28,156.75
589,275.00 483,745.56 105,529.44 726,998.50 605,891.17 121,107.33
25,700.00 28,607.44 (2,907.44) 17,455.06 15,060.06 2.395.00
671,807.00 526,518.24 145,288.76 784,538.50 632,879.42 151,659.08
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES
NON-DEPARTMENTAL
ACTIVITY TOTAL
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
723,983.00 203,831.82 520,151.18 794,802.16 307,042.57 487,759.59
723,983.00 209,42t.82 514,561.18 794,802.16 307.04~.57 487,759.59
T 0 T A L EXPENDITURES
EXCESS <REVENUE>EXPENDITURE
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
723,983.00 209,421.82 514,561.18
52,176.00 (317,096.42) 369,272.42
794,802.16 307,042.57 487,759.59
10,263.66 (325,836.85) 336,100.51
13,582,460.94 13,582,460.94
EXCESS <REVENUE>EXPENDITURE 52,176.00 (317,096.42) 369,272.42 (12,572.197.28) (325,836.85)(13,246,360.43)
CURRENT
BUDGET
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/1999 THRUGH 04/30/2000
ENTERPRISE
FUND
CURRENT PRIOR PRIOR
ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
***********************
USES/MONEY & PROP-INTEREST
TOTAL REVENUE
1,671,632.89 1,718,528.89 (46,896.00)
1,671,632.89 1,718,528.89 (46,896.00)
********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 935,724.30
344.50 (344.50) 500.00
354.50 (344.50) 936,224.30
354.50
354.50
15,234,638.82 (14,298,914.52)
500.00
15,234,638.82 (14,298,414.52)
(344.50) 936,224.30 15,234,638.82 (14,298,414.52)
(344.50) (735,408.59) 13,516.109.93 (14,251,518.52)
(12,134,212.45)(12,134,212.45)
13,587,133.27 13,587,133.27
EXCESS <REVENUE>EXPENDITURE 10.00 354.50 (344.50) 717,512.23 1,381,897.48 (664,385.25)