Please solve in excel file

This project is aimed at giving an understanding on information- based strategies by a real life scale data. Students are required to design a plant layout for the production of a given product mix. The project will require you to maneuver and calculate the necessary flow of information on a large data set such as Bill of Materials(BOM), Routes, Work Centers for selected products. In order to promote the team approach, groups of three students will be allowed for each project. To get started, please create your groups of 3, give it a name and specify it on the excel file by next Friday. In the first phase of the facility design project, each group will submit followings: 1. All parts are identified and enumerated in the parts list provided by file s1pl.doc. 2. The route sheets for the parts to be manufactured in the facility are prepared and documented in the s2rs.doc template. 3. The route sheets contain the standard times for performance of each manufacturing operation or process. These standard times are necessary to estimate the machine requirements. The machine requirements are documented using the s2mrt.doc template. 4. The materials required for the fabrication of various parts are documented in the s2mmr.doc template. 5. The necessary equipment will be purchased after a careful review of possible vendors. The costs for the machinery will be tabulated using the s2mct.doc template. This project is aimed at giving an understanding on information- based strategies by a real life scale data. Students are required to design a plant layout for the production of a given product mix. The project will require you to maneuver and calculate the necessary flow of information on a large data set such as Bill of Materials(BOM), Routes, Work Centers for selected products. In order to promote the team approach, groups of three students will be allowed for each project. To get started, please create your groups of 3, give it a name and specify it on the excel file by next Friday. In the first phase of the facility design project, each group will submit followings: 1. All parts are identified and enumerated in the parts list provided by file s1pl.doc. 2. The route sheets for the parts to be manufactured in the facility are prepared and documented in the s2rs.doc template. 3. The route sheets contain the standard times for performance of each manufacturing operation or process. These standard times are necessary to estimate the machine requirements. The machine requirements are documented using the s2mrt.doc template. 4. The materials required for the fabrication of various parts are documented in the s2mmr.doc template. 5. The necessary equipment will be purchased after a careful review of possible vendors. The costs for the machinery will be tabulated using the s2mct.doc template