Please see the SAP Analytics Approach document, section 'Documentation' for more information about the context of this document.

 It is to be populated by the story owner and the reporting functional consultant collaboratively.  

It does NOT describe business logic e.g. KPI definitions delivered by the data models (e.g. analytic models) that it consumes. This is covered in the Data Model Functional Specification  

If a requirement is for a flat table, then this will be delivered as a story and this document may simply show the order of the columns.  Where more detailed requirements for a story layout are known, this template will capture these requirements. 

 As story building is an iterative and agile process, it is expected that this document will be updated through the development process.

Status

Functional Specification OwnerCONNELLY-ext, Delia 
Stakeholders
Jira Request ID[ERP-125] Business Case form to capture Project Financial Indicators - Jira
Jira Development (Build) ID[ERP-263] Business Case form to capture Project Financial Indicators - Jira
Lean IX App LinkTo be added when development reaches UAT 
Business Process Reference (L4)10.01.03.01. Manage Initiatives and Items | Signavio

High-Level Specification

ParameterValue
Application System (Delivery Tool)

SAC Story

Functional Overview

The Project Business Case captures key financial information about a project in a simplified and standardized format to enable:

The Business Case includes:

Scope

The Project Business Case must be completed for all financially driven projects.

Process Flow Diagram

This section is predominantly for planning stories and can be deleted if not applicable. Insert the flowchart and fill in the steps.  


Step

Description

Comment

1.Create ItemA new Item is created in S4HANA. The Item master data is synch'd to SAC.
2.Maintain Project Cost

A time-phased Project Cost is required for all Portfolio Items.

This is entered at Item level for new Items or copied from Detailed Planning for Items with a Project/WBS.

Past periods are automatically over-written with actual costs.

3.Financial Driver?If the Project has a financial driver, then a Business Case is required.
4.Complete Business Case*

The previously entered Project Cost is displayed in the Business Case (non-editable).

Manual inputs to the Business Case are made as required.

5.Calculate Financial Indicators*Financial Indicators such as NPV, MIRR and VCI are calculated from the business case inputs.
6.Calculate Project Score**

If the Project has a financial driver, Project Score is calculated based on the financial indicators from the Business Case.

Otherwise, Project Score is calculated based on a Risk assessment.

7.Maintain ItemPortfolio Item master data is maintained throughout its lifecycle.
8. Next?Various planning actions are required throughout the life of the Portfolio Item
9.FY Budget RequestFY Budget Request is maintained for Items requiring budget for the next Financial Year. This is an annual process for the relevant Items.
10.Stage Gate Funding RequestA Stage Gate is triggered. Depending on the Item Type and Stage Gate, this may involve a funding request.
11.Variation Funding RequestA Variation Funding Request is made mid-phase when supplementary budget is required.
12.Detailed Planning

During the life of the Item/Project a time-phased, detailed plan can be maintained at WBS Element level. This can be copied at Item level to Project Cost.

Past periods are automatically over-written with actual costs.

* Covered in this Functional Specification

** Referenced in this Function Specification, but details not included.

Solution Overview

Content Ownership: Functional Consultant, Input from: Reporting & Analytics Consultant

The Project Business Case incorporates data drawn from the following sources:

The results are stored in DSP against the Portfolio Item.

Story Definition

Overview Page 

An Overview Page for 'Portfolio Item Planning & Reporting' will include a link to the 'Portfolio Item Planning' Story:

StoryPage #PageFunctional Specification
Portfolio Item Planning1Project Cost (Item)ERP-669 SAC Planning Portfolio Items
2Project Cost (Cluster)ERP-669 SAC Planning Portfolio Items
3Business Case (Item/Cluster)ERP-263 SAC Project Business Case
4Detailed Planning (Item)

ERP-670 SAC Planning WBS Elements


Further related planning Stories are accessed via the same 'Portfolio Item Planning & Reporting' Overview Page:

StoryPage #PageFunctional Specification
FY Budget Request1FY Budget Request (Item/Cluster)

ERP-669 SAC Planning Portfolio Items

Stage Gate Funding Request1Stage Gate Funding Request

ERP-669 SAC Planning Portfolio Items

