Instructions:

1. Using the 4 steps in the formulation of a linear programming, creating a problem that requires the use of a decision making, related to an application for the use of the linear programming, based on the following case:
2. A company produces 3 types of furniture. Each one sells on $200, $150 y $120 respectfully. Make the linear programming with the data in the following table. The student must assume the data is provided by the company.
3. In the following table, the data is showing as the amount of hours required to produce each furniture, in: Wood cutting, Wood sanding and Wood painting and varnished.

	Hours required to produce 1 unity
Department	(A) Furniture	(B) Furniture	(C) Furniture	Hours availables this week
Wood cutting	15	7	5	315
Wood Sanding	2	5	2	110
Wood painting and varnished	1	3	1	50
Utility for unity	$200	$140	$130

1. Using your creativity, give a name and location to the company.

Modeling a real scenario: Linear programming

ESTRADA FURNITURE 300 Ave Casto Prez, San Germn PR 00683
Step	Description
Understand the administrative problem the business is facing.
Identify the objective and the restrictions.
Define the decision variables.
Use the decision varibales to write mathematic expressions of the objective and restrictions.
Note: With this table, enclose the results ot the Excel Qm o QM for Windows applications that were useful as supporting tool in the decisions making, in this modeling a real scenario exercise.

1. For this criteria stimation, use the ExcelQM o QM for Windows applications.
2. The document must follow the APA format. For APA format reference, visit the web pagehttp://owl.english.purdue.edu/owl/resource/560/01/.
3. Describe each step in the linear programming formulation, using the next table Levine, D. M., Stephan, D. Krehbiel, T.C. & Berenson, M.L., Statistics for Managers