Question: please show work in excel SM.51 The Candy Shack is in the process of finding suppliers for their candy stands. They have determined to single-source

please show work in excel SM.51 The Candy Shack

please show work in excel

SM.51 The Candy Shack is in the process of finding suppliers for their candy stands. They have determined to single-source their supply in order to focus on the buyer/vendor relationship. The Candy Shack has narrowed their supplier list to two candidates: Gem State, a local company in Pocatello, and Metro Candy, an online wholesaler. The table below contains the Candy Shack's weighted criteria for making this decision along with the raw scores for each of the two supplier options. What is Gem State's weighted score for PRICE? (Display your answer to two decimal places.) What is Metro's weighted score for PRICE? (Display your answer to two decimal places.) What is Gem State's weighted score for QUALITY? (Display your answer to two decimal places.) What is Metro's weighted score for REPUTATION? (Display your answer to two decimal places.) What is Gem State's TOTAL weighted score? Display your answer to two decimal places.) What is Metro's TOTAL weighted score? Display your answer to two decimal places.)

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!

SM.51 The Candy Shack is in the process of finding suppliers fortheir candy stands. They have determined to single-source theirsupply in order to focus on the buyer/vendor relationship. TheCandy...

I'm an undergrad accounting student in an introduction to forensic accounting course.I need help getting started on a final project for this class over a fictitious company called the Grand Teton...

Discussion Board Week 2 1. "Estimating Demand and Its Elasticities" and Statistical Estimation of the Demand Curve During the Weekly Scenarios Herb Jones, a graduate student and part-time data...

Please read carefully, all necessary information is attached, need to show work let me know if there is something missing. Microsoft word can be used thanks. You are Cindy, completing the analysis...

Read PSM Case 5-1 Garland Chocolates and prepare three 10-year cashflow spreadsheets for three scenarios---maintaining the current lines, upgrading the lines, and outsourcing---using the attached...

MGT411 Innovative and Creative Business Thinking University of Phoenix Material Organizational Ecosystem Case Study Wal-Mart Stores, Inc. is a leading company in its industry and a widely recognized...

MKT500 Week 7 Discussion Board I have attached the question, lecture notes, and an example of a student's response to the questions. Running head: KEYSAN NATURALS COMPANY: AIDA PRINCIPLE Keysan...

Hello tutor Please find the attached instruction file and use the template for solving this question. If you have any question about the problem please contact me. Thanks Your Course Project...

Boston Beer Company WACC Project In this project, you will find and discern the appropriate data to determine a realistic assessment of the weighted average cost of capital for The Boston Beer...

Fame Inc. is considering a new investment whose data are shown below. The equipment would be depreciated on a straight-line basis over the projects 3-year life, would have a zero-salvage value, and...

On the date of the business combination of Passman Corporation and Slago Company, the following working paper elimination was prepared (in journal entry format): PASSMAN CORPORATION AND SUBSIDIARY...

What is the going charge per hour ( the amount you would pay your accountant ) in your geographic area for tax research?

What is an example of constructive feedback? provide reference