Process Throughput Rate

Process Throughput Rate

Develop an Excel spreadsheet that will determine the maximum throughput rate of a process (i.e. the actual throughput rate of the process if it is not being starved by supply or blocked by demand.) The spreadsheet should be able to adjust for the possibility that not all of the product will go through all steps. The spreadsheet should be able to calculate the throughput rate for any process with up to 12 steps.

Inputs will include:

• Labels for each of the steps in the process • Work-in-process inventory for each step of the process • Flow time for each step of the process • The percentage of product that passes through each step in the process

Outputs will include:

• Designed throughput rate for each step of the process • Maximum actual throughput rate for the entire process.

Is this the question you were looking for? If so, place your order here to get started!