IS Dpt Bud Act 08/15/13 12:11 PM Valley Medical Center Dept # 7230 - EMERGENCY DEPARTMENT For the Twelve Months Ending June 30, 2013 June Budget Year To Date Budget Actual Prior Year Actual Prior Year PATIENT SERVICE REVENUES HOSPITALIP REV HOSPITAL OP REV $3,496,545 11,781,412 $3,723,135 12,250,524 $3,735,300 12,045,534 $42,381,555 $44,190,657 144,815,116 145,407,886 $36,232,075 120,693,546 15,277,956 15,973,659 15,780,834 187,196,672 189,598,543 156,925,620 GROSS PATIENT REVENUES DEDUCTIONS FROM REVE CONTRACTUAL ADJUSTMENTS (10,081,561) (11,017,753) (10,318,149) (128,342,493) (130,843,579) (103,083,072) TOTAL DED FROM REV (10,081,561) (11,017,753) (10,318,149) (128,342,493) (130,843,579) (103,083,072) NET PATIENT SERVICE REV 5,196,395 4,955,906 5,462,685 58,854,179 58,754,964 53,842,548 OTHER OPERATING REVENUES 0 3,168 0 0 38,000 25,777 NET OPERATING REVENUE 5,196,395 4,959,074 5,462,685 58,854,179 58,792,964 53,868,325 OPERATING EXPENSES SALARIES AND WAGES EMPLOYEE BENEFITS PHYSICIAN FEES SUPPLIES PURCHASED SERVICES OTHER EXPENSES DEPRECIATION 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 TOTAL OP EXPENSES 1,161,813 1,174,520 1,245,123 13,708,758 14,259,661 14,439,652 NET INCOME FROM OPERATIONS 4,034,583 3,784,554 4,217,561 45,145,420 44,533,303 39,428,673 NET INCOME $4,034,583 $3,784,554 $4,217,561 $45,145,420 $44,533,303 $39,428,673 7230_Emergency Dept ED_Services Provided_2013 8560_HR 8431 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. Is there one level charge that is more or less profitable than another? Who should determine what charges should be applied to a patient? What are the advantages/disadvantages on determining who should determine what emergency department charge level should be applied to a patient? Does it matter? Are there any ethical issues involved in this? IS Dpt Bud Act 08/15/13 12:11 PM Valley Medical Center Dept # 7230 - EMERGENCY DEPARTMENT For the Twelve Months Ending June 30, 2013 June Budget Year To Date Budget Actual Prior Year Actual Prior Year PATIENT SERVICE REVENUES HOSPITALIP REV HOSPITAL OP REV $3,496,545 11,781,412 $3,723,135 12,250,524 $3,735,300 12,045,534 $42,381,555 $44,190,657 144,815,116 145,407,886 $36,232,075 120,693,546 15,277,956 15,973,659 15,780,834 187,196,672 189,598,543 156,925,620 GROSS PATIENT REVENUES DEDUCTIONS FROM REVE CONTRACTUAL ADJUSTMENTS (10,081,561) (11,017,753) (10,318,149) (128,342,493) (130,843,579) (103,083,072) TOTAL DED FROM REV (10,081,561) (11,017,753) (10,318,149) (128,342,493) (130,843,579) (103,083,072) NET PATIENT SERVICE REV 5,196,395 4,955,906 5,462,685 58,854,179 58,754,964 53,842,548 OTHER OPERATING REVENUES 0 3,168 0 0 38,000 25,777 NET OPERATING REVENUE 5,196,395 4,959,074 5,462,685 58,854,179 58,792,964 53,868,325 OPERATING EXPENSES SALARIES AND WAGES EMPLOYEE BENEFITS PHYSICIAN FEES SUPPLIES PURCHASED SERVICES OTHER EXPENSES DEPRECIATION 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 TOTAL OP EXPENSES 1,161,813 1,174,520 1,245,123 13,708,758 14,259,661 14,439,652 NET INCOME FROM OPERATIONS 4,034,583 3,784,554 4,217,561 45,145,420 44,533,303 39,428,673 NET INCOME $4,034,583 $3,784,554 $4,217,561 $45,145,420 $44,533,303 $39,428,673 7230_Emergency Dept ED_Services Provided_2013 8560_HR 8431 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. Is there one level charge that is more or less profitable than another? Who should determine what charges should be applied to a patient? What are the advantages/disadvantages on determining who should determine what emergency department charge level should be applied to a patient? Does it matter? Are there any ethical issues involved in this