Reference no: EM13964981
Analytical Models in DSS
A company that assembles electronic alarm systems requires three component parts: C1, C2, and C3. In-house production costs are estimated to be $15 per unit for part C1, $18 per unit for part C2, and $ 20 per unit for part C3. It requires 0.16 hours of machining time and 0.1 hours of finishing time to produce to each unit of part C1 in-house; 0.3 hours of machining time and 0.2 hours of finishing time to produce to each unit of part C2 in-house; and 0.25 hours of machining time and 0.3 hours of finishing time to produce to each unit of part C3 in-house.
Because of contractual obligations the company needs 6,000 units each of parts C1, C2, and C3 in the upcoming week. It has only 3000 hours of machining time and 2400 hours of finishing time available over this period. Since its limited production capacity prevents it from satisfying its entire demand for these parts through in-house production alone, the company also needs to purchase some quantities of these parts from external suppliers.
Two external suppliers are available - Supplier A and Supplier B. Supplier A can supply at most 1000 units of C1 at a cost of $16 per unit, at most 1500 units of C2 at a cost of $20 per unit, and at most 1000 units of C3 at a cost of $24 per unit. Supplier B can supply at most 1200 units of C1 at a cost of $18 per unit, at most 2000 units of C2 at a cost of $22 per unit, and at most 1000 units of C3 at a cost of $23 per unit.
For your convenience, the information presented above is summarized in the table below.
|
Part
|
Cost per unit
|
Quantity
|
Capacity (units)
|
Hours required per unit
|
|
In-house
|
Supplier A
|
Supplier B
|
Required
|
Supplier A
|
Supplier B
|
Machining
|
Finishing
|
|
C1
|
$ 15
|
$ 16
|
$ 18
|
6000
|
1000
|
1200
|
0.16
|
0.10
|
|
C2
|
$ 18
|
$ 20
|
$ 22
|
6000
|
1500
|
2000
|
0.30
|
0.20
|
|
C3
|
$ 20
|
$ 24
|
$ 23
|
6000
|
1000
|
1000
|
0.25
|
0.30
|
|
|
|
|
|
|
|
|
Available (hours)
|
|
|
|
|
|
|
|
|
Machining
|
Finishing
|
|
|
|
|
|
|
|
|
3000
|
2400
|
The company uses a decision support system to determine the optimal production and purchase plan for parts C1, C2, and C3 so as to meet their needs (contractual obligations in the upcoming week) at minimum cost. It also uses the decision support system to perform sensitivity analysis.
a) What is the minimum cost attainable under the optimal plan?
The company has located a third supplier (New-Supplier) who can supply at most 100 units of part C1 in the upcoming week, but the purchase price is subject to negotiations. What is the maximum price that the company should be willing to pay New-Supplier for each unit of C1? Justify your answer. Assume that all demands, prices, and availability of resources remain unchanged.
|
Expatriate failure or expatriate performance management
: Expatriate failure or expatriate performance management. Answer the following: 1. What is the purpose of this article? What problem or issue does it address? 2. How does the article relate to the textbook? 3. What problems or concerns are you left wi..
|
|
Identify the key alternative distribution channels
: 3D-Magic is a new company that has developed a revolutionary 3D television. It uses a new technology that provides a much sharper and realistic 3D experience than their competitors. The company is based in the United States. The company's top managem..
|
|
What would its new volume be at stp
: A chamber sealed with a moveable piston contains 5.50 litres of hydrogen at 28 degrees C and 81.3 kPa.
|
|
Produce two products-fuel additive and solvent base
: The RMC Corporation blends three raw materials to produce two products: a fuel additive and a solvent base. Each ton of fuel additive is a mixture of 2/5 ton of material 1 and 3/5 ton of material 3. A ton of solvent base is a mixture of 1⁄2 ton of ma..
|
|
Analytical models in dss
: A company that assembles electronic alarm systems requires three component parts: C1, C2, and C3. In-house production costs are estimated to be $15 per unit for part C1, $18 per unit for part C2, and $ 20 per unit for part C3.
|
|
What is the frequency of ha in vacuum
: The so-called "hydrogen alpha (Ha) line" is a specific wavelength of red light caused by excited atomic hydrogen. It is frequently used when studying the Sun. The wavelength of Ha is 656.3 nm, or 656.3*10-9 m. The speed of light in vacuum is 3*108..
|
|
Find the pressure in the tire at that point in si units.
: After driving for several hours, the temperature in the tire reaches 120 degrees Fahrenheit.
|
|
Possibility of five different undesirable characteristics
: 850 units of a product were examined for the possibility of 5 different undesirable characteristics. A total of 75 defects were found. find How many defects would be expected in a million opportunities (i.e. DPMO)? Using the Six Sigma conversion tabl..
|
|
Find the dual solution graphically
: Write the dual of this problem, sketch the feasible region of the dual, and find the dual solution graphically
|