Reference no: EM13380892

Question:

The medical centre tender selection panel have provided you with some estimated figures of the number of emergency appointments, patients per day and the associated administrative costs for the first year of operation.  Below is the summary of the years expected patients. It has been estimated that the clinics relevant range is 150 to 300 patients per day.

Month	Emergency appointments	Patients per day	Administrative costs ($)
January	30	350	2780
February	32	125	1400
March	20	100	1200
April	30	250	2000
May	34	325	2380
June	38	225	1840
July	26	275	2040
August	24	75	820
September	34	175	1880
October	34	300	2220
November	26	150	1660
December	42	375	3220

Required:

a) Identify the number of emergency appointments, patient load and administrative costs for each month within the relevant range

b) Construct an excel spreadsheet and create a regression analysis to estimate

i. An equation with patient per day predicting administrative cost within the relevant range

ii. An equation with both activities - patients per day, number of emergency appointments predicting administrative costs within the relevant range

c) Does the inclusion of an additional cost driver improve the model? Explain your answer