How well the memo visual presentation convey the reasoning

Assignment Help Operation Management

Reference no: EM131674294

Dr. Pat Combs is the head a large conglomerate of hospitals, Acuity Hospital Association. Dr. Combs is converting the company to an Activity Based Costing system for internal reporting. Your team has been asked to assist in the process. Your task is to present to Dr. Combs your conclusion on the best cost driver (and the rate) to determine Medical Overhead costs associated with a patient’s visit. You will submit a memo and a visual presentation to Dr. Combs.

You have been provided Medical Overhead cost history from 2009 to 2014 for the company. You have also been provided with information about the type of medication used, the amount of medication used, the level of nursing care (1- technician level to 4-skilled & specialized), the length of the stay, the doctors’ fee, and the type of visit (Medical, Surgical or Other). Your task is to determine the best cost driver and the associated rate to best estimated Medical Overhead costs for a patient visit. It can be a single driver or a combination of multiple drivers.

You must conduct your analysis and generate your visual presentation from Tableau. Your electronic submission should include a Word file for your memo and the Tableau file used for the analysis. You may use other programs as part of your analysis, but any conclusions must be supported by your work in Tableau.

The submissions will be evaluated on how well the memo and the visual presentation convey the reasoning for why your chosen cost driver (or combination of cost drivers) is the best choice for predicting Medical Overhead costs.

Reference no: EM131674294

Questions Cloud

Difference between good and bad strategies : What is the difference between good and bad strategies?

What are key output measure of innovative activity : What are key output measure of innovative activity. What are the main strengths of the current United States Healthcare system?

The reasons for the increase in disclosure requirements : What are the reasons for the increase in disclosure requirements? Do you see these reasons forming the basis for even more disclosure in the future?

Explain what that company did to earn your loyalty : Share a company you have loyalty to and explain what that company did to earn your loyalty?

How well the memo visual presentation convey the reasoning : The submissions will be evaluated on how well the memo and the visual presentation convey the reasoning for why your chosen cost driver

While under the marketing umbrella-public relations : While under the marketing umbrella, public relations is an industry in itself.

Difference in outside-in planning and inside-out planning : Identify the factors that influence a firm’s choice of entry mode. What is the key difference between outside-in planning and inside-out planning?

All contracts with credit card companies are unconscionable : All contracts with credit card companies are "unconscionable” contracts. All contracts must be in writing to be enforceable.

Badly by the acceptability and implementation issues : What are the most serious instances you can recall personally where a company did badly by the acceptability and implementation issues, respectively?

User Account

All Pages