Loading...
HomeMy WebLinkAbout2017-02-02 e-packet@3:30Thursday, February 2, 2017 3:30 PM City of South San Francisco P.O. Box 711 (City Hall, 400 Grand Avenue) South San Francisco, CA City Hall, City Manager's Conference Room 400 Grand Avenue, South San Francisco, CA Budget Standing Committee of the City Council Special Meeting Agenda February 2, 2017Budget Standing Committee of the City Council Special Meeting Agenda NOTICE IS HEREBY GIVEN, pursuant to Section 54956 of the Government Code of the State of California, the Budget Subcommittee of the City of South San Francisco will hold a Special Meeting on Thursday, February 2, 2017 at 3:30 p.m., at City Hall, City Manager's Conference Room, 400 Grand Avenue, South San Francisco, California. Call To Order. Roll Call. Public Comments. MATTERS FOR CONSIDERATION Motion to Approve the Minutes of the meeting of December 19, 2016.1. Report transmitting the Fiscal Year (FY) 2016-17 Mid-year financial report. (Richard Lee, Director of Finance) 2. Report transmitting the Ambulance Service Financial Report for Fiscal Year 2016-17 Quarter One and Quarter Two, and discussing write-off of $2,229,642.57 in uncollectable ambulance billing accounts receivable. (Gerald Kohlmann, Fire Chief) 3. Adjournment. Page 2 City of South San Francisco Printed on 2/14/2017 City of South San Francisco Legislation Text P.O. Box 711 (City Hall, 400 Grand Avenue) South San Francisco, CA File #:17-167 Agenda Date:2/2/2017 Version:1 Item #:1. Motion to Approve the Minutes of the meeting of December 19, 2016. City of South San Francisco Printed on 1/26/2017Page 1 of 1 powered by Legistar™ City of South San Francisco Legislation Text P.O. Box 711 (City Hall, 400 Grand Avenue) South San Francisco, CA File #:17-162 Agenda Date:2/2/2017 Version:1 Item #:2. Report transmitting the Fiscal Year (FY) 2016-17 Mid-year financial report.(Richard Lee, Director of Finance) RECOMMENDATION Staff requests that the Budget Standing Committee provide direction regarding FY 2016-17 Mid-year budget adjustments. BACKGROUND/DISCUSSION At the mid-year point in Fiscal Year 2016-17,certain year-to-date General Fund revenues are projected to exceed budget assumptions,and serve as indicators of a robust economy.Operating departments have diligently kept year-to-date expenditures within budget through regular budget review and analysis,and expenditures are projected to end the fiscal year within approved budget authority. General Fund Revenues Based on current year-to-date revenues,General Fund revenues are projected to end FY 2016-17 at $109.7 million, an increase of $4.0 million or 3.9 percent, as principally noted in the following revenue sources: Property Taxes +$250,000 Current year secured property taxes are projected to be $250,000 above the FY 2016-17 Adopted Budget.On average,the City receives 17 percent of the property tax levy on the assessed value of land and land improvements. Transient Occupancy Tax (TOT) +400,000 | Parking Tax +$200,000 There are three primary drivers that impact TOT revenues: 1.The City’s proximity to San Francisco International Airport (SFO); 2.The average room rate; and 3.Occupancy rates. Through November 2016,passenger traffic at SFO was 6.2 percent more than the same period in the prior year. If the trend holds true through December,SFO will have had 53.1 million passengers in 2016,breaking its annual passenger traffic record for the 11th consecutive year. Through October 2016,the overall occupancy rate remains high at 87.7 percent,and the average room rate of $162 per night are indicative of vibrant tourism in the San Francisco Bay Area.Parking Tax revenues follow similar trends that that of TOT,given the number of parking facilities and hotels that offer park and fly services. Motor Vehicle In-Lieu Tax (Vehicle License Fee) +$363,100 Since 1935,the State of California has collected an annual Vehicle License Fee (VLF)in lieu of assessing a property tax on motor vehicles.In 1998,the state legislature began reducing the VLF rate from 2 percent to 0.65 percent of a vehicle’s value,and backfilled the difference with the State General Fund.In 2004,the state passed the VLF-property tax swap,which backfilled lost VLF revenues with property tax that would have otherwise been directed to schools through the Educational Revenue Augmentation Fund (ERAF).The StateCity of South San Francisco Printed on 1/26/2017Page 1 of 7 powered by Legistar™ File #:17-162 Agenda Date:2/2/2017 Version:1 Item #:2. otherwise been directed to schools through the Educational Revenue Augmentation Fund (ERAF).The State General Fund backfills schools for the loss in ERAF funds. VLF is remitted twice per fiscal year,at the same time as property tax revenues.Half is remitted in December, and the remaining half in April.Based on the amount received in December,the projected year-end total will be $363,100 above the adopted budget. Program Reimbursement - Intergovernmental +$340,000 (one-time) The Fire Department responded to three statewide mutual-aid fires this summer.The additional revenue accounts for reimbursement from the Office of Emergency Services (OES).Staff is also requesting additional appropriations to account for overtime costs incurred in responding to the call for mutual aid Use of Money & Property +$2,380,000 (one-time) The General Fund will receive $1.7 million from the sale of City-owned property located at 178-190 Airport Boulevard,while the remaining $700 thousand in sale proceeds will be recognized by the Parking District Fund. The City’s share of net proceeds from the sale of the Successor Agency-owned property to Sares Regis will bring $680 thousand into the General Fund,while the remaining net proceeds will be remitted to the other taxing agencies within the former Redevelopment Agency. Property Transfer Tax +$200,000 As a General Law city,South San Francisco receives $0.55 for every $1,000 of value for property sold in the city.In 2016,there were 292 single family homes sold for an average sales price of $901,298.Given the current potency of the local real estate market,property transfer taxes are projected to be $200 thousand more than the adopted budget. General Fund Expenditures Including the $1.8 million in requested additional mid-year appropriations and $9.8 million in budget and encumbrances that are projected to be rolled over to FY 2017-18,General Fund expenditures are projected to be $2.1 million under budget by the end of the fiscal year. City Clerk | SB 415 Notices +$20,000 (one-time) At its September 28,2016 Regular Meeting,the City Council of the City of South San Francisco adopted Ordinance No.1524-2016 (the Ordinance)in response to the California Voter Participation Rights Act,Senate Bill 415 (SB 415).The Ordinance consolidates the election date for South San Francisco’s elected officials with the date of the statewide elections in November of even-numbered years as mandated by Sections 14050- 14057 of the California Elections Code.The Ordinance also extends the terms of elected officials that are scheduled to end in 2017 and 2019 for 12 months pursuant to Section 10403.5 of the Elections Code.The Ordinance will become operative upon approval by the San Mateo County Board of Supervisors. The County has begun the process of sending city and special district ordinances to the Board of Supervisors for approval on a rolling basis.The County has given school districts priority consideration dates based upon an Elections Code requirement that puts a deadline on school district approvals and does not apply to City approvals. On December 14,2016,the City received word from the County Elections Office that the Ordinance is scheduled for approval by the Board of Supervisors at the February 14,2017 meeting of the Board of City of South San Francisco Printed on 1/26/2017Page 2 of 7 powered by Legistar™ File #:17-162 Agenda Date:2/2/2017 Version:1 Item #:2. scheduled for approval by the Board of Supervisors at the February 14,2017 meeting of the Board of Supervisors.After approval,the City must mail an individually addressed Notice to each of the City’s 31,548 registered voters within 30 days (Elections Code Section 10403.5[e]).The Notice must include the required text in English,Spanish,Tagalog and Chinese and be set forth in a mailer that conspicuously sets it apart as election related mail.The general consensus amongst San Mateo County cities and affiliates of the City Clerk’s Association of California is that the City must send the Notice to each registered voter separately -it will not suffice to issue one Notice to a household addressed to all registered voters residing there. City Attorney | Legal Services & Settlements +$382,000 The City Attorney’s Office is requesting a mid-year budget amendment to account for additional expenditures related to settlements and general legal services.The City settled a larger number of claims and there was a higher volume of City-led initiatives necessitating legal services than originally anticipated for this fiscal year. The increased volume and pace of City-led initiatives is anticipated to continue throughout the remainder of the current fiscal year.The City Attorney’s Office has provided and will continue to provide substantial support in structuring,strategizing and advising on these City-led initiatives,including but not limited to Measure W Community Civic Campus project development,disposition of City-owned property,and research and analysis related to potential development of City-owned properties with complex legal issues,such as the Oyster Point Marina and the Brentwood Parking Lot. City Manager | Oyster Point Phase IIC Master Plan and Technical Studies +$300,000 (one-time) The City Council provided direction for staff to develop a Master Plan for Oyster Point Phase IIC.This effort is needed now to coordinate efforts with the other phases of the project on site and discussions with the Harbor District on a new JPA. The scope of work, schedule and budget are attached to the staff report. City Manager | Oyster Point Area Municipal Services Study +$40,000 (one-time) In addition,the City Manager’s office requests $40,000 in funds to conduct a Municipal Services Study for the Oyster Point Area.This study will develop a needs assessment and cost estimate for public infrastructure and services associated with development in the Oyster Point Area. Human Resources | Succession Development/Legal Services/Class & Compensation +$45,000 The City Council appropriated $25,000 as part of the FY 2015-16 Adopted Budget for a city-wide succession development initiative.However,the appropriations were not encumbered at the end of FY 2015-16,and all unencumbered budget appropriations expire at the end of each fiscal year.Staff requests that the Council appropriate $25,000 to support the succession development efforts. Staff is requesting $15,000 in additional appropriations in the Human Resources Department operating budget to account for legal services that address internal issues such as personnel,discipline,workers compensation settlements and bargaining language. Staff also requests $10,000 in additional appropriations for professional class and compensation research and reporting services. Fire Department | Mutual-aid overtime & various +$478,500 As mentioned above,the Fire Department responded to three statewide mutual-aid fires this summer.$340,000 in additional appropriations is needed to account for the cost of overtime,which is offset by reimbursement from the Office of Emergency Services (OES).Other material mid-year appropriation requests are discussed below,while a full list of Fire Department budget requests are included in the attached FY 2016-17 Mid-Year City of South San Francisco Printed on 1/26/2017Page 3 of 7 powered by Legistar™ File #:17-162 Agenda Date:2/2/2017 Version:1 Item #:2. Budget Adjustments schedule. The Fire Department requests $27,900 in additional funds to replace the department's current gas detection monitors.These monitors are used to detect Oxygen,Carbon Monoxide,Hydrogen Sulfide,hydrocarbon lower explosive limits,and volatile organic compounds.The detection of these gases at critical levels is important for the safety of our employees and the community.These detection devices are used on multiple types of calls ranging from Hazardous Materials incidents,odor investigations,known gas leaks,confined space incidents, and every fire that we respond to ensuring that we limit our exposure to hazardous gases that cannot be detected by normal human senses.Our current inventory has reached its serviceable life and the cost of maintenance and repair is significantly increasing for each of these units.It is time to replace the current monitors with newer, more reliable, technologically upgraded units which will have added capability and lower recurring repair cost. Fire Department staff requests $15,000 in appropriations to purchase Knox box key security/retention devices for Knox keys assigned to response apparatus.These devices would be used to secure the Knox key that each apparatus currently carries in a simple combination safe.The Knox key vault provides tracking and accountability by requiring a unique code for each employee that accesses the key.The vaults visually alert crews while the key is removed from the vault.These vaults would be an increase in security to the department’s 30 year old Knox key program. Staff also requests $51,800 in additional funds to account for recruitment and providing personal protective clothing costs for six personnel.Expenses also include a polygraph test,psychiatric evaluation,extensive background evaluation and medical exam.The request also includes a Fire Captain promotional examination scheduled for May 2017, which includes consultant services, materials, and a test location. Public Works Department | Various operating & CIP +$455,000 The Public Works Department requests $10,000 in appropriations to accommodate supplies required by additional work completed as a result of completing deferred street striping,upgrading existing signs to meet reflectivity standards,and increased maintenance resulting from the agreement with the San Mateo County Flood Control District. Staff also requests $10,000 in funds to procure additional supplies necessary to conduct LED Street Lighting Pilot Programs throughout South San Francisco. Staff recommends that the City Council amend the FY 2016-17 Capital Improvement Program (CIP)in the amount of $75,000 to fund or address any traffic related improvements identified by the City’s Traffic Advisory Committee (TAC).This has historically been an annual project;however funding was omitted from the 2016-17 annual budget request. Public Works requests $250,000 to fund a Traffic Advisory Committee-recommended project to improve pedestrian crossings at uncontrolled intersections across Grand Avenue.The project scope includes design, construction,and installation of flashing beacons,enhanced signage,and passive detection at six crosswalks on Grand Avenue between Airport Boulevard and Walnut Avenue. Staff requests $100,000 to fund a project to demolish and remove the unsafe Colma Creek pedestrian overcrossing.The overcrossing is owned by the Successor Agency,and is part of what is commonly known as the PUC site.Once the PUC site has been sold,the City will recoup the cost from the sale proceeds from the Successor Agency. City of South San Francisco Printed on 1/26/2017Page 4 of 7 powered by Legistar™ File #:17-162 Agenda Date:2/2/2017 Version:1 Item #:2. Library Department | Increase hours for part-time staff/Position reclass +$28,600 The Library Department requests $26,200 in additional funds to account for additional hours from two of its regular part-time Library Assistant IIs,increasing from 26 per week to 32,to address short-staffing during continuing heavy-demand times.Staff requests that the City Council authorize permanently increase their weekly hours to 32 hours per week.The Library currently has one additional part time regular Library Assistant II,who is already scheduled for 32 hours per week.In addition to directly serving the public,both have taken on new responsibilities,including support of makerspace and craft programming and taking a lead role with technology,including maintaining the website and social media outreach.In addition,with the re-opening of the Grand Avenue Branch Library in October,staff is busier providing more services to more people.It is very important to retain regular staff.Relying on a large staff base of hourly positions has made it difficult to maintain an acceptable skill level to meet community needs and expectations.By making their temporary increase permanent, the Library Department will benefit from their continuing to serve in these roles. Staff also requests $2,400 in additional appropriations to reclassify a Library Assistant II to Librarian I/II.The reclassification will provide a career path for the incumbent to continue to grow with South San Francisco.The incumbent has exceptional customer service and technology-assistance skills and is a high performing employee. Parks and Recreation | Classification and Compensation Study/Mobile phones +$67,800 Parks and Recreation Department requests $1,350 in appropriations to purchase mobile phones and pay for monthly service for a Craftworker position that was filled in FY 2016-17 and the Aquatics Supervisor position approved in the FY 2016-17 Adopted Budget.As a lead staff person on the Building Maintenance team working out in the field,the Craftworker’s mobile phone will support the day to day management of maintenance and repair needs in City facilities.Purchase of a mobile phone for the Aquatics Supervisor would be in alignment with the policy of all Parks &Recreation managers and supervisors being assigned City cell phones to support them in their roles overseeing the day to day maintenance and management of City programs, parks, and facilities. Staff also requests $48,000 in additional funds to account for the classification and compensation study that recognized that Hourly Recreation Leaders who work as Preschool Teachers should be compensated at an hourly rate for Preschool Teacher I or II.Calculation of the requested appropriations assumes that out of six FTE hourly Recreation Leaders,half will fall under Teacher I qualifications,and the other half would be qualified as Teacher II.The requested amount of $48,000 is based on the estimated additional cost to cover the salary + benefits adjustment from January-June 2017 (est. $96,000 annually). In addition,$11,000 in additional appropriations are needed to account for the classification and compensation study of preschool teachers that was completed this fiscal year which resulted in changing preschool teacher positions to flex positions,effective July 1,2016.Teacher I positions will be promoted to Teacher II upon receipt of certifications required by Childcare licensing to act as a Site Director. Further,staff requests $7,500 in funds to account for hourly Rec Leader IV (also known as sub-coordinators) serving as "Acting Coordinators"in the After School Recreation Program that should be compensated at the hourly rate for Recreation and Community Services Program Coordinators.The requested additional appropriations are based on assumptions that "Acting Coordinators"serve about 20 hours per week annually. This covers all After School Recreation Programs and Summer, Winter, and Spring Camp. City of South San Francisco Printed on 1/26/2017Page 5 of 7 powered by Legistar™ File #:17-162 Agenda Date:2/2/2017 Version:1 Item #:2. Other Funds Developer Deposits Fund Bike and Pedestrian Master Plan Update +$250,000 Public Works staff requests that the City Council amend the FY 2016-17 Capital Improvement Program (CIP) to include a project to update the Pedestrian and Bicycle Master Plan.Many of the projects identified in the current plans have been constructed and funded through grants.Updating the plans will identify additional projects for pedestrian and bicycle safety.The City’s General Plan Maintenance Reserve,currently with a balance of $1.8 million, will serve as the funding source, which resides in the Developer Deposits Fund. Permit Program User Licenses +$10,000 Staff requests that the City Council appropriate $10,000 to procure additional user licenses for the City’s permit program,as the City is over its capacity for 25 licenses.The Permit Program Replacement Reserve will serve as the funding source, which also resides in the Developer Deposits Fund, and has a balance of $193,800. Train Station Enhancement In-Lieu Fee Fund Caltrain Station Plaza Enhancement - Phase II Design +$95,000 This project will fund further urban design recommendations to improve the upcoming Caltrain Station Improvement project.The project will include community and stakeholder engagement to select a range of preferred options for upgrades to finish material,site furnishings,landscaping,and lighting and security enhancements. Additionally, planning will include program preferences for the plaza and under-highway park. Equipment Replacement Fund Computer hardware replacement +$130,000 The IT Department requests that the City Council appropriate $130,000 of the Computer Hardware Replacement Reserve,which resides in the Equipment Replacement Fund,and current has a balance of $140,500.Additional funds are needed to account for the cost of desktop computer and printers on a city-wide basis. IT Fund Import, Index and Search Building Department Files +$7,000 The Building Department has digitized over 30,000 files and now needs assistance to automate import of files into the City’s document imaging server.This will allow for indexing,search capabilities and provide public access to the files. Parking District Fund Sale Proceeds of 178-190 Airport +$700,000 Pursuant to the Purchase and Sale of the City-owned property located at 178-190 Airport Boulevard,the Parking District receives $700,000 of the sale proceeds. Park-In-Lieu Fee Fund City of South San Francisco Printed on 1/26/2017Page 6 of 7 powered by Legistar™ File #:17-162 Agenda Date:2/2/2017 Version:1 Item #:2. Sares Regis Property +$1,700,000 Pursuant to the purchase and sale of Successor Agency-owned property by Sares Regis,the developer will pay $1.7 million in Park-In-Lieu fees. FUNDING Approval of the additional appropriations will generate a projected net surplus of $5.4 million.Pursuant to the City’s Reserves Policy,$2.2 million of the net surplus will be needed to fund minimum reserve requirements. Staff recommends the remaining $3.3 million in net surplus be transferred to the City’s Infrastructure Reserve. CONCLUSION The City’s operating budget at the mid-year point remains on target.The additional revenues and offsetting appropriations maintain the City’s prudent financial position. Attachments: 1.General Fund Summary 2.Park-In-Lieu Fees Fund Summary 3.Developer Deposit Fund Summary 4.Train Station Enhancement In-Lieu Fee Fund Summary 5.Capital Improvement Project Fund Summary 6.Parking District Fund Summary 7.Equipment Replacement Fund Summary 8.Information Technology Fund Summary 9.Oyster Point Marina - Concept Plan Outline 10.FY 2016-17 Mid-Year Budget Adjustments 11.PowerPoint Presentation City of South San Francisco Printed on 1/26/2017Page 7 of 7 powered by Legistar™ FY 2016-17 MID-YEAR BUDGET GENERAL FUND SUMMARY Revenues Property Taxes 22,543,734$ 23,264,539$ 23,264,539$ 16,546,450$ 23,514,539 ERAF Refund from County 2,233,926 2,222,250 2,222,250 - 2,222,250 Sales Tax 17,710,425 23,105,336 23,105,336 8,462,794 23,105,336 Transient Occupancy Tax 13,442,951 13,100,000 13,100,000 6,367,837 13,500,000 Business License 1,375,875 1,300,000 1,300,000 962,972 1,300,000 Commercial Parking Tax 3,252,356 3,383,400 3,383,400 1,585,445 3,583,400 Franchise Fees 3,982,092 4,060,000 4,060,000 994,691 4,060,000 Building and Fire Permits 6,896,895 8,411,713 8,411,713 3,277,285 8,411,713 Motor Vehicle License & In-Lieu 5,770,060 5,770,060 5,770,060 3,066,615 6,133,160 Revenue from Other Agencies 2,063,600 1,024,896 1,636,561 662,351 1,985,973 Charges for Services 7,294,607 7,235,843 7,375,843 3,141,048 7,307,843 Administrative Charges 1,365,265 1,365,265 1,365,265 682,633 1,365,265 Fines 791,756 838,500 838,500 381,308 838,500 Use of Money & Property 3,079,978 3,071,500 3,071,500 1,286,648 5,451,500 Transfers In & Other 2,810,057 6,654,823 6,675,323 3,352,224 6,875,323 Add Prior Year Committed Reserves N/A N/A 3,951,003 3,951,003 Total Revenues 94,613,575$ 104,808,125$ 109,531,292$ 50,770,299$ 113,605,804$ Budget Expenditures City Council 268,134$ 204,499$ 204,499$ 95,938$ 204,499$ -$ 204,499$ City Clerk 646,517 647,864 647,864 309,176 647,864 20,000 667,864 City Treasurer 118,788 123,340 123,340 49,617 123,340 - 123,340 City Attorney 782,389 802,002 802,002 391,904 802,002 382,000 1,184,002 City Manager 1,735,427 1,926,245 2,094,915 765,816 2,094,915 340,000 2,434,915 Finance 2,186,649 2,477,795 2,522,457 1,213,035 2,522,457 - 2,522,457 Non-Departmental 1,108,496 973,973 1,155,102 410,240 1,155,102 - 1,155,102 Human Resources 1,468,781 1,458,009 1,508,044 714,667 1,508,044 45,000 1,553,044 Economic & Community Dev 6,144,860 10,331,488 10,918,200 2,905,530 5,811,061 - 5,811,061 Fire 24,058,472 25,689,589 25,735,043 12,758,212 25,735,043 478,517 26,213,560 Police 25,319,520 27,104,498 27,234,498 12,745,365 27,234,498 9,412 27,243,910 Public Works 5,025,903 4,975,860 5,278,790 2,237,413 5,278,790 120,000 5,398,790 Library 4,681,186 5,051,647 5,254,059 2,558,503 5,254,059 28,638 5,282,697 Parks & Recreation 13,234,028 14,553,266 15,079,579 7,292,547 15,079,579 67,844 15,147,423 CIP 1,587,763 6,468,980 9,218,937 592,875 2,371,500 325,000 2,696,500 Transfers Out/Other 4,510,851 700,000 700,000 250,000 700,000 - 700,000 Total Expenditures 92,877,764$ 103,489,055$ 108,477,330$ 45,290,837$ 96,522,752.96$ 1,816,411$ 98,339,164$ Less Projected Purchase Order/CIP Rollover 9,831,416$ 9,831,416$ Net Surplus / (Deficit)7,251,636 5,435,225 20% of operating revenues 20,713,082$ 20,713,082$ Beginning balance 18,527,949$ 18,527,949 Amount needed to fully fund reserves 2,185,133$ 2,185,133 Remaining surplus to be transferred to Infrastructure Reserves 5,066,503$ 3,250,092 2015-16 Actual 2016-17 Adopted 2016-17 Amended 2016-17 YTD 2015-16 Actual 2016-17 Adopted 2016-17 Amended 2016-17 YTD 2016-17 Projected 2016-17 Requested 2016-17 Proposed (Projected + Requested) 2016-17 Projected FY 2016-17 Mid-Year Budget Adjustments Amount Account Type Fund Fund Department Description 132,000$ Expenditure 100 General Fund City Attorney Legal services 250,000 Expenditure 100 General Fund City Attorney Legal settlements 20,000 Expenditure 100 General Fund City Clerk SB 415 Change of Election Date Notice 300,000 Expenditure 100 General Fund City Manager OP Phase IIC Master Plan & Technical Studies 40,000 Expenditure 100 General Fund City Manager OPD Environmental Study with Michael Baker Int'l 340,000 Expenditure 100 General Fund Fire Reimbursable OT expense - statewide mutual aid 51,787 Expenditure 100 General Fund Fire New hire recruitment cost including protective clothing, test, consultations, etc. 27,940 Expenditure 100 General Fund Fire Replace 10 gas detection monitors 15,000 Expenditure 100 General Fund Fire 13 Knox key vaults to increase Knox key security 340,000 Revenue 100 General Fund Fire Reimbursable OT expense - statewide mutual aid 10,000 Expenditure 100 General Fund Fire Fire Staff development/training 8,090 Expenditure 100 General Fund Fire Replace Emergency Operations Center (EOC) tables 8,000 Expenditure 100 General Fund Fire MREs & Go Bags 5,400 Expenditure 100 General Fund Fire Replace Fire Admin reception area workstation 5,300 Expenditure 100 General Fund Fire New fire hose tester 5,000 Expenditure 100 General Fund Fire External waterproof ventilated storage for Personal Protective Turnout clothing 2,000 Expenditure 100 General Fund Fire Emergency preparedness kit/First aid kit for Safety inspectors 250,000 Revenue 100 General Fund General Property Tax 400,000 Revenue 100 General Fund General TOT 200,000 Revenue 100 General Fund General Commercial Parking Tax 200,000 Revenue 100 General Fund General Property Transfer Tax 363,100 Revenue 100 General Fund General Vehicle License Fee 680,000 Revenue 100 General Fund General City's share of sales proceeds for Sares Regis property 1,700,000 Revenue 100 General Fund General Sale proceeds of 178-190 Airport property 25,000 Expenditure 100 General Fund HR Succession Development 15,000 Expenditure 100 General Fund HR Legal fees for all HR related internal issues 5,000 Expenditure 100 General Fund HR Class and Compensation- Professional services for research and reporting capabilities. 2,400 Expenditure 100 General Fund Library Reclass Library Assistant II to Librarian I/II 13,119 Expenditure 100 General Fund Library Increase hours for PT Library Assistant IIs 13,119 Expenditure 100 General Fund Library Increase hours for PT Library Assistant IIs 48,000 Expenditure 100 General Fund P&R P&R Class/Comp Study - Hourly Rec Leaders 11,000 Expenditure 100 General Fund P&R Class/Comp study - Flex positions of Preschool Teacher I to Teacher II 7,500 Expenditure 100 General Fund P&R Class/Comp Study - Rec Leader IV/Acting Coordinators 844 Expenditure 100 General Fund P&R Phone and service- RCS supervisor position. 500 Expenditure 100 General Fund P&R Phone and service- new Craftworker position. Cost for suture year is estimated $644.00 9,412 Revenue 100 General Fund Police Bulletproof Vests DOJ grant 9,412 Expenditure 100 General Fund Police Bulletproof Vests DOJ grant 250,000 Expenditure 100 General Fund PW Grand Ave Ped improvements 100,000 Expenditure 100 General Fund PW Demolish Colma Creek Ped Bridge @ Antoinette 75,000 Expenditure 100 General Fund PW TAC-identified traffic-related improvements 10,000 Expenditure 100 General Fund PW Street striping, street signs, maintenance re: San Mateo County Flood Control District 10,000 Expenditure 100 General Fund PW LED Street Lighting Pilot Programs 1,700,000 Revenue 209 Park-In-Lieu Fees General Park in lieu Fee from Sares Regis 10,000 Expenditure 270 Developer Deposi IT TrakIT user licenses 250,000 Expenditure 270 Developer Deposi PW Bike Ped Master Plan updates 95,000 Expenditure 290 Train Station Enha ECD Caltrain Station Plaza Enhancement - Phase II Design 75,000 Expenditure 510 CIP Fund PW Traffic-related improvements in CIP identified by TAC; 75,000 Revenue 510 CIP Fund PW Transfer in from General Fund for traffic-related improvements 250,000 Revenue 510 CIP Fund PW Transfer in from General Fund for Grand Ave ped improvements Revenue 510 CIP Fund ECD Transfer in from Train Station Enhancement In-Lieu Fee Fund for Caltrain Station Plaza Enhancement Expenditure 510 CIP Fund ECD Caltrain Station Plaza Enhancement - Phase II Design; Project st1603 250,000 Expenditure 510 CIP Fund PW Grand Ave Ped improvements 700,000 Revenue 720 Parking District FuGeneral Parking District's share of sale proceeds for 178-190 Airport property 129,948 Expenditure 784 Equipment Replac IT Computer hardware 10,000 Expenditure 785 IT Fund IT TrakIT user licenses 7,000 Expenditure 785 IT Fund IT Import/index/search electronic files for Building Dept FY 2016-17 Mid-Year Budget Budget Standing Committee February 2, 2017 Overview General Fund Summary General Fund Revenues General Fund Mid-Year Budget Requests Other Funds Mid-Year Budget Requests CalPERS Discount Rate Reduction General Fund Summary (in millions) Description Projected Total Revenues $113.6 Less: Total Expenditures $98.3 Less: Purchase Orders to Roll Over $9.8 Net Surplus $5.4 Surplus to Reserves $2.2 Remaining Surplus $3.2 General Fund Revenues Property Taxes +$250k TOT +$400k / Parking Tax +$200k VLF +$363k CalOES Reimbursement +$340k Sale of Property +$2.4M Property Transfer Tax +$200k General Fund Mid-Year Budget Requests City Clerk – SB 415 Notices +$20k City Attorney – Legal Svcs/Settlement +$382k City Manager – Oyster Point +$340k ◦$40k Municipal Services Study ◦$300k Master Plan & Technical Studies HR – Succession Development/Legal Svcs/Class & Comp +$45k General Fund Mid-Year Budget Requests (Continued) Fire Department +$478k ◦$340k Mutual-aid overtime (reimburse f/ CalOES) ◦$30k Gas detection monitors ◦$15k Knox box key security ◦$52k Recruitment/PPE General Fund Mid-Year Budget Requests (Continued) Public Works Department +$455k ◦$10k Street striping/signs/maintenance ◦$10k LED Street Lighting ◦$75k TAC-recommended traffic CIP ◦$250k Pedestrian crossings on Grand Ave ◦$100k Demolish Colma Creek overcrossing General Fund Mid-Year Budget Requests (Continued) Library +$29k ◦$26k Additional hours for Library Assistant IIs ◦$3k Reclass Library Assistant II to Librarian I/II Parks and Recreation +$68k ◦$66k Classification/Compensation Study $48k Hourly Recreation Leaders $11k Preschool Teachers $7k Recreation Leader IV ◦$2k Craftworker & Aquatics Supervisor mobile phones Other Funds Developer Deposits Fund ◦$250k Bike & Pedestrian Master Plan Update ◦$10k TrakIT user licenses Train Station Enhancement Fee Fund ◦$95k Caltrain Station Plaza Enhancement Design Equipment Replacement Fund ◦$130k Computer hardware Other Funds (Continued) IT Fund ◦$7k Import/Index/Search Building files Parking District Fund +$700k Sale Proceeds Park-In-Lieu Fees Fund +$1.7M Sares Regis CalPERS Discount Rate Reduction Reduce from 7.5% to 7.0% over three years Projected cost to City over the next decade: ◦$47M Actual discount rate should be 6.25% – 6.50% Questions/Discussions PARK-IN LIEU FEES FUND SUMMARY Revenues 2015-16 Actual 2016-17 Adopted 2016-17 Amended 2016-17 YTD 12/31/16 Actual 2016-17 Projected 2016-17 Requested 2016-17 Proposed (Projected + Requested) Interest Income-investments 7,980$ -$ -$ -$ -$ 1,700,000$ 1,700,000$ Unrealized Gains/Losses 6,715 - - - Total Revenues 14,695$ -$ -$ -$ -$ 1,700,000$ 1,700,000$ Expenditures Transfers 130,158$ -$ 574,512$ 57,200$ 574,512$ -$ 574,512$ Total Expenditures 130,158$ -$ 574,512$ 57,200$ 574,512$ -$ 574,512$ Surplus/(Deficit)(115,463)$ -$ (574,512)$ (57,200)$ (574,512)$ 1,700,000$ 1,125,488$ Plus Committed Reserves for CIP 574,512 574,512 Fund Balance 142,970$ 142,970$ 1,842,970$ * 1.7M from Sares Regis DEVELOPER DEPOSITS FUND 2015-16 Actual 2016-17 Adopted 2016-17 Amended 2016-17 YTD Actual 12/31/16 2016-17 Projected 2016-17 Requested 2016-17 Proposed (Projected + Requested) Revenues: CHARGES FOR SERVICES $ 1,359,910 $ - $ - 279,584$ 359,020$ $ - 359,020 USE OF MONEY & PROPERTY 43,263 - - - - - - Total Revenues 1,403,173$ -$ -$ 279,584$ 359,020$ -$ 359,020 Expenditures: PAYROLL 29,201$ -$ 1,862$ 1,862$ -$ 1,862 SUPPLIES & SERVICES 533,665 - 158,650 96,394 - - TRANSFERS OUT - - 260,000 260,000 Total Expenditures 562,866$ -$ 158,650$ 98,255$ 1,862$ 260,000$ 261,862 Surplus/(Deficit)840,307$ -$ (158,650)$ 181,329$ 357,158$ (260,000)$ 97,158 Fund Balance & Reserves 2,135,755$ 2,135,755$ 1,977,105$ 2,317,084$ 2,492,913$ 2,232,913$ 2,590,072$ FUND CHANGES & HIGHLIGHTS: • Transfer $10,000 to IT Fund for TrakIT user licenses from database maintenance fees • Transfer $250,000 to fund Bicycle Pedestrian Master Plan updates from General Plan Maintenance Reserve TRAIN STATION ENHANCEMENT IN-LIEU FEE FUND SUMMARY Revenues 2015-16 Actual 2016-17 Adopted 2016-17 Amended 2016-17 YTD 12/31/16 Actual 2016-17 Projected 2016-17 Requested 2016-17 Proposed (Projected + Requested) Train Station Enhancement Fee 201,996$ -$ -$ -$ -$ -$ -$ Total Revenues 201,996$ -$ -$ -$ -$ -$ -$ Expenditures Transfers out to CIP -$ -$ -$ -$ -$ 95,000$ 95,000$ Total Expenditures -$ -$ -$ -$ -$ 95,000$ 95,000$ Surplus/(Deficit)201,996$ -$ -$ -$ -$ (95,000)$ Fund Balance 459,633$ 459,633$ 459,633$ 459,633$ 459,633$ 364,633$ FUND CHANGES & HIGHLIGHTS: • Fee is collected pursuant to Development Agreements since 2015. CAPITAL IMPROVEMENT FUND SUMMARY Revenues 2015-16 Actual 2016-17 Adopted 2016-17 Amended 2016-17 YTD 12/31/16 Actual 2016-17 Projected 2016-17 Requested 2016-17 Proposed (Projected + Requested) Intergovernmental 2,131,810$ 4,098,180$ 7,642,593$ (176,297)$ (352,593)$ -$ (352,593)$ Other revenues 612,121 250,000 250,000 - -$ - -$ Other Financing Sources - - 218,917 65,135 130,270$ - 130,270$ Transfers In for CIP Expenses 6,161,203 8,904,200 22,527,480 1,582,831 3,165,661$ 420,000 3,585,661$ Transfers In from Infrastructure Reserves 201,996 - - 5,103 10,206$ 10,206$ Total Revenues 9,107,129$ 13,252,380$ 30,638,990$ 1,476,772$ 2,953,544$ 420,000$ 3,373,544$ Expenditures Salaries and Benefits 401,492$ 182,424$ 364,847$ -$ 364,847$ Supplies and Services 8,137,242 13,252,380 31,025,750 3,531,195 7,062,391$ 420,000 7,482,391 Total Expenditures 8,538,734$ 13,252,380$ 31,025,750$ 3,713,619$ 7,427,238$ 420,000$ 7,847,238$ Surplus/(Deficit)568,395$ -$ (386,760)$ (2,236,847)$ (4,473,694)$ -$ (4,473,694)$ Committed reserves for rollover Enc - - 4,184,439 - 4,184,439 4,184,439 Fund Balance 367,023$ 367,023$ 4,164,702$ (1,869,824)$ 77,768$ 367,023$ 77,768$ Infrastructure Reserve 10,316,270 5,889,318 5,889,318 - 5,889,318 5,889,318 ADA Improvement Reserve 386,758 - - - - PARKING FUND SUMMARY Revenues 2015-16 Actual 2016-17 Adopted 2016-17 Amended 2016-17 YTD 12/31/16 Actual 2016-17 Projected 2016-17 Requested 2016-17 Proposed (Projected + Requested) Charges for Services: Parking Permit Fees 116,884$ 95,000$ 95,000$ 90,482$ 180,964$ -$ 180,964$ Parking Meter Fees 646,079 555,000 555,000 300,562 601,124 - 601,124$ Miller Ave Parking Garage 80,235 50,000 50,000 37,967 75,934 - 75,934$ Interest/Other Income 32,012 10,000 10,000 - - 700,000 700,000$ Total Revenues 875,210$ 710,000$ 710,000$ 429,011$ 858,022$ 700,000$ 1,558,022$ Expenditures Payroll 268,371$ 339,876$ 339,876$ 173,276$ 346,552$ -$ 346,552$ Supplies & Services 265,159 196,292 716,211 101,983 203,966 - 203,966 Capital Outlay 257,063 - - - Interdepartmental Charges 104,682 104,986 104,986 52,493 104,986 - 104,986 Total Expenditures 895,275$ 641,154$ 1,161,073$ 327,752$ 655,504$ -$ 655,504$ Surplus/(Deficit)(20,065)$ 68,846$ (451,073)$ 101,259$ 202,518$ 700,000$ 902,518$ Fund Balance 1,912,780$ 1,981,626$ 1,461,707$ 2,014,039$ 2,115,298$ 2,612,780$ 2,815,298$ Reserve for Elevator Replacement 480,000 480,000 480,000 Available Fund Balance 1,912,780$ 1,981,626$ 1,461,707$ 1,534,039$ 1,635,298$ 2,612,780$ 2,335,298$ FUND CHANGES & HIGHLIGHTS: • $700 thousand in share of net proceeds from of sale of City-owned property at 178-190 Airport Boulevard EQUIPMENT REPLACEMENT FUND Revenues 2015-16 Actual 2016-17 Adopted 2016-17 Amended 2016-17 YTD Actual 12/31/16 2016-17 Projected 2016-17 Requested 2016-17 Proposed (Projected + Requested) USE OF MONEY & PROPERTY 84,336$ 95,000$ 95,000$ -$ 95,000$ -$ 95,000$ LEASE FINANCING & CHARGES TO DEPTS 1,678,461 1,854,155 1,854,155 561,368 1,854,155 - 1,854,155 TRANSFERS - - - - - - - Total Revenues 1,762,796$ 1,949,155$ 1,949,155$ 561,368$ 1,949,155$ -$ 1,949,155$ Expenditures SUPPLIES & SERVICES (71,606)$ 211,844$ 464,614$ 104,289$ 594,562$ 129,948$ 724,510$ CAPITAL OUTLAY 723,168 1,388,156 3,239,651 1,414,478 3,239,651 - 3,239,651 DEBT SERVICE 631,419 631,419 631,419 370,903 631,419 - 631,419 TRANSFERS 108,923 100,000 288,669 54,147 288,669 - 288,669 Total Expenditures 1,391,904$ 2,331,419$ 4,624,352$ 1,943,817$ 4,754,301$ 129,948$ 4,884,249$ Surplus/(Deficit)370,892$ (382,264)$ (2,675,197)$ (1,382,449)$ (2,805,146)$ (129,948)$ (2,935,094)$ Plus Committed Reserve for Carry Over Encumbrances 1,939,265$ 1,939,265$ 1,939,265$ Fund Balance 1,375,879$ 993,615$ 639,947$ 1,932,695$ 509,998$ 380,050$ 380,050$ FUND CHANGES & HIGHLIGHTS: • $130,000 requested for computer hardware replacement costs in multiple departments INFORMATION TECHNOLOGY FUND SUMMARY 2015-16 Actual 2016-17 Adopted 2016-17 Amended 2016-17 YTD Actual 12/31/16 2016-17 Projected 2016-17 Requested 2016-17 Proposed (Projected + Requested) Revenues: CHARGES FOR SERVICES $ 45,701 $ 40,000 $ 40,000 12,635$ 40,000$ $ - 35,467 USE OF MONEY & PROPERTY 12,028 14,000 14,000 - 14,000 - 1,658 OTHER REVENUES 2,192,903 2,192,902 2,192,902 1,096,451 2,192,902 10,000 1,644,677 Total Revenues 2,250,631$ 2,246,902$ 2,246,902$ 1,109,086$ 2,246,902$ 10,000$ 1,681,802 Expenditures: PAYROLL 1,068,138$ 1,386,041$ 1,386,041$ 571,875$ 1,386,041$ 0 827,548 SUPPLIES & SERVICES 919,830 1,045,582 1,679,399 612,784 1,679,399 17,000 623,645 INTERDEPARTMENTAL CHARGES 9,677 11,077 11,077 5,539 11,077 - 5,461 Total Expenditures 1,997,645$ 2,442,700$ 3,076,517$ 1,190,198$ 3,076,517$ 17,000$ 1,456,654 Surplus/(Deficit)252,987$ (195,798)$ (829,615)$ (81,112)$ (829,615)$ (7,000)$ 225,148 Fund Balance & Reserves 853,275$ 657,476$ 23,660$ 772,163$ 23,660$ 16,660$ 7,000$ FUND CHANGES & HIGHLIGHTS: • $10,000 to fund TrakIT user licenses from Developer Deposit Fund database maintenance fees • $7,000 to fund import, index and search Building Department files Oyster Point Marina – Phase 2 Concept Plan Task 1 – Concept Plan (Total Budget of $150,000) a. Public Engagement Plan - $30,000 i. Public Visioning Workshops ii. Stakeholder Engagement b. Parks and Open Space Framework Plan - $20,000 i. Open Space Constraints (Wind Study) ii. Open Space Programming iii. Landscape Plan iv. Special Events c. Marina Improvement Plan - $20,000 i. OP Marina Facilities: Upland Uses ii. OP Marina Facilities: Water Dependent Uses iii. Time of User Study (how to attract different segments of the population based on programming and open space types) d. Hotel Parcel RFQ Snapshot (info item only, completed under separate contract) e. Transportation and Connectivity - $15,000 i. Connectivity to Transit/Shuttle/Etc ii. Pedestrian and Bicycle facilities iii. Parking Study (Structure/Surface) and Strategy iv. Wayfinding f. Commercial/Retail Market Study - $35,000 g. Rough Cost Estimating - $20,000 Task 2 - Master Plan / CEQA (Total Budget of $150,000) a. Master Plan Preparation - $10,000 b. Refined Cost Estimates - $20,000 i. Costs for construction, operation and maintenance that may be expected with regard to plan implementation c. Implementation Strategy - $20,000 i. Schedule, responsibility, priority for improvements, action steps needed for implementation d. CEQA Preparation and Adoption - $100,000 Milestones - March 2017 – Release RFP - April 2017 – Select Consultant Team - Summer 2017 – Public Engagement Meetings and Technical Studies - Fall 2017 – Technical Plans Completed, Study Sessions on Alternative Concepts, Determine Preferred Alternative - Winter 2017 – Rough Cost Estimating, Acceptance of Concept Plan - 2018 – Master Plan Preparation / CEQA City of South San Francisco Legislation Text P.O. Box 711 (City Hall, 400 Grand Avenue) South San Francisco, CA File #:17-185 Agenda Date:2/2/2017 Version:1 Item #:3. Report transmitting the Ambulance Service Financial Report for Fiscal Year 2016-17 Quarter One and Quarter Two, and discussing write-off of $2,229,642.57 in uncollectable ambulance billing accounts receivable. (Gerald Kohlmann, Fire Chief) RECOMMENDATION It is recommended that the Budget Subcommittee accept staff’s ambulance service financial report for Fiscal Year 2016-17 quarter one and quarter two,and discuss the write-off of $2,229,642.57 in uncollectable ambulance billing accounts receivable. BACKGROUND/DISCUSSION The purpose of this staff report is to update the Budget Subcommittee on the South San Francisco Fire Department (SSFFD) ambulance service financial status, and to write off uncollectable aged receivables. Staff first reported SSFFD ambulance transportation financial practices to the City Council on December 16, 2015.In that report,staff detailed current accounting practices,provided the history of department operations, and sought direction on future processes for accounting and collection activities.Since that first report,staff has implemented all recommended actions and practices,and provided memos to City Council to provide an update on progress. Staff referred $4,160,743 of aged receivables to Resolve Insurance Systems (RIS),the City’s secondary billing contractor.The secondary billing process is the final step in attempting to collect on unpaid account balances. Staff deferred write-off requests until these referred accounts could be verified as uncollectable. Guidance received through our relationship with the new billing contractor shaped training provided to SSFFD field personnel to maximize the collection opportunity on every patient care report (PCR).By reviewing our initial PCRs,Novato Fire Protection District (NFPD)staff was able to identify specific areas for improvement. Based on the emphasis on these identified elements,all SSFFD response personnel receive ongoing PCR training within their continuous education requirement.Due to this training,PCR and billing documentation has significantly improved and prepared us to receive the highest allowable reimbursement for transports provided by City ambulances. ALS ambulance revenue was $367,759 during quarter one.This was comprised of:$143,044 in July;$125,053 in August;and $99,662 in September.Quarter two revenue was $348,296,comprised of:$79,153 in October; $155,601 in November;and $113,542 in December.See Attachment 1 Quarter One and Quarter Two Monthly Revenue. Fiscal Year 2016-17 ALS ambulance revenue,including adjustments as of December 31,2016,is $715,589.At this time last year,ALS revenues were $809,505.Focused discussions with Novato Fire Protection District (NFPD)have determined that a temporary delay in processing PCRs is the reason for reduced revenues so far in FY 2016-17.It is anticipated that the revenues we should have seen in Quarter two will arrive later in FY 2016- 17. City of South San Francisco Printed on 1/30/2017Page 1 of 3 powered by Legistar™ File #:17-185 Agenda Date:2/2/2017 Version:1 Item #:3. The net operational cost of the ALS ambulance service has increased in FY 2016-17,reflecting the increase in personnel costs and the reduced revenue noted above.EMS supplies consumption has increased due to a 3 percent increase in patient transports (1999 transports in FY 2016-17 quarters one and two),but have been mitigated by increased administrative controls over product selection and ordering. During quarter one,the BLS ambulance service generated $62,222 of revenue.This was made up of $26,273 in July;$22,799 in August;and $13,150 in September.Quarter two for the BLS ambulance yielded $64,302 of revenue:$9,267 in October;$40,833 in November;and $14,202 in December.See Attachment 1 Quarter One and Quarter Two Monthly Revenue. The revenue differences in each month do not necessarily correlate to fluctuations in transport volume,but are associated with a delay in ambulance billing procedures by the City’s contractors.During the transition to the new billing contractor, there were procedural differences that emerged and have been rectified. BLS ambulance revenues have increased due to operational changes made by staff and from improvements in patient care documentation.Staff modified BLS ambulance hours to 12 hours per day,weekdays and special events only,instead of seven days per week.We have also focused the BLS ambulance on supporting the two ALS ambulances more frequently,which reduces the number of incidents where we have to rely on private ambulances. BLS ambulance revenues through quarter two of FY 2016-17 are $121,515,with an additional $7,747 generated by Health and Safety educational programs delivered by BLS staff.This is an increase in revenue compared to this time last year of $76,774.35.Improved training and accuracy related to documentation has proven to be worthwhile and has been validated by the increase in BLS revenue,even though BLS ambulance call volume has decreased.The BLS program has contributed $33,695 to the Emergency Medical Services program so far this fiscal year. In summary,ALS ambulance operational costs consisting of personnel and supplies were $1,562,396. Revenues for quarter one and quarter two totaled $715,589,resulting in costs exceeding revenues by $846,806. BLS ambulance operational costs consisting of personnel and supplies were $95,567.BLS transport and Health &Safety training revenues for quarter one and quarter two totaled $129,262,resulting in an ambulance program offset of $33,695. See Attachment 2 ALS and BLS Financial Summaries. Under City Council direction,SSFFD staff has worked with Finance to develop a hardship waiver process. Since initiating this process,a few customers have contacted SSFFD for hardship waiver write-off,but only one account has been approved by the Finance Director,totaling $2,265.This amount is included in the requested write-off. As of December 31, 2016, the accounts receivable balance is $8,859,086.81, which includes: ·$3,114,162 is from active accounts (180 days or less); ·$823,964 (ADPI, greater than 180 days); ·$862,833 (NFPD, greater than 180 days); and ·$4,058,129 is being worked by RIS secondary billing. As of December 2015,account balances unpaid after being processed by the ambulance billing contractors are being forwarded to Resolve Insurance Services (RIS)for secondary billing,which employs proprietary processes and technology to locate potential commercial or governmental payment sources.Secondary billing City of South San Francisco Printed on 1/30/2017Page 2 of 3 powered by Legistar™ File #:17-185 Agenda Date:2/2/2017 Version:1 Item #:3. processes and technology to locate potential commercial or governmental payment sources.Secondary billing does not involve contact with the patient or a formal collection process.RIS is currently working 3194 accounts totaling $4,058,129.RIS processed the oldest,most at-risk accounts first and has collected $71,617.See Attachment 3 which illustrates the billing process from transport to account closure,whether by payment,write off or a combination of both. Of the $4,058,129 being processed by RIS,$2,229,642.57 has completed the secondary billing phase and there are no more steps remaining in our current billing process.Therefore,staff is recommending the write-off of $2,229,642.57. See Attachment 4 Recommended write-off Accounts Summary. CONCLUSION It is recommended that the Budget Subcommittee accept the ambulance services financial report and discuss the write-off of $2,229,642.57 of the ambulance billing accounts receivable balance that has been determined uncollectable. Attachments: 1.Quarter One and Quarter Two Monthly Revenue 2.ALS and BLS Financial Summaries 3.Billing Process Graphic 4.Recommended Write-off Accounts Summary City of South San Francisco Printed on 1/30/2017Page 3 of 3 powered by Legistar™ February 2, 2017  1  AMBULANCE FINANCIAL STAFF REPORT ATTACHMENT 1    Quarter One and Quarter Two Monthly Revenue   FY 2016‐17 ‐ Quarter One Revenue  ALS REVENUE BLS Revenue  Month Amount Month Amount  July $77,820 July $12,219  August $280,772 August $49,771  September $9,167 September $232  Adjustments* ‐$10,274 Adjustments* ‐$5,009  Total $357,484 Total $57,212    FY 2016‐17 ‐ Quarter Two Revenue  ALS REVENUE BLS Revenue  Month Amount Month Amount  October  $38,341 October  $7,113  November $257,770 November $47,155  December $52,185 December $10,034  Adjustments* $9,809 Adjustments* $0  Total $358,105 Total $64,302  Grand Total  ALS $715,589 BLS $121,515  $837,104              *Adjustments include refunds to insurance companies or patients, and revenue owed to SSFFD.  February 2, 2017  2  AMBULANCE FINANCIAL STAFF REPORT  ATTACHMENT 2    ALS and BLS Financial Summaries     ALS FINANCIAL SUMMARY Personnel Cost $1,384,481 Supplies $177,915 Total Cost $1,562,396 Revenue $715,589 Annual net cost -$846,807     BLS FINANCIAL SUMMARY Personnel Cost $90,492 Supplies $5,075 Total Cost $95,567 Transport Revenue $121,515 Health & Safety Revenue $7,747 Revenue Total $129,262 EMS Program Offset $33,695   Fe b r u a r y  2,  20 1 7    3  AM B U L A N C E  FI N A N C I A L  ST A F F  RE P O R T    ATTACHMENT 3     Am b u l a n c e   Tr a n s p o r t •P a t i e n t  Ca r e  Re p o r t Bi l l i n g   Co n t r a c t o r •I n v o i c e  1 •I n v o i c e  2 •I n v o i c e  3 Pa y m e n t   Ac t i v i t y • I n s u r a n c e  & Pr i v a t e  Pa y   (C l o s e s  Ac c t . ) •N o  Pa y m e n t Re s o l v e  (R I S ) •P a y m e n t •W r i t e  off BI L L I N G  PR O C E S S   February 2, 2017  4    AMBULANCE FINANCIAL STAFF REPORT  ATTACHMENT 4    Recommended Write‐Off Summary   Year # of Accounts Balance   2004 2 $1,010.41  2009 1 $641.90  2010 3 $2,777.46  2011 10 $9,716.40  2012 211 $326,496.89  2013 940 $1,228,214.63  2014 456 $380,214.57  2015 387 $278,305.31  2016 1 $2,265.00  Grand Total 2011 $2,229,642.57