In This Article
- Using VDT Calculation Method
- Using Manual Capture (If ONLY Improvement Value)
- Using Manual Capture (If Improvement Value AND Actual Monthly Benefit)
- Using VDT Calculation Method
- Using Manual Capture (If ONLY Improvement Value Captured)
- Using Manual Capture (If Improvement Value AND Actual Monthly Benefit)
- Using VDT Calculation Method
- Using Manual Capture (If Only Improvement Value)
- Using Manual Capture (If Improvement Value AND Actual Monthly Benefit)
- Using VDT Calculation Method
- Using Manual Capture (If ONLY Improvement Value)
- Using Manual Capture (If Improvement Value AND Actual Monthly Benefit)
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 |