$1.$ Trace precedents and dependents on the two cells with errors: F$9$ and E$7.2.$ Use Error Checking to evaluate the error in cell F$9.$ Use the solution suggested by Error Checking. $3.$ Trace the error in cell E$7.$ Because the Social Media cost of zero is valid, the division error appears. In cell E$7,$ type $=$E$5$ because all people might be reached by Social Media with no cost$.4.$ Use Solver to determine the best mix of advertising for the advertising dollars. The costs for the month of June are already in the worksheet $($B$6$:D$6).$a$.$ The objective is an advertising budget of $$10,500($the Value Of parameter$),$ which will display in cell F$11.$b$.$ Set the Value Of parameter to $10500.$c$.$ The changing variables cells are B$9$:D$9.$d$.$ The constraints are as follows: the newspaper allows a maximum of $14$ ads per week, the radio station allows a maximum of $30$ advertisement spots per week, and the TV station allows a maximum of $21$ advertisements per week. The Ads Placed values must be positive whole numbers $($Hint: Use the int operator as well as the $>=$ operator, and turn off $$ignore integer constraints.$)$e$.$ Use the Simplex LP solving method. $5.$ After you click the Solve button $($Solver Parameters dialog box$),$ use the Save Scenario button $($Solver Results dialog box$)$ to save the scenario with the name, June. $6.$ Instruct Solver to create the Answer Report for your solution. Rename the answer report tab, June Advertising Report. Change the tab color to $$Blue$,$ Accent $1.$ Move the worksheet to the right of the $$Festival Ad Placement$$ worksheet. $7.$ Create a second solution using Solver. This solution is for the larger, October festival and will have an advertising budget of $$25,000.8.$ After you click the Solve button $($Solver Parameters dialog box$),$ if the Solver Results dialog box says it cannot find a solution, click the $$Solve Without Integer Constraints$$ option button and solve again. Use the Save Scenario button $($Solver Results dialog box$)$ to save the scenario with the name, October. $9.$ Create an answer report. Rename the answer report tab, October Advertising Report. Change the tab color to $$Orange$,$ Accent $2.$ Move the worksheet to the right of the other worksheets. $10.$ Change cells B$9$:D$9$ back to zero, so the summary report you create in the next step will begin with zeroes. $11.$ Use Scenario Manager to create a summary report. When Excel displays the Scenario Summary dialog box, type B$9$:D$9,$F$10$:F$11$ as the Result cells box. $12.$ Name the resulting summary tab, Advertising Summary. Change the tab color to $$Green$,$ Accent $6.$ Move the worksheet to the right of the other worksheets. $13.$ Save the file with the file name, SC$\_$EX$\_9\_$FestivalAdvertising, and submit the revised workbook in the format specified by your instructor. $14.$ Exit Excel. $15.$ How would you determine which scenario makes the best use of the advertising dollars? If the budget was a secondary concern, what cell might you use as an objective? Would it be a max, min, or value?