F G . M N 0 Q o R B D E Grayson General Hospital Budget Report Jun-20 Revenue Actual Budget Variance Variance Inpatient stays 2,900 2,500 400 13.8% Inpatient Revenue 1,522,500 1,250,000 272,500 17.9% Please answer the following: 1 Did the inpatient revenue meet the budget for the month? What do you think contributed to this result? Be specific. 2 Did the outpatient revenue meet the budget for the month? What do you think contributed to this result? Be specific. 3. Did the Total Inpatient expenses meet the budget for the month? What was the expense category that contributed most to this result? Be specific. 4 Did Grayson General have a favorable month? Why or why not? Be specific. 5 For 5 Extra Credit points: What are the break even points for inpatient and outpatient? Outpatient Procedures Outpatient Revenue 1,250 1,000 2501 $293,750 $250,000 $43,750 20.0% 14.9% Total Revenue 1,816,250 1,500,000 316,250 17.4% Operating Expenses Inpatient Labor (fixed costs) 1,350,000 1,225,000 125,000 Inpatient Supplies (variable co $475,000 $500,000 $25,000 Total Inpatient Expenses 1,825,000 1,725,000 100,000 9.3% -5.3% 5.5% Outpatient Labor (fixed costs) $137,500 $150,000 $12,500 Outpatient Supplies (variable($55,000 $50,000 $5,000 Total Outpatient Expenses $192,500 $200,000 - $7,500 -9.1% 9.1% -3.9% Total Operating Expenses 2,017,500|1,925,000 $92,500| 4.6% Net Income/(Loss) $201,250 $425,000 223,750 -111.2% F G . M N 0 Q o R B D E Grayson General Hospital Budget Report Jun-20 Revenue Actual Budget Variance Variance Inpatient stays 2,900 2,500 400 13.8% Inpatient Revenue 1,522,500 1,250,000 272,500 17.9% Please answer the following: 1 Did the inpatient revenue meet the budget for the month? What do you think contributed to this result? Be specific. 2 Did the outpatient revenue meet the budget for the month? What do you think contributed to this result? Be specific. 3. Did the Total Inpatient expenses meet the budget for the month? What was the expense category that contributed most to this result? Be specific. 4 Did Grayson General have a favorable month? Why or why not? Be specific. 5 For 5 Extra Credit points: What are the break even points for inpatient and outpatient? Outpatient Procedures Outpatient Revenue 1,250 1,000 2501 $293,750 $250,000 $43,750 20.0% 14.9% Total Revenue 1,816,250 1,500,000 316,250 17.4% Operating Expenses Inpatient Labor (fixed costs) 1,350,000 1,225,000 125,000 Inpatient Supplies (variable co $475,000 $500,000 $25,000 Total Inpatient Expenses 1,825,000 1,725,000 100,000 9.3% -5.3% 5.5% Outpatient Labor (fixed costs) $137,500 $150,000 $12,500 Outpatient Supplies (variable($55,000 $50,000 $5,000 Total Outpatient Expenses $192,500 $200,000 - $7,500 -9.1% 9.1% -3.9% Total Operating Expenses 2,017,500|1,925,000 $92,500| 4.6% Net Income/(Loss) $201,250 $425,000 223,750 -111.2%
