Please help and reply asap

Problem 6: 'I don't understand this cost report at all', exclaimed John Carter, the newly appointed administrator of AngelCare General Hospital. 'Our administrative costs in the new paediatrics clinic are difcult to understand. 0n month the report shows $16, 600, and the next month it's $32, 200. What's going on?' Carter question was posed to Alice Baines, the hospital's accountant. "Ihe main problem is that the clinic has experience some widely varying patient loads in its first year of operation'. Baines replied. 'There seems to be some confusion in the public's mind about what services we offer in the clinic. When do they come to the clinic? When do they go the outpatients' department? That sort of thing. As the patient load has varied, we've frequently changed our clinic administrative staffing. Also, we have found that the number of emergency procedures varies each month, and emergency procedures cause additional staff oosts.' Carter continued to puzzle over the report. 'Could you put some data together, Alice, so we can see how this cost behaves over a range of patient loads?' 'You'll have it this aernoon', Baines responded. She set to work right away and gathered the following date: Month Number of emergency procedures Patient load Administrative cost January 20 2 800 $27 800 February 22 1 000 14 000 March 1 0 800 1 2 000 A riI 20 2 000 20 000 May 24 2 600 23 800 June 28 1 800 18 400 July 16 2 200 20 400 August 14 600 3 200 September 24 1 400 13 800 October 24 2 400 22 200 November 16 1 200 16 600 December 32 3 000 32 200 Baines does not believe that the rst year's widely uctuating patient load will be experienced again in future, she has estimated that the clinic's relevant range of monthly activity in the lture will be 600 to l 200 patients. Required: 1. Assume that the relevant range is within 600 and 1200 patients. Use the high-low method to estimate the behaviour of the clinic's administrative costs, based on patient load within the relevant range. Use an equation to express the results of this estimation method. 2. What is your prediction of the clinic's administrative cost during a month when 800 patients visit the hospital? Problem solving assignment Page 11 of 12 3. Would you use the cost function from requirement 1 to predict the clinic's administrative cost for 300 patient visits? Explain your answer. 4. Identify the number of emergency procedures, patient load and administrative costs for each month within the relevant range. 5. If only patient load is considered as a determinant of administration costs and only the historical patient load data that falls within the relevant range (patient load between 600 and 1200) are considered, then simple regression can be used, utilising Excel. Following is the results of regression analysis as per the given information in the case: Regression Statistics Multiple R 0.991355 R Square 0.982784 Adjusted R. Square 0.974176 Standard Error 569.2099788 Observations 4 ANOVA df SS MS F Significance F Regression 36992000 36992000 114.1728395 0.00864523 Residual 648000 324000 324000 Total 37640 000 Coefficients Standard error t-Stat P-value Lower-95% Upper-95% Intercept 460 1180.338934 0.389718569 0.734330305 -4618.588538 5538.589 Patients 13.6 1.272792206 10.68516914 0.008645234 8.12361714 19.07638 the equation to explain administrative cost behaviour is as follows Y = $460 + $13.60X Does the inclusion of additional cost driver of emergency procedures improve the model? Explain your