for part b we need to solve it in solver using excel

4. A contractor needs to assign 4 projects to 5 project managers. Each manager can manage only one project and each project can only be assigned to one manager. The cost (in $1000) to the contractor depends on the relavant experience/expertise of the managers. The following table summarize the costs. Manager Project A Project B Project C Project D #1 41 38 36 #2 48 43 40 38 #3 52 50 42 40 #4 51 46 46 42 #5 49 45 44 39 44 (a) Formulate a linear programming model to find the assignment that minimize total cost. Identify the objective function, the decision variables, and the constraints. (10 points) (b) Solve this problem using Excel Solver ar (c) Solve this problem using the Hungarian method. Show which engineer should be assigned to which task and the overall cost to the firm to complete the three tasks. (