Automatically calculate list price of a product kit / bundle BOM

tom.richter

Please add a feature where the system will automatically calculate the list price of a new product bundle (assembly BOM) based on the pricing of the individual line items. 

We often create "kits" of individual products to simplify the sales process when working with more complex products. When creating the kits, we currently have to manually calculate the cost of the items that make up the kit and then input it. This can be time consuming when all of the info is already in the system. 

1

Comments

1 comment

Date Votes
  • Comment author
    Nicolas Noakes
    • Edited

    This is an optimization that is really needed, especially where you have many bundles based off the same basic components. Each time the price for one basic component changes, You have to identify all the kit/bundle prices that need be updated as well. Practically, this ends up with the business maintaining the majority of their prices in Excel, completely negating the advantages of a “system”.

    To solve this very issue, we have implemented our own pricing system which is connected via the API to calculate markup prices and assembly BOM prices.

    For the Cin7 implementation, I would add an additional option under the “Use” column on the product Pricing screen for this feature: Average cost, Fixed price, Latest price, Price tier value, Sum of components.

    I would also propose a third option in the “Type” column for Discount instead of Markup and Append.

    To use the feature:

    • Check the “Calculated" box for a price tier
    • Set “Use” to Sum of components
    • Optionally set “Type” to Discount and enter a value in the “Value” column. This would allow you to apply a small discount to a bundle.

    How it would work:

    • Cin7 would sum the price for all components (multiplied by quantity in the BOM, divided by quantity to produce for the BOM) using the Price value from the equivalent price tier for each component. (i.e. If you used “Sum of components” in Price Tier 3 for a kit, then it would add the prices from Price Tier 3 of the components.)
    • Cin7 would apply the Markup / Discount percentage to the total

    Caveats:

    • You need a way to flag or identify a BOM where a component is missing a price entirely. This is to avoid pricing a kit or bundle at a price that is unintentionally missing the price of one component. In our implementation, we abort the calculation if any component does not have a price, meaning that the kit has zero price - then you can investigate.

     

    0

Please sign in to leave a comment.