Variation Funding Request1Variation Funding Request

ERP-669 SAC Planning Portfolio Items

Story Page 3 - Business Case

Page Objective

This page supports input of the Business Case and calculation of Financial Indicators and Project Score. It is also possible to display a previously saved snapshot of the Business Case.

Page filters

Report

Field Name

Mandatory/Optional

Prompt Type

(Single Value, Multiple Single Values, Interval, Selection Option, Hierarchy)

Default Value(s) or Restrictions

(please provide default value)

Item IdMandatory

Single Value

Select from Hierarchy with option to filter by Item attributes such as Description, Person Responsible


Snapshot VersionOptional

Single Value

Select from existing Business Case snapshots for the Item


Page level input controls

N/a

Calculations

Calculations are incorporated in the Layout tables below.

All currency amounts will be saved in the Item Currency with the necessary conversions applied:

All quantities will be saved in the selected Unit.

Layout

This section will contain a wire-frame of the page indicating the widgets on it. The wire-frame can be a draw-io diagram or a screenshot of e.g. an excel mock-up.

 If there are multiple data models in the story, indicate which data models the widget takes data from at page or widget level.

Widget level details such as filters, dimensions, hierarchy usage, history, comparatives, targets, thresholds, top N etc can also be included. N.B. This level of detail is not mandatory and often changes through the iterative development process. For tables, indicate the number of expected rows.

Refer here for a mock-up of the Business Case: Business Case Template - Google Sheets


If multiple data sources consumed by story:

Widget

Data ModelFieldFilter

Header

PPM_ITEM

Project Name:

CGPL_TEXT-TEXT1



PPM_ITEM

Project ID

/RPM/ITEM_D-EXTERNAL_ID



PPM_ITEM

Project Owner:

/RPM/ITEM_D-ZXX14

Derive Personnel Name from Position

PPM_ITEM/RPM/ITEM_D-CATEGORYRetrieve description from RPM_PROJ_CAT

Time Horizon


 

Years to be displayed in the time horizon are repeated for each table/widget and determined as follows:

If Year of Project Kick=Off not blank

First year = Year of Project Kick-Off

else

First year = year of Planned Start (/RPM/ITEM_D-PLANNED_START)

Final year = End Year for NPV Calculation

The following years are highlighted in the time horizon:

  • First year of Commercial Sales
  • Year of Maturity = (First year of Commercial Sales + Time to Full Maturity)

0. Preliminary Information

PPM_ITEMYear of Project Kick-Off

Mandatory, format YYYY

Default to year of /RPM/ITEM_D-PLANNED_START


PPM_ITEMFirst Year of Commercial Sales

Optional, format YYYY

If entered, must be >= Year of Project Kick-Off


PPM_ITEMTime to Full Maturity (Years)

Optional, integer

If entered, must be >= 0


PPM_ITEMDiscount Rate (WACC)

Mandatory, format %

If blank, take default from /SYQ/T_SCORING_PARAMS-PARAM_VALUE where:

  •  /SYQ/T_SCORING_PARAMS-CALCULATION = 'NPV'
  • /SYQ/T_SCORING_PARAMS-PARAM = 'Discount Rate/WACC'

Must be >= 0 and <= 100


SCORING_PARAMETERS

Years for NPV Calculation:

/SYQ/T_SCORING_PARAMS-PARAM_VALUE

Where:

  • /SYQ/T_SCORING_PARAMS-CALCULATION = 'NPV'
  • /SYQ/T_SCORING_PARAMS-PARAM = 'Years for NPV Calculation'

PPM_ITEMCurrency

Mandatory

Default to Group Currency (EUR) and allow to switch to Item currency (/RPM/ITEM_D-CURRENCY)



Currency Multiplier

Mandatory

Select from list of defined multipliers; 1, 1k, 1m

If blank, default to 1k

Derive Currency Factor and Currency Display:

If Currency Multiplier = 1

Currency Factor = 1

Currency Display = Currency

ElseIf Currency Multiplier = 1k

Currency Factor = 1,000

Currency Display = "k" & Currency

Else (Currency Multiplier = 1m)

Currency Factor = 1,000,000

