{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Some solutions for A05 - Due Saturday 2/7 at midnight This...

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

View Full Document Right Arrow Icon
Due Saturday 2/7 at midnight This assignment is worth 20 points. It must be done in your pre-assigned team. Do the following problems from the text (H&H) 5.2 5.3 5.4 5.7 Please submit work in ONE Excel file. Name your file A05_TeamName. (TeamName is shown in Group Pages folder.) Examples: A05_Blue A05_Maize A05_Red. One submission per team. In the upper left hand corner of the first tab of the Excel file: List the name(s) of each team member. List the percent contributions of each team member. Submissions without names or percent contributions will be scored. However, individual scores Submissions without names or percent contributions will be scored. However, individual scores wi
Background image of page 1

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

View Full Document Right Arrow Icon
will not be assigned until percent contributions are received. 10% reduction per day overdue. ill not be assigned until percent contributions are received. 10% reduction per day overdue.
Background image of page 2
5.2 Live model: C3:H10 d A1 A2 Profit A1 A2 Profit a Unit profit $2.00 $5.00 6 2 #REF! 6 2 #REF! $1.00 0 4 $20.00 $2.50 10 0 $20.00 esource Usage per Un $1.20 0 4 $20.00 $3.00 10 0 $20.00 Resource A1 A2 Used Available $1.40 0 4 $20.00 $3.50 10 0 $20.00 1 1 2 10 <= 10 $1.60 0 4 $20.00 $4.00 6 2 $20.00 2 1 3 12 <= 12 $1.80 6 2 $20.80 $4.50 6 2 $21.00 $2.00 6 2 $22.00 $5.00 6 2 $22.00 Level 6 2 Profit $22.00 $2.20 6 2 $23.20 $5.50 6 2 $23.00 $2.40 6 2 $24.40 $6.00 0 4 $24.00 $2.60 10 0 $26.00 $6.50 0 4 $26.00 b Unit profit $1.00 $5.00 Solution changes $2.80 10 0 $28.00 $7.00 0 4 $28.00 $3.00 10 0 $30.00 $7.50 0 4 $30.00 esource Usage per Un Resource A1 A2 Used Available e 1 1 2 8 <= 10 2 1 3 12 <= 12 Level 0 4 Profit $20.00 Unit profit $3.00 $5.00 Solution changes esource Usage per Un Resource A1 A2 Used Available 1 1 2 10 <= 10 2 1 3 10 <= 12 Level 10 0 Profit $30.00 c Unit profit $2.00 $2.50 Solution changes esource Usage per Un Resource A1 A2 Used Available 1 1 2 10 <= 10 2 1 3 10 <= 12 Level 10 0 Profit $20.00 f See next tab Unit profit $2.00 $7.50 Solution changes g (6,2) $2.50 $3.00 $3.50 $4.00 $4.50 $5.00 $5.50 $6.00 $6.50 $7.00 $7.50 esource Usage per Un $1.00 (6,2) (0,4) (0,4) (0,4) (0,4) (0,4) (0,4) (0,4) (0,4) (0,4) (0,4) Resource A1 A2 Used Available $1.20 (6,2) (6,2) (6,2) (0,4) (0,4) (0,4) (0,4) (0,4) (0,4) (0,4) (0,4) 1 1 2 8 <= 10 $1.40 (10,0) (6,2) (6,2) (6,2) (0,4) (0,4) (0,4) (0,4) (0,4) (0,4) (0,4) 2 1 3 12 <= 12 $1.60 (10,0) (10,0) (6,2) (6,2) (6,2) (0,4) (0,4) (0,4) (0,4) (0,4) (0,4) $1.80 (10,0) (10,0) (10,0) (6,2) (6,2) (6,2) (0,4) (0,4) (0,4) (0,4) (0,4) Level 0 4 Profit $30.00 $2.00 (10,0) (10,0) (10,0) (6,2) (6,2) (6,2) (6,2) (0,4) (0,4) (0,4) (0,4) $2.20 (10,0) (10,0) (10,0) (10,0) (6,2) (6,2) (6,2) (6,2) (6,2) (0,4) (0,4) h See next tab $2.40 (10,0) (10,0) (10,0) (10,0) (10,0) (6,2) (6,2) (6,2) (6,2) (6,2) (0,4) $2.60 (10,0) (10,0) (10,0) (10,0) (10,0) (10,0) (6,2) (6,2) (6,2) (6,2) (6,2) P 1 P 2 P 1 P 2 P 2 P 1
Background image of page 3

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

View Full Document Right Arrow Icon
$2.80 (10,0) (10,0) (10,0) (10,0) (10,0) (10,0) (10,0) (6,2) (6,2) (6,2) (6,2) $3.00 (10,0) (10,0) (10,0) (10,0) (10,0) (10,0) (10,0) (6,2) (6,2) (6,2) (6,2) 0.00 $2.50 $3.00 $3.50 $4.00 $4.50 $5.00 $5.50 $6.00 $6.50 $7.00 $7.50 $1.00 11.00 12.00 14.00 16.00 18.00 20.00 22.00 24.00 26.00 28.00 30.00 $1.20 12.20 13.20 14.20 16.00 18.00 20.00 22.00 24.00 26.00 28.00 30.00 $1.40 14.00 14.40 15.40 16.40 18.00 20.00 22.00 24.00 26.00 28.00 30.00 $1.60 16.00 16.00 16.60 17.60 18.60 20.00 22.00 24.00 26.00 28.00 30.00 $1.80 18.00 18.00 18.00 18.80 19.80 20.80 22.00 24.00 26.00 28.00 30.00 $2.00 20.00 20.00 20.00 20.00 21.00 22.00 23.00 24.00 26.00 28.00 30.00 $2.20 22.00 22.00 22.00 22.00 22.20 23.20 24.20 25.20 26.20 28.00 30.00 $2.40 24.00 24.00 24.00 24.00 24.00 24.40 25.40 26.40 27.40 28.40 30.00 $2.60 26.00 26.00 26.00 26.00 26.00 26.00 26.60 27.60 28.60 29.60 30.60 $2.80 28.00 28.00 28.00 28.00 28.00 28.00 28.00 28.80 29.80 30.80 31.80 $3.00 30.00 30.00 30.00 30.00 30.00 30.00 30.00 30.00 31.00 32.00 33.00 P 2 P 1
Background image of page 4
Microsoft Excel 12.0 Sensitivity Report Worksheet: [Some solutions for A05.xlsx]5.2 Report Created: 2/6/2009 7:21:24 PM Objective Cell (Max) Cell Name Final Value Profit Profit Available 22 Decision Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $D$10 Level A1 6 0 2 0.5 0.33 $E$10 Level A2 2 0 5 1 1 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $F$7 Used 10 1 10 2 2 $F$8 Used 12 1 12 3 2 h
Background image of page 5

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

View Full Document Right Arrow Icon
Background image of page 6
Allowable Range Low High $1.67 $2.50 $4.00 $6.00 b $1 & $3 are both outside the limits in J12:K12 c $2.50 & $7.50 are both outside the limits in J13:K13 d J12:K13 are consistent with Solver Table results e
Background image of page 7

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

View Full Document Right Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}