--%>

Sensitivity analysis report

ABC Company manufactures three types of products and has provided you with the following linear problem:

Max Z=15X1+20X2+14X3 (Total profit)
s.t.
5X1+6X2+4X3<=210 (Total labor hours available)
10X1+8X2+5X3<=200 (Total material in pounds available)
4X1+2X2+5X3<= 170 (Total machine minutes available)

1. Explain what the parameters of each decision variable (x1, x2, & x3) in the objective  function and constraints define? Solve the problem using solver or Tora and provide the sensitivity analysis report.

2. Based on the sensitivity report answer the following questions with a clear description of your answer (No credit will be given if your answer is not based in the sensitivity analysis report):

a) What is the optimal solution and what is its value?

b) By how much would the profit per unit of product 1 have to increase for it to have a non-zero value in the optimal solution?

c) If the profit per unit of product 2 increased by $2, would the optimal values of products 2 and 3 change? Would the optimal value of the objective function change? By how much?

d) If the available labor decreased by 12 hours, would it cause a change in the optimal values of the decision variables? Would anything change?

e) If the available amount of material increased by 10 pounds, how would that affect the optimal value of the objective function?

E

Expert

Verified

Part 1:

X1 – number of units of product 1 to be produced
X2 – number of units of product 2 to be produced
X3 – number of units of product 3 to be produced

In the objective function, the coefficients of X1, X2 and X3 are their respective profits. In constraint 1, the coefficients of X1, X2 and X3 are their respective labor hours to produce one unit of each and the right hand side indicates the total labor hours available. In constraint 2, the coefficients of X1, X2 and X3 are their respective pounds of material to produce one unit of each and the right hand side indicates the total material in pounds available. In constraint 3, the coefficients of X1, X2 and X3 are their respective minutes in machine to produce one unit of each and the right hand side indicates the total machine minutes available.

On solving the problem in solver, we get the optimal solution and sensitivity report as attached in the excel file.

Part 2:

(a) The optimal solution is to produce 5 units of product 2 and 32 units of product 3 which gives a total profit of $548.

(b) The profit per unit of product 1 would have to increase by $10.6 (reduced gradient value) for it to have a non-zero value in the optimal solution.

(c) If the profit per unit of product 2 increased by $2, the optimal values of products 2 and 3 would have change since their reduced gradient values are zero. Yes, the optimal value of the objective function would change by 5x, where x is the increase in profit of product 2. In this case, it is $2 and hence the optimal value of the objective function will increase by $10 (5*$2) and the value is $558.

(d) If the available labor decreased by 12 hours, it would not cause a change in the optimal values of the decision variables because the Lagrange multiplier for labor hours is zero. Only the slack will decrease by 12. Other than that, there will be no change in anything.

(e) If the available amount of material is increased by 10 pounds, the optimal value of the objective function will increase by 2.4x (Lagrange multiplier for material usage), where x is the increase in the amount of material available in pounds. In our case, since it is 10 pounds, the optimal value will increase by $24, thus resulting in a value of $572.

   Related Questions in Finance Basics

  • Q : Describe the benefits of paying late

    Describe the benefits of "paying late" (but not too late) and how do companies try to do this? Since money has time value, the later cash is paid, but not too late, the better. Companies employ remote disbursement banks to facilitate holding at

  • Q : In which ratios long-term bond investor

    Which ratios would a potential long-term bond investor is most interested in? Describe. Current & potential lenders of long-term funds, such like banks & bondholders, are interested in debt ratios.  While a business's debt ratios ri

  • Q : Explain the primary advantage of

    Explain the primary advantage to a corporation of investing some of its funds within working capital? Through investing in working capital a firm gets the liquidity it require helping it to pay its bills. Therefore the risk of the firm is reduce

  • Q : What is Prior Year Adjustment Prior

    Prior Year Adjustment: An adjustment for the difference among prior year accruals and real expenditures or revenues. The previous year adjustment amount is usually comprised in the Fund Condition Statements as an adjustment to realign the starting fun

  • Q : Assignments i want to write final

    i want to write final report about my state Texas. using the resources that i attached and the other resources to cover the outlines.

  • Q : Measuring net output GDP in a specific

    Why do national income accountants comprise only final goods in measuring net output GDP in a specific year? Why don't they comprise the value of stocks and bonds bought & sold? Why don't they comprise the value of utilized furniture bought and so

  • Q : Clarify trade credit is free credit or

    Trade credit is free credit. Do you agree or conflicting with this statement? Clarify. Trade credit is not free. It contains a cost. Who bears that cost based on the terms of the transaction among the grantor and the recipient of the trade c

  • Q : Define the term Technical Technical :

    Technical: In the budget systems, refers to an amendment which clarifies, accurate, or else does not materially influence the purpose of a bill.

  • Q : Define Financial Planning Financial

    Financial Planning: It is a comprehensive assessment of an investor's present and future financial state by employing presently known variables to forecast future cash flows, asset values and the withdrawal plans.

  • Q : Describe Modigliani and Miller theory

    Describe Modigliani and Miller theory of dividends? Describe. The Modigliani-Miller theory of dividends says which dividend theory is irrelevant. They claim that it is the income generated by assets that is significant, not how funds are distr