one

profileFaint
Week1-Ch24-LPTEMPLATES.xlsx
Home>Business & Finance homework help>Management homework help>one

2 by 2 Template

LP Template for 2 by 2 Problem
DV 1
Bud: Step 2: List the decision variables. 		DV 2 type RHS
Min/Max
Bud: Step 1: State the objrctive.
Bud: Step 2: List the decision variables. 		Objective
Bud: Step 3: Quantify the relationship between the objective and the decision variavbles.		 Objective 0
Bud: Optimum objective value
Constraint 1
Bud: Step 4: List the names of the constraints.
Bud: Step 7: Quantify the relationship between each decision variable and each constraint.
Bud: Step 5: Define the type of each constraint. <=, =, >=
Bud: Step 6: Quantify the limiting vakue of each constraint.
Bud: Optimum objective value		 Constraint 1 0
Constraint 2 Constraint 2 0
Allocations
PROCESS >>> USE SOLVER

3 x 2 Template

LP Template for 3 by 2 Problem
DV 1
Bud: Step 2: List the decision variables. 		DV 2 type RHS
Min/Max
Bud: Step 1: State the objrctive.
Bud: Step 2: List the decision variables. 		Objective
Bud: Step 3: Quantify the relationship between the objective and the decision variavbles.		 Objective 0
Bud: Enter the SUMPRODUCT formulas.
Constraint 1
Bud: Step 4: List the names of the constraints.
Bud: Step 7: Quantify the relationship between each decision variable and each constraint.
Bud: Step 5: Define the type of each constraint. <=, =, >=
Bud: Step 6: Quantify the limiting vakue of each constraint.
Bud: Enter the SUMPRODUCT formulas.		 Constraint 1 0
Constraint 2 Constraint 2 0
Constraint 3 Constraint 3 0
Allocations
PROCESS >>> USE SOLVER

3 by 3 Template

LP Template for 3 by 3 Problem
DV 1
Bud: Step 2: List the decision variables. 		DV 2 DV 3 type RHS
Min/Max
Bud: Step 1: State the objrctive.
Bud: Step 2: List the decision variables. 		Objective
Bud: Step 3: Quantify the relationship between the objective and the decision variavbles.		 Objective 0
Bud: Optimum objective value
Constraint 1
Bud: Step 4: List the names of the constraints.
Bud: Step 7: Quantify the relationship between each decision variable and each constraint.
Bud: Step 5: Define the type of each constraint. <=, =, >=
Bud: Step 6: Quantify the limiting vakue of each constraint.
Bud: Optimum objective value		 Constraint 1 0
Constraint 2 Constraint 2 0
Constraint 3 Constraint 3 0
Allocations
PROCESS >>> USE SOLVER

4 x 2 Template

LP Template for 4 by2 Problem
DV 1
Bud: Step 2: List the decision variables. 		DV 2 type RHS
Min/Max
Bud: Step 1: State the objrctive.
Bud: Step 2: List the decision variables. 		Objective
Bud: Step 3: Quantify the relationship between the objective and the decision variavbles.		 Objective 0
Bud: Optimum objective value
Constraint 1
Bud: Step 4: List the names of the constraints.
Bud: Step 7: Quantify the relationship between each decision variable and each constraint.
Bud: Step 5: Define the type of each constraint. <=, =, >=
Bud: Step 6: Quantify the limiting vakue of each constraint.
Bud: Optimum objective value		 Constraint 1 0
Constraint 2 Constraint 2 0
Constraint 3 Constraint 3 0
Constraint 4 Constraint 4 0
Allocations
PROCESS >>> USE SOLVER

4 by 4 Template

