Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Given results after developing the excel LP and Solver: Excel program ASAN 8 HANA 5 4 Cotton Leather Labor Profitunit Availability 1000 900 700 0
Given results after developing the excel LP and Solver: Excel program ASAN 8 HANA 5 4 Cotton Leather Labor Profitunit Availability 1000 900 700 0 6 4 $15 $30 0 175.0 Number produced Profit contribution Total (per week) $5250 SO $5250 20 minutes on slide Solver Sensitivity Report: Variable Cells Cell SBS21 $C$21 Name Number produced ASAN Number produced HANA Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 0 -15 15 15 IE+15 175 0 30 1E-30 2 Sober Constraints Cell Name SB$25 Cotton Amount Used $B$26 Leather Amount Used $B$27 Labor Amount Used Final Shadow Constraint Value 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? e. How much should the ASAN unit profit of $15 be increased by so the manufacturer can produce them
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started