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

Info iconThis preview shows pages 1–5. 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
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 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 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 4 $20.00 $2.50 10 $20.00 esource Usage per Un $1.20 4 $20.00 $3.00 10 $20.00 Resource A1 A2 Used Available $1.40 4 $20.00 $3.50 10 $20.00 1 1 2 10 <= 10 $1.60 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 4 $24.00 $2.60 10 $26.00 $6.50 4 $26.00 b Unit profit $1.00 $5.00 Solution changes $2.80 10 $28.00 $7.00 4 $28.00 $3.00 10 $30.00 $7.50 4 $30.00 esource Usage per Un Resource A1 A2 Used Available e 1 1 2 8 <= 10 2 1 3 12 <= 12 Level 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 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 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 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 $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$4....
View Full Document

This note was uploaded on 04/21/2009 for the course BUS 338W-1 taught by Professor White during the Winter '09 term at University of Michigan-Dearborn.

Page1 / 26

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

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

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