A s signment: Employee Assignment Schedule for new store in Mexico City

(Integer linear programming solution)

To the extent permitted by local law, each Acme Home Improvements store, including AMC, is open from 7 am - 11 pm every day. AMC planners have provided the following table, which identifies the minimum number of customer service employees needed on the floor each hour of the day:

Full-time employees at AMC work a 9 hour shift (8 hours of work plus a 1 hour meal break) either from 7 am to 4 pm or from 2 pm to 11 pm. Workers on the 7-4 shift are assigned an hour-long lunch break at either 10 am, 11 am or 12 noon. Workers on the 2-11 shifts are assigned an hour-long dinner break at either 5 pm, 6 pm or 7 pm.

Part-time employees work four consecutive hours per day and their shifts can start any time between 7 am and 7 pm.

By corporate policy, which is consistent with Mexican labor law, the company limits part-time hours to 50% of the day's total hours (part-time hours plus full-time hours) worked.

Part-time employees earn $300 per day, and full-time employees earn $750 per day in salary and benefits ($ = Moneda Nacional, ie, the Mexican peso).

To be solved

Using Excel Solver software, prepare an employee assignment schedule for Acme Mexico City that addresses the following tasks:

1. Prepare a minimum cost assignment schedule (modified by the quantitative considerations you incorporate)
2. Treatment of both full-time and part-time employees
3. The assumptions made and why
4. Overall, why this schedule should be recommended
5. A discussion of the process used to determine the schedule

Price: $10.46

Solution: The downloadable solution consists of 7 pages, 346 words.
Deliverable: Word Document