Backlog and Lead times

Hi,

I need to calculate a backlog for per product per day.

I have a module with Factory open days and closed days and a module with lead times by product.

Volume gets sent to production (factory) and then I need to take a lead time calc for the products.

The trick is that to work out how many future days in a row the factory is open (these can change depending if the factory open boolean is ticked) to see when the product will get produced and by equal to or more than the lead times.

E.g: the factory could be open Monday Thursday Friday. If the volume came in on Monday (with a 3 day lead time) then the backlog would get recognised on the Friday. The lead times and the factory open days can differ. Also the lead times can cross over days, weeks, months and years.

I have booleans for open days per factory and a count for the days open.

I also have lead times by month by product.

Hope this enough information?

Adrian

Accepted answers

All comments

nathan_rudman

the core solution is to use movingsum(value,1,lead time), which will give you your open days from that date.

CommunityMember113241

Hi Nathan,

I need to get the amount of days open in the factory from the date. I then need to force the value into the day that is on the (in this case 3 days) counting all the days that the factory is open.

Best Regards

Adrian

nathan_rudman

in that case it will be movingsum(value, -1,-lead time)

or maybe 0 instead of -1 depends if you want to include the current day from the count

CommunityMember113241

Hi Nathan,

It is a bit more complicated than moving sum due to the calculation being in the future days and time span can be variable, depending on when the factory is open and closed. (Mon could be closed then Tue open then wed closed, Thu open, Fri open) this would make a 5 day lead time not 3. The closure could be all week, then closed for 2 days etc etc.

Adrian

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…