How to calculate the Planned vs Actual Score for the Department?

In Profit.co before calculating the Planned and the Actual score, we first have to know the Overall Progress of the OKR. The formula for the overall OKR progress is,

Actual progress percentage = ( Total OKRs Progress / Total Count of OKRs)

Step 1

Let us discuss this with an example. Navigate to the All OKRs page.  

In Corporate, we have created three OKRs for the period Q4-2024.

• The first OKR has 21% of progress.
• The second OKR has 35% of progress.
• The third OKR has 70% of progress.

So the overall progress percentage will be,

Actual progress percentage = [(21 + 35 + 70) / 3] = 42% 

Step 2

In the above OKRs, we have selected for the period Q4-2024.

The total number of days for the quarter Q4-2024 will be 92 days.

Currently, the total count of days completed in Q4-2024 including the current date is 79 days.

So let's calculate the Planned Progress per day and the formula is,

Planned progress percentage = (Difference between target start date & current date / Difference between target start date & target end date) * 100

Let’s consider that your Department Heatmap settings have the below configuration.

And the value will be,

Planned progress percentage = [(79)/(92)*100] = 85%

In the OKRs department heatmap, you can view the Planned and Actual Progress in percentage form.