Excel formula macro and solve expert

Job ID: 36066666

Budget: $20 – $30 NZD

help create inventory allocation formula/macro/solve on excel based on my existing tables and dataset.
there is 2 existing tables.
1. shipment table that shows the goods arriving by arrival port and date.
2. the customer list that shows the allocation ratio. and distribution port.
this is the information that would need to be compiled to give the required result in the final table.