Stock Item Overview

Stock item Management

Faith N. Dolorito

06Dec2023

ADGT Stock Items

Electronics Components

Standard Sparesand Cables

FabricatedParts

PackagingMaterials

Raw Materials

Test Sockets, Pins, Contactors and PCB

Production, Office and IT Supplies

OEM/OPMSpareparts

Chemicals

OEM - Original Equipment ManufacturerOPM - Original Parts Manufacturer http://adgtwebapps/AIMS

ADGT Stock Items

Charisse

Paul

Faith

Jovy

Ronna

Ohnie

Leah

Ria R.

PCB

Packaging Supplies

OEM/OPM Spareparts

Fabrication

Sockets and Contact pins

Chemicals IT Supplies

Electronic ComponentsProduction Supplies Office Supplies

Raw Materials

CablesStandard Spares

Stock Item per Buyer

25,077 PNs

Faith's Stock item for transfer to New buyer

5,016 PNs

Faith's Stock Item Commodity

OEM SparesStandard Spares PCBs Cables IT Supplies Fabrications

Cables

Standard SparesCables

5K PNs

12K PNs

Commodity: Cables

CUSTOMIZED

Design and Fabricate according to our required specs and applications

• Wings Technology
• Anthony Industries
• Meds Technology

These are readily available cables use in our machines

STANDARD

• RS Components
• Technomotion Controls
• Embassy Components
• Konnect RF
• Keypoint
• Quantum Leap
• Leeds International
• Samtec Asia

Project Strategies

Localization

Consolidation

Alternate Sourcing

Source out for alternative vendor as part of our contingency plan

Consolidate all the cables being used by the factory - ADCV/ADGT

Source out for local vendors who can provide competitive price and shorter leadtime

ON-GOING

ON-GOING

ON-GOING

• Samples provided to identified vendors
• On-going evaluation with

Get International and Wehner Engineering

• Explore capability of local vendors like Zenith United

• Review current stock of cables
• Check applications in different factory

• Explore Med's Technology capability

Stock Item Transfer

How to update Buyer code in Inforec

Buyer code update

In SAP Menu type ME1M then click execute

Enter the Material Code: XXXXXXXEnter Purchasing Organization: ADGT Enter Plant: MPH4

Buyer code update

Select the "Square" located on the left sideClick the Pencil icon

How to transfer PR to New Buyer

PR Transfer to new buyer

Click the "Other Purchase Requisition" Enter the PR no.

In SAP Menu type ME52N (Change Purchase Requisition) then click execute

Change the PGR (Purchasing Group) to new buyer PGR / Buyer Code

Stock item as of Nov 2023

$ 33,608K

Inventory Management (Cost on Hand $K)

Indirect Materials

Raw Materials

$197K

$189K

$1,755K

$157K

$124K

$106K

$702K

$507K

$228K

$183K

Inventory Management

Inventory Cost on Hand

Review current inventory min/max and consumption.Explore possible alternate source or parts

Slow Moving/Dormant PN

Review in collaboration with stores and endusers for deletion of slow moving/dormant PN

High value PN

For review consumption and leadtime (JIT)For cost negotiation

ABC Analysis

High, Medium and Low value items for review

FSN Analysis

Fast, Slow and Non-moving items for review

Thank you

Stock Item Challenges

Stock item with dual source

~722 Aging PRs

Zero Stock

• Reviewed the stock items
• One item code with different sources
• Identified lowest bid & better LT
• Generate GM Savings of $29K

• 1,045 PNs that are zero stock (WW125)
• Communicate with vendors
• PO Amendment/Sourcing
• Reduced Zero stock to 9PNs by end of FY22 (WW249)

• Request for updated quote
• Source out obsolete parts
• Reduce Aging PRs to 200 by end of FY22 (WW249)

PN/Price/Min-Max/Consumption/ Leadtime Update

Direct /Alternate Sourcing

• Constant PO revisions/amendment
• Ballooning zero-stock inventory
• Clean up of total 337 PNs

• COHU/DELTA/ISMECA mass leadtime update of 1,578 PNs

• Stock items purchased from Traders
• OEM Parts with direct source
• Obsolete Parts with alternate souce

• 39PNs transfered resulted to $12K GM Savings

Inventory Management (Cost on Hand $K)

• Inventory cost on hand for review consumptions and cost

• Slow moving/Dormant PN review for deletion

• High value PN for review and source

• ABC Analysis (High,Medium and Low value items)

• FSN Analysis (Fast,Slow and Non moving items)

$197K

$189K

$157K

$124K

$106K

Stock Item per Buyer

Stock Item per Buyer

Inventory Management (Cost on Hand)

$74K

$61K

$58K

$44K

$32K

• Inventory cost on hand for review consumptions and cost
• Slow moving/Dormant PN review for deletion
• High value PN for review and source
• ABC Analysis (High,Medium and Low value items)
• FSN Analysis (Fast,Slow and Non moving items)

Stock item as of Nov 2023

$ 33,608K