Expert Answer :MGMT640 case study 2

Solved by verified expert :· The case study 2 is Line Balancing (see the case file posted under the Course Documents). Answer questions at the end of the case. Use Excel to develop the precedence diagram, identify cycle time and minimum number of workstations, identify and present assignments, and calculate efficiency and idleness of the process and explain them. You can also do all required write-ups in the Excel file.· Prepare the case study report in Excel. Please, remember that the name of the Excel file may contain only letters, numbers, and underscores.The name of the file should not contain special characters like #, $, *, &, /, and others.· Submit the case report to the instructor by utilizing the Submit Assignments button in the course homepage, and then the File to Attach option to attach your file with the case study report.Case 2: Line Balancing• Darsoft Inc., a large manufacturer of personal computers, assembles Intel Core Duo motherboards on a product line. According to the production technology, the tasks that must be performed on each motherboard are shown below. Production quotas require that 60 completed units be assembled in a 10-hour shift. Task Description Predecessor Time (minutes) ____________________________________________________________________________________ A Assemble motherboard frame none 3 B Install circuit board #1 A 5 C Install circuit board #2 A 4 D Install controller A 3 E Install hard drive B,C 6 F Install disk drives D,E 4 G Install power supply E 3 H Install motherboard cover F,G 2 I Final quality check H 6 ____________________________________________________________________________________Questions. Explain why the line balancing approach may be used for this case.Develop precedence diagram for this case in Excel or Word, identify cycle time and minimum number of workstations.Using the rule of the longest task (operation) time, identify and present assignments of tasks to the workstations.Identify efficiency and idleness of the process and explain what they mean.