Page 38 - Mercy MOR All Regions_FinalwVideo
P. 38

RUN DATE: 2/7/2018  RUN TIME: 3:31:02 PM  YTD  PY  1,362,935                    426,432                        295,135                        945                                10,100                          11,045                          22,244                          45,965                          189,855                        258,063                        269,108                        48,043                          6,399                             19,017                          11,009                          33,648                          46,278                          32,872






                       YTD  Var %  -2.6%  9.8%  -6.7%  -28.1%  100.0%  50.1%  -2.4%  44.4%  -19.6%  -4.8%  -3.8%  -11.1%  21.4%  69.6%  -45.3%  -117.9%  102.3%  0.9%  15.5%  15.6%  41.7%  -167.3%  -30.5%  -244.1%  -47.2%  -66.2%  -13.7%  6.6%  10.1%  -184.7%  -20.3%  -18.6%  -408.7%  63.0%  -36.2%  -62.7%  30.5%  1.8%  -3.3%  -45.0%  3.6%  (0)                  0                   4  3.9%  4.4%  -2.4%  3.1%  0.4%  1.5%  -1.7%


                       Year To Date  Variance  (41,011)                       47,282                        (28,234)                       (611)                             3,413                          2,802                          (1,617)                         26,074                        (40,174)                       (15,717)                       (12,915)                       (5,514)                         7,799                          13,782                        (5,274)                         (31,330)                       24,543                        292                               4,082





                       Year To Date  Budget  1,564,059                   483,310                      418,711                      2,176                          3,413                          5,589                          67,121                        58,677                        204,463                      330,261                      335,850                      49,722                        36,415                        19,791                        11,631                        26,584                        23,980                        33,020                        26,258                        25,902





                       Year To Date  Actual  1,605,070                   436,027                      446,944                      2,787                          -                               2,787                          68,738                        32,603                        244,637                      345,978                      348,765                      55,236                        28,616                        6,009                          16,905                        57,915                        (563)                             32,728                        22,176                        21,864









                   Mercy Health - Clermont Hospital  For Periods Ending January 31, 2018



                 6302          Total Supplies  Medical Surgical  Drugs  Implant - Stents Implant - CRM AICD/Pacemakers  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  Chemistry Supplies  Radiology  Office Minor Equipment Non-Medical  Suture  Instruments  Minor Equipment Medical  Linen & Laundry  Freight  Housekeeping & Laundry  Contrast Media  Gases, Medical  Forms  Fuel (aircraft & auto)  Uniforms  Inventory Variance  Premier Incentive  Rebates &






                               1,362,935  426,432  295,135  945  10,100  11,045  22,244  45,965  189,855  258,063  269,108  48,043  6,399  19,017  11,009  33,648  46,278  32,872  30,044  22,939  19,651  11,925  9,090  21,984  24,656  6,330  28,494  7,513  8,835  6,222  3,033  121  -  (684)  (20,938)  (3,445)  (777)  684  2,752  73  561  634  1,572  13.3%  13.5%  867  20,162,108  26,179,902  46,342,011  10,119,665
                       MTD  PY



                               -2.6%  9.8%  -6.7%  -28.1%  100.0%  50.1%  -2.4%  44.4%  -19.6%  -4.8%  -3.8%  -11.1%  21.4%  69.6%  -45.3%  -117.9%  102.3%  0.9%  15.5%  15.6%  41.7%  -167.3%  -30.5%  -244.1%  -47.2%  -66.2%  -13.7%  6.6%  10.1%  -184.7%  -20.3%  -18.6%  -408.7%  63.0%  -36.2%  -62.7%  30.5%  1.8%  -3.3%  -45.0%  3.6%  -3.0%  0.2%  3.9%  4.4%  -2.4%  3.1%  0.4%  1.5%  -1.7%

                       MTD  Var %



                       Month To Date  Variance  (41,011)                        47,282                         (28,234)                        (611)                              3,413                           2,802                           (1,617)                          26,074                         (40,174)                        (15,717)                        (12,915)                        (5,514)                          7,799                           13,782                         (5,274)                          (31,330)                        24,543                         292                                4,0






                       Month To Date  Budget  1,564,059                    483,310                       418,711                       2,176                           3,413                           5,589                           67,121                         58,677                         204,463                       330,261                       335,850                       49,722                         36,415                         19,791                         11,631                         26,584                         23,980                         33,020                         26,258                         2





                       Month To Date  Actual  1,605,070                       436,027                           446,944                           2,787                                -                                    2,787                                68,738                              32,603                              244,637                           345,978                           348,765                           55,236                              28,616                              6,009                                16,905                              57,915                              (563)
   33   34   35   36   37   38   39   40   41   42   43