Granularity Issue with fact tables

Hi, so i've got an issue with the granularity between our inventory table and our budget table. The budget table was produced to product and colour level e.g Pink Baselayer. The inventory table goes to sku level e.g RB0001 = Small pink baselayer. 

The issues i have are: Pink baselayer equals multiple styles so Pink Baselayer may = RB0001 and RB0002. 

So when the budget says to expect 50 sales of pink baselayer in November 2022 i need to caculate the expected units for the month. Is there any way i could do this despite the multiple SKUs and sizes?