Answered step by step
Verified Expert Solution
Question
1 Approved Answer
7:53 AM Mon Oct 23 Project a copy Home 49% Calibri (Body) 11 Page Layout Formulas Data Review View B I SaA0A fx Enter text
7:53 AM Mon Oct 23 Project a copy Home 49% Calibri (Body) 11 Page Layout Formulas Data Review View B I SaA0A fx Enter text or formula here \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline & A & & B & C & D & E & F & G \\ \hline 1 & HOSPITAL INPATIENT P \& L & & 2021 & 2022 & Variance & Variance % & Per DC 2021 & Per DC 2022 \\ \hline 2 & Total Number of Licensed Beds & & 182 & 182 & & & & \\ \hline 3 & Maximum Occupancy & & 68,270 & 68,270 & & & & \\ \hline 4 & Total Patient Days & & 36,520 & 37,001 & & & & \\ \hline 5 & Actual Occupancy \% & & & & & & & \\ \hline 6 & ALOS & & & & & & & \\ \hline 7 & Discharges by Payer & & & & & & & \\ \hline 8 & Medicare & & 3,119 & 3,138 & & & & \\ \hline 9 & Medicaid & & 2,481 & 2,499 & & & & \\ \hline 10 & Commercial Ins & & 1,382 & 1,323 & & & & \\ \hline 11 & Private Pay & & 193 & 176 & & & & \\ \hline 12 & Total Discharges & & & & & & & \\ \hline \multicolumn{9}{|l|}{13} \\ \hline 14 & REVENUE & & & & & & & \\ \hline 15 & Gross Patient Revenue & $ & 254,125,275 & $271,038,548 & & & & \\ \hline 16 & Contract Allowances, Uncollectables & $ & (170,531,434) & $(185,117,531) & & & & \\ \hline 17 & Net Patient Revenue & & & & & & & \\ \hline 18 & Misc Income & $ & 424,313 & 429,015 & & & & \\ \hline 19 & NET REVENUE & & & & & & & \\ \hline \multicolumn{9}{|l|}{20} \\ \hline 21 & Salaries & $ & 23,737,973 & 25,046,456 & & & & \\ \hline 22 & Benefits & $ & 7,121,392 & 7,764,401 & & & & \\ \hline 23 & Contract Labor & $ & 3,146,759 & 2,217,295 & & & & \\ \hline 24 & Physician Contract Services & $ & 7,449,830 & 7,552,691 & & & & \\ \hline 25 & Lab Services & $ & 1,855,017 & 1,793,626 & & & & \\ \hline \end{tabular} 7:52 AM Mon Oct 23 \begin{tabular}{l|l} fx & Enter text or formula here \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & & D & E & F & G & H & I & J & K & L & M \\ \hline 19 & .04,248 & & & & & & & & & & \\ \hline 20 & 17,928 & & & & & & & & & & \\ \hline 21 & 24,592 & & & & & & & 2.7% & Net Op Exp & & \\ \hline 22 & 19,932 & & & & & & & & & & \\ \hline 23 & 9,046 & & & & & & & 2.3% & Net Op Exp & & \\ \hline 24 & 26,411 & & & & & & & & & & \\ \hline 25 & 26,168 & & & & & & & 4.2% & Net Rev & & \\ \hline 26 & 11,529 & & & & & & & & & & \\ \hline 27 & 2,209 & & & & & & & & & & \\ \hline 28 & 4,019 & & & & & & & & & & \\ \hline 29 & 2,692 & & & & & & & & & & \\ \hline 30 & 340,548 & & & & & & & & & & \\ \hline 31 & & & & & & & & 91.0% & \begin{tabular}{|l|} Net \\ Revenue \\ \end{tabular} & & \\ \hline 32 & & & & & & & & & & & \\ \hline 33 & & & & & & & & 9.0% & \begin{tabular}{|l|} Net \\ Revenue \\ \end{tabular} & & \\ \hline 34 & & & & & & & & & & & \\ \hline 35 & & & & & & & & & & & \\ \hline 36 & & & & & & & & & & & \\ \hline 37 & & & & & & & & & & & \\ \hline 38 & & & & & & & & & & & \\ \hline 39 & & & & & & & & & & & \\ \hline 40 & & & & & & & & & & & \\ \hline 41 & & & & & & & & & & & \\ \hline & UCC & MT Proj & F Proj & + & & & & & & & \\ \hline \end{tabular} 7:52 AM Mon Oct 23 Home Insert Draw Page Layout Formulas Data Review view \& \& Calibri (Body) \begin{tabular}{l|l} fx & Enter text or formula here \end{tabular} 7:53 AM Mon Oct 23 Project a copy Home 49% Calibri (Body) \begin{tabular}{l|l} fx & Enter text or formula here \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline & D & E & F & G & H & I & J & K & L & M \\ \hline 21 & & & & & & & 2.7% & \multicolumn{2}{|l|}{ Net Op Exp } & \\ \hline 22 & & & & & & & & & & \\ \hline 23 & & & & & & & 2.3% & \multicolumn{2}{|l|}{ Net Op Exp } & \\ \hline 24 & & & & & & & & & & \\ \hline 25 & & & & & & & 4.2% & Net Rev & & \\ \hline 26 & & & & & & & & & & \\ \hline 27 & & & & & & & & & & \\ \hline 28 & & & & & & & & & & \\ \hline 29 & & & & & & & & & & \\ \hline 30 & & & & & & & & & & \\ \hline 31 & & & & & & & 91.0% & \begin{tabular}{l} Net \\ Revenue \end{tabular} & & \\ \hline 32 & & & & & & & & & & \\ \hline 33 & & & & & & & 9.0% & \begin{tabular}{l} Net \\ Revenue \end{tabular} & & \\ \hline 34 & & & & & & & & & & \\ \hline 35 & & & & & & & & & & \\ \hline 36 & & & & & & & & & & \\ \hline 37 & & & & & & & & & & \\ \hline 38 & & & & & & & & & & \\ \hline 39 & & & & & & & & & & \\ \hline 40 & & & & & & & & & & \\ \hline 41 & & & & & & & & & & \\ \hline 42 & & & & & & & & & & \\ \hline 43 & & & & & & & & & & \\ \hline & UCC & MT Proj & F Proj & + & & & & & & \\ \hline \end{tabular} 7:52 AM Mon Oct 23 Project a copy Home 48% Calibri (Body) 11 B General fx Enter text or formula here \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G & H & I & J & \\ \hline 1 & \begin{tabular}{l} Hospital Owned Urgent Care Center 2 \\ MD's and 1 Nurse Practitioner per day \end{tabular} & 2021 & 2022 & Variance & \begin{tabular}{c} Variance \\ % \\ \end{tabular} & \begin{tabular}{l} Per Visit \\ 2021 \\ \end{tabular} & \begin{tabular}{l} Per Visit \\ 2022 \\ \end{tabular} & \begin{tabular}{c} \% of \\ Revenues \\ 2022 \\ \end{tabular} & \begin{tabular}{|c|} % of \\ Expenses \\ 2022 \\ \end{tabular} & Benchmarks & \\ \hline 2 & Days Practice Open & 252 & 252 & & & & & & & & \\ \hline 3 & Avg Visits/Day per Practitioner & & & & & & & & & 22 & 2 Visits \\ \hline 4 & Office Visits by Payer & & & & & & & & & & \\ \hline 5 & Medicare & 5,880 & 5,765 & & & & & & & & \\ \hline 6 & Medicaid & 2,248 & 2,628 & & & & & & & & \\ \hline 7 & Commercial Ins & 7,725 & 7,249 & & & & & & & & \\ \hline 8 & Private Pay & 252 & 341 & & & & & & & & \\ \hline 9 & Total Office Visits & & & & & & & & & & \\ \hline 10 & Revenues & & & & & & & & & & \\ \hline 11 & Gross Patient Revenues & 2,184,725 & 2,194,816 & & & & & & & & \\ \hline 12 & Total Adjustments to Income & (340,440) & (454,082) & & & & & & & & \\ \hline 13 & Net Patient Revenue & & & & & & & & & $125.00 & \\ \hline 14 & Expenses & & & & & & & & & & \\ \hline 15 & Physician Fees/Bens (F) & 420,376 & 432,770 & & & & & & & & \\ \hline 16 & Nurse Practitioner Fees/Bens (F) & 157,529 & 156,127 & & & & & & & & \\ \hline 17 & Clinical Staff Salaries (60%V;40%F) & 231,175 & 243,448 & & & & & & & 40% & 6Ne \\ \hline 18 & Staff Benefits (V) & 185,502 & 193,389 & & & & & & & & \\ \hline 19 & Contract Services (V) & 102,642 & 104,248 & & & & & & & & \\ \hline 20 & Van(F) & 19,141 & 17,928 & & & & & & & & \\ \hline 21 & Medical Supplies (V) & 23,983 & 24,592 & & & & & & & 2.7% & Net \\ \hline 22 & Office Supplies/Printing/Postage (V) & 20,109 & 19,932 & & & & & & & & \\ \hline 23 & Ancillary Services (V) & 10,945 & 9,046 & & & & & & & 2.3% & 0 Net \\ \hline \end{tabular} 7:53 AM Mon Oct 23 Project a copy Home 49% Calibri (Body) 11 Page Layout Formulas Data Review View B I SaA0 fx Enter text or formula here \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline & A & & B & C & D & E & F & G & H \\ \hline 13 & & & & & & & & & \\ \hline 14 & REVENUE & & & & & & & & \\ \hline 15 & Gross Patient Revenue & $ & 254,125,275 & $271,038,548 & & & & & \\ \hline 16 & Contract Allowances, Uncollectables & $ & (170,531,434) & $(185,117,531) & & & & & \\ \hline 17 & Net Patient Revenue & & & & & & & & \\ \hline 18 & Misc Income & $ & 424,313 & 429,015 & & & & & \\ \hline 19 & NET REVENUE & & & & & & & & \\ \hline 21 & Salaries & $ & 23,737,973 & 25,046,456 & & & & & \\ \hline 22 & Benefits & $ & 7,121,392 & 7,764,401 & & & & & \\ \hline 23 & Contract Labor & $ & 3,146,759 & 2,217,295 & & & & & \\ \hline 24 & Physician Contract Services & $ & 7,449,830 & 7,552,691 & & & & & \\ \hline 25 & Lab Services & $ & 1,855,017 & 1,793,626 & & & & & \\ \hline 26 & Radiology Services & $ & 2,700,727 & 2,723,959 & & & & & \\ \hline 27 & Rehabilitation Services & $ & 798,151 & 806,552 & & & & & \\ \hline 30 & Cost of Food & $ & 672,441 & 708,124 & & & & & \\ \hline 31 & Patient Transportation & $ & 147,531 & 149,761 & & & & & \\ \hline 32 & Total Patient Care Expenses & & & & & & & & \\ \hline \multicolumn{10}{|l|}{33} \\ \hline 34 & General and Administrative Expenses & & & & & & & & \\ \hline 35 & Salaries & $ & 9,734,850 & 10,124,719 & & & & & \\ \hline 36 & Benefits & $ & 2,920,455 & 3,138,663 & & & & & \\ \hline 37 & Contract Labor & $ & 174,585 & 158,884 & & & & & \\ \hline \multirow[t]{2}{*}{38} & \multirow{2}{*}{\begin{tabular}{l} Purrhaced Servires \\ UCC MT Proj \end{tabular}} & & 1571597 & 1678185 & & & & & \\ \hline & & - & & & & & & & \\ \hline \end{tabular} 7:53 AM Mon Oct 23 Project a copy Home 49% Calibri (Body) 11 Page Layout Formulas Data Review View B I SaA0A fx Enter text or formula here \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline & A & & B & C & D & E & F & G \\ \hline 1 & HOSPITAL INPATIENT P \& L & & 2021 & 2022 & Variance & Variance % & Per DC 2021 & Per DC 2022 \\ \hline 2 & Total Number of Licensed Beds & & 182 & 182 & & & & \\ \hline 3 & Maximum Occupancy & & 68,270 & 68,270 & & & & \\ \hline 4 & Total Patient Days & & 36,520 & 37,001 & & & & \\ \hline 5 & Actual Occupancy \% & & & & & & & \\ \hline 6 & ALOS & & & & & & & \\ \hline 7 & Discharges by Payer & & & & & & & \\ \hline 8 & Medicare & & 3,119 & 3,138 & & & & \\ \hline 9 & Medicaid & & 2,481 & 2,499 & & & & \\ \hline 10 & Commercial Ins & & 1,382 & 1,323 & & & & \\ \hline 11 & Private Pay & & 193 & 176 & & & & \\ \hline 12 & Total Discharges & & & & & & & \\ \hline \multicolumn{9}{|l|}{13} \\ \hline 14 & REVENUE & & & & & & & \\ \hline 15 & Gross Patient Revenue & $ & 254,125,275 & $271,038,548 & & & & \\ \hline 16 & Contract Allowances, Uncollectables & $ & (170,531,434) & $(185,117,531) & & & & \\ \hline 17 & Net Patient Revenue & & & & & & & \\ \hline 18 & Misc Income & $ & 424,313 & 429,015 & & & & \\ \hline 19 & NET REVENUE & & & & & & & \\ \hline \multicolumn{9}{|l|}{20} \\ \hline 21 & Salaries & $ & 23,737,973 & 25,046,456 & & & & \\ \hline 22 & Benefits & $ & 7,121,392 & 7,764,401 & & & & \\ \hline 23 & Contract Labor & $ & 3,146,759 & 2,217,295 & & & & \\ \hline 24 & Physician Contract Services & $ & 7,449,830 & 7,552,691 & & & & \\ \hline 25 & Lab Services & $ & 1,855,017 & 1,793,626 & & & & \\ \hline \end{tabular} 7:52 AM Mon Oct 23 \begin{tabular}{l|l} fx & Enter text or formula here \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & & D & E & F & G & H & I & J & K & L & M \\ \hline 19 & .04,248 & & & & & & & & & & \\ \hline 20 & 17,928 & & & & & & & & & & \\ \hline 21 & 24,592 & & & & & & & 2.7% & Net Op Exp & & \\ \hline 22 & 19,932 & & & & & & & & & & \\ \hline 23 & 9,046 & & & & & & & 2.3% & Net Op Exp & & \\ \hline 24 & 26,411 & & & & & & & & & & \\ \hline 25 & 26,168 & & & & & & & 4.2% & Net Rev & & \\ \hline 26 & 11,529 & & & & & & & & & & \\ \hline 27 & 2,209 & & & & & & & & & & \\ \hline 28 & 4,019 & & & & & & & & & & \\ \hline 29 & 2,692 & & & & & & & & & & \\ \hline 30 & 340,548 & & & & & & & & & & \\ \hline 31 & & & & & & & & 91.0% & \begin{tabular}{|l|} Net \\ Revenue \\ \end{tabular} & & \\ \hline 32 & & & & & & & & & & & \\ \hline 33 & & & & & & & & 9.0% & \begin{tabular}{|l|} Net \\ Revenue \\ \end{tabular} & & \\ \hline 34 & & & & & & & & & & & \\ \hline 35 & & & & & & & & & & & \\ \hline 36 & & & & & & & & & & & \\ \hline 37 & & & & & & & & & & & \\ \hline 38 & & & & & & & & & & & \\ \hline 39 & & & & & & & & & & & \\ \hline 40 & & & & & & & & & & & \\ \hline 41 & & & & & & & & & & & \\ \hline & UCC & MT Proj & F Proj & + & & & & & & & \\ \hline \end{tabular} 7:52 AM Mon Oct 23 Home Insert Draw Page Layout Formulas Data Review view \& \& Calibri (Body) \begin{tabular}{l|l} fx & Enter text or formula here \end{tabular} 7:53 AM Mon Oct 23 Project a copy Home 49% Calibri (Body) \begin{tabular}{l|l} fx & Enter text or formula here \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline & D & E & F & G & H & I & J & K & L & M \\ \hline 21 & & & & & & & 2.7% & \multicolumn{2}{|l|}{ Net Op Exp } & \\ \hline 22 & & & & & & & & & & \\ \hline 23 & & & & & & & 2.3% & \multicolumn{2}{|l|}{ Net Op Exp } & \\ \hline 24 & & & & & & & & & & \\ \hline 25 & & & & & & & 4.2% & Net Rev & & \\ \hline 26 & & & & & & & & & & \\ \hline 27 & & & & & & & & & & \\ \hline 28 & & & & & & & & & & \\ \hline 29 & & & & & & & & & & \\ \hline 30 & & & & & & & & & & \\ \hline 31 & & & & & & & 91.0% & \begin{tabular}{l} Net \\ Revenue \end{tabular} & & \\ \hline 32 & & & & & & & & & & \\ \hline 33 & & & & & & & 9.0% & \begin{tabular}{l} Net \\ Revenue \end{tabular} & & \\ \hline 34 & & & & & & & & & & \\ \hline 35 & & & & & & & & & & \\ \hline 36 & & & & & & & & & & \\ \hline 37 & & & & & & & & & & \\ \hline 38 & & & & & & & & & & \\ \hline 39 & & & & & & & & & & \\ \hline 40 & & & & & & & & & & \\ \hline 41 & & & & & & & & & & \\ \hline 42 & & & & & & & & & & \\ \hline 43 & & & & & & & & & & \\ \hline & UCC & MT Proj & F Proj & + & & & & & & \\ \hline \end{tabular} 7:52 AM Mon Oct 23 Project a copy Home 48% Calibri (Body) 11 B General fx Enter text or formula here \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G & H & I & J & \\ \hline 1 & \begin{tabular}{l} Hospital Owned Urgent Care Center 2 \\ MD's and 1 Nurse Practitioner per day \end{tabular} & 2021 & 2022 & Variance & \begin{tabular}{c} Variance \\ % \\ \end{tabular} & \begin{tabular}{l} Per Visit \\ 2021 \\ \end{tabular} & \begin{tabular}{l} Per Visit \\ 2022 \\ \end{tabular} & \begin{tabular}{c} \% of \\ Revenues \\ 2022 \\ \end{tabular} & \begin{tabular}{|c|} % of \\ Expenses \\ 2022 \\ \end{tabular} & Benchmarks & \\ \hline 2 & Days Practice Open & 252 & 252 & & & & & & & & \\ \hline 3 & Avg Visits/Day per Practitioner & & & & & & & & & 22 & 2 Visits \\ \hline 4 & Office Visits by Payer & & & & & & & & & & \\ \hline 5 & Medicare & 5,880 & 5,765 & & & & & & & & \\ \hline 6 & Medicaid & 2,248 & 2,628 & & & & & & & & \\ \hline 7 & Commercial Ins & 7,725 & 7,249 & & & & & & & & \\ \hline 8 & Private Pay & 252 & 341 & & & & & & & & \\ \hline 9 & Total Office Visits & & & & & & & & & & \\ \hline 10 & Revenues & & & & & & & & & & \\ \hline 11 & Gross Patient Revenues & 2,184,725 & 2,194,816 & & & & & & & & \\ \hline 12 & Total Adjustments to Income & (340,440) & (454,082) & & & & & & & & \\ \hline 13 & Net Patient Revenue & & & & & & & & & $125.00 & \\ \hline 14 & Expenses & & & & & & & & & & \\ \hline 15 & Physician Fees/Bens (F) & 420,376 & 432,770 & & & & & & & & \\ \hline 16 & Nurse Practitioner Fees/Bens (F) & 157,529 & 156,127 & & & & & & & & \\ \hline 17 & Clinical Staff Salaries (60%V;40%F) & 231,175 & 243,448 & & & & & & & 40% & 6Ne \\ \hline 18 & Staff Benefits (V) & 185,502 & 193,389 & & & & & & & & \\ \hline 19 & Contract Services (V) & 102,642 & 104,248 & & & & & & & & \\ \hline 20 & Van(F) & 19,141 & 17,928 & & & & & & & & \\ \hline 21 & Medical Supplies (V) & 23,983 & 24,592 & & & & & & & 2.7% & Net \\ \hline 22 & Office Supplies/Printing/Postage (V) & 20,109 & 19,932 & & & & & & & & \\ \hline 23 & Ancillary Services (V) & 10,945 & 9,046 & & & & & & & 2.3% & 0 Net \\ \hline \end{tabular} 7:53 AM Mon Oct 23 Project a copy Home 49% Calibri (Body) 11 Page Layout Formulas Data Review View B I SaA0 fx Enter text or formula here \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline & A & & B & C & D & E & F & G & H \\ \hline 13 & & & & & & & & & \\ \hline 14 & REVENUE & & & & & & & & \\ \hline 15 & Gross Patient Revenue & $ & 254,125,275 & $271,038,548 & & & & & \\ \hline 16 & Contract Allowances, Uncollectables & $ & (170,531,434) & $(185,117,531) & & & & & \\ \hline 17 & Net Patient Revenue & & & & & & & & \\ \hline 18 & Misc Income & $ & 424,313 & 429,015 & & & & & \\ \hline 19 & NET REVENUE & & & & & & & & \\ \hline 21 & Salaries & $ & 23,737,973 & 25,046,456 & & & & & \\ \hline 22 & Benefits & $ & 7,121,392 & 7,764,401 & & & & & \\ \hline 23 & Contract Labor & $ & 3,146,759 & 2,217,295 & & & & & \\ \hline 24 & Physician Contract Services & $ & 7,449,830 & 7,552,691 & & & & & \\ \hline 25 & Lab Services & $ & 1,855,017 & 1,793,626 & & & & & \\ \hline 26 & Radiology Services & $ & 2,700,727 & 2,723,959 & & & & & \\ \hline 27 & Rehabilitation Services & $ & 798,151 & 806,552 & & & & & \\ \hline 30 & Cost of Food & $ & 672,441 & 708,124 & & & & & \\ \hline 31 & Patient Transportation & $ & 147,531 & 149,761 & & & & & \\ \hline 32 & Total Patient Care Expenses & & & & & & & & \\ \hline \multicolumn{10}{|l|}{33} \\ \hline 34 & General and Administrative Expenses & & & & & & & & \\ \hline 35 & Salaries & $ & 9,734,850 & 10,124,719 & & & & & \\ \hline 36 & Benefits & $ & 2,920,455 & 3,138,663 & & & & & \\ \hline 37 & Contract Labor & $ & 174,585 & 158,884 & & & & & \\ \hline \multirow[t]{2}{*}{38} & \multirow{2}{*}{\begin{tabular}{l} Purrhaced Servires \\ UCC MT Proj \end{tabular}} & & 1571597 & 1678185 & & & & & \\ \hline & & - & & & & & & & \\ \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