Question
Jiranna Healthcare Expenses Worksheet, Mid-Year Review Outpatient Outpatient Product Line Unit Expense (FY20) Actual Units (FY20) Total OP Expenses (FY20) Unit Forecast (FY21) Unit Expence
| Jiranna Healthcare Expenses Worksheet, Mid-Year Review | ||||||||
| Outpatient | ||||||||
| Outpatient Product Line | Unit Expense (FY20) | Actual Units (FY20) | Total OP Expenses (FY20) | Unit Forecast (FY21) | Unit Expence (Budget FY21) | FY21 Budget (FY20+6% Inflation) | Acutal Mid Year Units (FY21) | Actual OP Expenses (FY21 YTD) |
| CARDIOLOGY | $ 5,478.81 | 645 | $ 3,533,832 | 677 | $5,807.54 | $ 3,931,704 | 197 | $ 1,144,085 |
| ENDOCRINOLOYGY | $ 5,478.81 | 217 | $ 1,188,902 | 228 | $5,807.54 | $ 1,324,119 | 112 | $ 650,444 |
| FAMILY MED | $ 5,476.81 | 1,105 | $ 6,051,875 | 1,161 | $5,802.92 | $ 6,737,188 | 636 | $ 3,690,656 |
| GYN | $ 5,478.81 | 208 | $ 1,139,592 | 219 | $5,794.28 | $ 1,268,947 | 116 | $ 672,136 |
| ENT | $ 5,475.81 | 690 | $ 3,778,309 | 724 | $5,804.36 | $ 4,202,356 | 421 | $ 2,443,635 |
| MENTAL HEALTH | $ 498.78 | 1,287 | $ 641,930 | 1,351 | $528.71 | $ 714,283 | 736 | $ 389,128 |
| NEWBORN | $ 5,478.81 | 698 | $ 3,824,209 | 733 | $5,807.54 | $ 4,256,926 | 433 | $ 2,514,664 |
| OB | $ 5,478.81 | 1,430 | $ 7,834,698 | 1,501 | $5,807.54 | $ 8,717,115 | 868 | $ 5,040,943 |
| ORTHO | $ 5,478.81 | 601 | $ 3,292,765 | 631 | $5,807.54 | $ 3,664,557 | 274 | $ 1,591,266 |
| PEDIATRICS | $ 5,477.81 | 124 | $ 679,248 | 130 | $5,806.48 | $ 754,842 | 72 | $ 418,066 |
| PODIATRY | $ 5,478.81 | 2,050 | $ 11,231,561 | 2,152 | $5,807.54 | $ 12,497,823 | 800 | $ 4,646,031 |
| Total Expenses | $55,281 | 9,055 | $43,196,921 | 9,507 | $58,582 | $48,069,860 | 4,665 | $23,201,056 |
| Jiranna Healthcare Revenues Worksheet, Mid-Year Review | ||||||||
| Outpatient | ||||||||
| Outpatient Product Line | Unit Price (FY20) | Actual Units (FY20) | Total OP Revenue (FY20) | Unit Forecasted For (FY21) | Unit Price (Budget FY21) | Projected OP Revenue For FY21 | Actual Units (FY21 YTD) | Actual OP Revenue (FY21 YTD) |
| CARDIOLOGY | $ 6,118.73 | 645 | $ 3,946,580.85 | 677 | $6,118.73 | $ 4,142,380 | 197 | $ 1,205,390 |
| ENDOCRINOLOYGY | $ 6,103.65 | 217 | $ 1,324,492.05 | 228 | $6,103.65 | $ 1,391,632 | 112 | $ 683,609 |
| FAMILY MED | $ 6,021.65 | 1,105 | $ 6,653,923.25 | 1,161 | $6,019.06 | $ 6,988,125 | 636 | $ 3,828,120 |
| GYN | $ 6,013.65 | 208 | $ 1,250,839.20 | 219 | $5,999.92 | $ 1,313,983 | 116 | $ 695,991 |
| ENT | $ 6,010.65 | 690 | $ 4,147,348.50 | 724 | $6,010.65 | $ 4,351,711 | 421 | $ 2,530,484 |
| MENTAL HEALTH | $ 502.99 | 1,287 | $ 647,348.13 | 1,351 | $502.99 | $ 679,539 | 736 | $ 370,200 |
| NEWBORN | $ 7,014.71 | 698 | $ 4,896,267.58 | 733 | $7,014.71 | $ 5,141,782 | 433 | $ 3,037,369 |
| OB | $ 5,713.65 | 1,430 | $ 8,170,519.50 | 1,501 | $5,713.65 | $ 8,576,189 | 868 | $ 4,959,448 |
| ORTHO | $ 6,084.18 | 601 | $ 3,656,592.18 | 631 | $6,084.18 | $ 3,839,118 | 274 | $ 1,667,066 |
| PEDIATRICS | $ 6,001.65 | 124 | $ 744,204.60 | 130 | $6,001.65 | $ 780,215 | 72 | $ 432,119 |
| PODIATRY | $ 6,018.14 | 2,050 | $ 12,337,187.00 | 2,152 | $6,018.14 | $ 12,951,037 | 800 | $ 4,814,512 |
| Total Revenue | $61,604 | 9,055 | $47,775,303 | 9,507 | $61,587 | $50,155,711 | 4,665 | $24,224,308 |
How do you find the Projected FY21 Revenue, Expenses, and Profit based on the above information?
How do you find the Projected (mid-year) Projection Revenue, Expenses, and Profit based on the above information?
How do you find the Actual (mid-year) Projection Revenue, Expenses, and Profit based on the above information?
How do you find the Revised FY21 Projection Revenue, Expenses, and Profit based on the above information?
| Jiranna Healthcare | ||||
| Projected Profit | ||||
| Projected (FY21) | Projected (mid-year) | Actual (mid-year) | Revised FY21 Projection | |
| Revenue | ||||
| Expenses | ||||
| Profit | $ | $ | $ | $ |
Step by Step Solution
3.45 Rating (164 Votes )
There are 3 Steps involved in it
Step: 1
lets break down each question and provide detailed solutions for finding Projected FY21 Revenue Expenses and Profit Projected midyear Projection Reven...
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
Financial Reporting Financial Statement Analysis And Valuation A Strategic Perspective
Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
9th Edition
1337614689, 1337614688, 9781337668262, 978-1337614689
