Betty Edwards is a college student whose summer job involves selling magazine subscriptions. She currently has four magazine subscriptions available and, according to company policy, she can only sell one subscription to any customer. She currently has four prospective customers, and these four customers are willing to pay different prices for the subscriptions to the four magazines. The profit table associated with sales of the four magazine subscriptions to the four customers is as follows.

Magazine	Customer 1	Customer 2	Customer 3	Customer 4
1	8	7	10	$5
2	9	6	11	8
3	7	6	9	9
4	10	8	7	11

To which customers should Betty Edwards try to sell which magazine subscriptions, in order to maximize profits?

Write the algebraic formulation for this problem

Set the problem up in Excel (you must use SUMIF functions) and solve using Solver.

Report the solution and objective result.