Effective Savings Rate (AWS Discountable Compute)

	B	C	E
1
2
3	https://www.prosperops.com
4
5	PLEASE MAKE A COPY OF THIS SHEET IN ORDER TO POPULATE
6
7	Formula
8
9	Effective Savings Rate (ESR) = What you saved / What you would have spent with no discounts
10
11
12	STEP 1: CONFIGURE TIME PERIOD OVER WHICH TO MEASURE ESR
13
14	Time Period
15
16	Start Date	2023-01-01
17	End Date **	2022-02-01
18
19	** End Date is non-inclusive, i.e. data is pulled through 23:59:59 up to, but not including, the date specified
20
21
22	STEP 2: EXECUTE THE FOLLOWING AWS CLI COMMANDS FROM THE MANAGEMENT ACCOUNT
23
24	AWS CLI Commands
25
26	aws ce get-savings-plans-utilization --time-period Start=2023-01-01,End=2022-02-01 --filter '{ "Dimensions": { "Key": "SAVINGS_PLANS_TYPE", "Values": [ "ComputeSavingsPlans", "EC2InstanceSavingsPlans" ] } }' --query 'Total.Savings.[{OnDemandCostOfSPHoursUsed: OnDemandCostEquivalent}, {NetSPSavings: NetSavings}]'
27	aws ce get-reservation-utilization --time-period Start=2023-01-01,End=2022-02-01 --filter '{ "Dimensions": { "Key": "SERVICE", "Values": [ "Amazon Elastic Compute Cloud - Compute" ] } }' --query 'Total.[{OnDemandCostOfRIHoursUsed: OnDemandCostOfRIHoursUsed}, {NetRISavings: NetRISavings}]'
28	aws ce get-savings-plans-coverage --time-period Start=2023-01-01,End=2022-02-01 --filter '{ "Dimensions": { "Key": "SERVICE", "Values": [ "Amazon Elastic Compute Cloud - Compute", "Amazon EC2 Container Service", "Amazon Elastic Container Service", "Amazon Elastic Container Service for Kubernetes", "AWS Lambda" ] } }' --query 'SavingsPlansCoverages[].Coverage.{OnDemandCost: OnDemandCost}'
29
30
31	STEP 3: ENTER DATA AS SHOWN, USING THE VALUES GENERATED IN STEP 2
32
33	Calculations		Command → Value
34
35	A. Savings Plan On-Demand Equivalent Spend (EC2, Fargate, Lambda)		get-savings-plan-utilization → OnDemandCostOfSPHoursUsed
36	B. Reserved Instance On-Demand Equivalent Spend (EC2)		get-reservation-utilization → OnDemandCostOfRIHoursUsed
37	C. On-Demand Spend (EC2, Fargate, Lambda)		get-savings-plan-coverage → OnDemandCost
38	D. Compute On-Demand Equivalent Spend (A + B + C)	$0.00
39
40	E. Savings from Compute related Savings Plans		get-savings-plan-utilization → NetSPSavings
41	F. Savings from Compute related Reserved Instances		get-reservation-utilization → NetRISavings
42	G. Compute RI & SP Savings (E + F)	$0.00
43
44
45	STEP 4: ENTER COST TO ACHIEVE SAVINGS OUTCOME, IF ANY
46
47	H. Cost to Achieve Savings (CMP, service, time, tooling, etc. cost)
48
49
50	STEP 5: SEE YOUR EFFECTIVE SAVINGS RATE
51
52	Effective Savings Rate (G - H) / D
53
54
55
56	Notes
57	* This particular ESR calculation is limited to AWS Discountable Compute (i.e., EC2, Fargate, and Lambda, exclusive of Spot) savings from Reserved Instances and Savings Plans. It does not measure additional discounts from EDPs, Private Pricing Agreements, etc. which would deliver incremental savings and a higher ESR.
58
59
60	Last Updated: 2023-02-28
61