Split Distribution line automatically based on Deliver to Location

Summary: Split Distribution line automatically based on Deliver to Location

Content (required):

We need to split the distribution for a given requisition line into multiple ones with varying percentage. Lets say that Business is requesting for painting the entire building. This building as multiple departments on different floors as shown below

Dep1 on Floor 1, 2 and 3

Dep2 on Floor 4 and 5

Dep3 on Floor 6

Business have a lookup of Building name with percentage split assigned against each department when such activity are being carried out and will be charged accordingly. Refer to screenshot.

How can we achieve it automatically?

Version (include the version you are using, if applicable): 22C