HomeMy WebLinkAbout101-Treasurer’s Report for the Month Ended October 31, 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 Oct
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
tober 31, 201
with LAIF. Co
w purposes, to
o fall below $
eds the minim
SA
December 7,
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
11, the City h
ouncil Policy
avoid occurr
$2,000,000.
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
had $149,068
on operating
rence of dry p
The total poo
uired.
ted Cash
Bank
ith LAIF
restricted Ca
Cas
A CITY C
e Services
th Ended Oc
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
8 in cash dep
g reserve fund
period financin
oled cash bal
ash
s h Summary
OUNCIL
AGENDA
CITY M
DIRECT
ctober 31, 20
d October 31
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
lance as of O
14$
12,57$
12,726$
A ITEM:
MANAGER:
TOR: Mary F
11
, 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
October 31, 20
49,068
77,225
6,293
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 $12,577,2
994, states tha
funds should n
011 is $12,72
rson
rk and
. The
ger as
ty
all
Funds
t from
25 on
at: for
not be
26,293
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 Cash12,726,293$
Plus: Assets94,519
Less: Liabilities (1,335,584)
Ending Fund Balance11,485,228$
Adjusting Cash to Ending Fund Balance
ATTACHMENT A
CHANGES IN TOTAL FUND BALANCE
Fund Description
Fund
Balance
7/1/11
Increase/
(Decrease)
Jul-Sep
Current
Revenue
Current
Expenditure Transfers
Fund Balance
10/31/11
General
Undesignated Unreserved Balance563,290 (1,277,045) 951,224 1,633,226 (14,000) (1,409,757)
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,277,045) 951,224 1,633,226 (174,000) 5,351,018
Special Revenue
Landscape/Lighting Districts504,125 (72,207) 11,298 55,664 - 387,552
CDBG Federal Grants- - 7,087 - - 7,087
Capital Project
Street Projects1,906,037 21,838 54,323 93,979 170,000 2,058,220
Park and Trail Projects959,923 (38,782) - 264,611 - 656,530
Facility Improvement Projects942,051 (64,719) (2,295) 4,236 136,430 1,007,231
Administrative Projects147,329 (3,177) - - (1,430) 142,721
Tree Fund36,771 2,000 - - - 38,771
CIP Grant Street Repair Projects(9,850) 31,487 (236,429) 25,867 - (240,659)
CIP Grant Park & Trail Projects(40,302) (94,519) (112,586) 28,021 - (275,429)
CIP Grant Administrative Projects810 (2,617) 5,224 - - 3,418
Gas Tax Fund532,645 226,621 - 2,126 (106,000) 651,140
Debt Service
Library Bond 850,657 (694,867) 4,983 - - 160,773
Internal Service Fund
Liability/Risk Management134,905 (179,220) 77,160 3,748 - 29,097
Workers Compensation224,104 1,124 53,750 54,685 - 224,293
Office Stores Fund15,831 3,570 10,664 3,772 - 26,294
Information Technology Services 231,063 (4,475) 100,000 34,122 - 292,466
Equipment Maintenance42,817 9,886 50,000 26,120 - 76,583
Building Maintenance208,518 30,076 181,250 66,604 - 353,239
Equipment Replacement331,373 15,000 25,000 - - 371,373
Technology Replacement185,567 474 12,500 10,031 (25,000) 163,510
Total City14,688,437 (2,089,553) 1,193,153 2,306,809 - 11,485,228
ATTACHMENT B
FUND BALANCES BY CIP PROJECT
CIP Funds/Projects
Fund
Balance
7/1/11
Increase/
(Decrease)
Jul-Sep
Current
Revenue
Current
Expenditure Transfers
Fund
Balance
10/31/11
Street Projects
Traffic Safety129,793 (20,611) - 49,531 50,000 109,651
Highway 9 Safety Project36,033 (2,168) - 899 90,000 122,966
Annual Street Resurfacing Project453,149 91,963 54,323 32,151 (121,781) 445,503
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 - - 2,686 - 3,895
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 Upgrade38,507 (18,073) - - 50,000 70,434
Prospect Road Median537 - - 308 (537) (308)
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) - 6,958 - 305,262
Village-Phase II Construction256,800 - - 1,447 33,400 288,753
Saratoga-Sunnyvale/Gateway Sidewalk2,525 - - - - 2,525
Total Street Projects1,906,037 21,838 54,323 93,979 170,000 2,058,220
Parks & Trails
Hakone Garden Koi Pond25 - - - - 25
EL Quito Park Improvements10,999 - - 1,000 - 9,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) - 5 - (635)
Park/Trail Repairs17,681 - - - - 17,681
Playground Safety Equipment39,064 (2,300) - 2,648 - 34,116
Blaney Plaza Improvements6,527 - - - - 6,527
Ravenswood Playground Improvement65,626 (33,758) - 10,927 - 20,942
Tank Trail Repair31 - - 31 - -
Mid Pen O/S Land Purchase250,000 (2,094) - 250,000 - (2,094)
Total Parks & Trails959,923 (38,782) - 264,611 - 656,530
Facility Improvements
Facility Projects125,518 (3,258) (2,295) - 66,665 186,629
Theater Improvement76,653 (6,944) - 5,510 (5,893) 58,306
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 (33,617) - (1,274) - 303,253
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 (64,719) (2,295) 4,236 136,430 1,007,231
Administrative Projects
Financial System Upgrade3,534 - - - - 3,534
Document Imaging Project80,815 (1,885) - - 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 - - - (36,430) -
Total Administrative Projects147,329 (3,177) - - (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,000 - - - 38,771
CIP Grant Street Repair Projects (9,850) 31,487 (236,429) 25,867 - (240,659)
CIP Grant Park & Trail Projects (40,302) (94,519) (112,586) 28,021 - (275,429)
CIP Grant Administrative Projects 810 (2,617) 5,224 - - 3,418
Gas Tax Fund 532,645 226,621 - 2,126 (106,000) 651,140
Total CIP Funds4,475,414 78,132 (291,763) 418,839 199,000 4,041,943
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 Ag ency Investment Fund