Page 18 - P4304.1-V100_PS Magazine - August 24 PRINT
P. 18

Sales by Supplier Report


                                         IPSEN LIMITED
               2218915  Decapeptyl SR INJ 3MG      4    £276.00  £55.20   £331.20
               3020534  Decapeptyl SR INJ 11.25MG  6   £1,242.00  £248.40  £1,490.40
               3585536  Decapeptyl SR INJ 22.5MG  1  4  £1,656.00  £331.20  £1,987.20
               Supplier Total                     14   £3,174.00  £634.80  £3,808.80
              Now we need to find those discounts paid. Here we need that
              MDS discount report for the same month.


                  MDS Discount Report


                                             IPSEN

                  2218915  Decapeptyl SR INJ 3MG  4  £276.00   20.00%   £55.20
                  3020534  Decapeptyl SR INJ 11.25MG  6  £1,242.00  20.00%  £248.40
                  3585536  Decapeptyl SR INJ 22.5MG  4  £1,656.00  20.00%  £331.20
                  Product Scheme Total          14   £3,174.00          £634.80
                  Happy days, I can see the discounts and the rebates received.





              Let’s look at another example where alarm bells should be ringing.
              First the Sales by Supplier report:

                                   ASPIRE PHARMA LTD (ETHICAL)

               3941754  BIQUELLE XL 50MG T QUETIAPINE XL  60  9  £265.05  £53.01  £318.06
               3941770  BIQUELLE XL 200MG T QUETIAPINE XL  60  3  £148.35  £29.67  £178.02
               3941796  BIQUELLE XL 300MG T QUETIAPINE XL  60  9  £670.05  £134.01  £804.06
               4175410  BIQUELLE XL TABS 200MG        30   9    £222.57  £44.51  £267.08
               1179605  GATALIN XL CAPS 8MG           28   6   £155.64   £31.13  £186.77
               1179621  GATALIN XL CAPS 24MG          28   6   £239.40   £47.88  £287.28
               1180181  NEDITOL XL CAPS 4MG           28   9    £116.01  £23.20  £139.21
               1173319  REPINEX XL TABS 2MG           28   6    £37.20   £7.44   £44.64
               1174135  REPINEX XL TABS 4MG           28   5    £62.50   £12.50  £75.00
               1174143  REPINEX XL TABS 8MG           28   6   £126.00   £25.20  £151.20
               Supplier Total                              68  £2,042.77  £408.55  £2,451.32



                    Now the MDS Discount report for the same supplier:
                                                        ASPIRE PHARMA

                     3941754       BIQUELLE XL 50MG T QUETIAPINE XL 60     9    £265.05   20.00%     £0.00
                     3941770       BIQUELLE XL 200MG T QUETIAPINE XL 60    3    £148.35   20.00%     £0.00
                     3941796       BIQUELLE XL 300MG T QUETIAPINE XL 60    9    £670.05   20.00%     £0.00
                     4175410       BIQUELLE XL TABS 200MG 30               9    £222.57   20.00%     £0.00
                     1179605       GATALIN XL CAPS 8MG 28                  6    £155.64   25.00%     £0.00
                     1179621       GATALIN XL CAPS 24MG 28                 6    £239.40   25.00%     £49.88
                     1180181       NEDITOL XL CAPS 4MG 28                  9    £116.01   20.00%     £12.89
                     1173319       REPINEX XL TABS 2MG 28                  6     £37.20   25.00%     £0.00
                     1174135       REPINEX XL TABS 4MG 28                  5    £62.50    25.00%     £0.00
                     1174143       REPINEX XL TABS 8MG 28                  6    £126.00   25.00%     £0.00
                     Product Scheme Total                                  68   £2,042.77            £62.77




              18     PS Magazine | Keeping a check on your discounts                       Buy direct online at PSUK.co.uk



                                                                                                                 09/07/2024   10:30:37
         P4304.1-V100_PS Magazine - August 24.indd   18
         P4304.1-V100_PS Magazine - August 24.indd   18                                                          09/07/2024   10:30:37
   13   14   15   16   17   18   19   20   21   22   23