Spreadsheet: 141891d1329499665-sumifs-formula-error-central-division-termination-tracker-21712
Sheet: Lost Beds 2012

[NAME] | RSA | Pharmacy | Facility | Bed  Count | Bed  Type | Confirmed/  Potential | On Forecast Report | If not on Forecast, date added | Projected Term Date | Projected  Term Date | Current At Risk Ranking | Annual Revenue | Monthly  Revenue | Date Unit Notified | Date Retention notified | How Retention notified | Type of Term Notice | Date LAIF  Received | Date LAIF approved RVP | Date LAIF approved Kitty | Date LAIF approved M.Arnold | Date LAIF Sent to [NAME] | *Reason for Termination | Valid  Termination | New Pharmacy  Provider | Last Deep Dive Date | Avg Score Last Survey | Date of last survey | Date of last ER | Lost or Saved | COMMENTS
Meyer | KY | Beeber Pharmacy | Autumn Years | 50 | SNF | Confirmed | Yes | n/a | 2012-04-14 00:00:00 |  | A2 | 153507 |  | 2011-12-15 00:00:00 | 2011-12-15 00:00:00 | Bi-weekly call | Written | 2011-12-16 00:00:00 | 2011-12-19 00:00:00 | 2011-12-19 00:00:00 | 2011-12-19 00:00:00 | 2011-12-20 00:00:00 | Other | Yes | Skilled Care | n/a | 3 | 2011-03-11 00:00:00 | 2011-10-01 00:00:00 | Lost | Owner desires all 5 facilities to be serviced by one pharmacy. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Inman | KY | Beeber Pharmacy |  |  |  | ALF | Confirmed | A1 | Call to Kitty |  | Yes | Closed |  |  | Closed
Meyer | KY | Beeber Pharmacy | Eaglewood - SNF | 113 | SNF | Potential | Yes | n/a | 2012-03-01 00:00:00 |  | [NAME] | 852023 |  |  | 2011-11-28 00:00:00 | Bi-weekly call |  |  |  |  |  |  |  |  |  | 2011-11-08 00:00:00 | 3.7 | 2011-08-26 00:00:00 | 2011-11-29 00:00:00 |  | Facility sold to ADCare, contract is assignable but ADCare has a relationship with [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Meyer | TN | D&R Pharmacare |  |  |  | HOSPICE | Potential | A1c | Email from unit |  | No | Collections/AR |  |  | Collections/AR
Meyer | KY | Beeber Pharmacy | Eaglewood - ALF | 80 | ALF | Potential | Yes | n/a | 2012-03-01 00:00:00 |  | [NAME] | 135911 |  |  | 2011-11-28 00:00:00 | Bi-weekly call |  |  |  |  |  |  |  |  |  | 2011-11-08 00:00:00 | 3.7 | 2011-08-26 00:00:00 | 2011-11-29 00:00:00 |  | Facility sold to ADCare, contract is assignable but ADCare has a relationship with [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WV | Denman Pharmacy |  |  |  | HOSPITAL |  | A2 | Forecast Call |  |  | J/V In-House Pharmacy |  |  | J/V In-House Pharmacy
Meyer | KY | D&R Pharmacare | The Neighborhood | 12 | SNF | Confirmed | Yes | n/a | 2012-01-01 00:00:00 |  | C2c | 2600 |  | 2012-01-12 00:00:00 | 2012-01-19 00:00:00 | Call to Kitty | Verbal |  |  |  |  |  | Other |  | [NAME] | 2012-01-16 00:00:00 | n/a | n/a | n/a |  | Local Rx that supplies oral meds not has ability to do infusion.  [NAME], DON, commented that families want to give local a try.  DON confirmed there were no service issues.  [NAME] has meeting with Five Star early in Feb.regarding contract renewals that are up in April 2012.  Contract may go out to bid nationally.  If new contract is signed, this facility will just drop off at that time since official term letter hasn't been received. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | St. Louis | Home Care Pharmacy |  |  |  | ICF |  | [NAME] | Bi-weekly call |  |  | National Accounts |  |  | National Accounts
Inman | St. Louis | Denman Pharmacy | Williams Care #1 | 15 | MR/DD | Confirmed | Yes | 2012-01-27 00:00:00 | 2012-01-01 00:00:00 |  | [NAME] | 39012 |  |  | 2012-02-06 00:00:00 | Other |  |  |  |  |  |  | Closed | Yes | n/a | n/a | 4.4 | 2011-08-23 00:00:00 | 2011-10-18 00:00:00 | Lost | Closed the facility and moved all residents into Loving Hands (which we we service) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Verbal | OK | Home Pharmacy |  |  |  | MR/DD |  | A3 | KVL email |  | Lost | Other |  |  | Other
Inman | St. Louis | Interlock - Columbia | Fischer Heights | 15 | ALF | Confirmed | Yes | 2012-02-13 00:00:00 | 2012-01-31 00:00:00 |  | A3 | 47148 |  | 2012-01-10 00:00:00 | 2012-01-13 00:00:00 | Email from unit | Written | 2012-01-13 00:00:00 | 2012-02-03 00:00:00 | 2012-02-03 00:00:00 |  |  | Other | No | Saultz Pharmacy | 2012-01-20 00:00:00 | 3.7 | n/a | 2011-09-16 00:00:00 |  | Not able to contact DON until 1/11/12.  At that time she geve the name of the owner and the telephone number.  DON did not sound optimistic about the possibility of retaining the business.  Trying to set up a meeting with owners as Callaway County has always been pleased with service and they want to keep the carts.  New ownership is Finck and the [NAME].  Same owners for other Callaway County bldg Timbrook.  KVL sent invalid term letter 1/31/12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Written | North | Interlock - Columbia |  |  |  | OTHER |  | A3c | Other |  | Saved | Per Diem |  |  | Per Diem
Inman | St. Louis | Interlock - Columbia | [NAME] | 16 | ALF | Confirmed | Yes | 2012-02-13 00:00:00 | 2012-01-31 00:00:00 |  | A3 | 21516 |  | 2012-01-10 00:00:00 | 2012-01-13 00:00:00 | Email from unit | Written | 2012-01-13 00:00:00 | 2012-02-03 00:00:00 | 2012-02-03 00:00:00 |  |  | Other | No | Saultz Pharmacy | 2012-01-20 00:00:00 | 3.7 | n/a | 2011-09-16 00:00:00 |  | Not able to contact DON until 1/11/12.  At that time she geve the name of the owner and the telephone number.  DON did not sound optimistic about the possibility of retaining the business.  Trying to set up a meeting with owners as Callaway County has always been pleased with service and they want to keep the carts.  New ownership is Finck and the [NAME].  Same owners for other Callaway County bldg Timbrook.  KVL sent invalid term letter 1/31/12.   [NAME] letter sent on Tuesday this week.  Have not heard a response from new management company. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A |  | Interlock - St. Louis |  |  |  | PC |  | B1 |  |  |  | Pricing |  |  | Pricing
Inman | St. Louis | [NAME] | Homestead Health Center | 80 | SNF | Confirmed | Yes | n/a | 2012-04-01 00:00:00 |  | A2 | 300852 |  | 2011-11-08 00:00:00 | 2011-11-07 00:00:00 | Call to Kitty | Written | 2011-11-22 00:00:00 | 2011-11-22 00:00:00 | 2011-11-22 00:00:00 | 2011-11-22 00:00:00 | 2011-11-22 00:00:00 | Service - lack of relationship with decision maker | Yes | Prestons | 2011-09-01 00:00:00 | 3.3 | 2011-03-01 00:00:00 | 2011-06-21 00:00:00 | Lost | New ADM, [NAME] said she has had a strong relationship with Prestons in the past and is ready for change.  Could not give us any issues about service.  [NAME] has met with facility multiple times.  Still hopes of saving the account. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Managed Health Care |  |  |  | SNF |  | B1c |  |  |  | Service - billing |  |  | Service - billing
Inman | St. Louis | [NAME] | Aldersgate | 194 | SNF | Confirmed | Yes | n/a | 2012-03-31 00:00:00 |  | A1 | 1800000 |  | 2011-04-15 00:00:00 | 2011-04-15 00:00:00 | Call to Kitty | Written | 2011-08-15 00:00:00 |  |  |  | 2011-08-16 00:00:00 | Other | Yes | Preston | 2012-02-02 00:00:00 | n/a | n/a | n/a |  | Attending QA 2-8-12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Medicate [NAME] |  |  |  |  |  | B2 |  |  |  | Service - lack of relationship with decision maker |  |  | Service - lack of relationship with decision maker
Meyer | TN | Omnicare of Huntsville | Hearthstone Heritage Woods | 112 | ALF | Potential | Yes | n/a | 2012-03-01 00:00:00 |  | [NAME] |  |  | 2011-10-24 00:00:00 | 2011-10-24 00:00:00 | Email from unit |  |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a |  | [NAME] buy out , no contract |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  | B2c |  |  |  | Service - Med errors |  |  | Service - Med errors
Meyer | TN | Omnicare of Huntsville | [NAME] of Byrd Springs (FKA Hearthstone Huntsville) | 112 | ALF | Potential | Yes | n/a | 2012-03-01 00:00:00 |  | [NAME] |  |  | 2011-10-24 00:00:00 | 2011-10-24 00:00:00 | Email from unit |  |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a |  | [NAME] buy out , no contract |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Omnicare of Ashland |  |  |  |  |  | B3 |  |  |  | Service - medical records |  |  | Service - medical records
Meyer | TN | Omnicare of Huntsville | [NAME] | 234 | SNF | Potential | Yes | n/a | 2012-04-01 00:00:00 |  | A1c | 1446598 |  | 2011-06-27 00:00:00 | 2011-06-27 00:00:00 | Email from unit |  |  |  |  |  |  |  |  |  | 2011-09-23 00:00:00 | 4.8 | 2011-11-17 00:00:00 | 2011-11-16 00:00:00 |  | [NAME] Home |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Omnicare of Beattyville |  |  |  |  |  | B3c |  |  |  | Service - meds not delivered timely |  |  | Service - meds not delivered timely
Meyer | TN | Omnicare of Huntsville | [NAME] | 159 | SNF | Potential | Yes | n/a | 2012-04-01 00:00:00 |  | A1c | 1658437 |  | 2011-06-27 00:00:00 | 2011-06-27 00:00:00 | Email from unit |  |  |  |  |  |  |  |  |  | 2011-09-23 00:00:00 | 4.6 | 2011-11-16 00:00:00 | 2011-11-15 00:00:00 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Omnicare of Herrin |  |  |  |  |  | C1 |  |  |  | Service - stat medications |  |  | Service - stat medications
Meyer | TN | Omnicare of Huntsville | [NAME] Shleby Ridge | 172 | SNF | Potential | Yes | n/a | 2012-03-01 00:00:00 |  | A1c | 1113139 |  | 2011-06-27 00:00:00 | 2011-06-27 00:00:00 | Email from unit |  |  |  |  |  |  |  |  |  | 2011-09-23 00:00:00 | 5 | 2011-11-10 00:00:00 | 2011-11-30 00:00:00 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Omnicare of Huntsville |  |  |  |  |  | C1c |  |  |  | Service - survey issues |  |  | Service - survey issues
Meyer | TN | Omnicare of Memphis | Prestige - Pine Meadows | 144 | SNF | Confirmed | Yes | n/a | 2012-01-31 00:00:00 |  | A1c | 908416 |  | 2011-11-18 00:00:00 | 2011-11-18 00:00:00 | Other | Written |  |  |  |  |  |  | Yes | [NAME] | 2011-10-19 00:00:00 | 4.4 | 2011-11-10 00:00:00 | n/a | Lost | Presitge Home, lost RFP to [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Omnicare of Memphis |  |  |  |  |  | C2 |  |  |  | Service - Technology |  |  | Service - Technology
Meyer | TN | Omnicare of Memphis | Prestige - Ripley | 134 | SNF | Confirmed | Yes | n/a | 2012-02-29 00:00:00 |  | A1c | 506644 |  | 2011-11-18 00:00:00 | 2011-11-18 00:00:00 | Other | Written |  |  |  |  |  |  | Yes | [NAME] | 2011-10-19 00:00:00 | 4 | 2011-03-01 00:00:00 | n/a |  | Presitge home - lost RFP to [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Omnicare of Minnesota |  |  |  |  |  | C2c
Meyer | TN | Omnicare of Memphis | Prestige - Spring Gate | 233 | SNF | Confirmed | Yes | n/a | 2012-03-31 00:00:00 |  | A1c | 1767363 |  | 2011-11-18 00:00:00 | 2011-11-18 00:00:00 | Other | Written |  |  |  |  |  |  | Yes | [NAME] | 2011-10-19 00:00:00 | n/a | n/a | n/a |  | Presitge home - lost RFP to [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Omnicare of Morgantown |  |  |  |  |  | [NAME] |  |  |  | Forecasted |  |  | Forecasted
Inman | North | Omnicare of Minnesota | Northfield Care Center | 54 | SNF | Confirmed | Yes |  | 2012-05-31 00:00:00 |  | [NAME] | 131000 |  | 2012-01-27 00:00:00 | 2012-02-09 00:00:00 | Other | Written |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a |  | received written term – they want to give their people freedom of choice and have choosen Merwins or Village Drug.  3 years ago they gave us notice and did not give it timely so contract rolled over and we held them to it back then. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Omnicare of Nashville |  |  |  |  |  | [NAME] |  |  |  | Not Forecasted
Inman | North | Omnicare of Minnesota | Primrose Retirement Communities | 66 | ALF | Confirmed | Yes | 2012-02-13 00:00:00 | 2012-05-11 00:00:00 |  | A2 | 123696 |  | 2011-09-26 00:00:00 | 2011-10-07 00:00:00 | Email from unit | Written | 2011-11-29 00:00:00 | 2011-11-30 00:00:00 | 2012-02-01 00:00:00 |  |  | Service - meds not delivered timely | Yes | Local - name unknown | 9/29/11 12/13/11 | 2.3 | 2011-09-11 00:00:00 | scheduled 12/15/11 but cancelled | Lost | Not renewing their contract due to pharmacy not meeting their needs. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Omnicare of Nebraska
Meyer | TN | Omnicare of Nashville | Prestige - Camden Health & Reahb | 150 | SNF | Confirmed | Yes | n/a | 2012-01-31 00:00:00 |  |  |  |  | 2011-11-18 00:00:00 | 2011-11-18 00:00:00 | Other | Written |  |  |  |  |  |  | Yes | [NAME] | 2011-10-19 00:00:00 | 3.3 | 2011-11-22 00:00:00 |  |  | Prestige home - lost RFP to [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Omnicare of Nitro
Meyer | TN | Omnicare of Nashville | Prestige - Huntington Health & Rehab | 150 | SNF | Confirmed | Yes | n/a | 2012-02-29 00:00:00 |  |  |  |  | 2011-11-18 00:00:00 | 2011-11-18 00:00:00 | Other | Written |  |  |  |  |  |  | Yes | [NAME] | 2011-10-19 00:00:00 | 3.6 | 2011-10-28 00:00:00 |  |  | Prestige home - lost RFP to [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Omnicare of South Dakota
Meyer | TN | Omnicare of Nashville | Bios | 40 | MR/DD | Confirmed | Yes | n/a | 2012-03-31 00:00:00 |  | B3 | 261150 |  | 2011-11-17 00:00:00 | 2011-11-17 00:00:00 | Email from unit | Written | 2011-11-28 00:00:00 | 2011-11-28 00:00:00 | 2011-02-01 00:00:00 | 2012-02-14 00:00:00 | 2012-02-14 00:00:00 | Pricing | Yes | Del Mar | 2010-06-08 00:00:00 | 4.4 | 2011-04-01 00:00:00 | n/a | Lost | Facility is not renewing contract - gave 120 notice.  They will start using Delmar in January but will not "terminate" until 3/31/12.  Del Mar is offering software to help with documentation in medical records. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Omnicare of Tennessee
Meyer | TN | Omnicare of Nashville | [NAME] | 84 | ALF | Potential | Yes | n/a | 2012-02-28 00:00:00 |  | A3 | 133643 |  | 2011-10-24 00:00:00 | 2011-10-24 00:00:00 | Bi-weekly call |  |  |  |  |  |  |  |  |  | 2011-12-01 00:00:00 | n/a | n/a | 2011-11-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Omnicare of Urbandale
Meyer | TN | Omnicare of Nashville | Elmcroft - Carestone Brentwood | 113 | ALF | Potential | Yes | n/a | 2012-03-01 00:00:00 |  | [NAME] | 230353 |  | 2011-10-24 00:00:00 | 2011-10-24 00:00:00 | Bi-weekly call |  |  |  |  |  |  |  |  |  |  | n/a | n/a | 2011-12-13 00:00:00 |  | [NAME] buy out, no contract |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Omnicare Pharmacy of the Midwest
Meyer | TN | Omnicare of Nashville | Elmcroft - Carestone Rivergate | 113 | ALF | Potential | Yes | n/a | 2012-03-01 00:00:00 |  | [NAME] | 156351 |  | 2011-10-24 00:00:00 | 2011-10-24 00:00:00 | Bi-weekly call |  |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a |  | [NAME] buy out, no contract |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sequoia - OK City
Inman | North | Omnicare of South Dakota | Cayman Court | 24 | ALF | Confirmed | Yes | 2012-02-13 00:00:00 | 2012-06-01 00:00:00 |  | B2 | 344393 |  | 2012-02-03 00:00:00 | 2012-02-03 00:00:00 | KVL email | Written |  |  |  |  |  |  | Yes | local competitor | n/a | 5 | 2011-11-02 00:00:00 | n/a |  | Facility is affiliated with Southeastern Behavioral Health who termed their relationship with OCRSD approximately two years ago.  [NAME] was still under contract at the time of the Southeastern Behavioral termination (separate contracts).  Contract is up in May 2012 with a 120 day out clause.  Moving to our local competitor.  Multiple phone calls have been made with messages left to [NAME], CEO of Southeastern Behavioral Healthcare.  [NAME] was scheduled for 2/9/2012 with DON/Admin of Cayman.  [NAME]/[NAME] called back cancelling appointment at the direction of [NAME], CEO. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Meyer | TN | Omnicare of Tennessee | [NAME] I | 32 | ALF | Confirmed | Yes | n/a | 2012-02-28 00:00:00 |  | [NAME] | 75695 |  | 2012-02-02 00:00:00 | 2012-02-02 00:00:00 | Call to Kitty | Written |  |  |  |  |  |  |  |  | 2012-02-06 00:00:00 | 3.3 | 2011-08-31 00:00:00 | n/a
Meyer | TN | Omnicare of Tennessee | [NAME] | 32 | ALF | Confirmed | Yes | n/a | 2012-02-28 00:00:00 |  | [NAME] |  |  | 2012-02-02 00:00:00 | 2012-02-02 00:00:00 | Call to Kitty | Written |  |  |  |  |  |  |  |  | 2012-02-06 00:00:00 | 3.3 | 2011-08-31 00:00:00 | n/a
Meyer | TN | Omnicare of Tennessee | Mountainbrook | 169 | ALF | Confirmed | Yes | n/a | 2012-05-31 00:00:00 |  | B3 | 224157 |  | 2012-01-19 00:00:00 | 2012-01-26 00:00:00 | Call to Kitty | Written |  |  |  |  |  |  |  |  | 9/8/11 1/30/12 | 3.9 | 2011-11-22 00:00:00 | 2012-11-16 00:00:00 |  | New Administrator effective 1/1/12.  [NAME] came from Emory Valley.  Meeting with new ADM on 2/1/12
Meyer | TN | Omnicare of Tennessee | Colonial Hills | 203 | SNF | Confirmed | Yes | n/a | 2/7/201 |  | B1 | 1506703 |  | 2011-12-28 00:00:00 | 2012-01-13 00:00:00 | Email from unit | Written | 2011-12-29 00:00:00 | 2012-01-17 00:00:00 | 2012-01-17 00:00:00 | 2012-01-30 00:00:00 | 2012-01-30 00:00:00 | Closed | Yes | n/a | n/a | 3 | 2011-11-28 00:00:00 | n/a | Lost | Facility is closing.   Information provided by National Accounts.  Term date has not been shared.  Survey issues , noting pharmacy related.
Meyer | TN | Omnicare of Tennessee | Emory Valley | 100 | MR/DD | Confirmed | Yes | n/a | 2012-02-29 00:00:00 |  | A2 | 650886 |  | 2012-01-03 00:00:00 | 2012-01-03 00:00:00 | Email from unit | Written | 2012-01-03 00:00:00 |  |  |  |  | Service - billing | Yes | Unknown | 2012-01-03 00:00:00 | n/a | n/a | 2011-12-09 00:00:00
Meyer | TN | Omnicare of Tennessee | Prestige - Jefferson City Health & Rehab | 170 | SNF | Confirmed | Yes | n/a | 2012-03-01 00:00:00 |  | A1c | 1389564 |  | 2011-11-28 00:00:00 | 2011-11-28 00:00:00 | Other | Written |  |  |  |  |  |  |  |  |  |  |  |  |  | Presitge Home, lost RFP to [NAME]
Meyer | TN | Omnicare of Tennessee | Carestone chattanooga | 113 | ALF | Potential | Yes | n/a | 2012-03-01 00:00:00 |  | [NAME] | 254166 |  | 2011-10-24 00:00:00 | 2011-10-24 00:00:00 | Bi-weekly call |  |  |  |  |  |  |  |  |  | 2012-01-30 00:00:00 | n/a | n/a | n/a |  | Sold to [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Inman | KY | Beeber Pharmacy |  |  |  | ALF | Confirmed | A1 | Call to Kitty |  | Yes | Closed
Inman | North | Omnicare of Urbandale | Genesis Senior Living | 80 | SNF | Confirmed | Yes | 2012-02-13 00:00:00 | 2012-04-01 00:00:00 |  | B1c | 711000 |  | 2012-02-03 00:00:00 | 2012-01-27 00:00:00 | Email from unit | Written |  |  |  |  |  | Other |  |  | 2011-04-08 00:00:00 | 3.9 | 2011-09-16 00:00:00 | 2011-11-15 00:00:00 |  | Request for a copy of the contract due to new ownership on 1/17/2012.  Received termination notice 2/2/12.   2/9/12 Update:  Spoke to managing partner [NAME] today.  He manages facilities for the new owner in New York and New Jersey and wants to consolidate to one pharmacy – PharMerica.  Says it is not service or he would have called.  Says it is not price, as he has not even evaluated that, but states it is a long standing relationship with PharMerica and not negotiable.  Polite, but firm. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Inman | KY | Beeber Pharmacy |  |  |  | ALF | Confirmed | A1 | Call to Kitty |  | Yes | Closed
Inman | North | Omnicare of Urbandale | Regency Care Center | 101 | SNF | Confirmed | Yes | 2012-02-13 00:00:00 | 2012-04-01 00:00:00 |  | B1c | 691000 |  | 2012-02-03 00:00:00 | 2012-01-27 00:00:00 | Email from unit | Written |  |  |  |  |  | Other |  |  | 2011-04-08 00:00:00 | 3.5 | 2011-04-01 00:00:00 | 2011-11-15 00:00:00 |  | Request for a copy of the contract due to new ownership on 1/17/2012.  Received termination notice 2/2/12.   2/9/12 Update:  Spoke to managing partner [NAME] today.  He manages facilities for the new owner in New York and New Jersey and wants to consolidate to one pharmacy – PharMerica.  Says it is not service or he would have called.  Says it is not price, as he has not even evaluated that, but states it is a long standing relationship with PharMerica and not negotiable.  Polite, but firm. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Inman | KY | Beeber Pharmacy |  |  |  | ALF | Confirmed | A1 | Call to Kitty |  | Yes | Closed
Inman | North | Omnicare of Urbandale | Regency Care Center AL | 60 | ALF | Confirmed | Yes | 2012-02-13 00:00:00 | 2012-04-01 00:00:00 |  | A1c | combined | combined | 2012-02-03 00:00:00 | 2012-01-27 00:00:00 | Email from unit | Written |  |  |  |  |  | Other |  |  | 2011-04-08 00:00:00 | n/a | n/a | 2011-11-15 00:00:00 |  | Request for a copy of the contract due to new ownership on 1/17/2012.  Received termination notice 2/2/12.   2/9/12 Update:  Spoke to managing partner [NAME] today.  He manages facilities for the new owner in New York and New Jersey and wants to consolidate to one pharmacy – PharMerica.  Says it is not service or he would have called.  Says it is not price, as he has not even evaluated that, but states it is a long standing relationship with PharMerica and not negotiable.  Polite, but firm. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WV | Denman Pharmacy |  |  |  | HOSPITAL |  | A2 | Forecast Call |  |  | J/V In-House Pharmacy
Inman | North | Omnicare of Urbandale | [NAME] | 38 | SNF | Confirmed | Yes | n/a | 2012-02-24 00:00:00 |  | A3 | 89000 |  | 2012-01-24 00:00:00 | 2012-01-27 00:00:00 | Bi-weekly call | Written | 2012-02-02 00:00:00 |  |  |  |  | Service - Med errors | Yes | Martin Brothers | 11/1/11 2/1/12 | 3.7 | 2011-09-30 00:00:00 | 2011-10-20 00:00:00 | Lost | Meeting was scheduled with facility on 1/20/12.  Forced to reschedule for 1/31/12 but letter and packet left with NHA.  Have attempted to contact by phone.  Not returning calls.  Term not related to Cedar Rapids closing, facility said have had service issues for the past year, however none were communicated to [NAME] or [NAME] in November/December when they met with facility.  New ADM at facility and has made up his mind that they are leaving. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | St. Louis | Home Care Pharmacy |  |  |  | ICF |  | [NAME] | Bi-weekly call |  |  | National Accounts
Inman | North | Omnicare of Urbandale | Highland Ridge - Cedar Rapids | 94 | ALF | Confirmed | Yes | n/a | 2012-04-01 00:00:00 |  | [NAME] | 20000 |  | 2012-01-09 00:00:00 | 2012-01-27 00:00:00 | Bi-weekly call | Written | 2012-02-02 00:00:00 |  |  |  |  | Other | No | Martin Brothers | n/a | n/a | n/a | n/a |  | Highland Ridge term letter was received 1/9/12.  Stated 80% of residents use a different pharmacy.
Inman | North | Omnicare of Urbandale | Courtyard [NAME] | 60 | ALF | Confirmed | Yes | n/a | 2012-02-15 00:00:00 |  | A3 | 90000 |  | 2011-12-29 00:00:00 | 2012-01-27 00:00:00 |  | Written | 2012-01-09 00:00:00 |  |  |  |  | Service - lack of relationship with decision maker | No | Medicap | 2011-12-20 00:00:00 | n/a |  | n/a | Saved | Met with Executive Director and DON on 1/25/12 and account has been saved.
Inman | North | Omnicare of Urbandale | First Resources - Cedar Rapids | 25 | Other | Confirmed | Yes | n/a | 2012-02-01 00:00:00 |  | B3 | 24000 |  | 2011-12-06 00:00:00 | 2011-12-09 00:00:00 | Email from unit | Written | 2011-12-09 00:00:00 | 2011-12-20 00:00:00 | 2012-01-30 00:00:00 |  |  | Service - lack of relationship with decision maker | Yes | Pamida | n/a | n/a | n/a | n/a | Lost | Small group home with no contract
Inman | North | Omnicare of Urbandale | Quality Health Care Mitchellville | 65 | SNF | Potential | Yes | n/a | 2012-01-31 00:00:00 | 2012-01-12 00:00:00 | A2 | 445000 |  | 2011-12-01 00:00:00 | 2011-12-01 00:00:00 | Bi-weekly call | Written | 2011-12-05 00:00:00 | 2011-12-20 00:00:00 | 2011-12-21 00:00:00 | 2012-01-09 00:00:00 | 2012-01-10 00:00:00 | Service - meds not delivered timely |  | Unkown | 2011-12-05 00:00:00 | 4 | 2011-03-11 00:00:00 | 2011-11-09 00:00:00 | Saved | [NAME] and [NAME] were presented term letter during meeting with ADM and DON.  Discussed issues at length.  After action plan and DD, [NAME] went back to ADM and offered a month to month contract and ADM said he would consider.  2/16/12 - signed addendum for month to month contract, submitted saved paperwork, but [NAME] still uncomfortable they will stay long term.
Inman | North | Omnicare of Urbandale | Osage Care Center | 50 | SNF | Confirmed | Yes | n/a | 2012-01-31 00:00:00 |  | A3 | 228000 |  | 2011-12-30 00:00:00 | 2011-06-17 00:00:00 | Other | Written | 2012-01-04 00:00:00 | 2012-02-03 00:00:00 | 2012-02-13 00:00:00 | 2012-02-14 00:00:00 | 2012-02-14 00:00:00 | Service - lack of relationship with decision maker |  | Martin Brothers | 2011-09-26 00:00:00 | 2.4 | 2011-09-26 00:00:00 | scheduled 11/11/11 |  | National Account, team working with KAM
Inman | St. Louis | Omnicare Pharmacy of the Midwest | Lexington Care Center | 160 | SNF | Confirmed | Yes | n/a | 2012-01-22 00:00:00 |  | A2 | 589548 |  | 2012-01-22 00:00:00 | 2012-01-22 00:00:00 | Email from unit | Verbal | 2012-01-27 00:00:00 | 2012-02-03 00:00:00 | 2012-02-03 00:00:00 | 2012-02-04 00:00:00 | 2012-02-06 00:00:00 | National Accounts | Yes | AccuScript | 2011-12-23 00:00:00 | 2.3 | 2011-09-16 00:00:00 | 2011-09-16 00:00:00 | Lost | Saber facility sold to [NAME].  [NAME] has their own pharmacy.  ADM stated that they were happy with service but resident has the right to choose and asked us to continue to service the building.  The ADM contacted pharmacy later that day and asked them to stop pharmacy services.
Inman | St. Louis | Omnicare Pharmacy of the Midwest | Faith Haven | 11 | MR/DD | Confirmed | Yes | n/a | 2012-01-18 00:00:00 |  | A3 | 37143 |  | 2012-01-18 00:00:00 | 2012-01-18 00:00:00 | Email from unit | Verbal |  |  |  |  |  | Other |  |  | 2011-01-04 00:00:00 | n/a | n/a | 2011-12-05 00:00:00 | Lost | Patients First acquisition.  Wants to use local provider and does not like receiving information that a med is not coming because of coverage.  Spoke with [NAME] and she agreed it was okay to call her back mid year to see how pharmacy services were going with new provider.  If the new pharmacy was not meeting her expectations, she will consider returning to [NAME].
Inman | St. Louis | Omnicare Pharmacy of the Midwest | [NAME] | 124 | ALF | Confirmed | Yes | n/a | 2012-03-01 00:00:00 |  | A2 | 352272 |  | 2012-01-12 00:00:00 | 2012-01-12 00:00:00 | Email from unit | Written | 2012-01-26 00:00:00 | 2012-01-27 00:00:00 | 2012-02-02 00:00:00 | 2012-02-15 00:00:00 | 2012-02-16 00:00:00 | Pricing |  | Uvanta | 2012-01-16 00:00:00 | 3.1 | 2011-09-09 00:00:00 | n/a |  | Met with Executive Director on 1/15/12 and requested opportunity to correct pricing issues.  Offered new 30 day contract with permanent 30 day out.  ED stated she would consider and called later that day and termed pharmacy services.  [NAME] she would look foolish to her superiors after already getting the go ahead to term.
Inman | St. Louis | Omnicare Pharmacy of the Midwest | Reaching Out | 3 | MR/DD | Confirmed | Yes | n/a | 2011-12-30 00:00:00 |  | B3 | 66976 |  | 2011-12-30 00:00:00 | 2012-01-02 00:00:00 | Email from unit | Verbal | 2012-01-02 00:00:00 | 2012-01-12 00:00:00 | 2012-01-30 00:00:00 |  |  | Other | Yes | Unknown | 2012-01-04 00:00:00 | 4.2 | 2011-10-24 00:00:00 | n/a | Lost | Decision by the owner to change pharmacy providers.  Pharmacy requested the opportunity to correct service issues.  Owner denied and wants the opportunity to return if new provider doesn't work out.  Owner denies service issues, just wants to try to
Inman | OK | Sequoia - OK City | Oaks in McAlester | 80 | SNF | Confirmed | Yes | n/a | 2012-01-03 00:00:00 |  | A2 | 212308 |  | 2012-01-02 00:00:00 | 2012-01-02 00:00:00 | Email from unit | Verbal | 2012-01-03 00:00:00 |  |  |  | 2012-01-13 00:00:00 | Closed | Yes | none closed | n/a | 5 | 2011-11-18 00:00:00 | 2011-10-26 00:00:00 | Lost | Owner of the facility reports that the facility is losing money.  Pharmacy only services 22 residents.