Purchase Solution

Linear programming in Excel Solver

Not what you're looking for?

Ask Custom Question

Linear programming applied to maximize benefit for spending advertising dollars on TV, ads, radio, etc. to affect opnion about manatees. See attachment for deails.

Purchase this Solution

Solution Summary

Attachment has details on Solver setup and specific solution to an intricate application. Spreadsheet attachment have working setup of Excel Solver.

Solution Preview

See my proposed solution in the attached Excel for your manatee problem. You want to read your manatee article closely and check all my entered values. The imporant thing is you have a working model in Excel that you understand. Features to note:

1] You get to Excel Solver through the Add-Ins, so be sure you have it set up
2] The Target cell is b11 in my model
3] The "Changing Cells" is row 9 (columns b thru L), the units we can vary purchases
4] rows 4 and 6 are the range of possible units I gathered from reading the value, note I have in columns M andn other ...

Purchase this Solution

Free BrainMass Quizzes
Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.

Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.