The quantity of the non-grower(s) is divided between the designated growers using the following formula:
Total quantity for each grower for each split line item divided by overall total quantity for all growers for the line item = that grower's percentage. The non-grower's total quantity for that line item is then multiplied by each grower's percentage and added to the quantity for that grower.
For example:
Split invoice for total of 10,000 lbs of Dap
Customer A's split is 60% or 6,000 lbs
Customer B's split is 20% or 2,000 lbs
Customer C's split is 20% or 2,000 lbs
Customer A and B are designated growers
6000 / 8000 = 75% 2000 X 75% = 1500 lbs so Customer A's total quantity on the report
would be 6000 + 1500 for a total of 7500 lbs
2000 / 8000 = 25% 2000 x 25% = 500 lbs so Customer B's total quantity on the report
would be 2000 + 500 for a total of 2500 lbs
