Question: Please show excel calculations Purpose In this assignment, you will apply concepts from the Source unit (Introduction to Supply Chain Management & Supplier Selection) along

Please show excel calculations Purpose In thisPlease show excel calculations Purpose In this

Please show excel calculations

Purpose In this assignment, you will apply concepts from the Source unit (Introduction to Supply Chain Management & Supplier Selection) along with knowledge learned about Excel in the LinkedIn Learning Excel assignment. Scenario It's another late night finishing up work for that crazy SCM 301 instructor. Your plan is to order a pizza and knock out the studying and assignments. The only problem is Ames has sooooo many great pizza places to choose from that you always have a tough time deciding where to get your ZA. That's okay! You remember the weighted supplier scorecard description from SCM 301 and decide to make one for Ames' pizza places. Tasks Create a multi-criteria analysis for Blaze, Dominos, Jeff's Pizza, and Pizza Pit (needs to be completed in Excel). o Use a scale of 0-100 for the score each pizza place can earn under each criterion. The score for each criterion per pizza place is based on your opinion. However, remember the criterion weights should be the same for each supplier. Having the same criterion weights helps align the importance of criterion to you while also creating a more "apples to apples" criterion between suppliers (in this case, pizza providers). For the purposes of this assignment, each pizza provider needs to earn a total score of 70 or higher. This will prevent people from rating one provider much higher than all the others making the answers to the below questions too easy. Please note the scorecard, needs to display the formulas used to calculate the score for each pizza provider and category. Use the following criteria to generate a supplier scorecard: o Price o Quality o Availability of Toppings o Hours (open) o Delivery Availability

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!