HomeMy WebLinkAboutItem 4.14 FinancialRptsAug05
CITY CLERK
File # D~[3][Q]-[9Q]
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: September 20, 2005
SUBJECT:
Financial Reports for the Month of August 2005
Report Prepared by: Carole A. Perry, Administrative Services
Director and Fred W Marsh, Finance Manager
ATTACHMENTS:
1.
2.
3.
YTD Revenues and Budget Comparison
YTD Expenses and Budget Comparison
Financial Statements for August 2005
RECOMMENDA TION:~
FINANCIAL STATEMENT:
Rcccive the reports.
See reports for detail of monthly financial activity.
DESCRIPTION:
This item provides thc report on the preliminary financial statements for the month of August 2005.
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.
Analvsis of AUl!ust 2005 Reveuue and Expenditure Reports
The August reports represent the reporting of revemlCs and expenditures for the two months of the Fiscal
Year, through August 31, 2005. 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, including Police and Fire
Services.
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. Also, in October 2005, the auditors will start the
final phase of the fieldwork necessary for the Fiscal Year 2004-2005 audit. The final audit results will
impact the reported Fund Balance presented in the attached monthly reports.
General Fund Revenues
Total Gcneral Fund Revcnues collected through August are less than what occurred in the second month
of the previous Fiscal Year. Through August 2005, the City had collected approximately 9% of the total
budgeted General Fund Revcnucs, which was 2% less than the percentage col1ectcd in the prior Fiscal
Y car. A brief description is provided below to explain any material revenue variations.
The first quarter Sales Tax is lower when compared to the same period in the prior year since last year the
State delayed implementation ofthe Y. percent reduction to sales tax (related to the "Triple Flip") until the
second quarter (October 2004). The City will receive reimbursements for these deductions from the State
as part of the property tax receipts to be received later in the Fiscal Year. Real Property Transfer Tax is
higher than in the same period in the prior year due to timing differences in the receipt of thcsc funds.
Franchise Fecs arc lowcr than in the same period in the prior period due to timing differences in the
_________________________________________.___~_~~______________R_~~_______________________~M___________~_____
Document in FSCOLOR 08-200S.XLS
COPIES TO:
\001..
ITEMNO,~
receipt of Garbage Franchise Fees. Licenses and Pern1Îts are lower than in the same period of the prior
year due to a decrcase in the valuation of building permits on new residential and commercial projects.
Intercst and Rentals received to date are higher than thc prior year due to an increase in the rate ofreturn
on the City's investments. Initial1y al1 interest revenue is recorded in the General Fund and is then
al10cated quarterly to other funds on a pro rata basis.
Intergovernmental revenue is higher than in the prior year due to an early repayment by the State of the
Vehicle License Fee (VLF) Loan from Fiscal Year 2003-2004. At the time the Fiscal Year 2005-2006
City budget was approved, thcrc was no indication that the VLF loan would be repaid ahead of schedule;
therefore, no revenuc was budgeted for this event. However, with the adoption of the State Budget, cities
were advised that the VLF Gap Loan would be repaid early.
Other Revenues are lower than in thc same period of the prior year due to a one time payment received in
the prior year for ongoing maintenance of storm drains and timing differences in the receipt of
rcimbursements from the City of Pleasanton for the design of improvemcnts to the Fallon RoadJI-580
freeway interchange.
General Fund Exnenditures
Overall, through the month of August, expenditures in the General Fund totaled about $2.8 million and
represented approximately 6% of the total budgeted expenditures in the General Fund. Of this amount, a
total of approximately $540,000 was relatcd to Capital Improvement Projects and the remainder was
related to Operating Costs rcported 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 2005 was similar to
the amounts expended for the same period in the prior Fiscal Year. Through the end of August 2005, the
City had expended 5% of the General Fund Opcrating Budget, which was the same as the amount
expended in the prior Fiscal Year. Hcalth and Welfare expenditures, as a percentage of budget, are higher
than in the same pcriod of the previous year due to expenditures budgeted in the prcvious year for
consultant scrvices used in the negotiation of a new waste management contract for the City.
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.
2ðQL
\ \ \
...,.------...-...-.''''''...'''.---'''..
City of Dublin 2005-2006 YTD Revenues and Budget Comparison
. ....for the Perio_d Endin Au ust 31 2005
Sales Taxes
-'!
Total General Fund Revenues
Property Taxes
Real Propcrty Transfcr Tax
[;:~~~~~~~~ .
Transient Occupancy Taxes
Franchise Taxes
Licenses and Permits
Intcrest and Rentals
Intergovernmental from State
1260/.
40%
Charges for Services
Fines and Forfeitures
Other Revenues
64%
....."'·"···,·.··.·.______·4
0%
30%
60%
90%
120%
150%
17% of Year Complete
FY 2005/06 FY 2005/06 %of FY 2004105 % of Total for
Budget YTD Actual Budget YTD Actual FY 2004105
Property Taxes 15.716,461 0 0% 0 0%
Sales Taxes 14,984,884 1,741.900 12% 2,126,100 15%
Real Property Transfer Tax 745.600 76,264 10% 0 0%
Transient Occupaney Taxes 680,500 63,253 9% 61,243 9%
Franchise Taxes 1,626,300 4,387 0% 125,652 8%
Licenses and Permits 2.380.013 567,879 24% 1,293,373 37%
Interest and Rentals 1,898,725 105,304 6% 26,143 2%
Intergovernmental 498.650 628,012 126% 225,672 40%
Charges for Services 5,256,561 606,407 12% 552.720 10%
Fines and Forteltures 132,200 15.862 12% 12,929 9%
Other Revenues 1.591.243 129,914 8% 417,817 64%
Total General Fund Revenues 45,511,137 3,939,182 9% 4.841,649 11%
I-n: tv\ l\, 1'-\ C\ -"20 --(:)5'"
QIII.I-'r'nlEI,t:III:II::!0061t1.'i21w1 ATTACHMENT 1
..-..-.--.-
z"o
City of Dublin 2005-2006 YTD Expenses and Budget Comparison
For the Period Ending August 31, 2005
Fire
-
,
Total General Fund
Expenses
General Government
Police
Health and Welfare
100%
! íli FY 2005/06
1~~'{2004/05
I
,
I
,
i
Other Public Safety
Trausportation
Culture & Community
Services
Community
Development
Captml Improv.
Projects
0%
20%
40% 60% 80%
17% of Year Complete
100%
120%
- -----.-..-
2005/06 2005106 %of FY 2004105 % ofTotal for
Budget YTD Actual Budget YTD Actual FY 2004/05
General Government 5,526,335 657,472 12% 617,405 13%
Police 11,358,537 114,021 1% 161,212 2%
Fire 8,890,188 43.918 0% 58,007 1%
Other Public Safety 366.512 6.855 2% 9,194 3%
Transportation 1.824,115 82,711 5% 89.977 5%
Health and Welfare 15,000 15.000 100% 15,660 18%
Culture and Community Services 6,337.038 626.164 10% 535,660 10%
Community Development 8,433.682 716.523 8% 744.259 10%
Capital Improvement Projects 4,525,725 539,831 12% 499.731 11%
Total General Fund Expenses 47.277.132 2,802,495 6% 2,731.105 7%
General Fund Operating Expenses 42.751,407 2,262,664 5% 2,231.374 6%
[),u "'OlIN: fII9f..'OO5 10:~2 AM
ATTACHMENT 2
'3 Gò\ \
CITY OF DUBLIN'S
PRO FORMA FINANCIAL STATEMENTS
FOR
THE MONTH OF AUGUST 2005
Prepared by
The Finance Department
September 9, 2005
ATTACHMENT 3
L\ obI I
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 31Aug2005
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 (52.t76.4t5) 5.371. 092 580.278 38. t78.138 16.957 (8,029,950) (30,640,946)
CASH WITH FISCAL AGENT 175.727 175.727 172.779
AMOUNT HELD IN ESCROW
INVESTMENTS AT COST 103,482.493 103.482.493 99.862.341
RECEIVABLES; TAXES
ACCOUNTS 127.768 91.919 219.686 2.564,261
INTEREST 500.222 500.222 496,242
ASSESSMENTS
DUE FROM OTHERS 1. 829.213 1. 829.213 1. 829,213
INVENTORY AT COST
PREPAID ITEMS 11.350 11.350 11.743
FIXED ASSETS
LOANS RECEIVABLE 4.500.000 4,500,000
AMOUNT TO BE PROVIDED 1. 334,500 1. 334 , 500 1. 334,500
TOTAL ASSETS 53,774,630 5,463,011 580.27B 42,67B,13B 1. 527 .184 104.023.24t 75.630.133
LIABtLITIES!FUND EOUITY
DEPOSITS FOR PRIVATE DEVEL (1,Ot9.859) (1.0t9,B59) (1. 028.201)
DEPOSITS FOR AB1600 FEES (2B3,830) (415.131) (698,961) (72. t27)
DEPOSITS OTHERS (2,658.102) (2.658,102) (2.20B.500)
PAYABLES, ACCOUNTS (2,3B4,2B5) (763,444) (224.279) (3.372.008) (1.456.608)
INTEREST
PAYROLL (562.790 ) (562.790) (524.984)
DUE TO OTHERS (262,967) (1.829.213) (2.092.179) 037.101)
DEFERRED REVENUE 027.768) (127.76B) 027,76B)
DEBT INSTRUMENTS PAYABLE (1.452,000) (1.452.000) (1,452.000)
TOTAL LIABILITIES (7,299,600) (763.444 ) (2.468.623) (1.452,000) 01.983.667) (7.007.290)
FUNO BALANCES (46,47S.030) (4.699.567) (580.278) (40.209.515) (75,184) (92.039.574) (6B.622.843)
TOTAL FUND E (46,475.030) (4.699,567) (580,278) (40.209,515) (75.184) (92.039.574) (68.622.843)
TOTAL LIABILITIES/EQUITY (53.774.630) (5,463.0llJ (580.278) (42.678,138) (1,527,184)(t04.023,241) (75.630,133)
I;)òb\\
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 31Aug2005
INTERNAL ENTERPRI5E FIXED ASSETS GENERAL LONG TOT A L S
SERVICE FUND GROUP OF TERM DEBT .- ·MEMORANDUM---
FUNDS ACCOUNTS ACCOUNT GROUP CURRENT PRIOR
ASSETS
CASH 9.054.633 9,054,633 B,065,IB6
CASH WtTH FISCAL AGENT
AMOUNT HELD IN ESCROW
INVESTMENTS AT COST
RECEIVABLES, TAXES
ACCOUNTS
INTEREST
ASSESSMENTS
DUE FROM OTHERS
INVENTORY AT COST
PRE PAlO ITEMS
FIXED ASSETS 46.511,915 39.208.244 85.720.159 85.720.159
AMOUNT TO BE PROVIDED 66.753.945 66.753,945 66.753 , 945
TOTAL ASSETS 55.566.548 39.208.244 66.753.945 161. 528 .736 160,539,289
LIABILITIES/FUND EQUITY
DEPOSITS FOR PRIVATE DEVEL
DEPOSITS FOR AB1600 FEES
DEPOSITS OTHERS
PAY ABLES , ACCOUNTS (28.403)
INTEREST
PAYROLL
DUE TO OHIERS
DEFERRED REVENUE
DE8T INSTRUMENTS PAYABLE
TOTAL LIA8ILITIES (28.403)
FUND BALANCES (55.538.145)
TOTAL FUND E (55.538,145)
(28,403)
(l5,222)
(66.753.945)
(66,753,945)
(66.753.945) (66,753.945)
(66.782.348) (66.769.167)
(94.746.388) (93.770.122)
(94.746.388) (93.770.122)
(39,208.244)
(39.208.244)
TOTAL LIA8ILITIES/EOUITY (55,566,548)
(39.208.244) (66.753.945)
(t6t.528.736)(160.539.289)
THE CITY OF DUBLIN STATEMENT SHOWING Loùbl\
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2005 THROUGH 08/31/2005
G ENE R A L REV E N U E FUN 0
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
*******REVENUES*******
PROPERTY TAXES 15.716.461.00 15.716.461. DO 13.705.546.32 13,705.546.32
SALES TAX 14.984.884.00 1.741.900.00 13.242.984.00 13.793.899.88 2.126.100.00 11.667.799.88
REAL PROPERTY TRANSFER TAX 745.60000 76.263.85 669.336.15 831.003.24 831. 003.24
HOTEL TRANS tENT OCCUPANCY TAX 680.500.00 63.252.69 617.247.31 663.631. 67 61. 243 .18 602.388 49
FRANCHISE TAXES 1.626.300.00 4.386.73 1. 621.913.27 1.559.900.22 125.652.00 1.434.248.22
LICENSES & PERMITS 2.380.01300 567.878.70 1.812.134.30 3.520.140.84 1.293.373.46 2.226.76738
FINES & FORFEITURES 132.20000 t5. 862.44 116.337.56 141. 591. 33 12.929.34 128.661. 99
USE/MONEY & PROP-INTEREST 1.757.524.00 96.303.72 1. 661. 220.28 1. 521. 527 .78 5.966.73 1. 515.561. 05
USE/MONEY & PROP·RENTALS 141.201.00 8,999.96 132.201. 04 114,687.90 20.176.04 94.511.86
INTERGOVERNMENTAL 498.650.00 628.011.54 (129.361.54) 568.598.34 225.672 .45 342.925.89
CHARGES FOR SERVICES 5,256.561.00 606,407.09 4,650.153.91 5.554.949.94 552,720.27 5.002.229.67
OTHER SOURCES OF REVENUE 1. 591.243.00 129.913.52 1. 461. 329 48 652.t71.3t 417.8t7.0t 234.354.30
TOTAL REVENUE 45.511.137.00 3.939.180.24 41. 571. 956.76 42.627.648.77 4,841.650.48 37.785,998.29
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES,
CITY COUNCIL 280.704.00 29.649.94 251. 054.06 224.070.48 23.914.56 200.155.92
CITY MANAGER 997.923.00 121.341. 07 876.581. 93 915.792.63 129.809.98 785.982.65
CENTRAL SERVICES 538.556.00 47.415.83 491.140.17 356.248.43 41. 628.08 314.620.35
CITY ATTORNEY 824.252.00 3.838.85 820.413.t5 702.95864 4.126.97 698.831.67
ADMIN SERVICES 1.642.603.00 204.984.01 1.437.618.99 1.428.578.92 201.444.37 1.227.134.55
BUILDING MANAGEMENT 734.657.00 18.653.23 716,003.77 667.791.12 31. 035.30 636.755.82
INSURANCE COST CENTER 397,038.00 231.138 00 t65.900.00 314.526.18 185,395.00 129. t31.18
ELECTIONS COST CENTER 2.890.00 2.890.00 12.265.33 50.55 12.214 78
NON-DEPARTMENTAL 107,712.00, 450.65 107.261. 35 4.876.28 4.876.28
ACTIVITY TOTAL 5,526.335.00 657.471.58 4.868.863.42 4,627.108.01 617.404.81 4.009.703.20
PUBlI C SAFETY
POll CE 11.358.537.00 114.020.89 11.244.516.11 9.834.326.77 161. 212. to 9.673.114.67
CROSSING GUARDS 72.283 00 821.40 71.461. 60 71 .407 .04 876.16 70,530.88
ANIMAL CONTROL 208.898.00 208.898.00 208.369.91 208.369.91
TRAFFIC SIGNALS & STREET LIGHTIN 10.6tOOO 10.61000 8.587.87 8.587.87
DISASTER PREPAREDNESS 74.721.00 6,033.92 68,687.08 68.023.t5 8.318.21 59.704.94
FIRE SERVtCES 8.890.t88.00 43.917.87 8.846.270.13 8.202.566.69 58.00704 8.144.559.65
ACTI V ITY TOTAL 20,615.237.00 164.794.08 20,450.442.92 18.393.281. 43 228.413.51 18.164.867.92
TRANSPORT A TI ON
PUBLI C WORKS 808.577.00 82.645.92 725.931. 08 716.737.80 89.953.00 626.784.80
STREET MAINTENANCE 30.314.00 30.314.00 15.908.28 15.908.28
STREET SWEEPING 150.670.00 150.670.00 140.783.85 140.783.85
STREET TREE MAINTENANCE 99.430.00 99.430.00 99,195.45 99.195.45
STREET LANDSCAPING MAINTENAN 735.124-00 65.57 735.058.43 664.567.70 24.25 664.543.45
ACTIVITY TOTAL 1.824.115.00 82.711.49 1.741.403.51 1.637.193.08 89.977 .25 1.547.215.83
HEALTH & WELFARE
WASTE MANAGEMENT 71.474.64 15.660.00 55.814.64
CHILD CARE 15.000.00 15.000.00 15.000.00 15.000.00
SOCIAL SERVICES
HOUSING PROGRAMS 199.15 199.15
THE CITY OF DUBLIN STATEMENT SHOWtNG O'Ö"
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2005 THROUGH 08/31/2005
GENERAL REV E N U E FUN 0
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.O. VARIANCE
ACTIVITY TOTAL 15,000.00 15.000.00 86,673.79 15,660.00 71.013.79
CULTURE & LEISURE SERVICES
LIBRARY SERVICES 6t5.611.00 5.475.66 6tO.135.34 577.722.50 1. 795.00 575.927.50
CULTURAL ACTIVITIES 204.701.00 69.116.61 135.584.39 124,521. 69 28,920.64 95,601.05
HERITAGE CENTER 163.333.00 17.200.37 146.132.63 124.26662 t6.206.96 108.059.66
DUBLIN CEMETERY 49.958.00 1.000.00 48.958.00 40.518.28 750,00 39.768.28
PARK MAINTENANCE 1,692,165.00 706.12 1.691.458.88 1.420,027.17 984.38 1.419,042.79
COMMUN!TY TV 66.407.00 58.160.58 8,246.42 61. 809.00 54.649.00 7.160.00
RECREATION AOMtN 704.134.00 94.263.53 609.870A7 594.665.89 90.003.80 504.662.09
PLAYGROUNDS 275.357.00 43.413.10 231.943.90 248.304.86 51.47491 196.829.95
SHANNON CENTER 342.706.00 44,770.06 297,935.94 316,674.25 40,441.30 276,232.95
PRESCHOOL 105 A58. 00 9.017.08 96 A40 . 92 80.834.69 10.517.35 70.317.34
TEENS PROGRAM 159.835.00 t5 .131. 32 144.703.68 87.288.83 10.787.03 76.501.80
ADULT SPORTS 109.230.00 t4.325.62 94.904.38 91. 259.22 11.388.31 79.870.91
YOUTH SPORTS 153.617.00 22.038.00 131. 579.00 118,533.39 10,214.31 108.319.08
COMMUN ITY GYM 43.459.00 2.249.13 41.209.87 42.887.87 1. 838.55 41. 049.32
EMERALD GLEN ACTIVITY CENTER
SPECIAL EVENTS 364.601.00 43.842.54 320.758.46 328,362.11 26,209.73 302,152.38
SEN lOR CENTER 365.728.00 32.316.06 333.411.94 251. 385.39 27.765.53 223.619.86
RECREATION INSTRUCTION 183.02300 26.796.39 156.226.61 175.147.95 26.986.88 148.161. 07
AOUATICS 429.221. 00 83.503.38 345.71762 392.152.29 88.768.89 303.383 AO
PARKS/FACILITIES MANAGEMENT 308,494.00 42,838.17 265,655.83 260,359.00 35,957.77 224 A01. 23
ACTIVITY TOTAL 6.337.038.00 626.163.72 5.710.87428 5.336.721.00 535.660.34 4.801.060.66
COMMUNITY DEVELOPMENT
PLANN1NG 2.685.t64.00 246.459.77 2.438.704.23 2.414.653.86 249.772.60 2.164.881.26
BUILDING SAFETY 3,213.885.00 203,011.80 3,010,873.20 2.395,154.71 167.444.47 2.227.710.24
ENGINEERING 2.194.005.00 200.547.37 1. 993 .457 . 63 2.295.532A1 224.449.74 2.071.082.67
ECONOMIC OEVELOPMENT 340.628.00 66.503 7t 274.124.29 271.732.72 102,592.13 169.140.59
ACTIVITY TOTAL 8,433.682.00 716,522.65 7,717.159.35 7,377,073.70 744.258.94 6,632,814.76
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS 1.319.558.00 1.454.53 1.318.103.47 638.027 .42 65.754.24 572.273.18
COMMUNITY IMPROVEMENTS 522.329.00 279.235.07 243.093.93 188.629.59 5.573.92 183.055.67
PARKS 1.498.597.00 180.969.50 1.317.627.50 2.629.538.67 417.948.66 2.211.590.01
STREET CONSTRC/IMPROVEMENTS 1. 185.241. 00 78.171.98 1.107.069.02 979,822.61 10,454.12 969,368.49
ACTIVITY TOTAL 4.525.725.00 539.831. 08 3.985.893.92 4.436.018.29 499.730.94 3.936.287.35
TOTAL EXPENDITURES 47.277.132.00 2.802.494.60 44.474. 637 AO 41. 894.069.30 2.731.105.79 39.162.963.51
EXCESS REVENUE (EXPENDITURES) (1.765,995.00) 1.136.685.64 (2,902,680.64) 733,579.47 2.110,544.69 (1,376,965.22)
TRANSFERS IN FROM OTHER FUNOS 6.600.00 6.600.00
TRANSFERS OUT FROM OTHER FUNDS
REVENUES OVER(UNOER) EXPENDITURES (1.765.995.00) 1.136.685.64 (2.902.680.64) 740.179 A7 2.110.544.69 0.370.365.22)
-------- .- ".
THE CITY OF OUBLIN STATEMENT SHOWING "3 obI \
REVENUES YERSUS EXPENDITURES
FOR THE PERIOD
07/01/2005 THROUGH 08/31/2005
S P E C I A L REV E N U E FUN D S
CURRENT CURRENT PRIOR PRIOR
8UDGET ACTUAL VARIANCE FISCAL YEAR Y.T.O. VARIANCE
********REVENUES********
PROPERTY TAXES 117,680.00 117.680.00 111. 532.51 111.532,51
SALES TAX/OTHER TAXES 360,500.00 360,500,00 364.477,71 364.477.71
FINES & FORFEITURES 156,000.00 11. 525.30 144.474.70 149,341- 93 t49. 341- 93
USES/MONEY & PROPERTY 99.757.00 99.757.00 102.932.29 102.932.29
INTERGOVERNMENTAL FROM STATE 1. 014.231. 00 141. 841. 49 872.389.51 2.037,231.75 138.494,96 1-898,736.79
INTERGOVERNMENTAL FROM COUNTY 340,440.00 340.440.00 332,344.00 332,344.00
INTERGOVERNMENTAL FROM FEDERAL 76.792.00 76.792.00 51. 527 . 00 51.527.00
CHARGES FOR SERVICES 1. 350.461. 00 1. 350.461. 00 1.064,250.t2 1.064,250,12
OTHER SOURCES OF REVENUE 409,500.00 409.500.00 170,482.39 170.482.39
TOTAL REVENUE 3,925.361-00 153.366.79 3.771.994.2t 4.384.119.70 138.494,96 4.245.624.74
*******EXPENOITURES*******
PUBL! C SAFETY,
POll CE 120.255.00 120,255,00 105.952,40 105.952.40
TRAFFIC SIGNALS & STREET LTG 234.700.00 44.82100 189,879.00 173. t7514 4.898.85 168,276.29
DISASTER PREPAREDNESS
FIRE SERVICES 270.120,00 270,120.00 251- 09121 500.00 250.59l.21
ACTIVITY TOTAL 625.075.00 44.821. 00 580,254.00 530.218.75 5,398.85 524.819.90
TRANSPORTATION,
STREET MAINTENANCE 330.474.00 330,474.00 272.39025 272.390.25
STREET SWEEPING
ACTIVITY TOTAL 330.474.00 330,474.00 272,390,25 272.390,25
HEALTH & WELFARE;
WASTE MANAGEMENT 1.874.906.00 12.594.17 1. 862.311. 83 1.383.964.16 5.589.33 1.378.374.83
SOCIAL SERVICES 60.427.00 60.427.00 44.927.00 44.927.00
HOUSING PROGRAMS
ACTI V ITY TOTAL 1. 935,333.00 12.594.17 1,922.738,83 1-428.891.16 5.589.33 1.423.301. 83
COMMUNITY DEVELOPMENT;
ENGINEERING 6.000.00 6.000,00 6.000.00 6,000.00
ACTI V ITY TOTAL 6.000,00 6,000,00 6.000.00 6,000.00
CAPITAL IMPROVEMENT PROJECTS;
GENERAL CIP PROJECTS
COMMUNITY PROJECTS 9.765,00 9.765,00 14,850.00 14.850.00
PARKS 31.310,00 31.310.00 321. 717.00 321.717 . 00
STREET CONSTRUCTION/IMPROVEMENT 1. 654 .170 00 7,055.69 1.647.114.31 149,554.78 8.232,64 141.322.14
ACTIVITY TOTAL 1.695.245,00 7,055.69 1.688.189.31 486,121-78 8.23264 477.889.14
TOT A L EXPENDITURES 4.597.69100 64,470.86 4.533.220.14 2.723.621. 94 19.220,82 2.704.401.12
EXCESS REVENUE (EXPENDITURES) (672.33000) 88.895.93 (761.225.93) 1. 660 .497 . 76 119.274.14 1.541.223.62
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS 6,600.00 6.600.00
REVENUES OVER (UNDER) EXPENDITURES (672,330,00) 88.895,93 (761.225.93) 1.653.897.76 119,274.14 1.534.623,62
THE CITY OF DUBLIN STATEMENT SHQWtNG
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2005 THROUGH 08/3t/2005
~ Db \ \
SPECIAL ASS E SSM E N T FUN 0 S
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
********REVENUES********
SPECIAL BENEFITS ASSESSMENTS 664,610.00 664,610,00 741.372.52 741.372,52
USES/MONEY & PROP· INTEREST 15,478.00 15.478,00 14.748.10 14.748.10
OTHER SOURCES OF REVENUE 5,000.00 2.578.84 2.42116
TOTAL REVENUE 685,088.00 2.578,84 682.509,16 756.120,62 756,120.62
*******EXPENDITURES*******
PUBLI C SAFETY:
TRAFFIC SIGNALS & STREET LIG 278.600.00 15.58826 263.011.74 231. 533.62 14.289.89 217 .243.73
ACTIVITY TOTAL 278,600,00 15,588,26 263,01l.74 231533 . 62 14,289.89 217.243.73
TRANSPORTATION
PUBLIC WORKS 2.415,00 229,23 2.185.77 1. 591. 29 222.53 1.368,76
STREET TREE MAINTENANCE 34.231.00 46124 33.769.76 18.46676 476.00 17.990.76
STREET LANDSCAPE MAINTENANCE 356.039.00 3.420,70 352,618.30 306.402,30 3,326.98 302.075,32
ACTIVITY TOTAL 392.685.00 4.111.17 388,573.83 325.46035 4.025.51 321. 434 . 84
COMMUNITY DEVELOPMENT
ENGINEERING 13,100.00 327.60 12,772.40 7.t39,94 1.619.05 5.520,89
ACTIVITY TOTAL 13.100.00 327,60 12,772.40 7.139.94 1.619.05 5.520,89
CAPITAL tMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS 32.920.00 32.920.00
STREET CONSTRUCTION/IMPRVMNT 75.000.00 75.000.00
ACTIVITY TOTAL 107.920,00 107,920.00
TOT A L EXPENDITURES 792.305,00 20,027.03 772.277,97 564.133.91 19.934,45 544,199.46
EXCESS REVENUE (EXPENDITURES) (107 .2t7 .00) (17,448.19) (89768.81) t91.9B6.7t (19.93445) 211.921.16
REVENUES OVER (UNDER) EXPENDITURES (107.217 00) (17,44B.19) (B9.76B,81) 191. 986. 7t (19,934.45) 211 ,921.16
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2005 THROUGH 08/31/2005
\0 00' \
CAP I TAL IMP R 0 V E MEN T FUN 0 S
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.O. VARIANCE
********REVENUE********
USES/MONEY & PROP-INTEREST 865,623.00 865.623,00 1.125.436.25 1.125.436,25
OTHER SOURCES OF REVENUE 19.267,625.00 3.654.734.53 15.6t2.89047 14.976.041. 97 7.205.067.62 7.770.97435
TOTAL REVENUE; 20.133,248.00 3.654.734.53 16,478.513,47 16.101. 478.22 7,205,067,62 8.B96.4IO.60
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVtTtES;
CITY ATTORNEY 38.950,00 38.950.00 35.736.39 35.736.39
ACTIVITY TOTAL 38.950,00 38.950.00 35.736.39 35.736,39
PUBLI C SAFETY:
TRANSPORTATION;
HEALTH & WELFARE:
HOUSING PROGRAMS B99. 170.00 33,2t2,49 B65,957.51 212,088.92 20,696.74 191. 392 .IB
CULTURE & LEISURE SERVICES:
RECREATION ADMINISTRATION
ACTIVITY TOTAL
COMMUNITY DEVELOPMENT
PLANNING
ACTI V ITY TOTAL
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS 67.70000 67.700.00 624.943.39 137 .114 57 487.828.82
COMMUNITY IMPROVEMENTS 251. 251. 50 251. 251. 50
PARKS 9,165,802,00 333,051. 56 8.832.750 44 6,285,543.71 50,280,68 6.225,263.03
STREET CONSTRUCTION/IMPROVEMENT 36.028,246.00 22,041. 95 36.006.204,05 3.970,457.62 29.758.02 3.940,589.60
ACTI V ITY TOTAL 45.261.748.00 355.093.51 44.906.654.49 11.t32.196.22 227.163.27 10.905.032.95
TOT A L EXPENDITURES 46.199.868.00 388.306.00 45.811.552.00 11 .380. 021. 53 247,860.01 11,132.161.52
EXCESS REVENUE (EXPENDITURES) (26.066.620.00) 3.266.428.53 (29.333.048.53) 4.721.456.69 6.957.207.61 (2.235.750.92)
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
REVENUES OVER (UNDER) EXPENDITURES(25.D66,620.00) 3,266,428,53 (29,333.048.53) 4.721.456,69 6.957.207.61 (2.235,750,92)
THE CITY OF DUBLIN STATEMENT SHOWING , \ t5t'\
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2005 THROUGH. 08/31/2005
I N T ERN A L S E R V ICE FUN 0 S
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR YTD. VARIANCE
********REVENUES********
USES/MONEY & PROP-INTEREST 297.089.00 297.089.00 245.407.37 245.407.37
CHARGES FOR SERVICES 1.796.096.00 t45.412.53 1.650.683.47 1.624.800.05 281. 014.89 1. 343 .785.16
OTHER SOURCES OF REVENUE 23.400.00 14.116.75 9.283.25 14.606.96 t4.606.96
TOTAL REVENUE 2.116.585.00 159.529.28 1.957.055.72 1.884.B14.38 281,014.89 1.603.799.49
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES
NON-DEPARTMENTAL 2.074.072.00 59.839.23 2.014.23277 1.130.744.57 448.173.78 682,570.79
ACTIVITY TOTAL 2.074.072.00 59.839.23 2,014.232.77 1.130.744.57 448.173.78 682.570.79
PUBLI C SAFETY,
FIRE 65.561. 00 65.561. 00 44,652.77 44.652.77
ACTI V ITY TOTAL 65.561. 00 65.561. 00 44.652.77 44.652.77
TRANSPORTATION,
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT,
CAPITAL IMPROVEMENT PROJECTS:
TOT A L EXPENDITURES 2.139.633.00 59,839.23 2,079.793.77 1.175.397.34 448.173.78 727.223.56
EXCESS REVENUE (EXPENDITURES) (23.048.00) 99.690.05 022.738. 05) 709.417.04 067.158.89) 876,575.93
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
REVENUES OVER (UNDER) EXPENDITURES (23.048.00) 99.690.05 022.738.05) 709.417.04 067.158.89) 876.57593