Hard Savings YTD metric calculation

  • Release version: Australia
  • Updated March 31, 2025
  • 4 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 Hard Savings YTD metric calculation

    The Hard Savings Year-to-Date (YTD) metric quantifies the total confirmed and negotiated savings realized from pipeline projects that were closed and completed within the current calendar year. This metric excludes estimates or projections and focuses solely on actual savings recorded in closed projects. It provides ServiceNow customers with a precise measure of annual savings performance, enabling year-over-year comparisons to track financial impact over time.

    Show full answer Show less

    Key Features

    • Metric Scope: Includes only projects in the “Closed Complete” state with a non-zero annual hard savings value and savings periods overlapping the current calendar year (January 1 to December 31).
    • Annual Hard Savings Field: Represents the negotiated savings value entered upon project completion.
    • Proration: Savings are prorated based on the number of days the project’s savings period overlaps with the current year, ensuring accurate attribution even for projects spanning multiple years.
    • 365-Day Cap: Projects spanning more than 365 days have their duration capped at 365 days to normalize savings to an annual basis, preventing dilution of savings across extended project timelines.
    • Year-over-Year Comparison: The metric automatically compares the current year’s savings total to the previous year’s equivalent period, providing insight into savings trend changes.

    Calculation Process

    • Identify qualifying projects: Select closed and completed projects with valid savings periods overlapping the target year.
    • Calculate overlap days: Determine the number of days the project’s savings period intersects with the calendar year.
    • Determine per-day savings rate: Divide the project’s total hard savings by the project duration in days, capped at 365.
    • Prorate savings: Multiply the per-day rate by the overlap days to calculate the prorated savings for the year.
    • Aggregate totals: Sum prorated savings across all qualifying projects and round to two decimal places.
    • Compute year-over-year change: Repeat calculations for the prior year and determine the difference and percentage change.

    Practical Example

    Consider three projects with the following characteristics for the year 2024:

    • PIPE-001: $120,000 savings, full-year project (365 days), full savings attributed.
    • PIPE-002: $365,000 savings, project spans mid-year 2024 to mid-year 2025, prorated for 184 days in 2024 resulting in $184,000 savings attributed.
    • PIPE-003: $730,000 savings, multi-year project spanning three years (1,095 days), but capped at 365 days to reflect annual savings, yielding full $730,000 attributed in 2024.

    The combined total Hard Savings YTD for 2024 from these projects is $1,034,000.

    Why This Matters

    This metric gives ServiceNow customers an accurate, standardized view of realized financial savings from pipeline projects within the current year. By applying proration and a 365-day cap, the metric ensures multi-year projects are fairly represented without understating annual savings. The year-over-year comparison enables performance tracking and financial planning based on actual savings delivered.

    Hard Savings YTD (Year-to-Date) shows the total realized savings from pipeline projects that were closed and completed within the current calendar year. These are confirmed, negotiated savings — not estimates or projections.

    Metric definition

    The following attributes define the Hard Savings YTD metric:

    Attribute Detail
    Metric name Hard Savings Year-to-Date
    Pipeline state Closed Complete
    Savings field Annual hard savings
    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

    Key concepts

    • Annual hard savings is the field on a pipeline project record that holds the actual negotiated savings value, entered when the project is closed and completed.
    • Only projects in Closed Complete state contribute to this metric.
    • Savings are prorated based on how many days of the project's savings period fall within the current calendar year.
    • For projects that span more than one year, the per-day savings rate is calculated using a 365-day cap. This prevents multi-year project totals from being diluted across the full project duration and ensures the metric always reflects an annual savings rate.

    How Hard Savings YTD Is Calculated

    The following steps describe how the system arrives at the Hard Savings YTD figure displayed on the dashboard widget.

    1. Establish the date range. The system sets the calculation range to January 1 through December 31 of the current calendar year. This same process also runs against the previous calendar year to enable year-over-year comparison.
    2. Identify qualifying projects. The system queries the pipeline project table for all projects assigned to the current user that meet the following criteria:
      • The project is in Closed Complete state.
      • The project has a savings start date and a savings end date.
      • The savings period overlaps with the target year — the savings start date falls on or before December 31, and the savings end date falls on or after January 1.
      • The project has a non-zero value in the Annual hard savings field.
    3. Calculate overlap days for each project. For each qualifying project, the system determines how many days the project's savings period fall within the target year. This is the number of days between the later of (the savings start date or January 1) and the earlier of (the savings end date or December 31).
    4. Calculate the per-day savings rate. The system divides the project's total hard savings value by the project's duration in days. If the project spans more than 365 days, the duration is capped at 365 to normalize the rate to an annual basis.
    5. Prorate the savings. The prorated savings for each project equals the per-day rate multiplied by the number of overlap days. Projects where the savings period falls entirely within the current year receive their full hard savings value.
    6. Aggregate and round. The prorated savings values for all qualifying projects are added together. The result is rounded to two decimal places.
    7. Compute the year-over-year comparison. Steps 2–6 run a second time against the previous calendar year. The system calculates the difference and percentage change between the two year totals.
    8. Return the result. The current year total is displayed as the Hard Savings YTD value on the dashboard widget, together with the year-over-year change indicator.

    Proration formula

    Prorated Savings = (Hard Savings ÷ min(Project Days, 365)) × Overlap Days.

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

    The 365-day cap explained: For a project that spans 1,095 days (3 years), using the actual project duration as the divisor would spread the savings across 1,095 days and significantly understate the annual figure. Capping the divisor at 365 ensures the per-day rate reflects the project's intended annual savings value, not a fraction of it.

    Example calculation

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

    Pipeline State Hard Savings Savings Start Savings End Project Days
    PIPE-001 (Supplier Renegotiation) Closed Complete $120,000 Jan 1, 2024 Dec 31, 2024 365
    PIPE-002 (Contract Consolidation) Closed Complete $365,000 Jul 1, 2024 Jun 30, 2025 365
    PIPE-003 (Multi-Year Agreement) Closed Complete $730,000 Jan 1, 2023 Dec 31, 2025 1,095
    PIPE-001: Full overlap
    • Project duration = 365 days
    • Overlap with YTD range = 365 days (project falls entirely within the year)
    • Per-day rate = $120,000 ÷ 365 = $328.77/day
    • Prorated savings = $328.77 × 365 = $120,000.00
    PIPE-002: Partial overlap (starts mid-year)
    • Project duration = 365 days (Jul 1, 2024 – Jun 30, 2025)
    • Overlap with YTD range = 184 days (Jul 1 – Dec 31, 2024)
    • Per-day rate = $365,000 ÷ 365 = $1,000.00/day
    • Prorated savings = $1,000.00 × 184 = $184,000.00
    PIPE-003: Multi-year project (365-day cap applies)
    • Project duration = 1,095 days (Jan 1, 2023 – Dec 31, 2025) — exceeds 365 days
    • Overlap with YTD range = 365 days (full year 2024)
    • Per-day rate = $730,000 ÷ 365 (capped) = $2,000.00/day
    • Prorated savings = $2,000.00 × 365 = $730,000.00

    Why the cap matters here: PIPE-003 spans 1,095 days across three years. Without the 365-day cap, the per-day rate would be $730,000 ÷ 1,095 = $667/day — and only $243,333 would be attributed to 2024. The cap corrects for this by treating the savings as an annual figure, which returns the full $730,000 to the 2024 total.

    Final aggregation

    The final aggregation sums the prorated values:

    Pipeline Prorated Hard Savings
    PIPE-001 $120,000.00
    PIPE-002 $184,000.00
    PIPE-003 $730,000.00
    Total Hard Savings YTD $1,034,000.00