IDEA Users Working Remotely: We’re here to help! Please contact our IDEA Help Desk to ensure there is minimal disruption to your daily workflow.

X
Icon


Blog Image

Inventory and Stock

CaseWare IDEA Applications


Inventory and stock can vary in volume and cost within organizations.

 

Analyses

 

  • Reconcile physical counts to computed amounts
  • Analyze usage and ordering to improve turnover
  • Analyze high value transactions
  • Summarize and stratify turnover by stock item
  • Summarize stock on-hand by group, location, type, etc.
  • Create custom reports on stock and high value balances
  • Review product reordering volumes by item, warehouse, and vendor
  • Summarize products by group, location, type, etc.
  • Summarize and stratify turnover by stock item in any order
  • Age inventory (e.g. by date of receipt)

 

Calculations

 

  • Report on products in order of profitability
  • Statistically analyze usage and ordering to improve turnover
  • Test clerical accuracy of totals and extensions
  • Check product reordering volume by item, warehouse, and vendor
  • Determine the percentage change in sales, price and/or cost levels by product/vendor
  • Assess the financial viability of LIFO versus FIFO management

 

Exception Tests

 

  • Identify surplus obsolete/damaged inventory by sorted turnover analysis
  • Identify differences between standard costs and actual costs
  • Identify stock acquired from group companies
  • Segregate variances from standard pricing in amount order
  • Isolate stock lines/products with cost greater than retail price, with zero/negative quantities,or with zero/negative prices
  • Isolate items where stock exceeds maximum stock levels
  • Select items from perpetual stock for test reconciliation

 

Gaps and Duplicates

 

  • Test for duplicate parts, item numbers, prices or descriptions

 

Matching and Comparing

 

  • Compare yearly volume with on-hand quantity for stock items
  • Compare cost to retail price to look for pricing discrepancies
  • Compare the value of physical counts to General Ledger value

 

Sampling

 

  • Attribute Sampling, Random Sampling or Stratified Random Sampling for physical verification or checking additions

Areas of Applications , CaseWare IDEA



Posted By

By Audimation Team


Related Posts
Applying Fuzzy Logic to Acquire Clear Results
Oct 01 Fuzzy logic techniques are an effective way to normalize data to identify potential matches, duplicates, errors or fraud. Here are some tips and techniques from...
Less Labor When Analyzing Labor Data
Mar 21 What if you could replace two weeks of work each month with a 3-minute process that actually delivered more consistent results? Our Solutions Development team w...
The Field Statistics Primer
Jul 18 Although “Pop Kurtosis” sounds like it could be a music genre from the ’60's, in IDEA it is one of the many statistics automatically calculated on your po...
BROWSER NOT SUPPORTED

This website has been designed for modern browsers. Please update. Update my browser now

×