The stadium manager wants to install CCTV cameras at different locations for security reasons. Each location covers some areas of stadiums, and the goal is to put the least amount of cameras such that all areas of stadiums are covered. The stadium has areas from 1 to 15, and possible camera locations from 1 to 8.

Camera location 1 covers stadium areas {1,3,4,6,7}, camera location 2 covers stadium areas {4,7,8,12}, while the remaining camera locations and the stadium areas that the cameras can cover are given in the table below:

Table. Camera Location vs Stadium Area

Camera Location

1

2

3

4

5

6

7

8

Stadium Area

1,3,4,6,7

4,7,8,12

2,5,9,11,13

1,2,14,15

3,6,10,12,14

8,14,15

1,2,6,11

1,2,4,6,8,12

(a) Formulate a spreadsheet model and solve this BIP problem. In which locations should the minimum number of cameras be installed?