Warehouse Logistics Optimization

Problem: Containers are shipped with low volume utilization because manual packing by a partner in China is sub-optimal. Additionally, when the requested item is not available, planned substitutes are not placed because of manual re-planning complexity, which significantly decreases utilization even further.
Input: Table of shipping items with dimensions and weight, Item availability spreadsheet, urgency priority for every item, minimum batch size, pallet and container loading template projects in HyperC, accounting tables to be recalculated.
Output: Pallet loading scheme table, accounting report.