Dukes Wear wants to determine the number of women's Polos (P), Sweatshirts (S) and Tshirts (1) to produce to maximize profits. There is limited time available (in minutes) in each of three departments - cutting & dyeing, sewing, and inspection & packaging - as well as a minimum requirement for number of Polos produced. The Excel model for the company is given below. E F B C D Polos Sweatshirts Tshirts 0 0 0 Number of units 1 2 3 4 Total Profit $0 Profit per unit $3 $5.5 $4 5 LHS 0 6 Constraints 7 Cut & Dye time (minutes) 8 Sew time (minutes) 9 Inspect & Pack time (minutes) 10 Minimum Polos reqd. 12 15 10 15 8 12 2 0 RHS 18000 18000 9000 1000 4 0 0 1 0 0 Using the information above, write the question number and your answers. 1. The numerical value computed by the Excel function =SUMPRODUCT(07:08,07:08) is_ 2. Write the exact entries for each of the following items in the Solver dialog box: a. Set cell b. Changing cells c. Constraint for Cut & Dye time 3. Using the variables P. 5, and T (as defined above), formulate the following parts of the original LP model represented by the spreadsheet: 0 UAN Total Profit $0 $5.5 $4 LHS 2 Number of units 0 3 4 Profit per unit $3 5 Constraints 7 Cut & Dye time (minutes) 12 8 Sew time (minutes) 15 9 Inspect & Pack time (minutes) 3 10 Minimum Polos reqd. 1 6 10 15 4 0 8 12 2 0 OOOO RHS 18000 18000 9000 1000 Using the information above, write the question number and your answers. 1. The numerical value computed by the Excel function=SUMPRODUCT(C7:C8,07:08) is_ 2. Write the exact entries for each of the following items in the Solver dialog box: a. Set cell b. Changing cells c. Constraint for Cut & Dye time 3. Using the variables P, S, and T (as defined above), formulate the following parts of the original LP model represented by the spreadsheet: a. Constraint for Inspect & Pack time b. Objective function