Scribd Logo
Upload

Welcome to Scribd!

  • 897 views

    Amazon Flipkart Comparision Calculator

    Uploaded by

    shah faisal
    The document compares key metrics for Amazon and Flipkart related to selling a single SKU (stock keeping unit) priced at Rs. 200. Amazon had higher net earnings (Rs. 65.44 vs Rs. 31.88) and net margin (33% vs 16%) per SKU compared to Flipkart due to lower returns, replacements and collection fees. While both marketplaces had similar selling prices and commissions, Amazon experienced better performance overall for this SKU.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Amazon Flipkart Comparision Calculator

    Uploaded by

    shah faisal
    897 views12 pages
    The document compares key metrics for Amazon and Flipkart related to selling a single SKU (stock keeping unit) priced at Rs. 200. Amazon had higher net earnings (Rs. 65.44 vs Rs. 31.88) and net margin (33% vs 16%) per SKU compared to Flipkart due to lower returns, replacements and collection fees. While both marketplaces had similar selling prices and commissions, Amazon experienced better performance overall for this SKU.

    Original Description:

    Calculator for calculating the selling price of product on amazon and flipkart.

    Original Title

    Amazon Flipkart Comparision calculator

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document compares key metrics for Amazon and Flipkart related to selling a single SKU (stock keeping unit) priced at Rs. 200. Amazon had higher net earnings (Rs. 65.44 vs Rs. 31.88) and net margin (33% vs 16%) per SKU compared to Flipkart due to lower returns, replacements and collection fees. While both marketplaces had similar selling prices and commissions, Amazon experienced better performance overall for this SKU.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    897 views12 pages

    Amazon Flipkart Comparision Calculator

    Uploaded by

    shah faisal
    The document compares key metrics for Amazon and Flipkart related to selling a single SKU (stock keeping unit) priced at Rs. 200. Amazon had higher net earnings (Rs. 65.44 vs Rs. 31.88) and net margin (33% vs 16%) per SKU compared to Flipkart due to lower returns, replacements and collection fees. While both marketplaces had similar selling prices and commissions, Amazon experienced better performance overall for this SKU.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 12

    Amazon

    No of Order

    Flipkart

    1000

    1000

    Selling Price

    500

    500

    Commission

    17%

    17%

    10

    15

    20

    RTO (Undelivered Returns)

    70

    70

    Customer Return

    50

    50

    35

    Shipping Fees

    65

    65

    Reusable Inventory Returned

    45

    45

    885

    885

    Closing Fee
    Collection Fee

    Replacement

    Actual SKU Usage


    SKU Cost Price

    200

    269110

    238802

    304

    270

    Net Earning per SKU

    65.44

    31.88

    Net Margin per SKU


    against Purchase Price (Rs.
    200)

    33%

    16%

    Net Margin per SKU


    against Selling Price ( on
    Amazon Rs. 500) (on
    Flipkart Rs. 500)

    13%

    6%

    Total Gross Seller Payable


    Earning per SKU from
    Marketplace

    Industry Average Estimates


    RTO (Undelivered Returns)

    7% / 70

    Customer Returns

    5% / 50

    Replacement

    70% / 35

    Customer Returns are higher in Apparels.

    Major Customer Returns are converted to Rep

    Actual SKU Usage : In customer returns some inventory is not reusable. So we need to calcula
    Earning per SKU from Marketplace is Total Amout received vs Actual SKU Usage.
    Net Earning Per SKU is Actual Amount we Earn after all Deductions

    Disclaimer : We have tried our best to create a Calculation Sheet with help of inputs from se
    calculations error free. If any error in calculation please put in group.
    Calculation Sheet Specially for AOSI and AIOVA enrolled Members on

    Reusable Inventory

    90%

    Service Tax

    15%

    Shipping (500 gm)


    Local

    30

    Zonal

    45

    National

    65
    Select Shipping Zone
    National

    Packing Cost
    Vat

    10
    5.5%

    Box with this colour are editable.

    stimates

    urns are higher in Apparels.

    er Returns are converted to Replacement

    reusable. So we need to calculate the cost.

    Actual SKU Usage.

    heet with help of inputs from sellers and to keep


    culation please put in group.
    AIOVA enrolled Members only

    Local
    Zonal
    National

    You might also like