Question: Workforce Scheduling Problem: Operations Management Decision variables: Xi is defined to be the number of nurses hired to start on day i of the week

Workforce Scheduling Problem: Operations Management

Workforce Scheduling Problem: Operations

Decision variables: Xi is defined to be the number of nurses hired to start on day i of the week (assume the first day is Monday) minimize X1 + x2 + x3 + x4 + x5 + X6 + X7 Subject to: X1 + x4 + x5 + X6 + x7 > 18 (cover staffing requirement for Monday) X1 + X2 + X5 + X6 + x7 > 25 (cover staffing requirement for Tuesday) X1 + x2 + x3 + X6 + x7 > 15 (cover staffing requirement for Wednesday) X1 + x2 + x3 + x4 + x7 > 30 (cover staffing requirement for Thursday) X1 + x2 + x3 + x4 + X5 > 40 (cover staffing requirement for Friday) x2 + x3 + x4 + X5 + X6 2 20 (cover staffing requirement for Saturday) x3 + x4 + x5 + X6 + x7 > 23 (cover staffing requirement for Sunday) Xi > 0, Xi are integers Question 1. Solve the problem using MS Excel Solver and find an optimal solution and the optimal objective value. (Note: when you create constraints in the Solver, you have to specify that the cells for decision variables are INT type.)

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!

1) (A)Model the Nurses shift scheduling problem in Excel and see if you can determine the required number of nurses required for each start day, and the total nurses required. (B) then rerun the...

The Answer of part (a) is as the following: a) Formulation of LP model Decision variables : Xi = Number of employees to start a five day stunt on day i of the week Objective : Minimize Xi Constraints...

Decision variables: x i i s defined t o b e the number o f nurses hired t o start o n day i o f the week ( a s s u m e the first day i s Monday ) minimize, x 1 + x 2 + x 3 + x 4 + x 5 + x 6 + x 7...

Identify the linear programming problem apparent in the case, that will help the company achieve their goals. Excel file with model and optimal solution (optimal purchasing, refining, shipping...

Question 1 . Solve the problem using MS Excel Solver and find an optimal solution and the optimal objective value. (Note: when you create constraints in the Solver, you have to specify that the cells...

Submitted to Management Science manuscript MS-0001-1922.65 Authors are encouraged to submit new papers to INFORMS journals by means of a style file template, which includes the journal title....

Supply Chain Management Introduction Outline What is supply chain management? Significance of supply chain management. Push vs. Pull processes utdallas.edu/~metin 1 A Generic Supply Chain Sources:...

Chapter Ten Nonwage Issues in Bargaining Wage and nonwage issues are not completely separable. Both have economic consequences for the employer. For example, provisions relating to hours of work...

Reference FOSSUM. (2008). Labor Relations, 10th Edition. [VitalSource Bookshelf version]. Retrieved from http://online.vitalsource.com/books/1259220389/epubcfi/6/34 Page 294 Chapter Ten Nonwage...

Despite the various efforts that have been implemented by ABSA and many other financial institutions in preventing and mitigating operational risk occurrences, however, losses are still incurred....

Pete Inc., a U.S. company, sold inventory to Ping Pte. Ltd. for 20,000 Singapore dollars and to Satria Tbk. for 300mn Indonesian rupiahs on December 1, 2014, when the spot rate for the SGD was $0.798...

Question 1 Which of the following standards represents levels of operation that can be attained with reasonable effort? theoretical BOTTIII datal variable Question 2 A report that summarizes actual...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...