Related Experiment Video
Updated: May 2, 2026
11:53
Spatial Multiobjective Optimization of Agricultural Conservation Practices using a SWAT Model and an Evolutionary Algorithm
Published on: December 9, 2012
12.6K
Personnel scheduling using an integer programming model- an application at Avanti Blue-Nile Hotels.
Biniyam Asmare Kassa1, Anteneh Eshetu Tizazu1
1College of Business & Economics, Bahir Dar University, Bahir Dar, 2052 Ethiopia.
Springerplus
|February 21, 2014
Summary
This study introduces a management science approach, using an integer programming model, to optimize weekly shift schedules for hotel engineering staff in Ethiopia. The model ensures fair scheduling and efficient resource utilization while meeting all constraints.
Area of Science:
- Operations Research
- Management Science
- Industrial Engineering
Background:
- The Ethiopian hotel industry faces challenges in personnel scheduling.
- Optimizing staff shifts is crucial for operational efficiency and employee well-being.
Purpose of the Study:
- To develop and implement an integer programming model for optimal weekly shift scheduling.
- To address constraints such as rest requirements and personnel needs per shift.
- To improve personnel management in the Ethiopian hotel sector.
Main Methods:
- Development of an integer programming model.
- Application of the model to Avanti Blue Nile Hotels' engineering department.
- Implementation using an Excel solver routine.
Main Results:
- The model successfully generated optimal weekly shift schedules.
- Ensured compliance with technical, legal, and economic requirements.
- Facilitated fair personnel scheduling and effective resource utilization.
Conclusions:
- Management science approaches, specifically integer programming, are effective for optimizing hotel operations in Ethiopia.
- The developed model provides a practical tool for personnel management.
- Encourages wider adoption of management science in Ethiopian organizations.
Related Concept Videos
01:29Application of Differentiation to Business
343
Calculus offers essential techniques for businesses seeking to optimize pricing strategies and revenue. In this case, a bakery wants to determine the ideal price and daily sales volume to maximize revenue. By modeling how changes in price affect demand and revenue, the bakery can apply calculus to make data-driven decisions.The demand function relates the price per cupcake to the number of cupcakes sold and captures how lower prices increase sales. Based on market data, the demand function can...
343
01:29Application of Nonlinear Inequalities
357
A nonlinear inequality describes a comparison involving an expression that curves or behaves more complexly than a straight line. These inequalities often appear in forms that include squares, products, or variables in the denominator.To solve such an inequality, one starts by rewriting it so that zero appears on one side. For example, the inequality: can be factored as: This form makes it easier to identify the values that cause the expression to equal zero. In this case, the...
357
01:16Statically Indeterminate Problem Solving
948
Statically indeterminate problems are those where statics alone can not determine the internal forces or reactions. Consider a structure comprising two cylindrical rods made of steel and brass. These rods are joined at point B and restrained by rigid supports at points A and C. Now, the reactions at points A and C and the deflection at point B are to be determined. This rod structure is classified as statically indeterminate as the structure has more supports than are necessary for maintaining...
948
01:29Mathematical Modeling: Problem Solving
576
Mathematical modeling transforms real-world scenarios into mathematical expressions, allowing for structured problem-solving and analysis. This process involves defining the situation, assigning variables to measurable quantities, selecting an appropriate model, and solving the resulting equation. Such models are invaluable in finance, providing precise methods to evaluate investments, loans, and repayment structures.A widely used example is the calculation of fixed monthly payments on a loan,...
576
01:27Linear Equations
1.1K
Linear equations form the foundation of many algebraic and real-world applications, characterized by their simplicity and utility. A linear equation is an algebraic statement in which each term is either a constant or a product of a constant and a single variable. These equations represent straight lines when plotted on a Cartesian coordinate plane, reflecting a constant rate of change between two quantities.A typical linear equation in one variable has the form: ax + b = c, where a, b, and c...
1.1K
01:25Introduction to Nonlinear Inequalities
326
Linear and nonlinear inequalities are fundamental for analyzing variable relationships and identifying ranges satisfying specific conditions. A linear inequality involves variables raised only to the first power, resulting in a straight-line graph. This line partitions the coordinate plane into two distinct regions: one that satisfies the inequality and one that does not. Each region represents a set of solutions where the linear relationship holds true under the specified constraint.Nonlinear...
326