Use Excel to solve the linear program, optimal solution and objective function value. A political candidate is planning his media budget for an upcoming election. He has $90,500 to spend. His political consultants have provided him with the following estimate of additional voites as a result of the advertising effort: for every small sign placed by the roadside, he will garner 20 additional votes for every larg sign placed by the roadside, he will garner 30 additional votes for every thousand bumper stickers placed on cars, the will garner 15 additional votes for every hundred personal mailings to voters, he will garner 40 additional votes for every radio ad heard in the last month, he will garner 485 additional votes The costs for each of the advertising devices, along with the practical minimum and maximum that should be planned for each, are shown on the following table. How should the candidate plan to spend his campaign money? Advertising Medium Cost Minimum Maximum Bumper Stickers (thousands) $30 50 200 Personal mailings (hundreds) $85 500 900 Radio Ads (per day) $1000 5 10 Small road signs $35 100 600 Large Road signs $60 50 400
Use Excel to solve the linear program, optimal solution and objective function value. A political candidate is planning his media budget for an upcoming election. He has $90,500 to spend. His political consultants have provided him with the following estimate of additional voites as a result of the advertising effort:
for every small sign placed by the roadside, he will garner 20 additional votes
for every larg sign placed by the roadside, he will garner 30 additional votes
for every thousand bumper stickers placed on cars, the will garner 15 additional votes
for every hundred personal mailings to voters, he will garner 40 additional votes
for every radio ad heard in the last month, he will garner 485 additional votes
The costs for each of the advertising devices, along with the practical minimum and maximum that should be planned for each, are shown on the following table. How should the candidate plan to spend his campaign money?
Advertising Medium Cost Minimum Maximum
Bumper Stickers (thousands) $30 50 200
Personal mailings (hundreds) $85 500 900
Radio Ads (per day) $1000 5 10
Small road signs $35 100 600
Large Road signs $60 50 400
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 4 images
