linear programming Application

profileRomany11
rating.xlsx

Sheet1

Assignment 3
Assignment 3
Criteria Ratings Pts
PART 1: For Oct - is # working correct? Yes No 0.5 pts
0.5 pts 0.0 pts
PART 1: For Oct, is # working at least the min needed? Yes No 0.5 pts
0.5 pts 0.0 pts
PART 1: For Nov - Is # working correct? Yes No 0.5 pts
0.5 pts 0.0 pts
PART 1: For Nov: is # working at least the min needed? Yes No 0.5 pts
0.5 pts 0.0 pts
PART 1: For Dec, is # working correct? Yes No 0.5 pts
0.5 pts 0.0 pts
PART 1: For Dec, is # working at least the min needed? Yes No 0.5 pts
0.5 pts 0.0 pts
PART 1: For Jan, is # working correct? Yes No 0.5 pts
0.5 pts 0.0 pts
PART 1: For Jan, is # working at least min needed? Yes No 0.5 pts
0.5 pts 0.0 pts
PART 1: For Feb, is # working correct? Yes No 0.5 pts
0.5 pts 0.0 pts
PART 1: For Feb, is # working at least the min needed? Yes No 0.5 pts
0.5 pts 0.0 pts
PART 1: For March - is #working correct? Yes No 0.5 pts
0.5 pts 0.0 pts
PART 1: For March - Is # working at least the min? Yes No 0.5 pts
0.5 pts 0.0 pts
PART 1: Labor cost correct? Yes No 1.5 pts
1.5 pts 0.0 pts
PART 1: Training cost correct? Yes No 1.5 pts
1.5 pts 0.0 pts
PART 2a: Formulation of Objective Function Correct? Full Credit Partial credit No Credit 4.0 pts
4.0 pts 2.0 pts 0.0 pts
PART 2a: Formulation of constraint for Oct min requirement Full Credit Partial credit No Credit 4.0 pts
4.0 pts 2.0 pts 0.0 pts
PART 2a: Formulation of constraint for Nov min requirement Full credit Partial credit No credit 4.0 pts
4.0 pts 2.0 pts 0.0 pts
PART 2a: Formulation of constraint for Dec min requirement Full credit Partial credit No credit 4.0 pts
4.0 pts 2.0 pts 0.0 pts
PART 2a: Formulation of constraint for Jan min requirement Full credit Partial credit No credit 4.0 pts
4.0 pts 2.0 pts 0.0 pts
PART 2a: Formulation of constraint for Feb min requirement Full credit Partial credit No credit 4.0 pts
4.0 pts 2.0 pts 0.0 pts
PART 2a: Formulation of constraint for March min requirement Full credit Partial credit No credit 4.0 pts
4.0 pts 2.0 pts 0.0 pts
PART 2a: Generation of optimal solution in provided spreadsheeet Full credit Partial credit No credit 5.0 pts
5.0 pts 3.0 pts 0.0 pts
PART 2b: Is calculation of new cost allowable and correct? Full Marks Partial credit No credit 5.0 pts
5.0 pts 3.0 pts 0.0 pts
PART 2c: Is calculation of % cost savings correct? Full credit No credit 3.0 pts
3.0 pts 0.0 pts
Total Points: 50.0
PreviousNext