22 Oct Optimization 2: Linear Programming

MBTN Academy announces the beta release of Optimization 2, the second in a new series for operations and business math courses. The tutorial is authored by Alexander Skvorchevsky, our faculty author expert in Statistics, Modeling, and Optimization. This module serves as a gateway to the world of linear programming, offering insights into various methods for solving linear programming problems. In particular, we’ll explore how to harness the Microsoft Excel Solver add-in, a versatile tool that empowers individuals and organizations to tackle a wide range of optimization challenges.

At its core, linear programming seeks to find the best possible outcome from a set of linear constraints, often with the goal of maximizing or minimizing a particular objective. One of the highlights of this module is the exploration of the Microsoft Excel Solver add-in, which brings the power of linear programming to the fingertips of Excel users. It enables individuals and organizations to create and solve linear programming models without the need for complex coding or specialized software. As you progress through the course, you’ll learn how to set up linear programming problems in Excel, define constraints and objectives, and harness the Solver to find optimal solutions.

The Optimization 2 tutorial consists of 27 slides of information and examples. The four problem sets consist of 23 questions that include true/false, multiple choice, and Excel-based scenarios. As is always our policy with any beta release, MBTN faculty may add this module to any existing Fall class at no additional cost. Learn more about this module and all MBTN modules at https://www.mbtn.academy/our-modules/