Supply data audit

What was read

Materials

42

Plants

3

Suppliers

15

Finished goods

9

Purchase orders

46

Customer orders

23

Committed value

Rp 18,214,000,000

Rows in total

334

Critical (2)

• Material with one source and committed revenue behind it

  Rp 17,904,000,000

  continuity

  14 material(s) have exactly one supplier on record and no alternate. Each is a single point of failure that stays invisible until the supplier misses. The figure beside this is the revenue that touches those materials, not an expected loss: one missed delivery does not stop every product that happens to contain the part.

  Evidence (14)

  • M-1124
  • M-1130
  • M-1136
  • M-1142
  • M-1148
  • M-1160
  • M-1172
  • M-1196
  • M-2222
  • M-2228
  • M-5512
  • M-6648
  • M-9910
  • M-9922

  Recommended. Qualify a second source, starting with the highest committed value.

• Cover below the safety floor

  Rp 3,515,000,000

  continuity

  3 material and plant pair(s) hold less than 14 days of cover. The thinnest is M-4471 at KRW1 at 9.1 days.

  Evidence (3)

  • M-5512 at KRW1
  • M-8830 at KRW1
  • M-4471 at KRW1

  Recommended. Bring supply forward or pre-position stock from another plant.

Serious (5)

• Inbound lane concentrated on one port

  Rp 14,924,000,000

  concentration

  13 of 35 purchased materials route through CNNGB, which is 37% of the inbound book. One closure takes out all of them on the same day.

  Evidence (12)

  • M-1118
  • M-1124
  • M-1166
  • M-1196
  • M-1202
  • M-2210
  • M-3308
  • M-4471
  • M-4472
  • M-5512
  • M-6648
  • M-7716

  Recommended. Split the lane, or hold buffer on the far side of the chokepoint.

• Bill of materials names a component that is not stocked anywhere

  Rp 2,174,000,000

  integrity

  1 component(s) appear in a product structure but have no stock record at any plant. Planning cannot see them, so a shortage will surface as a line stoppage rather than as a warning.

  Evidence (1)

  • M-1208

  Recommended. Create the stock record, or remove the line if the component is obsolete.

• Order past its delivery date and still not shipped

  integrity

  1 order(s) are overdue with no shipment recorded. Either the goods moved and nobody updated the record, or they did not move and nobody noticed.

  Evidence (1)

  • 4500018640

  Recommended. Chase the supplier and reconcile the status before planning trusts it.

• One supplier carries more than one code

  integrity

  1 supplier(s) appear under multiple codes. Spend is split across them, so the firm looks smaller than it is, concentration is understated, and a single certificate lapse hits more materials than the records suggest.

  Evidence (2)

  • SUP-4417
  • SUP-4417B

  Recommended. Merge the duplicates and repoint open orders at the surviving code.

• Sourcing options in the file would worsen local content

  compliance

  3 option(s) would drop the local-content ratio below the current 38.2%, against a contract floor of 40.0%. The cheapest of them, Cheapest source in China, is Rp 48,000,000, which is exactly the trade a cost-only model would take.

  Evidence (3)

  • D
  • E
  • G

  Recommended. Keep the veto ahead of the cost comparison, not after it.

Warning (4)

• Customer order for a product with no bill of materials

  Rp 310,000,000

  integrity

  1 finished good(s) are being sold with no component structure behind them. Nothing can trace a disruption from a raw material to these orders.

  Evidence (1)

  • FG-9099

  Recommended. Build the structure, or confirm the product is bought in finished.

• Revised delivery date falls before the date originally promised

  integrity

  1 order(s) were revised earlier than the commitment. Either the supplier genuinely pulled the date in, or the revision overwrote the original. Every lead-time figure computed from this field inherits the error.

  Evidence (1)

  • 4500019204

  Recommended. Confirm with the supplier, and keep the original commitment in its own field.

• Material with one source and no traceable revenue

  continuity

  13 single-sourced material(s) could not be priced, because no bill of materials links them to a customer order. Unpriced is not the same as unimportant; it means the records do not say.

  Evidence (13)

  • M-1105
  • M-1112
  • M-1166
  • M-1202
  • M-2210
  • M-2216
  • M-3308
  • M-3320
  • M-5524
  • M-5530
  • M-6640
  • M-7716
  • M-7722

  Recommended. Complete the product structure before judging whether these matter.

• Stock held against a material nobody consumes

  capital

  1 position(s) carry stock with a consumption rate of zero. Either the rate is missing from the record or the stock is dead and tying up capital and floor space.

  Evidence (1)

  • M-1202 at CKR1

  Recommended. Confirm the rate, then write off or redeploy what is genuinely dead.

Note (1)

• Purchase order for a quantity of zero

  integrity

  2 order line(s) commit to nothing. Harmless individually, and a sign that order entry accepts input it should reject.

  Evidence (2)

  • 4500018946
  • 4500019310

  Recommended. Void the line and add a minimum-quantity check at entry.