1. a. Matt's Master Photography has 56000 available per year for advertising. Newspaper ads cost S100 each and he can afford a maximum of 21 ads annually. Radio ads cost $300 each and he can afford a maximum of 28 annually at this price. Each newspaper ad is estimated to reach 6000 potential customers (brides and families with children), and each radio ad is estimated to reach 8000 potential customers. Of course Matt wants to maximize the number of ad exposures to potential customers. Write the objective function and the system of constraints, then set up a workspace in an Excel program to find the maximum possible number of exposures to potential customers. B A 1 Variables 2 3 #newspaper ads (M) 4 #radio ads (R) 5 6 Objectives 7 8 Maximum # of exposures 9 10 Constraints 11 12 Newspaper ads 13 Radio ads 14 Cost Amount used Maximum 21 28 6000 b. Write a sentence that tells the number of newspaper and radio ads used, the cost, and the number of potential customers reached. c. What if the available cost is $8,000? Since the newspaper ads maximized in the previous constraint conditions, it is decided to let both the radio ads and the newspaper ads be 20; enter these amounts in the cells that maximize these values. Write the new system of constraints, then open the solver menu, and solve with these new constraints. d. Write a sentence that tells the number of newspaper and radio ads used, the cost, and the number of potential customers reached e. Write a short paragraph telling how the constraints may be changed, and how they can affect the value of the variables which optimize the problem. 1. a. Matt's Master Photography has 56000 available per year for advertising. Newspaper ads cost S100 each and he can afford a maximum of 21 ads annually. Radio ads cost $300 each and he can afford a maximum of 28 annually at this price. Each newspaper ad is estimated to reach 6000 potential customers (brides and families with children), and each radio ad is estimated to reach 8000 potential customers. Of course Matt wants to maximize the number of ad exposures to potential customers. Write the objective function and the system of constraints, then set up a workspace in an Excel program to find the maximum possible number of exposures to potential customers. B A 1 Variables 2 3 #newspaper ads (M) 4 #radio ads (R) 5 6 Objectives 7 8 Maximum # of exposures 9 10 Constraints 11 12 Newspaper ads 13 Radio ads 14 Cost Amount used Maximum 21 28 6000 b. Write a sentence that tells the number of newspaper and radio ads used, the cost, and the number of potential customers reached. c. What if the available cost is $8,000? Since the newspaper ads maximized in the previous constraint conditions, it is decided to let both the radio ads and the newspaper ads be 20; enter these amounts in the cells that maximize these values. Write the new system of constraints, then open the solver menu, and solve with these new constraints. d. Write a sentence that tells the number of newspaper and radio ads used, the cost, and the number of potential customers reached e. Write a short paragraph telling how the constraints may be changed, and how they can affect the value of the variables which optimize the
