How is the "Forecast Actual %" Is Calculated In Planned Vs Actual Graph?

Tracking and comparing the planned Vs actual progress of a project is critical for ensuring timely delivery and efficient resource utilization. However, deviations from the planned timeline often occur due to unforeseen challenges, requiring dynamic forecasting to stay on track.

The Planned Vs Actual Graph bridges this gap by visually presenting the project's progress, while the Forecast Actual % provides a forward-looking view based on the project's performance to date. By leveraging the Scheduled Performance Index (SPI), the Forecast Actual % adjusts planned milestones to predict when they are likely to be achieved.

Key Definitions

1. Planned % of Completion

   • The percentage of completion expected by the end of each month.
   • Source: Manually provided by the user for each month from the project start to the end.

2. Baseline Planned % of Completion

   • The percentage of completion expected by the end of each month based on the Baseline Plan
   • Source: Manually provided by the user for each month from the project start to the end in the Baseline Plan

3. Actual % of Completion

   • The percentage of completion achieved by the end of each month.
   • Calculation: Based on:
     • Each task's status.
     • The milestone percentage contributed by the task.
     • The weightage of the task up to the current date.

4. Scheduled Performance Index (SPI)

   • Measures project performance and efficiency.
   • Formula: SPI = [Actual % till date / Planned % till date ]
     

5. Forecast Actual %

   • Predicts the project’s progress based on SPI and adjusts the Baseline planned percentages to forecasted dates.
     

Logic for Calculating Forecast Actual %

1. Forecasted Month Calculation
   
1. The forecasted month is calculated using the following formula:
   
   
   
   
2. Inputs:
   • Start of Project
   • Current Month
   • SPI (as of the current month)
     

2. Mapping Planned % to Forecasted Month

   • For each month, the Planned % is mapped to the forecasted month.
   • Example:
     • Baseline Planned % for May: 20%
     • Actual % for May: 5%
     • Forecasted Date for May (based on SPI): July
     • Result: 20% is placed in Forecasted Actual % for July.
       

Example Workflow

1. Inputs:
   • Start Date: January 1, 2025
   • Current Date: June 30, 2025
   • SPI as of June: 0.8
   • Planned % for May: 20%
2. Calculation:
   • Forecasted Month for May:
     
     
   • Result: July 31, 2025
     
3. Mapping:
   • The Planned % of May (20%) is assigned to the Forecast Actual % for July.
     

Graph Representation

1. Planned %: Original Planned % values for each month.
2. Actual %: Actual progress achieved for each month.
3. Forecast Actual %: Adjusted progress predictions based on SPI and mapped forecasted months.
   

Use Cases

1. Identify delays in project milestones.
2. Assess the efficiency of task completion using SPI.
3. Predict the adjusted timeline for project completion.

• Related Articles

• How planned vs actual progress is calculated in PSR ( Program Status Report) Dashboard ?

  Introduction: This document provides a comprehensive guide to understanding and interpreting the planned versus actual progress metrics within the PSR Dashboard. This information is crucial for project managers and stakeholders to assess project ...

• How Is Project Progress Calculated In KTern?

  In KTern’s Transformation Hub, you can monitor the progress of your projects using dashboard. The dashboard features a progress bar that provides an overview of the project’s advancement from its inception. You can configure the progress calculated ...

• How Can You Customize Your View In The Simulation Tab To Focus On Specific Columns And Ensure A Convenient Layout?

  KTern provides a comprehensive set of tools to manage project timelines and simulate various scenarios effectively. This documentation outlines the features available under the Simulation tab of the Timeline section. 1. Navigating the Simulation Tab ...

• How to manage configurations in a project?

  Managing Project Configuration: Customizing Date and Duration Calculations The Configuration feature allows you to tailor how dates and durations are calculated for your project. Follow these steps: Locate and select the “Configuration” tab. Choose ...

• How baseline version and metrics are calculated in KTern.AI - Project Planner

  Project Governance When managing projects, a "baseline" refers to the initial plan approved by key stakeholders, capturing expectations for scope, time, and cost. Tracking baseline metrics such as Baseline Start, Baseline End Date, Baseline Duration, ...