Hi.
I have searched the community for days without finding what I need so now I hope for you guys 🙂
In order to deliver on time, we need to start order management no later than seven days after the order date. On the occasion of delays, I need to find out at what time (date or at least week) we are expected to start order processing on the seventh day (order date + 7). My data structure looks like this:
Balance
| Date | Orderdate | Qty | Balance |
| 2019-04-14 | 2019-03-26 | 44 | 44 |
| 2019-04-14 | 2019-03-27 | 766 | 810 |
| 2019-04-14 | 2019-03-28 | 680 | 1 490 |
| 2019-04-14 | 2019-03-29 | 622 | 2 112 |
| 2019-04-14 | 2019-03-30 | 91 | 2 203 |
Production capacity
| Date | Capacity |
| 2019-04-15 | 963 |
| 2019-04-16 | 1 246 |
| 2019-04-17 | 1 246 |
| 2019-04-18 | 1 246 |
| 2019-04-19 | 963 |
Expected new orders
| Orderdate | Qty |
| 2019-04-15 | 1 249 |
| 2019-04-16 | 1 186 |
| 2019-04-17 | 1 186 |
| 2019-04-18 | 1 249 |
| 2019-04-19 | 999 |
I really appreciate all the help I can get.
