HomeMy WebLinkAboutItem 4.04 Qty Financial Rpt~~~~ OF Dp~~~~
~
19~~~~~~ STAFF REPORT C I T Y C L E R K
~~c~~,,~~ ~ DUBLIN CITY COUNCIL File #^ 3^ 3~ OO-0~
DATE: November 16, 2010
TO: Honorable Mayor and City Council Members
FROM: Joni Pattillo, City Manager
SUBJE T• Quarterly Financial Report for The Period Ending September 30, 2010 (First
Quarter Fiscal Year 2010-2011)
Prepared By: Vivian Gong, Finance Manager
EXECUTIVE SUMMARY:
The City Council will be presented with preliminary information related to the revenues and
expenditures through the end of the first quarter of Fiscal Year 2010-2011. Based on the
completion of three months of activity the report will include analysis of significant trends and
variances between budgets and actual expenditures.
FINANCIAL IMPACT:
Detailed financial information can be found within the Staff Report and the Attachments.
RECOMMENDATION:
Receive the reports as authorized by Section 41004 of the California Government Code.
~~~a~;:~'~~
Submitted By:
Administrative Services Director
DESCRIPTION:
/~, _ "
Review By:
Assistant ity Manager
This item provides the report on the preliminary financial statements for the first quarter which
includes the months of July, August, and September 2010. 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.
Page 1 of 5 ITEM NO. ~• ~
/'
Contents of Reports
The Quarterly Report is broken into four components to provide a breakdown of information.
The components are:
• Attachment 1 General Fund Year To Date Revenues and Budget Comparisons (The
report also includes a graphic comparison of actual revenue collected compared to the
same period in the previous year. The report is broken down into Major Revenue Types.)
• Attachment 2 General Fund Year To Date Expenditures and Budget Comparisons (The
report also includes a graphic comparison of actual expenditures compared to the same
period in the previous year. The report is broken down into Major Program Types with
segregated information for Police and Fire Services.)
• Attachment 3 Comparison of Revenue Versus Expenditures - By Fund Type (The report
provides budget to actual comparisons for the current Fiscal Year as well as information
for the same period in the previous Fiscal Year. The information is arranged by Fund
Type: General Fund; Special Revenue Fund; Assessment District Funds; Agency Trust
Funds; and Internal Service Funds.)
• Attachment 4 Monthlv Fund Balances (The report presented is as of the end of the
quarter and it provides fund balance information as well as revenues and expenditures to
date as required in Government Code Section 41004. The first page is a high level
summary followed by additional detail for each fund.)
The first quarter represents 25% of the Fiscal Year. It should 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 some expenditures due to the significant amount of services provided to the City by
outside independent contractors, including Police and Fire Services. These services are billed
to the City on a quarterly or bi-monthly basis and therefore, expenditures incurred during the
first several months may be incomplete until the billing is received and recorded.
General Fund Revenues
As shown in Attachment 1, the total General Fund Revenues collected through September 2010
represented 12% of the current budget. Although the number does not track according to the
percentage of year completion, it is consistent with the collection in the first three months of the
previous Fiscal Year in which the City also collected 11 % of its total General Fund revenue.
There were deviations in terms of dollars collected in several categories and the following Table
summarizes some of the more significant deviations compared to the same reporting period in
the prior year.
In order to place the year to date trends in context this Table also includes: the Current Year
Budget, Prior Fiscal Year Total and the Difference. This helps to provide context to the most
recent trends. This will also help to identify items where a decrease in year to date collections
may be consistent with the adopted Fiscal Year 2010/2011 Budget and Financial Plan.
Page 2 of 5
Summary of Significant General Fund Revenue Differences
For Amounts Collected July - September 2010 vs. July - September 2009
REVENUE YTD YTD DIFFERENCE
September September FY 2010/11 EXPLANATION
2010 2009 More / (Less)
FY 2009/10
Property $ 919,994 $ 925,797 ($ 5,803) The majority of the taxes collected to date
Tax represent the collection of unsecured
property tax. Unsecured Tax is typically
paid in a single installment due in
September. The 2010/2011 Budget
anticipates a reduction in the secured
property taxes. The City normally receives
ANNUAL ACTUAL the first allocation for secured property tax
BUDGET PRIOR YR DIFFERENCE in December.
$21,386,000 $22,141,004 ($ 755,004)
Sales Tax/ $1,899,051 $2,097,623 ($ 198,572) It is important to note that there is a
In-Lieu significant lag in sales tax data. The
Sales Tax reported revenue as of September only
includes advances based on State
estimates. The reconciling payment for
first quarter is not received until December.
Staff monitors detailed sales tax data with
the City's Consultant as it becomes
available.
ANNUAL ACTUAL
BUDGET PRIOR YR DIFFERENCE
$11,885,680 $12,183,267 ($ 297,587)
Transient $ 70,807 $64,458 $6,349 With local hotels completing renovations
Occupancy additional rooms are available and a small
Taxes increase in occupancy rates. There has
been some growth in this revenue
subsequent to the analysis used for the
preparation of the Fiscal Year 2010/2011
ANNUAL ACTUAL Budget. More data is needed before
BUDGET PRIOR YR DIFFERENCE determining the e~ctent of the impact on the
$500,000 $557,000 ($57,000) budget.
License $650,795 $435,292 $215,503 The primary difference in this category is
and related to increased building permit
Permits activity. Permits for a total of 77 new
residential units were issued in July -
ANNUAL ACTUAL September 2010 compared to only 18 in
BUDGET PRIOR YR DIFFERENCE the same period of the previous year. As '
$1,516,980 $2,260,365 ($743,385) part of the development projections Staff
, will be monitoring whether the increase is
only a timing difference of when expected
ermits were obtained.
Page 3 of 5
REVENUE YTD YTD DIFFERENCE
September September FY 2010/11 EXPLANATION
2010 2009 More / (Less)
FY 2009/10
Charge for $ 915,319 $ 853,196 $ 62,123 The deviation in this revenue category is
Services comprised of both positive and negative
deviations: Among the positive variances
is 1) A$10,089 increase in Police Services
Charges primarily due to increased
number of vehicle releases processed and
an increase in DUI Response costs
recovered. 2) An increase in Waste
Management Fees of $11,429 as a result
of the amended agreement with AVI
approved by the City Council June 1,
2010. 3) Approximately $101,290 in
Development Services primarily related to
Engineering Plan Check and Inspection.
There was also a change in the accounting
for Building Permit Fees that are
transmitted to third parties which partially
offset some of the gains. The increases in
this Charges For Services were partially
offset by decreases in the following major
revenue: 1) The Heritage and Cultural Arts
results are down approximately $4,339,
comprised of increases in program
revenue offset by a larger decrease in the
Community Events / Festivals line item.
Recreation and Community Services
currently show a decrease of $55,930.
ANNUAL ACTUAL This is due to a timing difference in the
BUDGET PRIOR YR DIFFERENCE recording of deferred revenue and a
$4,376,170 $5,327,968 ($951,798) positive variance is expected when the
next uarterl re orts are re ared.
Other $236,028 $ 68,950 $167,078 The variance is primarily related to a
Revenue payment for the sale of excess right-of way
on Scarlett Court that was processed in
the current year for $166,667.
ANNUAL ACTUAL
BUDGET PRIOR YR DIFFERENCE
$569,200 $1,635,316 ($1,066,116)
General Fund Expenditures
Overall, through the month of September 2010, expenditures in the General Fund totaled
approximately $4.5 million and represented approximately 9% of the total budgeted
expenditures in the General Fund (Attachment 2). Of this amount, a total of $172,762 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.
Page 4 of 5
An examination of only the General Fund Operating Expenditures (Attachment 2) indicates that
through September 2010, expenditures totaled 10% of the Budgeted General Fund expenses,
which was the same percentage incurred in the previous year. The total amount of General
Fund Operating expenditures for all Departments in the first three months of Fiscal Year 2010-
2011, were approximately $97,610 lower than the amounts expended for the same period in the
prior Fiscal Year. This variance reflects a combination of increases and decreases when
compared to the prior Fiscal Year. The largest variance is in Culture and Community Services
however the difference is primarily due to a timing difference in Park Maintenance contract
services and one time park or facility maintenance projects that occurred in 2009. There is also
a year to year variance with Community Development which primarily reflects contract services
related to development processing. 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.
NOTICING REQUIREMENTS/PUBLIC OUTREACH:
None
ATTACHMENTS:
Attachment 1- General Fund Year To Date Revenues and Budget Comparisons
Attachment 2- General Fund Year To Date Expenditures and Budget Comparisons
Attachment 3- Comparison of Revenue Versus Expenditures - By Fund Type
Attachment 4- Monthly Fund Balances - For the Period Ending September 30, 2010
Page 5 of 5
i~
FY 2010/11 FY 2010/11 % of FY 2009/10
Budget YTD Actual Budget YTD Actual
Property Taxes 21,386,000 919,994 4% 925,797
Sales Taxes 11,885,680 1,899,051 16% 2,097,623
Real Property Transfer Tax 290,000 53,512 18% 73,325
Transient Occupancy Taxes 500,000 70,807 14% 64,458
Franchise Taxes 2,667,500 106,176 4% 154,253
Licenses and Permits 1,516,980 650,795 43% 435,292
Fines & Penalties 131,540 20,354 15% 27,962
Interest & Rentals 1,432,534 351,328 25% 482,440
Intergovernmental 430,200 24,194 6% 37,320
Charges for Services 4,376,170 915,349 21% 853,196
Other Revenues 569,200 236,028 41 % 68,950
Total General Fund Revenues 45,185,804 5,247,588 12% 5,220,616
Date P~inted'. 10292010 1.39 PM
% of Total for
FY 2009/10
4%
17%
20%
12%
7%
19%
19%
25%
7%
16%
4%
11%
yy i~-~~-i~
ATTACHMENT 1
City of Dublin 2010-2011 YTD Expenses and Budget Comparison
For the Period Ending September 30, 2010
Total General Fund
Expenses
CIP Projects
Community
Development
Culture & Community
Services
Health and Welfare
Transportation
15%
I19°/a
Other Public Safety "~o~o
General Government
0%
19%
21%
-~
20% 40% 60% 80%
25% of Year Complete
^ FY 2010/11
FY 2009/10
100% 120%
FY 2010/11 FY 2010/11 % of FY 2009/10 % of Total for
Budget YTD Actual Budget YTD Actual FY 2009/10
General Government 6,309,220 1,198,240 19% 1,207,469 21%
Police 12,868,710 259,161 2% 300,427 2°/a
Fire 10,451,170 89,668 1% 112,613 1%
Other Public Safety 831,220 17,249 2% 34,344 7%
Transportation 1,896,210 289,046 15% 341,194 19%
Health and Welfare 115,430 46,288 40% 3,486 5%
Culture and Community Services 7,616,999 1,316,437 17% 1,481,898 20%
Community Development 5,077,440 1,117,302 22% 949,570 18%
CIP Projects 2,670,009 _ 172,762 6% 788,492 12%
Total General Fund Expenses 47,836,408 4,506,153 9% 5,219,493 11%
General Fund Operating Expenses 45,166,399 4,333,391 10% 4,431,001 10%
oa~eP~~~,=d,o,29,2o,o,3sPM ATTACHMENT 2
3 ~~ ~ %~
CtTY OF DUBLIN
PRO FORMA
COMPARISON OF REVENUE VERSUS EXPENDITURES
(By Fund Type)
FISCAL YEAR 2010-2011
FOR THE PERIOD ENDING SEPTEMBER 30, 2010 (Quarter 1)
~. ~~ DU~
ti~ ~~
~ ~ ~
//! ~ ~ 111
19 ~" ~' - -~ 8~
1
~
~~~I~ R~~~
O
Prepared by
The Finance Department
October 29, 2010
• General Fund - Comparison of Revenue & Expenditures 7/1/2010 - 9/30/2010
• Special Revenue Funds - Comparison Revenue & Expenditures 7/1/2010 - 9/30/2010
• Assessment District Funds - Comparison Revenue & Expenditures 7/1/2010 - 9/30/2010
• Agency Trust Funds - Comparison Revenue & Expenditures 7/1/2010 - 9/30/2010
• Internai Service Funds - Comparison Revenue & Expenditures 7/1/2010 - 9/30/2010
ATTACHMENT 3
Printed on: 10/29/2010 CITY OF DUBLIN L, ~ , ~ f ~~
GENERALFUND ~ ~ ~i
COMPARISON OF REVENUES / VERS US EXPENDIT URES
FOR THE PERIOD 7/1/2010 THROUGH 9/30/2010
2011 2011 2011 2011 2010 2010 2010
BUDGET ACTUAL VARIANCE % BUD ACTUAL YTD %
"""""**REVENUES/SOURCE OF FUNDING*****"**
PROPERTY TAXES 21,386,000 919,994 20,466,006 4% 22,141,004 925,797 4 ~%
SALES TAX 11,885,680 1,899,051 9,986,629 16 % 12,183,267 2,097,623 17 °,/o
PROPERTY TRANSFER TAX 290,000 53,512 236,488 18 % 372,646 73,325 20 °,~o
HOTEL TAX 500,000 70,807 429,193 14 % 557,000 64,458 12 °,~o
FRANCHISE TAXES - WASTE MGT 1,525,000 106,176 1,418,824 7% 1,100,516 129,032 12 °,~o
FRANCHISETAXES-UTILITIES 1,142,500 1,142,500 1,171,058 25,221 2°,/0
LICENSES & PERMITS 1,516,980 650,795 866,185 43 % 2,260,365 435,292 19 °,~o
FINES & PENALTIES 131,540 20,354 111,186 15 % 144,593 27,962 19 °~o
INTEREST 1,057,610 223,962 833,648 21 % 1,576,962 390,592 25 °o
RENTALS 8~ LEASES 374,924 127,366 247,558 34 % 379,644 91,848 24 °o
INTERGOVERNMENTAL - FEDERAL 97,600 97,600 180,647
INTERGOVERNMENTAL - STATE 332,600 24,194 308,406 7% 340,072 37,320 11 °~o
CHARGES FOR SERVICES 4,376,170 915,349 3,460,821 21 % 5,327,968 853,196 16 °~o
OTHER REVENUE 569,200 236,028 333,172 41 % 1,635,316 68,950 4°~o
SUB-TOTAL OPERATINC'i REVENUES 45,185,804 5,247,589 39,938,215 12 % 49,371,056 5,220,616 11 90
TRANSFERS IN 29,730 29,730 28,648
GRAND TOTAL REVENUE/SOURCES 45,215,534 5,247,589 39,967,945 12 % 49,399,705 5,220,616 11 %~
*'****''*EXPEN DITURES/TRANSFERS""`~"**'*
GENERAL GOVERNMENT
CITY COUNCIL 331,440 41,251 290,189 12 % 353,408 61,455 17 °/~
CITY MANAGER/CITY CLERK 1,136,650 260,968 875,682 23 % 1,098,683 224,127 20 °/~
ELECTIONS 79,870 512 79,358 1% 1,945 880 45 °/~
CENTRAL SERVICES/HUMAN RESOURCES 439,380 80,566 358,814 18 % 398,475 73,317 18 °/~
INSURANCE 940,780 203,713 737,067 22 % 788,886 197,868 25 °/~
CITY ATTORNEY 520,000 102,350 417,650 20 % 727,015 108,002 15 °/~
ADMINISTRATIVE SERVICES 1,946,790 406,833 1,539,957 21 % 1,788,564 392,523 22 %~
BUILDING MANAGEMENT 716,830 100,796 616,034 14 % 703,853 147,841 21 %~
NON-DEPARTMENTAL 197,480 1,251 196,229 1% 11,461 1,456 13 %
GENERAL GOVERNMENT- SUBTOTAL 6,309,220 1,198,240 5,110,980 19 % 5,872,290 1,207,469 21 %
PUBLIC SAFETY
POLICE 12,868,710 259,161 12,609,549 2% 12,281,022 300,427 2%
FIRE 10,451,170 89,668 10,361,502 1% 10,203,635 112,613 1°/a
DISASTER PREPAREDNESS 103,480 11,925 91,555 12 % 107,025 9,578 9%
CROSSING GUARDS 100,830 3,091 97,739 3% 100,659 7,426 7%
ANIMAL CONTR~L 414,420 414,420 293,357
TRAFFIC SIGNALS/STREET LIGHTING 212,490 2,233 210,257 1% 12,418 17,340 140 %
PUBLIC SAFETY- SUBTOTAL 24,151,100 366,078 23,785,022 2% 22,998,117 447,385 2%
TRANSPORTATION
PUBLIC WORKS ADMINISTRATION 876,660 165,192 711,468 19 % 784,658 171,277 22 %
STREET MAINTENANCE/SWEEPING 131,280 15,051 116,229 11 % 143,562 18,918 13 °/a
STREET LANDSCAPE/TREE MAINTENANCE 888,270 108,803 779,467 12 % 862,864 150,998 17 %
TRANSPORTATION-SUBTOTAL 1,896,290 289,046 1,607,164 15 % 1,791,083 341,194 19 %
HEALTH & WELFARE
ENVIRONMENTAL SERVICES 13,755
CHILD CARE 18,500 1,570 8%
SOCIAL SERVICES 115,430 46,288 69,142 40 % 39,425 1,916 5%
HEALTH & WELFARE - SUBTOTAL 915,430 46,288 69,142 40 % 71,680 3,486 5%
~
Printed on: 10/29/2010 CITY OF DUBLIN
~ ~ 7 ,+~ ~
t~•
GENERAL FUND
`-~~ _: _
~ ) ~.~
COMPARISON OF REVENUES / VERSUS EXPENDIT URES
FOR THE PERIOD 7/1/2010 THROU GH 9/30/2010
2011 2011 2011 2011 2010 2010 2010
BUDGET ACTUAL VARIANCE % BUD ACTUAL YTD °io
'`""""*`EXPEN DITURES/TRANSFERS*"""***
CULTURE & LEISURE SERVICES
COMMUNITY N 86,790 36,320 50,470 42 % 83,659 38,438 46 °/o
LIBRARY SERVICES 522,940 15,215 507,725 3% 815,019 41,144 5°/~
PARK MAINTENANCE 2,309,330 205,494 2,103,836 9% 1,753,494 350,140 20 °/i
HERITAGE & CULTURAL ARTS 712,400 150,833 561,567 21 % 768,932 198,535 26 %;
RECREATION & COMMUNITY SERVICES 3,732,119 865,951 2,866,168 23 % 3,625,582 803,531 22 %
PARKS/FACILITIES DEVELOPMENT 253,420 42,623 210,797 17 % 220,144 50,110 23 °/~
CULTURE 8 LElSURE SERVICES - SUBTOTAL 7,616,999 1,316,437 6,300,562 17 % 7,266,829 1,481,898 20 %
COMMUNITY DEVELOPMENT
DEVELOPMENT SERVICES 3,446,960 699,245 2,747,715 20 % 3,578,842 636,592 18 °/~
ENGINEERING 1,330,590 350,751 979,839 26 % 1,397,678 237,227 17 %~
ECONOMIC DEVELOPMENT 299,890 67,306 232,584 22 % 299,751 75,750 25 %~
COMMUNITYDEVELOPMENT-SUBTOTAL 5,077,440 1,117,302 3,960,138 22 % 5,276,271 949,570 18 %
SUB-TOTAL OPERATIONG EXPENDlTURES 45,166,399 4,333,391 40,833,008 10 % 43,276,269 4,431,002 10 %~
TRANSFERS OUT 2,670,009 172,762 2,497,247 6% 6,429,024 788,492 12 °k
GRAND TOTAL EXPENDITURES 47,836,408 4,506,153 43,330,255 9% 49,705,294 5,219,494 11 %
REVENUES (SOURCE OF FUNDSJ OVER/(UNDER) (2,620,874) 741,436 (3,362,310) (28%) (305,589) 1,122 0%
EXPENDITURES
Printed on: 10/29/2010 CITY OF DUBLIN
SPECIAL REVENUE FUNDS
COMPARISON OF REVENUES / VERSUS EXPENDITURES
FOR THE PERIOD 7/1/2010 THROUGH 9/30/2010
2011 2011 2011 2011
BUDGET ACTUAL VARIANCE % BUD
"*******REVENUES/SOURCE OF FUNDING*""""**'
PROPERTY TAXES
SALES TAX
FINES & PENALTIES
INTEREST
LOAN REPAYMENTS
INTERGOVERNMENTAL-FEDERAL
INTERGOVERNMENTAL-STATE
INTERGOVERNMENTAL-COUNTY
CHARGES FOR SERVICES
OTHER REVENUE
SUB-TOTAL OPERATING REVENUES
TRANSFERSIN
GRAND TOTAL REVENUE/SOURCES
""""""EXPENDITURES/TRANSFERS"*'**"'"'
GENERAL GOVERNMENT
CITY ATTORNEY
GENERAL GOVERNMENT - SUBTOTAL
PUBLIC SAFETY
POLICE
FIRE
TRAFFIC SIGNALS/STREET LIGHTING
PUBLIC SAFETY - SUBTOTAL
TRANSPORTATION
PUBLIC WORKS ADMINISTRATION
STREET MAINTENANCE/SWEEPING
Others
TRANSPORTATION - SUBTOTAL
HEALTH 8 WELFARE
WASTE MANAGEMENT
ENVIRONMENTAL SERVICES
SOCIAL SERVICES
HOUSING PROGRAMS
Others
HEALTH 8 WELFARE - SUBTOTAL
CULTURE 8~ LEISURE SERVICES
PARK MAINTENANCE
CULTURE & LEISURE SERV/CES - SUBTOTAL
COMMUNITY DEVELOPMENT
ENGINEERING
COMMUNITY DEVELOPMENT - SUBTOTAL
SUB-TOTAL OPERATIONG EXPENDITURES
TRANSFERS OUT
GRAND TOTAL EXPENDITURES
REVENUES (SDURCE OF FUNDS) OVER/(UNDER)
EXPENDITURES
144, 300
375,920
150,000
292,500
1,000
1,280,730
2,210,760
1,578,735
2,229,870
505,520
144,300
375,920
30,592 119,408
72,007 220,493
250 750
1,280,730
76, 578 2,134,182
55, 925 1,522, 810
15,906 2,213,964
172,400 333,120
8,769,335
8, 775,935
423, 659 8,345, 676
6,600
423,659 8,352,276
2010
ACTUAL
145,206
398,611
20 % 168,187
25 % 476,977
25 % 861,769
2, 046, 716
3 % 1,864,487
4 % 1,564,180
1 % 1,772,435
34 % 2,062,066
5 % 11,360,633
445, 844
5 % 11,806,477
1 r_
~~ i:7
2010 2010
YTD '%
25,588 15 `%
113,000 24 ~/o
788,162 91 ~/o
(62,324) (3°/>)
8,531 1 °ia
13,758 1 °,/o
374 0 °%
887,089 8 °o
887,089 8 i~
57,430 13,348 44,082 23 °/a 85,455 31,217 37 °ro
57,430 13,348 44,082 23 % 85,455 31,217 37 %>
114,430 1,114 113,316 1% 160,299 2,490 2°i~
318, 860 7, 018 311, 842 2% 380, 012 643 0°/i
156,400 11,647 144,753 7% 293,604 16,162 6%i
589,690 19,779 569,911 3% 833,915 19,295 2%~
15,571 1,508 14,063 10 % 8,770
510,205 31,222 478,983 6% 310,127 22,367 7°/~
3, 861
525,776 32,730 493,046 6% 322,758 22,367 7%
2,413,720 25,722 2,387,998 1% 1,847,767 14,703 1%
255,060 62,351 192,709 24 % 245,145 44,159 18 %
104,240 14,555 89,685 14 % 55,435 7,032 13 %
13,198,270 123,151 13,075,119 1% 1,432,282 239,407 17 %
22 (22)
15,971,290 225,802 15,745,488 9% 3,580,629 305,301 9%
6,220 6,220 1,964 975 50 %
6,220 6,220 1,964 975 50 %
6,000 6,000 6,000
6, 000 6, 000 6, 000
17,156,406 291,659 16,864,747 2% 4,830,721 379,155 g/
5,532,735 791,039 4,741,696 14 % 7,477,808 2,272,378 30 %
22,689,141 1,082,698 29,606,443 5% 12,308,529 2,651,534 22 %
(13,913,206) (659,039) (93,254,967) 5 % (502,052) (1,764,445) 351 %
Printed on: 10/29/2010 CITY OF DUBLIN
ASSESSMENT DISTRICT FUNDS
COMPARISON OF REVENUES / VERSUS EXPENDITURES
FOR THE PERIOD 7l1/2010 THROUGH 9/30/2010
2011 2011 2011 2011 2010
BUDGET ACTUAL VARIANCE % BUD ACTUAL
'*`***"*REVENUES/SOURCE OF FUNDING"*'****'
PROPERTY TAXES 886,810 886,810 868,349
INTEREST 10,670 2,859 7,811 27 % 17,973
OTHER REVENUE 2,500 2,500 6,119
SUB-TOTAL OPERATING REVENUES 899,980 2,859 897,121 0% 892,440
GRAND TOTAL REVENUEISOURCES 899,980 2,859 897,121 0% 892,440
**'*"*"EXPENDITURES/TRANSFERS"`*""""
PUBLIC SAFETY
TRAFFIC SIGNALS/STREET LIGHTING 408,890 25,126 383,764 6% 367,039
PUBLIC SAFETY- SUBTOTAL 408,890 25,126 383,764 6% 367,039
TRANSPORTATION
STREET LANDSCAPE/TREE MAINTENANCE 468,740 50,591 418,149 11 % 376,187
TRANSPORTATION-SUBTOTAL 468,740 50,591 498,949 11 % 376,187
COMMUNITY DEVELOPMENT
ENGINEERING 16,850 3,907 12,943 23 % 17,942
COMMUNlTYDEVELOPMENT-SUBTOTAL 16,850 3,907 12,943 23 % 17,942
SUB-TOTAL OPERATIONG EXPENDITURES 894,480 79,624 814,856 9% 761,168
TRANSFERS OUT 123,930 123,930 10,773
GRAND TOTAL EXPENDITURES 1,018,410 79,624 938,786 8% 771,941
REVENUES (SOURCE OF FUNDS) OVER/(UNDER) (198,430J (76, 765) (41, 665) 65 % 120,499
EXPENDITURES
`~ ~i ~ ~~;
2010 20'0
YTD %
4,266 24 '%
12 0 '%
4,278 p q/,
4,278 0 `o
47,538 13 `,/o
47,538 13 °o
68,417 18 °%
68,417 18 %
3,745 21 °o
3, 745 21 °r;
119,700 16 !
119,700 16 %~
(115,422) (96%)
Printed on: 10l29/2010 CITY OF DUBLIN
AGENCY/TRUST FUNDS
COMPARISON OF REVENUES 1 VERSUS EXPENDITURES
FOR THE PERIOD 7/1/2010 THROUGH 9/30/2010
2011 2011 2011 2011
BUDGET ACTUAL VARIANCE % BUD
'**"""*REVENUESlSOURCE OF FUNDING'"`**~""*
PROPERTY TAXES 551,285
INTEREST 2,683
OTHER REVENUE
SUB-TOTAL OPERATING REVENUES 553,968
GRAND TOTAL REVENUE/SOURCES 553,968
**"`****EXPENDITURES/TRANSFERS"*"""***
GENERALGOVERNMENT
NON-DEPARTMENTAL 551,533
GENERAL GOVERNMENT - SUBTOTAL 551,533
SUB-TOTAL OPERATIONG IXPENDITURES 551,533
GRAND TOTAL EXPEND/TURES 551,533
REVENUES (SOURCE OF FUNDS) OVER/(UNDER) 2,435
EXPENDITURES
2010
ACTUAL
-~ , ~ ~
t~ ~~- ~
~, ~ -~
2010 2010
YTD %
551,285 363,193
1,101 1,582 41 % 758,153 824,665 109 '%
128,407 (128,407) 601,719 132,093 22 `%
129,508 424,460 23 % 1,723,064 956,758 56:%
129,508 424,460 23 % 1,723,064 956,758 56 °6
287,232 264,301 52 % 534,977 284,603 53 °,/o
287,232 264,301 52 % 534,977 284,603 53 96
287,232 264,301 52 % 534,977 284,603 53 °o
287,232 264,301 52 % 534,977 284,603 53 ib
(157,724) 160,159 (6,477%) 1,188,087 672,154 57 90
Printed on: 10/29/2010
CITY OF DUBLIN
`~ /
~~~
~ ~~-~
INTERNAL SERVICE FUNDS ~ ~
~ ''
COMPARISON OF REVENUES / VERSUS EXPENDIT URES
FOR THE PERIOD 7/1/2009 THROUGH 9(30/2009
2010 2010 2010 2010 2009 2009 2003
BUDGET ACTUAL VARIANCE % BUD ACTUAL YTD °o
"""""REVENUES/SOURCE OF FUNDING"""**i'*
INTEREST 181,824 49,472 132,352 27 % 255,009 36,364 14 °io
CHARGES FOR SERVICES 1,777,031 516,843 1,260,188 29 % 1,955,258 477,818 24 °~b
OTHER REVENUE 29,020 79,310 (50,290) 273 % 8,778,663 71,036 1°io
SUB-TOTAL OPERATING REVENUES 1,987,875 645,625 1,342,250 32 % 10,988,930 585,219 5„
TRANSFERS IN 2,032,302 (2,032,302)
GRAND TOTAL REVENUE/SOURCES 1,987,875 2,677,927 (690,052) 135 % 10,988,930 585,219 5%>
""*'`***EXPENDITURES/TRANSFERS*"""""
GENERAL GOVERNMENT
NON-DEPARTMENTAL 3,453,610 311,405 3,142,205 9% 3,491,356 325,327 9%;
GENERALGOVERNMENT-SUBTOTAL 3,453,610 3?1,405 3,142,205 9% 3,491,356 325,327 9%~
SUB-TOTAL OPERATIONG EXPENDITURES 3,453,610 311,405 3,142,205 9% 3,491,356 325,327 g%,
TRANSFERS OUT 2,032,303 (2,032,303) _
GRAND TOTAL EXPENDITURES 3,453,610 2,343,708 1,109,902 68 % 3,491,356 325,327 9%
REVENUES(SOURCEOFFUNDS)OVER/(UNDER) (1,465,735J 334,219 (1,799,954) (23%) 7,497,575 259,892 3%
EXPEND/TURES •
ld 15
CITY OF DUBLIN
PRO FORMA MONTHLY FINANCIAL INFORMATION
FOR
THE MONTH OF SEPTEMBER 2010
~. ~F DU~
~~~ ~~~
~
~ll ~ 11~
19 ~,~~~- -~ 8'Z
1
~-
r,. _t ~.
Prepared by
The Finance Department
October 29, 2010
• SUMMARY - All Funds Revenue, Expenditures and Fund
Balances 7/1 /2010 - 9/30/2010
• DETAIL - By Individual Fund Revenue, Expenditures and Fund
Balances 7/1 /2010 - 9/30/2010
ATTACHMENT 4
BALANCE
FUNDS 07/01/2010
GOVERNMENTALFUNDS
GENERAL
General Funds 59,496,258
Sub-Total GENERAL 59,496,258
SPECIAL REVENUE
Public Safety ~ 329,457
Transportation 2,628,237
Environmental 1,463,966
Parks p
Maintenance Assessment Districts 803,704
Culture & Arts 375,002
Health & Welfare 12,900,338
5ub-Total SPECIAL REVENUE 18,500,705
CAPITAL FUNDS
Current Capital Projects 9,314
Impact Fees 2,996,328
~ub-Total CAPITAL FUNDS 3,005,642
iOTAL GOVERNMENTAL FUND 81,002,604
NTERNAL SERVICE FUNDS
Internal Service Funds 8,761,378
~ub-Total INTERNAL SERVICE FUNDS 8,761,378
aGENCYFUNDS
improvement District 6,103,325
Geologic Hazard Abatement 154,255
3ub-Total AGENCY FUNDS 6,257,580
Grand Total 96,021,563
City of Dublin
All Funds - Revenue, Expenditures and Fund Balances
July 01, 2010 through September 30, 2010
SUMMARY
REVENUES TRANSFERS TOTALFUNDS
09/30/2010 09/30/2010 AVAILABLE
EXPENDITURES TRANSFERS ENDING
09/30/2010 09/30/2010 BALANCE
5,247,589 0 64,743,847 ~'~~i~7~$~~, ~ ` ~,
~~ x~
,a (4,333,391
)
(172,762)
60,237,694
5,247,589 0 64,743,847 ~,
~ '`~7 ~~i~~t} (4,333,391) (172,762) 60,237,694
~~~
~ ~n.
~
167,869 0 497,326 ~~ - ,2D
v (19,779) 0 477,547
91,810 0 2,720,048 ~; ` ~~: (32,730) (353,336) 2,333,982
61,189 0 1,525,154 ~~' ~, ~~~~ (88,096) (22,489) 1,414,569
0 0 0 ,y" ~~~j "p. 0 (408,742) (408,742)
2,859 0 806,563 ~~~ ~s qQ ~ =~j. (79,624) 0 726,939
15,156 0 390,159 ~" ~" ~. 0 (6,473) 383,686
87,634 0 12,987,973 *s ~~~y ~~ (151,054) 0 12,836,919
426,518 0 18,927,222 ~7~1~ 1~
~, (371,283) (791,039) 17,764,900
0
1,024,381
1,033,696 ~
~~ ~~4~'~
_ ~s~`
,
"
a ~
`~e
~
(1,024,322)
0
9,373
1,722,207
0
4,718,535 ~
.
~
,
.
;
~, ~~,~: ~~ $,9~'~
0
(42,683)
4,675,852
1,722,207 1,024,381 5,752,231 ~ r~ 23, Q~$~$~
, ~ ~ ~,-~
~ (1,024,322) (42,683) 4,685,225
..u ~..~...;z#
7,396,314 1,024,381 89,423,300 F~~~4~~4b;857'
` (5,728,996) (1,006,485) 82,687,819
~ ~~ i
r
~
~~'~`?
585,031 0 9,346,409 ,
~ , ~~~~ ~~ ~ "
`~, ~4r~}39~~?,'~
(340,592)
(17,896)
8,987,921
585,031 0 9,346,409 ~~ 4~43~,5~~,' (340,592) (17,896) 8,987,921
128,942 0 6,232,267
566 0 154,821
129,508 0 6,387,088
8,110,853 1,024,381 105,156,797
(285,982) 0 5,946,285
(1,250) 0 153,571
(287,232) 0 6,099,856
(6,356,820) (1,024,381) 97,775,596
~
~
V \
City of Dublin
All Funds - Revenue, Expenditures and Fund Balances
July 01, 2010 through September 30, 2010
DETAILS BY FUND
BALANCE ~~~Bl~1T~G~T~D REVENUES TRANSFERS TOTAL FUNDS ~~~;~~BE'~~.4"`a~~"~C~ EXPENDITURES TRANSFERS ENDING
FUNDS 07/01/2010 €~R~1/~N(j~$ 09/30/2010 09/30/2010 AVAILABLE ~~X~EI~IU'1"1;1~~, 09/30/2010 09/30/2010 BALANCE
~~ ~~~~~ ~ ~
~ 3~'a~f~ ,~
~ ~~fi.~"r~ aw~~ .~a~`_': ~ . .'@~~: 'Y^ `x ~` .~.~,y„
~r ~ ~e ~ ~ ~ ~_: ...
GOVERNMENTAL FUNDS ~,~;~ ~ ~ '~- x ~ ~ ~ ~ ~~~
~ u ~- y~ ~ ~ ~ ~
z ~ za
GENERAL ~; : Y ~
~~ ~~ ~ ~ °~r'~
~
1001 Generai Fund 59,436,258 ~~ ~~,~(~~g~r}~ 5,247,368 0 64,683,625 `'~~,~ ¢~ ~~A~~ (4,333,391) (172,762) 60,177,473
1002 Cemetery Reserve 60,000 E~;~~~ ,~~(~ 221 0 60,221 ~~~ ~~x-, q' 0 0 60,221
~~ ~~;~~~~ - ~
Sub-Total 59,496,258 ~~~`~i 4~~~,5fr~34~ 5,247,589 0 64,743,847 ~~~f~7~$~~y 4,333,391 )
,~~~. ~~ ~ ~Q , ( ) (172,762 60,237,694
e ,^ ~ z ~ ~
SPECIAL REVENUE ~k '~ ~~ ~` ~ ~~~^, ' ~
~ ~~ ~~~~ ~a
Public Safety y; £ ~~ ~ ~,~~
; ~ ~~-,~ ~ ~ ' ~ ~~''"~'
~ ~ ~~ ~
2101 Special Criminal Activity Fund 82,053 ~hx~~~3 6~5Q, 302 0 82,355 ,f ~°~ ~+~~~p~ (170) 0 82,185
2102 Vehicle Abatement 186,118 ~~~~ 3~ ~90, 686 0 186,804 ~~~~ ~ 5
~~+rA' ~~~ ~~~~ - ~ '~ ~~r~8Q~ (142) 0 186,662
2103 SLES/COPS Fund - CA 0~~`~`4+ '~'10U,000~ 44 0 44 ~~ 100,~U~OQ,° 0 0 44
~ ~ 4~
2104 Local Law Enforcement Block Grant - Fed 8,630 ~~ g`~~~ ~,0, 30 0 8,660 ~ ~~~ ~$,~0~ (803) 0 7,857
2106 Traffic Safety 38,799 k~~ ~~gg~g~q,~~~ 30,828 0 69,627 ~~~ a'.~ ~ 2,ggp~ (11,647) 0 57,980
2 1 0 7 Fe dera l Asse t Seizure Fun d 4,504 ~~ .~ ~~~~40~ 134,704 0 1 3 9, 2 0 8 ~ ,~~~ q 0 0 139,208
~~~ ~ ~
2109 EMS Special Revenue 9,352 ~~ '~316700~ 70 0 9,423 =a ~3 8,860~ (7,018) 0 2,405
2111 Enforcement Grants 0~~~~ ~';5gpx, 1,205 0 1,205 ~ ~ ~~
~ ~~'°~ ~~ i ~ ~~ ~~q~ 0 0 1,205
Sub-Total 329,457 ~649254' 167,869 0 497,326 ~ ~
~~,,~,~~ + 3 ~ ~~ 6p5 ~ (19,779) 0 477,547
~ ~
Transportation ~~~~'~~~~, z ~ ~~; ~~A~
~~ ~ ~ , ~, ~; ; ~'~~
2201 State Gas Tax 1,483,705 ~~~ ~~~$~,~~~ 81,067 0 1,564,772 ~~ ,~,~9 ` (31,222) (46,963) 1,486,587
2202 SAFETEA-LU (456,856) ~~r~~~~7;~40~ 0 0 ) ~9 7Y~ p 0 (222,401) (679,257)
~~ ~,~ (456,856 ~ ~ r
~ ~ ~ ~~ A ~ ~
2204 ACTIA Sales Tax-Local Streets 656,349 ~~~~2~0353U; 7,487 0 663,836 ~ 4,Q5U 0 (73,354) 590,482
2205 ACTIA Sales Tax-Bike & Ped 499,396 ,~3~ ~~OF#41 ~ 1,789 0 501,185 ~~~129 ~01~~ 1,508
( ) (10,619 489,058
2209 TCRF(Traffic) Congestion Relie~ 445,643 ~~~~ : ~~°~~~ ~ ` ~ ~~ ~~ ~ ~
~~ ~,~ Q 1,468 0 447,112 y~ ~ ~2,~
~K~ ~ ~ ~ ~OQ 0 0 447,112
Sub-Total 2,628,237 ~~~~ ~~~,64'1,9$0~ 91,810 0 2,720,048 ~~ '
Environmental ~~~r ~ ~ ~ J a ~+~~~~'~g~: (32,730) (353,336) 2,333,982
~~ ~ ~, ~ ~~"~
~ , ~~ ~ ~ ~
2302 Measure D 251,800 ~~ ~'I~ 4Q~ 56,841 0 308,641 ~~ ~,~ ~;~SQ~ (51,756) 0 256,885
2303 Garbage Service Fund 57,411 ~~~~~~~~J~~~~~ 209 0 57,620 ~~~ ~~~~~ ;~30s (964) 0 56,656
2 3 0 4 L o c a l R e c y c l i n g P r o g r a ms 440,994 ~~ ~~~ ~~`6~~273 1,537 0 442,531 ~~~~' ~~~~~r~`~ (35,376) 0 407,155
2311 American Recovery & Relnvest. Act. - Env p ~~~ ~~ ~ "~~ ~~ ~~ ~~~
~~~i QQ"o 0 ~ ~ ~x ~~~~~~Q~ ~ ~ ~
2321 Storm Water Management 183,685 ~~~ ~"`~ k~~ ~~'.` `~
~~~ 83~,9~Q~ 647 0 184,332 ~`,~ $~6;5~~~4~ 0 (22,489) 161,843~
2322 Box Culvert 343,882 ~~~r ~ 5 860': 1,268 0 345,149 ~~~~ ~~ ~
;~ ~ ~ ~ ~~~O,QC10` 0 0 345,149
2323 Dublin / Dougherty 106,034 ~ ~ ! ~ ~z ' ~~~ ~ ~ ~
~~ ~ p~ 391 0 106,425 ~~,~~ ~SUOA~ 0 0 106,425~
2324 Village Parkway 80,160 ~~~ ~"~0; 295 0 80,456 ~ ~ ~"~=<'~p~ p 0 80,456 ~
~ . ~.~.~ , ... ~. ,~ ~.~~~ r ~R
FUNDS
GOVERNMENTAL FUNDS
SPECIAL REVENUE
S u b-Tota I
Parks
2402 East Bay Regional Park District
S u b-Total
Maintenance Assessment Districts
2701 Street Light District 1983-1
2702 Landscape District Stagecoach 1983-2
2703 Landscape District Dougherty 1986-1
2704 Landscape District Santa Rita 1997-1
2705 Street Light District East Dublin 1999-1
Sub-Total
Culture & Arts
2801 Public Art Fund
Sub-Total
Health & Welfare
2901 Affordable Housing Fund
2902 Noise Mitigation Fund
2903 Community Development Block Grant
Sub-Total
CAPITAL FUNDS
Current Capital Projects
3300 General Improvement CIP Projects
3400 Community Improvement CIP Projects
3500 Parks CIP Projects
3600 Streets CIP Projects
Sub-Total
IMPACT FEES
City of Dublin
All Funds - Revenue, Expenditures and Fund Balances
July 01, 2010 through September 30, 2010
DETAILS BY FUND
BALANCE ~~f~BIJpGET~D REVENUES TRANSFERS TOTAL FUNDS a
07/01/2010 ~REU~NU~S' 09/30/2010 09/3072010 AVAILABLE ~
~ ~~~ ~ ~
s ~ ';~ ;t ~
1,463,966 ~~ ~r~~3, ~~~ 61,189 0 1,525,154
~ u ~°x
~ ~~ ~~"~~~2 ..~¢0- 0 0 0
a , ~~a -- ~a;
~ ~~6 1x'l~~l~ Q: 0 0 0
~
~ ~~~,~~1 ~~
~ r
151,673 ~ '~ $~~ pz 560 0 152,233
~~ ~
29,360 ~~ ~ ~3~ °~~~~`~i 91 0 29,451
85,711 ~~ ~~~, p~ 292 0 86,003
~ ~ ,p~
191,985 ~~,'~~Q;3 647 0 192,632
344,975 ~~~.. ~191 98b~ 1,269 0 346,245
~ ~ ~~~s ~ ~ ~
803,704 ~~ ' ~899;980: 2,859 0 806,563
~
~~ ~~~ ~ ~
375,002 `~~i~~~~~~~3~<~p~ 15,156 0 390,159
~~,, d 9s
375,002 ~~~ j~ ,g~3"p,~ 15,156 0 390,159
~~ ~
~~ ~1~~~ ~~~
12,838,676 ~~ ° ~~~~ "~
Z66,7'~40~ 87,186 0 12,925,862
~~ a~~~
61,662 ~~ ~ ~ ~~ ~ ~~~q~ 448 0 62,110
~ ~ ~' ~~'~,~4 0 0 0
qa
12,900,338 ~~~;~~~,~8~1~4~0~ 87,634 0 12,987,973
`~~^~r ,~ ~'n~t-,n ~i
t h
~~ ~~ t
~ °~ r- ~ ~
~ "~` ~fF3.'6 A
~ ~a~'~~`~3 °$A ,~v
~ ~ 'T~90~t~~ 0 59,303 59,303
,
~ ~~'; 344,~97~ 0 7,185 7,185
~~s~ ~1' 759,$03 0 575,581 575,581
9,314 9~,~38i540' 0 382,312 391,626
~ ~~ ;
9,314 ~~,~~°'~~q~~~(j,7~~g~ 0 1,024,381 1,033,696
ra ~ .'~~~~~t~~~; '.
EXPENDITURES TRANSFERS ENDING
09/30/2010 09/30/2010 BALANCE
(88,096) (22,489) 1,414,569
0 (408,742) (408,742)
0 (408,742) (408,742)
(18,209) 0 134,024
(9,506) 0 19,944
(14,333) 0 71,671
(28,706) 0 163,926
(8,870) 0 337,375
(79,624) 0 726,939
0 (6,473) 383,686
0 (6,473) 383,686
(136,499) 0 12,789,363
0 0 62,110
(14,555) 0 (14,555)
(151,054) 0 12,836,919
(59,303) 0 0
(7,185) 0 p
(575,581) 0 0
(382,253) 0 9,373
(1,024,322) 0 9,373
~~
V \
FUNDS
GOVERNMENTAL FUNDS
IMPACTFEES
Public Facility
4100 Public Facility Fees
Sub-Total
Fire
4201 Fire Impact Fees
S u b-Tota I
Traffic
4301 EDTIF Category 1
4302 EDTIF Category 2
4303 EDTIF Category 3
4304 West Dublin TIF
4305 Dougherty Valley TIF
4306 TVTD
4307 Fallon Interchange Advances
4309 Mitigation Contributions
Sub-Total
NTERNAL SERVICE FUNDS
6101 Police Vehicles
6102 Fire Vehicles & Apparatus
6103 Non-Safety Vehicles
6201 Buildings
6301 Equipment
6501 Maintenance & Repairs
6901 Retiree Health
6951 PERS Side Fund Payoff
S u b-Tota I
\GENCY FUNDS
improvement District
5101 Dublin Bivd Extension Trust/Agency
City of Dublin
Ali Funds - Revenue, Expenditures and Fund Balances
July 01, 2010 through September 30, 2010
DETAILS BY FUND
BALANCE ~,~ ~3~ ~"[~p` REVENUES TRANSFERS TOTAL FUNDS ~
07/01/2010 ~'~`z ~1~ ~ ~;~5 09/30/2010 AVAILABLE
~,~~y ; 09/30/2010 ~
~? ~~u~.~ ~: - . ~.~`~
EXPENDITURES TRANSFERS ENDING
09/30/2010 09/30/2010 BALANCE
City of Dublin
All Funds - Revenue, Expenditures and Fund Balances
July 01, 2010 through September 30, 2010
DETAILS BY FUND
FUNDS
BALANCE ~~~UD~ai~~~D REVENUES TRANSFERS TOTALFUNDS
07/01/2010 '"' REEV~NU~S 09/30/2010 09l30/2010 AVAILABLE
~ ,.hz~ y ~ ,... . , ~
EXPENDITURES TRANSFERS ENDING
09/30/2010 09/30/2010 BALANCE
AGENCYFUNDS
Improvement District
5171 CERBT (OPEB) Trust Fund
Sub-Total
Geologic Hazard Abatement
5301 Fallon Village GHAD
5302 Schaefer Ranch GHAD
Sub-Total
Grand Total
5,840,997 ;'~"' ~'~"'~~~~ 6~ 128,407 0 5,969,404
~~ a ~a
6,103,325 " 2~Q,~:~g~ 128,942 0 6,232,267
~
, - ~~
~ ~fi:~
~ ~~~% '°c.~.~~
43,222 ~ ~' ~~ p~ 158 0 43,380
111,033 ~~yry~ p(j~~2q~ 408 0 111,441
~
154,255 ~W~- `~~~~ p 566 0 154,821
~~3~.
`~ ~.°; ~~ ~ >;
.:~
96,021,563 ;:7$,326,235~ 8,110,853 1,024,381 105,156,797
(75,648) 0 5,893,756
(285,982) 0 5,946,285
(625) 0 42,755
(625) 0 110,816
(1,250) 0 153,571
(6,356,820) (1,024,381) 97,775,596
~ ~
~M1~