Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Posts
    280
    Thanks
    0
    Thanked 0 Times in 0 Posts

    percentage (Access 2000)

    My question is from a dummy(myself),and it relates not for an Access database but pure mathematics
    How does one calculate the profit? I have a PurchasePrice and a SalesPrice, and i must calculate the profit in selling the bought product.In my view, i must at first define the difference between the Sales and the Purchase price with the equation Delta = SalesPrice - PurchasePrice.
    Then to find the percentage, i must divide the SalesPrice to the Delta( the difference)
    Or : Profit percentage = SalesPrice/Delta
    AM i right, and are my calclulations right?

    Thank you for your reply.

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Margin per cost of sales

    Well I know this is how to calculate the margin: -

    Margin per cost of sales = (Sales

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: percentage (Access 2000)

    Hi,
    By my reckoning, the profit percentage would be:
    ((Sales price-Purchase price)/Purchase price)*100
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: percentage (Access 2000)

    That's the way I did it back in my accounting days, Rory, except that the multiplication is for display purposes only. Essentially, any variance is calculated this way, the difference divided by the base number. Profit has to be expressed as a percentage of cost in order to make any sense. Now if you want to express profit as a percentage of sales, that's something else.
    Charlotte

Posting Permissions

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