Description

📦 Plan production and see your full material requirements — across all levels.

Most Excel BOM tools stop at one level.

This tool doesn’t.

It handles full multi-level BOM structures, giving you complete visibility from finished goods down to raw materials.

🎯 Core Value

👉 Turn a production plan into a complete multi-level material requirement list

No missing components. No surprises.

⚙️ Key Features (REORDERED — MULTI LEVEL FIRST)

🔄 Multi-Level BOM Explosion (MAIN FEATURE)

• Supports full hierarchy: FG → SUB → SUB → RM
• Automatically calculates quantities across all levels
• Eliminates hidden material gaps

🏭 Production Planning

• Input multiple finished goods
• Automatically triggers full explosion
• Works instantly

🔍 Explosion Detail View

• Visual hierarchy of BOM structure
• Trace materials across levels
• Understand dependencies clearly

🚨 Missing BOM Detection

• Identifies sub-assemblies without BOMs
• Prevents incomplete planning

📦 Item Master

• Central database
• FG / SUB / RM classification
• Easy maintenance

🛠️ BOM Builder

• Build and edit BOMs
• Validate structure
• Manage components

📊 KPI Dashboard

• Total BOMs
• Missing BOMs
• Total items

📋 Material Summary

• Aggregates ALL materials
• Removes duplicates
• Ready for purchasing

💡 Use Cases (UPDATED)

• Multi-level BOM management
• Production planning
• Material requirement planning (MRP)
• Complex product structures
• BOM validation

⚙️ System Requirements

💻 Excel Desktop (Windows)
Recommended: Office 365

⚠️ Macros must be enabled