Value allocation by Milestone and Month

I have a financial forecasting scenario where I need to allocate a cost (let’s say $100,000) across 4 milestones where each milestone has a % allocated (40%, 50%, and 10%). I want to identify the values by milestone and by month.

It gets complicated when I have multiple rows, with varying values and dates starting and ending mid-month.

Input:

Project | Value | Date1 | Date2 | Date3 | Date4

A | $100,000 | Jan 4, 2023 | Mar 5, 2023 | Mar 5, 2023 | June 2, 2023

B | $50,000 | Feb 4, 2023 | Mar 30, 2023 | Jun 5, 2023 | Feb 2, 2024

Output:

Project | Milestone | Value | Jan 2023 | Feb 2023 | Mar 2023 | Apr 2023 | May 2023 | Jun 2023 | Jul 2023 | Aug 2023 | Sep 2023 | Oct 2023 | Nov 2023 | Dec 2023

Output Notes:

• Output date range (Jan 2023 to Dec 2023) is user defined

• 3 rows for each project as a result of 4 milestones (potential to increase to more milestones)

I was able to do this in Knime, however the workflow is very complex. I am hopeful the Knime Community can identify a simply solution, or create a node in a future update.