Calculate end date based on resource allocation and estimated days

Question

Hi

I need to be able to calculate the end date of the development feature based on the number of assigned people.

Scenario

I have front-end work that will take 30 days to complete with 1 person. The target start date is July 1st. If I add another person assigned to the feature, it may take 15 days, pulling the completion date from July 30th to July 15th.

Is there a Jira integration that does this? Do I really need to do this in a spreadsheet?

Meghan LaClair · Answer

Hi @Karl Jackson

If you are open to 3rd party solutions we've created an automated solution for this at minware.

Our roadmap automatically shows dependencies, weighs weekends, and in addition to being able to roll down from epic to subtask we offer a breakdown by task assignee so that you can coordinate with your team.

Since our dashboards are created by uniquely combining version control, ticketing, and calendar data we can help build reliability into your estimations and teams.

We offer a free trial, if you would like to check it out please let me know!

Disclaimer: marketplace partner

Karl Jackson_6d0yft · Answer

I created a new field 'Resource Count' but it's not clear which action should be used. I see that we need to use advanced actions given it's a custom field, but they all seem to be setting a variable.

Fabian Lim · Answer

Hi @Karl Jackson

You could use the jira automation to calculate the end date.

You can have a field that contains the info about how many resources are required in this example 2 and then use smart values to determine what the end date would be.  Jira Tickets can only be assigned to only one person so the assignee field will not work.

Help to jira smart values for dates: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/

Automation:

- Manual Trigger/when the resource field changes -> to trigger at any time to re-calculate de effort

- Action -> Grab the start date and add the business days based on a calculation on duration.  For example if a features takes 30 days and you have 2 resources then 15 days need to be added to the start day.  (Start Date + addworkingdays(30/# of resources)

I hope this helps