opencost icon indicating copy to clipboard operation
opencost copied to clipboard

Net Amortized Costs

Open kirbsauce opened this issue 3 years ago • 11 comments

This feature request is to add net amortized costs calculations.

Net amortized costs adds logic to amortize discount-related information, in addition to savings plans or reservation-related charges. For example, it amortizes the upfront and monthly reservation fees while including discounts such as RI volume discounts.

gz#848

(related to Zendesk ticket #878)
gz#878

kirbsauce avatar Sep 28 '21 15:09 kirbsauce

@AjayTripathy would you be able to comment? I know you have a lot of expertise + wrote some documentation.

dwbrown2 avatar Sep 29 '21 21:09 dwbrown2

Yep! This was a customer request that seems pretty reasonable. Net unblended costs are incompatible with our model but this is relatively simple. We'll get this prioritized and done.. cc'ing @Sean-Holcomb who is refactoring some things here in our Assets schema to make this stuff simple.

AjayTripathy avatar Oct 01 '21 15:10 AjayTripathy

goal: net amortized cost which includes also the EDP discount

in use:

line_item_unblended_cost
savings_plan_savings_plan_effective_cost
reservation_effective_cost

need to use:

line_item_net_unblended_cost
savings_plan_net_savings_plan_effective_cost
reservation_net_effective_cost

kbrwn avatar Oct 05 '21 21:10 kbrwn

I have a comment about it. Starting 1/10/2021, I have a new EDP plan with full upfront. Apparently, AWS has limitation that in this specific case, they use a manual mode for discount to update the billing and I just learned they pulled out the net fields from my schema. AWS told me they plan to fix it also for this scenario. As such, I suggest that you will have a checkbox in your setting indicating if to apply the net fields or not. If you do that, your customers can select if they need to take into consideration the net fields or not and then you can support all cases.

dhoffman3 avatar Oct 13 '21 21:10 dhoffman3

This may be helpful for those that want to better understand the difference between amortized and net amortized. See the section "Net amortized costs" on this AWS doc page.

srpomeroy avatar Oct 21 '21 16:10 srpomeroy

Adding my comment from the ZD ticket here

As far as I can tell

line_item_net_unblended_cost
savings_plan_net_savings_plan_effective_cost
reservation_net_effective_cost

Are not real columns in the CUR, they do not exist in our CUR and they are not in any of the documentation. See the section "Net amortized costs" on this AWS doc page.

This page refers to an option in the Cost Explorer in the AWS console. The documentation for what is available in the CUR

It is still unclear to me if the available information in the CUR can create the desired values

Sean-Holcomb avatar Jan 06 '22 19:01 Sean-Holcomb

Revisited the CUR documentation today and saw that they have added the required "net" columns to implement this function. My proposal is to use these columns for pricing when they are available.

Sean-Holcomb avatar Feb 14 '22 17:02 Sean-Holcomb

Have we implemented, or are there any plans to implement the use of the net amortized costs?

srpomeroy avatar Aug 15 '22 14:08 srpomeroy

@Sean-Holcomb Could you confirm we have not implemented this yet ?@srpomeroy, if we have not, there is no current plans to add this. However, if you feel strongly about it please let me know.

Adam-Stack-PM avatar Aug 16 '22 20:08 Adam-Stack-PM

We have not implemented it

Sean-Holcomb avatar Aug 16 '22 22:08 Sean-Holcomb

Candidate for v1.98?

AjayTripathy avatar Aug 20 '22 00:08 AjayTripathy

Curious if this got implemented. I recently had another user mention this.

keithhand avatar Dec 29 '22 20:12 keithhand

https://github.com/kubecost/cost-analyzer-helm-chart/issues/1869 Let's move tracking here. This is sort-of beyond the scope of opencost.

AjayTripathy avatar Jan 04 '23 20:01 AjayTripathy