Hi, The formats: plan-character, week-character, beginning_inventory, usage and orders are nuemrical. Example of data: Plant Week beginning_Inventory usage orders ending inventory (has to be calculated....) h 01/14/2017 30 5 22 a 01/21/2017 . b 01/29/2017 . I need to calculate ending inventory: ending_inventory=beginning_inventory-usage+orders. So for the first week it is easy to get ending_inventory whihc is 30-5+22=47 now this ending inventory from the week 01/14/2017 needs to become my beginning inventory for the week 01/29/2017 an so on... Any idea how to approach this problem? Thank you so much.
... View more