Comparison analysis widget

The Comparison analysis widget displays the changes in Recommended value and Recommended service level if recommendations are applied.

Clicking the widget presents the Comparison of reorder level settings window.

The Comparison tab displays a comparison of the performance of the current Host System settings and the MIO recommendations. This calculation can be performed on the item currently being displayed or all tagged items on the grid.

The table has five columns of values:

Annualised historical actuals is an annual averaged value for data from over the last two years of actual historical usage.

Current recorder levels (Annual projection) is the expected values for the list of features based on the current Host system stocking levels.

Recommended is based on annual projections. It is the expected values for the list of features based on MIO recommended stocking levels.

Difference is the difference between the Current and Recommended values for each row.

Change is the difference as a percentage.

The differences and changes in Current and Recommended levels is calculated and presented.

The data that is displayed is read-only and is presented for observation and analysis.

Table 1. Comparison analysis values
Row Definition Annualised Current Recommended
Safety stock value Safety stock value No value given Based on current reorder levels Based on recommended reorder levels
Stock value Average stock value Based on average stock on hand Based on current reorder levels Based on recommended reorder levels
Turnover A measure of how many times in a specific period a company is able to replace the inventories Based on last years usage and the average stock on hand Based on forecasted yearly usage and the current average stock level for the current reorder levels Based on forecasted yearly usage and the recommended average stock level for the recommended reorder levels
Service level The expected probability of meeting a demand Last years on time issues percentage Based on the current reorder levels Based on the recommended reorder levels
Annual orders Number of purchase orders expected over a year Last years actual purchase order count Based on the expected number of orders for the current reorder levels Based on the expected number of orders for the recommended reorder levels
Annual holding costs The cost of holding stock over a year Based on average stock on hand Based on the average stock holding for the current reorder levels Based on the average stock holding for the recommended reorder levels
Annual replenishment costs The costs of purchasing stock over a year Cost of replenishment for last years purchased order count Cost of replenishment for the expected number of orders for the current reorder levels Cost of replenishment for the expected number of orders for the recommended reorder levels
Annual stock out costs The cost of possible stock outs through the year No value given Based on the current reorder levels Based on the recommended reorder levels
Total annual costs The summed costs of all Annual stock out costs for the stocking level No value given Holding cost + replenishment cost + Annual stock out costs for the current stocking levels Holding cost + replenishment cost + Annual stock out costs for the recommended stocking levels
Issues Per year The count of actual issues for a year Actual issues averaged over the last 2 years No value given No value given
Transfers per year The count of actual transfers for the year Actual transfers averaged over the last 2 years No value given No value given
Consumption value The value of stock issued over the year Actual issue value averaged over the last 2 years No value given No value given