A Political candidate is planning his campaign budget for an upcoming election. He has $90,000 to spend. His political consultants have provided him with the following estimates of additional votes as a result of the advertising effort:
For every small sign placed by the roadside, he will garner 10 additional votes.
For every large sign placed by the roadside, he will garner 30 additional votes.
For every thousand bumper sticker placed on a car, he will garner 10 additional votes.
For every hundred personal mailings to registered voters, he will garner 40 additional votes, and
For every ad heard daily in the last month before the election, he will garner 490 additional votes.
The costs for each of these advertising devices, along with the practical minimum and maximum that should be planned for each, are shown on the table below. How should the candidate plan to spend his campaign money?
Advertising Device Cost Minimum Maximum
Roadside Sign Small 25 100 500
lARGE RAOD SIGN 60 50 300
Bumper sticker (in thousands) 30 40 100
Personal mailing (in hundreds) 82 500 800
Daily radio ads 1000 3 12
Write the equations in a WORD document. .
Take a screenshot of SOLVER before you run it. Paste that screenshot into the WORD document. Submit both the EXCEL file and the WORD file.