LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
calculation problem Suleman[_2_] Excel Worksheet Functions 3 April 28th 08 04:11 AM
FV Calculation problem bao Excel Worksheet Functions 1 October 31st 06 04:19 AM
Calculation Problem slwaite Excel Discussion (Misc queries) 1 July 18th 06 07:31 PM
Calculation problem - please help Neil Hindry Excel Discussion (Misc queries) 2 July 10th 06 02:38 PM
Calculation Problem cvolkert Excel Discussion (Misc queries) 0 August 22nd 05 06:14 PM


All times are GMT +1. The time now is 08:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"