Create linear regression equation to model number of calls

Assignment Help Management Information Sys
Reference no: EM131300543

Scheduling and capacity planning

Here is the data and the answers to those questions.

Month

Average # of Telemedicine callsreceived per day for each month the center was open in year 1

Jan

37

Feb

28

Mar

42

Apr

48

May

63

Jun

71

Jul

75

Aug

74

Sep

88

Oct

93

Nov

95

Dec

102

a. Using Excel, create a linear regression equation to model the number of calls per month.
y = 6.6853x + 24.545

b. At the current rate of growth, how many telemedicine calls does the regression equation predict for June of year 2?

At June of year 2, x = 18. Plugging this into linear regression equation we get:
# calls / day = 6.6853(18) + 24.545, which is 145 calls per day on average.

c. Given your prediction for June of year 2, how many telemedicine nurses do you forecast will be needed per 12 hour shift to handle the load?

At 145 calls per day, that is 12 calls on average per hour. Since a single nurse can handle 4 calls an hour, we need 3 nurses minimum manning the telemedicine center for the 12 hour shift.

You are to come up the minimum number of nurses required for the telemedicine unit. Here are your assumptions / constraints:
1. The Telemedicine Unit is open 7 days a week from 7am - 7pm. This is one 12-hour shift.

2. There will be 4 telemedicine nurses on a shift, and they work 4 days on and 3 off. Four nurses are required due to breaks and meals. This leaves 3 nurses to staff the telemedicine consoles at all times.

3. All nurses earn 4 weeks of vacation a year. A week is 7 days for planning purposes.

4. You can assume the nurses are unavailable 1 week of the year for professional development.

5. On average the nurses are only sick 3 days a year.

Reference no: EM131300543

Questions Cloud

Compute and analyze the financial data : Compute and analyze the financial data using a Microsoft Excel spreadsheet. Make sure all calculations can be seen in the background of the applicable spreadsheet cells
What is the stationary probability that system is blocked : Describe the behaviour of the system by a Markov chain and draw the transition graph.
In your own word define public administration : In your own word define Public Administration. Then explain whether or not public administration should be separated form politics and why. Finally explain how the current presidential administration might be consider Wilsonian. Be specific and ju..
Personal experience to prevent issues : Determine the needed leadership style to help develop a solution. Outline an action plan for a resolution. Make additional suggestions based on your personal experience to prevent issues like this from happening in the future.
Create linear regression equation to model number of calls : Create a linear regression equation to model the number of calls per month.- how many telemedicine calls does the regression equation predict for June of year 2?
How government has overstepped biblical principles : For this assignment, you will write a 2-3-page paper (double-spaced, 1-inch margins) providing at least 1 example of how government has overstepped biblical principles in some form of economic policy.
Describes the research design or approach in depth : describes the research design or approach in depth. This should be a detailed and clearly written description which permits a precise replication of the study. The sections described below apply mainly to a quantitative thesis, but may be appropri..
Analyze and discuss your personal leadership style : In this assignment, you will analyze and discuss your personal leadership style. Based solely on your experience, current readings, work experience, or education, describe what you feel is your personal leadership style. Include the following in y..
Describe the behaviour of the system by a markov chain : Consider a two-unit system with standby redundancy and one mechanic. All repair times of failed units have an Erlang distribution with parameters n = 2 and µ Apart from this, the other model assumptions listed in example 5.5 remain valid.

Reviews

Write a Review

Management Information Sys Questions & Answers

  Information technology and the changing fabric

Illustrations of concepts from organizational structure, organizational power and politics and organizational culture.

  Case study: software-as-a-service goes mainstream

Explain the questions based on case study. case study - salesforce.com: software-as-a-service goes mainstream

  Research proposal on cloud computing

The usage and influence of outsourcing and cloud computing on Management Information Systems is the proposed topic of the research project.

  Host an e-commerce site for a small start-up company

This paper will help develop internet skills in commercial services for hosting an e-commerce site for a small start-up company.

  How are internet technologies affecting the structure

How are Internet technologies affecting the structure and work roles of modern organizations?

  Segregation of duties in the personal computing environment

Why is inadequate segregation of duties a problem in the personal computing environment?

  Social media strategy implementation and evaluation

Social media strategy implementation and evaluation

  Problems in the personal computing environment

What is the basic purpose behind segregation of duties a problem in the personal computing environment?

  Role of it/is in an organisation

Prepare a presentation on Information Systems and Organizational changes

  Perky pies

Information systems to adequately manage supply both up and down stream.

  Mark the equilibrium price and quantity

The demand schedule for computer chips.

  Visit and analyze the company-specific web-site

Visit and analyze the Company-specific web-site with respect to E-Commerce issues

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd