image_pdfimage_print

Product Analysis allows user to analyse products’ months on hand (M.O.H), average sales and inventory turnover data. Below are available actions for the user from “Product Analysis” :

Samooha icon2  View and search for products’ average sales data

Samooha icon2  View and search for products’ inventory turnover

Samooha icon2  Print products’ analysis reports

Product Analysis

 Product Analysis – M.O.H (Months On Hand) Analysis Field Names
Field Name
Explanation
Mandatory Information
Product Brand Select a product brand or select all to view

Y

Product Group Self-Explanatory

N

Fiscal Year Self-Explanatory

Y

From Self-Explanatory

N

Till Self-Explanatory

N

Warehouse Self-Explanatory

Y

Day / Week / Month Select option to view period of on hand quantity

Y

Product # Self-Explanatory

Y

Product Name Self-Explanatory

Y

Barcode Self-Explanatory

Y

On Hand Qty Self-Explanatory

Y

Avg. Monthly Sales Self-Explanatory

Y

Days / Weeks / Months On Hand Qty Show products’ inventory quantity on hand by days / weeks / months view

Y

 

Product Analysis1

 Product Analysis – Inventory Turnover Field Names
Field Name
Explanation
Mandatory Information
Product Brand Select a product brand or select all to view

Y

Product Group Self-Explanatory

N

Fiscal Year Self-Explanatory

Y

From Self-Explanatory

Y

Till Self-Explanatory

Y

Warehouse Self-Explanatory

Y

Type Select to view data by quantity or value

Y

Product # Self-Explanatory

Y

Product Name Self-Explanatory

Y

Avg Stock Value Self-Explanatory

Y

Total Cost Self-Explanatory

Y

Turnover Value Self-Explanatory

Y

Value Ratio to Avg Self-Explanatory

Y

Value Avg Type Self-Explanatory

Y

Show Select an option to view inventory turnover data by its value average type

Y

 

View and Search for Products’ Average Sales Data:

1. On “M.O.H Analysis” tab select a product brand from “Product Brand” drop-down list at the top of screen, user able to view all brands by choosing “Select All“. It will pull up the selected products’ average sales data

2. Select a product group in “Product Group” drop-down list to further filter the products’ average sales data

3. Enter year, from date and till date to further filter the product’s average sales data

4. Select a warehouse from “Warehouse” drop-down list at the top of screen to filter the result. User able to choose “Select All Warehouse” as well

5. Select Day, Week, or Month view for products’ on hand quantity

  • Days on Hand Qty = On Hand Qty / Avg. Monthly Sales * 30
  • Weeks on Hand Qty = On Hand Qty / Avg. Monthly Sales * 7
  • Months on Hand Qty = On Hand Qty / Avg. Monthly Sales

Product Analysis2

6. Enter search parameter to filter the result, i.e. type in the product number in the search textfield box at the bottom of the screen.

Product Analysis3

7. Right-click on a product row, a small pop-up pane will appear with the following options:

  • Show Product Details
  • Show Product Register
  • Show Product Ageing Register

 

View and Search for Products’ Inventory Turnover:

1. On “Inventory Turnover” tab select a product brand from “Product Brand” drop-down list at the top of screen, user able to view all brands by choosing “Select All“. It will pull up the selected products’ inventory turnover data

2. Select a product group in “Product Group” drop-down list to further filter the products’ inventory turnover data

3. Enter year, from date and till date to further filter the product’s inventory turnover data

4. Select a warehouse from “Warehouse” drop-down list at the top of screen to filter the result.

5. Select to view inventory turnover data by quantity or value data from “Type” drop-down list at top right of screen

Product Analysis4

6. Enter search parameter to filter the result, i.e. type in the product number in the search textfield box at the bottom of the screen.

Product Analysis5

7. User can filter the product’s inventory turnover data to show only “Fast Moving“, “Low Moving“, or “Slow Moving

Note: Products’ Average values are set in Organization – (Settings) Default Settings for Inventory module

Product Analysis6

8. Right-click on a product row, a small pop-up pane will appear with the following options:

  • Show Product Details
  • Show Product Register
  • Show Product Ageing Register

 

Print Products’ Analysis Reports:

1. For products’ average sales report, on “M.O.H Analysis” tab select a product brand from “Product Brand” drop-down list at the top of screen, user able to view all brands by choosing “Select All“. It will pull up the selected products’ average sales data.

For products’ inventory turnover report, on “Inventory Turnover” tab select a product brand from “Product Brand” drop-down list at the top of screen, user able to view all brands by choosing “Select All“. It will pull up the selected products’ inventory turnover data.

2. Click on “Print” button at bottom of screen, a window will come up showing print report options.

3. User can print report, export the report as pdf or excel, or preview the report

Product Analysis7