This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Do you use Alteryx in a language other than English? If so, we want to hear from you! Please help us improve the international experience of our products by participating in this 5 minute survey.
We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.
To be honest, I don't have a sample output. I just look at hundreds of families and schedule one by on, consuming capacity forward and backwards, but not going over requirements with good ol' fashioned excel.
The end game is to schedule 18 months while trying to get as close to 3899 but staying under each month's capacity limit.
Total 18 Month Requirement Total 18 Month Capacity
I think I managed to achieve the backward balance you are looking for.
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.