Complete answer please

Create a spreadsheet model and solve it using Solver. (Upload your EXCEL file) A department store has leased a new store and wishes to decide how to place four departments in four locations so as to maximize total profits. The table below gives the profits, in dollars, when the departments are allocated to the various locations. Find the assignment that maximizes total profits Location 3 4 5 Department 1 2 1 20 29 30 24 31 2 25 28 24 21 24 3 27 27 25 28 20 4 23 25 24 22 25 5 24 30 26 30 25