HomeMy WebLinkAbout101-Treasurer’s Report for the Month Ended September 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 Sep
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
ptember 30, 2
with LAIF. Co
w purposes, to
o fall below $
eds the minim
SA
November 2,
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
2011, the City
ouncil Policy
avoid occurr
$2,000,000. T
mum limit requ
Unrestrict
Comerica
Deposit wi
Total Unr
ARATOGA
, 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 $135,14
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 Sep
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
44 in cash dep
g reserve fund
period financin
led cash balan
ash
sh Summary
OUNCIL
AGENDA
CITY M
DIRECT
ptember 30,
d September
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 Sep
13$
13,32$
13,463$
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
tember 30, 20
35,144
28,225
3,369
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 $13,328,2
994, states tha
funds should n
011 is $13,46
rson
rk and
. The
ger as
ty
all
Funds
t from
225 on
at: for
not be
63,369
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.
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
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
B – Change in Total Fund Balances by CIP Project
C – Local Agency Investment Fund (LAIF) Quarterly Apportionment Rates
Total Unrestricted Cash13,463,369$
Plus: Assets89,330
Less: Liabilities (1,302,830)
Ending Fund Balance12,249,869$
Adjusting Cash to Ending Fund Balance
ATTACHMENT A
CHANGES IN TOTAL FUND BALANCE
Fund Description
Fund
Balance
7/1/11
Increase/
(Decrease)
Jul-Aug
Current
Revenue
Current
Expenditure Transfers
Fund Balance
9/30/11
General
Undesignated Unreserved Balance563,290 (1,194,614) 720,608 803,039 6,000 (707,755.23)
Designated Fund Balances:
Designated for Operations 2,903,522 - - - - 2,903,522
Designated Economic Uncertainty 1,500,000 - - - - 1,500,000
Designated for Development 632,380 - - - - 632,380
Designated for Environmental 513,182 - - - - 513,182
Designated for Uncollected Deposits44,791 - - - - 44,791
Designated for Hillside Reserve500,000 - - - - 500,000
Designated for Capital Project Reserve500,000 - (160,000) 340,000
Designated for Carryforward326,900 - - - - 326,900
Subtotal 7,484,065 (1,194,614) 720,608 803,039 (154,000) 6,053,020
Special Revenue
Landscape/Lighting Districts504,125 (57,258) 888 15,837 - 431,918
CDBG Federal Grants- - - - - -
Capital Project
Street Projects1,906,037 81,238 29,895 89,295 150,000 2,077,875
Park and Trail Projects959,923 (2,094) - 36,688 - 921,141
Facility Improvement Projects942,051 169 397 65,285 136,430 1,013,762
Administrative Projects147,329 (3,235) - (58) (1,430) 142,721
Tree Fund36,771 2,500 - 500 - 38,771
CIP Grant Street Repair Projects(246,279) 33,804 - 2,317 - (214,792)
CIP Grant Park & Trail Projects(152,888) (35,093) - 59,427 - (247,408)
CIP Grant Administrative Projects810 - - 2,617 - (1,806)
Gas Tax Fund532,645 153,283 73,338 - (106,000) 653,266
Debt Service
Library Bond 850,657 (695,020) 1,036 883 - 155,790
Internal Service Fund
Liability/Risk Management134,905 (175,755) - 3,465 - (44,314)
Workers Compensation224,104 864 1,059 800 - 225,228
Office Stores Fund15,831 6,427 584 3,441 - 19,401
Information Technology Services 231,063 23,225 - 27,700 - 226,588
Equipment Maintenance42,817 24,559 - 14,673 - 52,703
Building Maintenance208,518 82,132 - 52,056 - 238,593
Equipment Replacement331,373 15,000 - - - 346,373
Technology Replacement185,567 12,124 - 11,650 (25,000) 161,041
Total City14,339,422 (1,727,743) 827,805 1,189,615 - 12,249,869
ATTACHMENT B
FUND BALANCES BY CIP PROJECT
CIP Funds/Projects
Fund
Balance
7/1/11
Increase/
(Decrease)
Jul-Aug
Current
Revenue
Current
Expenditure Transfers
Fund
Balance
9/30/11
Street Projects
Traffic Safety129,793 (6,225) - 14,386 50,000 159,181
Highway 9 Safety Project36,033 (2,000) - 168 90,000 123,865
Annual Street Resurfacing Project453,149 88,050 29,895 25,983 (121,781) 423,331
Annual Sidewalks Project52,905 - - 2,500 50,000 100,405
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 - - - - 6,581
Quito Road Bridge Construction214,470 - - - - 214,470
Village Façade Program978 - - - - 978
Solar Power Radar Feedback Signs24,158 - - - - 24,158
El Quito Area Curb Replacement37,553 - - - - 37,553
Annual Storm Drain Upgrade38,507 1,413 - 19,486 50,000 70,434
Prospect Road Median537 - - - (537) -
Padero Erosion Mitigation12,963 - - - - 12,963
Monte Vista Storm Drain1,082 - - - (1,082) -
Canyon View/Elva Drain35,000 - - 25,000 - 10,000
Village-Streetscape Impv 313,991 - - 1,772 - 312,220
Village-Phase II Construction256,800 - - - 33,400 290,200
Saratoga-Sunnyvale/Gateway Sidewalk2,525 - - - - 2,525
Total Street Projects1,906,037 81,238 29,895 89,295 150,000 2,077,875
Parks & Trails
Hakone Garden Koi Pond25 - - - - 25
EL Quito Park Improvements10,999 - - - - 10,999
Hakone Garden Retaining Wall & D/W137,379 - - - - 137,379
Hakone Garden Upper Moon House 375,000 - - - - 375,000
Park Restroom Improvement57,589 - - - - 57,589
Lower House ADA Ramp- - - 630 - (630)
Park/Trail Repairs17,681 - - - - 17,681
Playground Safety Equipment39,064 - - 2,300 - 36,764
Blaney Plaza Improvements6,527 - - - - 6,527
Ravenswood Playground Improvement65,626 - - 33,758 - 31,869
Tank Trail Repair31 - - - - 31
Mid Pen O/S Land Purchase250,000 (2,094) - - - 247,906
Total Parks & Trails959,923 (2,094) - 36,688 - 921,141
Facility Improvements
Facility Projects125,518 - - 3,258 66,635 188,895
Theater Improvement76,653 6,092 - 13,036 (5,863) 63,846
North Campus Improvements120,446 - - 2,747 - 117,699
Corp Yard Solar Project85,337 - - - - 85,337
Vehicle Structure Solar125,000 - - 1,350 - 123,650
Library Improvement335,596 (5,923) 397 28,091 - 301,979
SPCC Furniture & Fixture4,065 - - - - 4,065
HVAC System Upgrade- - - 14,228 14,228 -
Electric Upgrades- - - 2,575 61,430 58,855
Electric Charging Station65,000 - - - - 65,000
McWilliams House Improvement4,435 - - - - 4,435
Total Facility Improvements942,051 169 397 65,285 136,430 1,013,762
Administrative Projects
Financial System Upgrade3,534 - - - - 3,534
Document Imaging Project80,815 (854) - 1,031 10,000 88,930
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 Back36,430 (1,875) - (1,875) (36,430) -
Total Administrative Projects147,329 (3,235) - (58) (1,430) 142,721
Tree Fund
Citywide Tree Planting12,147 - - 500 - 11,647
SMSCF Tree Donation Fund- 2,500 - - - 2,500
Tree Dedication Program24,623 - - - - 24,623
Total Tree Fund36,771 2,500 - 500 - 38,771
CIP Grant Street Repair Projects (246,279) 33,804 - 2,317 - (214,792)
CIP Grant Park & Trail Projects (152,888) (35,093) - 59,427 - (247,408)
CIP Grant Administrative Projects 810 - - 2,617 - (1,806)
Gas Tax Fund 532,645 153,283 73,338 - (106,000) 653,266
Total CIP Funds4,126,399 230,573 103,630 256,071 179,000 4,383,530
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