Explain why further analysis of physician visits maybe needed.
please answer to the questions 1 to 3B of the questionnaire page and write an executive summary and introduction for this project. There is one guideline page, please follow the instructions, there is also one coaching PowerPoint for more informations.
Thanks
Requirements: Answer the questions and write one page of executive summary and about a page of introduction.
GOODLIFE ZONE – QUESTIONS
Use the guidelines for writing a report on the course website 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
maybe 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 $260 premium using a column chart. Does the allocation of the $260 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 data 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 and standard deviation for these measures for this six-month period. Explain how these statistics are useful in understanding the trend in total outpatient physician costs per Sparks Interactive employee.
Q. 3. Regression analysis can be useful to tease out the importance of various factors in explaining
costs.
Evaluate the relationship between visits per week and week. Interpret your regression results by discussing the significance of the regression equation and the magnitude of the estimated coefficients.
Evaluate the relationship between cost per visit and week. Interpret your regression results by discussing the significance of the regression equation and the magnitude of the estimated coefficients.
Compare the results from the two regressions and explain how they can be used to help Mr. Green in making his decision.
Q. 4. Mr. Ramirez referred to a national study of copayment levels. The important results of this study
are provided in Exhibit 3.
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. Green in making his decision?
b. Using the six months of data provided in the Excel data 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. In addition to the options suggested by his staff, Mr. Green 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. Green consider this approach? Discuss the ethical considerations.
119 BUS 302 SHORT BUSINESS REPORT: GUIDELINES This document provides an outline for the short business report. Please follow this format when preparing your case reports, and ask your instructor for additional clarification, if necessary. Transmittal Page The report should begin with a transmittal memo. This memo serves to explain the audience, author, and basic purpose of the attached report. It should be short and to the point. For example, the transmittal memo for the Day at the Movies case might read: DATE: March 17, 2004 TO: Mr. Plex, Owner, Royal Theater FROM: Joe Smith, Legal Analyst, Group One Consulting, Inc. RE: Analysis of Liability for Fraud Per your request, we have prepared an analysis of Royal Theater’s liability for fraud as alleged by the moviegoer, Tommy. Please contact us if you need any additional information. The memo should indicate an appropriate date (given the facts of the case), and should not exceed one page. Executive Summary The second page of the document should have a report title at the top, and provide an executive summary, which is a paragraph or two that summarizes the report. It should provide enough of an overview of the report so that an executive (who doesn’t have time to fully read the longer document) gets the main ideas and conclusions of your report. Most importantly, the summary should contain (1) the purpose of the report (with minimal background information), (2) what you did (analysis) and what you found (results), and (3) your recommendations. It should not exceed one page.
120 Report Page 3 of the report should contain a title at the top (the same title that you put on the top of the previous page. This is the first page that should actually be numbered, and it should be page 2 (because the memo is not technically part of the report). • The report starts with an introduction section, including a statement of purpose for the report. This paragraph should provide important background information, and should end with a clear “road map” that tells the reader what to expect in the remainder of the report. • After the introduction, use headings and subheadings frequently to ease the reader’s task. For example, possible headings for the Day at the Movies case are: Analysis of Liability for Fraud, Analysis of Moviegoers’ Opinions, Other Considerations, Conclusions, and Recommendations. • A conclusion paragraph responds to the report’s purpose and how the report has achieved it. The conclusion may contain the recommendations. • The length of the body of the report will be determined by necessity to convey the analysis and conclusions, but should generally not exceed 10 pages. • Statistical analysis, including Excel output, should be summarized and presented at the appropriate level, given the audience. As a general rule, most output should be placed in an appendix, and the most important results should be discussed in the text of the report. When a figure or table is important to the discussion, it may be included in the text if it does not take up more than 1/3 of the page. • Tables and figures should all be labeled. No tables or figures should ever cut across a page. • References may be cited within the text, in footnotes, or in separate “References” section. Do NOT cite the Gateway text—consider that all the case information is general knowledge—but you must provide cites to the legal library cases when used. These citations take the form: Cao and Cao v. Nguyen and Pham, 258 Nev. 1027; 607 N.W.2d 528; 2000 Neb. LEXIS 56.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
