Raw Material Content and Shipped Quantity

These reports are based on the same information and logic, but presented from two different perspectives:

  • The Raw Material Content report shows raw material usage. The quantity used per lot and percent content of the raw material in a finished product or semifinished product are displayed. If panel setting Attribute Details is set to Include for the report, the report shows a nested grid in connection to the component item.
  • The Shipped Quantity report shows all shipments that contain the selected raw material or product, the content and percent content of this raw material, or product lot in the shipped product.

For both reports, the base assumption is that all raw materials are viewed as mixed in one batch before production. Therefore, raw materials are evenly spread at the production level where they are applied. Raw materials are assumed to be evenly spread in all the products that are reported on a manufacturing order, co-products, by-products, and end products.

In both reports, all quantities are converted into one common unit of measure. The used unit is provided by the M3REPORT:RMContent_Unit setting. For the report to be correct, you must define the unit as the base unit, or the alternate unit, for all raw materials, semifinished products, and finished products. If this conversion factor is missing, the content is 0. Catch weight is used as quantity where applicable. You must define the catch weight unit for the M3REPORT:RMContent_Unit setting.

To exclude scrap from the report calculations in both reports, you can perform one of these steps:
  • For standard manufacturing process, you can exclude scrap from the report calculations by enabling .M3Report:Exclude_Scrap_Calculation in the Application Settings.
  • For complex manufacturing processes such as co-products and by-products, you can exclude scrap from the report calculations by enabling .M3Report:Omit_Scrap_Only and disabling .M3Report:Exclude_Scrap_Calculation in the Application Settings.

Percent content is calculated according to this formula:

Material content/product content*100

Therefore, the sum of percentage content differs from 100% in these cases:

  • Reported usage does not reflect the reported products.
  • The receipt is incorrectly balanced.
  • The unit conversion factors are incorrect.

You can omit raw material, such as packaging, from being displayed on the report. You can suppress or omit material by item type, item group, or product group. To do this, the M3 Graphical Lot Tracker administrator can specify values on one or more of the below Application Settings.

Use these settings to exclude raw material and semifinished material from being displayed on the report, and exclude them from the Sum Material Content calculation:

  • .M3REPORT:RMContent_omit_Item_type
  • .M3REPORT:RMContent_omit_Item_group
  • .M3REPORT:RMContent_omit_Product_group

Use these settings to exclude raw material and semifinished material from being displayed on the report, but include them in the Sum Material Content calculation:

  • .M3REPORT:RMContent_suppress_Item_type
  • .M3REPORT:RMContent_suppress_Item_group
  • .M3REPORT:RMContent_suppress_Product_group

Each setting can hold one or more values. You must use this syntax: gr1,gr2,gr3

If the setting is incorrectly specified, then no result is returned in the report.

Material content in the product is calculated according to this formula:

Material content in product

This table shows the description of the formula values:

Value Description
MUCU Material usage in calculation unit
MW Material waste percentage as specified on the material line
SQ Scrapped quantity for an operation
MQO Manufactured quantity for an operation
∑BQCU Sum of manufactured quantities that are produced by co-products and by-products at an operation in calculation unit
∑MUCU Total sum of material usage for all items in calculation unit for all operations up to, and including, the current operation
O# Current operation number
nO Number of operations up to, and including, the current operation

Raw Material Content / Attribute Details

Optionally, you can include the attributes of a component item and its connected lots in the Raw Material Content report. When included, the attribute details are displayed as a nested grid under the component record in the report.

You can also include the attribute details in the export of the Raw Material Content report to Microsoft Excel. You can use the Panel Settings panel to select and configure the included attributes.
Note: You can select a maximum of 10 attributes for export.