#
Move from Excel to Python with Pandas Transcripts

Chapter: Case study walk through: Sales commissions

Lecture: Product commission variable amounts

Login or
purchase this course
to watch this video and the rest of the course contents.

0:00
up until now, we've just used one commission re. But since we know our business,

0:05
we know that we don't need to do as much work to sell products through the

0:09
partner and reseller spaces. So maybe we should adjust those commissions down. So let's set a new partner rate these air to starting values,

0:18
and we'll do some analysis to see how this impacts air total commissions.

0:26
Now we've added the commission rates so that we can modify it for each transaction.

0:31
And here's the commission rate. Now we want to update it where the customers are

0:35
partners or resellers. It's a type of there where their partners or resellers and apply

0:46
that lower commission rate and see how it changes the total commissions we need to build

0:51
a Boolean. Siri's identify which transactions are partners in which our resellers, in which a reto. So let's start with that.

1:04
So to refresh your memory about what we've done here. If you look at partners, we now have a true false list of all of

1:11
those values that our partners are all those transactions, their partners. So now that we have that true false list,

1:17
let's go ahead and update our data frame so that those transactions can have the lower commission rate. Now we have the new rates,

1:29
and because all of these top transactions are retail, it's not showing up. But it is in there. If we want to see what the rates are,

1:37
let's just do a quick check. So now we can see that we do have variable rates in here.

1:43
The final step is we need to actually calculate the commission's. So now we have a commission rate and we multiply that by the invoice total to

1:52
get the new commission. So we have a dynamic model now that will give us a different calculation for the commission.

2:00
So let's check that. See now or commissions are 565,000 versus one million, which makes sense because we lower those rates.

2:10
Now let's see what the impact was on our total commissions paid. We already did that calculation. Copy this down here.

2:22
I'm also gonna add margins equal true to show totals. So now we can see that the commission's have come down for Tiner and sudden,

2:34
but they've also come down quite a bit for Malcolm immunised. So we still have this discrepancy. So we've created some room in our commission values,