) The Biggs Department Store chain has hired an advertising firm to determine the types and amount

of advertising it should invest in for its stores. The three types of advertising available are television

and radio commercials and newspaper ads. The retail chain desires to know the number of

each type of advertisement it should purchase to maximize exposure. It is estimated that each ad

or commercial will reach the following potential audience and cost the following amount:

The company must consider the following resource constraints:

1. The budget limit for advertising is $100,000.

2. The television station has time available for 4 commercials.

3. The radio station has time available for 10 commercials.

4. The newspaper has space available for 7 ads.

5. The advertising agency has time and staff available for producing no more than a total of

15 commercials and/or ads.

List the decision variables, briefly explain why you choose them

List the constraints, briefly explain why you think they are the constraints

Formulate the model summary which includes the objective functions and the constraints

Please Solve and show the problem using Excel