Project Cost Estimation Template In Excel
2. Calculate total of each stage by using sum formula. Then drag it horizontally to get the sum of other columns.
3. Revise step two for stage 2 total.
4. Now, add another column of total cost per unit, which includes all horizontal additions.
5. Make two more rows below this table:
6. Enter the no of units in the cell corresponding to units to be produced. Then, multiply units to be produced by total cost per units (both highlighted in the red in the following screen shot). This is your total cost of production.
This is how to estimate project costs in Excel.
Template
You can download the Template here – Download
Further reading: Basic concepts Getting started with Excel Cell References
