Identify the number of emergency appointments

Reference no: EM13198710

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: EM13198710

Questions Cloud

Hypothesis remembering that hypotheses involve variables : Develop a hypothesis, remembering that hypotheses involve variables and cause/effect relationships. Be specific in the research design you would use, including proper terminology. The intent is to assess your ability to reason about social issues,..

State the slope and y-intercept of the graph : State the slope and y-intercept of the graph

What is the economic cost function for the business : A fully equipped facility can be leased at a cost of $35,000 for the year. Additional projected costs are $15,000 for overhead, and $5 per automobile for materials and supplies. Full detail automobile cleaning would be priced at $25.

Library assignment-determining the economic : To continue with your evaluation for the new vice president position, the president of your company, Mr. Wilson, has asked you to prepare a report for him determining the economic impact of a coffee pushcart that will provide hot coffee and cappuccin..

Identify the number of emergency appointments : Identify the number of emergency appointments, patient load and administrative costs for each month within the relevant range and construct an excel spreadsheet and create a regression analysis to estimate

Explain most effective in refining solutions to the problem : Compare two steps that would be most effective in refining solutions to the problem and resolutions to the issues presented by the topic

Calculate the incremental profit fluff rite would earn : Fluff Rite, Inc., manufactures stove top popcorn poppers that it sells to distributors, who then customize and distribute the products to retailers as house-brand poppers. The yearly volume of output is 100,000 units.

Describe proposal getting an indoor swimming pool on campus : My assignment is to write a formal proposal pertaining to getting an indoor swimming pool on campus. Where do I begin and where to find construction costs,

Regarding social development : Which of the following is not true regarding social development?

User Account

All Pages