Scope of Project 1. Activate Materi

Scope of Project
1. Activate Material Master with number of day on “Total Shelf Life” on Plant Data/Storage View
2. Get “Batch Number” on FEX File from Factory & Integrated FEX file Via YLP10 with option “ Active, data retrieved from Packing File”.
3. System convert Batch number as MFG date and together with calculate BBD date[ best before date ] and update into Inbound Line Item. “Expiration Date = Production Date +Total Shelf Life”
4. Warehouse can process replenishment with put away strategy [“H”-Shelf Life Expiration Date].
5. Scope of project will cover only High Rack & Put Away area. There are no record of MFG date / Batch on Put Away or Goods Issues process.
6. Project will active only CPD product.

Project Concerns & Issues
1. Batch# not provided by Factory CPP Vendor that is CHI460, IOR199 and some is missing from FEX file.
2. Loss of Invoice information on inbound for Finance team if we create inbound by Pallet- >Status now Check with CDC France for Solution

Change Management:
1) MM: The way to Create Inbound will be change as Inbound creation by Pallet
2) MM: Number of Lines on Inbound will increase according to number lines of FEX
3) WM: Add on Physical and logical on Bin location at WIP Area and High Rack.
4) WM: Add on Warehouse internal process on stock transfer from WIP to Sub-contact Location when release from QI stock since stock need to transfer by Bin under same Batch/Expiration Date.
5) WM: During Goods receipts process, system require to enter Production date if it is MFG Date or Batch on FEX file is missing with message “Enter the date of Production” when process GR by inbound.


Benefit:
1. Expiration date can visibility under Bin Level [Warehouse Module]
2. There will be WM Report for Critical Shelf Life Expiration Date Control List, this report can view the material is under Critical on Shelf Life.

Quantified benefit from Dc side
a. Reduce manual admin job to record & key MFD (for CPD only) in excel sheet after receiving + putting away: 150 pallets/ day
Time Spending: 3 hours/ day >> Est. Manpower cost: 4,500 THB/ month
b. Reduce idol time of replenish + pick team to select “right” MFD to sensitive customers (i.e., 7-11, Tops, Big C, GT customers): 16 SKUs and 2 pallets/ SKU/ day
Time Spending: 2 hours/ day >> Est. Manpower cost: 3,500 THB/ month
c. Per “b” requirement, it leads to physical and logical pallets mismatched, and inventory inaccuracy.
Time Spending: 4 hours to check CPD stocks and re-arrange “right” pallets to “right” locations.
>> Est. Manpower cost: 6,000 THB / month
d. Manual check stocks + MFD for the whole Dc when DP needs MFD report by division.
Time Spending: 1 Saturday >> Est. Manpower cost: 12,000 THB/ time

After implementing EXP date,
(1) Manpower in a + b will turn to 1 headcount using to key “stock transfer from WIP to Sub-contact Location” after receiving.
(2) Extra works in c + d will help reducing no. of overtime/ man/ month.

ผลลัพธ์ (อังกฤษ) 2:

