Unit7Paretoexerciceclass.xlsx
Factor value example
| | Item | Stock | Unit Value | Total Value | | | Add up value |
| 10 | J | 125 | 0.99 | 123.75 | 1 | 10% | 123.75 | 43% |
| 1 | A | 200 | 0.5 | 100 | 2 | 20% | 223.75 | 78% |
| | H | 14 | 1 | 14 | 3 | 30% | 237.75 | 83% |
| | E | 13 | 1 | 13 | 4 | 40% | 250.75 | 87% |
| | F | 9 | 0.96 | 8.64 | 5 | 50% | 259.39 | 90% |
| | B | 10 | 0.75 | 7.5 | 6 | 60% | 266.89 | 93% |
| | I | 15 | 0.47 | 7.05 | 7 | 70% | 273.94 | 95% |
| | G | 8 | 0.74 | 5.92 | 8 | 80% | 279.86 | 97% |
| | C | 12 | 0.48 | 5.76 | 9 | 90% | 285.62 | 99% |
| | D | 11 | 0.16 | 1.76 | 10 | 100% | 287.38 | 100% |
| | 10 | | | 287.38 |
Factor Movements example
| | Item | Movements | item order | % order | Add up M. | Pareto % |
| 8 | F | 650 | 1 | 10% | 650 | 48% |
| 6 | E | 370 | 2 | 20% | 1020 | 76% |
| | B | 120 | 3 | 30% | 1140 | 85% |
| | C | 100 | 4 | 40% | 1240 | 92% |
| | D | 32 | 5 | 50% | 1272 | 94% |
| | G | 30 | 6 | 60% | 1302 | 97% |
| | A | 20 | 7 | 70% | 1322 | 98% |
| | I | 15 | 8 | 80% | 1337 | 99% |
| | H | 9 | 9 | 90% | 1346 | 100% |
| | J | 2 | 10 | 100% | 1348 | 100% |
| | 10 | 1348 |
mohamedabbas77
