Winamp & Shoutcast Forums Help: Calculating selling fees
 User Name Remember Me? Password

 Thread Tools Search this Thread Display Modes
16th May 2017, 06:07   #1
iomegajaz
Balled and Chained
Alumni

Join Date: Jun 2000
Posts: 5,238
Help: Calculating selling fees

Fellow elementary/rudimentary-level mathematics people, I have a riddle for you, that I cannot seem to resolve on my own. Ebay and PayPal fees are calculates has follows:
• Ebay fee = ( Shipping price (postage cost) + Sell price (list price) ) * 9.9%
• PayPal fee = (( Shipping price (postage cost) + Sell price (list price) ) * 2.6% ) + \$0.30
In the above screenshot, I have worked out calculations for determining what my net result will be, based on my input of the Ship price and Sell price.

What I actually want to achieve, however, is almost the opposite, i.e. I want to type in my goal net result and Ship price, to determine the required Sell price.

How can I do this without using circular references? I'm attaching my XLSX in a ZIP as a starting point.

Please, make me feel inadequate/stupid and help me figure this out.
Attached Thumbnails

Attached Files
 Ebay and PayPal selling fee calcs.zip (10.9 KB, 66 views)

"My heart hates uggos." –J.D.

 16th May 2017, 07:45 #2 iomegajaz Balled and Chained Alumni   Join Date: Jun 2000 Posts: 5,238 I worked it out. Don't know why I had such a mental block with this.=((Ship_price*0.125)+0.3+Net_result)/0.875 "My heart hates uggos." –J.D.
 16th May 2017, 17:21 #3 SSJ4 Gogitta Followed by Gnomes(Forum King)     Join Date: Dec 2000 Location: West Virginia Googolplex: 10^10¹°° FB:/SSJ4.DominusDeus DeviantArt: DominusDeus XboX GT: A Wild Meeseeks Playstation 4: DominusDeus Posts: 7,161 Most folks I see just use +3% to cover PPGS fees. "Buy this for \$50 (add 3% for PPGS). \$3 S&H. Free shipping at \$100 purchase. Add \$1 per \$100 of insurance."
17th May 2017, 00:29   #4
iomegajaz
Balled and Chained
Alumni

Join Date: Jun 2000
Posts: 5,238
Quote:
 Originally Posted by SSJ4 Gogitta Most folks I see just use +3% to cover PPGS fees. "Buy this for \$50 (add 3% for PPGS). \$3 S&H. Free shipping at \$100 purchase. Add \$1 per \$100 of insurance."
I used to do something like that, i.e. "Eh, _% should cover it", and I invariably wound up short of my desired net result. In your example, for a \$50 sell price and \$3 actual postage costs, adding 3%* (on \$50+\$3) would result in revenue of \$54.59, fees of \$7.91 and net result of \$46.68. No bueno.

The point of this exercise is to be more precise; once I work out the minimum that I need to charge in order to cover costs (in this \$50 case, it'd be \$57.91) I can then round up to a clean number (e.g. \$58 or \$60).

* I'm not sure what PPGS means; Google suggests it may be PayPal Gifts.

"My heart hates uggos." –J.D.

 21st May 2017, 03:46 #5 SSJ4 Gogitta Followed by Gnomes(Forum King)     Join Date: Dec 2000 Location: West Virginia Googolplex: 10^10¹°° FB:/SSJ4.DominusDeus DeviantArt: DominusDeus XboX GT: A Wild Meeseeks Playstation 4: DominusDeus Posts: 7,161 Wonder if 3% not being enough has to do with you being in Australia? According to PayPal; "There is a fee to send money as a personal payment using a debit card or credit card. The fee in the U.S. is 2.9% plus \$0.30 USD of the amount you send. For example, if you send \$100.00 USD by credit card, the fee would be \$3.20 USD (\$2.90 \$0.30)." So if I bought something from /r/PMsForSale, the sellers typically have the price of the item, ask to add 3% if using PPGS (Goods & Services), plus say \$3.50 s&h. In total, I'd send \$106.50 for s \$100 item. PPFF = Friends & Family. It's the free options but has no buyer protection like the GS option.
23rd May 2017, 01:06   #6
iomegajaz
Balled and Chained
Alumni

Join Date: Jun 2000
Posts: 5,238
Quote:
 Originally Posted by SSJ4 Gogitta Wonder if 3% not being enough has to do with you being in Australia?
A couple of things:

1. The US PPGS fee you've quoted (2.9% + \$0.30) is for paying others (i.e. buying on reddit). The AU PPGS fee for charging others (i.e. selling on Ebay) is 2.6% + \$0.30. See attached.

2. You're correct that the rounded "3%" is enough to cover the PayPal fee, so long as the sell price plus ship price comes to at least \$100; however, I also need to cover the Ebay fee—a hefty 9.9%!
Attached Thumbnails

"My heart hates uggos." –J.D.

 24th May 2017, 04:56 #7 SSJ4 Gogitta Followed by Gnomes(Forum King)     Join Date: Dec 2000 Location: West Virginia Googolplex: 10^10¹°° FB:/SSJ4.DominusDeus DeviantArt: DominusDeus XboX GT: A Wild Meeseeks Playstation 4: DominusDeus Posts: 7,161 Yeeeeeah, feeBay, as it's known. 'Tis why /r/PMsForSale is a great place for stuff.
 Winamp & Shoutcast Forums Help: Calculating selling fees
 User Name Remember Me? Password

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Forum Rules
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Tech Support Greatest Hits Winamp     Winamp Technical Support     Winamp Discussion     Winamp Wishlist     Winamp Bug Reports     Winamp for Android     Winamp Site Design Shoutcast     Shoutcast Technical Support     Shoutcast Discussions     Shoutcast For Business & Monetization     Shoutcast Site Design International Connection     International Connection     Русскоязычный форум (Russian)     Français: de l'aide pour les francophones (French)     Winamp Deutsch (German) Community Center     General Discussions     Breaking News     Music O'Rama     Games Center     Movies and Television     The Bitchlist Skinning and Design     Skinning Tips and Tricks     Classic Skins     Modern Skins     Arts and Design Developer Center     Winamp Development     NSIS Discussion         NSIS Translations Visualizations     AVS         AVS Presets         AVS Wishlist         AVS Troubleshooting     MilkDrop         MilkDrop Presets         MilkDrop Development         MilkDrop Feature Requests         MilkDrop Troubleshooting Forum

 -- Deutsch -- English (US) -- Polish -- Russian Winamp.com - Help - Archive - Top