About D0nmac

D0nmac · ‎10-31-2019

Thats exactly what it was, I've made that change and its working as you discribed. Thanks a lot Arun

D0nmac · ‎10-30-2019

@ArunManickam I've been trying what you said but I'm getting a lookup issue with a data mismatch, Data type mismatch: format other than LIST or DATE being referenced as a relation so I think I may have misunderstood you when I've executed it. I've created a numbered list for the items I have, 1-106. I've then created a module and imported a unique reference 1-106, products, components and percentages. then when I goto do my lookup referencing back to the model I get teh above error. am i doing the correct thing or should the numbered list contain all of the propertys we are using. Thanks again David

D0nmac · ‎10-30-2019

Thanks @ArunManickam I'll try that today and let you know how I get on but it looks exactly what I'm trying to do

D0nmac · ‎10-29-2019

Thanks for that, I've attached a sample spreadsheet with a rough layout of what I'm trying to achieve. My main issue is that we need the SKU total from the calculation but the formula is assigned to a level or 2 up. Also in our live data we have multiple SKUs rolling into the same product hierarchy with the same formula. If I make my hierarchy unique for the formula layer which I need to do to get the formula onto Anaplan, I don't then have the hierarchy to roll up. I was thinking of creating a module with a unique reference for each recipe, but have a hierarchy component part in it e.g. unique1, product1, unique2, product1 with a list for the unique code and then create a module using this and time then use the lookup to get the Product total and then the correct percentage for my calculation. does this sound correct or am I wasting my time? Thanks again David

D0nmac · ‎10-29-2019

Hi folks, I was wondering if you might be able to help point me in the right direction as I seem to have hit a wall. I am building a model which appears to have a linear hierarchy SKU-> Product -> product Family and this is working as expected. However in part of the model I need to work out component requirements in which we currently take the monthly figure then multiply it by a percentage per component. The problem I'm having is that to be able to do this I feel I need to change my hierarchy but as soon as I do that the levels below can't map he current level and I need the figures from the existing hierarchy to get my solution. e.g. Jan 10,000 is made up of part A 60% and part B 40% I want to be able to show that at product family level we need 6000 Part A and 4000 Part B I'm just a bit stumped and I'm looking for possible suggestions that might get me moving on it. Thanbks David

D0nmac · ‎08-21-2019

That's great thanks for your help. I'll give it a try today 🙂

D0nmac · ‎08-20-2019

@ArunManickam Thanks a lot for the suggestion, I was thinking something along the same lines I just didn't know if I would have needed a special calculation to work out when the item came of age. would the same calculation work if the time frame was months instead of Days e.g. 12, 24,36... Thanks D0nmac

D0nmac · ‎08-20-2019

Hi Everyone, i’m hoping you might be able to help me, I’m looking to build a model which takes an inventory with a start date and then shows when it comes of age e.g. beef that needs hung for 28 days, or wine that needs stored for a couple of years. I’d know the current demand but I’m not sure how Or if I can get the supply figure for something that needs to get aged for 24 months. Any ideas or suggestions would be appreciated. thanks in advance D0nmac 🙂

About D0nmac

Re: Hierarchy and Demand planning(like MRP)

Re: Hierarchy and Demand planning(like MRP)

Re: Hierarchy and Demand planning(like MRP)

Re: Hierarchy and Demand planning(like MRP)

Hierarchy and Demand planning(like MRP)

Re: Question on Maturing inventory

Re: Question on Maturing inventory

Question on Maturing inventory

Re: Hierarchy and Demand planning(like MRP)

Re: Hierarchy and Demand planning(like MRP)