The Project Summary Template presents an overview of all the projects your department is working on, the business results associated with them, and the status of each project.
There are three supporting spreadsheets to help you fill out the summary template. These templates are described as follows:
Capital Supporting Spreadsheet – The capital supporting spreadsheet enables you to identify the specific items that need to be purchased for the implementation of the project. For each project, copy the hardware and software sections and enter the information. Enter the total capital in the project summary spreadsheet.
Expense Supporting Spreadsheet – The expense supporting spreadsheet enables you to indentify the specific expense items that need to be purchased for the implementation of the project. For each project, copy the expense sections and enter the appropriate information. Enter the total expense number in the project summary spreadsheet.
Benefits supporting Spreadsheet – The benefits supporting spreadsheet enables you to identify the specific benefit areas and dollar amounts for the benefits. For each project, copy the benefits sections and enter the appropriate infomration. Enter the total benefits number in the project summary spreadsheet.
FTE – FTE stands for Full Time Equivalent. An FTE is a way to measure a person’s involvement in a project. For example, if you have a person working full time on a 6 months project, they will be allocated 1 to a project. A person allocated half time would count as 0.5 FTE.
Capital – Capital is a financial term that describes expensive equipment or software being purchased by a business. Your Finance Dept will treat a capital purchase differently than other types of purchases, and they have rules that govern this process. The main rule is that the purchase has to be over a certain dollar amount, but other rules may apply as well.
Spreadsheet Column Description
Project – Enter the name of the project here.
Champion – The project champion is the person that is sponsoring the project. This is typically the head of the business unit or department that gets the most benefit of the project.
Owner – The Business Owner is the primary point of contact for the project. This person has direct responsibility from the business side for delivering the solution. This person is typically the one who knows the specifics of what the system needs to do to deliver business value.
IT Owner – The IT owner for the project is the person responsible for delivering the project on the IT side. This person is typically the project manager for the project.
Start – The start column is the scheduled start or date the project started.
Est. Completion – The estimated completion date is the date the solution is scheduled to be fully implemented into production. You may want to break large projects into multiple phases and list them on separate lines.