Please show step-by-step on how to use excel solver to calculate the number of tellers needed by work schedule.

A D E F G H K L M N Q R 1 20 pts. 2 3 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. 4 5 6 7 Please note that the number of tellers must be integer. 8 9 10 11 12 13 14 no lunch 15 16 17 18 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 12-1 lunch 9-6 1-2 lunch parttime HOURS Tellers 0 0 0 Needed Time 8-5 9-6 part-time 8 8-9 1 0 0 Teller availability table 16 9-10 1 1 o Please fill it with O's and 1's based on the problem description to indicate each group's availability over time 12 10-11 1 1 1 8 11-12 1 1 1 18 12-1 0 1 1 This model will be tested on different sets of input data. 16 1-2 1 0 1 10 2-3 1 1 0 8 3-4 1 1 84-5 1 1 0 10 5-6 0 1 0 19 20 21 22 23 24 25 26 27 29