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
Sales data
Input Sales Data
Add your monthly sales data here.
Sales Data
Sales Data
Month
Product Type
Qty Sold
Avg Sold per Day
Month
Product Type
Qty Sold
Avg Sold per Day
January 2018
Jumpsuits & Rompers
16,000
533
January 2018
Skirts
3,000
100
January 2018
Dresses
3,000
100
January 2018
Leotards
3,000
100
January 2018
Tops
4,000
133
January 2018
Headbands
7,000
233
January 2018
Outerwear
2,000
67
January 2018
Swimwear
1,000
33
January 2018
Shoes
1,000
33
February 2018
Jumpsuits & Rompers
15,000
500
February 2018
Dresses
4,000
133
February 2018
Tops
4,000
133
February 2018
Skirts
2,000
67
February 2018
Headbands
6,000
200
February 2018
Leotards
2,000
67
February 2018
Outerwear
2,000
67
February 2018
Swimwear
1,000
33
February 2018
Shoes
1,000
33
March 2018
Jumpsuits & Rompers
13,000
433
March 2018
Tops
5,000
167
March 2018
Dresses
4,000
133
March 2018
Bottoms
7,000
233
March 2018
Skirts
2,000
67
March 2018
Leotards
2,000
67
March 2018
Headbands
7,000
233
March 2018
Shoes
2,000
67
March 2018
Outerwear
2,000
67
March 2018
Swimwear
1,000
33
April 2018
Jumpsuits & Rompers
14,000
467
April 2018
Bottoms
5,000
167
April 2018
Dresses
4,000
133
April 2018
Tops
3,000
100
April 2018
Headbands
7,000
233
April 2018
Skirts
1,000
33
April 2018
Outerwear
1,000
33
April 2018
Shoes
1,000
33
April 2018
Leotards
1,000
33
April 2018
Swimwear
1,000
33
May 2018
Jumpsuits & Rompers
13,000
433
May 2018
Dresses
4,000
133
May 2018
Bottoms
3,000
100
May 2018
Headbands
6,000
200
May 2018
Tops
2,000
67
May 2018
Skirts
1,000
33
May 2018
Swimwear
1,000
33
May 2018
Leotards
1,000
33
May 2018
Outerwear
1,000
33
May 2018
Shoes
1,000
33
June 2018
Jumpsuits & Rompers
23,000
767
June 2018
Dresses
12,000
400
June 2018
Bottoms
11,000
367
June 2018
Tops
9,000
300
June 2018
Skirts
6,000
200
June 2018
Outerwear
6,000
200
June 2018
Headbands
6,000
200
June 2018
Swimwear
2,000
67
June 2018
Leotards
1,000
33
June 2018
Shoes
1,000
33
July 2018
Jumpsuits & Rompers
10,000
333
July 2018
Dresses
4,000
133
July 2018
Tops
6,000
200
July 2018
Skirts
2,000
67
July 2018
Bottoms
5,000
167
July 2018
Swimwear
5,000
167
July 2018
Headbands
4,000
133
July 2018
Outerwear
2,000
67
July 2018
Leotards
2,000
67
July 2018
Shoes
100
3
August 2018
Jumpsuits & Rompers
8,000
267
August 2018
Dresses
6,000
200
August 2018
Tops
7,000
233
August 2018
Skirts
4,000
133
August 2018
Leotards
4,000
133
August 2018
Bottoms
5,000
167
August 2018
Headbands
7,000
233
August 2018
Outerwear
2,000
67
August 2018
Shoes
100
3
August 2018
Swimwear
100
3
September 2018
Dresses
10,000
333
September 2018
Jumpsuits & Rompers
10,000
333
September 2018
Skirts
6,000
200
September 2018
Tops
9,000
300
September 2018
Leotards
6,000
200
September 2018
Headbands
10,000
333
September 2018
Bottoms
5,000
167
September 2018
Outerwear
3,000
100
September 2018
Shoes
1,000
33
September 2018
Swimwear
100
3
October 2018
Tops
16,000
533
October 2018
Dresses
10,000
333
October 2018
Skirts
6,000
200
October 2018
Jumpsuits & Rompers
11,000
367
October 2018
Outerwear
6,000
200
October 2018
Leotards
6,000
200
October 2018
Bottoms
6,000
200
October 2018
Headbands
9,000
300
October 2018
Shoes
1,000
33
October 2018
Swimwear
1,000
33
November 2018
Tops
14,000
467
November 2018
Dresses
10,000
333
November 2018
Jumpsuits & Rompers
12,000
400
November 2018
Skirts
5,000
167
November 2018
Outerwear
4,000
133
November 2018
Headbands
15,000
500
November 2018
Bottoms
5,000
167
November 2018
Leotards
2,000
67
November 2018
Shoes
1,000
33
November 2018
Swimwear
1,000
33
December 2018
Jumpsuits & Rompers
7,000
233
December 2018
Dresses
5,000
167
December 2018
Tops
8,000
267
December 2018
Bottoms
4,000
133
December 2018
Skirts
3,000
100
December 2018
Leotards
2,000
67
December 2018
Headbands
5,000
167
December 2018
Outerwear
1,000
33
December 2018
Shoes
1,000
33
December 2018
Swimwear
10
0
January 2019
Jumpsuits & Rompers
9,000
300
January 2019
Dresses
8,000
267
January 2019
Tops
9,000
300
January 2019
Skirts
3,000
100
January 2019
Bottoms
4,000
133
January 2019
Leotards
2,000
67
January 2019
Headbands
5,000
167
January 2019
Outerwear
2,000
67
January 2019
Shoes
10
0
January 2019
Swimwear
10
0
February 2019
Jumpsuits & Rompers
10,000
333
February 2019
Dresses
10,000
333
February 2019
Tops
8,000
267
February 2019
Skirts
3,000
100
February 2019
Bottoms
4,000
133
February 2019
Leotards
3,000
100
February 2019
Headbands
6,000
200
February 2019
Outerwear
2,000
67
February 2019
Swimwear
1,000
33
February 2019
Shoes
1,000
33
March 2019
Jumpsuits & Rompers
11,000
367
March 2019
Dresses
10,000
333
March 2019
Tops
8,000
267
March 2019
Bottoms
6,000
200
March 2019
Skirts
3,000
100
March 2019
Headbands
7,000
233
March 2019
Leotards
2,000
67
March 2019
Outerwear
1,000
33
March 2019
Swimwear
1,000
33
March 2019
Shoes
1,000
33
April 2019
Jumpsuits & Rompers
11,000
367
April 2019
Dresses
7,000
233
April 2019
Tops
8,000
267
April 2019
Bottoms
6,000
200
April 2019
Skirts
2,000
67
April 2019
Leotards
3,000
100
April 2019
Headbands
6,000
200
April 2019
Outerwear
1,000
33
April 2019
Shoes
1,000
33
April 2019
Swimwear
10
0
There are no rows in this table
FORMULAS:
Supporting Data
Product Type
Product Type
Product Type
Avg Cost
Product Type
Avg Cost
Jumpsuits & Rompers
$4.50
Dresses
$5.00
Tops
$3.00
Bottoms
$2.50
Skirts
$7.00
Leotards
$4.00
Headbands
$2.00
Outerwear
$8.00
Shoes
$5.00
Swimwear
$5.50
There are no rows in this table
*For future use*
Service Level Table
Service Level Table
Service Level
Service Factor
Service Level
Service Factor
80.00%
0.84
85.00%
1.04
90.00%
1.28
95.00%
1.64
96.00%
1.75
97.00%
1.88
98.00%
2.05
99.00%
2.33
99.50%
2.58
99.60%
2.65
99.70%
2.75
99.80%
2.88
99.90%
3.09
99.99%
3.72
There are no rows in this table
Service Level
=
96.00%
👉Next up:
Daily Sales
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.