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.
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.
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.
Click to collapse the Selection box. To display the Selection box again, click .
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 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 |