Forum Discussion

nic140274's avatar
nic140274
Copper Contributor
Feb 21, 2020
Solved

Automatic Selling price calculator

Hello, could someone help me with a formula to calculate the selling price of an item given some specific guidelines?   Basically I sell products on a website which I buy from a supplier, The web...
excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Feb 22, 2020

    nic140274 Not sure I follow. If you refer to the 25% in cell K4, that is not a revenue. I just entered the tax% there that you charge to the customer. PErhaps I should have removed your column header. Then I don't have to type "25%" in every formula where it is used. Just a habit.

     

    The tax that you pay on you purchases are not costs and the tax that you charge to your customers is not revenue. I doubt that the 1 euro and the 15% are inclusive of taxes, but if you are certain that this is really the case, enter:

    =1/1.21

     in C4, and

    =15%/1.21

    in D5. 

    Have attached the schedule with these formulae.

nic140274's avatar
nic140274
Copper Contributor
Feb 22, 2020

Riny_van_Eekelen 

I don't understand the formula behind L4 that uses a 25% revenue,

also, is the fact that I can claim 21% back from the 1 Euro plus 15% selling price important or required?

 

Thanks

Nic

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Feb 22, 2020

nic140274 Not sure I follow. If you refer to the 25% in cell K4, that is not a revenue. I just entered the tax% there that you charge to the customer. PErhaps I should have removed your column header. Then I don't have to type "25%" in every formula where it is used. Just a habit.

 

The tax that you pay on you purchases are not costs and the tax that you charge to your customers is not revenue. I doubt that the 1 euro and the 15% are inclusive of taxes, but if you are certain that this is really the case, enter:

=1/1.21

 in C4, and

=15%/1.21

in D5. 

Have attached the schedule with these formulae.

  • nic140274's avatar
    nic140274
    Copper Contributor
    Feb 23, 2020

    Riny_van_Eekelen 

    OK I spent all day on this yesterday, I did lots of tests and matched them to manual calculations and looks really good, I am very happy and I consider this now resolved.

    Sorry while I live here in the Netherlands my Dutch is still really bad 🙂

     

    Bedankt voor al je harde werk om me te helpen

     

    Regards

    Nic from Huizen

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Feb 22, 2020
    Mijn fout. Weet niet waarom ik 25% gebruikte. Prettig weekend.
  • nic140274's avatar
    nic140274
    Copper Contributor
    Feb 22, 2020

    Riny_van_Eekelen 

     

    I think this is it, the 25% confused me, because we charge 21% tax to customers here in the Netherlands,

    so I manually changed it to 21%. I hope I did not missundertood the use for it and mess the whole logic.

     

    For now thanks so much and and I will keep working on it.

     

    Regards

    Nic

Resources