Description
This course gives an overview of linear programming (definition, background, use cases) and then shows how to solve a linear program using Microsoft Excel through 2 complete examples. Below is a complete outline of the course: Lecture 1: Introduction: Linear programming in Excel - course overview + use casesQuick introduction + our backgroundsLecture 2: Enabling Solver add-on for linear optimizationEnabling Solver add-on in MS ExcelLecture 3: What is linear programming?What linear programming is comprised of, and the general framework of solving for a linear optimization. Lecture 4: Examples of when to use linear programmingLecture 5: How to identify optimal solutions in linear programming graphicallyWe will walk you through determining feasible and optimal solutions in linear programming given a graph. Lecture 6: Linear programming example 1 - 'taking a test' (optimizing score)Test score optimization problem (our first example)Lecture 7: Linear programming example 2 - 'Stanley's glass'Students joining this course should have access to MS Excel, and a willingness to learn!