Thanks alot Jay, I had made up something very similar. Your one gave me a few more bits to add and its perfect. Thanks alot dude, good of you to help out a few of us!
A pleasure. As a relative newbie around here it's nice to be able to bring something to the table. You never know, at sometime in the future one of you guys may be in a position to help me out in return
I'm pretty hot on Excel. I'm putting together a sheet to track stockholding, movement and re-order trigger points, might be useful for the wholesalers out there. Will put it out if anyone's interested in it..
Why didn't someone tell me I could add attachments on here!? lol
Spreadsheet attached for anyone who doesn't have it yet..
Just select the right box (technology, media or other - and selling price range) and add in your cost and sell prices. Do the same for carriage and it will calculate your margin as a percentage as well as the markup as a decimal and the actual sterling profit per sale. Listing fee is based on an ebay shop with no listing upgrades so you may have to edit that to fit.
I'd suggest copying the box to sheet 2 first to keep the original calculations intact but up to you.
Re: Dropshiping profit margin
Linear Mode
November 2009
