Question 1) Apollo's Hospital's CFO. Julie, has been concerned of late about the hospital's consumption of medical supplies. To better understand the behavior of this cost, Julie consults with Rhett, the person responsible for Apollo's cost system. After some discussion, Julie and Rhett conclude that there are two potential cost drivers for the hospital's 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. Home Insent Page Layout Formutes Data Redew A B C D 1 Month Medical Supplies costs Number of procedures Number of patient-hours 2 1 $106,000 320 2,000 13 230,000 500 3,900 84,000 240 1.900 5 238,000 520 4,100 193,000 240 3,400 180,000 340 3,700 210,000 420 3,100 92,000 360 1.200 222.000 320 3,000 11 10 83,000 180 1,300 12 11 127,000 440 2.800 13 12 225,000 380 3.800 Required (round all numbers to two decimal places, if needed): 1, Run a regression analysis on Excel for medical supplies costs using number of procedures as your driver. Make sure this is included in your homework submission. You can answer the following questions on the same tab/sheet or write them down and submit separately: a. Using your results from (1), write the cost formula for medical supplies cost. b. Using the cost formula from (la), what would medical supplies cost be for a month with 417 procedures? c. Using the high-low method", write the cost formula for medical supplies cost using number of procedures as your driver