Bob,

What formula could I use in Excel without using all the verbage.
--
Thank you,
Angie


"Bob I" wrote:

You may have 32 pieces at the station. 32/81 is the amount of time they
will last in the form of a decimal hour. How long does it take to send a
new box to the station from the time the cards are picked up? In round
numbers you will need to replace an empty box every 1/5 of an hour to
keep up so every 12 minutes.

Angie wrote:

Hello,

I have 5 different part numbers that are on a production line and I have
listed below one of the part numbers.

part # PPC-0013, at process #3, 2 boxes (16 pcs each box) can be kept at the
line. The production is scheduled for 81 pieces an hour.

What type of formula can be used to figure up amount of kanban cards needed
and how often to pick up the kanban cards?