Spreadsheet: 886468d1736489346-power-query-onhand-calculation-sample-to-evaluate
Sheet: FNDWRR

ORIGINAL |  |  |  |  |  |  |  | RESULT
ORGANIZATION | ITEM | ORDER TYPE | QUANTITY | COST | SUGG DUE DATE |  |  | ORGANIZATION | ITEM | ORDER TYPE | QUANTITY | COST | SUGG DUE DATE
A02:FAN | A | On Hand | 55.413 | 38.9 | 2025-01 |  |  | A02:FAN | A | On Hand | 55.413 | 38.9 | 2025-01
A02:FAN | A | Work order demand | -56.24248 | 38.9 | 2025-01 |  |  | A02:FAN | A | Work order demand | -56.24248 | 38.9 | 2025-01
A02:FAN | A | Intransit shipment | 100 | 38.9 | 2025-01 |  |  | A02:FAN | A | Intransit shipment | 100 | 38.9 | 2025-01
A02:FAN | A | Purchase order | 100 | 38.9 | 2025-02 |  |  | A02:FAN | A | EOM |  | 38.9 | 2025-01
A02:FAN | A | Work order demand | -49.14 | 38.9 | 2025-02 |  |  | A02:FAN | A | Purchase order | 100 | 38.9 | 2025-02
A02:FAN | A | Work order demand | -0.00504 | 38.9 | 2025-03 |  |  | A02:FAN | A | Work order demand | -49.14 | 38.9 | 2025-02
A02:FAN | A | Work order demand | -54.35724 | 38.9 | 2025-03 |  |  | A02:FAN | A | EOM |  | 38.9 | 2025-02
A02:FAN | A | Purchase order | 600 | 38.9 | 2025-04 |  |  | A02:FAN | A | Work order demand | -0.00504 | 38.9 | 2025-03
A02:FAN | A | Work order demand | -51.324 | 38.9 | 2025-04 |  |  | A02:FAN | A | Work order demand | -54.35724 | 38.9 | 2025-03
A02:FAN | A | Work order demand | -63.95144 | 38.9 | 2025-05 |  |  | A02:FAN | A | EOM |  | 38.9 | 2025-03
A02:FAN | A | Work order demand | -0.007 | 38.9 | 2025-06 |  |  | A02:FAN | A | Purchase order | 600 | 38.9 | 2025-04
A02:FAN | A | Work order demand | -20.82556 | 38.9 | 2025-06 |  |  | A02:FAN | A | Work order demand | -51.324 | 38.9 | 2025-04
A02:FAN | A | Purchase order | 700 | 38.9 | 2026-02 |  |  | A02:FAN | A | EOM |  | 38.9 | 2025-04
A02:FAN | B | On Hand | 61342 | 0.0501 | 2025-01 |  |  | A02:FAN | A | Work order demand | -63.95144 | 38.9 | 2025-05
A02:FAN | B | Purchase order | 100000 | 0.0501 | 2025-01 |  |  | A02:FAN | A | EOM |  | 38.9 | 2025-05
A02:FAN | B | Work order demand | -89330 | 0.0501 | 2025-01 |  |  | A02:FAN | A | Work order demand | -0.007 | 38.9 | 2025-06
A02:FAN | B | Purchase order | 100000 | 0.0501 | 2025-02 |  |  | A02:FAN | A | Work order demand | -20.82556 | 38.9 | 2025-06
A02:FAN | B | Work order demand | -93746 | 0.0501 | 2025-02 |  |  | A02:FAN | A | EOM |  | 38.9 | 2025-06
A02:FAN | B | Purchase order | 100000 | 0.0501 | 2025-03 |  |  | A02:FAN | A | Purchase order | 700 | 38.9 | 2026-02
A02:FAN | B | Work order demand | -92784 | 0.0501 | 2025-03 |  |  | A02:FAN | A | EOM |  | 38.9 | 2026-02
A02:FAN | B | Work order demand | -91675 | 0.0501 | 2025-04 |  |  | A02:FAN | B | On Hand | 61342 | 0.0501 | 2025-01
A02:FAN | B | Planned order | 100000 | 0.0501 | 2025-04 |  |  | A02:FAN | B | Purchase order | 100000 | 0.0501 | 2025-01
A02:FAN | B | Work order demand | -25 | 0.0501 | 2025-05 |  |  | A02:FAN | B | Work order demand | -89330 | 0.0501 | 2025-01
A02:FAN | B | Work order demand | -89063 | 0.0501 | 2025-05 |  |  | A02:FAN | B | EOM |  | 0.0501 | 2025-01
A02:FAN | B | Planned order | 100000 | 0.0501 | 2025-05 |  |  | A02:FAN | B | Purchase order | 100000 | 0.0501 | 2025-02
A02:FAN | B | Work order demand | -73845 | 0.0501 | 2025-06 |  |  | A02:FAN | B | Work order demand | -93746 | 0.0501 | 2025-02
A02:FAN | C | On Hand | 6.7 | 63.77691 | 2025-01 |  |  | A02:FAN | B | EOM |  | 0.0501 | 2025-02
A02:FAN | C | Purchase order | 18.1437 | 63.77691 | 2025-01 |  |  | A02:FAN | B | Purchase order | 100000 | 0.0501 | 2025-03
A02:FAN | C | Work order demand | -5.45493 | 63.77691 | 2025-01 |  |  | A02:FAN | B | Work order demand | -92784 | 0.0501 | 2025-03
A02:FAN | C | Work order demand | -5.3418 | 63.77691 | 2025-02 |  |  | A02:FAN | B | EOM |  | 0.0501 | 2025-03
A02:FAN | C | Work order demand | -0.00054 | 63.77691 | 2025-03 |  |  | A02:FAN | B | Work order demand | -91675 | 0.0501 | 2025-04
A02:FAN | C | Purchase order | 18.1437 | 63.77691 | 2025-03 |  |  | A02:FAN | B | Planned order | 100000 | 0.0501 | 2025-04
A02:FAN | C | Work order demand | -5.8596 | 63.77691 | 2025-03 |  |  | A02:FAN | B | EOM |  | 0.0501 | 2025-04
A02:FAN | C | Work order demand | -5.5425 | 63.77691 | 2025-04 |  |  | A02:FAN | B | Work order demand | -25 | 0.0501 | 2025-05
A02:FAN | C | Work order demand | -6.06348 | 63.77691 | 2025-05 |  |  | A02:FAN | B | Work order demand | -89063 | 0.0501 | 2025-05
A02:FAN | C | Work order demand | -0.00075 | 63.77691 | 2025-06 |  |  | A02:FAN | B | Planned order | 100000 | 0.0501 | 2025-05
A02:FAN | C | Work order demand | -3.62166 | 63.77691 | 2025-06 |  |  | A02:FAN | B | EOM |  | 0.0501 | 2025-05
A02:FAN | D | On Hand | 8406 | 0.016 | 2025-01 |  |  | A02:FAN | B | Work order demand | -73845 | 0.0501 | 2025-06
A02:FAN | D | Work order demand | -3592 | 0.016 | 2025-01 |  |  | A02:FAN | B | EOM |  | 0.0501 | 2025-06
A02:FAN | D | Purchase order | 10000 | 0.016 | 2025-02 |  |  | A02:FAN | C | On Hand | 6.7 | 63.77691 | 2025-01
A02:FAN | D | Work order demand | -5948 | 0.016 | 2025-02 |  |  | A02:FAN | C | Purchase order | 18.1437 | 63.77691 | 2025-01
A02:FAN | D | Purchase order | 10000 | 0.016 | 2025-03 |  |  | A02:FAN | C | Work order demand | -5.45493 | 63.77691 | 2025-01
A02:FAN | D | Work order demand | -8088 | 0.016 | 2025-03 |  |  | A02:FAN | C | EOM |  | 63.77691 | 2025-01
A02:FAN | D | Work order demand | -3436 | 0.016 | 2025-04 |  |  | A02:FAN | C | Work order demand | -5.3418 | 63.77691 | 2025-02
A02:FAN | D | Work order demand | -4524 | 0.016 | 2025-05 |  |  | A02:FAN | C | EOM |  | 63.77691 | 2025-02
A02:FAN | D | Work order demand | -4732 | 0.016 | 2025-06 |  |  | A02:FAN | C | Work order demand | -0.00054 | 63.77691 | 2025-03
A02:FAN | D | Planned order | 10000 | 0.016 | 2025-06 |  |  | A02:FAN | C | Purchase order | 18.1437 | 63.77691 | 2025-03
 |  |  |  |  |  |  |  | A02:FAN | C | Work order demand | -5.8596 | 63.77691 | 2025-03
 |  |  |  |  |  |  |  | A02:FAN | C | EOM |  | 63.77691 | 2025-03
 |  |  |  |  |  |  |  | A02:FAN | C | Work order demand | -5.5425 | 63.77691 | 2025-04
 |  |  |  |  |  |  |  | A02:FAN | C | EOM |  | 63.77691 | 2025-04
 |  |  |  |  |  |  |  | A02:FAN | C | Work order demand | -6.06348 | 63.77691 | 2025-05
 |  |  |  |  |  |  |  | A02:FAN | C | EOM |  | 63.77691 | 2025-05
 |  |  |  |  |  |  |  | A02:FAN | C | Work order demand | -0.00075 | 63.77691 | 2025-06
 |  |  |  |  |  |  |  | A02:FAN | C | Work order demand | -3.62166 | 63.77691 | 2025-06
 |  |  |  |  |  |  |  | A02:FAN | C | EOM |  | 63.77691 | 2025-06
 |  |  |  |  |  |  |  | A02:FAN | D | On Hand | 8406 | 0.016 | 2025-01
 |  |  |  |  |  |  |  | A02:FAN | D | Work order demand | -3592 | 0.016 | 2025-01
 |  |  |  |  |  |  |  | A02:FAN | D | EOM |  | 0.016 | 2025-01
 |  |  |  |  |  |  |  | A02:FAN | D | Purchase order | 10000 | 0.016 | 2025-02
 |  |  |  |  |  |  |  | A02:FAN | D | Work order demand | -5948 | 0.016 | 2025-02
 |  |  |  |  |  |  |  | A02:FAN | D | EOM |  | 0.016 | 2025-02
 |  |  |  |  |  |  |  | A02:FAN | D | Purchase order | 10000 | 0.016 | 2025-03
 |  |  |  |  |  |  |  | A02:FAN | D | Work order demand | -8088 | 0.016 | 2025-03
 |  |  |  |  |  |  |  | A02:FAN | D | EOM |  | 0.016 | 2025-03
 |  |  |  |  |  |  |  | A02:FAN | D | Work order demand | -3436 | 0.016 | 2025-04
 |  |  |  |  |  |  |  | A02:FAN | D | EOM |  | 0.016 | 2025-04
 |  |  |  |  |  |  |  | A02:FAN | D | Work order demand | -4524 | 0.016 | 2025-05
 |  |  |  |  |  |  |  | A02:FAN | D | EOM |  | 0.016 | 2025-05
 |  |  |  |  |  |  |  | A02:FAN | D | Work order demand | -4732 | 0.016 | 2025-06
 |  |  |  |  |  |  |  | A02:FAN | D | Planned order | 10000 | 0.016 | 2025-06
 |  |  |  |  |  |  |  | A02:FAN | D | EOM |  | 0.016 | 2025-06