View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tartan tim tartan tim is offline
external usenet poster
 
Posts: 7
Default Multiple calculation problem

I am secretary to a society. We have 10,580 members. There are 4 categories
of membership. Each category of member pays a different annual fee to cover
annual expenses. Annual expenses are £2,500,000. There is a base fee and this
is calculated by dividing member numbers into budget so this is £2,500,000
divided by 10,580 = £236. 500 members pay the base fee.

The other categories pay the balance of the expenses. One group pay a top
fee - there are 7000 in this group. Another group pays one half of the top
fee there are 1500 in this group. The last group with 1,580 members pay one
third of the top fee.

How do I calculate what the top fee should be? Bear in mind that annual
expenses can change and membership numbers in each category can vary year to
year.