| Analiza XYZ w gospodarce zapasami |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Historyczne dane sprzedaży, wejściowe dane do zadania |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| LP |
KOD |
NAZWA |
Dane historyczne sprzedaży |
|
|
|
|
|
|
|
|
|
|
|
| I.2012 |
II.2012 |
III.2012 |
IV.2012 |
V.2012 |
VI.2012 |
VII.2012 |
VIII.2012 |
IX.2012 |
X.2012 |
XI.2012 |
XII.2012 |
|
cena |
|
procent |
|
|
a z kreską |
sigma^2 |
sigma |
Mxyz |
|
| 1 |
1000 |
Papier A4 |
4 789 |
4 683 |
3 987 |
4 521 |
4 867 |
5 784 |
3 124 |
2 987 |
5 784 |
4 598 |
4 271 |
4 384 |
53 779 |
35 |
1882265 |
18,94% |
39,96% |
A |
4481,58333333333 |
1799,94 |
42,4257413387551 |
0,946668580793733 |
X |
| 14 |
1013 |
Wkład niebieski |
2 468 |
2 535 |
2 131 |
2 789 |
3 489 |
1 948 |
2 356 |
2 148 |
2 555 |
2 968 |
3 001 |
2 785 |
31 173 |
67 |
2088591 |
21,02% |
21,02% |
A |
2597,75 |
804,16 |
28,3577395020148 |
1,09162696572091 |
X |
| 20 |
1019 |
Ołówek 0,5 HB |
421 |
624 |
922 |
946 |
754 |
896 |
976 |
952 |
843 |
943 |
951 |
912 |
10 140 |
12 |
121680 |
1,22% |
60,04% |
C |
845 |
366,36 |
19,1404648963839 |
2,26514377471999 |
X |
| 8 |
1007 |
Długopis czarny |
149 |
245 |
187 |
165 |
123 |
178 |
154 |
146 |
138 |
147 |
141 |
187 |
1 960 |
7 |
13720 |
0,14% |
58,82% |
C |
163,333333333333 |
71,23 |
8,43994390154487 |
5,16731259278258 |
X |
| 15 |
1014 |
Długopis zielony |
56 |
3 533 |
1 189 |
3 111 |
671 |
898 |
845 |
1 645 |
567 |
227 |
553 |
484 |
13 779 |
21 |
289359 |
2,91% |
58,68% |
B |
1148,25 |
11622,30 |
107,80678077596 |
9,38878996524797 |
X |
| 3 |
1002 |
Papier kancelaryjny kratka |
|
|
139 |
721 |
2 464 |
1 896 |
6 535 |
8 457 |
692 |
72 |
189 |
4 116 |
25 281 |
2 |
50562 |
0,51% |
55,77% |
C |
2106,75 |
42070,88 |
205,111871693995 |
9,73593789932334 |
X |
| 19 |
1018 |
Kredki 24 szt. |
|
|
|
|
|
1 543 |
1 745 |
1 328 |
1 489 |
1 567 |
1 601 |
1 458 |
10 731 |
45 |
482895 |
4,86% |
55,26% |
A |
894,25 |
7777,28 |
88,1889110767473 |
9,86177367366477 |
X |
| 17 |
1016 |
Kredki 6 szt. |
239 |
1 936 |
755 |
1 219 |
239 |
791 |
737 |
1 276 |
33 |
198 |
8 |
1 921 |
9 352 |
56 |
523712 |
5,27% |
50,40% |
A |
779,333333333333 |
6617,99 |
81,3510488963975 |
10,4385434854231 |
X |
| 2 |
1001 |
Papier A3 |
|
|
158 |
775 |
2 444 |
1 821 |
744 |
9 681 |
113 |
924 |
2 693 |
2 788 |
22 141 |
80 |
1771280 |
17,82% |
45,13% |
A |
1845,08333333333 |
42941,05 |
207,222217494487 |
11,2310492296366 |
X |
| 13 |
1012 |
Cyrkiel |
141 |
1 921 |
738 |
1 243 |
295 |
149 |
919 |
1 552 |
79 |
167 |
11 |
1 867 |
9 082 |
54 |
490428 |
4,94% |
27,31% |
A |
756,833333333333 |
7674,99 |
87,6070006725233 |
11,5754680474596 |
X |
| 12 |
1011 |
Linijka 30 cm |
1 231 |
4 726 |
189 |
4 283 |
1 511 |
916 |
131 |
36 |
72 |
152 |
171 |
9 |
13 427 |
34 |
456518 |
4,59% |
22,37% |
B |
1118,91666666667 |
27173,42 |
164,843634763215 |
14,7324317953272 |
X |
| 11 |
1010 |
Linijka 20 cm |
|
|
|
|
|
7 897 |
3 749 |
1 424 |
842 |
961 |
32 |
189 |
15 094 |
10 |
150940 |
1,52% |
17,78% |
B |
1257,83333333333 |
48598,55 |
220,450794515325 |
17,5262325041997 |
X |
| 18 |
1017 |
Kredki 12 szt. |
98 |
78 |
96 |
79 |
97 |
84 |
141 |
348 |
468 |
198 |
141 |
108 |
1 936 |
76 |
147136 |
1,48% |
16,26% |
C |
161,333333333333 |
1029,09 |
32,0794468326826 |
19,883954648357 |
X |
| 6 |
1005 |
Bloczek makulatorowy A4 |
73 |
111 |
617 |
1 636 |
27 |
611 |
959 |
8 816 |
467 |
539 |
28 |
316 |
14 200 |
23 |
326600 |
3,29% |
14,78% |
B |
1183,33333333333 |
55687,05 |
235,981030510004 |
19,9420589163384 |
X |
| 16 |
1015 |
Kolorowanka |
|
|
|
|
|
8 765 |
2 913 |
1 789 |
454 |
175 |
132 |
17 |
14 245 |
23 |
327635 |
3,30% |
11,49% |
B |
1187,08333333333 |
60531,36 |
246,031214649602 |
20,7256902477727 |
X |
| 7 |
1006 |
Długopis niebieski |
54 |
239 |
619 |
3 228 |
13 452 |
1 |
49 |
2 |
37 |
1 |
419 |
3 |
18 104 |
6 |
108624 |
1,09% |
8,19% |
C |
1508,66666666667 |
109159,92 |
330,393581493348 |
21,8997071250562 |
X |
| 5 |
1004 |
Bloczek makulatorowy A5 |
|
|
|
|
|
|
|
|
1 232 |
1 387 |
1 399 |
1 201 |
5 219 |
4 |
20876 |
0,21% |
7,10% |
C |
434,916666666667 |
10510,90 |
102,522672848393 |
23,5729464299811 |
X |
| 10 |
1009 |
Długopis czerwony |
3 |
11 |
192 |
1 263 |
14 387 |
11 |
9 |
28 |
12 |
72 |
|
9 |
15 997 |
9 |
143973 |
1,45% |
6,89% |
C |
1333,08333333333 |
140500,59 |
374,834081358476 |
28,1178281946722 |
X |
| 9 |
1008 |
Wkład czarny |
131 |
528 |
192 |
89 |
113 |
21 |
16 |
5 744 |
851 |
156 |
44 |
183 |
8 068 |
67 |
540556 |
5,44% |
5,44% |
A |
672,333333333333 |
42698,03 |
206,635015781811 |
30,7340132546075 |
X |
| 4 |
1003 |
Papier kancelaryjny linia |
|
|
|
|
|
|
|
|
|
|
|
112 |
112 |
3 |
336 |
0,00% |
0,00% |
C |
9,33333333333333 |
1232,00 |
35,0998575495685 |
376,069902316805 |
Z |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Wartość materiału na magazynie |
9937686 |
1 |
|
|
|
|
|
|
|