North and South each order Basic and Plus kits. You need the number of clips and pads to pack for each destination. Multiply the component recipe by the kit counts.
Align the shared kit labels
Use Basic and Plus as columns in B2:C3. The Clips row is 2, 1 and the Pads row is 1, 3. In F2:G3, put North and South as columns. The Basic row is 6, 10 and the Plus row is 4, 5. Keep the kit order the same in both ranges.

Illustrated inputs. Align the shared kit dimension before multiplying.
Check the upper-left total before using the grid
=MMULT(B2:C3,F2:G3)Leave room for two rows and two columns. For North clips, check 2 × 6 + 1 × 4 = 16. The Clips row should be 16, 25 and the Pads row 18, 25. Keep the labels visible. Switching the kit order on only one side can still yield a number with the wrong meaning.

Illustrated output check. Calculate North clips by hand first.



