Asortyment | Ilosc sumaryczna | cena jednostkowa | wartość | procentowy udział asortymentu | Grupa | Podziałka | ilość | ilość | ilość | ilość | ilość | ilość | ilość | ilość | ilość | ilość | ilość | ilość | suma | wartosc całkowita | a | δ^2 | δ | Mxyz | |||||||||||||||||
całkowita | 2.5 | styczeń | luty | marzec | kwiecień | maj | czerwiec | lipiec | sierpień | wrzesień | październik | listopad | grudzień | ||||||||||||||||||||||||||||
A18 | 530 | 1179.78 | 625283.40 | 30.95 | 30.95 | A | |||||||||||||||||||||||||||||||||||
A37 | 600 | 448.33 | 268998.00 | 13.31 | 44.26 | A | A34 | 130.00 | 0.00 | 20.00 | 90.00 | 35.00 | 50.00 | 62.00 | 50.00 | 0.00 | 35.00 | 20.00 | 0.00 | 492 | 229990.32 | 41.00 | 412.73 | 20.32 | 49.55 | X | A | ||||||||||||||
A34 | 492 | 467.46 | 229990.32 | 11.38 | 55.65 | A | 0.00 | 0.00 | A18 | 0.00 | 60.00 | 70.00 | 0.00 | 100.00 | 0.00 | 100.00 | 100.00 | 0.00 | 100.00 | 0.00 | 0.00 | 530 | 625283.40 | 44.17 | 568.11 | 23.84 | 53.97 | Y | A | ||||||||||||
A9 | 147 | 1204.88 | 177117.36 | 8.77 | 64.41 | A | A | 6.00 | 15.00 | 77.62 | A37 | 100.00 | 150.00 | 0.00 | 0.00 | 0.00 | 100.00 | 0.00 | 0.00 | 0.00 | 150.00 | 0.00 | 100.00 | 600 | 268998.00 | 50.00 | 900.00 | 30.00 | 60.00 | Y | A | ||||||||||
A13 | 500 | 297.84 | 148920.00 | 7.37 | 71.78 | A | B | 10.00 | 40.00 | 94.66 | A13 | 0.00 | 200.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 50.00 | 50.00 | 50.00 | 50.00 | 100.00 | 500 | 148920.00 | 41.67 | 940.00 | 30.66 | 73.58 | Y | A | ||||||||||
A15 | 156 | 756.47 | 118009.32 | 5.84 | 77.62 | A | C | 24.00 | 100.00 | 100.00 | A1 | 100.00 | 0.00 | 0.00 | 80.00 | 80.00 | 0.00 | 0.00 | 0.00 | 0.00 | 40.00 | 0.00 | 0.00 | 300 | 12093.00 | 25.00 | 676.00 | 26.00 | 104.00 | Z | A | ||||||||||
A2 | 74 | 1025.42 | 75881.08 | 3.76 | 81.38 | B | A7 | 0.00 | 0.00 | 0.00 | 0.00 | 20.00 | 14.00 | 5.00 | 26.00 | 20.00 | 0.00 | 25.00 | 15.00 | 125 | 25367.50 | 10.42 | 119.51 | 10.93 | 104.95 | Z | A | ||||||||||||||
A40 | 49 | 1074.00 | 52626.00 | 2.60 | 83.98 | B | A23 | 14.00 | 8.00 | 10.00 | 10.00 | 10.00 | 30.00 | 16.00 | 10.00 | 0.00 | 0.00 | 1.00 | 0.00 | 109 | 7521.00 | 9.08 | 91.04 | 9.54 | 105.04 | Z | B | IDZIE IDZE | |||||||||||||
A16 | 140 | 360.61 | 50485.40 | 2.50 | 86.48 | B | A35 | 10.00 | 0.00 | 0.00 | 10.00 | 10.00 | 10.00 | 20.00 | 21.00 | 0.00 | 0.00 | 10.00 | 0.00 | 91 | 26044.20 | 7.58 | 85.84 | 9.26 | 122.17 | Z | B | PODBESKIDZIE | |||||||||||||
A20 | 29 | 1248.63 | 36210.27 | 1.79 | 88.28 | B | A15 | 0.00 | 20.00 | 50.00 | 0.00 | 0.00 | 0.00 | 0.00 | 26.00 | 10.00 | 40.00 | 0.00 | 10.00 | 156 | 118009.32 | 13.00 | 257.54 | 16.05 | 123.45 | Z | B | ||||||||||||||
A17 | 36 | 937.13 | 33736.68 | 1.67 | 89.95 | B | A2 | 15.00 | 0.00 | 6.00 | 12.00 | 1.00 | 0.00 | 5.00 | 0.00 | 0.00 | 20.00 | 0.00 | 15.00 | 74 | 75881.08 | 6.17 | 97.24 | 9.86 | 159.91 | Z | B | ||||||||||||||
A35 | 91 | 286.20 | 26044.20 | 1.29 | 91.23 | B | A3 | 28.00 | 0.00 | 0.00 | 0.00 | 25.00 | 0.00 | 22.00 | 10.00 | 0.00 | 0.00 | 3.00 | 5.00 | 93 | 16809.75 | 7.75 | 168.55 | 12.98 | 167.52 | Z | B | ||||||||||||||
A7 | 125 | 202.94 | 25367.50 | 1.26 | 92.49 | B | A40 | 8.00 | 0.00 | 5.00 | 12.00 | 0.00 | 4.00 | 0.00 | 10.00 | 0.00 | 5.00 | 5.00 | 0.00 | 49 | 52626.00 | 4.08 | 48.71 | 6.98 | 170.93 | Z | B | MYYYYY | |||||||||||||
A3 | 93 | 180.75 | 16809.75 | 0.83 | 93.32 | B | A16 | 0.00 | 0.00 | 60.00 | 0.00 | 0.00 | 0.00 | 0.00 | 10.00 | 20.00 | 50.00 | 0.00 | 0.00 | 140 | 50485.40 | 11.67 | 425.71 | 20.63 | 176.85 | Z | B | GÓÓÓÓRALE | |||||||||||||
A30 | 16 | 903.12 | 14449.92 | 0.72 | 94.04 | B | A9 | 0.00 | 65.00 | 10.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 0.00 | 0.00 | 70.00 | 0.00 | 147 | 177117.36 | 12.25 | 606.39 | 24.62 | 201.02 | Z | B | Z BIELSKA | |||||||||||||
A5 | 33 | 378.68 | 12496.44 | 0.62 | 94.66 | B | A4 | 10.00 | 0.00 | 11.00 | 5.00 | 0.00 | 0.00 | 5.00 | 0.00 | 27.00 | 8.00 | 0.00 | 0.00 | 66 | 10703.88 | 5.50 | 127.45 | 11.29 | 205.27 | Z | B | ||||||||||||||
A39 | 15 | 822.38 | 12335.70 | 0.61 | 95.27 | C | A22 | 30.00 | 10.00 | 0.00 | 0.00 | 0.00 | 20.00 | 0.00 | 0.00 | 0.00 | 12.00 | 0.00 | 0.00 | 72 | 5495.04 | 6.00 | 185.33 | 13.61 | 226.90 | Z | B | ||||||||||||||
A1 | 300 | 40.31 | 12093.00 | 0.60 | 95.86 | C | A19 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 10.00 | 0.00 | 20.00 | 40.00 | 10.00 | 0.00 | 0.00 | 80 | 4705.60 | 6.67 | 250.00 | 15.81 | 237.17 | Z | C | ||||||||||||||
A14 | 34 | 354.12 | 12040.08 | 0.60 | 96.46 | C | A21 | 15.00 | 0.00 | 5.00 | 0.00 | 0.00 | 1.00 | 5.00 | 0.00 | 10.00 | 0.00 | 0.00 | 2.00 | 38 | 2485.58 | 3.17 | 82.00 | 9.06 | 285.96 | Z | C | ||||||||||||||
A10 | 33 | 354.87 | 11710.71 | 0.58 | 97.04 | C | A38 | 0.00 | 2.00 | 3.00 | 3.00 | 0.00 | 2.00 | 0.00 | 5.00 | 0.00 | 5.00 | 0.00 | 0.00 | 20 | 5024.40 | 1.67 | 25.60 | 5.06 | 303.58 | Z | C | ||||||||||||||
A4 | 66 | 162.18 | 10703.88 | 0.53 | 97.57 | C | A24 | 2.00 | 0.00 | 6.00 | 3.00 | 5.00 | 1.00 | 0.00 | 0.00 | 1.00 | 2.00 | 0.00 | 0.00 | 20 | 5278.60 | 1.67 | 28.00 | 5.29 | 317.49 | Z | C | ||||||||||||||
A27 | 5 | 2003.54 | 10017.70 | 0.50 | 98.07 | C | A29 | 2.00 | 0.00 | 6.00 | 3.00 | 6.00 | 1.00 | 0.00 | 0.00 | 1.00 | 2.00 | 0.00 | 0.00 | 21 | 39.90 | 1.75 | 31.00 | 5.57 | 318.16 | Z | C | ||||||||||||||
A23 | 109 | 69.00 | 7521.00 | 0.37 | 98.44 | C | A33 | 0.00 | 0.00 | 0.00 | 2.00 | 2.00 | 2.00 | 2.00 | 3.00 | 6.00 | 1.00 | 0.00 | 0.00 | 18 | 343.44 | 1.50 | 23.33 | 4.83 | 322.03 | Z | C | ||||||||||||||
A22 | 72 | 76.32 | 5495.04 | 0.27 | 98.71 | C | A11 | 0.00 | 3.00 | 7.00 | 0.00 | 1.00 | 9.00 | 0.00 | 10.00 | 0.00 | 0.00 | 0.00 | 0.00 | 30 | 1788.90 | 2.50 | 66.00 | 8.12 | 324.96 | Z | C | ||||||||||||||
A24 | 20 | 263.93 | 5278.60 | 0.26 | 98.97 | C | A5 | 11.00 | 2.00 | 0.00 | 0.00 | 10.00 | 10.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 33 | 12496.44 | 2.75 | 85.18 | 9.23 | 335.61 | Z | C | ||||||||||||||
A38 | 20 | 251.22 | 5024.40 | 0.25 | 99.22 | C | A39 | 4.00 | 2.00 | 2.00 | 2.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 3.00 | 0.00 | 0.00 | 15 | 12335.70 | 1.25 | 17.80 | 4.22 | 337.52 | Z | C | ||||||||||||||
A19 | 80 | 58.82 | 4705.60 | 0.23 | 99.45 | C | A12 | 0.00 | 10.00 | 1.00 | 0.00 | 10.00 | 0.00 | 0.00 | 11.00 | 0.00 | 0.00 | 0.00 | 0.00 | 32 | 1526.40 | 2.67 | 88.75 | 9.42 | 353.28 | Z | C | ||||||||||||||
A36 | 15 | 227.42 | 3411.30 | 0.17 | 99.62 | C | A30 | 1.00 | 0.00 | 4.00 | 3.00 | 5.00 | 0.00 | 0.00 | 0.00 | 1.00 | 2.00 | 0.00 | 0.00 | 16 | 14449.92 | 1.33 | 26.00 | 5.10 | 382.43 | Z | C | ||||||||||||||
A21 | 38 | 65.41 | 2485.58 | 0.12 | 99.74 | C | A17 | 5.00 | 0.00 | 5.00 | 0.00 | 0.00 | 0.00 | 4.00 | 1.00 | 0.00 | 21.00 | 0.00 | 0.00 | 36 | 33736.68 | 3.00 | 133.33 | 11.55 | 384.90 | Z | C | ||||||||||||||
A11 | 30 | 59.63 | 1788.90 | 0.09 | 99.83 | C | A10 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 6.00 | 0.00 | 3.00 | 1.00 | 0.00 | 3.00 | 20.00 | 33 | 11710.71 | 2.75 | 132.45 | 11.51 | 418.51 | Z | C | ||||||||||||||
A12 | 32 | 47.70 | 1526.40 | 0.08 | 99.91 | C | A6 | 0.00 | 4.00 | 0.00 | 1.00 | 0.00 | 2.00 | 0.00 | 12.00 | 0.00 | 0.00 | 5.00 | 0.00 | 24 | 366.48 | 2.00 | 71.00 | 8.43 | 421.31 | Z | C | ||||||||||||||
A28 | 10 | 66.72 | 667.20 | 0.03 | 99.94 | C | A28 | 0.00 | 0.00 | 1.00 | 2.00 | 0.00 | 0.00 | 0.00 | 1.00 | 3.00 | 1.00 | 0.00 | 2.00 | 10 | 667.20 | 0.83 | 14.00 | 3.74 | 449.00 | Z | C | ||||||||||||||
A6 | 24 | 15.27 | 366.48 | 0.02 | 99.96 | C | A32 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 1.00 | 3.00 | 4.00 | 2.00 | 0.00 | 0.00 | 0.00 | 12 | 94.68 | 1.00 | 22.00 | 4.69 | 469.04 | Z | C | ||||||||||||||
A33 | 18 | 19.08 | 343.44 | 0.02 | 99.98 | C | A14 | 26.00 | 0.00 | 4.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 4.00 | 0.00 | 34 | 12040.08 | 2.83 | 215.88 | 14.69 | 518.57 | Z | C | ||||||||||||||
A8 | 6 | 40.31 | 241.86 | 0.01 | 99.99 | C | A26 | 0.00 | 0.00 | 0.00 | 2.00 | 0.00 | 2.00 | 0.00 | 1.00 | 1.00 | 0.00 | 0.00 | 4.00 | 10 | 31.50 | 0.83 | 21.20 | 4.60 | 552.52 | Z | C | ||||||||||||||
A25 | 8 | 12.88 | 103.04 | 0.01 | 99.99 | C | A20 | 22.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 7.00 | 0.00 | 0.00 | 29 | 36210.27 | 2.42 | 191.55 | 13.84 | 572.70 | Z | C | ||||||||||||||
A32 | 12 | 7.89 | 94.68 | 0.00 | 100.00 | C | A27 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 1.00 | 0.00 | 1.00 | 1.00 | 1.00 | 0.00 | 0.00 | 5 | 10017.70 | 0.42 | 7.00 | 2.65 | 634.98 | Z | C | ||||||||||||||
A29 | 21 | 1.90 | 39.90 | 0.00 | 100.00 | C | A36 | 10.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 3.00 | 2.00 | 0.00 | 15 | 3411.30 | 1.25 | 75.40 | 8.68 | 694.67 | Z | C | ||||||||||||||
A26 | 10 | 3.15 | 31.50 | 0.00 | 100.00 | C | A25 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 4.00 | 8 | 103.04 | 0.67 | 22.00 | 4.69 | 703.56 | Z | C | ||||||||||||||
A31 | 3 | 2.67 | 8.01 | 0.00 | 100.00 | C | A8 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 0.00 | 1.00 | 0.00 | 1.00 | 0.00 | 2.00 | 6 | 241.86 | 0.50 | 14.00 | 3.74 | 748.33 | Z | C | ||||||||||||||
A31 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 1.00 | 1.00 | 3 | 8.01 | 0.25 | 9.00 | 3.00 | 1200.00 | Z | C | |||||||||||||||||||||
2020459.64 | 2020459.64 |