IE 312 Assignment 2 This is an individual assignment. Opening your data file (Surname, Name-1D.xlsx) in google docs may create structural problems in the file. So, please open it (preferably) in MS Excel, or other offline spreadsheet applications. Submit your hand-written solutions as a single pdf file containing all the answers. You can submit your files multiple times but only the last submitted file will be graded. Tasks; 1) Develop a From-To Chart (based on the daily flows) for the given departments using the given item properties. 2) Convert this chart to an Activity Relationship Chart. State your assumptions clearly. 3) Obtain a layout using Relationship Diagramming Procedure. B F A Item Item 1 Item 2 Item 3 Item 4 Item 5 Item 6 Item 7 Item 8 Item 9 Weight 50 kg 30 kg 10 kg 40 kg 30 kg 30 kg 50 kg 40 kg 50 kg Dept. A B D E F Area 90 60 80 50 40 50 B Item Item 7 Item 2 Item 6 Item 9 Item 4 Item 9 Item 4 Item 3 Item 2 Item 8 Item 1 Item 2 Item 6 Item 5 Item 8 Item 8 Units 35 25 50 15 20 65 45 70 95 10 80 50 90 95 75 25 Frequency Weekly Daily Weekly Daily Monthly Weekly Weekly Daily Weekly Weekly Daily Daily Monthly Monthly Monthly Monthly From B E E F B F D D D E E B B B E E E F E F D D A D B