A price matrix is a collection of formulas that calculate the price of a product based on different purchasing scenarios. This topic outlines several possible scenarios you might want to configure. You set price formulas on the Price Matrix Master. Go to Sales>Pricing>Price Matrix.

Tip: To learn how to enter the options here, see Create a price formula in the matrix and Advanced price formula options

Parameters |
Product Line: Cabinets Customer Category: Contractors |

Formula |

Parameters |
Price Group: Water Heater Parts Customer Category: Schools |

Formula |
To calculate a gross profit of 25%, click the drop down arrow beneath the Calculator icon. In the Enter Desired Gross Profit box, type 25, and then press the Tab key to calculate the amount that will give you the desired 25% GP. In the example below, it calculates to 33.33. |

Parameters |
Product Line: Shower Doors Customer Category: Contractors Quantity: 10 (entered as part of the formula) |

Formula |
Note that all price formulas require a formula for one product (Quantity=1) before you can add special pricing for quantities greater than 1. In this scenario, there is no special pricing for 1 unit, so the first line has a Quantity of 1 with a zero amount. To add a second line, click Add Price Matrix Break, and then enter the price formula as above. |

Parameters |
Product Line: American Standard Price Contract: Fairfield County Schools |

Formula |