HomeMy WebLinkAboutItem 4.04 Quarterly Fin Reportor
19 82
/ii � 111
DATE:
TO:
FROM:
STAFF REPORT
CITY COUNCIL
November 20, 2012
Honorable Mayor and City Councilmembers
Joni Pattillo City Manager""'
CITY CLERK
File #320 -30
SUBJECT: Preliminary Quarterly Financial Report for the Period Ending September 30, 2012
(1st Quarter)
Prepared by Paul S. Rankin, Administrative Services Director
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 ending June 30, 2013. The
annual financial audit field work was completed on October 26, 2012. The auditors have not
proposed any audit adjustments at the time the financial reports are prepared. However the
beginning balances should be considered preliminary as any final audit adjusting entries will be
recorded and included in the City's Comprehensive Annual Financial Report, to be presented in
December. Based on the completion of the first quarter of the year, 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:
Staff recommends that the City Council receive the reports as authorized by Section 41004 of
the California Government Code
Submitted By Reviewed By
Administrative Services Director Assistant City Manager
DESCRIPTION:
This item provides the report on the preliminary financial statements for the first quarter of Fiscal
Year 2012 -2013 (which includes the months of July, August, and September 2012). Consistent
Page 1 of 5 ITEM NO. 4.4
with prior reports, the focus will be on General Fund Revenues and Expenditures, which
represent the most significant portion of the City's operations.
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 Monthly 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 2012
represented 15% of the current budget. By comparison, revenue collected in the first three
months of the previous Fiscal Year represented 11 % of its total General Fund revenue. It is
typical for the first quarter revenue to be well below the percentage of the year completed. This
is due to the fact that major general fund revenues such as property tax and sales tax are not
evenly distributed on a monthly basis. 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 is helpful to identify items where a
decrease or increase in year to date collections, may be consistent with the adopted Budget and
Financial Plan.
Page 2 of 5
Summary of Significant General Fund Revenue Differences
For Amounts Collected July — September 2012 vs. July - September 2011
REVENUE
YTD
YTD
DIFFERENCE
September
September
FY 2012/13
EXPLANATION
2012
2011
More / (Less)
FY 2011/12
Property
$ 952,100
$ 903,781
$ 48,319
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 increase in Fiscal Year
ANNUAL
ACTUAL
2012 -2013 represents increased assessed
BUDGET
PRIOR YR
DIFFERENCE
valuation associated with the Unsecured
$ 827,591
$23,073,950
$22,246,359
Tax Roll.
Sales Tax/
$1,420,950
$1,808,413
($ 387,463)
The reported revenue as of September
In -Lieu
only includes advances based on State
Sales Tax
estimates. The reconciling payment for
first quarter is not received until
ANNUAL
ACTUAL
December. Staff monitors detailed sales
BUDGET
PRIOR YR
DIFFERENCE
tax data with the City's Consultant as it
($446,932)
$14,550,000
$14,996,932
becomes available.
License
$ 1,343,401
$ 1,087,636
$ 255,765
The positive variance is related to the
and
increase in building permit activity. A total
Permits
of 446 residential units were issued in the
first quarter of Fiscal Year 2012 -2013
compared to only 372 permits issued in
the same period of the previous fiscal year
— an increase of additional 74 permits or
about 19 %. Staff will be monitoring
ANNUAL
ACTUAL
development activity and will determine if a
BUDGET
PRIOR YR
DIFFERENCE
mid -year adjustment to the adopted
($2,067,946)
$2,452,490
$4,520,436
budget is appropriate.
Charge for
$ 1,597,206
$ 1,300,771
$ 296,435
There are increases and decreases of the
Services
revenues in this category, and the
increase in total revenues was due
primarily related to development activities.
As of September 2012, the City received
an increase of approximately $78,000 in
fire plan check /inspection fees and
approximately $123,000 in planning and
zoning fees compared to the same period
ANNUAL
ACTUAL
of the prior year. The fees collected from
BUDGET
PRIOR YR
DIFFERENCE
Parks and Community Services
($1,123,530)
$6,566,010
$7,689,540
contributed to the remaining increase.
Page 3 of 5
REVENUE
YTD
September
2012
YTD
September
2011
DIFFERENCE
FY 2012/13
More / (Less)
FY 2011/12
EXPLANATION
Other
$3,054,062
$ 543,089
$2,510,973
The revenues in this category are typically
Revenue
one -time or have irregular timing, such as
contributions and reimbursements,
therefore the revenues do not maintain a
specific pattern. Pursuant to certain
development agreements the City
collected one -time community benefit
payments in Fiscal Year 2012 -2013 that
ANNUAL
ACTUAL
were not received in the same period of
BUDGET
PRIOR YR
DIFFERENCE
the prior year.
($5,416,160)
$7,241,290
$1,825,130
General Fund Expenditures
Overall, through the month of September 2012, expenditures in the General Fund totaled
approximately $6.2 million and represented approximately 10% of the total budgeted
expenditures in the General Fund (Attachment 2). Of this amount, a total of $139,551 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.
An examination of only the General Fund Operating Expenditures (Attachment 2) indicates that
through September 2012, expenditures totaled 11 % of the Budgeted General Fund expenses,
which was 1% higher than the percentage of total operating expenditures incurred in the
previous year. The total amount of General Fund Operating expenditures for all Departments in
the first three months of Fiscal Year 2012 -2013, were approximately $866,000 higher 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 prior Fiscal Year. The largest
variance occurred in Community Development (approximately $295,000) which reflects an
increase in contract services related to development processing and reimbursable expenses,
corresponding to the increases in the collection of development related fees. The Culture and
Community Services also incurred an increase (approximately $205,000) related to staffing and
contract costs. Increased community events during this period in the current fiscal year also
contributed to the increase (such as the All America City Celebration and Splatter). There are
also increases in Health and Welfare (approximately $159,000). This relates increased portions
of staffing costs in environmental services and contract costs in social services budgeted in the
General Fund. Police Services incurred an additional $120,000 of expenditures related to the
conversion of police radios to digital units. The City has not received invoices for contract
services for Police and Fire through September 2012, so those expenditures have not been
recorded.
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 4 of 5
NOTICING REQUIREMENTS /PUBLIC OUTREACH:
None.
ATTACHMENTS: 1. General Fund Year to Date Revenues and Budget Comparisons.
2. General Fund Year to Date Expenditures and Budget Comparisons.
3. Comparison of Revenue versus Expenditures by Fund Type.
4. Fund Balances for the Period Ending September 30, 2012.
Page 5 of 5
City of Dublin 2012 -2013 YTD Revenues and Budget Comparison
For the Period Ending September 30, 2012
Total General Fund
Revenues
Other Revenues
Charges for Services
Intergovernmental
from State
Interest
Fines and Forfeitures
Licenses and Permits
Franchise Taxes
Transient Occupancy
Taxes
Real Property
Transfer Tax
Sales Taxes
0% 30% 60% 90% 120% 150%
25% of Year Complete
FY 2012/13
FY 2012/13
% of
FY 2011/12
% of Total for
42
YTD Actual
Budget
YTD Actual
FY 2011/12
I""=
Property Taxes
30%
952,100
4%
903,781
4%
Sales Taxes
14,550,000
1,420,950
10%
1,808,413
■ FY 2012/13
17
%
60,841
14%
84,523
�IIIIIIII FY 2011/12
Transient Occupancy Taxes
15%
181,754
21%
154,637
18%
Franchise Taxes
0%
188,602
7%
197,817
7%
Licenses and Permits
14%
1,343,401
55%
1,087,636
24%
Fines & Penalties
11%
30,119
26%
25,008
20%
Interest & Rentals
1,077,630
6%
14%
149,268
11%
Intergovernmental
181,800
27,910
15%
0
0%
Charges for Services
6,566,010
1,597,205
5%
1,300,771
17%
Other Revenues
7,241,290
2
%
543,089
30%
Total General Fund Revenues
7%
9,006,346
15%
6,254,943
11%
7%
21%o
18°
14%
19 °0
10%
JJJJ2%
0% 30% 60% 90% 120% 150%
25% of Year Complete
Date Printed 11/9/20129'. 48 AM ATTACHMENT 1
FY 2012/13
FY 2012/13
% of
FY 2011/12
% of Total for
Budget
YTD Actual
Budget
YTD Actual
FY 2011/12
Property Taxes
23,073,950
952,100
4%
903,781
4%
Sales Taxes
14,550,000
1,420,950
10%
1,808,413
12%
Real Property Transfer Tax
430,000
60,841
14%
84,523
19%
Transient Occupancy Taxes
875,000
181,754
21%
154,637
18%
Franchise Taxes
2,897,300
188,602
7%
197,817
7%
Licenses and Permits
2,452,490
1,343,401
55%
1,087,636
24%
Fines & Penalties
115,410
30,119
26%
25,008
20%
Interest & Rentals
1,077,630
149,402
14%
149,268
11%
Intergovernmental
181,800
27,910
15%
0
0%
Charges for Services
6,566,010
1,597,205
24%
1,300,771
17%
Other Revenues
7,241,290
3,054,062
42%
543,089
30%
Total General Fund Revenues
59,460,880
9,006,346
15%
6,254,943
11%
Date Printed 11/9/20129'. 48 AM ATTACHMENT 1
City of Dublin 2012 -2013 YTD Expenses and Budget Comparison
For the Period Ending September 30, 2012
Total General Fund
Expenses
CIP Projects
Community Development
Culture & Community
Services
Health and Welfare
Transportation
Other Public Safety
Fire
Police
General Government
10%
9%
8,278,567
Police
15,222,647
1%
10,868,810
Other Public Safety
623,410
�L2%
2,200,100
Health and Welfare
619,154
Culture and Community Services
22%
Community Development
7,609,640
CIP Projects
19%
1,426,110
22%
456,738
21%
296,185
2%
100,992
19%
104,689
1 %
15,438
28%
17,289
4%
361,406
5%
343,110
18%
172,988
16%
13,952
5%
1,806,852
21%
8%
19%
1,676,008
2%
1,381,759
19%
139,551
4%
136,479
2%
6,189,918
1%
5,320,678
9%
6,050,367
1%
5,184,199
10%
3%
2%
8%
22%
0% 20%
FY 2012/13
Budget
General Government
8,278,567
Police
15,222,647
Fire
10,868,810
Other Public Safety
623,410
Transportation
2,200,100
Health and Welfare
619,154
Culture and Community Services
8,572,397
Community Development
7,609,640
CIP Projects
10,725,400
Total General Fund Expenses 64,720,125
General Fund Operating Expenses 53,994,725
■ FY 2012/13
uuuu FY 2011/12
40% 60%
80%
100%
120%
25% of Year Complete
FY 2012/13
% of
FY 2011/12
% of Total for
YTD Actual
Budget
YTD Actual
FY 2011/12
1,459,945
18%
1,426,110
22%
456,738
3%
296,185
2%
100,992
1 %
104,689
1 %
15,438
2%
17,289
4%
361,406
16%
343,110
18%
172,988
28%
13,952
5%
1,806,852
21%
1,601,105
19%
1,676,008
22%
1,381,759
19%
139,551
1%
136,479
2%
6,189,918
10%
5,320,678
9%
6,050,367
11%
5,184,199
10%
Date Printed 11/9/2012 9 .50 AM ATTACHMENT 2
CITY OF DUBLIN
PROFORMA
COMPARISON OF REVENUE VERSUS EXPENDITURES
(By Fund Type)
FISCAL YEAR 2012 -2013
FOR THE PERIOD ENDING SEPTEMBER 30, 2012 (Quarter 1)
r
LL(\1
LqM
v
I r
IM-6Z APPEAR, -
�
Prepared by
The Finance Department
November 7, 2012
• General Fund - Comparison of Revenue & Expenditures 7/1/2012 — 9/30/2012
• Special Revenue Funds - Comparison Revenue & Expenditures 7/1/2012 — 9/30/2012
• Assessment District Funds - Comparison Revenue & Expenditures 7/1/2012 — 9/30/2012
• Agency Trust Funds - Comparison Revenue & Expenditures 7/1/2012 — 9/30/2012
• Internal Service Funds - Comparison Revenue & Expenditures 7/1/2012 — 9/30/2012
ATTACHMENT 3
Printed on: 11/09/2012
CITY OF DUBLIN
Page 1 of 2
GENERALFUND
COMPARISON OF REVENUES /VERSUS EXPENDITURES
FOR THE PERIOD 7/1/2012 THROUGH 9/30/2012
2013
2013
2013
2013
2012
2012
2012
BUDGET
ACTUAL
VARIANCE % BUD
ACTUAL
YTD
%
REVENUES/SOURCE OF FUNDING*"*"**"*
PROPERTY TAXES
23,073,950
952,100
22,121,850
4%
22,246,359
903,781
4%
SALES TAX
14,550,000
1,420,950
13,129,050
10%
14,996,932
1,808,413
12%
PROPERTY TRANSFER TAX
430,000
60,841
369,159
14%
441,575
84,523
19%
HOTELTAX
875,000
181,754
693,246
21%
879,733
154,637
18%
FRANCHISE TAXES - WASTE MGT
1,670,000
188,602
1,481,398
11%
1,683,239
197,817
12%
FRANCHISE TAXES - UTILITIES
1,227,300
1,227,300
1,291,129
LICENSES & PERMITS
2,452,490
1,343,401
1,109,089
55%
4,520,436
1,087,636
24%
FINES & PENALTIES
115,410
30,119
85,292
26%
126,387
25,008
20%
INTEREST
553,690
988
552,702
0%
771,567
13,605
2%
RENTALS & LEASES
523,940
148,414
375,526
28%
548,408
135,663
25%
LOAN REPAYMENTS
16,603
(16,603)
INTERGOVERNMENTAL - STATE
181,800
11,308
170,492
6%
196,629
CHARGES FOR SERVICES
6,566,010
1,597,206
4,968,804
24%
7,689,540
1,300,771
17%
OTHER REVENUE
7,241,290
3,054,062
4,187,228
42%
1,825,130
543,090
30%
SUB -TOTAL OPERATING REVENUES
59,460,880
9,006,346
50,454,534
15%
57,217,064
6,254,943
11%
TRANSFERS IN
28,800
28,800
27,760
GRAND TOTAL REVENUE/SOURCES
59,489,680
9,006,346
50,483,334
15%
57,244,824
6,254,943
11%
*"** - EXPENDITURES /TRANSFERS"**""**"
GENERAL GOVERNMENT
CITY COUNCIL
417,520
74,134
343,386
18%
349,649
69,584
20%
CITY MANAGER /CITY CLERK
1,333,360
296,271
1,037,089
22%
1,277,736
300,891
24%
ELECTIONS
46,120
881
45,239
2%
1,686
CENTRAL SERVICES /HUMAN RESOURCES
541,717
109,504
432,213
20%
515,500
108,757
21%
INSURANCE
983,380
318,427
664,953
32%
594,999
253,555
43%
CITY ATTORNEY
883,120
59,219
823,901
7%
716,959
130,195
18%
ADMINISTRATIVE SERVICES
2,111,200
454,030
1,657,170
22%
1,948,071
417,529
21%
BUILDING MANAGEMENT
868,660
142,906
725,754
16%
759,439
123,647
16%
NON - DEPARTMENTAL
1,093,490
4,572
1,088,918
0%
291,153
21,951
8%
GENERAL GOVERNMENT- SUBTOTAL
8,278,567
1,459,945
6,818,622
18%
6,455,192
1,426,110
22%
PUBLIC SAFETY
POLICE
15,222,647
456,738
14,765,909
3%
14,660,756
296,185
2%
FIRE
10,868,810
100,992
10,767,818
1%
10,287,783
104,689
1%
DISASTER PREPAREDNESS
113,810
13,644
100,166
12%
92,395
14,096
15%
CROSSING GUARDS
111,890
2,876
109,014
3%
111,843
508
0%
ANIMALCONTROL
365,340
(10,869)
376,209
(3 %)
223,353
TRAFFIC SIGNALS /STREET LIGHTING
32,370
9,788
22,582
30%
30,302
2,686
9%
PUBLIC SAFETY- SUBTOTAL
26,714,867
573,168
26,141,699
2%
25,406,432
418,163
2%
TRANSPORTATION
PUBLIC WORKS ADMINISTRATION
932,980
185,754
747,226
20%
832,899
184,920
22%
STREET MAI NTENANCE/SWEEPING
180,070
15,034
165,036
8%
140,454
15,137
11%
STREET LANDSCAPE /TREE MAINTENANCE
1,087,050
160,617
926,433
15%
953,944
143,053
15%
TRANSPORTATION- SUBTOTAL
2,200,100
361,406
1,838,694
16%
1,927,297
343,110
18%
HEALTH & WELFARE
WASTE MANAGEMENT
154,110
34,289
119,821
22%
ENVIRONMENTAL SERVICES
225,490
56,223
169,267
25%
85,717
1,032
1%
SOCIAL SERVICES
239,554
82,475
157,079
34%
221,791
12,871
6%
HOUSING PROGRAMS
50
HEALTH & WELFARE- SUBTOTAL
619,154
172,988
446,166
28%
307,508
13,952
5%
Printed on: 11/09/2012 CITY OF DUBLIN
GENERALFUND
COMPARISON OF REVENUES /VERSUS EXPENDITURES
FOR THE PERIOD 7/1/2012 THROUGH 9/30/2012
2013 2013 2013 2013 2012
BUDGET ACTUAL VARIANCE % BUD ACTUAL
*"** - EXPENDITURES /TRANSFERS"**""**"
CULTURE & LEISURE SERVICES
COMMUNITY TV
LIBRARY SERVICES
PARK MAINTENANCE
HERITAGE & CULTURALARTS
RECREATION & COMMUNITY SERVICES
PARKS /FACILITIES DEVELOPMENT
CULTURE & LEISURE SERVICES - SUBTOTAL
COMMUNITY DEVELOPMENT
DEVELOPMENT SERVICES
ENGINEERING
ECONOMIC DEVELOPMENT
COMMUNITY DEVELOPMENT - SUBTOTAL
SUB -TOTAL OPERATIONG EXPENDITURES
TRANSFERS OUT
GRAND TOTAL EXPENDITURES
REVENUES (SOURCE OF FUNDS) 0VERI(UNDER)
EXPENDITURES
Page 2 of 2
2012 2012
YTD %
87,150
36,138
51,012
41%
23,244
7,384
32%
564,730
28,746
535,984
5%
573,872
23,754
4%
2,488,630
441,546
2,047,084
18%
2,472,490
414,569
17%
987,110
232,088
755,022
24%
792,244
165,396
21%
4,082,700
986,247
3,096,453
24%
3,925,229
911,909
23%
362,077
82,088
279,989
23%
425,784
78,092
18%
8,572,397
1,806,852
6,765,545
21%
8,212,863
1,601,105
19%
4,673,040
985,314
3,687,726
21%
4,167,692
833,916
20%
2,146,580
536,554
1,610,026
25%
2,551,585
456,762
18%
790,020
154,141
635,880
20%
595,567
91,081
15%
7,609,640
1,676,009
5,933,631
22%
7,314,844
1,381,759
19%
53,994,725
6,050,367
47,944,358
11%
49,624,136
5,184,199
10%
10,725,400
139,551
10,585,849
1%
6,938,330
136,479
2%
64,720,125
6,189,918
58,530,207
10%
56,562,466
5,320,678
9%
(5,230,445)
2,816,429 (8,046,874) (54%)
682,358
934,266
137%
Printed on: 11/09/2012
CITY OF DUBLIN
Page 1 of 1
SPECIAL
REVENUE FUNDS
COMPARISON OF REVENUES
/VERSUS EXPENDITURES
FOR THE PERIOD 7/1/2012
THROUGH 9/30/2012
2013
2013
2013
2013
2012
2012
2012
BUDGET
ACTUAL
VARIANCE % BUD
ACTUAL
YTD
%
REVENUES/SOURCE OF FUNDING*"*"**"*
PROPERTY TAXES
152,400
152,400
152,486
SALES TAX
453,560
453,560
468,408
FINES & PENALTIES
141,870
14,930
126,940
11%
158,606
30,387
19%
INTEREST
117,980
27,464
90,516
23%
108,538
2,636
2%
LOAN REPAYMENTS
111,448
250
0%
INTERGOVERNMENTAL - FEDERAL
1,914,660
1,914,660
1,002,227
INTERGOVERNMENTAL - STATE
1,858,950
269,829
1,589,121
15%
2,188,862
233,198
11%
INTERGOVERNMENTAL - COUNTY
675,040
57,324
617,716
8%
606,145
26,301
4%
CHARGES FOR SERVICES
2,661,250
25,650
2,635,600
1%
2,623,258
19,530
1%
OTHER REVENUE
1,618,800
776,918
841,882
48%
1,036,964
20,457
2%
SUB -TOTAL OPERATING REVENUES
9,594,510
9,906,993
4,566,123
96%
4,537,255
116,034
50%
TRANSFERS IN
6,600
6,600
6,600
GRAND TOTAL REVENUE/SOURCES
2,789,998
9,906,993
4,564,223
96%
4,571,355
116,034
5%
*"** - EXPENDITURES /TRANSFERS"**""**"
GENERAL GOVERNMENT
CITY ATTORNEY
53,780
502
53,278
1%
15,462
9,254
60%
GENERAL GOVERNMENT- SUBTOTAL
31,048
386
31,604
9%
93,576
2,635
78%
PUBLIC SAFETY
POLICE
252,183
103,583
148,600
41%
154,109
9,547
6%
FIRE
337,310
2,250
335,060
1%
321,670
643
0%
TRAFFIC SIGNALS /STREET LIGHTING
369,986
24,491
345,495
7%
253,566
11,367
4%
PUBLIC SAFETY- SUBTOTAL
232,502
918,161
462,937
95%
062,155
69,330
1%
TRANSPORTATION
PUBLIC WORKS ADMINISTRATION
15,410
1,460
13,950
9%
12,731
1,045
8%
STREET MAI NTENANCE/SWEEPING
591,595
47,015
544,581
8%
428,709
45,818
11%
TRANSPORTATION- SUBTOTAL
780,883
54,505
334,319
4%
559,558
57,471
99%
HEALTH & WELFARE
WASTE MANAGEMENT
2,557,310
23,135
2,534,175
1%
2,626,796
32,010
1%
ENVIRONMENTAL SERVICES
206,490
2,069
204,421
1%
272,530
40,215
15%
SOCIAL SERVICES
90,750
9,057
81,693
10%
77,577
5,763
7%
HOUSING PROGRAMS
967,700
51,381
916,319
5%
1,138,054
522,317
46%
HEALTH &WELFARE - SUBTOTAL
1,466,638
43,756
1,017,784
6%
5,995,230
788,183
93%
CULTURE & LEISURE SERVICES
COMMUNITY TV
47,130
17,669
29,461
37%
35,360
PARK MAINTENANCE
2,500
2,500
CULTURE & LEISURE SERVICES - SUBTOTAL
52,718
90,772
19,279
17%
13,178
COMMUNITY DEVELOPMENT
ENGINEERING
174,800
6,410
168,391
4%
6,000
COMMUNITY DEVELOPMENT- SUBTOTAL
905,488
7,598
974,129
5%
7,888
SUB -TOTAL OPERATIONG EXPENDITURES
5,666,944
642,868
3,100,265
3%
3,156,371
700,204
910%
TRANSFERS OUT
5,123,378
457,877
4,665,501
9%
2,260,949
162,557
7%
GRAND TOTAL EXPENDITURES
98,028,166
057,420
98,851,563
0%
0,781,396
458,313
99%
REVENUES (SOURCE OF FUNDS) 0VER /(UNDER)
(9,942,696)
563,694 (9,795,518) (179/. )
478,816
(380 ,000)
(32° %)
EXPENDITURES
Printed on: 11/09/2012 CITY OF DUBLIN Page 1 of 1
ASSESSMENT DISTRICT FUNDS
COMPARISON OF REVENUES /VERSUS EXPENDITURES
FOR THE PERIOD 7/1/2012 THROUGH 9/30/2012
2013 2013 2013 2013 2012 2012 2012
BUDGET ACTUAL VARIANCE % BUD ACTUAL YTD %
REVENUES/SOURCE OF FUNDING*"*"**"*
PROPERTY TAXES
985,820
985,820
944,454
INTEREST
11,020
2,183
8,837
20%
10,048
216
2%
OTHER REVENUE
2,500
2,500
2,924
SUB -TOTAL OPERATING REVENUES
999,340
2,183
997,157
0%
957,425
216
0%
GRAND TOTAL REVENUE/SOURCES
999,340
2,183
997,157
0%
957,425
216
0%
*"** - EXPENDITURES /TRANSFERS"**""**"
PUBLIC SAFETY
TRAFFIC SIGNALS /STREET LIGHTING
465,010
62,423
402,587
13%
418,092
25,513
6%
PUBLIC SAFETY- SUBTOTAL
465,010
62,423
402,587
13%
418,092
25,513
6%
TRANSPORTATION
STREET LANDSCAPE /TREE MAINTENANCE
494,370
62,182
432,188
13%
399,336
67,884
17%
TRANSPORTATION- SUBTOTAL
494,370
62,182
432,188
13%
399,336
67,884
17%
COMMUNITY DEVELOPMENT
ENGINEERING
32,390
32,390
40,722
2,605
6%
COMMUNITY DEVELOPMENT- SUBTOTAL
32,390
32,390
40,722
2,605
6%
SUB -TOTAL OPERATIONG EXPENDITURES
991,770
124,605
867,165
13%
858,151
96,002
11%
TRANSFERS OUT
37,320
37,320
33,541
GRAND TOTAL EXPENDITURES
1,029,090
124,605
904,485
12%
891,693
96,002
11%
REVENUES (SOURCE OF FUNDS) 0VER /(UNDER)
(29,750)
(122,422)
92,672
412%
65,732
(95,786)
(14694
EXPENDITURES
Printed on: 11/09/2012 CITY OF DUBLIN Page 1 of 1
INTERNAL SERVICE FUNDS
COMPARISON OF REVENUES /VERSUS EXPENDITURES
FOR THE PERIOD 7/1/2012 THROUGH 9/30/2012
2013 2013 2013 2013 2012 2012 2012
BUDGET ACTUAL VARIANCE % BUD ACTUAL YTD %
REVENUES/SOURCE OF FUNDING*"*"**"*
INTEREST
106,090
35,950
70,140
34%
158,854
3,955
2%
CHARGES FOR SERVICES
3,154,280
711,487
2,442,793
23%
2,785,435
678,846
24%
OTHER REVENUE
380,200
117,075
263,125
31%
381,956
120,537
32%
SUB -TOTAL OPERATING REVENUES
3,640,570
864,512
2,776,058
24%
3,326,245
803,338
240%
GRAND TOTAL REVENUE/SOURCES
3,640,570
864,512
2,776,058
24%
3,326,245
803,338
24%
*"** — EXPENDITURES /TRANSFERS"**""**"
GENERAL GOVERNMENT
NON - DEPARTMENTAL
5,585,170
638,603
4,946,567
11%
4,493,890
509,389
11%
GENERAL GOVERNMENT- SUBTOTAL
5,585,170
638,603
4,946,567
11%
4,493,890
509,389
11%
SUB -TOTAL OPERATIONG EXPENDITURES
5,585,170
638,603
4,946,567
11%
4,493,890
509,389
11%
TRANSFERS OUT
894,597
894,597
143,111
GRAND TOTAL EXPENDITURES
6,479,767
638,603
5,841,164
10%
4,637,001
509,389
11%
REVENUES (SOURCE OF FUNDS) 0VER /(UNDER)
(2,839,197)
225,909 (3,065,106) (8%) (1,310,756)
293,950 (22V.
EXPENDITURES
Printed on: 11/09/2012 CITY OF DUBLIN
AGENCY /TRUST FUNDS
COMPARISON OF REVENUES /VERSUS EXPENDITURES
FOR THE PERIOD 7/1/2012 THROUGH 9/30/2012
2013 2013 2013 2013 2012
BUDGET ACTUAL VARIANCE % BUD ACTUAL
REVENUES/SOURCE OF FUNDING*"*"**"*
PROPERTY TAXES
INTEREST
OTHER REVENUE
SUB -TOTAL OPERATING REVENUES
GRAND TOTAL REVENUE/SOURCES
*"** - EXPENDITURES /TRANSFERS"**""**"
GENERAL GOVERNMENT
NON - DEPARTMENTAL
GENERAL GOVERNMENT- SUBTOTAL
COMMUNITY DEVELOPMENT
ENGINEERING
COMMUNITY DEVELOPMENT - SUBTOTAL
SUB -TOTAL OPERATIONG EXPENDITURES
GRAND TOTAL EXPENDITURES
REVENUES (SOURCE OF FUNDS) 0VERI(UNDER)
EXPENDITURES
Page 1 of 1
2012 2012
YTD %
585,030
585,030
462,077
12,160
499,934
(487,774)
4,111%
5,607
(869,738)
(15,512 %)
260,384
(260,384)
1,356,350
276,521
20%
597,190
760,319
(163,129)
127%
1,824,033
(593,217)
(3394)
597,190
760,319
(163,129)
127%
1,824,033
(593,217)
(3394)
9,550
311,418
(301,868)
3,261%
1,496,964
621,343
42%
9,550
311,418
(301,868)
3,261%
1,496,964
621,343
42%
66,500
66,500
66,500
66,500
76,050
311,418
(235,368)
409%
1,496,964
621,343
420%
76,050
311,418
(235,368)
409%
1,496,964
621,343
42%
521,140
448,901
72,239
86%
327,070
(1,214,560)
(371V.
CITY OF DUBLIN
PRO FORMA MONTHLY FINANCIAL INFORMATION
FOR THE PERIOD ENDING SEPTEMBER 30, 2012 (Quarter 1)
Prepared by
The Finance Department
November 7, 2012
• SUMMARY — All Funds Revenue, Expenditures and Fund
Balances 7/1/2012 — 9/30/2012
• DETAIL — By Individual Fund Revenue, Expenditures and Fund
Balances 7/1/2012 — 9/30/2012
ATTACHMENT 4
City of Dublin
All Funds - Revenue, Expenditures and Fund Balances
July 01, 2012 through September 30, 2012
SUMMARY
BALANCE BUDGETED REVENUES TRANSFERS TOTAL FUNDS BUDGETED EXPENDITURES TRANSFERS ENDING
FUNDS 07/01/2012 REVENUES 09/30/2012 09/30/2012 AVAILABLE EXPENDITURES 09/30/2012 09/30/2012 BALANCE
GOVERNMENTAL FUNDS
GENERAL
General Funds
63,750,029
59,489,680
9,006,346
0
72,756,375
64,720,125
(6,050,367)
(139,551)
66,566,457
Sub -Total GENERAL
63,750,029
59,489,680
9,006,346
0
72,756,375
64,720,125
(6,050,367)
(139,551)
66,566,457
SPECIAL REVENUE
Public Safety
491,305
607,810
33,621
0
524,927
751,833
(130,323)
0
394,603
Transportation
4,027,466
4,140,230
300,657
0
4,328,123
5,460,149
(50,824)
(457,877)
3,819,423
Environmental
832,948
3,135,770
19,960
0
852,908
3,302,930
(29,264)
0
823,644
Parks
468
106,950
1
0
469
106,950
0
0
469
Maintenance Assessment Districts
922,009
999,340
2,183
0
924,192
1,029,090
(124,605)
0
799,588
Culture &Arts
376,348
239,400
846
0
377,194
49,630
(17,669)
0
359,525
Health & Welfare
5,226,153
1,370,950
817,030
0
6,043,182
1,118,830
(60,940)
0
5,982,242
Sub -Total SPECIAL REVENUE
11,876,697
10,600,450
1,174,298
0
13,050,995
11,819,412
(413,625)
(457,877)
12,179,494
CAPITAL FUNDS
Current Capital Projects
0
30,139,134
0
1,289,144
1,289,144
37,020,995
(1,289,144)
0
0
Impact Fees
25,015,923
5,231,690
4,510,480
0
29,526,403
6,484,170
0
(691,716)
28,834,687
Sub -Total CAPITAL FUNDS
25,015,923
35,370,824
4,510,480
1,289,144
30,815,547
43,505,165
(1,289,144)
(691,716)
28,834,687
TOTAL GOVERNMENTAL FUNDS
100,642,648
105,460,954
14,691,125
1,289,144
116,622,917
120,044,702
(7,753,136)
(1,289,144)
107,580,638
INTERNAL SERVICE FUNDS
Internal Service Funds
12,283,548
3,640,570
864,512
0
13,148,060
6,479,767
(638,603)
0
12,509,457
Sub -Total INTERNAL SERVICE FUNDS
12,283,548
3,640,570
864,512
0
13,148,060
6,479,767
(638,603)
0
12,509,457
AGENCYFUNDS
Trust Funds
8,548,754
0
758,171
0
9,306,924
0
(311,418)
0
8,995,507
Geologic Hazard Abatement
867,149
597,190
2,148
0
869,297
76,050
0
0
869,297
Sub -Total AGENCY FUNDS
9,415,903
597,190
760,319
0
10,176,222
76,050
(311,418)
0
9,864,804
Grand Total
122,342,100
109,698,714
16,315,955
1,289,144
139,947,199
126,600,519
(8,703,156)
(1,289,144)
129,954,899
City of Dublin
All Funds - Revenue, Expenditures and Fund Balances
July 01, 2012 through September 30, 2012
DETAILS BY FUND
BALANCE BUDGETED REVENUES TRANSFERS TOTAL FUNDS BUDGETED EXPENDITURES TRANSFERS ENDING
FUNDS 07/01/2012 REVENUES 09/30/2012 09/30/2012 AVAILABLE EXPENDITURES 09/30/2012 09/30/2012 BALANCE
GOVERNMENTAL FUNDS
GENERAL
1001 General Fund
1002 Cemetery Reserve
Sub -Total
SPECIAL REVENUE
Public Safety
2101 Special Criminal Activity Fund
2102 Vehicle Abatement
2103 SLES /COPS Fund - CA
2106 Traffic Safety
2107 Federal Asset Seizure Fund
2109 EMS Special Revenue
2111 Enforcement Grants
Sub -Total
Transportation
2201 State Gas Tax
2202 SAFETEA -LU
2204 ACTIA Sales Tax -Local Streets
2205 ACTIA Sales Tax -Bike & Ped
2208 Congestion Management Agency
2210 Highway Safety Traffic Reduction Bond
2211 Federal Transportation (TIGER)
2212 ACTC -VEHICLE REGISTRATION FEE
Sub -Total
Environmental
2302 Measure D
2303 Garbage Service Fund
2304 Local Recycling Programs
2311 American Recovery & Reinvest. Act. - Env
2321 Storm Water Management
2322 Box Culvert
2323 Dublin / Dougherty
63,690,029
60,000
59,489,020
660
9,006,197
150
0 72,696,225
0 60,150
64,720,125
0
(6,050,367)
0
(139,551)
0
66,506,307
60,150
63,750,029
59,489,680
9,006,346
0 72,756,375
64,720,125
(6,050,367)
(139,551)
66,566,457
109,171
215,149
0
37,630
108,700
16,710
3,945
1,070
35,010
100,000
141,870
1,110
326,550
2,200
303
543
3,321
15,031
120
14,302
0
0
0
0
0
0
0
0
109,475
215,692
3,321
52,661
108,820
31,013
3,945
44,830
20,720
100,000
142,240
104,533
337,310
2,200
(3,329)
0
0
(24,491)
(100,254)
(2,250)
0
0
0
0
0
0
0
0
106,146
215,692
3,321
28,171
8,566
28,763
3,945
491,305
607,810
33,621
0
524,927
751,833
(130,323)
0
394,603
1,746,775
1,279,880
270,306
0
2,017,081
1,287,561
(45,581)
(19,844)
1,951,656
156,202
1,560,790
0
0
156,202
1,560,790
0
(306,720)
(150,518)
843,848
342,030
2,051
0
845,899
790,436
0
(13,453)
832,446
367,965
461,650
421
0
368,386
844,112
(5,243)
(51,802)
311,342
0
0
0
0
0
0
0
0
0
515,622
0
2,217
0
517,839
515,070
0
(24,715)
493,124
146,327
292,520
0
0
146,327
292,520
0
(41,344)
104,983
250,727
203,360
25,662
0
276,389
169,660
0
0
276,389
4,027,466
4,140,230
300,657
0
4,328,123
5,460,149
(50,824)
(457,877)
3,819,423
36,184
150,850
0
0
36,184
188,690
(21,191)
0
14,993
48,046
2,475,650
117
0
48,164
2,493,860
(2,250)
0
45,914
180,933
19,060
18,487
0
199,420
87,130
(3,323)
0
196,097
13,506
0
0
0
13,506
0
0
0
13,506
25,127
483,250
50
0
25,177
443,250
0
0
25,177
353,098
5,050
875
0
353,973
80,000
0
0
353,973
98,785
1,100
244
0
99,029
5,000
0
0
99,029
City of Dublin
All Funds - Revenue, Expenditures and Fund Balances
July 01, 2012 through September 30, 2012
DETAILS BY FUND
FUNDS
BALANCE
07/01/2012
BUDGETED
REVENUES
REVENUES
09/30/2012
TRANSFERS
09/30/2012
TOTAL FUNDS
AVAILABLE
BUDGETED
EXPENDITURES
EXPENDITURES
09/30/2012
TRANSFERS
09/30/2012
ENDING
BALANCE
GOVERNMENTAL FUNDS
SPECIAL REVENUE
Environmental
2324 Village Parkway
77,269
810
186
0
77,456
5,000
(2,500)
0
74,956
Sub -Total
832,948
3,135,770
19,960
0
852,908
3,302,930
(29,264)
0
823,644
Parks
2402 East Bay Regional Park District
468
106,950
1
0
469
106,950
0
0
469
Sub -Total
468
106,950
1
0
469
106,950
0
0
469
Maintenance Assessment Districts
2701 Street Light District 1983 -1
156,409
277,110
337
0
156,746
318,860
(38,954)
0
117,792
2702 Landscape District Stagecoach 1983 -2
32,938
79,900
67
0
33,004
77,350
(13,354)
0
19,651
2703 Landscape District Dougherty 1986-1
75,320
116,070
168
0
75,488
123,590
(13,937)
0
61,551
2704 Landscape District Santa Rita 1997 -1
243,903
305,700
608
0
244,511
313,850
(34,891)
0
209,620
2705 Street Light District East Dublin 1999 -1
413,440
220,560
1,003
0
414,443
195,440
(23,469)
0
390,974
Sub -Total
922,009
999,340
2,183
0
924,192
1,029,090
(124,605)
0
799,588
Culture &Arts
2801 Public Art Fund
272,941
102,700
676
0
273,617
2,500
0
0
273,617
2811 Cable TV Facilities
103,407
136,700
170
0
103,577
47,130
(17,669)
0
85,908
Sub -Total
376,348
239,400
846
0
377,194
49,630
(17,669)
0
359,525
Health & Welfare
2901 Affordable Housing Fund
5,155,894
1,306,860
815,438
0
5,971,332
1,057,480
(51,883)
0
5,919,449
2902 Noise Mitigation Fund
70,259
2,740
1,591
0
71,850
0
0
0
71,850
2903 Community Development Block Grant
0
61,350
0
0
0
61,350
(9,057)
0
(9,057)
Sub -Total
5,226,153
1,370,950
817,030
0
6,043,182
1,118,830
(60,940)
0
5,982,242
CAPITAL FUNDS
Current Capital Projects
3300 General Improvement CIP Projects
0
18,185,846
0
92,514
92,514
20,248,099
(92,514)
0
0
3400 Community Improvement CIP Projects
0
86,820
0
2,018
2,018
88,902
(2,018)
0
0
3500 Parks CIP Projects
0
3,869,630
0
534,208
534,208
4,363,114
(534,208)
0
0
3600 Streets CIP Projects
0
7,996,838
0
660,405
660,405
12,320,880
(660,405)
0
0
Sub -Total
0
30,139,134
0
1,289,144
1,289,144
37,020,995
(1,289,144)
0
0
City of Dublin
All Funds - Revenue, Expenditures and Fund Balances
July 01, 2012 through September 30, 2012
DETAILS BY FUND
FUNDS
BALANCE
07/01/2012
BUDGETED
REVENUES
REVENUES
09/30/2012
TRANSFERS
09/30/2012
TOTAL FUNDS
AVAILABLE
BUDGETED
EXPENDITURES
EXPENDITURES
09/30/2012
TRANSFERS
09/30/2012
ENDING
BALANCE
GOVERNMENTAL FUNDS
IMPACT FEES
Public Facility
4100 Public Facility Fees
18,340,076
3,871,210
3,332,265
0
21,672,341
3,977,960
0
(534,208)
21,138,133
Sub -Total
18,340,076
3,871,210
3,332,265
0
21,672,341
3,977,960
0
(534,208)
21,138,133
Fire
4201 Fire Impact Fees
(1,358,914)
55,330
23,863
0
(1,335,052)
0
0
0
(1,335,052)
Sub -Total
(1,358,914)
55,330
23,863
0
(1,335,052)
0
0
0
(1,335,052)
Traffic
4301 EDTIF Category 1
1,384,387
328,290
230,356
0
1,614,743
785,370
0
(13,426)
1,601,317
4302 EDTIF Category 2
699,642
133,830
152,306
0
851,948
174,680
0
0
851,948
4303 EDTIF Category 3
1,536,465
16,720
3,807
0
1,540,272
0
0
0
1,540,272
4304 West Dublin TIF
628,002
164,730
57,395
0
685,398
5,270
0
0
685,398
4305 Dougherty Valley TIF
2,356,947
512,190
5,401
0
2,362,348
1,204,270
0
(4,937)
2,357,411
4306 TVTD
228,131
147,550
702,528
0
930,659
0
0
0
930,659
4308 BART Garage
0
1,840
242
0
242
0
0
0
242
4309 Mitigation Contributions
1,201,187
0
2,319
0
1,203,506
336,620
0
(139,145)
1,064,360
Sub -Total
8,034,761
1,305,150
1,154,353
0
9,189,114
2,506,210
0
(157,509)
9,031,606
INTERNAL SERVICE FUNDS
6101 Police Vehicles
754,076
167,550
40,869
0
794,945
404,370
0
0
794,945
6102 Fire Vehicles & Apparatus
2,107,762
176,930
44,283
0
2,152,046
329,270
0
0
2,152,046
6103 Non - Safety Vehicles
171,922
20,890
5,235
0
177,157
77,700
(50,768)
0
126,389
6201 Buildings
8,648,422
228,530
64,259
0
8,712,681
2,670,887
0
0
8,712,681
6301 Equipment
2,416,016
404,500
102,850
0
2,518,866
907,590
(134,517)
0
2,384,349
6401 Parks Replacement Fund
105,368
106,400
26,423
0
131,791
0
0
0
131,791
6501 Maintenance & Repairs
60,372
534,580
125,792
0
186,164
440,750
(85,546)
0
100,619
6901 Retiree Health
14,436
1,651,190
377,773
0
392,208
1,649,200
(367,772)
0
24,437
6951 PERS Side Fund Payoff
(1,994,826)
350,000
77,028
0
(1,917,798)
0
0
0
(1,917,798)
Sub -Total
12,283,548
3,640,570
864,512
0
13,148,060
6,479,767
(638,603)
0
12,509,457
AGENCYFUNDS
Trust Funds
5101 Dublin Blvd Extension Trust/Agency
80,240
0
36
0
80,276
0
(189,053)
0
(108,777)
AGENCYFUNDS
Trust Funds
5171 CERBT (OPEB) Trust Fund
5198 ACAP
Sub -Total
Geologic Hazard Abatement
5301 Fallon Village GHAD
5302 Schaefer Ranch GHAD
5311 FALLON VILLAGE ANNEX /JORDAN RANCH
5321 FALLON CROSSING GHAD /N. TASSAJARA
Sub -Total
Grand Total
City of Dublin
All Funds - Revenue, Expenditures and Fund Balances
July 01, 2012 through September 30, 2012
DETAILS BY FUND
8,370,747 0
97,767 0
8,548,754 0
757,728 0 9,128,475 0 (120,333) 0 9,008,142
407 0 98,174 0 (2,033) 0 96,141
758,171 0 9,306,924 0 (311,418) 0 8,995,507
336,164
260,970
833
0
336,997
7,050
0 0
336,997
530,985
327,870
1,315
0
532,301
66,500
0 0
532,301
0
3,360
0
0
0
0
0 0
0
0
4,990
0
0
0
2,500
0 0
0
867,149
597,190
2,148
0
869,297
76,050
0 0
869,297
122342,100
109,698,714
16,315,955
1,289,144
139,947,199
126.600.519 (8,703,156)
(1,289,144)
129,954,899