create s functional sheet (criteria for each supplier), landed cost and ppm. please write the formulas

Assignment 1- Create "functional" tool (spreadsheet) to assist you in making good sourcing decisions. Using the Data-Facts contained in this file, determine the "best" supplier to produce the car door mirror assenbly Use this tab for your answer, the data facts are on the 2nd tab, and I want you to create your function tool on the 3 rd tab. Requirement: Create a One page, working, spreadsheet, not a Word document, a spreadsheet. - Must be functional, that is, a working spreadsheet i.e. must do calculations which will change automatically if the input variables change - Must show clearly the logic used to come to your final selection 1. Go to any car dealership and inspect the models in the showroom. Talk to a salesperson, tell them what your assignment is and they w give you the features or functions that the mirror assemblies perform. List them below... le Situational Analysis Name of Car that you researched...ie.Mercedes C300: Acura MDX: Tovota Camry: What was the trim level i.e. LX; EX; EX-L: List the features of the iminu assennuly veium veriur........ 1 2 3 4. 5. 6. Based on the course text, Ppt slides, or your research, answer the following questions: 1. Define the following: a) Rlark Rnv Sunnliar b) Riau anv Cunnliar c) Whire Rnx Sunnlier d) Given the complexity of the product above and definitions above, what level of supplier do you think is required to make the product in question? 3. Based on the information provided in the Data-Facts tab, please provide the calculated PPM for each supplier 2. When considering product auality. what is "PPM" and how is it calculated? 4. Define: Total Landed raer. ] PRODUCT to be SOURCED: AUTOMOTIVE DOOR MIRRORS our of the vehicle ?d parts must be Supplier D 200,000 Existing Montreal, P