Project Estimation Template

 

Read Me
All white cells are editable in the estimation template
Estimation Summary
1	In this sheet, mention the basic project information.
2	This sheet gives the amount of effort estimated for each phase, based on the effort distribution.
3	‘Engineering effort’ is the total amount of effort estimated for the project
4	Total Size (complexity Point) is the calculated value of the complex points or the size of the work that has to be performed.
5	‘Project Management Effort’ is the percentage of Engineering Effort that will be required for project management.
6	‘Total Effort (Hours)’ is the sum of ‘Engineering Effort’ and ‘Project Management Effort’
7	‘Contingency %’ is the percentage of total effort that counts for an incidental expense
8	‘Grand Total Effort (Hours)’ is the sum of ‘Total Effort (Hours)’ and ‘‘Contingency %’’
9	‘Assumptions’ and Risks: List all the assumptions and risks related to estimation
Estimation Criteria
1	Mention the criteria for various complexities i.e. Low, Medium, High and effort spent in coding phase for each of the complexity.
2	Mention the effort distribution percentage for each phase.
3	Based on total complexity point, development effort is calculated
Estimation Sheet
1	List down all the functions or requirements to be developed
2	Identify the complexity in for each functions or requirements to be developed.
Revision History
1	Details of the revision done to the estimation to be logged in this sheet

Estimation Summary
Project Information
Project Code		Project Name
Estimated By		Estimation Date
Reviewed By		Review Date
Approved By		Approval Date
Effort Distribution
Phases		% Effort	Efforts
Requirement Development Phase		0	0
Design Phase		0	0
Coding and Unit Testing Phase		0
Testing Phase		0	0
User Acceptance Testing		0	0
<any other phase>		0	0
<any other phase>		0	0
Go-Live		0	0
Total Engineering Effort (Hours)		100	0
Total Size (complexity Point)			0
Productivity Factor (CP per Hour)			#DIV/0!
Miscellaneus Effort			XXX.00
Project Management and Support Activities Effort			0.1
Total Effort (Hours)			xxx
Contingency %			20%
Grand Total Effort (Hours)			xxx
Assumptions
Risks

Estimation Criteria Setup
Complexity of Feature or Requirement	Criteria for complexity	Effort in Coding and Unit Testing Phase	Normalization	Count of H/M/L	Total Size
Low	<Defined the criteria for low complex requirement or feature>	<mention the effort estimated for low complex requirement or feature in development activity>		0
Medium	<Defined the criteria for medium complex requirement or feature>	<mention the effort estimated for medium complex requirement or feature in development activity>		0
High	<Defined the criteria for high complex requirement or feature>	<mention the effort estimated for high complex requirement or feature in development activity>		0
				Total Size	0.00
				Total Development Effort
Effort Distribution
Phases	% Effort
Requirement Development Phase	20
Design Phase	10
Coding and Unit Testing Phase	30
Testing Phase	5
User Acceptance Testing	10
<any other phase>	10
<any other phase>	10
Go-Live	5
Total	100

Feature or Requirement breakdown
Module Name
Functions
S. No	Function No.	Function Name	Complexity
		1
	Miscellaneous/Other Tasks Estimate the effort for miscellaneous/other tasks (like UAT support, User Training etc.) (Both Engineering and Non-Engineering) S. No Miscellaneous/Other Tasks Effort (Hours) 1 User training 100.0 2 Installation 20.0 3 4 5 6 7 8 9 10 Total Miscellaneous/Other Effort (PH) 120.00