Forum Discussion
FIFO Inventory Formula Challenge
To revel my second anniversary as a member of this EXCELlent Community, I hereby proffer this challenge to season your array manipulation skills. Perhaps, keenadvice mathetes Riny_van_Eekelen PeterBa...
Here is the link to my detailed explanation of my two solutions:
https://roberthontoriagascon.medium.com/these-fifo-inventory-formulas-will-challenge-your-array-manipulation-skill-129a8f680ad?source=friends_link&sk=915b52e8696e1cf06fad1baff7563a21
https://roberthontoriagascon.medium.com/these-fifo-inventory-formulas-will-challenge-your-array-manipulation-skill-129a8f680ad?source=friends_link&sk=915b52e8696e1cf06fad1baff7563a21
Twifoo Nice technique and explanation!
Bearing in mind ABS(x) = x^2^0.5, our methods are not too dissimilar. For 'Courage' the second formula I posted evaluates to:
=SUM({76;65}*{141,-40;40,40})
where for the sake of brevity an extra MMULT was omitted that would have resulted in:
=SUM({76;65}*{101;80})
Aside: It also occurred to me to use MDETERM({76,-80;65,101}) which returns the same result of 12876. Maybe not so useful in this case but could save looking up prices and quantities individually for calculating total cost =65*760+76*101.