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.

1. what is the highest profit we can get under the optimum solution?

   		$620
   		$680
   		$640
   		$600

QUESTION 52

1. Which constraint is binding constraint?

   sewing only

   cutting and material

   material only

   cutting and sewing

QUESTION 53

1. Which constraint is non-binding constraint?

   sewing

   cutting

   material

   none of them

QUESTION 54

1. How many sewing hours were unused under the optimum solution?

   		60
   		20
   		0
   		40

QUESTION 55

1. How many yards of materials were left under the optimum solution?

   		60
   		40
   		20
   		0

A product mix problem can be solved by linear porgramming model. There are three resources needed for the production. The problem formulation is given: X; - number of skirts produced X; - number of dresses produced X = number of sport coats produced Maximize: Profit = $5X, +$17X, +$30x, Subject to: X; +3X+4X, 5100 (cutting) X; +4X: +6X, 5180 (sewing) X; + X: +4X, 560 (material X. X, and X, 20 014 using the solver add-on in Excel, solve this problem in Excel and answer the following questions