IBM Apptio

 View Only

 Catch overallocated $$ from Standard Value Allocation

Jump to  Best Answer
  • CostingStandard(CT-Foundation)
Jaison Joy's profile image
Jaison Joy posted Tue May 18, 2021 01:16 AM
Hi all,

I'm working on a Standard Value Allocation (hyperlinked). My destination has higher $$ than the Source and hence it shows as an overallocation. I would like to catch this $$ and allocate it to Business Services. However, I've been unable to do so till now. I'm already using the "Remainder" checkbox for another allocation line. I'm out of ideas and seek your recommendations.





Thanks,
Jaison Joy
#CostingStandard(CT-Foundation)
Jaison Joy's profile image
Jaison Joy posted Thu May 20, 2021 06:50 PM  Best Answer

Thanks Kelly & Guillermo for your responses.

@Kelly - No, unfortunately we do have to use Standard value allocation since the destination is basically a billing table that has actual invoice amounts.

@Guillermo Cuadrado - Formula would have been ideal. I tried modifying the SOURCE x Destination.Column formula a lot, but couldn't get to it. I finally appended Cost Source (General Ledger) to a Custom object (with a filter), and also appended the invoices table to it. Grouped it on amount, did a pivot, and subtracted both amounts to find the offset amount that I wanted to allocate. I then did another standard value allocation to this new custom object. So earlier my custom tower was over-allocating. Now, it's allocating 100%.


Thanks,
Jaison​​

​​
#CostingStandard(CT-Foundation)
Apptio Community Member's profile image
Apptio Community Member posted Tue May 18, 2021 10:31 AM
Hi Jaison - 
I have never used a Standard Value Allocation before in a model.
In the case of the overallocation I don't believe a remainder would work anyways because the allocation in question wouldn't be seen as a remainder.  It is allocated, just happens to be overallocated, and as such would be viewed differently than a remainder.  I am not sure what the options would be with this type of allocation line.  Do you have options of using a different type of allocation? That could use weighting and Data Relationships?

@Gregory Nutt do you happen to have recommendations on this allocation question?​
#CostingStandard(CT-Foundation)
Guillermo Cuadrado's profile image
Guillermo Cuadrado posted Wed May 19, 2021 04:06 AM

I have been doing some experiments with =LookupObjectTotalAllocated(Cost) in Using=Formula, but no success so far 😒🤷‍♂️😢
Was trying to get something like this:


I was trying to capture the Offset and allocate it to another object. I think that's what you want.

Since in my TBM book over/underallocation is anathema, I would reverse the signs and thus keep 100% top to bottom, no more, no less.

I have done something like this in the past as follows:
1) Build a report that yields the actuals
2) Downloading it to a table via Datalink
3) Calculate the Offset as in the picture above
4) Use that calculated column to allocate the values to the desired object.

Don't have time to prototype this, but maybe it helps you.


#CostingStandard(CT-Foundation)

Related Content