Mountain Valley Health Network

Decision Variables:

Objective Function:

Constraints:

Use the attached template to formulate and solve this as a linear programming problem with the goal of minimizing the total cost of the advertising campaign while reaching at least $24,000,000($i$.$e$.24,000($in $1000$s$)).$

Answer the following questions clearly in the Excel file:

$1.$ How many placements are needed in each advertising medium to minimize the total cost?

$2.$ What is the minimum cost of the campaign under the conditions specified?