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 am to pm 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. Fulltime tellers work am to pm five days a week, with one hour off each day for
lunch. The bank determines when a fulltime employee takes their lunch hour, but each teller must go between noon and pm or
between pm and pm Fulltime employees are paid $ per hour, which includes payment for their lunch hour. The bank can also
hire parttime tellers. Each parttime teller must work exactly three consecutive hours each day. A parttime teller is paid $ per hour.
To maintain an adequate quality of service, the bank has decided that at most five parttime 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 $
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
