Versions Compared

Version Old Version 1 New Version 2
Changes made by

Mike Deskis

Mike Deskis

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel
bgColor#C0B6F2

📽️ Check out a video demonstration for this use case, here.

Panel
bgColor#E6FCFF

Use Case Situation Description

In this use case, pricing practitioners have the ability to configure formula-based agreements to improve contract business contribution margin, eliminate manual errors and increase customer trust, and reduce margin compression due to out-of-date pricing.

...

Expand
titleValue Projections

...

Panel
bgColor#B3F5FF

Prescriptive Design Requirements

Primary:

As a Pricing Manager/Sales Rep, I want to use contract renewal as an opportunity for a long-lasting business improvement. I want to improve contract margin, volume, and mix by considering:

...

Expand
titleFunctional and Non-functional Requirements

For this use case, the functional requirements are separated into these categories:

Complications:

  • Limited time for negotiations

  • Seasonality (e.g., year-end contract renewal rush)

  • Limited visibility into market trends and recent outcomes for similar renewal accounts

  • Limited visibility into underperformance and recommendation for price improvements

Capability Needed:

  • Timeline view into when each contract expires; count-rev-vol at risk by month

  • Track and alert system for agreement expiration dates

  • Draft progress review

  • Rank customers and products - high/low performance

Benefit:

  • Reduce risk of missing renewal deadline

  • Reduce risk of delay in price/margin increase

  • Increase margin with contextual support

  • Increased alignment between pricing and sales teams

KPI:

  • Up-to-date margin inputs: no profits lost due to old/incorrect pricing inputs

  • Efficiency and error reduction: cost of manual errors, process costs

Calculation:

  • Up-to-date margin inputs = average monthly cost increase * days pricing out of sync

  • Labor savings & error reduction = hrs./mo. contract calculations * analyst rate

Non-Functional Requirements

For this use case, the non-functional requirements are:

  • As a prerequisite: Contracts need to be set up already within the Pricefx system.

  • Automatically updated metrics in the dashboard.

Expand
titleMeasures, Calculation and Decision-making KPIs

The following are the primary KPIs for this use case:

  • Revenue Trend YTD: metric that tracks a company's revenue performance over a certain period of time, usually the current year

  • Margin Trend YTD: metric that tracks a company's margin performance over a certain period of time, usually the current year

  • Volume Trend YTD: metric that tracks a company's sales volume performance over a certain period of time, usually the current year.

  • Renewal Timeline: metric that tracks the time it takes for a company to renew its contracts with existing customers.

  • Contracts Status: list of approved contracts and contracts waiting for approval.

  • Expiry Date: listing of contract expiration dates.

Expand
titleReporting and Dashboards

These requirements for reporting and dashboards are included in the baseline estimate.

  • Single dashboard that contains:

    • Single widget showing summary of total and year-to-date trends for same period from previous year

    • 8 charts via portlets

      • Pie charts (3)

      • Bubble charts (2)

      • Bar charts (2)

      • Column chart (1)

    • 4 tables via portlets

      • Contracts portfolio summary

      • Individual contract performance

      • Approved contracts

      • Contracts awaiting approval

Expand
titleScope Validation and Project Readiness

During scope validation process we are ensuring that the project deliverables are completed according to the agreed scope and quality standard by asking the following questions:

Scope Validation and Project Readiness Workshop – Validation Questions & Answers

Q1: Are the dashboards dimensions reflecting your business? Or do you need additional dimensions/attributes to be displayed in the dashboard?

A1:

Q2: Where is your data stored?

A2:

Q3: How many customers is expected?

Tip

NOTE: Assumption is less than 20000.

A3:

Q4: How many contracts do you expect to have displayed with applying filters in the dashboard?

Tip

NOTE: The average and max number. Assumption is less than 10000.

A4:

Q5: Are you able to provide contract ID field from PFX in the transaction table? If not, enriching the transactions with contracts will become significant additional effort.

A5:

Info

LEARN MORE: For more information on scope validation and project readiness, click here.

...

Panel
bgColor#79E2F2

User Stories

As a Sales Rep/Pricing Manager/Pricing Administrator, I want to create a dashboard visualizing metrics of my contract portfolio to improve my overall performance.

Expand
titleEpic: Contract Renewal Dashboard

User Story Name - Dashboard

I want to: To filter the dashboard data by following fields: - Customer group - Product group - time segment

so I can: Have a clear overview of specific information I am interested in analyzing

Acceptance Criteria: inputs: - Customer group - Product group - Start Date - End Date

User Story Name - Contract business summary Total

I want to: See a general summary of total and Year-to-date trend of - volume - revenue - margin

so I can: Evaluate my portfolio health

Acceptance Criteria: Widget: - Revenue Trend YTD (%) - Margin Trend YTD (%) - Volume Trend YTD (%) - Total Revenue - Total Margin - Total Volume

User Story Name - Contract business summary

I want to: I want to see a more detailed summary of my contracts portfolio, aggregated by:

  • Industry

  • Region

  • Product group

Just like in the general summary I want to see YTD trending as well as accumulative totals for the year.

so I can: Evaluate success of all my contracts quickly

Acceptance Criteria: Table of business contracts. Columns:

  • Industry

  • Region

  • Product group

  • Revenue Trend YTD

  • Margin Trend YTD

  • Volume Trend YTD

  • Total Revenue

  • Total Margin

  • Total Volume

