Due Date: May 25, 2014 23:59:59 Max Points:45Details:Complete problems 9.11, 9.13, and 9.15 in the textbook.Submit one Excel file. Put each problem result on a separate sheet in your file.You are not required to submit this assignment to Turnitin, unless otherwise directed by your instructor. If so directed, refer to the Student Success Center for directions. Only Word documents can be submitted to Turnitin.Details:Complete Problems 10.25, 10.29, E.3, E.5, and E.6 in the textbook.Submit one Excel file. Put each problem result on a separate sheet in your file.You are not required to submit this assignment to Turnitin, unless otherwise directed by your instructor. If so directed, refer to the Student Success Center for directions. Only Word documents can be submitted to Turnitin.9.11 Stanford Rosenberg Computing wants to establish anassembly line for producing a new product, the Personal DigitalAssistant (PDA). The tasks, task times, and immediate predecessorsfor the tasks are as follows:TASK TIME (sec)IMMEDIATEPREDECESSORSA 12 B 15 AC 8 AD 5 B, CE 20 DRosenbergs goal is to produce 180 PDAs per hour.a) What is the cycle time?b) What is the theoretical minimum for the number of workstationsthat Rosenberg can achieve in this assembly line?c) Can the theoretical minimum actually be reached when workstationsare assigned?9.13 Sue Helms Appliances wants to establish an assemblyline to manufacture its new product, the Micro PopcornPopper. The goal is to produce five poppers per hour. The tasks,task times, and immediate predecessors for producing one MicroPopcorn Popper are as follows:TASKTIME(min)IMMEDIATEPREDECESSORSA 10 B 12 AC 8 A, BD 6 B, CE 6 CF 6 D, Ea) What is the theoretical minimum for the smallest number ofworkstations that Helms can achieve in this assembly line?b) Graph the assembly line and assign workers to workstations.Can you assign them with the theoretical minimum?c) What is the efficiency of your assignment?9.15 The following table details the tasks required forIndiana-based Frank Pianki Industries to manufacture a fullyportable industrial vacuum cleaner. The times in the table are inminutes. Demand forecasts indicate a need to operate with a cycletime of 10 minutes.ACTIVITY ACTIVITY DESCRIPTIONIMMEDIATEPREDECESSORS TIMEA Attach wheels to tub 5B Attach motor to lid 1.5C Attach battery pack B 3D Attach safety cutoff C 4E Attach filters B 3F Attach lid to tub A, E 2G Assemble attachments 3H Function test D, F, G 3.5I Final inspection H 2J Packing I 2a) Draw the appropriate precedence diagram for this productionline.b) Assign tasks to workstations and determine how much idletime is present each cycle.c) Discuss how this balance could be improved to 100%.d) What is the theoretical minimum number of workstations10.25 Peter Rourke, a loan processor at Wentworth Bank,has been timed performing four work elements, with the resultsshown in the following table. The allowances for tasks such as thisare personal, 7%; fatigue, 10%; and delay, 3%.TASKELEMENTPERFORMANCERATING (%)OBSERVATIONS (MINUTES)1 2 3 4 51 110 .5 .4 .6 .4 .42 95 .6 .8 .7 .6 .73 90 .6 .4 .7 .5 .54 85 1.5 1.8 2.0 1.7 1.5a) What is the normal time?b) What is the standard time?10.29. The Dubuque Cement Company packs 80-poundbags of concrete mix. Time-study data for the filling activity areshown in the following table. Because of the high physical demandsof the job, the companys policy is a 23% allowance for workers.a) Compute the standard time for the bag-packing task.b) How many observations are necessary for 99% confidence,within {5% accuracy?ELEMENTOBSERVATIONS (SECONDS) PERFORMANCE1 2 3 4 5 RATING (%)Grasp and place bag 8 9 8 11 7 110Fill bag 36 41 39 35 112a 85Seal bag 15 17 13 20 18 105Place bag on conveyor 8 6 9 30b 35b 90aBag breaks open; included as delay in the allowance factor.bConveyor jams; included as delay in the allowance factorComplete problems 9.11, 9.13, and 9.15 in the textbook.Submit one Excel file. Put each problem result on a separate sheet in your file.You are not required to submit this assignment to Turnitin, unless otherwise directed by your instructor. If so directed, refer to the Student Success Center for directions. Only Word documents can be submitted to Turnitin.Details:Complete Problems 10.25, 10.29, E.3, E.5, and E.6 in the textbook.Submit one Excel file. Put each problem result on a separate sheet in your file.You are not required to submit this assignment to Turnitin, unless otherwise directed by your instructor. If so directed, refer to the Student Success Center for directions. Only Word documents can be submitted to Turnitin.9.11 Stanford Rosenberg Computing wants to establish anassembly line for producing a new product, the Personal DigitalAssistant (PDA). The tasks, task times, and immediate predecessorsfor the tasks are as follows:TASK TIME (sec)IMMEDIATEPREDECESSORSA 12 B 15 AC 8 AD 5 B, CE 20 DRosenbergs goal is to produce 180 PDAs per hour.a) What is the cycle time?b) What is the theoretical minimum for the number of workstationsthat Rosenberg can achieve in this assembly line?c) Can the theoretical minimum actually be reached when workstationsare assigned?9.13 Sue Helms Appliances wants to establish an assemblyline to manufacture its new product, the Micro PopcornPopper. The goal is to produce five poppers per hour. The tasks,task times, and immediate predecessors for producing one MicroPopcorn Popper are as follows:TASKTIME(min)IMMEDIATEPREDECESSORSA 10 B 12 AC 8 A, BD 6 B, CE 6 CF 6 D, Ea) What is the theoretical minimum for the smallest number ofworkstations that Helms can achieve in this assembly line?b) Graph the assembly line and assign workers to workstations.Can you assign them with the theoretical minimum?c) What is the efficiency of your assignment?9.15 The following table details the tasks required forIndiana-based Frank Pianki Industries to manufacture a fullyportable industrial vacuum cleaner. The times in the table are inminutes. Demand forecasts indicate a need to operate with a cycletime of 10 minutes.ACTIVITY ACTIVITY DESCRIPTIONIMMEDIATEPREDECESSORS TIMEA Attach wheels to tub 5B Attach motor to lid 1.5C Attach battery pack B 3D Attach safety cutoff C 4E Attach filters B 3F Attach lid to tub A, E 2G Assemble attachments 3H Function test D, F, G 3.5I Final inspection H 2J Packing I 2a) Draw the appropriate precedence diagram for this productionline.b) Assign tasks to workstations and determine how much idletime is present each cycle.c) Discuss how this balance could be improved to 100%.d) What is the theoretical minimum number of workstations10.25 Peter Rourke, a loan processor at Wentworth Bank,has been timed performing four work elements, with the resultsshown in the following table. The allowances for tasks such as thisare personal, 7%; fatigue, 10%; and delay, 3%.TASKELEMENTPERFORMANCERATING (%)OBSERVATIONS (MINUTES)1 2 3 4 51 110 .5 .4 .6 .4 .42 95 .6 .8 .7 .6 .73 90 .6 .4 .7 .5 .54 85 1.5 1.8 2.0 1.7 1.5a) What is the normal time?b) What is the standard time?10.29. The Dubuque Cement Company packs 80-poundbags of concrete mix. Time-study data for the filling activity areshown in the following table. Because of the high physical demandsof the job, the companys policy is a 23% allowance for workers.a) Compute the standard time for the bag-packing task.b) How many observations are necessary for 99% confidence,within {5% accuracy?ELEMENTOBSERVATIONS (SECONDS) PERFORMANCE1 2 3 4 5 RATING (%)Grasp and place bag 8 9 8 11 7 110Fill bag 36 41 39 35 112a 85Seal bag 15 17 13 20 18 105Place bag on conveyor 8 6 9 30b 35b 90aBag breaks open; included as delay in the allowance factor.bConveyor jams; included as delay in the allowance factor