The URL can be used to link to this page

Home My WebLink About101-Treasurer’s Report for the Month Ended July 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 July 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 September 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 he City had $1 Policy on ope id occurrence $2,000,000. limit required 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 140,330 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 Jul 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 ly 31, 2011 d July 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 Ju 14$ 14,49$ 14,635$ A ITEM: MANAGER: HEAD: Mary F 11. 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,4 l 20, 1994, st h from all fu uly 31, 2011 i 40,330 95,102 5,432 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. 495,102 on d tates that: for unds should n is $14,635,43 rson rk and . The ger as ty all Funds t from eposit r cash not be 32 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 Cash14,635,432$ Plus: Assets241,309 Less: Liabilities (1,654,162) Ending Fund Balance13,222,579$ Adjusting Cash to Ending Fund Balance ATTACHMENT A CHANGES IN TOTAL FUND BALANCE Fund Description Fund Balance 7/1/11 Increase/ (Decrease) Jul Current Revenue Current Expenditure Transfers Fund Balance 7/31/11 General Undesignated Unreserved Balance1,788,185 - 353,533 511,776 - 1,629,942 Reserved Fund Balance: Petty Cash Reserve1,450 - - - - 1,450 Designated Fund Balances: Designated for Operations 2,889,077 - - - - 2,889,077 Designated Economic Uncertainty 1,500,000 - - - - 1,500,000 Designated for Development 422,380 - - - - 422,380 Designated for Environmental 513,182 - - - - 513,182 Designated for Uncollected Deposits44,791 - - - - 44,791 Designated for Hillside Reserve250,000 - - - - 250,000 Designated for Capital Project Reserve75,000 - - 75,000 Subtotal 7,484,064 - 353,533 511,776 - 7,325,822 Special Revenue Landscape/Lighting Districts504,127 - - - - 504,127 CDBG Federal Grants- - - - - - Capital Project Street Projects1,906,037 - 73,421 6,641 - 1,972,817 Park and Trail Projects959,923 - - - - 959,923 Facility Improvement Projects942,049 - - - - 942,049 Administrative Projects147,329 - - - - 147,329 Tree Fund36,771 - - - - 36,771 CIP Grant Street Repair Projects(246,279) - - - - (246,279) CIP Grant Park & Trail Projects(152,888) - - 1,198 - (154,086) CIP Grant Administration 810 - - - - 810 Gas Tax Fund532,645 - - - - 532,645 Debt Service Library Bond 850,657 - - 696,328 - 154,329 Internal Service Fund Liability/Risk Management134,905 - 6,950 254,252 - (112,396) Workers Compensation224,104 - - 1,117 - 222,987 Office Stores Fund15,831 - 578 2,898 - 13,511 Information Technology Services 231,063 - - 43,902 - 187,161 Equipment Maintenance42,817 - - 4,632 - 38,185 Building Maintenance208,518 - - 28,582 - 179,936 Equipment Replacement331,373 - - - - 331,373 Technology Replacement185,567 - - - - 185,567 Total City14,339,422 - 434,482 1,551,325 - 13,222,579 ATTACHMENT B FUND BALANCES BY CIP PROJECT CIP Funds/Projects Fund Balance 7/1/11 Increase/ (Decrease) Jul Current Revenue Current Expenditure Transfers Fund Balance 7/31/11 Street Projects Traffic Safety129,793 - - - - 129,793 Highway 9 Safety Project36,033 - - - - 36,033 Annual Street Resurfacing Project 388,149 - 73,421 6,641 - 454,929 Sidewalks Annual Project52,905 - - - - 52,905 2010 VTA - FED STP Grant65,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 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 - - - - 38,507 Prospect Road Median537 - - - - 537 Padero Erosion Mitigation12,963 - - - - 12,963 Monte Vista Storm Drain1,082 - - - - 1,082 Canyon View/Elva Drain35,000 - - - - 35,000 Village-Streetscape Impv 313,991 - - - - 313,991 Village-Phase II Construction256,800 - - - - 256,800 Saratoga-Sunnyvale/Gateway Sidewalk2,525 - - - - 2,525 Total Street Projects1,906,037 - 73,421 6,641 - 1,972,817 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 Park/Trail Repairs17,681 - - - - 17,681 Playground Safety Equipment39,064 - - - - 39,064 Blaney Plaza Improvements6,527 - - - - 6,527 Ravenswood Playground Improvement65,626 - - - - 65,626 Tank Trail Repair31 - - - - 31 Mid Pen O/S Land Purchase250,000 - - - - 250,000 Total Parks & Trails959,923 - - - - 959,923 Facility Improvements Facility Projects125,518 - - - - 125,518 Theater Improvement76,653 - - - - 76,653 North Campus Improvements120,446 - - - - 120,446 Corp Yard Solar Project85,337 - - - - 85,337 Vehicle Structure Solar125,000 - - - - 125,000 Library Improvement335,596 - - - - 335,596 SPCC Furniture & Fixture4,065 - - - - 4,065 Electric Charging Station65,000 - - - - 65,000 McWilliams House Improvement4,435 - - - - 4,435 Total Facility Improvements942,049 - - - - 942,049 Administrative Projects Financial System Upgrade3,534 - - - - 3,534 Document Imaging Project80,815 - - - - 80,815 CDD Document Imaging Project22,907 - - - - 22,907 CMO Document Imaging Project3,643 - - - - 3,643 IT Emergency Power Back36,430 - - - - 36,430 Total Administrative Projects147,329 - - - - 147,329 Tree Fund Citywide Tree Planting12,147 - - - - 12,147 Tree Dedication Program24,623 - - - - 24,623 Total Tree Fund36,771 - - - - 36,771 CIP Grant Street Repair Projects (246,279) - - - - (246,279) CIP Grant Park & Trail Projects (152,888) - - 1,198 - (154,086) CIP Grant Administration 810 - - - - 810 Gas Tax Fund 532,645 - - - - 532,645 Total CIP Funds4,126,396 - 73,421 7,838 - 4,191,978 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 Quarterly Apportionment Rates Local Agency Investment Fund