Linear Programming - Excel Solver
Not what you're looking for?
The advertising director for Diversey Paint and Supply, a chain of four retail stores on Chicago's North Side, is considering tow media possibilities. One plan is for a series of half-page ads in the Sunday Chicago Tribune newspaper, and the other is for advertising time on Chicago TV. The stores are expanding their lines of do-it-yourself tools, and the advertising director is interested in an exposure level of at least 40% within the city's neighborhoods and 60% in northwest suburban areas.
The tv viewing time under consideration has an exposure rating per spot of 5% in city homes and 3% per ad. The cost of a half-page Tribune advertisement is $925; a television spot costs $2,000. Diversey Paint would like to select the least costly advertising strategy that would meet desired exposure levels.
A. Formulate using LP
B. Solve the problem using QM for windows or create the Excel spreadsheet for this problem and use solver to solve for the solution
Purchase this Solution
Solution Summary
This posting provides solution to linear programming problem, using Excel Solver, for Diversey Paint and Supply company for considering media possibilities.
Purchase this Solution
Free BrainMass Quizzes
Know Your Statistical Concepts
Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.
Measures of Central Tendency
This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.
Measures of Central Tendency
Tests knowledge of the three main measures of central tendency, including some simple calculation questions.
Terms and Definitions for Statistics
This quiz covers basic terms and definitions of statistics.