B28 xfx B C D E F G H 2 Budget vs Actual Worksheet 3 4 in 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 You are responsible for completing a budget for an Ambulatory Clinic. Here are the assumptions: INITIAL BUDGET a. The budget anticipated 40,000 inpatient days this year at an average of $750 per day. b. Inpatient expenses were budgeted at $650 per day. c. The budget anticipated 12,000 outpatient visits this year at an average of $475 revenue per visit. d. Outpatient expenses were budgeted at $420 per visit. ACTUAL RESULTS a. Assume that only 34,800 or 87% of the inpatient days are going to actually be achieved for the year. b. The average revenue of $750 per day will be achieved for these 34,800 inpatient days. c. The Outpatient visits will actually amount to 120% or 13,400 for the year. d. The average revenue of $475 per visit will be achieved for these 13,400 visits. e. Actual inpatient expenses will amount to $13,700,000 and actual outpatient expenses will amount to $4,620,000. 25 REQUIRED: 26 27 28 A. Prepare the budget and the actual on the attached worksheet. BvAStatic Worksheet + Ready