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 lists raw material usage. The quantity used per lot and percent content of the raw material in an end product or semifinished product are displayed. If panel setting Attribute Details is set to Include for the report, the report displays a nested grid in connection to the component item.
• The Shipped Quantity report lists all shipments that contain the selected raw material, the content and percent content of the raw material lot in the shipped product.

For both reports, the base assumption is that all raw materials can be viewed as mixed in one batch before the 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, this unit must be defined as the base unit, or the alternate unit, for all raw materials, semifinished products, and end products. If this conversion factor is missing, the content is 0. Catch weight is used as quantity where applicable. The catch weight unit must be specified for the M3REPORT:RMContent_Unit setting.

For both reports, the scrap can be excluded from the report calculations by enabling the Application Setting .M3Report:Exclude_Scrap_Calculation.

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. Material can be suppressed or omitted by item type, item group, or product group. To do this, an 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:

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