BOM Creation in Anaplan

[dihya.atmani]

Hello Everyone,

在供应链项目中，通常要拥有超过15个级别的BOM。

一个级别可以是父母和孩子。

and for one level, we need to identify all of the parents in order to calculate the quantity to produce.

Clients often provide a file with at least 3 columns, The first one is the compound, the second is the compound and the third is the quantity.

你们中有人成功地将该文件导入了Anaplan吗？

欢迎任何想法

干杯

[sanjeev]

Hi@dihya.atmani

Anaplan支持创建多级BOM。有两种方法可以采用

1. Get a Hierarchy in your input file and use that to build a nested composite list on Anaplan showing the parent-child relationship. These lists will be numbered list as you can have single component as both parent and child and also child in multiple parents.

Pros - this approach makes roll-up of BOM level information very easy as Anaplan does it for you. Traceability all the way down is simple and easy.

Cons - changing the BOM is a challenge as you need to rebuilt the whole hierarchy all over again. And then having the old hierarchy intact for prior months may be difficult to do.

Further, we find that SAP [mostly used ERP in Manufacturing setup] doesn't throw out a multi-level BOM. It just give a single level BOM with Level, Alt Level, Parent, Base Qty, Base UOM, Component, Comp Base Qty, Comp Base UOM, Quantity etc.

2.在Anaplan中建立单个级别的BOM，并使用动作按钮将成本从最低级别提升到最高水平

优点 - 在这种方法中，更改很容易捕获。在整个模型中，在建模方面的努力最小的努力可以轻松地传播一个父子关系变化。

缺点 - 从顶级到底层的宽松可追溯性。在任何时候，您只能获得该级别的材料成本和半固定的商品成本。

My recommendation is to take the 2nd approach as the problem statement gets compounded when you include Recipes as well. With multiple recipe versions and alternate versions, the challenge to manage is very difficult in a single nested BOM in Anaplan.

[DavidSmith]

我过去使用特定模型爆炸BOM层次结构为此创建了一个解决方案。我将我的想法放在文章中并发布。当我这样做时，我会回到这里

David

[nagadeepk]

嗨，大卫，

Did you get a chance to put your thoughts together on this

问候，

Nagadeep k

[DavidSmith]

good news - I've found the time to put this together

Coming soon (as in next week!)

David

[DavidSmith · Accepted solution]

@dihya.atmani

@nagadeepk

@sanjeev

Thank you for your patience!

As you might have expected, the process is complex, so I have written it up in a document rather than a community post.

这是一份涵盖三个领域的综合文件：

• 从顶级到所有子级别的需求级联
• Creating a fully exploded Composite list for All BOM levels
• Created an breakdown of the Assembly for all leaf components

I hope you all find it helpful

干杯

David

[sanjeev]

谢谢@DavidSmith. The document is quite comprehensive and detailed.

I have figured out my own way to create a Hierarchy BOM. And it involves no change in the file structure whatsoever. The only requirement is to have an Action process to run through the BOM creation in an interactive way. I could do a 9 level deep BOM with running the process about 70 odd times. And it took Anaplan less than 15 mins to do so. Once you have built the detailed BOM, you can create a single level BOM out of this hierarchy that shows all the components at the first level as a leaf.

Makes it extremely simple. I will try and put it together in a document or maybe publish an app on the App Store. As it can save time and effort for the whole community. Pls bear with me till I do so

[DavidSmith]

@sanjeev

If you have achieved a solution that works for you, well done

However, we do try and avoid end users running actions , especially multiple times due to the disruption/blocking of multiple users running actions concurrently

As with most things, it depends, and there are often pros and cons or every solution

David

[asnadeem]

Hello David,

I am new to Anaplan, wanted to practice BOMs how do they playout, I have tried creating datasets and but with limited levels, I was wondering if you can also share dataset, (Please disregard if that is a live or confidential data set) so I can hands-on.

问候，

Aslam Nadeem

[Misbah]

@asnadeem

If you scroll up and see the reply from David, he has attached a document which basically will walk you thru the entire BOM explosion. be Patient as it is good an hour or two read.

And hey! David is not longer with Anaplan. So you most probably wouldn't hear from him on this community

Misbah