An electrical contractor pays his subcontractors a fixed fee plus mileage for work performed. On a given day the contractor is faced with three electrical jobs associated with various projects. Given below are the distances between the subcontractors and the projects.

$\backslash$table$[[,$Projects$],[$Subcontractor$,$A$,$B$,$C$],[$Westside$,70,56,36],[$Federated$,48,50,38],[$Goliath$,55,54,40]]$

How should the contractors be assigned so that total mileage is minimized?

a$.$ Solve manually using the Hungarian Method

b$.$ Solve using Excel Solver $($submit a hard$-$copy of the Excel spreadsheet$)$

An electrical contractor pays his subcontractors a fixed fee plus mileage for work performed. On a given day the contractor is faced with three electrical jobs associated with various projects. Given below are the distances between the subcontractors and the projects.

$\backslash$table$[[,$Projects$],[$Subcontractor$,$A$,$B$,$C$],[$Westside$,70,56,36],[$Federated$,48,50,38],[$Goliath$,55,54,40]]$

How should the contractors be assigned so that total mileage is minimized?

a$.$ Solve manually using the Hungarian Method

b$.$ Solve using Excel Solver $($submit a hard$-$copy of the Excel spreadsheet$)$