1. ## 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?

2. ## Margin per cost of sales

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

Margin per cost of sales = (Sales

3. ## Re: percentage (Access 2000)

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

4. ## 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.

#### Posting Permissions

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