Problem $2(40\%)$: Chapter $2$ Question $6.$ Some changes$/$clarifications have been made to the text. See bolded parts below:

Widespread is a marketing company which helps clients design ads for their products. One of its client, Wolf Apothecary is now asking Widespread to allocate the marketing budget of $$14,000$ per month among four promotional media: TV ads, Facebook, newspaper ads, and direct mailing. The budget of $$14,000$ does not necessarily need to be completely spent. The goal of the client is to reach the maximum number of potential buyers through various promotional media. The estimated cost and reachable audience for each medium is given as follows:

Table unchanged

Wolf Apothecary requires that at least $4$ TV ads and $8$ newspaper ads be placed every month. They also require that at least $20\%$ of the total money spent should be spent on Facebook ads and no more than $15\%$ of the total money spent should be spent on direct mailing.

$$ Complete part a$.$ and include this model in a textbox.

$$ Complete part b$.($ignore $$and print out your Excel worksheet$)$

$$ Use Solver to solve the LP model and generate an Answer Report and Sensitivity Report.

$$ What is the optimal solution and what is the optimal value? Put this in a textbox.