Scribd
Upload
25 views6 pages

Request Consolidated Inventory Reports

Uploaded by

Owe

This document summarizes the inventory levels of various K-Palette branded items across different warehouses and locations for the month of February 2023. It shows beginning inventory, replenishments, returns, and transfers between locations, resulting in available and ending stocks. Key metrics such as beginning inventory, replenishments, available and ending stocks are provided for each item code and location.

Copyright:

© All Rights Reserved
Download as XLSX, PDF, TXT or read online from Scribd
Download as xlsx, pdf, or txt

Request Consolidated Inventory Reports

Uploaded by

Owe
25 views6 pages
This document summarizes the inventory levels of various K-Palette branded items across different warehouses and locations for the month of February 2023. It shows beginning inventory, replenishments, returns, and transfers between locations, resulting in available and ending stocks. Key metrics such as beginning inventory, replenishments, available and ending stocks are provided for each item code and location.

Copyright

© © All Rights Reserved

Available Formats

XLSX, PDF, TXT or read online from Scribd

Did you find this document useful?

Is this content inappropriate?

This document summarizes the inventory levels of various K-Palette branded items across different warehouses and locations for the month of February 2023. It shows beginning inventory, replenishments, returns, and transfers between locations, resulting in available and ending stocks. Key metrics such as beginning inventory, replenishments, available and ending stocks are provided for each item code and location.

Copyright:

© All Rights Reserved
Download as XLSX, PDF, TXT or read online from Scribd
Download as xlsx, pdf, or txt
25 views6 pages

Request Consolidated Inventory Reports

Uploaded by

Owe
This document summarizes the inventory levels of various K-Palette branded items across different warehouses and locations for the month of February 2023. It shows beginning inventory, replenishments, returns, and transfers between locations, resulting in available and ending stocks. Key metrics such as beginning inventory, replenishments, available and ending stocks are provided for each item code and location.

Copyright:

© All Rights Reserved
Download as XLSX, PDF, TXT or read online from Scribd
Download as xlsx, pdf, or txt
You are on page 1/ 6

Consolidated Inventory Report - Good Stocks (Central Warehouse)

For the Month of February 2023


K-PALETTE (per brand)

Beginning Available
ITEM CODE Replenishement Returns Beauty Bar
Inventory Stocks
(from diff location to
CW-GS) Other
(per sku) 1-Feb-23 (from shipment)
transfer-in to Central
Total (B+C+D)
Warehouse
KKB001 100 600 1 701 24
KKB002 100 600 700 24
KPEWP SB 100 500 2 602 12

TOTAL 300 1700 3 2003 60

Per Month
Per Brand
Per Sku
Stock Transfer
Watsons Rustans Landmark Isetan Allgreen Supervalue Chimes Altura

(from CW-GS to stores - Deliveries and other transfer-out transactions)

24 18 12 24 6 6
24 18 12 24 6 6
12 12 6 18 6 2

60 48 30 66 18 0 14 0
OLW - Online CAD (Assemble / Ending
Issuance CW-PK CW-Tester
Warehouse Disassemble) Inventory

ransfer-out transactions) 28-Feb-23

100 3 5 1 6 472
120 3 5 1 6 451
100 2 5 1 6 420

320 8 15 3 18 1343
Consolidated Inventory Report - Good Stocks
For the Month of February 2023
K-PALETTE (per brand)

ITEM CODE Beginning Inventory Replenishement Returns Available Stocks


(from diff location
(per sku) (CW-GS) (from RR)
to CW-GS)
Total (B+C+D)

Consolidated Inventory Report - Online Warehouse Stocks


For the Month of February 2023
K-PALETTE (per brand)

ITEM CODE Beginning Inventory Replenishement Returns Available Stocks


(from diff location
(per sku) (OLW-GS) (from CW-GS) to OLW-GS) Total (B+C+D)

Consolidated Inventory Report - Pull out Stocks


For the Month of February 2023
K-PALETTE (per brand)

ITEM CODE Beginning Inventory Replenishement Returns Available Stocks


(from diff location
(per sku) (CW-PO)
to CW-PO)
Total (B+C+D)
Stock Transfer
Beauty Bar Watsons Rustans Landmark Isetan Allgreen Supervalue Chimes
(from CW-GS to stores/ Others)

Stock Transfer
Bbox Online Lazada Shopee Zalora Metromart Edamama Tiktok
(from OLW-GS to stores/ Others)

Stock Transfer
Beauty Bar Watsons Rustans Landmark Isetan Allgreen Supervalue Chimes
(from CW-PO to stores/ Others)
nsfer
Altura OLW Issuance CW-PK CW-Tester CAD Ending Inventory
tores/ Others) (CW-GS)

nsfer
CW-GS Issuance CW-PK CW-Tester CAD Ending Inventory
stores/ Others) (OLW-GS)

nsfer
Altura CW-GS Issuance CW-PK CW-Tester CAD Ending Inventory
tores/ Others) (CW-PO)

You might also like