Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The Pine Valley Credit Union is trying to schedule bank tellers. The credit union is open 8AM-6PM and needs a certain number of tellers
The Pine Valley Credit Union is trying to schedule bank tellers. The credit union is open 8AM-6PM and needs a certain number of tellers each hour (see table below). Full-time tellers can work 8AM-5PM with 12PM-1PM lunch hour or 9AM-6PM with 1PM-2PM lunch hour. Part-time tellers work 10AM-2PM. Full-time tellers receive $160 per day and part-time tellers $70 per day. At most four part-time tellers can be hired. Please note that the number of tellers must be integer. How can the credit union minimize their daily teller salary cost? FT Cost $ 160.00 Total Daily Salary Cost: remember that you may add as many calculation cells as you wish PT Cost $ 70.00 Tellers needed (by work schedule): Max PT 4 8-5 9-6 12-1 lunch 1-2 lunch parttime no lunch Tellers Needed Time 8-5 9-6 part-time 88-9 16 9-10 12 10-11 8 11-12 18 12-1 16 1-2 10 2-3 8 3-4 84-5 10 5-6 Teller availability table Please fill it with O's and 1's based cription to indicate each group's availability over time This model will be tested on different sets of input data.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started