Question

In: Finance

MA 117 Lab 1 In this lab, you will need to write equations, perform calculations, and...

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.

  1. Hospital Administration

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.

  1. Identify the revenue per case and the annual fixed and variable costs for running the operating room.
  2. How many eye operations must the hospital perform each year in order to break even?
  3. Southwest Hospital currently averages 70 eye operations per month. One of the nurses has just learned about a machine that would reduce by $100 per patient the amount of medical supplies needed. It can be leased for $100,000 annually. Keeping in mind the financial cost and benefits, advise the hospital on whether it should lease this machine.
  4. An advertising agency has proposed to the hospital’s president that she spend $20,000 per month on television and radio advertising to persuade people that Southwest Hospital is the best place to have any eye surgery performed. Advertising account executives estimate that such publicity would increase business by 40 operations per month. If they are correct and if this increase is not big enough to affect fixed costs, what impact would this advertising have on the hospital’s profits?
  5. In case the advertising agency is being overly optimistic, how many extra operations per month are needed to cover the cost of the proposed ads?
  6. If the ad campaign is approved and subsequently meets its projections, should the hospital review its decision about the machine discussed in Question 3?

Solutions

Expert Solution

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.


Related Solutions

In the discussion, write the equilibrium equations for the reactions studied in this lab (equations 3,...
In the discussion, write the equilibrium equations for the reactions studied in this lab (equations 3, 4, and 5). Determine whether the reaction is exothermic or endothermic and include heat (Q) as a product or reactant. Remember that there is only one equilibrium equation for a given system and the added reagents are not part of that equation. For each stress applied (reagent added, heat added or removed) identify the stress and explain the effect of the stress in detail,...
1- Bromobutane sintesis Lab VII. Write the equations (chemical equations) taking place on the SECONDARY REACTION...
1- Bromobutane sintesis Lab VII. Write the equations (chemical equations) taking place on the SECONDARY REACTION of these t-pentil alcohol + HCl   -----> t-pentil clorhidride maybe this could help you I need the secondary ( CH3)2 C ( Cl ) CH2 CH3 + HCl ---à ( CH3)2 C ( OH ) CH2 CH3 + H2O The SODIUM BICARBONATE 5% is used to wash crude t-pentil clorhidride . Why is the need to perform this wash And Why its not apropiate...
How do you perform adiabatic flash calculations?
How do you perform adiabatic flash calculations?
Write a Python program that will perform various calculations (addition, subtraction, multiplication, division, and average). The...
Write a Python program that will perform various calculations (addition, subtraction, multiplication, division, and average). The program will add, subtract, multiply, or divide 2 numbers and provide the average of multiple numbers inputted from the user. You need to define a function named performCalculation which takes 1 parameter. The parameter will be the operation being performed (+,-,*,/). This function will perform the given prompt from the user for 2 numbers then perform the expected operation depending on the parameter that’s...
Write a program in C++ that computes the sum of odd numbers between 1 and 117....
Write a program in C++ that computes the sum of odd numbers between 1 and 117. Execute the program and submit a screen capture of the program and its results.
Question: You perform a lab where you are instructed to observe the characteristics of a lipid...
Question: You perform a lab where you are instructed to observe the characteristics of a lipid molecule in oil and water and are told to conduct 3 trials each time for the lab. You noticed that you get the same observations for all 3 trials for the lab. Explain in detail why you were asked to complete 3 trials? Why were you not asked to complete 1 trial?
For this problem, you must use Excel to perform the necessary calculations. Below are the formulas...
For this problem, you must use Excel to perform the necessary calculations. Below are the formulas and equations you will need to use. Click on the image below to download a power point version if the text is blurry or too small. If it is appropirate to use the binomial distribution, use the formula=binom.dist(number_s,trails,probability,cumulative) to calculate the probability. In this formula, number_s is the number of successful trails, trails is the total number of trails, probability is the probability for...
If you were to perform this reaction in a lab, you would make far less than...
If you were to perform this reaction in a lab, you would make far less than the theoretical yield of product due to a wide range of outside factors. We can compare the actual yield to the theoretical yield to calculate the percent yield: percent yield=actual yieldtheoretical yield×100% Keep in mind that the percent yield can be calculated using any unit of mass or moles, so long as they are the same. For example, you can divide moles by moles,...
Design an experiment that you could perform in our lab to determine the coefficient of kinetic...
Design an experiment that you could perform in our lab to determine the coefficient of kinetic friction and static friction and to compare the coefficient of kinetic friction and static friction. A good design should include details of the materials and equipment needs, the experimental procedure, including precautions, the types of data you will collect, how the data will be represented and analyzed, and how you will determine the accuracy of your experimental result(s).
Lab 02 Final Grade Calculator **** I need it in JAVA **** **** write comments with...
Lab 02 Final Grade Calculator **** I need it in JAVA **** **** write comments with the code **** Objective: Write a program that calculates a final grade! The program should read in a file and then calculates the final grade based on those scores. Files read into this system are expected to follow this format: <Section0>\n <Grade0 for Section0>\n <Grade1 for Section0>\n … <GradeX for Section0>\n <Section1>\n <Grade0 for Section1>\n … <GradeY for Section1> <Section2> … <SectionZ> Sections denote...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT