Please Answer question using attached excel information

DATA FOR SIMPLEX METHOD

DATA FOR GRG NONLINEAR METHOD

PLEASE PLEASE PUT STEP BY STEP ON HOW TO DO THE ANALYSIS IN EXCEL!!!!

Please apply Linear Programming to a following business scenario: A firm plans to use three different types of ads to attract potential customers to its product. The three ad choices are TV ads, Magazine ads, and Sunday Supplement. The following table shows the number of potential customers one ad can reach: 5 There are two categories of spending per ad as below (\$, Thousands): There are following constraints: Total Ad Budget 3,500 Total Planning Budget 1,500 Total Number of TV Ads 5 Find the optimal numbers of TV ads, Magazine ads, and Sunday Supplement so that the total number of the potential customers attracted by these ads can be MAXIMIXZED. Use the associated EXCEL file to implement your linear programming procedures. When you run the linear programming, choose both Simplex LP and GRG Nonlinear Solving Method and output the corresponding Answer Report worksheets in the EXCEL file and submit the EXCEL file to Canvas for grading. (100 points) DATA FOR SIMPLEX LP METHOD \begin{tabular}{|l|c|c|c|} \hline & \multicolumn{3}{|c|}{ Cost Per Ad (\$TThousands) } \\ \hline & TV Ads (TV) & Magazine Ads (M) & Sunday Supplement (SS) \\ \hline Ad Budget & 250 & 100 & 100 \\ \hline Planning Budget & 100 & 50 & 50 \\ \hline & & & \\ \hline Number of Ads & TV Ads (TV) & Magazine Ads (M) & Sunday Supplement (SS) \\ \cline { 2 - 4 } & 0 & 0 & 0 \\ \hline Max TV Spots & & & \\ \hline \end{tabular} D