Tracking Units Consumed in Project Cost Plan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-10-2023 05:54 PM
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.
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!