2. A jewelry manufacturer wants to optimally producing four different bracelets with their quantities denoted by...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
2. A jewelry manufacturer wants to optimally producing four different bracelets with their quantities denoted by x, x2, X3 and x4. The production of these bracelets require different amounts of gold, silver and time. A linear programming model has been formulated for determining the optimal quantities of the four different bracelets such that the total profit is maximized and the model is as follow: Max $900x, + $1250 x2 + 450x3 + $650x4 subject to 0.10x1 + 0.25x2 + 0.08x3 + 0.21x4 < 72 units (Gold) 3x1 + 3x2 + x3 + X4 < 1200 units (Silver) 3.6x1 + 4.8x2 + 2.5x3 + 3.5x4 < 2500 hours (Manufacturing Time) X1 + x2 < 500 (Limit on Total Quantity of Bracelets 1 & 2 Produced) X3 + x4 < 500 (Limit on Total Quantity of Bracelets 3 & 4 Produced) X1, X2, X3, X4 > 0 a. Determine the optimal solution to this linear programming model by Excel Solver. b. For each coefficient in the objective function, identify its range of change that the current optimal solution remains unchanged. c. For each of the first three constraints, identify the range of change of its right-hand-side value, in which the constraint's shadow price remains valid. d. One of the four bracelets is not produced in the optimal solution. How much would the objective coefficient of this bracelet be adjusted so that it is worthwhile to be produced? 2. A jewelry manufacturer wants to optimally producing four different bracelets with their quantities denoted by x, x2, X3 and x4. The production of these bracelets require different amounts of gold, silver and time. A linear programming model has been formulated for determining the optimal quantities of the four different bracelets such that the total profit is maximized and the model is as follow: Max $900x, + $1250 x2 + 450x3 + $650x4 subject to 0.10x1 + 0.25x2 + 0.08x3 + 0.21x4 < 72 units (Gold) 3x1 + 3x2 + x3 + X4 < 1200 units (Silver) 3.6x1 + 4.8x2 + 2.5x3 + 3.5x4 < 2500 hours (Manufacturing Time) X1 + x2 < 500 (Limit on Total Quantity of Bracelets 1 & 2 Produced) X3 + x4 < 500 (Limit on Total Quantity of Bracelets 3 & 4 Produced) X1, X2, X3, X4 > 0 a. Determine the optimal solution to this linear programming model by Excel Solver. b. For each coefficient in the objective function, identify its range of change that the current optimal solution remains unchanged. c. For each of the first three constraints, identify the range of change of its right-hand-side value, in which the constraint's shadow price remains valid. d. One of the four bracelets is not produced in the optimal solution. How much would the objective coefficient of this bracelet be adjusted so that it is worthwhile to be produced?
Expert Answer:
Answer rating: 100% (QA)
the solution of this problem is attached a Answer Create Excel model as follows Enter Solver Paramet... View the full answer
Related Book For
Operations Management Creating Value Along the Supply Chain
ISBN: 978-0470525906
7th Edition
Authors: Roberta S. Russell, Bernard W. Taylor
Posted Date:
Students also viewed these programming questions
-
Total Profit. Flexl, Inc., determines that its total profit is given by the function P(x) = -3x2 + 630x - 6000. a) Flexl makes a profit for those nonnegative values of x for which P(x) > 0. Find the...
-
How should the production scheduler sequence the production of these products? The production scheduler of Scotsburn Dairy in Truro, NS, has just received a list of products and their desired lot...
-
x1 - 3x2 + x3 = 4 2x1 - x2 = - 2 4x1 - 3x3 = 0 Solve by Cramer's rule, where it applies.
-
Compare two versions of the two-period depletable resource model that differ only in the treatment of marginal extraction cost. Assume that in the second version the constant marginal extraction cost...
-
Kristin Company sells 300 units of its products for $20 each to Logan Inc. for cash. Kristin allows Logan to return any unused product within 30 days and receive a full refund. The cost of each...
-
The following information was obtained from the 2017 financial reports of Hathaway Toy Company and Yakima Manufacturing: Assume that the only change to shareholders equity during 2017 is due to net...
-
A significant issue when a contract is breached is whether the cause of action is strictly in breach of contract or may be expanded to negligence and strict liability. The significance comes into...
-
Cleveland Area Rapid Delivery (CARD) operates a delivery service in the Cleveland met- ropolitan area. Most of CARDs business involves rapid delivery of documents and parcels between offices during...
-
Find the slope m and y-intercept b. (If an answer is undefined, enter UNDEFINED. If an answer does not exist, enter DNE.) x = -7 m = b = XX Graph the equation. No Solution Help -10 8 7 6 5 4 3 -2-1...
-
Superior Hardwood Company distributes hardwood products to small furniture manufacturers. The adjusted trial balance data given below is from the firms worksheet for the year ended December 31, 2019....
-
Questions 1. Given that DS-2000H, BX-0100H, SI-0002H, 12H 34H 56H 78H are stored sequentially in memory units [20100H]-[20103H), 2AH 4CH B7H 65H are stored sequentially in memory units...
-
11. There are 5 forms of settlement: bank, barter, capital, cash, and IOU. For each of the following 5 transactions, complete the table below with: (1) The form of settlement (ii) The account to be...
-
What is the expected yearly sales distribution of each product? What is the expected monthly aggregate sales distribution for all products together? What is the expected yearly aggregate sales...
-
solve the following sec y + cot x = 3.
-
A tortoise is walking in the desert. It walks for 2.56 meters at a speed of 2 meters per minute. For how many minutes does it walk?
-
What are the Krogers major elements of the company's approach to entrepreneurship and value creation? What is Krogers action the company could take to increase its entrepreneurial value creation?...
-
The demand for new electric scooter at Kern Motors is 3,600 per week. The factory runs 8 hours per shift. There are 3 shifts per day. Each work week is 5 working days. What is the Takt Time to meet...
-
Name some of the various types of financial intermediaries described in the chapter and indicate the primary reason(s) each was created.
-
Identify 10 real-life examples of queuing systems with which you are familiar.
-
Develop a fishbone diagram for the possible causes of your car not starting.
-
Lydia and Jon order their holiday gifts through the mail. They have spent many evenings at home comparison shopping through gift catalogues and have found all the things they need from three...
-
The figures show Elastic cords lead to the up-and-down motion of a bungee jump. four identical oscillators at different points in their motion. Which is moving fastest at the time shown? A. wwwww. B....
-
The graphs in the table above apply to pendulum motion as well as the motion of a mass on a spring. A pendulum in a clock has a period of 2.0 seconds. You pull the pendulum to the right-a positive...
-
Rank in order, from largest to smallest, the time constants TA to To of the decays in the figures. The scales on all the graphs are the same. Xmax Xmax Xmax Xmas A. B. C. D.
Study smarter with the SolutionInn App