Purchase Solution

Linear Programming - Excel Solver

Not what you're looking for?

Ask Custom Question

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.