Currency Display = "m" & Currency


PPM_ITEMReinvestment Rate

Mandatory, format %

If blank, default to Discount Rate (WACC)

Must be >= 0 and <= 100


PPM_ITEMEnd Year for NPV Calculation

Calculated:

If First Year of Commercial Sales = 0 then

End Year for NPV Calculation = Year of Project Kick-Off + Years for NPV Calculation

Else

End Year for NPV Calculation = First Year of Commercial Sales + Years for NPV Calculation


PPM_ITEMProbability of Commercial Success

Optional, format %

If entered, must be >= 0 and <= 100


PPM_ITEMProbability of Technical Success

Optional, format %

If entered, must be >= 0 and <= 100


PPM_ITEMRisk Adjustment

Mandatory, format %

Must be >= 0 and <= 100


PPM_ITEM

Working Capital/Sales Ratio

Mandatory, format %

Must be >= 0 and <= 100

If blank, take default from /SYQ/T_SCORING_PARAMS-PARAM_VALUE where:

  • /SYQ/T_SCORING_PARAMS-CALCULATION = 'NPV'
  • /SYQ/T_SCORING_PARAMS-PARAM = 'Working Capital/Sales Ratio'


PPM_ITEMEBITDA at MaturityOptional, format as per Currency

1. Project Cost


Project Cost - Opex Currency

/RPM/FIN_PLAN-CURRENCY

Display-only; Currency Display


PPM_ITEM

Project Cost - Opex:

/RPM/FIN_PLAN-AMOUNT

Display-only, format as per Currency

Filter:

  • Financial View = 22 (Project Cost - Scoring)
  • Financial Category = Z002 (Opex)
  • Financial Group = Z001 (All Costs)


Project Cost - Capex Currency

/RPM/FIN_PLAN-CURRENCY

Display-only; Currency Display


PPM_ITEM

Project Cost - Capex:

/RPM/FIN_PLAN-AMOUNT

Display-only, format as per Currency

Filter:

  • Financial View = 22 (Project Cost - Scoring)
  • Financial Category = Z001 (Capex)
  • Financial Group = Z001 (All Costs)


Total Project Costs Currency

Display-only; Currency Display



Total Project Costs

Display-only, format as per Currency

Calculated:

Project Cost - OPEX + Project Cost - CAPEX

2. Project P&L Impact

PPM_ITEM

Price/Cost Multiplier

Mandatory

Select from list of defined multipliers; 1, 1k, 1m

Derive Price/Cost Factor:

If Currency Multiplier = 1

Price/Cost Factor = 1

Price Currency Display = Currency

ElseIf Currency Multiplier = 1k

Price/Cost Factor= 1,000

Price Currency Display ="k" & Currency

Else (Currency Multiplier = 1m)

Price/Cost Factor = 1,000,000

Price Currency Display ="m" & Currency


PPM_ITEM

Unit

Mandatory

Select from list of defined UOM


PPM_ITEM

Product Volumes Unit:

/RPM/FIN_PLAN-UNIT

Display-only, same as selected Unit

Filter:

  • Financial View = 80 (Product Volumes)
  • Financial Category = Z003 (All Costs)
  • Financial Group = Z001 (All Costs)


PPM_ITEM

Product Volumes:

/RPM/FIN_PLAN-QUANTITY

Optional, format as quantity in selected Unit

Filter:

  • Financial View = 80 (Product Volumes)
  • Financial Category = Z003 (All Costs)
  • Financial Group = Z001 (All Costs)

PPM_ITEM

Product Selling Price Unit:

/RPM/FIN_PLAN-UNIT

Display-only, derived as Price Currency Display / Unit

Filter:

  • Financial View = 90 (Business Case)
  • Financial Category = Z092 (Product P&L)
  • Financial Group = Z921 (Product Selling Price)

PPM_ITEM

Product Selling Price:

/RPM/FIN_PLAN-AMOUNT

Optional, format is Currency per selected Unit

Filter:

  • Financial View = 90 (Business Case)
  • Financial Category = Z092 (Product P&L)
  • Financial Group = Z921 (Product Selling Price)


Sales Forecast Currency

