APPX Software Library

4Reports and Inquiry

Option 24Product Price/Cost Catalog

This catalog lists each product by warehouse and product class and shows the quantities and prices by quantity break and price break, respectively. The average cost of the product and the percentage markup at each price break are included. The catalog also lists the product’s freight class, stockkeeping unit of measure, items per unit of measure, package size, shipping weight, and ABC class.

Here is a sample Product Price/Cost Catalog:

                                                     Expert Distributing, Inc.
05/24/91 10:49 am                                                                                                  KAY Page:    1
                                                     Product Price/Cost Catalog

Product                                       Unit     ABC                  Qty1        Qty2        Qty3        Qty4        Qty5
Frt Cls  Wh     Items   Ship Wt               Package Size                Price1      Price2      Price3      Price4      Price5
                                              Ave Cost                   Markup1     Markup2     Markup3     Markup4     Markup5
==================================================================================================================================

Product Class
Warehouse

20  #4 12" Gold Plated Black Round            Each                         0.00        0.00        0.00        0.00        0.00
020      00     00001     15.00               2 X 2                        0.000       0.000       0.000       0.000       0.000
                                                 0.000                           %           %           %           %          %


Product Class 10 Standard
Warehouse 10 Main Facility

10  #10 3-1/2" White Round                    Each      A                  1.00       10.00       25.00       50.00      100.00
010      10     00001    100.00               3 X 5                      250.000     245.000     240.000     220.000     200.000
                                                34.913                    86.0   %    85.7   %    85.5   %    84.1   %    82.5  %


Warehouse 20 South End Facility

40  #58 10" Yellow Cylinder                   Each      C                  1.00      100.00        0.00        0.00        0.00
010      20     00001     25.00               3 X 6                       62.000      57.500       0.000       0.000       0.000
                                                19.637                    68.3   %    65.8   %     0.0   %     0.0   %     0.0  %


Warehouse 99 Drop Ship Warehouse

10  #10 3-1/2" White Round                    Each                         1.00       10.00       25.00       50.00      100.00
010      99     00001    100.00               3 X 5                      250.000     245.000     240.000     220.000     200.000
                                                 0.000                           %           %           %           %          %


Product Class 20 Special Order
Warehouse 20 South End Facility

10  #10 3-1/2" White Round                    Each      A                  1.00       10.00       25.00       50.00      100.00
010      20     00001    100.00               3 X 5                      320.000     315.000     310.000     305.000     295.000
                                                16.146                    95.0   %    94.9   %    94.8   %    94.7   %    94.5  %

30  #56 10" Red Cylinder                      Each      A                  1.00       10.00       25.00       50.00      100.00
010      20     00001     25.00               3 X 6                      360.000     355.000     350.000     340.000     320.000
                                                11.591                    96.8   %    96.7   %    96.7   %    96.6   %    96.4  %