HomeMy WebLinkAbout4.05 Financial Reports
CITY CLERK
File # D~~@]-[I]0
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: October 16, 2007
SUBJECT:
Preliminary Financial Reports for Fiscal Year 2006-2007
Report Prepared by: Paul S. Rankin, Administrative Services t~
Director and Vivian Gong, Finance Manager
ATTACHMENTS: 1. Revenues and Budget Comparison (Period Ending 06/30/07)
2. Expenditures and Budget Comparison (Period Ending 06/30/07)
. W. Preliminary Financial Statements (Period Ending 06/30/07)
RECOMMENDA nON: ~ Receive the reports.
FINANCIAL STATEMENT: See reports.
DESCRIPTION: This item provides the report on the preliminary financial statements for the Fiscal
Year Ended June 30, 2007. It is important to note that the annual financial audit has not been completed.
Consistent with prior years, any audit adjusting entries will be recorded and noted as part of the City's
Comprehensive Annual Financial Report to be presented later this year.
The financial analysis in this report focused on the General Fund, which is the most significant portion of
City revenue and expenditures.
Analvsis of June Revenue and Expenditure Reports
The June reports represent the reporting of revenues and expenditures for the entire Fiscal Year; Final
accruals have been made for all revenues and expenditures that may have been July or August
transactions, however, they related to Fiscal Year 2006/2007 activities. Given that there is a full year of
data available more detail is provided to explain deviations that are significant.
General Fund Revenues
Total General Fund Revenues collected through June 2007 were $53.4 million compared to $46.3 million
recorded in 200512006. As will be explained in the detailed explanation about interest revenue,
approximately $955,000 of the total revenue presented in the preliminary financial statements is an
unrealized gain on investments. Through June 2007, the City had collected approximately 106% of the
total budgeted General Fund Revenues, which includes the unrealized interest income.
Significant General Fund Estimated Revenue Variances
The Preliminary year end revenues in the General Fund exceeded the budget estimated by $ 2,937,000 or
6%. These results were a combination of deviations from both over and under the budget estimate. The
following section describes the fluctuation by major revenue type:
. Property Taxes: + $2,676,000 (15% QY!:.! budget estimate)
As reported in previous monthly reports this category was expected to exceed the budget. It was impacted
by increases in assessed values as well as the elimination of ERAF III. The final actual Property taxes
collected were $276,021 less than the amount estimated in June as part of the 2007/2008 Budget
preparation.
COPIES TO:
Page 10f5
ITEM NO. 1/5'
G:\Monthly Financials\FY 06-07\June 2007\June2007Vers2.doc
. Sales Taxes: - $1,148,000 (8% under budget estimate)
As previously reported total sales tax is expected to be below the budget estimate at year end. The
estimate presented in June as part of the 2007/08 Budget was $14,220,500. The final actual
revenue was very close to this amount at $14,135,424. The amount collected is less than
collections in 2005/06. The decrease reflected economic trends with retail sales and was impacted
by decreased sales in the automobile sector.
. RealPropertv Transfer Tax: - $115,000 (16% under budget estimate)
The Real Property Transfer Tax revenue trended below budget the entire year as a result of lower
than expected sales activities from both the residential and non residentfal properties. The final
collections of $596,533 were approximately $93,871 less than the revenue collected in Fiscal Year
2005/2006. The final amount collected was $76,533 more than the June 2007 estimate.
. Transient Occupancy Taxes: + $116,000 (17% over budget estimate)
Transient Occupancy Taxes are higher due to a higher than expected hotel occupancy and room
rates. The collection of$800,773 exceeded the amount collected last Fiscal Year by $73,161.
. Franchise Taxes: + $190,000 (10% over budget estimate)
As reported in previous monthly reports, Gas, Electric, Waste, and Cable TV franchise taxes have
trended above the level collected in 2006 due to higher consumption.
. Licenses and Permits: - $330,000 (11 % under budget estimate)
89 percent of the budget in this revenue category is for Building Permits. The remainder is
comprised of animal licenses, encroachment permits, demolition permits, business licenses and
fire permits. With the slow down in construction the trend particularly with Building Permits, has
been tracking throughout the year at a level below the Budget. This also reflects permits that may
have been obtained in the Spring of 2006, however, the construction activity occurred in
200612007. The final year end collections Were also less than the June 2007 Budget estimate by
approximately $222,463.
. Interest and Rental Revenues: +$1,724,000 (84% over budget estimate - prior to adjustment
for unrealized gain)
Attachment 1 shows a total of$3,773,698 combined revenue for this category. This is distorted by
mandatory adjustments to the Interest Revenue account, in order to comply with governmental
accounting rules. At year end the City must reflect the market value of its investments. On June
30, 2007 the fair market value of the investments was more than the book value resulting in an
unrealized gain of $954,528. On the attached financial statements this amount was recorded as
interest revenue. In the more detailed records a separate line item is used to segregate this entry.
The final balance sheet will contain a reserve of this amount since it does not represent funds that
can be expended. The City holds its investments until maturity and no gain was realized.
If the revenue were adjusted for this accounting entry the total revenue for this category would be
$2,819,170 or $769,482 more than the Budget. The City's overall rate of return on its investments
was higher than assumed in the budget estimate. In addition the City had more rentals of rental of
City facilities than expected in the budget. A portion of the rental revenue was also impacted due
to the purchase of the Dublin Square property for the City's Heritage Park. This parcel had tenants.
on the property who are paying rent prior to their relocation.
Page 2 of5
. Inten!overnmental: - $381,000 (25% under, budget estimate)
This category of revenue is below the budget ,primarily due to the timing of the Workforce
Housing Grant reimbursement for the Shannon Center Reconstruction. . The grant. is a
reimbursement as funds are expended. The construction completed as of June 30, did not allow
for the full amount budgeted to be claimed. Therefore, in 200712008 additional grant funds will be
received as the construction continues.
. Chan!es for Services: + $1,275,000 (19% QY!:.! budget estimate)
Consistent with previous monthly reports a significant portion of the change reflects a billing
adjustment for prior years Fire services provided to the Santa Rita facility. (+$719,903) In
addition, Jail Booking Fee Recovery was approximately $134,428 more than the budget due to the
receipt of State funding that was not expected when the budget was adopted. There are also
increases in Zoning and Subdivision fees, and Plan Check and Inspection fees amounting to
approximately 414,775 more than budgeted. The category was also positively impacted by
increased Parks and Community Services fees.
. Fines and Forfeitures: - $3,000 (2% under budget estimate)
Court Fines decreased by 31 % or $25,000 which was offset by the increases in Parking Fines and
penalties collected $21,853.
. Other Revenues: - $1,067,000 (53% under budget estimate)
Consistent with prior reports. The variance in this revenue category was primary due delays
associated with Capital Projects. This includes: a delay in the receipt of a utility underground
payment from AT&T. Approximately $258,335 will now be received in 2007/2008 for this work.
Also, the I-580/Fallon Road Interchange project has not begun construction, and therefore
reimbursements included in the Budget of approximately $670,000 will be received in a future
year after construction begins. The original budget estimated that $273,000 in revenue would be
received as part of work on St Patrick Way adjacent to the new BART station. The right-of way
transaction is now expected to take place between the two developers.
Significant General Fund Estimated Operating Expenditures Variances
The City's General Fund operating expenditures, excluding funds programmed for the Capital Projects,
were approximately $2,482,000 or 5.7% less than the budget estimate. The following breakdown
examines major areas of savings by Program:
. General Government: - $379,000 (6% under budget estimate)
Several factors contributed to budget savings in this category including a savings of salaries and
benefits as a result of vacancy in the Finance Manager position for several months; lower than
budgeted group insurance costs in the City Council program; Building Management incurred costs
below budget primarily due to less time required for facility set up; lighting maintenance savings
and savings in general building improvement projects; Savings in the InsuranceIRisk Management
program occurred in both the insurance premiums as well as the amount of claims paid; and
approximately $56,967 remained unspent in the Budgeted contingent reserve.
. Public Safety: - $668,000 (3% under budget estimate)
All three components of this program contributed to the savings (Police - $511 ,971; Fire -
$115,718; Other Public Safety $40,010). The budget savings in this category resulted primarily
from: salary and benefit savings as a result of vacancies and turnover among City Staff; lower than
anticipated expenditures for contract Alameda County Sheriff services and personnel; lower than
expected booking fees; a delay in the filling of a Disaster Preparedness contract position; contract
Fire Service costs were less than the budget primarily due to lower than budgeted personnel costs
and a savings due to a vacancy in the part-time fire inspection staffing.
Page 3 of5
. Transportation: - $93,000 (4% under budget estimate)
The savings in this category was primarily due to the lower than budgeted salaries and benefits
cost associated with vacancies and partial year expenses for added positions. Other savings
resulted in the Street Maintenance drainage maintenance activity and Street Sweeping.
. Health and Welfare: - $17,000 (30% under budget estimate)
Savings in Waste Management program were primarily due to savings in contract services. The
City Council had conditionally approved a $10,000 contribution to Eden INR for the establishment
of a 211 Social Service referral assistance. The conditions related to the participation by other
agencies were not met prior to June 30th. In July 2007, Eden did receive other funding
commitments, and this will be presented to the City Council for consideration as a carry-over
budget appropriation.
. Culture and Community Services: - $228,000 (3% under budget estimate)
Savings occurred in contract services for Library services, due to a delay in the beginning of Friday
operating hours. Park Maintenance had a savings of approximately $43,985 due to a delay in the
acceptance of the Dog Park and other maintenance savings including the performance of some
maintenance projects as volunteer Eagle Scout projects; Recreation and Cultural programs had
savings on part-time salaries; and a delay in completing improvement projects at the Heritage
Center (Visitation Area Audio Visual System). The Swim Center experienced a delay with the
installation of a replacement diving board. The improvement projects will be completed in the
current fiscal year.
. Community Development: - $1,097,000 (12% under budget estimate)
Savings in this category occurred due to: lower than expected expenditures for Salaries and
Benefits for the Planning, and Building division as a result of position vacancies; reduced Planning
contract services due to a delay in the schedule for the Downtown Specific Plan and the
Community Design Element projects; reduced contract Building Services due to a slow down in
the amount of new construction activity and applications;
General Fund Capital Project Expenditure Variances
The City's General Fund Capital Project Expenditures were approximately $4,499,000 or 57% less than
the amount budgeted. This variance represents a combination of timing differences on the completion of
these capital projects such as Shannon Center Reconstruction and the Heritage Park Acquisition. Also
some of the completed projects incurred expenditures below the project budget. Some of the unspent
funds have already been re-appropriated and accounted 'for in the adopted Fiscal Year 2007/2008 budget.
For projects that will be continuing those requiring a carryover appropriation are addressed as a separate
Agenda item.
Summary of the Year End Fund Balances for the General Fmid
In preparing the 2007/2008 Budget, Staff presented to the City Council projected results from the
200612007 Fiscal Year. These projections were used in order to plan for the designation and use of certain
unexpended funds as part of the 2007/2008 Budget. As presented in the 2007/2008 Budget Message,
several long term fiscal needs exist for the City.
In the 2007/2008 Budget Message Staff estimated a projected surplus for 2006-2007 of $8,409,041.
Based on the Preliminary Financial Statements, the General Fund surplus is estimated to be approximately
$7,685,804, prior to any carry-over of funds for incomplete projects. This is a difference of $723,237.
The presentation of year-end changes in fund balance will be reported as part of the Comprehensive
Annual Financial Report, which incorporates the annual Audit of the Financial Statements. The primary
Page 4 of5
reasons for the deviation from the initial projection was that General Fund Revenues were approximately
$895,000 less than projected and there were offsetting savings in the use of reserves and expenditures.
RECOMMENDATION
It is recommended. that the City Council receive these reports as authorized by Section 41004 of the
California Government Code.
Page 5 ~f5
City of Dublin 2006:-2007 YTn Revenues and Budget Comparison
T FQrJhePeriodEndingJune30,200~m
I I I !
Total General Fund Revenues 106%
100%1
Property Taxes
Sales Taxes
Real Property Transfer Tax
Transient Occupancy Taxes
Franchise Taxes
Licenses and Permits
Interest and Rentals
Intergovernmental from State
Charges for Servi~es
Fines and Forfeitures
Other Revenues
0%
120%
30%
60%
90%
100% of Year Complete
.1
I
I
I
I
I
I
I
I
I
I
I
I
I
!
1~/3
I
I
I
I
I
. FY 2006/0711
FY 2005/06
150%
m FY 2006/07 FY 2006/07 % of FY 2005/06 % of Total for
Budget YTO Actual Budget YTO Actual FY 2005/06
Property Taxes 17,470,288 20,146,743 115% 16,775,906 100%
Sales Taxes 15,283,000 14,135,424 92% 14,363,863 100%
Real Property Transfer Tax 712,000 596,533 84% 690,404 100%
Transient Occupancy Taxes 685,000 800,773 117% 727,612 100%
Franchise Taxes 1,921,000 2,111,281 110% 1,789,356 100%
Licenses and Permits 2,901,819 2,572,068 89% 3,142,223 100%
Interest and Rentals 2,049,688 3,773,698 184% 1,570,966 100%
Intergovernmental 1,530,976 1,149,759 75% 1,020,574 100%
Charges for Services 6,740,407 8,015,065 119% 5,774,669 100%
Fines and Forfeitures 143,560 140,235 98% 149,467 100%
Other Revenues 1,995,670 928,704 47% 275,245 100%
Total General Fund Revenues 51,433,408 54,370,283 106% 46,280,285 100%
I-tem* Lf'SI(No'1~
Date Printed: 9J28/2007 3:49 PM ATTACHMENT 1
100%
I
4Wo
100%
i
%
100%
i
,
II
II
I'
I
I
% I
i
100% !
i
07 o;f 13 I
I
I
I
I
i
I
I
I
I
I
I
I
I
II
. FY 2006/07 i I'
B FY 2005/06 I,
I
,
I
i
I
i
I
I
I
I
I
I
I
I
I
I
I
I
I
I
i
!
City of Dublin 2006-2007 YTD Expenses and Budget Comparison
For the Period Ending June 30,2007
Total General Fund
Expenses
General Government
~"~ . .",...:~ "'''''-'4:~\. ~f." 'c~" ._",~', 1.
I
I
Fire
,
, '
I
I
I
100%
I
Police
Other Public Safety
Transportation
Health and Welfare
Culture & Community
Services
Community
Development
Capital Improv.
Projects
0%
20%
40%
60%
80%
100%
120%
100% 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,859,046 5,480,365 94% 4,861,689 100%
Police 12,174,365 11,662,394 96% 10,519,026 100%
Fire 9,294,483 9,178,765 99% 8,896,548 100%
Other Public Safety 473,856 433,846 92% 377,533 100%
Transportation 2,097,102 2,003,668 96% 1,779,004 100%
Health and Welfare 57,575 40,555 70% 23,829 100%
Culture and Community Services 7,102,361 6,874,595 97% 5,948,563 100%
Community Development 8,795,963 7,698,894 88% 7,798,412 100%
Capital Improvement Projects 7,899,624 3,400,139 43% 3,085,323 100%
Total General Fund Expenses 53,754,375 46,773,221 ' 87% 43,289,927 100%
General Fund Operating Expenses 45,854,751 43,373,082 95% 40,204,604 100%
Date Printed: 912812007 3:48 PM
ATTACHMENT 2,
CITY OF DUBLIN'S
PRO FORMA FINANCIAL STATEMENTS
FOR
THE MONTH OF JUNE 2007
Prepared by
The Finance Departnlent
September 28, 2007
3~J3
ATTACHMENT 3
Lf~ )3
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 30Jun2007
GENERAL SPECIAL SPECIAL CAP IT AL TRUST/ TOTALS
REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY ---MEMORANDUM ONLY---
FUNDS FUNDS FUNDS FUNDS FUND CURRENT PRIOR
,
ASSETS
CASH (52.791.014) 4.792.487 627.016 37.204.182 219.887 (9.947.442) (9.996.616)
CASH WITH FISCAL AGENT 171.889 171.889 181. 893
AMOUNT HELD IN ESCROW 1. 692 . 262 1. 692 . 262 1. 762 . 000
INVESTMENTS AT COST 113.400.818 113.400.818 109.788.509
RECEIVABLES: TAXES
ACCOUNTS 3.862.911 384.207 4.496 315.056 4.566.671 4.556.446
INTEREST 1. 073.527 666 1.074.193 866.405
ASSESSMENTS
DUE FROM OTHERS 5.458.936 5.458.936 1.970.771
INVENTORY AT COST
PREPAID ITEMS 9.306 9.306 2.079
FIXED ASSETS
LOANS RECEIVABLE 6.723.334 6.723.334 8.345.396
AMOUNT TO BE PROVIDED 943.500 943.500 1. 083.500
TOTAL ASSETS 71.014.483 5.176.694 631.512 45.934.833 1. 335 . 942 124.093.465 118.560.382
LIABILITIES/FUND EQUITY
DEPOSITS FOR PRIVATE DEVEL (833.839) 06.860) (850.699) (877.512)
DEPOSITS FOR AB1600 FEES 0.010.229) O. 010 .229) (659.837)
DEPOS ITS OTHERS (597.649) (597.649) (2.322.126)
PAYABLES: ACCOUNTS 00 . 223 . 046) (749.869) (93.633) (819.146) 01. 885 . 694 ) (11.102.314)
INTEREST
PAYROLL (218.942) (218.942) 098.761)
DUE TO OTHERS (606.343) (97.419) 0.791. 762) (2.495.525) (2.285.710)
DEFERRED REVENUE 030.037) (2.473.334) (2.603.370) (2.494.352)
DEBT INSTRUMENTS PAYABLE (1. 061. 000) 0.061. 000) 0.201.000)
TOTAL LIABILITIES 02.609.855 ) (847.288) (93.633) (6.111.331) (1.061.000) (20,723.108) (21.141.612)
FUND BALANCES (58.404.628) (4,329.406) (537.879) (39.823.502) (274.942)(103.370.357) (97.418.770)
TOTAL FUND E (58.404.628) (4.329.406) (537.879) (39.823.502) (274.942)(103.370.357) (97.418.770)
TOTAL LIABILITIES/EQUITY (71.014.483) (5.176.694) (631. 512) (45.934.833) (1.335.942)(124.093.465)(118.560.382)
LIABILITIES/FUND EQUITY
DEPOSITS FOR PRIVATE DEVEL
DEPOSITS FOR AB1600 FEES
DEPOSITS OTHERS
PAYABLES: ACCOUNTS (27.652)
INTEREST
PAYROLL
DUE TO OTHERS
DEFERRED REVENUE
DEBT INSTRUMENTS PAYABLE (229.457)
TOTAL LIABILITIES (257.109)
FUND BALANCES (54.892.255)
TOTAL FUND E (54,892.255)
(351. 342.286)
(351. 342.286)
(27.652)
(31. 062)
(61.719.086)
(61.719.086)
(61.948.543) (62.838.532)
(61.976.195) (62.869.595)
(406.234.540)(397.644.149)
(406.234.540)(397.644,149)
TOTAL LIABILITIES/EQUITY (55.149.364)
(351.342.286) (61.719.086)
(468.210.735)(460.513.743)
THE CITY OF DUBLIN STATEMENT SHOWING r;, ~ 13
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2006 THROUGH 06/30/2007
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 17.470.288.00 20.146.742.78 (2.676.454.78) 16.775.905.94 16.775.905.94
SALES TAX 15.283.000.00 14.135.423.73 1.147.576.27 14.363.863.47 14.363.863.47
REAL PROPERTY TRANSFER TAX 712.000.00 596.532.87 115.467.13 690.404.35 690.404.35
HOTEL TRANSIENT OCCUPANCY TAX 685.000.00 800.772.57 015.772.57) 727.611.60 727.611.60
FRANCHISE TAXES 1. 921. 000 . 00 2.111. 281. 26 090.281. 26) 1.789.355.75 1.789.355.75
LICENSES & PERMITS 2.901.819.00 2.572.067.54 329.751.46 3.142.223.22 3.142.223.22
FINES & FORFEITURES 143.560.00 140.234.79 3.325.21 149.467.45 149.467.45
USE/MONEY & PROP-INTEREST 1. 864 . 164 . 00 3.575.137.21 0.710.973.21) 1.447.812.35 1.447.812.35
USE/MONEY & PROP-RENTALS 185.524.00 198.560.52 03.036.52 ) 123,154.10 123.154.10
INTERGOVERNMENTAL 1.530.976.00 1.149.759.30 381.216.70 1.020.574.22 1.020.574.22
CHARGES FOR SERVICES 6.740.407.00 8.015.064.77 0.274.657.77) 5.774.668.80 5,774.668.80
OTHER SOURCES OF REVENUE 1.995.670.00 928.704.12 1. 066 . 965 . 88 275.245.24 275,245.24
TOTAL REVENUE 51. 433.408.00 54.370.281. 46 (2.936.873.46) 46.280.286.49 46.280.286.49
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
CITY COUNCIL 362.356.00 320.924.20 41. 431. 80 246.713.83 246.713.83
CITY MANAGER 1. 045 .943.00 1. 042 . 480 . 01 3.462.99 960.957.13 960.957.13
CENTRAL SERVICES 454.214.00 438.786.38 15.427.62 429.560.48 429.560.48
CITY ATTORNEY 867.875.00 867.874.77 .23 623.049.58 623.049.58
ADMIN SERVICES 1. 731. 461. 00 1.593.027.81 138.433.19 1. 526 .107 .93 1. 526 .107.93
BUILDING MANAGEMENT 769.109.00 707.316.31 61. 792.69 709.411.15 -709.411.15
INSURANCE COST CENTER 534.659.00 474.542.39 60.116.61 353.414.23 353.414.23
ELECTIONS COST CENTER 26.603.00 25.554.79 1.048.21 2.244.10 2.244.10
NON-DEPARTMENTAL 66.826.00 9.858. 11 56.967.89 10.230.71 10.230.71
ACT! V ITY TOTAL 5.859.046.00 5.480.364.77 378.681. 23 4.861.689.14 4.861.689.14
PUBLIC SAFETY
POLICE 12.174.365.00 11.662.394.30 511.970.70 10.519.026.18 10.519.02618
CROSSING GUARDS 88.511.00 86.639.21 1. 871 .79 79.558.58 79.558.58
ANIMAL CONTROL 255.100.00 251.956.53 3 . 143 . 47 225.853.07 225.853.07
TRAFFIC SIGNALS & STREET LIGHTIN 16.315.00 15.424.08 890.92 12.608.33 12.608.33
DISASTER PREPAREDNESS 113.930.00 79.826.64 34.103.36 59.513,44 59.513.44
FIRE SERVICES 9.294,483.00 9.178.765.31 115 . 717 . 69 8.896.548.07 8 . 896 . 548 . O}
.ACT!VITY TOTAL 21. 942.704,00 21. 275.006.07 667.697.93 19.793.107.67 19.793.107.67
TRANSPORT A T! ON
PUBLIC WORKS 975.320.00 907.511.91 67.808.09 783.632.70 783.632.70
STREET MAINTENANCE 33.440.00 13.221. 64 20.218.36 30.314.00 30.314.00
STREET SWEEPING 145.400.00 139.992.31 5.407.69 135.923.35 135.923.35
STREET TREE MAINTENANCE 131.392.00 131.391.84 .16 119.576.15 119.576,15
STREET LANDSCAPING MAINTENAN 811.550.00 811.550.20 ( .20) 709.557.73 709.557.73
ACT! V ITY TOTAL 2.097.102.00 2.003.667.90 93.434.10 1. 779 . 003.93 1. 779 . 003.93
HEALTH & WELFARE
WASTE MANAGEMENT 29.075.00 22.055.21 7.019.79 8.829.31 8.829.31
CHILD CARE 18.500.00 18.500.00 15.000.00 15.000,00
SOCIAL SERVICES 10.000.00 10.000.00
HOUSING PROGRAMS
y~ )3
THE CITY OF DUBLIN STATEMENT SHOWING
.REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2006 THROUGH 06/30/2007
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
ACT! V ITY TOTAL 57.575.00 40.555.21 17.019.79 23.829.31 23.829.31
CULTURE & LEISURE SERVICES
LIBRARY SERVICES 832.317.00 809.628.89 22.688.11 618.993.45 618.993.45
CULTURAL ACTIVITIES 265.457.00 251. 944.51 13.512.49 233.515.51 233.515.51
HERITAGE CENTER 192.777 . 00 181.827.65 10.949.35 158.806.33 158.806,33
DUBLI N CEMETERY 49.060.00 43.942,65 5 . 117 . 35 36.321. 70 36.321. 70
PARK MAINTENANCE 1.852.674.00 1. 808.688.78 43.985.22 1.390.353.67 1. 390 . 353 .67
COMMUN ITY TV 132.591. 00 128.881. 00 3.710.00 63.060.91 63.060.91
RECREATION ADMIN 740.553.00 702.189.94 38.363.06 686.496.76 686.496.76
PLAYGROUNDS 280.851. 00 260.228.97 20.622.03 243.464.19 243.464.19
SHANNON CENTER 315.329.00 342.407.56 (27.078.56) 328.750.40 328.750.40
PRESCHOOL 121. 504.00 105.844.87 15.659.13 108.039.36 108.039.36
TEENS PROGRAM 150.581,00 135.910.40 14,670.60 143.225.92 143.225.92
ADULT SPORTS 136.873.00 106.532.29 30.340.71 83.918.06 83.918.06
YOUTH SPORTS 170.700.00 174.520.06 (3.820.06) 142.237,92 142.237.92
COMMUN ITY GYM 43.969.00 44.662.71 (693.71) 40.429.40 40.429.40
EMERALD GLEN ACTIVITY CENTER
SPECIAL EVENTS 369.636.00 354.952.30 14.683,70 377.607.25 377 .607.25
SENIOR CENTER 485.216.00 472.926.09 12.289.91 421. 034.20 421.034.20
RECREATION INSTRUCTION 189.417.00 198.529.01 (9.112.01) 166.976,26 166.976.26
AQUAT! CS 446.642.00 445.981.03 660.97 411.688.61 411. 688.61
PARKS/FACILITIES MANAGEMENT 326.214.00 304.996.60 21.217.40 293.642.66 293.642.66
ACT! V ITY TOTAL 7.102.361.00 6.874.595.31 227.765.69 5.948.562.56 5.948.562.56
COMMUNITY DEVELOPMENT
PLANNING 2.920.013.00 2.152.189 29 767.823.71 2.218.62009 2.218.620.09
BUILDING SAFETY 3.205.667.00 2.886.668.83 318.998.17 2.908.309.60 2.908.309.60
ENGINEERING 2.407.541.00 2.407.540.23 .77 2.380.371. 77 2.380.371.77
ECONOMIC DEVELOPMENT 262.742.00 252.495.57 10.246.43 291.110.11 291.110.11
ACT! V ITY TOTAL 8.795.963.00 7.698.893,92 1.097.069.08 7.798.411.57 7.798.411,57
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS 1.198.806.00 377 . 025.76 821.780.24 606.778.83 606.778.83
COMMUNITY IMPROVEMENTS 203.772.00 95.671. 93 108.100.07 780.954.81 780.954.81
PARKS 5.435.076.00 2.619.196.45 2.815.879.55 1. 037 . 007.51 1.037.007.51
STREET CONSTRC/IMPROVEMENTS 1. 061. 970.00 308.244.43 753.725.57 660.581.62 660.581.62
ACT! V ITY TOTAL 7.899.624,00 3.400.138.57 4.499.485.43 3.085.322.77 3.085.322.77
TOTAL EXPENDITURES 53.754.375.00 46.773.221. 75 6.981.153.25 43.289.926.95 43.289.926.95
EXCESS REVENUE (EXPENDITURES) (2.320.967,00) 7.597.059.71 (9.918.026.71) 2.990.359.54 2.990.359.54
TRANSFERS IN FROM OTHER FUNDS 59. 196 . 81 (59.196.81) 15.188.59 15.188.59
TRANSFERS OUT FROM OTHER FUNDS (23.505.65) 23.505.65
REVENUES OVER(UNDER) EXPENDITURES (2.320.967,00) 7,632.750.87 (9.953.717.87) 3.005.548.13 3.005.548.13
8~ r~
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2006 THROUGH 06/30/2007
S P E C I A L REV E N U E FUN D S
CURREN"!: CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
********REVENUES********
PROPERTY TAXES 119.960.00 119.472.73 487.27 115.763.98 115.763.98
SALES TAX/OTHER TAXES 426.421. 00 433.043.17 (6 . 622 . 17) 443.195.51 443,195.51
FINES & FORFEITURES 177.000.00 201.862.59 (24.862.59) 190,869.24 190.869.24
USES/MONEY & PROPERTY 120.002.00 194.816.32 (74.814.32) 108.314.70 108.314.70
INTERGOVERNMENTAL FROM STATE 1.084.313.00 1.172. 212.86 (87.899.86) 1.094.513.46 1.094.513.46
INTERGOVERNMENTAL FROM COUNTY 370.913.00 376.594.90 (5.681.90) 355.919.00 355.919.00
INTERGOVERNMENTAL FROM FEDERAL 482.198.00 144,868.47 337.329.53 122.330.00 122.330.00
CHARGES FOR SERVICES 1. 462.058.00 1. 430 . 805 . 72 31. 252 . 28 1. 315.435.57 1.315.435.57
OTHER SOURCES OF REVENUE 29.000.00 25.467.40 3.532.60 420.867.00 420.867.00
TOTAL REVENUE 4.271.865.00 4.099.144.16 172.720.84 4.167.208.46 4.167.208.46
*******EXPENDITURES*******
PUBLIC SAFETY:
POll CE 104.783.00 101. 780.53 3.002.47 105.670.43 105.670.43
TRAFFIC SIGNALS & STREET LTG 265,922.00 249.275.06 16.646.94 225.650.30 225.650.30
DISASTER PREPAREDNESS
FIRE SERVICES 276.973.00 196.755.84 80.217.16 267.350.23 267.350.23
ACTI V ITY TOTAL 647.678.00 547.811.43 99.866.57 598.670.96 598.670.96
TRANSPORTATION:
STREET MAINTENANCE 379.294.00 305.088.60 74.205.40 335.939.86 335.939.86
STREET LANDSCAPE MAINTENANCE 7.564.00 7.563,43 .57 4,823.96 4.823.96
ACTI V ITY TOTAL 386.858.00 312.652.03 74.205.97 340.763.82 340.763.82
HEALTH & WELFARE:
WASTE MANAGEMENT 1.575.838.00 1. 525 .606. 71 50.231. 29 1. 822 . 693.60 1. 822 . 693.60
SOCIAL SERVICES 61. 804.00 60.035.35 1. 768 . 65 60.427.00 60.427.00
HOUSING PROGRAMS
ACTI V ITY TOTAL 1. 637 .642 . 00 1. 585 . 642 . 06 51. 999.94 1. 883 .120,60 1. 883 .120 . 60
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.580.62 .38 39.556.00 39.55600
PARKS 134.845.00 132.238.71 2.606.29 50.349.43 50.349.43
STREET CONSTRUCTION/IMPROVEMENT 1. 204.569.00 726.185.12 478.383.88 1.257.617.38 1.257.617.38
ACTI V ITY TOTAL 1. 356 . 995 . 00 876.00445 480.990.55 1.347.522.81 1. 347 .522.81
TOT A L EXPENDITURES 4.035.173.00 3.328.109.97 707.063.03 4.176.078.19 4.176.078.19
EXCESS REVENUE (EXPENDITURES) 236.692.00 771.034.19 (534.342.19) (8.869.73) (8.869.73)
TRANSFER IN FROM OTHER FUNDS 0.097.00 ) 1. 097 .00
TRANSFERS OUT TO OTHER FUNDS 27.368.61 (27 .368 . 61) 21. 788.59 21. 788.59
REVENUES OVER (UNDER) EXPENDITURES 236.692.00 744,762.58 (508.070.58) (30.658.32) (30.658.32)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2006 THROUGH 06/30/2007
'S P E C I A LAS S E SSM E N T FUN D S
CURRENT
BUDGET
CURRENT
ACTUAL
PRIOR
FISCAL YEAR
PRIOR
. Y.T.D.
VARIANCE
********REVENUES********
SPECIAL BENEFITS ASSESSMENTS
USES/MONEY & PROP-INTEREST
OTHER SOURCES OF REVENUE
TOTAL REVENUE
737.494.00
17.137.00
9.700.00
764.331. 00
716.143.96
26.363.45
3.219.91
745.727.32
21. 350 . 04
(9.226.45)
6.480.09
18.603.68
645.230.59
17.139.71
5.603.48
667.973.78
645.230.59
17.139.71
5.603.48
667.973.78
*******EXPENDITURES*******
PUBLI C SAFETY:
TRAFFIC SIGNALS & STREET LIG 330.335.00 325.491. 81 4.843.19 262.370.43 262.370.43
ACTIVITY TOTAL 330.335,00 325.491.81 4.843.19 262.370.43 262.370.43
TRANSPORT A TI ON
PUBLIC WORKS 2.470.00 1. 640 . 07 829.93 2.095.50 2.095.50
STREET TREE MAINTENANCE 43.874.00 39.305.46 4.568,54 19.407.11 19.407.11
STREET LANDSCAPE MAINTENANCE 392.089.00 369.334.70 22.754.30 329.352.28 329.352.28
ACTI V ITY TOTAL 438.433.00 410.280.23 28.152.77 350.854.89 350.854.89
COMMUN ITY DEVELOPMENT
ENGINEERING 13.100.00 10.558.50 2.541.50 11.357.60 11. 357.60
ACTI V ITY TOTAL 13.100.00 10.558.50 2.541. 50 11.357.60 11.357.60
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS 18.106.69 18.106.69
STREET CONSTRUCTIONiIMPRVMNT 75.000.00 75.000.00
ACTI V ITY TOTAL 93.106.69 93.106.69
TOT A L EXPENDITURES 781. 868.00 746.330,54 35.537.46 717.689.61 717.689.61
EXCESS REVENUE (EXPENDITURES) (17 .537 . 00) (603.22) (16.933.78) (49.715.83) (49.715.83)
REVENUES OVER (UNDER) EXPENDITURES (17.537.00) (60322) 06.933.78) (49.715.83) (49.715.83)
1 oJ. /j
VARIANCE
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDJTURES
FOR THE PERIOD
07/01/2006 THROUGH 06/30/2007
CAP I TAL IMP R 0 V E MEN T FUN D S
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 78.785,62 (78.785.62) 75.050.34 75.050.34
CITY ATTORNEY 69.440.00 59.936.48 9.503.52 56.509.63 56.509.63
ACTI V ITY TOTAL 69.440.00 138.722.10 (69.282.10) 131. 559.97 131.559,97
PUBLI C SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
HOUSING PROGRAMS 864.070.00 458.257.23 405.812.77 327.654.70 327.654.70
ACT! V ITY TOTAL 864.070.00 458.257.23 405.812.77 327.654.70 327.654.70
CULTURE & LEISURE SERVICES:
RECREATION ADMINISTRATION
ACT! V ITY TOTAL
COMMUNITY DEVELOPMENT
PLANNING
ACT! V ITY TOTAL
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS 35.970.00 24.905.17 11. 064.83 59.380.81 59.380.81
COMMUNITY IMPROVEMENTS
PARKS 9.042.877.00 7.993,412.28 1. 049 .464 . 72 9.102.130.25 9.102.130.25
STREET CONSTRUCTION/IMPROVEMENT 33.106.780.00 4.497.678.86 28.609.101.14 5.109.251.49 5.109.251.49
ACT! V ITY TOTAL 42.185.627.00 12.515.996.31 29.669.630.69 14.270.762.55 14.270.762.55
TOT A L EXPENDITURES, 43.119.137.00 13.112.975.64 30.006.161. 36 14.729.977 ,22 14.729.977 .22
EXCESS REVENUE (EXPENDITURES) (20.406,488.00) (2.415.819.02)(17.990.668.98) 3.699.459.52 3.699.459.52
TRANSFER IN FROM OTHER FUNDS 30.105.65 (30.105.65) 6.600,00 6.600.00
TRANSFERS OUT TO OTHER FUNDS 39.525.20 (39.525.20)
REVENUES OVER (UNDER) EXPENDITURES(20.406,488.00) (2.425.238.57)(17.981.249.43) . 3.706.059.52 3.706.059.52
JO~ 13
THE CITY OF DUBLIN STATEMENT SHOWING ~ I 'i /3
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2006 THROUGH 06/30/2007
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 217.030.10 (217.030.10) 242.044.14 242.044.14
USES/MONEY & PROP-INTEREST 14.825.42 04.825.42) 9.505.83 9.505.83
TOTAL REVENUE 5.929.923.59 (5.929.923.59) 251.549.97 251.549.97
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 230.503.00 231.940.00 0.437.00) 231.731.25 231.731,25
ACTIVITY TOTAL 230.503.00 231.940.00 0.437.00) 231. 731. 25 231.731,25
PUBLI C SAFETY:
TRANS PORT AT ION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS
TOT A L EXPENDITURES 230.503.00 231.940.00 0.437.00) 231. 731. 25 231. 731. 25
EXCESS REVENUE (EXPENDITURES) (230.503.00) 5.697.983.59 (5.928.486.59) 19.818.72 19.818.72
REVENUES OVER (UNDER) EXPENDITURES (230.503.00) 5.697.983.59 (5.928.486.59) 19.818.72 19.81872
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2006 THROUGH 06/30/2007
1c11t3
I N T ERN A L S E R V ICE FUN D S
CURRENT CURRENT PR IOR PR IOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
********REVENUES********
USES/MONEY & PROP-INTEREST 407.294.00 477 .640. 72 (70.346.72) 267.035.82 267.035.82
CHARGES FOR SERVICES 1.784.731.00 1. 786.972 . 00 (2.241.00) 1. 790 . 982 . 80 1. 790 .982.80
OTHER SOURCES OF REVENUE 19.800.00 1.475.321.69 0.455.521.69) 939.048.36 939.048.36
TOTAL REVENUE 2.211.825.00 3.739.934.41 (1.528.109.41) 2.997.066.98 2.997.066.98
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES
NON-DEPARTMENTAL 2.043.020.00 11.474.930.13 (9.431. 910 .13) 2.908.427.37 2.908.427.37
ACTI V ITY TOTAL 2.043.020.00 11.474.930.13 (9.431.910.13) 2.908.427.37 2.908.427.37
PUBLIC SAFETY:
FIRE
ACTI V ITY TOTAL
TRANSPORTATION:
HEALTH & WELFARE,
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
TOT A L EXPENDITURES 2.043.020.00 11.474.930.13 (9.431.910.13) 2.908.427.37 r 908.427.37
EXCESS REVENUE (EXPENDITURES) 168.805.00 (7.734.995.72) 7.903.800.72 88.639.61 88.639.61
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
REVENUES OVER (UNDER) EXPENDITURES 168.805.00 (7.734.995.72) 7.903.800.72 88.639.61 88.639.61
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2006 THROUGH 06/30/2007
E N T E R P R I S E
FUN 0
CURRENT
BUDGET
CURRENT
ACTUAL
VARIANCE
PRIOR
FISCAL YEAR
********REVENUES********
USES/MONEY & PROP-INTEREST
TOTAL REVENUE
********EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 20.00 20.00
FINANCE
ACT! V!TY TOTAL 20.00 20.00
PUBLI 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.
J3 ~. L~
VARIANCE