#### Description of this paper

##### Ques_5.4 and 5.5 - Break even analysis

Description

solution

Question

Question;Please provide all answers and solutions on;INDIVIDUAL Excel Worksheets.;#1:Question 5.4;General Hospital, a not for profit acute care;facility, has the following cost structure for its inpatient services;Fixed costs \$10,000;Variable cost per inpatient day \$200;Charge (revenue) per inpatient day \$1000;The hospital expects to have a patient load of;\$15,000 inpatient days next year;a. Construct;the hospital?s base case projected P&L statement;b. What;is the hospital?s breakeven point?;c. What;volume is required to provide a profit of \$1,000,000? A profit of \$500,000?;d. Now;assume that 20 percent of the hospital?s inpatient days come from a managed;care plan that wants a 25 percent discount from charges. Should the hospital agree to the discount;proposal?;#2: Question;5.5;You are considering starting a walk-in clinic. Your financial projections for the first year;of operations are as follows;Revenues (10,000 visits) \$400,000;Wages and benefits;\$220,000;Rent;\$5000;Depreciation \$30,000;Utilities;\$2500;Medical supplies \$50,000;Administrative supplies \$10,000;Assume that all cost are fixed, except supply costs;which are variable. Furthermore, assume;that the clinic must pay taxes at a 30 percent rate.;a. Construct;the clinic?s projected P&L statement.;b. What;number of visits is required to break even?;c. What;number of visits is required to provide you with an after-tax profit of;\$100,000?

Paper#40151 | Written in 18-Jul-2015

Price : \$25