complete the following assignment, MUST HAVE THE FORMULAS IN THE EXCEL BOXES. There are 3 different tabs 2.1, 2.2 and 2.3 DUE TODAY 2/7/2021 by 7 pm Central Standard time. Below is tab 2.1
CHAPTER 5 HOMEWORK – COSTING AND PROFIT ANALYSISHomework 2.1, Chapter 5Using the data below, answering the following questions:Fixed costs$23,750,000 Variable cost/day$525 Charge (rev)/day$2,575 Inpatient days14,500
a. Construct the hospital’s base case projected P&L statementb.
What is the hospital’s breakeven point (volume / patient days needed to breakeven)?
c. What is the economic breakeven (volume required ) to provide a profit of $1,500,000?
d. What is the total contribution margin if volume decreases by 20%?
e. Based on the scenario in d., if fixed costs remain the same, what is the hospital’s profit or loss?
