Excel Online Structured Activity: Supplier Scorecard for XYZ Company

Consider the following XYZ Company classification based on it's overall performance scores:

Unacceptable (less than 50) supplier dropped from further business Conditional (between 50 and 70*) supplier needs development work to improve performance but may be dropped if performance continues to lag Certified (between 70 and 90*) supplier meets intended purpose or performance Preferred (between 90 and 100) supplier will be considered for involvement in new product development and opportunities for more business *The upper boundary is not included.

The data related to the weights to each of the performance dimensions and ratings has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.

Questions

1. Calculate the total score. Do not round intermediate calculations. Round your answer to two decimal places.

fill in the blank 2

2. Classify vendor based on it's overall score.

Based on the total score, the XYZ Company is considered a(an) _________supplier.

Period	Actual Demand	Forecast	Formulas
1	1,200		#N/A
2	2,400		#N/A
3	2,200		#N/A
4	1,400		#N/A
5	2,700		#N/A
6	3,500		#N/A
7	3,400		#N/A
8	3,300		#N/A
9	4,300		#N/A
10	4,700		#N/A
11	4,300		#N/A
12	4,300		#N/A
13			#N/A
	Intercept		#N/A
	Slope		#N/A