In: Finance
MA 117 Lab 1
In this lab, you will need to write equations, perform calculations, and make judgements. All equations and calculations should be included in your lab write-up. All judgements should be explained and justified in complete sentences referencing your calculations.
Southwest Hospital has an operating room used only for eye surgery. The annual cost of rent, heat, and electricity for the operating room and its equipment is $360,000, and the annual salaries of the people who staff this room total $540,000.
Each surgery performed requires the use of $760 worth of medical supplies and drugs. To promote goodwill, every patient receives a bouquet of flowers the day after surgery. In addition, one-quarter of the patients require dark glasses, which the hospital provides free of charge. It costs the hospital $30 for each bouquet of flowers and $40 for each pair of glasses.
The hospital receives a payment of $2000 for each eye operation performed.
Question 1:
The revenue per case and the annual fixed and variable costs for running the operating room are determined as below:
Revenue Per Case = Amount Received for Each Eye Operation Performed = $2,000
Annual Fixed Costs = Annual Cost of Rent, Heat, and Electricity for the Operating Room and its Equipment + Annual Salaries = $900,000
Variable Costs Per Case = Cost of Medical Supplies Per Case + Cost of Bouquet Flowers + Cost of Glasses = 760 + 30 + 40*1/4 = $800 per case
Annual Variable Costs = Total Number of Cases*Variable Costs Per Case = 70*12*800 = $672,000
______
Question 2:
The number of eye operations to be performed each year to break even is calculated as follows:
Number of Eye Operations to Break Even = Annual Fixed Costs/(Revenue Per Case - Variable Costs Per Case)
Substituting values in the above formula, we get,
Number of Eye Operations to Break Even = 900,000/(2,000 - 800) = 750 eye operations
______
Question 3:
In order to decide whether we should lease the machine or not, we will have to calculate profit under each scenario as below:
Profit Calculation | ||
When Machine is Not Leased | When Machine is Leased | |
Revenue (840*2,000) | 1,680,000 | 1,680,000 |
Less Variable Costs | 672,000 (840*800) | 588,000 (840*700) |
Contribution Margin | 1,008,000 | 1,092,000 |
Less Fixed Costs | 900,000 | 1,000,000 (900,000 + 100,000) |
Profit | $108,000 | $92,000 |
Based on the above calculations it can be seen that the profit decreases by $16,000 (108,000 - 92,000) when the machine is leased. Therefore, the machine shouldn't be leased.
______
Question 4:
The impact of advertising on hospital profits is calculated as follows:
Profit Calculation | ||
When Advertising is Not Done | When Advertising is Done | |
Revenue | 1,680,000 (840*2,000) | 2,640,000 [(840 + 40*12)*2,000] |
Less Variable Costs | 672,000 (840*800) | 1,056,000 [(840 + 40*12)*800] |
Contribution Margin | 1,008,000 | 1,584,000 |
Less Fixed Costs | 900,000 | 1,140,000 (900,000 + 20,000*12) |
Profit | $108,000 | $444,000 |
Based on the above calculations it can be seen that the hotel's profits will increase to $444,000 if it undertakes advertising.
______
Question 5:
The number of extra operations needed to cover the cost of proposed ads is calculated as below:
Number of Extra Operations to Cover Cost of Proposed Ads (Annual) = Annual Fixed Costs Including Advertising Costs/(Revenue Per Case - Variable Cost Per Case) - Current Number of Operations = 1,140,000/(2,000 - 800) - 840 = 110 operations
Now, we can calculate the number of extra operations to be performed monthly as follows:
Number of Extra Operations to Cover Cost of Proposed Ads (Monthly) = Number of Extra Operations (Annual)/12 = 110/12 = 9.167 extra operations
Based on the above calculations it can be concluded that the hospital needs to perform 9.167 extra operations or 10 operations to cover the cost of proposed ads.
______
Question 6:
We will have to calculate the revised profit in order to take the decision as below:
Revenue [(840 + 40*12)*2,000] | 2,640,000 |
Less Variable Costs [(840 + 40*12)*700] | 924,000 |
Contribution Margin | 1,716,000 |
Less Fixed Costs (900,000 + 100,000 + 240,000) | 1,240,000 |
Profit | $476,000 |
Based on the above calculations it can be seen that with advertising campaign and leased machine, the hospital's profit increases from $444,000 (as calculated in question 5) to $476,000. Therefore, the hospital can review its decision about the machine and consider it taking on lease.