/RPM/FIN_PLAN-CURRENCY

Display-only; Currency Display


PPM_ITEM

Sales Forecast

Display-only

Calculated per year:

Product Volumes * Product Selling Price * Price/Cost Factor / Currency Factor


PPM_ITEM

Product Variable Cost Unit:

/RPM/FIN_PLAN-UNIT

Display-only, derived as Price Currency Display / Unit

Filter:

  • Financial View = 90 (Business Case)
  • Financial Category = Z092 (Product P&L)
  • Financial Group = Z922 (Product Variable Cost)


PPM_ITEM

Product Variable Cost:

/RPM/FIN_PLAN-AMOUNT

Optional, format as per Product Selling Price

Filter:

  • Financial View = 90 (Business Case)
  • Financial Category = Z092 (Product P&L)
  • Financial Group = Z922 (Product Variable Cost)

 

 

Contribution Currency

/RPM/FIN_PLAN-CURRENCY

Display-only; Currency Display

2. Project P&L Impact

PPM_ITEM

Contribution

Display-only, format as per Currency

Calculated per year:

Product Volumes * (Product Selling Price - Product Variable Cost) * Price/Cost Factor / Currency Factor


PPM_ITEM

Contribution in % of Sales

Display-only, format as %

Calculated per year:

Contribution / Sales Forecast * 100



Total Fixed Costs Currency

/RPM/FIN_PLAN-CURRENCY

Display-only; Currency Display


PPM_ITEM

Total Fixed Costs:

/RPM/FIN_PLAN-AMOUNT

Optional, format as per Currency

Filter:

  • Financial View = 90 (Business Case)
  • Financial Category = Z092 (Product P&L)
  • Financial Group = Z924 (Total Fixed Costs)
3. Cash Impacts

Working Capital Currency

Display-only; Currency Display


PPM_ITEM

Working Capital

Display-only, format as per Currency

Calculated per year:

Working Capital/Sales Ratio * Sales Forecast



Change in Working Capital Currency

Display-only; Currency Display


PPM_ITEM

Change in Working Capital

Display-only, format as per Currency

Calculated per year:

Working Capital/Sales Ratio * (Sales Forecast this year - Sales Forecast last year)



Other Cash Impacts Currency

/RPM/FIN_PLAN-CURRENCY

Display-only; Currency Display


PPM_ITEM

Other Cash Impacts:

/RPM/FIN_PLAN-AMOUNT

Optional, format as per Currency

Filter:

  • Financial View = 90 (Business Case)
  • Financial Category = Z093 (Cash Impact)
  • Financial Group = Z932 (Other Cash Impacts)
4. Subsidies

Subsidy Currency

/RPM/FIN_PLAN-CURRENCY

Display-only; Currency Display

 PPM_ITEM

Subsidy:

/RPM/FIN_PLAN-AMOUNT

Optional, format as per Currency

Filter:

  • Financial View = 90 (Business Case)
  • Financial Category = Z094 (Subsidies)
  • Financial Group = Z001 (All Costs)
5. Interim Calculations
Year XXXX - Year YYYY

Display only

Year XXXX = Year of Project Kick-Off

Year YYYY = End Year for NPV Calculation


PPM_ITEM

Discount Period

Display-only, format as numeric, 1 decimal

Calculated per year:

Retrieve First Discount Period from /SYQ/T_SCORING_PARAMS-PARAM_VALUE where:

      • /SYQ/T_SCORING_PARAMS-CALCULATION = 'NPV'
      • /SYQ/T_SCORING_PARAMS-PARAM = 'First Discount Period'

If Year = Year of Project Kick-Off then

Set Discount Period to First Discount Period

Else

Add 1 to previous year Discount Period



Cashflow Currency

Display-only; Currency Display


PPM_ITEM

Cashflow

Display-only, format as per Currency

Calculated per year:

Cashflow = Contribution - Total Project Costs - Change in Working Capital - Other Cash Impact



Discounted Cashflow Currency

Display-only; Currency Display


PPM_ITEM

Discounted Cashflow

Display-only, format as per Currency

Calculated per year:

Cashflow / (1 + Discount Rate) ^ Discount Period



