Question: this is to be solved in excel. please show all steps. thanks Totem Bank is open weekdays 8 AM to 4 PM. Staffing include full-time

this is to be solved in excel. please show all steps. thanks this is to be solved in excel. please show all
Totem Bank is open weekdays 8 AM to 4 PM. Staffing include full-time tellers that work the full day with lunch breaks from either 11 AM - 12 PM or 12-1 PM and are paid $120 per day. Part-time tellers work either 9 AM - 1 PM (no break) or 12 PM - 4 PM (no break) for $55 per shift. The bank can schedule no more than three part-time tellers each day. The number of tellers required each hour is shown in the table below. Develop a linear Solver model to determine how the company can minimize daily labour costs. Hourly start 8 AM - 9 AM 9 AM - 10 AM 10 AM - 11 AM 11 AM - 12 PM 12 PM - 1 PM 1 PM - 2 PM 2 PM-3 PM 3 PM - 4PM Required 12 7 13 15 9 10 12 9

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!