consider the following vendor classification basea on their overall performance scores: Developmental (less than 70) - supplier is required to take corrective action if it is rated at this level for three consecutive months during the calendar year. Acceptable (between 70 and 89*) - supplier is required to provide a plan to Federal-Mogul on how to achieve preferred status. Preferred (between 90 and 100) - supplier to be worked with on new product development, approve for new business, and assist in maintaining a competitive position. *The upper boundary is not included. The data related to the weights to each of the performance dimensions and ratings for three companies has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet Questions 1. Calculate the total scores for three vendors. Do not round intermediate calculations. Round your answers to two decimal places. Sun Devils: Gamecocks: Spartans: 2. Classify vendors based on their overall scores. The Sun Devils Company is considered a(an) supplier The Gamecocks Company is considered a(an) supplier. The Spartans Company is considered a(an) supplier. Supplier Scorecard Min (>=) 0 70 90 Max (