Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
calculation problem | Excel Worksheet Functions | |||
FV Calculation problem | Excel Worksheet Functions | |||
Calculation Problem | Excel Discussion (Misc queries) | |||
Calculation problem - please help | Excel Discussion (Misc queries) | |||
Calculation Problem | Excel Discussion (Misc queries) |