Did I do this question correctly? If not please show where I went wrong and how to fix it.

A company is taking bids on four construction jobs. Three contractors have placed bids on the jobs. Their bids (in thousands of dollars) are given in the file P05_52.xlsx. (A blank indicates that the contractor did not bid on the given job.) Contractor 2 can do only one job, but contractors 1 and 3 can each do up to two jobs. Determine the minimum cost assignment of contractors to jobs (Note that the data from P05_52.xlsx is already in the excel sheet).

Function F22 1 Bidding on contracts 2 2 Autobum Recently Financial Logical Used 5 Contractor 1 6 Contractor 2 7 Contractor 3 3 Bids on contracts (in $1000s) (large values me 4 9 Assignment of contractors to jobs 10 11 Contractor 1 12 Contractor 2 13 Contractor 3 14 Total 15 16 Required 17 18 Total cost ($1000) 19 20 21 22 23 24 Ready A PS-43 PS-46 STB 1 W 10 Y g Date&L& M Time Reference 54 47 W 1 VIEW -SUM(811:813) Trg le Anderson SEALICLA B View * More Functione SolverTable for Mac Tell me Define Name Use Formule Create from Selection SUMPRODUCTIB5:E7W1L:E13) Name Manager Job 1 Job 1 47 45 1 SUM(C11:C13) C ROUND 2 S Job 2 Job 2 46 52 Trace Trace Dependents e Show 2 fames Checking Wind D SUM(011-013) Job 3 Job 3 1 52 46 -55 SUM(E11E13) E wwwh C Job 4 Job 4 12 KS Damien Inglis SE/France F Total SUM81111 SUMB12-E12 SUM(813:13 Pap C G Shee H Max Mon Jun 27 3:11 PM a 8 Comments 1 Bidding on contracts 2 7 fix 3 Bids on contracts (in $1000s) (large values mean contractor didn't bid for that job) 4 Job 1 Job 2 5 Contractor 1 54 6 Contractor 2 Contractor 3 11 Contractor 1 12 Contractor 2 13 Contractor 3 14 Total 15 16 Required 17 18 Total cost ($1000) 19 20 21 22 23 24 A 8 9 Assignment of contractors to jobs 10 25 26 27 B 47 Job 1 0 W 1 47 45 Job 2 0 . 1 D Job 3 48 46 52 Job 3 0 1 Geography E Job 4 0 . 6 55 Job 4 1 52 46 F Total 0 = $B$11:SES13 SFS11:SFS13