Product Profitability Analysis Template
                                                Sales Revenue Data
                                                                 Quantity    Total       Shipping 
          Product                         Price/Unit  Markup % Sold          Revenue     Cost Charged 
                                                                                         to Customer
             Product 1                       ₹ 125       10%         35       ₹         4,813   ₹                 50 
             Product 2                        ₹ 85       25%         52       ₹         5,525   ₹                 50 
             Product 3                       ₹ 100       30%         28       ₹         3,640   ₹                 50 
             Product 4                       ₹ 250       30%         55       ₹       17,875   ₹                 50 
             Product 5                       ₹ 135       40%         40       ₹         7,560   ₹                 50 
             Product 6                       ₹ 145       25%         60       ₹       10,875   ₹                 50 
             Product 7                       ₹ 120       30%         37       ₹         5,772   ₹                 50 
             Product 8                       ₹ 110       50%         44       ₹         7,260   ₹                 50 
                                                                    Productwise Revenue
                                           Product 1 Product 2 Product 3      Product 4    Product 5
             Total Revenue                  ₹ 4,813     ₹ 5,525    ₹ 3,640     ₹ 17,875      ₹ 7,560
             % of Total Revenue               8%          9%         6%          28%          12%
                                                                      Productwise Profit
                                           Product 1 Product 2 Product 3      Product 4    Product 5
             Profit                         ₹ 1,313     ₹ 2,384    ₹ 1,540      ₹ 5,500      ₹ 3,160
             Profit %                         6%         10%         7%          24%          14%
                         Productwise Revenue                              % of Total Revenue
            ₹ 120 
            ₹ 100 
                                                                                   11.47%
             ₹ 80                                                   Product 1
                                                                    Product 2            7.60%
             ₹ 60                                                             9.12%          8.73%
                                                                    Product 3                    5.75%
                                                                    Product 4
             ₹ 40                                                   Product 5
                                                                             17.17%
                                                                    Product 6
             ₹ 20 
                                                                    Product 7                  28.23%
               ₹ -                                                  Product 8
                                                                                  11.94%
       ₹ 120 
       ₹ 100 
                                            11.47%
        ₹ 80                         Product 1
                                     Product 2  7.60%
        ₹ 60                              9.12%   8.73%
                                     Product 3      5.75%
                                     Product 4
        ₹ 40                         Product 5
                                          17.17%
                                     Product 6
        ₹ 20 
                                     Product 7     28.23%
        ₹ -                          Product 8
                                            11.94%
Product Profitability Analysis Template            From:                 1/1/2017
Sales Revenue Data                                 To:             31/01/2017
                Actual                             Return 
                Shipping  Profit/Unit Goods                        Net Income
                Cost
                 ₹           25   ₹            38         0             ₹ 1,313
                 ₹           25   ₹            46         1             ₹ 2,384
                 ₹           25   ₹            55         0             ₹ 1,540
                 ₹           25   ₹          100          0             ₹ 5,500
                 ₹           25   ₹            79         0             ₹ 3,160
                 ₹           25   ₹            61         0             ₹ 3,675
                 ₹           25   ₹            61         2             ₹ 2,185
                 ₹           25   ₹            80         0             ₹ 3,520
Productwise Revenue
                 Product 6 Product 7 Product 8                             All
                  ₹ 10,875           ₹ 5,772          ₹ 7,260          ₹ 63,320
                     17%                9%              11%               100%
Productwise Profit
                 Product 6 Product 7 Product 8                             All
                   ₹ 3,675           ₹ 2,185          ₹ 3,520          ₹ 23,276
                     16%                9%              15%               100%
                                 Total Income/Product
                   ₹ 6,000
                   ₹ 5,000
11.47%             ₹ 4,000
Product 1
Product 27.60%
9.12%8.73%         ₹ 3,000
Product 35.75%
Product 4          ₹ 2,000
Product 517.17%    ₹ 1,000
Product 6
Product 728.23%           ₹ 0
Product 8
11.94%
               ₹ 6,000
               ₹ 5,000
11.47%         ₹ 4,000
Product 1
Product 27.60%
9.12%8.73%     ₹ 3,000
Product 35.75%
Product 4      ₹ 2,000
Product 517.17%₹ 1,000
Product 6
Product 728.23%      ₹ 0
Product 8
11.94%