Loading...
HomeMy WebLinkAbout2012-03-21 PACKET 04.C.REQUEST OF CITY COUNCIL ACTION COUNCIL MEETING DATE 3/21/12 AGENDA ITEM# -----7.c 12 Finance ORIGINATING DEPARTMENT Robin Roland DEPARTMENT HEAD COUNCIL ACTION REQUEST: To adopt the resolution to write-off Cottage Grove EMS accounts receivable in the amount of $1,326,834. STAFF RECOMMENDATION: To adopt the resolution to write-off Cottage Grove EMS accounts receivable in the amount of $1,326,834. BUDGET IMPLICATION: BUDGETED AMOUNT ADVISORY COMMISSION ACTION: DATE ❑ PLANNING ❑ PUBLIC SAFETY F PUBLIC WORKS ❑ PARKS AND RECREATION F HUMAN SERVICES/RIGHTS ❑ ECONOMIC DEV. AUTHORITY R SUPPORTING DOCUMENTS: MEMO/LETTER: RESOLUTION: ❑ ORDINANCE: F ENGINEERING RECOMMENDATION: ❑ LEGAL RECOMMENDATION: ❑ OTHER: ACTUAL AMOUNT REVIEWED APPROVED DENIED ❑ ❑ ❑ ❑ ❑ ❑ El El El ❑ ❑ ❑ ❑ ❑ ❑ ❑ ❑ ❑ ❑ ❑ ❑ ADMINISTRATORS COMMENTS: 4 1!'ity Administrator Date COUNCIL ACTION TAKEN: FIAPPROVED ❑ DENIED FIOTHER GAfinance\Council ltems\2012\CC Action Form Ambulance write-offs.doc City (M Finance of • •- Grove To: Honorable Mayor and City Council Ryan Schroeder, City Administrator From: Robin Roland, Finance Director Brenda Peper, Assistant Finance Director VR Date: March 9, 2012 Subject: Ambulance Write -offs Introduction •i The Council is asked to consider approving a resolution to write -off uncollectible ambulance accounts totaling $1,326,834. Discussion We are requesting to write -off $1,326,834 in ambulance accounts this year compared to $1.197.414 last vear. 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 2008 2009 2010 2011 Percentage Increase '10to'11) Medicare $487,305.77 $641,497.90 $729,729.00 $857,857.00 17.56% Medicaid 154,519.73 243,804.00 270,738.00 283,567.00 4.74% Worker's Comp. 6,061.09 4,878.61 2,306.49 5,184.00 124.76% Other Manadatory Ad' 4,011.13 13,241.00 8,835.00 13,383.00 51.48% l Bankruptcy 1 5,519.241 2,126.00 322.00 33.00 - 89.75% Closed b Collection 164,214.00 190,292.00 185,484.00 166,810.00 - 10.07% Total Write-offsl $821,630.96 $1,095,839.51 $1,197,414.49 $1,326,834.001 10.81% 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 31238 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 2011 Totals Revenue (billed charges) 2,917,489 1,827,778 1,781,000 2,094,560 2,331,188 2,470,142 13,422,157 Medicare 668,385 492,645 508,955 660,085 738,752 754,993 Medicaid 301,641 177,900 161,952 269,671 244,910 254,656 Worker's Comp /Other Mandatory 18,776 12,123 10,120 15,997 11,804 14,093 Bankruptcy 2,629 7,897 3,777 1,117 0 33 Uncontrollable Total 991,431 690,565 684,804 946,870 995,466 1,023,775 Closed by Collection (Controllable) 251,352 174,817 155,307 166,298 205,011 Total Write Offs 1,242,783 865,382 840,111 1,113,168 1,200,477 1,023,775 Written Off 2011 -4,408 -4,255 -9,393 - 17,320 338,435 1,023,775 1,326,834 Written Off previously 1,247,191 869,637 849,504 1,130,488 862,042 0 4.958.862 Total Write offs 1,242,783 865,382 840,111 1,113,168 1,200,477 1,023,775 6,285,696 Write offs as % of Revenue Revenue increase 2,917,489 14.38% -2.56% 17.61% 11.30% 5.96% Uncontrollable 33.98% 37.78% 38.45% 45.21% 42.70% 41.45% Controllable 8.62% 9.56% 8.72% 7.94% 8.79% 0.00% Still Owing 0.00% 0.00% 0.00% 0.00% 0.00% 20.43% Controllable write -offs as % of Net Revenue Revenue 2,917,489 1,827,778 1,781,000 2,094,560 2,331,188 2,470,142 Uncontrollable write -offs 991,431 690,565 684,804 946,870 995,466 1,023,775 Net Revenue 1,926,058 1,137,213 1,096,196 1,147,690 1,335,722 1,446,367 Controllable write -offs 251,352 174,817 155,307 166,298 205,011 0 Control. write -offs as % of Net Rev. 13.05% 15.37% 14.17% 14.49% 15.35% 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. 2011 has not been included because all the mandatory write - offs have not been accounted for as they are still working through the system. Write off's W /O's as % $ 820,232 51.1 159,269 61.3 204,323 60.E 3,990 1,187, 814 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 $243,000 through this program from 2004 through 2011. This program is proving to be a cost effective way to collect delinquent accounts. Draft Financial Statements 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 2011 budget contained a net operating loss of $83,455 Charges 2008 $ 1,603,506 vport Charges Write offs W /O's as % Cottage Grove $ 1,207,326 $ 504,213 41.76% Newport 231,887 134,463 57.99% St. Paul Park 334,487 195,345 58.40% Grey Cloud 2,880 - 0.00% Out of Area 4,420 2,761 62.47% 1,781,000 836,782 46.98% Write off's W /O's as % $ 820,232 51.1 159,269 61.3 204,323 60.E 3,990 1,187, 814 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 $243,000 through this program from 2004 through 2011. This program is proving to be a cost effective way to collect delinquent accounts. Draft Financial Statements 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 2011 budget contained a net operating loss of $83,455 Charges 2009 $ 1,603,506 vport Charges Write off's W /O's as % Cottage Grove $ 1,445,130 $ 712,403 49.30% Newport 255,620 157,317 61.54% St. Paul Park 370,550 233,237 62.94% Grey Cloud 9,290 - 0.00% Out of Area 14,130 3,662 25.92% 2,094,720 1,106,619 52.83% Write off's W /O's as % $ 820,232 51.1 159,269 61.3 204,323 60.E 3,990 1,187, 814 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 $243,000 through this program from 2004 through 2011. This program is proving to be a cost effective way to collect delinquent accounts. Draft Financial Statements 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 2011 budget contained a net operating loss of $83,455 Charges tage Grove $ 1,603,506 vport 259,540 Paul Park 336,820 !y Cloud 22,186 of Area 8,684 2,230,736 Write off's W /O's as % $ 820,232 51.1 159,269 61.3 204,323 60.E 3,990 1,187, 814 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 $243,000 through this program from 2004 through 2011. This program is proving to be a cost effective way to collect delinquent accounts. Draft Financial Statements 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 2011 budget contained a net operating loss of $83,455 compared to an actual net income of $31,082 because call volume was 10% higher than budgeted. Action Requested Adopt the resolution authorizing write -offs in the amount of $1,326,834. j :)[ \ \\ \ \\ )$ /§\ )!!l ; :: , ! ;_a� \ \ >! :, ! ( / / RESOLUTION AUTHORIZING WRITE -OFFS OF THE COTTAGE GROVE EMS ACCOUNTS RECEIVABLE IN THE AMOUNT OF $1,326,834 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,326,834 be written off the Cottage Grove EMS accounts. Passed this 21 ST day of March 2012. Myron Bailey, Mayor Attest: Caron M. Stransky, City Clerk