QUESTION 50 Scenario E A product mix problem can be solved by linear porgramming model. There are three resources needed for the production. The problem formulation is given:

number of skirts produced number of dresses produced number of sport coats produced Maximize: Profit = Subject to: using the solver add-on in Excel, solve this problem in Excel and answer the following questions. how many sport coats should be produced? 8 12 10 6 1 points

QUESTION 51 Scenario E A product mix problem can be solved by linear porgramming model. There are three resources needed for the production. The problem formulation is given: number of skirts produced number of dresses produced number of sport coats produced Maximize: Profit = Subject to: using the solver add-on in Excel, solve this problem in Excel and answer the following questions. what is the highest profit we can get under the optimum solution? $640 $680 $600 $620

QUESTION 52 Which constraint is binding constraint? sewing only material only cutting and sewing cutting and material

QUESTION 53 Which constraint is non-binding constraint? sewing cutting material none of them

QUESTION 54 How many sewing hours were unused under the optimum solution? 40 20 0 60

QUESTION 55 How many yards of materials were left under the optimum solution? 0 20 60 40

QUESTION 56 Add an additional constraint to this problem : X 1 + X 3 16, resolve it in Excel. How many coats should be produced now?

QUESTION 57 What is the highest profit we can make after we add the new constraint? (put in numbers only, no $ sign)

X1 = number of skirts produced X2 = number of dresses produced X; = number of sport coats produced Maximize: Profit = $5X, +$17X, +$30X, Subject to: X: +3X, +4X, 5100 (cutting) X1 +4X2 +6X, S180 (sewing) X + Xx +4X, S 60 (material ) X1, X3, and X: 20