Answered step by step
Verified Expert Solution
Question
1 Approved Answer
fill answers in blue part of the Excel sheet begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} hline & A & B & & C & & D & & E &
fill answers in blue part of the Excel sheet
\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline & A & B & & C & & D & & E & F & G \\ \hline 1 & \multicolumn{10}{|c|}{ LIU POST INTERNAL MEDICINE } \\ \hline 2 & \multicolumn{10}{|c|}{ MONTHLY RECAP OF REVENUES \& EXPENDITURES } \\ \hline 3 & \multicolumn{10}{|c|}{2024 Budget Prep } \\ \hline 4 & & & & & & & & & & \\ \hline 5 & & & \multicolumn{6}{|c|}{ Jan - June 2023} & \multirow{2}{*}{\multicolumn{2}{|c|}{\begin{tabular}{r} Annualize your \\ budget for 2023 \\ \end{tabular}}} \\ \hline 6 & & & \multicolumn{2}{|c|}{ ACTUAL } & \multicolumn{2}{|c|}{ BUDGET } & \multicolumn{2}{|c|}{ VARIANCE } & & \\ \hline 9 & Total & Net Patient Revenues & $ & 4,780,000 & $ & 4,600,000 & $ & 180,000 & $ & - \\ \hline \multicolumn{11}{|c|}{10 Other Revenue } \\ \hline 11 & 55330 & Contract Revenue & $ & 2,725 & $ & 2,725 & $ & - & $ & - \\ \hline 12 & \multirow[t]{2}{*}{ Total } & Contracts and Other & $ & 2,725 & $ & 2,725 & $ & - & $ & - \\ \hline 13 & & \multirow[b]{2}{*}{ I Revenues } & & & & & & & & \\ \hline 14 & Total & & $ & 4,782,725 & $ & 4,602,725 & $ & 180,000 & $ & - \\ \hline \multicolumn{11}{|l|}{15} \\ \hline 16 & \multicolumn{10}{|l|}{ EXPENSES } \\ \hline 17 & 60010 & Salaries And Wages Clerical & $ & 586,250 & $ & 575,000 & $ & 11,250 & $ & - \\ \hline 18 & 60015 & Salaries And Wages Nursing & $ & 175,760 & $ & 175,000 & $ & 760 & $ & - \\ \hline 19 & 60020 & Overtime & $ & - & $ & - & $ & - & $ & - \\ \hline 20 & 60050 & Physician Salaries & $ & 1,250,000 & $ & 1,250,000 & $ & - & $ & - \\ \hline 21 & Total & Faculty \& Support Staff Salary & $ & 2,012,010 & $ & 2,000,000 & $ & 12,010 & $ & - \\ \hline \multicolumn{11}{|l|}{22} \\ \hline \multicolumn{11}{|l|}{23} \\ \hline 24 & 63000 & Supplies - Laboratory & $ & 7,250 & $ & 8,000 & $ & (750) & $ & - \\ \hline 25 & 63030 & Supplies - Medical & $ & 18,540 & $ & 15,000 & $ & 3,540 & $ & - \\ \hline 26 & 63080 & Supplies - Surgical & $ & 12,000 & $ & 11,450 & $ & 550 & $ & - \\ \hline 27 & 63300 & Rx - All Other & $ & 19,800 & \$ & 15,000 & $ & 4,800 & $ & - \\ \hline 28 & 64020 & Supplies - Office & $ & 15,000 & $ & 14,350 & $ & 650 & $ & - \\ \hline 29 & 65505 & Equipment Service Contracts & $ & 25,000 & $ & 23,400 & $ & 1,600 & $ & - \\ \hline 30 & 66040 & Rent & $ & 165,000 & $ & 165,000 & $ & - & $ & - \\ \hline 31 & Total & Supplies and Expenses & $ & 262,590 & $ & 252,200 & $ & 10,390 & $ & - \\ \hline \multicolumn{11}{|l|}{32} \\ \hline 33 & 67040 & Medical Malpractice & $ & 98,000 & $ & 98,000 & $ & - & $ & - \\ \hline 34 & Total & Malpractice & $ & 98,000 & $ & 98,000 & $ & - & $ & - \\ \hline \multicolumn{11}{|l|}{35} \\ \hline 36 & 68710 & Affil-Billing \& Collection OH & $ & 119,500 & $ & 105,000 & $ & (14,500) & $ & - \\ \hline 37 & Total & Overhead and Billing & $ & 119,500 & $ & 105,000 & $ & (14,500) & $ & - \\ \hline \multicolumn{11}{|l|}{38} \\ \hline \multicolumn{11}{|l|}{39} \\ \hline 40 & Total & Expenses & $ & 2,492,100 & $ & 2,455,200 & $ & 7,900 & $ & - \\ \hline \multicolumn{11}{|l|}{41} \\ \hline 42 & Net Revenues / Ove & er (Expenditures) & $ & 2,290,625 & $ & 2,147,525 & $ & 172,100 & $ & - \\ \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