Use the Per column to accurately price commodities like wire, cable, and conduit by unit of measure — ensuring your extended sell prices calculate correctly based on how the product is sold.
Note: The Per column also works within kit components. Each component's cost sums together automatically and appears as the kit unit cost. |
Step 1: Add Correct Columns
In the Pricing & Lead Time tab, click the manage columns icon.
Make sure the following columns are selected:
Cost
Margin (if applicable)
Sell Price
Per
Selling UOM
Selling UOM Conversion Factor (if applicable - covered in Step 3)
Extended Sell Price (to see the calculation)
Tip: Drag and drop column headers using the six dots to the left to reposition  |
Step 2: Set the 'Per' Value
The Per value tells Parspec how many units are included in the Unit Price. This is commonly used for commodity items where pricing may be provided per each, per 100, or per 1,000 units.
In the Per column, double-click the cell and select the unit that matches how the item is priced:
1 = price is per each
100 C = price is per 100 units
1,000 M = price is per 1,000 units
You can also enter a custom value if needed.
Example: If wire has a Unit Price of $500 per 1,000 feet, select 1,000 M. If the customer needs 250 feet (quanity value), Parspec calculates:
$500 × 250 (qty) ÷ 1,000 = $125 Sell Price
Parspec uses the Per value to automatically calculate the extended Sell Price based on the quantity entered:
Sell Price = (Unit Price × Quantity) ÷ Per
This makes it clear that “Per” isn’t a conversion factor—it simply tells Parspec what quantity the entered price represents.
Tip: Use the bulk edit (✎) feature to mass assign the same unit of measure across multiple line items at once.
Step 3: Set the Selling UOM Conversion Factor (If Applicable)
The Selling UOM Conversion Factor tells Parspec how the entered quantity should be converted before calculating the Extended Sell Price.
For most items, use a conversion factor of 1. A value of 1 means there is a 1:1 relationship, so no conversion is made to the quantity.
Example: Imagine you are quoting wire that is sold by the foot, but each quantity entered represents a 10-foot length of wire. Your customer needs 250 of those 10-foot lengths.
In Parspec, you would enter:
Quantity: 250
Sell Price: $500
Per: 1,000
Selling UOM: FEET
Selling UOM Conversion Factor: 10
The 10 is used because each quantity of 1 represents 10 feet. Parspec first converts the quantity:
250 × 10 = 2,500 feet
The Sell Price is $500 per 1,000 feet, so Parspec then calculates:
($500 × 2,500) ÷ 1,000 = $1,250 Extended Sell Price
Therefore, the customer is being quoted $1,250 for 2,500 feet of wire
Tip: Think of the Selling UOM Conversion Factor as answering the question: “How many of my Selling UOM does one quantity represent?” If 1 quantity = 1 foot, enter 1. If 1 quantity = 10 feet, enter 10.
Tip: Use 1 when no quantity conversion is needed. Change the Selling UOM Conversion Factor only when the entered quantity represents a different amount of the Selling UOM.
Step 4: Display the UoM on your Quote
Once the Selling UOM and pricing values are set, you can display the unit of measure on the customer-facing quote.
Click Create Quote from the Pricing & Lead Time tab.
In the Pricing & Lead Time section of the quote customization screen, turn on:
Unit Price – displays the calculated price per selling unit.
Show Selling UOM – displays the Selling UOM entered on the BOM (for example, FEET).
Preview your quote to confirm the Unit Price and Selling UOM appear correctly before generating the final document.
Example: If your Selling UOM is FEET, the quote will show the calculated Unit Price along with FEET, helping the customer understand that the displayed pricing is based on feet rather than individual units.
Note: The Per value and Selling UOM Conversion Factor are used behind the scenes to calculate the correct pricing. The Selling UOM is what identifies the unit being sold on the customer-facing quote.
Need help? Visit the Parspec Training Academy or use the in-app support chat.