Is it possible to calculate actual cost based on the rate of the user logged in the work

[Yatam_ Annapurna]

Hello Team,

We are having the below requirement in our project and thought ScriptRunner will be the good option for us to achieve this. But we are stuck and looking for help.

Requirement: Calculation of actual cost.

We are using Tempo for time tracking and each resource is associated with he individual rates and the rates do change according to the year.

For Example:
Resource 1: Rate in 2020 - $50, Rate in 2021 - $55.57, Rate in 2022 - $56.01
Resource 2: Rate in 2020 - $60, Rate in 2021 - $63.59, Rate in 2022 - $70.19

There are multiple tasks in my project where these resources are logging the work.
Task1
Task2
Task3

Resource 1 logged 5 hours on Task1, 3 hours on Task2
Resource 2 logged 10 hours on Task1, 5 hours on Task2, 2 hours on Task3

So in JIRA, Whenever I look at the actual cost against the tasks, it should show the sum of (Rate*No.of hours) for each practitioners and this actual cost I hould be able to show in the Structure

In the above example: My actual cost should be (Assuming that they had logged work in 2020 hence the rates of 2020 will be applicable) as below:

Task1 Actual cost: (5*50)+(10*60)
Task2 Actual Cost: ((3*50)+(5*60)
Task3 Actual Cost: (2*60)

And this actual cost on these should get updated immediately in JIRA as soon a the resource log the work and we will be able view that actual cost field against the tasks

If there is a way to store these rates in a table and pick from there to calculate also may be a good option or hardcoding rates in a field also works for us if the first option is not possible.

Will look forward for your response.

[Alexander Eck [Tempo]]

Hi Annapurna,

In Tempo Timesheets you can´t assign a price rate to an individual. You do only assign a price rate to a user role. On top of this price rates/price tables are tight to an Tempo Account. All these constraints would make it impossible to find out which price rate a user has. Unless you store that information outside of Tempo?

Our financial tool Tempo Budgets is more suited for that use case.

But I could also connect you to one of the Adaptavist team who could probably do something like this for you.

BR