Answer: | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Schumpert Medical Center | | | | | | | | | | | Revenues Worksheet, Mid-Year Review | | | | | | | | | | | | | | | | | | | | | | Inpatient | | | | | | | | | | | | | | | | Inpatient Product Line | Price/RWP | Forecasted RWPs For FY11 | Projected IP Revenue For FY11 | Actual RWPs (FY11 YTD) | Actual IP Revenue (FY11 YTD) | | | | | | | | | | | CIRC | $ 6,010.65 | 724 | $ 4,351,711 | 421 | $ 2,530,676 | | | | | | | | | | | DIGEST | $ 6,021.65 | 1,161 | $ 6,988,125 | 636 | $ 3,830,402 | | | | | | | | | | | ENT | $ 6,001.65 | 130 | $ 780,215 | 72 | $ 433,948 | | | | | | | | | | | GYN | $ 6,013.65 | 219 | $ 1,313,983 | 116 | $ 697,128 | | | | | | | | | | | MENTAL HEALTH | $ 502.99 | 1,351 | $ 679,539 | 736 | $ 369,949 | | | | | | | | | | | NERVOUS | $ 6,103.65 | 228 | $ 1,391,632 | 112 | $ 682,744 | | | | | | | | | | | NEWBORN | $ 7,014.71 | 733 | $ 5,141,782 | 433 | $ 3,033,900 | | | | | | | | | | | OB | $ 5,713.65 | 1,501 | $ 8,576,189 | 868 | $ 4,960,622 | | | | | | | | | | | ORTHO | $ 6,084.18 | 631 | $ 3,839,118 | 274 | $ 1,664,658 | | | | | | | | | | | OTHER | $ 6,018.14 | 2,152 | $ 12,951,037 | 800 | $ 4,813,961 | | | | | | | | | | | RESP | $ 6,118.73 | 677 | $ 4,142,380 | 197 | $ 1,202,960 | | | | | | | | | | | Total Inpatient Earnings | | 9,506 | $ 50,155,710 | 4,664 | $ 24,220,949 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Schumpert Medical Center | | | | | | | | | | Expenses Worksheet, Mid-Year Review | | | | | | | | | | | | | | | | | | | | Inpatient | | | | | | | | | | | | | | | | | Inpatient Product Line | Budget/RWP (FY10) | Actual RWPs (FY10) | IP Expenses (FY10) | Forecasted RWPs (FY11) | FY11 Budget (FY10+6% Inflation) | FY11 Budget (FY10+6% Inflation) | Actual IP Expenses (FY11 YTD) | | | | | | | | | | CIRC | $ 5,475.81 | | $ 3,778,309 | 724 | $ 4,202,356 | 4,202,356 | # | | | | | | | | | | DIGEST | $ 5,476.81 | | $ 6,051,875 | 1,161 | $ 6,737,188 | 6,737,188 | # | | | | | | | | | | ENT | $ 5,477.81 | | $ 679,248 | 130 | $ 754,842 | 754,842 | # | | | | | | | | | | GYN | $ 5,478.81 | | $ 1,139,592 | 219 | $ 1,268,947 | 1,268,947 | # | | | | | | | | | | MENTAL HEALTH | $ 498.78 | | $ 641,930 | 1,351 | $ 714,283 | 714,283 | # | | | | | | | | | | NERVOUS | $ 5,478.81 | | $ 1,188,902 | 228 | $ 1,324,119 | 1,324,119 | # | | | | | | | | | | NEWBORN | $ 5,478.81 | | $ 3,824,209 | 733 | $ 4,256,926 | 4,256,926 | # | | | | | | | | | | OB | $ 5,478.81 | | $ 7,834,698 | 1,501 | $ 8,717,115 | 8,717,115 | # | | | | | | | | | | ORTHO | $ 5,478.81 | | $ 3,292,765 | 631 | $ 3,664,557 | 3,664,557 | # | | | | | | | | | | OTHER | $ 5,478.81 | | $ 11,231,561 | 2,152 | ########### | 12,497,823 | # | | | | | | | | | | RESP | $ 5,478.81 | | $ 3,533,832 | 677 | $ 3,931,704 | 3,931,704 | # | | | | | | | | | | Total Inpatient Expenses | | | $ 43,196,922 | 9,506 | ########### | 48,069,860 | # | | | | | | | | | | | | | | | | | | | | | | | | | | | Product Line | MDC Description | | | | | | | | | | | | | | | | CIRC | Diseases and Disorders of the Circulatory System | | | | | | | | | | | | | | | | DIGEST | Diseases and Disorders of the Digestive System | | | | | | | | | | | | | | | | ENT | Diseases and Disorders of the Ear, Nose, Mouth, and Throat | | | | | | | | | | | | | | | | GYN | Diseases and Disorders of the Female Reproductive System | | | | | | | | | | | | | | | | MH | Mental Diseases and Disorders | | | | | | | | | | | | | | | | MH | Alcohol/Drug Use and Alcohol/Drug Induced Organic Mental Disorders | | | | | | | | | | | | | | | | NERVOUS | Diseases and Disorders of the Nervous System | | | | | | | | | | | | | | | | NEWBORN | Newborns and Other Neonates with Conditions Originating in Perinatal Period | | | | | | | | | | | | | | | | OB | Pregnancy, Childbirth, and the Puerperium | | | | | | | | | | | | | | | | ORTHO | Diseases and Disorders of the Musculoskeletal System and Connective Tissue | | | | | | | | | | | | | | | | OTHER | Unknown | | | | | | | | | | | | | | | | OTHER | Diseases and Disorders of the Eye | | | | | | | | | | | | | | | | OTHER | Diseases and Disorders of the Hepatobiliary System and Pancreas | | | | | | | | | | | | | | | | OTHER | Diseases and Disorders of the Skin, Subcutaneous Tissue and Breast | | | | | | | | | | | | | | | | OTHER | Endocrine, Nutritional and Metabolic Diseases and Disorders | | | | | | | | | | | | | | | | OTHER | Diseases and Disorders of the Kidney and Urinary Tract | | | | | | | | | | | | | | | | OTHER | Diseases and Disorders of the Male Reproductive System | | | | | | | | | | | | | | | | OTHER | Diseases and Disorders of the Blood, Blood Forming Organs, Immunological Dis | | | | | | | | | | | | | | | | OTHER | Myeloproliferative Diseases and Disorders, Poorly Differentiated Neoplasm | | | | | | | | | | | | | | | | OTHER | Infectious and Parasitic Diseases, Systemic or Unspecified Sites | | | | | | | | | | | | | | | | OTHER | Injuries, Poisonings and Toxic Effects of Drugs | | | | | | | | | | | | | | | | OTHER | Burns | | | | | | | | | | | | | | | | OTHER | Factors Influencing Health Status and Other Contacts with Health Services | | | | | | | | | | | | | | | | OTHER | Multiple Significant Trauma | | | | | | | | | | | | | | | | OTHER | Human Immunodeficiency Virus Infections | | | | | | | | | | | | | | | | RESP | Diseases and Disorders of the Respiratory System | | | | | | | | | | | | | | | |