Busi. 410 HW 1

Busi. 410 HW 1 - S1 S2 S3 S4 Min 400 270 400 65 Cost 14560...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: S1 S2 S3 S4 Min. 400 270 400 65 Cost 14560 Subject to: 20 Demand 1 280 >= 20 10 Demand 2 400 >= 10 20 Demand 3 380 >= 10 20 5 Demand 4 420 >= Actual value 14 12 13 8 Solution 1. The goal is t o minimize t he t otal cost of hir ing. 2. Decision var iables: let S1=the student s hired in week 1, let S2=st udents hired in week 2, let S3=students hired in week 3, and let S4=student s hired in week 4 3. Min. $400(S1) + $270(S2) + $400(S3) + $65(S4) 4. Const raint s:-Demand in Week 1: 20(S1) >= 280-Demand in Week 2: 20(S1) + 10(S2) >= 400-Demand in Week 3: 10(S2) + 20(S3) >= 380-Demand in Week 4: 10(S2) + 20(S3) + 5(S4) >= 420 280 400 380 420 Total needed Microsoft Excel 12.0 Answer Report Worksheet: [Busi. 410 HW 1.xls]1 Report Created: 9/12/2010 11:35:49 PM Target Cell (Min) Cell Name Original Value Final Value $N$2 Cost 1135 14560 Adjustable Cells Cell Name Original Value Final Value $I$9 S1 1 14 $J$9 S2 1 12 $K$9 S3 1 13 $L$9 S4 1 8 Constraints Cell Name Cell Value Formula Status Slack $N$4 Demand 1 280 $N$4>=$P$4 Binding $N$5 Demand 2 400 $N$5>=$P$5 Binding $N$6 Demand 3 380 $N$6>=$P$6 Binding $N$7 Demand 4 420 $N$7>=$P$7 Binding H B C Max. 0.3 0.5 0.4 Profit 764 Subject to: 0.4 0.6 0.5 Assembly minutes 960 <= 1 Minimum H 980 >= 1 Minimum B 780 >= 1 Minimum C 200 >= 1 1 1 Total sandwiches needed 1960 >= 1-1-1 Increased demand for H 0 >= Actual used 980 780 200 Solution 1. The goal is t o maximize profit s from sandwich product ion. 2. Decision var iables: let H =ham and cheese, let B=bologna, and let C=chicken salad 3. Max. $.3(H ) + $.5(B) + $.4(C) 4. Const raint s:-Assembly minut es: .4(H ) + .6(B) + .5(C) <= 960-Minimum H: H >= 200-Minimum B: B>= 200-Minimum C: C >= 200-I ncreased demand for H: H-B-C >= 0-Total sandwiches needed: H + B + C >= 1500 960 200 200 200 1500 Total available Microsoft Excel 12.0 Answer Report Worksheet: [Busi. 410 HW 1.xls]Problem 2 Report Created: 9/13/2010 12:00:13 AM Target Cell (Max) Cell Name Original Value Final Value $M$2 Profit 1.2 764 Adjustable Cells Cell Name Original Value Final Value $I$11 H 1 980 $J$11 B 1 780 $K$11 C 1 200 Constraints Cell Name Cell Value Formula Status Slack $M$4 Assembly minutes 960 $M$4<=$O$4 Binding $M$5 Minimum H 980 $M$5>=$O$5 Not Binding 780 $M$6 Minimum B 780 $M$6>=$O$6 Not Binding 580 $M$7 Minimum C 200 $M$7>=$O$7 Binding $M$8 Total sandwiches needed...
View Full Document

This note was uploaded on 06/07/2011 for the course BUSI 410 taught by Professor Massa during the Fall '09 term at UNC.

Page1 / 20

Busi. 410 HW 1 - S1 S2 S3 S4 Min 400 270 400 65 Cost 14560...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online