Risk Adjusted Contribution Currency

Display-only; Currency Display


PPM_ITEM

Risk Adjusted Contribution

Display-only, format as per Currency

Calculated per year:

Risk Adjusted Contribution = Contribution * Risk Adjustment %



Risk Adjusted Cashflow Currency

Display-only; Currency Display


PPM_ITEM

Risk Adjusted Cashflow

Display-only, format as per Currency

Calculated per year:

Risk Adjusted Cashflow = Risk Adjusted Contribution - Total Project Costs - Change in Working Capital 



Risk Adjusted Discounted Cashflow Currency

Display-only; Currency Display


PPM_ITEM

Risk Adjusted Discounted Cashflow

Display-only, format as per Currency

Calculated per year:

Risk Adjusted Cashflow / (1 + Discount Rate) ^ Discount Period



Cumulative Discounted Cashflow Currency

Display-only; Currency Display


PPM_ITEM

Cumulative Discounted Cash Flow

Display-only, format as per Currency

Calculated per year:

Discounted Cashflow for this year + Cumulative Discounted Cash Flow for previous year 


PPM_ITEM

Payback Period (Days)

Display-only, format as per Currency

Calculated per year:

If Cumulative Discounted Cash Flow = 0 then

Payback Period (Days) = zero

ElseIf Cumulative Discounted Cash Flow < 0 then

Payback Period (Days) =365

ElseIf previous year Cumulative Discounted Cash Flow > 0 then

Payback Period (Days) = zero

Else

Payback Period (Days) = (previous year Cumulative Discounted Cash Flow * -1) / (Cumulative Discounted Cash Flow - previous year Cumulative Discounted Cash Flow) * 365



Present value -ve Cashflow Currency

Display-only; Currency Display



Present value -ve Cashflow

Display-only, format as per Currency

Calculated per year:

If Cash Flow >= 0 then

Present value -ve Cashflow = zero

Else

Present value -ve Cashflow = Cashflow / (1 + Discount Rate) ^ Discount Period



Future value +ve Cashflow Currency

Display-only; Currency Display



Future value +ve Cashflow

Display-only, format as per Currency

Calculated per year:

If Cash Flow <= 0 then

Present value +ve Cashflow = zero

Else

