1. Business
  2. Accounting
  3. need help with 1a 1b 1c...

Question: need help with 1a 1b 1c...

Question details
Need help with 1A 1B 1C
BUS2102-Spring 2019-Chapter 3 Fun & Exciting Exercises Always show your work when doing fun &exciting exercises! Box or circle final answers! Question 1) Apollo Hospital specializes in outpatient surgeries for relatively minor procedures. Apollo is a nonprofit institution and places great emphasis on controlling costs in order to provide services to the community in an efficient manner Apollos CFO, Julie Chen, has been concerned of late about the hospitals consumption of medical supplies. To better understand the behavior of this cost, Julie consults with Rhett Bratt, the person responsible for Apollos cost system. After some discussion, Julie and Rhett conclude that there are two potential cost drivers for the hospitals medical supplies costs. The first driver is the total number of procedures performed. The second is the number of patient-hours generated by Apollo. Julie and Rhett view the latter as a potentially better cost driver because the hospital does perform a variety of procedures, some more complex than others Rhett provides the following data relating to the past year to Julie. Hone Insert e Page Layout FormulasDate Review Month Medical Supplies costs Number of procedures Number of 106,000 230.000 84.000 238.000 193.000 80.000 210.000 92.000 222.000 $3,000 2,000 3.900 1,900 4.100 3.400 3.700 3.100 1.200 3.000 1.300 2,800 3.800 320 500 520 240 340 420 360 320 180 440 380 10 9 1110 12 11 127.000 225.000 Required (round all numbers to two decimal places, if needed): Run a regression analysis on Excel for medical supplies costs using number of procedures as your driver Print a copy of the results and attach it to your homework. If you like, you can use this printout to write out your final answers to the following questions: 1. Using your results from (1), write the cost formula for medical supplies cost. Using the cost formula from (1a), what would medical supplies cost be for a month with 417 procedures? Using the high-low method, write the cost formula for medical supplies cost using number of procedures as your driver a. b. c. 2. Run a regression analysis on Excel for medical supplies costs using number of patient-hours as your driver. Print a copy of the results and attach it to your homework. If you like, you can use this printout to write out your final answers to the following questions: Using your results from (2), write the cost formula for medical supplies cost. a. b. Using the cost formula from (2a), what would medical supplies cost be for a month with 3,333 patient-hours? c. Using the high-low method, write the cost formula for medical supplies cost using number of patient-hours as your driver. Based on your answers from parts 1 & 2, which driver (number of procedures or number of patient-hours) is better for determining costs? Explain using R2 as part of your answer. 3. e: On Ic and 2c, your fixed cost answers will be slightly different using the high number andor the low numb to rounding. Whichever way you chose to solve it (high or low),just write that answer down for fixed cost
Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution