Learn techniques of project scheduling using MS Excel and Solver.
Key Features
Description
This book assists project management professionals in resolving project crashing situations through linear programming. It demonstrates how the PM team can help streamline the project’s on-time completion and cost optimization.
The book begins with understanding project management processes and frameworks such as WBS, PDM, and EVM. The book helps build familiarity with the PM team’s procedures to monitor a project. It helps investigate linear programming problems (LPPs) and the mathematical foundations for their formulation. It covers various approaches to solving the LPP, including graphical methods, their limitations, and the necessity of tools such as MS Excel’s Solver. It also covers how the PM team can solve LPP with the help of Solver.
This book covers various business and technical scenarios for crashing a project. It teaches how to formulate the problem of optimizing a project for time and cost using LPP. This book then discusses how LPP can be solved using Solver and more complex issues. It also explores the relationship between earned value management and crashing a project.
What you will learn
Who this book is for
This book is intended for project management professionals at all levels, including project coordinators, operations analysts, quality analysts, and all stakeholders in a running project. Although not mandatory, some background in project management and familiarity with Microsoft Excel would be an advantage.
