QUESTION 50

1. 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?

   		12
   		6
   		8
   		10

2. 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

3. Which constraint is binding constraint?

   cutting and sewing

   sewing only

   material only

   cutting and material

4. Which constraint is non-binding constraint?

   sewing

   cutting

   material

   none of them

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

   		40
   		0
   		60
   		20

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

   		0
   		40
   		20
   		60