Wal-Mart Staffing Schedule
Not what you're looking for?
Wal-Mart, a discount store chain, has completed its new store in Rock Springs, Maryland. The 150,000 square foot store operates seven days per week and requires the following number of full-time employees working each day of the week.
Number of Employees
Sunday 47
Monday 22
Tuesday 28
Wednesday 35
Thursday 34
Friday 43
Saturday 53
Each employee must work five consecutive days each week and then has two days off. For example, any employee who works Sunday through Thursday has Friday and Saturday off. The store currently has a total of 60 employees available to work. Wal-Mart has developed the following prioritized goals for employee scheduling:
? The store wants to avoid hiring any additional employees.
? The most important days for the store to be fully staffed are Saturday and Sunday.
? The next most important day to be fully staffed is Friday
? The store wants to be fully staffed from Monday through Thursday.
a. Formulate a linear goal programming model to determine the number of employees who should begin their five-day workweek each day of the week in order to achieve the store's objectives.
b. Determine the solution that will best achieve the company's goals in employee scheduling. Interpret the solution results including the levels of goal achievement.
Purchase this Solution
Solution Summary
The solution provides step-by-step explanations and Excel Solver codes for both full-time and part-time scenarios.
Solution Preview
Please see the attached files.
I have done this part in the attached Excel file using the Tool -> Solver option. I hope you're familiar with this technique in Excel. Basically the constraints are that the ...
Purchase this Solution
Free BrainMass Quizzes
Graphs and Functions
This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.
Solving quadratic inequalities
This quiz test you on how well you are familiar with solving quadratic inequalities.
Probability Quiz
Some questions on probability
Geometry - Real Life Application Problems
Understanding of how geometry applies to in real-world contexts
Multiplying Complex Numbers
This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.