Target Cell (Max) Cell Name $G$3 Total Profit= Original Value 450 Final Value 640 Adjustable Cells Cell Name $B$2 Units Skirt $C$2 Units Dress $D$2 Units Coat Original Value 0 0 15 Final Value 0 20 10 Constraints Cell Name $E$6 Cutting Used $E$7 Sewing Used $E$8 Material Used $B$2 Units Skirt $C$2 Units Dress $D$2 Units Coat Cell Value Formula Status 100 $E$6=0 Binding 20 $C$2>=0 Not Binding 10 $D$2>=0 Not Binding Slack 0 40 0 0 20 10 Below is Excel Solver's Sensitivity Report Adjustable Cells Cell Name $B$2 Units Skirt CO2 units Dress Final Reduced Objective Allowable Value Cost Coefficient Increase 0 -2.5 5 2.5 55 Allowable Decrease 1E+30 05 Adjustable Cells Cell Name $B$2 Units Skirt $C$2 Units Dress $D$2 Units Coat Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 0 -2.5 5 2.5 1E+30 20 0 17 5.5 9.5 10 0 30 38 7.333333333 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $E$6 Cutting Used 100 4.75 100 32 40 $E$7 Sewing Used 140 0 180 1E+30 40 $E$8 Material Used 60 2.75 60 40 26.66666667 If Trimline were to produce the profit maximizing combination of skirts, dresses and coats, how many skirts would Trimline produce? Round to the closest whole number, Answer: Check Which of the following is constraining Trimline from earning a high profit if Trimline produces the profit maximizing number of skirts, dresses and coats? Select one or more: a. #hours of sewing capacity b. #yards of fabric c. #hours of cutting capacity The Con TDAW Which of the following is constraining Trimline from earning a high profit if Trimline produces the profit maximizing number of skirts, dresses and coats? Select one or more: a. #hours of sewing capacity b. #yards of fabric c. #hours of cutting capacity d. There are no constraints on Trimline's ability to make money. Check How much should Trimline be will to pay for an extra hour of cutting capacity Choose... an extra yard of material Choose... an extra hour of sewing capacity Choose. Check 0 Trimline could purchase additional yards of material for $2.50, how many additional yards should Trimline purchase? 3 Answer: ait of Check Suppose Trimline could sell cutting capacity for $5/hour. How many hours of cutting capacity should Timline be willing to sell at $5/hour? Answer: Check If before Trimline begins production the profit Trimline earns from producing a dress drops from $17 to $10, should Trimline change its initial production plans? Select one: a.no b. yes Check