Activity Cost Estimates Template
A standardised framework for projecting labour and physical resource costs at the activity level, ensuring robust baseline budgets and defendable contingency reserves.
§1 Understanding Cost Estimates
Accurate activity cost estimation is the prerequisite for an achievable project budget. It involves forecasting the monetary resources required to complete project activities.
This template aligns with standard Work Breakdown Structure (WBS) practices. By breaking down costs into discrete activities and separating labour from physical (non-labour) costs, project managers can pinpoint variances during execution and justify necessary management reserves.
§2 Blank Template Structure
The standard format captures the core components required to roll up individual activity costs into the final project Cost Baseline.
| Activity Details | Cost Projections | Estimation Metrics | |||||
|---|---|---|---|---|---|---|---|
| WBS | ID | Resource | Labour Costs | Physical Costs | Estimate Method | Range | Confidence |
| [Code] | [Act. ID] | [Name/Role] | [$ Value] | [$ Value & Description] | [Method] | [± %] | [Low/Med/High] |
| Subtotal | [$ Total] | [$ Total] | Base Estimate | [$ Combined] | |||
| Contingency Reserve | [Method / %] | Reserve | [$ Value] | ||||
| Cost Baseline | Baseline | [$ Value] | |||||
| Management Reserve (sponsor-held) | Reserve | [$ Value] | |||||
| Total Funding Required | Budget | [$ Value] | |||||
§3 Worked Example: Website Project
The following table demonstrates a completed Activity Cost Estimate for a fictional IT project: Mary's Consulting - New Company Website. It illustrates the breakdown of labour versus physical costs (such as software licences and audit fees) and the calculation of the final project budget.
| WBS | ID | Resource | Labour Costs | Physical Costs | Estimate Method | Range | Confidence |
|---|---|---|---|---|---|---|---|
| 1.1.1 | A001 | Andrew (PM) | $1,300 | Analogous | ±20% | Medium | |
| 1.1.1 | A002 | Andrew (PM) | $1,040 | Analogous | ±20% | Medium | |
| 1.1.2 | A003 | Andrew (PM) | $3,900 | Analogous | ±20% | Medium | |
| 1.1.2 | A004 | Andrew (PM) | $1,300 | Analogous | ±20% | Medium | |
| 1.1.4 | A005 | Andrew (PM) | $2,600 | Analogous | ±20% | Medium | |
| 1.2.1 | A006 | Andrew (PM) | $1,950 | Parametric | ±10% | High | |
| 1.2.1 | A007 | Andrew (PM) | $1,040 | Analogous | ±20% | Medium | |
| 1.2.1 | A008 | Christine | $600 | Parametric | ±10% | High | |
| 1.2.2 | A009 | Andrew (PM) | $2,600 | Three-point | ±15% | Medium | |
| 1.2.3 | A010 | Bill (UX) | $3,250 | Three-point | ±15% | Medium | |
| 1.2.4 | A011 | Bill (UX) | $7,800 | $400 Design tools/fonts licence | Three-point | ±15% | Medium |
| 1.2.5 | A012 | Mary (Sponsor) | $0 | Analogous | ±20% | Medium | |
| 1.3.1 | A013 | Christine | $1,500 | Analogous | ±20% | Medium | |
| 1.3.2 | A014 | Christine | $5,000 | Parametric | ±10% | High | |
| 1.3.3 | A015 | Christine | $4,000 | $500 Client clearance / legal review fee | Three-point | ±15% | Medium |
| 1.3.4 | A016 | Christine | $3,000 | Parametric | ±10% | High | |
| 1.3.5 | A017 | Christine | $2,000 | Parametric | ±10% | High | |
| 1.3.6 | A018 | Bill (UX) | $2,600 | $2,200 Stock imagery + photographer fees | Analogous | ±20% | Medium |
| 1.3.7 | A019 | Andrew (PM) | $1,040 | Analogous | ±20% | Medium | |
| 1.3.2 | A020 | Andrew (PM) | $1,560 | Analogous | ±20% | Medium | |
| 1.4.1 | A021 | Bob (Dev) | $2,880 | $800 Cloud env. setup / dev tooling | Analogous | ±20% | Medium |
| 1.4.2 | A022 | Bob (Dev) | $4,320 | $3,000 CMS licence (annual) | Three-point | ±15% | Medium |
| 1.4.3 | A023 | Bob (Dev) | $5,760 | Three-point | ±15% | Medium | |
| 1.4.3 | A024 | Bob (Dev) | $7,200 | $2,500 Frontend contractor SOW | Three-point | ±15% | Medium |
| 1.4.4 | A025 | Bob (Dev) | $8,640 | Three-point | ±15% | Medium | |
| 1.4.5 | A026 | Bob (Dev) | $4,320 | Three-point | ±15% | Medium | |
| 1.4.6 | A027 | Bob (Dev) | $2,880 | $400 Analytics tooling | Analogous | ±20% | Medium |
| 1.5.1 | A028 | Andrew (PM) | $1,300 | Analogous | ±20% | Medium | |
| 1.5.2 | A029 | Bob (Dev) | $4,320 | Three-point | ±15% | Medium | |
| 1.5.3 | A030 | Bob (Dev) | $2,160 | Analogous | ±20% | Medium | |
| 1.5.4 | A031 | Bill (UX) | $2,600 | $4,000 Third-party WCAG audit fee | Analogous | ±20% | Medium |
| 1.5.6 | A032 | Bob (Dev) | $4,320 | Three-point | ±15% | Medium | |
| 1.5.5 | A033 | Andrew (PM) | $2,600 | Three-point | ±15% | Medium | |
| 1.5.5 | A034 | Mary (Sponsor) | $0 | Analogous | ±20% | Medium | |
| 1.6.1 | A035 | Christine | $800 | Analogous | ±20% | Medium | |
| 1.6.2 | A036 | Christine | $2,000 | Parametric | ±10% | High | |
| 1.6.1 | A037 | Christine | $400 | Analogous | ±20% | Medium | |
| 1.6.3 | A038 | Bob (Dev) | $1,152 | $1,200 Hosting Q4/SSL/CDN | Analogous | ±20% | Medium |
| 1.6.4 | A039 | Bob (Dev) | $4,320 | $800 Hypercare on-call coverage | Analogous | ±20% | Medium |
| 1.6.6 | A040 | Christine | $800 | Analogous | ±20% | Medium | |
| 1.6.5 | A045 | Andrew (PM) | $1,300 | Analogous | ±20% | Medium | |
| Subtotal | $112,152 | $15,800 | Total Base Estimate | $127,952 | |||
| Contingency Reserve | Reserve analysis (approx 10%) | Calculated Reserve | $15,000 | ||||
| Cost Baseline | Project Baseline | $142,952 | |||||
| Management Reserve (sponsor-held) | Held outside baseline | $7,500 | |||||
| Total Funding Required | Total Budget | $150,452 | |||||
§4 Quick Reference
Historical Referencing
Relies on the actual cost of a previous, similar project as the basis for estimating the current project. Often applied early when detailed information is scarce, carrying a higher variance (e.g., ±20%).
Statistical Modelling
Uses a statistical relationship between historical data and variables (e.g., lines of code, square footage). Yields high confidence when underlying models are mature and scalable.
Risk-Adjusted Averages
Incorporates uncertainty by taking the Optimistic, Most Likely, and Pessimistic estimates to generate an expected cost (using triangular or PERT beta distributions).