Cost Avoidance YTD metric calculation

  • Release version: Australia
  • Updated March 31, 2025
  • 3 minutes to read
    • Summarize
    Summarized using AI
    This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.

    Summary of Cost Avoidance YTD metric calculation

    The Cost Avoidance Year-to-Date (YTD) metric measures the costs that were prevented through pipeline projects during the current calendar year. Unlike hard savings, which represent direct reductions in spend, cost avoidance reflects costs that were not incurred, such as avoiding price increases, unnecessary purchases, or risk-related expenses. This metric uses the same proration engine as Hard Savings YTD but reads from the Annual cost avoidance field on project records.

    Show full answer Show less

    Key Features

    • Metric scope: Covers pipeline projects in the Closed Complete state with savings periods overlapping the current year.
    • Date range: January 1 to December 31 of the current calendar year, with automatic year-over-year comparison.
    • Calculation basis: Prorated values based on the overlap between the project’s savings period and the calendar year, capped at 365 days.
    • Field used: Annual cost avoidance on each project record, distinct from Annual hard savings used in related metrics.

    How Cost Avoidance YTD Is Calculated

    • The system identifies all qualifying Closed Complete projects with non-zero Annual cost avoidance overlapping the target year.
    • For each project, it determines the number of days the savings period overlaps with the calendar year.
    • It calculates a per-day cost avoidance rate by dividing the total cost avoidance by the project duration in days (maximum 365 days).
    • The prorated cost avoidance is computed by multiplying the per-day rate by the overlap days.
    • All prorated values are summed and rounded to two decimal places to obtain the total Cost Avoidance YTD.
    • The same calculation is performed for the previous year to enable year-over-year comparison.

    Proration Formula

    Prorated Cost Avoidance = (Cost Avoidance ÷ min(Project Days, 365)) × Overlap Days

    This ensures that only the portion of cost avoidance that falls within the target year is counted, accurately reflecting partial-year projects.

    Example Scenario

    • For a project with $200,000 cost avoidance spanning April 1, 2024 to March 31, 2025 (365 days), the overlap with 2024 is 275 days. The prorated cost avoidance is $547.95/day × 275 days = $150,684.93.
    • For a project with $90,000 cost avoidance fully within January 1 to June 30, 2024 (181 days), the prorated cost avoidance equals the full amount: $90,000.
    • The total Cost Avoidance YTD is the sum: $150,684.93 + $90,000 = $240,684.93.

    Practical Impact for ServiceNow Customers

    This metric enables customers to track and quantify the financial benefits of projects that prevent costs rather than directly reduce spend, providing a more comprehensive view of project value. By using consistent proration logic and automated year-over-year comparisons, it supports accurate reporting and informed decision-making regarding pipeline project performance and financial impact.

    Cost Avoidance YTD measures the costs that were prevented through pipeline projects during the current calendar year. Unlike hard savings, which reflect a direct reduction in spend, cost avoidance captures expenditures that were not incurred.

    Cost avoidance captures prevented expenditures such as avoiding a price increase, preventing an unnecessary purchase, or reducing exposure to a risk-related cost. The metric operates on the same proration engine as Hard Savings YTD but reads from a different field on the project record.

    Metric definition

    The following attributes define the Cost Avoidance YTD metric:

    Attribute Detail
    Metric name Cost Avoidance Year-to-Date
    Pipeline state Closed Complete
    Savings field Annual cost avoidance
    Date range January 1 to December 31 of the current year
    Proration Yes — based on the overlap between the project's savings period and the current year
    Year-over-year comparison Yes — the metric automatically compares the current year total against the same date range in the previous year

    Differences between cost avoidance and hard savings

    Cost avoidance and hard savings represent distinct types of financial impact:

    Aspect Hard Savings Cost Avoidance
    Nature Direct reduction in budget spend Prevention of a cost that would otherwise have been incurred
    Field on project record Annual hard savings Annual cost avoidance
    Visibility on P&L Directly reflected Counterfactual — represents what was not spent
    Calculation logic Identical — both use the same proration engine Identical — both use the same proration engine

    How Cost Avoidance YTD Is Calculated

    The calculation follows the same steps as Hard Savings YTD. The only difference is that the system reads the Annual cost avoidance field on each project record rather than the Annual hard savings field.

    • Establish the date range: The system sets the calculation range to January 1 through December 31 of the current calendar year. The same process also runs against the previous year for comparison.
    • Identify qualifying projects: The system queries the pipeline project table for all Closed Complete projects assigned to the current user where the savings period overlaps with the target year and the project has a non-zero value in the Annual cost avoidance field.
    • Calculate overlap days for each project: The system identifies how many days of the project's savings period fall within the target year.
    • Calculate the per-day savings rate: The project's total cost avoidance value is divided by its duration in days, capped at 365 days for projects that span more than one year.
    • Prorate the savings: The prorated cost avoidance for each project equals the per-day rate multiplied by the overlap days.
    • Aggregate and round: The prorated values for all qualifying projects are summed and rounded to two decimal places.
    • Compute the year-over-year comparison: The same steps run against the previous year, and the system calculates the difference and percentage change.

    Proration formula

    The proration formula calculates the portion of cost avoidance that falls within the target year:

    Prorated Cost Avoidance = (Cost Avoidance ÷ min(Project Days, 365)) × Overlap Days

    Overlap Days represents the number of days the project's savings period intersects with the target year's date range.

    Example calculation

    The following scenario demonstrates how Cost Avoidance YTD is calculated for two pipeline projects during the year-to-date range of January 1 to December 31, 2024:

    Pipeline State Cost Avoidance Savings Start Savings End Project Days
    PIPE-101 (Prevented Price Increase) Closed Complete $200,000 Apr 1, 2024 Mar 31, 2025 365
    PIPE-102 (License Optimization) Closed Complete $90,000 Jan 1, 2024 Jun 30, 2024 181
    PIPE-101 has a partial overlap with the year-to-date range:
    • Project duration = 365 days (Apr 1, 2024 – Mar 31, 2025)
    • Overlap with YTD range = 275 days (Apr 1 – Dec 31, 2024)
    • Per-day rate = $200,000 ÷ 365 = $547.95/day
    • Prorated cost avoidance = $547.95 × 275 = $150,684.93
    PIPE-102 falls entirely within the year-to-date range:
    • Project duration = 181 days
    • Overlap with YTD range = 181 days (project falls entirely within the year)
    • Per-day rate = $90,000 ÷ 181 = $497.24/day
    • Prorated cost avoidance = $497.24 × 181 = $90,000.00

    Final aggregation

    The final aggregation sums the prorated values:

    Pipeline Prorated Cost Avoidance
    PIPE-101 $150,684.93
    PIPE-102 $90,000.00
    Total Cost Avoidance YTD $240,684.93