In Paladin, you can view item costs in different units, such as thousand board feet (MBF), thousand square foot (MSF), tons, and order multiples. This information can be viewed in both the Inventory and PO modules. This feature is especially useful for products that are priced by suppliers in a different unit of measure than how you sell them to your customers. Building materials and feed/grain mixtures are common examples.
For example, lumber is traditionally priced by the supplier in units of a thousand board feet and sold as individual pieces. Similarly, a feed mixture may be purchased by the ton, but sold in small quantities by weight.
With this feature, you can view item cost in the following ways:
- Cost per thousand board feet (MBF) based on the item’s thickness, width and length.
- Cost per thousand square feet (MSF) based on the item’s width and length.
- Cost per ton based on the item’s weight in pounds or ounces.
- Cost per minimum order quantity. This option does not involve any unit conversion. It is particularly useful for items with a supplier ratio or items with an order quantity that is higher than 1
- How to view item inventory costs and prices by MBF, MSF, ton, or order multiple
- View sample scenario and additional details for lumber (MBF)
- View additional details for MSF or Ton
- View additional details for order multiples
- Show prices in MBF, MSF and Ton on invoices
How to view item inventory costs and prices by MBF, MSF, ton, or order multiple
- In Paladin, on the top ribbon, select the Inventory module.
- Pull up the part number, and then click the Pricing tab.
- In the Item Cost pane, in the Cost Per list, select either MBF, MSF, Ton, or OrderMult.
Note: If MBF, MSF, or Ton are selected, the Cost of Lumber Wizard window appears. If you chose Ton as your unit, enter the item’s weight. If you chose MBF or MSF as your unit, enter the item’s dimensions.
- In the Item Cost pane, the PO costs will change and appear based on the unit selected.
- Click F12 Save.
Optional: To show MBF prices on quotes and invoices, in the Pricing Levels pane, check MBF. For more details on this step, see the Show prices in MBF, MSF and Ton on invoices section.
View sample scenario and additional details for lumber (MBF)
Example: A lumber item’s dimensions are 2 inches x 4 inches x 8 feet, and you want to see the item cost in MBF (thousand board feet) units.
To do this:
- In Paladin, from the top ribbon, select the Inventory module.
- pen the lumber item, and open the Pricing tab.
- In the Item Cost pane, select MBF from the Cost Per list.
When you select MBF, the Cost of Lumber Wizard window appears. Enter the dimensions for this lumber item, and then click OK.
- After the wizard closes, new PO numbers appear in the Item Cost pane. These numbers show the item costs for a thousand board feet (MBF).
In this example, the average cost (Avg) of $2 is used to calculate the first PO value of $375 per MBF. Similarly, the market value cost (Mkt) of $3 is used to calculate the second PO value of $562.50 per MBF. The Last box displays the item cost of $1.00 from the most recent purchase order as well as the equivalent MBF cost of $187.50.
Note: To ensure precise PO cost values, calculated numbers are saved at much higher accuracy (more values after the decimal point) than are displayed.
5. To save the MBF calculations, click F12 Save.
Once the MBF costs are saved with the inventory item, both the cost for the item and the equivalent MBF cost will appear when you add this item to a purchase order.
View additional details for MSF or Ton
You can use the same process used in the MBF example to compute costs for thousand square foot (MSF) and Ton units.
In the Cost Per menu, select MSF for thousand square foot
Cost Per Square Foot Wizard
To use the Cost Per Square Foot Wizard, enter a value for each dimension—width and length—in either inches or feet. Values entered in inches are automatically shown in feet. Similarly, values entered in feet are converted to inches.
For example, if you enter a width of 1.5 feet, the wizard displays the width as 18 inches.
Click OK, and the cost per thousand square foot will now show up below the Avg and Mkt costs.
Cost Per Ton Wizard
To use the Cost Per Ton Wizard, enter a value in either ounces or pounds. When you enter one of these weight measures, the other is calculated automatically.
For example, if you enter 8 ounces, the wizard also displays the equivalent value of 0.5 pounds.
Click OK, and the cost per ton will now show up below the Avg and Mkt costs.
View additional details for Order Multiples
Item and OrderMult are additional options, but do not do any unit conversion. This setting is useful for items with a supplier ratio or items with an order qty that is higher than 1.
If you select the OrderMult option, the PO values give you the purchase order cost for the item’s order quantity. The order quantity is found in the Order Qty box on the Order Control tab. In the example below, the order quantity is 100, each item cost is $2, and the calculated PO costs are all $200.
Note: The PO value for the OrderMult option is informational only. Unlike the MBF, MSF and Ton options, this PO value does not appear when you add the item to a purchase order.
Show prices in MBF, MSF and Ton on invoices
This option allows your customers to see the price based on thousand board feet (MBF), thousand square feet (MSF), or ton on invoices and quotes. This feature is useful for products commonly quoted in these units, such as lumber, sand, and gravel.
Note: Invoice quantity and pricing is still calculated using the ‘per piece’ (EACH) price.
To turn on this feature for an inventory item:
in the Inventory module, open the item and then click the Pricing tab.
In the Cost Per: list, select the alternate unit: MBF, MSF, or Ton. Depending on the unit, you will be prompted for item dimensions or weight. An MBF, MSF or Ton checkbox will also appear. Select this checkbox and notice that the Sale Price changes to the alternate unit price that will also appear on invoices and quotes.
Press F12 Save. These items will show the sale price based on MBF, MSF, or Ton on a customer’s invoice.
If you have questions or suggestions about this information, contact firstname.lastname@example.org.