Manoir Budget Account revamped!

This is the latest for who's coming...
The total adults 27
children 11
Roomhire £350 divided by 27 adults works out at £13pp. Therefore food is £62.50pp + £13pp=£75.50pp(adult)
Children=£20 for meal



Family and friends..................paid.................to pay.......in credit
Steve Gem,Will Clive..............£250.................£52....................
Hugh, Margaret.......................125...................26....................
Graham, Josie............................60...................91...................
Dororothy.................................30...................45.50...............
Pam..........................................30...................45.50...............
Tina..........................................30.......................................£30
Fay...........................................30....................45.50................
Cathy,Edmund,Thomas,Kate....100...................35.50...............
Nic,Jen-Hwe, Claire, Daniel......250.....................................£59
Julian, Ruth...............................60....................91................
Pete,Jan,Jess,Beth,Amy.............481.99...........................£270.99
Valerie,Neil,Georgie, Jamie......120....................71......................
Mandy, John H..........................60....................91......................
Steve & Elaine Holt....................60....................91......................
David & Cara.............................60....................91......................
Nikki & Freya..............................0....................95.50.................

Suggest that being as Nikki and Freya are now going to join us that we fully reimburse Tina.
It would probably be easier if we collect the above outstanding from everyone before the 13th and then split the drinks bill between the adults ie 27. Think this would make it much simpler for all on the day.

Sorry this doesn't line up but as Dad knows it's a b*gger!