4Reports and Inquiry
Option 12Market Value Report
This report shows the total inventory cost (average cost x adjusted on hand quantity) and total inventory market value (price x adjusted on hand quantity).
Here is a sample Market Value Report:
Expert Distributing, Inc.
05/23/91 04:38 pm KAY Page: 1
Market Value Report
Product Description Unit Adjusted
Wh Description Avg Cost Price 1 On Hand Total Cost Market Value
==================================================================================================================================
Product Class
20 #4 12" Gold Plated Black Round Each
00 0.000 0.000 0.00 0.00 0.00
---------- ----------- -----------
-- Product Subtotals --> 0.00 0.00 0.00
========== =========== ===========
---------- ----------- -----------
-- Product Class Subtotals --> 0.00 0.00 0.00
========== =========== ===========
Product Class 10 Standard
10 #10 3-1/2" White Round Each
10 Main Facility 34.913 250.000 400.00 13964.00 100000.00
99 Drop Ship Warehouse 0.000 250.000 1.00 0.00 250.00
---------- ----------- -----------
-- Product Subtotals --> 401.00 13964.00 100250.00
========== =========== ===========
40 #58 10" Yellow Cylinder Each
20 South End Facility 19.637 62.000 277.00 5440.28 17174.00
---------- ----------- -----------
-- Product Subtotals --> 277.00 5440.28 17174.00
========== =========== ===========
---------- ----------- -----------
-- Product Class Subtotals --> 678.00 19404.28 117424.00
========== =========== ===========
Product Class 20 Special Order
10 #10 3-1/2" White Round Each
20 South End Facility 16.146 320.000 892.00 14405.80 285440.00
---------- ----------- -----------
-- Product Subtotals --> 892.00 14405.80 285440.00
========== =========== ===========
30 #56 10" Red Cylinder Each
20 South End Facility 11.591 360.000 634.00 7348.06 228240.00
---------- ----------- -----------
-- Product Subtotals --> 634.00 7348.06 228240.00
========== =========== ===========
40 #58 10" Yellow Cylinder Each
30 North End Facility 4.651 79.000 306.00 1422.90 24174.00
---------- ----------- -----------
-- Product Subtotals --> 306.00 1422.90 24174.00
========== =========== ===========
---------- ----------- -----------
-- Product Class Subtotals --> 1832.00 23176.76 537854.00
========== =========== ===========