<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto">It helps a hell of a lot! This is the process that I was looking for. <br><br><div id="AppleMailSignature" dir="ltr"><div>Thanks, </div><div><br></div>Shripal</div><div dir="ltr"><br>On Jun 5, 2019, at 7:10 PM, Ryan Delgrosso <<a href="mailto:ryandelgrosso@gmail.com">ryandelgrosso@gmail.com</a>> wrote:<br><br></div><blockquote type="cite"><div dir="ltr">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<p>This is (un) fortunately a problem I'm intimately familiar with.
In the end Ive pretty much always solved it by writing a small
utility or script. <br>
</p>
<p>1: You need to normalize breakouts across carriers, this means
expanding to the longest match, so in the previous example: <br>
</p>
<div>Number dialed: 44-20-7499-9000</div>
<div>Carrier A: 44 - 0.0025</div>
<div>Carrier B: 442 - 0.0045</div>
<div>Carrier C: 44207 - 0.0085</div>
<div><br>
</div>
<div>you end up with: <br>
</div>
<div>44: carrier A - 0.0025</div>
<div>442: carrier A - 0.0025, Carrier B - 0.0045</div>
<div>44207: carrier A - 0.0025, Carrier B - 0.0045, Carrier C -
0.0085</div>
<div><br>
</div>
<div>Great now your routing table is instead of 215k entries, 1.3M
but its comparable. <br>
</div>
<div><br>
</div>
<div>If you have a cost cap, before you do the next part, strip all
routes that exceed it. You don't want pricing for routes you'll
never use influencing your rates. <br>
</div>
<div><br>
</div>
<div>2: For each destination drop your lowest cost and use some
combination of your tolerable route depth pricing * some margin.
You might also consider a smarter algo like dropping lowest if
more than std dev away from avg of next X carriers etc. Basically
you dont want your price forced below carrier 2/3 by an abnormally
low 1 who in the end will never complete calls satisfactorily for
you. <br>
</div>
<div><br>
</div>
<div>3: Now, you need to de-duplicate, removing all routes whose
price is identical to their parent route (route stripping the
right-most digit, if that doesnt exist, strip again until you hit
base country code) <br>
</div>
<div><br>
</div>
<div>4: Finally, take your rate deck to your sales team and listen
to them tell you how they cannot sell it because its more
expensive than <fly_ny_night_telecom>. <br>
</div>
<div><br>
</div>
<div>There are lots of other ways to do this, but i pretty much
always implement some flavor of this process. <br>
</div>
<div><br>
</div>
<div>FYI, after expansion, if you have the means, its always worth
adding a step that scans for fictitious codes. Occasionally IRSF
perpetrators will inject bogus country sub-codes in the hopes of
getting FAS traffic from fraudsters. <br>
</div>
<div><br>
</div>
<div>Hope that helps. <br>
</div>
<div><br>
</div>
<div>-Ryan <br>
</div>
<div><br>
</div>
<div class="moz-cite-prefix">On 6/4/2019 7:10 AM, Shripal Daphtary
wrote:<br>
</div>
<blockquote type="cite" cite="mid:CADA0+sCrfDv1Wuc9L5xdj8+kXKXS0HzteqKf9Sxve_yfMH_QMA@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">Hey group,
<div><br>
</div>
<div>I have a question that I have been struggling with for
years and have never come up with a good solution for. It
revolves around International Rate Deck creation, but i guess
it could be for any tariff. We have multiple carriers for
International, however, i'm trying out Thinq right now so we
can use their LCR. Our other carriers aren't very successful
with Intl. Thinq's rate deck to me is 6 carriers for each
prefix, making it around 215,000 lines. The carrier(s) that
have the lowest cost for each prefix varies, so i can't turn
off the most expensive three or something like that. </div>
<div><br>
</div>
<div>I was thinking of taking the least expensive 3 carriers and
then averaging them and creating my rate from that average and
then only allow Thinq to go 3 carriers deep. Does anyone have
any experience with this? Are there any best practices? </div>
<div><br>
</div>
<div>The second part of the question is how does one calculate
the profit margin? Let's say you wanted to make 35% for
retail and 20% for wholesale, but if you call UK landline, the
cost is only 0.004. Your rate would be 0.0054 for retail and
0.0048, which is nothing. We have been doing something like
If your cost is less than 0.03, then increase by 35% or 20% or
whatever. however, that doesn't always work if the cost is
super close to your target. </div>
<div><br>
</div>
<div>Does anyone have any hard and fast rules that they use when
creating decks? is there software that can help my puny brain
think through this? </div>
<div><br>
</div>
<div><br>
</div>
<div>Thanks ! </div>
<div><br>
</div>
<div>Shri</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
VoiceOps mailing list
<a class="moz-txt-link-abbreviated" href="mailto:VoiceOps@voiceops.org">VoiceOps@voiceops.org</a>
<a class="moz-txt-link-freetext" href="https://puck.nether.net/mailman/listinfo/voiceops">https://puck.nether.net/mailman/listinfo/voiceops</a>
</pre>
</blockquote>
</div></blockquote><blockquote type="cite"><div dir="ltr"><span>_______________________________________________</span><br><span>VoiceOps mailing list</span><br><span><a href="mailto:VoiceOps@voiceops.org">VoiceOps@voiceops.org</a></span><br><span><a href="https://puck.nether.net/mailman/listinfo/voiceops">https://puck.nether.net/mailman/listinfo/voiceops</a></span><br></div></blockquote></body></html>