SAP CRM CRM 20 07 Detailed View Presentatio Presentation n
Trade Promotion Management Part Two: Funds Management
B u s i n e s s Pr Pr o c e s s Overview
1. Busi Busines ness s Proces Process s Overvi Overview ew 2. Cu Curr rren entt Sol Solut utio ion n 3. Append ndiix
© SAP 2007 / Page Page 2
B u s i n e s s Pr Pr o c e s s Overview
1. Busi Busines ness s Proces Process s Overvi Overview ew 2. Cu Curr rren entt Sol Solut utio ion n 3. Append ndiix
© SAP 2007 / Page Page 2
Co n s u m e r Pr o d u c t s B u s i n e s s P r o c e s s Board / Executive
Strategic Targets
Brand Targets
Marketing
Brand Plan
Marketing Plan Reconciliation
Sales
Sales Targets
Top Down Sales Plan Bottom Up Sales Plan
Trade Promotion Plan
Demand Plan
Logistics
Financials
Claims Management
Investment Plan
Financial Statement Plan
Funds Management
Supply Network Plan
Production Plan
Dr i l l d o w n o f T PM B u s i n e s s Pr o c e s s BPS
Develop Overall Channel and Customer Plans: •Planning Customer
•Tactics
•Month
•Category Plan
Claims Management
•Short-term
•Product Categories
•Brand Plan
Trade Promotion Plan: •Long-term
•Total and Target Volume
Inputs
Applications
•Objectives
•Profitability
•Templates
•Marketing Calendar •Historical Analysis
CRM
Develop Key Customer/Product Category: •By period, events, terms and conditions •Agreements
Top Down Sales Plan Bottom Up Sales Plan
Trade Promotion Plan
Funds Management
Claims Management
Funds Management
Agreement Acceptance and Promotion Plan
Pr o c e s s Ov e r v i e w :
1. Headquarter Planning
Consensus Plan Sales Budgeting Schedule Creation
2. Account Planning
Pre-analysis Event Planning Promotion Planning
5. Evaluation & Analysis
KPI Reporting Syndicated Data Funds Tracking
4. Retail Execution, Validation & Settlement
FSR support Invoicing Payments
3. Sell-in & Negotiation
Proposal generation Demand planning Flexibility
Pr o c e s s Ov e r v i e w :
Trade Funds Management
1. Headquarter Planning Consensus Plan Sales Budgeting Schedule Creation
Planned, Committed, Accrued
Budget
2. Account Planning
5. Evaluation & Analysis
Pre-analysis Event Planning Promotion Planning
Trade Promotion Management
KPI Reporting Syndicated Data Funds Tracking Budget tracking
4. Retail Execution, Validation & Settlement
Trade Funds Management
Planned, Committed, Accrued
FSR support Invoicing Payments
3. Sell-in & Negotiation
Proposal generation Demand planning Flexibility
Pr o c e s s Ov e r v i e w :
1. Headquarter Planning
Consensus Plan Sales Budgeting Schedule Creation
2. Account Planning
Prepayments
5. Evaluation & Analysis
Pre-analysis Event Planning Promotion Planning
KPI Reporting Syndicated Data Funds Tracking
Trade Claims Management
Finalization Schedule Payments Trade Claims Management
4. Retail Execution, Validation & Settlement
Deductions Invoices Direct Payments
FSR support Invoicing Payments
3. Sell-in & Negotiation
Proposal generation Demand planning Flexibility
Cu r r e n t So l u t i o n
1. Business Process Overview 2. Current Solution 3. Appendix
© SAP 2007 / Page 8
Pr o c e s s Ov e r v i e w :
Trade Funds Management
1. Headquarter Planning Consensus Plan Sales Budgeting Schedule Creation
Planned, Committed, Accrued
Budget
2. Account Planning
5. Evaluation & Analysis
Pre-analysis Event Planning Promotion Planning
Trade Promotion Management
KPI Reporting Syndicated Data Funds Tracking Budget tracking
4. Retail Execution, Validation & Settlement
Trade Funds Management
Planned, Committed, Accrued
FSR support Invoicing Payments
3. Sell-in & Negotiation
Proposal generation Demand planning Flexibility
T r a d e Fu n d s M a n a g e m e n t
Trade Funds Management (TFM) is a CRM based application that enables you to set up and manage fund programs and funds, thus allowing to plan and track how you spend your money for trade. TFM is integrated into:
TPM Trade Promotion Planning
MDF Market Development Fund Initiatives
CRM Claims Management
SAP NetWeaver Business Intelligence
ERP Financials (CO-PA, Accruals)
APIs to integrate external business planning and forecasting tools
T r a d e Fu n d s M a n a g e m e n t
Top Down Sales Plan Trade Promotion Plan
Bottom Up Sales Plan
Funds Management
Claims Management
T r a d e Fu n d s M a n a g e m e n t
Plan, fund and track trade promotion spending: Multi-dimensional
set-up of discretionary budgets with the f ramework to support performance-
based live accruals Detailed
tracking and auditing of all funds transactions
Full
budget check capabilities for planning and settlements
Full
checkbook capabilities
Full
accrual management capabilities
Fu n d s M a n a g e m e n t M a i n F ea t u r e s
Multi-dimensional set-up of discretionary budgets with the f ramework to support performance-based live accruals Definition of fund plans Manual set-up and allocation in CRM
Import from external planning and forecasting tools like SAP BPS
Detailed tracking and auditing of all funds transactions Sarbanes-Oxley and FASB accounting standard compliant Full visibility into planned, committed, accrued, settled, paid, etc. values
Fund checkbook view for accounts, categories and organization units
Full budget check capabilities for planning and settlements
Full checkbook capabilities
Full financial accrual management capabilities The accrual management allows detailed bottom-up accrual calculations based on promotions or fund budgets, and triggers them in ERP FI/CO
Fu n d s M a n a g e m e n t : Cu r r e n t So l u t i o n Trade Funds Management
Fund Types and Allocation Rules
Funds Plans, Funds and Budget Distribution
Funds Determination and Accruals Period-end Processing
© SAP 2007 / Page 14
Fu n d s M a n a g e m e n t Pr o c e s s
Fund Type
A fund type defines: Fund category (e.g. fix/variable) Whether budget is accrued and how it is accrued Calculation frequency Calculation method Accrual Base All funds that are tied to a certain fund type will follow the pre-defined rules of that fund type Fund types are set-up for different purposes to separately track budgets within the Funds Management process. Examples for fund types are: Audio/Video, Base, Travel Bill back, Display, Off-Invoice
Fu n d T y p e - Co n f i g u r a t i o n Fund Category: Fixed vs. Variable
Accrual profile: Fixed vs. Variable
Expense Type is a categorization according to the purpose, e.g. Displays Advertising Shelf space Assignment Expense Type to Fund Type done in IMG
Fu n d T y p e – Co n f i g u r a t i o n (c o n t i n u e d )
Customer and Product Dimension
Fiscal year variant And currency
Fund attribute matches the fund attribute assigned to the fund type.
Territory check
Number range For Fund Postings
A s s o c i a t i n g Fu n d s Pl a n t o a Pr o m o t i o n
Trade Promotion
Funds Plan
Trade Spends
Product
Fu n d s Pl a n A s s o c i a t i o n t o a T P
Funds Plan group funds for a fiscal year
Funds Plan is an attribute for a TP and this attribute is later used in Fund Determination
Funds plan for a TP can be either:
Determined – BAdI:
Default implementation to use Currency and Sales Area – Default Funds Plan if unique –
F4 help – Search –
on multiple attributes of the Funds Plan
Only “Released” Fund plans to be retrieved by search
Fu n d A s s o c i a t i o n o n a T r a d e Pr o m o t i o n : Di f f e r e n t L e v e l s
Trade Promotion
Funds Plan
Fund
Trade Spends
Fund
Product
Fund
Fund
The level at which funds are associated on a promotion is driven by how the funds are setup Brand specific Trade Spend specific … …
Fu n d s C a n B e A s s o c i a t e d T o O n e Of T h e 4 Levels
A customizing setting to determine at what level funds can be associated
Customizing Setting: Fund Association Level
Promotion Type Price Reduction
Fund Association Level Trade Spend
Scan Based
Product
When a Promotion is created, the system looks up the customizing setting to determine the fund association level UI will be dynamic and display fund information only at the appropriate level - Ex: If Fund Association Level is ‘Product’, then user will not see any fund information at the Trade Spend level.
Default is Trade Spend level if customizing setting is not maintained
Funds can be associated at only one level (exception – discussed in Fund Usages)
Fu n d A s s o c i a t i o n a t Ro o t L e v e l
Fu n d A s so c i a t i o n a t P r od u c t L e v e l
New Fund Field on Product Group, Product, Product Category, Product Segment Assignment blocks. In Edit mode for the assignment block, F4 Value for this field will invoke the fund determination procedure
Fu n d A s s o c i a t i o n a t T r a d e Sp e n d L e v e l
New Fund Field on planning assignment block In Edit mode for the assignment block, F4 Value for this field will invoke the fund determination procedure
Fu n d As s o c i a t i o n a t I n t e r s e c t i o n L ev e l
B illb a c k E v e n t R e la te d O f f-In v o ic e G aStar t o ra dCookies e S port GStar a t o raChocolates de E nergy T r o Star p ic a n Chips a OJ
F1
F3
F4
F1 F2
F5
A new assignment block on the trade promotion overview page. Editable only if “Fund Association Level” is set to ‘Trade Spend – Product’ The cells where Fund information is visible is editable. Fund determination is fired whenever Value Help is accessed
Expense Types are displayed as columns instead of Trade Spends
Fu n d A s s o c i a t i o n Ca n B e M a n ua l o r A u t o m a t e d
Key Account Managers can associate funds manually at the appropriate level
F4 Value help for funds will display a result based on fund determination
Display 10 funds in the F4 Value Help. Provide navigation to next 10 and so on
Funds association can be automated as well when trade promotion status is set to “Released”
A s s o c i a t e Fu n d s A t T h e A p p r o p r i a t e L e v e l
When Fund Determination is invoked via Automation:
The system determines the funds at the intersection level - Errors if fund cannot be determined
Looks up the ‘Fund Association Level’ customizing setting to associate funds at the appropriate level
B illb a c k E v e n t R e la te d O f f-In v o ic e G aStar t o r a dCookies e Sport GStar a t o r Chocolates ade Energy T r o Star p ic a n Chips a OJ
F1
F3
F1 F2
F5
F4
Invoke the complete Fund Determination procedure for each of the cells
Fu n d s M a n a g e m e n t : Cu r r e n t So l u t i o n Trade Funds Management Fund Types and Allocation Rules Funds Plans, Funds and Budget Distribution
Funds Determination and Accruals Period-end Processing
© SAP 2007 / Page 29
Fu n d s M a n a g e m e n t Pr o c e s s
Funds Plan
A framework for the funds set-up defines fundamentals like: validity period currency and others attributes that all funds have in common
Group funds to a logical unit, e.g. US Trade Funds 2007
Funds Plan
Create Funds Plans Manually or by copying of existing Funds Plan For different areas and purposes Fund
Fu n d s P l a n Ov e r v i e w Pa g e
Navigate to Funds Overview Page
Available Columns: • Employee Responsible • Account Hierarchy Node • Created on • Created by
Funds
A fund specifies a container for budgets
Available for a specific reason during a specific planning period, e.g. Kroger Star Cookies
Fund is identified by Funds
Plan
Fund
Type
Fund
Attributes Budget
Fund
Fu n d O v e r v i e w Pa g e
Fund Attributes section will dynamically show only those attributes which are required for the Fund Type selected above.
Additional customized k ey values can be displayed here (Checkbook configuration)
Fu n d Ov e r v i e w Pa g e (A s s i g n m e n t B l o c k s )
Navigate to Budget Postings Overview Page
Navigate to Fund Usage Overview Page
Navigate to Application Object Overview Page.
Set -up Funds Pla n
A Finance personnel creates a funds plan.
Funds Plans may also be created via an external application
User can add additional information, e.g. maintain notes, attach documents, assign involved parties, select sales area
Ch a n g e F u n d s P l a n St a t u s
Finance
personnel changes the status to Released in order to assign funds . New
Release Lock Locked
Released
Release Close
Close
Closed
Archive
Archived
Release
Cr e a t e F u n d A Finance personnel creates a fund Funds may also be created via an external application
User can add additional information, e.g. maintain notes, attach documents, assign involved parties, select sales area
Fu n d St a t u s Finance
personnel changes the status to Released in order to make the funds available for consumption.
Fu n d St a t u s New Initial status when a fund is created. You cannot post any budget yet. All fields are still modifiable and you can still delete the fund. Preliminary You can switch a fund from status [New] to [Preliminary], to start setting up budgets. Fund is not yet consumable. You cannot delete it any more, but need to cancel it instead. Preliminary funds are not active for accruals yet. Released Once a fund is released, all transactions are allowed – you can prepay, plan, accrue and settle from the fund. Note that you can cancel a fund only after you have zeroed out the budget. Accruing funds are now active for the accrual process.
Fu n d St a t u s
Locked
A released fund can be locked at any time, to temporarily disallow budget changes and budget consumptions.
Accrual processes continue, and fund usages for locked funds can still be closed.
The fund can be released again by reactivating it.
Cancelled
A preliminary fund, which for some reason is not to be released, can be canceled. When the fund was released before, you need to manually set the budget to zero before.
The fund can be reused by reactivating it (set status to Preliminary).
Closed
Funds are closed at the end of their life cycle. This can be a manual or automated process.
As part of standard, there will be no automatic process to close funds.
Mass Copy of funds
A finance personnel can copy over the funds of an existing Funds Plan, with or without the initial budget or actual used budget, into a new Funds Plan.
Initial Budget: three possible values:
None - no initial budget postings. Initial Budget - the initial budget posting is equal to the total budget which was assigned to the fund. Actual Consumption - the initial budget posted to the new fund is the total “Spent” amount of the fund being copied.
Fu n d s M a n a g e m e n t Pr o c e s s
Budget
A budget can be either allocated or accrued on any level in the hierarchy (customer, product, and marketing organization) or combinations of these.
Budget Postings are used to create or change budgets in the funds Budget Updates are used to deposit or withdraw budget from a fund, initially or at a later point in time. With Budget Transfers budget can be distributed between different funds.
B u d g e t U p d a t e Ov e r v i e w Pa g e
First line item is d efaulted if budget posting has been created from the fund overview page
Available Columns (in Personalization) - Funds Plan ID - Funds Plan Description - Accrual Balance - Approved Claim - Available-to-Spend - Chargeback Balance - Expensed - Expired - Pending Budget - Prepaid Balance - Prereserved - Remaining Cash - Reserved - Settled
Di s t r i b u t e B u d g e t –> B ud g e t U p d a t e
In order to deposit budget in funds the Finance personnel creates a budget posting.
Funds may also be filled via an external application. Star Chips
User can add additional information, e.g. maintain notes, attach documents, assign involved parties, select sales area
E x t e r n al a l F un u n d s s er e r v ic ic e s – f u n c t i o n a l i t y supported
Mass creation of funds plans
Mass creation of funds
Change of funds plans
Change of funds
FPO (create funds, update budget through the fund postings API)
BPO (create funds, update budget through the budget postings API)
F u n d s Pl Pl a n O ve ve r v i e w a f t e r B u d g e t U p d a t e
Budget has been distributed to the selected funds in the budget update.
As seen on previous slide showing the Budget Update, the amount of the Budget Posting line item matches the amount on the Funds Plan Overview.
Budget can be visualized in the Fund Checkbook as well, as seen in the next slide
Star Chips
F u n d s Ch Ch e c k b o o k
Checkbook An overview of all the key figures that are calculated based on the value categories maintained for a fund A
financial report that rolls-up all of the t he value categories at a certain level
K e y f i g u r e s i n Ch e c k b o o k Key Figure
Value Category
Updated By
Use in TPM
Budget
Budget
Budget Posting
Budget – usually provided for a full fiscal year.
Prereserved
Prereserved
Trade Promotion
Budget amount requested for a TP, which is not yet approved.
Reserved
Reserved
TP
Budget amount reserved for TP, which are approved and released. When a TP is approved, Prereserved is decreased and Reserved is increased.
Accrual Balance
Accrual Balance
Settlement, Accrual Run
Amount financially accrued.
Claimed
ApprovedClaim
Claim
Amount approved on a claim. Replaces the Pending amount.
Settled
Settled
Settlement
Amount is settled, i.e. the settlement is sent to ERP. At the same time, Expenses are debited and corresponding accruals are released.
Write-Off
(WrittenOff)
Write-Off
Amount written off. This is a special type of expense.
Prepaid
Prepaid Balance
Settlement
Amount prepaid.
Ex c h a n ge B u dg e t b e t w e e n fu n d s – B u d ge t Transfer
A Finance personnel creates a budget transfer to exchange budget between funds (more budget for Rema Drink needed).
User can add additional information, e.g. maintain notes, attach documents, assign involved parties, select sales area
Guided flows available for the budget transfer
B u d ge t T r a n sf e r - w i za r d
B u d ge t T r a n sf e r - w i za r d
B u d ge t T r a n sf e r - w i za r d
B u d ge t T r a n sf e r - w i za r d
B u d g e t T r a n s f e r Ov e r v i e w Pa g e
Available Columns (in Personalization) - Budget -Funds Plan ID - Funds Plan Description - Transfer % - Expired - Approved Claim - Available-to-Spend - Chargeback Balance - Expensed - Pending Bdgt Reduct. - Prepaid Balance -Prereserved -Remaining Cash - Reserved - Settled - Written Off - Accrual Balance
Fu n d P o s t i n g s
All value flows are captured in Fund Postings, like e.g. changes to budgets, planned and reserved values, prepay and accrual balances, and expensed and settled amounts
Changes to budgets, fund usages or actuals are captured in Fund Postings, producing a line item based audit trail like in a financial system.
$ +100.000 Budget Update $ - 15.000 Trade Promotion, Spend Type Billback -> Budget reserved $ $ $
- 10.000 Prepayment - 5.000 Direct Payment + 20.000 Chargeback
Fu n d Po s t i n g O v e r v i e w Pa g e
Available Columns (in Personalization) - Transaction Amount - Transaction Currency - Budget Expiration Date - Account - Account Hierarchy Node - Fund Usage Type - Distribution Channel - Division - Expense Type - Fund Type - Fund Usage Description - Fund Usage ID - Product - Product Group - Territory - Service Organization
A t t r i b u t e s (V a l u e c a t e g o r i e s ) Monies are attributed to the following ‘states’:
Accrual Balance
Pending Prepayment Reduction
Approved Claim
Pending Write-Off
Budget
Prepaid
Chargeback Balance
Prepaid Balance
Expensed
Prereserved
Expired
Released to Settle
Pending Budget Reduction
Reserved
Pending Chargeback
Settled
Pending Claim
Write-Off
Pending Prepayment
Fu n d s M a n a g e m e n t V a l u e s Fl o w s
Tracks the movement of money (value) in various processes
Budget transfers and update
Budget reservations
Prepayments
Accruals
Claims
Settlements
Budget update Trade planning
Settlement
Trade Promotion lifecycle
Claim submission Prepayments
Chargeback
Write-off
Accrual run
B u s i n e s s Pr o c e s s a n d V a l u e Fl o w s
Business Process Budget Update (F1)
Setup TP & approve (TPM1)
Release Approve TP TP (TPM1) (TPM1)
Create Claim
Route fo r
Claim
Approval
Approved
Claim Settled
Value Flows s e i r o g e t a 1 C F e u l a V d n u F
Budget s e i r o g e t a C e u l a V e g a s U d n u F
1 M P T
Prereserved
Reserved
Open Claim
Pending Claim
Approved Claim
Release to Settle
Settled
Fu n d U s a g e
Fund usages are used in Funds Management to reserve parts of fund budgets. All fund consumptions are represented in the system by fund usages.
The funds can be reserved for: Claims Settlements Prepayments
Direct Payments Reservations
Chargebacks
Fund usages contain accrual information, such as the accrual profile, accrual dates, and the current accrual balance.
Fu n d U s a g e
Fund Usage is the consumption of a Fund through:
Trade Promotion
MDF initiatives (reservations)
Fund Usages can be claimed against, accrued and closed after the last claim is made to return unconsumed budget and accruals.
Fu n d U s a g e s C o n c e p t
Fund 1 Product: Chips Customer: Gro4U
TP1 – Chips $12,500
$12,500 Budget: $100K, Reserved: $0
Fund 2 Product: Cookies Customer: Gro4U
TP1 – Cookies $17,500
Budget:$200K, $200K,Reserved: Reserved:$17,500 $0 Budget:
Fund Usages
Trade Promotion “TP1”: Gro4U Miami, 2007-09-01 to 2007-09-30 Product
Price Reduction
Planned Scan Volume
Spend type Billback
Fund
Chips
$1.25 / case
10,000 cases
$12,500
Fund 1
Cookies
$1.75 / case
10,000 cases
$17,500
Fund 2
Fu n d U s a g e s P ro v i d e T h e A b i l i t y T o T r a c k Co n s u m p t i o n A g a i n st A Pr o m o t i o n Fund 1
Product: Chips Customer: Gro4U
Budget: $200K, $12,500, Budget: $100K,Reserved: Reserved: $12,500, Budget: $100K, Reserved: $0, Settled: $0 Settled: $11K Settled: $0
TP1 – Chips $11,000 $12,500
Fund 2
Product: Cookies Customer: Gro4U
Budget: $200K, Reserved: $17,500, Budget: $200K, Reserved: $17,500, Budget: $200K, Reserved: $0, Settled: $0 Settled: $16K Settled: $0
TP1 – Cookies $16,000 $17,500
Fund Usages
Consumption against a promotion Gro4U Miami, 2007-09-01 to 2007-09-30 Trade1:Promotion “TP1”:2007-10-15 Claim Gro4U Miami Product Promotion
Price Trade Spend Reduction
Planned Scan Product Volume
Spend type Amount Billback
Fund
TP1 Chips
Billback $1.25 / case
Chips 10,000 cases
$11,000 $12,500
Fund 1
Cookies TP1
$1.75 / case Billback
10,000 cases Cookies
$17,500 $16,000
Fund 2
Fu n d U s a g e O v e r v i e w Pa g e Available Columns (in Personalization) - External - Fund Type - Product - Product ID - Product Category ID - Product Group - Product Group ID - Pending Claim - Pending Prepayt Redn - Pending Prepayment - Pending Write Off - Prepaid - Prepaid Balance - Prereserved - Chargeback Balance - Expensed - Accrual Balance - Released-to-Settle - Written Off - Account Hierarchy - Account
Fund Usages Ensur e Reserv at ion Of Fund Budget Fund 1 Product: Chips Customer: Gro4U Fund Type: Nul l Fund 2 Product: Cookies Customer: Gro4U Fund Type: Nul l
TP1–Chips Potato/BB $12,500
TP1-Chips Potato/ Display $5,000
TP1-Cookies Choc/BB $17,500
Budget Budget:: $100K , Reserved: Reserved: $0 $17,500
TP1-Cookies Choc/ Display $10,000
Budget: Budget:$200K, $200K,Reserved: Reserved: $27,500 $0
Billback Fund Usages
Display Fund Usages
Trade Promotion “TP1”: Rema Store, 2007-09-01 to 2007-09-30 Product
Price Reduction
Planned Scan Volume
Spend type Billback
Spend Type Display
Chips
$1.25 / case
10,000 cases
$12,500
$5,000
Cookies
$1.75 / case
10,000 cases
$17,500
$10,000
Planning Grid and Fund Usage
Planning Grid and Fund Usage should always be in-sync
Fund Usages are created finally from the information in the planning grid
Customizing setting to define mapping between Expense Type and Key Figure to be used in creating fund usages.
Planning Grid
Fund Usages
Sample Customization Setting Expense Type
Key Figure
Display
0DISAB
BB-Scan
0BBSC
Fu n d U s a g e St r u c t u r e Billback
TP1 for Kroeger Ottawa
Fund: F1 Spend: ER Product: Gatorade Customer: Kroeger
Gatorade Sport Tropicana OJ Gatorade Energy
Fund F2 F3 F2
$2,000
Fund Usag e 1 C u s to m e r
K ro g e r O tta w a
E x p e n s e Ty p e
E v e n t R e la t e d
R e f O b je c t
TP1
Usage
1 Item
(s)
F un d
P ro d u ct
F1
G a t S p o rt
$ 1 ,0 0 0
F1
G a t E n e rg y
$ 2 ,0 0 0
A m oun t
Fund Usag e 2 C u s to m e r
K ro g e r O tta w a
Expense Typ e
B illb a c k
R e f O b je c t
TP1
Fun d
Usage F un d
Fund: F3 Spend: Billback Product: Tropicana Customer: Kroeger
F1
Fund Usages
Fun d
Fund: F2 Spend: Billback Product: Gatorade Customer: Kroeger
Event Related Fund Amount F1 $1,000
Amount $2,400 $4,000 $3,100
2 Item
(s) P ro d u ct
A m oun t
F2
G a t S p ort
$ 2 ,4 0 0
F3
T r o p ic a n a O J
$ 4 ,0 0 0
F2
G a t E n e rg y
$ 3 ,1 0 0
Fu n d U s a g e G e n e r a t i o n L e v e l Billback
TP1 for Kroeger Ottawa
Fund F2 F3 F2
Gatorade Sport Tropicana OJ Gatorade Energy
Event Related Fund Amount F1 $1,000
Amount $2,400 $4,000 $3,100
F1
F F uu nndd UUs sa g a eg se a s t aPtl aBnun di ngge Lt eLveevl e l
Fund: F1 Spend: ER Product: Gatorade Customer: Kroeger
Fun d Usage 1
Fun d Usag e 1 C u s to m e r
K ro g e r O tta w a
E xp e n se T yp e
E v e n t R e la t e d
R e f O b je c t
T P1
C u s to m er
E x p e n se T y p e
K ro g e r O tta w a E v e n t R ela t e d
R F uenf dO b U jseacgte 1 I t e m T(Ps1) F u n d FUusnadg e 1 I t e m P( rso)d u c t P Gr ao tdSupcotr t
A m$o1 u ,0n0 t0
FF 11
GGaattoEr na edreg y
$ 3$, 2 0 ,0 0 00 0
F e e2 2 F uu nn dd UUs sa ag g C u s t o m e r C u s to m er
Fund: F2 Spend: Billback Product: Gatorade Customer: Kroeger
E xp e n se Typ e
KKr o ge ro g re O r tOt at w t aaw a B illb a c k
R e f O b je c t
T P1
E x p e n s e Ty p e R e f O b je c t
B i ll b a c k
TP1
Fun d Usage 2 Item (s)
Fun d Usage 2 Item (s) Fund
F2
Fund: F3 Spend: Billback Product: Tropicana Customer: Kroeger
Am ount
Fu F 1n d
Fund
P ro d u ct
P ro d u ct
G a t S p o rt
F 2 F3
oa ra TG r oaptic nd a eO J
F 3 F2
pni ce a GTarto E r gnya
Am ount
A m o $u2n, 4t 0 0 $ 5$,45,0 00 00 $ 4$,30,0 00 10
Some customers have large number of products on a promotion which could lead to an explosion in the number of fund usage items
A customizing setting can aggregate generation of fund usages to the ‘Budget’ level
Fund Usage Generation Level: Budgeting Planning
$2,000
Wh e n A r e F u n d U s a g e s G e n e r a t e d ?
Status change of Trade Promotion
Controlled via customizing setting Fund Usage Value Category (Uneditable)
Promotion Status
Reserved
Released
Pre-reserved
Approved
Generate Usage
(mandatory)
(optional)
Usages are generated in specific value categories
Ability to turn off generation for ‘Pre-reserved’ value category
Invocation of ‘Generate Usages’ service via push button or execution in batch mode
Invoked when the status (relevant based on the above customizing setting) of the promotion changes
Detects if usages already exist and mak e updates in such a case
Invokes the ‘Assign Funds’ service, if funds are not associated at the intersection level
Invokes Availability check at Aggregate level to ensure budget is available - Errors if promotion is in released status (or is being released) and sufficient budget is not available
Creates usages for all expense types or none (if usage for an expense type cannot be created)
Fu n d U s a g e s Ge n e r a t i o n Du r i n g T r a n s i t i o n t o ‘A pp r ov e d’ St a t e
Created
Approve
Consistency Checks?
Trade Promotion Header
Planning Node Funds Plan
Kroeger Toronto TPM 2007 Planning Details
Fail Success
Product/Prod Cat Gat Sport
Spend Type ER Display
Vol
Cost
Amount
$4,000
Fund F2
Release Consistency Checks?
Approved
1. Fund Determination for each record at Intersection level
Fail
Released
Success
2. Check Availability for each record at Intersection level Request ed Am ount* >=
Finalize
Finalized
Archive
Archived
Budget – E xpi red – PendingBudgetReduction – Prereserved – Reserved –Variance - PendingPrepayment - Prepaid
3. Generate warning message if funds are not available (Application specific) 4. Generate funds posting to update the prereserved value category 5. Check Availability at aggregate level and generate appropriate warning messages
Fu n d U s a g e s Ge n e r a t i o n Du r i n g T r a n s i t i o n t o ‘Re l e as e d ’ St a t e
Created
Approve
Consistency Checks?
Fail Success Released Consistency Checks?
Approved
Trade Promotion Header
Planning Node Funds Plan
Finalized
TPM 2007 Planning Details
Fail
Released
Kroeger Toronto
Success
Product/Prod Cat Gat Sport
Spend Type ER Display
Vol
Cost
Amount
Archive
Fund F2
1. Confirm if Funds are associated at the intersection level (Run Fund Determination in case Funds are not assigned) 2. Check Availability for each record at intersection level
Finalized
$4,000
Requested Amount* >=
Budget – Expired –Reserved – Variance – Prepaid – Writeoff + Chargeback
3. Generate error message if funds are not available Archived
4. Generate funds posting to release value from the prereserved category and add the amount to the reserved value category
5. Check Availability at the aggregate level and error if AVC fails
A g g r e g a t e A v a i l a b i l i t y C h ec k
Billback
TP1 for Kroeger Ottawa
Gatorade Sport Tropicana OJ Gatorade Energy
Fund F2 F3 F2
Amount $2,400 $4,000 $3,100
Individual level Check: Is $3,100 available in Fund F2?
Event Related Fund Amount F1 $1,000
F1
Aggregate level Check: Can the following request be supported against each of the funds?
Fund
Requested Amount
F1
$3,000 ($1,000 for Gat Sport and $2,000 for Gat Energy)
F2
$5,500
F3
$4,000
$2,000
Fu n d A v a i l a b i l i t y
Fund availability balances the supply and demand for money is ensured trough AVC
Fund Budget and Fund Usages
Trade Plans and Claims
AVC - Availability Check Profile is specified in a customizing setting Promotion Status Released Approved
Promotion Type Price Reduction Scan - Based
AVC Profile TPM1 Hard AVC TPM1 Soft AVC
H o w I s A v a i l ab i l i t y C h ec k I n v o c a t i o n Co n t r o l l e d ?
Availability Check Profile is specified in a customizing setting Promotion Status Released Approved
Promotion Type Price Reduction Scan - Based
AVC Profile TPM1 Hard AVC TPM1 Soft AVC
Each time usages are generated, the check is invoked to ensure funds are available
Out-of-the-box, the system will raise an error if AVC fails in ‘Released’ status (or during transition to ‘Released’ status) - Warning in the event of AVC failure in ‘Approved’ status
Customers have the ability to override how AVC should be handled
The system behaviour when AVC fails is controlled by the AVC profile
The profile determines - The formula for AVC - Failure response – Error or Warning - Tolerance levels
Cu s t o m i z i n g f o r A V C: Fo r m u l a b u i l d e r
Create formula to evaluate key figures for every rule
Fu n d U s a g e s a n d F i n an c i a l A c c r u a l s
Financial Accruals for promotions are driven off of Fund Usages
Accrual Profile determines the accrual methodology for a specific fund usage
A customizing setting determines the Accrual Profile that will be used for a given trade spend on a promotion Expense Type BB Scan BB Ship Display
Promotion Type Price Reduction Scan - Based Temporary Price Cut
Accrual Profile Sales Volume Take Rate Profile Fixed Rate
System derives Accrual Profile during usage generation
Effective dates on trade spends are le veraged to determine the Accrual Start and End Dates on the usages
BAdI support to override the application behaviour to determine Accrual Profile
Fu n d U s a g es Wi t h A c c r u a l I n f o r m a t i o n
TP1 for Kroeger Ottawa
Gatorade Sport Tropicana OJ Gatorade Energy
Fund: F1 Spend: ER Product: Gatorade Customer: Kroeger
Billback (Take Rate Based - June 1-30) Fund Amount F2 $2,400 F3 $4,000 F2 $3,100 F u n d
U s a g e s
F u n d
U s a g e
P r o f ile
A c c r u a l
S ta r t
A c c r u a l
E n d
E v e n t R e la t e d F ix e d 1 - J u n - 0 8 3 0 - J u n - 0 8
R e f O b je c t F u n d
Fund: F2 Spend: Billback Product: Gatorade Customer: Kroeger
F u n d
U s a g e
T P 1 1
( s ) P r o d u c t
A m o u n t
F 1
G a t S p o rt
$ 1 ,0 0 0
F 1
G a t E n e rg y
$ 2 ,0 0 0
U s a g e
E x p e n s e
2 K ro g e r O tta w a
T y p e
A cc r u a l
P r o f ile
A c c r u a l
S ta r t
A c c r u a l
E n d
B illb a c k T a k e
U s a g e F u n d
R a te 1 - J u n - 0 8 3 0 - J u n - 0 8
R e f O b je c t
Fund: F3 Spend: Billback Product: Tropicana Customer: Kroeger
I t e m
F u n d
C u s to m e r
F u n d
$2,000
K ro g e r O tta w a
T y p e
A c c r u a l
F1
1
C u s to m e r E x p e n s e
Event Related (Fixed - June 1-30) Fund Amount F1 $1,000
T P 1 2
I t e m
( s ) P r o d u c t
F 2
G a t S p o rt
F 3
T r o p ic a n a
F 2
G a t E n e rg y
A m o u n t $ 2 ,4 0 0
O J
$ 4 ,0 0 0 $ 3 ,1 0 0
Fu n d s M a n a g e m e n t : Cu r r e n t So l u t i o n Trade Funds Management Fund Types and Allocation Rules Funds Plans, Funds and Budget Distribution Funds Determination and Accruals
© SAP 2007 / Page 80
Period-end Processing
Fu n d s M a n a g e m e n t Pr o c e s s
Fund determination mechanisms to associate funds at various levels
Fu n d De t e r m i n a t i o n I
Fund determination is used to assign the appropriate funds to:
Trade promotions
Reservations for market development funds (MDF) initiatives and MDF claims
Claims
Budget postings
Fund determination is based on the evaluation of certain determination rules that are defined in the fund determination profiles in Customizing. Fund determination varies from one scenario to another. For each fund determination profile, you can make settings for:
Org. Data (Organizational Data) Terr. Hier. (Territory Hierarchy) Acc. Hier. (Account Hierarchy) Prod. Hier. (Product Hierarchy)
T y p i c a l F u nd D et e r m i n a t i o n A l g o r i t h m
Fund Determination Procedure
1. Get all released funds based on funds plan on TP header
2. Filter based on org data of TP
3. Filter based on Planning customer of TP
4. Filter based on Product dimension
5. Filter based on expense type on line item
Fu n d A s s o c i a t i o n o n a T P Di f f e r e n t L e v e l s
Trade Promotion
Fund
Trade Spends
Fund
Product
Fund
Fund
M a n u a l Fu n d De t e r m i n a t i o n a n d F u n d A s s o c i a t i o n Level Level = “Root” Level = “P roduct” Level = “Trade Spend” Level = “Trade Spend - Product”
1. Get all released funds based on funds plan on TP header
2. Filter based on org data of TP
3. Filter based on Planning customer of TP
4. Filter based on Product dimension
5. Filter based on expense type on line item
Not applied in Fund Not applied in Fund Not applied in Fund Determination Determination Determination
Fu n d De t e r m i n a t i o n f o r T r a d e Pr o m o t i o n – Automatic
Start
1. Get header and item data for TP
4. Filter based on Planning customer of TP
Calling application action Service action
2. Get all released funds based on funds plan on TP header
5. Filter based on Product dimension
3. Filter based on org data of TP
6. Filter based on expense type on line item
7. If the filter is a unique match create a link between line and the fund
End
Fu n d De t e r m i n a t i o n f o r T r a d e Pr o m o t i o n Automatic 1. Get header and item data for TP
Start
4. Filter based on Planning customer of TP
2. Get all released funds based on funds plan on TP header
3. Filter based on org data of TP
6. Filter based on expense type on line item
5. Filter based on Product dimension
Calling application action
7. If the filter is a unique match create a link between line and the fund
Serviceaction
Fund F1 Name
Fund F2 F1
Fund F3
Name
F2
Name
F3
Fund Type Billbacks
Fund Type Event Related (Fi x)
Fund Type Event Related (Fi x)
Customer
Customer
Customer
Product
Kroger Gatorade
Budget
Product Budget
$50,000
Fund F5 F4
Kroger
Budget
$200,000
Product Hierarchy Gatorade Gatorade Drinks Gat Sport Gat Sport 20Oz 1Pk Gat Sport 10Oz 1Pk
Kroger Montreal
Gat Sport 30Oz 1Pk Gat Energy Tropicana Tropicana Citrus Tropicana OJ
Kroger Tropicana $150,000
Kroger BC Kroger Vancouver Kroger Victoria
Fund F6
Name
Fund Type Billbacks Customer
Budget
Customer Hierarchy Kroger Kroger Ontario Kroger Toronto Kroger Ottawa Kroger Quebec
$100,000
Fund F4 Name
Kroger Ontario
F5
Name
Fund Type Slots Customer Product Budget
Spend
Fund Type
Funds Plan
BB Ship
Billbacks
TPM 2007
F6
Tropicana Lemon Tropicana Sweet Tropicana Mango
Fund Type Billbacks
Kroger
Customer
Tropicana
Product $75,000
Budget
Kroger Toronto Tropicana $25,000
Trade Promotion Header C us to me r N od e
TPM 2007-2
BB Scan Billbacks
F1
F5
Planning Basis
ER Disp
ER (Fix)
F2
F6
Funds Plan
ER FA D
ER (Fix)
F3 F4
End
K ro ge r T or on to Product and Product Category TPM 2007 Planning Details Product/Prod Cat Gat Sport
Spend Type
Vol
BB Ship
10,000
Cost $1
Amount $10,000
Fu n d De t e r m i n a t i o n f o r T r ad e Pr o m o t i o n – V a l u e Help
Start
1. Get header and item data for TP
4. Filter based on Planning customer of TP
Calling application action Service action
2. Get all released funds based on funds plan on TP header
5. Filter based on Product dimension
3. Filter based on org data of TP
6. Filter based on expense type on line item
7. Get checkbook figures and pass to F4 popup
End
Fu n d De t e r m i n a t i o n f o r Tr a d e Pr o m o t i o n – V a l u e Help (F4 Hel p) 2. Get all released funds based on funds plan on TP header
1. Get header and item data for TP
Start
4. Filter based on Planning customer of TP
3. Filter based on org data of TP
5. Filter based on Product dimension
Calling application action
7. Get checkbook figures and pass to F4 popup
Serviceaction
Fund F1 Name
Fund F2 F1
Fund F3
Name
F2
Name
F3
Fund Type Billbacks
Fund Type Event Related (Fix)
Fund Type Event Related (Fi x)
Customer
Kroger
Customer
Customer
Product
Gatorade
Budget
Budget
$50,000
Kroger
Budget
$200,000
Fund F5 F4
Product Hierarchy Gatorade Gatorade Drinks Gat Sport Gat Sport 20Oz 1Pk Gat Sport 10Oz 1Pk
Kroger Montreal
Gat Sport 30Oz 1Pk Gat Energy Tropicana Tropicana Citrus Tropicana OJ
Fund Type Billbacks
F5
Name
Fund Type Slots
Kroger
Customer
Kroger
Product
Tropicana
Product
Tropicana
$150,000
Budget
F6
Tropicana Lemon Tropicana Sweet Tropicana Mango
Fund Type Billbacks
Customer Budget
Kroger BC Kroger Vancouver Kroger Victoria
Fund F6
Name
Customer
Kroger Toronto
Product Fund Name FundTropicana Description $75,000 Budget $25,000 Events for Kroger Ontario F2
F3
Spend
Fund Type
Funds Plan
BB Ship
Billbacks
TPM 2007
Events for Kroger corporate
TPM 2007-2
BB Scan Billbacks
F1
F5
ER Disp
ER (Fix)
F2
F6
ER FAD
ER (Fix)
F3 F4
End
Customer Hierarchy Kroger Kroger Ontario Kroger Toronto Kroger Ottawa Kroger Quebec
$100,000
Fund F4 Name
Kroger Ontario
6. Filter based on expense type on line item
Budget Reserved Claimed Settled Prepaid $50,000 $1,000 $500 $500 $200,000
$166,000 $150,000
$150,000
$0
$34,000
Trade Promotion Header Customer Node Kroger Toronto Planning Basis Product and Product Category Funds Plan TPM 2007 Planning Details P ro du ct /Pr od C at S pe nd T yp e
Gat Sport
ER Display
Vol
C os t
Am ou nt
$8,000
Fu n d De t e r m i n a t i o n “ a t w o r k ”
Here we can see that fund determination works in a budget transfer
A source fund was selected
Through fund determination, possible target funds were defaulted into the result list
Terminology
Trade Spends – Combination of Spend Type, Spend Method and Spend Category leveraged for a trade promotion
Intersection Level – Planning at the Trade Spend – Product level. Uplift, unit costs, etc. are specified at this level
Planning Sheet – The VTS grid that captures the spending at the Trade Spend – Product level
Billback Drink A
F1
Drink B
F1
Drink C
F2
Event Related F3
F5
Intersection Level
OffInvoice F4
T r a d e Sp e n d s – Ex p e n s e T y p e M a p p i n g
Expense Type drives FM services, especially Fund Usage creation Expense Type is Generic
The relationship between Trade Spends and Expense T ype will be a 1:1 relationship
A new customizing setting to enable the mapping between Trade Spends and Expense Type based on the following parameters of the Trade Spend: Spend Type Spend Category Spend Method
TPM: Spend Type
Other application
Expense Type
A sample “Trade Spend - Expense Type” mapping might be as follows:
Spend Type
Spend Category
Spend Method
Expense Type
Rebate
Scan based
Bill back
BB
Discount
Shipment
Off Invoice
OI
FM Services
MDF: Marketing Event Expenses
Co n f i g u r a b i l i t y – Fu n d d e t e r m i n a t i o n p r o f i l e
Every promotion uses a fund determination profile Promotion Type
Fund determination Profile
Fund determination profile to adjust the different filter values
Parameter
Value
Organizational Data
Ignore Direct match Hierarchical match
Territory Hierarchy
Ignore
(Note: the calling application will pass which account hierarchy to traverse and the date to be used for hierarchy traversal)
Direct match
Account Hierarchy
Direct match
(Note: the calling application will pass which account hierarchy to traverse and the date to be used for hierarchy traversal)
Direct match or attribute not specified
Hierarchical match
All levels in Hierarchy All levels in Hierarchy or attribute not specified Ignore
Product Hierarchy
Direct match Direct match or attribute not specified All levels in Hierarchy All levels in Hierarchy or attribute not specified Ignore
Fu n d T y p e – Ex p e n s e T y p e M a pp i n g
The mapping is primarily used in Fund Determination
Funds Type 0
Expense Type
Trade Spend Spend Type
Spend Category
Spend Method
Expense Type
Rebate
Scan based
Bill back
BB
Discount
Shipment
Off Invoice
OI
Se t t i n g U p T r a d e Fu n d s A n d Pr o m o t i o n s Customer Hierarchy
Kroger
Kroger Canada
Kroger ON
Kroger Mexico
Kroger US
Kroger Mexico City
Kroger BC
Kroger SE
Kroger NE
Product Hierarchy Beverages
Gatorade
Fund : F1 Spend: Billback Product: Gatorade Customer: Kroger
Tropicana
TP Gat Sport
Gat Sport 20Oz 1Pk
Gat Sport 10Oz 1Pk
Gat Energy
Tropicana Citrus
Gat Sport 30Oz 1Pk
Tropicana OJ
OffInvoice
Billback
Event Related
Slotting
Tropicana Sweet
Tropicana Lemon
Tropicana Mango
Trade Spends
Promotion : 2 for $4 Customer: Kroger US Spends: •Billback Products: •Tropicana Citrus
Pr o m o t i o n s A r e T y p i c a l l y Pl a n n e d a t a L o w e r L e v e l
Customer Hierarchy
Kroger
Kroger Canada
Kroger ON
Kroger Mexico
Kroger US
Kroger Mexico City
Kroger BC
Kroger SE
Kroger NE
Product Hierarchy Beverages
Fund : F1 Gatorade
Product: Gatorade Customer: Kroger
Tropicana
TP Gat Sport
Gat Sport 20Oz 1Pk
Gat Sport 10Oz 1Pk
Gat Energy
Tropicana Citrus
Gat Sport 30Oz 1Pk
Tropicana OJ
OffInvoice
Billback
Event Related
Slotting
Tropicana Sweet
Tropicana Lemon
Tropicana Mango
Trade Spends
Promotion : 2 for $4 Customer: Kroger NE Spends: •Billback •Event Related Products: •Gat Energy •Tropicana Citrus
Fu n d s M a n a g e m e n t Pr o c e s s
Accruals
Reserved budgets in Funds Management are accrued to ensure that expenses are posted in the fiscal period(s) they occur.
Load Accrual Reference Data Search and Display Accrual Reference Data Calculate Accruals Search, Display and Edit Accruals Post Accruals Accrual Reversal
Pr o c e s s O v e r v i e w
CRM Trade Promotion Management
CRM Funds Management
Fund Plan determined/ Specified on promotion
Funds Plan
Fund • Fund type • Customer • Product •Marketing Organization
Fund determination
Trade Promotion • Validity period • Customer • Product(s) • Trade spend(s) • Planned cost
ERP Financials
Fund Usage Header • Trade Promotion • Expense Type Items • Fund • Product • Amounts (in FM docs)
Creation/Updating
Expenses
Accrual Run
Calculate
Accruals
Transfer
and Post Accruals
Fi n a nc i a l A c c r u a ls – A c c r u a l Ca l c u l a t i o n R un Funds Plan Fund [Hierachy-Node;ProdCat;SalesArea]
Manipulation External application (i.e. Excel)
Fund Type Accrual Profile
BI- BPS
•Accrual Method •Reference Data
Info Cube
• Selects relevant Fund Usages • Calculates „Expected Expenses“ • Posts data to staging area • Can be started in test mode
Fund Usages for Accruals Fund
SpTyp
Budget
Accrual s
Expense s
F1
ACC1
$
6000
$ 1000
$ 1000
F2
ACC2
$ 10000
$ 10000
$ 10000
F3
ACC2
$ 2000
$ 2000
$ 2000
ODS
API
Expected Expenses
Accrual Run Accrual Staging Area • Can be repeated if required • Can be reversed if required • Is batch-enabled • Is assigned to a period
E X T R A C T O R
Fi n a nc i a l A c c r u a l s – A c c r u a l m e t h o d s supported The following accrual methods will be supported by the application:
ERP_SV
Accrues ERP sale volumes and TPM take rates using the ERP sales volume agreement accrual rate
FIXED_DT Accrues the amount reserved for the fund usage on a fixed date
FUNDFIXD
Used for fund-based accruals and accrues the entire amount of the fund on the date the accrual posting is performed (fixed date)
NB_DAYS Spreads the amount reserved for the fund usage equally over the number of days that it accrues. The number of days can span several periods.
TPM_PLAN
This accrual profile accrues TPM planning data
Fi n a nc i a l A c c r u a ls – A c c r u a l Po s t i n g Ru n
CRM Funds Management
ERP Financials
Transfer to Accounting • Account Determination (Spend Type G/L Account) • SalesOrg CompanyCode • Trigger GL- Posting
Accrual Posting Run Fund Postings for F2
Expected Expenses •Builds Fund Postings and updates fund usages •Triggers Account Determination •Extracts data to BI
Accrual Staging Area
• Accruals $10000• Expenses $10000 • Spend Type ACC2
•Assuming settlements have come in for F2 and F3
Fund Usages for Accruals Fund
SpTyp
Budget
Accrual s
Expense s
F1
ACC1
$6000
$1000
$1000
F2
ACC2
$10.000
$0
$10000
F3
ACC2
$2000
$0
$2000
Update Fund Usages
Fu n d s M a n a g e m e n t : Cu r r e n t So l u t i o n Trade Funds Management Fund Types and Allocation Rules Funds Plans, Funds and Budget Distribution
Funds Determination and Accruals Period-end Processing
© SAP 2007 / Page 103
Fu n d s M a n a g e m e n t Pr o c e s s
B a l a n c e Fu Fu n d U s a g e s
In order to finalize fund usages a Financial Analyst can search for fund usages
Select one, several or all and finalize them.
Any remaining accruals for the fund usage are released,
difference between the reserved amount and the total settled amount per fund is captured captured as ‘variance’ ‘variance’ for this fund usage.
Reserved
$ 10.000
Settled
$ 8.000
Variance
$ 2.000
Closing Fund Usages Releas es Funds Reserv R eserv ed For T h e Pr Pr o m o t i o n Fund 1
Product: Chips Customer: Gro4U
Budget: $100K, Available:$87,500, $89K, Budget: $100K, Available: $87,500K, Budget: $100K, Available: Budget: $100K, Available: $87,500 Reserved:$0, Settled: $11K$11K Reserved: $12,500, Settled: Reserved: $12,500, Settled: Reserved: $12,500, Settled:$0 $0
TP1 – Chip Chips s $11,000 $12,500
Fund 2
Product: Cookies Customer: Gro4U
Budget: $182,500, Budget:$200K, $200K,Available: Available: $184K, Budget: $200K, Available: $182,500, Reserved: $17,500, Settled: Reserved:$0, Settled: $16K$16K Reserved: $17,500, Settled: $0
TP1 – Cookies es $16,000 $17,500
Close Fund Usages
Fund Usages
Consumption against a promotion Gro4U Miami, 2007-09-01 to 2007-09-30 Trade1:Promotion “TP1”:2007-10-15 Claim Gro4U Miami Product Promotion
Price Trade Spend Reduction
Planned Scan Product Volume
Spend type Amount Billback
Fund
TP1 Chips
Billback $1.25 / case
Chips 10,000 cases
$11,000 $12,500
Fund 1
Cookies TP1
$1.75 / case Billback
10,000 cases Cookies
$17,500 $16,000
Fund 2
Appendix
1. Business Process Overview 2. Current Solution 3. Appendix
© SAP 2007 / Page 107
I n t e g r a t e d O v e r vi e w Full integration of TPM includes AOP/ Forecast and APO/ Demand Planning Periodic Trade Spend Expense (non event-based)
Funds
Accruals
Prelim Funds
AOP/ FORECAST
Baseline
Planned Trade Spend Promoted (event-based) Volume
APO/ DEMAND PLANNING
Promotion Attributes Base
TFM
Forecasted Volume
Commitments
Promoted Commitments
Claims/ Settlements
TPM
Budget Availability
TCM Promotions
Da t a Fl o w : De m a n d P l a n ni n g I n t e g r a t i o n
CRM 2007
SCM uplift
Create and save Trade Promotion (Marketing Planner)
plan data
baseline (for display)
BI Plan/Actual InfoCube
(incremental sales volume)
ERP
Total forecast
SD
Demand Planning Baseline forecast
baseline (copy via SEM function)
copy actual data by SEM function (including hierarchy derivation)
CO-PA
actual data
Actual InfoCube
CRM Co n s u m e r Pr o d u c t s So l u t i o n M a p ( Cu s t o m e r a n d C o n s u m e r )
Strategy
Brand & Category
Sales Planning
Planning & Budgeting
Execution
Evaluation
Bus Strategy & Planning
Marketing Calendar
Portfolio Management
Category Management
Media Planning
Creative Content
Target Setting (Vol,$)
Promotion Guidelines
NPDI
Marketing Dev Funds
Channel & Cust. Strategy
Volume Planning
Promotion Simulation
Claim Management
Fund ReAllocation
Funding Allocation
Fund Management
TPM
Accruals Management
Funds Checkbook
Chargebacks
KPI Planning
Portfolio Planning
Account Plan Development
Customer Management
Prepayments
Year End Rebate
Customer Segmentation
Objective Management
Visit Planning
Pricing & Contracts
Promotion sell in
Expense Reporting
Terms of Trade
Territory Management
Retail Execution
Promotion Validation
Order Management
Consumer Segmentation
Campaign Planning
Campaign Execution
Interactive Offers
Complaints & Returns
c e C n a t e l r l
Deduction Validation
Account
Trade & Sales
Consumer
m D i r a e i l c t
Market Research Brand Performance Promotion Effectiveness
e W -m e a b i / l
s F a e l i e l s d
P a r t n e r s
One view of Financials Field Sales Monitoring Third Party Data Response Rates Consumer Insights
/ B s r t o a n r c e s h
Marketing Solution map
Sales Solution map
Service Solution map
Analytics
Fu r t h e r i n f o r m a t i o n
© SAP 2007 / Page 111
SAP CRM - Roll-Out Map https://portal.wdf.sap.corp/go/crm-rollout-map
SAP CRM - Ramp-Up Knowledge Transfer (RKT) http://service.sap.com/rkt-crm
SAP CRM – Demo Portal http://crmportal.wdf.sap.corp:1080
SAP CRM – WiKi https://wiki.wdf.sap.corp/display/SAPCRMHub/Home
SAP CRM - Help Portal http://help.sap.com/crm
SAP Public Web http://www.sap.com/crm
