SOFTWARE DEVELOPMENT ESTIMATE TEMPLATE
COMPANY NAME, Project Title, Project Manager Enter info in white cells, only; shaded cells populate automatically. Enter Rates, Roles, and more on the DATA tab.
ENTER
ESTIMATION ESTIMATED ACTUAL
PHASE
VARIABLES, HOURS HOURS
BELOW
PROJECT MANAGEMENT EFFORT % 0% Business Requirements - -
PROJECT MANAGEMENT OFFICE EFFORT % 0% Functional Specifications - -
PROJECT CONTROL OFFICE EFFORT % 0% Detailed Design - -
TOTAL SHOULD BE 100% -------------------> 0% Code and Unit Test - -
WORK DAY LENGTH IN HOURS 0 System Testing - -
ESTIMATED START DATE User Acceptance Testing - -
COMPUTED ESTIMATED END DATE #DIV/0! Project Manager - -
ESTIMATED PROJECT DURATION IN WEEKS #DIV/0! Project Control Office - -
Project Management Office - -
COMPUTED
COMPUTED COMPUTED TASK COMPUTED COMPUTED COMPUTED
STANDARD WORK AVERAGE
PHASE ACTIVITY PHASE TEAM SIZE WORK EFFORT DURATION IN ESTIMATED COST TASK DATE OF WORK EFFORT TASK DURATION
EFFORT % RESOURCE
HOURS WEEKS COMPLETION IN DAYS IN DAYS
HOURLY COST
Business Requirements 0% 0 - #DIV/0! #REF! #REF! #DIV/0! #DIV/0! #DIV/0!
Functional Specifications 0% 0 #DIV/0! #DIV/0! #REF! #REF! #DIV/0! #DIV/0! #DIV/0!
Detailed Design 0% 0 #DIV/0! #DIV/0! #REF! #REF! #DIV/0! #DIV/0! #DIV/0!
Code and Unit Test 0% 0 #DIV/0! #DIV/0! #REF! #REF! #DIV/0! #DIV/0! #DIV/0!
System Testing 0% 0 #DIV/0! #DIV/0! #REF! #REF! #DIV/0! #DIV/0! #DIV/0!
User Acceptance Testing 0% 0 #DIV/0! #DIV/0! #REF! #REF! #DIV/0! #DIV/0! #DIV/0!
TOTAL SHOULD BE 100% -------------------> 0% #DIV/0! #DIV/0! #REF! #DIV/0! #DIV/0!
Project Manager 0% #DIV/0! #DIV/0! #REF! #REF! #DIV/0! #DIV/0!
Project Control Office 0% #DIV/0! #DIV/0! #REF! #REF! #DIV/0! #DIV/0!
Project Management Office 0% #DIV/0! #DIV/0! #REF! #REF! #DIV/0! #DIV/0!
PROJECT MANAGEMENT #DIV/0! #REF!
BASELINE PROJECT HOURS ESTIMATE #DIV/0! #REF!
ENTER RISK CONTINGENCY 0% #REF!
BASELINE PROJECT COST ESTIMATE #REF!
PROJECT MINIMUM ESTIMATE #REF! #REF!
PROJECT MAXIMUM ESTIMATE #REF! #REF!
LEAD BUSINESS CLIENT PROJECT HOUR
TECHNICAL LEAD ANALYST DEVELOPER MISSING COUNT
DEVELOPER RESOURCES COSTS
HOURLY RATE #REF! #REF! #REF! #REF! $ -
RESOURCE COUNT ALLOCATION
BUSINESS REQUIREMENTS - - - - - - #DIV/0!
FUNCTIONAL SPECIFICATIONS - - - - - - #DIV/0!
TECHNICAL SPECIFICATIONS - - - - - - #DIV/0!
CODE AND UNIT TEST - - - - - - #DIV/0!
SYSTEM TESTING - - - - - - #DIV/0!
USER ACCEPTANCE TESTING - - - - - - #DIV/0!
RESOURCE HOURS #DIV/0!
PROJECT MANAGEMENT HOURS #DIV/0!
TOTAL PROJECT HOURS #DIV/0!