You will no doubt recognize the template below. It is taken directly from Chapter 6, Problem 5 as assigned for practice in Week #8. Please reread that problem now. Recall that, when that linear program was crafted, the optimal value of our objective function was exactly $57,925. Now, imagine that we do NOT want to allow Client A to work with Campbell. (They just don't get along!) Modify the spreadsheet as needed for this purpose and then craft a related linear program in Solver. Run the LP so that I can see the output here. (23 pts.) Then answer the question below the template in Row 27. (2 pts.) RATE (AKA - REVENUE) TABLE CLIENT A CLIENT B CLIENT C CLIENT D AVERY 100 125 115 100 BAKER 120 135 115 120 CAMPBELL 155 150 140 130 ASSIGNMENT TABLE CLIENT A CLIENT B CLIENT C CLIENT D TOTAL MAX ALLOWED AVERY BAKER CAMPBELL TOTAL MAXIMUM ALLOWED TOTAL REVENUE Given this result, how much revenue did we lose when we decided NOT to allow Client A to work with Campbell?