Sales data

icon picker
Input Sales Data

Add your monthly sales data here.
Sales Data
Month
Product Type
Qty Sold
Avg Sold per Day
January 2018
16,000
533
January 2018
3,000
100
January 2018
3,000
100
January 2018
3,000
100
January 2018
4,000
133
January 2018
7,000
233
January 2018
2,000
67
January 2018
1,000
33
January 2018
1,000
33
February 2018
15,000
500
February 2018
4,000
133
February 2018
4,000
133
February 2018
2,000
67
February 2018
6,000
200
February 2018
2,000
67
February 2018
2,000
67
February 2018
1,000
33
February 2018
1,000
33
March 2018
13,000
433
March 2018
5,000
167
March 2018
4,000
133
March 2018
7,000
233
March 2018
2,000
67
March 2018
2,000
67
March 2018
7,000
233
March 2018
2,000
67
March 2018
2,000
67
March 2018
1,000
33
April 2018
14,000
467
April 2018
5,000
167
April 2018
4,000
133
April 2018
3,000
100
April 2018
7,000
233
April 2018
1,000
33
April 2018
1,000
33
April 2018
1,000
33
April 2018
1,000
33
April 2018
1,000
33
May 2018
13,000
433
May 2018
4,000
133
May 2018
3,000
100
May 2018
6,000
200
May 2018
2,000
67
May 2018
1,000
33
May 2018
1,000
33
May 2018
1,000
33
May 2018
1,000
33
May 2018
1,000
33
June 2018
23,000
767
June 2018
12,000
400
June 2018
11,000
367
June 2018
9,000
300
June 2018
6,000
200
June 2018
6,000
200
June 2018
6,000
200
June 2018
2,000
67
June 2018
1,000
33
June 2018
1,000
33
July 2018
10,000
333
July 2018
4,000
133
July 2018
6,000
200
July 2018
2,000
67
July 2018
5,000
167
July 2018
5,000
167
July 2018
4,000
133
July 2018
2,000
67
July 2018
2,000
67
July 2018
100
3
August 2018
8,000
267
August 2018
6,000
200
August 2018
7,000
233
August 2018
4,000
133
August 2018
4,000
133
August 2018
5,000
167
August 2018
7,000
233
August 2018
2,000
67
August 2018
100
3
August 2018
100
3
September 2018
10,000
333
September 2018
10,000
333
September 2018
6,000
200
September 2018
9,000
300
September 2018
6,000
200
September 2018
10,000
333
September 2018
5,000
167
September 2018
3,000
100
September 2018
1,000
33
September 2018
100
3
October 2018
16,000
533
October 2018
10,000
333
October 2018
6,000
200
October 2018
11,000
367
October 2018
6,000
200
October 2018
6,000
200
October 2018
6,000
200
October 2018
9,000
300
October 2018
1,000
33
October 2018
1,000
33
November 2018
14,000
467
November 2018
10,000
333
November 2018
12,000
400
November 2018
5,000
167
November 2018
4,000
133
November 2018
15,000
500
November 2018
5,000
167
November 2018
2,000
67
November 2018
1,000
33
November 2018
1,000
33
December 2018
7,000
233
December 2018
5,000
167
December 2018
8,000
267
December 2018
4,000
133
December 2018
3,000
100
December 2018
2,000
67
December 2018
5,000
167
December 2018
1,000
33
December 2018
1,000
33
December 2018
10
0
January 2019
9,000
300
January 2019
8,000
267
January 2019
9,000
300
January 2019
3,000
100
January 2019
4,000
133
January 2019
2,000
67
January 2019
5,000
167
January 2019
2,000
67
January 2019
10
0
January 2019
10
0
February 2019
10,000
333
February 2019
10,000
333
February 2019
8,000
267
February 2019
3,000
100
February 2019
4,000
133
February 2019
3,000
100
February 2019
6,000
200
February 2019
2,000
67
February 2019
1,000
33
February 2019
1,000
33
March 2019
11,000
367
March 2019
10,000
333
March 2019
8,000
267
March 2019
6,000
200
March 2019
3,000
100
March 2019
7,000
233
March 2019
2,000
67
March 2019
1,000
33
March 2019
1,000
33
March 2019
1,000
33
April 2019
11,000
367
April 2019
7,000
233
April 2019
8,000
267
April 2019
6,000
200
April 2019
2,000
67
April 2019
3,000
100
April 2019
6,000
200
April 2019
1,000
33
April 2019
1,000
33
April 2019
10
0
There are no rows in this table


FORMULAS:


image.png

image.png

image.png



Supporting Data
Product Type
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
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 =

👉Next up:


Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.