Anonymous

Question description

In paragraph form, the roadmap is basically addressing the questions in order of my answers and what the purpose of it is. The road map is coming in right after the intro. Half a page should be good to be honest. There is a bit of material you need to know.

Questions: "green-guard-questions" doc

I believe I'm missing one question involving statistical analysis.

GREEN GUARD CARE – QUESTIONS Use the guidelines for writing a report on the course web site and use the following questions as a guide: Q. 1. Using only the information provided in Exhibit 1, explain why further analysis of physician visits may be needed. Compare the profitability of hospital and surgical services to physician services, using the allocation of revenue that was given. Show the breakdown of the \$250 premium using a pie chart. Does the allocation of the \$250 per employee per month payment across the types of health care services seem reasonable, given the past two months’ utilization? Q. 2. The weekly utilization data is provided in the Excel file on the BUS 302 website. Create scatter plots to show the relationships between the number of employees, number of visits per week, and total physician costs. Calculate visits per employee and the cost per visit for each week. Calculate the mean, standard deviation, and coefficient of variation for these measures for this six-month period. Explain how these statistics are useful in understanding the trend in total outpatient physician costs per Arc Electric employee. Q. 3. Regression analysis can be useful to tease out the importance of various factors in explaining costs. a. Evaluate the relationship between visits per week and week. Interpret your regression results by discussing significance of the regression equation and magnitude of the estimated coefficients. b. Evaluate the relationship between cost per visit and week. Interpret your regression results by discussing significance of the regression equation and magnitude of the estimated coefficients. c. Compare the results from the two regressions and explain how they can be used to help Mr. Pasture in making his decision. Q. 4. Mr. Langdon referred to a national study of copayment levels. The important results of this study are provided in Exhibit 3. a. Calculate the price elasticity of demand for physician visits at each copayment level using the arc method. What does the data tell you about the price elasticity of demand for physician visits? How does this information help Mr. Pasture in making his decision? b. Using the six months of data provided in the Excel file, simulate the profitability of the physician services department if copayments are increased to \$20 per visit. Repeat your analysis using a copayment of \$25 per visit. Q. 5. Using the six months of data provided in the Excel file, calculate the percentage reduction in physician payments that would be required to achieve the same level of profits as in Q.4.b. Q. 6. In addition to the options suggested by his staff, Mr. Pasture recently read an article about rationing health care services as a method of controlling costs. The general idea of rationing is that more expensive treatments are excluded so that basic health benefits can be provided to a wider population. Health plans can implement rationing by limiting the types of services they will cover. While they commonly exclude coverage for experimental treatments and cosmetic surgery, many are now considering adding physical therapy, mental health services, and therapies that treat fatal conditions to the list of excluded services. Would you recommend that Mr. Pasture consider this approach? Discuss the ethical considerations.

(Top Tutor) Studypool Tutor
School: UIUC
Studypool has helped 1,244,100 students
flag Report DMCA

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors