Price Sensitivity

Input Ports

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 'Input Product Array' must have the following columns:

1. Product (string - required): The name of the Product corresponding to a column of the same name in the 'WTP Matrix' input port. There can also be an additional row with a Product named 'No Sale' - this row is used to track those Customers who are in the Market but have not yet purchased a Product. If the Product column is not found then the Row Identification (RowID) column will be used in place of the Product column.
2. Price (double - required): The 'Static Price' of each Product in the Market. This 'Static Price' can be adjusted by the personalized 'Dynamic Price' found in the 'Input WTP Matrix'. Personalized Price = Static Price x PAV + PAF. For example, some Customers may be entitled to the percentage Discount found in the 'Price Adjustment Variable' (PAV) column, or some Customers may need to pay the personalized delivery charges found in the 'Price Adjustment Fixed' (PAF) column. The Static Price of the 'No Sale' Product, if included, should be zero. Products with missing Prices are deemed to be Out-of-Stock.
3. Cost (double): The Product Cost is only required if the 'Price Change Method' is set to raise/lower the Profit Margin by a percentage. Otherwise the Cost column is not required.
4. Holding Cost (double - optional): At the end of each period, except the last Liquidation Period, unsold Products with residual Inventory Capacity accumulate a Holding Cost that reduces the overall Profitability of the Product. Holding Cost can also be thought of the Opportunity Cost of not having the capital tied up in Inventory available for investment in other projects. Products that do not have a Capacity Constraint will not be penalized a Holding Cost. If this field is missing then a zero Holding Cost is assumed.
5. Volume (double - optional): The 'Static Volume' of the Product relative to the Volume of other Products in the Market. For example, if a Product were a twin-pack then its Volume would be '2' while the Volume of the original Product would be '1' (default). Other scales could also be used, so that one Product might be 250 (ml) while another 500 (ml). But care with the scale should be taken as the Units are disregarded and the default of '1' will always be used if a Volume is missing. This 'Static Volume' field in the 'Input Product Array' is only important if an accompanying 'Dynamic Volume' field (or _VOL field) is found in the 'Input WTP Matrix'. Otherwise this field is ignored as Virtual Customers do not distinguish Products by the different Volume they require.
6. Units (string - ignored): The Units of Measurement (UoM) associated with the Product's Volume. For example, the Units could be set to 'ml' when the Products are liquids or beverages. But note that this Units field is ignored and only provided as a convenience. No conversion is provided between different Units. The model will not understand, for instance, that 1 'Litre' contains twice as much Product as 500 'mL'.
7. 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.
8. Quantity (integer): A reference Quantity sold for each Product in the actual (real-world) Market. If the Quantity is provided then an 'Quantity Error' will be returned as part of the results in the Output Product Array. The Quantity is required if the 'Market Size Option' is set to 'Set to total number of Customers in Product Array'. Change the 'Market Size Option' to 'Set to total number of Customers in WTP Matrix' to avoid specifying a Quantity in the 'Input Product Array'.
9. Transactions (integer): A reference number of Transactions for each Product in the actual (real-world) Market. Transactions are only relevant if Customers purchase by Volume. That is, the 'Input WTP Matrix' must contain either a 'Volume' field or at least one '_VOL' field. Otherwise each Customer will purchase only a single Product, and the number of Transactions will equal the Quantity sold.
10. Include (boolean): Set to FALSE to exclude a Product from the Price Sensitivity calculation only. This does NOT exclude a Product from the Market Simulation. All Products are included by default.

Input Willingness To Pay Matrix (double): The Willingness To Pay (WTP) Customer Distribution matrix for each Product column in the Market by each Virtual Customer row. The total number of Virtual Available Customers is equal to the number of rows in the WTP Matrix. In addition to each of the Product's WTP Customer Distributions, this 'Input WTP Matrix' can also contain two types of 'Dynamic Price' and two types of 'Dynamic Cost' Distributions that depend upon the Customers who Purchase the Product. These personalized 'Dynamic Prices' and 'Dynamic Costs' adjust the 'Static Price' and 'Static Cost' found in the 'Input Product Array' to calculate the Product's Margin.

1. Product01, Product02, etc (double): Each of the Products listed in the 'Input Product Array' should have a corresponding column in this 'Input WTP Matrix'. Each row represents a different Virtual Customer, and each value represents the Customer's Willingness To Pay (WTP) for each Product.
2. Volume (double - optional): The personalized 'Dynamic Volume' of Product demanded by each Virtual Customer. For example, if the 'Input Product Array' contains a list of beverages of Volume 250ml, 330ml, 500ml, 750ml, and 1000ml then a Virtual Customer with a demanded Volume of '1000' could purchase a Quantity of either 4, 3, 2, 1, or 1 of the Products (respectively). If Customers are buying by Volume then they must purchase in whole number integers. For instance, if a Product had a Volume of 250ml but a Customer demanded 300ml then the Customer would only be able to buy 1 of that Product. Note that the excess Volume of 50ml received by the Customer is deemed to be of no value! The Price, WTP, and Consumer Surplus are all re-scaled by the relative Quantity demanded. When Customers buy in Volume then the Output Transactions field will differ from the Output Quantity field - otherwise these two values ought to be the same. Note that the 'Input Product Array' need not also contain a 'Volume' field. If the Product Volume is missing then the Product is presumed to be sold in Volumes of 1 Unit.
3. _VOL (double - optional): The per-Product 'Dynamic Volume' (VOL) demanded by each Virtual Customer. This per-Product 'VOL' value will override the general 'Volume'. For example, a Virtual Customer buying laundry detergent might generally demand a 'Volume' of 2 (Litres) but might only demand a '_VOL' of 1 (Litre) for the concentrated detergent Product. Negative values will be replaced with a Demand Volume of zero '0'. If both of the 'Dynamic Volume' values ('Volume' and '_VOL') are missing then a default of '1' will be used.
4. _PAV (double - optional): The Price Adjustment Variable (PAV) is the percentage adjustment to the Price (typically a Discount) a particular Customer would receive when they Purchase the Product. For example, if the Customer is entitled to a 10% Discount then the 'PAV' would be set to 0.90. The 'Price Adjustment Variable' column is identified by the Product's Name followed by a trailing 'PAV'. The 'PAV' designator can be upper-case or lower-case and may-or-may-not be separated by a space, underscore, or other single character. For example, 'Product_01_PAV' or 'Product 02 PAV' or 'Product03pav'.
5. _PAF (double - optional): The Price Adjustment Fixed (PAF) is the fixed adjustment to the Product's Price. For example, if Customers pay different amounts for Shipping the Product then this could be modeled using the 'PAF' column. If the WTP Matrix contains both 'PAV' and 'PAF' columns, then the Price is first multiplied by the variable 'PAV' before adding the fixed 'PAF'. The 'Price Adjustment Fixed' column is also identified by the Product's Name followed by a trailing 'PAF' in a manner similar to the 'PAV' designator.
6. _CTS (double - optional): The Cost To Serve (CTS) is the additional Cost that must be incurred when a Product is sold to a particular Customer. This is a Dynamic Cost as some Customers are cheaper to serve than others, and is only incurred if the Customer actually Purchases the Product. The 'Cost To Serve' column is identified by the Product's Name followed by a trailing 'CTS'. The 'CTS' designator can be upper-case or lower-case and may-or-may-not be separated by a space, underscore, or other single character. For example, 'Product_01_CTS' or 'Product 02 CTS' or 'Product03cts'.
7. _CTM (double - optional): The Cost To Make (CTM) depends not upon the individual Customer but upon the number of Customers who Purchase the Product. This 'Cost To Make' can be used to simulate the Law of Diminishing Returns. Starting from the first row in the column, each 'Cost To Make' row represents the incremental Cost of manufacturing each additional Product. If the Product is sold ten-times, then the total Dynamic Cost is the sum of the first 10 CTM rows. The 'Cost To Make' column is also identified by the Product's Name followed by a trailing 'CTM' in a manner similar to the 'CTS' designator.

Output Ports

Output Product Array: The 'Output Product Array' corresponds to the 'Input Product Array' but is updated to reflect the results from the Market Simulation. The Product Array will contain these columns:

1. Product: The name of the Product corresponding to the Input Product Array.
2. Brand: The name of the Product Brand or a missing value if the Brand has not been defined.
3. Store: The name of the Product Store or a missing value if the Store has not been defined.
4. Location: The name of the Product Location or a missing value if the Location has not been defined.
5. Family: The name of the Product Family or a missing value if the Product Family has not been defined.
6. Category: The name of the Product Category or a missing value if the Category has not been defined.
7. Platform: The name of the Product Platform or a missing value if the Platform has not been defined.
8. Price: The 'Static Price' of each Product from the 'Input Product Array'. The 'Dynamic Price' from the 'Input WTP Matrix' is NOT included in this output 'Price' field so as to allow multiple Market Simulation nodes to be chained together. Instead the 'Dynamic Price' is accounted for in the output 'Margin' field.
9. Cost: The 'Static Cost' of each Product from the 'Input Product Array' or a missing value if the Cost has not been defined. The 'Dynamic Cost' from the 'Input WTP Matrix' is NOT included in this output 'Cost' field so as to allow multiple Market Simulation nodes to be chained together. Instead the 'Dynamic Cost' is accounted for in the output 'Margin' field.
10. Margin: The average Profit Margin of each Product, where: Profit Margin = Personalized Price - Static Cost - Average Dynamic Cost. The Personalized Price is the 'Static Price' adjusted by the two types of 'Dynamic Price'. The 'Dynamic Cost' depends upon the Customers who Purchase the Product and is averaged across the total Quantity Sold.
11. Volume: The given 'Static Volume' of the Product relative to the Volume of other Products in the Market or '1' if the Volume has not been defined in the input.
12. Units: The given Units of Measurement (UoM) associated with the Product's Volume.
13. Capacity: The Capacity Constraint of each Product or a missing value if the Capacity has not been defined. When the 'Holding Cost' for the Product has been set, Capacity will be treated as Inventory and the Residual Capacity after Quantity sold will be returned.
14. Quantity: The simulated number of Customers who selected each Product, including those who selected the 'No Sale' option.
15. Error: The absolute value of the difference between the actual input 'Quantity' and the simulated output 'Quantity'. The Error can be weighed and summed by downstream nodes to determine the 'Total Error' has part of the Tuning Loop to tune the Market Model. Note that the Quantity Error for the 'No Sale' Product is not calculated unless the user explicitly includes the 'No Sale' Product in the Input Product Array and sets a target Quantity to be greater than zero.
16. Transactions: The simulated number of Transactions for each Product. By default, each Customer will purchase only a single Product, and the number of Transactions will equal the Quantity sold. Transactions and Quantity will only vary if Customers are purchasing by Volume. That is, the 'Input WTP Matrix' must contain either a 'Volume' field or at least one '_VOL' field so that Virtual Customers demand different Product Quantity.
17. Share: The simulated Market Share as a percentage (%) of each Product based upon the 'Quantity' column but not including those Customers who selected the 'No Sale' option.
18. COGS: The Cost of Goods Sold (COGS) for the Product is calculated as the Product's 'Cost' and final 'Quantity'. COGS is only calculated if the Product's 'Cost' was provided in the 'Input Product Array'. Both the Static Costs and Dynamic Costs are included in the COGS.
19. COGH: The Cost of Goods Held (COGH) for the Product is calculated from the Product's 'Holding Cost' and residual 'Capacity' (after selling 'Quantity'). COGH is only calculated if both the Product's 'Holding Cost' and 'Capacity' are provided in the 'Input Product Array'.
20. Revenue: The Product's Revenue is calculated as the Product's 'Price' and final 'Quantity'.
21. Profit: The Product's Profitability is only calculated if the Product's 'Cost' was provided in the 'Input Product Array'. Both Static and Dynamic Prices and Costs are included in the Profit. In addition, if both the Product's 'Holding Cost' and 'Capacity' were provided, then the COGH is also calculated and subtracted from the Profit.
22. Sensitivity: The Price Sensitivity of the Product. This is calculated as the percentage change in Quantity divided by the percentage change in Price. The Quantity change is calculated as the Quantity at [Price * (1 - Change Factor)] minus the Quantity at [Price * (1 + Change Factor)] divided by the original Quantity. Sensitivity = [ (q2-q1)/q0 / (p2-p1)/p0 ]. To measure the percentage Quantity change given a 1% change in Price, the user will need to set the Change Factor = 0.5%. More detailed Price Elasticity and Cross Elasticity calculations can be made from the 'Output Price Sensitivity Array' table.

Output Price Sensitivity Array: Lists the degree by which a change in Price of each Target Product will impact of each of the other Impacted Product in the Market. The Price Sensitivity Array contains these columns:

