Applying excel solver on above data:
Order quantity: | |||||||
Component | 1 | 2 | 3 | total qty | constraint | total | |
1 | 200 | 0 | 825 | 1025 | = | 1025 | |
2 | 350 | 475 | 0 | 825 | = | 825 | |
550 | 475 | 825 | |||||
constraint | <= | 550 | 1025 | 825 | |||
slack | 0 | 550 | 0 | ||||
total cost = | 20200 |
from above
Supplier: | |||
Component | 1 | 2 | 3 |
1 | 200 | 0 | 825 |
2 | 350 | 475 | 0 |
Edwards Manufacturing Company purchases two component parts from three different suppliers. The suppliers have limited capacity,...
Problem 4-11 (Algorithmic) Edwards Manufacturing Company purchases two component parts from three different suppliers. The suppliers have limited capacity, and no one supplier can meet all the company's needs. In addition, the suppliers charge different prices for the components. Component price data (in price per unit) are as follows Supplier Component $10 $14 $10 $12$12 $10 Each supplier has a limited capacity in terms of the total number of components it can supply. However, as long as Edwards provides sufficient...
Problem 4-11 (Algorithmic) Edwards Manufacturing Company purchases two component parts from three different suppliers. The suppliers have limited capacity, and no one supplier can meet all the company's needs. In addition, the suppliers charge different prices for the components. Component price data (in price per unit) are as follows: Supplier Component 1 2 13 1 $12 $13 510 2 $11 $12 s10 Each supplier has a limited capacity in terms of the total number of components it can supply. However,...
Edwards Manufacturing Company purchases two component parts from three different suppliers The suppliers have limited capacity, and no one supplier can meet all the company's needs. In addition, the suppliers charge different prices for the components. Component price data (in price per unit) are as follows: Supplier Component 1 2 3 1 $12 $13 $14 2 $10 $11 $10 Each supplier has a limited capacity in terms of the total number of components it can supply. However, as long as...
Problem 9-11 (Algorithmic) Edwards Manufacturing Company purchases two component parts from three different suppliers. The suppliers have limited capacity, and no one supplier can meet all the company’s needs. In addition, the suppliers charge different prices for the components. Component price data (in price per unit) are as follows: Supplier Component 1 2 3 1 $11 $12 $15 2 $11 $10 $11 Each supplier has a limited capacity in terms of the total number of components it can supply. However,...
Problem 9-11 (Algorithmic) Edwards Manufacturing Company purchases two component parts from three different suppliers. The suppliers have limited capacity, and no one supplier can meet all the company’s needs. In addition, the suppliers charge different prices for the components. Component price data (in price per unit) are as follows: Supplier Component 1 2 3 1 $11 $11 $13 2 $10 $12 $10 Each supplier has a limited capacity in terms of the total number of components it can supply. However,...
A linear programming computer package is needed. Edwards Manufacturing Company purchases two component parts from three different suppliers. The suppliers have limited capacity, and no one supplier can meet all the company's needs. In addition, the suppliers charge different prices for the components. Component price data (in price per unit) are as follows. Supplier Component 2 1 $11 $12 $13 2 $9 $10 59 Each supplier has a limited capacity in terms of the total number of components it can...
Benson Manufacturing is considering ordering electronic components from three different suppliers. The suppliers may differ in terms of quality in that the proportion or percentage of defective components may differ among the suppliers. To evaluate the proportion defective components for the suppliers, Benson has requested a sample shipment of 500 components from each supplier. The number of defective components and the number of good components found in each shipment is as follows. Supplier Component 10 35 Good 490 465 455...
Benson Manufacturing is considering ordering electronic components from three different suppliers. The suppliers may differ in terms of quality in that the proportion or percentage of defective components may differ among the suppliers. To evaluate the proportion defective components for the suppliers, Benson has requested a sample shipment of 500 components from each supplier. The number of defective components and the number of good components found in each shipment is as follows. Supplier Component A B C Defective 15 35...
Benson Manufacturing is considering ordering electronic components from three different suppliers. The suppliers may differ in terms of quality in that the proportion or percentage of defective components may differ among the suppliers. To evaluate the proportion defective components for the suppliers, Benson has requested a sample shipment of 500 components from each supplier. The number of defective components and the number of good components found in each shipment is as follows. Supplier Component Defective Good 10 25 50 490...
Harley Davidson purchases components from three suppliers. Components purchased from Supplier A are priced at $ 5 each and used at the rate of 206700 units per year. Components purchased from Supplier B are priced at $ 4 each and are used at the rate of 25,000 units per year. Components purchased from Supplier C are priced at $ 5 each and used at the rate of 10,000 units per year. Currently Harley purchases a separate truckload from each supplier. As...