Creat excel score board and show formulas

Read the following story and answer the corresponding questions. The supplier scorecard needs to be completed in Excel. Assignment 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. Use the following criteria to generate a supplier scorecard: Price, Quality, Availabifity of Topping5, Hours (open), and Delivery Availability. Remember you should provide a weight to each criteria and these weights should add up to 1.0. For the purpose of this assignment, all 5 criterion cannot have the same weight. 1 am certain at least one of these criteria is more important to you than the others. Create a supplier scorecard for Biaze, Dominos, Jeff's Pizza, and Pizza Pit. 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 pirza 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. Best of luck and remember, your supplier scorecard should indicate where you should order pizza from most of the time between these 4 supptiers! Create your supplier scorecard using the above criteria in an Excel document. Be ready to upload this Excel document to Camas. After completing the scorecard. please answer the following questions. The question and answer should be placed underneath your supplier scorecard in Excel. Please note the scorecard needs to display the formulas used to calculate the score for each pizza provider and category. 1. Based on criterion weighting. What is the most important criterion to you when ordering pizza? 2. What score did Blaze carn for the price category? 3. What score did Dominos earn for the delivery category? 4. What score did Jeff's eam for the availability of toppings category? 5. What score did Pizra Pit eam for the hours category? 6. Based on total supplier score, from which pizza provider should you order? 7. Would you expect each classmate to share the same "best" supplier of pizza? Why or why not? 8. Would you expect each chassmate to have the same most important criterionz Why or whynot