URSEN TRANS USA ANIMAINS SLIDESHOW YEW VILW SUKY INGARDING Question 6: Sensitivity Analysis (13 Points) JMNS Inc. is a manufacturer of office supplies. In their new round of production they produce two types of chairs called HANA and ASAN. HANAS have partial leather fabric as well as Cotton. ASANs require 8 meters of Cotton and 6 hours of labor, while HANAs require 5 meters of Cotton, 4 meters of leather, and 4 hours of labor. For the next week, the company has 1,000 meters of Cotton, 900 meters of leather, and 700 hours of labor available. HANAS net a profit of $30 each, while ASANS net a profit of $15 each. All products can be sold to national chains shops. Instructions: Using the Excel Solver results in Table, address the following questions: 1.What are the Binding Constraints and the Optimum profit? 2.What are the slack/surplus values for Cotton, Leather and Labor? 3.Looking at the Shadow prices, how much would the objective profit increase by if labor increases by 90 hours? 4.What % of available Leather can be reduced without it affecting the current (given) optimum solution? 5.How much should the ASAN unit profit of $15 be increased by so the manufacturer can produce them? (i.e. become a positive number)? Given results after developing the excel LP and Solver: Excel progn Cotion Leather Labor Profi Fant Nesterpraded Profit condon Leather Labor AKAN HANA Availability 1000 0 4 900 6 4 700 $13 130 175.0 Total() 20 $3250 $1250 Amount Used 875 700 700 20 minutes on slide Sale Selby Repart Variable Calls Call Name Vale 0 175 Final Reduced Object Cast Coffin -15 15 30 Alable Allowable Incre Decreme 13 18-13 2 58521 Number produced ASAN SCS21 Number produced HANA Solver Contralat Name Cell 58525 Caon Amount Lled 5853 Luther Ampont Led S8527 Labor Amount Ubed Fisal Shadow Constraint Value Price 875 0 Allowable Allowable RH. Me Incre Decrease 1000 1E-10 130 700 0 900 1-30 250 700 20 700 40 360