Homework Help is Here – Start Your Trial Now!
Business
Operations Management
he Bank of Seattle is open Monday through Friday from 9am to 5pm. From past experience, the bank knows that t needs the number of tellers shown in the table below at various times of the day. Bank of Seattle hires two types of tellers. Full-time tellers work 9am to 5pm, 5 days a week, with 1 hour off each day for lunch. The bank determines when a full-time employee takes his or her lunch hour, but each teller must go between 11am and hoon, noon and 1pm, or between 1pm and 2pm. Full-time employees are paid $25 per hour, including a paid lunch hour. The bank can also hire part-time tellers. Each part-time teller works exactly three consecutive hours each lay, starting at any specified hour (e.g., 10am-1pm), the same time every day of the week. A part-time teller is paid $17 per hour. To maintain adequate quality of service, the bank has decided that at all times (every hour of he day) there must be at least three full-time tellers working for each part-time teller. Determine how to meet he bank's teller requirements at the minimum cost. Build a linear programming spreadsheet model and solve it using Solver. Time of Day Tellers Required 9am – 10am 10am – 11am 11am – noon 7 Noon – 1pm 9 1pm – 2pm 8 2pm - Зpm 3pm – 4pm 4pm - 5pm 8 9.

he Bank of Seattle is open Monday through Friday from 9am to 5pm. From past experience, the bank knows that t needs the number of tellers shown in the table below at various times of the day. Bank of Seattle hires two types of tellers. Full-time tellers work 9am to 5pm, 5 days a week, with 1 hour off each day for lunch. The bank determines when a full-time employee takes his or her lunch hour, but each teller must go between 11am and hoon, noon and 1pm, or between 1pm and 2pm. Full-time employees are paid $25 per hour, including a paid lunch hour. The bank can also hire part-time tellers. Each part-time teller works exactly three consecutive hours each lay, starting at any specified hour (e.g., 10am-1pm), the same time every day of the week. A part-time teller is paid $17 per hour. To maintain adequate quality of service, the bank has decided that at all times (every hour of he day) there must be at least three full-time tellers working for each part-time teller. Determine how to meet he bank's teller requirements at the minimum cost. Build a linear programming spreadsheet model and solve it using Solver. Time of Day Tellers Required 9am – 10am 10am – 11am 11am – noon 7 Noon – 1pm 9 1pm – 2pm 8 2pm - Зpm 3pm – 4pm 4pm - 5pm 8 9.

Practical Management Science
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter4: Linear Programming Models
Section: Chapter Questions
Problem 104P
See similar textbooks
icon
Related questions
Question
The Bank of Seattle is open Monday through Friday from 9am to 5pm. From past experience, the bank knows that it needs the number of tellers shown in the table below at various times of the day. Bank of Seattle hires two types of tellers. Full-time tellers work 9am to 5pm, 5 days a week, with 1 hour off each day for lunch. The bank determines when a full-time employee takes his or her lunch hour, but each teller must go between 11am and noon, noon and 1pm, or between 1pm and 2pm. Full-time employees are paid $25 per hour, including a paid lunch hour. The bank can also hire part-time tellers. Each part-time teller works exactly three consecutive hours each day, starting at any specified hour (e.g., 10am-1pm), the same time every day of the week. A part-time teller is paid $17 per hour. To maintain adequate quality of service, the bank has decided that at all times (every hour of the day) there must be at least three full-time tellers working for each part-time teller. Determine how to meet the bank's teller requirements at the minimum cost. Build a linear programming spreadsheet model and solve it using Solver. Time of Day Tellers Required 9am – 10am 3 10am – 11am 5 11am - noon 7 Noon – 1pm 9. 1pm – 2pm 8 2pm - Зpm 3pm – 4pm 8 4pm - 5pm
Transcribed Image Text:The Bank of Seattle is open Monday through Friday from 9am to 5pm. From past experience, the bank knows that it needs the number of tellers shown in the table below at various times of the day. Bank of Seattle hires two types of tellers. Full-time tellers work 9am to 5pm, 5 days a week, with 1 hour off each day for lunch. The bank determines when a full-time employee takes his or her lunch hour, but each teller must go between 11am and noon, noon and 1pm, or between 1pm and 2pm. Full-time employees are paid $25 per hour, including a paid lunch hour. The bank can also hire part-time tellers. Each part-time teller works exactly three consecutive hours each day, starting at any specified hour (e.g., 10am-1pm), the same time every day of the week. A part-time teller is paid $17 per hour. To maintain adequate quality of service, the bank has decided that at all times (every hour of the day) there must be at least three full-time tellers working for each part-time teller. Determine how to meet the bank's teller requirements at the minimum cost. Build a linear programming spreadsheet model and solve it using Solver. Time of Day Tellers Required 9am – 10am 3 10am – 11am 5 11am - noon 7 Noon – 1pm 9. 1pm – 2pm 8 2pm - Зpm 3pm – 4pm 8 4pm - 5pm
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 3 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

How to determine B3:B5 and B:7 to B12

Solution
Bartleby Expert
SEE SOLUTION
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
SEE MORE TEXTBOOKS