HomeMy WebLinkAbout101-Treasurer’s Report for the Month Ended March 31, 2011 .pdf
MEETIN
DEPART
PREPAR
SUBJEC
RECOM
Review an
REPORT
California
City of S
submit to
disbursem
Sectio
Clerk
file a
The follo
collective
the State T
FISCAL
Cash and
As of Mar
with LAIF
flow purp
allowed to
exceeds th
NG DATE:
TMENT:
RED BY:
T: Treasur
MENDED A
nd accept the
T SUMMARY
a government
Saratoga, Arti
o the City C
ments, and fun
on 41004. R
k a written rep
copy with the
wing attachm
ely as well as
Treasurer’s O
IMPACT
d Investments
rch 31, 2011,
F. Council P
poses, to avo
o fall below $
he minimum
SA
May 4, 2011
Finance & A
Ann Xu, Acc
rer’s Report
ACTION
Treasurer’s R
Y
t code section
icle 2-20, Se
Clerk and the
nd balances.
Regularly, at l
port and accou
e legislative b
ments provide
specifically f
Office of Quar
s Balance by F
, the City had
Policy on ope
id occurrence
$2,000,000. T
limit required
Unrestrict
Comerica
Deposit w
Total Unr
ARATOGA
Administrative
countant
for the Mont
Report for the
n 41004 requ
ction 2-20.03
e legislative
east once eac
unting of all
body.
e various fina
for the City’s
rterly LAIF ra
Fund
d $9,199 in ca
erating reserv
e of dry peri
The total pool
d.
ted Cash
Bank
ith LAIF
restricted C
Cas
A CITY C
e Services
th Ended Ma
e month ende
uires that the
35, designate
body a writ
ch month, the
receipts, disb
ancial transac
General (Op
ates from the
ash deposit at
ve funds, adop
od financing
led cash balan
ash
sh Summary
OUNCIL
AGENDA
CITY M
DEPT H
arch 31, 2011
d March 31, 2
City Treasur
es the City M
tten report a
e City Treasu
bursements, a
ction data for
perating) Fund
1st Quarter of
Comerica ba
pted on Apri
, pooled cash
nce as of Mar
$
13,40$
13,414$
A ITEM:
MANAGER:
HEAD: Mary F
1
2011.
rer (the Mun
Manager as th
and accountin
urer shall subm
and fund balan
r the City of
d, including a
f 1977 to pres
ank, and $13,4
l 20, 1994, st
h from all fu
rch 31, 2011 i
9,199
05,205
4,403
Dave Ander
Furey
nicipal Code o
he City Trea
ng of all rec
mit to the Cit
nces. He sha
f Saratoga’s F
an attachment
sent.
405,205 on d
tates that: for
unds should n
is $13,414,40
rson
of the
asurer)
ceipts,
ty
all
Funds
t from
eposit
r cash
not be
03 and
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
N/A
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,414,403$
Plus: Assets240,015
Less: Liabilities (1,489,781)
Ending Fund Balance12,164,637$
Adjusting Cash to Ending Fund Balance
ATTACHMENT A
CHANGES IN TOTAL FUND BALANCE
Fund Description
Fund
Balance
7/1/10
Increase/
(Decrease)
Jul-Feb
Current
Revenue
Current
Expenditure Transfers
Fund
Balance
3/31/11
General
Undesignated Unreserved Balance1,284,366 (1,421,850) 1,090,727 1,061,816 106,000 326,026
Reserved Fund Balance:
Petty Cash Reserve1,300 - - - - 1,300
Designated Fund Balances:
Designated for Operations 2,889,077 - - - - 2,889,077
Designated Economic Uncertainty 1,500,000 - - - - 1,500,000
Designated for Development 632,380 (210,000) - - - 422,380
Designated for Environmental 563,182 (50,000) - - - 513,182
Designated for Uncollected Deposits44,791 - - - - 44,791
Designated for Hillside Reserve300,000 - - - (50,000) 250,000
Designated for Capital Project Reserve126,983 - (126,983) -
Designated for CIP Matching Grant600,000 - - - (600,000) -
Designated for Carryforward68,600 (68,600) - - - -
Subtotal 8,010,679 (1,750,450) 1,090,727 1,061,816 (670,983) 5,946,756
Special Revenue
Landscape/Lighting Districts440,391 (8,725) 19,889 22,102 - 429,453
CDBG Federal Grants(9,621) 138,452 100,199 - (116,678) 112,352
SHARP Loan210,034 345 188 - - 210,567
Capital Project
Street Projects2,169,661 (312,239) (237,310) 123,896 443,661 1,939,876
Park and Trail Projects653,881 (114,036) - 10,385 150,000 679,460
Facility Improvement Projects525,256 (169,225) 641 37,424 751,360 1,070,608
Administrative Projects224,773 (58,937) - 8,732 - 157,104
Tree Fine Fund16,985 (3,780) 500 1,830 25,000 36,874
CIP Grant Fund - Street Repair(118,073) (241,341) 69,365 1,741 - (291,789)
CIP Grant Fund - Park & Trail(46,013) (261,050) - 80,232 - (387,295)
Gas Tax Fund279,470 294,195 122,321 26,211 (106,000) 563,774
Debt Service
Library Bond 892,593 (513,265) 484 - - 379,811
Internal Service Fund
Liability/Risk Management244,562 (126,486) 29,764 (1,249) (50,000) 99,089
Workers Compensation198,592 27,077 (250) 7,829 (25,000) 192,590
Office Stores Fund26,830 (1,061) 770 3,070 - 23,470
Information Technology Services 213,940 52,095 - 24,373 - 241,662
Equipment Maintenance54,258 25,574 - 18,403 - 61,429
Building Maintenance202,570 87,474 - 39,260 - 250,784
Equipment Replacement236,229 71,723 - - (25,000) 282,951
Technology Replacement186,686 29,198 - 25,772 (25,000) 165,111
Trust/Agency
Library Fund351,360 - - - (351,360) -
KSAR - Community Access TV109,842 (109,748) (95) - - -
Total City15,074,884 (2,944,213) 1,197,195 1,491,827 - 12,164,637
ATTACHMENT B
FUND BALANCES BY CIP PROJECT
CIP Funds/Projects
Fund
Balance
7/1/10
Increase/
(Decrease)
Jul-Feb
Current
Revenue
Current
Expenditure Transfers
Fund
Balance
3/31/11
Street Projects
Traffic Safety168,497 (62,425) - 63,044 52,980 96,008
Highway 9 Safety Project50,008 53,099 (63,387) - 39,720
Annual Street Resurfacing Project529,434 (258,660) 32,031 23,590 (65,000) 214,215
Sidewalks Annual Project87,092 (5,535) - 4,863 1,581 78,276
2010 VTA - FED STP Grant- - - - 65,000 65,000
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 Design9,730 - - - 9,730
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
Sobey Road Culvert Repair50,000 (31,994) - (1,572) (19,578) -
Annual Storm Drain Upgrade53,883 (16,720) - - 2,358 39,520
Village Trees & Lights at Sidestreets25,336 (25,336) - - -
Prospect Road Median51,663 (972) - - (50,000) 691
City Entrance Sign/Monument23,788 - - - (23,788) -
Padero Erosion Mitigation- - - - 50,000 50,000
Monte Vista Storm Drain- (63,831) - 27,307 92,220 1,082
Canyon View/Elva Drain- - - - 35,000 35,000
Village-Streetscape Impv 549,952 172,765 (205,954) - (16,029) 500,735
Village-Phase II Design- - - - 33,400 33,400
Village-Phase II Construction- - - - 223,400 223,400
Saratoga-Sunnyvale/Gateway Sidewalk4,107 (72,631) - 6,664 62,117 (13,072)
Total Street Projects2,169,661 (312,239) (237,310) 123,896 443,661 1,939,876
Parks & Trails
Hakone Garden Koi Pond15,600 (9,875) - - 5,725
EL Quito Park Improvements27,571 (1,847) - 5 25,719
Historical Park Landscape50,588 (53,097) - - (2,509)
Hakone Garden Retaining Wall & D/W142,829 - - - 142,829
Hakone Garden Upper Moon House 125,000 - - - 125,000
West Valley Soccer Field(8,201) - - - (8,201)
Park/Trail Repairs23,762 (5,703) - - 18,059
Playground Safety Equipment- - - 8,680 50,000 41,321
Blaney Plaza Improvements- (18,473) - - 25,000 6,527
Ravenswood Playground Improvement- (42) - - 75,000 74,958
Tank Trail Repair26,731 (25,000) - 1,700 31
Mid Pen O/S Land Purchase250,000 - - - 250,000
Total Parks & Trails653,881 (114,036) - 10,385 150,000 679,460
Facility Improvements
Facility Projects81,070 (4,395) 125 4,532 117,923 190,190
Civic Center Improvement20 - - - (20) -
Theater Improvement71,472 14,729 - 1,882 84,320
Senior Center Minor Building Improvement1,050 (1,050) - - 1,050 1,050
Senior Center Furniture & Fixture- (23,569) - - 28,000 4,431
Portable Building Gutters2,460 (2,460) - - 2,460 2,460
North Campus Improvements3,920 (23,468) - 28,353 175,000 127,099
HVAC System Upgrade117,949 (117,016) - - (932) -
Corp Yard Solar Project93,250 - - - 93,250
Vehicle Structure Solar125,000 - - - 125,000
Library Improvement15,000 (2,684) 516 1,065 351,360 363,127
SPCC Furniture & Fixture4,065 (3,746) - (256) 1,820 2,394
Museum Storage Bldg- - - 1,848 2,000 152
Hot Water Pump- - - - 2,500 2,500
Electric Upgrades- - - - 5,200 5,200
Electric Charging Station- - - - 65,000 65,000
McWilliams House Improvement10,000 (5,565) - - 4,435
Total Facility Improvements525,256 (169,225) 641 37,424 751,360 1,070,608
Administrative Projects
Financial System Upgrade3,534 - - - 3,534
Document Imaging Project85,183 - - 2,236 82,947
CDD Document Imaging Project31,989 (671) - 6,073 25,245
CMO Document Imaging Project8,887 (3,266) - 423 5,198
Telecommunication System55,000 (55,000) - - -
IT Emergency Power Back40,180 - - - 40,180
Total Administrative Projects224,773 (58,937) - 8,732 - 157,104
Tree Fine Fund
Tree Fine Fund16,985 (3,780) 500 1,830 25,000 36,874
CIP Fund - Street Repair
CIP Grant Fund(118,073) (241,341) 69,365 1,741 (291,789)
CIP Fund - Park & Trail
CIP Grant Fund(46,013) (261,050) - 80,232 (387,295)
Gas Fund
Gas Tax Fund279,470 294,195 122,321 26,211 (106,000) 563,774
Total CIP Funds3,687,624 (866,414) (44,482) 290,452 1,264,020 3,768,612
ATTACHMENT C
MarchJuneSeptemberDecember
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
Quarterly Apportionment Rates
Local Agency Investment Fund