Purchasing with Price Breaks. Universal Technologies, Inc. has identified two qualified vendors with the capability to supply certain of its electronic components. For the coming year, Universal has estimated its volume requirements for these components and has obtained price-break schedules from each vendor. (These are summarized as "all-units" price discounts in the table at the bottom of p. 333.) Universal's engineers have also estimated each vendor's maximum capacity for producing these components, on the basis of available information about equipment in use and labor policies in effect. Finally, because of its limited history with vendor A, Universal has adopted a policy that permits no more than 60 percent of its total unit purchases on these components to come from vendor A. a. What is the minimum total cost for Universal's purchases? b. In the optimal solution to part (a), which purchases are made at discounted prices?

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

Use solver to calculate this and share excel

7. Purchasing with Price Breaks. Universal Technologies, Inc. has identified two qualified vendors with the capability to
supply certain of its electronic components. For the coming year, Universal has estimated its volume requirements for
these components and has obtained price-break schedules from each vendor. (These are summarized as "all-units"
price discounts in the table at the bottom of p. 333.) Universal's engineers have also estimated each vendor's
maximum capacity for producing these components, on the basis of available information about equipment in use and
labor policies in effect. Finally, because of its limited history with vendor A, Universal has adopted a policy that permits
no more than 60 percent of its total unit purchases on these components to come from vendor A.
a. What is the minimum total cost for Universal's purchases?
b. In the optimal solution to part (a), which purchases are made at discounted prices?
Transcribed Image Text:7. Purchasing with Price Breaks. Universal Technologies, Inc. has identified two qualified vendors with the capability to supply certain of its electronic components. For the coming year, Universal has estimated its volume requirements for these components and has obtained price-break schedules from each vendor. (These are summarized as "all-units" price discounts in the table at the bottom of p. 333.) Universal's engineers have also estimated each vendor's maximum capacity for producing these components, on the basis of available information about equipment in use and labor policies in effect. Finally, because of its limited history with vendor A, Universal has adopted a policy that permits no more than 60 percent of its total unit purchases on these components to come from vendor A. a. What is the minimum total cost for Universal's purchases? b. In the optimal solution to part (a), which purchases are made at discounted prices?
1
2
3
500
1,000
2,500
A
Vendor B
Unit Price Volume Required Unit Price
$225
0-250
$224
$220
250-500
$214
$124
0-600
$120
$115
(no discount)
$60
$54
$56
$52
$51
BERASTE
600-1,000
0-1,000
1,000-2.000
2,000-2,500
Total Capacity (Units)
2,800
example, if 1,400 units are purchased from Vendor A, they cost $56 each for a total of $70.100
Volume Required
0-300
300-500
0-1,000
0-1,500
1,500-2,500
2.400
ant:
Transcribed Image Text:1 2 3 500 1,000 2,500 A Vendor B Unit Price Volume Required Unit Price $225 0-250 $224 $220 250-500 $214 $124 0-600 $120 $115 (no discount) $60 $54 $56 $52 $51 BERASTE 600-1,000 0-1,000 1,000-2.000 2,000-2,500 Total Capacity (Units) 2,800 example, if 1,400 units are purchased from Vendor A, they cost $56 each for a total of $70.100 Volume Required 0-300 300-500 0-1,000 0-1,500 1,500-2,500 2.400 ant:
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 5 images

Blurred answer
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
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
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.