I need youor help!
In the product sales business that I run I get paid by the owner a % of the Profit that I create. I am setting up a spreadsheet to track this so that I can be paid the right amount for the work that I do.
Here is the problem, when I put all the informantion in quick books, the number looks sad to be sure, but when I put the same information in to Excel, I get a completely different number!?!?!
My question is, if I pay say $5.80 for an item and I sell it for $14.50, what is my profit margin? And is that different some how than my mark up.
In my spreadsheet, I am using the formula (Selling Price-Purchase Price)/Selling Price, is this right?
Please help thank you!
Tony Sorensen Performance Detailing www.performance-detailing.com firstname.lastname@example.org email@example.com