The current allocations may fill the need but may be actually in excess to meet

Question

The current allocations may fill the need but may be actually in excess to meet demand resulting in increased costs

Outsourcing has its drawbacks to so we will have to consider them. Also, we should take cost and productivity factors into account

Using an excel solver we can introduce constraints thus taking cost factors and productivity, into account. Scheduling needs and allocations during a critical time is also possible. This is achieved using linear programming- assignment type.

This will helps us to fulfill the constraints and optimize the ratio of different classes of nurses. Conventionally the objective is to minimize costs for such problems and the usual constraints we use are

We can find

Excel solver also offers sensitivity analysis where we can find

Explanation / Answer

BCMH must decide on how it will supply the OR with nursing staff. They are currently staffed with 60 percent permanent staff, 35 percent temporary staff and 5 percent on call staff. One option is to do nothing since it is filling the required need, as this is one of the assumption made. The second option is to use a forecasting model or Excel Solver to anticipate demand and adjust the makeup of permanent, temporary and on call staff ratios. The third and final option is to outsource 100 percent of the nursing staff. How doe use excel solver to find an answer

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.