The URL can be used to link to this page

Home My WebLink About101-Treasurer�s Report for the Month Ended May 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 May with LAIF flow purp allowed to exceeds th 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 y 31, 2011, th F. Council P poses, to avo o fall below $ he minimum SA August 17, 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 he City had $5 Policy on ope id occurrence $2,000,000. limit required Unrestrict Comerica Deposit wi Total Unr ARATOGA 011 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 590,023 in ca erating reserv e of dry peri The total poo d. ted Cash Bank ith LAIF restricted Ca Cas A CITY C e Services th Ended Ma 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 ash deposit at ve funds, adop od financing oled cash bala ash sh Summary OUNCIL AGENDA CITY M DEPT H ay 31, 2011 d May 31, 20 City Treasure eipts, disburse on 2-20.035 d e City Treasu bursements, a ction data for perating) Fund 1st Quarter of Comerica ba pted on Apri , pooled cash ance as of Ma 59$ 14,92$ 15,518$ A ITEM: MANAGER: HEAD: Mary F 011. 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 ank, and $14,9 l 20, 1994, st h from all fu ay 31, 2011 i 90,023 28,205 8,228 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. 928,205 on de tates that: for unds should n is $15,518,22 rson rk and . The ger as ty all Funds t from eposit r cash not be 28 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 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 Cash15,518,228$ Plus: Assets223,265 Less: Liabilities (1,116,143) Ending Fund Balance14,625,350$ Adjusting Cash to Ending Fund Balance ATTACHMENT A CHANGES IN TOTAL FUND BALANCE Fund Description Fund Balance 7/1/10 Increase/ (Decrease) Jul-Apr Current Revenue Current Expenditure Transfers Fund Balance 5/31/11 General Undesignated Unreserved Balance1,284,366 530,800 809,797 1,048,747 149,550 2,054,367 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 - (51,983) 75,000 Designated for CIP Matching Grant600,000 - - - (600,000) - Designated for Carryforward68,600 (68,600) - - - - Subtotal 8,010,679 202,200 809,797 1,048,747 (552,433) 7,750,097 Special Revenue Landscape/Lighting Districts440,391 (31,006) 644 90 - 409,940 CDBG Federal Grants(9,621) 249,540 - - (239,919) - SHARP Loan210,034 533 - - - 210,567 Capital Project Street Projects2,169,661 (609,577) (3,682) 68,219 523,352 2,011,534 Park and Trail Projects653,880 254,189 - 1,007 75,000 982,062 Facility Improvement Projects525,256 (235,374) 12,076 9,507 751,360 1,043,811 Administrative Projects224,773 (72,122) - - - 152,651 Tree Fund16,985 (4,920) 250 - 25,000 37,314 CIP Grant Street Repair Projects(118,073) (225,576) 108,928 (126,184) - (108,537) CIP Grant Park & Trail Projects(46,013) (125,603) - 4,867 - (176,483) CIP Grant Administration - (901) - 3,002 - (3,903) Gas Tax Fund279,470 308,699 156,124 147,819 (106,000) 490,474 Debt Service Library Bond 892,593 (502,294) 4,434 795 - 393,938 Internal Service Fund Liability/Risk Management244,562 (62,258) - 57,485 (50,000) 74,819 Workers Compensation198,592 26,265 4,183 2,152 (25,000) 201,888 Office Stores Fund26,830 (776) 762 4,142 - 22,675 Information Technology Services 213,940 83,799 - 25,563 - 272,176 Equipment Maintenance54,258 29,262 - 12,752 - 70,767 Building Maintenance202,570 159,813 - 57,855 - 304,528 Equipment Replacement236,229 96,723 - - (25,000) 307,951 Technology Replacement186,686 14,943 - (455) (25,000) 177,083 Trust/Agency Library Fund351,360 - - - (351,360) - KSAR - Community Access TV109,842 (109,842) - - - - Total City15,074,883 (554,285) 1,093,516 1,317,362 - 14,625,350 ATTACHMENT B FUND BALANCES BY CIP PROJECT CIP Funds/Projects Fund Balance 7/1/10 Increase/ (Decrease) Jul-Apr Current Revenue Current Expenditure Transfers Fund Balance 5/31/11 Street Projects Traffic Safety168,497 (145,494) - 4,054 90,887 109,836 Highway 9 Safety Project50,008 91,311 (108,928) 550 - 31,842 Annual Street Resurfacing Project529,434 (251,022) 105,246 (67,740) (65,000) 386,397 Sidewalks Annual Project87,092 (25,000) - - 1,581 63,674 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 (2,300) - - - 7,430 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) - - (18,006) - Annual Storm Drain Upgrade53,883 (15,148) - 930 786 38,590 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- (91,138) - - 92,220 1,082 Canyon View/Elva Drain- - - - 35,000 35,000 Village-Streetscape Impv 549,952 (33,189) - 130,426 (16,029) 370,309 Village-Phase II Design- - (33,400) - 33,400 - Village-Phase II Construction- - 33,400 - 223,400 256,800 Saratoga-Sunnyvale/Gateway Sidewalk4,107 (79,295) - - 103,900 28,712 Total Street Projects2,169,661 (609,577) (3,682) 68,219 523,352 2,011,534 Parks & Trails Hakone Garden Koi Pond15,600 (9,875) - - - 5,725 EL Quito Park Improvements27,571 (16,542) - 30 - 10,999 Historical Park Landscape50,588 (50,588) - - - - Hakone Garden Retaining Wall & D/W142,829 - - - - 142,829 Lower House ADA Ramp- - - 977 - (977) Hakone Garden Upper Moon House 125,000 250,000 - - - 375,000 Park Restroom Improvement- 57,589 - - - 57,589 West Valley Soccer Field(8,202) 8,202 - - - - 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- 74,958 - - - 74,958 Tank Trail Repair26,731 (26,700) - - - 31 Mid Pen O/S Land Purchase250,000 - - - - 250,000 Total Parks & Trails653,880 254,189 - 1,007 75,000 982,062 Facility Improvements Facility Projects84,580 (8,887) - - 110,062 185,755 Civic Center Improvement20 - - - (20) - Theater Improvement71,472 (11,599) 12,076 117 5,935 77,767 Senior Center Minor Building Improvement- (1,050) - - 1,050 - Senior Center Furniture & Fixture- (26,064) - 370 28,000 1,566 Portable Building Gutters- (2,460) - - 2,460 - North Campus Improvements3,920 (54,162) - 4,219 175,000 120,539 HVAC System Upgrade117,949 (117,016) - - (932) - Corp Yard Solar Project93,250 - - - - 93,250 Vehicle Structure Solar125,000 - - - - 125,000 Library Improvement15,000 (3,233) - - 351,360 363,127 SPCC Furniture & Fixture4,065 (3,490) - - 3,746 4,320 Museum Storage Bldg- (1,848) - - 2,000 152 Hot Water Pump- - - - 2,500 2,500 Electric Upgrades- - - 4,800 5,200 400 Electric Charging Station- - - - 65,000 65,000 McWilliams House Improvement10,000 (5,565) - - 4,435 Total Facility Improvements525,256 (235,374) 12,076 9,507 751,360 1,043,811 Administrative Projects Financial System Upgrade3,534 - - - - 3,534 Document Imaging Project85,183 (3,381) - - - 81,803 CDD Document Imaging Project31,989 (9,082) - - - 22,907 CMO Document Imaging Project8,887 (4,659) - - - 4,228 Telecommunication System55,000 (55,000) - - - - IT Emergency Power Back40,180 - - - - 40,180 Total Administrative Projects224,773 (72,122) - - - 152,651 Tree Fund Citywide Tree Planting16,985 (4,692) - - - 12,292 Tree Dedication Program- (228) 250 - 25,000 25,022 Total Tree Fund16,985 (4,920) 250 - 25,000 37,314 CIP Grant Street Repair Projects (118,073) (225,576) 108,928 (126,184) - (108,537) CIP Grant Park & Trail Projects (46,013) (125,603) - 4,867 - (176,483) CIP Grant Administration - (901) - 3,002 - (3,903) Gas Tax Fund 279,470 308,699 156,124 147,819 (106,000) 490,474 Total CIP Funds3,705,938 (711,186) 273,696 108,236 1,268,711 4,428,923 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