Please answer A, B, C, and D on paper AND on Excel using Solver.

A national retail chain receives credit card payments from four regions of the country (West, Midwest, East, and South). The average daily payments from each region are given in the table. This companys management must decide where customers should mail their payments. An annual interest rate of 18% can be earned on cash received. The company is considering setting up payment centers in four cities: San Francisco, St. Louis, Philadelphia, and Tampa. The average number of days that elapse between the time a payment check is mailed and the time the check is credited to one of the companys accounts are also given in Table. The annual cost of operating a payment center is $100,000.

Moreover, each payment center that is opened could handle at most $270,000 per day in payments. All of the customers in each region must send all of their payments to a single payment center. This company wants to determine the payment center configuration that minimizes the sum of annual lost interest and center operating costs. Formulated and solved an integer programming model to help the company solve its decision problem.

1. Define the decision variables
2. Define the objective function
3. Define the constraints
4. Determine an optimal solution

Lockbox location Tampa Check origin West Philadelphia 4 Payments per day $115,000 San Francisco 3 4 5 St. Louis 3 3 4 Midwest $125,000 3 East South 4. $140,000 $130,000