I've been working a sheet to manage stock levels for my place of work.
Basically it's a "kanban", "JIT" system where you have a level of stock and a re-order level, if the level of stock goes below your min level it will highlight to say "order more".
On one sheet I have a summary of the parts/stock levels and the rows below you can enter a quantity in the headed row for that item and select Add/remove to either add to stock, or remove from stock, this applies the numbers to a seperate sheet which adds/subtracts the numbers and updates the current stock level on the summary.
It works ok, but is very limited and can be a lot of work just to add another new product to the list, new columns, on both sheets, referencing the cells, etc etc.
What I'm wondering is does anyone know of a template/sheet which will do this already, just to save me hours updating it?
I've been searching on google all morning and I'm unable 't find anything I need
Any suggestions?
Basically it's a "kanban", "JIT" system where you have a level of stock and a re-order level, if the level of stock goes below your min level it will highlight to say "order more".
On one sheet I have a summary of the parts/stock levels and the rows below you can enter a quantity in the headed row for that item and select Add/remove to either add to stock, or remove from stock, this applies the numbers to a seperate sheet which adds/subtracts the numbers and updates the current stock level on the summary.
It works ok, but is very limited and can be a lot of work just to add another new product to the list, new columns, on both sheets, referencing the cells, etc etc.
What I'm wondering is does anyone know of a template/sheet which will do this already, just to save me hours updating it?
I've been searching on google all morning and I'm unable 't find anything I need
Any suggestions?