Loading...
HomeMy WebLinkAbout2011-03-16 PACKET 04.Q.REQUEST OF CITY COUNCIL ACTION COUNCIL AGENDA MEETING ITEM # DATE 3/16/11 PREPARED BY Finance Robin Roland ORIGINATING DEPARTMENT DEPARTMENT HEAD COUNCIL ACTION REQUEST To adopt the resolution to write -off Cottage Grove EMS accounts receivable in the amount of $1,197,414. STAFF RECOMMENDATION To adopt the resolution to write -off Cottage Grove EMS accounts receivable in the amount of $1,197,414. BUDGET IMPLICATION BUDGETED AMOUNT ADVISORY COMMISSION ACTION DATE REVIEWED ❑ PLANNING ❑ ❑ PUBLIC SAFETY ❑ ❑ PUBLIC WORKS ❑ ❑ PARKS AND RECREATION ❑ ❑ HUMAN SERVICES /RIGHTS ❑ ❑ ECONOMIC DEV. AUTHORITY ❑ SUPPORTING DOCUMENTS ❑ MEMO /LETTER: ® RESOLUTION: ❑ ORDINANCE: ❑ ENGINEERING RECOMMENDA T ION: ❑ LEGAL RECOMMENDATION: ❑ OTHER: ACTUAL AMOUNT APPROVED DENIED ❑ ❑ ❑ ❑ ❑ ❑ ❑ ❑ ❑ ❑ G: \finance \Council Items \2011 \CC Action Form Am an write -o s.do v r y City o f Co Gr Finance To: Honorable Mayor and City Council Ryan Schroeder, City Administrator From: Robin Roland, Finance Director l e Brenda Peper, Assistant Finance Director Date: March 11, 2011 Subject: Ambulance Write -offs Introduction The Council is asked to consider approving a resolution to write -off uncollectible ambulance accounts totaling $1,197,414. Discussion We are requesting to write -off $1,197,414 in ambulance accounts this year compared to $1,095,840 last year. The write -offs are detailed below: The write offs shown above relate to multiple years of services provided because the timing of the write -offs each year varies by the type of call and whether there is mandatory assignment required. For example, the write -offs related to Medicare and Medicaid are for runs over the past 12 months because the amounts are collected shortly after the billing process starts. However, the write -offs for those accounts "closed by collection" are for runs that occurred over the past couple of years. For the first four types (Medicare through other mandatory adjustment) we are only allowed to collect a small government payment and a small co- payment from the patient for the call. The amounts provided through this arrangement are a fraction of our billing rate and is lower than our cost to provide the service. The "closed by collection" calls are for our remaining patients. These are amounts that the collection 2007 2008 2009 2010 Percentage Increase ('09 to' 10) Medicare $480,953.93 $487,305.77 $641,497.90 $729,729.00 13.75% Medicaid 186,661.86 154,519.73 243,804.00 270,738.00 11.05% Worker's Comp. 4,798.96 6,061.09 4,878.61 2,306.49 - 52.72% Other Manadatory Adj 7,324.73 4,011.13 13,241.00 8,835.00 - 33.28% Bankruptcy 3,639.69 5,519.24 2,126.00 322.00 84.85% Closed by Collection 122,105.83 164,214.00 190,292.00 185,484.00 - 2.53% Total Write-offsl 095,839.51 $1,197,414.49 9.27% The write offs shown above relate to multiple years of services provided because the timing of the write -offs each year varies by the type of call and whether there is mandatory assignment required. For example, the write -offs related to Medicare and Medicaid are for runs over the past 12 months because the amounts are collected shortly after the billing process starts. However, the write -offs for those accounts "closed by collection" are for runs that occurred over the past couple of years. For the first four types (Medicare through other mandatory adjustment) we are only allowed to collect a small government payment and a small co- payment from the patient for the call. The amounts provided through this arrangement are a fraction of our billing rate and is lower than our cost to provide the service. The "closed by collection" calls are for our remaining patients. These are amounts that the collection agency feels they no longer will be able to collect. This process takes over 12 months from the call date to run through the collection process. Currently if the calls are not paid within 120 days, they are sent to collection as well as placed in the State Revenue Recapture program for collection. The Medicare write -offs have increased since 2002 when Cottage Grove EMS was required to accept assignment for Medicare payments. Medicare / Medicaid continues to pay a predetermined dollar amount no matter what our rates are set at. The table below includes an example outlining the Medicare reimbursement amounts for the past six years. The table demonstrates that the reimbursement rate from the federal government is the same no matter what the total bill is. As our rates increase faster than the increase in the reimbursement amount, the write -off amounts will also increase. Type of Call 2006 2007 Cottage 2008 Grove 2009 2010 2011 BLS Rate $ 924.67 $ 989.40 $ 1,104.00 $ 1,160.00 $ 1,230.00 $ 1,270.00 Medicare Reimb 309.83 312.38 324.49 338.08 331.45 340.37 Reimbursed 33.51% 31.57% 29.39% 29.14% 26.95% 26.80% ALS -1 Rate 1,198.81 1,282.73 1,368.00 1,430.00 1,520.00 1,570.00 Medicare Reimb 367.93 370.95 385.34 401.47 393.59 404.19 % Reimbursed 30.69% 28.92% 28.17% 28.07% 25.89% 25.74% ALS -2 Rate 1,429.85 1,563.00 1,650.00 1,750.00 1,810.00 Medicare Reimb 536.90 557.72 581.07 569.68 585.01 % Reimbursed 37.55% 35.68% 35.22% 32.55% 32.32% Below is information on the write -off trend for the past several years as compared to the corresponding revenue by year. 2005 2006 2007 2008 2009 2010 Totals Revenue (billed charges) 1,319,476 1,598,013 1,827,778 1,781,000 2,094,560 2,331,188 13,146,943 Write-Offs Medicare 289,861 378,524 492,645 508,955 658,515 637,458 Medicaid 101,165 200,476 177,900 161,952 269,671 215,999 Worker's Comp /Other Mandatory 8,224 10,552 12,123 10,120 14,742 8,585 Bankruptcy 2,629 0 7,897 3,777 1,117 Uncontrollable Total 401,879 589,552 690,565 684,804 944,045 862,042 Closed by Collection (Controllable) 115,887 139,873 179,072 164,700 186,443 0 Total Write Offs 517,766 729,425 869,637 849,504 1,130,488 862,042 Written Off 2010 -1,647 -2,806 - 10,297 13,791 336,331 862,042 I 1,197,4141 Written Off previously 519,413 732,231 879,934 835,713 794,157 0 4,560,461 Total Write offs 517,766 729,425 869,637 849,504 1,130,488 862,042 5,757,875; Write offs as % of Revenue Revenue Increase 11.62% 21.11% 14.38% -2.56% 14.60% 30.89% Uncontrollable 30.46% 36.89% 37.78% 38.45% 45.07% 36.98% Controllable 8.78% 8.75% 9.80% 9.25% 8.90% 0.00% Still Owing 0.00% 0.00% 0.00% 0.00% 0.00% 24.70% Controllable write -offs as % of Net Revenue Revenue 1,319,476 1,598,013 1,827,778 1,781,000 2,094,560 2,331,188 Uncontrollable write -offs 401,879 589,552 690,565 684,804 944,045 862,042 Net Revenue 917,597 1,008,461 1,137,213 1,096,196 1,150,515 1,469,146 Controllable write -offs 115,887 139,873 179,072 164,700 186,443 0 Controll. write -offs as % of Net Rev. 12.63% 13.87% 15.75% 15.02% 16.21% Staff has tracked the revenue (charges) versus write offs by each City for the past three years. Grey Cloud Township reimburses the City for their write offs so these have not been included. 2010 has not been included because all the mandatory write - off's have not been accounted for as they are still working through the system. W /O's as % 42.27% 58.69% 59.28% 0.00% 62.47% Charges Write off's W /O's as % tage Grove $ 1,179,375 $ 491,900 41.71% roport 220,690 118,353 53.63% Paul Park 414,931 256,630 61.85% !y Cloud 4,040 - 0.00% of Area 8,742 1,248 14.28% 1,827,778 868,131 47.50% W /O's as % 42.27% 58.69% 59.28% 0.00% 62.47% Charges Write offs Cottage Grove $ 1,207,326 $ 510,360 Newport 231,887 136,085 St. Paul Park 334,487 198,295 Grey Cloud 2,880 - Out of Area 4,420 2,761 - 1,781,000 847,501 W /O's as % 42.27% 58.69% 59.28% 0.00% 62.47% In 2004 the City started placing delinquent patient ambulance accounts, if we have a social security number, in the State Revenue Recapture Program for collection. The City has been able to collect approximately $214,000 through this program from 2004 through 2010. This program is proving to be a cost effective way to collect delinquent accounts. Attached is a draft of the financial statements for the ambulance fund. These have not been audited yet so there is a chance they could change but we do not expect them to change significantly. The statement includes 6 years of history for comparison purposes. The adopted 2010 budget shows a net operating income of $9,990 Charges Write off's W /O's as % Cottage Grove $ 1,445,130 $ 725,274 50.19% Newport 255,620 158,923 62.17% St. Paul Park 370,550 235,308 63.50% Grey Cloud 9,290 - 0.00% Out of Area 14,130 4,112 29.10% 2,094,720 1,123,617 53.64% In 2004 the City started placing delinquent patient ambulance accounts, if we have a social security number, in the State Revenue Recapture Program for collection. The City has been able to collect approximately $214,000 through this program from 2004 through 2010. This program is proving to be a cost effective way to collect delinquent accounts. Attached is a draft of the financial statements for the ambulance fund. These have not been audited yet so there is a chance they could change but we do not expect them to change significantly. The statement includes 6 years of history for comparison purposes. The adopted 2010 budget shows a net operating income of $9,990 compared to an actual net income of $41,716 because a federal grant was received for ambulance stretchers in the amount of $32,107. Action Requested Adopt the resolution authorizing write -offs in the amount of $1,197,414. s • • WHEREAS, certain ambulance bills are determined uncollectable NOW, THEREFORE BE IT RESOLVED, by the City Council of Cottage Grove, County of Washington, State of Minnesota, that $1,197,414 be written off the Cottage Grove EMS accounts. Passed this 16th day of March 2011. Myron Bailey, Mayor Attest: Caron M. Stransky, City Clerk g o Ell