Calculation of Total Costs

Question Description

*** I just need questions 2 & 3 from the word document to be answered.

*** The instructions are included in the power point attachment.

***** For each question, there MUST be at least 1 – 1 1/2 pages.

Use the guidelines for writing a report on the course web site and use the following questions as a guide:

2) The weekly utilization data is provided in the Excel file on the class website. Create scatter plots to show the relationships between the following and explain the results:

• The total cost of physician visits vs. # of employees
• # of employees vs. # of visits
• Total cost for physician visits vs. # of visits

3) For question # 2, calculate visits per employee and the cost per visit for each week. Calculate and interpret the mean, standard deviation, and coefficient of variation for these measures for the six-month period. Explain how these statistics are useful in understanding the trend in total outpatient physician costs per Digi Tech Media employee.