Purchase Solution

Analytical Models in DSS

Not what you're looking for?

Ask Custom Question

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:

Please see the attached MS Word document for the table.

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?

b) 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.

Purchase this Solution

Solution Summary

The analytical models in DSS are examined.

Purchase this Solution


Free BrainMass Quizzes
Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Probability Quiz

Some questions on probability

Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.