Calcuations based on string pattern

I have a file that contains average user review on various products. The goal is to combine rows with similar products based on Model Number column and calculate the weighted scores in a new sheet. I've attached the file.

Example:
I want to combine and do a weighted score on the Model Number that begins with SDAD or GES. Based on the file, there are two rows with the pattern SDAD and GES.

If you do the calculations manually:
For SDAD calculation, (10 x 4) + (3 x 5) = 55/15 = 3.6
For GES calculation, it's just (5 x 3) = 15/3 = 5

I want to run a macro where it creates a new sheet in the same workbook and in the new sheet display something similar to the below. if I get a template, I can add more patterns in there. Thank you!

SDAD Total Weight Score = 3.6
GES Total weight Score = 5