I suggest that you decide which weeks management wants to look at. Hopefully they will say like "well we usually only look out about 6 weeks.
So make a summary fields on the Employee Record to summarize the allocated hours for the current week. call it [Allocated Hours Current Week]
The filter on the summary will be
where date is during the current week.
The copy the field and called it [Allocated Hours Current Week + 1]
Adjust the summary filters to be where
ALL of
Date is during the next 1 weeks
duplicate to
[Allocation Hours Current Week + 2]
Adjust the summary filters to be where
ALL of
Date is during the next 2 weeks
Date is
not during the next 1 week
and keep going so the +3 will be
Adjust the summary filters to be where
ALL of
Date is during the next 3 weeks
Date is
not during the next 2 weeks
The you can make a report when any of those say 6 summary fields is > 50 hours or whatever the threshold of concern is.
If they want more weeks out well, just turn up the music real loud and keep on duplicatin' that Summary field. It's pretty quick once you get the rhythm of the mental pattern going for the field duplication.