Consider the following vendor classification based 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) _________developmentalacceptablepreferred supplier.

The Gamecocks Company is considered a(an) _________developmentalacceptablepreferred supplier.

The Spartans Company is considered a(an) _________developmentalacceptablepreferred supplier.

Supplier Scorecard
Performance Measure	Weight	Sun Devils	Gamecocks	Spartans		Min (>=)	Max (<)	Vendor Classification
Price	0.20	90	95	95		0	70	Developmental
Payment terms	0.20	95	70	60		70	90	Acceptable
Quality	0.20	80	80	55		90	100	Preferred
Delivery	0.10	75	85	85
Sugggestions for Quality Improvement	0.05	50	95	70			Total Scores	Classification	Formulas
Reputation	0.15	55	70	55		Sun Devils			#N/A	#N/A
Sustainability	0.10	85	55	85		Gamecocks			#N/A	#N/A
Total Score	1.00					Spartans			#N/A	#N/A