How To Allocating Rent Between Two Categories?

  • Thread starter Thread starter Han
  • Start date Start date
H

Han

Original Question:

[The part I need help with is that the amount in column G has to be
allocated to the following accounts in this order
Gas, Hydro, Promo
FC CAM
Mkt CAM
Base
% Rent

I'm just working on allocating the last two, so I'm assuming that
there is rent remaining to be allocated from column G after allocating
to Gas, Hydro, Promo, FC CAM and Mkt CAM.

The remaining balance has to be allocated first to base rent than to %
rent on a monthly basis. If some rent is allocated to % rent, and the
next months sales are so low that the base rent is fully filled we
need to first reduce % rent until it is 0 before reducing the base
rent.

Feel free to make what ever changes to the spreadsheet as necessary to
make it work.]

My Question:
I have done something to the question above. but what i have done is
allocated first to base rent than to % rent on a yearly basis, not on
monthly basis as required. for example, The eighth month's Base Rent
and %Rent should be 91.08 and -219.04, not 662.08 and (790.04) as my
formular calculated.I would appreciated if you could help me?

Thanks!
 
I would like to send you the spreadsheet to understand my question if
you leave your email address?

Thank you help in advance!
 
Base Rent:

=IF(AND(N17<SUM(Q17:W17),SUM($O$16:O16)<AG17,SUM($P$16:P16)>0),$Y
$4,IF(AND(SUM($P$16:P16)<$Y$4,SUM($P$16:P16)>0),SUM($P
$16:P16),IF(SUM($O$16:O16)<AG17,MIN(AG17-SUM($O$16:O16),IF(SUM($P
$16:P16)<0,N17-SUM(Q17:W17)+SUM($P$16:P16),N17-SUM(Q17:W17))))))

% Rent:

=IF(O17+SUM(Q17:W17)>AG17,0,N17-O17-SUM(Q17:W17))



I would like to send you the spreadsheet to understand my question if
you leave your email address?

Thank you help in advance!

Original Question:
Click to expand...
[The part I need help with is that the amount in column G has to be
allocated to the following accounts in this order
Gas, Hydro, Promo
FC CAM
Mkt CAM
Base
% Rent
Click to expand...
I'm just working on allocating the last two, so I'm assuming that
there is rent remaining to be allocated from column G after allocating
to Gas, Hydro, Promo, FC CAM and Mkt CAM.
Click to expand...
The remaining balance has to be allocated first to base rent than to %
rent on a monthly basis.  If some rent is allocated to % rent, and the
next months sales are so low that the base rent is fully filled we
need to first reduce % rent until it is 0 before reducing the base
rent.
Click to expand...
Feel free to make what ever changes to the spreadsheet as necessary to
make it work.]
Click to expand...
My Question:
I have done something to the question above. but what i have done is
allocated first to base rent than to % rent on a yearly basis, not on
monthly basis as required. for example, The eighth month's Base Rent
and %Rent should be  91.08 and -219.04, not  662.08 and (790.04) asmy
formular calculated.I would appreciated if you could help me?
Click to expand...
Thanks!- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...
 
Back
Top