Please show or attach an excel file if you can to show how you figured it out

Part D. Bank Assignments. A bank distributes checks to different sites to be processed within a large metro area. Each site has the capacity to process different amounts of checks per day. The checks that need to be processed each day are personal, payroll, draft, and government. The total demand is different for each type of check. The cost to process each type of check varies with the site. These values are summarized in the table. Cost per check Sitel Site2 Site3 Site4 Sites Total Demand Checks/day Personal 2.85 Payroll Draft 1.78 Government 1.34 1.35 1.33 Total Capacity Checks/day 2.55 2.35 3.22 2.25 500 1.45 1.35 2.1 1.95 1.84 400 1.67 1.51 1.89 1.86 200 1.41 1.3 100 400 300 300 200 200 Question 13. What is the minimum cost that can be achieved and meet requirements? A. $2240 B. $2260 C. $2220 D. $2200 E. None of the above Question 14. From concern about a site processing a large number of one type of check, a limit of 200 transactions per type of check for each site is being considered. What is the minimum increase in cost due to this added constraint? A. $12 B. $20 C. si D. $125 E. None of the above Question 15. After the transaction limit was implemented for each type of check for each site, the demand for payroll checks was increased to 900 checks/day which increased the total demand for all the checks beyond the total capacity. What is the minimum cost of processing as many checks as possible with the available capacity? (Solution Note: The transaction limit does not apply to a dummy source.) A. $2169 B. $2259 C. $2579 D. $2489 E. None of the above