Operational Research Method
Table of Conten
1. INTRODUCTION1
2. Formulate the Problem1
2.1 CHOOSE DECISION VARIABLES1
2.2 FORMULATE THE OBJECTIVE FUNCTION1
2.3 FORMULATE CONSTRAINTS2
3. SOFTWARE2
3.1 MICROSOFT OFFICE EXCEL2 3.1.1 EXCEL DATA INPUT AND SOLVE THE PROBLEM2 3.1.2 ANSWER ANALYSIS3 3.1.3 SENSITIVITY ANALYSIS4
3.2 XPRESS-IVE ANALYSIS6
4. CONCLUSION6
APPENDIX
Operational Research Methods Report
1. Introduction
Linear programming (LP) model is a significant and popular used model of operational research technique. It helps to optimize the objective value with constraints. LP model have three essential assumptions when use this model to solve problem. Firstly, proportionality and additively, which means that the objective function and the functions in constraints are all linear. In other words, it means the equation of objective and constraints are linear equation. Secondly, LP model assume that non-integer values of the decision variables are meaningful for the problem addressed, which indicate that LP model have divisibility. Finally, LP model assume that the parameters of the model are all known constants. In this report, Microsoft Office Excel and Xpress are implemented in order to solve the problem.
2. Formulate the Problem
This report focuses to solve the problem of nurse assignment for Jefferson County Regional Hospital. Formulate the problem as a linear programing model with objective function and constraints.
Table 2.1: Nurse assignment table
3.1 Choose decision variables
As table 2.1 shows, declare 12 variables, x1 x2 … x12, which represent the numbers of nurse to start work in each time period. In this case, the coefficient of each variable has to be value 1 because it represents one person rather than price or costs.
3.2 Formulate the objective function
Depends on the require of problem description, the minimize total number of nurses can be written as (‘Z’ stands for objective value): Minimize Z =
1. INTRODUCTION1
2. Formulate the Problem1
2.1 CHOOSE DECISION VARIABLES1
2.2 FORMULATE THE OBJECTIVE FUNCTION1
2.3 FORMULATE CONSTRAINTS2
3. SOFTWARE2
3.1 MICROSOFT OFFICE EXCEL2 3.1.1 EXCEL DATA INPUT AND SOLVE THE PROBLEM2 3.1.2 ANSWER ANALYSIS3 3.1.3 SENSITIVITY ANALYSIS4
3.2 XPRESS-IVE ANALYSIS6
4. CONCLUSION6
APPENDIX
Operational Research Methods Report
1. Introduction
Linear programming (LP) model is a significant and popular used model of operational research technique. It helps to optimize the objective value with constraints. LP model have three essential assumptions when use this model to solve problem. Firstly, proportionality and additively, which means that the objective function and the functions in constraints are all linear. In other words, it means the equation of objective and constraints are linear equation. Secondly, LP model assume that non-integer values of the decision variables are meaningful for the problem addressed, which indicate that LP model have divisibility. Finally, LP model assume that the parameters of the model are all known constants. In this report, Microsoft Office Excel and Xpress are implemented in order to solve the problem.
2. Formulate the Problem
This report focuses to solve the problem of nurse assignment for Jefferson County Regional Hospital. Formulate the problem as a linear programing model with objective function and constraints.
Table 2.1: Nurse assignment table
3.1 Choose decision variables
As table 2.1 shows, declare 12 variables, x1 x2 … x12, which represent the numbers of nurse to start work in each time period. In this case, the coefficient of each variable has to be value 1 because it represents one person rather than price or costs.
3.2 Formulate the objective function
Depends on the require of problem description, the minimize total number of nurses can be written as (‘Z’ stands for objective value): Minimize Z =