- Release updates
- Analytics
- Campaign Manager
- CPQ
- About CPQ
- Global data configuration
- User and access management
- Accounts
- Activities
- Product modeling
- About product modeling
- Create products
- Manage product templates
- Hide product groups and sub-groups from the UI Profile
- Manage product BOMs
- Manage product knowledge bases
- Manage product attributes
- Manage product triggers
- Define a related product group
- Define calculations
- Troubleshoot product modeling
- Guided selling
- Equipment
- Leads
- Opportunities
- Quotes
- Pricing
- Approvals
- Extensibility
- Analytics and reports
- Report templates
- UI configuration
- Payment gateway
- Implementation
- Groovy Service
- About Groovy
- Binding variables
- Upload a Groovy script
- Extension Points
- About extension points
- Quote Proposal Sent
- Post Quote Creation
- Check Credit Limit
- On Quote Routing
- Simulate ERP Sales Order
- Create ERP Sales Order
- Create Price to ERP
- Filter Account List
- Sales Text Parameter Mapping
- Additional Data for Proposal Generation
- On Change Quote Pricing Relevant
- Create MTO Material
- Create MTO BOM
- Create MTO Routing
- Create Quote Routing Recipients
- Google Map Validation
- On Configuration Exits
- Organize Line Item Structure
- Generating AutoCAD Drawing
- Get Range Values
- Report Sync
- Additional Approval Action
- Quote to Sales Order Creation
- Server Startup
- Debugging Groovy Scripts
- IMCScript
- Groovy Service
- Integrations
- Microsoft Outlook
- Salesforce CRM
- SAP
- SSC
- Product recommendations
- Zilliant AI CPQ Assistant
- Logs
- eCommerce
- Deal Manager
- About Deal Manager
- Deal Manager use cases
- Configure Deal Manager
- Deal Manager objects and fields
- Activate Lightning record pages
- Make fields visible or editable
- Add Lines component
- Line Items component
- Workspace
- Customize components
- Edit Lines modal
- How Edit Lines modal works
- Conditionally display columns
- Expand sublines automatically
- Limit the number of lines
- Mark fields as required
- Configure text wrapping in fields and headers
- Freeze columns
- Display a link to the Details page
- Define subline columns as read-only
- Replace Save button with a custom action
- Mass Edit
- Sublines
- Filter lines and sublines
- Duplicate lines
- Copy and Template
- Scenarios
- CSV Import
- Apex hooks
- How Apex hooks work
- Pre-Entry Field Options Filterer
- Pre-Entry Fields Configurer Class
- Line Items Creation Configurer Class
- Line Items Evaluation Post Processor
- Line Items Operations Configurer Class
- Line Items Filterer Class
- Filter Field Post Processor
- Subline Change Line Subline Updater Class
- Tiered Subline Change Line Subline Updater Class
- Line Change Subline Updater Class
- Template Provider Class
- Mass Edit Parameter Options Filterer
- Subline Validator Class
- CDT Scoped Records Filterer Class
- Post-Processable Filter Picklist Configurer
- IQ Anywhere configuration
- Multicurrency
- Quick Starts
- Platform components
- IQ Interface
- About IQ Interface
- Get started with IQ Interface
- IQ Interface release notes
- Common questions
- Troubleshoot IQ Interface
- Workbooks
- Worksheets
- About worksheets
- Create a worksheet from a database
- Create a worksheet from a data file
- Create an aggregate worksheet
- Create a Tableau analytics worksheet
- Link Tableau analytics to a worksheet
- Refresh worksheet data
- Sort data
- Import and export data
- Define worksheet relationships
- Delete a worksheet
- Highlight rows
- Columns and column groups
- KPI cards
- Filters
- Locale settings
- Additional tailoring options
- Logs
- Price IQ
- Price Manager
- Sales IQ
- User administration
- Developer tools
- Connectors
- Resources
- Training
- Licenses and Libraries
- 07 Mar 2023
- 3 Minutes to read
- Print
- DarkLight
Passthrough Cost Global List template
- Updated on 07 Mar 2023
- 3 Minutes to read
- Print
- DarkLight
Objective
Use the recommendations in this template to analyze the impact of supplier cost changes and make price updates, including a full or partial "cost passthrough" to the global price list.
Example flow
Edit data
Open the Passthrough Cost Global List scenario workbook.
When you created the scenario, this workbook was loaded with data from base and decision support workbooks.Open the New Product Costs worksheet.
In the New Cost column, update product costs. Update values manually or upsert data from a CSV file.
Update the Proposed Start Date column. (If this column isn't visible, select > to expand the Publish Info column group.)
Specify or select values for Adjustment Type and Adjustment as shown in the following table. (If these columns aren't visible, select > to expand the Adjusted Cost column.)
Column | Type | Definition |
---|---|---|
Adjustment Type | calculated | Select Amount, Override, or Percentage. |
Adjustment | input | Enter a value based on the Adjustment Type selection. For example, if you select an adjustment type of Percentage, then enter a percentage value such as 5%. |
The value of the Adjusted Cost column is calculated as follows:
CASE
WHEN {Adjustment Type} = 'Amount' THEN {Cost} + COALESCE({Adjustment}, 0)
WHEN {Adjustment Type} = 'Percentage' THEN {Cost} * (1 + COALESCE({Adjustment}, 0))
WHEN {Adjustment Type} = 'Override' THEN COALESCE({Adjustment}, {Cost})
ELSE {Cost}
END
- In the Cost Passthrough Strategy column, select how the new product cost is applied to the global list price.
The following information shows how other columns, column groups, and KPI cards in this worksheet are calculated. Use this information for additional decision support.
Cost Difference
CASE
WHEN {Cost} = 0 THEN 0
ELSE (({Adjusted Cost} - {Cost}))
END
Cost Adjusted List
CASE
WHEN {Cost Passthrough Strategy} = 'Maintain Margin' THEN {Maintain Margin Price}
WHEN {Cost Passthrough Strategy} = 'Passthrough None' THEN {List Price}
WHEN {Cost Passthrough Strategy} = 'Passthrough 50%' THEN {List Price} + ({Cost Difference} *.5)
WHEN {Cost Passthrough Strategy} = 'Passthrough 100%' THEN {List Price} + {Cost Difference}
ELSE {List Price}
END
Maintain Margin Price
{Adjusted Cost} / (1 - {Current Margin}) * 100 / 100.00</code></pre>
New Price
COALESCE ({Price Override}, {Cost Adjusted Price})
Price Change
CASE
WHEN COALESCE ({List Price}, 0) = 0 THEN NULL
ELSE ({Cost Adjusted Price} - {List Price}) / {List Price}
END
New Margin
CASE
WHEN COALESCE ({List Price}, 0) = 0 THEN 0
ELSE ({New Price} - {Adjusted Cost}) / {New Price}
END
Current Margin
({List Price} - {Cost}) / {List Price}
Margin Difference
CASE
WHEN {New Margin} IS NULL
or {New Margin} = 0 THEN 0
ELSE ({New Margin} - {Current Margin})
END
- Open the List Price Review worksheet to review the value of Cost Adjusted List. This shows how the strategy you chose applies to the global list prices.
- By default, the List Price Review worksheet is filtered to show only records with cost changes.
- Calculated columns, column groups, and KPI cards in this worksheet provide additional decision support.
- Review the resulting global price in the New Price column of the List Price Review worksheet. If desired, override the value:
- Enter a value in the Price Override column.
- Update the New Start Date column. (If this column isn't visible, select > to expand the Publish Info column group.)
Publish data
In the New Product Costs and List Price Review worksheets, select the Publish checkbox for records that represent updated and final data. These records will be published back to the base and master data workbooks.
From the Actions menu, select Publish.
The selected records are synchronized with:
- Global and Country Lists Prices base workbook
- Country Prices base workbook
- Product Costs waterfall element workbook