Procedure Detail MCP Template Overview This tool includes nine different tabs that are identified by four colors: Tab Purpose White Quality Information Contains the version and updates pertaining to the Template. Summary Contains specific information from the Detail worksheet (Detail Tab) that can be viewed, printed and used to develop an Investment Plan. Blue Detail Sheet The Detail worksheet is where all the data is entered in order to generate information for the other tabs. Red tabs Benefit Project Distribution Chart Proj Distrb Chart per Service Cumulative Capex Contain specific graphs to illustrate the results of the Benefit Assessment. Grey tabs Cumulative Cost Chart Data Example Cumulative Cost Data Contains various pieces of data that are used in the calculations. The Summary Tab The Summary Worksheet provides a specific view of the information derived from the Detail worksheet. No information needs to be added to this worksheet as the date is generated from the information that has been entered in the Detail Tab. The Detail Tab This section consists of 6 Steps in order to complete the Detail Sheet. The following Steps describe the Detail Worksheet’s column items and the type of information required.
Step 1: General and Cost Information This Step involves entering information the “General” and “Cost” headings (grey-coloured columns) in the Detail Worksheet. The information to be entered in this section can be taken from the Project Business Case. “General” and “Cost” Items Explanation / Instruction Project # Enter the sequential number based on the initial data entry position. It is used to sort the Projects if necessary. Project ID The Business Case Project ID. This is a unique Identification Number for the Project. The Project ID is found _____. Project Name the Project Name as exactly on the Business Case. Department Select the Department from the drop down list. Service - sub-service The Sub-service Category from the Service View Budget. Select the sub-service category from the drop down list. Project Owner Enter the name of the Project Sponsor or Project Manager. Investment Type Choose between the two types of investments from the drop-down list: Project or Program Number of Projects included in Program Enter the number of Projects included in the Program. For linear Projects, it may be difficult to know the number of Projects included in the Program. In that case, estimate the number of Projects you will/could do for the investment amount requested. Capex Enter the Capital Expenditure in $K required to complete the Project. For Programs, include one year of Capital Expenditure. Grants and other external funding Enter the value of any external funding that the investment will receive. Capex - external funding, adjusted for programs Automatically subtracts the external funding from the Capex value (if a Program), then divides the amount by the number of Projects within a Program. Step 2: Benefit Analysis This Step involves entering information under the “Benefits Analysis” heading (red-coloured columns) in the Detail Worksheet. This Step requires the use of the “Benefit Evaluation Sheet” in the Benefit Evaluation Criteria Procedure to help assess each Benefit Criteria.