This content has been marked as final. Show 2 replies
does anybody know how to solve the problem below?
Desired Result 1: is the consumption of actual stock of code A. At a given time 24/11 you start with a stock of 1000 and I would like to know how the stock will evolve by fulfilling orders.
Desired Result 2: I would like to know how many days of coverage I have before getting out of stock.
|6||CODE A||DESIRED RESULT 1||800||550||350||100||-100||-300||-500|
|7||EXCEL FORMULA||=D3-D4||=D6-E4||=E6-F4||=F6-G4||=G6-H4||=H6-I4||ETC... ETC….|
|DESIRED RESULT 2||4||3||2||1|
Thank in advance for any ideas or help.