Distributing Cost

Hi Everyone,

I need help with the attached a spreadsheet where I am trying to distribute the daily cost of each employee depending on the amount of hours they worked each day in columns V through AB. However I have a balance left over for each employee. For the 1st employee I have a balance of $168.75 and for the 2nd employee I have a balance of $94.50 left over. The formulas in columns V through AB don't seem to be correct. Can someone please help me? Thanks.