From here, you will be asked to apply three different approaches to evaluate suppliers. Please read through the whole problem set and answer questions specific to each table by following the instructions accordingly. After applying three approaches, you will be asked to make a final recommendation. ------- Mrs. Kandells Christmas tree shop just conducted regular evaluations and got the following results.

Table 1COSTQUALITYServiceTotal (1pt each)AA+-O BBO+O CC-++

After reviewing, one of Mrs Kandells friend told her that her evaluation of those potential suppliers is not specific enough and urged her to adopt two other approaches. The friend argued that everything can be better quantified and created below Table 2 and Table 3 for her.

Table 2CostQualityService

Total

penalty

(1pt each)

Quoted price/unit

Net Adjusted

(2pts each)

AA-0.150%3.00%0.20% 83.15 BB-0.20%-2.00%0.20% 86.5 CC3.50%-1.00%-1.00% 84.23

The friend told her that Table 3, see below, has the most specific information:

Table 3Supplier AASupplier BBSupplier CCQuality (weight=50) Acceptable lots505849Total lots received556052

Quality rating

(1pt each in this row; 3 pts total)

Service (Weight=35)

On-time deliveries

(1pt)

51 52Total lots received556052

Service rating

(1pt each, 2 pts in total)

0.95 Price

Lowest price

83.15 Price submitted83.1586.584.23

Price rating

(1pt each in this row; 3pts total)

Total performance rating (2pts each in this row)

To help Mrs Kandell in making the best decision, please first help her complete each table.

--------- (part 1) First, please help Mrs. Kandell in completing Table 1 (3pts) and pick ONE and only ONE supplier based on the completed Table 1. You will receive NO points if you pick more than one supplier.

To respond to Part 1, please copy and complete Table 1 in the textbox, and recommend ONE supplier (1pt) with justifications (1pt) by completing the sentence: (copy Table 1 and complete it here; 3 pts in total) She should source from supplier_____ (1pt) because__________ (1pt).

(part 2) (Continued from above). Please help Mrs. Kandell in completing Table 2 (9pts) and pick ONE and only ONE supplier based on the completed Table 2. You will receive NO points if you pick more than one supplier. Please do the rounding to the 2nd digit after the decimal points; failures to follow the instructions will result in points deductions (i.e., half of the allotted points for each number/cell). To respond to Part 2, please copy Table 2 from the above problem set and complete Table 2 in the textbox, and recommend ONE supplier (1pt) with justifications (1pt) by completing the sentence: (copy Table 2 and complete it here; 9 pts in total) She should source from supplier_____ (1pt) because__________ (1pt).

(part 3) (Continued from above). Please help Mrs. Kandell in completing Table 3 (15 pts) and pick ONE and only ONE supplier based on the completed Table 3. You will receive NO points if you pick more than one supplier. Please use exactly the same format as your textbook example (i.e., Example 8.1) in presenting your numbers. Please do the rounding to the 2nd digit after the decimal points; failures to follow the instructions will result in points deductions (i.e., half of the allotted points for each number/cell).

To respond to Part 3, please copy Table 3 from the above problem set and complete Table 2 in the textbox, and recommend ONE supplier (1pt) with justifications (1pt) by completing the sentence: (copy Table 3 and complete it here; 15 pts in total) She should source from supplier_____ (1pt) because__________ (1pt).