Given results after developing the excel LP and Solver: Excel program ASAN HANA Availability 1000 Cotton 8 5 0 4 900 Leather Labor Profit/unit 6 4 700 $15 $30 0 175.0 Number produced Profit contribution Total (per week) $5250 $0 $5250 20 minutes on slide Solver Sensitivity Report: Variable Cells Reduced Final Value Allowable Cell Cost Objective Coefficient 15 Decrease Name Number produced ASAN Number produced HANA $B$21 SC$21 Allowable Increase 15 1E-30 0 -15 175 0 1E+15 2 30 Soker Constraints Final Value Shadow Constraint Price R.H. Side Allowable Cell Name $B$25 Cotton Amount Used $B$26 Leather Amount Used $B$27 Labor Amount Used Allowable Decrease 120 0 1000 Increase 1E+30 1E+30 875 700 700 0 900 20 700 250 3601 40 Given results after developing the excel LP and Solver: Excel program ASAN HANA Availability 1000 Cotton 8 5 0 4 900 Leather Labor Profit/unit 6 4 700 $15 $30 0 175.0 Number produced Profit contribution Total (per week) $5250 $0 $5250 20 minutes on slide Solver Sensitivity Report: Variable Cells Reduced Final Value Allowable Cell Cost Objective Coefficient 15 Decrease Name Number produced ASAN Number produced HANA $B$21 SC$21 Allowable Increase 15 1E-30 0 -15 175 0 1E+15 2 30 Soker Constraints Final Value Shadow Constraint Price R.H. Side Allowable Cell Name $B$25 Cotton Amount Used $B$26 Leather Amount Used $B$27 Labor Amount Used Allowable Decrease 120 0 1000 Increase 1E+30 1E+30 875 700 700 0 900 20 700 250 3601 40