The purpose of this assignment is to align proper service system applications to certain industries. You will also analyze and evaluate a company’s customer service strengths and challenges. Select a company you are familiar with, such as your own employer or a public company that you know you can find customer service data on. Identify the type(s) of service system used in the company or a certain part of the company.  Create an 8- to 10-slide PowerPoint presentation, including detailed speaker notes, that outlines and highlights the system strengths and weaknesses. Include an analysis of industry comparisons if available. Choose a service system from this assignment that you will implement in the Supply Chain Template assignment in Week 6.

Question 1In G14: Use the VIN # code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following:If the vehicle is a Toyota Camry insert the Sales Price, otherwise the cell should be blank. Copy the function down to the other cells in the column.In cell G13 use the appropriate function to calculate the total from the results.Question 2In H14: Use the VIN # code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following:If the vehicle assembly plant is Toyota City insert the Sales Price, otherwise the cell should be blank. Copy the function down to the other cells in the column.In cell H13 use the appropriate function to calculate the total from the results.Question 3In I14: Use the VIN # code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following:If the vehicle model year is 2016 insert the MSRP, otherwise the cell should be blank. Copy the function down to the other cells in the column.In cell I13 use the appropriate function to calculate the total from the resultsQuestion 4In J14: Use the VIN # code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following:If the vehicle has a Diesel engine and is assembled in Puebla insert the number 1, otherwise the cell should be blank. Copy the function down to the other cells in the column.In cell J13 use the appropriate function to count the number of results.Question 5In K14: Use the VIN # code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following:If the vehicle is a Toyota sold in 2013 insert the Sales Price, otherwise the cell should be blank. Copy the function down to the other cells in the column.In cell K13 use the appropriate function to calculate the total from the resultsQuestion 6In L14: Use the VIN # code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following:If the vehicle is a Blue or Metallic Blue colour insert the Sales Price, otherwise the cell should be blank. Copy the function down to the other cells in the column.In cell L13 use the appropriate function to calculate the total from the results.Question 7In M14: Use the VIN # code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following:If the vehicle is a Toyota with a Metallic Red or Metallic Blue colour insert the Sales Price, otherwise the cell should be blank. Copy the function down to the other cells in the column.In cell M13 use the appropriate function to calculate the total from the resultsQuestion 8In N14: Use the VIN # code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following:If the vehicle was sold by sales rep Ming in 2014 or 2015 insert the Sales Price, otherwise the cell should be blank. Copy the function down to the other cells in the column.In cell N13 use the appropriate function to calculate the total from the resultsQuestion 9In O14: Use the VIN # code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following:If the vehicle is Red or Metallic Red and the Sales Price is more than $22,000 insert the number 1, otherwise the cell should be blank. Copy the function down to the other cells in the column.In cell O13 use the appropriate function to count the number of results.Question 10In P14: Use the VIN # code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following:If the vehicle model year is 2015 or 2016 and the MSRP is less than $21,500 insert the number 1, otherwise the cell should be blank. Copy the function down to the other cells in the column.In cell P13 use the appropriate function to count the number of resultsQuestion 11In Q14: Use the VIN # code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following:If the vehicle was assembled in Toyota City or Cambridge and was sold in 2013 or 2014 and has a Gas 1800 CC engine insert the number 1, otherwise the cell should be blank. Copy the function down to the other cells in the column.In cell Q13 use the appropriate function to count the number of resultsQuestion 12In R14: Use the VIN # code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following:If the vehicle is Model Year 2015 or 2016 and is assembled in Cambridge, Dusseldorf or Puebla insert the number 1, otherwise the cell should be blank. Copy the function down to the other cells in the column.In cell R13 use the appropriate function to count the number of results.