I am working on a cash flow project for building a plant. I know the cost of
the various segments of the plant rounded to the nearest M. I need to show a
cash flow projection for each segment of the plant construction by month. I
am using a percent by month for the allocation for each different segment.
The monthly allocation is rounded to the nearest M also. The problem I am
having is that the monthly allocation for each segment does not always add up
to the total because of the rounding. How can I put in the last month
allocation formula a process that would, account for the difference between
the monthly allocation and the total being allocated, and then either add or
subtract that differnce to the last months allocated amount.