Calgarypuck Forums - The Unofficial Calgary Flames Fan Community - View Single Post - Excel Help - allocating a positive number based on positive and negative values.

eddly · 09-08-2014, 09:31 PM

Hi,

I'm trying to complete a monthly expense allocation. The expense allocation is to three regions and it is based on their incurred claims. This is an insurance company so claims would be a cash outflow. I need to allocate an expense amount of 104,000.

Location #1: 700,000
Location #2: 550,000
Location #3: -1,750,000 (claim recovery)

Total of -500,000.

I haven't had a negative number as a total before...

Does anyone have any suggestions as to how to do this? I have spent way too much time on this and have searched google extensively. Any help is much appreciated.

09-08-2014, 09:31 PM	#1
eddly Powerplay Quarterback Join Date: Oct 2002 Location: Calgary Exp:	Excel Help - allocating a positive number based on positive and negative values. Hi, I'm trying to complete a monthly expense allocation. The expense allocation is to three regions and it is based on their incurred claims. This is an insurance company so claims would be a cash outflow. I need to allocate an expense amount of 104,000. Location #1: 700,000 Location #2: 550,000 Location #3: -1,750,000 (claim recovery) Total of -500,000. I haven't had a negative number as a total before... Does anyone have any suggestions as to how to do this? I have spent way too much time on this and have searched google extensively. Any help is much appreciated. __________________