PLATFORM 02 • PROGRAM & ASSEMBLY COSTING

From Excel BOMs to Material, Weight & Cost Intelligence.

Digitalize complex assembly Bill of Materials exports (.xlsx, .xls, .csv). Track multi-revision delta trajectories, auto-cost line items against date-effective material rates, and eliminate spreadsheet consolidation.

Ingests standard .xlsx, .xls, .csv • Real-time delta computation
85% Faster Gate Review Sign-off
< 1s Delta Computation
100% Revision Diff Accuracy
REV B → REV C COMPARISON (illustrative data)
TOTAL PARTS
146
6 vs Rev B
TOTAL WEIGHT
385 g
17g vs Rev B
TOTAL COST
Rs. 1,080
Rs.60 vs Rev B
MATERIAL FAMILIES
6
stable

Rev B → Rev C: Weight & Cost

500 400 300 200 100 0 Weight (g) 1400 1200 1000 800 600 400 0 Cost (Rs.) Rev B Weight: 402g 402g Rev B Cost: Rs. 1,140 Rs.1140 Rev B Rev C Weight: 385g (▼ -17g) 385g Rev C Cost: Rs. 1,080 (▼ -Rs.60) Rs.1080 Rev C

Material Mix by Family (Rev C)

Plastics: 33% Steel: 23% Aluminum: 18% Copper: 12% Rubber: 8% Others: 5% 33% 23% 18% 12% 8% 5%
Plastics
Steel
Aluminum
Copper
Rubber
Others
Sample figures shown for illustration only, populated from your uploaded BOM revisions in the live dashboard.
HOW IT FLOWS

One Upload. Four Simple Stages. Complete BOM Clarity.

Easily turn your Excel files into clear, automated dashboards without messy formulas.

01

Upload & Organize

Upload your Excel or CSV files. MATG automatically sorts part numbers, quantities, weights, and materials.

02

Check & Match

Match parts against verified materials to quickly find missing details and unmapped grades.

03

Cost & Compare

Calculate material costs automatically with current market rates and track changes between revisions.

04

View & Export

See cost and weight trends on simple visual charts and download clean reports in PDF or Excel.

PLATFORM CAPABILITIES

Everything Required to Control Assembly BOM Cost & Mass.

Designed specifically for automotive, aerospace, and industrial manufacturing program managers.

ENGINE 01 • REVISION TRAJECTORY

Multi-Revision Delta Tracking

Compare Rev A and Rev B side-by-side to track part additions, removals, substitutions, mass variance, and cost evolution.

  • Side-by-Side Tree Diff: Instantly spot added, modified, or obsoleted line items.
  • Mass Variance Trajectory: Track assembly lightweighting across engineering milestones.
  • Material Consolidation: Identify redundant grades and consolidate into high-volume resins.
ENGINE 02 • DYNAMIC COSTING

Date-Effective Material Cost Engine

Stop hard-coding stale pricing into spreadsheet cells. Apply date-effective commodity and specialty resin indices automatically.

  • Material Family Rates: Polymer & metal market rates dynamically cost every gram of material.
  • Cost Driver Isolation: Surface the top 5% of components driving 80% of total assembly cost.
  • What-If Substitution: Model metal-to-polymer replacement impact on cost and weight in real time.
DATA INGESTION

Universal Field Normalization

Ingest raw exports from Siemens Teamcenter, PTC Windchill, SAP, or Tier 1 supplier spreadsheets without format re-work.

  • Automated column detection (PN, Description, Mass, Resin, Qty).
  • Intelligent unit conversion (g, kg, lbs, oz normalized automatically).
EXECUTIVE REPORTING

One-Click Gate Review Exports

Export management-ready PDF milestone briefs and fully populated Excel workbooks for program sign-off reviews.

  • Executive PDF summaries with delta charts and cost breakdown.
  • Multi-tab Excel workbooks formatted with clean formulas and headers.

Take Control of Your Assembly BOM Material, Weight, Cost, Comparison & Beyond.

Schedule a live demonstration to see MATG analyze your organization's sample BOM exports.