How to use the Project Cost Management Plan Excel

Follow the below steps to start using the Stakeholder Management Plan Template

This template has 6 tabs

  • Dashboard
  • Resource Costs
  • Software Costs
  • Hardware Costs
  • Others and Config tab

Dashboard tab:

This tab has 4 sections

1.Project Cost Summary (Auto Populated):

  • Enter the Description of the project
  • Planned cost, Actual and Variance cost are auto populated.

2.Resource cost (Auto populated):

  • Graphical representation of Planned and actual cost of each resource
  • And captures overall Planned and actual cost of resources in separate graph

3.Software, Hardware and Other costs (Auto-Populated):

  • Capture the Planned and actual cost for software, Hardware and Other costs in separate graph.

4.Overall cost (Auto populated):

  • Captures overall cost whole project i.e. Resource, Software, hardware, and other cost

 Resource cost Tab:

  • Enter the Resource name and role of the resource in respective column.
  • Specify the daily rate of the resource.
  • Mention the Hours of working in the timeline.
  • Planned cost and Actual cost are auto updated.

 Software cost Tab:

  • Enter the description of the software.

Planned Section:

  • Mention the cost of Licensing, Setup, and Consultation,
  • Project Total is auto calculated and specify the cost per annum ongoing cost.

 Actual Section:

  • Mention the cost of Licensing, Setup, and Consultation.
  • Project Total is auto calculated and specify the cost per annum ongoing cost.

 Hardware cost tab:

  • Enter the Description of the Hardware

Planned section:

  • Mention the cost of the product, setup fees and FST.
  • Project Total is auto calculated and specify the cost per annum ongoing cost.

Actual section:

  • Mention the cost of the product, setup fees and FST.
  • Project Total is auto calculated and specify the cost per annum ongoing cost.

 Others tab:

  • Enter the description of the item.
  • Mention the actual and planned cost for each item, at the end of the column total cost planned and actual cost is auto populated.