- #FEE AND PROFIT CALCULATOR FOR EBAY APP, MAC FULL#
- #FEE AND PROFIT CALCULATOR FOR EBAY APP, MAC PLUS#
I finally concluded in that case that the only solution was to create a UDF that would start at a base sale price, probably the cost times a percentage, then would increment by 1, checking all the fees and taxes, and quit when all constraints were met. His setup was much more complicated, with different types of products getting different fees and tax rates. On a related note, I spent a lot of time once working out the same type of analysis for another eBay seller. It appears joeu2004 has the most complete and accurate analysis, so I'd stick with that. Multiplying the break-even price by the desired profit ended up with higher fees, so it ended up as a 13% profit on the sale price, or a 24% profit on the cost. However, I really didn't do a complete analysis. In any case, note that igold's profit margin is based on the net revenue (price minus operating costs), not on the price, as eaxlns specified.īecause the OP said "I want to make a 15% profit of the selling price". Corresponding changes are also needed in the "proof of concept" formulas in 11:15. If igold's interpretation is correct, I would agree with his inclusion of shipping with cost of goods sold. Both interpretations are equally valid, IMHO. Arguably, igold might interpret it to mean: the cost of shipping to the seller. I interpret it to mean: the cost of shipping to the customer. That depends on an interpretation of "shipping" in the OP. It is just another operating cost that is, it is not a cost of goods sold.Īfter thought. If we exclude ebay and paypal operating costs, I see no reason not to also exclude the shipping cost. The difference is: I do not include shipping costs in the amount that the profit margin is based on. Note that my numbers different somewhat from the other 3 responses. Since you specified a profit margin as a percentage of price per se, you would want the profit applied to all costs.
#FEE AND PROFIT CALCULATOR FOR EBAY APP, MAC FULL#
Note that if the profit is applied only to the item cost, excluding operating costs, the profit margin is really a percentage of net revenue (price minus operating costs), not the full price. This necessarily causes a difference in the profit margin. The calculations in columns C and F are the correct calculations, given the real-world requirement to round to unit of currency. They demonstrate that exact profit margin is indeed calculated. The calculations in columns B and E are provided as a proof of concept. If you layout all the base figures on a row you can generate a easy formula.Ĭ10: =ROUNDUP((B1/(1-B6)+B2+B5)/(1-B3-B4),2) 68 subtract that from your sell of 3.73 and you have 3.05 which was your original sell price at a 15% margin. If you go backwards now you will see that Same as before you divide by the reciprocal. Now you have to get another GM of 12.9% which is the total of the Ebay 10% and the Paypal 2.9%. To get a Gross Margin of 15% for item that costs 2.59, you must divide the cost by the reciprocal of the GM.
#FEE AND PROFIT CALCULATOR FOR EBAY APP, MAC PLUS#
In you example your total cost, is the item cost plus the shipping: 1.72 +. The first thing you have to do is get the selling price of your item that generates a 15% Gross Margin. This application is maintained by an independent developer.ĮBay and PayPal are the property of their respective owners.I can give you the logic but you will have to fill the formula to match your sheet layout. Not located in the US not a problem our app supports countries like the United Kingdom, Australia, India, and ready to add more just leave a kind comment below about which part of the globe you're from and we'll get right on it.ĭisclaimer: eProfit is in no way endorsed by eBay. Have an ebay store? are you a top rated seller? eProfit has got you covered. How about sourcing products in bulk with eProfit you'll also be able to see the big picture of how selling the same product 50 or even hundreds of times will affect your bottom line.
In addition to providing the total dollar amount you'll be earning after all the fees and charges that come with selling anything on eBay eProfit also provides return on investment (ROI) data to help with sourcing products to sell on eBay.Īre you promoting your listing for discoverability on eBay see how that is impacting your profits. The eProfit app is a simple tool that provides meaningful insight into how much you'll earn from your ebay listings. Knowledge is power and in this case Profit.
0 kommentar(er)
