How To Perform a Markup Using the Rate Deck Generator
The Rate Deck Generator can be used to perform a markup on decks have been uploaded into the platform. The following example will allow you to perform a 20% markup on all of the rates that are in the decks of the considered vendors. Once the settings are configured, generating and exporting or distributing the new ratedeck can be done with a few clicks!
The below screenshot is an example of the Generator settings for a Termination, US&Canada, NPANXX type ratedeck:
To perform a simple markup:
Navigate to the Rate Deck Generator page under Tools.
Click on the Add Rate Deck button on the top right of the UI.
In the popup window:
Name the Rate Deck.
Define your Pricing Mode.
Set your Profit Markup to Percent.
Define your Profit Value (percentage, based upon step 3C choice).
Select Decimal Precision.
Select LCR Depth.
Select Rate By option from the drop-down menu.
When generating US&Canada ratedecks, define the following settings:
Indeterminate Rate.
If you plan to Include 8YY Pricing in the deck and the price if so.
To include/exclude US or Canada.
Click on the Add Rate Deck button in the popup.
Navigate to your newly created Rate Deck in the list on the Rate Deck Generator page and click the menu option on the far right.
Click Edit and then scroll to the bottom of the popup to select the Vendors and their assigned ratedecks that the generator will generate against.
Click on the Update Rate Deck Button
Navigate to your newly created Rate Deck in the list on the Rate Deck Generator page and click the menu option on the far right.
Click on generate to a ratedeck file based upon the settings you have configured thus far.
Once generated, the file can be exported from the same menu by clicking on Export.
The file can also be assigned to trunk groups and distributed en masse from the other options in same menu.
Â
Note:
Islands and US Territories are currently considered international and considered decks will be filtered of these prefixes/rates.
Filtering also occurs with 8YY prefixes. Please set the code value in the settings as mentioned in step 3H-2 to set 8YY Pricing.
Markup and margin are different.
A markup shows how much more your selling price is than the cost. For example, to calculate a price based on a 40% markup: cost = $0.00045, so price = $0.00045 x 1.4 = $0.00063.
To find the margin, divide gross profit by the revenue. For example, Margin = (selling price - cost) / selling price. Using the same example, Margin would be = ($0.00063 - $0.00045) / $0.00063 = 28.57%.
Â