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

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!

QUESTION 26 50 Please model the following decision in a spreadsheet, optimize it using MS-Excel Solver, and then upload that spreadsheet by attaching it to this question. I will grade this question...

Please model the following decision in a spreadsheet, optimize it using MS-Excel Solver, and then upload that spreadsheet by attaching it to this question. I will grade this question on the accuracy...

The personnel- Planning problen of lexington bank. The main branch of lexington bank is open for retail business from 8:00am to 4:00pm weekdays. the staffing requires 8 to 15 tellers on duty...

GRADUATE CERTIFICATE IN PROJECT MANAGEMENT PROJ5010: PROJECT PROCUREMENT AND STRATEGIC SOURCING. CASE STUDIES CONTENTS 1. Proj5010: The World Bank RFP Case Study covers 1. Assignment 1: Marks = 5 2....

BUS 370 QUEUEING CASE 1. Cases for BUS 370 are take-home, open-book, open-notes, open-library, etc. You may consult any written materials other than another (past or present) team's case or work...

Project. Workforce Planning Mexico City Bank of Commerce and Industry is a busy bank that needs different number of tellers depending on the time of day due to different numbers of customers needed...

AMB Bank is a busy bank that has requirements for between 10 and 20 tellers depending on the time of day. The busiest time is usually from 12 pm to 3 pm when people are taking their lunch break....

please help me to find the answer for part 1, part3 and part4 Queensland University of Technology QUT Business School School of Accountancy AYB 339 Accountancy Capstone Integrated Case Study Semester...

i need a tutor to help me finish the financial planning assignment. 1202AFE Financial Planning 1 Semester 2, 2016 File Note - Statement of Advice Client's name: Date of contact: Re: Liam Sem 17...

Three point charges are located at the corners of an equilateral triangle as in Figure. Calculate the net electric force on the 7.00-C charge. 100 0.500 m 60.0 -4.00 C 2.00 C

You have 17.5 g of oxalic acid, H2C204. What amount is represented by 17.5 g of oxalic acid? How many molecules of oxalic acid are in 17.5 g? How many atoms of carbon are in 17.5 g of oxalic acid?...

Which factor does NOT impact the automobile insurance pricing?Vehicle usageColour of the vehicleTerritory the vehicle is garaged or driven inDriver experience

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...