Publisher's Synopsis
Learn techniques of project scheduling using MS Excel and Solver.Key Featuresâ- Covers methods to streamlining project completion and optimising budgets.â- Includes techniques for resolving business problems and optimising EVM.â- Examines project crashing strategies, linear programming solutions, and the Solver tool.DescriptionThis 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â- Learn the process of developing the Work Breakdown Structure.â- Prepare a project schedule with all contingencies in consideration.â- Recognize the circumstances that necessitate considering crashing a project.â- Utilize linear programming to formulate and resolve project scheduling issues.â- Develop strong proficiency in using MS Excel for Project Management activities.Who this book is forThis 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.Table of Contents1. Project Scheduling2. Earned Value Method3. Linear Programming Problems4. Crashing a Project5. Using LPP to Crash a Project6. More Complex Problems7. Linking EVM and LPP8. Annexure I: Microsoft Excel Basics9. Annexure II: Advanced Methods of Crashing a Project
