--%>
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 : Define CALSTARS CALSTARS : The acronym

    CALSTARS: The acronym for the California State Accounting and Reporting System that is the state's primary accounting system. Most of the departments presently use CALSTARS.

    		•
  • Q : Risk from perspective of the Capital

    Discuss risk through the perspective of the Capital Asset Pricing Model (CAPM).The Capital Asset Pricing Model, or CAPM, can be utilized to compute the appropriate required rate of return for an investment project specified its degree of risk as

    		•
  • Q : How do mergers influence communities

    How do mergers influence communities?While a locally controlled bank is merged into a bank headquartered elsewhere (an out-of-market merger), some of the apprehension regarding the institution's future commitment to the local community is bound

    		•
  • Q : What is Budget Change Proposal Budget

    Budget Change Proposal (BCP): It is a proposal to modify the level of service or funding sources for activities sanctioned by the Legislature, suggest new program activities not presently authorized, or to remove existing programs.

    Q : Explain Budget Cycle Budget Cycle : The

    Budget Cycle: The time period needed to made a state financial plan and enacts that part of it applying to the budget year. The Significant events in the cycle comprise: • The preparation of G

    		•
  • Q : What are Authorized Positions

    Authorized Positions: As replicated in the Governor’s Budget (Expenditures by Category and modifications in Authorized Positions), corresponds with the “Total, Authorized Positions” illustrated in the Wages and Salaries.

    		•
  • Q : Describe Section 28.50 Section 28.50 :

    Section 28.50: It is a Control Section of the Budget Act which authorizes the Department of Finance to increase or reduce the reimbursement line of an appropriation schedule for the reimbursements received from agencies of other state. It too contains

    		•
  • Q : Define the term floor Floor: The

    Floor: The Assembly or Senate chambers or the word employed to explain the location of a bill or the kind of session. Matters might be termed to as “on the floor”.

    		•
  • 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 : What is Capital Outlay Capital Outlay

    Capital Outlay (CO): A character of expenses of funds to obtain land, plan and build new buildings, expand or transform existing buildings, and/or purchase tools associated to such construction.

    		•