AutoSave Search CON Assignment - Chapter 15-1 . Protected View Insert Draw Home Page Layout File Formulas Data Review View Help Ena PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. B28 Ex F G H 1 K L M N B C D E Homework Assignment - Chapter 15 2 Budget vs Actual Worksheet 3 4 You are responsible for completing a budget for an Ambulatory clinic. Here are the assumptions: 5 6 7 INITIAL BUDGET 8 9 10 11 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. d. Outpatient expenses were budgeted at $420 per visit. 12 13 15 ACTUAL RESULTS 15 11 18 13 20 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. 22 22 24 25 REQUIRED: 26 A. Prepare the budget and the actual on the attached worksheet. 28 BVAStatic Worksheet Ready Type here to search o Hi Search Assignment - Chapter 15-1 - Protected View AutoSave 4 View Review Help Formulas Data Draw Page Layout File Insert Home O PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protec fx C41 M N . G F B D E AS BUDGETED Revenue - Inpatient Revenue - Outpatient 7 Subtotal 8 3 Expenses - Inpatient Expenses - Outpatient Subtotal 14 Excess of Revenue over Expenses 15 16 ACTUAL 18 IITIT IIT Revenue - Inpatient Revenue - Outpatient 22 23 Subtotal 24 25 Expenses - Inpatient Expenses - Outpatient Subtotal 23 SO Excess of Revenue over Expenses BVAStatic Worksheet Type here to search