Please provide the excel formulas for the different cells: Catch 22 Realty, Inc., has identified four small apartment buildings (A1, A2, A3, and A4) in Richardson, TX, in which it would like to invest. Mr. Shaw, the manager at the firm, approaches three local banks (B1, B2, and B3) for financing. Each bank has placed a credit ceiling on how much it will lend. Moreover, each loan officer has set a different interest rate on each of the four properties. Relevant information has been summarized in the table below. Set up for Solver and solve it.

2 Catch 22 Realty, Inc., has identified four small apartment buildings (A1, A2, A3, and A4) in Richardson, TX, in which it would like to invest. Mr. Shaw, the manager at the firm, approaches three local banks (B1, B2, and B3) for financing. Each bank has placed a credit ceiling on how much it will lend. Moreover, each loan officer has set a different interest rate on each of the four properties. Relevant information has been summarized in the table below. Set up for Solver and solve it. Interest rate (%) Local bank Apt 1 Apt 2 Apt 3 Apt 4 Maximum credit line 8 Bank 1 Bank 2 Bank 3 11 8 12 10 10 10 11 8 9 10 $130,000 $80,000 $120,000 9 Selling price $50,000 $60,000 $70,000 130000 Since each of the four apartment buildings is equally attractive as an investment to Mr. Shaw, he decides to purchase all of them. Formulate the problem as a linear program that can be used to determine the financing plan with the minimum total interest cost. Formulation Variable Description Objective Function Subject to