Question: Put the information below into an EXCEL document. You should understand how to calculate the weighted point evaluation system or what I call the weighted

Put the information below into an EXCEL document. You should understand how to calculate the weighted point evaluation system or what I call the weighted scorecard.

Calculate the scores for each supplier using FORMULAS. You must use the SUM formula to get full credit. Then, select the supplier with the highest score as this is the one that you would normally source! SUBMIT the completed excel spreadsheet here!

		POTENTIAL SOURCES
PERFORMANCE DIMENSION	IMPORTANCE	Handman	Jaycar	Upstart
Price	0.3	4	3	5
Quality	0.4	3	5	5
Delivery Reliability	0.3	4	2	1

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!

incorrect document, we'll assume that the homework assignment was not actually completed. Background DBVac is considering adding an additional product to their lineup. The company's Research and...

In this assignment, you'll be writing a business case in which you will recommend to DBVac which of the three vacuums to bring to market, give them a sense for what to expect from its release in...

Purpose Learn to build a basic business case by using data analysis techniques and interpreting and presenting their results. Techniques include weighted values, NPV calculation and comparison,...

1-Please provide 5 cross-examination questions for: Chris Moss Dr. Gerry Stein Sydney Payne Terry Preece Leslie Brown Alex Lloyd 2-Explain why/how/if you would use exhibits A, B, C, and D. 3-What...

Hi, I need help with the attached Excel spreadsheet. There are multiple questions across the different tabs. Please do not claim this unless you have read the questions and you are positive you can...

Please find attached question. The questions must be answered using the excel format. Please let me know if you need further clarifications. Case Green Valley Medical Center (GVMC) This case is a...

FIN201 Final Exam Sample MULTIPLE CHOICE. 1. Why will banks permit the use of an overdraft as suitable for funding the purchase of inventory that will quickly be converted into cash? A. To assist a...

\fSUPPORT FOR THE CULTURAL DIVERSITY AND POLICING (CDAP) PROJECT AND ALL OF ITS PRODUCTS HAVE BEEN PROVIDED BY THE BUREAU OF JUSTICE ASSISTANCE GRANT #2001-DD-BX-K003. OPINIONS STATED IN THIS PAPER...

PROJECT SCOPE [Instructions for what to include in this section: Define the scope of work that will be undertaken to provide the deliverable(s) mentioned in the Project Charter (PC). Craft this...

hi. I'm stuck with a report whose Chic Paints Ltd. and I am finding difficulty to answer some questions such as the organisations accounting system requirements including hardware and software...

1. The hydrogen emission spectrum extends into the near ultraviolet region. Calculate the wavelengths associated with the two next highest energy emission lines of hydrogen beyond the Balmer series,...

Refer back to the hypothetical Sun City Savings and Loan case presented in this chapter, and consider each of the following independent situations: a. Suppose that Pina, Johnson & Associates also...

Consider the following cash flow: \ table [ [ tent , tstr 9 7 - 2

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...