I've been banging my head against the wall for the better part of 2 days now trying to figure this thing out.
I have an commodity product. a beg inv, an injection/withdraw, a COGS, and an ending inventory. and my inventory resets to 0 every 12 months
i think i have the cogs on a withdraw from inventory down. i basically used the small function to find the earliest date and with an if then statement i.e if withdraw > injection @ month 1 then use month 1 vol then would be withdraw greater than sum(month1,month2) then use those 2 and going down the 12 months. i can't figure out however, how to deduct what i have withdrew from the original inventory at month 1.
example. month 1 injection 50, month 2 100, month 3 -75. i can't get month 1 to be at 0 and month 2 at 75.
is there an easy way to do this without creating 7 sheets and 14 tables?
thanks in advance
I have an commodity product. a beg inv, an injection/withdraw, a COGS, and an ending inventory. and my inventory resets to 0 every 12 months
i think i have the cogs on a withdraw from inventory down. i basically used the small function to find the earliest date and with an if then statement i.e if withdraw > injection @ month 1 then use month 1 vol then would be withdraw greater than sum(month1,month2) then use those 2 and going down the 12 months. i can't figure out however, how to deduct what i have withdrew from the original inventory at month 1.
example. month 1 injection 50, month 2 100, month 3 -75. i can't get month 1 to be at 0 and month 2 at 75.
is there an easy way to do this without creating 7 sheets and 14 tables?
thanks in advance
