Question

15. You are responsible for completing a budget for an Ambulatory Clinic. Here are the assumptions: INITIAL BUDGET I The budget anticipated 15,000 inpatient days this year at an average of $500 per day. • Inpatient expenses were budgeted at $450 per patient day. The budget anticipated 10,000 outpatient visits this year at an average of $350 revenue per visit. • Outpatient expenses were budgeted at $280 per visit.

Answer 1

X fic Inpatient A B C D E F Inpatient | Outpatient 15,000 10,000 Budgeted Activity a wn Budget Inpatient $ 7,500,000 $ 6,750,000 $ 750,000 Budgeted Revenue less: Budgeted Expenses Budgeted Income Outpatient $ 3,500,000 $ 2,800,000 $ 700,000 Total $ 11,000,000 $9,550,000 $ 1,450,000 000

for formulas and calculations, refer to the image below -

X Inpatient fic В ДА C D E F Inpatient Outpatient 15000 10000 Budgeted Activity Bo00 von A WN Budgeted Revenue less: Budgeted Expenses Budgeted Income Budget Inpatient Outpatient Total =C3*500 =D3*350 =C7+D7 =C3*450 =D3*280 =C8+D8 =C7-C8 =D7-D8 =C9+D9

In case you have any query, kindly ask in comments.