{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Some solutions for A05

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

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

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

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

View Full Document
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.
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

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

View Full Document
\$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
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

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

View Full Document
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

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}