Questions 16 - 20 are based on the following information: Dukedom Chemicals blen
ID: 366855 • Letter: Q
Question
Questions 16 - 20 are based on the following information:
Dukedom Chemicals blends its private label orchard spray from four individual compounds. Management would like to make the blend at as low a cost as possible while maintaining the requirements for chemical structure. The linear programming problem has been formulated and the SOLVER solution to it is provided. The objective function is to minimize the total cost. The two constraints are formulated to meet the minimum requirements for chemicals 1 and 2.
What is the total cost to make the blend?
Question 16 options:
Xi = The number ofunits of compound 1 to putin the blend i=1,..,4 MIN Z 25x1 t 36x2+ 16x3t 4x4 S.T 12x1t 9x2+10x3 6x42 780 (1) 5x 22x2 19x3+10.2x4 2 900 (2) Units of Chemical 1 Units of Chemical 2 Answer Report Target Cell (Min) Name Original Value Final Value Cell SBS18 Total Cost Amount Adjustable Cells 520 Name Original Value Final Value Cell SAS11 Compound 1 SBS11 Compound 2 SCS11 Compound 3 SDS11 Compound 4 Constra ints Name Cell Value Formula Status Bindin Not Bindin Slack Cell SBS15 SBS16 780SBS15 SFS5 1326SBS16 SFS6 Chemical 1 Amount Chemical 2 Amount 426 Sens itivity Report Adjustable Cells Final Value Objectve Coefficient Allowable Increase Allowable Decrease Reduced Name Cost Compound 1 Compound 2 Compound 3 Compound 4 Constraints 25 36 1E+30 1E+30 1E+30 5.6 30 9.333333333 30 9.333333333 130 Final Value Constraint R.H. Side Allowable Increase Allowable Decrease Shadow Name Price 0.666666667 Chemical 1 Amount Chemical 2 Amount 780 1326 780 900 250.5882353 1E+30 1E+30 426Explanation / Answer
The total cost to make the blend = 520 (as per the sensitivity report of the LP solver solution)
The value in Target Cell table for Total Cost amount gives the final value of the minimum cost.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.