Question: The Northside Bank is working to develop an efficient work schedule for full - time and part - time tellers. The schedule must provide for
The Northside Bank is working to develop an efficient work schedule for fulltime and parttime tellers. The schedule must provide for efficient operation of the bank, including adequate customer service, employee breaks, and so on On Fridays, the bank is open from : AM to : PM The number of tellers necessary to provide adequate customer service during each hour of operation is summarized here.
Time No of Tellers Time No of Tellers
: am: am: pm: pm
: am: am: pm: pm
: amNoon : pm: pm
Noon: pm: pm: pm
: pm: pm: pm: pm
Each fulltime employee starts on the hour and works a hour shift, followed by a hour break and then a hour shift. Parttime employees work one hour shift beginning on the hour. Considering salary and fringe benefits, fulltime employees cost the bank $ per hour $ a day and parttime employees cost the bank $ per hour $ per day
a Formulate an integer programming model that can be used to develop a schedule that will satisfy customer service needs at a minimum employee cost. Hint: Let xi number of fulltime employees coming on duty at the beginning of hour i and yj number of parttime employees coming on duty at the beginning of hour j
If your answer is zero enter and if the constant is it must be entered in the box.
Min
x
x
x
y
y
y
y
y
y
y
st
x
x
x
y
y
y
y
y
y
y
Select your answer
Time : am: am
x
x
x
y
y
y
y
y
y
y
Select your answer
Time : am: am
x
x
x
y
y
y
y
y
y
y
Select your answer
Time : amNoon.
x
x
x
y
y
y
y
y
y
y
Select your answer
Time Noon: pm
x
x
x
y
y
y
y
y
y
y
Select your answer
Time : pm: pm
x
x
x
y
y
y
y
y
y
y
Select your answer
Time : pm: pm
x
x
x
y
y
y
y
y
y
y
Select your answer
Time : pm: pm
x
x
x
y
y
y
y
y
y
y
Select your answer
Time : pm: pm
x
x
x
y
y
y
y
y
y
y
Select your answer
Time : pm: pm
x
x
x
y
y
y
y
y
y
y
Select your answer
Time : pm: pm
xi yj and integer for i and j
b Solve the LP Relaxation of your model in part a Enter the total cost value under the optimal solution.
Total Cost: $
c Solve for the optimal schedule of tellers. Enter the total number of fulltime and parttime employees required.
If your answer is zero enter
Total Number of FullTime Employees:
Total Number of PartTime Employees:
d After reviewing the solution to part c the bank manager realized that some additional requirements must be specified. Specifically, she wants to ensure that one fulltime employee is on duty at all times and that there is a staff of at least six fulltime employees. Revise your model to incorporate these additional requirements, and solve for the optimal solution. Enter the total number of fulltime and parttime employees required and the total cost under the revised optimal solution.
If required, round your answers to the nearest whole number. If your answer is zero enter
Total Number of FullTime Employees:
Total Number of PartTime Employees:
Total Cost: $
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
