To the extent permitted by local law, each Acme Home Improvements store, including AMC, is open from 7 am - 11 pm every day. Acme Mexico City planners have provided the following table, which identifies the minimum number of customer service employees estimated to be needed on the floor of the store each hour of the day:
Customer Service Employees
Minimum number needed on the floor
7 am - 8 am
8 am - 9 am
9 am - 10 am
10 am - 11 am
11 am - 12 pm
12 pm - 1 pm
1 pm - 2 pm
2 pm - 3 pm
3 pm - 4 pm
4 pm - 5 pm
5 pm - 6 pm
6 pm - 7 pm
7 pm - 8 pm
8 pm - 9 pm
9 pm - 10 pm
10 pm - 11 pm
Full-time customer service 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 11 am or 12 noon. Workers on the 2-11 shift are assigned an hour-long dinner break at either 5 pm or 6 pm.
Part-time customer service employees work four consecutive hours per day and their shifts can start any hour between 7 am and 7 pm.
By corporate policy, which is consistent with Mexican labor law, the company limits part-time customer service employees hours to 50% of the day's total required hours.
Further, in the interest of proper supervision of employees and employee safety, management has a policy that the actual number of customer service employees on the floor in the store should never exceed 30 during any given time period.
Part-time customer service employees earn $500 per day, and full-time customer service employees earn $1100 per day in salary and benefits
Each student prepares a customer service employee daily assignment schedule for Acme Mexico City that addresses the following tasks:
An executive summary
An optimal schedule for full-time and part-time customer service employees that minimizes personnel costs to the extent congruent with the qualitative factors that you determine are relevant
A discussion of the process used to determine the schedule, to include a discussion of all model assumptions and of your qualitative factors
I have attached an Excel file which has the model results to answer your question 1. The response to question 2 is below.
The process that was used to determine the ...
The solution goes into a great amount of detail regarding the question being asked. Step by step explanation is provided for each part of the question which makes it very easy to follow along for anyone with just a basic understanding of the concepts. Overall, an excellent response to the question being asked.