Compare forecast values from the past twelve months to the historic sales values during the same period. Forecasts and customer order values for the next twelve months on these manual items are also detailed. This report is useful for marking up new forecasts and then capturing the values in our Forecast Viewer.

Compare forecasts to sales during the particular time period, as well as the forecasts for the next twelve months. The data is grouped by stocked and non-stocked items and priority and non-priority items.

Calculate the standard deviation for the last twelve months of historical sales. All items with a standard deviation above the figure entered in the input parameter are returned. The report data is sorted in descending order of the average monthly value of forecasted demand, so that products above the minimum standard deviation entered with the highest forecasted demand are at the top of the list.

Highlight items that are selling at less than targeted profit margins as well as month-to-month sales trends. The report displays the lost sales and actual sales turnover and profit for the past four months. Profit is calculated as the difference between cost and selling price.

Determine if purchases exceed sales and analyze purchase volumes from suppliers whose buying strength and negotiating power is measurable. If purchases exceed sales, investigate into the sales disproportion and determine increased supplier advertising and possible inventory returns could be negotiated.

Highlight the exposure to lost sales caused by overdue supplier orders. This report displays the details of supplier orders by item, including the order number and the amount of days late. Use the Item and Supplier Lead Time Managers to assess the Supplier performance.

See which orders exceed recommended order quantities. This report displays stock information, history, forecast, supplier and customer information. It may be beneficial to cancel or partially cancel surplus orders because of excess inventory costs. However, some surplus orders may be justified by the size of the rebate accompanying the order or other benefits.

Determine which suppliers contribute to the most turnover. This report analyzes supplier sales and unit volume contribution.

A high number of contributing suppliers above the 80% contribution mark could mean the business has less dependency on any single supplier. Distribution may be a concern because the chance of excess stock is greater with a larger range of items to manage.

When only a few Suppliers make up the 80% category, service levels from those suppliers are more important.

Highlight exposure to lost sales because of failure to meet promised delivery dates. This report displays customer orders that are currently overdue.

See all items facing potential stock-outs (within the supplier lead time) and the existing supplier orders of those items. This report includes stock, policy, stock holding information and existing supplier orders information of potential stock-outs within the supplier lead time. An item is considered potential stock-out when there is danger of having no stock within a Supplier lead time.

When budget and cash flow constraints make it impossible to address all the potential stock outs, prioritize higher Pareto categories for replenishment. Purchase orders shown here will also appear on the Expedite Orders Report and additional replenishment on the Ordering report.

See all items facing potential stock-outs (within the supplier lead time) which have no existing supplier orders to be expedited. This report includes stock policy and stock holding information of these items.

Review recommended order quantity, stock information, historical sales and forecasted demand. This report is a printable version of information available in Replenishment modules. Use Direct Supplier Orders and Supplier Orders and/or the Upload Manager modules to make changes to and upload orders to the transaction system.

In some industries it is helpful to add sales variability to revenue contribution when prioritizing items. 80% of revenues often come from less than 20% of a company’s product lines so focusing on high revenue items could cover a lot of the business. Variability measures the accuracy of the sales forecast. Items can be categorized according to a combination of variability and revenue contribution.

JustEnough uses this type of analysis to establish priorities for your inventory. Classifications include:

AX – High sales, high variability
AY – High sales, medium variability
AZ – High sales, low variability
BX – Medium sales, high variability
BY – Medium sales, medium variability
BZ – Medium sales, low variability
CX – Low sales, high variability
CY – Low sales, medium variability
CZ- Low sales, low variability

Determine decreasing sales trends to allow appropriate response on items with changing sales trends.

In hi-tech industries the decline of an item’s contribution to the business can happen very quickly. Too many supplier orders can lead to overstocking of products that are declining in sales, which could then lead to excess of redundant products. In low-tech industries the decline in contribution is far more gradual, and it is a more obvious trend. This analysis could then be used to suggest a stocking status change from stocked to non-stocked.

See details of all items with excess stock i.e. with more than the maximum stock holding required by the policy of each item. It contains stock information, sorted in descending order of excess value.

Review a numerical comparison between the actual and the model stock on hand values, grouped by item priority and item type. The value of the shortfall and excess stock, as well as the amount of stock on order for each, is given as an indication of the state of the stock holding.

In some cases the model value and the actual stock value may be very similar. However, it may be a picture of shortfall and excess inventory that balances out to a healthy looking actual stock but is actually an unhealthy mix. Looking at the days on hand is also an indication of the stocking situation.

The on order figures indicate the future inventory situation. A high excess on order means that excess stock is expected to increase. Shortfall on order, on the other hand, shows that inventory level correction for these items is pending.

See which items most significantly add to turnover. This report compares the cumulative percentages of all items in terms of stock quantity (units), inventory value and sales value. A turning point like 60 or 80% will yield surprisingly fewer items than can usually be guessed.

Highlight excess of bin items by various groupings i.e. age, criticality, movement (sales) and inventory group for identifying problem items that can possibly be defined by these groupings. It also shows the difference in excess according to an item’s bin level and its order multiple. This is because excess above the order multiple could be considered a truer reflection of bin item excess as buyers are compelled to order the items according to order multiples which may not be a multiple of the required bin level.