User Story Name - Customer Performance

I want to: See my contracts in quartiles by performance: low, medium, high by:

  • volume

  • revenue

  • margin

I want to be able to drill down on quartiles to see specific contracts within quartiles

so I can: H

ave a clear understanding of:

  1. My portfolio overall health

  2. individual contract performance to easily identify underperformers and overperformers

Acceptance Criteria: 3 pie charts “Customer Performance”

  1. Margin

  2. Revenue

  3. Volume

Chart divided into quartiles:

  • low – red

  • medium – blue

  • high – green

Tip

Each quartile is clickable and when clicked, it unfolds into a pie chart showing all contracts in the quartile.

When hovering over an individual contract, exact numbers are displayed:

User Story Name - Contract mix by Region

I want to: See an overview of my business portfolio by region

so I can: Maintain proportions of business per region as I have intended them

Acceptance Criteria: Bubble chart

  • X-axis: Revenue (absolute value)

  • Y-axis: Margin (%)

Bubbles represent individual contracts. The size of the bubble is related to its comparative size. The color of the bubble indicates the region to which contact belongs. When hovering over a bubble, exact numbers are displayed.

Tip

Under the X-axis are names of the regions. When clicked, makes bubble contract bubble of that region disappear from the chart.

User Story Name - Contract mix by Industry

I want to: See an overview of my business portfolio by region

so I can: Maintain proportions of business per industry as I have intended them

Acceptance Criteria: Bubble chart

  • X-axis: Revenue (absolute value)

  • Y-axis: Margin (%)

Bubbles represent individual contracts. The size of the bubble is related to its comparative size. The color of the bubble indicates industry, to which contact belongs. When hovering over a bubble, exact numbers are displayed.

Tip

Under the X-axis are Names of regions. When clicked, makes bubble contract bubble of that industry disappears from the chart.

User Story Name - Renewals Trending

I want to: To see renewals trending over time, considering volume, but also margin and revenue 

so I can: Spot upcoming contract renewals to anticipate and start renegotiations in suitable time

Acceptance Criteria: Will have 2 Bar charts: 

  • Renewal Timeline by Volume

    • X-axis: TTM 

    • Left Y-axis: Volume 

    • Right Y-axis: Contract Count 

Tip

Bars alight to left Y-axis: Volume
with dots, connected by line align to right Y-axis: Contracts

  • Renewal Timeline by Margin and Revenue

    • X-axis: TTM 

    • Left Y-axis: Amount 

    • Right Y-axis: Contract Count

Info

NOTE: When user hovers over the bar or a dot, exact amount is displayed. 

Tip

2 types of bars: light blue for Revenue, dark for Margin. The Bars alight to left Y-axis: Amount
with dots, connected by line align to right Y-axis: Contracts

User Story Name - Renewals by Quarter

I want to: See renewals per quarter

so I can: Know now best to plan my year, resources, allocation, etc.

Acceptance Criteria: A bar chart where:

  • X-axis: Quarter

  • Y-axis: Renewals

Info

NOTE: When user hovers over a bar, exact amount is displayed. 

User Story Name - Contract performance

I want to: See individual contract performance to understand contract success, but also to see how soon contract expires

so I can: Anticipate and start renegotiations in suitable time.   

I need to see all relevant information immediately, so that I can bring context to the table of negotiations. 

Acceptance Criteria: Table columns of:

  • Contract Id 

  • Customer Name  

  • Customer Id 

  • Region 

  • Industry 

  • Expiration Date 

  • Days to expire (color coded) 

  • Revenue 

  • Volume 

  • Margin $ 

  • Margin %

User Story Name - Approved Contracts

I want to: See summary of approved contracts

so I can: Understand which contracts have been approved

Acceptance Criteria: Table columns of:

  • Contract Id 

  • Contract Name  

  • Customer Name  

  • Customer Id 

  • Expiration Date 

  • Days to expire (color coded)

User Story Name - Contracts to be approved

I want to: Contracts waiting to be approved

so I can: Understand which contracts are not yet approved, so I can act on them

Acceptance Criteria: Table columns of:

  • Contract Id 

  • Contract Name  

  • Customer Name  

  • Customer Id 

  • Expiration Date 

  • Days to expire (color coded) 

...

Panel
bgColor#ABF5D1

Data Requirements

The data requirements for the dashboard depends on following data: 

  • Customer master 

  • Product master 

  • Transactions, enriched with Contract ID 

...

Panel
bgColor#FFBDAD

Out-of-Scope

This represents the out-of-scope business functions and features for this use case. They can be configured, but by default they are not included in the Chemical Industry Catalog.

  • Any metrics reporting other than the ones explicitly mentioned above 

  • Any customization 

  • Additional filters 

  • User entitlement of the dashboard 

  • Data Integration 

...

Panel
bgColor#998DD9

Solution Design

The design and the implementation of this use case (Improve contract renewal performance and long-term visibility via analytics and KPIs) is going to utilize a suite of analytical dashboards that will utilize a range of measures (volume, revenue and margin) from sales transactions, contract portfolio aggregates by industry, region and product group, outperformers and underperformers, business mixture by region and customer industry basis, trending contract renewals, individual contract performance and list of approved contracts and those awaiting approval.

...