Question: Please show me the calculation with excel? This problem is from Service Management ed(10) 5.5. Getting a physical examination at a physician's office involves a

Please show me the calculation with excel?

This problem is from Service Management ed(10) Please show me the calculation with excel? This

5.5. Getting a physical examination at a physician's office involves a series of steps. The table below lists these activities and their average times. The activities can occur in any order, but the doctor's consultation must be last. Three nurses are assigned to perform activities 1, 2, and 4. Activity Average Time, Min. 1. Blood pressure, wt., temp. 2. Medical history 3. Doctor's checkup 4. Lab work 5. Doctor's consultation 18 a. What are the bottleneck activity and the maximum number of patients who can be seen per hour? b. Suggest a reallocation of nursing and/or doctor activities that would result in increased service capacity, and draw a product flow diagram. What is the capacity of your improved system

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

please assist me to solve Q2 and show my the calculation in excel CoursHeroTranscribedText: Qatar University College of Business and Economics Department of Management and Marketing Operations...

Case Pate Memorial Hospital In mid-April 2000, Shenri Worth, assistant administrator at Pate Memorial Hospital (PMM) in charge of the hospital's Pate Health Clinic (PHC), uncovered an unsettling...

The instructions and background information for this case are in the file called Medical ABC_Case #2. The 8 questions that need to be answered are at the end of the document. The data used to answer...

PROGRAMME HANDBOOK: JANUARY 2016 INTAKE ASSIGNMENT 2: HUMAN RESOURCES DEVELOPMENT Read the case study below and answer the questions that follow. National HRD in Finland, Russia, and South Africa...

I want to know the answer for problem 1and 2 Discuss some of the alternatives and factors that Greg should consider when developing the expense allocation system. What are some of the costs and...

Journal of Autism and Developmental Disorders, Vol. 32, No. 3, June 2002 ( 2002) Descriptive Epidemiology of Autism in a California Population: Who Is at Risk? Lisa A. Croen,1,3 Judith K. Grether,1...

Case Pate Memorial Hospital In mid-April 2000, Shenri Worth, assistant administrator at Pate Memorial Hospital (PMM) in charge of the hospital's Pate Health Clinic (PHC), uncovered an unsettling...

I need help with questions 1-8 and 11. Thank you! The document attached has all required info. ISSN 1940-204X Product Costs: Application in an Insurance Company Scott McGregor Western Connecticut...

2006 National Institute of Standards and Technology Technology Administration Department of Commerce Baldrige National Quality Program Arroyo Fresco Community Health Center Case Study 2006 National...

A proton moves at 0.90c. What is its momentum in SI units?

This problem involves the use of crosscorrelation to detect a signal in noise and estimate the time delay in the signal. A signal x(n) consists of a pulsed sinusoid corrupted by a stationary...

Does the if - corverted assumption apply only to dilused earnings per share? convertble preferned slock. B . The fl - convefied assumption is always applad to diuted EPs, as long an the setuls are...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...