Radiant Global Technologies
All Case Studies
Business Intelligence, Application Development

AOP Planning and Commitment Tracker

An AOP planning and commitment tracking tool for factory savings across manufacturing and procurement giving the finance organization a single, consolidated view of committed savings across categories and initiatives.

Annual Operating Planning financial tracker dashboard showing budget, forecast, and variance by category

The Challenge

The client's North America operations organization ran cost reduction initiatives as part of its AOP commitment to finance across procurement and operations. The initiatives cut across procurement, one-time negotiated supplier savings and design changes leading to manufacturing or part cost reductions. However, the launch of these initiatives as well as the continued savings from these initiatives over the committed year were tracked in scattered spreadsheets maintained by different category teams and/or manufacturing sites. Leadership had no consolidated, trustworthy view of initiative launch or savings performance, and pulling together a status report took manual effort every time and was quite error prone.

Our Approach

  1. 01

    Application build

    Build the application to manage an initiative lifecycle from conception to close supported by approval workflows.

  2. 02

    Integrate planning data

    Integration of forecast and actuals data to operationalize unit cost savings by month.

  3. 03

    Approval workflows & Finance roll process

    Build approval workflows to launch initiative as well as validate savings by financial period and support monthly finance roll process.

  4. 04

    Design BI dashboards

    Built BI dashboards summarizing savings by category, region, and initiative owner for leadership reporting.

  5. 05

    Legacy data integration

    Onboard CY and PY initiative launch data to support comprehensive view of initiative performance for the current year.

The Results

One source of truth

Gave leadership a single, consolidated source of truth for purchasing savings.

On-demand reporting

Replaced manual spreadsheet consolidation with on-demand reporting.

Visibility by owner

Made savings performance visible by category and owner, not just in aggregate.

Validated savings data

Improved the reliability of reported savings through a built-in validation step.

Business Intelligence Dashboards Procurement Analytics Workflow