i need some one who is good at this stuff

profileahmedalali
supplier_scorecard_example.xlsx

criteria examples

Example Criteria Supplier examples
price colleges
distance grocery stores
proximity day care
schedule mass transit
operating hours high end grocery (Whole Foods, New Seasons, Trader Joes)
security specialty store
classes available
variety offered
accessories
customer service
courteousness
sustainability

description

Supplier category: Brick and mortar stores that sell grain-free dog food
Evaluation Criteria:
Price: 30%
Location: 25%
Customer Service: 20%
Breadth of offering: 15%
Other products: 10%
100%
Criteria Explanation:
Price: Calculated on an average price per pound basis
Location: Based on proximity to a regularly traveled route. Measured in minutes.
Customer Service: Amount of time between when I enter the store and I am greeted by a store employee. Measured in minutes.
Breadth of offering: Number of other regularly purchased items available. Applies to items included on the scorecard. Measured in number of brands.
Other products: Number of other regularly purchased items available. Applies to items not included on the scorecard. Ex: treats. Measured in individual units.
Suppliers:
Costco
Pet Smart
PetCo
Poneer Feed
Wilco

evaluation data

Price:
Costco PetCo Pet Smart Pioneer Feed Wilco
Price Lbs Price/lbs Price Lbs Price/lb Price Lbs Price/lb Price Lbs Price/lb Price Lbs Price/lb
Nature's Domain
NutroMax
Taste of the Wild
Average Price*:
*calculated on a price per pound basis