Stock/Inventory Management

[robrobby]

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?

 

[tweedle]

can check this post on similar scenario:

 

[robrobby]

That looks like an ideal suggestion, I'll try that out.

Thanks

 

[robrobby]

Many thanks, the formulas in the examples helped a lot, and I've learned a few things from it also.

Thanks again.