Harmon M. Step-By-Step Optimization With Excel Solver The Excel Statistical

2011. — 236 p.Reader Testimonials For The Excel Statistical Master.
Excel Solver Overview.
Installing the Excel Solver.
Optimization Basics With Excel Solver.
Solver Option Settings.
Interpreting Solver Results Messages.
Understanding Solver Reports.
Knapsack Example.
Cutting Stock Example.
Machine Selection Example - Selecting Machines to Optimally Fulfill an Order.
Maximizing Employee Satisfaction Example - Optimal Assignment of Company Assets Among Employees For Maximum Satisfaction.
Shipping Cost Minimization Example - Minimizing the Total Cost of Shipping From Multiple Points To Multiple Points.
Outbound Marketing Budget Optimization - Reaching a Required.
Number of Prospects As Cheaply As Possible With Outbound Marketing.
Inbound Marketing Budget Optimization - Generating a Required.
Number of Qualified Leads As Cheaply As Possible With Inbound Marketing.
Bond Portfolio Optimization Example - Optimizing the Allocation of Bonds in a Portfolio To Maximize Return.
Optimal Investment Selection Example - Maximizing Investment Return Through Optimal Investment Selection.
Supplier Shipping/Purchasing Cost Minimization - Minimizing the Total Cost of Purchasing and Shipping From Multiple Suppliers.
Traveling Salesman Problem - Using the All Different Constraint and the Evolutionary Method To Find the Shortest Path To All Customers.
How To Perform Nonlinear Regression and Curve Fitting - Using the GRG Nonlinear Method.
Meet Mark the Author.
Check Out the Latest e-Manuals in the Excel Master Series.
To Download the Excel Workbook Containing All Examples In This Manual.