09 Denim B10 Corduroy C10 B12 7 8 Model 9 10 Yards 11 12 OBJECTIVE 13 14 Constraints 15 Cotton 16 Processing 17 Demand 18 B15 D15 B16 B17 sor2 Sor2 Sor2 D16 D17 1) With the use of the cell references from the template above, what is the proper Excel formula used for cell B12 (INCLUDE THE EQUAL SIGN IN YOUR FORMULA) 2) List one of the binding constraints (Answer: Cotton, Processing, or Demand). 3) List the other binding constraint. 4) Is there SLACK or SURPLUS associated with the non-binding constraint? (Answer: Slack or Surplus) 5) How much slack or surplus is associted with the non-binding constraint? (Answer to O DECIMAL PLACES, do NOT include units with answer) 6) How many yards of denim should be produced monthly? 7) How many yards of corduroy should be produced monthly? 8) What is the maximum monthly profit? (ANSWER TO O DECIMAL PLACES, INCLUDE UNITS WITH ANSWER) Mills produces two types of cotton cloth; denim and corduroy. Corduroy is a heavier grade of cotton cloth and, as such, requires 8 pounds of raw cotton per yard, whereas denim requires 5 pounds of raw cotton per yard. A yard of denim requires 3 hours of processing time; a yard of corduroy requires 4 hours. While demand for denim is practically unlimited, demand for corduroy has never exceeded 600 yards per month. The manufacturer has 7,000 pounds of raw cotton and 4,000 hours of processing time available each month. The manufacturer makes a profit of $2.25 per yard of denim and $3.75 per yard of corduroy. How many yards of each type of cloth should be produced monthly to maximize profit? B C D Denim B3 B4 B5 Corduroy Total C3 D3 C4 D4 C5 DS C6 D6 B6 A 1 TEXTILE 2 3 Cotton 4 Processing 5 Demand 6 Profit or Cost 7 8 Model 9 10 Yards 11 12 OBJECTIVE 13 14 Constraints 15 Cotton 16 Processing 17 Demand 18 Denim B10 Corduroy C10 B12 Sor B15 B16 B17 Sor2 Sor2 D15 D16 017 1) With the use of the cell references from the template above, what is the proper Excel formula used for cell B12 (INCLUDE THE EQUAL SIGN IN YOUR FORMULA