Analytical models in dss

Assignment Help Basic Statistics
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.

Reference no: EM13964981

Information about compute the probability

A certain disease occurs in 35% of the population. A test for the disease is fairly accurate: it misclassifies people with the disease as healthy 6% of the time and reports

Interpret the meaning of the slopes in equation

The Multiple Regression file has already been pre-loaded with the data, so you need only interpret the output. Complete the following tasks: State the multiple regression eq

Over time and becomes a visual record of a community

1. Use examples to explain why it is especially important to know the purpose and function of African artwork in order to understand it. 2. How is pattern used to enhance c

Scatter plots comparing gdp growth

Make for more scatter plots comparing GDP growth 1970-2000 to corruption, political rights, rule of law, and socio-political instability

Translate statements into symbolic form- bill gates

Translate the following statements into symbolic form using capital letters to represent affirmative English statements.- Bill Gates does not support malaria research unless W

Estimate proportion of unemployed college students

What size sample would be required to estimate the proportion of unemployed college students if we want the margin of error not to exceed 5 percent?

Computing sample variances and poolded variance

Assuming that n = 6 for both samples, calculate each of the sample variances, then calculate the pooled variance. Because the samples are the same size, you should find that

Coefficient between the number of automatic weapons

The data below show the number of registered automatic weapons, in thousands, and the murder rate, in murders per 100,000, for eight randomly selected states. a. Determine t

Reviews

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd