Formulate an optimization model for this problem.

Operations Research : Applications and Algorithms
4th Edition
ISBN:9780534380588
Author:Wayne L. Winston
Publisher:Wayne L. Winston
Chapter3: Introduction To Linear Programming
Section3.5: A Work-scheduling Problem
Problem 5P
icon
Related questions
Question

ACE Hardware wants to develop a daily schedule for its employees in one of its stores in Omaha. Currently,
this store has five employees and the store is opened from 12pm to 9pm. The store must always have at least
two people on hand. Each employee must work at least four hours and no more than eight hours per day.
Employee #1 goes to school and cannot start before 4pm while all other employees can work at any time.
Furthermore, employee #1 earns $10 per hour while all other employees earn $12 per hour. Because all five
employees live so close to the store, you must assume that they do not need to work consecutive hours.
a) Formulate an optimization model for this problem.
b) Solve the optimization model using either the Microsoft Excel Solver or the IBM ILOG CPLEX
Optimization Studio.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Bayes' Theorem
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Operations Research : Applications and Algorithms
Operations Research : Applications and Algorithms
Computer Science
ISBN:
9780534380588
Author:
Wayne L. Winston
Publisher:
Brooks Cole