Nixon C. Learn to use Excel's Solver in an Hour

Independently published, 2017. - 48p. - ISBN: 978-1520577111+Sample filesLearn to use Excel's Solver in an Hour
If you are new to Excel's Solver it can seem daunting and scary. This easy to follow and fully illustrated guide by the internationally renowned Excel consultant, Carl Nixon, is designed to get you up to speed quickly and easily. You will be able to start producing your own Solver solutions in an hour or less!This easy to follow guide uses 5 real world business examples to walk you through how to use Excel's SolverStock Level Problem
Work out which stock to buy so you can make the most effective use of your money and your storage facilities.Supplier Problem
When you have a variety of suppliers with different pricing and stock levels, work out the most cost effective way of ordering your required stock.
Workload Problem
If you have a combination of work centres all capable of completing certain tasks, all at different costs, work out what is the most cost effective way of distribution the workload.Delivery Route Problem
In this classic problem we work out the optimum route through a series of distribution points.Maximum Flow Problem
In this problem we work out the maximum flow through a system when each link in the system has limited through put. This could be through a network of pipes, a computer network or even the workflow through a factory.An accompanying spreadsheet, which helps you follow the exercises in the book, is also provided via a FREE download.