calculating weights

need help on a simple contribution % question. Please find it attached in spreadsheet

Attachment 21606Attachment 21606