Spreadsheet: 886713d1736825901-power-query-onhand-calculation-power-query-onhand-calculation
Sheet: FNDWRR

ORIGINAL |  |  |  |  |  |  | RESULT
ORGANIZATION | ITEM | ORDER TYPE | QUANTITY | COST | SUGG DUE DATE |  | 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 | 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 | 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 | 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 | EOM | 99.17052 | 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 | 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 | -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 | EOM | 150.03052 | 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 | -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 | -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 | EOM | 95.66824 | 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 | 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 | 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 | A | EOM | 644.34424 | 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 | 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 | A | EOM | 580.3928 | 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 | 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 | 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 | A | EOM | 559.56024 | 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 | 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 | A | EOM | 1259.56024 | 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 | 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 | 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 | -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 | EOM | 72012 | 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 | 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 | 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 | B | EOM | 78266 | 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 | 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 | 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 | B | EOM | 85482 | 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 | 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 | 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 | B | EOM | 93807 | 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 | 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 | 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 | 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 | B | EOM | 104719 | 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 | 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 | B | EOM | 30874 | 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 | 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 | 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 | 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 | C | EOM | 19.38877 | 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 | 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 | C | EOM | 14.04697 | 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 | 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 | Purchase order | 18.1437 | 63.77691 | 2025-03
 |  |  |  |  |  |  | A02:FAN | C | Work order demand | -5.8596 | 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 | EOM | 26.33053 | 63.77691 | 2025-03
 |  |  |  |  |  |  | A02:FAN | C | Work order demand | -5.5425 | 63.77691 | 2025-04 |  | A02:FAN | C | Work order demand | -5.5425 | 63.77691 | 2025-04
 |  |  |  |  |  |  | A02:FAN | C | EOM |  | 63.77691 | 2025-04 |  | A02:FAN | C | EOM | 20.78803 | 63.77691 | 2025-04
 |  |  |  |  |  |  | A02:FAN | C | Work order demand | -6.06348 | 63.77691 | 2025-05 |  | A02:FAN | C | Work order demand | -6.06348 | 63.77691 | 2025-05
 |  |  |  |  |  |  | A02:FAN | C | EOM |  | 63.77691 | 2025-05 |  | A02:FAN | C | EOM | 14.72455 | 63.77691 | 2025-05
 |  |  |  |  |  |  | A02:FAN | C | Work order demand | -0.00075 | 63.77691 | 2025-06 |  | 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 | Work order demand | -3.62166 | 63.77691 | 2025-06
 |  |  |  |  |  |  | A02:FAN | C | EOM |  | 63.77691 | 2025-06 |  | A02:FAN | C | EOM | 11.10214 | 63.77691 | 2025-06
 |  |  |  |  |  |  | A02:FAN | D | On Hand | 8406 | 0.016 | 2025-01 |  | A02:FAN | D | On Hand | 8406 | 0.016 | 2025-01
 |  |  |  |  |  |  | A02:FAN | D | Work order demand | -3592 | 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 | EOM | 4814 | 0.016 | 2025-01
 |  |  |  |  |  |  | A02:FAN | D | Purchase order | 10000 | 0.016 | 2025-02 |  | A02:FAN | D | Purchase order | 10000 | 0.016 | 2025-02
 |  |  |  |  |  |  | A02:FAN | D | Work order demand | -5948 | 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 | EOM | 8866 | 0.016 | 2025-02
 |  |  |  |  |  |  | A02:FAN | D | Purchase order | 10000 | 0.016 | 2025-03 |  | A02:FAN | D | Purchase order | 10000 | 0.016 | 2025-03
 |  |  |  |  |  |  | A02:FAN | D | Work order demand | -8088 | 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 | EOM | 10778 | 0.016 | 2025-03
 |  |  |  |  |  |  | A02:FAN | D | Work order demand | -3436 | 0.016 | 2025-04 |  | A02:FAN | D | Work order demand | -3436 | 0.016 | 2025-04
 |  |  |  |  |  |  | A02:FAN | D | EOM |  | 0.016 | 2025-04 |  | A02:FAN | D | EOM | 7342 | 0.016 | 2025-04
 |  |  |  |  |  |  | A02:FAN | D | Work order demand | -4524 | 0.016 | 2025-05 |  | A02:FAN | D | Work order demand | -4524 | 0.016 | 2025-05
 |  |  |  |  |  |  | A02:FAN | D | EOM |  | 0.016 | 2025-05 |  | A02:FAN | D | EOM | 2818 | 0.016 | 2025-05
 |  |  |  |  |  |  | A02:FAN | D | Work order demand | -4732 | 0.016 | 2025-06 |  | A02:FAN | D | Work order demand | -4732 | 0.016 | 2025-06
 |  |  |  |  |  |  | A02:FAN | D | Planned order | 10000 | 0.016 | 2025-06 |  | A02:FAN | D | Planned order | 10000 | 0.016 | 2025-06
 |  |  |  |  |  |  | A02:FAN | D | EOM |  | 0.016 | 2025-06 |  | A02:FAN | D | EOM | 8086 | 0.016 | 2025-06