Inventory Team Reports
Company:
Nature of the business:
Unit / Area:
Activity:
I.
One of the Top Warehousing & Logistics Services Provider in the Philippines
Warehousing & Logistics Services
Finance & Accounting
Prepared by: Airah Maye T. Querubin
Inventory Management
Designation: Acting Inventory Supervisor
Scope of Work
INVENTORY MANAGEMENT (Main Functions)
1
2
3
4
5
6
7
Inbound Receiving to Put-away
•
Monitors Inbound Receiving Timeliness
Ageing Stocks Monitoring
Daily or Weekly Cycle Count
Submits count result on a weekly basis
Reconciliation of inventory variances
Non-Conforming Stocks Monitoring and Reporting
Physical Sorting of Items for Quality Inspection
•
12
Tagging of Non-Conforming stocks in the WH
(based on QA Disposition)
Material Reservation Preparation
Cleanup of System Hanging Transactions/Variances
•
Clean-up of items parked at Recon Storage Location
•
Clean up of stocks under N-Series
•
Clean up of stocks under Claims Storage Location
Closing of Hanging STO's
Monthly Wall to Wall Count
•
Submits monthly count result
•
Reconciliation of inventory variances every after count
Monitors and leads depletion program for Ageing stocks to
avoid downgrades of RM
13
14
Monitors downgrades - Logistics and Inventory inaccuracies
related
Monitors compliance to SAP Timeliness
8
9
10
11
Responsible
Inventory Team
WH / Inventory
Team
Inventory Team
Remarks
- Weekly submission to SMFI IM
Team
Inventory Team
Inventory Team
Inventory Team
WH / Inventory
Team
WH / Inventory
Team
Inventory Team
Inventory Team
Inventory Team
Inventory Team
Inventory Team
Inventory Team
Inventory Team
Inventory Team
Inventory Team
Inventory Team
For Inventory Team Monitoring (with impact to IRA)
1
2
3
4
5
ORDER PROCESSING
Order Processing
•
Unlocated stocks should be coordinated to IM Team for
checking
TRANSPORT MANAGEMENT
Invoice Transmittal
•
Un-transmitted Invoices Monitoring
DOCUMENTATION MANAGEMENT
On-Time and Accurate Tagging of Unserved & Devuelto
Reasons
POD Liquidation
•
Unconfirmed Devuelto & Contested Invoices
Miscellaneous Sales Invoice Processing and Transmittal
(Claims)
•
Damaged in Transit
Responsible
Customer Service
Inventory Team
Responsible
Transport
Inventory Team
Responsible
Documentation
Team
Documentation
Team
Documentation
Team
Remarks
Customer Service
Inventory Team
Remarks
Transport
With impact to IRA if undispatched in the WH
Remarks
Should be completed every end of
month
©ATQ
6
Closing of Daily Sales and Stock Report (DSSR)
REVERSE LOGISTICS MANAGEMENT
Documentation
Team
Responsible
7
Devuelto/CM processing
Reverse Logistics
8
Reverse Logistics - Pullout Good Stocks
Reverse Logistics
II.
Required Reports
Type of Report
1
Stock Position Report (SPR)
2
Ageing Report
3
4
5
6
7
8
9
Should be completed every end of
month
Remarks
With impact to IRA if
unprocessed
With impact to IRA if
unprocessed
Content
SOH and Inventory Profile
- With Ageing Details and
Expiry Date
- With ABC Classification,
Total Pallets and DTL
(see sample report)
- Product Age Classification
based on actual expiry dates
- Reference of Sales &
Marketing Team for
depletion plan
Unserved Outlook
(for out of stocks &
unlocated)
Cycle Count Report
- To compute for potential
unserves for Maybunga &
North Hub
- Result of daily and weekly
Cycle Count with computation
per SKU and per module
- Action Steps to be
provided to close the
recurring variances
Receiving Report
- To monitor the Receiving of
Stocks,
On-time
System
Posting of Goods Received
and Turnaround of trucks
- To monitor the receiving
of RUD
- To check on-time system
posting for RUD
- Turnaround time to putaway or other disposition
needed.
List of all damages - items
that were hit during
operations or due to carton
issue
List of all stocks that could
not be served due to noncon, damaged or returns
from delivery.
Frequency of
sending /
BLG Cut-Off
Daily / 10AM
Responsible
person/s
Recipient/s
Inventory
Supervisor /
Analyst
SMFI: Warehouse,
Inventory and
Planning Team
Weekly - Every
Friday / 12 MM
Inventory
Supervisor /
Analyst
SMFI Inventory
Team
Daily / 10AM
Inventory Analyst
Weekly - Every
Saturday
Inventory Analyst
SMFI: Warehouse,
Inventory and
Planning Team
SMFI: Inventory,
Finance and WH
Team
Daily / 10AM
Inventory Clerk
SMFI: Warehouse,
Inventory and
Planning Team
Daily / 10AM
Inventory Clerk
SMFI: Warehouse
and Inventory Team
Inventory Clerk
SMFI: QA,
Warehouse and
Inventory Team
As needed
Inventory Clerk
SMFI: QA,
Warehouse and
Inventory Team
End of day inventory
Daily
Inventory Analyst
System to System Report
Daily
Inventory Analyst
Returns Receiving Report
In-house Damaged Inspection
Report (Damaged during
Operations)
List of Items for QA
Inspection
SMFI: Inventory,
Finance and WH
Team
SMFI: Inventory,
Finance and WH
Team
©ATQ