Question: Problem 3 : A bank has 4 sites at which checks are processed. Site 1 can process 5000 checks per day, site 2 can process
Problem 3: A bank has 4 sites at which checks are processed. Site 1 can process 5000 checks per day, site 2 can process 6000 checks per day, site 3 can process 7000 checks per day, and site 4 can process 8000 checks per day. The bank processes 4 types of checks: vendor, salary, household, and personal. The processing cost per check (in cents) depends on the site and is given on the table below. Each day, 9000 vendor checks, 8000 salary checks, 6000 household checks, and 7000 personal checks need to be processed. The objective is to minimize the total daily cost of processing checks.
|
| Site (cents) | |||
| Check | 1 | 8 | 0 | 7 |
| Vendor | 7 | 6 | 7 | 5 |
| Salary | 1 | 2 | 3 | 6 |
| Household | 6 | 5 | 4 | 7 |
| Personal | 4 | 4 | 5 | 5 |
a) Set up a form to run Solver. (1 point) b) Write down a table for the optimal solution, which includes the number of each type of checks processed at each site, the corresponding unit costs and the minimum total cost. (1 point) c) Write down the quantity of each type of checks that cannot be processed at any site. (0.5 point) Note: If your file (sheet 3) contains one the following errors, then your score for this problem is 0: there is no Solver form; there is a Solver form but when rerunning, it displays a different optimal total cost; your answer in part (b) does not match with the result produced by Solver.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
