It was requested of me to build a report that calculates the current cost of a specific product.
Let's call this product. Product A. Product A is the Father Product in this case.
Product A consists of two components, Product B & C. The quantity required of each component
to produce Product A is shown in the Qty field. The cost per unit of each component is shown in Unit Cost field.
|F00014829||Product A||HZA000991||Product B||29.44|
|F00014829||Product A||PZA00095||Product C||1.00||56.27|
The issue I am having is that Product B is a Father Product on its own as well. There is a number of components required to produce Product B.
|HZA000991||Product B||R00025457||Component B1||0.00||691.12|
|HZA000991||Product B||R00027720||Component B2||0.19||32.59|
|HZA000991||Product B||R00032427||Component B3||0.42||9.23|
|HZA000991||Product B||R00033164||Component B4||0.08||33.84|
|HZA000991||Product B||R00034256||Component B5||0.15||4.99|
|HZA000991||Product B||R00036131||Component B6||0.05||42.08|
|HZA000991||Product B||R00039869||Component B7||0.00||233.78|
|HZA000991||Product B||R00056138||Component B8||0.10||39.00|
|HZA000991||Product B||R00084788||Component B9||0.00||76.69|
|HZA000991||Product B||R00098034||Component B10||0.00||67.46|
|HZA000991||Product B||R01038421||Component B11||0.00||170.63|
What I want at the end is to select Product A. Qlikview should then calculate how much it will cost to produce Product A. Qlikview should automatically calculate how much it will cost to produce one unit of product B. This cost of product B should then be added to the Product B (as a component of Product A).
The total cost of one unit of product A should be 660.65. This is the correct answer.
Please find attached excel sheet. This excel sheet is an extract of the database we are using. I think the hierarchy function should be use in some way, but I am not sure how.
BOM Cost.xls 23.5 K