Help using Excel Revise your linear programming model for th

Help using Excel:

Revise your linear programming model for the woodworking company discussed in problems 2 and 3 to take into account the following additional general guidelines for production:

Tables and chairs shall only be sold in complete sets consisting of one table and four chairs (i.e., tables and chairs may not be sold individually).

Profit for a given production period shall be calculated based upon the number of complete table and chair sets produced during the production period.Tables and chairs associated with partial table and chair sets shall not be considered when calculating profit.

Partially manufactured tables and/or chairs do not contribute to profit earned during a given production cycle.

The company must manufacture a minimum of 50 complete table and chair sets during any given production cycle in order to satisfy estimated customer demand.

Answer the following questions based upon your revised LP model:

What is the optimal number of tables the company should produce during the current production cycle in order to produce the optimal number of complete table and chair sets?

What is the optimal number of chairs the company should produce during the current production cycle in order to produce the optimal number of complete table and chair sets?

What is the total amount of profit that the company will potentially earn for producing the optimal number of complete table and chair sets?

Which resources will be fully used in producing the optimal number of tables and chairs?

Solution