PC Review


Reply
Thread Tools Rate Thread

calculating commision on sales

 
 
k-leo
Guest
Posts: n/a
 
      1st Jul 2006
hi,how do we calculate?...i have 2 methods,
1) amount of sales * 5% , say if the decided commision is 5%
2) (amount of sales - expenses of the month) * 5%
any other method will be highly appreciated,but a simple one.
please help someone.

 
Reply With Quote
 
 
 
 
=?Utf-8?B?SkxhdGhhbQ==?=
Guest
Posts: n/a
 
      2nd Jul 2006
Are you asking about how other people determine a commission rate or rates?
That's a little beyond the scope here. There was discussion here from one
person who had the commission rates escalate to a maximum amount based on
total sales - more bonus for more sales.

I can show you how to use Excel to calculate using the two methods you've
mentioned.

1st method
Column A has total sales, Column B will show commission

A B
1 $$$$$ =A1 * .05

Be sure to type the = symbol at the start of the formula in B1.

2nd method A = sales, B = expenses, C = commission

A B C
1 $$$$ $$$$ =(A1-B1)* .05


"k-leo" wrote:

> hi,how do we calculate?...i have 2 methods,
> 1) amount of sales * 5% , say if the decided commision is 5%
> 2) (amount of sales - expenses of the month) * 5%
> any other method will be highly appreciated,but a simple one.
> please help someone.
>
>

 
Reply With Quote
 
k-leo
Guest
Posts: n/a
 
      2nd Jul 2006
hi klatham,
thanks, but i know how to calculate on excel....i want to know that if
i want to pay commision to staff....which method is correct of the 2
mentioned b4...giving 5% from profit.... or directly from sales.

 
Reply With Quote
 
k-leo
Guest
Posts: n/a
 
      2nd Jul 2006
oops... JLatham...

 
Reply With Quote
 
=?Utf-8?B?SkxhdGhhbQ==?=
Guest
Posts: n/a
 
      13th Jul 2006
I think that the answer to that depends on the company. A lot depends on how
the profit margin is set up. If the sales commission is calculated in to
come up with a firm or minimum selling price, then calculating commission on
sales doesn't hurt anything. But if price is a variable based on cost, then
a fixed commission on sales could put the company in the red.

Let's take an automobile dealership and one car.
Car costs $1000 and their target profit is 33%, so the windshield sticker says
$1330
Meanwhile, the deal for the salesmen is 10% of sales.
Along comes a sharp customer, salesman has a bad day, sales were down
anyhow, so he lets the car go for $1050. Ok - it cost us $1000, so we made
$50 on it. Oops - now we have to pay 10% commission on SALES, so we own the
salesman $105, which means the dealership just lost $55 on the sale.

But if the potential commission was calculated into the lowest sell price to
begin with, then not a problem as long as the rules are followed. Example,
same $1000 car, same 10% of sales deal for salesmen, but now the calculated
cost of the vehicle is at $1111.11 - no one is allowed to sell the car for
less than that, since that is roughly the breakeven point (I know the
$1111.11 doesn't quite look right, but if you take 10% of that and subtract
it from $1111.11 you end up with the $1000 cost left over). And a smart car
dealer would set it up that way, and a really sharp one would calculate
amount for profit on this, thus actually making some profit from the
commission itself.

Hope this helps.

I doubt that there is a "right" or "wrong" way to set it up. You just have
to make sure that your selling price is always enough to pay whatever
commission you set up under whatever method and that paying commission never
puts the sale in the red.

The safest thing for the company to do is accurately calculate costs and pay
commission on 'net profit'. This serves 2 purposes, makes sure that as long
as you make some profit, you don't have money-losing sales. Makes the
salesmen tough to deal with because they realize their money is directly tied
to how much above cost they sell the item for.
It's also a way for the really sharp car dealerships to never pay a dime in
commission - I know some bookkeepers that could prove a loss on the sale of
sand that cost $10/pound to buy and was selling for $1000/pound. These
places generally have a high turn-around rate for their sales staff.


"k-leo" wrote:

> oops... JLatham...
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating sales tax krymer Microsoft Access 8 18th Dec 2008 03:58 PM
Calculating sales commission that changes based on a sales volume =?Utf-8?B?RWxib3dlcw==?= Microsoft Excel Worksheet Functions 2 8th Jun 2007 02:48 PM
Re: formula for calculating sales tax (GST) Cor Ligthert [MVP] Microsoft VB .NET 0 31st Aug 2006 02:35 PM
I'm looking for a tiered sales commision tracker =?Utf-8?B?QWx2aW4gTWNOYWly?= Microsoft Excel Misc 1 5th Jul 2006 08:44 PM
Calculating sales commision HELP!!!!!!! spunkysezza Microsoft Excel Worksheet Functions 4 26th Feb 2006 05:45 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:47 PM.