ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formula for kanban cycle usage (https://www.excelbanter.com/excel-discussion-misc-queries/202597-formula-kanban-cycle-usage.html)

Angie

Formula for kanban cycle usage
 
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?
--
Thank you,
Angie

Otto Moehrbach[_2_]

Formula for kanban cycle usage
 
Tell us what a "kanban" card is. Otto
"Angie" wrote in message
...
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?
--
Thank you,
Angie



Angie

Formula for kanban cycle usage
 
A kanban card is a signaling system to trigger action such as taking
components to a production line when the production line is in need of more
components.
--
Thank you,
Angie


"Otto Moehrbach" wrote:

Tell us what a "kanban" card is. Otto
"Angie" wrote in message
...
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?
--
Thank you,
Angie




Bob I

Formula for kanban cycle usage
 
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?



Angie

Formula for kanban cycle usage
 
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?




Bob I

Formula for kanban cycle usage
 

The formula will depend on a lot of unstated information. I just told
you how to figure it out. One box is 16/81 hours. How many kanban cards
will you need for what? How long does it take from card pick up till box
delivered? Start by determining WHAT you need to do before you try
inserting it into Excel.



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?






All times are GMT +1. The time now is 12:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com