Chris Sandvig Irrigation, Inc., has summarized the price list from four potential suppliers of an underground control valve. See the accompanying table. Annual usage is 2,400 valves; order cost is $10 per order; and annual inventory holding costs are $3.33 per unit. Which vendor should be selected and what order quantity is best if Sandvig Irrigation wants to minimize total cost? Px VENDOR A QUANTITY 1-49 50-74 75-149 150-299 300-499 500+ PRICE $35.00 34.75 33.55 32.35 31.15 30.75 VENDOR C QUANTITY 1-99 100-199 200-399 400+ PRICE $34.50 33.75 32.50 31.10 VENDOR B QUANTITY 1-74 75-149 150-299 300-499 500+ PRICE $34.75 34.00 32.80 31.60 30.50 VENDOR D QUANTITY 1-199 200-399 400+ PRICE $34.25 33.00 31.00

Purchasing and Supply Chain Management
6th Edition
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Chapter2: The Purchasing Process
Section: Chapter Questions
Problem 1GPE
icon
Related questions
Question
12.27 Chris Sandvig Irrigation, Inc., has summarized the
price list from four potential suppliers of an underground control
valve. See the accompanying table. Annual usage is 2,400 valves;
order cost is $10 per order; and annual inventory holding costs
are $3.33 per unit.
Which vendor should be selected and what order quantity is
best if Sandvig Irrigation wants to minimize total cost? PX
VENDOR A
QUANTITY
1-49
50-74
75-149
150-299
300-499
500+
VENDOR C
QUANTITY
1-99
100-199
200-399
400+
PRICE
$35.00
34.75
33.55
32.35
31.15
30.75
PRICE
$34.50
33.75
32.50
31.10
VENDOR B
QUANTITY
1-74
75-149
150-299
300-499
500+
PRICE
$34.75
34.00
32.80
31.60
30.50
VENDOR D
QUANTITY
1-199
200-399
400+
PRICE
$34.25
33.00
31.00
Transcribed Image Text:12.27 Chris Sandvig Irrigation, Inc., has summarized the price list from four potential suppliers of an underground control valve. See the accompanying table. Annual usage is 2,400 valves; order cost is $10 per order; and annual inventory holding costs are $3.33 per unit. Which vendor should be selected and what order quantity is best if Sandvig Irrigation wants to minimize total cost? PX VENDOR A QUANTITY 1-49 50-74 75-149 150-299 300-499 500+ VENDOR C QUANTITY 1-99 100-199 200-399 400+ PRICE $35.00 34.75 33.55 32.35 31.15 30.75 PRICE $34.50 33.75 32.50 31.10 VENDOR B QUANTITY 1-74 75-149 150-299 300-499 500+ PRICE $34.75 34.00 32.80 31.60 30.50 VENDOR D QUANTITY 1-199 200-399 400+ PRICE $34.25 33.00 31.00
Expert Solution
steps

Step by step

Solved in 2 steps with 4 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning