Question

In: Operations Management

Complete the following chart to determine which supplier will you choose according to given scoring system...

Complete the following chart to determine which supplier will you choose according to given scoring system and what are your selections's point of strengths and weaknesses?

		Pesi	Supplier 1	Supplier 2	Supplier 3	Supplier 4
Technical area (65%)	Technical proposal	40%	30%
	Matching with project planning	10%	70%
	Reorder lead time	5%	20%
	Supplier past performance (if applicable)	10%	10%
Economic area (35%)	Quotation for the project	10%	50%
	Quotation for future projects	15%	100%
	Quotation for repairing and maintenance	5%	100%
	Supplier dependence rate	5%	100%
	Total score	100%	51%
	Top supplier to be selected		NO

Given the following background information:

*Matching with project planning (10%)*
	Weight	Supplier 1	Supplier 2	Supplier 3	Supplier 4
Variance between project due date and proposed due date (days)	100%	34.00	46.00	46.00	42.00
Worst variance		46.00
Best variance		34.00

*Technical proposal (40%)*
	Weight	Supplier1	Supplier2	Supplier3	Supplier4
Adherence to system design included in the proposal	50%	95%	87%	75%	90%
Historical supplier capability to adhere to design included in the proposal	35%	90%	77%	70%	70%
Effectiveness of communication of technical details	15%	40%	30%	20%	35%

*Reorder lead time (5%)*
	Weight	Supplier1	Supplier2	Supplier3	Supplier4
Supplier lead time	100%	30	40	40	40
Average lead time		37.5
Variance with average lead time		-7.5	2.5	2.5	2.5
Worst variance		2.5
Best variance		-7.5

*Supplier past performance (10%)*
	Weight	Supplier1	Supplier2	Supplier3	Supplier4
order freezing time	20%	0%	90%	50%	60%
payment terms	20%	100%	100%	100%	100%
delivery lead time	20%	100%	100%	100%	100%
open work in progress activities	20%	100%	100%	100%	100%
defects part per million	20%	100%	93%	12%	100%

*Quotation for the project (10%)*
	Weight	Supplier1	Supplier2	Supplier3	Supplier4
Supplier quotation	100%	4900	9000	7250	6100
Average quotation		6812.5
Variance with average quotation		-1912.5	2187.5	437.5	-712.5
Worst variance		2187.5
Best variance		-1912.5

*Quotation for future projects (15%)*
	Weight	Supplier1	Supplier2	Supplier3	Supplier4
Supplier quotation	100%	15150	27000	21550	21200
Average quotation		21225
Variance with average quotation		-6075	5775	325	-25
Worst variance		5775
Best variance		-6075

*Quotation for repairing and maintenance (5%)*
	Weight	Supplier1	Supplier2	Supplier3	Supplier4
Supplier quotation	100%	38	40	40	35
Average quotation		38.25
Variance with average quotation		-0.25	1.75	1.75	-3.25
Worst variance		1.75
Best variance		-3.25

*Supplier dependence rate (5%)*
	Weight	Supplier1	Supplier2	Supplier3	Supplier4
Supplier dependence rate	100%	0.16	0.66	0.42	0.01

Each sub-item has the following meaning:

• Technical proposal: evaluation of three items 1. Adherence to system design included in the proposal (50%) 2. Historical supplier capability to adhere to design included in the proposal (35%) 3. Effectiveness of communication of technical details (15%)

• Matching with project planning: for each supplier, the difference between the project due date and the proposed due date is calculated. Then, each supplier receives a score between 0 and 100% calculated as 1 – [(supplier variance – best variance)/(worst variance – best variance)]

• Reorder lead time: each supplier offers a lead time value, from which the average lead time is calculated; so, for each supplier, the difference between the average lead time and the proposed lead time is calculated. Then, each supplier receives a score between 0 and 100% calculated as 1 – [(supplier variance – best variance)/(worst variance – best variance)]

• Supplier past performance: ongoing suppliers are evaluated against four performance dimensions (order freezing time, payment terms, delivery lead time, open work in progress activities, defects part per million); for each, a threshold value is set (e.g. for defects part per million, it is 1%): each supplier receives a score between 0% and 100% according to how much the target value has been achieved (it is default 0% if the supplier has no performance data available). Each performance has the same weight (20%)

• Quotation for the project: each supplier offers a price for this project, from which the average price is calculated; so, for each supplier, the difference between the average price and the proposed price is calculated. Then, each supplier receives a score between 0 and 100% calculated as 1 – [(supplier variance – best variance)/(worst variance – best variance)];

• Quotation for future projects: each supplier offers a price for at three future project, from which the average price is calculated; so, for each supplier, the difference between the average price and the proposed price is calculated. Then, each supplier receives a score between 0 and 100% calculated as 1 – [(supplier variance – best variance)/(worst variance – best variance)];

• Quotation for repairing and maintenance: each supplier offers a price for maintenance and repair, from which the average price is calculated; so, for each supplier, the difference between the average price and the proposed price is calculated. Then, each supplier receives a score between 0 and 100% calculated as 1 – [(supplier variance – best variance)/(worst variance – best variance)];

• Supplier dependence: each supplier receives a score which equal the value of supplier dependence.

Expert Solution


		Pesi	Supplier 1	Supplier 2	Supplier 3	Supplier 4
Technical area (65%)	Technical proposal	40%	85%	75%	65%	75%	• Technical proposal: evaluation of three items 1. Adherence to system design included in the proposal (50%) 2. Historical supplier capability to adhere to design included in the proposal (35%) 3. Effectiveness of communication of technical details (15%)
	Matching with project planning	10%	100%	0%	0%	33%	• Matching with project planning: for each supplier, the difference between the project due date and the proposed due date is calculated. Then, each supplier receives a score between 0 and 100% calculated as 1 – [(supplier variance – best variance)/(worst variance – best variance)]
	Reorder lead time	5%	100%	0%	0%	0%	• Reorder lead time: each supplier offers a lead time value, from which the average lead time is calculated; so, for each supplier, the difference between the average lead time and the proposed lead time is calculated. Then, each supplier receives a score between 0 and 100% calculated as 1 – [(supplier variance – best variance)/(worst variance – best variance)]
	Supplier past performance (if applicable)	10%	80%	97%	72%	92%	• Supplier past performance: ongoing suppliers are evaluated against four performance dimensions (order freezing time, payment terms, delivery lead time, open work in progress activities, defects part per million); for each, a threshold value is set (e.g. for defects part per million, it is 1%): each supplier receives a score between 0% and 100% according to how much the target value has been achieved (it is default 0% if the supplier has no performance data available). Each performance has the same weight (20%)
Economic area (35%)	Quotation for the project	10%	100%	0%	43%	71%	• Quotation for the project: each supplier offers a price for this project, from which the average price is calculated; so, for each supplier, the difference between the average price and the proposed price is calculated. Then, each supplier receives a score between 0 and 100% calculated as 1 – [(supplier variance – best variance)/(worst variance – best variance)];
	Quotation for future projects	15%	100%	0%	46%	49%	• Quotation for future projects: each supplier offers a price for at three future project, from which the average price is calculated; so, for each supplier, the difference between the average price and the proposed price is calculated. Then, each supplier receives a score between 0 and 100% calculated as 1 – [(supplier variance – best variance)/(worst variance – best variance)];
	Quotation for repairing and maintenance	5%	40%	0%	0%	100%	• Quotation for repairing and maintenance: each supplier offers a price for maintenance and repair, from which the average price is calculated; so, for each supplier, the difference between the average price and the proposed price is calculated. Then, each supplier receives a score between 0 and 100% calculated as 1 – [(supplier variance – best variance)/(worst variance – best variance)];
	Supplier dependence rate	5%	16%	66%	42%	1%	• Supplier dependence: each supplier receives a score which equal the value of supplier dependence.
	Total score	100%	85%	43%	47%	62%
	Top supplier to be selected		Yes	No	No	No

Given the following background information:

Matching with project planning (10%)
	Weight	Supplier 1	Supplier 2	Supplier 3	Supplier 4
Variance between project due date and proposed due date (days)	100%	34	46	46	42
Worst variance		46
Best variance		34
Technical proposal (40%)
	Weight	Supplier1	Supplier2	Supplier3	Supplier4
Adherence to system design included in the proposal	50%	95%	87%	75%	90%
Historical supplier capability to adhere to design included in the proposal	35%	90%	77%	70%	70%
Effectiveness of communication of technical details	15%	40%	30%	20%	35%
Reorder lead time (5%)
	Weight	Supplier1	Supplier2	Supplier3	Supplier4
Supplier lead time	100%	30	40	40	40
Average lead time		37.5
Variance with average lead time		-7.5	2.5	2.5	2.5
Worst variance		2.5
Best variance		-7.5
Supplier past performance (10%)
	Weight	Supplier1	Supplier2	Supplier3	Supplier4
order freezing time	20%	0%	90%	50%	60%
payment terms	20%	100%	100%	100%	100%
delivery lead time	20%	100%	100%	100%	100%
open work in progress activities	20%	100%	100%	100%	100%
defects part per million	20%	100%	93%	12%	100%
Quotation for the project (10%)
	Weight	Supplier1	Supplier2	Supplier3	Supplier4
Supplier quotation	100%	4900	9000	7250	6100
Average quotation		6812.5
Variance with average quotation		-1912.5	2187.5	437.5	-712.5
Worst variance		2187.5
Best variance		-1912.5
Quotation for future projects (15%)
	Weight	Supplier1	Supplier2	Supplier3	Supplier4
