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

Choose which optional cookies to allow. You can change or withdraw consent here at any time.