How to split monthly volume for two days within one month?

[#1]

Hi

I am trying to build a forecast report for accounts receivables. My sales forecast is only on monthly level and I would need to split that at least to two pieces. What kind of script I would need to write in following scenario:

Original table:

Product code	Sales forecast March
11111	10000
22222	10000
33333	10000

Desired table: 60% in 10th day and 40% in 20th day

Product code	Sales forecast in March 10th	Sales forecast in March 20th
11111	6000	4000
22222	6000	4000
33333	6000	4000

Thanks

Regards

Janne