Platform

Platform

A place for Apptio product users to learn, connect, share and grow together.

 View Only
Expand all | Collapse all

How Do You Allocate Cloud Costs?

  • 1.  How Do You Allocate Cloud Costs?

    Posted Wed October 21, 2020 05:00 PM
    Edited by System Admin Tue November 05, 2024 06:03 PM

    We have some line items that come through that are tagged as 'public cloud' based on the vendor name and if there's a Project ID associated, we route it to the Project object; if there's not a Project ID, but there's an App ID via tagging, it goes via the tower objects to the applications (bypasses the Project object). 

    By doing that, though, we're not seeing a lot of the cost that should hit an app.  People expect it to due to the app tagging, but since there's a Project ID, it sees that first, and routes accordingly.

    Therein lies the rub: folks want to see it both ways.  They want to see the expense hitting the apps based on tagging, but then again, we have folks budgeting/forecasting against certain projects, and they want to see that, too.  And we don't want to over-allocate or double-count in these situations, either. 

    How do you handle your cloud expenses?  Inquiring minds want to know...  Dating myself a bit lol...


    #Platform


  • 2.  Re: How Do You Allocate Cloud Costs?

    Posted Thu October 22, 2020 09:18 AM

    (Not in the context of Cloud costs for our model but I'm sure the same idea can apply here)

    We have all project costs going from Towers to Projects and if it also has an App ID it will then go from Projects to Apps. 


    #Platform


  • 3.  Re: How Do You Allocate Cloud Costs?

    Posted Thu October 22, 2020 10:11 AM

    Jenny,

     

    We aren't allocating AWS to projects just yet, but our AWS has one column used for tagging that could either be an application or a project and sometimes the tagging isn't clean, there could be a typo or something. I am having to set up a mapping table of these different taggings to the right applications as new tags get setup. I guess you could build a mapping table of tags to both applications and projects and create 2 allocations lines based on that data. One to applications and one to projects. 

     

    Follow up question. Could you allocate to projects first, then from projects to Applications? I have allocations from projects to the application tower then to applications.


    #Platform


  • 4.  Re: How Do You Allocate Cloud Costs?

    Posted Thu October 22, 2020 06:03 PM

    That's one of our issues.  All tagged apps may not be associated with the project, but they still want to see total project cost and total app cost for AWS.  Not sure how to swing that without double-counting.  May just have to maintain a separate mapping file and associate those tagged apps with the effort.  ¯\_(ツ)_/¯


    #Platform


  • 5.  Re: How Do You Allocate Cloud Costs?

    Posted Fri October 23, 2020 10:12 AM

    I don't know if it is possible to route through projects and have a project called "non-project apps" or something like that, then route to apps. Or maybe you can change the tagging rules to help distinguish between project apps and non-project apps. Just grasping at straws here.


    #Platform


  • 6.  Re: How Do You Allocate Cloud Costs?

    Posted Fri October 23, 2020 10:24 AM

    Very interesting!  May give that a whirl - thank you, @Jason Tucker!!


    #Platform


  • 7.  Re: How Do You Allocate Cloud Costs?

    Posted Thu October 22, 2020 07:01 PM

    I route through projects first and then to applications. I do that with any spend that hits a project. Cost>Projects>Apps. My next iteration, I need to add 2 more hops: Cost>Projects>Neighborhoods>Towns>Applications.

     

    We only use the ITRT for "peanut butter" costs though. So a difference there. The Towers/Sub-towers view doesn't add a lot of value for us. It makes things more confusing because our CIO-1s are referred to as "towers". So any costs that can be aligned by an identifiable direct relationship are aligned and anything that requires an equitable and defensible allocation strategy goes through the ITRT object.

     

    The strategy means to correct bad behavior type items. I.e. if you had tags, or the correct fields in the source, the costs wouldn't be "peanut butter". Also, it provides people a way to see which costs are directly related compared to what's simply being absorbed to achieve a full absorption costing.


    #Platform


  • 8.  Re: How Do You Allocate Cloud Costs?

    Posted Fri October 23, 2020 10:26 AM

    I love strategies that help correct bad behavior!  Going to look into this as well!  Thank you, @Stephanie Geltrude!


    #Platform


  • 9.  Re: How Do You Allocate Cloud Costs?

    Posted Thu October 29, 2020 11:23 AM

    Our model first looks for an application tag in the workload though our coverage isn't very thorough yet.  To bolster that, we recently forced people to assign a default application at the account level.  Untagged workloads are assigned to that default application.  It's not perfect, but it at least puts it in the right pocket rather than having a big pool of unallocated spend that winds up getting spread less scientifically.   We hope that those default app owners will protest and push the other app owners that share the same cloud account to tag their workloads appropriately.  


    #Platform


  • 10.  Re: How Do You Allocate Cloud Costs?

    Posted Thu October 29, 2020 11:47 AM

    This sounds like a great idea, @George McElfresh - thank you! 

    That would take care of a lot of the overhead that's falling out right now, too.


    #Platform


  • 11.  Re: How Do You Allocate Cloud Costs?

    Posted Thu October 29, 2020 11:53 AM

    @Jenny Franklin   As a bonus AWS worked with us to create an api that lets us pull this information straight from them allowing us to avoid worrying about maintaining/loading the table outside of that environment.  


    #Platform


  • 12.  Re: How Do You Allocate Cloud Costs?

    Posted Thu October 29, 2020 12:10 PM


  • 13.  Re: How Do You Allocate Cloud Costs?

    Posted Thu October 29, 2020 12:32 PM

    Yes, @George McElfresh and @Jenny Franklin, we're waiting for tagging to become usable. For now we also have a default allocation at the Cloud tenant level. Works for now. Trying to put together some notes on our method, but awfully busy these days... writing tagging coverage reports :O


    #Platform


  • 14.  RE: How Do You Allocate Cloud Costs?

    Posted Thu March 04, 2021 08:06 PM
    So you want to have your cake and eat it, too? ;-)

    I see fellow colleagues suggested routing costs to Applications via Projects. That's very similar to our approach.

    An issue could arise if the a project receiving Cloud costs is related to more than one application or a different application than what the Cloud expense reflects.

    To ensure the right application is targeted, I recommend creating a duplicated row for the project with additional attribution to take on the expense of the Cloud costs with context of the application. Then, you could properly show the project costs and allocate the application-specific Cloud costs to the Applications object.


  • 15.  RE: How Do You Allocate Cloud Costs?

    Posted Wed September 15, 2021 10:24 AM
    Hi Guys,

    I have a further question at the topic "how do you alocate cloud costs?"

    On the one hand, we have the cloud invoice metrics, which represent the "costs" per cloud service provider based on the consumption, and we have accruals in the general ledger that we use for the respective cloud cost invoice as part of the monthly closing.

    how do you configure the allocation in the model?

    Do you use the cost metric (based at the cost source) and allocate the cloud costs from the cost source to vendor and from vendor to cloud service provider and distribute the costs from the general ledger for each cloud service provider on the basis of the consumption data for the csp object and then allocate this to the it resource tower object , or how do you handle that?

    Kind Regards,
    Niklas


  • 16.  RE: How Do You Allocate Cloud Costs?

    Posted Wed September 15, 2021 11:43 AM
    @Niklas Netz, at my old gig, it was originally set up like this.  





  • 17.  RE: How Do You Allocate Cloud Costs?

    Posted Wed September 15, 2021 12:45 PM
    Edited by Matt Temple Tue November 05, 2024 05:48 PM
    The 'Cloud Service Providers' object should be backed by your Cloud Service Providers' billing data.

    Any Cloud Service Provider (CSP) found in data from Cost Source should be routed through the Vendors object and onto the CSP object weighted by the 'Cost' column (or alternative per your company's needs).

    For example...
    • Cost Source has 3 rows for AWS and 5 rows for Azure.
    • Vendors has 1 row for AWS and 1 row for Azure. Costs allocated into this object are consolidated down to one row for each CSP.
    • CSP has 100 rows for AWS and 333 for Azure. Costs allocated into this object are split and weighted by the 'Cost' column.

    The result of your allocations will likely not match your Cloud Service Providers' invoices due to "accounting noise" (eg accruals, reclasses, invoice receipt timing, invoice payment timing, vendor name affixed via Tablematch, etc).

    You can show a separate "invoice view" based on direct reporting from the CSP billing data. Generally, I avoid doing this when a Cloud operations tool (eg Cloudability, CloudHealth, etc) is present.

    ------------------------------
    Matt Temple
    Advocate
    matt.temple@advocateinsiders.com
    ------------------------------