Scope of Project
1. Activate with Material Master Number of Day on "Total Shelf Life" on Plant Data / Storage View.
2. Get "Batch Number" on FEX FEX Integrated File Via File from Factory & YLP10 with option "Active, Packing Data retrieved from File".
3. System convert Batch number as MFG date and together with calculate BBD date [best before date] and update into Inbound Line Item. "Expiration Date = Production Date + Total Shelf Life".
4. Warehouse Process Can Put away strategy replenishment with ["H"-Shelf Life Expiration Date].
5. Scope of project will cover only High Rack & Put Away area. There are no Record of MFG Date / Batch Process Issues on Put Away or Goods.
6. Active Project Will only Product CPD. Project Concerns & Issues 1. Batch # Not Provided by Vendor Factory CPP that is CHI460, IOR199 and some from FEX File is Missing. 2. Loss of Invoice information on Inbound for Finance team if We create Inbound by Pallet-> Status now Check with CDC France for Solution. Change Management: 1) MM: The Way to Create Inbound Will be Change as Inbound Creation by Pallet. 2) MM: Number of Lines on Inbound Will increase According to Number Lines of FEX. 3) WM: Add on Physical and Logical on Bin Location at WIP Area and High Rack. 4) WM: Add on Warehouse internal Process on Stock Transfer from WIP to Sub-Contact Location. when release from QI Stock since Stock Need to Transfer by Bin under Same Batch / Expiration Date. 5) WM: During Goods Receipts Process, System require to enter Production Date if it is MFG Date or Batch on FEX File is Missing with Message "Enter. The Date of Production "when GR by Inbound Process. Benefit: 1. Can expiration Date visibility under Bin Level [Warehouse Module]. 2. Will there be WM Report for Critical Control List Shelf Life Expiration Date, this Report is under Critical Can View The material on Shelf Life. Quantified Benefit from Dc Side A. Reduce manual job to Admin Record & Key MFD (for CPD only) in Excel Sheet After Receiving + Putting away: 150 pallets / Day. Spending Time: 3 hours / Day >> Est. Manpower Cost: 4,500 THB / month. B. Reduce time of RepleniSH + Pick Idol team to Select "right" MFD to sensitive customers (IE, 7-11, Tops, Big C, GT customers): 16 SKUs and 2 pallets / SKU / Day. Spending Time: 2 hours / Day>. > Est. Manpower Cost: 3,500 THB / month. C. Per "B" requirement, it Leads to physical and Logical mismatched pallets, and Inventory inaccuracy. Time Spending: 4 hours CPD Stocks to Check and re-Arrange "right" pallets to "right" Locations. >> Est. Manpower Cost: 6,000 THB / month. D. Check manual for The Whole Dc Stocks + MFD MFD when DP Needs Report by division. Spending Time: 1 Saturday >> Est. Manpower Cost: 12,000 THB / time. After Implementing EXP Date, (1) Manpower in A + B Will Turn to 1 Headcount using to Key "Stock Transfer from WIP to Sub-Contact Location" After Receiving. (2) Extra Works in C +. d will help reducing no. of overtime / man / month.

ผลลัพธ์ (อังกฤษ) 3:

Scope of Project
1. Activate Material Master with number of day on "Total Shelf Life." on Plant Data / Storage View
2. Get "Batch Number." on FEX File from Factory & Integrated FEX file Via YLP10 with option, "Active data retrieved from Packing File ".
3. System convert Batch number as MFG date and together with calculate BBD date [best before date] and update into Inbound Line Item"Expiration Date = Production Date Total Shelf Life"
4. Warehouse can process replenishment with put away strategy ["H - Shelf." Life Expiration Date].
5. Scope of project will cover only High Rack & Put Away area. There are no record of MFG date Batch on Put Away or Goods Issues process.
6. Project will active only CPD product.

Project Concerns & Issues
1Batch # not provided by Factory CPP Vendor that is CHI460 IOR199 and, some is missing from FEX file.
2. Loss of Invoice Information on inbound for Finance team if we create inbound by Pallet - > Status now Check with CDC France for Solution

Change Management:
1) MM: The way to Create Inbound will be change as Inbound creation by Pallet
2) MMNumber of Lines on Inbound will increase according to number lines of FEX
3) WM: Add on Physical and logical on Bin location At WIP Area and High Rack.
4) WM: Add on Warehouse internal process on stock transfer from WIP to Sub-contact Location when Release from QI stock since stock need to transfer by Bin under same Batch / Expiration Date.
5) WM: During Goods receipts ProcessSystem require to enter Production date if it is MFG Date or Batch on FEX file is missing with message Enter the date. " Of Production. "When process GR by inbound.



Benefit 1. Expiration date can visibility under Bin Level Warehouse Module []
2. There will be WM Report for Critical Shelf Life Expiration Date, Control List this report can view the material is under Critical on Shelf Life.

Quantified benefit from Dc side
a. Reduce manual admin job to record & key MFD (for CPD only) in Excel sheet after receiving Putting away: 150 pallets / day
Time Spending: 3 hours / day > > Est. Manpower cost: 4 500, THB / month
B. Reduce idol time of Replenish pick team to select "right." MFD to sensitive customers (i.e.,,,, 7-11 Tops Big C GT customers): 16 SKUs and 2 pallets SKU / day
Time Spending: 2 hours / day > > Est. Manpower cost: 3 500, THB / month
C. "B", Per requirement it leads to physical and logical Pallets mismatched and inventory, inaccuracy.
Time Spending: 4 hours to check CPD stocks and re-arrange "right pallets." To "right." locations.
> > Est. Manpower cost: 6 000, THB / month
D. Manual check stocks MFD for the whole Dc when DP needs MFD report by division.
Time Spending: 1 Saturday > > Est. Manpower cost: 12 000, THB / time

After implementing, EXP date
(1) Manpower in a B Will turn to 1 headcount using to key "stock transfer from WIP to Sub-contact Location." after receiving.
(2) Extra works In C D will help reducing NO. Of overtime / man / month.