HomeMy WebLinkAbout4.03 FinancialRptOct05
CITY CLERK
File # D~~[Q]-[5J[ð]
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: November 15, 2005
SUBJECT:
Financial Reports for the Month of October 2005
Report Prepared by: Carole A. Perry, Administrative Services
Director and Lisa Hisatomi, Administrative Analyst II
A TT ACHMENTS: I. YTD Revenues and Budget Comparison
2. YTD Expenses and Budget Comparison
3. Financial Statements for October 2005
..~
RECOMMENDA nON] \ Receive the reports.
FINANCIAL STATEMENT: See reports for detail of monthly financial activity.
DESCRIPTION:
This item provides the report on the preliminary financial statements for the month of October 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 October 2005 Revenue and Expenditure Reports
The October reports represent the reporting of revenues and expenditures for four months of the Fiscal
Year, through October 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, ineluding Police and Fire
Services.
Given October is only the fourth month of the Fiscal Year, there is limited data on which to base any
major projections or identity significant trends. Also, in October 2005, the auditors started the final phase
of thc fieldwork necessary for the Fiscal Year 2004-2005 audit. The fmal audit results will impact the
reported Fund Balance presented in the attached monthly reports.
General Fund Revenues
Total General Fund Revenues collected through October are less than what occurred in the fourth month
of the previous Fiscal Year. Through October 2005, the City had collected approximately 18% of the total
budgeted General Fund Revenues, which was 3% Icss than the percentage collected in the prior Fiscal
Year. A brief description is provided below to cxplain any material revenue variations.
Sales Tax is lower, when compared to the same period in the prior year, as last year the State delayed
implementation of the V. percent reduction to sales tax (related to the "Triple Flip") until the second
quarter. 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 these funds. Franchise Fees are lower
than in the same period in the prior period due to timing differences in the receipt of Garbage Franchise
___________________________________________________________________________w~_____~________________________·_
Document In FSCOLOR 1O&200S.XLS
ITEM NO.
~
COPIES TO:
Page I 0£2
Fees. Licenses and Permits, as a percent of the budget, are slightly higher than in the prior year.
However, the actual revenue dol1ars are lower than in the same period of the prioryear due to lower
permits pul1ed for residential projects. Interest and Rentals received to date are lower than the prior year
due to timing differences in the receipt of interest earnings on thc City's securities and allocation of
interest revenue to other funds. 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 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, there was no indication that the VLF loan would be repaid ahead of schedule;
therefore, no revenue 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.
Fines and Forfeitures are lower than in the same period of the prior year due to lower year to date receipts
of court and parking fines. Other Revenues are lower than in the same period of the prior ycar due to a
one time payment received in the prior year for ongoing maintenance of storm drains and timing
differences in the receipt of reimbursements from the City of Pleasanton for the design of improvements
to the Fallon RoadlI-580 freeway interchange.
General Fund Expenditures
Overal1, through the month of October, expenditures in the General Fund totaled about $6.8 million and
represented approximately 14% of the total budgeted expenditures in the General Fund. Of this amount, a
total of approximately $927,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 October 2005 was similar to
the amounts expended for the same period in the prior Fiscal Year. Through the end of October 2005, the
City had expended 14% of the General Fund Operating Budget, which was similar to the amount
expended in the prior Fiscal Year.
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.
Pagc 2 of2
115'tJ \~
City of Dublin 2005-2006 YTD Revenues and Budget Comparison
__fºx_t!!_~_I'!,'Ijºd_Kn<!l1!g_º~t9.ber 31 2005
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
Property Taxes
Sales Taxes
Real Property Transfer Tax
Transient Occupancy Taxes
Franchise Taxes
Lic:ense$ and Permits
Interest and Rentals
Intergovernmental
Charges for Services
Fines and Forfeitures
Other Revenue$
42%
0%
30%
60%
. FY 2005/06
. FY 2004/05
13 %
90%
150%
120%
33% of Year Complete
FY 2005106
Budget
FY 2005/06
YTD Actual
15,716.461
14,984,884
745,600
680,500
1,626,300
2,380,013
1,898,725
498,650
5,256,561
132,200
1,596,243
716,900
2,788.469
253,159
195,665
166.465
1,315,903
294,939
687,115
1.476,560
36,760
199,048
Total General Fund Revenues 45,516,137
DaI.Pr1rDd:11021200!i&:OI'IPM
8,130,983
n...__.__._......"'.
%of FY 2004105 % of Total for
Budget YTD Actual FY 2004/05
5% 635,551 5%
19% 3,091,338 22%
34% 135,112 16%
29% 174,782 26%
10% 279,044 18%
55% 1,880,047 53%
16% 870,227 50%
138% 285,891 50%
28% 1.468,492 26%
28% 48.445 34%
12% 328,839 42%
18% 9,197,788 21%
LIEMY,3 1/-/5'-0'5
ATTACHMENT 1
I-~Uy ofDobliD 2005-2006 YTD E_o_ .nd Bod,'" com.......~-%,3
. For the Period Ending October 31, 2005
Total General Fund
Expenses
General Goverument
Police
Fire 12%
. 20/.
Otber Public Safety
Transportation
Healtb and Welfare
Culture & Community
Services
Community
Development
Capital Improv.
Projects
0% 20% 40%
. FY 2005/06
. FY 2004105
11 %
60%
80%
100%
120%
33% of Year Complete
2005106 2005106 %of FY 2004105 % ofTotal for
Budget YTD Actual Budget YTD Actual FY 2004105
General Government 5,526,335 1,385,910 25% 1.277.308 26%
Police 11,358,537 343,397 3% 369.755 4%
Fire 8,890,188 141,928 2% 142,940 2%
Other Public Safety 383,869 21,961 6% 24,805 7%
Transportation 1.824.115 367,228 20% 345,437 21%
Health and Welfare 15,000 17,000 113% 31.689 37%
Culture and Community Services 6,348,938 1,642,125 26% 1.362.917 25%
Community Development 8,433,682 1,986,904 24% 1.940,763 26%
Capital Improvement Projects 4,567,765 926,780 20% 1,032,717 22%
Total General Fund Expenses 47,348,429 6.833.233 14% 6,528,331 15%
General Fund Operating Expenses 42.780,664 5.906.453 14% 5,495,614 15%
o.al"rlrnd.l.~S.'4"M
ATTACHMENT 2
CITY OF DUBLIN'S
PRO FORMA FINANCIAL STATEMENTS
FOR
THE MONTH OF OCTOBER 2005
Prepared by
The Finance Department
November 7, 2005
:36tJ3
ATTACHMENT 3
4~/3
CITY OF DUBL! N
BALANCE SHEET
FOR THE
PERIOD ENDING 310ct2005
GENERAL SPECIAL SPECIAL CAPITAL TRUST/ TOT A L S
REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY ---MEMORANDUM DNLY---
FUNDS FUNDS FUNDS FUNDS FUND CURRENT PRIOR
ASSETS
CASH (4B.731.849) 3.267,377 473,176 36.444.188 14.515 (8.532.592) (27.3B2.788)
CASH WITH FISCAL AGENT 175,727 175.727 172.779
AMOUNT HELD IN ESCROW 4.]77 .500 4,177.500
INVESTMENTS AT COST 98.812.763 98,812.763 97.873.031
RECEIVABLES, TAXES
ACCOUNTS 127.768 363,597 491. 364 475.500
INTEREST 500.222 500.222 496.242
ASSESSMENTS
DUE FR()1 OTHERS 2,206.558 2,206.558 1. 829.213
INVENTORY AT COST
PREPAIO ITEMS 4.682 4.682 13.708
FIXED ASSETS
LOANS RECEIVABLE 4.596.534 4.596.534
AMOUNT TO BE PROVIDEO 1. 213.500 1.213.500 1. 334. 500
TOTAL ASSETS 52.920.145 3.630.974 473.176 45.2IB.222 1.403.742 103.646.260 74.812.184
LIABILITIES/FUND EQUITY
OEPOSITS FOR PRIVATE OEVEL (1,01B.610) (1,01B.610) (658.276)
DEPOSITS FOR A81600 FEES (113.475 ) (496.725 ) (610.200) (171. 037)
DEPOSITS OTHERS (2,702.401) (2,702.401) (2.483.211 )
PAYABLES: ACCOUNTS (749.399) (35.622) (1.556) (786.577) (276.959)
INTEREST
PAYROLL (618.483) (618.483) (543.641)
DUE TO OTHERS (502.291) (5,270) (2.201.289) (2.708.850) (43.672)
OEFERRED REVENUE (127,768) (127,768) (127,768)
DEBT INSTRUMENTS PAYABLE (l, 331. 000) (1.331.000) 0.452.000 )
TOTAL LIA8ILITIES (5.832.429) (40,892) (2.699.570) (1.331.000) (9.903.890) (5,756.564)
FUND BALANCES (47.087,717) (3.590,082) (473.176) (42.518.653) (72.742) (93.742.370) (69.055,620)
TOTAL FUND E (47,087.717) (3.590,082) (473.176) (42.518.653) (72.742) (93.742.370) (69.055,620)
TOTAL LIABILITIES/EQUITY (52.92Q.145) (3.630,974) (473.176) (45.218.222) (1.403.742)(103.646.260) (74.812,184)
5" 6(:/ '3
CITY OF DUBLI N
BALANCE SHEET
FOR THE
PERIOO ENDING 310ct2005
INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG TOT A L S
SERVICE FUND GROUP OF TERM DEBT - - -MEMDRANDUM- --
FUNDS ACCOUNTS ACCOUNT GROUP CURRENT PRIOR
ASSETS
CASH 9.293.092 9.293.092 8,182.599
CASH WITH FISCAL AGENT
AMOUNT HELD IN ESCROW
INVESTMENTS AT COST
RECEIVABLES: TAXES
ACCOUNTS
INTEREST
ASSESSMENTS
OUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS
FIXED ASSETS 50.002.851 333.664.335 383.567.185 85.720.159
LOANS RECEIVABLE
AMOUNT TO 8E PROVIDED 63,776.544 63.776.544 66 .753 . 945
TOTAL ASSETS 59.295.944 333.664.335 63.776.544 456.736.823 160.656.702
LIABILITIES/FUND EQUITY
DEPOSITS FOR PRIVATE DEVEL
DEPQSITS FOR AB1600 FEES
DEPOSITS OTHERS
PAYABLES, ACCOUNTS
INTEREST
PAYROLL
DUE TO OTHERS
OEFERRED REVENUE
DEBT INSTRUMENTS PAYABLE (63.776.544) (63.776.544) (66.753.945)
TOTAL LIABILITIES (63.776.544) (63.776.544) (66.753.945)
FUND BALANCES (59.295.944) (333.664.335) (392.960.278) (93.902.758)
TOTAL FUND E (59.295.944) (333.664.335) (392.960.278) (93.902.758)
TOTAL LIABILITIES/EQUITY (59.295.944) (333.664.335) (63.776.544) (456.736.823)(160.656.702)
THE CITY OF DUBLIN STATEMENT SHOWING Ú2 C5() / 3
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
0710112005 THROUGH 1013112005
G ENE R A L REV E N U E FUN 0
CURRENT CURRENT PRIOR PRIOR
BUD3ET ACTUAL VARIANCE FISCAL YEAR Y.T.O. VARIANCE
*******REVENUES*******
PROPERTY TAXES 15.716.461.00 716.900.06 14.999.560.94 14.054.547.16 635.550.84 13.418.996.32
SALES TAX 14.984.884.00 2.788.468.87 12.196.415.13 14.152.987.24 3.091. 338 35 11. 061.648. 89
REAL PROPERTY TRANSFER TAX 745.600.00 253.159.09 492.440.91 831. 003.24 135.111. 76 695.891. 48
flOTEL TRANSIENT OCCUPANCY TAX 680.500.00 195.664 71 484.835.29 663.631. 67 174.782.06 488.849.61
FRANCHISE TAXES 1.626.300.00 166.464.82 1.459.835.18 1.559.900.22 279.043.77 1.280.856.45
LICENSES & PERMITS 2.380.013.00 1.315.903.36 1.064.109.64 3.520.140.84 1.880.047.46 1.640.093.38
FINES & FORFEITURES 132.200.00 36.76039 95.439.61 143.316.33 48.445.26 94.871.07
USEIMONEY & PROP-INTEREST 1. 757 . 524.00 281. 010 33 1.476.513.67 1. 608 . 966 . 40 841. 753 35 767.213.05
USEIMONEY & PROP-RENTALS 141.201.00 13.928.87 127.272.13 125.835.40 28.473.98 97.361.42
INTERGOVERNMENTAL 498.650.00 687.11512 088.465.12) 568.598.34 285,891.16 282.707.18
CHARGES FOR SERVICES 5.256.561.00 1.476.559.64 3.780.001. 36 5.548.124.34 1.468.491.75 4.079.632.59
OTHER SOURCES OF REVENUE 1.596.243.00 199.048.21 1.397.194.79 783.873.45 328.838.87 455.034.58
TOTAL REVENUE 45.516.137.00 8.130.983.47 37.385.153.53 43.560.924.63 9.197.768.61 34.363.156.02
*******EXPENOITURES*******
GENERAL GOVERNMENT ACTIVITIES,
CITY COUNCI L 300.704.00 74.388.02 226.315.98 224.070.48 61.145.18 162.925.30
CITY MANAGER 997.923.00 276.252.85 721. 670 .15 919.976.69 265.150.26 654. 826.43
CENTRAL SERVICES 538.556.00 104.255.17 434.300.83 362.244.59 97.388.79 264.855.80
CITY ATTORNEY 824.252.00 107.025.35 717.226.65 631. 96318 95.986.87 535.976.31
AC\'IIN SERVICES 1.642.603.00 449.688.79 1.192.914.21 1.433.876.94 418.419.12 1.015.457.82
BUILDING MANAGEMENT 734.657.00 141.618.03 593,038.97 668.646.21 152.184.39 516.461.82
INSURANCE COST CENTER 397.038.00 231. 904.31 165.133.69 508.448.41 186.958.20 321.490.21
ELECTIONS COST CENTER 2.890.00 22.50 2.867.50 12.265.33 50.55 12.214.78
NON-DEPARTMENTAL 87.712.00 754.74 86.957.26 68.155.13 25.00 68.130.13
ACTI V ITY TOTAL 5.526.335.00 1.385.909.76 4.140.425.24 4.829.646.96 1. 277 .308.36 3.552.338.60
PUBLIC SAFETY
POLICE 11.358.537.00 343.397.31 11.015.139.69 9.837.842.27 369.755.23 9.468.087.04
CROSSING GUAROS 82.140. DO 5.558.14 76.581. 86 71.407.04 4.284.97 67.122.07
AN I MAL CONTROL 208.898.00 208.898.00 208.369.91 208.369.91
TRAFFIC SIGNALS & STREET LIGHTIN 18.110.00 2.436.31 15.673.69 8.587.87 2.030.32 6.557.55
OISASTER PREPAREDNESS 74.721.00 13.966.98 60.754.02 68.023.15 18.490.20 49.53295
FIRE SERVICES 8.890.188.00 141.927.70 8.748.260.30 8.207.944.38 142.939.66 B.065.004.72
ACTIVITY TOTAL 20.632.594.00 507.286.44 20.125.307.56 18.402.174.62 537.500.38 17.864.674.24
TRANSPORTATION
PUBLIC WORKS 808.577.00 203.071. 89 605.505.11 723.562.41 200.999.70 522.562.71
STREET MAINTENANCE 30.314.00 30.314.00 15.908.28 15.908.28
STREET SWEEPING 150.670.00 23.381.79 127.288.21 140.783.85 23.343.92 117.439.93
STREET TREE MAINTENANCE 99.430.00 21. 969.55 77.460.45 99.195.45 6.537.05 92.658.40
STREET LANDSCAPING MAINTENAN 735.124.00 118.804.63 616.319.37 682.756.30 114.556.45 568.199.85
ACTIVITY TOTAL 1.824.115.00 367.227.86 1.456.887.14 I. 662.206.29 345.437.12 1. 316 .769.17
HEALTH & WELFARE
WASTE MANAGEMENT 2.000.00 (2.000.00) 71.474.64 31. 688.90 39.785.74
CHILD CARE 15.000.00 15.000.00 15.000.00 15.000.00
SOCIAL SERVICES
HOUSING PROGRAMS
THE CITY OF DUBLIN STATEMENT SHOWING 1ó?) 3
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2005 THROUGH 10/31/2005
G ENE R A L REVENUE FUN 0
CURRENT CURRENT PRIOR PRIOR
BUD3ET ACTUAL VARIANCE FISCAL YEAR Y.T.D, VARIANCE
ACTIVITY TOTAL 15.000.00 17.000,00 (2,000.00) 86.474.64 31. 688.90 54,785.74
CULTURE & LEISURE SERVICES
LIBRARY SERVICES 615.611.00 151.474 76 464.136.24 577.734.07 17.030.23 560.703.84
CULTURAL ACTIVITIES 204.701. 00 98.843,01 105.857,99 125.102,04 33,017.81 92.084.23
HERITAGE CENTER 163.333.00 41. 623.97 121. 709 . 03 125.641. 44 32,685.46 92.955.98
OUBLIN CEMETERY 49.958,00 4.777.13 45.180,B7 40.573,15 10,564.46 30.008,69
PARK MAINTENANCE 1.704.065,00 258.557.38 1.445.507,62 1.450.064,58 263,306.32 1.186.758,26
COMMUN ITY TV 66.407,00 58.985.58 7.421.42 61. 809 00 55.899.00 5.910.00
RECREATION ADMIN 704.134 00 187.266.67 516.867.33 60B .760.76 176.032.46 432.728.30
PLAYGROUNDS 275.357,00 76.456.85 198.900,15 247,214,27 85.688.91 161. 525.36
SHANNON CENTER 342.70600 93.462.03 249.243.97 301. 071.12 101. 336.21 199.734.91
PRESCHOOL 105.45B,00 29.623.53 75.834.47 82,639.86 22.281.15 60.358.71
TEENS PROGRAM 159.835,00 35.830.28 124.004.72 87,306.66 24.122.60 63.184.06
ADULT SPORTS 109.23000 25.879.98 83.350.02 92.694.01 28.312.17 64.381. 84
YOUTH SPORTS 153.617,00 43,485.42 110.131. 58 118,533.39 29.685.50 88.84789
COf'MUN ITY GYM 43.459.00 6,423.71 37.035.29 42.887.87 7.343.69 35.54418
EMERALD GLEN ACTIVITY CENTER
SPECIAL EVENTS 364.601. 00 152.763.49 211.837.51 331.898.19 121.089,81 210,808.38
SENIOR CENTER 365.728.00 113,760.60 251. 967 .40 253.121.20 68.31691 184.804.29
RECREATION INSTRUCTION 183.023.00 41. 954.88 141. 068 .12 174.492.75 58.550,50 115,942.25
AQUATICS 429,221. 00 135,629.17 293.591. 83 393.660.59 151. 866.69 241.793.90
PARKS/FACILITIES MANAGEMENT 308,494.00 85.326.67 223.167.33 261. 928.57 75.787.61 186.140.96
ACTIVITY TOTAL 6.348,938.00 1. 642 .125. II 4.706.812.89 5.377.133.52 1.362.917.49 4.014.216.03
COMMUNITY DEVELOPMENT
PLANNING 2.685,164.00 639.926.69 2.045.237.31 2.414.972.53 725,497.77 1.689.474.76
BUILDING SAFETY 3.213,885.00 708.145,33 2.505,739.67 2.399.434.25 494.699.62 1.904.734.63
ENGINEERING 2.194.005.00 536.47222 1.657.532.78 2.304.69155 593,163.45 1. 711.528.10
ECONOMIC DEVELOPMENT 340.628,00 102.359,73 238,268,27 272.379,63 127,401. 71 144.977.92
ACTIVITY TOTAL 8.433.682.00 1.986.903,97 6.446.778.03 7.391.47796 1.940.762.55 5.450.715.41
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS I.319.558.00 62.386,79 1.257.171.21 633.849,26 168.939.69 464.909,57
COMMUNITY IMPROVEMENTS 544.369.00 288.266.63 256.102.37 403.110.09 18.695.55 384.41454
PARKS 1.518.597.00 437.902,17 1.080.694.83 2.630,020.78 600.716.79 2.029.30399
STREET CDNSTRC/IMPRDVEMENTS 1,185.24100 138.224.21 1.047.016.79 980.260.11 244.365.35 735.89476
ACTIVITY TOTAL 4,567.765.00 926.779.80 3.640.985.20 4.647,240.24 1.032.717.38 3.614.522,86
TOTAL EXPENDITURES 47,348.429.00 6.B33.232.94 40.515.196.06 42.396,354.23 6.528.332.18 35.868,022,05
EXCESS REVENUE (EXPENDITURES) (1,832.292.00) 1. 297 .750.53 (3,130.042.53) 1.164,570.40 2,669.436,43 (1.504,866.03)
TRANSFERS IN FROM OTHER FUNDS 475.053.00 475.053.00 27.230.91 27,230.91
TRANSFERS OUT FROM OTHER FUNDS
REVENUES DVER(UNDER) EXPENDITURES 0.357.239.00) 1.297.750.53 (2.654.989.53) 1.191. 801. 31 2,669.436,43 (1.477.635.12)
THE CITY OF DUBLIN STATEMENT SHOWING Z5 9J/S
REVENUES VERSUS EXPENDITURES
FOR THE PE R 100
07/01/2005 THROUGH 10/31/2005
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 117, 6BO. 00 117.6BO.00 112.532.03 112.532.03
SALES TAX/OTHER TAXES 360,500.00 41. 252.07 319.247.93 364,477.71 58.572.16 305.905.55
FINES & FORFEITURES 156,000.00 27.601.10 128.39B.90 149,341. 93 11.296.B4 13B.045.09
USES/MONEY & PROPERTY 99.757.00 21. OB3 . 99 7B.673.01 102,932.29 102.932.29
INTERGOVERNMENTAL FROM STATE 1. 014,231. 00 345.650.33 668.580.57 2.354,339.55 311.980.50 2.042.359.15
INTERGOVERNMENTAL FROM COUNTY 340.440.00 38.110.00 302.330.00 332,344.00 332.344.00
INTERGOVERNMENTAL FROM FEDERAL 76.792.00 3.376.79 73.415.21 56 .796. BO 2.790.99 54.005,81
CHARGES FOR SERVICES 1. 350.461. 00 1. 350.461. 00 1.075.17B.65 1.075.178,55
OTHER SOURCES OF REVENUE 409.500.00 409.500.00 170.482.39 4.51B35 155.954,04
TOTAL REVENUE 3,925.351.00 477.074 28 3.44B.286.72 4.71B.425.45 3B9.15B,B4 4.329.26661
*******EXPENOITURES*******
PUBLlC SAFETY:
POll CE 120.255.00 ·"~20.255.00 105.952.40 1. 069.40 104.BB3.00
TRAFFIC SIGNALS & STREET LTG 234)00.00 " 93.23209 41.467.91 173.175.14 22.520,92 150,654.22
DISASTER PREPAREDNESS
FIRE SERVICES 270.120.00 2.500,00 257,520.00 251. 091.21 2.256.1B 24B.B35.03
ACTIVITY TOTAL 525.075.00 95.732.09 529,342.91 530. 21B.75 25.B46.50 504,372.25
TRANSPORTATION:
SrREET MAINTENANCE 330.474.00 29.657.63 300,816.37 272.390.25 23.633.3B 248.756.87
STREET SWEEPING
ACTIVITY TOTAL 330.474.00 29.657.63 300.815.37 272.390.25 23.633.3B 24B .756. B7
HEALTH & WELFARE:
WASTE MANAGEMENT 1. 874.906.00 27.686.60 1. 847.217.40 1. 383.95416 B.459.45 1.375.504.71
SOCIAL SERVICES 60.427.00 35.233.93 25.193.07 44.927,00 1.230.39 43.696.61
HOUSING PROGRAMS
ACTIVITY TOTAL 1.935.333.00 62.922.53 1.872.410.47 1.42B.B91.16 9.6B9.84 1.419.201.32
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.00000
CAPITAL IMPROVEMENT PROJECTS:
GENERAL C1 P PROJECTS
COMMUNITY PRDJECTS 9.76500 9.765.00 14.B50.00 14.B50,00
PARKS 31. 310,00 31.310.00 321.717.00 321.717 . 00
STREET CONSTRUCTION/IMPROVEMENT 1.654.170,00 313,981. 95 1.340.188.04 149.554.7B 61. 019 69 BB.535.09
ACTIVITY TOTAL 1.695.245,00 313,981. 96 1. 381. 263 . 04 4B6 .121. 7B 61. 019,69 425.102.09
TOT A L EXPENDITURES 4.597.591.00 502.294.21 4.095.396.79 2.723 . 621. 94 120.189,41 2.603.432.53
EXCESS REVENUE (EXPENDITURES) (672.330.00) (25.219.93) (647.110.07) 1.994.B03.51 268.959.43 1.725,834.08
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS 88.737.00 BB.737.00 1.336.274.5B 1.336.274.58
REVENUES OVER (UNDER) EXPENDITURES (761. 067 . 00) (25.219.93) (735.847.07) 656.526.93 256,959.43 389.559.50
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2005 THROUGH 10/31/2005
966F3
S P E C I A L ASS E SSM E N T FUN 0 S
CURRENT CURRENT PRIOR PR lOR
BUDGET ACTUAL VARIANCE FISCAL YEAR YT O. VARIANCE
********REVENUES********
SPECIAL BENEFITS ASSESSMENTS 664.610,00 664,610.00 744.099.49 744.099.49
USES/MONEY & PROP· INTEREST 15.478 00 3.123.59 12.354.41 14.748.10 14.748.10
OTHER SOURCES OF REVENUE 5.000,00 2.578.84 2.421.16
TOTAL REVENUE 685.088,00 5,702.43 679.385.57 758.847.59 758.847.59
*******EXPENOITURES*******
PU8LlC SAFETY:
TRAFFIC SIGNALS & STREET LIG 278.600,00 57,282.67 221.317.33 231.533.62 52.760.22 178.773.40
ACTIVITY TOTAL 278.600,00 57,282.67 221.317.33 231.533.62 52.760.22 178.773 40
TRANSPORTATION
PUBLlC WORKS 2.415,00 452.75 1. 962 . 25 1. 591. 29 296.56 1.294.73
STREET TREE MAINTENANCE 34 . 231. 00 3.624.38 30.606.62 18.466.76 2.223.75 16.243.01
STREET LANDSCAPE MAINTENANCE 356.039.00 47,919.64 308.119.36 317.657.53 68.790.55 248.866.98
ACTIVITY TOTAL 392.685.00 51.996.77 340.688.23 337.715.58 71.310,86 266.404.72
COMMUNITY DEVELOPMENT
ENGINEERING 13,100.00 11.357.60 1.742.40 7.139.94 5.104.96 2.034.98
ACTlVlTY TOTAL 13.100.00 11.357.60 1.742.40 7.139.94 5.104,96 2,034.98
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS 32,920.00 86.79 32.833.21
STREET CONSTRUCTION/IMPRVMNT 75,000.00 75.000.00
ACTIVlTY TOTAL 107,920.00 86.79 107.833.21
TOT A L EXPENDITURES 792,305.00 120.723,83 671.581.17 576.389.14 129.176.04 447.213.10
EXCESS REVENUE (EXPENDITURES) (107,217.00) m5.021.40) 7.804.40 182.458.45 029.176.04) 311.634.49
REVENUES OVER (UNDER) EXPENDITURES 007,217.00) m5.021.40) 7 . 804.40 182.458.45 029,176.04) 311.634.49
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2005 THROUGH 10/31/2005
/0 61/3
CAP I TAL IMP R 0 V E MEN T FUN 0 S
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
********REVENUE********
USES/MONEY & PROP-INTEREST 865,623,00 211.307.96 654.315.04 1.221. 970.50 1.221.970.50
OTHER SOURCES OF REVENUE 19.267,625.00 5.726.051. 89 13.541. 573.11 14.361.927.97 8,414.460.89 5.947.467.08
TOTAL REVENUE: 20.192 .732.00 5.937.359.85 14.255.372.15 16.892,942.14 8.414.460.89 8.478.481.25
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES;
C!TV ATTORNEY 38.950.00 5.774.40 33.175.60 35.736.39 180,00 35.556,39
ACTIVITY TOTAL 3B.950.00 5.774.40 33.175.60 35.736.39 180.00 35.556 39
PUBLIC SAFETY;
TRANSPORTATION:
HEALTH & WELFARE;
HOUS I NG PROGRAMS 899.170.00 75.577 .42 823.592.58 219.420.35 47.206,42 172.213,93
CULTURE & LEISURE SERVICES:
RECREATION ADMINISTRATION
ACTIVITY TOTAL
CDMMUNITY DEVELOPMENT
PLANNING
ACTIVITY TOTAL
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS 67.700.00 67.700.00 624.943.39 139,564.57 485,378.82
COMMUNITY IMPROVEMENTS 36.771,00 36.771.00
PARKS 9,183.930,00 1.733.898,05 7.450,031. 95 6.285.68719 1ll.213.38 6.174.473.81
STREET CONSTRUCTION/IMPROVEMENT 36,075.842.00 146.138.55 35.929.703.45 3.309.862,62 196.092.93 3,113.769.69
ACTIVITY TOTAL 45,327.472,00 1. BBO. 036. 60 43.447,435.40 10.257.26420 446.870.88 9,810.393.32
TOT A L EXPENDITURES 46,265.592.00 1.961.388.42 44.304.203.58 10.571.890,78 494.257.30 10.077 .633.48
EXCESS REVENUE (EXPENDITURES) (26,132.344.00) 3.975.971.43 (30.108.315.43) 5,012.007.69 7.920.203.59 (2.908.195.90)
TRANSFER IN FROM OTHER FUNDS (59.484.00) (59.484.00) (1,309.043.67) 0.309.043.67)
TRANSFERS OUT TO OTHER FUNDS 445.800.00 445.800.00
REVENUES OVER (UNDER) EXPENDITURES(26,518.660.00) 3.975.971.43 (30.494.631.43) 6.321. 051. 36 7.920.203.59 0.599.152,23)
THE CITY OF DUBLIN STATEMENT SHOWING //00/"-)
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2005 THROUGH 10/31/2005
T R U S T / AGE N C Y FUN 0
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR 1.T.D. VARIANCE
********REVENUES********
SPECIAL ASSESSMENTS 228.280 .46 228.280.46
USES/MONEY & PROP-INTEREST 407.89 (407.89) 5.612.63 5.612.63
TOTAL REVENUE 407.89 (407.89) 233.893.09 233.893.09
*******EXPENOITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 231. 038.00 182.873.75 4B.164.25 232.571.18 178.745.43 53.825.75
ACTIVITY TOTAL 231. 038.00 182.873.75 48.164.25 232,571.18 178,745.43 53.825.75
PUBLI C SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS
TOT A L EXPENDITURES 231. 038.00 182.873.75 48.154.25 232.571.18 178.745.43 53,825.75
EXCESS REVENUE (EXPENDITURES) (231. 038. 00) (182.465.86) (48.572.14 ) 1.321.91 (178.745 .43) 180,057.34
REVENUES OVER (UNDER) EXPENDITURES (231. 038. 00) (182.465.86) (48.572 .14) 1. 321. 91 (178.745.43) 180.067.34
THE CITY OF DUBLIN STATEMENT SHOWING /2 CJÒ/3
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2005 THROUGH 10/31/2005
I N T ERN A L SERVICE FUN 0 S
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.O. VARIANCE
********REVENUES********
USES/MONEY & PROP-INTEREST 297.0B9.00 49.629.49 247.459.51 245.407.37 245.407.37
CHARGES FOR SERVICES 1.796.096.00 446.872.51 1.349.223.49 1.642.441.30 567.407.00 1.075.034.30
OTHER SOURCES OF REVENUE 23.400.00 14.525.00 8.875.00 4.841.986.98 4.841.986.98
TOTAL REVENUE 2.116.585.00 511. 027.00 1.605.558.00 6.729.835.65 567.407.00 6.162.428.65
*******EXPENOITURES*******
GENERAL GOVERNMENT ACTIVITIES
NON-DEPARTMENTAL 2.074.072.00 146.696.49 1.927.375.51 2.467.397.02 601.930.33 1. 865.466.69
ACTIVITY TOTAL 2,074.072.00 146.696.49 1.927.375.51 2.467.397.02 601.930.33 1.865.466.69
PUBLIC SAFETY,
FIRE 65.561- 00 65.561. 00 59.862.86 59,862.86
ACTIVITY TOTAL 65.561. 00 65.561. 00 59.862.86 59.862.86
TRANSPORTATION;
HEALTH & WELFARE'
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT;
CAPITAL IMPROVEMENT PROJECTS:
TOT A L EXPENDITURES 2.139.633.00 146.69649 1.992.936.51 2.527.259.88 601.930.33 1- 925.329 .55
EXCESS REVENUE (EXPENDITURES) (23.048.00) 364.330.51 (387.378.51) 4.202.575.77 (34.523.33) 4.237.099.10
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
REVENUES OVER (UNDER) EXPENDITURES (23.048.00) 364.330.51 (387.378.51) 4.202.575.77 (34.523.33) 4.237.099.10
********REVENUES********
USES/MONEY & PROp· INTEREST
TOTAL REVENUE
********EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES;
NON·OEPARTMENTAL
FINANCE
ACTIVITY TOTAL
PUBLI C SAFETY:
HEALTH & WELFARE;
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT;
CAPITAL IMPROVEMENT PROJECTS:
TOT A L EXPENDITURES
EXCESS REVENUE (EXPENOITURES)
TRANSFERS IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
REVENUES OVER (UNDER) EXPENDITURES
CURRENT
BUDGET
THE CITV OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2004 THROUGH 06/30/2005
E N T E R P R I 5 E
FUN D
CURRENT
ACTUAL
PRIOR
FISCAL YEAR
VARIANCE
PRIOR
Y.T.O.
/ ~ CZJ/3
VARIANCE