A supplier ratio is required when you buy an item from your supplier in a different quantity or dimension than you sell the item.

Examples:

  • You buy chain, rope and wire by the spool, but sell it by the foot.
  • You buy packages of light bulbs by the case, but sell the packages individually.

 

Supplier sells item by One unit from the supplier equals Size/quantity sold in store Order quantity (sellable units) Supplier ratio
Spool 250 feet of wire One foot 250 feet 1/250 feet = 0.004
Stick 10 feet of pipe One foot 10 feet 1/10 feet = 0.1
Bundle of 10 sticks
(10 sticks x 10 feet = 100)
10 feet of pipe One foot 100 feet 1/100 feet = 0.01
  1. If you don’t know the supplier ratio and order quantity for the item, calculate this:
    Supplier ratio = 1 ÷ order quantity
  2. Open Paladin Point of Sale.
  3. On the top ribbon, click the Inventory module.
  4. On the Inventory tab, enter the Part # that you want to edit, and then recall it.
  5. Click the Order Control tab.
  6. In the Stock Information pane, in the Order Qty box, enter the order quantity, and then click the lock icon to prevent further changes.
  7. In the Suppliers pane, in the Sup. Ratio box, enter the supplier ratio, and then click the lock icon to prevent further changes.
  8. Click the Pricing tab.
  9. In the Item Cost pane, for the item unit that you sell, enter the Avg Cost and the Mkt Cost. Paladin Point of Sale will use the supplier ratio to calculate the equivalent cost for one supplier unit.
  10. In the Pricing Levels pane, on line 1, do the following:
    • In the Quantity column, enter the smallest size/quantity sold in the store, which is typically by the “each”.
    • In the Sales Price column, enter the retail price for the smallest size/quantity. 
  11. To sell a larger quantity for a reduced price (quantity price break), in line 2, in the Quantity column, enter the quantity, and in the Sale Price column, enter the quantity sale price. For additional quantity discounts, use lines 3 and 4.
  12. For each quantity price break that you entered in the Ref column, enter the reference margin for the quantity break level.  Typically, the reference margin will be equal to the amount in the Margin column or Mkt Margin column.

    Note:  If you do not enter the reference margins, this message will appear:  Supplier ratio settings are incomplete.  To add the reference margins, click OK, and then enter the amounts.  To move forward without adding margins, click Cancel.

  13. Depending on the store type, do one of the following:
    • Single-store: Make sure the Pricing Levels pane is NOT locked (padlock is open). In single-stores, if the Pricing Levels pane is locked, EDI and manual receiving processes cannot apply the reference margin or update the retail price.
    • Multi-store: Make sure the Pricing Levels pane is locked (padlock is closed). In multi-stores, the reference margin is only applied if the Pricing Levels padlock is closed (locked).
  14. Click Save.

 

If you have questions or suggestions about this information, contact support@paladinpos.com.

*Content is subject to change. For the most recent version, visit the Help Portal.
Printed on: 9/22/19