Hello
I’m currently working on a Production Planning base, which is essentially a way for us to communicate with factories on the projected production they can expect from us for the forthcoming months. Currently there are two sets of data:
- Projected Units
- Quantity attached to a “Launch” or a “Deal”.
- Confirmed Units.
- Quantity of confirmed units which have Purchase Orders attached
As an example, we have a deal across “P6 & P7” (period/phase) with a customer and projected around 500k units. The problem is that the factory is not going to produce all 500k units at the same time and this deal stretches over a period of time - which based on the customers sales calendar is Feb-Mar-Apr. That is their sales window, so we need to work backwards around 10 weeks for shipping and then an additional 30 days for production.
I’m currently trying to figure out the best way to disperse the 500k units realistically across the full period span so we can give the factory an idea of when we expect these units to fall into their production. My problem is they’re attached to a single deal, and I’m not entirely sure the best way to split them out. I’d welcome any suggestions!
