PPH and Net Effective Cycle Time

Follow the directions in the attachment on each problem tab.Complete each of the problem tabs with the data set given. Be sure to answer the 4 questions per problem.

Template Quality level Working Days Shifts Length of shift (hours) Operators per shift Planned downtime per shift (minutes) Cycle Time of the resource activity (sec) Demand for finished goods per week Demand for finished goods per day Budgeted/Target PPH Total Parts Produced all shifts Length of shift (minutes) Length of shift (seconds) Planned downtime per shift (seconds) Available time per shift (seconds) Available time per shift (hours) Available Seconds per Day Number of Parts to be scheduled per day (based on yield loss) After Quality Losses Defects Net Effective Cycle Time Takt Time (sec) Productivity - Parts Per Person per hour (PPH) - based on quality rate Data 0 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Problem 1 Quality level Working Days Shifts Length of shift (hours) Operators Planned downtime per shift (minutes) Cycle Time of the resource activity (sec) Demand for finished goods per week Demand for finished goods per day Budgeted/Target PPH Total Parts Produced All shifts Answer the following: Are you meeting takt time Are you meeting / exceeding productivity target? Are you generating FG inventory? Number of operators per shift needed to meet or exceed target PPH (same quality) Can Increasing Quality to 100% meet target PPH without changing original number of operators? Data Set 70.00% 5 3 8 5 45 5 52200 10440 35 11000