Materials Cube

The Materials cube allows you to review the bill of materials supporting a finished good and use that level of detail to determine material costs and ending inventory projections.

Inputs

Decisions

Outputs

Table 9. Predefined Information in the Materials Cube

DimensionsMeasuresConstraintsAllocation MapsRelated Objects
BOM

Manufacturing

Plants

Aggregated Children Material Cost

Aggregated Cost Per Unit

Beginning Inventory

Budget Material Cost

Commit

Dependent Demand

Ending Inventory

Ending Inventory Local Currency

Excess Inventory

Excess Inventory Local Currency

Excess Inventory Threshold

Independent Demand

Inventory Exposure Local Currency

Inventory Exposure Units

Material Cost

Material Cost in Local Currency

Product Family Material Cost

Product Family Total Material Cost – Local Currency

Production Required

Requested

Required

Supply Plan

Total Demand

Unit Cost

Component_Shortage

Excess_Material_Costs

MaterialBOM-Child-to-Parent-Level

SummaryLevel-To-LeafLevel

Cubes
  • Production

  • Financials

Dimensions

  • BOM

  • Manufacturing

  • Plants

Row Sources

  • WIP_RS

  • Financial_Plan_RS

  • Inventory_RS

  • Material_Details_RS

  • Batch_Currency_Exchange_RS