A population census will be organized in a city which involves home visits to randomly selected domestic households in 18 districts. Table 1 gives the relevant data for each district. A planning officer needs to assign the households to 5 different teams of checkers/enumerators. To coordinate with the district offices, all the selected households in a given district should be assigned to exactly one team. The planning officer would like to balance the workload in each team as much as possible. Workload can be defined here as the total number of households assigned to a team. One approach is to minimize the maximum workload (total number of households) to be assigned to any team. Table 1: Number of randomly selected domestic households in 18 districts District 1 2 3 4 5 6 7 8 9 Number of 863 618 1865 857 1207 1671 1486 1473 2474 selected households District 10 11 12 13 14 15 16 17 18 Number of 1785 1113 1995 2364 1230 1106 2469 1714 715 selected households (a) Formulate the problem by an integer linear program to determine an optimal assignment plan that would minimize the maximum workload assigned to any team. (b) Develop an Excel spreadsheet model for part (a) and use Solver to compute an optimal assignment plan. Request Excel to "Keep Solver Solution", and generate "Answer Report". (In the Excel Solver "Options", you may use the default setting of 1% for "Integer Optimality".) (c) From the results in part (b), report the following: (i) The districts and workload assigned to each team (ii) Maximum workload among the teams (iii) Minimum workload among the teams