Versions Compared

Old Version 6

changes.mady.by.user Bablot-ext, Romain

Saved on

compared with

New Version Current

changes.mady.by.user MENDES, Dina

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

 



The SHEET Contains initialy an extract based on Salesforce Inspector with the folllwing columns : 


Field API NameLabelTypeDescriptionValue


Then I arrange it to be : 


Object NameField API NameLabelTypeFunctionnal DescriptionValueIntegrationComment



The objective is to have in 1 sheet ALL fields. It will be easier to search common field definition. 

Also at a point I would recommend to load the Functionnal description in SF.


We are goint to setup specific Filter Views : 

  • Pricing Campaign
  • Price Settings
  • Quote
Final LABELDefinitionData ExamplePricing CampaignQuoteTransparencyShip-toPROCTER & GAMBLEXXShip-toProduct Level 5 (Material)Material PackagedRHODASURF PEG 9000 BULKXXMaterialProduct Level 4 (Product)Commercial product / Material groupRHODASURF L10 APE MB BULKN/AXProductRegionCampaign : GBU Region of the Ship to accountEMEAXXRegionManufacturing plantANCVXXManuf. PlantShipping PlantANCVXXShipping plantIncotermsDAPXXIncotermsCPC ReferenceCPC-00003726XN/AN/AUnit of MeasurementFor CPC, Original UOM available is only KG or LBKGXX?CurrencyFor CPC, Original Currency available is only EUR or USDEURXX?Pricing DashboardLinkXN/A?Scatter PlotN/AXBUCoatingsXGroup of activityGroup of ActivityXXSold-toAZELIS ITALIA SRLXXSold-toOwnerCampaign : The Account manager that is responsible of the CPC. He can update the Commited price.
Quote : User that manage the quoteJulien GENAXXGBUNovecareXXReference ContractXN/ALegal entityXN/AContractual commitmentXN/ALast 12M VolumeXN/AForecasted12M Volume of the Sold-to3393XN/AXLast sales month"Feb 2022"XN/ALast sales monthLast price1XN/ALast priceLast ICMBased on total variable costs of last transaction (Product & Freight)= $X $C/$M0,12XN/AXLast ICM%12%XN/AXActive SAP pricePrice conditions extracted from SAP price list, and converted to local currency2XN/ATO BEEstimated next 3M volumeSource: Dynasys848.25XN/ATO BEPrice based on Margin squeezePrice to cover forward looking costs and to maintain the highest margin of the last 4 quarters0.22XN/AXAsset Price floorFloor price to be considered within an allocation on constrained assets0.54XN/ATO BEMarket Price policyPrice to achieve the margin policy defined by the Marketing Directors0.56XN/ATO BEFinal recommended priceMaximum price between 3 prices above (Margin squeeze, Margin floor and Margin policy)0.56XN/A?Account Manager CPC reviewCommitted / Rejected (soon "Below Recomendation" IPP-984) / Not yet reviewedXN/A?Committed pricePrice committed by sales team to provide visibility to the organizationXN/A?Reason for deviationIf committed price is 5% below the recommended price, please provide the main reasonXN/A?CommentsXN/A?RMD CommentsXN/A?Price increase % vs. active SAP price250,00XN/A?Price increase % vs. last invoiced price250,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 modeAir (road departure)XXMarket Margin PolicyXN/AAsset Margin FloorXN/AVariable Manufacturing Costs (forward)XN/AVariable Manufacturing CostN/AXFreightXXBracket (From-To)N/AXEstimated Annual Volume (KG)N/AXQuoted PriceN/AXDiscountN/AXICM%N/AXYearly Financial ImpactN/AXRationaleN/AXDescriptionN/AXApproval StatusN/AXCommentN/AXSpecial customer informationN/AXStock Holding StrategyN/AXMinimum Order QuantityN/AXLead Time (Days)N/AXContact NameN/AXQuoted extended ?N/AXRenewed FromN/AX