Manage price factors

This page describes how to create price factors to set markups and discounts for cloud providers and private cloud.
To remove a discount applied for a reseller to bill a cloud tenant for a provider, such as Azure, use the enterprise property for the provider discount. See Display Azure billing data

You can assign price factors by enterprise, by reseller and customers, or by provider. For Azure and AWS you can also create more specific price factors.

By default, no price factors apply and that is the same as adding a price factor of 1.

To add a markup of 10%, enter a price factor with a value of 1.1.

To exclude an item from billing, add a price factor with a value of 0

Privileges: View price factors, Manage price factors

View price factors

To view price factors:

Log in with a user that has the same scope as the creator of the price factors
Go to Pricing → Price factors

Create a price factor

To create a price factor:

Go to Pricing → Price factors
On the providers list, click + add
Select the Provider. For private cloud, the provider is ONPREMISE
For Azure and AWS, you can also select the Bill type and Product ID
For Enterprise associations, select the type of association, which can be All, Reseller, or Key node. Abiquo will use your selection to create the list of Enterprises that match this type.
For Reseller or Key node, select an Enterprise
For the Enterprise association, enter the Value, which is the markup or discount.
- For example, to use a markup of 10%, enter 1.1 and to add a discount of 10%, enter 0.9.
- To exclude a product, you can set a value of 0
Click Add.
Select and add more enterprise associations as required. (You can also edit the price factor later to add more then.)
Click Save

When you create a price factor, the platform will assign your user scope to it, and only users with the same scope will be able to view and manage the price factor.

Azure price factor types table

For Azure, you can apply more specific price factors to apply to different resources at bill type and product level.

Azure price factor type	Applies to
azurecompute-arm_price_factor	All resources
azurecompute-arm_price_factor.bill_type	Resources of the specific category
azurecompute-arm_price_factor.bill_type.productId	Resources of the specific category and product ID

Azure bill types table

The multiple bill types for price factors let you separate the customer bill into Azure plan usages, reservations, licenses, and third-party products, and set different price factors for each one.

Azure bill type	Description
License based services	Products from the view “OnliceServices” with product type “OnlineServicesNCE”. Only the new commerce ones from the CSP license based services pricing sheet. (https://docs.microsoft.com/en-us/partner-center/develop/get-a-list-of-products#rest-request )
Marketplace	All the products for which the publisher is different from Microsoft or Microsoft Corporation
Azure plan	Entries retrieved by usage line items
Reserved instances	Products from target view “AzureReservations”
Software	Products from target view “Software”
Managed	Managed will be an extra line that consists of X percent of total Azure plan cost (used to define the factor to be applied to Azure plan costs to calculate the managed cost).

AWS bill types table

AWS has the following bill types as explained in their documentation for bill/BillType.
Reference: https://docs.aws.amazon.com/cur/latest/userguide/billing-columns.html#billing-details-B

Bill type	Description
Anniversary	Line items for services that you used during the month
Purchase	Line items for upfront service fees
Refund	Line items for refunds
Managed	Managed costs as a percentage of AWS costs, which the platform calculates if there is a `Managed` price factor, using: AWS costs AWS price factor * Managed price factor*

AWS product names

AWS has many product names. Here are some examples given in their documentation for product/ProductName

Reference: https://docs.aws.amazon.com/cur/latest/userguide/product-columns.html#product-details-P

AWS Backup, AWS Config, Amazon Registrar, Amazon Elastic File System, Amazon Elastic Compute Cloud, AWS Marketplace

Ignore AWS billing entries

AWS billing files contain charges and refunds. Abiquo lets you ignore billing items, which is helpful for excluding refunds from billing data. You can also ignore billing entries by specifying a price factor of 0.

To ignore billing entries with specific bill type and product name:

Log in to the Abiquo server as administrator
Go to the /opt/abiquo/config/ folder
Create a file with an appropriate name, such as aws-refund-product-ignore.csv
Enter a list of bill types and product names separated by a colon, for example:
Refund:AWS Premium Support
Refund:EC2 Reserved Instances
Edit the abiquo.properties file

Set the abiquo property with the file location, for example:

abiquo.ec2billing.parser.billType.productName.ignore.path=/opt/abiquo/config/aws-refund-product-ignore.csv

Include managed costs for AWS

To include managed costs as a percentage of a customer bill, define a price factor for the Managed bill type in the reseller, key node, or customer standard enterprise.

In AWS, the managed cost will be a percentage of the standard enterprise bill, as defined by the price factor of type Managed. The platform will apply the provider price factor and calculate the managed cost with the managed price factor.

For example, if Amazon price factor = 1.2 and Managed price factor = 0.3 and we run billing for an account that has a total cost of $125.70, then the managed cost will be $45, which the platform calculates as follows:

$125.70 * 1.2 * 0.3 = $45.00

Include managed costs for Azure

In Azure, the managed cost will be a percentage of the Azure plans cost, as defined by the price factor of type Managed. The platform will apply the provider price factor and calculate the managed cost with the managed price factor.

For example, if Azure price factor = 1.1 and Managed price factor = 0.4 and we run billing for an account that has a total Azure plans cost of $110.30 for usage line items, then the managed cost will be $48.53, which the platform calculates as follows:

$110.30 * 1.1 * 0.4 = $48.53