HomeMy WebLinkAboutItem 4.09 FinancialReportsAug04
CITY CLERK
File # Dßl[3][Œ-ø[Q]
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: September 21, 2004
SUBJECT:
Financial Reports for the Month of August 2004
Report Prepared by: Fred W Marsh, Finance Manager and
Lisa Hisatomi, Administrative Analyst II
ATTACHMENTS:
1.
2.
3.
YTD Revenues and Budget Comparison
YTD Expenses and Budget Comparison
Financial Statements for the Months of August 2004
RECOMMENDATION:~
FINANCIAL STATEMENT:
Receive the reports.
See reports for detail of monthly financial activity.
DESCRIPTION:
This item provides the report on the preliminary financial statements for the month of August. The final
audited results for Fiscal Year 2003-2004 are not yet available; therefore, this report is presented as
"preliminary" at this time. Since the purpose of this report is to present the City's monthly financial
status, it will focus on providing the August financial comparison and will not delve into the State Budget
implications. A subsequent staff report will be presented to Council this evening, to provide a detailed
update on the State's Fiscal Year 2004-2005 Budget and its potential impacts on the City.
Analvsis of AU2ust 2004 Revenue and Expenditure Report
Consistent with prior monthly reports the focus will be on General Fund Revenues and Expenditures,
which represent the most significant portion of the City's operations.
In November 2004, the auditors will start the final phase of the fieldwork necessary for the Fiscal Year
2003-2004 audit. The final audit results will impact the reported Fund Balance presented in the attached
monthly reports.
Given August is only the second month of the Fiscal Year, there is extremely limited data on which to
base any major projections or identify significant trends. It should also be noted that there is not an even
distribution of revenues and expenditures on a monthly basis. There is also a lag with the reporting of
expenditures due to the significant amount of services provided to the City by independent contractors,
induding Police and Fire Services.
-------------------------------------------------------------------------------------------------------------
COPIES TO:
Document in FSCOLOR 08-2004.XLS
\ûòót
ITEM NO.
4.~
General Fund Revenues
Total General Fund Revenues collected through August are comparable to what occurred in the second
month of the previous Fiscal Year. Through August 2004, the City had collected approximately 12% of
the total budgeted General Fund Revenues, which was 2%) more than the percentage collected in the prior
Fiscal Year.
Real property transfer taxes are lower than in the same period of the prior year due to timing differences in
the collection of these taxes. Franchise Taxes are slightly higher than in the same period of the prior year
due to timing differences in the collection of Garbage Franchise taxes. Licenses and Permits are higher
than in the same period of the prior year due to an increase in the valuation of building permits on new
residential and commercial projects. Interest and Rentals are lower than prior year due to the timing
difference in the receipt of interest payments, a significant increase in the market value of investments in
the prior year and the closure of the Shannon Community Center. Initially all interest revenue is recorded
in the General Fund and is then allocated quarterly to other funds on a pro rata basis.
Intergovernmental revenue is higher than in the same period of the prior year due to the suspension of
Vehicle License Fee (VLF) backfill payments to the City for three months in the early part of Fiscal Year
2003-2004. Also, additional cuts to the VLF allocation, which were included as part of the adopted State
Budget for Fiscal Year 2004-2005, have not yet been implemented. These cuts, when the budget
reduction formulas are finalized by the Department of Motor Vehicles, will result in reduced VLF
payments to the City for the remainder of the current Fiscal Year.
Charges for Services are higher than in the same period of the previous year due to additional zoning and
subdivision fees and plan check and inspection fees received due to new development. Fines and
Forfeitures are higher than in the same period of the previous year due to timing differences in the
collection of parking and court fines. Other revenues are higher than in the same period of the prior year
due to developer reimbursements received for the costs of maintaining new storm drains and
reimbursements received from City of Pleasanton for the design of improvements to the Fallon Road
Interchange.
General Fund Expenditures
Overall, through the month of August, expenditures in the General Fund totaled $2.6 million and
represented approximately 6% of the total budgeted expenditures in the General Fund. Of this amount, a
total of approximately $500,000 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 only at General Fund Operating Expenditures, the activity through August 2004 was similar to
the amounts expended for the same period in the prior Fiscal Year. Through the end of August 2004, the
City had expended 5% of the General Fund Operating Budget, which was similar to the amount expended
in the prior Fiscal Year. Health and Welfare expenditures are higher than in the same period of the prior
year due to expenditures incurred to date on consultant services related to the solid waste request for
proposal (RFP). Capital Improvement Project expenditures are higher than in the same period of the
previous year due to expenditures incurred on the construction of the new senior center. As previously
noted there are some timing differences with payment for contract services, which complicate
comparisons trom one year to the next.
All expenditures 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.
;;¿ ðbB..
City of Dublin 2004-2005 YTD Revenues and Budget Comparison
For the Period Ending August 31, 2004
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
. FY 2004/05
m FY 2003/04
50 Yo
0%
90%
150%
120%
30%
60%
17% of Year Complete
FY 2004/05 FY 2004/05 % of FY 2003/04 % of Total for
Budget YTD Actual Budget YTD Actual FY 2003/04
Property Taxes 13,661,980 0 0% 0 0%
Sales Taxes 13,613,216 2,126,100 16% 2,073,400 16%
Real Property Transfer Tax 520,000 0 0% 36,245 6%
Transient Occupancy Taxes 610,000 61,243 10% 55,841 8%
Franchise Taxes 1,536,000 125,652 8% 59,472 4%
Licenses and Permits 2,723,912 1,293,373 47% 540,000 17%
Interest and Rentals 1,538,090 26,143 2% 243,258 47%
Intergovernmental 449,100 225,672 50% 183,802 11%
Charges for Services 5,117,168 552,720 11% 420,348 9%
Fines and Forfeitures 112,900 12,929 11% 6,255 5%
Other Revenues 1,437,280 417,817 29% 13,725 5%
Total General Fund Revenues 41,319,646 4,841,649 12% 3,632,346 10%
1!4-'21-04 4,'1
Dale Printed: 919/2004 10:51 AM ATTACHMENT 1
d- 13
~~~..^~_'~n_~_
City of Dublin 2004-2005 YTD Expenses and Budget Comparison
For the Period Ending August 31, 2004
Fire
. FY 2004/05
m¡ FY 2003/04
Total General Fund
Expenses
General Government
Police
Other Public Safety
Transportation
Health and Welfare
Culture & Community
Services
Community
Development
Capital Improv.
Projects
0%
20%
40%
60%
80%
100%
120%
17% of Year Complete
_'~~'.M'~~~_~
2004/05 2004/05 %of FY 2003/04 % of Total for
Budget YTD Actual Budget YTD Actual FY 2003/04
General Government 4,964,972 589,136 12% 542,624 12%
Police 9,882,259 120,372 1% 174,765 2%
Fire 8,156,645 39,231 0% 57,758 1%
Other Public Safety 421,298 8,868 2% 7,575 2%
Transportation 1,690,651 83,055 5% 84,029 5%
Health and Welfare 78,125 15,660 20% 22,027 27%
Culture and Community Services 5,863,186 515,780 9% 541 ,844 11%
Community Development 7,807,374 719,669 9% 637,112 10%
Capital Improvement Projects 5,814,403 499,243 9% 90,895 2%
Total General Fund Expenses 44,678,913 2,591,014 6% 2,158,629 6%
General Fund Operating Expenses 38,864,510 2,091,771 5% 2,067,734 6%
Cat. Prtnl.d: 91912004 10:60 AM
ATTACHMENT 2
CITY OF DUBLIN'S
PRO FORMA FINANCIAL STATEMENTS
FOR
THE MONTH OF AUGUST 2004
Prepared by
The Finance Department
September 9, 2004
~Þblþ
ATTACHMENT 3
4'1J 13
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 31Aug2004
GENERAL SPECIAL SPECIAL CAPITAL TRUST/ TOT A L S
REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY ---MEMORANDUM ONLY---
FUNDS FUNDS FUNDS FUNDS FUND CURRENT PRIOR
ASSETS
CASH (50.141.462) 3.BB6.517 389.574 38.202.072 22.403 (7.640.897) (19.969.771)
CASH WITH FISCAL AGENT 172.779 172.779 172.312
AMOUNT HELD IN ESCROW
INVESTMENTS AT COST 99.862.341 99.862.341 91.072.833
RECEIVABLES: TAXES
ACCOUNTS 139.296 14.664 153.960 3.197.780
INTEREST 200.330
ASSESSMENTS
DUE FROM OTHERS 308.720 308.720 308.720
INVENTORY AT COST
PREPAID ITEMS 16.057 16.057 2.989
FIXED ASSETS
AMOUNT TO BE PROVIDED 1.447.500 1. 447.500 1.447.500
TOTAL ASSETS 50.184.953 3.901.181 389.574 38.202.072 1. 642 . 682 94.320.461 76.432.693
LIABILITIES/FUND EQUITY
DEPOSITS FOR PRIVATE DEVEL 0.028.201) 0.028.201) (965.342)
DEPOSITS FOR AB1600 FEES (72 .127) (72.127) (576.753)
DEPOSITS OTHERS (2.208.500) (2.208.500) (998.213)
PAY ABLES: ACCOUNTS (483.001) (44.656) (5.371) (356.669) (889.697) (5.220.301)
INTEREST
PAYROLL (524.984) (524.984) (519.932)
DUE TO OTHERS 037.101) (308.720 ) (445. B21) (312.407)
DEFERRED REVENUE 027.768) 027.768) 027.768)
DEBT INSTRUMENTS PAYABLE 0.565.000) 0.565.000) 0.565.000 )
TOTAL LIABILITIES (4.581.683) (353.376) (5.371) (356.669) (1. 565.000) (6.862.099) (10.285.716)
FUND BALANCES (45.603.270) (3.547.804) (384.202) (37.845.403) (77.682) (87.458.361) (66.146.977)
TOTAL FUND E (45.603.270) (3.547.804) (384.202) (37.845.403) (77.6B2) (87.458.361) (66.146.977)
TOTAL LIABILITIES/EQUITY (50.184.953) (3.901.181 ) (389.574) (38.202.072) (1.642.682) (94.320.461) (76.432.693)
Si5b 13
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 31Aug2004
INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG TOT A L S
SERVICE FUND GROUP OF TERM DEBT ---MEMORANDUM---
FUNDS ACCOUNTS ACCOUNT GROUP CURRENT PRIOR
ASSETS
CASH 7.955.028 (20) 7.955.008 7.243.295
CASH WITH FISCAL AGENT
AMOUNT HELD IN ESCROW
INVESTMENTS AT COST
RECEIVABLES: TAXES
ACCOUNTS
INTEREST
ASSESSMENTS
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS
FIXED ASSETS 47.265.633 19.466.456 66.732.089 66.732.089
AMOUNT TO BE PROVIDED 68.580.288 68.580.288 68.752.907
TOTAL ASSETS 55.220.662 (20) 19.466.456 68.580.288 143.267.386 142.728.291
LIA8ILITIES/FUND EQUITY
DEPOSITS FOR PRIVATE DEVEL
DEPOSITS FOR AB1600 FEES
DEPOSITS OTHERS
PAY ABLES: ACCOUNTS (17.586)
INTEREST
PAYROLL
DUE TO OTHERS
DEFERRED REVENUE
DEBT INSTRUMENTS PAYABLE (68.580.288) (68.580.288) (68.752.907)
TOTAL LIABILITIES (68.580.288) (68.580.288) (68.770.492)
FUND BALANCES (55.220.662) 20 (19.466.456) (74.687.097) (73.957.798)
TOTAL FUND E (55.220.662) 20 (19.466.456) (74.687.097) (73.957.798)
TOTAL LIABILITIES/EQUITY (55.220.662) 20 (19.466.456) (68.580.288) (143.267.386)(142.728.291)
~l5bI~
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2004 THROUGH 08/31/2004
G ENE R A L REV E N U E FUN D
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
*******REVENUES*******
PROPERTY TAXES 13.661. 980.00 13.661. 980.00 11.849.537.58 11.849.537.58
SALES TAX 13.613.216.00 2.126.100.00 11.487.116.00 12.990.288.02 2.073.400.00 10.916.888.02
REAL PROPERTY TRANSFER TAX 520.000.00 520.000.00 571. 360.79 36.245.25 535.115.54
HOTEL TRANSIENT OCCUPANCY TAX 610.000.00 61. 243 .18 548.756.82 664.308.51 55.841. 23 608.467.28
FRANCHISE TAXES 1. 536.000.00 125.652.00 1.410,348.00 1.442.448.53 59,472.00 1. 382.976.53
LICENSES & PERMITS 2,723:912.00 1.293.373.46 1.430,538.54 3.086.872.17 540,00'0.07 2.546.872.10
FINES & FORFEITURES 112.900.00 12.929.34 99,970.66 118.219.48 6.254.95 111. 964.53
USE/MONEY & PROP-INTEREST 1.369.725.00 5.966.73 1,363,758.27 (197.867.74) 227,235.51 (425.103.25)
USE/MONEY & PROP-RENTALS 168.365.00 20.176.04 148,188.96 120.748.65 16.022.01 104.726.64
INTERGOVERNMENTAL 449.100.00 225.672.45 223.427.55 1.724.372,93 183.802.10 1.540.570.83
CHARGES FOR SERVICES 5.117.168.00 552.720.27 4.564.447.73 4,791.138.74 420.348.14 4.370.790.60
OTHER SOURCES OF REVENUE 1.437.280.00 417.817.01 1. 019 .462.99 262,523.01 13.724.90 248.798. 11
TOTAL REVENUE 41. 319,646.00 4.841.650.48 36.477 , 995.52 37.423.950.67 3.632.346.16 33.791. 604.51
*******EXPENOITURES*******
GENERAL GOVERNMENT ACTIVITIES:
CITY COUNCIL 252,910.00 22.808.31 230,101.69 209.858.23 24.529.44 185.328.79
CITY MANAGER 928.273.00 124.810.62 803.462.38 817.034.42 113,793.19 703.241. 23
CENTRAL SERVICES 350.911.00 39.780.24 311.130.76 341.914.49 39.682.16 302.232.33
CITY ATTORNEY 689.493.00 3.618.64 685.874.36 698.116.15 2.227.38 695.888.77
ADMIN SERVICES 1.557.095.00 193,311.78 1. 363 . 783 . 22 1. 244,537.07 186.108.19 1. 058,428.88
BUILDING MANAGEMENT 641,134.00 19.360.72 621. 773.28 758.249.44 43.154.89 715,094.55
INSURANCE COST CENTER 358,986.00 185.395.00 173.591. 00 420.061.97 133.103.90 286.958.07
ELECTIONS COST CENTER 15,670.00 50.55 15,619.45 2.541.41 24.70 2.516.71
NON-DEPARTMENTAL 170,500.00 170.500.00 125.656.16 125,656.16
ACTI V ITY TOTAL 4,964.972.00 589.135.86 4,375,836.14 4.617.969.34 542,623.85 4.075.345.49
PUBLIC SAFETY
POLI CE 9.882.259.00 120.372.37 9,761.886.63 8.570.781.93 174.764.64 8.396.017.29
CROSSING GUARDS 72.283.00 876.16 71 .406 . 84 65.794.14 65.794.14
ANIMAL CONTROL 266.362.00 266.362.00 161.819.52 161.819.52
TRAFFIC SIGNALS & STREET LIGHTIN 17.240.00 17.240.00 6.543.33 6,543.33
DISASTER PREPAREDNESS 65.413.00 7 ,991. 96 57.421. 04 70.993.74 7.575.36 63.418.38
FIRE SERVICES 8.156.645.00 39,230.54 8.117.414.46 7,435,268.60 57.758.05 7.377,510.55
ACTI V ITY TOTAL 18.460.202.00 168.471. 03 18,291. 730.97 16.311.201. 26 240.098.05 16.071.103.21
TRANSPORTATION
PUBLIC WORKS 738.575.00 83.030.76 655.544.24 686.881.45 84,005.66 602.875.79
STREET MAINTENANCE 14,802.00 14.802.00 3.703.99 3.703.99
STREET SWEEPING 149,207.00 149,207.00 127.807.29 127.807.29
STREET TREE MAINTENANCE 97.352.00 97.352.00 117,583.47 117,583.47
STREET LANDSCAPING MAINTENAN 690.715.00 24.25 690.690.75 593,488.01 23.38 593,464.63
ACTI V ITY TOTAL 1. 690.651. 00 83.055.01 1.607,595.99 1.529,464,21 84,029.04 1. 445 .435 , 17
HEALTH & WELFARE
WASTE MANAGEMENT 63,125.00 15,660.00 47.465.00 46.419.04 2,000.00 44.419.04
CHILD CARE 15.000.00 15.000.00 18,500.00 18.500,00
'71J13
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2004 THROUGH 08/31/2004
G ENE R A L REV E N U E FUN D
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
SOCIAL SERVICES 1. 000 . 00 1. 000.00
HOUSING PROGRAMS 16.893.18 527.18 16.366.00
ACTIVITY TOTAL 78.125.00 15.660.00 62.465.00 82.812.22 22.027.18 60.785.04
CULTURE & LEISURE SERVICES
LIBRARY SERVICES 582.730.00 1. 795.00 580.935.00 522 . 604 .10 3.624.24 518.979.86
CULTURAL ACTIVITIES 159.718.00 28.318.64 131. 399.36 110.249.30 47.654.63 62.594.67
HERITAGE CENTER 141.355.00 15.350.79 126.004.21 99.628.11 12.199.22 87 .428.89
DUBL! N CEMETERY 53.602.00 750.00 52.852.00 53.533.84 53.533.84
PARK MAINTENANCE 1. 532 .409.00 984.38 1. 531. 424.62 1.403.585.67 973.90 1.402.611.77
COMMUNITY TV 62.999.00 54.649.00 8.350.00 62.020.72 55.590.38 6.430.34
RECREATION ADMIN 638.564.00 85.062.94 553.501. 06 518.099.07 76.517.78 441. 581. 29
PLAYGROUNDS 277.082.00 50.712.41 226.369.59 237.599.33 48.739.55 188.859.78
SHANNON CENTER 389.176.00 33.785.79 355.390.21 295.601. 24 34.107.37 261. 493.87
PRESCHOOL 90.699.00 10.009.02 80.689.98 76.812.27 8.308.42 68.503.85
TEENS PROGRAM 118.941. 00 10.532.86 108.408.14 86.212.99 13.668.73 72.544.26
ADULT SPORTS 110.559.00 11.184.98 99.374.02 101.640.17 15.881. 66 85.758.51
YOUTH SPORTS 138.824.00 10.010.98 128.813.02 122.764.81 11.431. 29 111.333.52
COMMUNITY GYM 46.504.00 1.838.55 44.665.45 37 .309.40 1.568.14 35.741. 26
EMERALD GLEN ACTIVITY CENTER
SPECIAL EVENTS 339.220.00 25.574.31 313.645.69 348.052.22 29.865.87 318.186.35
SENIOR CENTER 297.455.00 25.955.87 271.499.13 223.784.61 28.633.64 195.150.97
RECREATION INSTRUCTION 195.220.00 26.478.55 168.741.45 185.369.65 35.910.65 149.459.00
AQUATICS 407.136.00 88.285.97 318.850.03 366.568.40 83.507.32 283.061.08
PARKS/FACILITIES MANAGEMENT 280.993.00 34.499.68 246.493.32 246.546.42 33.661.11 212.885.31
ACTIVITY TOTAL 5.863.186.00 515.779.72 5.347.406.28 5.097.982.32 541. 843.90 4.556.138.42
COMMUNITY DEVELOPMENT
PLANNING 2.731. 301. 00 239.895.82 2.491.405.18 2.271.403.13 231. 329.91 2.040.073.22
BUILDING SAFETY 2.580.214.00 161.771.13 2.418.442.87 1. 907 . 211. 35 131. 010.91 1. 776.200.44
ENGINEERING 2.209.633.00 216.377.59 1. 993.255.41 1. 861. 971. 85 190.142.37 1. 671. 829.48
ECONOMIC DEVELOPMENT 286.226.00 101. 624.59 184.601.41 302.134.33 84.628.98 217.505.35
ACTI V ITY TOTAL 7.807.374.00 719.669.13 7.087.704.87 6.342.720.66 637.112.17 5.705.608.49
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS 1. 020.815.00 65.754.24 955.060.76 925.776.70 13.298.06 912.478.64
COMMUNITY IMPROVEMENTS 799.839.00 5.373.20 794.465.80 712.096.11 5.713.03 706.383.08
PARKS 2.619.129.00 417.928.82 2.201. 200 .18 1. 829 .760.32 62.657.59 1. 767 .102.73
STREET CONSTRC/IMPROVEMENTS 1.374.620.00 10.186.99 1. 364 .433.01 564.404.95 9.226.37 555.178.58
ACTI V ITY TOTAL 5.814.403.00 499.243.25 5.315.159.75 4.032.038.08 90.895.05 3.941.143.03
TOTAL EXPENDITURES 44.678.913.00 2.591.014.00 42.087.899.00 38.014.188.09 2.158.629.24 35.855.558.85
EXCESS REVENUE (EXPENDITURES) (3.359.267.00) 2.250.636.48 (5.609.903.48) (590.237.42) 1.473.716.92 (2.063.954.34)
TRANSFERS IN FROM OTHER FUNDS 6.600.00 6.600.00
TRANSFERS OUT FROM OTHER FUNDS
REVENUES OVER(UNDER) EXPENDITURES (3.359.267.00) 2.250.636.48 (5.609.903.48) (583.637.42) 1.473.716.92 (2.057.354.34)
~DQ13
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2004 THROUGH 08/31/2004
S P E C I A L REV E N U E FUN 0 S
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
********REVENUES********
PROPERTY TAXES 111. 049.00 111.049.00 104.563.17 104.563.17
SALES TAX/OTHER TAXES 336.500.00 336.500.00 326.973.38 326.973.38
FINES & FORFEITURES 164.000.00 164.000.00 154.784.03 63.89 154.720.14
USES/MONEY & PROPERTY 89.248.00 89.248.00 42.536.97 42.536.97
INTERGOVERNMENTAL FROM STATE 1.188.010.00 138.494.96 1.049.515.04 2.410.150.15 78.930.04 2.331.220.11
INTERGOVERNMENTAL FROM COUNTY 306.890.00 306.890.00 233.366.00 233.366.00
INTERGOVERNMENTAL FROM FEDERAL 97 .718.00 97.718.00 68.144.37 68.144.37
CHARGES FOR SERVICES 1.056.723.00 1.056.723.00 975.965.68 975.965.68
OTHER SOURCES OF REVENUE 160.500.00 160.500.00 291.518.00 291. 518.00
TOTAL REVENUE' 3.510.638.00 138.494.96 3.372.143.04 4.608.001.75 78.993.93 4.529.007.82
*******EXPENDITURES*******
PUBLl C SAFETY:
POll CE 121.560.00 121.560.00 161. 642.54 161. 642.54
TRAFFIC SIGNALS & STREET LTG 217.596.00 2.815.52 214.780.48 143.451. 04 8 .422 . 88 135.028.16
DISASTER PREPAREDNESS 8.179.22 8.179.22
FIRE SERVICES 287.626.00 500.00 287.126.00 211.138.48 500.00 210.638.48
ACTIVITY TOTAL 626.782.00 3.315.52 623.466.48 524.411.28 8.922.88 515.488.40
TRANSPORTATION:
STREET MAINTENANCE 301.750.00 301.750.00 216.334.44 216.334.44
STREET SWEEPING
ACTIVITY TOTAL 301.750.00 301.750.00 216.334.44 216.334.44
HEALTH & WELFARE:
WASTE MANAGEMENT 1.346.244.00 5.421. 58 1. 340 . 822 . 42 1.248.019.76 500.00 1.247.519.76
SOCIAL SERVICES 44.927.00 44.927.00 44.935.00 44.935.00
HOUSING PROGRAMS
ACTI V ITY TOTAL 1. 391.171. 00 5.421. 58 1.385.749.42 1.292.954.76 500.00 1.292.454.76
COMMUNITY DEVELOPMENT:
ENGINEERING 6.000.00 6.000.00 6.000.00 6.000.00
ACTIVITY TOTAL 6.000.00 6.000.00 6.000.00 6.000.00
CAPITAL IMPROVEMENT PROJECTS:
GENERAL CIP PROJECTS
COMMUNITY PROJECTS 44.928.00 44.928.00 61. 293.75 61. 293.75
PARKS 321. 717.00 321.717.00 6.000.00 6.000.00
STREET CONSTRUCTION/IMPROVEMENT 667.210.00 8.143.34 659.066.66 1. 530 . 550 . 65 11.040.64 1.519.510.01
ACTI V ITY TOTAL 1. 033 . 855 . 00 8.143.34 1. 025 .711. 66 1. 597 . 844.40 11.040.64 1. 586.803.76
TOT A L EXPENDITURES 3.359.558.00 16.880.44 3.342.677.56 3.637.544.88 20.463.52 3.617.081.36
EXCESS REVENUE (EXPENDITURES) 151. 080.00 121. 614.52 29 .465 . 48 970.456.87 58.530.41 911.926.46
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS 6.600.00 6.600.00
REVENUES OVER (UNDER) EXPENDITURES 151.080.00 121. 614.52 29.465.48 963.856.87 58.530.41 905.326.46
t1Dblp
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2004 THROUGH 08/31/2004
S P E C I A L ASS E SSM E N T FUN D S
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
********REVENUES********
SPECIAL BENEFITS ASSESSMENTS 639.589.00 639.589.00 589.675.53 589.675.53
USES/MONEY & PROP-INTEREST 12.909.00 12.909.00 5.915.20 5.915.20
OTHER SOURCES OF REVENUE 5.000.00 5.000.00 144.29 144.29
TOTAL REVENUE 657.498.00 657.498.00 595.735.02 144.29 595.590.73
*******EXPENDITURES*******
PUBLIC SAFETY:
TRAFFIC SIGNALS & STREET LIG 306.088.00 14.289.89 291. 798.11 217.534.35 14.663.09 202.871. 26
ACTIVITY TOTAL 306.088.00 14.289.89 291. 798.11 217.534.35 14.663.09 202.871. 26
TRANSPORTATION
PUBLI C WORKS 1.436.00 222.53 1. 213.47 1. 352 .46 134.22 1.218.24
STREET TREE MAINTENANCE 27.099.00 476.00 26.623.00 26.752.22 26.752.22
STREET LANDSCAPE MAINTENANCE 344.474.00 3.326.98 341.147.02 296.360.83 3.742.06 292.618.77
ACTI V ITY TOTAL 373.009.00 4.025.51 368.983.49 324.465.51 3.876.28 320.589.23
COMMUNITY DEVELOPMENT
ENGINEERING 12.750.00 1.619.05 11.130.95 15.007.20 4.380.67 10.626.53
ACTI V ITY TOTAL 12.750.00 1.619.05 11.130.95 15.007.20 4.380.67 10.626.53
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS
STREET CONSTRUCTION/IMPRVMNT 53.878.94 53.878.94
ACTIVITY TOTAL 53.878.94 53.878.94
TOT A L EXPENDITURES 691. 847.00 19.934.45 671.912.55 610.886.00 22.920.04 587.965.96
EXCESS REVENUE (EXPENDITURES) (34.349.00) (19.934.45) (14.414.55) (15.150.98) (22.775.75) 7.624.77
REVENUES OVER (UNDER) EXPENDITURES (34.349.00) (19.934.45) (14.414.55) (15.150.98) (22.775.75) 7.624.77
lú~l~
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2004 THROUGH OB/31/2004
CAP I TAL IMP R 0 V E MEN T FUN 0 S
CURRENT
BUDGET
CURRENT
ACTUAL
VARIANCE
PRIOR
FISCAL YEAR
PRIOR
Y.T.D.
VARIANCE
********REVENUE********
USES/MONEY & PROP-INTEREST
OTHER SOURCES OF REVENUE
TOTAL REVENUE;
BI0.154.00
18.631. 900.00
19.442.054.00
810.154.00 480.573.82
7.205.067.62 11.426.832.38 13.455.275.26
7.205.067.62 12.236.986.38 13.935.849.08
480.573.82
13.455.275.26
13.935.849.08
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES;
CITY ATTORNEY 55.300.00 55.300.00 95.175.29 95.175.29
ACTI V ITY TOTAL 55.300.00 55.300.00 95.175.29 95.175.29
PUBLI C SAFETY;
TRANSPORTATION;
HEALTH & WELFARE;
HOUSING PROGRAMS 809.412.00 19.569.74 789.842.26 2.252.493.88 29.472.92 2.223.020.96
CULTURE & LEISURE SERVICES;
RECREATION ADMINISTRATION
ACTI V ITY TOTAL
COMMUNITY DEVELOPMENT
PLANNING
ACTIVITY TOTAL
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS 5.000.00 137.114.57 (132.114.57) 1.344.731. 36 442.002.58 902.728.78
COMMUNITY IMPROVEMENTS 36.771. 00 36.771. 00
PARKS 13.582.774.00 60.273.81 13.522.500.19 3.566.651.85 124.002.63 3.442.649.22
STREET CONSTRUCTION/IMPROVEMENT 18.694.364.00 28.782.72 18.665.581.28 6.499.154.56 33 .468 . 95 6.465.685.61
ACTI V ITY TOTAL 32.318.909.00 226.171.10 32.092.737.90 11.410.537.77 599.474.16 10.811.063.61
TOT A L EXPENDITURES 33.183.621.00 245.740.84 32.937.880.16 13.758.206.94 628.947.08 13.129.259.86
EXCESS REVENUE (EXPENDITURES) (13.741. 567.00) 6.959.326.78 (20.700.893.78) 177.642.14 (628.947.08) 806.589.22
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
REVENUES OVER (UNDER) EXPENDITURES(13.741.567.00) 6.959.326.78 (20.700.893.78) 177.642.14 (628.947.08) 806.589.22
, (rfbl?
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2004 THROUGH 08/31/2004
T R U S T / AGE N C Y FUN D
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.O. VARIANCE
********REVENUES********
SPECIAL ASSESSMENTS 233.713.12 233.713.12
USES/MONEY & PROP-INTEREST 1.718.61 1.718.61
TOTAL REVENUE 235.431.73 235.431.73
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON~DEPARTMENTAL 228.196.00 177.555.25 50.640.75 229.893.50 172.998.25 56.895.25
ACTIVITY TOTAL 228.196.00 177.555.25 50.640.75 229.893.50 172.998.25 56.895.25
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS
TOT A L EXPENDITURES 228.196.00 177.555.25 50.640.75 229.893.50 172.998.25 56.895.25
EXCESS REVENUE (EXPENDITURES) (228.196.00) (177.555.25) (50.640.75) 5.538.23 (172.998.25) 178.536.48
REVENUES OVER (UNDER) EXPENDITURES (228.196.00) (177 .555.25) (50.640.75) 5.538.23 (172.998.25) 178.536.48
~Vb\3
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2004 THROUGH 08/31/2004
I N T ERN A L S E R V ICE FUN D S
CURRENT
BUDGET
CURRENT
ACTUAL
VARIANCE
PRIOR
FISCAL YEAR
PRIOR
Y.T.D.
VARIANCE
********REVENUES********
USES/MONEY & PROP-INTEREST 226.186.00 226.186.00 102.560.75 102.560.75
CHARGES FOR SERVICES 1.733.474.00 140.777.51 1. 592.696.49 1. 690 .762.96 292.469.54 1. 398.293.42
OTHER SOURCES OF REVENUE 21.122.00 21.122.00 18.206.68 18.206.68
TOTAL REVENUE 1. 980 .782.00 140.777.51 1.840.004.49 1.811.530.39 292.469.54 1.519.060.85
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES
NON-DEPARTMENTAL 2.309.746.00 448.173.78 1. 861. 572.22 504.332.93 63.833.84 440.499.09
ACT! V ITY TOTAL 2.309.746.00 448.173.78 1.861.572.22 504.332.93 63.833.84 440.499.09
PUBLIC SAFETY:
FIRE 66.010.00 66.010.00 41. 846.25 41. 846.25
ACTI V ITY TOTAL 66.010.00 66.010.00 41. 846.25 41. 846.25
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
TOT A L EXPENDITURES 2.375.756.00 448.173.78 1. 927 . 582 . 22 546.179.18 63.833.84 482.345.34
EXCESS REVENUE (EXPENDITURES) (394.974.00) (307.396.27) (87.577.73) 1. 265.351. 21 228.635.70 1.036.715.51
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
REVENUES OVER (UNDER) EXPENDITURES (394.974.00) (307.396.27) (87.577 .73) 1.265.351.21 228.635.70 1. 036 .715.51
********REVENUES********
USES/MONEY & PROP-INTEREST
TOTAL REVENUE
********EXPENOITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL
FINANCE
ACT! V ITY TOTAL
PUBLIC SAFETY:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
TOT A L EXPENDITURES
EXCESS REVENUE (EXPENDITURES)
TRANSFERS IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
REVENUES OVER (UNDER) EXPENDITURES
CURRENT
BUDGET
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2004 THROUGH 08/31/2004
E N T E R P R I S E
FUN D
CURRENT
ACTUAL
VARIANCE
PRIOR
FISCAL YEAR
20.00
20.00
20.00
(20.00)
(20.00)
PRIOR
V.T.D.
13~\3
VARIANCE
20.00
20.00
20.00
(20.00)
(20.00)