The URL can be used to link to this page

Home My WebLink About11. 14-62 FEBRUARY 11, 2014 14-62 RESOLUTION (CARRIED __7-0_____ LOST _______ LAID OVER _______ WITHDRAWN _______) PURPOSE: CANCEL OUTSTANDING CHECKS; WRITE OFF DELINQUENT AND UNCOLLECTIBLE ACCOUNTS INITIATED BY: DEPARTMENT OF FINANCE BE IT RESOLVED by the Common Council of the City of Oshkosh that because the checks on the attached list "A" ($3,460.53) have been outstanding for more than twelve months, the proper City officials are hereby authorized to notify Associated Bank of Oshkosh to stop payment on these checks and to credit the proper amounts to the appropriate accounts. BE IT FURTHER RESOLVED that the proper City officials are hereby authorized to write off, for accounting purposes only, the remaining ambulance balance of the 2010 ($565,327.71) accounts, with funds for this purpose appropriated from Account No. 100- 0908-6469-00000, Tax Refund & Bad Debt. BE IT FURTHER RESOLVED that the proper City officials are hereby authorized to write off, for accounting purposes only, the attached general accounts receivable, list "B", with money for this purpose appropriated from Account No. 100-0908-6469-00000 Tax Refund and Bad Debt, ($9,191.47). BE IT FURTHER RESOLVED that the proper city officials are hereby authorized to write off, for accounting purposes only, the attached water, sewer, and storm water utility accounts receivable, lists “C”, “D” and “E”, with money for the purposes appropriated from each Account Number as follows: Acct. No. 541-1890-6469-08903 ($22,728.25), Acct. No. 551-1950-6469-00000 ($20,979.63), and Acct. No. 561-2050-6469-00000 ($5,120.95). City of Oshkosh Finance Department 215 Church Ave.,PO Box 1130 Oshkosh,WI 54903-1130 OIHKQIH (920)236-5006 (920)236-5039 FAX ON THE WATER MEMORANDUM TO: Honorable Mayor and Members of the Common Council FROM: Tara J. Wendt, Assistant Director of Finance DATE: February 11, 2014 RE: Cancel Outstanding Checks/Write-Off Delinquent&Uncollectible Accounts BACKGROUND As part of the year-end process, staff reviews outstanding checks,past due accounts receivables, and bankruptcy accounts; and requests that Council approve the following: o Cancel outstanding accounts payable and payroll checks that were issued more than 1 year ago, and up to 2 years ago, i.e. the request in 2014 is to cancel checks that were issued in 2012, o Adjust our accounting records to reflect the likelihood that we may not collect past due receivables (various purposes, with the main one being ambulance billing), and o Write-off bankruptcies. ANALYSIS This is an annual process that is completed to maintain current and accurate records. The details for each section are as follows: Cancel Outstanding Checks—Per the detailed sheets, this recommendation includes $3,460.53 of combined accounts payable and payroll checks. Please note that it is very possible/likely that a substantial number of these checks have been cashed but did not make it back through the federal banking system to be charged against our accounts. However, I do review the list and make contact with those payees with outstanding check amounts greater than$100, as these are the ones that likely would not have gotten held up in the federal banking system. Also, if, at any time in the future, any of the checks are presented for payment, the City will certainly honor them. Ambulance Billing Write-Off's—This recommendation includes $565,327.71 of receivables from 2010. It is the City's policy to adjust our accounting records to reflect the likelihood that the receivables may not be collectible. This is an accounting entry only and does not relinquish the obligor of the debt as collection efforts are still taking place on these accounts. Delinquent Invoice Write-Off's - This recommendation includes $9,191.47 of receivables from 2010 through 2012. It is the City's policy to adjust our accounting records to reflect the likelihood that these receivables may not be collectible. This is an accounting entry only and does not relinquish the obligor of the debt as collection efforts are still taking place on these accounts. Bankruptcy Write-Of s - This recommendation includes $48,828.83 receivables from 2012. These are amounts that have been discharged through bankruptcy proceedings. Once the Utility is notified of the discharge, by the courts,these amounts are no longer legally collectible; therefore need to be written off. FISCAL IMPACT The `Cancel Outstanding Checks'item increases the City's cash position, while the `Bankruptcy Write- Off's' item reduces the cash position of each of the respective utilities. However,the `Ambulance Billing Write-Offs'item and the `Delinquent Invoice Write-Offs'item do not change operations. Rather, these two items will affect our financial statements in that they lower the accounts receivable amounts stated in those documents. RECOMMENDATION Staff recommends that Council authorize this resolution to execute these transactions as outlined. Respectfully Submitted, Approved: Tara J. Wendt" en Mark Rohloff Assistant Director of Finance City Manager OUTSTANDING CHECK LISTING AS OF DECEMBER 2012 FOR PAYROLL AND PAYABLES-A ASSOCIATED PAYABLES ACCOUNT ACCOUNTS PAYABLE OUTSTANDING CHECKS,FOR 2012,AS OF DECEMBER,2013 Check# Issue Date Payable to Amount Department 170040 1/6/2012 BRYAN DORN $ 5.00 PARKING TICKET REFUND 170043 1/6/2012 MATTHEW DREXLER 2.00 PARKING TICKET REFUND 170058 1/6/2012 TERRY&JUANITA GOODERMUTI- 4.12 TAX OVERPAYMENT REFUND 170069 1/6/2012 TRAVIS HIETPAS 38.00 PARKING TICKET REFUND 170078 1/6/2012 JUSTIN KAUFMAN 2.00 PARKING TICKET REFUND 170081 1/6/2012 WILLIAM KNEPFEL 2.00 PARKING TICKET REFUND 170083 1/6/2012 SHANNA KOEPPEL 2.00 PARKING TICKET REFUND 170108 1/6/2012 ANITA MARKIN 3.00 PARKING TICKET REFUND 170115 1/6/2012 LUKE MOFFITT 10.00 PARKING TICKET REFUND 170117 1/6/2012 WAYNE MORGAN JR. 5.00 PARKING TICKET REFUND 170137 1/6/2012 DEREK REES 0.41 TAX OVERPAYMENT REFUND 170154 1/6/2012 LINCOLN STAMPER 2.00 PARKING TICKET REFUND 170162 1/6/2012 NICHOLAS THOMA 23.00 PARKING TICKET REFUND 170245 1/13/2012 LINDA FAHLEY 0.94 TAX OVERPAYMENT REFUND 170288 1/13/2012 MARC LARGE 3.17 TAX OVERPAYMENT REFUND 170306 1/13/2012 DONNA MUELLER 3.60 TAX OVERPAYMENT REFUND 170324 1/13/2012 ISMAIL DAWOOD RAJAH 5.37 TAX OVERPAYMENT REFUND 170442 1/20/2012 FIFTH THIRD BANK 76.79 TAX OVERPAYMENT REFUND 170494 1/20/2012 ERIN MATZ 2.54 TAX OVERPAYMENT REFUND 170542 1/20/2012 KRISTOPHER SHAFFER 1.65 TAX OVERPAYMENT REFUND 170682 1/27/2012 CHRISTIAN/LORI HANSEN 3.50 TAX OVERPAYMENT REFUND 170748 1/27/2012 JASON VANDYKE 76.79 TAX OVERPAYMENT REFUND 170752 1/27/2012 JENNIFER VERWIEL 1.60 TAX OVERPAYMENT REFUND 170816 2/3/2012 COREY HOFACKER 15.00 PARKING TICKET REFUND 170820 2/3/2012 JUSTIN JOHNSON 0.90 TAX OVERPAYMENT REFUND 170916 2/10/2012 RUSSELL GOBLE 3.73 TAX OVERPAYMENT REFUND 170985 2/10/2012 BRIAN/REBEKAH TISLER 6.35 TAX OVERPAYMENT REFUND 171198 2/23/2012 NICOLE BEHN 0.78 REIMB LIFE INS PREMIUM 171836 3/30/2012 KEVIN CUSHING 2.00 PARKING TICKET REFUND 171918 3/30/2012 RYAN STENSTRUP 3.00 PARKING TICKET REFUND 171927 3/30/2012 KENNETH VANDENBUSH 10.00 PARKING TICKET REFUND 172188 4/20/2012 CYNTHIA BAKER 11.05 TAX OVERPAYMENT REFUND 172577 5/11/2012 MARYCAROLE KEEBLER BAIRD 8.46 WATER FINAL BILL REFUND 172631 5/11/2012 NEW TITLE SERVICES 15.98 WATER FINAL BILL REFUND 172803 5/25/2012 ASSET DEVELOPMENT 2,636.24 REF DUP PMT OF MOBILE HOME FEES 173091 6/1/2012 MAI VANG 18.00 PARKING TICKET REFUND 173795 7/13/2012 THOMAS BIEDINGER 20.00 PARK SHELTER REFUND 174368 8/10/2012 JAMES AUSTAD 30.00 OFD-TRAINING REIMBURSEMENT 174438 8/10/2012 WALLACE OCONNOR 10.58 TAX OVERPAYMENT REFUND 174513 8/17/2012 LOUIS GARNO 2.13 TAX OVERPAYMENT REFUND 174669 8/24/2012 TIM KILLILEA 9.90 WWTP-TRAINING REIMBURSEMENT 174971 9/7/2012 JAKE OLSON 23.00 GARBAGE SPECIAL PICKUP FEE REIMB 175130 9/14/2012 STEWART TITLE OF WI 24.47 WATER FINAL BILL REFUND 175213 9/21/2012 NORTHWEST TITLE AGENCY 110.00 DUP PMT WEED CUTTING CHARGES 176264 11/9/2012 KYLE SWANSON 18.00 PARKING TICKET REFUND 176359 11/16/2012 NEW TITLE SERVICES 35.00 DUP PMT SANITATION SPEC PICKUP FEE 176889 12/14/2012 WINNEBAGO CTY CLERK OF CRT 3.00 FILING FEE Subtotal-Payables $ 3,292.05 ASSOCIATED PAYROLL ACCOUNT PAYROLL ACCOUNT OUTSTANDING CHECKS,FOR 2012, AS OF DECEMBER,2013 Check# Issue Date Payable to Amount Department 601311 11/21/12 CATHERINE MCGINESS 143.19 POLL WORKER 601443 11/21/12 KYLE COWLING 25.29 GOLF COURSE Subtotal-Payroll $ 168.48 2013 Check Cancellations $ 3,460.53 2012 Accounts Receivable to be written off as of December 31, 2013 - B I Invoice Invoice Balance Date to Number Date Name Description Dept. Due Coll Agency Comments 22288 01/24/12 Dominaca Smith Sign Repair 0810 161.00 12/5/2013 No activity 22307 01/27/12 Shawn Huolihan Sign Repair 0810 36.55 12/5/2013 No activity 22577 03/16/12 Eric Lynk Sign Repair 0810 102.19 12/5/2013 No activity 22578 03/16/12 Cameron Riyahi-Mehabadi Sign Repair 0810 102.19 12/5/2013 No activity 22691 04/04/12 Samantha Copus Fire Hydrant Repair 1810 259.86 12/5/2013 No activity 22766 04/17/12 Johnathan Annis Accorn Light Repair 0801 3,778.61 12/5/2013 No activity 23016 05/24/12 Pierce Mathwig Fire Hydrant Repair 1810 788.16 12/5/2013 No activity 23120 06/08/12 Damon Ford Sign Repair 0810 120.46 12/5/2013 No activity 23089 06/08/12 Nation Wide Express Hazmat 0230 239.25 12/5/2013 No activity 23924 08/23/12 Larry Hagen Traffic Signal Repair 0801 844.72 12/5/2013 No activity 23925 08/23/12 Jennifer&Andy Parisi Traffic Signal Repair 0801 1,334.54 12/5/2013 No activity 24033 09/06/12 Gladiator Endurance Racing Paramedic Coverage 0230 276.00 12/5/2013 No activity 24135 09/18/12 Rafael Ortega Jr Traffic Signal Repair 0801 756.22 12/5/2013 No activity 24404 10/16/12 David Strouf Replacement Key 0610 100.00 12/5/2013 No activity 24543 11/05/12 MWM Contracting Bulk Water Usage 1810 155.24 12/5/2013 No activity 24624 11/14/12 Kyle Usinger Sign Repair 0810 101.48 12/5/2013 No activity 28358 12/18/13 Daniel Olk Traffic Signal Repair 0801 35.00 Settlement Balance is admin.fee $9,191.47 Water Delinquent Accounts to be Written off as of December 31, 2013 -C Account Name Address Date Amount Reason 1003-685000.01 CLEMENT GOODACRE JR 1824 DOTY ST 4/17/2012 329.62 BANKRUPTCY 1008-605000.03 JOE LUTZ 407 W 18TH AVE 5/25/2012 283.61 BANKRUPTCY 1031-435000.00 ROBERT PUSKARICH 233 W 14TH AVE 9/14/2012 135.84 BANKRUPTCY 1032-245000.03 PATRICK/ANGELA RAUSCH JR 406 W 15TH AVE 4/17/2012 75.35 BANKRUPTCY 2051-181500.00 VALVOLINE INSTANT OIL 205 W MURDOCK AVE 4/17/2012 43.43 BANKRUPTCY 2067-880000.01 EDWARD WOLLANGK 528 W SMITH AVE 8/21/2012 315.63 BANKRUPTCY 3091-615000.10 GLEN BREEZEE 14 E NEW YORK AVE 3/8/2012 26.96 BANKRUPTCY 3073-030000.03 MARY BAIRD 813 OTTER AVE 4/17/2012 201.07 BANKRUPTCY 3074-360000.01 RONALD MULHOLLON 1229 WAUGOO AVE 4/17/2012 18.69 BANKRUPTCY 3075-615000.00 JOYCE ANDERSON 835 HAZEL ST 11/14/2012 429.99 BANKRUPTCY 3077-295000.03 JESSICA AND J JUSTINGER 1325 WINNEBAGO AVE 11/14/2012 102.11 BANKRUPTCY 3081-140000.05 ROGER LIND 2009 HARRISON ST 8/21/2012 31.52 BANKRUPTCY 3087-360000.13 DAVID SCHOENBERG-LAUER 544 BOWEN ST 8/21/2012 14.32 BANKRUPTCY 3087-620000.01 RON DONNER 732 BOWEN ST 7/5/2012 308.03 BANKRUPTCY 3091-075000.02 RUTHANNE BUHROW 552 GRAND ST 9/5/2012 699.06 BANKRUPTCY 3091-360000.01 DAVID STAMBORSKI 1009 GRAND ST 3/8/2012 345.48 BANKRUPTCY 1015-145000.01 TERRY MOE 1544 PLUMMER ST 3/16/2009 28.60 BANKRUPTCY 2051-150000.03 NICOLE SPENCER 1739 ELMWOOD AVE 5/4/2011 144.26 BANKRUPTCY 2052-449000.00 STACY HARRMANN 2225 PARKSIDE DR 11/9/2011 519.89 BANKRUPTCY 3072-710000.01 DAVID YOUNG 501 OTTER AVE 5/20/2011 340.08 BANKRUPTCY 3084-175000.07 DAVID&RENE YOUNG 118 BROAD ST 5/20/2011 213.36 BANKRUPTCY 3106-320000.02 AMY JONES 965 CUMBERLAND TRL 5/20/2011 331.44 BANKRUPTCY 2060-030000.00 MOKLER PROP, MJ 814 FREDERICK ST 8/15/2011 750.39 BANKRUPTCY 2060-035000.00 MOKLER PROP, MJ 820 FREDERICK ST 8/11/2011 737.45 BANKRUPTCY 2061-235000.08 MOKLER PROPERTIES INC 994 CHERRY ST 8/15/2011 111.54 BANKRUPTCY 3090-985000.04 MOKLER PROPERTIES 417 E LINCOLN AVE 8/11/2011 16.44 BANKRUPTCY 1013-085000.06 MOKLER PROPERTIES 303 W 9TH AVE 8/11/2011 42.38 BANKRUPTCY 2061-220000.12 MOKLER PROPERTIES 988 CHERRY ST 8/11/2011 192.84 BANKRUPTCY 3074-640000.01 MOKLER PROPERTIES 309 WASHINGTON AVE 5/15/2011 1,647.11 BANKRUPTCY 2038-755000.13 MOKLER PROPERTIES 520 HIGH AVE 8/15/2011 4.83 BANKRUPTCY 2047-625000.01 MOKLER PROPERTIES 1649 SHERIDAN ST A 8/15/2011 26.16 BANKRUPTCY 2057-815000.01 MOKLER PROPERTIES INC 751 WOODLAND AVE 8/11/2011 819.14 BANKRUPTCY 3102-330000.00 MOKLER PROPERTIES INC 1761 MARICOPA DR 7/27/2011 1,315.36 BANKRUPTCY 3102-345000.00 MOKLER PROPERTIES INC 1775 MARICOPA DR 7/27/2011 433.72 BANKRUPTCY 3102-350000.00 MOKLER PROPERTIES INC 1777-79 MARICOPA DR 7/27/2011 1,072.66 BANKRUPTCY 3102-360000.00 MOKLER PROPERTIES INC 1781-83 MARICOPA DR 7/27/2011 915.31 BANKRUPTCY 1026-345000.01 MOKLER PROPERTIES INC 908 W 10TH AVE 7/27/2011 287.33 BANKRUPTCY 2047-620000.00 MOKLER PROPERTIES INC 1649 SHERIDAN ST 8/11/2011 41.47 BANKRUPTCY 1001-380000.11 MOKLER PROPERTIES LLC 1875 S MAIN ST 8/11/2011 94.37 BANKRUPTCY 3093-760000.01 MOKLER PROPERTY MGMT 1046 GREENWOOD CT 8/15/2011 1,163.91 BANKRUPTCY 3093-765000.01 MOKLER PROPERTY MGMT 1048 GREENWOOD CT 8/11/2011 978.12 BANKRUPTCY 3093-770000.02 MOKLER PROPERTY MGMT 1065 GREENWOOD CT 8/15/2011 952.27 BANKRUPTCY 3093-775000.02 MOKLER PROPERTY MGMT 1067 GREENWOOD CT 8/11/2011 1,526.88 BANKRUPTCY 3078-830000.01 MOKLER PROPERTY MGT 835 MERRITT AVE 8/15/2011 4,660.23 BANKRUPTCY $22,728.25 Sewer Delinquent Accounts to be Written off as of December 31, 2013 - D Account Name Address Date Amount Reason 1003-685000.01 CLEMENT GOODACRE JR 1824 DOTY ST 4/17/2012 259.30 BANKRUPTCY 1008-605000.03 JOE LUTZ 407 W 18TH AVE 5/25/2012 221.32 BANKRUPTCY 1031-435000.00 ROBERT PUSKARICH 233 W 14TH AVE 9/14/2012 104.98 BANKRUPTCY 1032-245000.03 PATRICK/ANGELA RAUSCH JR 406 W 15TH AVE 4/17/2012 66.60 BANKRUPTCY 2051-181500.00 VALVOLINE INSTANT OIL 205 W MURDOCK AVE 4/17/2012 40.75 BANKRUPTCY 2067-880000.01 EDWARD WOLLANGK 528 W SMITH AVE 8/21/2012 247.23 BANKRUPTCY 3091-615000.10 GLEN BREEZEE 14 E NEW YORK AVE 3/8/2012 19.62 BANKRUPTCY 3073-030000.03 MARY BAIRD 813 OTTER AVE 4/17/2012 140.03 BANKRUPTCY 3074-360000.01 RONALD MULHOLLON 1229 WAUGOO AVE 4/17/2012 15.25 BANKRUPTCY 3075-615000.00 JOYCE ANDERSON 835 HAZEL ST 11/14/2012 339.34 BANKRUPTCY 3077-295000.03 JESSICA AND J JUSTINGER 1325 WINNEBAGO AVE 11/14/2012 81.26 BANKRUPTCY 3081-140000.05 ROGER LIND 2009 HARRISON ST 8/21/2012 25.04 BANKRUPTCY 3087-360000.13 DAVID SCHOENBERG-LAUER 544 BOWEN ST 8/21/2012 10.83 BANKRUPTCY 3087-620000.01 RON DONNER 732 BOWEN ST 7/5/2012 238.41 BANKRUPTCY 3091-075000.02 RUTHANNE BUHROW 552 GRAND ST 9/5/2012 558.10 BANKRUPTCY 3091-360000.01 DAVID STAMBORSKI 1009 GRAND ST 3/8/2012 215.00 BANKRUPTCY 1015-145000.01 TERRY MOE 1544 PLUMMER ST 3/16/2009 22.13 BANKRUPTCY 2051-150000.03 NICOLE SPENCER 1739 ELMWOOD AVE 5/4/2011 113.74 BANKRUPTCY 2052-449000.00 STACY HARRMANN 2225 PARKSIDE DR 11/9/2011 400.87 BANKRUPTCY 3072-710000.01 DAVID YOUNG 501 OTTER AVE 5/20/2011 294.62 BANKRUPTCY 3084-175000.07 DAVID& RENE YOUNG 118 BROAD ST 5/20/2011 171.55 BANKRUPTCY 3106-320000.02 AMY JONES 965 CUMBERLAND TRL 5/20/2011 289.42 BANKRUPTCY 2060-030000.00 MOKLER PROP, MJ 814 FREDERICK ST 8/15/2011 984.41 BANKRUPTCY 2060-035000.00 MOKLER PROP, MJ 820 FREDERICK ST 8/11/2011 1068.94 BANKRUPTCY 2061-235000.08 MOKLER PROPERTIES INC 994 CHERRY ST 8/15/2011 99.86 BANKRUPTCY 3090-985000.04 MOKLER PROPERTIES 417 E LINCOLN AVE 8/11/2011 12.45 BANKRUPTCY 1013-085000.06 MOKLER PROPERTIES 303 W 9TH AVE 8/11/2011 43.22 BANKRUPTCY 2061-220000.12 MOKLER PROPERTIES 988 CHERRY ST 8/11/2011 167.33 BANKRUPTCY 3074-640000.01 MOKLER PROPERTIES 309 WASHINGTON AVE 8/15/2011 1570.40 BANKRUPTCY 2038-755000.13 MOKLER PROPERTIES 520 HIGH AVE 8/15/2011 3.56 BANKRUPTCY 2047-625000.01 MOKLER PROPERTIES 1649 SHERIDAN ST A 8/15/2011 52.44 BANKRUPTCY 2057-815000.01 MOKLER PROPERTIES INC 751 WOODLAND AVE 8/11/2011 644.91 BANKRUPTCY 3102-330000.00 MOKLER PROPERTIES INC 1761 MARICOPA DR 7/27/2011 1392.70 BANKRUPTCY 3102-345000.00 MOKLER PROPERTIES INC 1775 MARICOPA DR 7/27/2011 271.34 BANKRUPTCY 3102-350000.00 MOKLER PROPERTIES INC 1777-79 MARICOPA DR 7/27/2011 1213.38 BANKRUPTCY 3102-360000.00 MOKLER PROPERTIES INC 1781-83 MARICOPA DR 7/27/2011 1091.18 BANKRUPTCY 1026-345000.01 MOKLER PROPERTIES INC 908 W 10TH AVE 7/27/2011 285.47 BANKRUPTCY 2047-620000.00 MOKLER PROPERTIES INC 1649 SHERIDAN ST 8/11/2011 42.70 BANKRUPTCY 1001-380000.11 MOKLER PROPERTIES LLC 1875 S MAIN ST 8/11/2011 74.01 BANKRUPTCY 3093-760000.01 MOKLER PROPERTY MGMT 1046 GREENWOOD CT 8/15/2011 1403.55 BANKRUPTCY 3093-765000.01 MOKLER PROPERTY MGMT 1048 GREENWOOD CT 8/11/2011 877.36 BANKRUPTCY 3093-770000.02 MOKLER PROPERTY MGMT 1065 GREENWOOD CT 8/15/2011 573.51 BANKRUPTCY 3093-775000.02 MOKLER PROPERTY MGMT 1067 GREENWOOD CT 8/11/2011 1352.86 BANKRUPTCY 3078-830000.01 MOKLER PROPERTY MGT 835 MERRITT AVE 8/15/2011 3878.66 BANKRUPTCY $20,979.63 • Storm Water Delinquent Accounts to be Written off as of December 31, 2013 - E Account Name i Address Date Amount Reason 1003-685000.01 CLEMENT GOODACRE JR .1824 DOTY ST 4/17/2012 58.27 BANKRUPTCY 1008-605000.03 JOE LUTZ 407 W 18TH AVE 5/25/2012 65.74 BANKRUPTCY 1031-435000.00 ROBERT PUSKARICH 233 W 14TH AVE 9/14/2012 48.60 BANKRUPTCY 1032-245000.03 PATRICK/ANGELA RAUSCH JR 406 W 15TH AVE 4/17/2012 28.62 BANKRUPTCY 1500-000945.00 ITT CONTINENTAL BAKING MONTANA ST 2/3/2012 30.29 BANKRUPTCY 2051-181500.00 VALVOLINE INSTANT OIL 205 W MURDOCK AVE 4/17/2012 158.37 BANKRUPTCY 2067-880000.01 EDWARD WOLLANGK 528 W SMITH AVE 8/21/2012 45.41 BANKRUPTCY 3091-615000.10 GLEN BREEZES 14 E NEW YORK AVE 3/8/2012 17.10 BANKRUPTCY 3073-030000.03 MARY BAIRD 813 OTTER AVE 4/17/2012 61.54 BANKRUPTCY 3074-360000.01 RONALD MULHOLLON 1229 WAUGOO AVE 4/17/2012 4.49 BANKRUPTCY 3075-615000.00 JOYCE ANDERSON 835 HAZEL ST 11/14/2012 121.87 BANKRUPTCY 3077-295000.03 JESSICA AND J JUSTINGER 1325 WINNEBAGO AVE 11/14/2012 73.25 BANKRUPTCY 3081-140000.05 ROGER LIND 2009 HARRISON ST _ 8/21/2012 6.71 BANKRUPTCY 3087-360000.13 DAVID SCHOENBERG-LAUER 544 BOWEN ST _ 8/21/2012 11.43 BANKRUPTCY 3087-620000.01 RON DONNER 732 BOWEN ST 7/5/2012 80.26 BANKRUPTCY 3091-075000.02 RUTHANNE BUHROW 552 GRAND ST 9/5/2012 92.49 BANKRUPTCY 3091-360000.01 DAVID STAMBORSKI 1009 GRAND ST 3/8/2012 113.24 BANKRUPTCY 1015-145000.01 TERRY MOE 1544 PLUMMER ST 3/16/2009 8.59 BANKRUPTCY 2051-150000.03 NICOLE SPENCER 1739 ELMWOOD AVE 5/4/2011 67.10 BANKRUPTCY 2052-449000.00 STACY HARRMANN 2225 PARKSIDE DR 11/9/2011 157.85 BANKRUPTCY 3072-710000.01 DAVID YOUNG 501 OTTER AVE 5/20/2011 42.24 BANKRUPTCY 3084-175000.07 DAVID&RENE YOUNG 118 BROAD ST 5/20/2011 55.36 BANKRUPTCY 3106-320000.02 AMY JONES 965 CUMBERLAND TRL 5/20/2011 46.29 BANKRUPTCY 2060-030000.00 MOKLER PROP, MJ 814 FREDERICK ST 8/15/2011 136.78 BANKRUPTCY 2060-035000.00 MOKLER PROP, MJ 820 FREDERICK ST 8/11/2011 136.78 BANKRUPTCY 2061-235000.08 MOKLER PROPERTIES INC 994 CHERRY ST 8/15/2011 22.97 BANKRUPTCY 3090-985000.04 MOKLER PROPERTIES 417 E LINCOLN AVE 8/11/2011 9.48 BANKRUPTCY 1013-085000.06 MOKLER PROPERTIES 303 W 9TH AVE 8/11/2011 18.88 BANKRUPTCY 2061-220000.12 MOKLER PROPERTIES 988 CHERRY ST 8/11/2011 23.20 BANKRUPTCY 3074-640000.01 MOKLER PROPERTIES 309 WASHINGTON AVE 8/15/2011 391.68 BANKRUPTCY 2038-755000.13 MOKLER PROPERTIES 520 HIGH AVE 8/15/2011 3.49 BANKRUPTCY 2047-625000.01 MOKLER PROPERTIES 1649 SHERIDAN ST A 8/15/2011 45.66 BANKRUPTCY 2057-815000.01 MOKLER PROPERTIES INC 751 WOODLAND AVE 8/11/2011 84.77 BANKRUPTCY 3102-330000.00 MOKLER PROPERTIES INC 1761 MARICOPA DR 7/27/2011 898.54 BANKRUPTCY 3102-360000.00 MOKLER PROPERTIES INC 1781-83 MARICOPA DR 7/27/2011 262.49 BANKRUPTCY 1026-345000.01 MOKLER PROPERTIES INC 908 W 10TH AVE 7/27/2011 84.82 BANKRUPTCY 2047-620000.00 MOKLER PROPERTIES INC 1649 SHERIDAN ST 8/11/2011 26.08 BANKRUPTCY 3502-000750.00 MOKLER PROPERTIES INC 417 E NEVADA AVE 7/27/2011 348.54 BANKRUPTCY 1001-380000.11 MOKLER PROPERTIES LLC 1875 S MAIN ST 8/11/2011 12.49 BANKRUPTCY 2501-000545.00 MOKLER PROPERTIES LLC FREDERICK ST 8/11/2011 24.30 BANKRUPTCY 3093-760000.01 MOKLER PROPERTY MGMT 1046 GREENWOOD CT 8/15/2011 143.43 BANKRUPTCY 3093-765000.01 MOKLER PROPERTY MGMT 1048 GREENWOOD CT 8/11/2011 147.37 BANKRUPTCY 3093-770000.02 MOKLER PROPERTY MGMT 1065 GREENWOOD CT 8/15/2011 158.68 BANKRUPTCY 3093-775000.02 MOKLER PROPERTY MGMT 1067 GREENWOOD CT 8/11/2011 158.68 BANKRUPTCY 3078-830000.01 MOKLER PROPERTY MGT 835 MERRITT AVE 8/15/2011 586.73 BANKRUPTCY $5,120.95 Res 14-62 TO: Honorable Mayor and Members of the Common Council FROM: Tim Franz, Fire Chief DATE: February 11, 2014 RE: Questions Regarding Ambulance Billing and Collections This memo is in response to several questions posed by the Mayor and Deputy Mayor regarding ambulance billing and collection. The following questions have been summarized as follows: 1. Do we have statistics on the trend for these delinquencies? 2. Are delinquencies trending up or down? 3. Can we determine if the new collection contract has improved collections? 4. Are there any other factors contributing to delinquencies? In regard to the first question, I have attached summaries of ambulance billing and collections of which our responses are based from the years 2011 through 2013. Before making any direct comparisons to SGS there are several caveats that I need to present. First of all, the data is presented and sorted in a different format than our previous provider. Secondly and a very significant factor, is the rate increases that went into effect over this time period that we will also present. The write off s being considered by the council this evening are from the 2010 billing year, which was actually our last year with our previous billing provider SGS. This amount being considered for write off is $565,327.71. Although this amount is being written off for accounting purposes this year, some of the accounts making up this amount are still being pursued by our current billing provider Lifequest and may still be collected on in the future. We have yet to reach a milestone date to write off any bills handled by Lifequest our current provider, however looking at their reports, the closest comparative number would be the amount found on the revenue summary sheets on Phase 3 charges. Phase 3 charges are bills over 180 days that have not received any account activity and are in the collections stage. In making a comparison using 2013 phase 3 numbers, Lifequest is actually slightly higher in 2013 at $575,939.71 vs. $565,327.71 which is $10,612.00 more less or a 1.9% increase over SGS final year of billing. This shows us that Lifequest is actually performing better on Phase 1 and 2 of collections as the number going to this Phase is only 1.9%higher while the call volume increased 13.7% from 2010 -2013 and the rates or charges increased 17.75%. So with this comparison, adjusting for call volume increase as well as a rate increase, the percentage of bills going into the collection or"delinquent"phase" is lower with Lifequest. This would indicate Lifequest is performing better on the initial stages of billing and collections. I believe these numbers also answer question three as well. On a final note regarding this question, just because a bill has reached phase 3 does not mean that it has reached the stage of write off. Lifequest will continue to pursue these bills and has and we have seen significant progress in this area. The most significant is Lifequest use of the Tax Refund Intercept Program or"TRIP". In 2012 which would have been their first year of dealing with bills in the phase 3 or the collection phase they received $4,785.29 from TRIP, in 2013 this number jumped to $50,432.19. This is just their collection activity from this program on bills in Phase 3. I should also point out that when you look at the summary sheet titled"Collection Rates" you will see the grand total of collections is a number greater than 100%. This is because the bills in collections or phase 3 are not accounted for in charges, but added to collections for the year which lead to this positive number and indicates to us their pursuit of delinquent or phase 3 bills. In regard to the second question,just comparing Lifequest data for 2102 to 2013 it would appear that bills going to the collections or phase 3 are up 23.5% or $109,638.00 so this may be the start of an upward trend. This leads to the final question of other factors affecting this trend. As pointed out earlier, some of this though may be attributed to the rate increase that took effect for the full year of 2012 and increases in call volume. However there are other trends that we believe are affecting this which can be seen on the report titled"Payor Mix". Over the last three years we have seen a drop in patients with health insurance, 12.83% in 2011 to 10.71% in 2013. We believe along with Lifequest that job loss and or employers dropping this benefit are at the root cause of this trend. This has lead to patients in the private pay category going from 40.19% in 2011 to 42.54% in 2013. Those in the private pay category are most likely to fall into the delinquent or collections phase. In summary adjusting for increases in rates and call volume, and"payor mix", Lifequest has shown to be performing at a higher level. In addition they are providing us greater details of their performance in collections with different payor groups and phases so that we can more closely monitor developing trends such as those discussed. CITY OF OSHKOSH FIRE DEPT Executive Summary Worksheet January 1,2011 to December 31,2011 Revenue Summary 2011 Month Charges Gross Rev. Service Rev. LifeQuest Rev. LifeQuest% January'11 $0.00 $0.00 $0.00 $0.00 0.00% February'11 $132,227.12 $0.00 $0.00 $0.00 0.00% March'11 $544,637.07 $46,132.75 $43,600.06 $2,532.69 5.49% April'11 $266,091.68 $151,890.92 $143,552.11 $8,338.81 5.49% May'11 $270,518.59 $155,368.13 $146,838.42 $8,529.71 5.49% June'11 $332,503.64 $142,509.49 $134,685.72 $7,823.77 5.49% July'11 $421,286.06 $129,282.30 $122,184.70 $7,097.60 5.49% August'11 $364,587.25 $186,751.37 $176,195.53 $10,555.84 5.65% September'11 $310,603.53 $192,777.09 $181,218.45 $11,558.64 6.00% October'11 $252,249.99 $147,165.66 $138,741.32 $8,424.34 5.72% November'11 $288,459.60 $192,163.53 $180,754.47 $11,409.06 5.94% December'11 $248,327.82 $178,955.20 $168,201.72 $10,753.48 6.01% 2011 Total $3,431,492.35 $1,522,996.44 $1,435,972,50 $87,023.94 5.71% Grand Totals $3,431,492.36 $1,522,998.44 $1,435,972.50 $87,023.94 5.71% Revenue By Phase Summary 2011 Gross Service LifeQuest Phase Charges Revenue Revenue Revenue Phase 1 $2,892,473.55 $1,433,634.44 $1,354,927.91 $78,706.53 Phase 2 $333,546.79 $74,206.81 $70,132.86 $4,073.95 Phase 3 $205,472.01 $15,155.19 $10,911.73 $4,243.46 2011 Total $3,431,492.35 $1,522,998.44 $1,435,972.50 $87,023.94 Revenue Collected By Phase Summary Gross Collected Service LifeQuest Phase Charges Revenue Percentage Revenue Revenue Phase 1 1% ; , $2,892,473.55 $1,433,634.44 '' 94.13% $1,354,927.91 $78,706.53 Phase 2 $333,546.79 $74,206.81 4.87% $70,132.86 $4,073.95 Phase 3 $205,472.01 $15,155.19 1.00% $10,911.73 $4,243.46 Grand Totals $3,431,492.36 $1,522,986.44 100.00% $1,435,972.60 $87,023.94 Printed: 12/10/2013 at 5:08:18PM Page 1 of 5 CITY OF OSHKOSH FIRE DEPT Executive Summary Worksheet January 1,2011 to December 31,2011 Collection Rates 2011 Cash Adjustments GrouplPayor Type Charges Credits Rate 1 Mandatory Rate 2 Adjustments Rate 3 Commercial Insurance $662,262.57 $412,490.57 62.29% $7,198.92 62.97% $122,931.91 80.85% Workers Compensation $31.844.07 $18,497.96 58.09% $1,060.31 60.09% $5,957.47 76.80% Commercial Total $694,108.84 $430,988.53 62.09% $8,259.23 62.84% $128,889.38 80.66% Medicaid Medicaid $307,864.82 $65,684.80 21.34% $120,510.83 35.06% $186,031.79 81.76% Medicaid Total $307,864.82 $88,884.80 21.34% $120,510.83 35.06% $186,031.79 81.76% Medicare Medicare $1,581,583.06 $694,034.16 43.88% $494,482.59 63.84% $622,417.85 83.24% Medicare Total $1,581,583.06 $694,034.18 43.88% $494,482.59 63.84% $622,417.85 83.24% Other Other $113,641.77 $24,537.92 21.59% $6,596.52 22.92% $16,031.92 35.70% Other Total $113,641.77 $24,637.92 21.59% $6,598.52 22,92% $18,031.92 35.70% Private Attorneys $2,257.85 $431.00 19.09% $0.00 19.09% $1,826.85 100.00% Collections $1,212.20 $89,004.72 7342.41% $30,217.84 -306.85% $30,217.84 9835.22% Contract-Hospital,Intercept $13,767.59 $2,957.62 21.48% $333.25 22.02% $10,210.06 95.64% Private $709,354.33 $215,000.41 30.31% $74,070.39 33.84% $370,522.64 82.54% Private Total 5726,691.97 $307,393.75 42.31% $104,821.48 49.42% $412,777.39 99.12% 2011 Total $3,423,788.28 $1,522,839.16 44.47% $734,470.65 66.82% $1,366,148.33 84.37% Grand Totals 53,423,788.28 $1,522,839.16 44.47% $734,470.65 56.82% $1,388,148.33 84.37% Rate 1=(Cash Credits/Charges)x 100 Rate 2=((Cash Credits)/(Charges•Adjustments Mandatory))x 100 Rate 3 =((Cash Credits+Adjustments)/(Charges))x 100 Printed: 12/10/2013 at 5:08:18PM Page 3 of 5 CITY OF OSHKOSH FIRE DEPT Executive Summary Worksheet January 1,2011 to December 31,2011 Payor Mix - 2011 Group/Category Calls Percentage Commercial Insurance 922 12.83% Workers Compensation 51 0.72% Commercial Total 973 13.56% Medicaid Medicaid 516 7.19% Medicaid Total 616 7.19% Medicare Medicare 2,604 36.28% Medicare Total 2,604 36.28% Other Other 175 2.42% Other Total 176 2.42% Private Attorneys 3 0.04% Contract-Hospital,intercept 22 0.30% Private 2,885 40.19% Private Total 2,910 40.53% 2011 Totals 7,178 99.97% Grand Totals 7,178 100.00% Printed: 12/10/2013 at 5:08:18PM Page 4 of 5 CITY OF OSHKOSH FIRE DEPT Executive Summary Worksheet January 1,2012 to December 31,2012 Revenue Summary 2012 Month Charges Gross Rev. Service Rev. LifeQuest Rev. LlfeQuest% January'i2 $246,800.12 $153,159.08 $143,762.23 $9,396.85 6.14% February'12 $305,185.03 $165,564.05 $155,047.28 $10,516.77 6.35% March'12 $339,856.70 $152,410.82 $141,914.11 $10,496.71 6.89% April'12 $181,903.51 $184,207.26 $172,935.12 $11,272.14 6.12% May'12 $244,767.75 $168,546.68 $158,147.14 $10,399.54 6.17% June'12 $316,466.28 $156,720.26 $146,384.29 $10,335.97 6.60% July'12 $363,740.05 $141,540.04 $132,143.88 $9,396.16 6.64% August'12 $220,448.01 $183,387.65 $171,934.85 $11,452.80 6.25% September'12 $321,702.42 $135,830.60 $127,919.26 $7,911.34 5.82% October'12 $206,638.55 $208,386.71 $195,595.20 $12,791.51 6.14% November'12 $365,392.10 $134,761.68 $125,856.38 $8,905.30 6.61% December'12 $291,446.02 $172,464.23 $161,389.42 $11,074.81 6.42% 2012 Total $3,404,346.64 $1,956,979.06 $1,833,029.18 $123,949.90 6.33% Grand Totals $3,404,346.54 $1,958,979.06 $1,833,029.16 $123,949.90 6.33% Revenue By Phase Summary 2012 Gross Service LifeQuest Phase Charges Revenue Revenue Revenue Phase 1 $2,790,826.62 $1,784,186.90 $1,686,235.03 $97,951.87 Phase 2 $147,218.65 $99,439.15 $93,979.95 $5,459.20 Phase 3 $466,301.27 $73,353.01 $52,814.18 $20,538.83 2012 Total $3,404,346.54 $1,958,979.06 $1,833,029.16 $123,949.90 Revenue Collected By Phase Summary Gross Collected Service LifeQuest Phase Charges Revenue Percentage Revenue Revenue Phase 1 $2,790,826.62 $1,784,186.90 91.17% $1,686,235.03 $97,951.87 Phase 2 $147,218.65 $99,439.15 5.08% $93,979.95 $5,459.20 Phase 3 $466,301.27 $73,353.01 3.75% $52,814.18 $20,538.83 Grand Totals $3,404,346.54 81,966,979.06 100.00% $1,833,029.16 8123,849.90 Printed:2/11/2014 at 6:09:50AM Page 1 of 5 CITY OF OSHKOSH FIRE DEPT Executive Summary Worksheet January 1,2012 to December 31,2012 Collection Rates 201.2 Cash Adjustments GrouplPayor Type Charges Credits Rate 1 Mandatory Rate 2 Adjustments Rate 3 Commercial Insurance $712,453.76 $534,669.89 75.05% $19,648.39 77.17% $156,248.73 96.98% Workers Compensation $40,884.79 $34,089.16 83.38% $746.79 84.93% $7,374.70 101.42% Commercial Total $763,338.65 $668,769.06 75.50% $20,395.18 77.60% $163,623.43 97.22% Medicaid Medicaid $380,490.47 $99,864.38 26.25% $180,529.03 49.94% $268,868.21 96.91% Medicaid Total $380,490.47 $99,864.38 26.25% $180,529.03 49.94% $268,868.21 96.91% Medicare Medicare $1,865,042.32 $998,362.36 53.53% $678,819.14 84.16% $833,523,16 98.22% Medicare Total $1,866,042.32 $998,362.36 53.53% $678,819.14 84.16% $833,623.16 98.22% Other Other $5,573.36 $1,100.81 19.75% $3,287.27 48.15% $77,778.63 1415.29% Other Total $6,673.36 $1,100.81 19.75% $3,287.27 48.15% $77,778.831,415.29% Private Attorneys $5,548.65 $3,202.43 57.72% $0.00 57.72% $1,134.56 78.16% Collections $4,744.46 $171,216.94 3608.78% $35,118.19 -563.70% $35,118.19 4348.97% Contract-Hospital,intercept $23,577.83 $6,930.92 29.40% $5,075.06 37.46% $9,844.77 71.15% Private $432,800.59 $105,966.95 24.48% $26,942.86 26.11% $335,852.25 102.08% Private Total $466,671.53 $287,317.24 61.57% $67,136.11 71.91% $381,949.77 143.41% 2012 Total $3,471,116.23 $1,956,403.84 66.33% $960,166.73 77.67% $1,726,743.20 106.06% Grand Totals $3,471,116.23 $1,865,403.84 66.33% $960,166.73 77.67% $1,726,743.20 106.06% Rate 1=(Cash Credits/Charges)x 100 Rate 2=((Cash Creditsjl(Charges-Adjustments Mandatory))x 100 Rate 3 =((Cash Credits+Adjustments)l(Charges))x 100 Printed:2/11/2014 at 6:09:50AM Page 3 of 5 CITY OF OSHKOSH FIRE DEPT Executive Summary Worksheet January 1, 2012 to December 31,2012 PayorMix 2012 Group/Category Calls Percentage Commercial Insurance 959 13.14% Workers Compensation 56 0.76% Commercial Total 1,016 13.90% Medicaid Medicaid 590 8.09% Medicaid Total 690 8.09% Medicare Medicare 2,857 39.08% Medicare Total 2,857 39.08% Other Other 316 4.34% Other Total 316 4.34% Private Attorneys 7 0.08% Contract-Hospital,intercept 32 0.42% Private 2,489 34.07% Private Total 2,628 34.67% 2012 Totals 7,308 99.98% Grand Totals 7,306 100.00% Printed:2/11/2014 at 6:09:50AM Page 4 of 5 CITY OF OSHKOSH FIRE DEPT Executive Summary Worksheet January 1,2013 to December 31,2013 Revenue Summary 2013. Month Charges Gross Rev. Service Rev. LifeQuest Rev. LifeQuest% January'13 $319,985.31 $197,389.84 $184,579.43 $12,810.41 6.49% February'13 $338,220.00 $181,075.56 $165,520.07 $15,555.49 8.59% March'13 $298,564.92 $170,377.10 $157,880.34 $12,496.76 7.33% April'13 $304,638.14 $175,645.41 $162,909.10 $12,736.31 7.25% May'13 $275,582.03 $130,967.55 $123,141.37 $7,826.18 5.98% June'13 $346,890.56 $155,720.76 $146,340.95 $9,379.81 6.02% July'13 $385,117.93 $171,272.50 $161,113.39 $10,159.11 5.93% August'13 $415,388.18 $169,830.75 $159,398.94 $10,431.81 6.14% September'13 $262,757.82 $142,914.54 $133,048.97 $9,865.57 6.90% October'13 $397,408.44 $191,222.62 $178,845.22 $12,377.40 6.47% November'13 $235,086.09 $138,380.65 $129,039.94 $9,340.71 6.75% December'13 $364,771.62 $157,826.81 $147,953.77 $9,873.04 6.26% 2013 Total $3,944,411.04 $1,982,624.09 $1,849,771.49 $132,882.80 6.70% Grand Totals $3,944,411.04 $1,982,624.09 $1,849,771.49 $132,852.60 6.70% Revenue By Phase Summary 2013 Gross Service LifeQuest Phase Charges Revenue Revenue Revenue Phase 1 $3,227,671.44 $1,791,531.43 $1,693,176.36 $98,355.07 Phase 2 $140,799.89 $84,444.33 $79,808.33 $4,636.00 Phase 3 $575,939.71 $106,648.33 $76,786.80 $29,861.53 2013 Total $3,944,411.04 $1,982,624.09 $1,849,771.49 $132,862.60 Revenue Collected By Phase Summary Gross Collected Service LifeQuest Phase Charges Revenue Percentage Revenue Revenue Phase 1 $3,227,671.44 $1,791,531.43 90.36% $1,693,176.36 $98,355.07 Phase 2 $140,799.89 $84,444.33 4.26% $79,808.33 $4,636.00 Phase 3 $575,939.71 $106,648.33 5.38% $76,786.80 $29,861.53 Grand Totals $3,944,411.04 $1,982,624.09 100.00% $1,849,771.49 $132,852.60 Printed:2/11/2014 at 5:57:43AM Page 1 of 5 CITY OF OSHKOSH FIRE DEPT Executive Summary Worksheet January 1,2013 to December 31,2013 Collection Rates 2013 Cash Adjustments OrouplPayor Type Charges Credits Rate.' Mandatory Rate 2 Adjustments Rate 3 Commercial Insurance $713,772.83 $565,151.16 79.18% $19,657.84 81.42% $147,974.42 99.91% Workers Compensation $28,194.96 $27,448.90 97.35% $281.94 98.34% $2,177.75 105.08% Commercial Total $741,987.79 $692,600.06 79.87% $19,939.78 82.07% $160,162.17 100.11% Medicaid Medicaid $450,309.88 $103,917.80 23.08% $243,246.80 50.19% $344,496.83 99.58% Medicaid Total $460,309.88 $103,917.80 23.08% $243,246.80 50.19% $344,496.83 99.58% Medicare Medicare $2,212,071.64 $1,018,422.26 46,04% $990,124.12 83.34% $1,173,713.25 99.10% Medicare Total $2,212,071.64 $1,018,422.26 46.04% $990,124.12 83.34% $1,173,713.26 99.10% Other Other $1,819.77 $(364,91) -20.05% $6.04 -20.12% $146.03 -12.03% Other Total $1,819.77 $-364.91 -20.05% $6.04 -20.12% $146.03 -12.03% Private Attorneys $0.00 $1,211.66 0.00% $0.00 0.00% $0.00 0.00% Collections $8,266.93 $191,092.66 2311.53% $47,655.00 -485.15% $47,655.00 2887.98% Contract-Hospital,Intercept $34,095.77 $15,063.92 44.18% $7,002.31 55.60% $18,418.93 98.20% Private $492,239.60 $60,680.64 12.33% $10,913.60 12.61% $406,951.01 95.00% Private Total $634,602.30 $268,048.88 50.14% $65,570.91 57.15% $473,024.94 138.62% 2013 Total $3,940,771.38 $1,982,624.09 50.31% $1,318,887.65 75.62% $2,141,533.22 104.66% Grand Totals $3,940,771.38 $1,982,624.09 60.31% $1,318,887.66 76.62% $2,141,633.22 104.66% Rate 1=(Cash CreditslCharges)x 100 Rate 2=((Cash Credits)1(Charges-Adjustments Mandatory))x 100 Rate 3 =((Cash Credits+Adjustments)/(Charges))x 100 Printed:2/11/2014 at 5:57:43AM Page 3 of 5 CITY OF OSHKOSH FIRE DEPT Executive Summary Worksheet January 1,2013 to December 31,2013 Payor Mix 2013 Group/Category Calls Percentage Commercial Insurance 787 10.71% Workers Compensation 39 0.52% Commercial Total 826 11.23% Medicaid Medicaid 585 7.97% Medicaid Total 586 7.97% Medicare Medicare 2,764 37.60% Medicare Total 2,764 37.60% Other Other 4 0.04% Other Total 4 0.04% Private Attorneys 0 0.00% Contract-Hospital, Intercept 44 0.59% Private 3,127 42.54% Private Total 3,171 43.13% 2013 Totals 7,360 99.97% Grand Totals 7,350 100.00% Printed:2/11/2014 at 5:57:43AM Page 4 of 5