[Watch Video] Webinar: Excess & Obsolete Inventory Analyzer

Do you have inventory bloat from supply chain problems? Do you need a way to calculate an accurate value of your existing inventory based on recent usage and current demand?

Our IDF-based functions can import into your environment and provide an audit trail for utility, usage, and customer demand down to the component level – helping you find excess & obsolete items and help identify the planning  Read more...practices that might have contributed to the problem.

Speaker Name: Kevin Gerard, Solution Architect

Bio: I have been in I.T. about 4 decades, and worked with Mapics and Infor/XA during that time in a variety of rolls, including development, project lead, I.T. Management and now a Solution Architect with TriMin. For the last 20 years my focus has been all the new development tools from Infor and IDF including heavy use of Enterprise Integrator, System Link, and other functional components.

I help our customers deploy XA and promote the new technology to solve business problems and also fill gaps where standard XA does not solve. My focus is supply chain, planning, inventory management, procurement and shipping. I also have extensive experience with Xalt (Catavolt) technology and deploying mobile apps over XA

Overview

TriMin’s E&O Analyzer provides an easy way to calculate and estimate the value of your inventory including surplus, excess and obsolete. It gives you complete visibility to where the product is used, including what customer(s) will consume the existing inventory based on open XA orders.

The E&O Analyzer “allocates” inventory based on time-phased demand to determine what will be consumed. Inventory is allocated from the top down, so sub-assemblies are also used if in stock. The order backlog is reviewed based on user defined periods.

The result is a summary of each item on-hand, showing both current and future allocation, and identifies the remaining products that have no planned usage or chance of being used based on current demand and sales history.

Features

- Aging buckets configurable by the user (orders due 6 months out, a year, etc.)
- Extract sales summary and tag the item(s) based on which customer used it, not just the top level but component level.
- Provides a clean, formatted view of each end-item bill, showing the inventory on- hand that will be consumed to build the product.
- Can be exported to Excel or consumed by BI tools such as BIRST.
- Written in modern SQLRPGLE, the E&O Analyzer creates audit trails that can be data mined as well as logs errors for easy trouble shooting.
- Customizable over time, by you or TriMin.

Business Needs

- Logically calculate inventory reserves that can be audited.
- Repeatable at any time (once a month).
- Ability to know how much inventory on-hand will be consumed based on a time-phased backlog.
- Can feed KPI's and other metrics to track inventory stocking levels and assist with cash flow.
- Need to identify slow and no-moving inventory using an intelligent tool that replicates what will be consumed.
- Gives drill down to the indented bills as well as easy identification of what customer(s) use the products (top level and components)
- Utilize all the standard features of IDF, including customizable views, filters, and workspaces.

Contact Us Today to Learn More: Sarah.mackay@triminsystems.com

https://youtu.be/5dUKQgIFUn0 Show less...