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...

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.