Skip to content
Sales data

Input Sales Data

Add your monthly sales data here.

Sales Data
3
Month
Product Type
Qty Sold
Avg Sold per Day
1
January 2018
Jumpsuits & Rompers
16,000
533
2
January 2018
Skirts
3,000
100
3
January 2018
Dresses
3,000
100
4
January 2018
Leotards
3,000
100
5
January 2018
Tops
4,000
133
6
January 2018
Headbands
7,000
233
7
January 2018
Outerwear
2,000
67
8
January 2018
Swimwear
1,000
33
9
January 2018
Shoes
1,000
33
10
February 2018
Jumpsuits & Rompers
15,000
500
11
February 2018
Dresses
4,000
133
12
February 2018
Tops
4,000
133
13
February 2018
Skirts
2,000
67
14
February 2018
Headbands
6,000
200
15
February 2018
Leotards
2,000
67
16
February 2018
Outerwear
2,000
67
17
February 2018
Swimwear
1,000
33
18
February 2018
Shoes
1,000
33
19
March 2018
Jumpsuits & Rompers
13,000
433
20
March 2018
Tops
5,000
167
21
March 2018
Dresses
4,000
133
22
March 2018
Bottoms
7,000
233
23
March 2018
Skirts
2,000
67
24
March 2018
Leotards
2,000
67
25
March 2018
Headbands
7,000
233
26
March 2018
Shoes
2,000
67
27
March 2018
Outerwear
2,000
67
28
March 2018
Swimwear
1,000
33
29
April 2018
Jumpsuits & Rompers
14,000
467
30
April 2018
Bottoms
5,000
167
31
April 2018
Dresses
4,000
133
32
April 2018
Tops
3,000
100
33
April 2018
Headbands
7,000
233
34
April 2018
Skirts
1,000
33
35
April 2018
Outerwear
1,000
33
36
April 2018
Shoes
1,000
33
37
April 2018
Leotards
1,000
33
38
April 2018
Swimwear
1,000
33
39
May 2018
Jumpsuits & Rompers
13,000
433
40
May 2018
Dresses
4,000
133
41
May 2018
Bottoms
3,000
100
42
May 2018
Headbands
6,000
200
43
May 2018
Tops
2,000
67
44
May 2018
Skirts
1,000
33
45
May 2018
Swimwear
1,000
33
46
May 2018
Leotards
1,000
33
47
May 2018
Outerwear
1,000
33
48
May 2018
Shoes
1,000
33
49
June 2018
Jumpsuits & Rompers
23,000
767
50
June 2018
Dresses
12,000
400
51
June 2018
Bottoms
11,000
367
52
June 2018
Tops
9,000
300
53
June 2018
Skirts
6,000
200
54
June 2018
Outerwear
6,000
200
55
June 2018
Headbands
6,000
200
56
June 2018
Swimwear
2,000
67
57
June 2018
Leotards
1,000
33
58
June 2018
Shoes
1,000
33
59
July 2018
Jumpsuits & Rompers
10,000
333
60
July 2018
Dresses
4,000
133
61
July 2018
Tops
6,000
200
62
July 2018
Skirts
2,000
67
63
July 2018
Bottoms
5,000
167
64
July 2018
Swimwear
5,000
167
65
July 2018
Headbands
4,000
133
66
July 2018
Outerwear
2,000
67
67
July 2018
Leotards
2,000
67
68
July 2018
Shoes
100
3
69
August 2018
Jumpsuits & Rompers
8,000
267
70
August 2018
Dresses
6,000
200
71
August 2018
Tops
7,000
233
72
August 2018
Skirts
4,000
133
73
August 2018
Leotards
4,000
133
74
August 2018
Bottoms
5,000
167
75
August 2018
Headbands
7,000
233
76
August 2018
Outerwear
2,000
67
77
August 2018
Shoes
100
3
78
August 2018
Swimwear
100
3
79
September 2018
Dresses
10,000
333
80
September 2018
Jumpsuits & Rompers
10,000
333
81
September 2018
Skirts
6,000
200
82
September 2018
Tops
9,000
300
83
September 2018
Leotards
6,000
200
84
September 2018
Headbands
10,000
333
85
September 2018
Bottoms
5,000
167
86
September 2018
Outerwear
3,000
100
87
September 2018
Shoes
1,000
33
88
September 2018
Swimwear
100
3
89
October 2018
Tops
16,000
533
90
October 2018
Dresses
10,000
333
91
October 2018
Skirts
6,000
200
92
October 2018
Jumpsuits & Rompers
11,000
367
93
October 2018
Outerwear
6,000
200
94
October 2018
Leotards
6,000
200
95
October 2018
Bottoms
6,000
200
96
October 2018
Headbands
9,000
300
97
October 2018
Shoes
1,000
33
98
October 2018
Swimwear
1,000
33
99
November 2018
Tops
14,000
467
100
November 2018
Dresses
10,000
333
101
November 2018
Jumpsuits & Rompers
12,000
400
102
November 2018
Skirts
5,000
167
103
November 2018
Outerwear
4,000
133
104
November 2018
Headbands
15,000
500
105
November 2018
Bottoms
5,000
167
106
November 2018
Leotards
2,000
67
107
November 2018
Shoes
1,000
33
108
November 2018
Swimwear
1,000
33
109
December 2018
Jumpsuits & Rompers
7,000
233
110
December 2018
Dresses
5,000
167
111
December 2018
Tops
8,000
267
112
December 2018
Bottoms
4,000
133
113
December 2018
Skirts
3,000
100
114
December 2018
Leotards
2,000
67
115
December 2018
Headbands
5,000
167
116
December 2018
Outerwear
1,000
33
117
December 2018
Shoes
1,000
33
118
December 2018
Swimwear
10
0
119
January 2019
Jumpsuits & Rompers
9,000
300
120
January 2019
Dresses
8,000
267
121
January 2019
Tops
9,000
300
122
January 2019
Skirts
3,000
100
123
January 2019
Bottoms
4,000
133
124
January 2019
Leotards
2,000
67
125
January 2019
Headbands
5,000
167
126
January 2019
Outerwear
2,000
67
127
January 2019
Shoes
10
0
128
January 2019
Swimwear
10
0
129
February 2019
Jumpsuits & Rompers
10,000
333
130
February 2019
Dresses
10,000
333
131
February 2019
Tops
8,000
267
132
February 2019
Skirts
3,000
100
133
February 2019
Bottoms
4,000
133
134
February 2019
Leotards
3,000
100
135
February 2019
Headbands
6,000
200
136
February 2019
Outerwear
2,000
67
137
February 2019
Swimwear
1,000
33
138
February 2019
Shoes
1,000
33
139
March 2019
Jumpsuits & Rompers
11,000
367
140
March 2019
Dresses
10,000
333
141
March 2019
Tops
8,000
267
142
March 2019
Bottoms
6,000
200
143
March 2019
Skirts
3,000
100
144
March 2019
Headbands
7,000
233
145
March 2019
Leotards
2,000
67
146
March 2019
Outerwear
1,000
33
147
March 2019
Swimwear
1,000
33
148
March 2019
Shoes
1,000
33
149
April 2019
Jumpsuits & Rompers
11,000
367
150
April 2019
Dresses
7,000
233
151
April 2019
Tops
8,000
267
152
April 2019
Bottoms
6,000
200
153
April 2019
Skirts
2,000
67
154
April 2019
Leotards
3,000
100
155
April 2019
Headbands
6,000
200
156
April 2019
Outerwear
1,000
33
157
April 2019
Shoes
1,000
33
158
April 2019
Swimwear
10
0
There are no rows in this table


FORMULAS:

image.png


image.png


image.png





Supporting Data

Product Type
0
Product Type
Avg Cost
1
Jumpsuits & Rompers
$4.50
2
Dresses
$5.00
3
Tops
$3.00
4
Bottoms
$2.50
5
Skirts
$7.00
6
Leotards
$4.00
7
Headbands
$2.00
8
Outerwear
$8.00
9
Shoes
$5.00
10
Swimwear
$5.50
There are no rows in this table

*For future use*
Service Level Table
0
Service Level
Service Factor
1
80.00%
0.84
2
85.00%
1.04
3
90.00%
1.28
4
95.00%
1.64
5
96.00%
1.75
6
97.00%
1.88
7
98.00%
2.05
8
99.00%
2.33
9
99.50%
2.58
10
99.60%
2.65
11
99.70%
2.75
12
99.80%
2.88
13
99.90%
3.09
14
99.99%
3.72
There are no rows in this table

Service Level =
96.00%


👉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.