Target Compliance

Objective (3) Identify the applications of linear programming to business.

Objective (4) Use of computer programs to solve linear programming problems.

Introduction

The Module 3 material discussed linear programming models and their application in business. In this work the student will apply the four (4) steps in the formulation of a linear program to a hypothetical business situation.

Instructions:

Using the four steps to follow in the formulation of a linear program, model a problem that requires the use of a decision making related to the application of the use of linear programming based on the following case:

1. A company produces benches and tables for patios. The banks generate a profit of $9. The tables generate a profit of $20 each. Perform linear programming with the data in the Table below. The student will assume that these data come from the company.

2. The following Table shows the data with the hours required to produce the benches and patio tables in wooden feet, hours of work required by carpenters.

	Benches	Picnic tables	Available hours
Carpenters	4	6	1,200
			Wood available
Wood (foot)	10	35	3,500
Utility	$9	$20

3. Using your creativity, you are going to give the company a name and location.

4. You will describe each step in the formulation of linear programming using: Modeling Table of a real scenario: Linear Programming

Modeling in a real scenario: Linear programming Name of the company Location
Step	Description
Thoroughly understand the administrative problem being faced.
Identify the goal and constraints.
Define the decision variables.
Use decision variables to write mathematical expressions for the objective function and constraints.
Note: Next to this Table, attach results of the Excel Qm or QM for Windows programs that served as a support tool in the decision-making of the modeling of a real scenario.

1. Include the interpretation of the results how many units of each should be produced and how much is the optimal profit. Include this interpretation with recommendations. You can include the results of the sensitivity analysis.

2. For the estimation of these criteria, you will use the Excel tool QM or QM for Windows.

It must include academic sources 3 sources or more to sustain their arguments, they must be in formations and mentioned in accordance with the current APA regulations.