All-Walnut, Inc. produces two models of bookcases. The bookcases sell for the amount listed in the table below. Each bookcase requires a certain number of labor hours, machine time, and materials (wood). Each unit of material costs $6.00. All-Walnut has a fixed number of labor and machine hours available. However, the amount of wood required varies by bookcase. They want to maximize their profit by determining how many of each type of bookcase to produce given their available labor and machine hours. The profit should consider both the selling price per unit and the cost of materials required for production.

	Selling Price	Labor	Machine Time	Material Units
Bookcase 1	$60	1.00	2.20	2
Bookcase 2	$45	0.80	0.75	1
Available		40	80

The linear program is given below.

Let B1 represent the number of Bookcase 1 to produce.

Let B2 represent the number of Bookcase 2 to produce.

Maximize Profit: Profit = $60*B1 + $45*B2 - $6*Material

Subject to:

Material = 2*B1 + 1*B2

Labor Constraint: 1.00*B1 + 0.80*B2 <= 40

Machine Constraint: 2.20*B1 + 0.75*B2 <= 80

Non-negatively Constraint: B1, B2 >= 0

Integer Constraint: B1, B2 Integer

Create the optimization model for the problem in Excel and answer the following questions.

a. How many of Bookcase 1 will you produce to maximize profit?

b. How many of Bookcase 2 will you produce to maximize profti?

c. What is your maximum profit?