Maximum Consumption for Material "Y" over Any 30-Day Period

Hello Experts,

This is my first of (I'm sure of) many posts. My question today is, How do I calculate the max for a specific entity over a set window of time?

In this case, I would like to calculate the maximum consumption/usage of a specific material over any 30-day window inside of the year. The first two points can be taken care of with a MAXIFS, but I don't understand how to have excel evaluate every 30-day instance for each material. Seems doable, I think I am just lacking the knowledge. Any advice would be appreciated!

A small sheet with sample data should be attached.

Best,
Plenty o' Questions