Visual controling of stock level

[Pheng]

I am wanting to create a spreadsheet that will allow me a visual coun
on the level of stocks I have.

I want to nominate an intended level of a product, have a colum
showing items on back-order and also another column showing items i
transit.

I want it to display a message saying:

• I need to order x qty of a product because it is below the intende
level.
• Display a message saying no order is needed due to being at th
intended level.
• A message showing a qty over the intended level.

I guess the two columns (transit and back order) will need to b
considered to allow the appropriate message based on the intende
level.

Any assistance is greatly appreciated

 

[Andy B]

Hi

Usually on a sheet such as this you'd probably have a stock level, back
order level, transit qty, reorder level and reorder qty. You may also want a
level to top up to.
You'd set the reorder level to trigger when to reorder (this may be zero),
and the reorder qty is used if you have to buy in certain pack sizes.
I could mock up a sample if you are interested. Email me privately.