Question: Assignment Model:

Assume you have four cases that need immediate legal services, there are four lawyers available in town, and each case only needs one lawyer to work on it. According to the association (like BAR) policy in your town, every lawyer can only accept one case from you. The table listed below shows hourly rate each lawyer charges you if she/he works on relevant cases. Suppose you want to have all cases handled immediately, while ignoring the time duration differences, please use a simple assignment model to find the optimal strategy.

1. Establish a mathematical linear programming model.
   (Note: You must list clearly and completely the whole LP model in its mathematical format and structures).
2. Using Excel Solver, find the optimal solutions for minimizing the hourly legal service costs.

(Note: You must provide Excel spreadsheet setup, Solver setup, Solver Answer Report, and discuss in completeness your strategy.)

Price: $2.99

Solution: The downloadable solution consists of 5 pages
Deliverable: Word Document