Expense Reimbursement Calculation Assistance

Job ID: 39308703

Budget: $10 – $30 USD

I need help calculating and splitting expenses fairly among 5 entities based on their spending. The calculations are primarily percentage splits influenced by the amount spent by each entity. Ultimately, I would like the results displayed as summarized percentages.
Related categories: Accounting Excel Finance Business Analysis