Coverage Report - Future Estimation

This report allows you to view the coverage report of the items based on future estimation. Report Information.

Select the “Coverage Report – Future Estimation” link under the “INVReports” business component.

The “Coverage Report – Future Estimation” page appears.

Enter the following field details in the “Search Criteria” group box:

Coverage Report For

Use the drop-down list box to select the level at which you want to view the coverage report. The options available in the drop-down list box are “Warehouse”, “OU” and “BU”. The system displays “OU” as the default value on launch of the page.

Note: Warehouse code is selected only if Warehouse option is selected.

Warehouse Code

Use the drop-down list box to select the warehouse code. The system retrieves all the warehouses applicable for the login OU in ascending order with the first value as the default value on launch of the page.

Enter the following detail:

Coverage Days

Use the drop-down list box to select whether the coverage report you want to view is less than, equal to or greater than the coverage days you specify in the text box. The system displays blank as the default value on launch of the page, which mean that all the items will be listed independent of coverage days as a filter. If the coverage day’s chosen is not blank then the value entered must be greater than or equal to zero.

Demand Status To Consider

Use the drop-down list box to select the demand status to be considered. The options available are “Firm”, “Plan” and “All”. The system displays “All” as the default value on launch of the page.

Plan – indicates that only plan status demands available in disposition for the item variant for the warehouse will be considered for demand qty calculation.
Firm – indicates that only firm status demands available in disposition for the item variant for the warehouse will be considered for demand qty calculation.
All – indicates that both plan and firm status demands available in disposition for the item variant for the warehouse will considered for demand qty calculation

Item Selection Options

Use the drop-down list box to select whether the items for which you want to view the coverage report is based on “Item Type”, “Item Group” or “Item Category”. The system displays “Item Type” as the default value on launch of the page.

Note: Item Group Code is selected only if “Item Group” is selected in Item Selection Options drop-down.

Item Group Code

Use the drop-down list box to select the Item Group Code. The system retrieves all the active Item group in which Items are attached to it in the ascending order. The first value in the drop-down list box is displayed as the default value on launch of the page.

The system displays the following detail:

Item Group Desc.

The description of the Item Group Code.

Note: Item Category Code is selected only if “Item Category” option is selected in the “Item Selection Options” drop-down.

Item Category Code

Use the drop-down list box to select the item category code.

The system displays the following detail:

Item Category Desc.

The description of the Item Category Code.

Note: Item Type Selection is selected only if “Item Type” option is selected in the “Item Selection Options” drop-down.

Enter the following detail:

All Item Types

Check this box if you want to select all the item types specified in the “Item Type Selection” group box. This field is checked by default on launch of the page.

Enter the following in “Item Type Selection” group box:

Raw Material	Check this box to view “Coverage Report – Future Estimation” for item type “Raw Material” alone.
Intermediate	Check this box to view “Coverage Report – Future Estimation” for item type “Intermediate” alone.
Utility	Check this box to view “Coverage Report – Future Estimation” for item type “Utility” alone.
Finished Product	Check this box to view “Coverage Report – Future Estimation” for item type “Finished Product” alone.
Spare Part	Check this box to view “Coverage Report – Future Estimation” for item type “Spare Part” alone.
Pack	Check this box to view “Coverage Report – Future Estimation” for item type “Pack” alone.
Component	Check this box to view “Coverage Report – Future Estimation” for item type “Component” alone.
Tool	Check this box to view “Coverage Report – Future Estimation” for item type “Tool” alone.
Scrap	Check this box to view “Coverage Report – Future Estimation” for item type “Scrap” alone.
Consumable	Check this box to view “Coverage Report – Future Estimation” for item type “Consumable” alone.
Phantom	Check this box to view “Coverage Report – Future Estimation” for item type “Phantom” alone.
Sundry	Check this box to view “Coverage Report – Future Estimation” for item type “Sundry” alone.

Enter the following details in “Item Selection” group box:

Item Code From	The starting range of item code (Alphanumeric, 32).
Item Code To	The ending range of item code (Alphanumeric, 32).
Variant Code	The code identifying the variant of an item (Alphanumeric, 8).
Item Variant Desc.	The description of the item variant (Alphanumeric, 150).

Enter the following details in Date Selection group box:

Date Selection Option

Use the drop-down list box to select the date selection option. The options available in the drop-down list box are “Any Date”, “Fin Period” and “Fin Year”. The system displays “Any Date” as the default value on launch of the page.

Note: “Financial year” is specified only if “Fin Year” option is selected in the Date Selection Option field.

Financial Year

Use the drop-down list box to select the financial year. The system retrieves all the financial years defined for the company from the “Accounting Setup” component. The financial year retrieved must be on or before the system date. The values are populated in ascending order with first value as the default value. The system populates the starting date and end date of the financial year in the date from and date to fields.

Note: “Financial Period” is specified only if “Fin Period” option is selected in the Date Selection Option field.

Financial Period

Use the drop-down list box to select the financial period. The system retrieves the financial periods defined for the financial year selected from the “Accounting Setup” Component. The values are populated in ascending order with first value as the default value. The system populates the starting date and end date of the financial period in the date from and date to fields.

Note: “Date From” and “Date To” are user defined only if “Any Date” options is selected in the Date Selection Option field.

