and solve using excel

2. A company is budgeting 15 million dollars to construct as many as 7 transmitters to cover as much population as possible in 15 contiguous geographical communities. The communities covered by each transmitter and the budgeted construction costs are given below. The table further below provides the populations of the different communities. Formulate an ILP that can determine which of the proposed transmitters should be constructed and solve it in Excel. Transmitter 1 2 Covered communities 1,2 23,5 1,7,9,10 4,6,8,9 6,7,9,11 5,7,10,12,14 12, 13, 14, 15 Cost (million 5) 3.60 2.30 4.10 3.15 2.80 2.65 3.10 5 6 Community 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Population (in 1000s) 4 3 30 9 10 13 11 6 12 7 5 36 14 6 7