--%>
Assignment Help - homework help

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 : Explain Fund Condition Statement Fund

    Fund Condition Statement: A budget display, comprised in the Governor’s Budget, shortening the operations of a fund for the past, present, and budget years. The display comprises the starting balance, previous year adjustments, loans, revenue, t

    		•
  • Q : What is Audit Audit : Usually a review

    Audit: Usually a review of financial statements or performance activity (like an agency or program) to establish conformity or compliance with the applicable laws, regulations, and/or standards. The state has three central association

    		•
  • Q : How do flotation costs influence the

    Normal 0 false false

  • Q : Define Senate Senate : The higher house

    Senate: The higher house of California’s Legislature comprising of 40 members. As an outcome of Proposition 140 (that is, 1990, term limits) and Proposition 28 (that is, 2012, limits on Legislators’ terms in office), members chosen in or a

    		•
  • Q : Fin 235 Personal Finance Homework Fin

    Fin 235 Personal Finance Homework Chapter 8: Problems: 1, 3, 5, 7 1.   Most home insurance policies cover jewelry for $1,000 and silverware for $2,500 unless items are covered with additional insurance. If a family

    		•
  • Q : Inflationary expenditure gap or

    Normal 0 false false

  • Q : Define Allotment Allotment : The

    Allotment: The permitted division of an amount (generally of an appropriation) to be expended for a specific purpose throughout a particular time period. An allotment is usually authorized on line item expenditure basis by program or

    		•
  • Q : Define Reserve Reserve: The amount of a

    Reserve: The amount of a fund balance set sideways to give for expenditures from the unencumbered balance for ongoing appropriations, future apportionments, and economic uncertainties, pending salary or price raise appropriations, and appropriations f

    		•
  • Q : Define Executive Order Executive Order

    Executive Order (EO): It is a budget document, issued by the Department of Finance, asking for the State Controller’s Office to make an adjustment in their accounts. The adjustments are usually authorized by the Budget Act provision language, Bu

    		•
  • Q : Describe the bird in the hand theory of

    Describe the bird in the hand theory of cash dividends. The bird in the hand dividends theory says that dividends attained now are better than a promise of future dividends. Uncertainty is resolved while a dividend is paid.

    		•