this is all one problem

Analytical worksheet-Question # 3 Budget vs Actual Worksheet 25 POINTS You are responsible for completing a budget for an Ambulatory linic. Here are the assumptions: INITIAL BUDGET a. The budget anticipated 40,000 inpatient da b. Inpatient expenses were budgeted at $650 per day. c. The budget anticipated 12,000 outpatient visits this year at an average of S$475 revenue ys this year at an average of $750 per day. 12 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 19 21 will amount to $4,620,000. 24 REQUIRED: A. Prepare the budget and the actual on the attached worksheet B. Complete a side by side comparison using your results from A above and complete the Static Variances in each category AS BUDGETED Revenue-Inpatient Revenue-Outpatient Subtotal Expenses-Inpatient Expenses-Outpatient Subtota Excess of Revenue over Expenses ACTUAL Revenue Inpatient Revenue Outpatient Subtotal Expenses-Inpatient Expenses-Outpatient Subtotal Excess of Revenue over Expenses BvAStaticWorksheet Excess of Revenue over Expenses STATIC BUDGET VARIANCE BUDGET ACTUAL Revenue Inpatient Revenue - Outpatient Subtotal Expenses Inpatient Expenses-Outpatient Subtotal Excess of Revenue over Expenses BvAStaticWorksheet