Stock Control

[David.M]

The problem:

Trying to use Excel to set-up and run a small stock
control system and I cannot find a way to do it (espec.
with limited knowledge).

The main problem - I think - is finding a formula that
will allow me to enter the stock.
Say I start out with a stock of 10.
This figure will eg allow me to make 5 assemblies.
I build 3 assemblies so want to reduce the figure 10 by 6
leaving a stock balance of 4.
I now get a delivery of 8 parts.
How can I enter the new 8 figure and be told that I can
build 6 assemblies?
Can you help? can it be done?

I thought at first that it must be simple as surely such a
route will be used by many people - unfortunately it has
completely stumped me.

 

[Kieran]

David.M

Could it be that the number of assemblies that can be made is equal to
the (total stock on hand) /2

something like

PotentialAssemblies = INT(TotalStock / 2)

As assemblies are made, the total stock will reduce.
As more stock is received, the total stock will increase.

The INT() function is to prevent a result of 3.5 assemblies, where
there are 7 stock items.

 

[David.M]

Unfortunately not:-(
The machine takes various bills of materials and they are
all of varying quantities

david