Jump to content
DeX

Need advice on building BOM with many attributes for each product

Recommended Posts

I have a Bill Of Materials (BOM) and we buy a building product from a third party supplier that custom makes them for us. They charge us a certain price based on these factors of the product:

- width of building (in static increments: 24, 30, 36, 42, 44, 50...)

- building type it's being used in (each type requires certain design specifications to meet code requirements)

- snow load (depending on where in the country the building will be, we need to make it more durable if there will be a higher snow load on the building)

Based on all of these, they build the product for us and charge us accordingly. I'm wondering if I need to have 400 items in my BOM to account for each combination of length, building type and snow load for this one product. Is this normal practice? The price differences don't have a pattern and don't overlap in any way, it's random pricing set for each combination. It's not like the price goes up $30 for each length, the pricing gaps are all different for each setting.

Share this post


Link to post
Share on other sites

Only 400. That is quite a small table.

Share this post


Link to post
Share on other sites

There are only 400 items total in the products table, plus however many of these items there are.

Share this post


Link to post
Share on other sites
Posted (edited)

Without knowing exactly how a final price is calculated it is impossible to say what you need. It all depends on the rules, what combinations of factors come into play in different circumstances.

You need to thoroughly analyse the data, data relationships and processes to arrive a a data model that works, then implement it.

Edited by Barand

Share this post


Link to post
Share on other sites

Every item has a corresponding quantity calculation that's input manually by the developer, this calculation never changes. Then when a final price for the building is needed, it does the following:

- get all product ID from the database

- loop through all product ID quantity calculations and multiply this quantity by the price in the database (price updated once a month)

- adding all these totals together and multiplying by a markup percentage gives us our final price

Is that allĀ  you needed?

Share this post


Link to post
Share on other sites

I don't need anything, you do.

A thorough analysis exercise takes days, if not weeks. Certainly more work than you are going to get for free in a help forum and from those who don't have access to the detailed infomration required, such as all the quantity calculations

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.