Dig back into your original mathematical models for each assigned problem. Make sure the whole team understands:

The objective function $($what are we trying to maximize or minimize?$)$

The decision variables $($what choices are we making?$)$

The constraints $($limitations on resources or requirements$)$

Dorian Auto manufactures and sells cars and vans. The company wants to launch a TV advertising campaign and has to decide to buy advertisement slots in two types of programs: entertainment and football.

Each advertisement in the entertainment program is watched by $6$ million women and $2$ million men.

Each football match is watched by $3$ million women and $8$ million men.

An advertisement in the entertainment program costs $50,000$ and an advertisement in the football program costs $100,000.$

Dorian Auto would like the advertisements to be seen by at least $30$ million women and $24$ million men.

Dorian Auto wants to know how many advertisements it should purchase in each type of program so that the cost of the advertising campaign is minimized.

In Excel Solver, find the solution to all the models.