How to create a total of weekly allocated hours per employee

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.