Natural Furniture Company manufactures three outdoor products, chairs, benches, and tables. Each product must pass through the

Fantastic news! We've Found the answer you've been seeking!

Question:

Natural Furniture Company manufactures three outdoor products, chairs, benches, and tables. Each product must pass through the following departments before it is shipped: sawing, sanding, assembly, and painting. The time requirements (in hours) are summarized in the tables below.

The production time available in each department each week and the minimum weekly production requirement to fulfill contracts are as follows:

Minimum
Capacity	Production
Department	(In Hours)	Product	Level
Sawing	450	Chairs	100
Sanding	400	Benches	50
Assembly	625	Tables	50
Painting	550

Hours Required				Unit
Product	Sawing	Sanding	Assembly	Painting	Profit
Chairs	1.5	1.0	2.0	1.5	$15
Benches	1.5	1.5	2.0	2.0	$10
Tables	2.0	2.0	2.5	2.0	$20

The production manager has the responsibility of specifying production levels for each product for the coming week. Formulate as a linear programming problem to maximize profit.

What mix of products would yield maximum profit?

Formulate as an LP problem to maximize profit. What is the maximum profit? Use SOLVER in EXCEL to calculate