Capacity Scheduling

All,

I schedule 18 months out. Because of capacity, I work backwards, to ensure I only build forward and only build what is needed.

Attached is my flow. I do it by hand and I am trying very hard to automate it.

Required unconstrained starts is what I need for the month given. Family Capacity is the max. Runningtotal is reverse. Saying my Jul 2021 going up so I know my standing by 12 2022.

Any help would be amazing.

Rough Capacity Planning Flow.yxmd

Tips and Tricks

Common Use Cases

Best Practices

Optimization

Predictive Analysis

Time Series

Scheduler

Accepted answers

Jonny

Hi @Matthew_Zollmann ,

there were a couple of holes in the logic when dealing with some scenarios that did not exist on the 1st file you sent, my bad for not anticipating them! these are covered now. I also tried to think harder on some other possible scenarios. this version should be more robust.

let me know if this one works and if you get stuck again just shout! 🙂

cheers!

Jonny

Rough Capacity Planning Flow_Jonny_v2.yxmd

All comments

Matthew_Zollmann

Also, sometimes capacity < requirements. That is the easy one. Just run at full capacity

Jonny

Hi @Matthew_Zollmann ,

I cant runt the workflow as I am missing the input file. Can you export as package or simply attach the Data Input.xlsx file?

nb. to Export as a package: Options > Export Workflow > Save

sounds like an interesting use case!

cheers!

Jonny

Matthew_Zollmann

@Jonny ,

Thanks, this was my first post out of desperation lol.

Just giving input data.

Thanks! Let me know if you need any more info

Data Input.xlsx

Jonny

Hi @Matthew_Zollmann ,

I think I managed to achieve the backward balance you are looking for.

Assumption:

you work backwards as to avoid ending the 18month cycle with excess and making sure that you anticipate production when the plan have future capacity challenges

The logic I built was thinking on Inventory fulfilment. When the aggregate monthly difference is > 0, then that delta becomes my inventory available and the monthly difference when > 0 becomes my requirement. working backwards "fulfilling those orders" until the remaining is zero.

have a look and let me know what you think.

cheers!

Jonny

Rough Capacity Planning Flow_Jonny.yxmd

Matthew_Zollmann

Jonny! Absolutely brilliant. I owe you a beer because you probably just got me a promotion. Solved a 3 week monthly process for a $6B company 🤣

Matthew_Zollmann

@Jonny ,

I don't know what I did. The original file was working but I put a refreshed copy in there and the last month (record 18) is going over capacity. Could you happen to glance at it?

Data Input V3.xlsx

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703