Tracking Units Consumed in Project Cost Plan

Sasha10
Tera Contributor

Greetings!

 

I created cost plans for a project using the unit cost of an item and the quantity of the item required for the project. Ex. the unit cost is $100 and I need 10 units for the project. This results in my planned costs totaling $1,000.

 

Is it possible to create an expense based on the quantity of the item used, instead of the total cost incurred. I would like to be able to track the units consumed during the project as well as the costs associated with the units.

 

I would like to see the usage of units calculated as well as the cost of the units.

 

Sasha10_0-1696985068657.png

This screenshot from the Cost Plans in the Financials Summary shows the Total Planned Cost, the Total Actual Cost, the Unit Cost I entered when creating the cost plan, and the Quantity entered when creating the Cost Plan. Is there a way to indicate that I used 3 units and see the $300 actual cost and the difference between the Quantity needed and the actual quantity used?

 

A more specific application of this functionality is tracking the cost and units consumed of a resource from an external/3rd party source. I have a contract with a service provider that says I have access to 10 units of service from their company and each unit costs $100. These units are not something I can track in my asset database because they are not our assets. These units are also not something I can track as a resource with a time sheet because the units do not have an account in our system. Is there another way to track that I have used 2 units, and importantly, see that I have 8 remaining planned units available to me any my project?

 

Thanks!

0 REPLIES 0