Star Computers Limited > Microsoft Dynamics NAV

Inventory Optimisation

Benefits

Lower inventory
Higher service levels
Reduced workload
Increased overview
Reduction in transportation costs

The AGR Inventory Optimiser is a sophisticated inventory planning and forecasting solution fully integrated with Microsoft Navision and specially designed for operations in retail, wholesale, distribution and manufacturing.

It has the flexibility to fit any supply chain network from single location wholesalers to international retailers with multiple distribution centres and stores.

Taking raw data directly from Microsoft Navision, the AGR Inventory Optimiser presents a graphical view of historic sales, inventory levels and shortages, and utilises a powerful expert system to select the most suitable forecasting method in each instance, taking into account historic sales, seasonal fluctuations, customer and sales force input along with inclusion of events to manage any applicable promotions and so forth.

The forecasting methods employed are:-

Exponential Smoothing – covers a wide range of data characteristics

Simple Methods – for short or volatile data

Curve Fitting – identifies the general form of the curve the data is following

Low Volume Models – for low volume and/or sparse data

Box-Jenkins – for stable data-sets.

The system also provides safety stock calculations taking into account variations in sales during prevailing lead times.
Purchasing recommendations are based on:-

Sales forecasts with safety stocks

Order frequency

Delivery Time

Inventory

Undelivered orders

Minimum order quantities

Additional Modules

Manage by Exception - generates user-defined exception reports listing items needing special attention such as potential stockouts, late deliveries, high forecasting errors, slow movers etc.

Simulator – can answer various ‘what if’ questions to evaluate the impact of changed preconditions in the supply chain such as lead times, service levels, minimum order quantities and so forth.

Improved Inventory Management Whitepaper (Download pdf - 100k)

Click to enlarge

The item master shows detailed information on the chosen item. It gives a graphical overview of historical inventory development and sales figures while showing future forecasts and projected inventory levels. It gives a graphical overview of historical inventory development and sales figures while showing future forecasts and projected inventory levels.

Click to enlarge

Order proposals. The buyer reviews order proposals before sending them to the ERP system. The Item Master is updated automatically according to the item number that is being reviewed, showing historical sales, inventory levels and forecasts and enabling the purchaser to obtain a good overview of the past and future situations before making a final decision on how much of each item to order, as is shown in the picture above.

Click to enlarge

Management overview enables managers to evaluate the performance of various factors in the inventory system, such as stock value development, turnover, or turnover ratios for products, groups or locations, allowing them to closely monitor the performance of the system.

Click to enlarge

Stock by location. Inventory levels can be viewed graphically by location, either in units or days.

Click to enlarge

Manage By Exceptions. User can define custom reports to identify items that need special attention. The picture above shows all items with a potential stockout situation.

Click to enlarge

Simulator enables users among other things to evaluate what impact changes in buying preconditions will have on stock levels.

Microsoft Dynamics NAV

The AGR Inventory Optimiser is a sophisticated inventory planning and forecasting solution fully integrated with Microsoft Navision and specially designed for operations in retail, wholesale, distribution and manufacturing.

Additional Modules

Microsoft Dynamics NAV > Inventory Optimisation