The operations of a manufacturing / assembly line to produce 1500 units per 8-hour shift has been balanced. See below. During the 8-hour shift just 30 minutes is allowed for break times. The current performance rate of the production line is 85%. Balance the following assembly line to produce 1500 units per 8-hour shift (minus 1-30 minutes personal time break). Production Performance Rate is 85%. Operation No. 1 2 3 4 5 6 1 over = Time Standard (Minutes/Unit) 0.390 0.235 0.700 1.000 0.240 0.490 3.055 0.33 Actual Number of Work Stations/ Operation 2 1 3 4 1 2 Average Stations Per Cycle 0.195 0.235 0.233 0.250 0.240 0.245 % Load Hours Per Pieces Per Unit Hour 78.0% 0.00833 94.0% 0.00417 0.01250 93.3% 100.0% 0.01667 96.0% 0.00417 98.0% 0.00833 120 240 80 60 240 120 860 1720 Explain how the line balancing solution was derived. Submit your explanation of this line balancing exercise as a Word document through Blackboard. Hint*- Cut and paste to use spreadsheet to determine values to go into your answer explanations. With your explanation, be sure to address and explain: 1) Number of Units Required per Shift. 2) Takt Time-Plant Rate (R) (Minutes/Unit) value without adjustments 3) How Percent Performance influences the actual number of units that will need to be produced. Adjusted Takt Time-Plant Rate (Adjusted R) (Minutes/Unit) value. 4) How the number of work stations were derived. 5) Which Operation Number constrains (acts as a bottleneck (busiest)) all other operations? In other words, which operation with associated workstations is closest to the adjusted Plant Rate (Adjusted R)? 6) How was % Load for each operation derived from the actual number of work stations? How is Hours per Unit derived? Hint: Take the operations time standard, divide it by a certain value in another column, and then divide by 60 Minutes / Hour. 7) How do the values for the individual time standards relates to the Average Stations per Cycle Rate and the Adjusted Takt Time-Plant Rate (R)? 8) Does the Total for the Pieces per Hour Indicate that one production line is currently used? How many production lines are needed to make the 1720 Pieces per Hour at 85% performance rate? Why?