Scribd
Upload
71 views18 pages

Stock Maintenance and Inventory Overview

The document contains stock details of various products including name, brand, category, minimum required quantity, opening stock, monthly production details, total production, details of stock issued, total issued quantity, and whether the current stock is below the minimum requirement. It lists these details across 31 columns for multiple products showing current and projected inventory levels. The table provides a comprehensive overview of production and stock levels for planning purposes.

Uploaded by

Rajkumar Prajapati
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
71 views18 pages

Stock Maintenance and Inventory Overview

The document contains stock details of various products including name, brand, category, minimum required quantity, opening stock, monthly production details, total production, details of stock issued, total issued quantity, and whether the current stock is below the minimum requirement. It lists these details across 31 columns for multiple products showing current and projected inventory levels. The table provides a comprehensive overview of production and stock levels for planning purposes.

Uploaded by

Rajkumar Prajapati
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

SFG STOCK DETAILS

SR. NO. NAME OF PRODUCT BRAND CATEGORY


MINIMUM
REQUIRED
QTY (15 OPENING STOCK MONTHLY PRODUCTION DETAILS
1 MONTH QTY. FORECASTED QTY. KEY/SFG Days) MONTH 1 2 3 4 5
1500.0 500.00
3000.0
1000.0
10000.0
2000.0
10000.0
8000.0
10000.0
3000.0
1000.0
3200.0

1000.0
5000.0
3500.0
1300.0
1000.0
1350.0
500.0
1500.0
500.0
1350.0
500.0
1500.0
750.0
1350.0
1000.0
1500.0
1000.0
500.0
750.0
750.0
1000.0
550.0
550.0
750.0
500.0
750.0
500.0
300.0
0.00 0.00 0.00 84200.00 500.00 0.00 0.00 0.00 0.00 0.00
DUCTION DETAILS
6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
TOTAL PRODUCTION
(Qty)
SFG ISSUED DETAILS
26 27 28 29 30 31 1 2 3 4 5 6 7 8 9
1000.00 1000.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00 0.00 0.00 0.00 1000.00 0.00 1000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
500.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 500.00 0.00 0.00 0.00
Total Issued Stock Below minimum
Stock
Qty required qty
Details
(kg) (Kgs)
29 30 31
500.00 1000.00 Y
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 N
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 Y
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 N
0.00 0.00 0.00 500.00 1000.00

You might also like