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
Purchasing List
Calculate the quantity of products (split by sizes) that we should buy to fulfill the demand set in the Sales Forecast
Purchasing List
Purchasing List
Product Type
Month
July 2019
101
August 2019
101
September 2019
101
October 2019
101
November 2019
101
December 2019
101
Size
Percentage*
Forecast Data
Number of Styles
Qty to Purchase
Size
Percentage*
Forecast Data
Number of Styles
Qty to Purchase
Size
Percentage*
Forecast Data
Number of Styles
Qty to Purchase
Size
Percentage*
Forecast Data
Number of Styles
Qty to Purchase
Size
Percentage*
Forecast Data
Number of Styles
Qty to Purchase
Size
Percentage*
Forecast Data
Number of Styles
Qty to Purchase
Product Type
Month
July 2019
101
August 2019
101
September 2019
101
October 2019
101
November 2019
101
December 2019
101
Size
Percentage*
Forecast Data
Number of Styles
Qty to Purchase
Size
Percentage*
Forecast Data
Number of Styles
Qty to Purchase
Size
Percentage*
Forecast Data
Number of Styles
Qty to Purchase
Size
Percentage*
Forecast Data
Number of Styles
Qty to Purchase
Size
Percentage*
Forecast Data
Number of Styles
Qty to Purchase
Size
Percentage*
Forecast Data
Number of Styles
Qty to Purchase
Bottoms
60
0-3months
6.43%
5,500
1
354
3-6months
7.55%
5,500
1
416
6-9months
7.87%
5,500
1
433
9-12months
11.56%
5,500
1
636
12-18months
12.19%
5,500
1
671
18-24months
12.40%
5,500
1
682
2T
12.37%
5,500
1
681
3T
11.50%
5,500
1
632
4T
9.08%
5,500
1
499
5T
8.72%
5,500
1
479
10
5,483
0-3months
6.43%
5,500
1
354
12-18months
12.19%
5,500
1
671
18-24months
12.40%
5,500
1
682
2T
12.37%
5,500
1
681
3-6months
7.55%
5,500
1
416
3T
11.50%
5,500
1
632
4T
9.08%
5,500
1
499
5T
8.72%
5,500
1
479
6-9months
7.87%
5,500
1
433
9-12months
11.56%
5,500
1
636
10
5,483
0-3months
6.43%
5,500
1
354
12-18months
12.19%
5,500
1
671
18-24months
12.40%
5,500
1
682
2T
12.37%
5,500
1
681
3-6months
7.55%
5,500
1
416
3T
11.50%
5,500
1
632
4T
9.08%
5,500
1
499
5T
8.72%
5,500
1
479
6-9months
7.87%
5,500
1
433
9-12months
11.56%
5,500
1
636
10
5,483
0-3months
6.43%
6,600
1
425
12-18months
12.19%
6,600
1
805
18-24months
12.40%
6,600
1
819
2T
12.37%
6,600
1
817
3-6months
7.55%
6,600
1
499
3T
11.50%
6,600
1
759
4T
9.08%
6,600
1
599
5T
8.72%
6,600
1
575
6-9months
7.87%
6,600
1
520
9-12months
11.56%
6,600
1
763
10
6,581
0-3months
6.43%
5,500
1
354
12-18months
12.19%
5,500
1
671
18-24months
12.40%
5,500
1
682
2T
12.37%
5,500
1
681
3-6months
7.55%
5,500
1
416
3T
11.50%
5,500
1
632
4T
9.08%
5,500
1
499
5T
8.72%
5,500
1
479
6-9months
7.87%
5,500
1
433
9-12months
11.56%
5,500
1
636
10
5,483
0-3months
6.43%
4,400
1
283
12-18months
12.19%
4,400
1
536
18-24months
12.40%
4,400
1
546
2T
12.37%
4,400
1
544
3-6months
7.55%
4,400
1
332
3T
11.50%
4,400
1
506
4T
9.08%
4,400
1
399
5T
8.72%
4,400
1
384
6-9months
7.87%
4,400
1
346
9-12months
11.56%
4,400
1
509
10
4,385
Dresses
66
0-3months
5.05%
4,400
1
222
3-6months
5.19%
4,400
1
228
6-9months
5.70%
4,400
1
251
6-12months
0.42%
4,400
1
19
9-12months
10.16%
4,400
1
447
12-18months
10.71%
4,400
1
471
18-24months
11.35%
4,400
1
499
2T
12.10%
4,400
1
533
3T
12.83%
4,400
1
565
4T
12.57%
4,400
1
553
5T
13.09%
4,400
1
576
11
4,364
0-3months
5.05%
6,600
1
334
12-18months
10.71%
6,600
1
707
18-24months
11.35%
6,600
1
749
2T
12.10%
6,600
1
799
3-6months
5.19%
6,600
1
342
3T
12.83%
6,600
1
847
4T
12.57%
6,600
1
830
5T
13.09%
6,600
1
864
6-12months
0.42%
6,600
1
28
6-9months
5.70%
6,600
1
376
9-12months
10.16%
6,600
1
671
11
6,547
0-3months
5.05%
11,000
1
556
12-18months
10.71%
11,000
1
1,178
18-24months
11.35%
11,000
1
1,249
2T
12.10%
11,000
1
1,331
3-6months
5.19%
11,000
1
570
3T
12.83%
11,000
1
1,412
4T
12.57%
11,000
1
1,383
5T
13.09%
11,000
1
1,440
6-12months
0.42%
11,000
1
47
6-9months
5.70%
11,000
1
627
9-12months
10.16%
11,000
1
1,118
11
10,911
0-3months
5.05%
11,000
1
556
12-18months
10.71%
11,000
1
1,178
18-24months
11.35%
11,000
1
1,249
2T
12.10%
11,000
1
1,331
3-6months
5.19%
11,000
1
570
3T
12.83%
11,000
1
1,412
4T
12.57%
11,000
1
1,383
5T
13.09%
11,000
1
1,440
6-12months
0.42%
11,000
1
47
6-9months
5.70%
11,000
1
627
9-12months
10.16%
11,000
1
1,118
11
10,911
0-3months
5.05%
11,000
1
556
12-18months
10.71%
11,000
1
1,178
18-24months
11.35%
11,000
1
1,249
2T
12.10%
11,000
1
1,331
3-6months
5.19%
11,000
1
570
3T
12.83%
11,000
1
1,412
4T
12.57%
11,000
1
1,383
5T
13.09%
11,000
1
1,440
6-12months
0.42%
11,000
1
47
6-9months
5.70%
11,000
1
627
9-12months
10.16%
11,000
1
1,118
11
10,911
0-3months
5.05%
5,500
1
278
12-18months
10.71%
5,500
1
589
18-24months
11.35%
5,500
1
624
2T
12.10%
5,500
1
666
3-6months
5.19%
5,500
1
285
3T
12.83%
5,500
1
706
4T
12.57%
5,500
1
691
5T
13.09%
5,500
1
720
6-12months
0.42%
5,500
1
23
6-9months
5.70%
5,500
1
313
9-12months
10.16%
5,500
1
559
11
5,454
Jumpsuits & Rompers
90
0-3months
6.68%
11,000
1
735
0-6months (Small)
6.36%
11,000
1
699
3-6months
6.42%
11,000
1
706
6-9months
6.33%
11,000
1
696
6-12months (Medium)
6.04%
11,000
1
665
9-12months
9.48%
11,000
1
1,042
12-18months
8.93%
11,000
1
982
12-24months (Large)
2.84%
11,000
1
313
18-24months
9.81%
11,000
1
1,079
18-36months (Large)
3.07%
11,000
1
338
2T
8.31%
11,000
1
914
3T
8.29%
11,000
1
912
3-5T (XLarge)
1.96%
11,000
1
216
4T
7.50%
11,000
1
825
5T
7.70%
11,000
1
847
15
10,969
0-3months
6.68%
8,800
1
588
0-6months (Small)
6.36%
8,800
1
560
12-18months
8.93%
8,800
1
786
12-24months (Large)
2.84%
8,800
1
250
18-24months
9.81%
8,800
1
863
18-36months (Large)
3.07%
8,800
1
271
2T
8.31%
8,800
1
731
3-5T (XLarge)
1.96%
8,800
1
173
3-6months
6.42%
8,800
1
565
3T
8.29%
8,800
1
729
4T
7.50%
8,800
1
660
5T
7.70%
8,800
1
678
6-12months (Medium)
6.04%
8,800
1
532
6-9months
6.33%
8,800
1
557
9-12months
9.48%
8,800
1
834
15
8,777
0-3months
6.68%
11,000
1
735
0-6months (Small)
6.36%
11,000
1
699
12-18months
8.93%
11,000
1
982
12-24months (Large)
2.84%
11,000
1
313
18-24months
9.81%
11,000
1
1,079
18-36months (Large)
3.07%
11,000
1
338
2T
8.31%
11,000
1
914
3-5T (XLarge)
1.96%
11,000
1
216
3-6months
6.42%
11,000
1
706
3T
8.29%
11,000
1
912
4T
7.50%
11,000
1
825
5T
7.70%
11,000
1
847
6-12months (Medium)
6.04%
11,000
1
665
6-9months
6.33%
11,000
1
696
9-12months
9.48%
11,000
1
1,042
15
10,969
0-3months
6.68%
12,100
1
809
0-6months (Small)
6.36%
12,100
1
769
12-18months
8.93%
12,100
1
1,080
12-24months (Large)
2.84%
12,100
1
344
18-24months
9.81%
12,100
1
1,187
18-36months (Large)
3.07%
12,100
1
372
2T
8.31%
12,100
1
1,006
3-5T (XLarge)
1.96%
12,100
1
237
3-6months
6.42%
12,100
1
777
3T
8.29%
12,100
1
1,003
4T
7.50%
12,100
1
908
5T
7.70%
12,100
1
932
6-12months (Medium)
6.04%
12,100
1
731
6-9months
6.33%
12,100
1
766
9-12months
9.48%
12,100
1
1,146
15
12,067
0-3months
6.68%
13,200
1
882
0-6months (Small)
6.36%
13,200
1
839
12-18months
8.93%
13,200
1
1,179
12-24months (Large)
2.84%
13,200
1
375
18-24months
9.81%
13,200
1
1,295
18-36months (Large)
3.07%
13,200
1
406
2T
8.31%
13,200
1
1,097
3-5T (XLarge)
1.96%
13,200
1
259
3-6months
6.42%
13,200
1
848
3T
8.29%
13,200
1
1,094
4T
7.50%
13,200
1
990
5T
7.70%
13,200
1
1,017
6-12months (Medium)
6.04%
13,200
1
798
6-9months
6.33%
13,200
1
835
9-12months
9.48%
13,200
1
1,251
15
13,165
0-3months
6.68%
7,700
1
515
0-6months (Small)
6.36%
7,700
1
490
12-18months
8.93%
7,700
1
688
12-24months (Large)
2.84%
7,700
1
219
18-24months
9.81%
7,700
1
755
18-36months (Large)
3.07%
7,700
1
237
2T
8.31%
7,700
1
640
3-5T (XLarge)
1.96%
7,700
1
151
3-6months
6.42%
7,700
1
494
3T
8.29%
7,700
1
638
4T
7.50%
7,700
1
578
5T
7.70%
7,700
1
593
6-12months (Medium)
6.04%
7,700
1
465
6-9months
6.33%
7,700
1
487
9-12months
9.48%
7,700
1
730
15
7,680
Leotards
60
0-3months
6.20%
2,200
1
136
3-6months
7.02%
2,200
1
154
6-9months
6.52%
2,200
1
143
9-12months
12.90%
2,200
1
284
12-18months
12.24%
2,200
1
269
18-24months
12.44%
2,200
1
274
2T
12.59%
2,200
1
277
3T
12.08%
2,200
1
266
4T
9.54%
2,200
1
210
5T
8.46%
2,200
1
186
10
2,199
0-3months
6.20%
4,400
1
273
12-18months
12.24%
4,400
1
539
18-24months
12.44%
4,400
1
547
2T
12.59%
4,400
1
554
3-6months
7.02%
4,400
1
309
3T
12.08%
4,400
1
532
4T
9.54%
4,400
1
420
5T
8.46%
4,400
1
372
6-9months
6.52%
4,400
1
287
9-12months
12.90%
4,400
1
568
10
4,401
0-3months
6.20%
6,600
1
409
12-18months
12.24%
6,600
1
808
18-24months
12.44%
6,600
1
821
2T
12.59%
6,600
1
831
3-6months
7.02%
6,600
1
463
3T
12.08%
6,600
1
797
4T
9.54%
6,600
1
630
5T
8.46%
6,600
1
558
6-9months
6.52%
6,600
1
430
9-12months
12.90%
6,600
1
851
10
6,598
0-3months
6.20%
6,600
1
409
12-18months
12.24%
6,600
1
808
18-24months
12.44%
6,600
1