Calculate the average charge for medicaid patients

Reference no: EM133564960

Assignment

Real-World Case

AHIMA Competency: Calculate statistics for healthcare operations.

A summary of the patients discharged from MS-DRG 689 at Community Hospital is presented in the table below.

Data for Real-World Case discussion

Case	Principal Diagnosis	Principal Procedure	Age	LOS	Discharge Destination	Charges	Payer
1	599.0	38.93	53.5	4	HOMEIV	$8,851	MEDICAID
2	599.0	45.13	28.2	7	HOMEHEALTH	$18,966	MEDICARE
3	590.8		45.5	3	HOME	$4,370	MANAGED CARE
4	590.8	86.27	27.9	3	HOMEHEALTH	$7,121	GOV MNGD CARE
5	590.8		38.8	3	HOME	$13,350	MEDICAID
6	590.8	45.23	67.1	4	HOME	$15,854	MANAGED CARE
7	599.0	39.95	88.5	6	SNF	$22,373	MEDICARE
8	599.0		27.8	6	HOMEHEALTH	$11,381	GOV MNGD CARE
9	590.1		52.6	2	HOME	$4,082	MEDICAID
10	599.0		81.9	6	HOMEHEALTH	$17,025	MEDICARE
11	590.8		23.3	3	HOME	$5,039	MEDICAID
12	599.0	43.11	90.1	5	HOMEHEALTH	$17,411	MEDICARE
13	599.0	99.6	91.3	1	UNKNOWN	$5,302	MEDICARE
14	599.0	88.72	73.1	4	HOME	$11,091	MEDICARE
15	599.0		81.3	12	SNF	$23,341	MEDICARE
16	590.8	45.16	74.7	4	HOMEHEALTH	$16,277	MEDICARE
17	599.0		71.2	5	HOMEHEALTH	$9,239	MEDICARE
18	599.0		79.3	7	SNF	$21,050	MEDICARE
19	590.1		31.3	4	HOME	$7,085	GOV MNGD CARE
20	590.8	38.93	74.1	13	ACUTECARE	$49,487	MEDICAID
21	599.0		65.7	2	HOMEHEALTH	$8,980	MEDICARE
22	599.0	86.27	83.1	5	SNF	$11,651	MEDICARE
23	599.0		77.0	5	SNF	$12,295	MEDICARE
24	599.0	99.04	81.2	7	HOMEHEALTH	$23,745	MEDICARE
25	599.0		43.3	10	HOMEHEALTH	$25,130	MEDICARE
26	599.0		81.5	3	SNF	$10,092	MEDICARE
27	599.0	38.93	25.6	3	HOMEIV	$8,722	MEDICAID
28	599.0		61.4	2	SNF	$6,670	MEDICAID
29	599.0	45.13	76.0	8	SNF	$17,741	GOV MNGD CARE
30	590.1		44.4	4	HOME	$10,800	MANAGED CARE
31	590.8		44.8	2	HOME	$10,916	MEDICAID
32	599.0	45.13	61.2	8	SNF	$32,796	MEDICARE

Question A. Calculate the length of stay for all patients.

Question B. Calculate the average length of stay for Medicare patients.

Question C. Calculate the average charge for all patients.

Question D. Calculate the average charge for Medicaid patients.

Question E. Calculate the average age of all patients.

Question F. Calculate the average age of patients discharged to skilled nursing facilities.

Question G. Calculate the average age of patients discharged home.

Question H. Calculate the ratio of Medicare patients to Medicaid patients.

Reference no: EM133564960

Questions Cloud

Create plan that will guide future professional development : The purpose of this discussion is to create a plan that will guide future professional development. Formulate three goals for your professional development.

What is the transformational leadership approach : What is the transformational leadership approach? Give an example of what these leaders are like and what they do to lead their organization to success.

Describe three of the variations done in milgram original : Describe three of the variations done in Milgram's original obedience experiment. Be sure to discuss how the results varied as a function of these changes.

Determine top cancer sites by county based on number of case : Report healthcare data through graphical representation. Determine top three cancer site by county based on number of cases. Create table that illustrates data.

Calculate the average charge for medicaid patients : Calculate the average charge for Medicaid patients. Calculate the average age of patients discharged to skilled nursing facilities.

Identify some recent change on current trends in environment : Identify some recent changes on current trends in the external environment and the business opportunities they might offer.

How does that impact your work as a counselor : What are some of the contributing factors in your cultural context? As Christian psychotherapists and counselors, how can we speak to this culture and invite

Describe your plan to increase retention of all employees : Describe your plan to increase retention of all employees. What potential problems are leading to turnover? What specific actions could you take to reduce

What would you recommend that olivia do to resolve the issue : What are the potential ethical code violations that may occur because of this situation? What would you recommend that Olivia do to resolve this issue?

User Account

All Pages