You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

This is a shared dictionnary to be used by Quote Team / Campaign Team & Transparency Team.

The working GSHEET is : [CORE] - Pricing Campaign - Dictionary - Google Sheets


In the GSHEET Dictionnary you can use the Salesforce Inspector in order to get all detail of fields, then copy/past in the file.


X : means it is used

N/A : means not used.


For Transparency we still need to review final wording.

Final LABELDefinitionData ExamplePricing CampaignQuoteTransparency
Ship-to
PROCTER & GAMBLEXXShip-to
Product Level 5 (Material)Material PackagedRHODASURF PEG 9000 BULKXXMaterial
Product Level 4 (Product)Commercial product / Material groupRHODASURF L10 APE MB BULKN/AXProduct
RegionCampaign : GBU Region of the Ship to accountEMEAXXRegion
Manufacturing plant
ANCVXXManuf. Plant
Shipping Plant
ANCVXXShipping plant
Incoterms
DAPXXIncoterms
CPC Reference
CPC-00003726XN/AN/A
Unit of MeasurementFor CPC, Original UOM available is only KG or LBKGXX?
CurrencyFor CPC, Original Currency available is only EUR or USDEURXX?
Pricing Dashboard
LinkXN/A?
Scatter Plot

N/AX
BU
CoatingsX
Group of activity
Group of Activity

XX
Sold-to
AZELIS ITALIA SRLXXSold-to
OwnerCampaign : The Account manager that is responsible of the CPC. He can update the Commited price.
Quote : User that manage the quote		Julien GENAXX
GBU
NovecareXX
Reference Contract

XN/A
Legal entity

XN/A
Contractual commitment

XN/A
Last 12M Volume

XN/A
Forecasted12M Volume of the Sold-to
3393XN/AX
Last sales month
"Feb 2022"XN/ALast sales month
Last price
1XN/ALast price
Last ICMBased on total variable costs of last transaction (Product & Freight)= $X $C/$M0,12XN/AX
Last ICM%
12%XN/AX
Active SAP pricePrice conditions extracted from SAP price list, and converted to local currency2XN/ATO BE
Estimated next 3M volumeSource: Dynasys848.25XN/ATO BE
Price based on Margin squeezePrice to cover forward looking costs and to maintain the highest margin of the last 4 quarters0.22XN/AX
Asset Price floorFloor price to be considered within an allocation on constrained assets0.54XN/ATO BE
Market Price policyPrice to achieve the margin policy defined by the Marketing Directors0.56XN/ATO BE
Final recommended priceMaximum price between 3 prices above (Margin squeeze, Margin floor and Margin policy)0.56XN/A?
Account Manager CPC review
Committed / Rejected (soon "Below Recomendation" IPP-984) / Not yet reviewedXN/A?
Committed pricePrice committed by sales team to provide visibility to the organization
XN/A?
Reason for deviationIf committed price is 5% below the recommended price, please provide the main reason
XN/A?
Comments

XN/A?
RMD Comments

XN/A?
Price increase % vs. active SAP price
250,00XN/A?
Price increase % vs. last invoiced price
250,00XN/A?
Commited price impact(Committed price - Last price) x Forecasted next 3 months volume5089.5XN/A?
New ICM per unit(Committed price) - (Forward looking product costs: $X $C/$M Freight & Duties:$Y $C/$M)5,45XN/A?
New ICM%(New ICM per unit / Committed price)77,86 %XN/A?
Last Transportation mode
Air (road departure)XX
Market Margin Policy

XN/A
Asset Margin Floor

XN/A
Variable Manufacturing Costs (forward)

XN/A
Variable Manufacturing Cost

N/AX
Freight

XX
Bracket (From-To)

N/AX
Estimated Annual Volume (KG)

N/AX
Quoted Price

N/AX
Discount

N/AX
ICM%

N/AX
Yearly Financial Impact

N/AX
Rationale

N/AX
Description

N/AX
Approval Status

N/AX
Comment

N/AX
Special customer information

N/AX
Stock Holding Strategy

N/AX
Minimum Order Quantity

N/AX
Lead Time (Days)

N/AX
Contact Name

N/AX
Quoted extended ?

N/AX
Renewed From

N/AX
  • No labels