The URL can be used to link to this page

Home My WebLink About101-Treasurer’s Report for the Month Ended June 30, 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 Jun 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 e 30, 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 $ 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 119,476 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 Jun 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 ne 30, 2011 d June 30, 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 Jun 11$ 15,60$ 15,725$ 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 $15,6 l 20, 1994, st h from all fu ne 30, 2011 i 9,476 06,205 5,681 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. 606,205 on de tates that: for unds should n is $15,725,68 rson rk and . The ger as ty all Funds t from eposit r cash not be 81 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,725,681$ Plus: Assets697,922 Less: Liabilities (2,084,181) Ending Fund Balance14,339,422$ Adjusting Cash to Ending Fund Balance ATTACHMENT A CHANGES IN TOTAL FUND BALANCE Fund Description Fund Balance 7/1/10 Increase/ (Decrease) Jul-May Current Revenue Current Expenditure Transfers Fund Balance 6/30/11 General Undesignated Unreserved Balance1,284,366 491,851 1,360,362 1,726,544 49,550 1,788,185 Reserved Fund Balance: Petty Cash Reserve1,300 - 150 - - 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 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 163,251 1,360,512 1,726,544 (652,433) 7,484,065 Special Revenue Landscape/Lighting Districts440,391 (30,451) 144,598 50,411 - 504,127 CDBG Federal Grants(9,621) 249,540 51,153 0 (291,071) - SHARP Loan210,034 533 181 210,748 - - Capital Project Street Projects2,169,661 (681,479) 72,308 197,442 542,989 1,906,037 Park and Trail Projects653,552 253,182 - 25,602 78,791 959,923 Facility Improvement Projects525,256 (232,293) 10,703 112,977 751,360 942,049 Administrative Projects224,773 (72,122) - 5,322 - 147,329 Tree Fund16,985 (4,670) 700 1,244 25,000 36,771 CIP Grant Street Repair Projects(118,073) 9,535 - 165,467 27,725 (246,279) CIP Grant Park & Trail Projects(45,683) (130,470) 79,411 56,146 - (152,888) CIP Grant Administration - (3,903) 5,072 359 - 810 Gas Tax Fund279,470 317,004 141,434 99,263 (106,000) 532,645 Debt Service Library Bond 892,593 (498,655) 456,719 - - 850,657 Internal Service Fund Liability/Risk Management244,562 (119,743) - (35,086) (25,000) 134,905 Workers Compensation198,592 28,296 - 2,784 - 224,104 Office Stores Fund26,830 (4,156) 681 7,525 - 15,831 Information Technology Services 213,940 58,236 - 41,113 - 231,063 Equipment Maintenance54,258 16,509 - 27,950 - 42,817 Building Maintenance202,570 101,958 - 96,010 - 208,518 Equipment Replacement236,229 96,723 - 1,579 - 331,373 Technology Replacement186,686 15,398 - 16,516 - 185,567 Trust/Agency Library Fund351,360 - - - (351,360) - KSAR - Community Access TV109,842 (109,842) - - - - Total City15,074,885 (577,621) 2,323,473 2,809,913 - 14,339,422 ATTACHMENT B FUND BALANCES BY CIP PROJECT CIP Funds/Projects Fund Balance 7/1/10 Increase/ (Decrease) Jul-May Current Revenue Current Expenditure Transfers Fund Balance 6/30/11 Street Projects Traffic Safety168,497 (149,548) - 27,847 138,691 129,793 Highway 9 Safety Project50,008 (18,166) 13,881 9,689 - 36,033 Annual Street Resurfacing Project529,434 (78,036) 58,428 28,952 (92,725) 388,149 Sidewalks Annual Project87,092 (25,000) - 10,769 1,581 52,905 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) - 849 - 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 Sobey Road Culvert Repair50,000 (31,994) - - (18,006) - Annual Storm Drain Upgrade53,883 (16,079) - 83 786 38,507 Village Trees & Lights at Sidestreets25,336 (25,336) - - - - Prospect Road Median51,663 (972) - 154 (50,000) 537 City Entrance Sign/Monument23,788 - - - (23,788) - Padero Erosion Mitigation- - - 37,037 50,000 12,963 Monte Vista Storm Drain- (91,138) - - 92,220 1,082 Canyon View/Elva Drain- - - - 35,000 35,000 Village-Streetscape Impv 549,952 (163,614) - 56,318 (16,029) 313,991 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) - 25,745 103,459 2,525 Total Street Projects2,169,661 (681,479) 72,308 197,442 542,989 1,906,037 Parks & Trails Hakone Garden Koi Pond15,600 (9,875) - 5,700 - 25 EL Quito Park Improvements27,571 (16,572) - - - 10,999 Historical Park Landscape50,588 (50,588) - - - - Hakone Garden Retaining Wall & D/W142,829 - - 5,450 - 137,379 Lower House ADA Ramp- (977) - 2,814 3,791 - 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,434 (5,703) - 50 - 17,681 Playground Safety Equipment- (8,680) - 2,257 50,000 39,064 Blaney Plaza Improvements- (18,473) - - 25,000 6,527 Ravenswood Playground Improvement- 74,958 - 9,332 - 65,626 Tank Trail Repair26,731 (26,700) - - - 31 Mid Pen O/S Land Purchase250,000 - - - - 250,000 Total Parks & Trails653,552 253,182 - 25,602 78,791 959,923 Facility Improvements Facility Projects84,580 (8,887) - 59,781 109,606 125,518 Civic Center Improvement20 - - - (20) - Theater Improvement71,472 359 5,076 6,190 5,935 76,653 Senior Center Minor Building Improvement- (1,050) - - 1,050 - Senior Center Furniture & Fixture- (26,434) - - 26,434 - Portable Building Gutters- (2,460) - - 2,460 - North Campus Improvements3,920 (58,381) - 94 175,000 120,446 HVAC System Upgrade117,949 (117,016) - - (932) - Corp Yard Solar Project93,250 - - 7,913 - 85,337 Vehicle Structure Solar125,000 - - - - 125,000 Library Improvement15,000 (3,233) 6,139 33,670 351,360 335,596 SPCC Furniture & Fixture4,065 (2,979) (512) - 3,490 4,065 Museum Storage Bldg- (1,848) - - 1,848 - Hot Water Pump- - - 3,330 3,330 - Electric Upgrades- (4,800) - 2,000 6,800 - Electric Charging Station- - - - 65,000 65,000 McWilliams House Improvement10,000 (5,565) - - - 4,435 Total Facility Improvements525,256 (232,293) 10,703 112,977 751,360 942,049 Administrative Projects Financial System Upgrade3,534 - - - - 3,534 Document Imaging Project85,183 (3,381) - 987 - 80,815 CDD Document Imaging Project31,989 (9,082) - - - 22,907 CMO Document Imaging Project8,887 (4,659) - 585 - 3,643 Telecommunication System55,000 (55,000) - - - - IT Emergency Power Back40,180 - - 3,750 - 36,430 Total Administrative Projects224,773 (72,122) - 5,322 - 147,329 Tree Fund Citywide Tree Planting16,985 (4,692) 700 845 - 12,147 Tree Dedication Program- 22 - 399 25,000 24,623 Total Tree Fund16,985 (4,670) 700 1,244 25,000 36,771 CIP Grant Street Repair Projects (118,073) 9,535 - 165,467 27,725 (246,279) CIP Grant Park & Trail Projects (45,683) (130,470) 79,411 56,146 - (152,888) CIP Grant Administration - (3,903) 5,072 359 - 810 Gas Tax Fund 279,470 317,004 141,434 99,263 (106,000) 532,645 Total CIP Funds3,705,940 (545,216) 309,628 663,821 1,319,864 4,126,396 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