Tune Market
The Tune Market node is designed to take raw Customer Distributions for Products found in the Market and quickly tune them to create a Willingness To Pay (WTP) Matrix. A WTP Matrix quantifies the maximum Price that each Customer would pay for each Product in the Market.
Tuning a Market involves adjusting the Differentiation offered by each Product being sold. Stores, Products, and Features all offer their own Differentiating qualities. Differentiation describes the shape of a Customer Distribution and is quantified by the 'Mean', 'SD' (Standard Deviation), and 'Correlation' of the distribution. The 'Mean' quantifies Vertical Differentiation, the 'SD' quantifies Strange Differentiation, and the 'Correlation' quantifies Horizontal Differentiation.
The tuning algorithm systematically alters the 'Mean' and 'SD' (Standard Deviation) tuning parameters of each Customer Distribution until the simulated Market matches actual Market conditions. The initial 'Mean' and 'SD' tuning parameters are set in the Input Product Array or the Input Customer Distribution Matrix. The incoming Product-level Customer Distributions in the 'Input Customer Distribution Matrix' can be Unit Distributions or partially-tuned Willingness To Pay (WTP) Distributions.
The Willingness To Pay (WTP) Matrix output of the Tune Market node can be fed directly into a Profit Engine node in order to optimize the Price of a target Product or generate a Product Demand Curve.
Additional information that can be used to improve the accuracy of tuning is Price Elasticity and Cross Elasticity measurements. Analyzing historical sales data can yield information about the Price Elasticity of individual Products, and about the Cross Elasticity between Products in the Market. Price Elasticity measures the relationship between the changing Price of Product A and the subsequent change in Quantity sold by the same Product A. Cross Elasticity measures the relationship between the changing Price of Product A and the subsequent change in Quantity sold by different Product B. The observed Price Elasticity and Cross Elasticity from the real-world Market can be added to the 'Input Price Elasticity' table to increase the accuracy of the tuned Market Simulation.
Price Elasticity can also include information about the 'Out of Stock' impact a Product can have on other Products. If one Product is Out of Stock then sales of the other Products should increase. The degree by which sales increase reflects the degree of Competitive Rivalry between the Products.
The tuning algorithm operates in two phases. During the first phase, just the Quantity values are taken into account. During the second phase, both the Quantity values and the Price Elasticity measurements are taken into account.
To speed tuning, several Tune Market nodes can be cascaded together with increasing numbers of Virtual Customers. In this way, the calculated tuning parameters become increasingly accurate at each step in the cascade. But to do this, the user should first go into the Market Size Options for all but the last Tune Market node in the cascade and 'Set Output Market Size' to 'Override Product Quantities with Product Array'. This ensures that next node will tune according to actual market conditions.
More Help: Examples and sample workflows can be found at the Scientific Strategy website: www.scientificstrategy.com.
Input Ports
- Type: Data Input Product Array: The set of Products that define the Market. Each row corresponds to a Product that competes for customers in the Market. The 'Product Array' must have the following columns:
- Product (string): The name of the Product corresponding to a column of the same name in the 'Customer Distribution Matrix' input port. There can also be an additional row with a Product named 'No Sale' - this row is used to tune those Customers who are in the Market but have not yet purchased a Product. If there is no 'No Sale' Product then it is assumed that all Customers in the Market purchase a Product.
- Price (double): The Price of each Product in the Market. The Price of the 'No Sale' Product should be zero.
- Capacity (integer): The Capacity Constraint for the Product. A Product's Capacity may be limited by manufacturing constraints or by inventory levels. If the Capacity level is provided then the Quantity sold for the Product cannot exceed the Capacity limitation. If Capacity is not provided, or Capacity is negative, then the Quantity sold for the Product is not limited. Capacity will be limited relative to the total number of Customers in the 'Market Size' Configuration Dialog.
- Quantity (integer): The relative Quantity sold for each Product in the actual Market. The Quantity is treated as a percentage or a ratio. This Quantity from the actual Market will be compared against the Quantity from the simulated Market during the tuning process.
- Mean (double): The starting Mean of the Product-level Customer Distribution. This Mean will be altered during the tuning process by the user-defined 'Adjustment Percentage'. If the Mean value is missing then the starting Mean will be set equal to the Product Price. The final tuned Mean will be sent to the output port.
- SD (double): The starting Standard Deviation of the Product-level Customer Distribution. This 'SD' will be altered during the tuning process by the user-defined 'Adjustment Percentage'. If the Standard Deviation value is missing then starting Standard Deviation will be set to half of the Product Price. The final tuned 'SD' (Standard Deviation) will be sent to the output port.
- Tune: (optional) Contains special tuning instructions for the Product. The value of this 'Tune' field can be set to one of the following (not case-sensitive):
True adjust both the 'Mean' and 'SD' (Standard Deviation) of this Product
False don't adjust the 'Mean' or 'SD' (Standard Deviation) of this Product
Mean only adjust the 'Mean' but don't adjust the 'SD' (Standard Deviation)
SD only adjust the 'SD' (Standard Deviation) but don't adjust the Mean
Both adjust both the 'Mean' and 'SD' (Standard Deviation) of this Product (same as 'True')
Neither don't adjust the 'Mean' or 'SD' (Standard Deviation) of this Product (same as 'False')
- Type: Data Input Customer Distribution Matrix (double): The set of Product-level Customer Distributions. The incoming Customer Distributions can be either Unit Distributions or a partially-tuned Willingness To Pay (WTP) Matrix. Each row corresponds to a Virtual Customer and contains the customer's scaled Willingness To Pay (WTP). Each column corresponds to a Product. Each Product must have a corresponding entry in the 'Product Array' input port.
- Type: Data Input Price Elasticity: (optional) Additional measurements that can be used to tune the Market Simulation. Price Elasticity measures the relationship between the changing Price of Product A and the subsequent change in Quantity sold by the same Product A. Cross Elasticity measures the relationship between the changing Price of Product A and the subsequent change in Quantity sold by different Product B. The 'Input Price Elasticity' must have the following columns:
- If Product (string): The name of the trigger 'If Product' that changes Price. The 'If Product' must correspond to a row in the Input Product Array, and to a column in the 'Input Customer Distribution Matrix'.
- Price Change Percentage (double): The percentage difference between the original Price and the new Price of the trigger 'If Product'. A percentage of 10% is entered as 0.10 decimal. If including the sales impact a Competitive Product has when it is 'Out of Stock' on other Products, set this 'Price Change Percentage' to a very high value such as 9999.99 decimal. This effectively sets the Competitive Product Price to infinity as would be the case if the Product was Out of Stock.
- Then Product (string): The name of the impacted 'Then Product' that was impacted by the Price Change of the trigger 'If Product'. For Price Elasticity, the name of the 'If Product' and the 'Then Product' would be the same.
- Quantity Change Percentage (double): The percentage difference between the original Quantity and the new Quantity of the impacted 'Then Product'. A percentage of 10% is entered as 0.10 decimal. Note that the number sign is very important. Price Elasticity typically has different signs, such that a decrease in Price would result in an increase in Quantity. But Cross Elasticity would have the same sign, such that a decrease in the Price of one Product would result in a decrease in sales by another Product.
- Weight (optional): A numeric value to weigh the Quantity Error between the inputed Price Elasticity measurement and the forecasted Price Elasticity from the Market Simulation being tuned. If a weight is not provided then a weight of '1' will be used. A large weight should be placed upon Price Elasticity measurements that closely fit the historic data. The weighted influence of the Price Elasticity measurement can be found in the 'Output Price Elasticity' table, and in the 'Output KPI Indicators' table.
Output Ports
- Type: Data Output Product Array: The output Product Array corresponds to the input Product Array but has updated values in the 'Mean' and 'SD' columns that reflect the tuned results. The 'Quantity' column will also be updated according to the Market Size options. In addition, the Product Array will contain these additional columns:
- Share: The simulated Market Share of each Product based upon the 'Quantity' column but not including those customers who selected the 'No Sale' option.
- Quantity Error: The absolute value of the difference between the actual input 'Quantity' and the simulated output 'Quantity'. Note that the Quantity Error for the 'No Sale' Product is not considered unless the user explicitly includes the 'No Sale' Product in the Input Product Array and sets a target Quantity to be greater than zero.
- Revenue: The Product's Revenue is calculated as the Product's 'Price' and final 'Quantity'.
- Profit: The Product's Profitability is only calculated if the Product's 'Cost' was provided in the 'Input Product Array'.
- Type: Data Output Willingness To Pay Matrix: The tuned Willingness To Pay (WTP) Customer Distribution matrix for each Product column in the Market by each Virtual Customer row. The Output WTP Matrix quantifies the maximum Price that each Customer would pay for each Product in the Market. This WTP Matrix can be directly connected to a downstream 'Simulate Market' or 'Profit Engine' node.
- Type: Data Output KPI Indicators: The Output KPI Indicators contain select information about the tuning process and the quality of the final results. The Output KPI Indicators will contain these columns:
- Product: The Product associated with the Key Performance Indicator (KPI). If the KPI refers to the overall results and not to a specific Product then this field will be left blank.
- Indicator: The name of each Key Performance Indicator (KPI), including:
● Iteration Count: the number of iterations used during the tuning process.
● Final Adjustment: the final percentage (%) by which the 'Mean', 'Correlation', and 'SD' (Standard Deviation) of the incoming Distributions were adjusted.
● Sum of Total Error: the total sum of 'Sum of Input Actual Quantity Error' and the 'Sum of Price Elasticity Quantity Error'.
● Sum of Input Actual Quantity Error: the sum of the Quantity Error between the Actual Quantity and the Simulated Quantity for all Products in the Market.
● Sum of Price Elasticity Quantity Error: the sum of the Price Elasticity Quantity Change Weighted Error. Price Elasticity Quantity Error values for individual Products can be found in the 'Output Price Elasticity' table. The importance of the Price Elasticity Quantity Errors can be adjusted by the Weight value in the input table. - Value: The final value of each Key Performance Indicator (KPI).
These Output KPI Indicators are also output as Flow Variables:- TuneMarket.IterationCount Number of Tuning Iterations: The final count of the adjustments made to the 'Mean' and the 'SD' (Standard Deviation) tuning parameters of the incoming Customer Distributions. Only adjustments that result in an improved 'Error' are counted.
- TuneMarket.FinalAdjustment Final Adjustment Percentage: the percentage adjustment being made to the 'Mean' and 'SD' of all the Product Customer Distributions in the Market.
- TuneMarket.SumOfError Sum of Error: the sum of all 'Error' values in the output Product Array.
- TuneMarket.SumOfErrorSquared Sum of Error Squared: the sum of all 'Error Squared' values in the output Product Array.
- Type: Data Output Price Elasticity: Compares the measured Input Price Elasticity against the forecasted Output Price Elasticity from the tuned Market Simulation model. The Output Price Elasticity contains these columns:
- If Product: The Trigger Product that is making a Price Change.
- If Brand: The Brand of the Trigger Product.
- If Store: The Store of the Trigger Product.
- If Location: The Location of the Trigger Product.
- If Family: The Family of the Trigger Product.
- If Category: The Category of the Trigger Product.
- If Platform: The Platform of the Trigger Product.
- Change Method: Set to 'Input Price Elasticity' to indicate that the Price Change was set by the input table.
- Price Change From: The original Price of the Trigger Product.
- Price Change To: The new Price of the Trigger Product from the Input Price Elasticity table.
- Price Change: The difference between the original Price and the new Price of the Trigger Product.
- Price Change Percentage: The percentage difference between the original Price and the new Price of the Trigger Product.
- Then Product: The other Impacted Product that was impacted by the Trigger Product's Price Change.
- Then Brand: The Brand of the other Impacted Product.
- Then Store: The Store of the other Impacted Product.
- Then Location: The Location of the other Impacted Product.
- Then Family: The Family of the other Impacted Product.
- Then Category: The Category of the other Impacted Product.
- Then Platform: The Platform of the other Impacted Product.
- Quantity Change From: The original Quantity of the Focus Product.
- Quantity Change To: The new Quantity of the Focus Product after its positioning was altered.
- Quantity Change: The difference between the original Quantity and the new Quantity of the Focus Product.
- Quantity Change Percentage: The percentage difference between the original Quantity and the new Quantity of the Focus Product.
- Quantity Change Error: The difference between the measured Quantity Change from the Input Price Elasticity table and the forecasted output Quantity Change from the tuned Market Simulation.
- Quantity Change Weighted Error: The difference between the measured input Quantity Change the forecasted output Quantity Change multiplied by the input Weight. This Quantity Change Weighted Error is used by the tuning algorithm when finding the minimum error between real-world observations and the Market Simulation model.
Extension
This node is part of the extension
Market Simulation nodes by Scientific Strategy for KNIME - Community Edition
v4.0.0Short Link
Drag node into KNIME Analytics Platform