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 %