Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI there,
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.
A | B | C | D | E | F | G | H | I | |
2 | id_code_dwlog | dt_date_order | 24/11/2010 | 25/11/2010 | 26/11/2010 | 29/11/2010 | 30/11/2010 | 01/12/2010 | 02/12/2010 |
3 | CODE A | STOCK | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 |
4 | CODE A | ORDERS | 200 | 250 | 200 | 250 | 200 | 200 | 200 |
5 | CODE A | STOCK-ORDERS | 800 | 600 | 690 | 810 | 810 | 630 | 600 |
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.
Axo
Would be easier if you could upload an excel with the date & the desired results
added,
thank you for your time