LP Template for 4 by 4 Problem
DV 1
Bud: Step 2: List the decision variables. 		DV 2 DV 3 DV 4 type RHS
Min/Max
Bud: Step 1: State the objrctive.
Bud: Step 2: List the decision variables. 		Objective
Bud: Step 3: Quantify the relationship between the objective and the decision variavbles.		 Objective 0
Bud: Optimum objective value
Constraint 1
Bud: Step 4: List the names of the constraints.
Bud: Step 7: Quantify the relationship between each decision variable and each constraint.
Bud: Step 5: Define the type of each constraint. <=, =, >=
Bud: Step 6: Quantify the limiting vakue of each constraint.
Bud: Optimum objective value		 Constraint 1 0
Constraint 2 Constraint 2 0
Constraint 3 Constraint 3 0
Constraint 4 Constraint 4 0
Allocations
PROCESS >>> USE SOLVER

6 x 4 Template

LP Template for 6 by 4 Problem
DV 1
Bud: Step 2: List the decision variables. 		DV 2 DV 3 DV 4 type RHS
Min/Max
Bud: Step 1: State the objrctive.
Bud: Step 2: List the decision variables. 		Objective
Bud: Step 3: Quantify the relationship between the objective and the decision variavbles.		 Objective 0.00
Bud: Optimum objective value
Constraint 1
Bud: Step 4: List the names of the constraints.
Bud: Step 7: Quantify the relationship between each decision variable and each constraint.
Bud: Step 5: Define the type of each constraint. <=, =, >=
Bud: Step 6: Quantify the limiting vakue of each constraint.
Bud: Optimum objective value		 Constraint 1 0
Constraint 2 Constraint 2 0
Constraint 3 Constraint 3 0
Constraint 4 Constraint 4 0
Constraint 5 Constraint 5 0
Constraint 6 Constraint 6 0
Allocations
PROCESS >>> USE SOLVER

20 x 20 Template

LP Template for 20 by 20 Problem
DV 1
Bud: Step 2: List the decision variables. 		DV 2 DV 3 DV 4 DV 5 DV 6 DV 7 DV 8 DV 9 DV 10 DV 11 DV 12 DV 13 DV 14 DV 15 DV 16 DV 17 DV 18 DV 19 DV 20 type RHS
Maximize
Bud: Step 1: State the objective.
Bud: Step 2: List the decision variables. 		Objective
Bud: Step 3: Quantify the relationship between the objective and the decision variavbles.		 Objective 0
Bud: Optimum objective value
Constraint 1
Bud: Step 2: List the decision variables.
Bud: Step 7: Quantify the relationship between each decision variable and each constraint.		 ≤
Bud: Step 5: Define the type of each constraint. <=, =, >=		 0
Bud: Step 6: Quantify the limiting vakue of each constraint.		 Constraint 1 0.0
Constraint 2
Bud: Step 2: List the decision variables. 		≤ 0 Constraint 2 0.0
Constraint 3
Bud: Step 2: List the decision variables. 		≤ 0 Constraint 3 0.0
Constraint 4
Bud: Step 2: List the decision variables. 		≤ 0 Constraint 4 0.0
Constraint 5
Bud: Step 2: List the decision variables. 		≤ 0 Constraint 5 0.0
Constraint 6
Bud: Step 2: List the decision variables.
Bud: Step 5: Define the type of each constraint. <=, =, >=
Bud: Step 6: Quantify the limiting vakue of each constraint.
Bud: Optimum objective value		 ≤ 0 Constraint 6 0.0
Constraint 7 ≤ 0 Constraint 7 0.0
Constraint 8 ≤ 0 Constraint 8 0.0
Constraint 9 ≤ 0 Constraint 9 0.0
Constraint 10 ≤ 0 Constraint 10 0.0
Constraint 11 ≤ 0 Constraint 11 0.0
Constraint 12 ≤ 0 Constraint 12 0.0
Constraint 13 ≤ 0 Constraint 13 0.0
Constraint 14 ≤ 0 Constraint 14 0.0
Constraint 15 ≤ 0 Constraint 15 0.0
Constraint 16 ≤ 0 Constraint 16 0.0
Constraint 17 ≤ 0 Constraint 17 0.0
Constraint 18 ≤ 0 Constraint 18 0.0
Constraint 19 ≤ 0 Constraint 19 0.0
Constraint 20 ≤ 0 Constraint 20 0.0
Allocations