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