Background:NorthStar’s Chief Financial Officer has asked you to evaluate the performance of one of...

Question

Background:NorthStar’s Chief Financial Officer has asked you to evaluate the performance of one of its business units, Alphabet Anesthesia. The business unit has two facilities: ABC Regional Hospital and XYZ Memorial Hospital. The CFO would like a pro-forma P&L and an executive summary highlighting important insights. The practice has provided financial data from the past year of operations, including all details for revenue and expenses.Assignment:1) Using the prior-year data provided, create a pro-forma P&L in Excel. The CFO has provided the format and Q1 data in the chart below (P&L template also included in the financial data). Assume Overhead Expense is 5% of Total Direct Expense. Complete the remaining quarters to arrive at the full year total.2) As you review the data presented, you anticipate the CFO will have some specific questions related to performance in Q4 when compared to Q3. Prepare answers for the following questions:a. Is the change in revenue performance being driven by volume or rate?b. What payors (“carrier type”) may be causing this change in revenue performance?c. What are other key drivers lowering EBITDA margins?d. Are there any significant differences in the performance of ABC Regional Hospital and XYZMemorial Hospital?3) Summarize your findings from this assignment in an executive summary in Word or PowerPoint. Include the answers for questions one and two. Be sure to reference tables or graphs that you prepare to support your analysis.P&L Template 	Accounts	Q1	Q2	Q3	Q4	FY 2021 	Net Revenue	$   5,827,312				$   5,827,312 	MD Expenses	$   1,872,473				$   1,872,473 	CRNA Expenses	$   2,322,791				$   2,322,791 	Practice Expenses	$   64,420				$   64,420 	Total Direct Expenses	$   4,259,683				$   4,259,683 	Overhead Expense	$   212,984				$   212,984 	Total Expense	$   4,472,667				$   4,472,667 	EBITDA	$   1,354,645				$   1,354,645 	EBITDA %	23.2%				23.2% Practice Revenue 	Facility	TransChgCodeDetailUID	YRMO	Calculation_Category	ServDate	CarrierType	Carrier	Gross Chgs	Adjs	Net Revenue	TotBilledUnits	IsCareTeam	CPTCode 	ABC Regional Hospital	2250949	202101	ZBA	1/3/21	Aetna	AETNA HMO	1312.00	983.5	328.5	8	CRNA Only	43239 	ABC Regional Hospital	2251236	202101	ZBA	1/4/21	Aetna	AETNA HMO	1148.00	0	1148	7	CRNA Only	52005 	ABC Regional Hospital	2251597	202101	ZBA	1/4/21	Aetna	AETNA HMO	1640.00	1471.82	168.18	10	CRNA Only	01967 	ABC Regional Hospital	2255443	202101	ZBA	1/6/21	Aetna	MERITAIN HEALTH	2624.00	816	1808	16	CRNA Only	72142 	ABC Regional Hospital	2259276	202101	ZBA	1/15/21	Aetna	AETNA HMO	3613.00	2927.3	685.7	22	CRNA Only	36224 	ABC Regional Hospital	2273591	202101	ZBA	1/18/21	Aetna	AETNA HMO	1312.00	829.6	482.4	8	CRNA Only	43239 	ABC Regional Hospital	2273973	202101	ZBA	1/19/21	Aetna	AETNA HMO	984.00	723	261	6	CRNA Only	11982 	ABC Regional Hospital	2275888	202101	ZBA	1/21/21	Aetna	AETNA HMO	495.00	440.29	54.71	3	CRNA Only	36620 	ABC Regional Hospital	2278761	202101	ZBA	1/23/21	Aetna	AETNA HMO	4920.00	3583.5	1336.5	30	CRNA Only	22610 	ABC Regional Hospital	2279448	202101	ZBA	1/24/21	Aetna	AETNA HMO	1312.00	1113.37	198.63	8	CRNA Only	01967 	ABC Regional Hospital	2266967	202101	ZBA	1/16/21	Aetna	AETNA HMO	2624.00	1940	684	16	CRNA Only	47562 	ABC Regional Hospital	2311575	202101	ZBA	1/27/21	Aetna	AETNA HMO	1148.00	914	234	7	CRNA Only	10060 	ABC Regional Hospital	2243380	202101	ZBA	1/3/21	Aetna	AETNA HMO	2624.00	0	2624	16	CRNA Only	27447 	ABC Regional Hospital	2243411	202101	ZBA	1/3/21	Aetna	AETNA HMO	1148.00	851	297	7	CRNA Only	57522 	ABC Regional Hospital	2267518	202101	ZBA	1/9/21	Aetna	AETNA HMO	1804.00	1349.5	454.5	11	CRNA Only	93312 	ABC Regional Hospital	2276693	202101	ZBA	1/20/21	Aetna	AETNA HMO	1804.00	1804	0	11	CRNA Only	52352 	ABC Regional Hospital	2299298	202101	ZBA	1/27/21	Aetna	AETNA HMO	1804.00	1313.5	490.5	11	CRNA Only	45378 	ABC Regional Hospital	2299384	202101	ZBA	1/30/21	Aetna	AETNA HMO	1148.00	833	315	7	CRNA Only	43239 	ABC Regional Hospital	2262929	202101	ZBA	1/10/21	Aetna	AETNA HMO	1640.00	-662.97	2302.97	10	CRNA Only	45378 	ABC Regional Hospital	2263089	202101	ZBA	1/11/21	Aetna	AETNA HMO	1312.00	0	1312	8	CRNA Only	43235 	ABC Regional Hospital	2264839	202101	ZBA	1/12/21	Aetna	AETNA HMO	2624.00	1913	711	16	CRNA Only	47562 	ABC Regional Hospital	2265000	202101	ZBA	1/12/21	Aetna	AETNA HMO	1148.00	846.5	301.5	7	CRNA Only	45380 	ABC Regional Hospital	2265279	202101	ZBA	1/13/21	Aetna	AETNA HMO	1804.00	1322.5	481.5	11	CRNA Only	27385 	ABC Regional Hospital	2265290	202101	ZBA	1/13/21	Aetna	AETNA HMO	1485.00	1360.34	124.66	3	CRNA Only	64447 	ABC Regional Hospital	2265347	202101	ZBA	1/14/21	Aetna	AETNA HMO	330.00	0	330	2	CRNA Only	99231 	ABC Regional Hospital	2266114	202101	ZBA	1/16/21	Aetna	AETNA HMO	1476.00	1093.5	382.5	9	CRNA Only	45378 	ABC Regional Hospital	2277426	202101	ZBA	1/20/21	Aetna	AETNA HMO	2460.00	123	2337	15	CRNA Only	29827 	ABC Regional Hospital	2277433	202101	ZBA	1/20/21	Aetna	AETNA HMO	1650.00	0	1650	3	CRNA Only	64415 	ABC Regional Hospital	2277499	202101	ZBA	1/23/21	Aetna	AETNA HMO	6105.00	5604	501	40	CRNA Only	01967 	ABC Regional Hospital	2289075	202101	ZBA	1/25/21	Aetna	AETNA HMO	3772.00	3403	369	23	CRNA Only	01967 	ABC Regional Hospital	2300649	202101	ZBA	1/27/21	Aetna	AETNA HMO	1312.00	988	324	8	CRNA Only	46255 	ABC Regional Hospital	2300740	202101	ZBA	1/30/21	Aetna	AETNA HMO	1312.00	1188.34	123.66	8	CRNA Only	64718 	ABC Regional Hospital	2300867	202101	ZBA	1/30/21	Aetna	AETNA HMO	1312.00	0	1312	8	CRNA Only	45378 	ABC Regional Hospital	2300958	202101	ZBA	1/30/21	Aetna	AETNA HMO	1148.00	996.8	151.2	7	CRNA Only	43239 	ABC Regional Hospital	2301178	202101	ZBA	1/31/21	Aetna	AETNA HMO	1148.00	0	1148	7	CRNA Only	43239 	XYZ Memorial Hospital	2242013	202101	ZBA	1/2/21	Aetna	AETNA US HEALTHCARE	2460.00	660	1800	15	CRNA Only	01967 	XYZ Memorial Hospital	2242063	202101	ZBA	1/2/21	Aetna	AETNA US HEALTHCARE	2788.00	1156	1632	17	CRNA Only	01967 	XYZ Memorial Hospital	2245826	202101	ZBA	1/3/21	Aetna	AETNA US HEALTHCARE	1804.00	484	1320	11	CRNA Only	58662 	XYZ Memorial Hospital	2245862	202101	ZBA	1/3/21	Aetna	AETNA US HEALTHCARE	1312.00	976	336	8	CRNA Only	59820 	XYZ Memorial Hospital	2246010	202101	ZBA	1/3/21	Aetna	AETNA US HEALTHCARE	1312.00	1013.8	298.2	8	CRNA Only	01967 	XYZ Memorial Hospital	2246154	202101	ZBA	1/4/21	Aetna	AETNA US HEALTHCARE	6105.00	5420.4	684.6	39	CRNA Only	01967 	XYZ Memorial Hospital	2246472	202101	ZBA	1/5/21	Aetna	AETNA US HEALTHCARE	6105.00	1497	4608	48	CRNA Only	01967 	XYZ Memorial Hospital	2246522	202101	ZBA	1/5/21	Aetna	AETNA US HEALTHCARE	1476.00	396	1080	9	CRNA Only	01967 	XYZ Memorial Hospital	2246595	202101	ZBA	1/5/21	Aetna	AETNA US HEALTHCARE	1476.00	396	1080	9	CRNA Only	01967 	XYZ Memorial Hospital	2246753	202101	ZBA	1/5/21	Aetna	AETNA US HEALTHCARE	6105.00	5328	777	48	CRNA Only	01967 	XYZ Memorial Hospital	2254752	202101	ZBA	1/9/21	Aetna	AETNA	6105.00	1425	4680	39	CRNA Only	01967 	XYZ Memorial Hospital	2255709	202101	ZBA	1/11/21	Aetna	AETNA US HEALTHCARE	4756.00	4285.6	470.4	29	CRNA Only	01967 	XYZ Memorial Hospital	2255821	202101	ZBA	1/11/21	Aetna	AETNA US HEALTHCARE	3116.00	1514	1602	19	CRNA Only	01967 	XYZ Memorial Hospital	2256761	202101	ZBA	1/12/21	Aetna	AETNA US HEALTHCARE	3772.00	1012	2760	23	CRNA Only	01967 	XYZ Memorial Hospital	2257142	202101	ZBA	1/12/21	Aetna	AETNA US HEALTHCARE	5740.00	2590	3150	35	CRNA Only	01967 	XYZ Memorial Hospital	2257183	202101	ZBA	1/12/21	Aetna	AETNA US HEALTHCARE	6105.00	5273.6	831.4	44	CRNA Only	01967 	XYZ Memorial Hospital	2258630	202101	ZBA	1/14/21	Aetna	AETNA US HEALTHCARE	6105.00	5810.4	294.6	41	CRNA Only	01967 	XYZ Memorial Hospital	2259036	202101	ZBA	1/13/21	Aetna	AETNA US HEALTHCARE	2132.00	1752.74	379.26	13	CRNA Only	58660 	XYZ Memorial Hospital	2259130	202101	ZBA	1/13/21	Aetna	AETNA US HEALTHCARE	2624.00	896	1728	16	CRNA Only	01967 	XYZ Memorial Hospital	2259149	202101	ZBA	1/13/21	Aetna	AETNA US HEALTHCARE	4920.00	1320	3600	30	CRNA Only	01967 	XYZ Memorial Hospital	2259162	202101	ZBA	1/13/21	Aetna	AETNA US HEALTHCARE	6105.00	1545	4560	38	CRNA Only	01967 	XYZ Memorial Hospital	2267655	202101	ZBA	1/17/21	Aetna	AETNA US HEALTHCARE	2460.00	660	1800	15	CRNA Only	58262 	XYZ Memorial Hospital	2267700	202101	ZBA	1/17/21	Aetna	AETNA US HEALTHCARE	2460.00	2027.4	432.6	15	CRNA Only	01967 	XYZ Memorial Hospital	2267814	202101	ZBA	1/17/21	Aetna	AETNA US HEALTHCARE	4428.00	1188	3240	27	CRNA Only	01967 	XYZ Memorial Hospital	2267891	202101	ZBA	1/17/21	Aetna	AETNA US HEALTHCARE	3936.00	3406.8	529.2	24	CRNA Only	01967 	XYZ Memorial Hospital	2268882	202101	ZBA	1/16/21	Aetna	AETNA US HEALTHCARE	4264.00	0	4264	26	CRNA Only	19364 	XYZ Memorial Hospital	2268891	202101	ZBA	1/16/21	Aetna	AETNA US HEALTHCARE	2460.00	660	1800	15	CRNA Only	57288 	XYZ Memorial Hospital	2276772	202101	ZBA	1/20/21	Aetna	AETNA	3608.00	1628	1980	22	CRNA Only	01967 	XYZ Memorial Hospital	2279092	202101	ZBA	1/23/21	Aetna	AETNA US HEALTHCARE	2132.00	884	1248	13	CRNA Only	58552 	XYZ Memorial Hospital	2279167	202101	ZBA	1/23/21	Aetna	AETNA US HEALTHCARE	6105.00	0	6105	63	CRNA Only	01967 	XYZ Memorial Hospital	2279347	202101	ZBA	1/23/21	Aetna	AETNA US HEALTHCARE	2132.00	859	1273	13	CRNA Only	01967 	XYZ Memorial Hospital	2279546	202101	ZBA	1/24/21	Aetna	AETNA US HEALTHCARE	5251.00	2392.26	2858.74	32	CRNA Only	19302 	XYZ Memorial Hospital	2284236	202101	ZBA	1/26/21	Aetna	AETNA US HEALTHCARE	3608.00	968	2640	22	CRNA Only	19303 	XYZ Memorial Hospital	2296756	202101	ZBA	1/30/21	Aetna	AETNA US HEALTHCARE	1804.00	484	1320	11	CRNA Only	58661 	XYZ Memorial Hospital	2296933	202101	ZBA	1/31/21	Aetna	AETNA US HEALTHCARE	1148.00	308	840	7	CRNA Only	36590 	XYZ Memorial Hospital	2296993	202101	ZBA	1/31/21	Aetna	AETNA	2624.00	1088	1536	16	CRNA Only	58552 	XYZ Memorial Hospital	2296997	202101	ZBA	1/31/21	Aetna	AETNA US HEALTHCARE	2132.00	884	1248	13	CRNA Only	58552 	XYZ Memorial Hospital	2243314	202101	ZBA	1/5/21	Aetna	AETNA US HEALTHCARE	2296.00	1542.5	753.5	14	CRNA Only	49587 	XYZ Memorial Hospital	2243718	202101	ZBA	1/5/21	Aetna	AETNA US HEALTHCARE	1312.00	1018.2	293.8	8	CRNA Only	43239 	XYZ Memorial Hospital	2247010	202101	ZBA	1/9/21	Aetna	AETNA US HEALTHCARE	1312.00	485.64	826.36	8	CRNA Only	45346 	XYZ Memorial Hospital	2247306	202101	ZBA	1/6/21	Aetna	AETNA US HEALTHCARE	2624.00	704	1920	16	CRNA Only	38525 	XYZ Memorial Hospital	2247520	202101	ZBA	1/6/21	Aetna	AETNA US HEALTHCARE	1312.00	1312	0	8	CRNA Only	43239 	XYZ Memorial Hospital	2247553	202101	ZBA	1/6/21	Aetna	AETNA US HEALTHCARE	1312.00	1053.28	258.72	8	CRNA Only	43235 	XYZ Memorial Hospital	2250768	202101	ZBA	1/10/21	Aetna	AETNA US HEALTHCARE	1148.00	854	294	7	CRNA Only	52281 	XYZ Memorial Hospital	2251739	202101	ZBA	1/11/21	Aetna	AETNA US HEALTHCARE	1148.00	308	840	7	CRNA Only	43239 	XYZ Memorial Hospital	2252512	202101	ZBA	1/12/21	Aetna	AETNA US HEALTHCARE	1640.00	680	960	10	CRNA Only	36561 	XYZ Memorial Hospital	2252810	202101	ZBA	1/12/21	Aetna	AETNA US HEALTHCARE	4105.00	1043.35	3061.65	25	CRNA Only	44150 	XYZ Memorial Hospital	2252845	202101	ZBA	1/12/21	Aetna	AETNA US HEALTHCARE	660.00	586.37	73.63	4	CRNA Only	36556 	XYZ Memorial Hospital	2252991	202101	ZBA	1/12/21	Aetna	AETNA US HEALTHCARE	1476.00	396	1080	9	CRNA Only	43239 	XYZ Memorial Hospital	2258134	202101	ZBA	1/13/21	Aetna	AETNA US HEALTHCARE	1476.00	666	810	9	CRNA Only	43235 	XYZ Memorial Hospital	2259536	202101	ZBA	1/16/21	Aetna	AETNA US HEALTHCARE	1640.00	600	1040	10	CRNA Only	31540 	XYZ Memorial Hospital	2259596	202101	ZBA	1/16/21	Aetna	AETNA US HEALTHCARE	1476.00	1327.8	148.2	9	CRNA Only	43249 	XYZ Memorial Hospital	2259960	202101	ZBA	1/17/21	Aetna	AETNA US HEALTHCARE	1804.00	0	1804	11	CRNA Only	38525 	XYZ Memorial Hospital	2272844	202101	ZBA	1/19/21	Aetna	AETNA US HEALTHCARE	495.00	429.2	65.8	3	CRNA Only	36620 	XYZ Memorial Hospital	2277809	202101	ZBA	1/24/21	Aetna	AETNA US HEALTHCARE	1476.00	1203.84	272.16	9	CRNA Only	10060 	XYZ Memorial Hospital	2278004	202101	ZBA	1/24/21	Aetna	AETNA US HEALTHCARE	1804.00	484	1320	11	CRNA Only	43239 	XYZ Memorial Hospital	2279755	202101	ZBA	1/25/21	Aetna	AETNA US HEALTHCARE	4428.00	1188	3240	27	CRNA Only	21195 	XYZ Memorial Hospital	2280322	202101	ZBA	1/25/21	Aetna	AETNA US HEALTHCARE	1476.00	396	1080	9	CRNA Only	43244 	XYZ Memorial Hospital	2286765	202101	ZBA	1/25/21	Aetna	AETNA US HEALTHCARE	2805.00	2805	0	17	CRNA Only	36620 	XYZ Memorial Hospital	2287672	202101	ZBA	1/27/21	Aetna	AETNA US HEALTHCARE	1312.00	997	315	8	CRNA Only	43249 	XYZ Memorial Hospital	2291343	202101	ZBA	1/30/21	Aetna	AETNA US HEALTHCARE	1312.00	1150.75	161.25	8	CRNA Only	43235 	XYZ Memorial Hospital	2293852	202101	ZBA	1/31/21	Aetna	AETNA US HEALTHCARE	1148.00	1148	0	7	CRNA Only	19125 	XYZ Memorial Hospital	2293911	202101	ZBA	1/31/21	Aetna	AETNA US HEALTHCARE	1640.00	1327.52	312.48	10	CRNA Only	38500 	XYZ Memorial Hospital	2293944	202101	ZBA	1/31/21	Aetna	AETNA US HEALTHCARE	1148.00	0	1148	7	CRNA Only	43249 	XYZ Memorial Hospital	2294114	202101	ZBA	1/31/21	Aetna	AETNA US HEALTHCARE	1312.00	1056.64	255.36	8	CRNA Only	43249 	XYZ Memorial Hospital	2272266	202101	ZBA	1/19/21	Aetna	AETNA US HEALTHCARE	3116.00	3116	0	19	CRNA Only	93656 	XYZ Memorial Hospital	2279983	202101	ZBA	1/25/21	Aetna	AETNA US HEALTHCARE	1968.00	528	1440	12	CRNA Only	93312 	XYZ Memorial Hospital	2285916	202101	ZBA	1/26/21	Aetna	AETNA US HEALTHCARE	495.00	229.68	265.32	3	CRNA Only	36620 	ABC Regional Hospital	2251113	202101	ZBA	1/4/21	Aetna	AETNA HMO	1155.00	0	1155	7	MD CRNA	43235 	ABC Regional Hospital	2251300	202101	ZBA	1/3/21	Aetna	AETNA HMO	1485.00	926	559	9	MD CRNA	52356 	ABC Regional Hospital	2251546	202101	ZBA	1/4/21	Aetna	AETNA HMO	6105.00	5677.25	427.75	67	MD CRNA	01967 	ABC Regional Hospital	2255100	202101	ZBA	1/9/21	Aetna	AETNA HMO	3465.00	796.95	2668.05	21	MD CRNA	43775 	ABC Regional Hospital	2255219	202101	ZBA	1/9/21	Aetna	AETNA HMO	3300.00	759	2541	20	MD CRNA	43775 	ABC Regional Hospital	2255304	202101	ZBA	1/9/21	Aetna	AETNA HMO	6105.00	4458	1647	37	MD CRNA	43644 	ABC Regional Hospital	2255551	202101	ZBA	1/6/21	Aetna	MERITAIN HEALTH	2145.00	676	1469	13	MD CRNA	01961 	ABC Regional Hospital	2256513	202101	ZBA	1/2/21	Aetna	AETNA HMO	2145.00	2145	0	13	MD CRNA	01961 	ABC Regional Hospital	2257336	202101	ZBA	1/11/21	Aetna	AETNA HMO	3630.00	601.87	3028.13	12	MD CRNA	28485 	ABC Regional Hospital	2257930	202101	ZBA	1/11/21	Aetna	AETNA HMO	3960.00	910.8	3049.2	24	MD CRNA	50543 	ABC Regional Hospital	2270977	202101	ZBA	1/13/21	Aetna	AETNA HMO	1320.00	996	324	8	MD CRNA	43235 	ABC Regional Hospital	2272891	202101	ZBA	1/16/21	Aetna	AETNA HMO	1320.00	303.6	1016.4	8	MD CRNA	52332 	ABC Regional Hospital	2272967	202101	ZBA	1/18/21	Aetna	AETNA HMO	2303.00	0	2303	7	MD CRNA	58563 	ABC Regional Hospital	2273121	202101	ZBA	1/18/21	Aetna	AETNA HMO	1155.00	1155	0	7	MD CRNA	58558 	ABC Regional Hospital	2273205	202101	ZBA	1/16/21	Aetna	AETNA HMO	2475.00	2475	0	15	MD CRNA	24340 	ABC Regional Hospital	2273284	202101	ZBA	1/16/21	Aetna	AETNA HMO	4455.00	1024.65	3430.35	27	MD CRNA	27138 	ABC Regional Hospital	2274075	202101	ZBA	1/19/21	Aetna	AETNA HMO	825.00	609	216	5	MD CRNA	52332 	ABC Regional Hospital	2274282	202101	ZBA	1/19/21	Aetna	AETNA HMO	1320.00	973.5	346.5	8	MD CRNA	45380 	ABC Regional Hospital	2275063	202101	ZBA	1/19/21	Aetna	AETNA HMO	3630.00	0	3630	22	MD CRNA	27091 	ABC Regional Hospital	2275258	202101	ZBA	1/19/21	Aetna	AETNA HMO	1155.00	231	924	7	MD CRNA	43249 	ABC Regional Hospital	2275878	202101	ZBA	1/21/21	Aetna	AETNA HMO	3960.00	2934	1026	24	MD CRNA	44141 	ABC Regional Hospital	2278965	202101	ZBA	1/23/21	Aetna	AETNA HMO	3630.00	2662	968	22	MD CRNA	01967 	ABC Regional Hospital	2279154	202101	ZBA	1/24/21	Aetna	AETNA HMO	1320.00	0	1320	8	MD CRNA	54161 	ABC Regional Hospital	2279382	202101	ZBA	1/24/21	Aetna	AETNA HMO	3465.00	0	3465	21	MD CRNA	01967 	ABC Regional Hospital	2279434	202101	ZBA	1/24/21	Aetna	AETNA HMO	6105.00	5615.22	489.78	46	MD CRNA	01967 	ABC Regional Hospital	2284462	202101	ZBA	1/25/21	Aetna	AETNA HMO	3795.00	872.85	2922.15	23	MD CRNA	55866 	ABC Regional Hospital	2289575	202101	ZBA	1/27/21	Aetna	AETNA HMO	1155.00	0	1155	7	MD CRNA	55705 	ABC Regional Hospital	2290074	202101	ZBA	1/29/21	Aetna	AETNA HMO	2145.00	1618.5	526.5	13	MD CRNA	52356 	ABC Regional Hospital	2290108	202101	ZBA	1/29/21	Aetna	AETNA HMO	1485.00	1085.19	399.81	9	MD CRNA	52332 	ABC Regional Hospital	2296400	202101	ZBA	1/31/21	Aetna	AETNA HMO	6105.00	5191.5	913.5	55	MD CRNA	01967 	ABC Regional Hospital	2296428	202101	ZBA	1/31/21	Aetna	MERITAIN HEALTH	2640.00	832	1808	16	MD CRNA	01961 	ABC Regional Hospital	2297321	202101	ZBA	1/31/21	Aetna	AETNA HMO	3795.00	2796	999	23	MD CRNA	50900 	ABC Regional Hospital	2243682	202101	ZBA	1/5/21	Aetna	AETNA HMO	1980.00	0	1980	12	MD CRNA	27030 	ABC Regional Hospital	2267561	202101	ZBA	1/9/21	Aetna	AETNA HMO	2145.00	0	2145	13	MD CRNA	27030 	ABC Regional Hospital	2267871	202101	ZBA	1/10/21	Aetna	AETNA HMO	1320.00	0	1320	8	MD CRNA	29880 	ABC Regional Hospital	2271423	202101	ZBA	1/13/21	Aetna	AETNA HMO	2310.00	0	2310	14	MD CRNA	49505 	ABC Regional Hospital	2298977	202101	ZBA	1/26/21	Aetna	AETNA HMO	1815.00	90.75	1724.25	11	MD CRNA	58662 	XYZ Memorial Hospital	2245786	202101	ZBA	1/3/21	Aetna	AETNA US HEALTHCARE	3948.00	3671.98	276.02	12	MD CRNA	01961 	XYZ Memorial Hospital	2245812	202101	ZBA	1/3/21	Aetna	AETNA US HEALTHCARE	3948.00	3548.16	399.84	12	MD CRNA	01961 	XYZ Memorial Hospital	2245856	202101	ZBA	1/3/21	Aetna	AETNA US HEALTHCARE	3948.00	2508	1440	12	MD CRNA	58661 	XYZ Memorial Hospital	2246102	202101	ZBA	1/4/21	Aetna	AETNA US HEALTHCARE	2303.00	2021.6	281.4	7	MD CRNA	56620 	XYZ Memorial Hospital	2247563	202101	ZBA	1/6/21	Aetna	AETNA US HEALTHCARE	4607.00	0	4607	15	MD CRNA	01961 	XYZ Memorial Hospital	2254749	202101	ZBA	1/9/21	Aetna	AETNA US HEALTHCARE	4606.00	2926	1680	14	MD CRNA	58552 	XYZ Memorial Hospital	2254754	202101	ZBA	1/9/21	Aetna	AETNA	2962.00	1492	1470	10	MD CRNA	01967 	XYZ Memorial Hospital	2255387	202101	ZBA	1/10/21	Aetna	AETNA US HEALTHCARE	4607.00	2717	1890	15	MD CRNA	01961 	XYZ Memorial Hospital	2255600	202101	ZBA	1/11/21	Aetna	AETNA US HEALTHCARE	2303.00	1631	672	7	MD CRNA	57520 	XYZ Memorial Hospital	2255757	202101	ZBA	1/11/21	Aetna	AETNA US HEALTHCARE	4278.00	2950.5	1327.5	14	MD CRNA	01961 	XYZ Memorial Hospital	2256604	202101	ZBA	1/12/21	Aetna	AETNA US HEALTHCARE	3948.00	3948	0	12	MD CRNA	01961 	XYZ Memorial Hospital	2256735	202101	ZBA	1/12/21	Aetna	AETNA US HEALTHCARE	3619.00	2299	1320	11	MD CRNA	58670 	XYZ Memorial Hospital	2257190	202101	ZBA	1/12/21	Aetna	AETNA US HEALTHCARE	3291.00	2204.04	1086.96	11	MD CRNA	01967 	XYZ Memorial Hospital	2259153	202101	ZBA	1/13/21	Aetna	AETNA US HEALTHCARE	2633.00	1305.5	1327.5	9	MD CRNA	01967 	XYZ Memorial Hospital	2267896	202101	ZBA	1/17/21	Aetna	AETNA US HEALTHCARE	3291.00	2905.6	385.4	11	MD CRNA	01967 	XYZ Memorial Hospital	2268795	202101	ZBA	1/16/21	Aetna	AETNA US HEALTHCARE	4277.00	3832	445	13	MD CRNA	01961 	XYZ Memorial Hospital	2271611	202101	ZBA	1/18/21	Aetna	AETNA US HEALTHCARE	4277.00	2717	1560	13	MD CRNA	01961 	XYZ Memorial Hospital	2271710	202101	ZBA	1/18/21	Aetna	AETNA US HEALTHCARE	3290.00	2648.72	641.28	10	MD CRNA	64561 	XYZ Memorial Hospital	2275363	202101	ZBA	1/19/21	Aetna	AETNA US HEALTHCARE	5593.00	4900	693	17	MD CRNA	58571 	XYZ Memorial Hospital	2275701	202101	ZBA	1/19/21	Aetna	AETNA US HEALTHCARE	4278.00	4225.53	52.47	14	MD CRNA	01961 	XYZ Memorial Hospital	2276666	202101	ZBA	1/20/21	Aetna	AETNA US HEALTHCARE	4277.00	4013.34	263.66	13	MD CRNA	58661 	XYZ Memorial Hospital	2278967	202101	ZBA	1/23/21	Aetna	AETNA US HEALTHCARE	3619.00	2728	891	11	MD CRNA	01961 	XYZ Memorial Hospital	2284202	202101	ZBA	1/26/21	Aetna	AETNA US HEALTHCARE	4277.00	3768.8	508.2	13	MD CRNA	01961 	XYZ Memorial Hospital	2290468	202101	ZBA	1/27/21	Aetna	AETNA US HEALTHCARE	4935.00	2502.04	2432.96	15	MD CRNA	58262 	XYZ Memorial Hospital	2296942	202101	ZBA	1/31/21	Aetna	AETNA US HEALTHCARE	9870.00	8070	1800	30	MD CRNA	38525 	XYZ Memorial Hospital	2239362	202101	ZBA	1/3/21	Aetna	AETNA US HEALTHCARE	3619.00	3619	0	11	MD CRNA	31237 	XYZ Memorial Hospital	2239637	202101	ZBA	1/3/21	Aetna	AETNA US HEALTHCARE	6580.00	4180	2400	20	MD CRNA	43653 	XYZ Memorial Hospital	2241237	202101	ZBA	1/2/21	Aetna	AETNA US HEALTHCARE	2633.00	2633	0	9	MD CRNA	43247 	XYZ Memorial Hospital	2242542	202101	ZBA	1/4/21	Aetna	AETNA US HEALTHCARE	3619.00	2299	1320	11	MD CRNA	31237 	XYZ Memorial Hospital	2242583	202101	ZBA	1/4/21	Aetna	AETNA US HEALTHCARE	3126.00	1881	1245	10	MD CRNA	43270 	XYZ Memorial Hospital	2243732	202101	ZBA	1/5/21	Aetna	AETNA US HEALTHCARE	2961.00	1881	1080	9	MD CRNA	43244 	XYZ Memorial Hospital	2247027	202101	ZBA	1/6/21	Aetna	AETNA US HEALTHCARE	6909.00	6284.63	624.37	21	MD CRNA	58571 	XYZ Memorial Hospital	2247043	202101	ZBA	1/6/21	Aetna	AETNA US HEALTHCARE	5264.00	3344	1920	16	MD CRNA	49505 	XYZ Memorial Hospital	2247179	202101	ZBA	1/9/21	Aetna	AETNA US HEALTHCARE	7567.00	4807	2760	23	MD CRNA	42426 	XYZ Memorial Hospital	2247336	202101	ZBA	1/6/21	Aetna	AETNA US HEALTHCARE	6909.00	6909	0	21	MD CRNA	49561 	XYZ Memorial Hospital	2250772	202101	ZBA	1/10/21	Aetna	AETNA US HEALTHCARE	2961.00	1881	1080	9	MD CRNA	52353 	XYZ Memorial Hospital	2252530	202101	ZBA	1/12/21	Aetna	AETNA US HEALTHCARE	4606.00	4498	108	14	MD CRNA	52353 	XYZ Memorial Hospital	2252635	202101	ZBA	1/12/21	Aetna	AETNA US HEALTHCARE	3290.00	3091.7	198.3	10	MD CRNA	52353 	XYZ Memorial Hospital	2252832	202101	ZBA	1/12/21	Aetna	AETNA US HEALTHCARE	8225.00	6725	1500	25	MD CRNA	38525 	XYZ Memorial Hospital	2252844	202101	ZBA	1/12/21	Aetna	AETNA US HEALTHCARE	9379.00	8443.34	935.66	31	MD CRNA	49000 	XYZ Memorial Hospital	2258053	202101	ZBA	1/13/21	Aetna	AETNA US HEALTHCARE	2632.00	2087.97	544.03	8	MD CRNA	43260 	XYZ Memorial Hospital	2259413	202101	ZBA	1/16/21	Aetna	AETNA US HEALTHCARE	3290.00	2964.08	325.92	10	MD CRNA	21012 	XYZ Memorial Hospital	2259517	202101	ZBA	1/16/21	Aetna	AETNA US HEALTHCARE	3290.00	2090	1200	10	MD CRNA	31541 	XYZ Memorial Hospital	2259560	202101	ZBA	1/16/21	Aetna	AETNA US HEALTHCARE	2961.00	2759.74	201.26	9	MD CRNA	31237 	XYZ Memorial Hospital	2259610	202101	ZBA	1/16/21	Aetna	AETNA US HEALTHCARE	4606.00	2926	1680	14	MD CRNA	36475 	XYZ Memorial Hospital	2259979	202101	ZBA	1/17/21	Aetna	AETNA US HEALTHCARE	3619.00	2299	1320	11	MD CRNA	36561 	XYZ Memorial Hospital	2259994	202101	ZBA	1/17/21	Aetna	AETNA US HEALTHCARE	5922.00	5340.72	581.28	18	MD CRNA	49320 	XYZ Memorial Hospital	2260021	202101	ZBA	1/17/21	Aetna	AETNA US HEALTHCARE	3619.00	3161.2	457.8	11	MD CRNA	38525 	XYZ Memorial Hospital	2260828	202101	ZBA	1/17/21	Aetna	AETNA US HEALTHCARE	10199.00	8918	1281	31	MD CRNA	38525 	XYZ Memorial Hospital	2268077	202101	ZBA	1/18/21	Aetna	AETNA US HEALTHCARE	2961.00	1881	1080	9	MD CRNA	52351 	XYZ Memorial Hospital	2268343	202101	ZBA	1/18/21	Aetna	AETNA US HEALTHCARE	4935.00	3135	1800	15	MD CRNA	30520 	XYZ Memorial Hospital	2268373	202101	ZBA	1/18/21	Aetna	AETNA US HEALTHCARE	4606.00	2926	1680	14	MD CRNA	31525 	XYZ Memorial Hospital	2272401	202101	ZBA	1/19/21	Aetna	AETNA US HEALTHCARE	4935.00	4935	0	15	MD CRNA	36825 	XYZ Memorial Hospital	2272573	202101	ZBA	1/19/21	Aetna	AETNA US HEALTHCARE	5264.00	3344	1920	16	MD CRNA	49560 	XYZ Memorial Hospital	2273007	202101	ZBA	1/20/21	Aetna	AETNA US HEALTHCARE	3619.00	2299	1320	11	MD CRNA	52648 	XYZ Memorial Hospital	2273206	202101	ZBA	1/20/21	Aetna	AETNA US HEALTHCARE	2961.00	2097	864	9	MD CRNA	64483 	XYZ Memorial Hospital	2274284	202101	ZBA	1/23/21	Aetna	AETNA US HEALTHCARE	4606.00	2926	1680	14	MD CRNA	60240 	XYZ Memorial Hospital	2275192	202101	ZBA	1/23/21	Aetna	AETNA US HEALTHCARE	4607.00	4162	445	15	MD CRNA	20100 	XYZ Memorial Hospital	2276816	202101	ZBA	1/24/21	Aetna	AETNA US HEALTHCARE	8225.00	5225	3000	25	MD CRNA	51565 	XYZ Memorial Hospital	2277887	202101	ZBA	1/24/21	Aetna	AETNA US HEALTHCARE	8554.00	8026.9	527.1	26	MD CRNA	38525 	XYZ Memorial Hospital	2279822	202101	ZBA	1/25/21	Aetna	AETNA US HEALTHCARE	10199.00	9686.6	512.4	31	MD CRNA	44204 	XYZ Memorial Hospital	2280130	202101	ZBA	1/25/21	Aetna	AETNA US HEALTHCARE	5593.00	3553	2040	17	MD CRNA	30520 	XYZ Memorial Hospital	2280210	202101	ZBA	1/25/21	Aetna	AETNA US HEALTHCARE	14476.00	9954.85	4521.15	44	MD CRNA	33390 	XYZ Memorial Hospital	2280608	202101	ZBA	1/26/21	Aetna	AETNA US HEALTHCARE	3290.00	1754.14	1535.86	10	MD CRNA	52648 	XYZ Memorial Hospital	2287533	202101	ZBA	1/27/21	Aetna	AETNA US HEALTHCARE	3290.00	2707.8	582.2	10	MD CRNA	43260 	XYZ Memorial Hospital	2290969	202101	ZBA	1/30/21	Aetna	AETNA US HEALTHCARE	4607.00	4607	0	15	MD CRNA	67930 	XYZ Memorial Hospital	2291140	202101	ZBA	1/30/21	Aetna	AETNA US HEALTHCARE	3619.00	3194.8	424.2	11	MD CRNA	11770 	XYZ Memorial Hospital	2291386	202101	ZBA	1/30/21	Aetna	AETNA US HEALTHCARE	2961.00	2572.04	388.96	9	MD CRNA	31237 	XYZ Memorial Hospital	2246883	202101	ZBA	1/9/21	Aetna	AETNA US HEALTHCARE	8391.00	4669.68	3721.32	27	MD CRNA	93656 	XYZ Memorial Hospital	2246885	202101	ZBA	1/9/21	Aetna	AETNA US HEALTHCARE	2961.00	2097	864	9	MD CRNA	93312 	XYZ Memorial Hospital	2259785	202101	ZBA	1/16/21	Aetna	AETNA US HEALTHCARE	5593.00	4879	714	17	MD CRNA	93653 	XYZ Memorial Hospital	2279998	202101	ZBA	1/26/21	Aetna	AETNA US HEALTHCARE	7238.00	5126	2112	22	MD CRNA	93656 	XYZ Memorial Hospital	2280003	202101	ZBA	1/26/21	Aetna	AETNA US HEALTHCARE	3290.00	2330	960	10	MD CRNA	93312 	ABC Regional Hospital	2251366	202101	ZBA	1/3/21	Aetna	AETNA HMO	165.00	120	45	1	MD Only	99212 	ABC Regional Hospital	2252028	202101	ZBA	1/1/21	Aetna	AETNA HMO	165.00	120	45	1	MD Only	99212 	ABC Regional Hospital	2263541	202101	ZBA	1/3/21	Aetna	AETNA HMO	2145.00	0	2145	13	MD Only	47562 	ABC Regional Hospital	2289326	202101	ZBA	1/20/21	Aetna	AETNA HMO	2475.00	1836	639	15	MD Only	24340 	ABC Regional Hospital	2243384	202101	ZBA	1/3/21	Aetna	AETNA HMO	1485.00	0	1485	3	MD Only	64447 	ABC Regional Hospital	2267318	202101	ZBA	1/7/21	Aetna	AETNA HMO	1155.00	231	924	7	MD Only	01967 	ABC Regional Hospital	2267329	202101	ZBA	1/6/21	Aetna	AETNA HMO	1485.00	1147.5	337.5	9	MD Only	10060 	ABC Regional Hospital	2267920	202101	ZBA	1/10/21	Aetna	AETNA HMO	2805.00	2044.5	760.5	17	MD Only	47562 	ABC Regional Hospital	2271282	202101	ZBA	1/13/21	Aetna	AETNA HMO	1320.00	1320	0	8	MD Only	45990 	ABC Regional Hospital	2277111	202101	ZBA	1/21/21	Aetna	AETNA HMO	1815.00	1621.13	193.87	11	MD Only	01967 	ABC Regional Hospital	2298933	202101	ZBA	1/26/21	Aetna	MERITAIN HEALTH	990.00	312	678	6	MD Only	64721 	ABC Regional Hospital	2299160	202101	ZBA	1/27/21	Aetna	AETNA HMO	1155.00	499.8	655.2	7	MD Only	43235 	XYZ Memorial Hospital	2280555	202101	ZBA	1/25/21	Aetna	AETNA US HEALTHCARE	3795.00	1035	2760	23	MD Only	01967 	ABC Regional Hospital	2299946	202102	ZBA	2/1/21	Aetna	AETNA HMO	3608.00	0	3608	22	CRNA Only	55866 	ABC Regional Hospital	2300297	202102	ZBA	2/1/21	Aetna	AETNA HMO	4592.00	0	4592	28	CRNA Only	55866 	ABC Regional Hospital	2300639	202102	ZBA	2/2/21	Aetna	AETNA HMO	1476.00	0	1476	9	CRNA Only	45378 	ABC Regional Hospital	2318675	202102	ZBA	2/6/21	Aetna	AETNA HMO	3772.00	2768.5	1003.5	23	CRNA Only	43860 	ABC Regional Hospital	2318855	202102	ZBA	2/7/21	Aetna	AETNA HMO	2952.00	0	2952	18	CRNA Only	47562 	ABC Regional Hospital	2319805	202102	ZBA	2/7/21	Aetna	AETNA HMO	2788.00	2311.1	476.9	17	CRNA Only	01967 	ABC Regional Hospital	2319834	202102	ZBA	2/7/21	Aetna	AETNA HMO	4100.00	615.3	3484.7	25	CRNA Only	01967 	ABC Regional Hospital	2320514	202102	ZBA	2/8/21	Aetna	AETNA HMO	1804.00	1327	477	11	CRNA Only	36561 	ABC Regional Hospital	2321172	202102	ZBA	2/8/21	Aetna	AETNA HMO	1968.00	1446	522	12	CRNA Only	52648 	ABC Regional Hospital	2321277	202102	ZBA	2/8/21	Aetna	AETNA HMO	3936.00	2865	1071	24	CRNA Only	58571 	ABC Regional Hospital	2321495	202102	ZBA	2/8/21	Aetna	AETNA HMO	1968.00	1498.2	469.8	12	CRNA Only	01961 	ABC Regional Hospital	2322031	202102	ZBA	2/10/21	Aetna	AETNA HMO	2460.00	1816.5	643.5	15	CRNA Only	41899 	ABC Regional Hospital	2322227	202102	ZBA	2/10/21	Aetna	AETNA HMO	1476.00	1084.5	391.5	9	CRNA Only	52356 	ABC Regional Hospital	2340179	202102	ZBA	2/13/21	Aetna	AETNA HMO	1312.00	952	360	8	CRNA Only	55700 	ABC Regional Hospital	2353429	202102	ZBA	2/23/21	Aetna	AETNA HMO	1148.00	1053.15	94.85	7	CRNA Only	43239 	ABC Regional Hospital	2353494	202102	ZBA	2/21/21	Aetna	AETNA HMO	7055.00	5230.37	1824.63	43	CRNA Only	33390 	ABC Regional Hospital	2353578	202102	ZBA	2/24/21	Aetna	AETNA HMO	1968.00	0	1968	12	CRNA Only	67108 	ABC Regional Hospital	2356187	202102	ZBA	2/24/21	Aetna	AETNA HMO	1312.00	1045.6	266.4	8	CRNA Only	43239 	ABC Regional Hospital	2357828	202102	ZBA	2/26/21	Aetna	AETNA HMO	495.00	309	186	3	CRNA Only	36620 	ABC Regional Hospital	2372426	202102	ZBA	2/16/21	Aetna	AETNA HMO	1968.00	1455	513	12	CRNA Only	29827 	ABC Regional Hospital	2372676	202102	ZBA	2/16/21	Aetna	AETNA HMO	2624.00	1944.5	679.5	16	CRNA Only	67107 	ABC Regional Hospital	2314450	202102	ZBA	2/6/21	Aetna	AETNA HMO	1640.00	1194.5	445.5	10	CRNA Only	49585 	ABC Regional Hospital	2336689	202102	ZBA	2/13/21	Aetna	AETNA HMO	1640.00	377.2	1262.8	10	CRNA Only	49585 	ABC Regional Hospital	2310810	202102	ZBA	2/2/21	Aetna	AETNA HMO	2132.00	1678.4	453.6	13	CRNA Only	47562 	ABC Regional Hospital	2335799	202102	ZBA	2/13/21	Aetna	AETNA HMO	2788.00	557.6	2230.4	17	CRNA Only	58720 	ABC Regional Hospital	2336842	202102	ZBA	2/15/21	Aetna	AETNA HMO	1640.00	82	1558	10	CRNA Only	29879 	ABC Regional Hospital	2344296	202102	ZBA	2/22/21	Aetna	AETNA HMO	3444.00	2530.5	913.5	21	CRNA Only	58740 	ABC Regional Hospital	2360219	202102	ZBA	2/27/21	Aetna	AETNA HMO	1640.00	1208	432	10	CRNA Only	49520 	ABC Regional Hospital	2373168	202102	ZBA	2/16/21	Aetna	AETNA HMO	984.00	736.5	247.5	6	CRNA Only	57461 	ABC Regional Hospital	2304426	202102	ZBA	2/1/21	Aetna	AETNA HMO	1312.00	983.5	328.5	8	CRNA Only	45378 	ABC Regional Hospital	2304446	202102	ZBA	2/1/21	Aetna	MERITAIN HEALTH	3614.00	3493.1	120.9	17	CRNA Only	47562 	ABC Regional Hospital	2304510	202102	ZBA	2/2/21	Aetna	AETNA HMO	1476.00	1227	249	9	CRNA Only	42826 	ABC Regional Hospital	2310112	202102	ZBA	2/6/21	Aetna	AETNA HMO	1312.00	961	351	8	CRNA Only	45378 	ABC Regional Hospital	2329312	202102	ZBA	2/16/21	Aetna	AETNA HMO	1155

Background: NorthStar’s Chief Financial Officer has asked you to evaluate the performance of one of its business units, Alphabet Anesthesia. The business unit has two facilities: ABC Regional Hospital...

Get Answer To This Question

Related Questions & Answers

Submit New Assignment