Formula to Auto calculate stock that needs to be ordered

[caf20012]

Hi all

I need a way to monitor stock levels from using information from stock counts and delivery averages per month. Also taking into account that deliveries are twice per week. So 8 times a month.

I need a method or formula where it will tell me what stock i need to order. This is so each month if i update the stock count and average what i supplied it will tell me what stock i should order over the next 8 deliveries.


Not sure if this is the right forumla ive already done.

Please check the attachment.

[caf20012]

Anyone?

Able to help

[Pepe Le Mokko]

Hi. As you probably know this a a free forum where members volunteer to help on their spare time. If you have an urgent query, I suggest you use a paying forum.