The URL can be used to link to this page

Home My WebLink About101-Treasurer’s Report for the Month Ended August 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 Au 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 ugust 31, 201 with LAIF. Co w purposes, to o fall below eds the minim SA October 5, 20 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 1, the City h ouncil Policy avoid occurr $2,000,000. mum limit requ 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 had $191,842 on operating rence of dry p The total po uired. ted Cash Bank ith LAIF restricted Ca Cas A CITY C e Services th Ended Au 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 in cash depo g reserve fund period financin oled cash bal ash sh Summary OUNCIL AGENDA CITY M DIRECT ugust 31, 201 d August 31, City Treasure eipts, disburse on 2-20.035 d e City Treasu bursements, a ction data for perating) Fund 1st Quarter of osit at Come ds, adopted on ng, pooled ca lance as of A 19$ 14,24$ 14,437$ A ITEM: MANAGER: TOR: Mary F 1 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 August 31, 20 91,842 45,592 7,434 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 $14,245,5 994, states tha funds should n 011 is $14,43 rson rk and . The ger as ty all Funds t from 92 on at: for not be 37,434 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,437,434$ Plus: Assets132,287 Less: Liabilities (2,118,042) Ending Fund Balance12,451,679$ 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 8/31/11 General Undesignated Unreserved Balance1,788,185 (158,243) 622,669 1,819,040 - 433,571 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 (158,243) 622,669 1,819,040 - 6,129,451 Special Revenue Landscape/Lighting Districts504,127 - 142 57,399 - 446,870 CDBG Federal Grants- - - - - - Capital Project Street Projects1,906,037 66,780 44,037 29,579 - 1,987,275 Park and Trail Projects959,923 - - 2,094 - 957,829 Facility Improvement Projects942,049 - 6,792 6,623 - 942,218 Administrative Projects147,329 - - 3,235 - 144,094 Tree Fund36,771 - 2,500 - - 39,271 CIP Grant Street Repair Projects(246,279) - 39,947 6,143 - (212,475) CIP Grant Park & Trail Projects(152,888) (1,198) - 33,895 - (187,981) CIP Grant Administrative Projects810 - - - - 810 Gas Tax Fund532,645 - 155,427 2,144 - 685,928 Debt Service Library Bond 850,657 (696,328) 1,308 - - 155,637 Internal Service Fund Liability/Risk Management134,905 (247,302) 76,835 5,289 - (40,850) Workers Compensation224,104 (1,117) 53,750 51,768 - 224,968 Office Stores Fund15,831 (2,320) 10,795 2,049 - 22,258 Information Technology Services 231,063 (43,902) 100,000 32,874 - 254,288 Equipment Maintenance42,817 (4,632) 50,000 20,809 - 67,376 Building Maintenance208,518 (28,582) 181,250 70,536 - 290,650 Equipment Replacement331,373 - 25,000 10,000 - 346,373 Technology Replacement185,567 - 12,500 376 - 197,691 Total City14,339,422 (1,116,843) 1,382,953 2,153,853 - 12,451,679 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 8/31/11 Street Projects Traffic Safety129,793 - - 6,225 - 123,567 Highway 9 Safety Project36,033 - - 2,000 - 34,033 Annual Street Resurfacing Project453,149 66,780 42,624 21,354 - 541,199 Sidewalks Annual Project52,905 - - - - 52,905 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 - - 39,920 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 66,780 44,037 29,579 - 1,987,275 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 - - 2,094 - 247,906 Total Parks & Trails959,923 - - 2,094 - 957,829 Facility Improvements Facility Projects125,518 - - - 5,863 131,381 Theater Improvement76,653 - 6,792 700 (5,863) 76,882 North Campus Improvements120,446 - - - - 120,446 Corp Yard Solar Project85,337 - - - - 85,337 Vehicle Structure Solar125,000 - - - - 125,000 Library Improvement335,596 - - 5,923 - 329,673 SPCC Furniture & Fixture4,065 - - - - 4,065 Electric Charging Station65,000 - - - - 65,000 McWilliams House Improvement4,435 - - - - 4,435 Total Facility Improvements942,049 - 6,792 6,623 - 942,218 Administrative Projects Financial System Upgrade3,534 - - - - 3,534 Document Imaging Project80,815 - - 854 - 79,961 CDD Document Imaging Project22,907 - - - - 22,907 CMO Document Imaging Project3,643 - - 506 - 3,137 IT Emergency Power Back36,430 - - 1,875 - 34,555 Total Administrative Projects147,329 - - 3,235 - 144,094 Tree Fund Citywide Tree Planting12,147 - - - - 12,147 SMSCF Tree Donation Fund- - 2,500 - - 2,500 Tree Dedication Program24,623 - - - - 24,623 Total Tree Fund36,771 - 2,500 - - 39,271 CIP Grant Street Repair Projects (246,279) - 39,947 6,143 - (212,475) CIP Grant Park & Trail Projects (152,888) (1,198) - 33,895 - (187,981) CIP Grant Administrative Projects 810 - - - - 810 Gas Tax Fund 532,645 - 155,427 2,144 - 685,928 Total CIP Funds4,126,396 65,583 248,703 83,713 - 4,356,968 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