ONLY EXCEL PLEASE

PLEASE USE EXCEL FOR THIS! EXAMPLE OF EXCEL BELOW!

PLEASE USE EXCEL FOR THIS!

.. 9.12 Stanford Rosenberg Computing wants to establish an assembly line for producing a new product, the Personal Digital Assistant (PDA). The tasks, task times, and immediate predecessors for the tasks are as follows: TASK TIME (sec) IMMEDIATE PREDECESSORS A A 12 B 15 A 8 A D 5 B, C E 20 D Rosenberg's goal is to produce 180 PDAs per hour. a. What is the cycle time? b. What is the theoretical minimum for the number of work-stations that Rosenberg can achieve in this assembly line? c. Can the theoretical minimum actually be reached when workstations are assigned? PX Ovo A B D E F G H I J K 1 CHAPTER 9: Example 4 2 2 3 Assembly Line Balancing 4 4 Enter the cycle time below. You may need to compute it based on demand. Be certain the time unit (minutes, second, hrs) matches the task time unit. Enter 5 the data for each task. Predecesors should be separated by commas. Enter a number between 1 and 6 6 7 Data 8 Priority rule 1 Priority rule Cycle time 12 1 2 3 4 5 Most Ranked Least Lookup Immediate Longest following Positional Shortest following 10 Criterion Task Name Task Time Predecessors Row number operation time tasks Weight operation time tasks 11 10.0001 A 10 1 10 9 0 0.1 0.1 12 11.0002 B 11 A 2 11 6 0 0.090909091 0.090909091 13 5.0003 C 5B 3 5 4 0 0 0.2 0.2 14 4.0004 D 4B 4 4 4 0 0.25 0.25 15 12.0005 E 12A 5 12 3 0 0.083333333 0.083333333 16 3.0006 F 3 CD 6 3 3 0 0.333333333 0.333333333 17 7.0007G 7 F 7 7 2 0 0.142857143 0.142857143 18 11.0008 H 11 E 8 11 2 0 0 0.090909091 0.090909091 19 3.00090 3 GH 9 3 1 0 0.333333333 0.333333333 20 21 Station Assignments 22 Station 1 1 2 3 4 5 5 5 6 6 23 Activities A E H B D F G I 24 Idle Time 2 0 1 1 0 2 25 26 Results Summary 27 Cycle time 12 28 Time needed per cycle (E task times) 66 29 Min (theoretical) # of stations 6 30 31 Actual number of stations 6 32 Time allocated per cycle 72 33 Idle time per cycle 6 6 34 Efficiency 0.916666667 35 Balance delay 0.083333333 36