HomeMy WebLinkAboutItem 4.16 Financial Rpt 4/2008
CITY CLERK
File # D~~~-l5J[0
AGENDA STATEMENT
CITY COUNCIL MEETING DATE: June 17, 2008
SUBJECT:
Financial Reports for the Month of April 2008
Report Prepared by: Paul S. Rankin, Administrative Services
Director and Vivian Gong, Finance Manager t,rl
ATTACHMENTS:
Period Ending April 30, 2008
a. YTD (Year To Date) Revenues and Budget Comparison
b. YTD Expenditures and Budget Comparison
c. April 30, 2008 Financial Statements
~
RECOMMENDA TIO~
FINANCIAL STATEMENT:
Receive the reports.
See reports for detail of monthly financial activity.
DESCRIPTION: This item provides the report on the preliminary financial statements for the month
of April 2008. 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.
Analysis of April 2008 Revenue and Expenditure Reports
The April report represents the reporting of revenues and expenditures for the ten months (83%) of the
Fiscal Year, (July 1, 2007 through April 30, 2008). 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 outside independent
contractors, including Police and Fire Services.
General Fund Revenues
The total percentage of General Fund Revenues collected through April was higher compared to what
occurred through the same period ofthe previous Fiscal Year. Through April 2008, the City had collected
approximately 82% of the total budgeted General Fund Revenues, which was 4% more than the
percentage collected in the same period of the prior Fiscal Year. Part of this increase is the result of
timing differences in the distribution of property tax revenues by Alameda County Auditor-Controller.
This Department had significant turnover and they have made efforts to release payments earlier than what
occurred in the prior Fiscal Year.
The following section of the report highlights significant deviations in terms of dollars collected in several
categories, compared to the same reporting period in the prior year.
As noted in previous monthly reports, the deviation in Sales Tax revenue is substantially attributable to
the reporting changes to accommodate audit requirements. If the sales tax collections were reported on
the same basis in both 2007 and 2008 the revenue collections to date would show a slight negative
variance of$45,462.
-------------------------------------------------------------------------------------------------------------
COPIES TO:
G:\Monthly Financials\FY 07-08\Apr 2008.doc
ITEM NO.
Lfllo
Page 10f3
or mounts o ecte uly- cpn vso uly - .pn
GENERAL FUND YTD YTD DIFFERENCE
REVENUE April 2008 April 2007 FY 07/08 More / EXPLANATION
(Less) FY 06-07
Property Tax 20,250,217 15,877,669 4,372,549 The increase is due to the general
increase in the assessed valuation of
property on the tax roll as well as a
timing difference. Alameda County
released $1.7 million in reconciling
payments in March 2008. In the prior
year the reconcilement payment did
not occur until May.
Sales Tax 10,663,584 12,080,954 (1,417,371) As noted above, the difference is
distorted due to a change in the
accounting for year end payments. If
the April 2007 amount was presented
on the same basis as the current year,
the amount for 2007 would have been
$ 10,709,045. This would result in a
negative variance of$45,462.
Real Property 339,378 389,353 (49,975) Fewer real estate transactions occurred
Transfer Tax in the current fiscal year.
Franchise Tax 1,765,424 1,625,063 140,360 Cable TV and waste franchise taxes
are above level collected in 2007 due
to the increases in number of
subscribers and customers.
----
Licenses and 1,432,821 2,174,941 (742,120) Consistent with previous reports, the
Permits deviation reflects the decline in
building permit activity.
Interest and 2,063,276 1,955,037 108,239 The difference is attributed to: 1) the
Rentals increases in recreation rentals/uses of
the City's facilities 2) the collection of
monthly tenant rents in connection
with the purchase of the Dublin Square
property, which was owned by the City
for only approximately 2 months in
FY 2006/07. These were partially
offset by a decrease of investment
~-- earnings of approximately $54,000.
Summary of Significant General Fund Revenue Differences
F A C II d J I A 01 2008 J I A 01 2007
Page 2 of3
GENERAL FUND YTD YTD DIFFERENCE
REVENUE April 2008 April 2007 FY 07/08 More I EXPLANATION
(Less) FY 06-07
Intergovernmental 685,212 229,131 456,080 A major factor in the difference is due
to one- time revenues such as 2007/08
Workforce Housing reimbursement
grant funds of approximately
$409,000. There is also a timing
difference in receipt of $88,400 for the
Home Owner Property Tax Relief.
The positive variances were offset by a
reduction in Vehicle License Fee
receipts, which were $63,000 less.
Charges for 4,954,306 6,549,450 (1,595,144) Significant decreases due to:
Services 1) Decreased development activity in:
Zoning and Subdivision Fees;
Engineering / Plan Check and
Inspection Fees; and Fire Plan Check
Fees. 2) The amount received in FY
2006/07 for Santa Rita Fire Services
was larger than normal since it
included payments for the prior fiscal
years. 3) Booking Fee revenue
decreased by approximately $132,600,
due to a change in State Law.
Other Revenues 641,997 884,545 (242,547) This category of revenue typically
includes payments such as
contributions, donations, or one time
reimbursements that may not occur
consistently from year to year.
General Fund Expenditures
Overall, through the month of April, expenditures in the General Fund totaled approximately $32.1
million and represented approximately 58% of the total budgeted expenditures in the General Fund. Of
this amount, a total of approximately $4.3 million was related to Capital Improvement Projects and the
remainder was related to Operating Costs. Capital Project expenditures typically do not follow an even
distribution due to differences in project timing.
A closer examination of only General Fund Operating Expenditures indicates that the activity through
April 2008 for all Program Areas was approximately $767,000 higher than the amount expended for the
same period in the prior Fiscal Year. Although there are both positive and negative variances, Program
Areas where expenditures for the period July - April were higher than in the previous Fiscal Year include:
contract Police and Fire services; Park Maintenance (addition of the Dougherty Hills Dog Park; Sports
field renovations; and increased utilities); additional support to Community Television; Recreation
Special Events (expanded Day on the Glen Event for 25th Anniversary); and Heritage Center
improvements and increased Staff time to support additional programs.
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 3 of3
Transient Occupancy Taxes
Total General Fund Revenues
Property Taxes
Sales Taxes
I_ FY 2007/08
. ~Y_~Q06!07
Real Property Transfer Tax
Franchise Taxes
Licenses and Permits
Interest and Rentals
Intergovernmental from State
Charges for Services
Fines and Forfeitures
Other Revenues
"95%
0%
30%
60%
90%
120%
150%
83% of Year Complete
-_.._---.-~------_._-- -----,- ---~------_..- ---- ---------- ___J
FY 2007/08 FY 2007/08 %of FY 2006/07 % of Total for
Budget YTD Actual Budget YTD Actual FY 2006/07
Property Taxes 22,194,200 20,250,217 91% 15,877,669 79%
Sales Taxes 14,390,000 10,663,584 74% 12,080,954 86%
Real Property Transfer Tax 540,000 339,378 63% 389,353 65%
Transient Occupancy Taxes 775,000 589,974 76% 588,194 73%
Franchise Taxes 2,095,635 1,765,424 84% 1,625,063 77%
Licenses and Permits 1,564,645 1,432,821 92% 2,174,941 85%
Interest and Rentals 2,387,671 2,063,276 86% 1,955,037 52%
Intergovernmental 1,049,669 685,212 65% 229,131 20%
Charges for Services 6,262,056 4,954,306 79% 6,549,450 82%
Fines and Forfeitures 143,000 122,740 86% 97,418 69%
Other Revenues 1,651,012 641,997 39% 884,545 95%
Total General Fund Revenues 53,052,888 43,508,928 82% 42,451,756 78%
4- +e-v.'\# 4" (~ hln Ire
Dale Printed: 5/8120084:32 PM ATTACHMENT 1
--~I3-
City of Dublin 2007-2008 YTD Expenses and Budget Comparison -
For the Period Ending April 30, 2008
83% of Year Complete
--- ---~---,_.--
2007/08 2007/08 %of FY 2006/07 % of Total for
Budget YTD Actual Budget YTD Actual FY 2006/07
General Government 5,844,224 4,028,969 69% 4,216,077 77%
Police 12,558,821 6,730,437 54% 5,830,153 50%
Fire 9,468,930 4,712,838 50% 4,597,620 50%
Other Public Safety 563,028 261,901 47% 181,449 42%
Transportation 2,239,419 1,348,461 60% 1,350,451 67%
Health and Welfare 52,004 40,721 78% 20,421 50%
Culture and Community Services 7,529,844 5,249,831 70% 4,802,667 70%
Community Development 8,218,211 5,438,370 66% 6,045,452 79%
Capital Improvement Projects 9,011,577 4,289,695 48% 1,753,564 52%
Total General Fund Expenses 55,486,058 32,101,222 58% 28,797,854 62%
General Fund Operating Expenses 46,474,481 27,811,528 60% 27,044,290 62%
Total General Fund
Expenses
General Government
Police
Fire
Other Public Safety
Transportation
Health and Welfare
I
I
7a%
Culture & Community
Services
Community
Development
Capital Improv.
Projects
0%
20%
40%
80%
60%
Date Printed 5/23/20081:51 PM
T-----I
. FY 2007/08
II FY 2006/07
100%
120%
ATTACHMENT 2
.3 (f)V / $
~
r-;
CITY OF DUBLIN'S
PRO FORMA FINANCIAL STATEMENTS
FOR
THE MONTH OF APRIL 2008
Prepared by
The Finance Department
May 8, 2008
ATTACHMENT 3
II Q-P /3
),"
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 30Apr2008
GENERAL SPECIAL SPECIAL CAPITAL TRUST I TOT A L S
REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY ---MEMORANDUM ONLY---
FUNDS FUNDS FUNDS FUNDS FUND CURRENT PRIOR
ASSETS
CASH (64.290,915) 5.894.544 797.140 50.746.758 321.756 (6.530.716) (12.218.047)
CASH WITH FISCAL AGENT 177.348 177.348 169.862
AMOUNT HELD IN ESCROW 12.458 12.458 1. 581. 500
INVESTMENTS AT COST 131,084.029 131.084.029 122.824.719
RECEIVABLES: TAXES
ACCOUNTS 106.525 106.525 1. 552.561
INTEREST 666.589 666.589 671. 287
ASSESSMENTS
DUE FROM OTHERS 5.113.616 5,113.616 1. 901. 086
INVENTORY AT COST
PREPAIO ITEMS 5.419 5.419 7,772
FIXED ASSETS
LOANS RECEIVABLE 5,117.250 5.117.250 6.750,316
AMOUNT TO BE PROVIDED 943.500 943.500 1. 083.500
TOTAL ASSETS 72,685.264 5.894.544 797.140 56,463.201 1. 442 . 604 137.282.753 124,324,556
LIABILITIESIFUND EQUITY
DEPOSITS FOR PRIVATE DEVEL (1.094.864 ) (16.860) (1.111.723) (690.721)
DEPOSITS FOR AB1600 FEES (9,4ll) (1.131. 732) (1.141.143) (978.093)
DEPOSITS OTHERS (451. 645) (451.645) (586,778)
PAYABLES: ACCOUNTS (408,298) (306.936) (151. 000) (866.234) (387.326)
INTEREST
PAYROLL (7.273) (7,273) (3.181)
DUE TO OTHERS (709,825) (1.791. 762) (2,501.587) (1.937.568)
DEFERRED REVENUE (243,606) (5.703.985) (5,947.592) (2.504.907)
DEBT INSTRUMENTS PAYABLE (1.061. 000) (1. 061. 000) (1,201. 000)
TOTAL LIABILITIES (2,924,921) (8.951.276) (1.212.000) (13.088.197) (8.289.573)
FUND BALANCES (69.760.343) (5.894.544) (797.140) (47.511.925) (230.604)(124.194.556) (97,418.770)
TOTAL FUND E (69.760,343) (5.894.544) (797.140) (47.511,925) (230,604)(124.194.556) (97,418,770)
TOTAL LIABILITIES/EQUITY (72.685,264) (5.894.544) (797.140) (56.463.201) (1.442,604)(137.282,753)(105,708.343)
CITY OF DUBLIN
BALANCE SHEET
FOR THE
PERIOD ENDING 30Apr2008
!5 ~ 13
INTERNAL
SERVICE
FUNDS
ENTERPRISE FIXED ASSETS GENERAL LONG
FUND GROUP OF TERM DEBT
ACCOUNTS ACCOUNT GROUP
TOT A L S
---MEMORANDUM---
CURRENT PRIOR
ASSETS
CASH 7.049.844 7.049.844 11.626.858
CASH WITH FISCAL AGENT
AMOUNT HELD IN ESCROW
INVESTMENTS AT COST
RECEIVABLES: TAXES
ACCOUNTS 37.584 37.584
INTEREST
ASSESSMENTS
DUE FROM OTHERS
INVENTORY AT COST
PREPAID ITEMS 3.966
FIXED ASSETS 48.289.121 351. 342 . 286 399.631. 407 387.888.144
LOANS RECEIVABLE
AMOUNT TO BE PROVIDED 61. 986.566 61.986.566 62,216.048
TOTAL ASSETS 55,376.548 351,342.286 61.986.566 468,705.400 461. 735.016
LIABILITIESIFUND EQUITY
DEPOSITS FOR PRIVATE DEVEL
DEPOSITS FOR AB1600 FEES
DEPOSITS OTHERS
PAYABLES: ACCOUNTS
INTEREST
PAYROLL
DUE TO OTHERS
DEFERRED REVENUE
DEBT INSTRUMENTS PAYABLE (19.879)
TOTAL LIABILITIES (19.879)
FUND BALANCES (55.356,670)
TOTAL FUND E (55.356,670)
(61.986.566)
(61. 986.566)
(62.006.445) (62.734.414)
(62.006.445) (62,734,414)
(406.698.955)(397.644.149)
(406.698.955)(397.644.149)
(351.342.286)
(351.342.286)
TOTAL LIABILITIESIEQUITY (55.376.548)
(351.342,286) (61.986.566)
(468.705.400)(460.378.562)
THE CITY OF DUBLIN STATEMENT SHOWING 0~ 13
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2007 THROUGH 04/30/2008
G ENE R A L REV E N U E FUN D
CURRENT CURRENT PR lOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
*******REVENUES*******
PROPERTY TAXES 22.194.200.00 20.250.217.35 1. 943 . 982 . 65 20.146.742.78 15.877.668.60 4.269.074.18
SALES TAX 14.390.000.00 10.663.583.50 3.726.416.50 14.025.868.73 12.080.954.13 1.944.914.60
REAL PROPERTY TRANSFER TAX 540.000.00 339.377.97 200.622.03 596.532.87 389.353.26 207.179.61
HOTEL TRANSIENT OCCUPANCY TAX 775.000.00 589.973.51 185.026.49 800.772.57 588.194.39 212.578.18
FRANCHISE TAXES 2.095.635.00 1. 765.423.52 330.211.48 2.111. 281. 26 1. 625 . 063 . 11 486.218.15
LICENSES & PERMITS 1. 564 . 645 . 00 1. 432 . 821. 26 131.823.74 2.572.067.54 2.174.941. 08 397.126.46
FINES & FORFEITURES 143.000.00 122.739.89 20.260.11 140.234.79 97.418.46 42.816.33
USEIMONEY & PROP-INTEREST 2.096.744.00 1.812.608.50 284.135.50 3.575.137.21 1. 851. 871. 41 1. 723.265.80
USEIMONEY & PROP-RENTALS 290.927.00 250.667.47 40.259.53 203.240.52 103.165.41 100.075.11
INTERGOVERNMENTAL 1.049.669.00 685.211.51 364.457.49 1.149.759.30 229.131. 24 920.628.06
CHARGES FOR SERVICES 6.262.056.00 4.954.306.42 1.307.749.58 8.015.064.77 6.549.450.25 1.465.614.52
OTHER SOURCES OF REVENUE 1. 651. 012.00 641.997.33 1.009.014.67 928.704.12 884.544.73 44.159.39
TOTAL REVENUE 53.052.888.00 43.508.928.23 9.543.959.77 54.265.406.46 42.451. 756.07 11.813.650.39
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
CITY COUNCIL 304.891.00 223.295.34 81. 595 . 66 320.924.20 273.394.37 47.529.83
CITY MANAGER 1.128.643.00 835.196.63 293.446.37 1. 042 . 480.01 828.587.66 213.892.35
CENTRAL SERVICES 573.400.00 363.154.34 210.245.66 438.786.38 321.060.22 117.726.16
CITY ATTORNEY 615.723.00 448.425.62 167.297.38 867.874.77 659.599.08 208.275.69
ADMIN SERVICES 1. 844.459.00 1.251.310.98 593.148.02 1.593.027.81 1.248.350.64 344.677.17
BUILDING MANAGEMENT 796.873.00 505.175.29 291.697.71 707.316.31 496.469.30 210.847.01
INSURANCE COST CENTER 538.541. 00 385.108.99 153.432.01 474.542.39 356.150.41 118.391. 98
ELECTIONS COST CENTER 2.500.00 977 .39 1. 522.61 25.554.79 25.554.79
NON-DEPARTMENTAL 39.194.00 16.324.87 22.869.13 9.858.11 6.910.59 2.947.52
ACTI V ITY TOTAL 5.844.224.00 4.028.969.45 1. 815 . 254.55 5.480.364.77 4.216.077.06 1. 264 . 287 . 71
PUBLIC SAFETY
POLI CE 12.558.821. 00 6.730.437.31 5.828.383.69 11.662.394.30 5.830.152.89 5.832.241.41
CROSSING GUARDS 98.648.00 65.063.70 33.584.30 86.639.21 58.591. 38 28.047.83
ANIMAL CONTROL 351.192.00 138.138.90 213.053.10 251.956.53 74.570.22 177.386.31
TRAFFIC SIGNALS & STREET LIGHTIN 13.300.00 8.204.66 5.095.34 15.424.08 11. 684.91 3.739.17
DISASTER PREPAREDNESS 99.888.00 50.493.60 49.394.40 79.826.64 36.602.02 43.224.62
FIRE SERVICES 9.468.930.00 4.712.837.81 4.756.092.19 9.178.765.31 4.597.619.99 4.581.145.32
ACTI V ITY TOTAL 22.590.779.00 11.705.175.98 10.885.603.02 21.275.006.07 10.609.221.41 10.665.784.66
TRANSPORT A TI ON
PUBLI C WORKS 1.094.762.00 733.164.40 361.597.60 907.511.91 703.903.57 203.608.34
STREET MAINTENANCE 33.147.00 397.40 32.749.60 13.221. 64 7.467.59 5.754.05
STREET SWEEPING 138.000.00 92.371. 61 45.628.39 139.992.31 95.605.89 44.386.42
STREET TREE MAINTENANCE 106.917.00 35.162.00 71. 755.00 131.391.84 35.617.29 95.774 . 55
STREET LANDSCAPING MAINTENAN 866.593.00 487.365.21 379.227.79 811.550.20 507.856.81 303.693.39
ACTIVITY TOTAL 2.239.419.00 1. 348 .460 .62 890.958.38 2.003.667.90 1. 350.451.15 653.216.75
HEALTH & WELFARE
WASTE MANAGEMENT 8.091. 00 7.390.58 700.42 22.055.21 1. 921. 25 20.133.96
THE CITY OF DUBLIN STATEMENT SHOWING I,I~
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2007 THROUGH 04/30/2008
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
CHILD CARE 18.500.00 14.393.48 4.106.52 18.500.00 18.500.00
SOCIAL SERVICES 25.413.00 18,936.52 6.476.48
HOUSING PROGRAMS
ACTI V ITY TOTAL 52.004.00 40.720.58 11.283 .42 40.555.21 20.421. 25 20.133.96
CULTURE & LEISURE SERVICES
LI BRARY SERV ICES 836.571.00 589.584.98 246,986.02 809.628.89 592.227.36 217,401. 53
CULTURAL ACTIVITIES 239.530.00 173,145.22 66.384.78 251. 944.51 176.044.84 75,899.67
HERITAGE CENTER 238.752.00 177,759.82 60.992.18 181. 827 .65 144.554.37 37,273.28
DUBLI N CEMETERY 48.458.00 23.488.21 24.969.79 43,942.65 24.528.49 19,414.16
PARK MAINTENANCE 2.016.692.00 1.243.243.52 773.448.48 1. 808,688.78 1. 000 . 940 . 30 807.748.48
COMMUNITY TV 127.980.00 116.214.54 11.765.46 128,881.00 60.921. 00 67,960.00
RECREATION ADMIN 759.339.00 566.743.39 192.595.61 702,189.94 562.589.11 139,600.83
PLAYGROUNDS 320.073.00 214.269.89 105.803.11 260.228.97 195.450.84 64.778.13
SHANNON CENTER 286.982.00 215,038.20 71.943.80 342.407.56 268.656.73 73.750.83
PRESCHOOL 115.643.00 86,803.89 28.839.11 105.844.87 80,049.29 25.795.58
TEENS PROGRAM 146.164.00 92,791. 63 53.372.37 135.910.40 102.940.35 32.97005
ADULT SPORTS 183.056.00 117.592.63 65.463.37 106.532.29 82.586.88 23.945.41
YOUTH SPORTS 204.177.00 167.139.88 37.037.12 174.520.06 144,009.18 30.510.88
COMMUNITY GYM 46.187.00 33,160.35 13.026.65 44.662.71 32,220.86 12.441. 85
EMERALD GLEN ACTIVITY CENTER
SPECIAL EVENTS 403.471.00 352.352.65 51.118.35 354.952.30 298.424.62 56,527.68
SENIOR CENTER 549.653.00 399.637.19 150.015.81 472.926.09 365.501. 61 107.424.48
RECREATION INSTRUCTION 209.545.00 139.803.42 69.741.58 198.529.01 141.131. 53 57.397.48
AQUATICS 467.488.00 293.222.48 174.265.52 445.981.03 290.940.40 155.040.63
PARKSIFACILITIES MANAGEMENT 330.083.00 247,839.09 82,243.91 304.996.60 238.949.52 66.047.08
ACTI V ITY TOTAL 7.529.844.00 5.249,830.98 2,280,013.02 6.874.595.31 4,802,667.28 2,071.928.03
COMMUNITY DEVELOPMENT
PLANNING 2.893.306.00 1. 809 .433 . 82 1. 083,872 .18 2.152,189.29 1.715.814.02 436.375.27
BUILDING SAFETY 2.708.274.00 1. 862.309.23 845 . 964 . 77 2.886.668.83 2.230.837.22 655.831. 61
ENGINEERING 2.321. 911.00 1. 590 .269.15 731.641.85 2.407.540.23 1.884,070.12 523.470.11
ECONOMIC DEVELOPMENT 294.720.00 176.357.75 118.362.25 252.495.57 214.730.60 37.764.97
ACTI V ITY TOTAL 8,218,211.00 5,438.369.95 2.779.841.05 7.698.893.92 6.045.451. 96 1. 653,441. 96
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS 1.561.994.00 267.139.45 1. 294 . 854 . 55 377.025.76 262.610.97 114.414.79
COMMUNITY IMPROVEMENTS 328.578.00 143.019.50 185.558.50 95.671. 93 25.970.10 69.701. 83
PARKS 5,976.648.00 3,833.223.63 2.143.424.37 2,619.196.45 1.169.468.00 1.449.728.45
STREET CONSTRC/IMPROVEMENTS 1,144.357.00 46.311.95 1. 098.045.05 308.244.43 295.515.29 12.729.14
ACTI V ITY TOTAL 9.011.577.00 4,289.694.53 4.721.882.47 3.400.138.57 1. 753.564.36 1.646.574.21
TOTAL EXPENDITURES 55.486.058.00 32.101. 222.09 23.384.835.91 46.773.221. 75 28.797.854.47 17,975.367.28
EXCESS REVENUE (EXPENDITURES) (2.433.170.00) 11.407.706.14 (13.840.876.14) 7.492.184.71 13.653.901. 60 (6,161.716.89)
TRANSFERS IN FROM OTHER FUNDS 52.883.57 (52.883.57) 59.196.81 39.525.20 19,671.61
TRANSFERS OUT FROM OTHER FUNDS (23.505.65) (23,505.65)
REVENUES OVER(UNDER) EXPENDITURES (2.433.170.00) 11,460.589.71 (13.893.759.71) 7.527.875.87 13,669,921.15 (6.142,045.28)
9 ~)3
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07101/2007 THROUGH 04/30/2008
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 125.760.00 119.716.70 6.043.30 119.472.73 97.674.60 21. 798 .13
SALES TAXIOTHER TAXES 460.862.00 305.193.37 155.668.63 433.043.17 288.138.44 144.904.73
FINES & FORFEITURES 195.000.00 148.376.41 46.623.59 201. 862.59 152.804.40 49.058.19
USESIMONEY & PROPERTY 216.249.00 162.365.50 53.883.50 194.816.32 148.639.50 46.176.82
INTERGOVERNMENTAL FROM STATE 1. 972 .487 . 00 1.440.098.80 532.388.20 1.174.710.84 978.582.48 196.128.36
INTERGOVERNMENTAL FROM COUNTY 397.023.00 235.563.55 161. 459.45 376.594.90 171. 013.60 205.581.30
INTERGOVERNMENTAL FROM FEDERAL 459.471.00 107.486.84 351.984.16 144.868.47 33.887.13 110.981. 34
CHARGES FOR SERVICES 1.513.762.00 1. 405.278.20 108.483.80 1. 430.805.72 1.172.140.43 258.665.29
OTHER SOURCES OF REVENUE 9.000.00 9.205.00 (205.00) 25.467.40 25.467.40
TOTAL REVENUE 5.349.614.00 3.933.284.37 1.416.329.63 4.101. 642 .14 3.068.347.98 1. 033.294.16
*******EXPENDITURES*******
PUBLIC SAFETY:
POLI CE 104.810.00 102.640.36 2.169.64 101.780.53 100.420.70 1. 359 . 83
TRAFFIC SIGNALS & STREET LTG 279.525.00 175.948.62 103.576.38 249.275.06 188.349.72 60.925.34
DISASTER PREPAREDNESS
FIRE SERVICES 287.483.00 147.500.85 139.982.15 196.755.84 178.880.86 17.874.98
ACTI V ITY TOTAL 671.818.00 426.089.83 245.728.17 547.811.43 467.651.28 80.160.15
TRANSPORT A TI ON:
STREET MAINTENANCE 398.986.00 161.922.67 237.063.33 305.088.60 142.491.68 162.596.92
STREET LANDSCAPE MAINTENANCE 6.038.00 6.038.00 7.563.43 13.198.43 (5.635.00)
ACTI V ITY TOTAL 405.024.00 161. 922.67 243.101.33 312.652.03 155.690.11 156.961. 92
HEALTH & WELFARE:
WASTE MANAGEMENT 1. 663 .490.00 821. 603.21 841.886.79 1.525.606.71 1. 481. 826.66 43.780.05
SOCIAL SERVICES 52.945.00 40.806.15 12.138.85 60.035.35 39.343.68 20.691. 67
HOUSING PROGRAMS
ACTI V ITY TOTAL 1.716.435.00 862.409.36 854.025.64 1.585.642.06 1. 521.170.34 64.471.72
COMMUNITY DEVELOPMENT:
ENGINEERING 6.000.00 2.472.00 3.528.00 6.000.00 6.000.00
ACTI V ITY TOTAL 6.000.00 2.472.00 3.528.00 6.000.00 6.000.00
CAPITAL IMPROVEMENT PROJECTS:
GENERAL CIP PROJECTS 10.853.00 10.853.00
COMMUNITY PROJECTS 17.580.62 17.580.62
PARKS 103.588.00 103.588.00 132.238.71 75.525.71 56.713.00
STREET CONSTRUCTIONIIMPROVEMENT 2.086.803.00 864.866.99 1. 221. 936.01 726.185.12 77.743.80 648.441. 32
ACTI V ITY TOTAL 2.201.244.00 864.866.99 1.336.377.01 876.004.45 153.269.51 722.734.94
TOT A L EXPENDITURES 5.000.521.00 2.317.760.85 2.682.760.15 3.328.109.97 2.303.781.24 1.024.328.73
EXCESS REVENUE (EXPENDITURES) 349.093.00 1.615.523.52 (1.266.430.52) 77 3 . 532 . 17 764.566.74 8.965.43
TRANSFER IN FROM OTHER FUNDS (1.097.00) 0.097.00)
TRANSFERS OUT TO OTHER FUNDS 52.883.57 (52.883.57) 27.368.61 1. 097 . 00 26.271.61
REVENUES OVER (UNDER) EXPENDITURES 349.093.00 1. 562 . 639 . 95 0.213.546.95) 747.260.56 764.566.74 07.306.18)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2007 THROUGH 04/30/2008
q ~(3
S P E C I A L ASS E SSM E N T FUN D S
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
********REVENUES********
SPECIAL 8ENEFITS ASSESSMENTS 785.567.00 720.660.31 64.906.69 716.143.96 583.715.23 132.428.73
USESIMONEY & PROP-INTEREST 26.106.00 20.477.85 5.628.15 26.363.45 17.512.42 8.851.03
OTHER SOURCES OF REVENUE 5.000.00 578.00 4.422.00 3.219.91 3.219.91
TOTAL REVENUE 816.673.00 741.716.16 74.956.84 745.727.32 604.447.56 141. 279.76
*******EXPENDITURES*******
PU8LIC SAFETY:
TRAFFIC SIGNALS & STREET LIG 376.400.00 225.512.04 150.887.96 325.491. 81 261.561.76 63.930.05
ACTI V ITY TOTAL 376.400.00 225.512.04 150.887.96 325.491. 81 261.561.76 63.930.05
TRANSPORTATION
PUBLI C WORKS 100.00 100.00 1.640.07 1. 597 . 54 42.53
STREET TREE MAINTENANCE 65.910.00 40.350.95 25.559.05 39.305.46 9.985.57 29.319.89
STREET LANDSCAPE MAINTENANCE 393.678.00 204.308.84 189.369.16 369.334.70 211.946.49 157.388.21
ACTI V ITY TOTAL 459.688.00 244.659.79 215.028.21 410.280.23 223.529.60 186.750.63
COMMUNITY DEVELOPMENT
ENGINEERING 15.500.00 12.282.94 3.217.06 10.558.50 358.50 10.200.00
ACTI V ITY TOTAL 15.500.00 12.282.94 3.217.06 10.558.50 358.50 10.200.00
CAPITAL IMPROVEMENT PROJECTS:
COMMUNITY IMPROVEMENTS
STREET CONSTRUCTION/IMPRVMNT
ACTIVITY TOTAL
TOT A L EXPENDITURES 851. 588.00 482 .454 . 77 369.133.23 746.330.54 485.449.86 260.880.68
EXCESS REVENUE (EXPENDITURES) (34.915.00) 259.261.39 (294.176.39) (603.22) 118.997.70 019.600.92)
REVENUES OVER (UNDER) EXPENDITURES (34.915.00) 259.261.39 (294.176.39) (603.22) 118.997.70 (119.600.92)
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2007 THROUGH 04/30/2008
IO~L3
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********
USESIMONEY & PROP-INTEREST 1.709.300.00 1.514.515.43 194.784.57 2,044.630.85 1.588.698.60 455.932.25
OTHER SOURCES OF REVENUE 17.447.972.00 19.689,188.60 (2.241.216.60) 8,652,525.77 6,725.488.45 1. 927 , 037 .32
TOTAL REVENUE: 19,157,272.00 21. 203.704.03 (2.046.432.03) 10.697.156.62 8.314.187.05 2.382,969.57
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 78,785.62 78.785.62
CITY ATTORNEY 49.400.00 117.761.40 (68.361. 40) 59,936.48 57.794.59 2.141. 89
ACTIVITY TOTAL 49,400.00 117.761.40 (68.361.40 ) 138.722.10 57.794.59 80.927.51
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
HOUSING PROGRAMS 3.994.884.00 732,768.66 3.262.115.34 458.257.23 256.289.55 201.967.68
ACTI V ITY TOTAL 3.994.884.00 732.768.66 3.262.115.34 458.257.23 256.289.55 201,967.68
CULTURE & LEISURE SERVICES:
RECREATION ADMINISTRATION
ACTI V ITY TOTAL
COMMUNITY DEVELOPMENT
PLANNING
ACTI V ITY TOTAL
CAPITAL IMPROVEMENT PROJECTS
GENERAL CIP PROJECTS 195.550.00 195.550.00 24.905.17 16.751. 50 8,153.67
COMMUNITY IMPROVEMENTS 250.000.00 250.000.00
PARKS 8.242.583.00 1,404.396.65 6.838.186.35 7,993.412.28 371.678.54 7.621.733.74
STREET CONSTRUCTIONIIMPROVEMENT 30.119.579.00 7,010.354.06 23.109.224.94 4.497.678.86 3.488.269.18 1. 009 .409 . 68
ACTI V ITY TOTAL 38.807.712.00 8,414,750.71 30.392.961. 29 12.515.996.31 3.876.699.22 8,639.297.09
TOT A L EXPENDITURES 42.851. 996.00 9.265.280.77 33.586.715.23 13.112.975.64 4,190,783.36 8.922,192.28
EXCESS REVENUE (EXPENDITURES) (23.694.724.00) 11.938,423.26 (35.633.147.26) (2.415.819.02) 4.123.403.69 (6.539.222.71)
TRANSFER IN FROM OTHER FUNDS 30,105.65 23.505.65 6,600.00
TRANSFERS OUT TO OTHER FUNDS 39.525.20 39.525.20
REVENUES OVER (UNDER) EXPENDITURES(23.694.724.00) 11.938,423.26 (35,633.147.26) (2.425.238.57) 4.107.384.14 (6,532.622.71)
THE CITY OF DUBLIN STATEMENT SHOWING 1)~/3
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07101/2007 THROUGH 04/30/2008
T R U S T / AGE N C Y FUN 0
CURRENT CURRENT PRIOR PRIOR
BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE
********REVENUES********
SPECIAL ASSESSMENTS 178.404.03 (178.404.03) 217.030.10 174.662.43 42.367.67
USESIMONEY & PROP-INTEREST 85.290.65 (85.290.65) 14.825.42 9.695.20 5.130.22
TOTAL REVENUE 682.698.84 (682.698.84) 5.929.923.59 184.357.63 5.745.565.96
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL 236 .1l5. 03 (236.115.03) 231.940.00 229.015.00 2.925.00
ACTI V!TY TOTAL 403.340.26 (403.340.26) 231.940.00 229.015.00 2.925.00
PUBLIC SAFETY:
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES:
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS
TOT A L EXPENDITURES 403.340.26 (403.340.26) 231.940.00 229.015.00 2.925.00
EXCESS REVENUE (EXPENDITURES) 279.358.58 (279.358.58) 5.697,983.59 (44.657.37) 5.742.640.96
REVENUES OVER (UNDER) EXPENDITURES 279.358.58 (279.358.58) 5.697.983.59 (44.657.37) 5.742.640.96
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07101/2007 THROUGH 04/30/2008
v~ /3
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********
USESIMONEY & PROP-INTEREST 214.192.00 250.600.66 (36.408.66) 477.640.72 358.963.83 118.676.89
CHARGES FOR SERVICES 1.682.057.00 1.618,916.30 63.140.70 1.786,972.00 1. 486,223.80 300.748.20
OTHER SOURCES OF REVENUE 22.800.00 199.440.43 (176,640.43) 1. 475,321. 69 10,046.58 1.465.275.11
TOTAL REVENUE 1.919,049.00 2.068.957.39 (149.908.39) 3.739.934.41 1. 855 . 234 . 21 1. 884.700.20
*******EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES
NON-DEPARTMENTAL 3.787.454.00 988.882.80 2,798.571.20 11,472,708.13 498,780.91 10.973,927.22
ACTI V ITY TOTAL 3,787,454.00 988.882.80 2,798.571.20 11,472,708.13 498.780.91 10.973,927.22
PUBLIC SAFETY:
FIRE
ACTI V ITY TOTAL
TRANSPORTATION:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
TOT A L EXPENDITURES 3.787.454.00 988.882.80 2.798.571.20 11.472,708.13 498.780.91 10.973.927.22
EXCESS REVENUE (EXPENDITURES) (1,868.405.00) 1.080,074.59 (2.948.479.59) (7.732.773.72) 1,356,453.30 (9.089,227.02)
TRANSFER IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
REVENUES OVER (UNDER) EXPENDITURES (1,868.405.00) 1.080,074.59 (2.948.479.59) (7,732,773.72) 1,356,453.30 (9.089.227.02)
********REVENUES********
USESIMONEY & PROP-INTEREST
TOTAL REVENUE
********EXPENDITURES*******
GENERAL GOVERNMENT ACTIVITIES:
NON-DEPARTMENTAL
FINANCE
ACTI V ITY TOTAL
PUBLIC SAFETY:
HEALTH & WELFARE:
CULTURE & LEISURE SERVICES
COMMUNITY DEVELOPMENT:
CAPITAL IMPROVEMENT PROJECTS:
TOT A L EXPENDITURES
EXCESS REVENUE (EXPENDITURES)
TRANSFERS IN FROM OTHER FUNDS
TRANSFERS OUT TO OTHER FUNDS
REVENUES OVER (UNDER) EXPENDITURES
CURRENT
BUDGET
THE CITY OF DUBLIN STATEMENT SHOWING
REVENUES VERSUS EXPENDITURES
FOR THE PERIOD
07/01/2007 THROUGH 04/30/2008
E N T E R P R I S E
FUN D
CURRENT
ACTUAL
VARIANCE
PRIOR
FISCAL YEAR
PRIOR
Y.T.D.
13~ 13
VARIANCE