Daily Schedule for Acme Customer Service Employees

MEMORANDUM

To: Mr. Manager, Store Manager, Acme Mexico City

From: Working Employee, XYZ Consulting Company

Date: February 6, 2009

Subject: Daily Schedule for Acme Customer Service Employees

Based on the requirements of the proposal to develop a minimum cost daily assignment schedule for the customer service employees at the Acme Mexico City store, this memo will discuss the model developed to achieve optimal efficiency at a minimum cost to the company.

An integer linear program was developed to address the problem of labor restrictions. The model used to develop the assignment schedule for the Acme Mexico City store took into account the store hours of 7:00 a.m. - 11:00 p.m. daily, Mexican labor law, and employee safety and supervision rules. With the number of employees starting at each shift listed in the following table, the Acme Mexico City store will be able to meet the daily number of employees required for each shift and stay equal to or below the maximum number of employees allowed to work at a time.

|Shift |Start Time |End Time |# |

|Early 11 |7:00 |16:00 |7 |

|Early 12 |7:00 |16:00 |2 |

|Late 5 |14:00 |23:00 |6 |

|Late 6 |14:00 |23:00 |6 |

|PT 7 |7:00 |11:00 |1 |

|PT 8 |8:00 |12:00 |2 |

|PT 9 |9:00 |13:00 |13 |

|PT 10 |10:00 |14:00 |4 |

|PT 11 |11:00 |15:00 |0 |

|PT 12 |12:00 |16:00 |0 |

|PT 13 |13:00 |17:00 |0 |

|PT 14 |14:00 |18:00 |5...