Can We Do It?

One of the main problems faced by organizations is resource overload. JobOrder offers a powerful feature called 'Can We Do It?", available both in Estimates and in Jobs.

In Jobs, "Can We Do It?" button is a Power Tool, used to determine whether you have enough hours to complete one selected Job or all Jobs within the scheduled time. See the screen capture below.

In Estimates, the "Can We Do It?" button is located on the TimeLines tab. You can enter a hypthetical "Estimate Start Date" and then click ""Can We Do It?".

JobOrder will find all uncompleted Activities in Jobs not on hold that overlap any of this Estimate Activity date range and will then find the earliest Scheduled Start Date for any Activity and the latest Due Date for any Activity in this selection of Activities.

The “Starting Date” will be earliest date of the earliest Scheduled Start Date for any Activity or the earliest Scheduled Start Date for any Estimate Activity. If the Starting date is before the current date, we will set it to the current date. The “Ending Date” will be the latest date of the latest Due Date for any Activity in this selection of Activities or the latest Due Date for any Estimate Activities in this Estimate. If the Ending date is before the current date, we display an error message and end the calculation.

For each Activity assigned to an individual, we compute the Hours Required from the Hours Budgeted minus the Hours Completed minus the Hours Scheduled. If an Activity is assigned to a Team, we calculate the Hours Required from the Hours Budgeted minus the Hours Completed minus the Hours Scheduled. We then divide the Hours Required by the number of days in that Activity and divide again by the number of Resources on each Team. If an Activity is assigned to Full Staff Access, we compute the Hours Required from the Hours Budgeted minus the Hours Completed minus the Hours Scheduled. We then divide the Hours Required by the number of days in that Activity and divide again by the total number of Resources. We perform the same calculations for all Estimate Activities.

We then compute whether or not we have the hours available for the new Estimate. First, we query for each Activities assigned to a single Resource. We compute the Hours Still Needed as the Hours Required minus Hours Available. Second, we query for all Activities assigned to a Team. If we get to the last date for an individual and the Hours Still Needed are positive, we add the balance of Hours Still Needed to the first date of the next Resource on that Team. Go to the next Resource for that Team and repeat this process. If we can not adjust the Hours Required so that the Hours Needed for every date for that Resource for that Activity are zero, and we have reached the last Resource on that Team, we display an error message and end the calculation. If all of the Hours can be adjusted, continue. We perform the same comparisons for all Estimate Activities. If all of the Hours Needed have been adjusted correctly, we display a success message that “Yes, you have enough Hours Available” for this Estimate.” Otherwise, we display a message that “Not enough Available Hours exist for this Estimate”.

Please email if any of this information needs additional clarification.

Victor Siegle