Present value +ve Cashflow = Cashflow * (1 + Reinvestment Rate) ^ (# Cashflow Periods - Discount Period)



# Cashflow Periods

Derived:

# Cashflow Periods = End Year for NPV Calculation - Year of Project Kick-Off + 1

6. Financial IndicatorsPPM_ITEM

Year XXXX - Year YYYY

Where XXXX = Year of Project Kick-Off and YYYY = End Year for NPV Calculation


PPM_ITEM

NPV (Net Present Value)

Display-only, format as per Currency

Calculated:

   NPV (Net Present Value) = Sum (Discounted Cashflow) for all years



NPV Currency

Display-only; Currency Display


PPM_ITEM

Risk Adjusted NPV

Display-only, format as per Currency

Calculated:

   Risk Adjusted NPV = Sum (Risk Adjusted Discount Cashflow) for all years



Risk Adjusted NPV Currency

Display-only; Currency Display


PPM_ITEM

MIRR (Modified Internal Rate of Return)

Display-only, format as per Currency

Calculated:

FVCF = Sum (Present value +ve Cashflow) for all years   

PVCF = Sum (Present value -ve Cashflow) for all years * -1

MIRR = (FVCF / PVCF) ^ (1 / # Cashflow Periods) -1


PPM_ITEM

Discounted Payback Period

Display-only, format as per Currency

Calculated:

    Discounted Payback Period = Sum (Playback Period) for all years / 365


PPM_ITEM

VCI (Value Creation Index)

Display-only, format as per Currency

Calculated:

   VCI = NPV / Sum (Total Project Costs) for all years


PPM_ITEM

Project Score

Display-only, numeric

Refer to ERP-669 SAC Planning Portfolio Items for the calculation

7. Comments and JustificationPPM_ITEM_Long_Text

CGPL_TEXT-LTXT

Optional, long text commentary to support Business Case

Filter:

  • /RPM/OBJECT_LTXT-LTXT_FIELD_NAME = 'Business Case Comments/Justification'

Actions

Refresh & Calculate

On clicking 'Refresh & Calculate', the Project Cost rows are updated with the latest values (copied from the 'Project Cost' Financial View of the Portfolio Item) and all calculations are re-run.


Calculate & Save

On clicking 'Calculate & Save', the following automations occur all calculations are performed and the results saved.


Save as Version

On clicking 'Save as Version' a copy of the Business Case is saved. This is a non-editable version which can be displayed for future reference.

A Version is identified by the date & time it was created.

Story Page N+1 (etc.)

As story page N.

Story Filters

Details any filters that apply to the entire story. N.B. Most mandatory (e.g. security variables) should be applied in Datasphere.

Report

Field Name

Mandatory/Optional

Prompt Type

(Single Value, Multiple Single Values, Interval, Selection Option, Hierarchy)

Default Value(s) or Restrictions

(please provide default value)













Data models 

This section lists the data models consumed by the story and links to the functional specification describing them.

Data Model Technical NameData Model DescriptionJira Development IDLink to Data Model Functional Specification 
(Filled when available)Text for data model









Business Roles

The Business Case can be completed by:

Design Rationale

Content Ownership: Functional Consultant, Input from: Reporting & Analytics Consultant

Assumptions

The following assumptions have been made:

Dependencies

Indicate any dependencies or constraints that may impact development, in terms of requirements from internal or external applications or teams, limited access to legacy system, time constraints or data restrictions. Also, please specify schedule dependencies e.g. interface or batch jobs that must run prior to execution.

Special Requirements

Specify any special requirements or considerations that may impact the development based on specific locations, regulatory compliance or system limitations. Clearly outline requirements e.g. localization rules for countries like China

If the development interacts with third-party systems such as Icertis, describe any additional integration, security or authentication considerations that must be taken into account.

Frequency of Analysis/Report Run

The Business Case is required for financially driven Portfolio Item and will be completed/updated prior to each Stage Gate.

Testing Considerations / Dependencies

N.B. Unless this is a planning story, the testing should cover layout and user experience NOT data values for metrics created in the data model. Data model values will be tested in conjunction with the data model specification.

How to test

Please provide some guidance and/or test data to help the developer unit test the report. Please include both positive and negative testing (to validate error situations handling)

List any considerations essential for application test planning (e.g., test this before ABC along with DEF separate from GHI).

The developer will need to test repeatedly, so where appropriate provide instructions to reverse the actions performed so the test may be run again, or explain how to create new input data to the test. In particular, the developer will need logons for test users representing the various roles within the approval process.

Test Conditions and Expected Results

IDConditionExpected Results
1

Item is selected which has no previous Business Case.


Business Case is presented with default values and Project Costs pre-populated.

2All required data is entered.

Entered data is validated as expected.

3User clicks 'Calculate & Save'The calculations are performed and data is saved.
4Item is selected which has a previously saved Business Case.

Business Case is presented with previously entered data.

Calculations are re-run with same results as before.

5

Item is selected which has a previously saved Business Case.

Input data is changed.

User clicks 'Calculate & Save'

Calculations are re-run for the changed data with new results.

6

Project Cost is updated for an Item which has a previously saved Business Case.

Business Case is reopened.

User clicks 'Refresh' & Calculate'.

Initially, the Business Case is displayed with the previously saved data, including Project Costs.

Onn 'Refresh & Calculate' the latest Project Cost is copied into the Business Case and calculations re-run.

7User clicks 'Calculate & Save'The calculations are performed and data is saved, over-writing any previous data.
8Use clicks 'Save as Version'The current version of the Business Case is taken with date & time stamp.
9A Business Case Version is selected for display.The Version is displayed with all information unchanged. The data in non-editable.

Testing Considerations / Dependencies

Prerequisites for testing:

Other Requirements

Description of requirements not covered by topics above

See also

Insert links and references to other documents which are relevant when trying to understand this decision and its implications. Other decisions are often impacted, so it's good to list them here with links. Attachments are also possible but dangerous as they are static documents and not updated by their authors.

Change log