Loading...
HomeMy WebLinkAbout101-Treasurer’s Report for the Month Ended March 31, 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 Mar with LAIF flow purp 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 rch 31, 2011, F. Council P poses, to avo o fall below $ he minimum SA May 4, 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 Policy on ope id occurrence $2,000,000. T limit required Unrestrict Comerica Deposit w 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 $9,199 in ca erating reserv e of dry peri The total pool d. ted Cash Bank ith LAIF restricted C Cas A CITY C e Services th Ended Ma e month ende uires that the 35, designate body a writ ch month, the receipts, disb ancial transac General (Op ates from the ash deposit at ve funds, adop od financing led cash balan ash sh Summary OUNCIL AGENDA CITY M DEPT H arch 31, 2011 d March 31, 2 City Treasur es the City M tten report a e City Treasu bursements, a ction data for perating) Fund 1st Quarter of Comerica ba pted on Apri , pooled cash nce as of Mar $ 13,40$ 13,414$ A ITEM: MANAGER: HEAD: Mary F 1 2011. 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 ank, and $13,4 l 20, 1994, st h from all fu rch 31, 2011 i 9,199 05,205 4,403 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. 405,205 on d tates that: for unds should n is $13,414,40 rson of the asurer) ceipts, ty all Funds t from eposit r cash not be 03 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 N/A 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 Cash13,414,403$ Plus: Assets240,015 Less: Liabilities (1,489,781) Ending Fund Balance12,164,637$ Adjusting Cash to Ending Fund Balance ATTACHMENT A CHANGES IN TOTAL FUND BALANCE Fund Description Fund Balance 7/1/10 Increase/ (Decrease) Jul-Feb Current Revenue Current Expenditure Transfers Fund Balance 3/31/11 General Undesignated Unreserved Balance1,284,366 (1,421,850) 1,090,727 1,061,816 106,000 326,026 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 - (126,983) - Designated for CIP Matching Grant600,000 - - - (600,000) - Designated for Carryforward68,600 (68,600) - - - - Subtotal 8,010,679 (1,750,450) 1,090,727 1,061,816 (670,983) 5,946,756 Special Revenue Landscape/Lighting Districts440,391 (8,725) 19,889 22,102 - 429,453 CDBG Federal Grants(9,621) 138,452 100,199 - (116,678) 112,352 SHARP Loan210,034 345 188 - - 210,567 Capital Project Street Projects2,169,661 (312,239) (237,310) 123,896 443,661 1,939,876 Park and Trail Projects653,881 (114,036) - 10,385 150,000 679,460 Facility Improvement Projects525,256 (169,225) 641 37,424 751,360 1,070,608 Administrative Projects224,773 (58,937) - 8,732 - 157,104 Tree Fine Fund16,985 (3,780) 500 1,830 25,000 36,874 CIP Grant Fund - Street Repair(118,073) (241,341) 69,365 1,741 - (291,789) CIP Grant Fund - Park & Trail(46,013) (261,050) - 80,232 - (387,295) Gas Tax Fund279,470 294,195 122,321 26,211 (106,000) 563,774 Debt Service Library Bond 892,593 (513,265) 484 - - 379,811 Internal Service Fund Liability/Risk Management244,562 (126,486) 29,764 (1,249) (50,000) 99,089 Workers Compensation198,592 27,077 (250) 7,829 (25,000) 192,590 Office Stores Fund26,830 (1,061) 770 3,070 - 23,470 Information Technology Services 213,940 52,095 - 24,373 - 241,662 Equipment Maintenance54,258 25,574 - 18,403 - 61,429 Building Maintenance202,570 87,474 - 39,260 - 250,784 Equipment Replacement236,229 71,723 - - (25,000) 282,951 Technology Replacement186,686 29,198 - 25,772 (25,000) 165,111 Trust/Agency Library Fund351,360 - - - (351,360) - KSAR - Community Access TV109,842 (109,748) (95) - - - Total City15,074,884 (2,944,213) 1,197,195 1,491,827 - 12,164,637 ATTACHMENT B FUND BALANCES BY CIP PROJECT CIP Funds/Projects Fund Balance 7/1/10 Increase/ (Decrease) Jul-Feb Current Revenue Current Expenditure Transfers Fund Balance 3/31/11 Street Projects Traffic Safety168,497 (62,425) - 63,044 52,980 96,008 Highway 9 Safety Project50,008 53,099 (63,387) - 39,720 Annual Street Resurfacing Project529,434 (258,660) 32,031 23,590 (65,000) 214,215 Sidewalks Annual Project87,092 (5,535) - 4,863 1,581 78,276 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 - - - 9,730 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) - (1,572) (19,578) - Annual Storm Drain Upgrade53,883 (16,720) - - 2,358 39,520 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- (63,831) - 27,307 92,220 1,082 Canyon View/Elva Drain- - - - 35,000 35,000 Village-Streetscape Impv 549,952 172,765 (205,954) - (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 (72,631) - 6,664 62,117 (13,072) Total Street Projects2,169,661 (312,239) (237,310) 123,896 443,661 1,939,876 Parks & Trails Hakone Garden Koi Pond15,600 (9,875) - - 5,725 EL Quito Park Improvements27,571 (1,847) - 5 25,719 Historical Park Landscape50,588 (53,097) - - (2,509) Hakone Garden Retaining Wall & D/W142,829 - - - 142,829 Hakone Garden Upper Moon House 125,000 - - - 125,000 West Valley Soccer Field(8,201) - - - (8,201) 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 (25,000) - 1,700 31 Mid Pen O/S Land Purchase250,000 - - - 250,000 Total Parks & Trails653,881 (114,036) - 10,385 150,000 679,460 Facility Improvements Facility Projects81,070 (4,395) 125 4,532 117,923 190,190 Civic Center Improvement20 - - - (20) - Theater Improvement71,472 14,729 - 1,882 84,320 Senior Center Minor Building Improvement1,050 (1,050) - - 1,050 1,050 Senior Center Furniture & Fixture- (23,569) - - 28,000 4,431 Portable Building Gutters2,460 (2,460) - - 2,460 2,460 North Campus Improvements3,920 (23,468) - 28,353 175,000 127,099 HVAC System Upgrade117,949 (117,016) - - (932) - Corp Yard Solar Project93,250 - - - 93,250 Vehicle Structure Solar125,000 - - - 125,000 Library Improvement15,000 (2,684) 516 1,065 351,360 363,127 SPCC Furniture & Fixture4,065 (3,746) - (256) 1,820 2,394 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 (169,225) 641 37,424 751,360 1,070,608 Administrative Projects Financial System Upgrade3,534 - - - 3,534 Document Imaging Project85,183 - - 2,236 82,947 CDD Document Imaging Project31,989 (671) - 6,073 25,245 CMO Document Imaging Project8,887 (3,266) - 423 5,198 Telecommunication System55,000 (55,000) - - - IT Emergency Power Back40,180 - - - 40,180 Total Administrative Projects224,773 (58,937) - 8,732 - 157,104 Tree Fine Fund Tree Fine Fund16,985 (3,780) 500 1,830 25,000 36,874 CIP Fund - Street Repair CIP Grant Fund(118,073) (241,341) 69,365 1,741 (291,789) CIP Fund - Park & Trail CIP Grant Fund(46,013) (261,050) - 80,232 (387,295) Gas Fund Gas Tax Fund279,470 294,195 122,321 26,211 (106,000) 563,774 Total CIP Funds3,687,624 (866,414) (44,482) 290,452 1,264,020 3,768,612 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