4Reports and Inquiry
Option 11Inventory Value Report
This report shows the total inventory value, computed by multiplying the average cost of each product and the quantity on hand in each warehouse.
Here is a sample Inventory Value Report:
Expert Distributing, Inc.
05/23/91 04:36 pm KAY Page: 1
Inventory Value Report
Adjusted
Product Description Unit Avg Cost Wh Description On Hand Total Cost
==================================================================================================================================
Product Class
20 #4 12" Gold Plated Black Round Each 0.000 00 0.00 0.00
---------- -----------
-- Product Subtotals --> 0.00 0.00
========== ===========
---------- -----------
-- Product Class Subtotals --> 0.00 0.00
========== ===========
Product Class 10 Standard
10 #10 3-1/2" White Round Each 34.913 10 Main Facility 400.00 13965.00
0.000 99 Drop Ship Warehouse 1.00 0.00
---------- -----------
-- Product Subtotals --> 401.00 13965.00
========== ===========
40 #58 10" Yellow Cylinder Each 19.637 20 South End Facility 277.00 5439.45
---------- -----------
-- Product Subtotals --> 277.00 5439.45
========== ===========
---------- -----------
-- Product Class Subtotals --> 678.00 19404.45
========== ===========
Product Class 20 Special Order
10 #10 3-1/2" White Round Each 16.146 20 South End Facility 892.00 14402.50
---------- -----------
-- Product Subtotals --> 892.00 14402.50
========== ===========
30 #56 10" Red Cylinder Each 11.591 20 South End Facility 634.00 7348.73
---------- -----------
-- Product Subtotals --> 634.00 7348.73
========== ===========
40 #58 10" Yellow Cylinder Each 4.651 30 North End Facility 306.00 1423.20
---------- -----------
-- Product Subtotals --> 306.00 1423.20
========== ===========
---------- -----------
-- Product Class Subtotals --> 1832.00 23174.43
========== ===========