1. False order warehouse is in a big tray, a commodity (sku) on the big tray, warehouse 1 -- & gt; N a big tray, tray 1 -- & gt; N,
2. Now taking something from a database, fill in the outbound order, N on the outbound order goods,
3. Which tray to evaluate the highest rate
For example:
Warehouse W1 with one, two, three, four, five, six, seven, eight tray
Tray A commodity: A: B: 20 to 30 C 50
Tray two items: A: B: 30 to 60 C 10
Tray 3: A: 50 B: 10 to 50 C
Tray four items: A: 3 B: 60 C 100
Outbound application requirements:
A: 20 B: 30 to 60 C:
SQL how to calculate the 1234 outbound order fill rate, rate of tray meet how to calculate, how to calculate the optimal tray (outbound order fill rate * tray fill rate), thank you!
CodePudding user response:
Meet the rate how to calculate? Is to use commodity/inventory that meet rate?