"To live a creative life, we must lose our fear of being wrong." [Joseph Chilton Pearce]
If you need to reallocate indirect costs or overhead costs to other cost centers, you will face the challenge that the sum of rounded values will not match the rounded sum of these detailed values.
This could ruin your efforts of cost allocations when you enter your calculation into the accounting system of your company because accounting systems deal with cents and all these sums need to match up. But Excel’s © 16 digits won’t help.
How can you solve this? You apply the largest remainder method with the function sbRoundToSum:
[Compare to original cost allocation at a German website]