Question: Use LP Simplex model in excel, show excel spreadsheet Maumee City National Bank is open Monday through Friday from 9 a . m . to

Use LP Simplex model in excel, show excel spreadsheet
Maumee City National Bank is open Monday through Friday from 9 a.m. to 5 p.m. From experience, the bank knows that it needs the
number of tellers shown in the following table:
Maumee City Bank hires two types of tellers. Full-time tellers work 9 a.m. to 5 p.m. five days a week, with one hour off each day for
lunch. The bank determines when a full-time employee takes their lunch hour, but each teller must go between noon and 1 p.m. or
between 1 p.m. and 2 p.m. Full-time employees are paid $21 per hour, which includes payment for their lunch hour. The bank can also
hire part-time tellers. Each part-time teller must work exactly three consecutive hours each day. A part-time teller is paid $18 per hour.
To maintain an adequate quality of service, the bank has decided that at most five part-time tellers can be hired. Determine how to
meet the bank's daily teller requirements at a minimum cost.
Round to two decimal places.
Total daily cost = $
Use LP Simplex model in excel, show excel

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!