Use optimization techniques to provide a recommendation on how to best allocate the $$875,000$

advertising budget across these three digital marketing options. Develop a linear programming model

that can be used to optimize the advertising budget allocation. $($HINT: you should define two

variables for each media option $($eg$.$ S$1=$ number of Social Media advertisements with rating of $100$

and $14000$ new customers and S$2=$ number of Social Media advertisements with rating of $65$ and

$5000$ new customers, and so on$).$ Enter the problem into Excel and use Solver to solve for the optimal

solution.