JavaScript required
We’re sorry, but Coda doesn’t work properly without JavaScript enabled.
Skip to content
Gallery
Inventory Planning
Inventory Planning
Sales data
Inventory data
Inventory planning
More
Share
Explore
Inventory planning
Calculation
Calculate the safety stock and reorder point by selecting an avg lead time and maximum lead time.
Select an average lead time 👉
60
days
Select a maximum lead time 👉
90
days
Inventory Planning
Inventory Planning
Product Type
Last inventory count
Daily Sales
Lead Time Demand
Safety Stock
Reorder Point
Days of Inventory
Product Type
Last inventory count
Daily Sales
Lead Time Demand
Safety Stock
Reorder Point
Days of Inventory
1
Tops
50,000
250
15,000
9,750
24,750
200
2
Jumpsuits & Rompers
40,000
402
24,120
14,250
38,370
100
3
Dresses
30,000
231
13,860
6,750
20,610
130
4
Bottoms
20,000
181
10,860
7,500
18,360
110
5
Headbands
20,000
235
14,100
6,750
20,850
85
6
Skirts
10,000
108
6,480
6,750
13,230
93
7
Outerwear
5,000
79
4,740
1,875
6,615
63
8
Shoes
5,000
30
1,800
1,875
3,675
167
9
Leotards
3,000
88
5,280
3,750
9,030
34
10
Swimwear
3,000
34
2,040
2,625
4,665
88
There are no rows in this table
186,000
👉Next up:
Purchasing List
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
Ctrl
P
) instead.