shelly cashman series microsoft office 365 & excel 2019 comprehensive

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.Ħ. The Ads Placed values must be positive whole numbers (Hint: Use the int operator as well as the >= operator.)ĥ. 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 changing variables cells are В9:D9.ĭ. The objective is an advertising budget of $ 10,500 (the Value Of parameter), which will display in cell F11.Ĭ. The costs for the month of June are already in the worksheet (B6:D6).Ī. Use Solver to determine the best mix of advertising for the advertising dollars.

In cell E7, type =E5 because all people might be reached by Social Media with no cost.Ĥ.

Because the Social Media cost of zero is valid, the division error appears. Use Error Checking to evaluate the error in cell F9, Use the solution suggested by Error Checking.ģ. Trace precedents and dependents on the two cells with errors: F9 and E7.Ģ. Figure 9-86b shows the completed Scenario Summary.ġ. Figure 9–86a shows the completed Answer Report. You are to determine how best to promote the festivals, making the most of the town’s advertising budget. The workbook you open contains information about your town’s two annual festivals, one in June and one in October. Open the workbook called SC_EX_9-2.xlsx, which is located in the Data Files. Please contact your instructor for information about accessing the Data Files. Note: To complete this assignment, you will be required to use the Data Files. Using Solver to Plan Festival Advertising Reinforce the skills and apply the concepts you learned in this module.

Shelly cashman series microsoft office 365 & excel 2019 comprehensive