Supply Chain Management
Stock Control Sheet Template Excel
📊

Stock Control Sheet Template Excel

1
Enter Stock Item Details
2
Enter Initial Quantity On Hand
3
Enter Stock Purchase Details
4
Calculate Total Quantity On Hand
5
Enter Stock Sales Details
6
Deduct Sold Quantity From Total Quantity
7
Check For Discrepancies
8
Determine If Re-Ordering Is Needed
9
Create Re-Order List If Required
10
Approval: Purchasing Manager for Re-Order
11
Update Stock Item Detail If Required
12
Cross-Check Data With Physical Inventory
13
Identify Any Discrepancies Between Digital and Physical Inventory
14
Approval: Supervisor for Discrepancies
15
Enter Adjustments If Required
16
Update Total Quantity On Hand with Adjustments
17
Generate Stock Control Report
18
Approval: Department Head for Stock Control Report
19
Archive Previous Stock Control Sheet
20
Save and Secure Updated Stock Control Sheet