CREATE A TABLE & SOLVE USING EXCEL

Levis Strauss, a multinational corporation, produces two types of cotton products, denim and corduroy, which have profits of $9 and $7, respectively. It is required two assembly lines in order to process each unit of product, and the required production times are as follows:

	Hours/unit
	Line 1	Line 2
Denim	12	4
Corduroy	4	8
Total hours	60	40

a. Formulate a linear programming model to determine the optimal product mix that will maximize profit.

b. Transform this model into standard form.

c. Solve the Problem graphically.

d. Identify the amount of unused resources (i.e., slack) at each of the graphical extreme points.

e. What would be the effect on the optimal solution if the production time on line 1 was reduced

to 40 hours?

f. What would be the effect on the optimal solution if the profit for product B was increased

from $7 to $15? to $20?