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	$	$	$	$

Answer rating: 100% (QA)

ANSWER To find the various financial metrics based on the provided information well perform calculations for Projected FY21 Revenue Expenses and Profi... View the full answer