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
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question
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
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 2 steps with 3 images
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.