Problem $1$

Template Data

Quality level Quality level

Working Days Working Days

Shifts Shifts

Length of shift $($hours$)$ Length of shift $($hours$)$

Operators per shift Operators

Planned downtime per shift $($minutes$)$ Planned downtime per shift $($minutes$)$

Cycle Time of the resource activity $($sec$)$ Cycle Time of the resource activity $($sec$)$

Demand for finished goods per week Demand for finished goods per week

Demand for finished goods per day Demand for finished goods per day

Budgeted $/$ Target PPH Budgeted $/$ Target PPH

Total Parts Produced all shifts Total Parts Produced All shifts

Length of shift $($minutes$)0$

Length of shift $($seconds$)0$ Answer the following:

Planned downtime per shift $($seconds$)0$ Are you meeting takt time

Available time per shift $($seconds$)0$ Are you meeting $/$ exceeding productivity target?

Available time per shift $($hours$)0$ Are you generating FG inventory?

Available Seconds per Day $0$ Number of operators per shift needed to meet or exceed target PPH $($same quality$)$

Number of Parts to be scheduled per day $($based on yield loss$)$ #DIV$/0!$ Can Increasing Quality to $100\%$ meet target PPH without changing original number of operators?

After Quality Losses #DIV$/0!$

Defects #DIV$/0!$

Net Effective Cycle Time #DIV$/0!$

Takt Time $($sec$)$ #DIV$/0!$

Productivity $-$ Parts Per Person per hour $($PPH$)-$ based on quality rate #DIV$/0!$