Gulf Coast Electronics is ready to award contracts to suppliers for providing reservoir capacitors for use in its electronic devices. For the past several years, Gulf Coast Electronics has relied on two suppliers for its reservoir capacitors: Able Controls and Lyshenko Industries. A new firm, Boston Components, has inquired into the possibility of providing a portion of the reservoir capacitors needed by Gulf Coast. The quality of products provided by Lyshenko Industries has been extremely high; in fact, only 0.5% of capacitors provided by Lyshenko had to be discarded because of quality problems. Able Controls has also had a high quality level historically, producing an average of only 1% unacceptable capacitors. Because Gulf Coast Electronics has had no experience with Boston Components, it estimated Boston Components' defective rate to be 11%. Gulf Coast would like to determine how many reservoir capacitors should be ordered from each firm to obtain 74000 acceptable-quality capacitors to use in its electronic devices. To ensure that Boston Components will receive some of the contract, management specified that the volume of reservoir capacitors awarded to Boston Components must be at least 11% of the volume given to Able Controls. In addition, the total volume assigned to Boston Components, Able Controls, and Lyshenko Industries should not exceed 32000, 51000, and 49500 capacitors, respectively. Because of Gulf Coast's long-term relationship with Lyshenko Industries, management also specified that at least 30500 reports should be ordered from Lyshenko. The cost per capacitor is $2.35 for Boston Components, $2.55 for Able Controls, and $2.85 for Lyshenko Industries. a. Formulate and solve a linear program for determining how many reservoir capacitors should be ordered from each supplier to minimize the total cost of obtaining 75,000 acceptable-quality reservoir capacitors. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. Enter "0" if your answer is zero. If the constant is "1" it must be entered in the box. Let B = number of capacitors ordered from Boston Components Let A number of capacitors ordered from Able Controls Let L number of capacitors ordered from Lyshenko Industries Min s.t. 8 B 8 B | + | A A A A k k k B, A, L 20 s S s - 2 2 Boston Able Lyshenko useful capacitors Boston- Able % Minimum Lyshenko

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
.
Gulf Coast Electronics is ready to award contracts to suppliers for providing reservoir capacitors for use in its electronic devices. For the past several years, Gulf Coast Electronics has relied on two suppliers for its reservoir capacitors: Able
Controls and Lyshenko Industries. A new firm, Boston Components, has inquired into the possibility of providing a portion of the reservoir capacitors needed by Gulf Coast. The quality of products provided by Lyshenko Industries has been
extremely high; in fact, only 0.5% of capacitors provided by Lyshenko had to be discarded because of quality problems. Able Controls has also had a high quality level historically, producing an average of only 1% unacceptable capacitors.
Because Gulf Coast Electronics has had no experience with Boston Components, it estimated Boston Components' defective rate to be 11%. Gulf Coast would like to determine how many reservoir capacitors should be ordered from each firm to
obtain 74000 acceptable-quality capacitors to use in its electronic devices. To ensure that Boston Components will receive some of the contract, management specified that the volume of reservoir capacitors awarded to Boston Components must
be at least 11% of the volume given to Able Controls. In addition, the total volume assigned to Boston Components, Able Controls, and Lyshenko Industries should not exceed 32000, 51000, and 49500 capacitors, respectively. Because of Gulf
Coast's long-term relationship with Lyshenko Industries, management also specified that at least 30500 reports should be ordered from Lyshenko. The cost per capacitor is $2.35 for Boston Components, $2.55 for Able Controls, and $2.85 for
Lyshenko Industries.
a. Formulate and solve a linear program for determining how many reservoir capacitors should be ordered from each supplier to minimize the total cost of obtaining 75,000 acceptable-quality reservoir capacitors. For subtractive or negative
numbers use a minus sign even if there is a + sign before the blank. Enter "0" if your answer is zero. If the constant is "1" it must be entered in the box.
Let B = number of capacitors ordered from Boston Components
Let A = number of capacitors ordered from Able Controls
Let L = number of capacitors ordered from Lyshenko Industries
Min
s.t.
B
B
B
B
+
+
A
A
A
A
k
k
k
k
B, A, L 20
s
s
s
Boston
Able
Lyshenko
# useful capacitors
Boston Able %
Minimum Lyshenko
Transcribed Image Text:. Gulf Coast Electronics is ready to award contracts to suppliers for providing reservoir capacitors for use in its electronic devices. For the past several years, Gulf Coast Electronics has relied on two suppliers for its reservoir capacitors: Able Controls and Lyshenko Industries. A new firm, Boston Components, has inquired into the possibility of providing a portion of the reservoir capacitors needed by Gulf Coast. The quality of products provided by Lyshenko Industries has been extremely high; in fact, only 0.5% of capacitors provided by Lyshenko had to be discarded because of quality problems. Able Controls has also had a high quality level historically, producing an average of only 1% unacceptable capacitors. Because Gulf Coast Electronics has had no experience with Boston Components, it estimated Boston Components' defective rate to be 11%. Gulf Coast would like to determine how many reservoir capacitors should be ordered from each firm to obtain 74000 acceptable-quality capacitors to use in its electronic devices. To ensure that Boston Components will receive some of the contract, management specified that the volume of reservoir capacitors awarded to Boston Components must be at least 11% of the volume given to Able Controls. In addition, the total volume assigned to Boston Components, Able Controls, and Lyshenko Industries should not exceed 32000, 51000, and 49500 capacitors, respectively. Because of Gulf Coast's long-term relationship with Lyshenko Industries, management also specified that at least 30500 reports should be ordered from Lyshenko. The cost per capacitor is $2.35 for Boston Components, $2.55 for Able Controls, and $2.85 for Lyshenko Industries. a. Formulate and solve a linear program for determining how many reservoir capacitors should be ordered from each supplier to minimize the total cost of obtaining 75,000 acceptable-quality reservoir capacitors. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. Enter "0" if your answer is zero. If the constant is "1" it must be entered in the box. Let B = number of capacitors ordered from Boston Components Let A = number of capacitors ordered from Able Controls Let L = number of capacitors ordered from Lyshenko Industries Min s.t. B B B B + + A A A A k k k k B, A, L 20 s s s Boston Able Lyshenko # useful capacitors Boston Able % Minimum Lyshenko
Round your answers to the nearest whole number.
BA
А
L
Optimal
Solution:
b. Suppose that the quality level for reservoir capacitors supplied by Boston Components is much better than estimated. What effect, if
any, would this quality level have?
If the quality of reservoir capacitors supplied by Boston Components is much better than expected the optimal solution
For example, if Boston Components reduced their defect rate from 11% to 2%, the new optimal solution
mber of reservoir capacitors given to Boston Components to
wouldn't change.
may change.
c. Suppose that management is willing to reconsider their requirement that at least 30500 capacitors must be ordered from Lyshenko
Industries. What effect, if any, would this consideration have? If required, round your answer to the nearest cent.
If management removes or reduces the requirement that Lyshenko Industries be ordered at least 30500 reservoir capacitors the
cost will decrease by $
per unit decreased.
Transcribed Image Text:Round your answers to the nearest whole number. BA А L Optimal Solution: b. Suppose that the quality level for reservoir capacitors supplied by Boston Components is much better than estimated. What effect, if any, would this quality level have? If the quality of reservoir capacitors supplied by Boston Components is much better than expected the optimal solution For example, if Boston Components reduced their defect rate from 11% to 2%, the new optimal solution mber of reservoir capacitors given to Boston Components to wouldn't change. may change. c. Suppose that management is willing to reconsider their requirement that at least 30500 capacitors must be ordered from Lyshenko Industries. What effect, if any, would this consideration have? If required, round your answer to the nearest cent. If management removes or reduces the requirement that Lyshenko Industries be ordered at least 30500 reservoir capacitors the cost will decrease by $ per unit decreased.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 5 images

Blurred answer
Similar questions
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.