Supplier quotation	100%	15150	27000	21550	21200
Average quotation		21225
Variance with average quotation		-6075	5775	325	-25
Worst variance		5775
Best variance		-6075
Quotation for repairing and maintenance (5%)
	Weight	Supplier1	Supplier2	Supplier3	Supplier4
Supplier quotation	100%	38	40	40	35
Average quotation		38.25
Variance with average quotation		-0.25	1.75	1.75	-3.25
Worst variance		1.75
Best variance		-3.25
Supplier dependence rate (5%)
	Weight	Supplier1	Supplier2	Supplier3	Supplier4
Supplier dependence rate	100%	0.16	0.66	0.42	0.01

keosha answered 1 year ago

Complete the table to determine the Baddebt Expenses for the period. Villanueva, Inc. is a supplier...

Complete the table to determine the Baddebt Expenses for the period. Villanueva, Inc. is a supplier of supplies. The following is the status of accounts receivable ("Aging") Maturity Intervals Balance Percent Amount Non pastdue 345,000.00 2% 1- 30 days 96,000.00 4% 31-60 days 27,000.00 9% 61-90 days 22,000.00 15% 91-180 days 7,300.00 60% Over180 days 5,500.00 85% Totals Assuming a credit balance of $3,050.00 on the counter account. (Allowancefordoubtfulaccounts.) How much should we affect the account? Determine the net realizable...

1. Arachni has its own system for scoring vulnerability severity. Which vulnerabilities do you think are...

1. Arachni has its own system for scoring vulnerability severity. Which vulnerabilities do you think are the most severe/critical? Which are the least severe/critical? 2. How would you categorize the Windows Server that you scannedÑa server that stores and processes health dataÑin terms of its criticality? 3. "If you had to summarize the state of the BxB web app to GCPG's executives, what would you say?"

For the following situations, determine whether the energy of the given system is the same at...

For the following situations, determine whether the energy of the given system is the same at the initial and final states indicated (i.e., is the energy of the system constant or not). 0pts 0pts A block is hung from a spring that is vertical and connected to the ceiling. The block is made to oscillate vertically. Call the initial state when the block is at its highest position and the final state when the block is at its equilibrium position....

/* Complete this javascript file according to the individual instructions given in the comments. */ //...

/* Complete this javascript file according to the individual instructions given in the comments. */ // 1) Declare an array named myArray // Assign myArray three elements: 'Tuesday',3,true // Print myArray to the console with console.log() // 2) Use typeof on each element in myArray // Example: typeof myArray[0]; // Print all 3 lines to the console with console.log() // 3) Declare a variable named myStart and set it to // the value of the length property applied of myArray...

7. Identifying Body Planes: Complete the following chart as you ID the anatomical planes of section...

7. Identifying Body Planes: Complete the following chart as you ID the anatomical planes of section represented by the anatomical models in the classroom. Section Divides sample into what 2 portions? Midsagittal Parasagittal Coronal/Frontal Transverse

/* Assignment : Complete this javascript file according to the individual instructions given in the comments....

/* Assignment : Complete this javascript file according to the individual instructions given in the comments. */ // 1) Utilize comments to prevent the following line from executing alert('Danger!'); // 2) Assign a value of 5 to a variable named x // and print the value of x to the console // 3) Assign a value of 10 to a variable named myNum // and print the value of myNum to the console // 4) Assign the product of x...

/* Assignment: Complete this javascript file according to instructions given in the comments. */ // 1)...

/* Assignment: Complete this javascript file according to instructions given in the comments. */ // 1) Declare a variable named myName equal to your first name //Firstname is Susan // Construct a basic IF statement that prints the variable to the // console IF the length of myName is greater than 1 // 2) Copy your IF statement from above and paste it below // Change the IF statement to check if the length of myName // is greater than...

In this exercise, you will be given a system with their input/output relationships. Using MATLAB, determine...

In this exercise, you will be given a system with their input/output relationships. Using MATLAB, determine whether the system below are a) linear/non-linear b) time-invariant/timevariant, c) causal/noncausal, d) has memory/memoryless: y[n] = x2[n] Provide MATLAB code and graphs to show your work for the linearity and time-invariance testing

Qualitative practice with systems For the following situations, determine whether the energy of the given system...

Qualitative practice with systems For the following situations, determine whether the energy of the given system is the same at the initial and final states indicated (i.e., is the energy of the system constant or not). 0pts 0pts A block is hung from a spring that is vertical and connected to the ceiling. The block is made to oscillate vertically. Call the initial state when the block is at its highest position and the final state when the block is...

How does the current credit scoring system in the US affect people's everyday lives? Do you...

How does the current credit scoring system in the US affect people's everyday lives? Do you think the US should move to a system like in China in order to improve social outcomes? Why or why not?