Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please help me fill the worksheet out Budget vs Actual Worksheet You are responsible for completing a budget for an Ambulatory Clinic. Here are the
please help me fill the worksheet out
Budget vs Actual Worksheet 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. REQUIRED: A. Prepare the budget and the actual on the attached worksheet. AS BUDGETED \begin{tabular}{|l|} \hline Revenue - Inpatient \\ \hline Revenue - Outpatient \\ \hline \end{tabular} \begin{tabular}{|} \hline \\ \hline \end{tabular} Subtotal Excess of Revenue over Expenses ACTUAL \begin{tabular}{|l|} \hline Revenue - Inpatient \\ \hline Revenue - Outpatient \\ \hline \end{tabular} Subtotal \begin{tabular}{|l|} \hline Expenses - Inpatient \\ \hline Expenses - Outpatient \\ \hline \end{tabular} Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started