ebay

Document Sample
ebay Powered By Docstoc
					                                       eBay Used Computer Equipment Sales
                                            Auction Values                                                         Fees
                                                                     Shipping &               Total Cost   eBay Final
Item                                        Initial          Final     Handling      USPS      to Buyer        Value      PayPal         Net
AMD Athlon XP 3200+ CPU                     $5.00           $5.00        $6.00      $5.90       $11.00        $0.77       $0.62        $3.71
Dell Inspiron 8200 Notebook Computer      $199.00         $199.00       $20.00     $15.75      $219.00       $11.95       $6.65      $184.65
Toshiba 30GB 2.5" hard drive               $50.00          $50.00       $10.00     $10.50       $60.00        $4.00       $2.04       $43.46
Thermaltake CPU fan                         $5.00                                                $0.00        $0.00       $0.00        $0.00

Total                                                                                                                                $231.82

Jim Glenn 10/3/2011

Case                                   $0.99 to $50
Condition                              F4<=50
Formula (English)                      7% of total cost
Formula (Excel)                        =0.07*F4

Case                                   $50.01 to $1000
Condition                              AND(F4>50,F4<=1000)
Formula (English)                      7% of first $50 and 5% of the amount over $50
Formula (Excel)                        =0.07*50 + 0.05*(F4-50)

Case                                   $1000.01 and up
Condition                              F4>1000
Formula (English)                      7% of first $50, 5% of next $950, 2% of amount over $1000
Formula (Excel)                        =0.07*50 + 0.05*(1000-50) + 0.02*(F4-1000)

All together                           =IF(F4<=50,0.07*F4,IF(F4<=1000,0.07*50+0.05*(F4-50),0.07*50+0.05*(1000-50)+0.02*(F4-1000)))

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:24
posted:8/29/2012
language:Latin
pages:1