1. If Product: The Target Product that is making a Price Change.
2. Change Method: The method by which the Price, Profit Margin, or Cost of the Target Product was changed.
3. Change Factor: The numeric degree by which the Price of the Target Product was changed.
4. Price Change From: The original Static Price of the Target Product.
5. Price Change To: The new Static Price of the Target Product after using the Change Price Method to change by the Change Factor.
6. Price Change: The difference between the original Price and the new Price of the Target Product.
7. Price Change Percentage: The percentage difference between the original Price and the new Price of the Target Product.
8. Cost Change From: The original Static Cost of the Target Product.
9. Cost Change To: The new Static Cost of the Target Product if it was changed by the Change Factor.
10. Cost Change: The difference between the original Cost and the new Cost of the Target Product.
11. Cost Change Percentage: The percentage difference between the original Cost and the new Cost of the Target Product.
12. Then Product: The other Impacted Product that was impacted by the Target Product's Price Change.
13. Then Brand: The Brand of the other Impacted Product.
14. Then Store: The Store of the other Impacted Product.
15. Then Location: The Location of the other Impacted Product.
16. Then Family: The Family of the other Impacted Product.
17. Then Category: The Category of the other Impacted Product.
18. Then Platform: The Platform of the other Impacted Product.
19. Correlation: The Correlation between the 'If Product' and the 'Then Product' when comparing their respective WTP Distributions.
20. Margin Change From: The original average Profit Margin of the Focus Product, where: Profit Margin = Personalized Price - Static Cost - Average Dynamic Cost. The Personalized Price is the 'Static Price' adjusted by the two types of 'Dynamic Price'. The 'Dynamic Cost' depends upon the Customers who Purchase the Product and is averaged across the total Quantity Sold.
21. Margin Change To: The new average Profit Margin of the Focus Product after its positioning was altered.
22. Quantity Change From: The original Quantity of the Focus Product.
23. Quantity Change To: The new Quantity of the Focus Product after its positioning was altered.
24. Quantity Change: The difference between the original Quantity and the new Quantity of the Focus Product.
25. Quantity Change Percentage: The percentage difference between the original Quantity and the new Quantity of the Focus Product.
26. Share Change From: The original Market Share of the Focus Product.
27. Share Change To: The new Market Share of the Focus Product after its positioning was altered.
28. Share Change: The difference between the original Market Share and the new Market Share of the Focus Product.
29. Share Change Percentage: The percentage difference between the original Market Share and the new Market Share of the Focus Product.
30. Revenue Change From: The original Revenue of the Focus Product.
31. Revenue Change To: The new Revenue of the Focus Product after its positioning was altered.
32. Revenue Change: The difference between the original Revenue and the new Revenue of the Focus Product.
33. Revenue Change Percentage: The percentage difference between the original Revenue and the new Revenue of the Focus Product.
34. Profit Change From: The original Profit of the Focus Product.
35. Profit Change To: The new Profit of the Focus Product after its positioning was altered.
36. Profit Change: The difference between the original Profit and the new Profit of the Focus Product.
37. Profit Change Percentage: The percentage difference between the original Profit and the new Profit of the Focus Product.

Output Price Elasticity Matrix: The 'Output Price Elasticity Matrix' is a symmetric matrix which maps both the 'Price Elasticity' and 'Cross Elasticity' for each Product in the Market. The 'Output Price Elasticity Matrix' contains these columns:

1. Scenario: Whether the Elasticity is calculated relative to Quantity, Revenue, or Profit. By default, Elasticity is measured as the responsiveness of the Quantity demanded relative to a change in Price. But Elasticity can also be measured as the responsiveness of the Revenue or Profit to a change in Price.
2. If Product: The Target Product that is making a Price Change. Each 'If Product' row is compared against each 'Then Product' column.
3. Price Elasticity: Price Elasticity measures the responsiveness of the Quantity, Revenue, or Profit of a Product relative to a change in the Product's Price. Price Elasticity is calculated as the change in Quantity over the change in Price, where the change in Quantity and Price have been calculated by this node using both the negative and positive 'Change Factor' defined by the user. Price Elasticity values are almost always negative and are located along the diagonal of the 'Output Price Elasticity Matrix' where the 'If Product' matches the 'Then Product'.
4. Cross Elasticity: Cross Elasticity measures the responsiveness of a Product's Quantity, Revenue, or Profit relative to a change in a different Product's Price. Cross Elasticity is calculated as the change in Column-Product's Quantity over the change in Row-Product's Price (that is, the 'If Product' Price). Cross Elasticity also calculated using both the negative and positive 'Change Factor' defined by the user. Cross Elasticity values are almost always positive and are located off the diagonal of the 'Output Price Elasticity Matrix'.

Output Purchased Products List: The 'Output WTP Matrix' made up of the Customer Distributions for each Product in the Market. The Output WTP Matrix is equivalent to the 'Input WTP Matrix' and has been provided as a convenience to further calculations by downstream nodes. The Output WTP Matrix will contain these additional columns:

1. Purchased: The name of the Product Purchased by each Virtual Customer. If the Customer didn't Purchase any Product then this will be set to 'No Sale'. The user can use the views to hilite the Customers of interest who switched their purchase decision. These Customers who switched as a result of the Price Sensitivity change can then be further analyzed.

Popular Predecessors

• Price Sensitivity20 %
• Row Filter (deprecated)20 %
• Column Filter20 %
• Price Maximize10 %
• Joiner10 %
• Show all 7 recommendations

Popular Successors

• Correlation Pairs To Matrix45 %
• Column Rename (Regex)23 %
• Price Sensitivity9 %
• Price War5 %
• Price Maximize5 %
• Show all 8 recommendations