MIR Cycle Time - Intergraph Smart Materials - Version 10.1 - Help - Hexagon

Intergraph Smart Materials Web Help (10.1)

Language
English
Product
Intergraph Smart Materials
Subproduct
Web
Search by Category
Help
Smart Materials/Smart Reference Data Version
10.1

The timely posting of material issue reports (MIRs) is important because MIRs inform site and project management that the materials have been issued from the inventory and the on-hand quantity in the warehouse has been reduced. Once a MIR is posted, the materials are removed from the project’s inventory and no longer available.

The objective of the MIR Cycle Time metric is to measure how efficient your company is at documenting issuing equipment and materials from the site inventory. The MIR Cycle Time metric is calculated based on the MIR posted date and MIR issue date from Smart Materials.

  • The report considers only the initial and posted MIR (revision 0).

  • The report does not consider direct MIRs.

BIRMIRCycleTime

To generate a MIR Cycle Time report, select the appropriate format from the Report Formats group in the Selection box.

Select a month in the From and To lists to define the time frame for the report output. By default, the last 12 months are set as time frame

Additionally, you can select one or multiple values from the following lists to filter and limit the displayed data accordingly:

  • Project - Project for which the material is issued

  • Company - Company to which the material is issued

  • MIR Type - Type of the material issue report

  • Issue Type - The material issue type

  • Issued By - The storekeeper who issued the material

  • Item Type - Material's item type. With the item type, you can specify if you want to track bulk material or equipment material, having a particular item type.

The selection is limited to a maximum number of 1,800 entries.

SHARED Tip To select multiple values, press and hold CTRL while selecting values from the list.

After selecting the values, click Go to apply the filter.

To remove the filter and display all data, click Clear All.

SHARED Tip Click BIROpenSelectionButton to collapse the Selection box. To display the Selection box again, click BIRCloseSelectionButton.

The chart legend entries are truncated if their length exceeds 30 characters.

The cycle time categories used in the reports are specified with the parameters MIR_FAST, MIR_MEDIUM, and MIR_SLOW. You can change the parameter values on the A.30.05 Parameter screen in Smart Materials. The default values are 2 for MIR_FAST, 3-7 for MIR_MEDIUM, and 8 for MIR_SLOW.

Report Formats

The MIR Cycle Time report includes the following report formats:

(1) MIR Cycle Time Distribution

The (1) MIR Cycle Time Distribution report format contains the MIR count on the y-axis and the MIR cycle time days on the x-axis. This report format provides a quick visual of the MIR cycle time distribution and is helpful when identifying outliers that are impacting the average MIR cycle time.

(2) MIR Cycle - Monthly Count

The (2) MIR Cycle - Monthly Count report format contains the MIR count on the y-axis, the MIR posting month on the x-axis and presents an average MIR cycle time for the project. This diagram includes all MIRs created on a project, except for MIR revisions and direct issues. Each MIR is identified in one of these cycle time categories:

Fast (green)

Medium (yellow)

Slow (red)

The MIR cycle time and MIR count can be displayed by pointing to any of the bars on the graphic.

(3) Average MIR Cycle Time

The (3) Average MIR Cycle Time report format contains the calendar days on the y-axis and the MIR posting month/year on the x-axis. This diagram provides a monthly and cumulative MIR cycle time for a project and is useful to highlight MIR cycle time improvements over a period of time and to identify the MIR cycle time for a particular month. The cumulative average is calculated as the weighted average (based on the MIR count) over the monthly averages. For example, having month A with a MIR count of 7 and average cycle days of 10, and month B with an MIR count of 2 and average cycle days of 4, the average is calculated as ((7*10)+(2*4))/(7+2)=8.67days (unlike the simple average which would calculate as (10+4)/2=7days).

(4) MIR Cycle - Monthly %

The (4) MIR Cycle - Monthly % report format contains the percentage on the y-axis and the MIR posting month/year on the x-axis. This diagram provides a quick visual of the percentage of MIRs, posted during a particular month, that were processed in one of these cycle time categories:

Fast (green)

Medium (yellow)

Slow (red)

(5) MIR Processing Cycles per Project

The (P5) MIR Processing Cycles per Project report format identifies the overall MIR cycle times at the project level. This is a good management level report to monitor the efficiency of a particular field materials management team.

(6) MIR Posting Details

The (6) MIR Posting Details report format identifies all of the data elements that are utilized to generate the MIR cycle time metrics. This report is a good resource if there are questions concerning the details included as part of a particular report format.

  • This is an interactive report.

  • Click SearchColumn and select the column where you want to search, type the search criterion in the Search box, and click Go to apply the search.

  • To change the number of displayed rows, select a value from the Rows list.

Additionally, you can customize the report to meet your requirements, save the report, and download the result in csv or html format (see Use Actions menu).

(7) MIR Cycle by Month

The (7) MIR Cycle by Month report format is automatically displayed just below the diagrams and cannot be selected from the Report Formats list. This report is useful to highlight cycle time details for each month.

Data Sources

The table below shows the Smart Materials screen(s) where the data is entered that is displayed in this report. Additionally, this table shows the synchronization table and the CIPs used by the report, and the name of the log file created by the sync job or the report.

Screen

C.20.21 MIR by Reservation

C.20.22.01/.02/.04 MIR by BOM Commodity/Ident

Table

CIP

n/a (no CIP)

Log File

n/a

The following table shows all values displayed in the report, with the related Smart Materials screen and field where the value is displayed, the database table and column where the value is stored, and CIPs, functions, or procedures that are used to retrieve the value. Optionally, additional comment on the value is entered in the last column.

Value

Screen

Field

Database Column

Other Source/Comment

Project

C.20.21..

C.20.22..

Project

m_matl_issue_rpts.proj_id

all projects accessible for the login user

Company

C.20.21..

C.20.22..

Company

m_matl_issue_rpts.company_id (-> m_companies.company_code)

all companies assigned to any MIR

MIR Type

C.20.21..

C.20.22..

m_matl_issue_rpts.mir_type

Issue Type

C.20.22.01

Issue Type

m_matl_issue_rpts.issue_type

Issued By

C.20.21..

C.20.22..

Issue By

m_matl_issue_rpts.issue_by

Item Type

C.20.21..

C.20.22..

A.10.15

Item Type

m_inv_issues.ivi_id (-> m_inv_items.ident, m_idents.commodity_id -> m_commodity_codes.ity_id -> m_item_types.ity_code)

all item types from Smart Materials source screen A.10.15

Posted Date

C.20.21..

C.20.22..

Posted Date

m_matl_issue_rpts.posted_date

Issue Date

C.20.21..

C.20.22..

Issue Date

m_matl_issue_rpts.issue_date

MIR Cycle Days

MIR Posted Date-MIR Issue Date

Issued Quantity

C.20.21..

C.20.22..

Issue Qty

m_inv_issues.issue_qty

Sum of all issued quantities of the MIR revision 0