Free Download Solver in Excel for Management Consultants and Analysts

A practical guide on how to use linear programming and Solver in Excel to find optimal solutions

What you'll learn

• How to use Solver in Excel in practice
• How to define problems using the linear programming language
• How to find optimal solutions to problems using Solver
• How to pick the optimal place for a factory or warehouse
• How to allocate resources to different projects
• Requirements
• Basic or intermediate Excel
• Basic knowledge of economics

Description

What is the aim of this course?

From time to time you have to find optimal solutions to more complicated problems that cannot be solved by typical analyses. Where we should build factories to minimize the total costs for the whole supply chain? How should we plan the flow of goods between factories and our customers, so the demand is met and we maximize our profit? What mix of products will be optimal for us given our capacities, demand, costs, and profits? Luckily, for those cases, we can use Solver in Excel and Linear Programming that will help you find optimal solutions. In this course, I will teach how to use Solver in Excel and Linear Programming in practice to solve complex problems and find optimal solutions.