Date From	The starting range of date (Date Format). The date entered in Date From field must be Less than or equal to the Date To field.
Date To	The ending range of date (Date Format). Date To must be greater than or equal to the system date.

Note: The date difference between Date From and Date To is used for calculating the demands.

For viewing the report

Click the “View Report” pushbutton to view the coverage report details.

Coverage Report – Future Estimation – An overview

This report allows you to view the coverage report of the items based on future estimation. This report gives the number of days the stock will be able to cover the requirements for a set of items. The requirements are based on future demands of plan and firm statuses from disposition.

This page allows you to specify the search conditions for viewing the coverage report. You can specify the level at which you want to view the coverage report that is, OU, BU or Warehouse. The Warehouse code must be specified, only if you select the “Warehouse” option.

This page allows you to specify the coverage days for which you want to view the coverage report. You have an option by which you can view the coverage report less than, greater than or equal to the coverage days specified.

You can select whether the demand status to be considered is firm or plan. You can select the Item Selection Options from the drop-down list box. The three options available are “Item Group”, “Item Category” and “Item Type”.

Item Group – You must select a value from the Item Group Code drop-down list box.
Item Category – You must select the Item Category Code, and the corresponding Item Category description will be displayed automatically.
Item Type – You can select one or more or all the types of item for which you want to view the coverage report.

You can also directly specify the range of item codes in the Item Selection group box. A value can be selected for the Date Selection Option, based on which the financial year, financial period, Date From and Date To are specified. The Date From and Date To are manually entered, only if the “Any Date” option is selected, else they are fetched based on the financial year or financial period chosen.

Output For the Report “Coverage Report – Future Estimation”:

Header Information:

It displays the respective BU/OU/Warehouse which was selected in the Entry page. It displays the Date From and Date to fields with specific dates based on the date selection option which was chosen in the report. It also displays the Group code / Group type / Group Category based on the selection in the entry page in the “Item group selection option “. Coverage days which are specified in the entry page will also be displayed at the header. Unique “Report ID “ is also shown

Column Information:

The column fields displayed are Sl. No., Item code, Variant code, Item var desc ( Item Variant Description),Stock UOM, Item type, Stock on Hand, Demand Qty. for the dates, Coverage days, Pending Receipt Qty-Plan & Pending Receipt Qty - Firm

- Item Code, Variant code, Item variant description, Item type and Stock UOM for the respective Items for the BU/OU/Warehouse will be displayed in the respective columns.Only items which are set as “dispositionable” will be considered for this report

- Pending receipt Qty – Plan and Pending receipt qty – Firm will be be retrieved from Dispostion tables and displayed in the respective columns.

Stock on Hand for Items and demand qty for the specified period at Warehouse level:

The “stock quantity” available in a warehouse, which are in Nettable stock statuses for each item – variant, are retrieved and displayed in the Stock on Hand Column
The demand qty for the specified period for the item-variant for the warehouse will be displayed in the demand qty for the dates column . The plan or firm or both status demand qty is taken from the dispostion tables depending on the selection in the entry page

Stock on Hand and Demand Qty. for the specified period at OU level:

The stock quantity available in all the non-capital warehouses for the OU, which are in Nettable stock statuses for each item – variant is retrieved and displayed in the Stock on Hand column.
The demand quantity is summed up for all the non-capital warehouses for the OU to get the demand quantity for the OU for each item – variant and displayed in the Demand Qty. for the dates column. The plan or firm or both status demand qty is taken from the dispostion tables depending on the selection in the entry page

Stock on Hand and Demand Qty. for the specified period at BU level

The stock quantity available in all the non-capital warehouses for the BU, which are in Nettable stock statuses for each item – variant is retrieved and displayed in the Stock on Hand column.

The demand quantity is summed up for all the non-capital warehouses for the BU to get the demand quantity for the BU for each item – variant and displayed in the Demand Qty. for dates column. The plan or firm or both status demand qty is taken from the dispostion tables depending on the selection in the entry page

The system does the following validations at all the three levels to calculate Coverage days :

If the stock on hand is zero then the coverage days will also be zero.
If the stock quantity is not zero and the demand quantity is zero then the coverage days will be infinite which is represented as 99999.
If the stock quantity is less than the demand quantity then the day wise demand is got from disposition. If the stock quantity is more than the first day demand, the coverage day is marked as 1. The stock on hand is updated by reducing the first day’s demand. Similarly, if the stock quantity is more than the second day demand, the coverage day is marked as 2 and the stock on hand is reduced from the second day’s demand. This process is carried out till the stock on hand is less than the demandand the coverage days is calculated.
If the stock quantity is greater than the demand quantity then the Average demand quantity is obtained by dividing the total demand quantity by number of days. The coverage days is calculated by dividing the stock quantity by average demand quantity.
If coverage days drop-down is is not specified in the entry page then all the selcted items will be displayed along with the calculated coverage days If coverage days drop-down is not blank in the entry page then only those items whose coverage days match the filter criteria (>, <, +) for the specified coverage days will be displayed.

Footer Information:

The date and Time of running the report will be displayed at the bottom left side of the report.

Corresponding page number will be displayed at the bottom right side of the report.