The Pine Valley Credit Union is trying to schedule bank tellers. The credit union is open 8AM-6PM
Fantastic news! We've Found the answer you've been seeking!
Question:
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 $300 per day and part-time tellers $60 per day. At most six 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? remember that you may add as many calculation cells as you wish
FT Cost | $ 300.00 | Total Daily Salary Cost: | ||||
PT Cost | $ 60.00 | Tellers needed (by work schedule): | ||||
Max PT | 6 | 8-5 | 12-1 lunch | |||
9-6 | 1-2 lunch | |||||
parttime | no lunch | |||||
Needed | Time | 8 am - 5 pm | 9 am - 6 pm | Part Time | ||
8 | 8-9 | |||||
16 | 9-10 | |||||
12 | 10-11 | |||||
8 | 11-12 | |||||
18 | 12-1 | |||||
16 | 1-2 | |||||
10 | 2-3 | |||||
8 | 3-4 | |||||
8 | 4-5 | |||||
10 | 5-6 | |||||
Related Book For
Managerial Decision Modeling with Spreadsheets
ISBN: 978-0136115830
3rd edition
Authors: Nagraj Balakrishnan, Barry Render, Jr. Ralph M. Stair
Posted Date: