Please Solve BIP Problem in Excel using solver, please include screenshots of all steps and final answers. !!No hand calculations!!

The CDT assigns ship-guards to various districts. The minimum number of required visits for each district is provided below (e.g. district 1 requires 30 visits if ships 1 is assigned to it). Each ship is available only 50 times per week. Assign a ship to each district such that the total cost of operating ship-guards becomes minimum. The cost of each ship visiting each district is presented in the table. 13 District i Ship, j 1 2 3 4 5 6 1 Cost (000's) $130 $30 $510 $30 $340 $20 Time (weeks) 30 50 10 11 9 2 Cost (000's) $460 $150 $20 $40 $30 $450 Time (weeks) 10 20 60 10 10 17 Cost (000's) $40 $370 $120 $390 $40 $30 Time (weeks) 70 10 10 15 8 12 3 The CDT assigns ship-guards to various districts. The minimum number of required visits for each district is provided below (e.g. district 1 requires 30 visits if ships 1 is assigned to it). Each ship is available only 50 times per week. Assign a ship to each district such that the total cost of operating ship-guards becomes minimum. The cost of each ship visiting each district is presented in the table. 13 District i Ship, j 1 2 3 4 5 6 1 Cost (000's) $130 $30 $510 $30 $340 $20 Time (weeks) 30 50 10 11 9 2 Cost (000's) $460 $150 $20 $40 $30 $450 Time (weeks) 10 20 60 10 10 17 Cost (000's) $40 $370 $120 $390 $40 $30 Time (weeks) 70 10 10 15 8 12 3