I will need help on the following analysis for a project i am involved. I will post in addition to this analysis files of the actual project. Overhead allocation Volume and Price Payer mix Phased growth and expenses Projected cash flow (time value analysis) Depreciation and life of asset Payback period Other related financial analysis

CASE 9 8/13/13 Student Version Copyright 2014 Health Administration Press CAMBRIDGE TRANSPLANT CENTER Marginal Cost Pricing Analysis This case analyzes a relatively straightforward marginal cost pricing analysis. It is designed to illustrate the mechanics of estimating marginal costs as well as the advantages and disadvantages of using marginal costs as the basis for pricing transplant services. The input section of the worksheet contains historical average cost data for seven cost categories along with the fixed cost proportion and growth percentage for applicable categories. The output is the marginal (variable) cost for Phase 4 of the transplant program as well as the Phase 4 cost structure. The model consists of a complete base case analysis--no changes need to be made to the existing MODEL-GENERATED DATA section. However, all values in the student version INPUT DATA section have been replaced with zeros (or dashes). Thus, students must determine the appropriate input values and enter them into the model. These cells are colored red. When this is done, any error cells will be corrected and the base case solution will appear. Students will have to modify the model as required by the case as well create their own graphics (charts) as needed to present their results. INPUT DATA: KEY OUTPUT: Phase 4 Hospital Costs: Contract volume Marginal variable cost (variable cost rate) Marginal fixed cost Total contract marginal costs Average cost per contract transplant Average Cost Category Nursing Ancillary OR Laboratory Radiology Drug Other $13,314 53,245 5,906 8,097 1,389 15,268 22,586 Total Note: The model assumes that radiology, drug, and other costs are completely variable, while the remaining cost categories consist of both fixed and variable costs. $119,805 New contract (marginal) volume 30 Current proportion of fixed costs for categories that have both fixed and variable components 60.0% New (marginal) fixed costs required as a proportion of current total fixed costs when marginal volume exceeds 30 20.0% Note: Additional fixed costs are required when contract volume exceeds 30 transplants. Current fixed costs total $5,800,440. MODEL-GENERATED DATA: Phase 4 Fixed and Marginal Costs (Per Contract Transplant): Marginal Cost Existing Fixed Costs Category Nursing Ancillary OR Laboratory Radiology Drug Other Volume of 30 or less Volume of 31 or more $7,988 31,947 3,544 4,858 $48,337 Total $5,326 21,298 2,362 3,239 1,389 15,268 22,586 $71,468 Total cost See calculation below $119,805 Phase 4 Hospital Cost Structure: Total Marginal Costs Associated with New Contract Volume: Total costs Marginal (new) fixed costs + = $2,144,034 = Marginal (new) fixed costs + = Average marginal cost per transplant = $0 + $71,468 Variable costs (Variable cost rate $71,468 x Marginal volume). x 30 30 $71,468 $$2,144,034 $71,468