Stock & Orders Project
Instructions
Create an inventory system where on one sheet we can see the real stock, on the second sheet we see all the orders places, and on the third sheet we can see the production added.
The stocks are divided in Quality which are (A, B, C, ROTO).
Inside each one we have the colors on the top row of the chart and product name on the second column.
Example orders
On “Ordenes” sheet. Cell C8 must have a formula that when a number for example “58” is inserted, it must subtract from the “Stock” sheet.
· Another Example for cell M8 “Ordenes” sheet: if cell A8 says “A” and B8 says “Blanco” go to “Stock” sheet and subtract from E19
· Another Example for cell C9 “Ordenes” sheet: if cell A9 says “A” and B9 says “Bone” go to “Stock” sheet and subtract from F9
· Once all the quantities have been added to the row. On the column T of the respective row fill cell green and must say “SI”. If the stock of a certain item is below zero or negative, on column T of the respective row must appear in red “NO”. Once more production has been added and the orders can be fulfilled automatically change to “SI” in order starting from the top and working down.
Example Production
Same as Ordenes (above) but instead of subtracting, we just add the quantities to the real stock on the first sheet.