Media Selection 1 Excel Solver Computer Project Lotto Plus Gambling promotes gambling junkets from a large city to casinos in The Southern resorts. The club has budgeted up to R8 000 per week for local advertising. The money is to be allocated among four promotional media: TV spots, newspaper ads, and two types of radio advertisements. Lotto Plus's goal is to reach the largest possible high-potential audience through the various media. The table below presents the number of potential gamblers reached by making use of an advertisement in each of the four media. It also provides the cost per advertisement placed and the maximum number of ads that can be purchased per week. MEDIUM AUDIENCE COST PER AD MAXIMUM ADS REACHED PER AD PER WEEK TV spot (1 minute) 5 000 R 800 12 Daily newspaper (full-page ad) 8 500 R 925 5 2 400 R 290 25 Radio spot (30 seconds, prime time) Radio spot (1 minute, 2 800 R 380 20 afternoon) Lotto Plus's contractual arrangements require that at least five radio spots be placed each week. To ensure a broad-scoped promotional campaign, management also insists that no more than R1 800 be spent on radio advertising every week. (a) Formulate a linear programming model for this problem. (19) (b) Set up a spreadsheet model for this problem and use the Excel Solver to find the optimal solution. (46) (c) State the optimal solution and the value of the objective function