industrial engineering Excel1

1.(15%) Based on your own research online and career resources available at Mizzou, select 3 companies you might be interested in working for in the future, provide your reasoning for each selection.2.(10%) What are the University’s General Education Requirements? (Check out the following website: [login to view URL])Check out the College of Engineering website ([login to view URL] - GPA Grade Replacement and Academic Probation/Dismissal) to answer questions 3 and 4: 3.(10%) What is the University’s grade replacement policy?4.(10%) What constitutes good academic standing and what can cause you to be put on probation? 5.(25%) Using the IMSE Excel-based flowchart discussed in class, create your own 4-year degree plan (submit a copy of both the Flow Chart and Curriculum sheets – Cut and Paste them into your Word Document).6. (30%) Allocating Resources in Excel using Solver – Optimize the quantity of individual production units that depends on varying amounts of fixed resources. The [login to view URL] spreadsheet contains a model formulation for a toy company (Toys For Us) that makes five different toys. These toys use six different materials in varying amounts. For example, Toy E uses 3 units of red paint, 0 unit of blue paint, 2 units of white paint, 1 unit of plastic, and 5 units of wood, and 3 units of glue. Column G shows the current inventory of each type of material. Row 10 shows the unit profit for each toy. Run Solver (being sure to use Simplex LP as the solver), then discuss the results that you obtain with respect to the quantity to produce of each time, inventory used and remaining and overall company profit.