We manually allocate products from boxes to branches, but it's time-consuming. Each box has a unique ID, product type, and quantity, while each branch has specific product requirements. The challenge is that required amounts often don’t match box quantities—sometimes a single box is enough, sometimes multiple are needed, and sometimes boxes must be split.
We need an automated Excel solution (formulas, Power Query, VBA, or other tools) to:
We need an automated Excel solution (formulas, Power Query, VBA, or other tools) to:
- Assign whole boxes or split them as needed to fulfill branch demands.
- Indicate whether each branch's requirement is fully met.
- Track remaining product quantities in each box.