Computer the answers for the missing cells, Operation Management

Assignment Help:

You put your operations intern on the case, and she provided you with the following information:

• The clinic generally sees two types of patients: simple and complex.

• The clinic employs two clerks who check patients in at reception with a service time of 1.5 minutes, on average (regardless of patient type). The same clerk checks patients out and schedules follow up appointments, with an average service time of 1.5 minutes (regardless of patient type.)

• The clinic also employs four nurse practitioners (NP) and six physicians.

• NPs only see simple patients, with an average service time of 20 minutes, although it has been discovered that triage mistakenly assigns a complex patient to an NP about 20% of the complex cases. When this happens, it takes the NP about five minutes of time to detect the complexity of the patient and place the patient back in line to see a physician.

• Physicians see both simple and complex patients, with a service time of 10 minutes (simple) and 20 minutes (complex).

• A recent analysis suggested that on a typical day, the clinic see approximately 144 simple patients and 96 complex patients and that approximately 40% of the simple patients are seen by a physician.

In your search for a solution to the clinic's problems, you find a table like the following on a website of some operations management guru. You begin filling it out-

Calculate the answers for the missing cells (A, B, C, etc.) in the table

Step/Resource Service Times Time Available Time Busy Utilization (%)

Simple Complex Simple Complex Total

Reception (2 Clerks) 1.5 1.5 A B C D E

Triage (2 Nurses) 4 4 F G H I J

Nurse Practitioners (4) 20 5 K L M N O

Physicians (6) 10 20 P Q R S T

Check-out (2 Clerks) 1.5 1.5 U V W X Y


Related Discussions:- Computer the answers for the missing cells

The problem require that it get solved using excel solver, I cannot seem to...

I cannot seem to answer EX. 4a, b and c. from ISN# 978-0-13-274395-2 Pearson Chopra 5th Edition. You provide solutions to discussions questions but not chapter exercises. The probl

History.., The historical development of operation management.

The historical development of operation management.

Merits and demerits of using prepared sales presentation, 1-) Identify a fe...

1-) Identify a feature, an advantage, and a benefit for each of the following products: a camera, a backpack, fat-free ice cream, lawn care service. 2-) What are the advantages

Explain method would you pursue to minimize channel conflict, D-Magic is a ...

D-Magic is a new company that has developed a revolutionary 3D television. It uses a new technology that provides a much sharper and realistic 3D experience than their competitors.

Explain union leaflet urging employees, Suppose a co-worker just brought yo...

Suppose a co-worker just brought you a union leaflet urging employees to sign an authorization card. What may happen from this point on?

How can controlling asist a manager to become more efficient, How can contr...

How can controlling help a manager to become more efficient?

Explain impact an organizations ability to compete, Why are aggregate and s...

Why are aggregate and succession planning of critical importance? How might failures in these areas impact an organizations ability to compete? Be specific

Explain management often fail to realize the value of hr, Why does senior m...

Why does senior management often fail to realize the value of human assets versus other organizational assets?

Explain pipeline transportation system for treated water, The network in fi...

The network in figure below shows the pipeline transportation system for treated water from the treatment plant (node 1) to a city water supply system (node 14). The arc capacities

Write Your Message!

Captcha
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