So in inventory sheet, we have product name and product color columns (and the other optional columns). So we need count each produced product and also count each sold product Then subtract their values.
In your table i suppose the unique identifier for each product is product and color columns combinantion (Note that if you provide a column as ID you can distinguish same products with different colors, but the approach is the same).
