There are two products to produce. The unit profit of product 1 is 4 and that...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
There are two products to produce. The unit profit of product 1 is 4 and that of product 2 is 2. Two resources are required. They are labor hours and key components. Each product 1 will consume 2 units of labor hours and 3 key components. Each product 2 will consume 4 units of labor hours and 5 key components. The availability of labor hours is 20 units and that of key components is 15. The company wants to maximize its profits. Implement the following LP problem in Excel. Use Solver to solve the problem and create a Sensitivity Report. Use this information to answer the following questions: Variable: X1: Number of product 1 to produce X2: Number of product 2 to produce Max 4X1+2X2 Subject to: 2X1+4X2<=20 (Labor Hour) 3X1+5X2<=15 (Key Components) Non-negativity What is the optimal solution? O A. X1=5, X2%3D0 O B. X1=0, X2=0 O C.X1=0, X2=5 O D.X1=5, X2=5 Sensitivity Report Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease SAS2 X1 4 1E+30 2.8 $B$2 X2 -4.6667 2 4.6667 1E+30 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease SC$4 LHS 10 ????? 20 1E+30 ????? SC$5 LHS 15 1.3333 15 15 15 Which value can the unit profit of product 1 be without changing the optimal solution? O A. 0.2 B. 1000 ОС.1.1 O D. 0.8 Which statement regarding the shadow price of the Labor Hour constraint is true? O A. The shadow price of the first constraint is zero because the shadow price of a slack constraint is always 0. B. The shadow price of the first constraint is negative because the shadow price of a slack constraint is always negative. OC.There is no way to know about the shadow price of the first constraint without the sensitivity report. D. The shadow price of the first constraint is positive because the shadow price of a slack constraint is always positive. What is the optimal objective function value if key component availability changes from 15 to 25? O A. 16.6667 B. 33.3333 OC.6.6667 D. 35.3333 What is the reduced cost of product 2 if it only needs 1 key component? O A. -0.6667 O B. 0 C.-1.3333 O D. 0.6667 If product 2 only need 1 key component instead of 5, which statement is true? O A. It will not be worthwhile to produce product 2 because the reduced cost will be positive. B. It will be worthwhile to produce product 2 because the reduced cost will be positive. O C.It will be worthwhile to produce product 2 because the reduced cost will be negative. O D. It will not be worthwhile to produce product 2 because the reduced cost will be zero. There are two products to produce. The unit profit of product 1 is 4 and that of product 2 is 2. Two resources are required. They are labor hours and key components. Each product 1 will consume 2 units of labor hours and 3 key components. Each product 2 will consume 4 units of labor hours and 5 key components. The availability of labor hours is 20 units and that of key components is 15. The company wants to maximize its profits. Implement the following LP problem in Excel. Use Solver to solve the problem and create a Sensitivity Report. Use this information to answer the following questions: Variable: X1: Number of product 1 to produce X2: Number of product 2 to produce Max 4X1+2X2 Subject to: 2X1+4X2<=20 (Labor Hour) 3X1+5X2<=15 (Key Components) Non-negativity What is the optimal solution? O A. X1=5, X2%3D0 O B. X1=0, X2=0 O C.X1=0, X2=5 O D.X1=5, X2=5 There are two products to produce. The unit profit of product 1 is 4 and that of product 2 is 2. Two resources are required. They are labor hours and key components. Each product 1 will consume 2 units of labor hours and 3 key components. Each product 2 will consume 4 units of labor hours and 5 key components. The availability of labor hours is 20 units and that of key components is 15. The company wants to maximize its profits. Implement the following LP problem in Excel. Use Solver to solve the problem and create a Sensitivity Report. Use this information to answer the following questions: Variable: X1: Number of product 1 to produce X2: Number of product 2 to produce Max 4X1+2X2 Subject to: 2X1+4X2<=20 (Labor Hour) 3X1+5X2<=15 (Key Components) Non-negativity What is the optimal solution? O A. X1=5, X2%3D0 O B. X1=0, X2=0 O C.X1=0, X2=5 O D.X1=5, X2=5 Sensitivity Report Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease SAS2 X1 4 1E+30 2.8 $B$2 X2 -4.6667 2 4.6667 1E+30 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease SC$4 LHS 10 ????? 20 1E+30 ????? SC$5 LHS 15 1.3333 15 15 15 Which value can the unit profit of product 1 be without changing the optimal solution? O A. 0.2 B. 1000 ОС.1.1 O D. 0.8 Sensitivity Report Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease SAS2 X1 4 1E+30 2.8 $B$2 X2 -4.6667 2 4.6667 1E+30 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease SC$4 LHS 10 ????? 20 1E+30 ????? SC$5 LHS 15 1.3333 15 15 15 Which value can the unit profit of product 1 be without changing the optimal solution? O A. 0.2 B. 1000 ОС.1.1 O D. 0.8 Which statement regarding the shadow price of the Labor Hour constraint is true? O A. The shadow price of the first constraint is zero because the shadow price of a slack constraint is always 0. B. The shadow price of the first constraint is negative because the shadow price of a slack constraint is always negative. OC.There is no way to know about the shadow price of the first constraint without the sensitivity report. D. The shadow price of the first constraint is positive because the shadow price of a slack constraint is always positive. What is the optimal objective function value if key component availability changes from 15 to 25? O A. 16.6667 B. 33.3333 OC.6.6667 D. 35.3333 What is the reduced cost of product 2 if it only needs 1 key component? O A. -0.6667 O B. 0 C.-1.3333 O D. 0.6667 Which statement regarding the shadow price of the Labor Hour constraint is true? O A. The shadow price of the first constraint is zero because the shadow price of a slack constraint is always 0. B. The shadow price of the first constraint is negative because the shadow price of a slack constraint is always negative. OC.There is no way to know about the shadow price of the first constraint without the sensitivity report. D. The shadow price of the first constraint is positive because the shadow price of a slack constraint is always positive. What is the optimal objective function value if key component availability changes from 15 to 25? O A. 16.6667 B. 33.3333 OC.6.6667 D. 35.3333 What is the reduced cost of product 2 if it only needs 1 key component? O A. -0.6667 O B. 0 C.-1.3333 O D. 0.6667 If product 2 only need 1 key component instead of 5, which statement is true? O A. It will not be worthwhile to produce product 2 because the reduced cost will be positive. B. It will be worthwhile to produce product 2 because the reduced cost will be positive. O C.It will be worthwhile to produce product 2 because the reduced cost will be negative. O D. It will not be worthwhile to produce product 2 because the reduced cost will be zero. If product 2 only need 1 key component instead of 5, which statement is true? O A. It will not be worthwhile to produce product 2 because the reduced cost will be positive. B. It will be worthwhile to produce product 2 because the reduced cost will be positive. O C.It will be worthwhile to produce product 2 because the reduced cost will be negative. O D. It will not be worthwhile to produce product 2 because the reduced cost will be zero.
Expert Answer:
Answer rating: 100% (QA)
Solving the given formulation in Excel we get the below solution and the Sensitivity Report The sens... View the full answer
Related Book For
Posted Date:
Students also viewed these management leadership questions
-
There are two products that can be formed by syn addition of hydrogen to 2,3-dimethylbicyclo[ 2.2.1]-2-heptene. Write or make molecular models of their structures.
-
There are two products that can be formed by syn addition of hydrogen to 2,3 dimethylbicyclo[2.2.1]-2-heptene. Write or make molecular models of their structures. CH3...
-
In year 1 and year 2, there are two products produced in a given economy, computers and bread. Suppose that there are no intermediate goods. In year 1, 20 computers are produced and sold at $1,000...
-
The specific activity of a preparation consisting of radioactive Co58 as and non-radioactive Co59 ao is equal to 2.2.1012 dis /(s g). The half-life of Co58 as is 71.3 days. Find the ratio of the mass...
-
A firm sells goods with an average retail price of $550.00. Customers usually pay 60 days after the date of purchase. The per unit cost of producing the goods is $125.00. Assume the cost of borrowing...
-
Fashion Victim, Inc., sells a T-shirt called Skeleton Woopee with a fanciful design depicting skeletons engaging in sexual activity in seven different positions. Skeleton Woopee is Fashions...
-
Indicate whether each of the following costs related to inventory, a through I, would be considered (1) a purchasing cost, (2) an ordering cost, (3) a carrying cost, or (4) a cost of not carrying...
-
Sports Glove Company produces three types of high performance sports gloves: small, medium, and large. A glove pattern is first stenciled onto leather in the Pattern Department. The stenciled...
-
The shortform name of the external environment of business is PEST, what is PEST, explain each of the external factors that comprises PEST and how it can impact businesses?
-
Ramsey Liquors owns and operates a chain of beer and wine shops throughout the Dallas-Fort Worth metroplex. The rapidly expanding population of the area has resulted in the firm requiring a growing...
-
Below is a set of word-forms. Analyze them from the point of view of a possible decomposition route. Decompose them using bracketing form. Use web search/ online corpus search for frequency...
-
Using specific examples, explain the concepts of inbound and outbound calls.
-
Perform a strengths, weaknesses, opportunities and threats (SWOT) analysis on ASOS.
-
To what extent does ASOS sell through an integrated distribution channel system?
-
The quantity of audit working papers compiled on an engagement would most be affected by: a. Management's integrity. b. Control risk. c. A new engagement. d. The auditor's experience.
-
Discuss how firms can attract and retain new customers.
-
1. This software has been used to connect two or more software components in a system architecture where software from different vendors are in use. ____________is computer software that provides...
-
Determine whether the lines are parallel, perpendicular, or neither. 2x + 3y = -12, 2y - 3x = 8
-
Write structural formulas or make molecular models for all the compounds that are trichloro derivatives of cyclopropane. (Don't forget to include stereoisomers.) Which are chiral? Which are achiral?
-
Consider all the isomers of C7H7Cl containing a benzene ring and write the structure of the one that has the weakest carbon-chlorine bond as measured by its bond dissociation energy.
-
Write structural formulas and give the IUPAC names for all the alkynes of molecular formula C5H8.
-
Why is an adjustment for accrued federal income tax never planned on a partnership work sheet?
-
When does a deficit occur?
-
What account is debited when a partner withdraws supplies for personal use?
Study smarter with the SolutionInn App