Questionthe medical centre tender selection panel have

Assignment Help Corporate Finance

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

Reference no: EM13380892

Questions Cloud

1 benefit-cost analysis experts agree that to the extent : 1. benefit-cost analysis experts agree that to the extent you can quantify benefits and costs you should do this.

Office suppliesfairfield office supplies inc has a regional : office suppliesfairfield office supplies inc. has a regional chain of office supply stores in the midwest. fairfield is

1 as a financial analyst you have been asked to analyze : 1. as a financial analyst you have been asked to analyze certain aspects of working capital management for the wendys

Questionthe medical centre tender selection panel have : questionthe medical centre tender selection panel have provided you with some estimated figures of the number of

Marty the marketing manager would like you to review one of : marty the marketing manager would like you to review one of his marketing strategies he has put together.he is aiming

Question 1your mate arty the architect is feeling : question 1your mate arty the architect is feeling overwhelmed by the idea of designing the rotating the floor in the

The new medical centre wants you to simulate the day : the new medical centre wants you to simulate the day appointments schedule for one doctor.nbsp an analysis has been

Business analysis assignmentnbspthe following time-phasing : business analysis assignmentnbspthe following time-phasing chart is available for a single item within a mrp system.

User Account

All Pages