Loading...
HomeMy WebLinkAbout104-Financial Summaries.pdfC ITY OF SARATOGA F INANCIAL SUMMARIES 0 50 100 150 200 250 300 FINANCIAL SUMMARIES TOTAL REVENUES AND EXPENDITURES Summary schedules which provide a high level overview of the entire operating budget, in a fund-type summary, as well as by fund-specific and category-specific summary levels. Total Fund Activity Summary ....................................................................................................................... B – 3 Total Revenues – by Fund ............................................................................................................................. B – 4 Total Expenditures – by Fund ....................................................................................................................... B – 6 Total Revenues – by Category...................................................................................................................... B – 8 Total Expenditures – by Category ................................................................................................................. B – 9 GENERAL FUND REVENUES AND EXPENDITURES Summary schedules which identify the General Fund operating sources and uses at the department and category levels. The Fund Balance Activity summarizes the General Fund sources and uses which impact the ending fund balance. General Fund Revenues – by Department .................................................................................................... B – 10 General Fund Expenditures – by Department ............................................................................................... B – 11 General Fund Revenues – by Category ......................................................................................................... B – 12 General Fund Expenditures – by Category .................................................................................................... B – 13 General Fund Tax Revenues per Capita – Cities of Santa Clara County ..................................................... B – 14 General Fund Tax Revenues – 10 Year History of Key Tax Revenues ....................................................... B – 15 General Fund – Fund Balance Activity ......................................................................................................... B – 16 OPERATING TRANSFERS A schedule summarizing activity by fund, of estimated fund transfers for the prior year and budgeted for the adopted fiscal year. Schedule of Interfund Transfers .................................................................................................................... B – 17 FUND BALANCE Fund Balance schedules, one which summarizes activity and ending fund balances to provide a quick look at the ongoing status of the individual funds, and another which provides a 5 year trend. Total Fund Balance Activity Summary – by Fund ....................................................................................... B – 18 Fund Balance Reserve – 5 Year Comparative History .................................................................................. B – 20 C ITY OF SARATOGA F INANCIAL SUMMARIES B - 2 DEPARTMENTAL BUDGETS Department level schedules which provide an overview of funding source and expenditure use by each program within the department. Department Revenues – by Program ............................................................................................................. B – 22 Department Expenditures – by Program........................................................................................................ B – 24 STAFFING Staffing schedules which provide a summary level view of operational staffing assignments, funding, and trend over the prior five years. Summary of Employee Salary & Benefits ...................................................................................................... B - 27 Positions by Department ............................................................................................................................... B – 30 Staffing by Department ................................................................................................................................ B – 32 Staffing by Fund ........................................................................................................................................... B – 33 C ITY OF SARATOGA F INANCIAL SUMMARIES B - 3 TOTAL FUND ACTIVITY SUMMARY FY 2010/11 Estimated Revenues Expenditures Source (Use)Estimated Fund Balance && of Fund Balance Fund Category July 1, 2010 Transfers In Transfers Out Fund Balance June 30, 2011 Operating Funds General Fund Reserve for Petty Cash 1,300 - - - 1,300 Designated for Operations 2,891,666 - - 28,917 2,920,582 Economic Uncertainty 1,500,000 - - - 1,500,000 Environmental Reserve 563,182 - - (50,000) 513,182 Development Reserve 632,380 - - (210,000) 422,380 Uncollected Deposits 182,159 - - - 182,159 CIP/Matching Reserve 600,000 - - (453,017) 146,983 Hillside Stability Reserve 300,000 - - - 300,000 Undesignated Fund Balance 884,762 15,285,004 (15,993,445) 684,100 860,421 Total General Fund 7,555,449 15,285,004 (15,993,445) - 6,847,008 Special Revenue Funds Landscape & Lighting Districts 437,472 455,193 (631,156) - 261,509 CDBG Program Fund - 394,356 (394,356) - - SHARP Program Fund 210,125 1,000 - - 211,125 Internal Service Funds Liability/Risk Management 241,493 281,500 (393,464) - 129,528 Workers Compensation 181,415 225,000 (247,791) - 158,624 Office Support Services 31,033 42,000 (48,050) - 24,983 IT Services 127,589 400,000 (440,134) - 87,454 Vehicle & Equipment Maintenance 59,693 200,000 (210,623) - 49,070 Building Maintenance 189,039 725,000 (741,161) - 172,878 Vehicle & Equipment Replacement 237,587 100,000 (99,000) - 238,587 IT Equipment Replacement 168,296 50,000 (77,500) - 140,796 Total Operating Funds 9,439,191$ 18,159,053$ (19,276,681)$ -$ 8,321,562$ Debt Service 2001 Series GO Bonds 959,554 962,000 (1,019,656) - 901,898 Total Debt Service 959,554$ 962,000$ (1,019,656)$ -$ 901,898$ Trust & Agency Funds Library Capital Improvement 345,033 - (345,033) - - KSAR 105,588 68,500 (174,088) - - Total Trust & Agency Funds 450,621$ 68,500$ (519,121)$ -$ -$ TOTAL OPERATING BUDGET 10,849,365$ 19,189,553$ (20,815,458)$ -$ 9,223,460$ Capital Funds Street Projects 1,420,885 5,335,132 (6,756,017) - - Park & Trail Projects 556,413 2,589,807 (3,146,220) - - Facility Projects 438,443 761,636 (1,200,079) - - Administrative Projects 219,773 - (219,773) - - Total Capital Funds 2,635,513$ 8,686,575$ (11,322,089)$ -$ -$ TOTAL ALL FUNDS 13,484,878$ 27,876,128$ (32,137,547)$ -$ 9,223,460$ 1. Capital Project funding incorporates remaining funds from the prior year, new revenue, grants to be received, and transfers in. Prior year budgeted funds are shown as beginning fund balance carryforward amounts that are added to new funding to produce total available project budgets. All available funds are appropriated as expenditures and transfer outs to allow for project encumbrances and completion. As most projects will not be fully expended in a fiscal year, remaining project balances will carry forward into the next fiscal year. C ITY OF SARATOGA F INANCIAL SUMMARIES B - 4 TOTAL REVENUES & TRANSFERS IN BY FUND FY 2007/08 FY 2008/09 FY 2009/10 FY 2009/10 FY 2010/11 Fund Actuals Actuals Adjusted Estimated Proposed General Fund General Fund 16,603,493$ 15,874,200$ 15,116,623$ 14,844,277$ 15,035,454$ Total General Fund 16,603,493 15,874,200 15,116,623 14,844,277 15,035,454 Special Revenue Funds CDBG Program Fund 26,524 55,702 332,897 71,157 394,356 SHARP Program Fund 17,906 2,517 3,000 950 1,000 Landscape & Lighting Districts 435,505 478,535 439,358 436,133 455,193 Total Special Revenue Funds 479,935 536,755 775,255 508,240 850,549 Internal Service Funds Liability / Risk Management Ins 319,814 304,232 305,000 266,916 281,500 Workers Compensation Ins 247,000 270,920 260,000 260,000 225,000 Office Support Services 75,685 65,391 33,000 35,000 42,000 Information Technology Services 369,808 403,976 400,000 400,015 400,000 Vehicle & Equipment Maintenance 218,232 250,000 208,000 208,000 200,000 Building Maintenance 724,514 807,687 704,000 709,213 725,000 Vehicle & Equipment Replacement 200,000 213,569 116,000 110,000 100,000 IT Equipment Replacement 52,103 53,283 58,008 58,008 50,000 Total Internal Service Funds 2,207,156 2,369,059 2,084,008 2,047,152 2,023,500 Debt Service Funds 2001 Series GO Bond 1,118,965 1,092,291 960,000 1,043,600 962,000 Total Debt Service Funds 1,118,965 1,092,291 960,000 1,043,600 962,000 Trust Funds Library Capital Improvement Fund 14,116 9,358 10,000 2,150 - KSAR Community Access Trust 3,799 45,942 65,200 68,450 68,500 Total Trust Funds 17,915 55,300 75,200 70,600 68,500 Capital Project Funds Street Projects 1,447,600 1,202,795 4,484,196 1,507,154 5,032,712 Park & Trail Projects 184,209 446,652 1,940,058 403,047 2,375,007 Facility Projects 150,285 43,471 5,000 41,892 5,000 Administrative Projects - - - - - Total Capital Improvement Projects 1,782,094 1,692,918 6,429,254 1,952,093 7,412,719 Total Revenues 22,209,558$ 21,620,523$ 25,440,340$ 20,465,961$ 26,352,722$ Operating Transfers In General Fund 2,275,254 153,732 198,859 198,859 249,550 Landscape & Lighting Fund - 46,740 - - - Building Maintenance Fund 15,000 - - - - Library Capital Improvement Fund - - - 32,615 - Street Capital Project Funds 1,249,244 830,599 884,495 529,604 302,420 Park & Trail Capital Project Funds 359,360 227,667 277,324 293,210 214,800 Facility Capital Project Fund 590,000 1,003,704 568,912 560,322 756,636 Admin Capital Project Fund 169,280 119,000 50,000 108,887 - Total Operating Transfers In 4,658,138 2,381,442 1,979,590 1,723,497 1,523,406 Total Revenues & Transfers In 26,867,696$ 24,001,964$ 27,419,930$ 22,189,458$ 27,876,128$ C ITY OF SARATOGA F INANCIAL SUMMARIES B - 5 TOTAL REVENUES & TRANSFERS IN BY FUND TYPE FY 2010/11 REVENUES BY FUND FY 2007/08 FY 2008/09 FY 2009/10 FY 2009/10 FY 2010/11 Fund Actuals Actuals Adjusted Estimated Proposed General Fund 16,603,493$ 15,874,200$ 15,116,623$ 14,844,277$ 15,035,454$ Special Revenue Funds 479,935 536,755 775,255 508,240 850,549 Internal Service Funds 2,207,156 2,369,059 2,084,008 2,047,152 2,023,500 Debt Service Funds 1,118,965 1,092,291 960,000 1,043,600 962,000 Trust Funds 17,915 55,300 75,200 70,600 68,500 Capital Project Funds 1,782,094 1,692,918 6,429,254 1,952,093 7,412,719 Total Revenues by Fund 22,209,558$ 21,620,523$ 25,440,340$ 20,465,961$ 26,352,722$ Operating Fund Transfers 2,290,254 200,472 198,859 231,474 249,550 CIP Fund Transfers 2,367,884 2,180,970 1,780,731 1,492,023 1,273,856 Total Revenues & Transfers In 26,867,696$ 24,001,964$ 27,419,930$ 22,189,458$ 27,876,128$ Note: Capital Budgets – Revenues and expenditures amounts show full receipt and expense of capital activities, whereas this high level of activity is not expected, full appropriation provides a view of the full potential impact of adopted capital projects. C ITY OF SARATOGA F INANCIAL SUMMARIES B - 6 FY 2007/08 FY 2008/09 FY 2009/10 FY 2009/10 FY 2010/11 Fund Actuals Actuals Adjusted Estimated Proposed General Fund General Fund 14,974,823$ 15,763,360$ 15,347,432$ 15,066,373$ 15,440,428$ Total General Fund 14,974,823 15,763,360 15,347,432 15,066,373 15,440,428 Special Revenue Funds CDBG Program Fund - - - - - Landscape & Lighting Districts 359,247 347,000 536,061 358,577 631,156 Total Special Revenue Funds 359,247 347,000 536,061 358,577 631,156 Internal Service Funds Liability / Risk Management Ins 191,125 230,050 342,861 252,373 343,464 Workers Compensation Ins 199,265 195,622 265,881 201,618 222,791 Office Support Services 43,069 58,374 40,200 43,600 48,050 Information Technology Services 247,266 351,680 471,832 375,432 440,134 Vehicle & Equipment Maintenance 204,818 206,758 219,033 204,963 210,623 Building Maintenance 642,264 700,207 741,379 729,015 741,161 Vehicle & Equipment Replacement 110,464 158,465 36,360 25,627 74,000 IT Equipment Replacement 17,340 54,303 66,200 55,000 52,500 Total Internal Service Funds 1,655,611 1,955,458 2,183,746 1,887,630 2,132,724 Debt Service Funds 2001 Series GO Bond 1,015,941 1,014,550 1,015,556 1,015,406 1,019,656 Total Debt Service Funds 1,015,941 1,014,550 1,015,556 1,015,406 1,019,656 Trust Funds Library Capital Improvement Fund 7,782 38,893 15,000 11,106 - KSAR Community Access Trust 30,000 - 100,000 47,465 174,088 Total Trust Funds 37,782 38,893 115,000 58,571 174,088 Capital Project Funds Street Projects 1,696,829 1,800,383 7,446,001 2,312,399 6,650,017 Park & Trail Projects 548,190 1,587,747 2,410,475 582,937 3,146,220 Facility Projects 606,704 577,563 1,135,192 659,523 1,200,079 Administrative Projects 68,439 55,931 213,910 44,137 219,773 Total Capital Project Funds 2,920,162 4,021,624 11,205,578 3,598,996 11,216,089 Total Expenditures 20,963,567$ 23,140,884$ 30,403,373$ 21,985,553$ 30,614,141$ Operating Transfers Out General Fund 3,255,234 1,571,727 650,000 650,000 553,017 Liability/Risk Mgmt Fund - - - - 50,000 Workers Comp Fund - - - - 25,000 IT Equipment Replacement to CIP 70,734 - 150,000 150,000 25,000 Vehicle/Equipment Replacement Fund - - - - 25,000 Landscape & Lighting Districts 168,000 28,180 - - - CDBG Fund 138,090 55,702 332,897 71,157 394,356 Library Capital Trust Fund to CIP - 310,000 33,020 33,020 345,033 Street Capital Project Funds 1,112,674 282,074 177,503 309,149 106,000 Park & Trail Capital Project Funds 20,000 102,667 27,324 43,210 - Facility Capital Projects Fund 60,265 31,092 412,113 458,074 - Admin Capital Projects Fund - - - 8,887 - Total Operating Transfers Out 4,824,997 2,381,442 1,782,857 1,723,497 1,523,406 Total Expenditures & Transfers Out 25,788,563$ 25,522,326$ 32,186,230$ 23,709,050$ 32,137,547$ TOTAL EXPENDITURES & TRANSFERS OUT BY FUND C ITY OF SARATOGA F INANCIAL SUMMARIES B - 7 TOTAL EXPENDITURES & TRANSFERS OUT BY FUND TYPE FY 2010/11 E XPENDITURES BY F UND FY 2007/08 FY 2008/09 FY 2009/10 FY 2009/10 FY 2010/11 Fund Actuals Actuals Adjusted Estimated Proposed General Fund 14,974,823$ 15,763,360$ 15,347,432$ 15,066,373$ 15,440,428$ Special Revenue Funds 359,247 347,000 536,061 358,577 631,156 Internal Service Funds 1,655,611 1,955,458 2,183,746 1,887,630 2,132,724 Debt Service Funds 1,015,941 1,014,550 1,015,556 1,015,406 1,019,656 Trust Funds 37,782 38,893 115,000 58,571 174,088 Capital Project Funds 2,920,162 4,021,624 11,205,578 3,598,996 11,216,089 Total Expenditures by Fund 20,963,567$ 23,140,884$ 30,403,373$ 21,985,553$ 30,614,141$ Operating Fund Transfers 3,632,058 1,965,609 1,165,917 904,177 1,417,406 CIP Fund Transfers Out 1,192,939 415,833 616,940 819,320 106,000 Total Expenditures & Transfers 25,788,563$ 25,522,326$ 32,186,230$ 23,709,050$ 32,137,547$ Note: Capital Budgets – Revenues and expenditures amounts show full receipt and expense of capital activities, reflecting full potential impact of capital projects C ITY OF SARATOGA F INANCIAL SUMMARIES B - 8 TOTAL REVENUES & TRANSFERS IN BY CATEGORY FY 2010/11 Revenues by Category FY 2007/08 FY 2008/09 FY 2009/10 FY 2009/10 FY 2010/11 % of Revenue Category Actuals Actuals Adjusted Estimated Proposed Total Property Tax 9,490,683 9,703,536 9,553,648 9,554,805 9,420,793 33.8% Sales Tax 1,057,977 1,043,034 910,000 875,000 910,000 3.3% Franchise Fee Tax 1,625,414 1,701,663 1,739,000 1,719,579 1,720,000 6.2% Transient Occupancy Tax 211,532 151,378 140,000 120,000 120,000 0.4% Business/Other Taxes 482,184 511,675 490,000 425,000 425,000 1.5% Fees, Licenses & Permits 1,750,274 1,186,402 1,088,750 1,036,501 1,014,800 3.6% Intergovernmental 454,828 385,705 611,397 416,520 730,356 2.6% Charge for Services 1,749,603 1,675,566 1,561,531 1,473,411 1,544,035 5.5% Interest Income 638,000 388,700 205,410 110,657 105,500 0.4% Rental Income 386,834 366,619 364,342 411,694 435,320 1.6% Other Sources 436,037 493,806 344,000 367,693 594,200 2.1% Operational Revenues 18,283,366$ 17,608,083$ 17,008,078$ 16,510,860$ 17,020,003$ 61.1% Internal Service Charges 2,144,098 2,319,522 2,003,008 2,003,008 1,920,000 6.9% Capital Program Funding 1,782,094 1,692,919 6,429,254 1,952,094 7,360,736 26.4% Total Revenues 22,209,558$ 21,620,523$ 25,440,340$ 20,465,962$ 26,300,739$ 94.3% Fund Transfers In:4,658,138 2,381,440 1,979,590 1,723,496 1,575,389 5.7% Total Revenues & Transfers 26,867,696$ 24,001,964$ 27,419,930$ 22,189,458$ 27,876,128$ 100.0% Note: Saratoga is a minimum services contract city meaning consultants and contract services are utilized extensively to provide services to the community. Examples include: Sheriff’s services, animal control services, street sweeping, and landscape maintenance services. C ITY OF SARATOGA F INANCIAL SUMMARIES B - 9 TOTAL EXPENDITURES & TRANSFERS OUT BY CATEGORY FY 2010/11 Expenditures by Category FY 2007/08 FY 2008/09 FY 2009/10 FY 2009/10 FY 2010/11 % of Expenditure Category Actuals Actuals Adjusted Estimated Proposed Total Salaries & Benefits 6,788,872 7,125,280 7,259,436 7,059,208 7,344,552 22.6% Materials & Supplies 502,757 419,969 389,075 366,231 418,498 1.2% Fees & Charges 1,156,618 1,423,020 1,786,549 1,497,181 1,784,195 5.6% Consultant & Contract Serv 6,372,470 6,339,997 6,425,339 6,155,717 6,594,854 20.0% Meetings & Training 74,729 78,517 59,465 45,278 60,175 0.2% Community Grants & Events 189,934 162,669 208,006 207,792 181,376 0.6% Debt Service 1,015,941 1,014,550 1,015,556 1,015,406 1,019,656 3.2% Fixed Assets 162,373 235,735 51,360 36,734 74,000 0.2% Operational Expenditures 16,263,694 16,799,738 17,194,786 16,383,548 17,477,306 53.5% Internal Service Charges 1,779,711 2,319,522 2,003,009 2,003,009 1,920,746 6.2% Capital Improvements 2,920,162 4,021,624 11,205,578 3,598,996 11,216,089 34.9% Total Expenditures 20,963,567$ 23,140,884$ 30,403,373$ 21,985,553$ 30,614,141$ 94.6% Fund Transfers Out 4,824,997 2,381,442 1,732,857 1,673,497 1,498,406 5.4% Total Expenditures & Transfer 25,788,563$ 25,522,326$ 32,136,230$ 23,659,050$ 32,112,547$ 100.0% Note: Saratoga is a minimum services contract city meaning consultants and contract services are utilized extensively to provide services to the community. Examples include: Sheriff’s services, animal control services, street sweeping, and landscape maintenance services. C ITY OF SARATOGA F INANCIAL SUMMARIES B - 10 GENERAL FUND REVENUES BY DEPARTMENT FY 2010/11 REVENUES BY DEPARTMENT 2007/08 2008/09 2009/10 2009/10 2010/11 % of Departments Actuals Actuals Adjusted Estimated Proposed Total Council & Commissions 14,900$ 1,800$ 1,200$ 1,200$ 1,200$ 0.0% City Manager's Department 3,858 12,012 2,000 1,968 14,250 0.1% Administrative Services 34,869 83,879 42,650 65,660 40,000 0.3% Community Development 2,248,809 1,802,286 1,675,330 1,539,399 1,532,360 10.0% Public Works 549,319 516,954 436,000 494,233 577,152 3.8% Recreation & Facilities 900,093 787,813 759,943 787,985 871,942 5.7% Public Safety 585,153 575,999 470,000 546,292 634,950 4.2% Non-Departmental 12,266,492 12,093,457 11,729,500 11,407,539 11,363,600 74.3% Total General Fund Revenues 16,603,493$ 15,874,200$ 15,116,623$ 14,844,277$ 15,035,454$ 98.4% Fund Transfers In:2,275,254 153,732 198,859 198,859 249,550 1.6% Total Operating Revenues 18,878,747$ 16,027,932$ 15,315,482$ 15,043,136$ 15,285,004$ 100.0% Funding from Use of Deposits/Carryforwards/Designated Funds Theater Surcharge Deposit - 53,167 - - - 80,000 58,386 22,000 22,000 - Development Fund Balance 99,447 75,000 75,000 75,000 210,000 Environmental Fund Balance 40,000 66,735 50,000 50,000 50,000 CIP Transfer Reserve - 1,400,000 550,000 550,000 453,017 Economic Stability Reserve - - 25,000 25,000 - Total Operating Sources 19,098,194 17,681,221 16,037,482 15,765,136 15,998,021 Carryforward Funding C ITY OF SARATOGA F INANCIAL SUMMARIES B - 11 GENERAL FUND EXPENDITURES BY DEPARTMENT FY 2010/11 EXPENDITURES BY DEPARTMENT 2007/08 2008/09 2009/10 2009/10 2010/11 % of Departments Actuals Actuals Adjusted Estimated Proposed Total Council & Commissions 163,540$ 171,894$ 179,087$ 128,862$ 166,931$ 1.0% City Manager's Department 1,151,615 1,298,637 1,275,496 1,242,411 1,281,848 8.0% Administrative Services 784,139 893,132 861,756 842,004 850,497 5.3% Community Development 2,238,738 2,450,548 2,143,460 2,108,766 2,038,821 12.7% Public Works 4,310,496 4,352,644 4,324,168 4,237,449 4,296,380 26.9% Recreation & Facilities 1,369,233 1,424,421 1,248,694 1,225,937 1,326,899 8.3% Public Safety 3,952,640 4,205,672 4,345,234 4,391,245 4,523,431 28.3% Non-Departmental 1,004,423 966,411 969,537 889,698 955,623 6.0% 14,974,823$ 15,763,360$ 15,347,432$ 15,066,373$ 15,440,428$ 96.5% Fund Transfers Out 3,764,304 1,571,727 650,000 650,000 553,017 3.5% Total Exp & Transfers Out 18,739,127$ 17,335,086$ 15,997,432$ 15,716,373$ 15,993,445$ 100.0% Total General Fund Exp C ITY OF SARATOGA F INANCIAL SUMMARIES B - 12 GENERAL FUND REVENUES BY CATEGORY FY 2010/11 REVENUES BY CATEGORY FY 2007/08 FY 2008/09 FY 2009/10 FY 2009/10 FY 2010/11 % of Revenue Category Actuals Actuals Adjusted Estimated Proposed Total Property Tax 7,922,815$ 8,155,362$ 8,175,500$ 8,091,904$ 8,017,600$ 52.5% Sales Tax 1,057,977 1,043,034 910,000 875,000 910,000 6.0% Transient Occupancy Tax 211,532 151,378 140,000 120,000 120,000 0.8% Business & Other Taxes 482,184 511,675 490,000 425,000 425,000 2.8% Franchise Fee Tax 1,623,318 1,656,716 1,675,000 1,651,579 1,652,000 10.8% Intergovernmental 428,304 303,212 268,500 323,377 272,000 1.8% Fees, Licenses & Permits 1,747,922 1,186,319 1,083,750 1,036,249 1,012,300 6.6% Charge for Services 1,738,918 1,670,175 1,551,531 1,461,411 1,532,035 10.0% Interest 615,731 362,588 170,000 90,275 90,000 0.6% Rental Income 386,834 366,619 364,342 411,694 435,320 2.8% Other Sources 387,958 467,124 288,000 357,789 569,200 3.7% Total Revenues 16,603,493$ 15,874,201$ 15,116,623$ 14,844,277$ 15,035,454$ 98.4% Fund Transfers In 2,275,254 153,732 198,859 198,859 249,550 1.6% Total Revenues & Transfers 18,878,747$ 16,027,933$ 15,315,482$ 15,043,136$ 15,285,004$ 100.0% Funding from Use of Designated Funds Theater Surcharge Deposit - 53,167 - - - Funding Carryforward 80,000 58,386 22,000 22,000 - Development Reserve 99,447 75,000 75,000 75,000 210,000 Environmental Reserve 40,000 66,735 50,000 50,000 50,000 CIP Reserve - 1,400,000 550,000 550,000 453,017 Economic Stability Reserve - - 25,000 25,000 - Total Operating Sources 19,098,194 17,681,221 16,037,482 15,765,136 15,998,021 C ITY OF SARATOGA F INANCIAL SUMMARIES B - 13 GENERAL FUND EXPENDITURES BY CATEGORY FY 2010/11 EXPENDITURES BY CATEGORY FY 2007/08 FY 2008/09 FY 2009/10 FY 2009/10 FY 2010/11 % of Expenditure Category Actuals Actuals Adjusted Estimated Proposed Total Salary & Benefits 6,172,956$ 6,485,451$ 6,505,303$ 6,343,849$ 6,553,680$ 41.0% Materials & Supplies 316,073 216,062 185,525 164,724 179,208 1.1% Fees & Charges 621,787 619,648 698,080 636,499 701,859 4.4% Consultant & Contract Services 5,516,722 5,985,878 5,821,677 5,795,654 5,967,556 37.3% Meetings, Events & Training 73,746 74,204 55,265 44,278 57,975 0.4% Community Grants & Events 189,934 162,669 208,006 207,792 181,376 1.1% Fixed Assets 30,127 30,105 - - - 0.0% Internal Services Charges 2,053,479 2,189,340 1,873,576 1,873,576 1,798,775 11.2% Total Expenditures 14,974,823$ 15,763,356$ 15,347,432$ 15,066,373$ 15,440,428$ 96.5% Fund Transfers Out:3,764,304 1,571,727 650,000 650,000 553,017 3.5% Total Expenditures & Transfers 18,300,791$ 17,335,083$ 15,997,432$ 15,716,373$ 15,993,445$ 100.0% C ITY OF SARATOGA F INANCIAL SUMMARIES B - 14 GENERAL FUND TAX REVENUES CITIES OF SANTA CLARA COUNTY – TAX REVENUES PER CAPITA FY 2009/10 ESTIMATED TAX REVENUE AMOUNTS AND PER CAPITA City Population Amount Per capita Amount Per capita Amount Per capita Amount Per capita Campbell 40,420 8,882,191 220 9,222,268 228 1,287,184 32 232,424 6 Cupertino 55,840 12,950,000 232 14,140,000 253 2,140,000 38 700,000 13 Gilroy 51,508 10,927,795 212 11,650,355 226 870,175 17 575,564 11 Los Altos 28,458 12,740,166 448 2,697,494 95 1,289,722 45 403,338 14 Los Altos Hills 8,889 3,205,734 361 89,349 10 - - 233,529 26 Los Gatos 30,497 9,178,868 301 8,575,872 281 1,245,078 41 1,138,057 37 Milpitas 70,817 54,204,253 765 16,250,920 229 5,549,931 78 417,031 6 Monte Sereno 3,619 1,111,122 307 9,144 3 - - 46,850 13 Morgan Hill 39,814 5,903,101 148 6,552,031 165 1,110,669 28 161,483 4 Mountain View 74,762 25,647,300 343 16,263,600 218 3,154,900 42 220,600 3 Palo Alto 64,484 25,382,000 394 20,476,000 318 7,071,000 110 - - San Jose 1,006,892 499,843,000 496 135,215,388 134 23,900,000 24 39,901,000 40 Santa Clara 117,242 39,918,830 340 35,780,564 305 9,762,655 83 843,902 7 SARATOGA 31,997 8,091,904 253 875,000 27 120,000 4 305,000 10 Sunnyvale 138,826 5,683,758 41 26,919,485 194 5,683,758 41 1,199,364 9 Average 117,604 48,244,668 410 20,314,498 173 4,212,338 36 3,091,876 26 Property Tax Sales Tax Transient Occupancy Business License NOTES: Property Tax – includes VLF in Lieu revenues permanently received as Property Tax Sales Tax – includes Sales Tax portion temporarily received as Property Tax effective with the Triple Flip C ITY OF SARATOGA F INANCIAL SUMMARIES B - 15 GENERAL FUND REVENUES 10 YEAR HISTORY OF KEY TAX REVENUES Summary of Change from Tax Revenues Prior Year 2001/02 Actuals 2,772,021$ 1,165,214$ 218,837$ 314,669$ 4,470,740 8.0% 2002/03 Actuals 2,929,208$ 1,118,394$ 160,639$ 304,081$ 4,512,322 0.9% 2003/04 Actuals 3,020,516$ 976,899$ 149,316$ 282,553$ 4,429,284 (1.8%) 2004/05 Actuals 5,334,406$ 1,011,721$ 146,607$ 298,823$ 6,791,557 53.3% 2005/06 Actuals 6,141,365$ 988,132$ 163,222$ 339,648$ 7,632,367 12.4% 2006/07 Actuals 7,577,444$ 994,680$ 195,261$ 303,787$ 9,071,172 18.9% 2007/08 Actuals 7,922,815$ 1,057,977$ 211,532$ 290,996$ 9,483,320 4.5% 2008/09 Actuals 8,155,362$ 1,043,034$ 151,378$ 321,347$ 9,671,121 2.0% 2009/10 Estimated 8,091,904$ 875,000$ 120,000$ 305,000$ 9,391,904 (1.0%) 2010/11 Proposed 8,017,600$ 910,000$ 120,000$ 305,000$ 9,352,600 (3.3%) Business License Tax Occupancy Tax Sales Tax Property TaxFiscal Year NOTES: FY 2004/05 Property Tax Revenues – reflects the ongoing permanent addition of approximately $2 million plus of VLF in Lieu Fees received as Property Tax resulting from the State’s Prop 1A Triple Flip Legislation FY 2006/07 Property Tax Revenues – reflects the ongoing permanent addition of Property Tax revenues due to the increased City allocation share from TEA Legislation. (Approximately $760,000 in FY 2006/07, and growing C ITY OF SARATOGA F INANCIAL SUMMARIES B - 16 GENERAL FUND FUND BALANCE ACTIVITY Estimated Plus Less Sources Estimated 7/1/2010 Transfers Transfers (Uses) of 6/30/2011 Balance Revenues In Expenditures Out Fund Balance Balance Reserved Fund Balance Reserve for Petty Cash 1,300 - - - - - 1,300 Unreserved Fund Balance Designated Reserves Operations Reserve 2,891,666 - - - - 28,917 2,920,582 Economic Uncertainty Reserve 1,500,000 - - - - - 1,500,000 Environmental Services Reserve 563,182 - - - - (50,000) 513,182 Development Services Reserve 632,380 - - - - (210,000) 422,380 Uncollected Deposits 182,159 - - - - - 182,159 Carryforward Reserve - - - - - - - Capital Projects Reserve 600,000 - - - - (453,017) 146,983 Hillside Stability Reserve 300,000 - - - - - 300,000 Undesignated Reserves Undesignated Fund Balance 884,762 15,035,454 249,550 15,440,428 553,017 (684,100) 860,421 7,555,449$ 6,847,008$ GENERAL FUND Reserve Activity includes: The General Fund Operating Reserve was established July 1, 1999 at $2,000,000 to provide operational cash flow funding for the General Fund. The reserve is adjusted at the end of each fiscal year by the amount of interest income earned on the balance in the reserve. FY 2010/11 revenue for this reserve includes earnings at an estimated 1.% average interest rate. The Economic Uncertainty Reserve of $1,500,000 is to be used in the case of fiscal uncertainty. Upon approval from the City Council, this reserve may provide relief in the case of State takeaways, unanticipated revenue shortfalls, or for unexpected expenses or disasters. This reserve is not adjusted for interest earnings. The Development and Environmental Services reserves reflect established funding sources for future years operating services. These reserve balances were established at FY 2006/07 year end with the closing of the individual special revenue funds. To provide a nexus between the funding source and use, these funds are appropriated as supplemental support for use in development and environmental programs. The Hillside Stability Reserve reflects funding set aside for emergency roadway and retaining wall support projects. The Capital Project Reserve reflects funding designated to fund capital projects in the current or future fiscal years as of budget adoption. Use of / Addition to GF Reserves: Total Fund Balance Reserves Fund Balance Reserves reflect the cumulative effect of revenues and other financing sources over expenditures and other financing uses. Reserved Fund Balance are legal obligations, whereas Unreserved Fund Balance includes 'Designated Reserves': and 'Undesignated Fund Balance reseves. Designated Reserves are funding held for a specific purpose of use. 'Undesignated Fund Balance' is estimated year-end fund balance not previously identified for a specific purpose, and is therefore available to buffer unplanned financial situations during the fiscal year. As year-end fund balance reflects an estimate, sound finanical practices suggest retaining a sufficient amount of undesignated fund balance to offset unexpected revenue shortfalls and operational expenditures. C ITY OF SARATOGA F INANCIAL SUMMARIES B - 17 Estimated Estimated Proposed Proposed 2009/10 2009/10 2010/11 2010/11 Transfers In Transfers Out Transfers In Transfers Out General Funds General Fund 198,859 650,000 249,550 553,017 Special Revenue Funds CDBG Program Fund - 71,157 - 394,356 Internal Service Funds Risk Management/Liability Ins - - - 50,000 Workers Compensation - - - 25,000 Vehicle & Equipment Replacement - - - 25,000 IT Equipment Replacement - 150,000 - 25,000 Trust Funds Library Capital Projects 32,615 33,020 - 345,033 Capital Project Funds Street Projects 529,604 309,149 302,420 106,000 Parks & Trail Projects 293,210 43,210 214,800 - Facility Projects 560,322 458,074 756,636 - Administrative Projects 108,887 8,887 - - Total Interfund Transfers 1,723,497$ 1,723,497$ 1,523,406$ 1,523,406$ Transfer of the $345,033 in remaining bond funds from the Library Capital Improvement Fund to the CIP to make funds available for various Library Building projects Transfer to the General Fund are comprised of: 1. $43,550 from the CDBG Fund for Human Services Grants and administration costs 2. $106,000 from the CIP Gas Tax Fund to reimburse Engineering and Administrative Services 3. $100,000 from the following four ($25,000 each) Internal Service Funds: Risk Management; Workers Comp; Vehicle/Equip Replacement Fund; IT Equipment Replacement Fund Transfers to the CIP Funds include: 1. $453,017 from GF Reserve for various CIP projects 2. $100,000 from GF Operations to the CIP Facilities Fund 3. $350,806 from CDBG for Current and Prior Year ADA projects 3. $25,000 from the Liability Fund for Park CIP project 4. $345,033 from the Library Capital Improvement fund to Facility CIP projects Transfer from the General Fund is comprised of: 1. $100,000 annual transfer to the CIP Facilitiies Fund for projects 2. $73,017 to CIP Streets for projects 3. $145,000 to CIP Parks & Trails for projects 4. $235,000 to CIP Facilities for various other projects Transfer from the CDBG Fund are comprised of: 1. $15,000 annual transfer to the General Fund for program administration 2. $28,550 to the Grants program for SASCC Grant 3. $350,806 for ADA projects Transfer from the Internal Service Funds are comprised of: 1. $25,000 transfer from the Liability Fund' from an BAG Grant to the CIP Project Fund 2. $25,000 from each of the following Internal Service Funds to the General Fund: Risk Management; Workers Comp; Vehicle/Equip Replacement Fund; IT Equipment Replacement Fund Fund Description FY 2010/11 Interfund Transfers In Transfer from the CIP Streets Fund are comprised of: 1. $106,000 annual transfer to the General Fund for program administration FY 2010/11 Interfund Transfers Out SCHEDULE OF INTERFUND TRANSFERS C ITY OF SARATOGA F INANCIAL SUMMARIES B - 18 FUND BALANCE ACTIVITY FY 2010/11 7/1/2010 Plus Plus Less Less Sources 6/30/2011 Estimated Revenues &Transfers Exp & Transfers (Uses) of Estimated Balance Carryfwds In Carryfwds Out Fund Bal Balance General Fund Reserved Fund Balance Reserved for Petty Cash 1,300 - - - - - 1,300 Unreserved Fund Balance Designated Operations Reserve 2,891,666 - - - - 28,917 2,920,582 Economic Uncertainty Reserve 1,500,000 - - - - - 1,500,000 Environmental Services Reserve 563,182 - - - - (50,000) 513,182 Development Services Reserve 632,380 - - - - (210,000) 422,380 Uncollected Deposits Reserve 182,159 - - - - - 182,159 Capital Reserve 600,000 - - - - - 600,000 Hillside Reserve 300,000 - - - - - 300,000 Undesignated Undesignated Fund Balance 884,762 15,035,454 249,550 15,440,428 553,017 (231,083) 407,404 Total General Fund 7,555,449$ 15,035,454$ 249,550$ 15,440,428$ 553,017$ -$ 6,847,008$ Special Revenue Funds CDBG Program Fund - 394,356 - - 394,356 - - SHARP Program Fund 210,125 1,000 - - - - 211,125 Landscape & Lighting Districts 437,472 455,193 - 631,156 - - 261,509 Total Special Revenue Funds 647,597$ 850,549$ -$ 631,156$ 394,356$ -$ 472,634$ Internal Service Funds Liability / Risk Management 241,493 281,500 - 343,464 50,000 - 129,529 Workers Compensation 181,415 225,000 - 222,791 25,000 - 158,624 Office Stores Fund 31,033 42,000 - 48,050 - - 24,983 IT Services 127,589 400,000 - 440,134 - - 87,454 Vehicle & Equip Maintenance 59,693 200,000 - 210,623 - - 49,070 Building Maintenance 189,039 725,000 - 741,161 - - 172,878 Vehicle & Equip Replacement 237,587 100,000 - 74,000 25,000 - 238,587 IT Equipment Replacement 168,296 50,000 - 52,500 25,000 - 140,796 Total Internal Service Funds 1,236,145$ 2,023,500$ -$ 2,132,724$ 125,000$ -$ 1,001,921$ The City maintains Internal Service Funds to provide full operational costing for services.Two of these funds are equipment replacement sinking funds which charge back to departments the cost of the assets,to ensure funding is set aside and to charge an appropriate annual cost for the asset.Replacement Fund balances reflect the funding accumulated to date for asset replacement.The remaining Internal Service Funds provide for the cost of services and insurance in a fair, allocated manner. Undesignated Fund Balance reflects the operating budget's ongoing revenues,expenditures,carryforwards,transfers in and out,and the use of fund balance reserves.Designated Fund Balance reflects both legal requirements and Council directed reserves.The Operations Reserve grows by the annual investment rate earned by the City each year,and ensures cash availability for operations.The Economic Uncertainty Reserve was established at $1.5 million for dire economic situations. Special Revenue Funds are reserved for legally restricted revenues and obilgations. The CDBG Fund reflects grant funding which is tracked through this fund and transferred to the appropriate fund.The Saratoga Housing and Rehabilitation Fund (SHARP)is solely for receipts related to the loan program.The Landscape & Lighting Districts are restricted for use in paying for utilities and services for established districts. C ITY OF SARATOGA F INANCIAL SUMMARIES B - 19 FUND BALANCE ACTIVITY FY 2010/11 7/1/2010 Plus Plus Less Less Source &6/30/2011 Estimated Revenues &Transfers Expenditures &Transfers (Use) of Estimated Balance Carryforwards In Carryforwards Out Fund Bal Balance Debt Service Funds 2001 Series GO Bonds 959,554 962,000 - 1,019,656 - - 901,898 Total Debt Service Funds 959,554$ 962,000$ -$ 1,019,656$ -$ -$ 901,898$ Trust Funds Library Capital Improvement 345,033 - - - 345,033 - - KSAR Trust Fund 105,588 68,500 - 174,088 - - - Total Trust Funds 450,621$ 68,500$ -$ 174,088$ 345,033$ -$ -$ Capital Improvement Plan Funds Street Projects 1,420,885 5,032,712 302,420 6,650,017 106,000 - - Parks & Trails Projects 556,413 2,375,007 214,800 3,146,220 - - - Facility Projects 438,443 5,000 756,636 1,200,079 - - - Administrative Projects 219,773 - - 219,773 - - - Total Capital Improvement Funds 2,635,513$ 7,412,719$ 1,273,856$ 11,216,089$ 106,000$ -$ -$ FUND BALANCE TOTALS 13,484,878$ 26,352,722$ 1,523,406$ 30,614,141$ 1,523,406$ -$ 9,223,460$ Debt Service Funds reflects City debt.The City issued General Obligation Bonds in 2001 for the library expansion project.The Fund reflects the property tax assessment receipts, and the debt principal & interest payments made during the fiscal year. Fund Balance reflects the City's reserve for this debt issuance. The City holds two trust funds in a fiduciary capacity:The Library Bond's Capital Project Reserve,and the KSAR Community Access Television Foundation Investment Funds.Both funds earn interest on their fund balance at the City's investment rates.The Leonard Road Fund was closed with it's termination in the FY 2006/07 Year End. The above CIP funds are included at a summary level.Capital revenues include all outstanding funding sources identified as a source of funds for projects as approved in the fiscal year,however not all funding is expected to become available in the fiscal year.Appropriated expenditures will be reduced to actuals at year-end and the remaining project balance will be rolled forward. C ITY OF SARATOGA F INANCIAL SUMMARIES B - 20 FUND BALANCE RESERVES 5 YEAR COMPARATIVE HISTORY 6/30/2007 6/30/2008 6/30/2009 6/30/2010 6/30/2011 Actual Actual Actual Estimated Budgeted YE Balance YE Balance YE Balance YE Balance YE Balance General Fund Reserved Reserved for Petty Cash 1,300 1,300 1,300 1,300 1,300 Designated Operations Reserve 2,688,037 2,808,164 2,870,139 2,891,666 2,920,582 Economic Uncertainty 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 Economic Stability Reserve - - 25,000 - - Environmental Services Reserve 710,667 679,917 613,182 563,182 513,182 Development Services Reserve 776,192 782,380 707,380 632,380 422,380 Uncollected Deposits Reserve - 289,454 182,159 182,159 182,159 Carryforward Reserve 380,875 58,386 22,000 - - Capital Project Reserve 450,000 1,200,000 900,000 600,000 600,000 Hillside Stability Reserve - - 300,000 300,000 300,000 Open Space Land Reserve - - 250,000 - - Undesignated Undesignated Fund Balance 1,740,530 2,216,238 857,525 884,762 407,404 Total General Fund Reserves 8,880,760 9,535,839 8,228,686 7,555,448 6,847,008 Special Revenue Funds CDBG Program Fund - - - - - SHARP Program Fund 202,368 206,658 209,175 210,125 211,125 Landscape & Lighting Districts 316,078 209,821 359,916 437,472 261,509 Total Special Revenue Funds 930,766 416,479 569,091 647,597 472,634 Internal Service Liability / Risk Management - 128,689 202,871 241,493 129,528 Workers Compensation - 47,735 123,033 181,415 158,624 Office Support Services - 32,616 39,633 31,033 24,983 IT Services - 122,541 174,837 127,589 87,454 Vehicle & Equipment Maintenance - 13,412 56,654 59,693 49,070 Building Maintenance (15,618) 101,361 208,841 189,039 172,878 Vehicle & Equipment Replacement 8,573 98,110 153,214 237,587 238,587 IT Equipment Replacement 352,279 316,309 315,289 168,296 140,796 Total Internal Service Reserves 345,235 860,774 1,274,373 1,236,144 1,001,921 Fund Balance Reserves C ITY OF SARATOGA F INANCIAL SUMMARIES B - 21 FUND BALANCE RESERVES 5 YEAR COMPARATIVE HISTORY 6/30/2007 6/30/2008 6/30/2009 6/30/2010 6/30/2011 Actual Actual Actual Estimated Budgeted YE Balance YE Balance YE Balance YE Balance YE Balance Debt Service 2001 Series Library GO Bonds 746,557 853,619 931,360 959,554 901,898 Total Debt Service 754,299 853,619 931,360 959,554 901,898 Trust & Agency Library Capital Improvement 684,553 693,929 354,395 345,033 - KSAR Trust Fund 64,862 38,661 84,603 105,588 - Total Trust & Agency Reserves 749,415 732,590 438,997 450,621 - OPERATING BUDGET RESERVES 11,660,475$ 12,399,301$ 11,442,508$ 10,849,365$ 9,223,460$ Capital Project Funds Street Project Funds 1,703,304 1,955,994 1,906,930 1,420,885 - Park & Trail Project Funds 1,464,309 1,502,397 486,303 556,413 - Facility Improvement Funds 441,991 515,317 953,835 438,443 - Administrative Project Funds - 100,841 163,910 219,773 - Total Capital Projects Funds 3,609,604 4,074,549 3,510,978 2,635,513 - TOTAL RESERVES 15,270,079$ 16,473,850$ 14,953,486$ 13,484,878$ 9,223,460$ Fund Balance Reserves GRAPHIC REPRESENTATION OF 5 YEAR GENERAL FUND AND TOTAL OF ALL FUNDS – FUND BALANCE HISTORY WITH 5 YEAR TREND PROJECTION Note - FY 2010/11 fund balance and five years forward reflect the full expenditure of the Capital Budget in the first year, thereby causing a steep drop and a continued zero balance from that point forward in the graph above. The full appropriation of the capital project budget is to allow for full encumbrance and completion of the projects during the fiscal year, however in most cases this will not occur and project balances will roll forward into the following fiscal year. C ITY OF SARATOGA F INANCIAL SUMMARIES B - 22 DEPARTMENT REVENUES BY PROGRAM FY 2007/08 FY 2008/09 FY 2009/10 FY 2009/10 FY 2010/11 Actuals Actuals Adjusted Estimated Proposed Council & Commissions City Council 14,400 1,800 1,200 1,200 1,200 City Commissions 500 - - - - Total Council & Commissions 14,900$ 1,800$ 1,200 1,200 1,200 City Manager's Department City Manager's Office - 1,000 - 1,418 - City Clerk 3,858 11,012 2,000 550 14,250 Human Resources - - - - - Total City Manager's Department 3,858$ 12,012$ 2,000 1,968 14,250 Finance & Administrative Services Department Finance Services 34,869 83,879 42,650 65,660 40,000 Office Support Services 75,685 65,391 33,000 35,000 42,000 Information Technology Services 369,808 403,976 400,000 400,015 400,000 IT Equipment Replacement 52,103 53,283 58,008 58,008 50,000 Total Finance & Administrative Services 532,465$ 606,529$ 533,658 558,683 532,000 Community Development Development Services 731,759 609,876 470,080 449,390 440,960 Advanced Planning 71,993 131,563 160,000 130,000 130,000 Code Compliance 25,509 22,263 14,150 21,450 19,100 Building & Inspection Services 1,419,548 1,038,584 1,031,100 938,559 942,300 CDBG Program Fund 26,524 55,702 332,897 71,157 394,356 SHARP Program Fund 17,906 2,517 3,000 950 1,000 Total Community Development 2,293,239$ 1,860,505$ 2,011,227 1,611,506 1,927,716 Public Works Department General Engineering 122,480 122,414 75,000 87,560 190,000 Development Engineering 130,195 114,809 121,000 50,766 53,500 Environmental Services 26,517 24,412 8,500 23,000 23,000 Streets & Storm Drains 3,061 18,833 - 80,712 25,000 Parks & Landscape Maintenance 267,066 236,487 231,500 252,196 285,652 Vehicle & Equipment Maintenance 218,232 250,000 208,000 208,000 200,000 Vehicle & Equipment Replacement 200,000 213,569 116,000 110,000 100,000 Landscape & Lighting Districts 435,505 478,535 439,358 436,133 455,193 Total Public Works Department 1,403,056$ 1,459,058$ 1,199,358 1,248,366 1,332,345 Recreation & Facilities Department Recreation Services 646,708 602,175 573,543 572,180 637,642 Teen Services 11,258 3,108 2,500 5,250 5,400 Facility Rentals 242,127 182,531 183,900 210,555 228,900 Building Maintenance 724,514 807,687 704,000 709,213 725,000 Total Recreation Department 1,624,607$ 1,595,500$ 1,463,943 1,497,198 1,596,942 C ITY OF SARATOGA F INANCIAL SUMMARIES B - 23 DEPARTMENT REVENUES BY PROGRAM FY 2007/08 FY 2008/09 FY 2009/10 FY 2009/10 FY 2010/11 Actuals Actuals Adjusted Estimated Proposed Public Safety Public Safety Services 580,932 575,823 470,000 546,292 634,950 Emergency Preparedness 4,221 176 - - - Total Public Safety 585,153$ 575,999$ 470,000 546,292 634,950 Non-Departmental General Administration 12,194,599 12,089,017 11,729,500 11,407,539 11,363,600 Legal Services 71,893 4,441 - - - Community Grants - - - - - Community Events - - - - - Risk Management/Liability Ins 319,814 304,232 305,000 266,916 281,500 Workers Compensation Ins 247,000 270,920 260,000 260,000 225,000 2001 Series Bond Debt Service Fund 1,118,965 1,092,291 960,000 1,043,600 962,000 Library Capital Improvement Fund 14,116 9,358 10,000 2,150 - KSAR Community Access 3,799 45,942 65,200 68,450 68,500 Total Non-Departmental 13,970,186$ 13,816,201$ 13,329,700 13,048,655 12,900,600 Capital Improvement Projects Street Projects 1,447,600 1,202,795 4,484,196 1,507,154 5,032,712 Park & Trail Projects 184,209 446,652 1,940,058 403,047 2,375,007 Facility Projects 150,285 43,471 5,000 41,892 5,000 Administrative Projects - - - - - Total Capital Improvement Projects 1,782,094$ 1,692,918$ 6,429,254 1,952,093 7,412,719 Operating Transfers In General Fund 2,275,254 153,732 198,859 198,859 249,550 L&L Funds - 46,740 - - - Building Maintenance Fund 15,000 - - - - Library Capital Improvement - - - 32,615 - Capital Projects - Streets 1,249,244 830,599 884,495 529,604 302,420 Capital Projects - Parks & Trails 359,360 227,667 277,324 293,210 214,800 Capital Projects - Facilities 590,000 1,003,704 568,912 560,322 756,636 Capital Projects - Administrative 169,280 119,000 50,000 108,887 - Total Operating Transfers In 4,658,138$ 2,381,442$ 1,979,590 1,723,497 1,523,406 Total Revenues and Transfers In 26,867,696 24,001,964 27,419,930 22,189,458 27,876,128 C ITY OF SARATOGA F INANCIAL SUMMARIES B - 24 DEPARTMENT EXPENDITURES BY PROGRAM FY 2007/08 FY 2008/09 FY 2009/10 FY 2009/10 FY 2010/11 Actuals Actuals Adjusted Estimated Proposed Council & Commissions City Council 145,317 147,678 155,772 106,847 141,317 City Commissions 18,275 24,216 23,315 22,015 25,614 Total Council & Commissions 163,592$ 171,894$ 179,087$ 128,862$ 166,931$ City Manager's Department City Manager's Office 573,977 623,246 657,048 637,087 628,099 City Clerk 269,701 337,932 269,566 253,556 310,459 Human Resources 307,937 337,459 348,882 351,768 343,291 Total City Manager's Department 1,151,615$ 1,298,637$ 1,275,496$ 1,242,411$ 1,281,848$ Finance & Administrative Services Department Finance Services 784,139 893,132 861,756 842,004 850,497 Office Stores Fund 43,069 58,374 40,200 43,600 48,050 Information Technology Services 247,266 351,680 471,832 375,432 440,134 IT Equipment Replacement 17,340 54,303 66,200 55,000 52,500 Total Finance & Administrative Servic 1,091,814$ 1,357,489$ 1,439,988$ 1,316,037$ 1,391,181$ Community Development Development Services 972,894 993,349 917,629 855,889 867,357 Advanced Planning 61,575 211,313 159,206 183,766 162,128 Code Compliance 213,305 224,583 190,587 195,767 188,235 Building & Inspection Services 985,353 1,021,304 876,038 873,344 821,100 CDBG Program Fund - - - - - Housing & Rehabilitation Pgm - - - - - Total Community Development 2,238,738$ 2,450,548$ 2,143,460$ 2,108,766$ 2,038,821$ Public Works Department General Engineering 577,673 568,312 494,394 459,492 461,911 Development Engineering 176,996 179,226 185,462 176,020 189,785 Environmental Services 440,683 424,750 521,251 495,688 500,599 Streets & Storm Drains 1,319,186 1,299,945 1,231,404 1,227,096 1,179,540 Parks & Landscape Maintenance 1,795,957 1,880,411 1,891,657 1,879,153 1,964,545 Equipment Maintenance 204,818 206,758 219,033 204,963 210,623 Vehicle & Equipment Replacement 110,464 158,465 36,360 25,627 74,000 Landscape & Lighting Districts 359,247 347,000 536,061 358,577 631,156 Total Public Works Department 4,985,025$ 5,064,867$ 5,115,622$ 4,826,617$ 5,212,159$ Recreation & Facilities Department Recreation Services 941,212 981,619 888,392 888,213 929,173 Teen Services 123,487 121,343 64,236 58,213 67,087 Facility Rentals 304,534 321,459 296,066 279,511 330,640 Building Maintenance 642,264 700,207 741,379 729,015 741,161 Total Recreation Department 2,011,497$ 2,124,628$ 1,990,073$ 1,954,952$ 2,068,060$ C ITY OF SARATOGA F INANCIAL SUMMARIES B - 25 DEPARTMENT EXPENDITURES BY PROGRAM FY 2007/08 FY 2008/09 FY 2009/10 FY 2009/10 FY 2010/11 Actuals Actuals Adjusted Estimated Proposed Public Safety Public Safety Services 3,937,033 4,174,584 4,313,597 4,355,535 4,480,266 Emergency Preparedness 15,607 31,088 31,637 35,710 43,165 Total Public Safety 3,952,640$ 4,205,672$ 4,345,234$ 4,391,245$ 4,523,431$ Non-Departmental General Administration 532,476 482,787 454,805 440,543 464,667 Legal Services 281,961 320,955 306,726 241,363 309,580 Community Grants 167,538 149,803 193,156 193,156 160,676 Community Events 22,396 12,866 14,850 14,636 20,700 Liability / Risk Management 191,125 230,050 342,861 252,373 343,464 Workers Compensation 199,265 195,622 265,881 201,618 222,791 2001 Series Bond Debt Service Fund 1,015,941 1,014,550 1,015,556 1,015,406 1,019,656 Library Capital Improvement Fund 7,782 38,893 15,000 11,106 - KSAR Community Access 30,000 - 100,000 47,465 174,088 Total Non-Departmental 2,448,484$ 2,445,526$ 2,708,835$ 2,417,667$ 2,715,622$ Capital Improvement Projects Street Projects 1,696,829 1,800,383 7,446,001 2,312,399 6,650,017 Park & Trail Projects 548,190 1,587,747 2,410,475 582,937 3,146,220 Facility Projects 606,704 577,563 1,135,192 659,523 1,200,079 Administrative Projects 68,439 55,931 213,910 44,137 219,773 Total Capital Improvement Projects 2,920,162$ 4,021,624$ 11,205,578$ 3,598,996$ 11,216,089$ Operating Transfers Out General Fund 3,255,234 1,571,727 650,000 650,000 553,017 CDBG Fund to GF & CIP 138,090 55,702 332,897 71,157 394,356 Landscape & Lighting Districts 168,000 28,180 - - - Liability/Risk Mgmt Fund - - - - 50,000 Workers Comp Fund - - - - 25,000 Vehicle/Equipment Replacement Fund - - - - 25,000 IT Equipment Replacement to CIP 70,734 - 150,000 150,000 25,000 Library Capital Trust Fund to CIP - 310,000 33,020 33,020 345,033 Capital Projects - Streets 674,337 282,074 177,503 309,149 106,000 Capital Projects - Parks & Trails 20,000 102,667 27,324 43,210 - Capital Projects - Facilities 60,265 31,092 412,113 458,074 - Capital Projects - Administrative - - - 8,887 - Total Operating Transfers Out 4,386,660$ 2,381,442$ 1,782,857$ 1,723,497$ 1,523,406$ Total Expenditures and Transfers Out 25,350,226$ 25,522,326$ 32,186,230$ 23,709,050$ 32,137,547$ C ITY OF SARATOGA F INANCIAL SUMMARIES B - 26 C ITY OF SARATOGA F INANCIAL SUMMARIES B - 27 SUMMARY OF EMPLOYEE SALARY & BENEFITS FY 2010/11 The City of Saratoga’s total budgeted salary and benefit expenditures are projected to total $7.34 million dollars in FY2010/11, representing approximately 22.4% of total budgeted expenditures. The General Fund accounts for 89.2% of the total labor costs at $6.55 million, which represent 41.0% of the General Fund’s budget. Salary and budget projections are prepared using known data on current employees, current MOU provisions, and California Public Employees’ Retirement System (CalPERS), medical, dental, vision, long-term disability, and life insurance premiums. In some years, these projections can be very stable and in others there may be more fluctuation, as in the case of years in which MOUs expire and new MOU provisions are put into place. It is also difficult to predict employee turnover with great precision. Most salaries are budgeted at top step, and health insurance benefits are budgeted at the employee’s current status (Single/Double/Family) at the highest cost health insurance plan. This provides for a consistent budgeting process, with some flexibility built in for staff turnover or status changes. Employee Compensation and Benefits Personnel costs are comprised of salaries for full and part-time personnel, inclusive of holidays and paid time off, and benefits which includes health coverage, life and disability insurances, and retirement contributions. Annual wage increases and benefit adjustments are negotiated under each bargaining unit’s Memorandum of Understanding (MOU) contracts. Memorandums of Understanding Each of the three bargaining units have an MOU: the Saratoga Management Association for the Assistant City Manager and four Department Directors; the Northern California Carpenter’s Regional Council, Carpenters Forty Six Counties Conference Board and Their Affiliated Local Unions (UNION) for the sixteen Public Work’s Corporation Yard staff; and the City’s largest bargaining group with 33 full and part-time employees, the Saratoga Employees Association (SEA) for all other represented staff. The City Manager, the Human Resources Manager,, and hourly (un-benefited) staff are not represented by associations. All three bargaining units entered into a four year MOU agreement effective from July 1, 2007 through September 30, 2011. Wages Effective July 1, 2010 approximately 85% of employees will be at Step 5 (top step) of their salary ranges. Salary ranges adjust each July 1 by the cost of living increase as defined in MOUs. In addition, the City conducts salary surveys with its comparable cities every two years and pay range adjustments are implemented automatically and administratively, based on the salary survey results. In the event a salary range is adjusted in order to maintain Saratoga’s comparable position, those incumbents impacted by the newly established range will receive an increase in salary. Employee Benefits The City provides medical, dental, life insurance, land long-term disability insurance to its benefitted employees and CalPERS coverage to eligible employees. The City also provides self-funded short-term disability coverage of 75% of wages, after paid time off is exhausted, up until long-term coverage activates at six months. Employees also have options to enhance their long-term disability and life insurance plans, and to obtain vision care coverage through a group plan. The following carriers will be renewing effective January 1, 2011. The premium rate increases below reflect the percentage increase in premium rates effective January 1, 2010. Health Insurance (benchmark: Kaiser Plan) 4.77% Ameritas Dental Insurance 33.80% Principal Life Insurance – Non-Director’s 8.48% Principal Life Insurance – Director’s 3.57% Principal AD&D – All 0.00% UNUM Long Term Disability Insurance 0.00% VSP (Vision) – Ameritas 0.00% C ITY OF SARATOGA F INANCIAL SUMMARIES B - 28 The City contracts for Health Insurance through CalPERS, offering employees a choice between Kaiser, Blue Cross, or Blue Shield medical plans. Although CalPERS has substantial negotiating powers, health insurance premiums continue to increase each year. For October 1, 2008 through January 1, 2010, the City was able to negotiate an enhanced dental benefit plan through a new provider – Ameritas -- for the same premium paid in calendar year 2008. Unfortunately, the unexpected result of this enhanced benefit was a significant spike in employees’ use of their dental benefits, resulting in actual claims submitted exceeding the premium the City paid Ameritas as a participant in their group plan. As a result, Ameritas increased the City’s premium rate by 33.80%. The City is working very closely with Ameritas, and monitoring claims this calendar year, with the expectation that employees’ usage of dental benefits will be less and as a result, the City may be able to re-negotiate a lower premium beginning January 1, 2011. The Principal Life Insurance premium increases are the result of demographic changes (age/gender/salary level are all part of the risk factor analysis). Pension Plan The City of Saratoga’s 2% at 55 defined benefit plan is part of the “Miscellaneous 2% at 55 Risk Pool”, a cost sharing multiple-employer defined benefit plan. The City’s payment of CalPERS Contribution Rates is comprised of Employee and Employer contributions. The Employee Contribution Rate under the 2% at 55 benefit plan is constant at 7%, while the Employer Contribution Rate is determined each year by an actuarial valuation of the plan. Employer rates are based on CalPERS’ principle assumptions, including but not limited to an Investment Rate of Return of 7.75% (net of administrative expenses), and an annual payroll growth of 3.25%. Various agency-based factors such as number and age of employees, increases and decreases in employee FTEs, and employee wages, as well as impacts from other agencies in the benefit plan pool are also contributing factors in the calculation. Since 2003, CalPERS has utilized the assumption that the value of its stock, bonds and other holdings would increase by 7.75% a year, and in fact, CalPERS annualized investment rate of return over the past 20 years is slightly higher than the 7.75% target. However with the recent economic turmoil, CalPERS is reassessing its basic assumptions and methodologies. It is anticipated in early 2011 that CalPERS will make a decision if the 7.75% target should continue to be the right projected number or if the projected number should be reduced due to the extended period of modest economic growth world-wide. A cut could force a significant impact to the budget to cover the City’s employee pension obligations. The City will be informed of any change in rate of return upon receipt of its annual valuation report expected in October, 2011. The “Miscellaneous 2% at 55 Risk Pool” has been able to sustain the plan long-term because the plan design is based on actuarially sound principles, while other, enhanced plans (2.5@55, 2.7@55) were built based on short term assumptions that, at least at this point in time, have not been realized, and may ultimately prove to be financially unsustainable. A five year history of Saratoga’s employer contribution rates is provided below, along with the new rate for FY 2010/11, and the projected rate for FY 2011/12. Fiscal Year Employer Contribution Rate FY 2005/06 11.336% FY 2006/07 11.412% FY 2007/08 11.390% FY 2008/09 11.070% FY 2009/10 11.276% FY 2010/11 11.863% FY 2011/12 13.100% C ITY OF SARATOGA F INANCIAL SUMMARIES B - 29 As shown in the schedule above, the City of Saratoga pension plan Employer Contribution Rate for FY 2009/10 is 11.652% of payroll; the expected rate for FY 2010/11 is slightly higher at 11.863% of payroll; and the projected rate for FY 2011/12 is 13.1% of payroll. CalPERS’ estimate for FY 2011/12 assumes that there are no amendments and no liability gains or losses (such as larger than expected pay increases, more retirements than expected, etc.). The gains and losses cannot be predicted in advance; therefore, the projected employer contribution rate for FY 2011/12 is just an estimate. CalPERS will provide the City its actual rate for FY 2011/12 in its annual valuation report expected in October, 2010. Section 22892 of the Public Employees’ Medical and Hospital Care Act (PEMHCA), establishes contract agencies minimum health premium contribution for their participating active membership. The employer contribution is adjusted annually by the board to reflect any changes in the medical care component of the CPI-U. The CPI- Medical Component is $108.00 for calendar year 2011. C ITY OF SARATOGA F INANCIAL SUMMARIES B - 30 TOTAL FUNDED STAFF BY DEPARTMENT 2007/08 2008/09 2009/10 2010/11 Full Time Equivalents (FTE)Funded Funded Funded Funded City Manager's Department City Manager 1.00 1.00 1.00 1.00 Assistant City Manager 1.00 1.00 1.00 0.90 Executive Assistant to CM 1.00 1.00 0.75 0.75 City Clerk 1.00 1.00 1.00 1.00 Human Resources Manager 1.00 1.00 1.00 1.00 Administrative Analyst I/II 1.00 1.00 1.00 0.90 Total FTEs 6.00 6.00 5.75 5.55 Administrative Services Department Administrative Services Director 1.00 1.00 1.00 1.00 Supervising Accountant 1.00 1.00 - - Accountant 1.00 1.00 1.00 0.90 Accounting Technicians 2.00 2.00 3.00 3.00 Information Technology Administrator 1.00 1.00 1.00 1.00 IT Technician/MIS Assistant 1.00 - - - Total FTEs 7.00 6.00 6.00 5.90 Community Development Department Community Development Director 1.00 1.00 1.00 1.00 Senior Planner 1.00 1.00 1.00 1.00 Assistant/Associate Planner 3.00 3.00 2.00 2.00 Plan Check Examiner/Engineer 1.00 1.00 1.00 1.00 Arborist 1.00 1.00 1.00 1.00 Building Official 1.00 1.00 1.00 1.00 Building Inspector 3.00 3.00 2.00 2.00 Office Specialist II/III 2.00 2.00 2.00 2.00 Code Compliance Specialist 1.00 1.00 1.00 1.00 Total FTEs 14.00 14.00 12.00 12.00 Public Works Department Public Works Director 1.00 1.00 1.00 1.00 Senior Civil Engineer - 1.00 1.00 1.00 Assistant/Associate Engineer 3.00 1.00 1.00 1.00 Administrative Analyst I/II 1.00 1.00 1.00 0.90 Office Specialist II/III 1.75 1.75 1.75 1.75 Parks Maintenance Manager 1.00 1.00 1.00 1.00 Parks Maintenance Lead 1.00 1.00 1.00 1.00 Parks Maintenance Specialist 1.00 1.00 1.00 1.00 Parks Maintenance Worker I/II/III 6.00 6.00 6.00 6.00 Street Maintenance Manager 1.00 1.00 1.00 1.00 Street Maintenance Lead 1.00 1.00 1.00 1.00 Street Maintenance Specialist 1.00 1.00 1.00 1.00 Street Maintenance Worker I/II/III 4.00 4.00 4.00 4.00 Total FTEs 22.75 21.75 21.75 21.65 C ITY OF SARATOGA F INANCIAL SUMMARIES B - 31 TOTAL FUNDED STAFF BY DEPARTMENT 2007/08 2008/09 2009/10 2010/11 Funded Funded Funded Funded Recreation & Facilities Department Recreation Department Director 1.00 1.00 1.00 1.00 Senior Recreation Supervisor 1.00 1.00 1.00 1.00 Recreation Supervisor 2.00 1.00 1.00 1.00 Recreation Program Coordinator - 1.00 - - Facility Coordinator 0.60 0.60 0.60 0.60 Office Specialist II/III 2.00 2.00 1.75 1.90 Facility Maintenance Supervisor 1.00 1.00 1.00 1.00 Facility Maintenance Lead 1.00 1.00 1.00 1.00 Facility Maintenance Worker I/II/III 2.00 2.00 2.00 2.00 Total FTEs 10.60 10.60 9.35 9.50 Public Safety Department City Manager - - - - Assistant City Manager - - - - Total FTEs - - - - TOTAL STAFF FTEs 60.35 58.35 54.85 54.60 2007/08 2008/09 2009/10 2010/11 Funded Funded Funded Funded City Manager's Department Office Specialist II/III 1,800 1,600 1,600 1,768 Student Interns 240 - 900 - Executive Assistant - 800 - - Administrative Services Department Sr. Accountant - 960 960 960 Accountant/Budget Analyst 1,040 - - - Accounting Technician 1,040 2,000 - - IT Specialist - 2,000 2,080 2,040 Community Development Department Forestry Intern 940 940 940 940 Planning Intern 450 450 - - Office Specialist II/III - 1,200 1,200 800 Public Works Department Engineering Inspectors 1,840 1,840 1,840 1,840 Maintenance Workers 2,080 2,080 2,080 2,040 Recreation & Facilities Department Facility Attendents 1,700 1,700 1,200 1,362 Recreation Leaders 4,300 4,300 2,034 2,667 Total Annual Hours 15,430 19,870 14,834 14,417 Temporary Hours converted to FTEs 7.42 9.55 7.13 6.93 Total FTEs 67.77 67.90 61.98 61.53 FUNDED HOURLY STAFFING BY DEPARTMENT C ITY OF SARATOGA F INANCIAL SUMMARIES B - 32 STAFFING BY DEPARTMENT Four Year Staffing Trend Full Time Equivalents (FTE) 2007/08 2008/09 2009/10 2010/11 Funded Funded Funded Funded City Manager's Department 6.00 6.00 5.75 5.55 Administrative Services 7.00 6.00 6.00 5.90 Community Development 14.00 14.00 12.00 12.00 Public Works 22.75 21.75 21.75 21.65 Recreation Department 10.60 10.60 9.35 9.50 Public Safety - - - - Total Staff by Department 60.35 58.35 54.85 54.60 TOTAL STAFF BY DEPARTMENT C ITY OF SARATOGA F INANCIAL SUMMARIES B - 33 STAFFING SUMMARIES Four Year History of Department Staffing by Fund Full Time Equivalents (FTE) 2007/08 2008/09 2009/10 2010/11 Funded Funded Funded Funded General Fund City Manager's Department 5.70 5.70 5.70 5.50 Administrative Services 4.80 4.85 4.85 4.75 Community Development 14.00 14.00 12.00 12.00 Public Works 22.05 21.05 21.05 20.95 Recreation Department 6.85 6.65 5.20 5.35 Public Safety - - - - Total General Fund FTEs 53.40 52.25 48.80 48.55 Internal Service Funds City Manager's Department 0.30 0.30 0.05 0.05 Administrative Services 2.20 1.15 1.15 1.15 Public Works 0.70 0.70 0.70 0.70 Recreation Department 3.75 3.95 4.15 4.15 Total Internal Service Funds 6.95 6.10 6.05 6.05 Total FTEs 60.35 58.35 54.85 54.60 TOTAL DEPARTMENTAL STAFF BY FUND C ITY OF SARATOGA F INANCIAL SUMMARIES B - 34