MRR 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 receiving reports (MRRs) is important because MRRs inform engineering, purchasing, expediting and construction that the equipment or materials have arrived at the jobsite. Once an MRR is posted, the equipment or materials are part of the project’s inventory.

The objective of the MRR Cycle Time metric is to measure how efficient your company is at documenting receipt of equipment and materials once they arrive at the jobsite. The MRR Cycle Time metric is calculated based on the MRR posted date and MRR receipt date from Smart Materials.

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

  • The report does not consider direct MRRs and MRRs by package.

BIRMRRCycleTimePicture1

To generate a MRR 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 agreement is issued

  • Supplier - Supplier assigned to the agreement

  • Origin - Originator of the agreement

  • Buyer - The buyer assigned to and responsible for the agreement

  • Expediter - The expediter assigned to the agreement

  • 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.

  • Agreement Number - This option allows you to filter the report on particular agreements

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 MRR_FAST, MRR_MEDIUM, and MRR_SLOW. You can change the parameter values on the A.30.05 Parameter screen in Smart Materials. The default values are 2 for MRR_FAST, 3-7 for MRR_MEDIUM, and 8 for MRR_SLOW.

Report Formats

The MRR Cycle Time report includes the following report formats:

(1) MRR Cycle Time Distribution

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

(2) MRR Cycle - Monthly Count

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

Fast (green)

Medium (yellow)

Slow (red)

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

(3) Average MRR Cycle Time

The (3) Average MRR Cycle Time report format contains the calendar days on the y-axis and the MRR posted month/year on the x-axis. This diagram provides a monthly and cumulative MRR cycle time for a project and is useful to highlight MRR cycle time improvements over a period of time and to identify the MRR cycle time for a particular month. The cumulative average is calculated as the weighted average (based on the MRR count) over the monthly averages. For example, having month A with an MRR count of 7 and average cycle days of 10, and month B with an MRR 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) MRR Cycle - Monthly %

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

Fast (green)

Medium (yellow)

Slow (red)

(5) MRR Processing Cycles per Project

The (P5) MRR Processing Cycles per Project report format identifies the overall MRR 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) MRR Posting Details

The (6) MRR Posting Details report format identifies all of the data elements that are utilized to generate the MRR 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) MRR Cycle by Month

The (7) MRR 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

P.50.07 Maintain Agreements

P.70.72 Expediting Details

C.20.01 Prepare MRR by PO

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

P.50.01

Project

m_po_headers.proj_id

all projects accessible for the login user

Origin

P.50.01

Origin

m_po_headers.origin_id (-> m_origins.origin_code)

Supplier

P.50.07

Supplier

m_po_headers.sup_id (-> m_suppliers.sup_code)

all suppliers accessible for the login user

Buyer

P.50.07

Buyer

m_po_headers.buyer

Expediter

P.50.07

Expediter

m_po_headers.expediter

Item Type

P.50.07

A.10.15

Item Type

m_item_ships.ident ((-> m_idents.commodity_id -> m_commodity_codes.ity_id -> m_item_types.ity_code)

all item types from Smart Materials source screen

Agreement Number

P.50.01

Agreement Number

m_po_headers.po_number

MRR Number

C.20.01

MRR Number

m_matl_recv_rpts.mrr_number

Matl Recv Date

C.20.01

Matl Recv Date

m_matl_recv_rpts.matl_recv_date

Posted Date

C.20.01

Posted Date

m_matl_recv_rpts.posted_date

Received Quantity

C.20.01

Sum of all received quantities of the MRR revision 0

MRR Cycle Days

Posted Date – Matl Recv Date