Page 146 - Mercy MOR All Regions_FinalwVideo
P. 146

RUN DATE: 2/7/2018  RUN TIME: 3:31:02 PM  YTD  PY  224,644                       77,396                          84,572                          -                                 -                                 261                                4,859                             25,675                          30,795                          30,795                          5,487                             3,368                             -                                 710                                5,942                             4,167                             (1,022)






                        YTD  Var %  -35.2%  -4.1%  -19.0%  -533.4%  -533.4%  260.1%  -60.6%  -208.6%  -111.5%  -113.4%  -66.1%  -59.0%  0.0%  -71.9%  -60.3%  100.0%  -66.3%  -32.2%  -69.9%  67.6%  1.0%  -36.4%  17.0%  -357.4%  -8.9%  -124.1%  -1214.6%  23.1%  100.0%  35.2%  -73.2%  -282.1%  92.2%  13.3%  22.4%  8.4%  1  -24.2%  (0)                  (0)                  33.1%  33.5%  -39.6%  30.0%  6.9%  11.2%  1.3%


                        Year To Date  Variance  (105,328)                    (3,056)                          (27,125)                      (768)                             (768)                             153                              (12,819)                      (23,581)                      (36,247)                      (37,015)                      (2,052)                          (2,577)                          (7,529)                          (585)                             (2,850)                          (18)                               (16,255)                      (641)                             (946)






                        Year To Date  Budget  299,067                     73,959                         142,392                     144                              144                              59                                21,148                         11,304                         32,511                         32,655                         3,103                           4,371                           -                               813                              4,727                           (18)                               24,500                         1,989                           1,354






                        Year To Date  Actual  404,396                     77,015                         169,517                     912                              912                              (94)                               33,967                         34,885                         68,758                         69,670                         5,154                           6,948                           7,529                           1,398                           7,578                           -                               40,755                         2,630                           2,300














                 6795 Mercy Health – Defiance Hospital  For Periods Ending January 31, 2018        Total Supplies  Medical Surgical  Drugs  Implant - Stents  Total CRM Implants  Implant - Spinal  Implant - Orthopedic Joint  Implant - Other  Total Non-CRM Implants  Implant Total  Dietary  Blood  Endomechanical  Other Non-Medical  IV and IV Sets Physical Plant/Maintenance  Laboratory  Radiology  Office Minor Equipment Non-Medical  Suture  Instruments  Minor Equipment Medical  Freight  Housekeeping & Laundry  Contrast Media  Gases, Medical  Forms  Fuel (aircraft & auto)  Inventory Variance  Premier Incentive  Rebates & Incentiv







                                224,644  77,396  84,572  -  -  261  4,859  25,675  30,795  30,795  5,487  3,368  -  710  5,942  4,167  (1,022)  25  777  4,312  1,556  884  4,943  713  1,824  1,138  44  38  66  378  (2,901)  (465)  (104)  101  255  16  117  133  341  11.5%  11.5%  660  1,521,715  3,608,483  5,130,198  1,949,637

                        MTD  PY



                                -35.2%  -4.1%  -19.0%  -533.4%  -533.4%  260.1%  -60.6%  -208.6%  -111.5%  -113.4%  -66.1%  -59.0%  0.0%  -71.9%  -60.3%  100.0%  -66.3%  -32.2%  -69.9%  67.6%  1.0%  -36.4%  17.0%  -357.4%  -8.9%  -124.1%  -1214.6%  23.1%  100.0%  35.2%  -73.2%  -282.1%  92.2%  13.3%  22.4%  8.4%  -24.2%  -22.0%  -3.1%  33.1%  33.5%  -39.6%  30.0%  6.9%  11.2%  1.3%

                        MTD  Var %




                        Month To Date  Variance  (105,328)                     (3,056)                           (27,125)                       (768)                              (768)                              153                               (12,819)                       (23,581)                       (36,247)                       (37,015)                       (2,052)                           (2,577)                           (7,529)                           (585)                              (2,850)                           (18)                                (16,255)                       (641)






                        Month To Date  Budget  299,067                      73,959                          142,392                       144                               144                               59                                 21,148                          11,304                          32,511                          32,655                          3,103                            4,371                            -                                813                               4,727                            (18)                                24,500                          1,989






                        Month To Date  Actual  404,396                           77,015                             169,517                           912                                   912                                   (94)                                    33,967                             34,885                             68,758                             69,670                             5,154                                6,948                                7,529                                1,398                                7,578                                -                                    40,7
   141   142   143   144   145   146   147   148   149   150   151