Results 1 to 5 of 5

Calculating Selling Price Formula in Excel

Threaded View

  1. #1
    Registered User
    Join Date
    03-23-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2007
    Posts
    3

    Question Calculating Selling Price Formula in Excel

    Hi,

    I am quite new to this forum, I am working on a formula to calculate the selling price based on variables available including Item cost, commissions on sale, postage charge and fixed profit.

    Example will be as follow:

    Cost of the item = £10

    Postage charge = £0.50

    1st Commission on Sales = 9% (this include VAT of 15%)

    2nd Commission on Sale = 1.9% (No VAT on this)

    The Fixed Net Profit after deducting all VAT to make on this sale = £1

    (Note: the selling price inc 20% VAT)

    Any suggestions or help would highly be appreciated.

    Thank you
    Last edited by hitari; 03-23-2013 at 05:50 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1