PRODUCT

Modules - PRODUCTS & PRICING

Products

This module defines and maintains Products. Key features:

  • Provides a multi-level (unlimited) Product structure – have as many Categories, Classes, Groups and Sub-Groups as required
  • Allows a number of Attributes per product e.g. style, colour, size, brand, model etc. all user definable
  • Average, last, FIFO and standard cost methods
  • Lot, Serial, and Use By tracking
  • User definable data covering various units of measure, decimal places for cost, selling price and quantity, pack sizes, weights and configuration, alternative products and Suppliers etc
  • Automatically creates inventory items from Product creation

As can be seen above, apart from Category (ABC Manufactured Products), Class (Shirts) and Group (Mens Shirts), there are three Sub Groups. Uniquely, more Sub Groups could be accommodated if required.

Additionally, Attributes such as Brand, Style, Colour, Sleeve length, and Size can be accommodated.

Attributes enable product searches to be undertaken with limited product knowledge and training. In the above example a Casal blue T-Shirt with short sleeves in size 16 can be located without any product code knowledge.

Additionally, monitor and track sales without the need to do additional work via spreadsheets etc as can be seen in this example:

The use of Attributes provides an instant analysis of sales for Mens Shirts in Australia:

  • 100% of sales were Classic Brand
  • 98% were Polo Style
  • 47% were Sleeveless
  • 43% were Blue
  • Sizes sold showed an even pattern

The Attributes provide a better understanding of which products are selling.

Combine the structures and attributes with online inventory ABCD/Ranking (refer Inventory below), and you have the ability to manage complex inventory requirements and better manage inventory levels and mix.

Prices

This module provides for the creation and maintenance of Price Lists. Key features are:

  • Unlimited Price lists
  • Unlimited Discount groups and Quantity Price breaks
  • Unlimited number of special and promotional Price Lists
  • Specify start and end date per Price List
  • Include only Customers and/or Products required on each Price List
  • Multi currency
  • Print and email Price Lists

From this one form create and manage all Price Lists.

Inventory

The Inventory module maintains ABCD classifications, rankings, and tracks inventory by location and bin within each location. Key features are:

  • Inventory position by summary, location and warehouse by Attribute
  • Sales and Purchase Order links and lookup
  • History tracking and inquiry by Lot No., Serial No. and Use By Date
  • Inventory position both current and forward based on known Sales, Purchase, and Work Order dates
  • Stock take facilities for cyclical and full counts
  • Bills of material - unlimited levels
  • Movements tracking and enquiry

As can be seen here, the ability to view and drill down on inventory movements is extensive, and selection options include:

  • Location
  • Customer
  • Supplier
  • Some or all types of receipts
  • Some or all types of issues
  • Other including revaluations, cost rate and stocktake adjustments, bin transfers, and imported cost
  • Period or date range, and
  • Specific movement numbers

Shed light on your inventory with an instant display of all or selected inventory Classes. It allows you to focus on your best lines and develop action plans for slow moving and/or discontinued items.

Inventory items can be ranked by sales value or quantity sold, and stock turns and months cover on hand for each inventory is calculated.

Drill down to analyse detailed position on any item including sales rate, outstanding sales orders, stocking by location and much more.

Forecasting

This module is used to enter and maintain Forecasts. Key features are:

  • Provides for the creation of annual Budgets and Forecasts together with short term Forecasts (one month or more)
  • Uses historical sales levels and patterns to produce suggested Forecasts which can be altered for anticipated volume, sales price and cost movements on a monthly basis
  • Forecasts by Area by Product by Attribute
  • Updates Sales Analysis and General Ledger
  • Forecasts are used in Production Planning, MRP and Inventory control

Take away the majority of the grunt work in producing Budgets and Forecasts. Let the system do first pass numbers based on historical sales levels and patterns and compare it to the previous two corresponding financial years for sales value, quantity and margin.

Simply apply your market knowledge to amend any of sales value, quantity and/or margin for any period (month) to incorporate known or expected changes.

Once you are satisfied save it and the system will update sales budgets and General Ledger budgets.

Use the budget or forecast for inventory management in production planning and inventory ordering.

The following INSIGHT Modules are also available:

   
 
Copyright © Insight IMS 2007
Insight IMS Insight IMS