Inventory Management

 

To provide superior inventory management by optimizing stocking levels for excellent customer service and profit maximization.

 

The Value of Inventory

•  Effective control of supply and demand
•  Powerful queries include history and graphics
•  Flexible pricing and costing options
•  Replenishment rules by item
•  Identify key suppliers of items
•  Specify approved manufacturers
•  Extensive serial tracking with expiration dates
•  Available to Promise calculation feature

Matching Inventory to your business

• Cost method defined per warehouse (average, standard, last, LIFO, or FIFO)
• Retain cost in unit of measure other than stocking
• Powerful pricing options (quantity, discounted, contract pricing, and more)
• Globally change cost and selling prices
• Track transfers between warehouses
• Order policies and order modifiers defined at warehouse level
• Multiple bin locations specified per warehouse
• Multiple units of measure per item
• Optional two-phased receiving
• Backflush items with short manufacturing cycles
• Lead times and dock-to-stock for realistic time-phasing
• Record notes per item for purchasing, sales and manufacturing, including technical specs and dangerous goods handling
• Place stock codes on hold
• Robust physical inventory system
• Cross-reference supplier and customer stock codes
• Assign same serial number to multiple items
• Browse stock items using multimedia images
• Group inventory items into sales kits
• Calculate minimum quantity based on usage
• Facilitate bar code integration
• Extensive security options for maintaining Inventory information

Inventory families and groupings g

 

Objective

 

To provide the tools to arrange ‘collections’ of SKUs (stock keeping units) into families of products and groupings of like items. These collections provide a high-level view of items at which sales forecasts can be produced and the quality of the forecast can be measured. A significant feature is the ability to group warehouses for purposes of forecasting at a regional or territory level for Logistical or Supply Chain purposes. This also enables forecasts to be generated at a brand level to facilitate a clearer Marketing picture.

 

The Value of Inventory Families and Groupings

• Establish families or groupings of SKUs using SYSPRO’s unique ‘Collections’ capability with hierarchical structures for Brand or Product Type views
• Consolidate SKUs with different pack sizes using an alternate common unit of measure
• Forecast at regional or territory level by consolidating warehouses for logistical or Supply Chain purposes
• Aggregate sales history of the collection members to enable a forecast at collection level and then disaggregate collection forecast back to SKU level
• Facility to edit history at collection level
• Variety of forecasting algorithms including a competition method which automatically selects the best algorithm for the collection
• Forecast using sales value, cost value, quantity or gross profit as the basis
• Set default algorithms at company or collection level
• Detect seasonality and apply forecasts to seasonal data with trending if present
• Manually or automatically remove outliers and anomalies
• Use SKU history of three or more years
• Utilize monthly or weekly time buckets
• Determine forecast horizon up to 24 months
• Improve visibility with graphical output
• Edit suggested forecast to reflect market intelligence

Matching Inventory Families and Groupings to your business

• Very powerful Pareto (ABC) Analysis provides ranking of the items within each collection
• Generate and review forecasts at various levels in the family hierarchy (grandfather, father, child)
• Multi-level analysis of family performance over time
• Analyze sales value, gross profit, cost of sales, quantity sold or hits (invoice line occurrences) using very functional Pareto capability
• Automatically update collection history in real time
• Compare manual forecast with computer recommended forecast
• Control and validate the forecast before activating