Decision-making Scenarios/Sensitivity Analysis

The value of using a computer spreadsheet analysis for the development of the planning tools is that various scenarios can be “tested” to see the impact each has on numbers and starting dates. In the development of the “numbers” spreadsheet, the planner has to make certain assumptions about absenteeism, disabilities, markets etc. With the spreadsheet-based plan, these assumptions can be experimented with to show how “sensitive” the plan is to changes in the assumptions.

In this part of the guide we have tried to impress upon the reader the importance of planning in the recruitment process. Beyond highlighting its importance, we have outlined the main considerations the planner needs to be aware of in order to ensure the plan’s accuracy. Finally, we have explained two easy-to-use tools to carry out the process and improve planning effectiveness.


Motor Carrier Passenger Council of Canada (MCPCC), 10350 Yonge Street, Suite 206, Richmond Hill, Ontario L4C 5K9
Telephone 905-237-0533   Toll-free 1-877-631-0533   email