The Materials analysis sheet shows materials costs and availabilities based on bill of material calculations. The default view shows the following measures:
Total Demand—Demand quantity by component/raw material, plant, and week
Materials Cost—Projected material cost based on procurement costs as well as in-house manufacturing/assembly costs
Note: | See Materials Cube for detailed information about the predefined content in the Materials analysis sheet. |
Right-click an item to change the data display. Table 5 describes the display options available for the items in the Materials analysis sheet.
Table 5. Materials Items and Their Display Options
| Item in Excel | Display Options |
|---|---|
| Plants | Zoom In Zoom Out Include Parent Show Description |
| BOM | Zoom In Zoom Out |
| Materials | Select Measures Show Summary Show Inventory Details Show Material Cost Details Show Details Show Debug Measures Show Description Show Formula |
| Time Period | Insert/Edit Comment Add to Key Metrics BOM Review Component Metrics Material Cost Breakdown Where Used Clear Report |