3. Scheduling at the Bank of Tacoma The Bank of Tacoma 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 Tacoma 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 $24 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 $16 per hour. To maintain adequate quality of service, the bank has decided that at all times 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. Tellers Required Time of Day 9am-10am. 10am - 11am 11am-noon Noon-1pm 1pm-2pm 2pm-3pm 3pm - 4pm 4pm-5pm 34686STO 5 10 hhhF Pr
3. Scheduling at the Bank of Tacoma The Bank of Tacoma 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 Tacoma 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 $24 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 $16 per hour. To maintain adequate quality of service, the bank has decided that at all times 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. Tellers Required Time of Day 9am-10am. 10am - 11am 11am-noon Noon-1pm 1pm-2pm 2pm-3pm 3pm - 4pm 4pm-5pm 34686STO 5 10 hhhF Pr
Chapter6: Managing Multiple Worksheets And Workbooks
Section: Chapter Questions
Problem 2.3CP
Related questions
Question
Transcribed Image Text:File Edit View Sign Window Help
Home Tools
eh
U
&
O
PS1
→
X
Module 1 Linear Pr...
2 / 2
H
0
Q
87%
3. Scheduling at the Bank of Tacoma
The Bank of Tacoma 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
Tacoma 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 $24 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 $16 per hour. To maintain adequate quality
of service, the bank has decided that at all times 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
9am -10am
10am - 11am
11am-noon
Noon-1pm
1pm-2pm
2pm-3pm
3pm - 4pm
4pm-5pm.
H
Tellers Required
3
4
6
8
6
5
7
10
35
9 / 1 D
X
d
Find
hhhhhd
Previous
<
Q
ENG
IN
Next
40
☀
10:05 AM
6/27/2022
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage