In This Article

Overview

Benefit for Month

Benefit per Day

Annualized Benefit

Target Annual Benefit

Other Benefit Grid Items

Summary

Related Articles:


Overview

Once the new Benefit calculation method is activated (see article: New Monthly Benefit Calculation Method), the Benefit Grid will display values using the monthly benefit amounts generated by this monthly benefit calculation method. This article explains how these Benefit Grid rows are calculated and populated.


Benefit for Month

Using VDT Calculation Method

The values for the monthly Benefit for Month are sourced from the root/output KPI


Using Manual Capture (If ONLY Improvement Value)

The Benefit for Month is calculated as Benefit per Day * Production Days


Using Manual Capture (If Improvement Value AND Actual Monthly Benefit)

The Benefit for Month is the Actual Monthly Benefit captured for the month


Benefit per Day

Using VDT Calculation Method

The values for Benefit per Day are calculated using Benefit for Month/ Production Days


Using Manual Capture (If ONLY Improvement Value Captured)

The values for Benefit per Day are calculated using Annualized Benefit / Benefit Duration


Using Manual Capture (If Improvement Value AND Actual Monthly Benefit)

The values for Benefit per Day are calculated using Benefit for Month/ Production Days


Annualized Benefit

Using VDT Calculation Method

The values for the Annualized Benefit are calculated using the Benefit per Day * Benefit Duration


Using Manual Capture (If Only Improvement Value)

The Annualized Benefit is equal to the Target Annual Benefit


Using Manual Capture (If Improvement Value AND Actual Monthly Benefit)

The values for the Annualized Benefit are calculated using the Benefit per Day * Benefit Duration



Target Annual Benefit

Using VDT Calculation Method

The values for Target Benefit are calculated as the (Target Benefit / Production Days) * Benefit Duration 


Using Manual Capture (If ONLY Improvement Value)

The values for Target Benefit are calculated as the Target Benefit / (Production Days* Benefit Duration)


Using Manual Capture (If Improvement Value AND Actual Monthly Benefit)

The values for Target Benefit are calculated as the Target Benefit / (Production Days* Benefit Duration)


Other Benefit Grid Items

The following calculations on the grid always remain consistent, regardless of VDT and Manual Capture:

  • Cash In Forecast
  • Cash In
  • Cash Out Forecast
  • Cash Out
  • Production Days = Production days of the month up until today
  • Ongoing Benefit =Benefit For Month
  • Net Target Benefit = Target Benefit less (Cash In F. plus Cash Out F.)
  • % of Target Improvement Achieved = (Annualized Benefit / Target Annual Benefit) * 100
  • Variance vs Target Annual Benefit = Annualized Benefit less Target Annual Benefit

Summary

Monthly Benefit Calc Method (Using VDT)

Description

Calculation

Cash In Forecast

Sourced from the Cash Flow Table 

Cash In

Sourced from the Cash Flow Table  

Cash Out Forecast

Sourced from the Cash Flow Table  

Cash Out

Sourced from the Cash Flow Table  

Benefit Per Day

Benefit for month / Production Days (Production days of the month up until today)

Benefit For Month

Benefit Value (Actual less Baseline) from VDT

Production Days

Production days of the month up until today

Ongoing Benefit

Benefit For Month

Target Benefit

Improvement Value (Target less Baseline) from VDT

Net Target Benefit

Target Benefit less (Cash In F. plus Cash Out F.)

Annualized Benefit

Benefit Per Day * Benefit Duration (Production days of year up until today)

Target Annual Benefit

(Improvement Value / Production Days) * Benefit Duration (calc same as annualized benefit)

% of Target Improvement Achieved

(Benefit Value / Improvement Value) * 100

Variance vs Target Annual Benefit

Annualized Benefit less Target Annual Benefit


Monthly Benefit Calc Method (Manual Capture)

Description

Calculation

Cash In Forecast

Sourced from the Cash Flow Table 

Cash In

Sourced from the Cash Flow Table 

Cash Out Forecast

Sourced from the Cash Flow Table 

Cash Out

Sourced from the Cash Flow Table  

Benefit Per Day

Annualized Benefit/Benefit Duration

Benefit For Month

Benefit Per day * Production Days

Production Days

Sourced from Calendar Site Setting 

Ongoing Benefit

Benefit For Month

Target Benefit

Improvement Value (Manual Capture from Idea Overview)

Net Target Benefit

Target Benefit less (Cash In F. plus Cash Out F.)

Annualized Benefit

(Improvement Value / Production Days) * Benefit Duration

Target Annual Benefit

(Improvement Value / Production Days) * Benefit Duration

% of Target Improvement Achieved

(Annualized Benefit / Target Annual Benefit Value) * 100

Variance vs Target Annual Benefit

Annualized Benefit less Target Annual Benefit Value


Monthly Benefit Calc Method (Manual Capture) - When 'Actual Benefit for Month' is captured

Description

Calculation

Cash In Forecast

Sourced from the Cash Flow Table  

Cash In

Sourced from the Cash Flow Table  

Cash Out Forecast

Sourced from the Cash Flow Table 

Cash Out

Sourced from the Cash Flow Table 

Benefit Per Day

Benefit For Month / Production Days

Benefit For Month

Captured 'Actual Benefit for Month'

Production Days

Sourced from Calendar Site Setting 

Ongoing Benefit

Benefit For Month

Target Benefit

Improvement Value (Manual Capture from Idea Overview)

Net Target Benefit

Target Benefit less (Cash In F. plus Cash Out F.)

Annualized Benefit

Benefit Per Day * Benefit Duration

Target Annual Benefit

(Improvement Value / Production Days) * Benefit Duration

% of Target Improvement Achieved

(Annualized Benefit / Target Annual Benefit Value) * 100

Variance vs Target Annual Benefit

Annualized Benefit less Target Annual Benefit Value



New Monthly Benefit Calculation Method

Annualized Benefit Calculation Method