Can you help me verify that the cells highlighted in dark grey are correct? I am trying to figure out Expense Variance and Revenue Variance and if the Product Lines are favorable or unfavorable.
Jiranna Healthcare Expenses Worksheet, Mid-Year Review Outpatient Unit Expense (FY10) Actual Units Total OP Unit Unit FY11 Budget (FY10+6% Inflation) Actual OP Expenses Expense Variance (F)avorable or (U)nfavorable Outpatient Product Line (FY10) Expenses Forecast Expence Acutal Mid (FY10) (FY11) Year Units (FY11 YTD) Budget FY11) (FY11) CARDIOLOGY $ 5,478.81 645 $ 3,533,832 677 $5,807.54 ENDOCRINOLOGY $ 5,478.81 $ 3,931,704 197 217 $ 1,144,085 $ 1, 188,902 2,787.619) 228 $5.807.54 FAMILY MED $ 1,324,119 $ 5,476.81 112 $ 650.444 1, 105 $ 6,051,875 (673.675) 1, 161 $5,802.92 GYN $ 6,737,188 636 $ 5,478.81 208 $ 3.690,656 $ 1, 139,592 (3,046.532) 219 $5.794.28 ENT $ 1,268,947 116 $ 5,475.81 $ 672.136 690 $ 3,778,309 (596,811) 724 $5,804.36 MENTAL HEALTH $ 4,202,356 421 $ 498.78 62,443.635 1,287 $ 641,930 (1,758,721) 1.351 $528.71 NEWBORN $ 714,283 736 $ 5,478.81 698 $ 389,128 (325,155) $ 3,824.209 733 $5,807.54 OB $ 4.256.926 433 $ 5.478.81 $ 2,514,664 (1,742,262) 1,430 $ 7,834,698 1,50 $5.807.54 ORTHO $ 8.717.115 868 $ 5,478.81 $ 5.040.943 601 (3,676,172) $ 3.292.765 531 $5.807.54 PEDIATRICS $ 3.664,557 274 $ 5,477.81 124 $ 679,248 $ 1,591,266 (2,073,291) 130 $5,806.48 PODIATRY $ 754.842 72 $ 5.478.81 $ 418.066 2,050 $ 11,231,561 336,776 2, 152 $5.807.54 $ 12.497,823 800 Total Expenses $55,281 $ 4.646,031 9,055 $43,196,921 (7,851,792 9,507 $58,582 $48,069,860 4,665 $23,201,056 (24,868,804) Jiranna Healthcare Revenues Worksheet, Mid-Year Review ient Outpatient Product Line Unit Price (FY10) Actual Units Total OP Revenue Unit Forecasted Unit Price (Budget |Projected OP Revenue For FY11 Actual Actual OP Revenue Revenue Variance (FY10 |(F)avorable or (U)nfavorable FY11) For (FY11) FY11 FY11 YTD) CARDIOLOGY (FY11 YTD) $ 6, 118.73 645 $ 3,946,580.85 677 $6, 118.73 $ 4, 142,380 197 ENDOCRINOLOGY $ 1,205,390 $ 2,936,990 $ 6, 103.65 217 $ 1,324,492.05 228 $6, 103.65 $ 1,391,632 112 $ 683,609 $ 708,023 FAMILY MED $ 6,021.65 1, 105 $ 6,653,923.25 1, 161 $6,019.06 $ 6,988, 125 636 GYN $ 3,828, 120 -$ 3,160,005 $ 6,013.65 208 $ 1,250,839.20 219 $5,999.92 $ 1,313,983 116 $ 695,991 ENT -$ 617,992 $ 6,010.65 690 $ 4, 147,348.50 724 $6,010.65 $ 4,351,711 421 MENTAL HEALTH $ 2,530,484 $ 1,821,227 $ 502.99 1,287 $ 647,348.13 1,351 $502.99 $ 679,539 736 $ 370,200 -$ 309,339 NEWBORN $ 7,014.71 698 $ 4,896,267.58 733 $7,014.71 $ 5, 141,782 433 OB $ 3,037,369 $ 5,713.65 $ 2,104,413 1,430 $ 8, 170,519.50 1,501 $5,713.65 $ 8,576, 189 868 $ 4,959,448 ORTHO $ 3,616,741 $ 6,084.18 601 $ 3,656,592.18 631 $6,084.18 $ 3,839, 118 274 PEDIATRICS $ 1,667,066 -$ 2, 172,052 $ 6,001.65 124 $ 744,204.60 130 $6,001.65 $ 780,215 72 $ 432, 119 -$ 348,096 PODIATRY $ 6,018.14 2,050 $ 12,337, 187.00 2, 152 $6,018.14 $ 12,951,037 800 $ 4,814,512 -$ 8,136,525 Total Revenue $61,604 9,055 $47,775,303 9,507 $61,587 $50, 155,711 4,665 $24,224,308 -$ 25,931,403
