Course dashboard Question 2 The administrator of Azalea Hills Hospital would like a cost formula linking the administrative costs involved in Not yet answered admitting patients to the number of patients admitted during a month. The admitting department's costs and the Marked out of 7.00 number of patients admitted during the immediately preceding year are given in the following table: Flag question Month Number of Patients Admitted Admitting Department Costs January 8,175 $37,266 February 7,263 $35,595 March 7,758 $33,996 April 7, 140 $32,475 May 8,904 $41,550 June 9,843 $43,257 July 10,059 $44,805 August 8,949 $41,388 September 9, 171 $40,689 October 8,628 $35,667 November 8,205 $38,049 December 10,467 $47,214December 10,467 $47,214 Required: (LO# 3) A) Using the high-low method, estimate the fixed cost of admitting department per month and the variable cost of admitting department per patient admitted. Round off the fixed cost to the nearest whole dollar and the variable cost to the nearest whole cent. B) If it is estimated that 14,000 patient admitted will be run in next month, what is the expected total admitting department? C) Prepare a scattergraph plot. (Place admitting department costs on the vertical axis and patient admitted on the horizontal axis.) D) Using least-squares regression, estimate the variable cost per patient admitted and the monthly fixed cost incurred to admitting department. The total fixed cost should be estimated to the nearest dollar and the variable cost per rental return to the nearest cent. Comment on your answer EXCEL Paragraph B E