The URL can be used to link to this page

Home My WebLink About101-Treasurer�s Report for the Month Ended April 30, 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 Ap deposit w cash flow 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 pril 30, 2011, with LAIF. Co w purposes, to o fall below $ he minimum SA June 1, 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 ouncil Policy avoid occurr $2,000,000. T limit required Unrestrict Comerica Deposit wi 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 $1,492,576 on operating rence of dry p The total poo d. ted Cash Bank ith LAIF restricted Ca Cas A CITY C e Services th Ended Ap e month ende uires that the 35, designate body a writ ch month, the receipts, disb ancial transac General (Op ates from the in cash depo g reserve fund period financin oled cash bala ash sh Summary OUNCIL AGENDA CITY M DEPT H pril 30, 2011 d April 30, 20 City Treasur es the City M tten report a e City Treasu bursements, a ction data for perating) Fund 1st Quarter of osit at Come ds, adopted on ng, pooled ca ance as of Ap 1,49$ 13,98$ 15,472$ A ITEM: MANAGER: HEAD: Mary F 011. 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 erica bank, an n April 20, 19 ash from all fu pril 30, 2011 i 92,576 80,205 2,781 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. nd $13,980,2 994, states tha funds should n is $15,472,78 rson of the asurer) ceipts, ty all Funds t from 05 on at: for 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,472,781$ Plus: Assets539,958 Less: Liabilities (1,163,544) Ending Fund Balance14,849,195$ Adjusting Cash to Ending Fund Balance ATTACHMENT A CHANGES IN TOTAL FUND BALANCE Fund Description Fund Balance 7/1/10 Increase/ (Decrease) Jul-Mar Current Revenue Current Expenditure Transfers Fund Balance 4/30/11 General Undesignated Unreserved Balance1,284,366 (1,467,940) 3,732,197 1,733,457 106,000 2,249,766 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 (1,796,540) 3,732,197 1,733,457 (595,983) 7,945,497 Special Revenue Landscape/Lighting Districts440,391 (10,938) 46,159 66,226 - 409,386 CDBG Federal Grants(9,621) 238,651 10,889 - (196,369) 43,550 SHARP Loan210,034 533 - - - 210,567 Capital Project Street Projects2,169,661 (673,448) 164,066 100,198 523,352 2,083,433 Park and Trail Projects653,880 (124,421) 393,300 14,690 75,000 983,069 Facility Improvement Projects525,256 (206,007) - 29,367 751,360 1,041,241 Administrative Projects224,773 (67,670) - 4,453 - 152,651 Tree Fund16,985 (5,110) 190 - 25,000 37,064 CIP Grant Street Repair Projects(118,073) (173,716) (14,174) 37,685 - (343,649) CIP Grant Park & Trail Projects(46,013) (341,282) 288,865 73,186 - (171,616) CIP Grant Administration - - - 901 - (901) Gas Tax Fund279,470 390,304 - 81,605 (106,000) 482,169 Debt Service Library Bond 892,593 (512,782) 10,487 - - 390,299 Internal Service Fund Liability/Risk Management244,562 (95,472) 49,618 16,403 (50,000) 132,304 Workers Compensation198,592 18,998 53,900 46,634 (25,000) 199,856 Office Stores Fund26,830 (3,361) 8,419 5,834 - 26,055 Information Technology Services 213,940 27,722 100,000 43,923 - 297,739 Equipment Maintenance54,258 7,171 50,000 27,909 - 83,520 Building Maintenance202,570 48,214 180,692 69,093 - 362,383 Equipment Replacement236,229 71,723 25,000 - (25,000) 307,951 Technology Replacement186,686 3,426 12,500 983 (25,000) 176,628 Trust/Agency Library Fund351,360 - - - (351,360) - KSAR - Community Access TV109,842 (109,842) - - - - Total City15,074,883 (3,313,848) 5,112,106 2,352,546 - 14,849,195 ATTACHMENT B FUND BALANCES BY CIP PROJECT CIP Funds/Projects Fund Balance 7/1/10 Increase/ (Decrease) Jul-Mar Current Revenue Current Expenditure Transfers Fund Balance 4/30/11 Street Projects Traffic Safety168,497 (125,469) - 20,025 90,887 113,890 Highway 9 Safety Project50,008 (10,288) 130,082 28,483 - 141,319 Annual Street Resurfacing Project529,434 (250,218) 33,985 34,789 (65,000) 213,411 Sidewalks Annual Project87,092 (10,398) - 14,602 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,150) - - 786 39,518 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) - - (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 (79,295) - - 103,900 28,712 Total Street Projects2,169,661 (673,448) 164,066 100,198 523,352 2,083,433 Parks & Trails Hakone Garden Koi Pond15,600 (9,875) - - 5,725 EL Quito Park Improvements27,571 (1,852) - 14,690 11,029 Historical Park Landscape50,588 (53,097) 2,509 - - Hakone Garden Retaining Wall & D/W142,829 - - - 142,829 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- (42) 75,000 - - 74,958 Tank Trail Repair26,731 (26,700) - - 31 Mid Pen O/S Land Purchase250,000 - - - 250,000 Total Parks & Trails653,880 (124,421) 393,300 14,690 75,000 983,069 Facility Improvements Facility Projects84,580 (8,802) - 85 110,062 185,755 Civic Center Improvement20 - - - (20) - Theater Improvement71,472 12,847 - 24,447 5,935 65,808 Senior Center Minor Building Improvement- (1,050) - - 1,050 - Senior Center Furniture & Fixture- (23,569) - 2,495 28,000 1,936 Portable Building Gutters- (2,460) - - 2,460 - North Campus Improvements3,920 (51,821) - 2,341 175,000 124,758 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- - - - 5,200 5,200 Electric Charging Station- - - - 65,000 65,000 McWilliams House Improvement10,000 (5,565) - - 4,435 Total Facility Improvements525,256 (206,007) - 29,367 751,360 1,041,241 Administrative Projects Financial System Upgrade3,534 - - - 3,534 Document Imaging Project85,183 (2,236) - 1,145 81,803 CDD Document Imaging Project31,989 (6,744) - 2,338 22,907 CMO Document Imaging Project8,887 (3,689) - 970 4,228 Telecommunication System55,000 (55,000) - - - IT Emergency Power Back40,180 - - - 40,180 Total Administrative Projects224,773 (67,670) - 4,453 - 152,651 Tree Fund Citywide Tree Planting16,985 (4,882) 190 - 12,292 Tree Dedication Program- (228) - - 25,000 24,772 Total Tree Fund16,985 (5,110) 190 - 25,000 37,064 CIP Grant Street Repair Projects (118,073) (173,716) (14,174) 37,685 (343,649) CIP Grant Park & Trail Projects (46,013) (341,282) 288,865 73,186 (171,616) CIP Grant Administration - - - 901 (901) Gas Tax Fund 279,470 390,304 - 81,605 (106,000) 482,169 Total CIP Funds3,705,938 (1,201,350) 832,247 342,085 1,268,711 4,263,461 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