paraphrase

profilesaud.t1
scorecard.xlsx

Sheet1

Silk Cotton
Supplier Price Quality Reliability Minimum Order size Supplier Price Quality Reliability Minimum Order Size
Owens Textiles $ 3.20 50 Low 25 Owens Textiles $ 0.08 50 Low 750
Preston Premium $ 4.80 80 High 25 Freeway Fabrics $ 0.08 25 Medium 50
Red Maple Fabrics $ 4.00 40 Medium 50 Preston Premium $ 0.12 80 High 25
Reliable Clothing $ 4.00 35 High 200 Reliable Clothing $ 0.10 35 High 200
Tigerlily Textiles $ 4.00 60 Medium 100 Tigerlily Textiles $ 0.10 60 Medium 100
United Fabrics $ 4.80 70 High 500 United Fabrics $ 0.12 70 High 500
Supplier Scorecard Silk Supplier Scorecard Cotton
*Weight 4 3 2 1 *Weight 4 3 2 1
Suppliers Price Quality Reliability min. order size Score Suppliers Price Quality Reliability min. order size Score
Owens Textiles 5 2 1 5 33.00 Owens Textiles 5 2 1 1 29.00
Preston Premium 3 5 3 5 38.00 Freeway Fabrics 5 1 2 4 31.00
Red Maple Fabrics 4 1 2 4 44.00 Preston Premium 3 5 3 5 33.00
Reliable Clothing 4 1 3 2 36.00 Reliable Clothing 4 1 3 2 35.00
Tigerlily Textiles 4 3 2 3 35.00 Tigerlily Textiles 4 3 2 3 48.00
United Fabrics 3 4 3 1 27.00 United Fabrics 3 4 3 1 27.00
If the above criteria is used then I would choose "Red Maple Fabrics" for Silk suppliers as they had the highest score and for cotton I would pick "Tigerlily Textiles."
Explanation:
The Scores shown above are all from a scale of 1-5 and in each category a score is given to the supplier depending on thir performance. A 5 is given to either the cheapest, best quality, most reliable and lastly, to the supplier that
allows a smaller order. 1's are given vice a versa. This scorecard has 4 criterias and I decided them based on what is the most important in order to make a decision of who to buy from. I chose price to have a weight of 4, Quality of
3, reliability of 2 and minimum order size to be 1 because its not as important when you have large contracts but are fairly important for small orders.
If I had a small business I would really like to know how reliable my supplier is and what discounts are available to me. Especially for small businesses, price can be an issue so I would do a scorecard based on price and discounts of my
suppliers in order to make my small business larger.