ION Report - Inventory Valuation

Select Update Remove

Inventory Valuation

This report values the products in a warehouse based on the costing method for that product and then assigns a rank for that product. The ranks correlate to the percentage value of that product to the company's overall inventory. The inventory valuation report was designed around white papers written by Jon Schreibfeder, president of Effective Inventory Management Inc.

This report values the inventory in the warehouses and in the trucks. If FIFO is installed than eoStar will use the day's FIFO average, otherwise the value is assigned based on the costing method assigned to the product on the Records>Product>Records More Panel. If a product is checked to use manual cost, then the manual cost is used for this valuation report. Only Delivered purchases are scanned.

If the product is checked to use autocost, then the following is true when computing the value of the item on this report:

• The autocost is only updated when a purchase has been fully billed.
• The autocost includes all cost components that have been prorated to the item level.
• This report will calculate ION based on the purchases prior to the report date. So, if autocost is set to use the last three purchases, then this report uses the last three purchases prior to the report date.
• Receipts with a unit cost of zero or a quantity of less than zero (returns) are not considered when calculating the autocost.

Once the items are valued, they are ranked into 5 groups:

• A – Top 80% of the value of your inventory
• B – Next 15% of the value of your inventory
• C – Next 4 % of the value of your inventory
• D – Last 1% of the value of your inventory
• X – No Value

In order for employees to access this screen, the "May Access Inventory Valuation Report" checkbox on the Plugins Panel must be checked.

In July 2009, changes were made so that all inventory reports now include empties, even if an empty is assigned to a product category and that category is flagged to be omitted from ION sales reports.

In July 2009, changes were made to now make it possible to group, sort, and filter, on any of the columns and there are now some footer totals. The previously available columns for AccumulatedValuation and AccumulatedPct are now suppressed.

For a complete list of all available ION Reports, see Overview: ION Reports.

How-To Create an Inventory Valuation Report

1. Select Inventory Valuation off the Reports panel.
2. Select the warehouses off the Warehouses panel. If only a single warehouse is chosen, then only inventory in that warehouse and its associated trucks will be counted.
3. Select a Cutoff date off the Date Selection panel. This report only needs a single cutoff date.
4. Using the drop down arrow, bring up the Product Include or Exclude screen to select the products for the report. If the report is filtered to show only certain products, then the ranking will be based on only the selected records, not on all items.

Inventory Valuation Data

The information shown here correlates to the information chosen.

Basic columns:

• Item# - This column contains the product numbers.
• Item - This column contains the product names.
• Level - This is the level of inventory available in the selected warehouses, trucks, freight, x freight, and pallets.
• Cost - This is the cost of the products based on the costing method that the database is using. (FIFO, Manual Cost, or Auto Cost)
• Valuation - Essentially, this column is the level multiplied by the average cost.
• Whse Level- This column contains the warehouse inventory levels
• Truck Level- This column contains the truck inventory levels
• Freight - This is the estimated freight of the the products.
• XFreight - This is the accumulated total of freight.
• Excise Tax - This column contains the excise tax.
• XExcise Tax - This column contains the accumulated excise tax.
• Pallets - The number of pallets.
• Rank - This is the rank of the product based on the valuation. (These are the rankings as determined in the white papers.)

Laid-in Cost Fields

Added October 2011, this checkbox offers the ability to view laid-in costs of products. The columns include:

• FOB
• SPA
• Freight (LIC)
• Excise Tax (LIC)
• Deposit (LIC)
• Fuel Surcharge (Cost Component)
• Dunnage (Cost Component)
• Marketing Fee (Cost Component)
• Broker's Fee (Cost Component
• Drop Ship Charge (Cost Component)

Graph of Data

This graph is typically a pie chart that shows the percentage of the value of each product as compared to the whole.