60.1K

Verified Solution

Link Copied!

Given results after developing the excel LP and Solver: Excel program ASAN 8 HANA 5 Cotton Availability 1000 900 700 0 4 Leather Labor Profitunit 4 6 $15 $30 0 Number produced Profit contribution 175.0 $5250 Total (per week) $5250 SO 20 minutes on slide Solver Sensitivity Report: Variable Cells Cell SBS21 SC$21 Name Number produced ASAN Number produced HANA Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 0 -15 15 15 1E+15 175 0 30 1E-30 2 Sober Constraints Cell Name SB$25 Cotton Amount Used $B$26 Leather Amount Used SB$27 Labor Amount Used Final Shadow Constraint Vahe Price R.H. Sie 875 0 1000 700 0 700 20 700 Allowable Increase 1E+30 1E+30 40 Allowable Decrease 120 250 900 360 Question 3: Sensitivity Analysis (20 Points) Using the Excel Solver results in Table, address the following questions: a. What is the optimal solution and the Optimum profit? b. What are the slack/surplus values for Cotton, Leather and Labor? C. Looking at the Shadow prices, how much would the objective profit increase by if labor increases by 50 hours? d. What % of available Cotton can be reduced without it affecting the current (given) optimum solution? How much should the ASAN unit profit of $15 be increased by so the manufacturer can produce them

Answer & Explanation Solved by verified expert

See Answer