Finding Optimal Solutions with Solver
GoalSeek is a great tool for finding out how much you need to change a single input to generate a desired result from a formula, but it’s of no help if you want to find the best mix of several inputs. For example, Catherine Turner might want to advertise in four regional magazines to drive customers to The Garden Company’s Web site, but she might not know the best mix of ads to place among the publications. She asked the publishers for ad pricing and readership numbers, which are reflected in the spreadsheet shown below, along with the minimum number of ads per publication (three) and the minimum number of times ...
Get Microsoft® Office Excel® 2003 Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
