Use the guidelines for writing a report on the course website and use the following questions...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. a 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 b. 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 c. Compare the results from the two regressions and explain how they can be used to help Mr. Green in making his decision. A B Week Total Costs of Physician Visits 1234FCTBa 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 722222 23 24 25 $77,322 $79,177 $74,888 $73,428 $74,535 $75,487 $74,222 $75,499 $76,300 $76,033 $78,832 $79,755 $80,243 $78,993 $81,227 $84,219 $82,177 $82,456 $81,100 $84,211 $90,133 $95.120 $99.865 $97.752 $98.713 # Visits 401 423 404 407 404 432 430 452 457 459 446 481 484 484 491 496 500 450 469 498 495 500 520 505 517 D #Employees Visit/ employee Cost/ Visit 4065 $192.8 4065 $187.2 4062 $185.4 4063 $180.4 4069 $184.5 4070 $174.7 4076 4076 4083 4081 4088 4087 4095 4101 4099 4103 4112 4115 4126 4130 4129 4129 4129 4136 4137 0.099 0,104 0.099 0.100 0.099 0.106 0.105 $172.6 0.111 $167.0 0.112 $167.0 0.112 $165.6 0.109 $176.8 0.118 $165.8 0.118 $165.8 0.118 0.120 0.121 0.122 $164.4 0.109 $183.2 0.114 $172.9 0.121 $169.1 0.120 $182.1 0.121 0.126 0.122 0.125 $163.2 $165.4 $169.8 $190.2 $192.0 $193.6 $190.9 G 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. a 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 b. 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 c. Compare the results from the two regressions and explain how they can be used to help Mr. Green in making his decision. A B Week Total Costs of Physician Visits 1234FCTBa 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 722222 23 24 25 $77,322 $79,177 $74,888 $73,428 $74,535 $75,487 $74,222 $75,499 $76,300 $76,033 $78,832 $79,755 $80,243 $78,993 $81,227 $84,219 $82,177 $82,456 $81,100 $84,211 $90,133 $95.120 $99.865 $97.752 $98.713 # Visits 401 423 404 407 404 432 430 452 457 459 446 481 484 484 491 496 500 450 469 498 495 500 520 505 517 D #Employees Visit/ employee Cost/ Visit 4065 $192.8 4065 $187.2 4062 $185.4 4063 $180.4 4069 $184.5 4070 $174.7 4076 4076 4083 4081 4088 4087 4095 4101 4099 4103 4112 4115 4126 4130 4129 4129 4129 4136 4137 0.099 0,104 0.099 0.100 0.099 0.106 0.105 $172.6 0.111 $167.0 0.112 $167.0 0.112 $165.6 0.109 $176.8 0.118 $165.8 0.118 $165.8 0.118 0.120 0.121 0.122 $164.4 0.109 $183.2 0.114 $172.9 0.121 $169.1 0.120 $182.1 0.121 0.126 0.122 0.125 $163.2 $165.4 $169.8 $190.2 $192.0 $193.6 $190.9 G
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Calculate marketing return on sales and marketing ROI for both companies, as described in Appendix 2. Appendix 2 discusses other marketing profitability metrics beyond the marketing ROI measure...
-
Calculate Return on Investment (ROI) and Economic Value Added (EVA).Use the following data for Eastern Investments Company to calculate ROI and EVA for 2013 and 2014. Analyze the results. Eastern...
-
The following are miscellaneous transactions for Top Shoe Suppliers for March 2021: Date 1 7 13 14 15 Transaction Details The owner took shoes from the stock for personal use, selling price R 239.40...
-
You have just completed your four-year degree at LLC University! Your student loans that you have accumulated while studying at LLC total $25,000. Since you have graduated, you must now begin...
-
Distinguish between mentoring and coaching. What is reverse mentoring?
-
Oxygen to acetylene ratio in case of neutral flame: (a) \(1: 1\) (b) \(1.2: 1\) (c) \(0.8: 1\) (d) \(2: 1\)
-
List the problems with life-cycle assessment. Explain which level of management is appropriate for addressing each of these problems.
-
Following is information for the Fulcrum Companys three business segments located in Europe. Fulcrums applicable tax rate for the segments is 30%, and its weighted average cost of capital for each...
-
A certain loan has a stated interest rate of 11.6%. If the current inflation rate is 5.8%, what is the real interest rate on this loan? Suppose on January 1, 2023 a share of Ford cost $10.34. On...
-
Jurassic Jumpers Co. (JJ Co.) offers bungee jumping for those looking for an extreme outing. JJ Co. prepares annual financial statements and has a December 31, 2023 yearend. a. On April 1, 2023, JJ...
-
An investor and The are given Year 2009 2010 2011 2012 2013 2014 invested 65% of hu Stuck B 35% in return Retur. / on 0.52 data for both stock 4 and stock B below: Stuck A Weight = 0.65 5.21 7.2-3...
-
A persons risk tolerance might change with more investment knowledge or greater wealth. True or False
-
Which is not an advantage of investing in mutual funds? a. Mutual funds have less price variability than stocks or bonds. b. Mutual funds provide diversification. c. Mutual fund investments are...
-
The basic trade-off to be considered by the supplier with production capacity is between committing to an order from a higher-price buyer or waiting for a lower-price buyer to arrive later on....
-
What will happen to a projects schedule if an activity on the critical path is delayed? If an activity is not on the critical path?
-
Does Brazil face an increasing opportunity cost of ethanol? What feature of Brazils PPF illustrates increasing opportunity cost? Brazil produces ethanol from sugar, and the land used to grow sugar...
-
3 Hadley has of a box of white envelopes and of a box of gray envelopes. When full, each box of envelopes has the same number of envelopes. Hadley said she has of a box when she puts the white...
-
Using thermodynamic data from Appendix 4, calculate G at 258C for the process: 2SO 2 (g) + O 2 (g) 88n 2SO 3 (g) where all gases are at 1.00 atm pressure. Also calculate DG8 at 258C for this same...
-
Suppose you are a manufacturers agent for three lines of complementary womens apparel. Discuss the types of marketing mix decisions you will make.
-
Define IMC and discuss how marketers implement it.
-
Why is Apple virtually giving away this platform to third-party applications developers? Wouldnt it be more profitable for Apple to generate more revenue from its App Store? Apple has hit three home...
-
Use the data given in exercise SB-3. Assume that in November 2021, General Motors sold half its investment in \(\mathrm{ABC}\) to Toyota. The sale price was \(\$ 14\) million. Compute General...
-
Use the data given in exercise SB-1. On May 19, 2021, Knowlton sold its investment in BCE shares for \(\$ 26\) per share. 1. Journalize the sale. No explanation is required. 2. How does the gain or...
-
Arnold Financing leases airplanes to airline companies. Arnold has just signed a 10 -year lease agreement that requires annual lease payments of \(\$ 1,000,000\). What is the present value of the...
Study smarter with the SolutionInn App