HomeMy WebLinkAbout101-Treasurer�s Report for the Month Ended November 30, 2011 .pdf
MEETIN
DEPART
PREPAR
SUBJEC
RECOM
Review an
REPORT
California
the legisla
Municipa
the City T
Sectio
Clerk
file a
The follo
collective
the State T
FISCAL
Cash and
As of Nov
deposit w
cash flow
allowed to
and excee
NG DATE:
TMENT:
RED BY:
T: Treasur
MENDED A
nd accept the
T SUMMARY
a government
ative body a w
l Code of the
Treasurer.
on 41004. R
k a written rep
copy with the
wing attachm
ely as well as
Treasurer’s O
IMPACT
d Investments
vember 30, 2
with LAIF. Co
w purposes, to
o fall below $
eds the minim
SA
December 21
Finance & A
Ann Xu, Acc
rer’s Report
ACTION
Treasurer’s R
Y
t code section
written report
e City of Sara
Regularly, at l
port and accou
e legislative b
ments provide
specifically f
Office of Quar
s Balance by F
011, the City
ouncil Policy
avoid occurr
$2,000,000. T
mum limit requ
Unrestrict
Comerica
Deposit wi
Total Unr
ARATOGA
1, 2011
Administrative
countant
for the Mont
Report for the
n 41004 requ
and accounti
atoga, Article
east once eac
unting of all
body.
e various fina
for the City’s
rterly LAIF ra
Fund
y had $776,28
on operating
rence of dry p
The total pool
uired.
ted Cash
Bank
ith LAIF
restricted Ca
Cas
A CITY C
e Services
th Ended No
e month ende
ires that the C
ing of all rece
e 2-20, Sectio
ch month, the
receipts, disb
ancial transac
General (Op
ates from the
82 in cash dep
g reserve fund
period financin
led cash balan
ash
sh Summary
OUNCIL
AGENDA
CITY M
DIRECT
ovember 30, 2
d November
City Treasure
eipts, disburse
on 2-20.035 d
e City Treasu
bursements, a
ction data for
perating) Fund
1st Quarter of
posit at Come
ds, adopted on
ng, pooled ca
nce as of Nov
77$
11,94$
12,722$
A ITEM:
MANAGER:
TOR: Mary F
2011
30, 2011.
er submit to t
ements, and f
designates th
urer shall subm
and fund balan
r the City of
d, including a
f 1977 to pres
erica bank, an
n April 20, 19
ash from all fu
vember 30, 20
76,282
46,225
2,507
Dave Ander
Furey
the City Cler
fund balances
e City Manag
mit to the Cit
nces. He sha
f Saratoga’s F
an attachment
sent.
nd $11,946,2
994, states tha
funds should n
011 is $12,72
rson
rk and
. The
ger as
ty
all
Funds
t from
225 on
at: for
not be
22,507
The Fund Balance schedule presented on the following page represents actual funding available for all
funds at the end of the monthly period. This amount differs from the above Cash Summary schedule as
assets and liabilities are components of the fund balance. As illustrated in the summary below, Total
Unrestricted Cash is adjusted by the addition of Total Assets less the amount of Total Liabilities to arrive
at the Ending Fund Balance – which represents the actual amount of funds available.
Fund Balances Designations
In February 2009, the Governmental Accounting Standards Board (GASB) issued Statement No. 54,
Fund Balance Reporting and Governmental Fund Type Definitions. This standard left unchanged the
total amount reported as fund balance, but substantially altered the categories and terminology used to
describe its components. The new categories and terminology focuses, not on financial resources
available for appropriation, but on the extent to which the government is bound to honor constraints on
the specific purpose for which the amounts in the fund can be spent.
The components of fund balance are now categorized as follows: “non-spendable fund balance”,
resources that are inherently non-spendable from the vantage point of the current period; “restricted fund
balance”, resources that are subject to external enforceable legal restrictions; “committed fund balance”,
resources whose use is constrained by limitations that the government imposes upon itself at its highest
level of decision making and remain binding unless removed in the same manner; “assigned fund
balance”, resources that reflects a government’s intended use of resources, such intent would have to be
established at either the highest level of decision making, by a body, or an official designated for that
purpose; and “unassigned fund balance”, net resources in excess of what can properly be classified in one
of the other four categories. Currently, the City’s fund balance reserves fall into one of the four spendable
categories; restricted, committed, assigned, or unassigned fund balance.
CONSEQUENCES OF NOT FOLLOWING RECOMMENDED ACTION
The City would not be in compliance with Government Code Section 41004.
ALTERNATIVE ACTION
N/A
FOLLOW UP ACTION
N/A
ADVERTISING, NOTICING AND PUBLIC CONTACT
Pursuant to Government Code 54954.2, this item was properly posted as a City Council agenda
item and was included in the packet made available on the City’s web site in advance of the
Total Unrestricted Cash12,722,507$
Plus: Assets210,342
Less: Liabilities (1,802,217)
Ending Fund Balance11,130,632$
Adjusting Cash to Ending Fund Balance
meeting. A copy of the agenda packet is also made available at the Saratoga Branch Library each
Monday in advance of the Council meeting.
ATTACHMENTS
A – Change in Total Fund Balances by Fund under GASB 54
B – Change in Total Fund Balances by CIP Project
C – Local Agency Investment Fund (LAIF) Quarterly Apportionment Rates
ATTACHMENT A
CHANGES IN TOTAL FUND BALANCE UNDER GASB 54
Fund Description
Fund
Balance
7/1/11
Increase/
(Decrease)
Jul-Oct
Current
Revenue
Current
Expenditure Transfers
Fund Balance
11/30/11
Restricted Fund Balances:
Environmental Services513,182 - - - - 513,182
Committed Fund Balances:
Hillside Stability500,000 - - - - 500,000
Assigned Fund Balances:
Capital Projects500,000 - (160,000) 340,000
Carryforwards326,900 - - - - 326,900
Unassigned Fund Balances:
Operations 2,903,522 - - - - 2,903,522
Economic Uncertainty 1,500,000 - - - - 1,500,000
Development Services632,380 - - - - 632,380
Uncollected Deposits44,791 - - - - 44,791
Other Unassigned563,290 (1,959,046) 1,309,544 1,460,557 (14,000) (1,560,770)
Subtotal 7,484,065 (1,959,046) 1,309,544 1,460,557 (174,000) 5,200,005
Special Revenue
Landscape/Lighting Districts504,125 (116,573) 23,604 34,911 - 376,245
CDBG Federal Grants- 7,087 - - - 7,087
Capital Project
Street Projects1,906,037 (17,818) 43,433 166,433 170,000 1,935,220
Park and Trail Projects959,923 (303,393) 8,655 27,594 - 637,592
Facility Improvement Projects942,051 (71,250) - 43,040 136,430 964,191
Administrative Projects147,329 (3,177) - 1,356 (1,430) 141,365
Tree Fund36,771 2,000 300 - - 39,071
CIP Grant Street Repair Projects(9,850) (230,809) 113,944 121,442 - (248,157)
CIP Grant Park & Trail Projects(40,302) (235,127) - 8,157 - (283,586)
CIP Grant Administrative Projects810 2,608 - - - 3,418
Gas Tax Fund532,645 224,495 144,217 23,190 (106,000) 772,167
Debt Service
Library Bond 850,657 (689,884) 695 346 - 161,123
Internal Service Fund
Liability/Risk Management134,905 (105,808) 566 6,342 - 23,321
Workers Compensation224,104 189 - 700 - 223,594
Office Stores Fund15,831 10,463 701 4,411 - 22,584
Information Technology Services 231,063 61,403 - 24,057 - 268,409
Equipment Maintenance42,817 33,766 - 10,170 - 66,413
Building Maintenance208,518 144,721 - 66,570 - 286,669
Equipment Replacement331,373 40,000 - - - 371,373
Technology Replacement185,567 2,943 - 981 (25,000) 162,530
Total City14,688,437 (3,203,209) 1,645,659 2,000,255 - 11,130,632
ATTACHMENT B
FUND BALANCES BY CIP PROJECT
CIP Funds/Projects
Fund
Balance
7/1/11
Increase/
(Decrease)
Jul-Oct
Current
Revenue
Current
Expenditure Transfers
Fund
Balance
11/30/11
Street Projects
Traffic Safety129,793 (70,142) - - 50,000 109,651
Highway 9 Safety Project36,033 (3,067) - 7,712 90,000 115,254
Annual Street Resurfacing Project 453,149 114,135 43,433 13,232 (121,781) 475,704
Annual Sidewalks Project52,905 (2,500) - 63,630 50,000 36,775
Saratoga Sunnyvale Road Resurfacing99,011 - - - - 99,011
Traffic Signal @ Verde Vista Lane90,000 - - - - 90,000
Fourth Street Bridge100,000 - - - - 100,000
Quito Road Bridge Replacement Design6,581 (2,686) - 3,420 - 476
Quito Road Bridge Construction214,470 - - - - 214,470
Village Façade Program978 - - - 20,000 20,978
Solar Power Radar Feedback Signs24,158 - - - - 24,158
El Quito Area Curb Replacement37,553 - - - - 37,553
Annual Storm Drain Upgrades38,507 (18,073) - 81 50,000 70,353
Prospect Road Median537 (308) - - (537) (308)
Padero Erosion Mitigation12,963 - - - - 12,963
Monte Vista Storm Drain1,082 - - - (1,082) -
Canyon View/Elva Storm Drain35,000 (25,000) - - - 10,000
Village-Streetscape Improvements313,991 (8,730) - 78,357 - 226,904
Village-Phase II Construction256,800 (1,447) - - 33,400 288,753
Saratoga-Sunnyvale/Gateway Sidewalk2,525 - - - - 2,525
Total Street Projects1,906,037 (17,818) 43,433 166,433 170,000 1,935,220
Parks & Trails
Hakone Garden Koi Pond25 - - - (25) -
EL Quito Park Improvements10,999 (1,000) - 10,000 - -
Hakone Garden Retaining Wall & D/W137,379 - - - - 137,379
Hakone Garden Upper Moon House 375,000 - - - - 375,000
Park Restroom Improvements57,589 - - - - 57,589
Lower House ADA Ramp- (635) - 375 - (1,010)
Park/Trail Repairs17,681 - 8,655 1,575 25 24,787
Playground Safety Equipment39,064 (4,948) - 1,859 - 32,257
Blaney Plaza Improvements6,527 - - - - 6,527
Ravenswood Playground Improvement65,626 (44,685) - 13,785 - 7,157
Tank Trail Repair31 (31) - - - -
Mid Pen O/S Land Purchase250,000 (252,094) - - - (2,094)
Total Parks & Trails959,923 (303,393) 8,655 27,594 - 637,592
Facility Improvements
Facility Projects125,518 (5,553) - 17,782 66,665 168,847
Theater Improvement76,653 (12,454) - 2,295 (5,893) 56,011
North Campus Improvements120,446 (2,747) - - - 117,699
Corp Yard Solar Project85,337 - - - - 85,337
Vehicle Structure Solar125,000 (1,350) - - - 123,650
Library Improvements335,596 (32,343) - 7,566 - 295,687
SPCC Furniture & Fixtures4,065 - - - - 4,065
HVAC System Upgrade- (14,228) - 9,854 14,228 (9,854)
Museum HVAC Unit Replacements- - - 5,542 - (5,542)
City Hall Emergency Power Backup- (2,575) - - 61,430 58,855
Electric Charging Stations65,000 - - - - 65,000
McWilliams House Improvements4,435 - - - - 4,435
Total Facility Improvements942,051 (71,250) - 43,040 136,430 964,191
Administrative Projects
Financial System Upgrade3,534 - - - - 3,534
PW Document Imaging Project80,815 (1,885) - 1,356 10,000 87,573
CDD Document Imaging Project22,907 (786) - - - 22,121
CMO Document Imaging Project3,643 (506) - - - 3,137
IT Network Cabling Replacement- - - - 25,000 25,000
IT Emergency Power Back Up36,430 - - - (36,430) -
Total Administrative Projects147,329 (3,177) - 1,356 (1,430) 141,365
Tree Fund
Citywide Tree Planting Program12,147 (500) 300 - - 11,947
SMSCF Tree Donation Program- 2,500 - - - 2,500
Tree Dedication Program24,623 - - - - 24,623
Total Tree Fund36,771 2,000 300 - - 39,071
CIP Grant Street Repair Projects (9,850) (230,809) 113,944 121,442 - (248,157)
CIP Grant Park & Trail Projects (40,302) (235,127) - 8,157 - (283,586)
CIP Grant Administrative Projects 810 2,608 - - - 3,418
Gas Tax Fund 532,645 224,495 144,217 23,190 (106,000) 772,167
Total CIP Funds4,475,414 (632,471) 310,549 391,212 199,000 3,961,281
ATTACHMENT C
MarchJuneSe ptemberDecember
1977 5.68 5.78 5.84 6.45
1978 6.97 7.35 7.86 8.32
1979 8.81 9.10 9.26 10.06
1980 11.11 11.54 10.01 10.47
1981 11.23 11.68 12.40 11.91
1982 11.82 11.99 11.74 10.71
1983 9.87 9.64 10.04 10.18
1984 10.32 10.88 11.53 11.41
1985 10.32 9.98 9.54 9.43
1986 9.09 8.39 7.81 7.48
1987 7.24 7.21 7.54 7.97
1988 8.01 7.87 8.20 8.45
1989 8.76 9.13 8.87 8.68
1990 8.52 8.50 8.39 8.27
1991 7.97 7.38 7.00 6.52
1992 5.87 5.45 4.97 4.67
1993 4.64 4.51 4.44 4.36
1994 4.25 4.45 4.96 5.37
1995 5.76 5.98 5.89 5.76
1996 5.62 5.52 5.57 5.58
1997 5.56 5.63 5.68 5.71
1998 5.70 5.66 5.64 5.46
1999 5.19 5.08 5.21 5.49
2000 5.80 6.18 6.47 6.52
2001 6.16 5.32 4.47 3.52
2002 2.96 2.75 2.63 2.31
2003 1.98 1.77 1.63 1.56
2004 1.47 1.44 1.67 2.00
2005 2.38 2.85 3.18 3.63
2006 4.03 4.53 4.93 5.11
2007 5.17 5.23 5.24 4.96
2008 4.18 3.11 2.77 2.54
2009 1.91 1.51 0.90 0.60
2010 0.56 0.56 0.51 0.46
2011 0.51 0.48 0.38
Quarterly Apportionment Rates
Local Agency Investment Fund