I do not understand your data.
You say the calculation for Frank's team should be (3+6+7)/(1+3+2.5) but Franks team does not have any hours value of 2.5, did you mean 2?
Every row except row 3 has a value for shipped per hour equal to volume shipped divided by hours worked... Is there some reason for that different value?

Assuming the above are just typos, a simple pivot table with either a calculated field of volume shipped / hrs worked or an extra column in the data with the same calculation seemed to work ok in a pivot table.

regards