HomeMy WebLinkAboutItem 4.04 Financial Reports October 2006
CITY CLERK
File # D~~[Q]-~[Q]
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: December 5, 2006
SUBJECT:
Financial Reports for the Month of October 2006
Report Prepared by: Paul S. Rankin, Administrative Services
Director and Fred Marsh, Finance Manager
ATTACHMENTS: 1. YTD Revenues and Budget Comparison
2. YTD Expenses and Budget Comparison
3. Financial Statements for October 2006
~
RECOMMENDATION:~' Receive the reports.
/' \
L__J
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 2006. 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 2006 Revenue and Expenditure Reports
The October reports represent the reporting of revenues and expenditures for the first four months of the
Fiscal Year, through October 31, 2006. 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 October is only the fourth month of the Fiscal Year, there is extremely limited data on which to
base any major projections or identify significant trends. The auditors have completed the final phase of
the fieldwork and any final adjustments to Fund Balance will be incorporated in a future report after the
audit is complete.
General Fund Revenues
Total General Fund Revenues collected through October are similar, based upon the percentage collected,
to what occurred through the first quarter of the previous Fiscal Year. Through October 2006, the City
had collected approximately 17% of the total budgeted General Fund Revenues, which was the same as
the percentage collected in the same period of the prior Fiscal Year.
Although on a percentage basis the revenues are tracking according to the budget there are deviations in
terms of dollars collected in several categories. The following summarizes some of the more significant
deviations from the prior year.
~~-~~~-~-~~~-----------------------------~~~~-~-~;~---------------------I-T--E--M---N---o--.-----~~t:t-=-
Document in FSCOLOR 10-2006
u
Summary of Significant General Fund Revenue Differences
For Amounts Collected July - October 2006 vs July - October 2005
REVENUE YTD Oct YTD Oct DIFFERENCE
2006 2005 2006 More / EXPLANATION
(Less)Than 2005
Real Property Fewer real estate transactions in the
Transfer Tax $173,606 $253,159 ($79,553) current year.
Tra.nsient Higher occupancy rates are occurring
Occupancy Tax $221,268 $195,665 +$25,603 in 2006.
Reflects timing differences in when
Franchise Taxes $340,159 $166,465 +$173,694 taxes were received.
Licenses & $1,534,937 $1,315,853 +219,084 Increase in the number of residential
Permits permits issued as well as a change in
the rates.
Increase in interest rates paid and
Interest & Rentals $659,758 $307,992 +$351,766 also an increase in rentals of City
facilities
Intergovernmental $113,348 $687,115 ($573,767) In 2005 there was a one-time
repayment by the State of funds
borrowed in FY 2003/04.
Other Revenues $174,555 $74,048 +$100,507 Increase due to an insurance claim
reimbursement received from ABAG
for the Civic Center Water Intrusion
and Remediation Proj ect.
As noted earlier, the General Fund Revenue results through October 2006 are tracking in accordance with
the adopted budget plan.
General Fund Expenditures
Overall, through the month of October, expenditures in the General Fund totaled approximately $6.1
million and represented approximately 12% of the total budgeted expenditures in the General Fund. Of
this amount, a total of approximately $242,149 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 2006 was slightly
lower than the amounts expended for the same period in the prior Fiscal Year. Through the end of
October 2006, the City had expended 13% ofthe General Fund Operating Budget, which is 2% lower than
the percentage expended in July 2005 - October 2005.
The percentage of Health and Welfare expenditures expended are lower than the prior year due to
payments scheduled for later in the current Fiscal Year for a Franchise Hauler Audit. Culture and
Community Services are lower than in the prior year due to timing differences for the payment of contract
library services. Capital Improvement Projects are lower than in the same period of the prior year due to
project timing differences.
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.
Page 2 of2
/oJ
City of Dublin 2006-2007 YTD Revenues and Budget Comparison
...FQ.r..tbe.re.riQd...Ending.OctQ~er..3.1.,..20. 6
Total General Fund Revenues ~ ~~ . I
Property Taxes 4%
4%
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
Licenses and Permits
Interest and Rentals
Intergovernmental
Charges for Services
Fines and Forfeitures
Other Revenues
Total General Fund Revenues
Date Printed: 11/16/2006 8'51 AM
.67%
0%
30%
60%
. FY 2006/07 I
FY 2005/061
90%
120%
150%
33% of Year Complete
FY 2006/07
Budget
FY 2006/07
YTD Actual
17,470,288
15,283,000
712,000
685,000
1,921,000
2,901,819
2,037,738
1,083,021
6,740,407
143,560
1,952,195
50,930,028
749,251
3,024,651
173,606
221 ,268
340,519
1,534,937
659,758
113,348
1,756,252
39,235
174,555
8,787,380
%of FY 2005/06 % of Total for
Budget YTD Actual FY 2005/06
4% 716,900 4%
20% 2,788,469 19%
24% 253,159 37%
32% 195,665 27%
18% 166,465 9%
53% 1,315,853 42%
32% 307,992 20%
10% 687,115 67%
26% 1,4 76,480 26%
27% 36,760 25%
9% 74,048 27%
17% 8,018,906 17%
4, Lj /2/5/06
ATTACHMENT 1
City of Dublin 2006-2007 YTD Expenses and Budget Comparison
For the Period Ending October 31, 2006
;( (J( /2,
Total General Fund
Expenses
I
i i
".-j~%
11,111111.\1~1::!:::1::::::: 1 r%
General Government .,. T ..."'",..'" ".../~6% :
~dillb~;\I;\;\'iJI(IIEi&('iJI('iJI;'iJlf 29%
J
P I, .3%
o Ice 1111' 4%
~
Fo 1%
Ire 14 201
fu@ 10
Transportation
. FY 2006/07
Ii FY 2005/06
Other Public Safety
Health and Welfare
I
I
I
i
71%1
I
Culture & Community
Services
Community
Development
Capital Improvo
Projects
0%
20%
40%
60%
80%
100%
120%
33% of Year Complete
2006/07 2006/07 %of FY 2005/06 % of Total for
Budget YTD Actual Budget YTD Actual FY 2005/06
General Government 5,623,678 1,486,280 26% 1,418,951 29%
Police 12,171,938 385,508 3% 383,970 4%
Fire 9,253,613 136,418 1% 162,811 2%
Other Public Safety 463,056 21,478 5% 22,515 6%
Transportation 2,057,857 386,212 19% 372,509 21%
Health and Welfare 46,500 20,545 44% 17,003 71%
Culture and Community Services 7,004,411 1,501,825 21% 1,664,222 28%
Community Development 8,604,270 1,927,579 22% 2,016,474 26%
Capital Improvement Projects 5,970,962 242,149 4% 926,937 30%
Total General Fund Expenses 51,196,285 6,107,994 12% 6,985,392 16%
General Fund Operating Expenses 45,225,323 5,865,845 13% 6,058,455 15%
Date Printed: 11/16/20068:56 AM
ATTACHMENT 2
AI?"/" /.,;j./
-","v':
CITY OF DUBLIN'S
PRO FORMA FINANCIAL STATEMENTS
FOR
THE MONTH OF OCTOBER 2006
Prepared by
The Finance Department
November 16, 2006
ATTACHMENT 3
j' I
"1 (J "
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 3IOct2006
GENERAL SPECIAL SPECIAL CAPITAL TRUST/ TOTALS
REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY ---MEMORANDUM ONLY---
FUNDS FUNDS FUNDS FUNDS FUND CURRENT PRIOR
ASSETS
CASH (55,872,694) 4.137,309 410,368 41,345,739 42,739 (9,936,539) (8,647,304)
CASH WITH FISCAL AGENT 164,500 164,500 175,727
AMOUNT HELD IN ESCROW 1. 762,000 1. 762,000 4,177,500
INVESTMENTS AT COST 109,507.300 109,507,300 98,812,763
RECEIVABLES: TAXES
ACCOUNTS 1. 499.678 98,028 1.597,705 491,364
INTEREST 671,287 671 ,287 500,222
ASSESSMENTS
DUE FROM OTHERS 1. 901. 086 1. 901. 086 2,206,558
INVENTORY AT COST
PREPAID ITEMS 9,045 9,045 2,711
FIXED ASSETS
LOANS RECEIVABLE 4,731. 534 4,731. 534 4,596,534
AMOUNT TO BE PROVIDED 1. 083,500 1. 083,500 1. 213 ,500
TOTAL ASSETS 57,715,700 4,235,337 410,368 47.839,274 1. 290,739 111.491.418 103,529,577
LIABILITIES/FUND EQUITY
DEPOSITS FOR PRIVATE DEVEL (426,734) (426,734) 0.018,610)
DEPOSITS FOR AB1600 FEES (925,995) (925,995) (610,200)
DEPOS ITS OTHERS (2,325,365) (2.325,365) (2.702.401)
PAYABLES: ACCOUNTS (369,186) (55,626) (7,487) (432,298) (785.021)
INTEREST
PAYROLL (4,818) (4,818) (618.457)
DUE TO OTHERS (7,488) 0,893,598 ) 0,901. 086) (2,708,850)
DEFERRED REVENUE 053,470) 053,470) 027,768)
DEBT INSTRUMENTS PAYABLE (1. 201. 000) 0,201. 000) 0.331. 000)
TOTAL LIABILITIES (4,205,568) (63,114) 0,901. 085) 0,201. 000) (7,370,767) (9.902.308)
FUND BALANCES (53,510,132) (4,172,223) (410,368) (45.938,189) (89,739)(104,120,651) (93,627,269)
TOTAL FUND E (53.510.132) (4, 172. 223) (410,368) (45,938,189) (89,739)(104,120.651) (93.627,269)
TOTAL LIABILITIES/EQUITY (57,715,700) (4 , 235 , 337) (410,368) (47.839,274) (1.290,739)(111,491,418)(103,529,577)
::;Jo/I
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 310ct2006
INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG TOTALS
SERVICE FUND GROUP OF TERM DEBT ---MEMORANDUM--
FUNDS ACCOUNTS ACCOUNT GROUP CURRENT PR IOR
ASSETS
CASH 10.617.878 10.617.878 9.441. 310
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 49,264.248 338.623,896 387,888.144 383.667.186
LOANS RECEIVABLE
AMOUNT TO BE PROVIDED 61,593,536 61,593,536 63.728.304
TOTAL ASSETS 59.882.127 338,623.896 61.593,536 460,099,559 456,836,800
LIABILITIES/FUND EQUITY
DEPOSITS FOR PRIVATE DEVEL
DEPOSITS FOR AB1600 FEES
DEPOSITS OTHERS
PAYABLES: ACCOUNTS
INTEREST
PAYROLL
DUE TO OTHERS
DEFERRED REVENUE
DEBT INSTRUMENTS PAYABLE (61.593,536) (61,593,536) (63,728,304)
TOTAL LIABILITIES (61.593,536) (61,593,536) (63,728,304)
FUND BALANCES (59,882,127) (338,623,896) (398.506,023)(393,108,495)
TOTAL FUND E (59,882,127) (338,623,896) (398.506,023)(393,108,495)
TOTAL LIABILITIES/EQUITY (59,882,127) (338,623,896) (61.593,536) (460,099,559)(456,836,800)
60/ -,
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2006 THROUGH 10/31/2006
G ENE R A L REVENUE FUN D
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
*******REVENUES*******
PROPERTY TAXES 17,470.288.00 749.251. 08 16.721. 036.92 16.775.905.94 716.900.06 16,059.005.88
SALES TAX 15.283.000.00 3.024.650.79 12.258.349.21 14.363.863.47 2,788.468.87 11,575.394.60
REAL PROPERTY TRANSFER TAX 712.000.00 173,605.85 538.394.15 690.404.35 253.159.09 437.245.26
HOTEL TRANSIENT OCCUPANCY TAX 685.000.00 221.267.80 463.732.20 727.611.60 195.664.71 531.946.89
FRANCHISE TAXES 1. 921. 000.00 340.518.53 1.580.481.47 1. 789.355.75 166.464.82 1. 622 . 890 . 93
LICENSES & PERMITS 2,901.819.00 1.534.937.07 1. 366.881. 93 3,142.223.22 1.315,853.36 1.826.369.86
FINES & FORFEITURES 143.560.00 39.235.40 104.324.60 149.467.45 36.760.39 112.707.06
USE/MONEY & PROP-INTEREST 1.864.164.00 633.517.29 1. 230 . 646 . 71 1.447.812.35 294.062.89 1.153.749.46
USE/MONEY & PROP-RENTALS 173,574.00 26,240.93 147.333.07 123.154.10 13.928.87 109,225.23
INTERGOVERNMENTAL 1,083.021.00 113,347 93 969.673.07 1.020.574.22 687.115.12 333,459.10
CHARGES FOR SERVICES 6.740.407.00 1. 756.251. 97 4.984.155.03 5.774.668.80 1.476.479.64 4,298,189.16
OTHER SOURCES OF REVENUE 1. 952,195.00 174,554.83 1.777.640.17 275,245.24 74.048.21 201.197.03
TOTAL REVENUE 50,930.028.00 8.787.379.47 42.142.648 53 46.280.286.49 8.018.906.03 38.261. 380.46
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
CITY COUNC I L 358.156.00 76,350.07 281.805.93 246.713.83 75.516.30 171.197.53
CITY MANAGER 1. 045.943 00 296,049.57 749.893.43 939.434.70 282.131.85 657,302.85
CENTRAL SERVICES 453.57100 108,690.42 344.880.58 429.560.48 106.784.13 322,776 35
CITY ATTORNEY 750,395.00 141. 716.61 608.678.39 623,049.58 107.612.52 515.437.06
ADMIN SERVICES 1. 708,961. 00 464,657.30 1.244.303.70 1.544.223.93 460.067.83 1.084.156.10
BUILDING MANAGEMENT 762,909.00 149,700.22 613.208.78 709.411.15 152.845.36 556.565.79
INSURANCE COST CENTER 443.659.00 245.831. 51 197.827.49 353.414.23 231.904.31 121.609.92
ELECTIONS COST CENTER 21. 815.00 1. 393.13 20.421. 87 2,244.10 22.50 2.221.60
NON-DEPARTMENTAL 78.269.00 1. 891. 20 76,377.80 10,230.71 2.066.16 8.164.55
ACTI V ITY TOTAL 5.623.678.00 1.486.280.03 4.137.397.97 4.858,282.71 1.418.950.96 3.439.331.75
PUBLIC SAFETY
POLI CE 12.171.938.00 385.507.90 11 ,786 .430 . 10 10,519.026.18 383.969.76 10,135.056.42
CROSSING GUARDS 88,511.00 7.109.90 81.401.10 79.558.58 5.558.14 74.000.44
ANIMAL CONTROL 255,100.00 255.100.00 225.853.07 225.853.07
TRAFFIC SIGNALS & STREET LIGHTIN 16.315.00 2.475.33 13.839.67 12,608.33 2.436.31 10.172. 02
DISASTER PREPAREDNESS 103.130.00 11. 892 . 93 91. 237.07 59,513.44 14.520.40 44.993.04
FIRE SERVICES 9.253.613.00 136.418.19 9 . 117 .194 . 81 8.850.278.23 162.810.99 8.687.467.24
ACTI V ITY TOTAL 21. 888.607 00 543.404.25 21. 345 . 202 . 75 19,746.837.83 569.295.60 19.177.542.23
TRANSPORT A TI ON
PUBLIC WORKS 975.320.00 239.304.54 736.015.46 783.632.70 208,353.31 575.279.39
STREET MAINTENANCE 33.440.00 65.05 33.374.95 30.314.00 30.314.00
STREET SWEEPING 145.400.00 20.512.32 124,887.68 135,923.35 23.381. 79 112.541. 56
STREET TREE MAINTENANCE 103.529.00 15.946.41 87.582.59 119.576.15 21. 969 . 55 97.606.60
STREET LANDSCAPING MAINTENAN 800,168.00 11 0 . 383 . 46 689.784.54 709.557.73 118,804.63 590.753.10
ACTIVITY TOTAL 2.057.857.00 386.211.78 1.671.645.22 1. 779 . 003.93 372,509.28 1.406.494.65
HEALTH & WELFARE
WASTE MANAGEMENT 18.000.00 2.045.16 15,954.84 8,829.31 2.002.58 6.826.73
CHILD CARE 18.500.00 18.500.00 15.000.00 15.000.00
SOCIAL SERVICES 10.000.00 10.000.00
HOUSING PROGRAMS
7/-'
THE CITY OF DUBLIN STATEMENT SHOWING o~/::-
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2006 THROUGH 10/31/2006
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
ACT! V ITY TOTAL 46,500.00 20,54516 25.954.84 23,829,31 17,002.58 6,82673
CULTURE & LEISURE SERVICES
LIBRARY SERVICES 830,642.00 15,809.52 814,832.48 618,993.45 151.474.76 467,518.69
CULTURAL ACTIVITIES 265,457.00 84,556.40 180,900,60 233,515.51 99,532,43 133,983.08
HERITAGE CENTER 180,402.00 54,261.83 126,140.17 158,806.33 42,606,89 116,199.44
DUBLI N CEMETERY 49,06000 6,580.80 42,479.20 36,321. 70 4,777 .13 31. 544.57
PARK MAINTENANCE 1.846,074.00 259,293.93 1.586,780.07 1,390,353.67 258,557.38 1.131. 796,29
COMMUN ITY TV 67.591. 00 59,961. 00 7,630.00 63,060.91 58,985.58 4,075.33
RECREATION ADMIN 740,553.00 201. 968.42 538,584.58 686.496.76 197,327.56 489,169,20
PLAYGROUNDS 280.051.00 78,343.86 201,707.14 243,464.19 77,044.02 166,420.17
SHANNON CENTER 303,829.00 98,701.10 205,127.90 328,750.40 95,837.11 232,913,29
PRESCHOOL 121. 504.00 28,010.30 93,493.70 108,039.36 30.210,70 77,828.66
TEENS PROGRAM 150,581.00 38,216.06 112,364.94 143,225.92 36.652.28 106,573,64
ADULT SPORTS 136,873.00 27,168.87 109,704.13 83,918.06 25,879.98 58,038.08
YOUTH SPORTS 170,700,00 50,160.50 120,539.50 142,237.92 43,720,25 98,517.67
COMMUN ITY GYM 43,969.00 6,730.31 37,238.69 40,429.40 6 ,423,71 34.005.69
EMERALD GLEN ACTIVITY CENTER
SPECIAL EVENTS 369,636.00 109,156.73 260,479.27 377,607,25 153,497.49 224,109.76
SENIOR CENTER 485,216.00 121. 351. 59 363,864.41 421,034.20 115,966,85 305,067,35
RECREATION INSTRUCTION 189,41700 42,510.52 146,906.48 166,976.26 42,542.05 124,434.21
AQUA T! CS 446,642.00 128,594.02 318,047.98 411.688.61 136,187.00 275,501. 61
PARKS/FACILITIES MANAGEMENT 326,214.00 90,44918 235,76482 293,642.66 86,999.08 206,643.58
ACT! V ITY TOTAL 7,004.411.00 1. 501. 824,94 5,502,586.06 5,948,562.56 1,664,222.25 4,284,340,31
COMMUNITY DEVELOPMENT
PLANNING 2,920,013.00 560,652.15 2,359,360,85 2,218,620.09 651. 331. 65 1,567,288.44
BUILDING SAFETY 3,205,667.00 622,448.30 2,583,218,70 2,908,309.60 716,072.54 2,192,237.06
ENGINEERING 2,215.848.00 629,884.32 1. 585 , 963 68 2,380,371.77 545,711.49 1,834,660.28
ECONOMIC DEVELOPMENT 262,742.00 114,594.17 148,147,83 291.110.11 103.35807 187,752.04
ACTIVITY TOTAL 8,604,270.00 1.927,578.94 6,676,691.06 7,798,411.57 2,016,473,75 5,781. 937.82
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS 1.186,520.00 C 535.07) 1.187,055.07 606,778,83 62,386,79 544,392.04
COMMUNITY IMPROVEMENTS 261,044.00 1.400,70 259,643.30 780,954,81 288,423.78 492,531,03
PARKS 3,826,163.00 236,779,30 3,589,383.70 1. 037,007.51 437,902.17 599,105,34
STREET CONSTRC/IMPROVEMENTS 697,235.00 4,504.04 692,730.96 660.581.62 138,224.21 522,357.41
ACT! V ITY TOTAL 5,970,962.00 242,148.97 5,728,813.03 3,085,322.77 926,936.95 2,158.385.82
TOTAL EXPENDITURES 51.196,285.00 6,107,994.07 45,088,290.93 43,240.250.68 6,985,391. 37 36,254,859.31
EXCESS REVENUE (EXPENDITURES) (266,257.00) 2,679,385.40 (2.945.642,40) 3.040,035.81 1. 033,514.66 2,006,521.15
TRANSFERS IN FROM OTHER FUNDS 15.188.59 15,188,59
TRANSFERS OUT FROM OTHER FUNDS
REVENUES OVERCUNDER) EXPENDITURES C266,257.00) 2,679,385.40 (2,945,642.40) 3,055,224.40 1.033,514.66 2,021.709.74
THE CITY OF DUBLIN STATEMENT SHOWING &",", (
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2006 THROUGH 10/31/2006
S P E C I A L REV E N U E FUN D S
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
********REVENUES********
PROPERTY TAXES 119,960.00 119.960.00 115.763.98 115.763.98
SALES TAX/OTHER TAXES 426.421.00 70.291. 41 356.129.59 443.195.51 68.191. 68 375.003.83
FINES & FORFEITURES 177.000.00 52.234.27 124.765.73 190.869.24 27.601.10 163.268.14
USES/MONEY & PROPERTY 120.002.00 54.732.80 65.269.20 108.314.70 21. 083.99 87.230.71
INTERGOVERNMENTAL FROM STATE 1. 084 . 313.00 583.739.39 500.573.61 1. 094.513.46 345.650.33 748.863.13
INTERGOVERNMENTAL FROM COUNTY 370.913.00 39.253.30 331.659.70 355.919.00 38.110.00 317.809.00
INTERGOVERNMENTAL FROM FEDERAL 482.198.00 482.198.00 122.330.00 3.376.79 118.953.21
CHARGES FOR SERVICES 1. 462.058.00 1. 462.058.00 1.315.435.57 1.315.435.57
OTHER SOURCES OF REVENUE 29.000.00 29.000.00 420.867.00 420.867.00
TOTAL REVENUE 4.271.865.00 800.251.17 3.471.613.83 4.167.208.46 504.013.89 3.663.194.57
*******EXPENDITURES*******
PUBLl C SAFETY:
POll CE 103.710.00 103.710.00 105.670.43 105.670.43
TRAFFIC SIGNALS & STREET LTG 265.922.00 71.174.55 194.747.45 225.650.30 95.315.42 130.334.88
DISASTER PREPAREDNESS
FIRE SERVICES 276.97300 276.973.00 267.350.23 2.500.00 264.850.23
ACTI V ITY TOTAL 646.605.00 71.174 55 575.430.45 598.670.96 97.815.42 500.855.54
TRANSPORTATION:
STREET MAINTENANCE 379.294.00 32.053.01 347.240.99 335.939.86 29.657.63 306.282.23
STREET LANDSCAPE MAINTENANCE 5.822.00 5.822.00 4.823.96 4.823.96
ACTIVITY TOTAL 385.116.00 32.053.01 353.062.99 340.763.82 29.657.63 311.106.19
HEALTH & WELFARE:
WASTE MANAGEMENT 1.570.978.00 9.741.73 1. 561. 236.27 1.822.693.60 27.882.35 1. 794.811. 25
SOCIAL SERVICES 61. 804.00 406.12 61.397.88 60.427.00 35.233.93 25.193.07
HOUSING PROGRAMS
ACTI V ITY TOTAL 1. 632.782.00 10.147.85 1. 622 . 634 .15 1. 883 . 120 .60 63.116.28 1.820.004.32
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 17.581. 00 17.581.00 39.556.00 39.556.00
PARKS 136.587.00 75.525.71 61. 061. 29 50.349.43 50.349.43
STREET CONSTRUCTION/IMPROVEMENT 1 ,.204.569.00 23.771. 04 1.180.797.96 1.257.617.38 314.089.79 943.527.59
ACTIVITY TOTAL 1.358.737.00 99.296.75 1. 259.440.25 1.347.522.81 314.089.79 1. 033 . 433 . 02
TOT A L EXPENDITURES 4.029.24000 212.672.16 3.816.567.84 4.176.078.19 504.679.12 3.671.399.07
EXCESS REVENUE (EXPENDITURES) 242.625.00 587.579.01 (344.954.01) (8.869.73) (665.23) (8.204.50)
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS 21. 788.59 21. 788.59
REVENUES OVER (UNDER) EXPENDITURES 242.625.00 587.579.01 (344.954.01) (30.658.32) (665.23) (29.993.09)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2006 THROUGH 10/31/2006
,
,'!
10
S P E C I A LAS S E SSM E N T FUN D S
CURRENT
BUDGET
CURRENT
ACTUAL
VARIANCE
PR lOR
FISCAL YEAR
PRIOR
Y.T.D.
VARIANCE
********REVENUES********
SPECIAL BENEFITS ASSESSMENTS 737,494.00 737,494.00 645,230,59 645.230.59
USES/MONEY & PROP-INTEREST 17,13700 5,821.18 11. 315.82 17,139.71 3,123,59 14,016.12
OTHER SOURCES OF REVENUE 9,700.00 9,700,00 5.603.48 2,578.84 3,024,64
TOTAL REVENUE 764,331. 00 5,821.18 758,509,82 667.973.78 5,702.43 662,271,35
*******EXPENDITURES*******
PUBLIC SAFETY:
TRAFFIC SIGNALS & STREET LIG 319,000.00 81. 998.67 237,001.33 262,370,43 57,282.67 205,087,76
ACTI V ITY TOTAL 319,000,00 81. 998.67 237,001. 33 262.370.43 57,282.67 205,087,76
TRANSPORT A TI ON
PUBLIC WORKS 2,470.00 669,02 1. 800.98 2,095,50 452,75 1. 642,75
STREET TREE MAINTENANCE 31.173.00 4,704,93 26,468,07 19,407.11 3.624.38 15,782,73
STREET LANDSCAPE MAINTENANCE 404,790.00 46,203.85 358.586,15 329,352.28 47,919.64 281. 432.64
ACTIVITY TOTAL 438,433.00 51. 577 .80 386.855.20 350,854.89 51. 996.77 298,858.12
COMMUNITY DEVELOPMENT
ENGINEERING 13.100.00 358.50 12,741.50 11 ,357 .60 11,357.60
ACTI V ITY TOTAL 13,100.00 358.50 12,741.50 11,357.60 11,357,60
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS 18,106.69 86.79 18,019,90
STREET CONSTRUCTIONIIMPRVMNT 75,000.00 75,000.00
ACTIVITY TOTAL 93,106.69 86.79 93,019,90
TOT A L EXPENDITURES 770,533,00 133,934,97 636.598,03 717,689.61 120,723.83 596,965.78
EXCESS REVENUE (EXPENDITURES) (6,202.00) 028,113,79) 121,911,79 (49,715.83) (115.021.40) 65,305.57
REVENUES OVER (UNDER) EXPENDITURES (6,202.00) 028,113.79) 121,911.79 (49,715.83) 015,021. 40) 65.305.57
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2006 THROUGH 10/31/2006
lOr:
CAP I TAL IMP R 0 V E MEN T FUN D S
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
********REVENUE********
USES/MONEY & PROP-INTEREST 1.444.942.00 473.228.64 971.713.36 1. 286 .165 . 31 211.307.96 1.074.857.35
OTHER SOURCES OF REVENUE 21. 267.707.00 6,032,864.38 15.234.842.62 17,143.271.43 5,851. 051. 89 11,292,219.54
TOTAL REVENUE: 22,712,649.00 6,506,093.02 16.206.555.98 18.429.436.74 6,062,359.85 12,367,076.89
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 75,050.34 75,050.34
CITY ATTORNEY 52.250.00 15,237.06 37.012.94 56.509.63 5,774.40 50.735.23
ACTIVITY TOTAL 52,250.00 15,237.06 37,012.94 131,559.97 5.774.40 125,785.57
PUBLIC SAFETY:
TRANS PORTA TI ON:
HEALTH & WELFARE:
HOUSING PROGRAMS 804,070.00 80,948.94 723,121.06 327,654.70 76.859.24 250.795.46
ACTIVITY TOTAL 804.070.00 80,948.94 723,121.06 327,654.70 76,859.24 250.795.46
CULTURE & LEISURE SERVICES:
RECREATION ADMINISTRATION
ACTI V ITY TOTAL
COMMUNITY DEVELOPMENT
PLANNING
ACTI V ITY TOTAL
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS 29,120.00 16,751. 50 12.368.50 59.380.81 59,380.81
COMMUNITY IMPROVEMENTS
PARKS 1. 322 , 794.00 309,368 . 11 1.013.425.89 9.102,130.25 1. 732 . 345.92 7,369,784.33
STREET CONSTRUCTION/IMPROVEMENT 35,842,832.00 1.144,339.22 34,698,492.78 6,359,251.49 146.828.37 6.212.423.12
ACTI V ITY TOTAL 37,194,746.00 1.470,458.83 35,724,287.17 15,520,762.55 1.879.174.29 13.641. 588.26
TOT A L EXPENDITURES 38,051. 066.00 1. 566 , 644 . 83 36,484,421.17 15,979,977.22 1. 961. 807 . 93 14.018.169.29
EXCESS REVENUE (EXPENDITURES) 05,338,417.00) 4,939,448.19 (20,277,865.19) 2,456,059.52 4,100.551.92 (1.644.492.40)
TRANSFER IN FROM OTHER FUNDS 6,600.00 6.600.00
TRANSFERS OUT TO OTHER FUNDS
REVENUES OVER (UNDER) EXPENDITURES(15.338,417.00) 4,939.448.19 (20,277,865.19) 2,456,05952 4.100,551.92 (1.644.492.40)
THE CITY OF DUBLIN STATEMENT SHOWING l/o!l?
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2006 THROUGH 10/31/2006
T R U S T / AGE N C Y FUN D
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
********REVENUES********
SPECIAL ASSESSMENTS 242.044.14 242.044.14
USES/MONEY & PROP-INTEREST 1.719.81 0.719.81) 9.505.83 407.89 9.097.94
TOTAL REVENUE 1. 719.81 0.719 81) 251.549.97 407.89 251.142.08
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 230.503.00 187.007.50 43.495.50 231.731.25 182.873.75 48.857.50
ACTI V ITY TOTAL 230.503.00 187.007.50 43.495.50 231.731.25 182.873.75 48.857.50
PUBLI C SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS
TOT A L EXPENDITURES 230.503.00 187.007.50 43.495.50 231.731.25 182.873.75 48.857.50
EXCESS REVENUE (EXPENDITURES) (230.503.00) 085.287 69) (45.215.31) 19.818.72 082.465.86 ) 202.284.58
REVENUES OVER (UNDER) EXPENDITURES (230.503.00) 085.287.69) (45.215.31) 19.818.72 082.465.86 ) 202.284.58
/~{;/ -.,
,
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2006 THROUGH 10/31/2006
I N T ERN A L S E R V ICE FUN D S
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
********REVENUES********
USES/MONEY & PROP-INTEREST 407,294.00 119.090.73 288.203.27 267.035.82 49.629.49 217.406.33
CHARGES FOR SERVICES 1. 784.731. 00 447.715.01 1.337.015.99 1. 790,982.80 595,089.59 1.195,893: 21
OTHER SOURCES OF REVENUE 19,800.00 19,800.00 939,048.36 14,525.00 924.523.36
TOTAL REVENUE 2.211.825.00 566,80574 1. 645 , 019 . 26 2,997,066.98 659,244.08 2.337.822.90
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES
NON-DEPARTMENTAL 2,043.020.00 177 ,027 .87 1. 865.992.13 2.390.061. 37 146.696 .49 2,243,364.88
ACT! V ITY TOTAL 2,043,020.00 177 ,027 .87 1. 865.992.13 2.390,061. 37 146.696 .49 2.243,364.88
PUBLIC SAFETY:
FIRE 46,269.84 46,269.84
ACT! V ITY TOTAL 46,269,84 46.269.84
TRANS PORTA T! ON:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
TOT A L EXPENDITURES 2,043,020.00 177.027.87 1. 865 , 992 . 13 2,436,331.21 146,696.49 2,289,634.72
EXCESS REVENUE (EXPENDITURES) 168,805.00 389,777.87 (220,972 . 87) 560,735.77 512,547.59 48,188.18
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
REVENUES OVER (UNDER) EXPENDITURES 168.805.00 389.777.87 (220,972 . 87) 560.735.77 512,547.59 48,188.18
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2006 THROUGH 10/31/2006
E N T E R P R I S E
FUN D
CURRENT
BUDGET
CURRENT
ACTUAL
PRIOR
FISCAL YEAR
VARIANCE
********REVENUES********
USES/MONEY & PROP-INTEREST
TOTAL REVENUE
********EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 20.00 20.00
FINANCE
ACT! V lTY TOTAL 20.00 20.00
PUBLl C SAFETY:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
TOT A L EXPENDITURES 20.00 20.00
EXCESS REVENUE (EXPENDITURES) (20.00) (20.00)
TRANSFERS IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
REVENUES OVER (UNDER) EXPENDITURES (20.00) (20.00)
PRIOR
Y.T.D.
of
'';'
VARIANCE