An order of 100g should adhere to the initial shipping rule, which is set for a range of 0-100g. It will never meet the criteria for the 110-240g rule.
Additionally, I suggest configuring the shipping rule without any gaps in the range. With the current arrangement, no shipping cost will be provided for orders weighing between 101g and 109g.
No matter what I do products under 100g are consistently failing to meet the criteria of my 0-100g shipping rule, significantly affecting sales. Customers find the shipping costs too high for lighter items.