Homework subject:

An advertising company wants to determine the most effective advertisement according to

its current advertising budget. The company has four communication tools: television, radio,

magazine, and newspaper. The information in the table below was obtained by the marketing

research group.

The company does not want to spend more than $5,600,000TL$ on advertising.

Also, other requests are:

The advertisement must reach at least $1,900,000$ male customers.

The advertisement must reach at least $1,600,000$ female customers.

The number of advertisements to be given on television should be at least $4.$

No more than $10$ advertisements should be placed in the magazine.

The number of advertisements should be between $6$ and $20$ for each of the radio and

newspaper communication tools.

The company wants to determine how much advertisement should be given in each

communication tool to maximize the total number of customers reached.

Accordingly, create a linear programming model of the problem and solve the problem with

the Excel$-$Solver add$-$in$.$

you can send the Excel file by this email:khaledrak$290$@Icloud.com

it must be solved in Excel using solver add in

thank you