1 IS_Dpt_Bud_Act 2 08/15/13 3 12:11 PM Valley Medical Center Dept # 7230 - EMERGENCY DEPARTMENT For the Twelve Months Ending June 30, 2013 4 5 6 June 7 Year To Date Budget Actual Budget Prior Year Actual Prior Year $3,496,545 $3,723,135 $3,735,300 $42,381,555 $44,190,657 $36,232,075 11,781,412 12,250,524 12,045,534 144,815,116 145,407,886 120,693,546 15,277,956 15,973,659 15,780,834 187,196,672 189,598,543 156,925,620 (10,081,561) (11,017,753) (10,318,149) (128,342,493) (130,843,579) (103,083,072) (10,081,561) (11,017,753) (10,318,149) (128,342,493) (130,843,579) (103,083,072) 5,196,395 4,955,906 5,462,685 58,854,179 58,754,964 53,842,548 0 3,168 0 0 38,000 25,777 8 9 PATIENT SERVICE REVENUES 10 HOSPITAL IP REV 11 HOSPITAL OP REV 12 13 GROSS PATIENT REVENUES 14 15 DEDUCTIONS FROM REVENUE 16 CONTRACTUAL ADJUSTMENTS 17 18 TOTAL DED FROM REV 19 20 NET PATIENT SERVICE REV 21 22 OTHER OPERATING REVENUES 23 24 25 NET OPERATING REVENUE 26 27 OPERATING EXPENSES 28 SALARIES AND WAGES 29 EMPLOYEE BENEFITS 30 PHYSICIAN FEES 31 SUPPLIES 32 PURCHASED SERVICES 33 OTHER EXPENSES 34 DEPRECIATION 35 36 TOTAL OP EXPENSES 37 38 NET INCOME FROM OPERATIONS 39 NNNN 5,196,395 4,959,074 5,462,685 58,854,179 58,792,964 53,868,325 742,028 298,865 10,000 68,956 23,255 3,746 14,962 751,892 260,037 9,998 87,539 25,912 6,399 32,744 737,211 296,612 69,724 74,037 25,908 9,171 32,462 8,778,071 3,249,201 120,000 898,582 290,788 72,527 299,588 9,194,193 3,130,217 120,000 1,036,373 309,140 76,809 392,928 8,794,104 3,042,988 823,466 978,212 314,053 85,006 401,823 1,161,813 1,174,520 1,245,123 13,708,758 14,259,661 14,439,652 ww % 4,034,583 3,784,554 4,217,561 45,145,420 44,533,303 39,428,673 40 $4,034,583 $3,784,554 $4,217,561 $45,145,420 $44,533,303 $39,428,673 41 42 NET INCOME 43 44 1 Emergency Department 2 Charges By Service Code 3 2013 5 SERVICE 6 HC EMERGENCY DEPARTMENT VISIT HIGH/URGENT SEVERITY - L4 7 HC EMERGENCY DEPT VISIT HIGH SEVERITY&THREAT FUNCJ - L5 8 HC EMERGENCY DEPARTMENT VISIT MODERATE SEVERITY - L3 9 HC EMERGENCY DEPARTMENT VISIT LOW/MODER SEVERITY-L2 10 HC EMERGENCY DEPARTMENT VISIT LIMITED/MINOR PROB-L1 11 12 13 14 15 16 17 VOLUME PRICE TOTAL 43,642 $2,172.00 $94,791,286.15 16,415 $2,908.00 $47,734,239.67 29,091 $1,394.00 $40,552,712.05 4,945 $619.00 $3,060,710.95 2,843 $372.00 $1,057,726.18 $187,196,675.00 18 19 320 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 ww 38 39 7230_Emergency Dept ED_Services Provided_2013 8560_HR 8431Plant_M 2. Determine whether the Emergency Department is profitable after allocating costs of support departments. 1 IS_Dpt_Bud_Act 2 08/15/13 3 12:11 PM Valley Medical Center Dept # 7230 - EMERGENCY DEPARTMENT For the Twelve Months Ending June 30, 2013 4 5 6 June 7 Year To Date Budget Actual Budget Prior Year Actual Prior Year $3,496,545 $3,723,135 $3,735,300 $42,381,555 $44,190,657 $36,232,075 11,781,412 12,250,524 12,045,534 144,815,116 145,407,886 120,693,546 15,277,956 15,973,659 15,780,834 187,196,672 189,598,543 156,925,620 (10,081,561) (11,017,753) (10,318,149) (128,342,493) (130,843,579) (103,083,072) (10,081,561) (11,017,753) (10,318,149) (128,342,493) (130,843,579) (103,083,072) 5,196,395 4,955,906 5,462,685 58,854,179 58,754,964 53,842,548 0 3,168 0 0 38,000 25,777 8 9 PATIENT SERVICE REVENUES 10 HOSPITAL IP REV 11 HOSPITAL OP REV 12 13 GROSS PATIENT REVENUES 14 15 DEDUCTIONS FROM REVENUE 16 CONTRACTUAL ADJUSTMENTS 17 18 TOTAL DED FROM REV 19 20 NET PATIENT SERVICE REV 21 22 OTHER OPERATING REVENUES 23 24 25 NET OPERATING REVENUE 26 27 OPERATING EXPENSES 28 SALARIES AND WAGES 29 EMPLOYEE BENEFITS 30 PHYSICIAN FEES 31 SUPPLIES 32 PURCHASED SERVICES 33 OTHER EXPENSES 34 DEPRECIATION 35 36 TOTAL OP EXPENSES 37 38 NET INCOME FROM OPERATIONS 39 NNNN 5,196,395 4,959,074 5,462,685 58,854,179 58,792,964 53,868,325 742,028 298,865 10,000 68,956 23,255 3,746 14,962 751,892 260,037 9,998 87,539 25,912 6,399 32,744 737,211 296,612 69,724 74,037 25,908 9,171 32,462 8,778,071 3,249,201 120,000 898,582 290,788 72,527 299,588 9,194,193 3,130,217 120,000 1,036,373 309,140 76,809 392,928 8,794,104 3,042,988 823,466 978,212 314,053 85,006 401,823 1,161,813 1,174,520 1,245,123 13,708,758 14,259,661 14,439,652 ww % 4,034,583 3,784,554 4,217,561 45,145,420 44,533,303 39,428,673 40 $4,034,583 $3,784,554 $4,217,561 $45,145,420 $44,533,303 $39,428,673 41 42 NET INCOME 43 44 1 Emergency Department 2 Charges By Service Code 3 2013 5 SERVICE 6 HC EMERGENCY DEPARTMENT VISIT HIGH/URGENT SEVERITY - L4 7 HC EMERGENCY DEPT VISIT HIGH SEVERITY&THREAT FUNCJ - L5 8 HC EMERGENCY DEPARTMENT VISIT MODERATE SEVERITY - L3 9 HC EMERGENCY DEPARTMENT VISIT LOW/MODER SEVERITY-L2 10 HC EMERGENCY DEPARTMENT VISIT LIMITED/MINOR PROB-L1 11 12 13 14 15 16 17 VOLUME PRICE TOTAL 43,642 $2,172.00 $94,791,286.15 16,415 $2,908.00 $47,734,239.67 29,091 $1,394.00 $40,552,712.05 4,945 $619.00 $3,060,710.95 2,843 $372.00 $1,057,726.18 $187,196,675.00 18 19 320 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 ww 38 39 7230_Emergency Dept ED_Services Provided_2013 8560_HR 8431Plant_M 2. Determine whether the Emergency Department is profitable after allocating costs of support departments