Preface

Project Planning, Data and Spreadsheet Software

1 Why Plan?

2 Example: Ministry of Agriculture’s Yoghurt Plant and Sales Project

3 Defining Project Metrics

3.1 Defining goals
3.2 Defining metrics
3.3 Setting up a spreadsheet
3.4 Computing Financial Metrics

4 Scenario Building

4.1 Manipulating an input factor: Data Tables
4.2 Manipulating multiple input factors: Scenario Manager
4.3 Linking input factors
4.4 Optimizing the outcome: Solver

5 Measuring Performance and Risk

5.1 Expected performance
5.2 Volatility and risk
5.3 Comparing projects

6 Incorporating Randomness via Simulation

6.1 Functions for generating random numbers