Cost Estimation Template

By

Format: Evaluation Form / Log

Need help keeping track of costs for items in various categories of your work breakdown structure? Use this simple Excel sheet to help produce a quick analysis.

The data entry and calculations tab contains both the data to entry and some analysis of those entries. The analysis totals the costs by WBS ID and by cost category; in order to calculate correctly, the WBS ID must be numeric and the cost category must be text.

  • Enter data into columns A to G as appropriate
  • D and E must be used together
  • F is for one time costs
  • G is for any indirect costs assigned to the WBS item (share of rent, insurance, utilities, etc.)

Different cost categories for the same WBS ID should be entered on separate rows; different costs within the same category can be included in the same row. The template is set up to extend to row 100; you can extend for as many rows as you need simply by extending formulas in columns H-J and L-M.

People who downloaded this item also downloaded . . .

Premium Content
PMI Membership
$129 /year
(plus $10 application fee)
Sign up to download this deliverable and get unlimited access to our library of webinars, time-saving templates and more.
PMI Membership perks include job opportunities, local chapters, respected publications, and standards.   Learn more
Already a PMI Member? Log in now.

ADVERTISEMENT

6,773
Downloads

Comments (4)

Login/join to subscribe
ADVERTISEMENTS

"New York is my Lourdes, where I go for spiritual refreshment; a place where you're least likely to be bitten by a wild goat."

- Brendan Behan

ADVERTISEMENT

Sponsors